ACS5 Geographical Mobility in the Past Year by Poverty Status in the Past 12 Months for Current Residence in Puerto Rico

US Census ACS 5-Year Geographical Mobility in the Past Year by Poverty Status in the Past 12 Months for Current Residence in Puerto Rico. Tidy long-format table: one row per geography, year, and variable. 24 estimate variables per geo/year. Partitioned by geography level. 2009–2024.

economics country/usa economics/country/usa/acs5-b07012pr census acs acs5 tidy b-tables usa annual economy

Catalog

Browse and search all available datasets.

Catalog — browse all datasets
GET /api/catalog — catalog in JSON
GET /api/catalog?q=… — search the catalog

Dataset API

Endpoints for this dataset — schema, filter values, preview, and querying.

GET /api/datasets/acs5-b07012pr — schema, filters, and pricing
GET /api/datasets/acs5-b07012pr/sample — free sample (100 rows)
GET /api/datasets/acs5-b07012pr/members/{col} — valid values for a filterable column
GET /api/datasets/acs5-b07012pr/query — query with filters (API key required)

Purchase

Add balance or buy access to start querying.

POST /api/checkout/x402 — agents: add balance via x402 (USDC)
Sign in at /account — humans: add balance via Stripe (card, Apple Pay, bank transfer)
POST /api/ap2/intent → /api/ap2/purchase — agents: AP2 mandate-based payment

Source

Name: US Census Bureau — American Community Survey
URL: https://www.census.gov/programs-surveys/acs
License: Public Domain

Size and Format

Rows: 19,080
Columns: 14
Size (bytes): 10,882
Formats: parquet, csv

Pricing

Per query (USD): 0.0100 USD
Max rows per query: 1000
Free: No
Free sample: Yes

Temporal Coverage

end: 2024
start: 2009
frequency: annual

Geographic Coverage

level: multi
coding: GEOID
region: United States (national_state, county)

Query Filters

Columns you can use as query params in GET /api/datasets/acs5-b07012pr/query.

geo_id Members (JSON)
geo_level Members (JSON)
state_fips Members (JSON)
year Members (JSON)
variable Members (JSON)
node_type Members (JSON)
dim_1 Members (JSON)
dim_2 Members (JSON)

Schema (Columns)

Column	Type	Description	Filterable
`geo_id`	string	Standard Census GEOID (FIPS code)	Yes
`geo_name`	string	Human-readable geography name (e.g. "Georgia", "Fannin County, GA")	No
`geo_level`	string	Geography type: "national" \| "state" \| "county"	Yes
`state_fips`	string	2-digit state FIPS code; null for national and zcta rows	Yes
`year`	integer	ACS 5-Year survey ending year	Yes
`survey`	string	ACS product: "acs5"	No
`variable`	string	Census variable code (e.g. "B01001_005E")	Yes
`concept`	string	Table concept — same for all rows in this dataset	No
`label`	string	Human-readable label (e.g. "Male: 5 to 9 years")	No
`node_type`	string	"total" \| "subtotal" \| "leaf" — position in label hierarchy	Yes
`dim_1`	string	Depth 1 label value. (e.g. '100 to 149 percent of the poverty level', 'At or above 150 percent of the poverty level', 'Below 100 percent of the poverty level', 'Moved from different municipio')	Yes
`dim_2`	string	Depth 2 label value. (e.g. '100 to 149 percent of the poverty level', 'At or above 150 percent of the poverty level', 'Below 100 percent of the poverty level')	Yes
`value`	float	Estimate value (null if suppressed)	No
`moe`	float	Margin of error (null if suppressed)	No

← Back to catalog