ACS 2014 Table Metadata File

Jeffrey Naas over 8 years ago

Attached is a metadata file for both the 2014 1-year and 5-year I created from the ACS 1- year Seq_Table_Number_Lookup Excel file and from Glenn Rice’s modified 5-year shell file. I added fields for record (person/housing) and topic to allow for better sorting. If you would like to add more or different topics, just modify the lookup table on the Subjects tab and use a vlookup formula to update the field(s) on the meta table.

[Updated on 12/4/2015 11:58 AM]

Patty Becker over 8 years ago

Thank you for this, Jeff.

Can someone please tell me why the individual ancestry tables, B04001 to B04003, are not present in the 5 year data? I can see not providing these at the BG level (!), but we should be able to see them at, say, county level. Most annoying.
Cancel
Up 0 Down

Reply

Cancel
Girma Syoume over 8 years ago

Thanks Jeff!
Cancel
Up 0 Down

Reply

Cancel
Gretchen Gooding over 8 years ago

www.census.gov/.../1-year.html

Deleted/Removed Tables

Ancestry Detailed Tables B04001, B04002, and B04003 and Collapsed Tables C04001, C04002, and C04003 have been deleted. Detailed Tables B04004, B04005, B04006, C04004, C04005, and C04006 are available alternatives.
Cancel
Up 0 Down

Reply

Cancel
Patty Becker over 8 years ago

But why? 04004, 5 and 6 are not substitutes, because they provide tabulations for individual ancestries. They're pretty much useless. I would like to know the justification for the deletion.
Cancel
Up 0 Down

Reply

Cancel