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

Codex · Public Records

How to Use Census statistical data in Codex

Returns statistical values from a Census dataset for selected areas and years. Use it for ACS demographic, housing, or economic measures when you need the observations behind a community comparison.

Prompts to try with Census statistical data in Codex

Copy an example into Codex, or ask in your own words.

Use Census statistical data to retrieve 2024 ACS five-year total population estimates and margins of error for every county in Texas, then add a comparison table to this project.

Census statistical dataCodex
Try asking
  • Use Census statistical data to look this up and give me the result as a table. Save the result in ./assets.

  • Pull the latest numbers from Census statistical data and tell me what changed since last week.

  • Check Census statistical data and summarize what you find in three bullet points.

  • Pull the newest data from Census statistical data and give me the result as a table.

How to set up Census statistical data in Codex

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

Use Spiral's MCP server

  1. Add the hosted server
    codex mcp add spiral --url https://api.spiral.ai/mcp
  2. Sign in

    Codex opens the browser: sign in to Spiral and click Authorize. No API key. codex mcp list then shows Spiral.

    codex mcp login spiral

Use the Spiral skill

  1. Send Codex 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 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 Census statistical data

    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": "census-gov/census/data",
        "input": {
          "dataset": "acs/acs5",
          "vintage": 2000,
          "geography": {},
          "variables": [
            "<variables>"
          ]
        }
      }'

Then paste one of the prompts above: Codex finds Census statistical data on Spiral, shows the price and runs it.

Census statistical data providers and prices

Spiral runs Census statistical data through Alexandria. Open a card for today's price, with every fee included.

AlexandriaPublic Records
US Census Bureau · Data
census-gov/census/data

Settings you can ask for

Ask Codex for any of these in your prompt.

SettingAllowed valuesDefaultDescription
Datasetacs/acs5, acs/acs1, acs/acs5/subject, acs/acs1/subject, acs/acs5/profile, acs/acs1/profile, acs/acs5/cprofile, acs/acs1/cprofile and 5 more

dataset

Vintage2000 to 2035

vintage

Page size1 to 5000500

page_size

Every API field of US Census Bureau · Data is on its tool page: open its card above.

What can you do with Census statistical data in Codex?

Build a county comparison view with Census population, income, poverty, and ACS statistics. Use geographic identifiers, variable definitions, and publication metadata to keep the project's measures tied to the correct areas and periods.

Maintain a county community report

Build a report for Travis County, Texas, with ACS characteristics, population history, and poverty estimates. Find the datasets and variable definitions, resolve county identifiers, check publication status, compare statewide collections, and retrieve the county details for the narrative.

Prepare a grant needs assessment

Document population change, poverty, income, and housing conditions for a proposed county service area. Use statewide collections as benchmarks, local records as evidence, dataset and variable documentation to define measures, and publication checks to keep the assessment current.

Compare counties for business expansion

Compare North Carolina counties using population trends, household income, poverty, and ACS housing characteristics. Identify the appropriate datasets, measures, and county codes; check publication changes; rank the county collections; then examine shortlisted counties in detail.

Plan regional library outreach

Compare Montana counties for outreach planning using population change, poverty, and ACS characteristics. Resolve service-area counties, find and define the measures, check publication status, compare the statewide collections, and add local population and income detail to each county brief.

Compare neighborhood characteristics

Compare ACS five-year housing measures across census tracts in Wake County, North Carolina. Find the dataset, inspect variable definitions, resolve the geographic hierarchy, and retrieve estimates with their margins of error.

Questions about Census statistical data in Codex

Can Codex use Census statistical data?

Yes. Add Spiral to Codex as an MCP server, and Codex can find and run Census statistical data like any built-in tool.

How much does Census statistical data cost in Codex?

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

Do I need an Alexandria account to use Census statistical data in Codex?

No. Spiral runs Census statistical data on its own Alexandria account. You sign in to Spiral once and never paste a key.

How long does it take to set up Census statistical data in Codex?

About two minutes: add the hosted server, then sign in.

Does Codex wait while Census statistical data runs?

Census statistical data runs in the background. Codex starts the run, checks on it and gives you the json when it's ready.

How small an area can Census statistics describe?

Coverage depends on the program and table. ACS five-year Detailed Tables reach block groups, while Subject Tables and Data Profiles reach census tracts; the SAIPE state and county files describe those larger jurisdictions.

How current are Census estimates?

Population estimates and SAIPE estimates are produced annually. An ACS five-year estimate combines 60 months of collected data, so its ending year does not make it a snapshot of that year alone.

Why can an older population estimate change?

Each new population estimates vintage revises the series back to the most recent census. The newest vintage supersedes previously published estimates for those dates, so a growth calculation should use one vintage throughout.

Are poverty estimates exact counts?

SAIPE uses statistical models to estimate income and poverty. Each state and county estimate is published with a 90% confidence interval, which matters when comparing counties with similar results.

Why might an ACS one-year table omit a small community?

Standard ACS one-year estimates cover areas with at least 65,000 residents. ACS five-year estimates cover all areas and are the appropriate product to investigate for smaller communities.

Get started

Start using Census statistical data in Codex

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

Paste this into Codex:

Set up Codex

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