The 2025 ACS Data Users Conference will be held on May 29, 2025 (virtual day) and June 3, 2025 (in-person in DC)
American Community Survey Data Users Group
Search for topics, people, or keywords
Sign Up
Log in
Site
Search for topics, people, or keywords
User
Home
Discussion Forum
ACS Resources
Webinars
Conferences
Steering Committee
More
Cancel
Home
Discussion Forum
ACS Resources
Webinars
Conferences
About
More
Cancel
Details
Views
6785 views
Replies
6 replies
Subscribers
542 subscribers
Users
0 members are here
Labels
Summary File
Related Census Bureau Resources
Related Forum Threads
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
JamiRae
over 9 years ago
I got a version of the table shells from the census website that has the indent info on the first tab (sheet1). is that what you're looking for?
[Updated on 8/30/2015 7:11 PM]
Cancel
Up
0
Down
Reply
Cancel
Reply
JamiRae
over 9 years ago
I got a version of the table shells from the census website that has the indent info on the first tab (sheet1). is that what you're looking for?
[Updated on 8/30/2015 7:11 PM]
Cancel
Up
0
Down
Reply
Cancel
Children
No Data