Acc Climbing Related Claims Lodged Between 1 January 2018 And 31 December 2022: Climbing × Related × Claims × Lodged × Between × 1 × January × 2018 × And × 31 × December × 2022

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

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

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

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

pip install vswarehouse

from vswarehouse import Client

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

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

df = client.get("acc_climbing_related_claims_lodged_between_1_january_2018_and_31_december_2022")
df.to_csv("acc_climbing_related_claims_lodged_between_1_january_2018_and_31_december_2022.csv", index=False)

CREATE DATABASE vs_warehouse
  FROM SHARE MRWTYQY-WZ79363.vs_warehouse_share;

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

SELECT *
FROM vs_warehouse.STATS_NZ.ACC_CLIMBING_RELATED_CLAIMS_LODGED_BETWEEN_1_JANUARY_2018_AND_31_DECEMBER_2022
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/vswarehouse-r")

library(vswarehouse)
vs_key("your_key_here")
df <- vs_get("acc_climbing_related_claims_lodged_between_1_january_2018_and_31_december_2022")
head(df)

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

df <- vs_get("acc_climbing_related_claims_lodged_between_1_january_2018_and_31_december_2022")
write.csv(df, "acc_climbing_related_claims_lodged_between_1_january_2018_and_31_december_2022.csv", row.names = FALSE)

let
    apiKey  = "your_key_here",
    url     = "https://api.eolas.fyi/v1/series/acc_climbing_related_claims_lodged_between_1_january_2018_and_31_december_2022/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/series/acc_climbing_related_claims_lodged_between_1_january_2018_and_31_december_2022/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

let
    apiKey  = "your_key_here",
    url     = "https://api.eolas.fyi/v1/series/acc_climbing_related_claims_lodged_between_1_january_2018_and_31_december_2022/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/series/acc_climbing_related_claims_lodged_between_1_january_2018_and_31_december_2022/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/series/acc_climbing_related_claims_lodged_between_1_january_2018_and_31_december_2022/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/series/acc_climbing_related_claims_lodged_between_1_january_2018_and_31_december_2022/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);
}