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

n8n · Public Records

How to Use Census population publication status in n8n

Returns the available population estimates vintage and source file metadata. Use it before refreshing a population report to check whether the publication has changed.

Prompts to try with Census population publication status in n8n

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

Each month, use Census population publication status to check the population estimates publication, including Texas source files, and report any change since the previous check.

Census population publication statusn8n
Try asking
  • Every Monday at 9am: use Census population publication status to look this up and give me the result as a table.

  • Pull the latest numbers from Census population publication status and tell me what changed since last week.

  • Check Census population publication status and summarize what you find in three bullet points.

  • Pull the newest data from Census population publication status and give me the result as a table.

How to set up Census population publication status in n8n

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

Use the Spiral skill

  1. Send n8n 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 a key

    Create a key under API keys in the console.

  2. Add an MCP Client node

    In a workflow, add an MCP Client node (or, under an AI Agent node, an MCP Client Tool) and set:

    https://api.spiral.ai/mcp
  3. Pick a tool

    The node lists Spiral's tools. In an MCP Client node pick one, such as run, and give it its arguments:

    {
      "provider": "fal",
      "model": "fal-ai/flux/schnell",
      "input": { "prompt": "a lighthouse at dawn" },
      "wait": true
    }
  4. Run Census population publication status in a workflow step

    Give the step an instruction like the ones below and run it on your trigger or schedule. Spiral finds Census population publication status, prices it and runs it each time the step fires.

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 population publication status

    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/popest_status",
        "input": {
          "state": "<state>"
        }
      }'

Then paste one of the prompts above: n8n finds Census population publication status on Spiral, shows the price and runs it.

Census population publication status providers and prices

Spiral runs Census population publication status through Alexandria. Open a card for today's price, with every fee included.

AlexandriaPublic Records
US Census Bureau · Popest status
census-gov/census/popest_status

What can you do with Census population publication status in n8n?

Keep a regional Census briefing current by checking publications and refreshing county comparisons when new data appear. Track population vintages and poverty estimate years separately so revisions do not look like newly observed annual changes.

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.

Rank population growth

Rank Texas counties by population change within one vintage, then inspect the annual history of the fastest-growing counties. Resolve county identifiers and check the population publication before refreshing the ranking.

Monitor statistical publications

Check population and poverty publication status on a schedule and flag changes for a regional research team. Keep the population vintage and SAIPE estimate year separate when reporting what needs a refresh.

Questions about Census population publication status in n8n

Can n8n use Census population publication status?

Yes. Add Spiral to n8n as an MCP server, and n8n can find and run Census population publication status like any built-in tool.

How much does Census population publication status cost in n8n?

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

Do I need an Alexandria account to use Census population publication status in n8n?

You need no Alexandria account. n8n uses one Spiral API key for every tool, and Spiral runs Census population publication status on its own Alexandria account.

How long does it take to set up Census population publication status in n8n?

About two minutes: create a key, then add an MCP Client node, then pick a tool.

Does n8n wait while Census population publication status runs?

Census population publication status runs in the background. n8n 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 population publication status in n8n

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

Paste this into n8n:

Set up n8n

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