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
4704 views
Replies
4 replies
Subscribers
540 subscribers
Users
0 members are here
Labels
Summary File
Related Census Bureau Resources
Related Forum Threads
Here's a "fixed" table shells file for this week's release
Glenn Rice
over 8 years ago
I just spent a couple hours manually stripping all tables that are NOT included in the 2014 5-year release, out of the 2014 table shells file. Here it is!
[Updated on 11/30/2015 5:01 PM]
Bernie
over 8 years ago
Hi Glenn, can you explain the problem you're fixing?
Cancel
Up
0
Down
Reply
Cancel
Glenn Rice
over 8 years ago
Up until last year, the Bureau made available a separate table-shells file for each period, i.e. 1-, 3- and 5-year. Now there's a single file for all 3 (now 2) annual ACS releases.
Some of us use the table-shells file to control processing of the raw data. In my case at least, if the table-shells file contains tables/columns that don't exist in the data, there's a problem.
So, this isn't really a "fix", but a reversion to the earlier table shells format in order to match the data.
Cancel
Up
0
Down
Reply
Cancel
Bernie
over 8 years ago
Thanks for the explanation. We also need an external file for data processing, but we've used the file templates, which are already available: www2.census.gov/programs-surveys/acs/summary_file/2014/data/2014_5yr_Summary_FileTemplates.zip. My guess/hope is that these files are still specific to the 5-year estimates.
What they're missing is any metadata, so the table-shells file is still really useful for that. Thanks for posting.
Cancel
Up
0
Down
Reply
Cancel
Glenn Rice
over 8 years ago
And.... Thank YOU for letting me know where the Bureau is now putting data on its FTP site! :) I was looking all over for the 2014 1-year data.
Cancel
Up
0
Down
Reply
Cancel