what works · what's broken · what's on the way

Personal Income in Current and Constant (2000) Dollars by State: 1979 to 2006 (Statistical Abstract 2008 Table 0658)

Photo of a Barbary Macaques

Size: 21.8 KB (approx) Downloaded: 0 times
Available in: csv, yaml, and xls Category: demographics/us

Tags

About

The Statistical Abstract of the United States is the standard summary of statistics on the social, political, and economic organization of the United States. It is also designed to serve as a guide to other statistical publications and sources. The latter function is served by the introductory text to each section, the source note appearing below each table, and Appendix I, which comprises the Guide to Sources of Statistics, the Guide to State Statistical Abstracts, and the Guide to Foreign Statistical Abstracts. This volume includes a selection of data from many statistical sources, both government and private. Publications cited as sources usually contain additional statistical detail and more comprehensive discussions of definitions and concepts. Data not available in publications issued by the contributing agency but obtained from the Internet or unpublished records are identified in the source notes. More information on the subjects covered in the tables so noted may generally be obtained from the source.

Although emphasis in the Statistical Abstract is primarily given to national data, many tables present data for regions and individual states and a smaller number for metropolitan areas and cities. Appendix II, Metropolitan and Micropolitan Statistical Areas: Concepts, Components, and Population, presents explanatory text, a complete current listing and population data for metropolitan and micropolitan areas defined as of December 2005. Statistics for the Commonwealth of Puerto Rico and for island areas of the United States are included in many state tables and are supplemented by information in Section 29. Additional information for states, cities, counties, metropolitan areas, and other small units, as well as more historical data are available in various supplements to the Abstract.

Fields

nametypeunitstags

Credits

US Census Bureau source http://www.census.gov/statab/www

U.S. Census Bureau, Statistical Abstract of the United States: 2008 (127th Edition) Washington, DC, 2007; http://www.census.gov/statab/www/
Philip (flip) Kromer converted http://infochimp.org/flip
Except as noted, U.S. Bureau of Economic Analysis, http://www.bea.gov/regional/spi

Except as noted, U.S. Bureau of Economic Analysis,

Survey of Current Business, April 2007, and unpublished data. See also

< http://www.bea.gov/regional/spi >.

referenced on dataset section data (#1)

Usage Notes

[none]

Rights Info

All US Census Bureau materials, regardless of the media, are entirely in the public domain. There are no user fees, site licenses, or any special agreements etc for the public or private use, and or reuse of any census title. As tax funded product, it’s all in the public record. Some of our products, however, are special cases. [...] The Statistical Abstract has some data covered by copyright law. Check the table’s footnotes to determine if the data are covered by copyright law.

File structure

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.

Footnotes

Notes (pg 2)

  1. Constant dollar estimates are computed by the Census Bureau using the national implicit price deflator for personal consumption expenditures from the Bureau of Economic Analysis. Any regional differences in the rate of inflation are not reflected in these constant dollar estimates. SOURCE Except as noted, U.S. Bureau of Economic Analysis, Survey of Current Business, April 2007, and unpublished data. See also < http://www.bea.gov/regional/spi >. For more information: http://www.bea.gov/regional/spi

Headnotes

[In thousands of dollars, except percent. 2006 data preliminary. Represents a measure of income received from all sources during the calendar year by residents of each state. Data exclude federal employees overseas and U.S. residents employed by private U.S. firms on temporary foreign assignment. Totals may differ from those in personal income tables based on the national income accounts. See text, Section 13, and summary in Notes sheet. For methodology on how personal income is derived, see http://www.bea.gov/regional/docs/spi2005/ For information on reliability, see Survey of Current Business, December 2003 article at http://www.bea.gov/bea/ARTICLES/2003/12December/1203ReliableSPI.pdf

Shape

table: [63, 60]

Snippet

1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006
($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000) ($1,000)
United States US 00000 00 2053827000 2298255000 2580600000 2764886000 2949883000 3275805000 3511344000 3708199000 3934655000 4237460000 4571133000 4861936000 5032196000 5349384000 5548121000 5833906000 6144741000 6512485000 6907332000 7415709000 7796137000 8422074000 8716992000 8872871000 9150320000 9716351000 10220942000 10860916880 4364366008.63 4413101501.59 4549717912.55 4619075144.51 4724650842.46 5055566701.65 5245822875.58 5407981741.02 5545907508.42 5745241065.13 5938618736.44 6039897139.02 6032506173.73 6232969798.66 6318684585.16 6507134093.29 6709917337.32 6961725122.13 7261397754.51 7726467523.81 7989891878.04 8422074000 8538202049.09 8569344806.94 8665321931.49 8965656574.98 9167339653.61 9480879988.83
Alabama AL 01000 01 27615030 30563947 34004245 35988063 38491395 42692358 45944289 48552784 51501677 55120443 59910792 63678624 67250137 71977381 74862947 79264568 83534453 86972050 91419381 97011788 100662426 105806693 110420937 113835223 118356255 126654900 134736150 143924925 58681718.6936 58688787.9719 59951066.6432 60122394.6674 61649360.9456 65887335.638 68639131.4091 70808651.1397 72591761.4557 74733503.715 77833515.6483 79106828.8259 80618256.2516 83866262.3509 85260460.1105 88411635.8445 91217721.6987 92971500.9567 96105484.4203 101077109.338 103164156.802 105806693 108156147.276 109941108.922 112082971.107 116869423.196 120847183.231 125637177.45
Alaska AK 02000 02 5334297 6025363 6934044 8334625 9365055 10018906 10820869 10780322 10439633 10789400 11833899 12617439 13206523 14003812 14708813 15112637 15414795 15704172 16402151 17085208 17556559 18741427 20049501 20722288 21184467 22259283 23587717 24973549 11335338.6175 11569881.7159 12225042.3131 13923995.1218 14999447.4342 15462229.1499 16165992.8887 15721859.7325 14714692.6579 14628504.7996 15374090.915 15674421.407 15831742.5496 16316895.041 16751680.4282 16856623.2405 16832605.3485 16787467.2624 17242915.5628 17801171.1017 17992886.4976 18741427 19638275.5108 20013412.9146 20061618.2278 20539509.841 21156231.3329 21800297.671
Arizona AZ 04000 04 22474897 26073302 29888566 31597912 34655968 39524390 43833048 47729775 51505696 55245937 59413268 62648543 65389779 69608941 74369681 81554949 88333066 95514037 103557083 113370224 120857125 132557859 138853800 144150287 150582313 164122222 178705724 193982847 47758977.0288 50065866.5847 52694933.0042 52788118.5472 55506387.3406 60998194.333 65485012.5493 69608387.172 72597426.2478 74903651.2284 77187153.9371 77827177.4103 78388092.498 81106614.6999 84698685.724 90966324.9827 96457697.8936 102102725.902 108865357.849 118121052.741 123860748.142 132557859 136005837.757 139219144.888 142600938.474 151441984.627 160284254.617 169334514.997
Arkansas AR 05000 05 15923610 17221311 19545184 20510832 21884407 24522940 26203347 27306808 28308336 30222889 32334389 34076417 36042857 39161726 40822283 43272327 45829436 48679011 50954947 53810406 56051799 58726196 61967016 63234135 66476051 70852806 74058558 78521372 33837544.3592 33068303.3143 34459069.1114 34265815.764 35050943.366 37846379.4061 39146867.1567 39823838.761 39900680.7899 40976854.7644 42007442.8696 42332530.4049 43207529.55 45630273.5831 46491979.9556 48265918.9774 50044701.1804 52036955.7549 53566867.4572 56065354.5604 57444836.2798 58726196 60696040.9035 61071000.1738 62952594.2972 65378651.5091 66424401.5319 68544093.7184
California CA 06000 06 250061031 284455082 319962414 341592799 369132267 413355219 448334610 478831942 515252264 557867421 601455600 648262538 662727720 696670363 707906053 730529381 765805583 810448268 860544880 936008661 999228183 1103841912 1135304060 1147715704 1187040144 1268049043 1335386437 1420245320 531377698.209 546209689.312 564108628.35 570671921.882 591217033.442 637933235.076 669795939.405 698321314.297 726249544.026 756368866.262 781385161.03 805325090.376 794466086.456 811743059.051 806225218.382 814831888.148 836242269.347 866354097.94 904655901.77 975232512.659 1024061678.71 1103841912 1112018394.81 1108454254.31 1124122980.77 1170078380.22 1197731191.2 1239782569.22
60=. ... snip ...
Survey of Current Business, April 2007, and unpublished data. See also
.

Tablenum

0658

Year

2008

History

Uploaded by (admin) Modified by (admin)