1

I'm trying to to read the 2010 Census data so that I can link some of my research data to geographic information. Ideally I would like to use census tract data and other covariates.

I've downloaded the 2010 SF1 files for the relevant states, but my issue lies in understanding what the text files mean. I use R, but getting the data into R is not a problem (because they're comma-separated). I'm prepared to do massive amounts of data management before I can use the data, but I need simple things... like row and column names. For example, what is:

SF1ST,TN,000,03,0000001,6346105,4921948,1057315,19994,91242,3642,141955,110009,6346105,6056046,290059,6346105,6056046,4800782,1049391,16302,90311,2767,6422,90071,290059,121166,7924,3692,931,875,135533,19938,6463754,5019639,1107178,54874,113398,7785,160880,6463754,6152022,4882031,1094696,47888,110618,6070,10719,311732,137608,12482,6986,2780,1715,150161,6346105,6236096,4921948,1057315,19994,91242,3642,141955,110009,103173,36370,25649,15145,1476,12638,3492,1971,528,2381,384,73,657,533,1482,394,6177,3000,686,100,445,465,88,285,419,237,62,92,23,76,84,59,11,13,12,2,18,518,220,23,70,47,21,2,69,16,8,11,18,4,0,6,3,137,116,9,0,3,7,2,4,4,6346105,290059,6056046,5965975,4800782,1049391,16302,90311,2767,6422,90071,84716,34626,24046,14541,1333,1640,3269,1842,477,933,332,48,102,479,992,56,4897,2646,602,93,178,413,83,96,384,113,16,85,21,36,65,39,4,8,8,0,7,368,176,22,37,43,9,1,48,5,1,9,12,0,0,3,2,88,80,2,0,0,4,2,2,2

from the tn000032010.sf1 file?

Where can I find a key that indexes each value in the vector to tell me what it means?

Or even, is there a list of possible variables (and the way the data is coded) so that I can use API to subset desired data?

I've read the README and spend a few hours going through the 500+ page documentation.

closed as too broad by PolyGeo Mar 28 at 10:46

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 1
    The header row is stored as a separate table. Fields are listed on page 18 of this pdf. The Census Access tutorial linked below is the 2000 version - for the 2010 version (which is a bit more graphical) you can visit this pdf. – Chris W Jul 15 '14 at 18:32
1

So, the census has a template mdb file that is used for importing their sf1 data into... but if you want an open source route here is a post about using postgres to format the data: http://sproke.blogspot.com/2012/01/importing-2010-sf1-census-in-postgresql.html

And if you want to use access, there is that approach: http://www.census.gov/support/cen2000_sf1_ascii.html#msAccess

0

Field Mapping begins on page 2-8. Look at the "Data Dictionary Reference", field size, and starting position. Should give you a template for your files.

Not the answer you're looking for? Browse other questions tagged or ask your own question.