Details
  • Views 6447 views
  • Replies 6 replies
  • Subscribers 543 subscribers
  • Users 0 members are here
Labels
Related Census Bureau Resources
Related Forum Threads

Datapoint level/hierarchy in raw data downloads

Chris Engle
over 8 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
  • over 8 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?
Reply
  • over 8 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?
Children
No Data
For more information about the American Community Survey Census Bureau Website