How to Use Data.gov.au table records in dots
Returns rows from a resource stored in Data.gov.au's DataStore. Use it to retrieve the relevant part of a table for analysis without downloading the entire source file.
Prompts to try with Data.gov.au table records in dots
Copy an example into dots, or ask in your own words.
Every month, use Data.gov.au table records on a previously selected Australian regional population DataStore resource to retrieve Melbourne rows and report differences from the previous extract.
Every Monday at 9am: use Data.gov.au table records to look this up and give me the result as a table.
Pull the latest numbers from Data.gov.au table records and tell me what changed since last week.
Check Data.gov.au table records and summarize what you find in three bullet points.
Pull the newest data from Data.gov.au table records and give me the result as a table.
How to set up Data.gov.au table records in dots
Pick the way that suits you. Each takes about two minutes.
Use the Spiral skill
- Send dots this message
Your agent reads Spiral's skill and sets itself up.
set up https://spiral.ai/SKILL.md
- Sign in or paste a key
Approve Spiral in the browser, or give the agent a key from the console.
Use Spiral's MCP server
- Create an API key
In the console, open API keys and create a key for your dot. Copy it.
- Send your dot this message
Your dot reads Spiral's skill and asks for your API key.
set up https://spiral.ai/SKILL.md
- Give your dot the key
When your dot asks for the key, add it where your dot keeps secrets, never in the chat itself.
Use the Spiral CLI
- Install and sign in
Installs the Spiral CLI, signs you in and adds its skill to your coding agents.
npx -y spiral-cli@latest init
Call the Spiral API
- Create an API key
In the console, under API keys.
- Run Data.gov.au table records
One request; the result comes back by polling or a webhook.
curl https://api.spiral.ai/v1/runs \ -H "Authorization: Bearer $SPIRAL_API_KEY" \ -H "Content-Type: application/json" \ -H "Idempotency-Key: $(uuidgen)" \ -d '{ "provider": "alexandria", "model": "data-gov-au/open-data/query_datastore", "input": { "resource_id": "<resource_id>" } }'
Then paste one of the prompts above: dots finds Data.gov.au table records on Spiral, shows the price and runs it.
Data.gov.au table records providers and prices
Spiral runs Data.gov.au table records through Alexandria. Open a card for today's price, with every fee included.
Settings you can ask for
Ask dots for any of these in your prompt.
| Setting | Allowed values | Default | Description |
|---|---|---|---|
| Limit | 1 to 1000 | 100 | Rows per page. |
| Distinct | on or off | distinct |
Every API field of data.gov.au open data catalogue · Query datastore is on its tool page: open its card above.
What can you do with Data.gov.au table records in dots?
Maintain a weekly digest of changes to Australian government data sources used in your research. A scheduled agent can compare publisher, dataset, resource, and available table results with earlier snapshots to identify changes worth reviewing.
Build a regional evidence pack
Identify relevant government publishers, find datasets about Melbourne, inspect their resources, and extract available DataStore rows for a regional comparison. Keep each result tied to its source dataset.
Prepare council asset data for a map
Find a council's catalog entry and published asset datasets, inspect the resources, and retrieve relevant rows where DataStore access is available. Use the resulting locations to prepare a map of public infrastructure.
Compare published reporting years
Identify the publishing agency and locate a dataset with resources for multiple years. Inspect each resource and extract comparable DataStore rows where available before calculating changes.
Audit an agency's published data
Resolve the agency's catalog name, inventory its datasets and resources, and sample accessible DataStore tables. Produce a report showing which sources support row analysis and which require separate file retrieval.
Diagnose a missing data extract
Inspect a dataset and its selected resource to establish where the data lives. If the resource is stored in DataStore, query its rows; otherwise identify the linked file that needs separate retrieval.
More on Data.gov.au table records and dots
Overview
Data.gov.au table records in other agents
Questions about Data.gov.au table records in dots
Can dots use Data.gov.au table records?
Yes. Add Spiral to dots as an MCP server, and dots can find and run Data.gov.au table records like any built-in tool.
How much does Data.gov.au table records cost in dots?
$0.00873 per call. You pay from your Spiral balance as you go, with no subscription, and a failed run is not charged. Your dots plan is separate.
Do I need an Alexandria account to use Data.gov.au table records in dots?
You need no Alexandria account. dots uses one Spiral API key for every tool, and Spiral runs Data.gov.au table records on its own Alexandria account.
How long does it take to set up Data.gov.au table records in dots?
About two minutes: create an API key, then send your dot this message, then give your dot the key.
Does dots wait while Data.gov.au table records runs?
Data.gov.au table records runs in the background. dots starts the run, checks on it and gives you the json when it's ready.
Does Data.gov.au cover only federal government data?
It includes data published by Australian federal, state, and local government agencies. A search can therefore surface national statistics alongside council datasets.
How fresh and accurate is the data?
Data.gov.au explicitly does not guarantee dataset quality or timeliness. Its catalog should not be treated as a promise that every published dataset reflects current conditions.
Does a dataset search return the underlying table rows?
Search results represent datasets. Row access requires a resource loaded into DataStore; a resource can instead point to a file hosted elsewhere.
How much historical data can I retrieve?
Historical coverage depends on the resources supplied for the dataset. CKAN supports separate resources for different years, so inspect those resources before planning a year-to-year comparison.
What attribution does Data.gov.au request?
Its requested attribution includes the publishing organization, jurisdiction, dataset title, date sourced, and dataset URL. Preserve those details when preparing a report or derived dataset.
Start using Data.gov.au table records in dots
One Spiral account for every tool your agent needs. No subscription; you pay per run.
Paste this into dots:
set up https://spiral.ai/SKILL.md


