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
2292 views
Replies
1 reply
Subscribers
541 subscribers
Users
0 members are here
Labels
summary files
trend
Summary File
Related Census Bureau Resources
Related Forum Threads
Seek solution to crosswalk table and column IDs of all ACS Summary files
Shi-Jen He
over 9 years ago
Aloha,
We are trying to calculate social indicators from all summary files (i.e., all available 1,3,5-year files from year 2005 to 2013) that we had downloaded from the Census FTP sites. We found that some table/column IDs seem not always refer to the same subject tables/column across years and summary data files. Therefore, when we tried using same formula to do calculation based on certain columns of specific tables across years and different year (i.e. 1,3,5-year) estimates, we might got incorrect results for certain years/estimates. As compiling an accurate and scalable universal list of Table/Columns IDs for all summary files would take a tremendous amount of time, therefore I would like to seek your help and advice before we dive into it. Any existing solutions, tips, advice would be highly appreciated.
Thanks. Shi-Jen
Center on the Family
University of Hawaii at Manoa
Joe Germuska
over 9 years ago
This would be a very valuable resource. I have not come across any wholesale efforts like this, but would be interested to hear of them.
Cancel
Up
0
Down
Reply
Cancel