CISER header image
Cornell University Cornell University CISER

CISER Census 2010 SF1 Download Center

Rationale:

This site was developed to serve as an alternative to the Census Bureau's FTP Site for the 2010 SF1 Urban-Rural Update files. 

When you download 2010 SF1 Urban-Rural Update files at the Census Bureau's FTP site, it comes in zip files each containing 49 segments (50 if you include the product package list).  The first file is the Geo Header and the next 48 pertain to the fields that comprise the whole of the summary files.    Much work has to be done in order for you to process this package.  First, the files are mixed format.   The Geo Header file is a fixed format file and two of its variables (AREALAND and AREAWATR) have to be converted to string. The next 48 segment files are comma-delimited, with no headers, and has a .ur1 extension.  You have to use a Microsoft Access shell  on all 49 files in order to properly read and assign the correct type to the variables in each file.  In addition, in 9 of those comma-delimited files, you have to surgically (read, manually) delete the first four variables, and you also have to change the extension name of all 49 files from .ur1 to .txt.   If you decide to import the comma-delimited files directly into a spreadsheet or statistical package (instead of using the MS Access shell), they won't have variable names (because there are no headers) and the values corresponding to the CHARITER and CIFSN variables may be read in as numeric because there are no indications that they are string (i.e., the values of what are supposed be string variables are not enclosed in quotes to indicate they are string). 

Given above, we made life easy for you.  We've made some enhancements to the Census 2010 SF1 files and made them available here.

We combined all 49 segments (including the geo header) for each state into one file and made it available in four (4) ready-to-use formats --SAS, SPSS, Stata, and CSV (with headers and quoted strings).  We also provided setup files for the CSV files in SAS, SPSS, Stata, and R.  Each file here contains all records (tables/variables) for each state and for all 50 states

In addition, we've retained and enhanced the 49 segment files that users download from the CB's FTP site for those who do not have the capacity to process big datasets.  Each segment is comma-delimited, and now has headers, with string values enclosed in quotes so they can be properly read in as string, and we made its extension name .csv so it can be imported readily into a statistical software or spreadsheet.  You can download the individual segments for each state under the heading CSV49 below.

Access: 

There is no fee for this service.  You can download these files for free.  Just click on the data you want to download, enter the recaptcha text to validate you are human (not machine), and then agree to the CISER Data Use Agreement.  That's it!

Who can use this site:

This is a great site for you if...

 a) you are uncertain about the tables/variables you want to work on and/or you want to have ALL SF1 tables/variables at your disposal, and

 b) your computing system has the capacity to process the size of the files you selected, and

 c) you want an easy download.  

If you are certain about and want to work on selected tables/variables only OR you do not have the computing capacity to process the size of the files you are interested in.  An alternative site that we highly recommend is nhgis.org. They have an amazing tool for extracting selected SF1 tables/variables.  And their service is free as well.  NHGIS has a very close relationship with CISER through our director Bill Block.

Please read important short notes below the table for additional information about the files you are downloading.

  SAS SPSS STATA CSV CSV49
State
No. of Variables
No. of Records
File
Zip Size (GB)
Unzipped Size (GB)
File
Zip Size (GB)
Unzipped Size (GB)
File
Zip Size (GB)
Unzipped Size (GB)
File
Zip Size (GB)
Unzipped Size (GB)
File
Zip Size (GB)
Unzipped Size (GB)
National (US)
9,060
590,584
3.135
42.737
1.881
8.429
2.067
17.869
1.617
12.082
1.486
12.598
All 50 States
9,060
13,717,944
19.740
969.000
5.616
64.548
14.009
358.329
 
 
 
Alabama
9,060
299,640
0.414
21.684
0.245
3.096
0.400
5.909
0.212
4.119
0.232
2.768
Alaska
9,060
59,967
0.089
4.341
0.047
0.619
0.071
1.038
0.041
0.855
0.042
0.619
Arizona
9,060
283,940
0.444
20.548
0.228
2.954
0.415
6.107
0.227
3.905
0.241
2.609
Arkansas
9,060
235,129
0.325
17.016
0.185
2.416
0.301
4.479
0.163
3.275
0.179
2.269
California
9,060
903,231
2.033
65.362
1.096
9.784
1.805
23.927
1.084
12.805
1.119
8.848
Colorado
9,060
239,873
0.382
17.359
0.225
2.502
0.349
4.927
0.196
3.313
0.208
2.231
Connecticut
9,060
88,875
0.208
6.432
0.116
0.982
0.172
1.723
0.113
1.278
0.117
0.898
Delaware
9,060
30,969
0.063
2.242
0.038
0.333
0.051
0.520
0.034
0.441
0.036
0.308
Florida
9,060
593,314
1.121
42.935
0.600
6.319
1.048
13.975
0.593
8.292
0.628
5.643
Georgia
9,060
353,957
0.607
25.615
0.366
3.742
0.576
7.739
0.321
4.935
0.341
3.362
Hawaii
9,060
37,113
0.092
2.687
0.054
0.408
0.067
0.688
0.048
0.550
0.048
0.410
Idaho
9,060
164,339
0.164
11.893
0.095
1.662
0.179
2.893
0.078
2.204
0.087
1.424
Illinois
9,060
582,544
0.990
42.156
0.510
6.111
0.910
13.133
0.511
8.191
0.553
5.705
Indiana
9,060
331,556
0.520
23.994
0.272
3.468
0.504
6.868
0.272
4.623
0.297
3.174
Iowa
9,060
278,946
0.370
20.187
0.148
2.548
0.343
5.156
0.184
3.911
0.203
2.755
Kansas
9,060
288,401
0.355
20.871
0.167
2.934
0.336
5.513
0.173
3.976
0.186
2.718
Kentucky
9,060
203,084
0.318
14.697
0.167
2.134
0.289
3.869
0.166
2.848
0.181
1.971
Louisiana
9,060
255,471
0.397
18.488
.0232
2.662
0.359
5.049
0.203
3.561
0.221
2.447
Maine
9,060
86,242
0.121
6.242
0.060
0.899
0.110
1.416
0.061
1.210
0.067
0.842
Maryland
9,060
189,386
0.362
13.706
0.191
2.024
0.317
3.904
0.189
2.691
0.203
1.89
Massachusetts
9,060
196,412
0.386
14.214
0.211
2.120
0.339
4.127
0.206
2.769
0.218
1.901
Michigan
9,060
416,302
0.708
30.126
0.369
4.383
0.640
9.048
0.370
5.839
0.398
4.033
Minnesota
9,060
338,003
0.493
24.46
0.285
3.500
0.447
6.810
0.248
4.767
0.267
3.373
Mississippi
9,060
209,572
0.287
15.166
0.171
2.162
0.279
3.884
0.147
2.896
0.162
1.969
Missouri
9,060
422,218
0.566
30.554
0.327
4.342
0.538
8.673
0.283
5.843
0.314
3.997
Montana
9,060
150,211
0.148
10.871
0.085
1.514
0.146
2.464
0.069
2.034
0.077
1.347
Nebraska
9,060
228,782
0.243
16.557
0.108
2.305
0.240
4.117
0.113
3.123
0.124
2.105
Nevada
9,060
101,738
0.177
7.363
0.092
1.074
0.157
2.010
0.091
1.415
0.096
0.957
New Hampshire
9,060
59,868
0.096
4.334
0.050
0.634
0.084
1.001
0.050
0.840
0.054
0.578
New Jersey
9,060
219,862
0.510
15.911
0.276
2.411
0.435
4.783
0.273
3.150
0.280
2.206
New Mexico
9,060
192,934
0.242
13.962
0.139
1.970
0.220
3.661
0.119
2.628
0.126
1.745
New York
9,060
475,971
1.070
34.444
0.576
5.188
0.928
11.356
0.568
6.845
0.597
4.854
North Carolina
9,060
379,386
0.710
27.455
0.421
4.025
0.643
8.350
0.376
5.367
0.400
3.755
North Dakota
9,060
165,603
0.144
11.985
0.059
1.647
0.133
2.596
0.063
2.288
0.072
1.596
Ohio
9,060
475,936
0.814
34.441
0.486
5.026
0.739
10.356
0.426
6.717
0.465
4.693
Oklahoma
9,060
317,502
0.462
22.977
0.263
3.281
0.420
6.370
0.225
4.373
0.239
2.951
Oregon
9,060
227,440
0.312
16.459
0.186
2.347
0.304
4.559
0.159
3.107
0.172
2.060
Pennsylvania
9,060
535,331
0.936
38.739
0.485
5.668
0.826
11.850
0.195
3.902
0.522
5.321
Rhode Island
9,060
31,762
0.067
2.300
0.041
0.346
0.055
0.549
0.036
0.451
0.038
0.311
South Carolina
9,060
219,839
0.351
15.910
0.186
2.301
0.328
4.337
0.185
3.048
0.199
2.065
South Dakota
9,060
116,622
0.136
8.440
0.074
1.178
0.117
1.890
0.064
1.645
0.070
1.183
Tennessee
9,060
301,984
0.484
21.854
0.288
3.165
0.468
6.185
0.252
4.221
0.276
2.907
Texas
9,060
1,074,553
1.524
77.759
0.879
11.200
1.646
26.314
0.874
14.779
0.926
9.876
Utah
9,060
137,685
0.194
9.965
0.098
1.428
0.183
2.618
0.098
1.901
0.107
1.283
Vermont
9,060
41,537
0.064
3.007
0.037
0.436
0.048
0.621
0.032
0.589
0.033
0.411
Virginia
9,060
344,806
0.550
24.952
0.286
3.621
0.525
7.431
0.283
4.788
0.305
3.250
Washington
9,060
245,958
0.473
17.799
0.250
2.618
0.418
5.376
0.249
3.461
0.262
2.386
West Virginia
9,060
162,260
0.190
11.743
0.095
1.659
0.180
2.751
0.095
2.226
0.109
1.500
Wisconsin
9,060
326,692
0.499
23.642
0.254
3.404
0.456
6.636
0.257
4.595
0.278
3.218
Wyoming
9,060
95,198
0.086
6.890
0.049
0.957
0.085
1.483
0.039
1.277
0.044
0.830
 
District of Columbia
9,060
9,170
0.024
0.665
0.015
0.103
0.018
0.152
0.013
0.133
0.013
0.094
Puerto Rico
9,060
115,010
0.264
8.324
0.160
1.257
0.203
2.097
0.140
1.696
0.147
1.258
 
TOTAL 9,060 14,432,708  
25.721
1,044.460
 
14.224
153.295
 
22.916
311.157
 
13.086
201.780
 
14.067
145.505


Notes:

  • All files were created in SAS and then exported to SPSS, STATA, and CSV using Stat/Transfer
    Stata Users:  To open the Stata dataset you need to have Stata/SE or STATA/MP  and start by setting maxvar to a number much higher than 9,060 variables (e.g., set maxvar 11000)
  • The four (4) setup files below are applicable to the CSV files under the CSV column (not CSV49).  
  • You are downloading zipped files.  Some of these files can be considered big data when unzipped.  The ZIP SIZE column tells you what the size is of the zip file you are downloading   The UNZIPPED SIZE column tells you what the actual size of the file is when unzipped. 
  • To guide you in your analysis, read the following:
    1. Census 2010 SF1 Technical Documentation
    2. Data Field Descriptors (the Codebook in Excel)
  • For questions, clarifications, corrections, comments, and suggestions, please e-mail Florio Arguillas at foa2@cornell.edu.