Get a raw ACS variable
get_acs_variableLook up a single ACS data value for a given ZIP code by variable code or friendly column name. Returns that raw value directly.
Instructions
Raw value of a single ACS variable for a ZIP — an escape hatch.
`zip_code`: a 5-digit US ZIP. `variable`: an ACS variable code (e.g.
`B19013_001E`) or the friendly store-column name (e.g.
`median_household_income`); both match case-insensitively. Returns that one
value for the ZIP. Limited to the variables held in the local store (the
same ones the other tools draw on); an unknown variable errors with the
full list.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| variable | Yes | ||
| zip_code | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | No | Census name for the area | |
| zcta | Yes | 5-digit ZIP Code Tabulation Area | |
| value | No | The variable's value for this ZIP, or null if missing/suppressed (a string only for the 'name' variable) | |
| column | Yes | Friendly store-column name, e.g. 'median_household_income' | |
| vintage | Yes | ACS 5-year data vintage (end year) | |
| variable | Yes | ACS variable code, e.g. 'B19013_001E' |