socrata / opendatanetwork.com

The Open Data Network
https://www.opendatanetwork.com/
Other
19 stars 12 forks source link

bring in more demographics data #226

Open zang0 opened 8 years ago

zang0 commented 8 years ago

don't want only population data in the new 2 tier categories

aaasen commented 8 years ago

Sent the ACS data to @chrismetcalf to upload.

zang0 commented 8 years ago

out of time on this one.

zang0 commented 8 years ago

@aaasen Can you put the ACS data in this ticket? @dkuttner has expressed an interest in helping out. @dkuttner The 1 pager doc that should help you get started is here: https://docs.google.com/document/d/1WUv2fIyj3G-7L5aCPrCTzsPXBJ44_7z6pvj9ALlQWGc - feel free to ask any questions here or via other channels of lane or malinda.

high level is basic demographic info like: ethnic/gender/age distributions by geo region. final result should appear as additional options alongside Population here: http://www.opendatanetwork.com/region/1600000US5363000/Seattle_WA/population/population/2013?

aaasen commented 8 years ago

Here is the formatted 2014 ACS: https://drive.google.com/open?id=0B9pR2kVj0HXMV2FpWTgzUUtQbEk Scripts to generate the data here: https://github.com/socrata/acs

The dataset just needs to be uploaded to odn.data.socrata.com and then we can integrate it into the ODN. A lot of that will be finding the variables that we want to display. There is a Datalens showing all of them here: https://odn.data.socrata.com/view/qbrn-axz9

aliciatb commented 7 years ago

Population by age-sex-race dataset: https://odn.data.socrata.com/d/ushg-rxhy/data. Still need to add data for zipcode geographies and then calculate percent change for all count values.