Get Full Government Meeting Transcripts, Videos, & Alerts Forever!
Get email alerts on the Api Examples topic
No spam. Unsubscribe anytime.
API examples: pulling housing-unit counts and NAICS-based employee totals
Summary
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).
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.
Weister then showed an economic census example: he selected the 2022 econ census discovery entry, added the EMP variable for number of employees and the categorical NAICS variable (NAICS2022) then filtered to NAICS 62 (health care and social assistance). Reading the returned rows, he noted that Adams County, Wisconsin reported 454 employees in NAICS 62 in that dataset. He also showed how adding &descriptive=true and &output_format=csv returns labeled CSV files with GEOID columns suitable for mapping or CSV-based analysis.
Those examples were offered as templates participants can adapt for their own geographies and variables.
