Population and Area: 1790 to 2000 (Statistical Abstract 2008 Table 0001)

The Statistical Abstract files are distributed by the census department as excel files. These files have data mixed with notes and references, multiple tables per sheet, and worst of all the table headers aren’t easily matched to their rows and columns. The excel files in this collection are unmolested copies of the census originals, with the following exceptions:

1. A few files had extraneous characters in the title. These were corrected to be consistent. A few files have a sheet of crufty gibberish in the first slot. The sheet order was shuffled but no data were changed.

   The tables that were changed:

   0166 0257 0362 0429 0445 0446 0459 0461 0462 0464 0465 0466 0467 0469 0479 0480 0481 0482 0483 0484 0485 0486 0487 0559 0628 0629 1144 1227 1231

1. The first four files have been restructured to allow full comprehension of the table. If you’d like to help clean up the data follow along with what’s there.

The CSV files, and the payload portions of the yaml files, have not been processed beyond extracting an array (excel sheets) of 2-D arrays (each sheet’s cells).

Some metadata (title, footnotes, symbols, and sources) has been copied (without molesting the imported stream) into the appropriate slot in this schema. This metadata identification was purposefully done to be strict and simple, and the original files are somewhat irregular, so it’s possible that some metadata fields were missed

These files have been tagged by hand and received cursory inspection, but you’re advised to check against the originals before you go lauching any Mars rovers.

Notes (pg 2)

1. Data for 1790 to 1980 cover inland water only. Data for 1990 comprise Great Lakes, inland, and coastal water. Data for 2000 comprise Great Lakes, inland, territorial, and coastal water.
2. Revised to include adjustments for underenumeration in southern states; unrevised number is 38,558,371 (10.9 per square mile).
3. Total population count has been revised since the 1980 census publications. Numbers by age, race, Hispanic origin, and sex have not been corrected.
4. The April 1, 1990, census count includes count question resolution corrections processed through December 1997, and does not include adjustments for census coverage errors.
5. Data reflect corrections made after publication of the results.
6. Reflects modifications to the Census 2000 population as documented in the Count Question Resolution program.

[Area figures represent area on indicated date including in some cases considerable areas not then organized or settled, and not covered by the census. Area data include Alaska beginning in 1870 and Hawaii beginning in 1900. Total area figures for 1790 to 1970 have been recalculated on the basis of the remeasurement of states and counties for the 1980 census, but not on the basis of the 1990 census. The land and water area figures for past censuses have not been adjusted and are not strictly comparable with the total area data for comparable dates because the land areas were derived from different base data, and these values are known to have changed with the construction of reservoirs, draining of lakes, etc. Density figures are based on land area measurements as reported in earlier censuses]

table: [23, 13]

Notes (pg 2)

• (X) Not applicable.

0001

2008