How to Use Census poverty and income collection in opencode
Returns SAIPE poverty and median household income estimates across counties for one year, optionally within a state. Use it to compare economic need across jurisdictions or populate a county map.
Prompts to try with Census poverty and income collection in opencode
Copy an example into opencode, or ask in your own words.
Use Census poverty and income collection to retrieve 2024 Ohio county poverty and median household income estimates, then add a map with confidence intervals to this project.
Use Census poverty and income collection to look this up and give me the result as a table. Save the result in ./assets.
Pull the latest numbers from Census poverty and income collection and tell me what changed since last week.
Check Census poverty and income collection and summarize what you find in three bullet points.
Pull the newest data from Census poverty and income collection and give me the result as a table.
How to set up Census poverty and income collection in opencode
Pick the way that suits you. Each takes about two minutes.
Use Spiral's MCP server
- Add the server
Leave out --global to add Spiral to the current project only. No header and no client ID or secret: opencode registers itself with Spiral.
opencode mcp add spiral --global --url https://api.spiral.ai/mcp
- Sign in
Your browser opens. Sign in to Spiral, pick the organization and click Authorize, then return to the terminal. No API key. Inside opencode, /mcps starts the same sign-in.
opencode mcp auth spiral
- Check it
Spiral shows as connected.
opencode mcp list
Use the Spiral skill
- Send opencode 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 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 Census poverty and income collection
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/saipe_list", "input": { "year": 2010 } }'
Then paste one of the prompts above: opencode finds Census poverty and income collection on Spiral, shows the price and runs it.
Census poverty and income collection providers and prices
Spiral runs Census poverty and income collection through Alexandria. Open a card for today's price, with every fee included.
Settings you can ask for
Ask opencode for any of these in your prompt.
| Setting | Allowed values | Default | Description |
|---|---|---|---|
| Year | 2010 to 2035 | SAIPE estimate year (directory saipe/datasets/<year>/<year>-state-and-county/). Default: the newest year directory. Positions verified against the 2019 and 2024 layout READMEs; lines that do not fit the layout are rejected. | |
| Page size | 1 to 5000 | Records per page; default 500. |
Every API field of US Census Bureau · Saipe list is on its tool page: open its card above.
What can you do with Census poverty and income collection in opencode?
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.
Build a county poverty map
Map poverty rates and median household income across Ohio counties for one estimate year. Resolve the county identifiers, inspect selected counties with their confidence intervals, and check the poverty publication before updating the map.
More on Census poverty and income collection and opencode
Overview
Census poverty and income collection in other agents
Questions about Census poverty and income collection in opencode
Can opencode use Census poverty and income collection?
Yes. Add Spiral to opencode as an MCP server, and opencode can find and run Census poverty and income collection like any built-in tool.
How much does Census poverty and income collection cost in opencode?
$0.00873 per call. You pay from your Spiral balance as you go, with no subscription, and a failed run is not charged. Your opencode plan is separate.
Do I need an Alexandria account to use Census poverty and income collection in opencode?
No. Spiral runs Census poverty and income collection 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 poverty and income collection in opencode?
About two minutes: add the server, then sign in, then check it.
Does opencode wait while Census poverty and income collection runs?
Census poverty and income collection runs in the background. opencode 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.
Start using Census poverty and income collection in opencode
One Spiral account for every tool your agent needs. No subscription; you pay per run.
Paste this into opencode:
set up https://spiral.ai/SKILL.md


