7,612
edits
Changes
Jump to navigation
Jump to search
American Community Survey (ACS) Data (view source)
Revision as of 21:16, 11 February 2021
, 21:16, 11 February 2021→Working with the API
The API returns improper JSON. Essentially, it just encodes a flat data structure into JSON syntax one line at a time, and completely ignores the structure of the data (and so much of the point of encoding it in JSON!). However, the first (zeroth) column is the requested geography name, so multiple pulls can be joined using that. And the first (zeroth) row is a valid set of column headers. Also, the nulls are valid JSON encodings. This, and the strong quoting, makes using a JSON handler likely worthwhile. An alternative is to strip the JSON tags and treat the data as a badly encoded CSV, which it is.
To request a group ask for '''group(B06009)''' where you would normally request a field like '''B06011_001E'''. Programmers It looks like programmers can rely on groups and fields being identifiable from the "_" and the string length (\W\d{5}\w{0,1}_\d{3}\w{1}).
=Old Approach using AFF=
