ACS Data Users Group

 View Only
Back to discussions
Expand all | Collapse all

Seek solution to crosswalk table and column IDs of all ACS Summary files

  • 1.  Seek solution to crosswalk table and column IDs of all ACS Summary files

    Posted 01-13-2015 01:05 PM
    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


  • 2.  RE: Seek solution to crosswalk table and column IDs of all ACS Summary files

    Posted 01-14-2015 07:19 AM
    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.