census/acs5 endpoint - Githubissues

codefordenver / shift-api

1 stars 0 forks source link

census/acs5 endpoint #32

Closed eemshi closed 5 years ago

eemshi commented 5 years ago

api.shiftresearchlab.org/census/acs5/

path params:

geounit (ex. tract, county)
subject (ex. b01001)
year (ex. 2016) the above 3 parameters are from database table names.
- geoid10 (ex. geoid10 = '08001')
- other fields (ex. b01001_001e, b01001_002e, etc.) the above 2 parameters are from columns inside the table

sample GET:

api.shiftresearchlab.org/census/acs5/{subject}/{geounit}/{year}?geoid10='08001'&fields=b01001_001e,b01001_002e

ShiftRL commented 5 years ago

Hi team, I dump in 2017 tables into the acs5 schema

geounit (ex. tract, county)
subject (ex. b01001)
year (ex. 2016) the above 3 parameters are from database table names.
- geoid10 (ex. geoid10 = '08001')
- other fields (ex. b01001_001e, b01001_002e, etc.) the above 2 parameters are from columns inside the table

ShiftRL commented 5 years ago

desirable return: [ { "geoid10": "08023", "b01001_001e": 3628 }, { "geoid10": "08001", "b01001_001e": 487850 }, { "geoid10": "08021", "b01001_001e": 8147 } ]