2010 Decennial Census data download help

[Randy Chugh]

Hello,

Has anyone downloaded the 2010 Census data? Basically looking for income and population at the tract level. The data is extremely difficult to download and assemble. Has anyone had any luck with it? Tips appreciated!

Thanks,
Randy

[George Ford]

Yes, it is a mess.

I don't think the 2010 census did not collect detailed income data. You'll need to use ACS.

You can manually do it here: https://www.nhgis.org/

Or

import delimited "https://api.census.gov/data/2010/acs/acs5/spt?get=group(B01003)&POPGROUP=001&ucgid=pseudo(01 00000US$1400000)", clear
g tractfips = substr(geo_id,10,.)
replace b01003_001e = ustrregexra(b01003_001e, `"[\[\]"]"', "") //no idea why it imports like this. sometimes geo_id does the same.
keep b01003_001e geo_id name tractfips
ren b01003_001e pop2010
destring pop2010, force replace
save pop, replace

** median income B19013
import delimited "https://api.census.gov/data/2010/acs/acs5/spt?get=group(B19013)&POPGROUP=001&ucgid=pseudo(01 00000US$1400000)", clear
g tractfips = substr(geo_id,10,.)
replace b19013_001e = ustrregexra(b19013_001e, `"[\[\]"]"', "")
keep b19013_001e geo_id name tractfips
ren b19013_001e medinc2010
destring medinc2010, force replace
save medinc, replace

joinby geo_id using pop