Datapoint level/hierarchy in raw data downloads

Chris Engle over 9 years ago

Hi - Does anyone know if the Census has documentation that explains the hierarchy of data for ACS tables? I'm working with raw data and it doesn't include the indentions that the Census uses. I only see that the TableShells Excel file (attached) shows the hierarchy as formatted indentions.

I'm trying to create a system that will allow me to calculate a 3rd-level datapoint as a % of a 2nd-level datapoint. For example (chosen randomly), calculating the % of children under 6 living with 2 parents that are foreign-born for this table (screenshot attached).

Does this exist?

Thanks for any advice you have.

Parents

Glenn Rice over 9 years ago

Chris, we do pretty much the same thing as your solution. It's ridiculous that we have to count characters to determine indent levels -- how hard would it be for the Bureau to add a column with an indent level value?
Cancel
Up 0 Down

Reply

Cancel

Reply

Glenn Rice over 9 years ago

Chris, we do pretty much the same thing as your solution. It's ridiculous that we have to count characters to determine indent levels -- how hard would it be for the Bureau to add a column with an indent level value?
Cancel
Up 0 Down

Reply

Cancel

Children

No Data