API examples: pulling housing-unit counts and NAICS-based employee totals

Jul 29, 2026

Presenters demonstrated constructing API queries that return housing-unit counts and tenure (H001001, H004* variables) and a 2022 Economic Census example returning NAICS 62 employee counts (Adams County, WI = 454 employees).

The full story

Tyson Weister demonstrated how to add multiple variables to an API query and how to format outputs for analysis. In the decennial example he added variable codes from SF1 (H001001 for total housing units and H004002/H004003/H004004 for tenure rows) and showed how adding geo_id returns a fully qualified GEOID for mapping. "You can just repeat this process for up to 50 variables in a column," he said while assembling the URL and running the query.

Free newsletter

Sign up to keep reading.

Your free newsletter brings you what your city council, county, and school board discussed and decided.

or
Already have an account? Sign in