7 States have now been released including California. I only call this
out specifically since California includes 12 (?) % of the total U.S.
Also, below is an email from Bob Schwartz in PA, which I hope he
doesn't mind my sharing with the listserv. His email has been
forwarded to Census Bureau staff, but we have not gotten any response
In anticipation of the 2010 Census Summary File 1 for Pennsylvania, I
downloaded the 2010 Census Summary File 1 for Hawaii and immediately
noticed problems with the file and the documentation.
1. I unzipped the zipped file and noted that the 47 data segments
have a suffix of ".sf1", which it seems to me, should be ".txt". You
rename each file to a ".txt" but why should that be necessary?
2. In the "README File for 2010 Census Summary File 1 Delivered
via FTP", is the statement "This is done so that individual files will
not have more than 255 fields..." WRONG! The explanation for this is
that there are fewer than 255 data fields HOWEVER, EVERY DATA FILE HAS 5
FIELDS PRECEDING THE ACTUAL DATA. Therefore, if you add 5 to every
number under the column "Number of data cells" to get the total number
of fields, you will find 9 files with more than 255 fields! These 9
files cannot be imported into Microsoft Access which is my database.
3. In the "README File for 2010 Census Summary File 1 Delivered
via FTP", is the statement "All fields classified as numeric (N) should
be imported as long integers" WRONG! Tables P13, P17, P37, and H12 (and
their racial files A-I) are expressed decimal fields which should not be
set to integer.
Bob Schwartz, Data Administrator Phone: (412) 391-5590 Ext
Southwestern Pennsylvania Commission FAX: (412) 391-9160
Regional Enterprise Tower E-mail:
425 Sixth Avenue, Suite 2500 SPC web address:
Pittsburgh, PA 15219-1852 My normal hours: