data | list | — | Rows, as records, from Rust instead of src. |
src | text | — | Where the data comes from: a CSV, TSV, JSON, NDJSON or GeoJSON file, a REST or GraphQL URL, or an official statistics API (SDMX and JSON-stat need stats). |
view | text | — | The name of a DataView above, to use its data instead. |
format | text | — | csv, json, ndjson or sdmx, if it can't be told from the file or response. |
path | text | — | Where the rows are in a JSON response (data.items, results[*].stats). Found automatically when there's only one list. |
query | text | — | A GraphQL query ({ … }); makes src a GraphQL endpoint. For the URL's query string, use params. |
variables | record | — | GraphQL variables. |
method | text | GET | The HTTP method. |
body | text | — | The request body. |
params | record | — | Added to the URL's query string: { startPeriod: "2024-01" }. |
load | text | — | build (into the page), browser, or both. Site files default to build; anything else to both. |
refresh | number | — | Load again every this many seconds, resting while the page is out of sight. |
live | text | — | Where updates arrive: wss://… is a WebSocket, anything else server-sent events. Can replace src: the data then starts with the first message. Needs live. |
subscription | text | — | A GraphQL subscription, over a WebSocket to live or to src. Needs live. |
live_path | text | — | Where the rows are in a live message. |
event | text | message | The type of server-sent event to listen for. |
update | text | append | What a live message does: append, upsert (the default given key) or replace. |
key | text | — | The column identifying a row, for upsert. |
keep | number | — | The most recent rows to hold on to. |
where | text | — | Keep matching rows: TSEST=Original, REGION=Australia, or a record. |
sort | text | — | A column to sort by; -column for descending. |
limit | number | — | The most rows to keep. |
group_by | text | — | Combine rows with the same value in this column. |
aggregate | text | sum | With group_by: sum, mean, count, min or max. Cells with no value are left out, and a note says so. |
missing | text | — | More markers for "no value", comma-separated, beyond the standard np, .., n.a. and so on. |
paginate | boolean | false | Follow an API's pages to the end. Needs stats. |
preset | text | — | An export's layout: qualtrics, surveymonkey or tablebuilder. Needs stats. |
skip | text | — | Rows to drop from the top, or auto to find the table. Needs stats. |
header_rows | number | 1 | How many rows the header takes. Needs stats. |
footer | number | — | Rows to drop from the end. Needs stats. |
sheet | text | — | Which sheet of an Excel workbook. Needs excel. |
melt | text | — | Columns to turn into variable and value rows, or true for every number column. Needs stats. |
labels | text | — | A codebook of code and label, with column if codes differ by column. Needs stats. |