Greetings,
I am compiling an SDOH profile of persons age 55+ at the census tract level (plus the full City and state to compare) . I have most of what I need but am looking for an efficient way to download race for this population without having to download multiple race by age files (i.e. White by Age and so on) . Is this possible? I don't see where I can download this easily. I haven't used ACS directly in a while as my company used vendor software.
Any assistance, tips or hacks would be most appreciated!
I think OP was referring to census tracts, not the postal abbreviation for Connecticut.
Via IPUMS NHGIS, you can select all of the Age x Race tables to download in a single file for each geographic level (one file for tracts, one for counties, etc.)NHGIS is free to use with attribution.
Good idea but I don't see anything there by race and age for tracts (beyond the under 18/18 and over age groups from PL94 release) newer than 2010. I believe that's because normally the 2020 numbers would get more detailed versions in SF1 and SF2 files and that hasn't happened yet -- there's a new name for them and they're coming out soon, late May for the first one, details here www.census.gov/.../about-2020-data-products.html
NHGIS includes all ACS detailed tables going back to the 2009 5-year data, so that includes Sex by Age by Race tables for tracts for every ACS 5-year period. Any combo of data filters involving tracts, a 5-year period, or sex/age/race topics should bring those up in the "Select Data" table.
You're right I think there's something wrong with the boolean "or" in their interface -- I took out "or 2010" and I could see this set for 2017-21 , so you could assemble what you need from this with other race/ethnicity files you need --