2018 Census — Individual by SA1 (Part 2)

Excel 365 or 2016+: Data → Get Data → From Other Sources → Blank Query → Advanced Editor

let
    apiKey  = "your_key_here",
    url     = "https://api.eolas.fyi/v1/datasets/census_2018_individual_sa1_p2/data",
    source  = Json.Document(Web.Contents(url,
                  [Headers = [#"X-API-Key" = apiKey]])),
    toTable = Table.FromList(source, Splitter.SplitByNothing(), {"Record"}),
    cols    = Record.FieldNames(toTable{0}[Record]),
    result  = Table.ExpandRecordColumn(toTable, "Record", cols)
in
    result

curl https://api.eolas.fyi/v1/datasets/census_2018_individual_sa1_p2/data \
  -H "X-API-Key: your_key_here"

curl "https://api.eolas.fyi/v1/datasets/census_2018_individual_sa1_p2/data?start=2020-01-01&end=2024-12-31" \
  -H "X-API-Key: your_key_here"

curl "https://api.eolas.fyi/v1/datasets/census_2018_individual_sa1_p2/data?format=csv" \
  -H "X-API-Key: your_key_here" -o census_2018_individual_sa1_p2.csv

curl https://api.eolas.fyi/v1/datasets/census_2018_individual_sa1_p2/data ^
  -H "X-API-Key: your_key_here"

curl "https://api.eolas.fyi/v1/datasets/census_2018_individual_sa1_p2/data?start=2020-01-01&end=2024-12-31" ^
  -H "X-API-Key: your_key_here"

curl "https://api.eolas.fyi/v1/datasets/census_2018_individual_sa1_p2/data?format=csv" ^
  -H "X-API-Key: your_key_here" -o census_2018_individual_sa1_p2.csv

Invoke-RestMethod `
  -Uri "https://api.eolas.fyi/v1/datasets/census_2018_individual_sa1_p2/data" `
  -Headers @{ "X-API-Key" = "your_key_here" } | ConvertTo-Json

pip install eolas-data

from eolas_data import Client

client = Client("your_key_here")
df = client.get("census_2018_individual_sa1_p2")
print(df.head())

df = client.get("census_2018_individual_sa1_p2", start="2020-01-01", end="2024-12-31")
print(df.head())

client.download("census_2018_individual_sa1_p2", path="census_2018_individual_sa1_p2.csv")

CREATE DATABASE vs_warehouse
  FROM SHARE MRWTYQY-WZ79363.vs_warehouse_share;

SELECT *
FROM vs_warehouse.STATS_NZ.CENSUS_2018_INDIVIDUAL_SA1_P2
ORDER BY date DESC
LIMIT 100;

SELECT *
FROM vs_warehouse.STATS_NZ.CENSUS_2018_INDIVIDUAL_SA1_P2
WHERE date >= '2020-01-01'
  AND date <= '2024-12-31'
ORDER BY date;

-- Run the query above, then use
-- Results → Download as CSV in the Snowflake UI

remotes::install_github("phildonovan/eolas-r")

library(eolas)
eolas_key("your_key_here")
df <- eolas_get("census_2018_individual_sa1_p2")
head(df)

df <- eolas_get("census_2018_individual_sa1_p2", start = "2020-01-01", end = "2024-12-31")
head(df)

eolas_download("census_2018_individual_sa1_p2", path = "census_2018_individual_sa1_p2.csv")

let
    apiKey  = "your_key_here",
    url     = "https://api.eolas.fyi/v1/datasets/census_2018_individual_sa1_p2/data",
    source  = Json.Document(Web.Contents(url,
                  [Headers = [#"X-API-Key" = apiKey]])),
    toTable = Table.FromList(source, Splitter.SplitByNothing(), {"Record"}),
    cols    = Record.FieldNames(toTable{0}[Record]),
    result  = Table.ExpandRecordColumn(toTable, "Record", cols)
in
    result

let
    apiKey  = "your_key_here",
    url     = "https://api.eolas.fyi/v1/datasets/census_2018_individual_sa1_p2/data?start=2020-01-01&end=2024-12-31",
    source  = Json.Document(Web.Contents(url,
                  [Headers = [#"X-API-Key" = apiKey]])),
    toTable = Table.FromList(source, Splitter.SplitByNothing(), {"Record"}),
    cols    = Record.FieldNames(toTable{0}[Record]),
    result  = Table.ExpandRecordColumn(toTable, "Record", cols)
in
    result

function getVSData() {
  const apiKey = "your_key_here";
  const url    = "https://api.eolas.fyi/v1/datasets/census_2018_individual_sa1_p2/data";

  const res  = UrlFetchApp.fetch(url, { headers: { "X-API-Key": apiKey } });
  const data = JSON.parse(res.getContentText());

  const sheet   = SpreadsheetApp.getActiveSheet();
  const headers = Object.keys(data[0]);
  const rows    = data.map(r => headers.map(h => r[h] ?? ""));

  sheet.clearContents();
  sheet.getRange(1, 1, 1, headers.length).setValues([headers]);
  sheet.getRange(2, 1, rows.length, headers.length).setValues(rows);
}

function getVSData() {
  const apiKey = "your_key_here";
  const url    = "https://api.eolas.fyi/v1/datasets/census_2018_individual_sa1_p2/data?start=2020-01-01&end=2024-12-31";

  const res  = UrlFetchApp.fetch(url, { headers: { "X-API-Key": apiKey } });
  const data = JSON.parse(res.getContentText());

  const sheet   = SpreadsheetApp.getActiveSheet();
  const headers = Object.keys(data[0]);
  const rows    = data.map(r => headers.map(h => r[h] ?? ""));

  sheet.clearContents();
  sheet.getRange(1, 1, 1, headers.length).setValues([headers]);
  sheet.getRange(2, 1, rows.length, headers.length).setValues(rows);
}