Spiral gives your agent every tool with one account. Browse the tools →

Instinct · Public Records

How to Use Data.gov.au table records in Instinct

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 Instinct

Copy an example into Instinct, 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.

Data.gov.au table recordsInstinct
Try asking
  • 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 Instinct

Pick the way that suits you. Each takes about two minutes.

Use the Spiral skill

  1. Send Instinct this message

    Your agent reads Spiral's skill and sets itself up.

    set up https://spiral.ai/SKILL.md
  2. 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

  1. Create an API key

    In the console, open API keys and create a key for Instinct. Copy it.

  2. Send Instinct this message

    Instinct reads Spiral's skill and asks for your API key.

    set up https://spiral.ai/SKILL.md
  3. Give Instinct the key

    When Instinct asks for the key, add it where Instinct keeps secrets, never in the chat itself.

Use the Spiral CLI

  1. 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

  1. Create an API key

    In the console, under API keys.

  2. 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: Instinct 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.

AlexandriaPublic Records
data.gov.au open data catalogue · Query datastore
data-gov-au/open-data/query_datastore

Settings you can ask for

Ask Instinct for any of these in your prompt.

SettingAllowed valuesDefaultDescription
Limit1 to 1000100

Rows per page.

Distincton 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 Instinct?

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.

Questions about Data.gov.au table records in Instinct

Can Instinct use Data.gov.au table records?

Yes. Add Spiral to Instinct as an MCP server, and Instinct can find and run Data.gov.au table records like any built-in tool.

How much does Data.gov.au table records cost in Instinct?

$0.00873 per call. You pay from your Spiral balance as you go, with no subscription, and a failed run is not charged. Your Instinct plan is separate.

Do I need an Alexandria account to use Data.gov.au table records in Instinct?

You need no Alexandria account. Instinct 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 Instinct?

About two minutes: create an API key, then send Instinct this message, then give Instinct the key.

Does Instinct wait while Data.gov.au table records runs?

Data.gov.au table records runs in the background. Instinct 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.

Get started

Start using Data.gov.au table records in Instinct

One Spiral account for every tool your agent needs. No subscription; you pay per run.

Paste this into Instinct:

Set up Instinct

set up https://spiral.ai/SKILL.md
Are you an AI agent? See setup options