Estimated Unauthorized Immigrants by Selected States and Countries of Origin: 2000 and 2005 (Statistical Abstract 2008 Table 0046)

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.

[In thousands (8,460 represents 8,460,000). As of January. Unauthorized immigrants refers to foreign-born persons who entered the United States without inspection or who were admitted temporarily and stayed past the date they were required to leave. Unathorized aliens who have applied for but have not yet received approval to lawfully remain in the United States are considered to be unauthorized. These estimates were calculated using a “residual method,” whereby estimates of the legally resident foreign-born population were subtracted from the total foreign-born population in order to derive the unauthorized immigrant population. All of these component populations were resident in the United States on January 1, 2005 and entered during the 1980-2004 period. Persons who entered the United States prior to 1980 were assumed to be legally resident. Estimates of the legally resident foreign-born were based primarily on administrative data of the Department of Homeland Security, while estimates of the total foreign-born population were obtained from the American Community Survey of the U.S. Census Bureau. Estimates for 2000 are based on the same methodology, assumptions, and definitions with the exception that data from Census 2000 were used to estimate the foreign-born population in 2000 that entered the United States from January 1, 1980 through December 31, 1999]

table: [32, 3]

0046

2008