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

Social Security--Covered Employment, Earnings, and Contribution Rates: 1970 to 2006 (Statistical Abstract 2008 Table 0527)

Photo of a Allen's Swamp Monkey

Size: 7.4 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
U.S. Social Security Administration,

U.S. Social Security Administration,

Annual Statistical Supplement to the Social Security Bulletin;

and unpublished data.

referenced on dataset section Data (#1)
U.S. Social Security Administration, http://www.ssa.gov/policy/docs/statcomps/supplement/2006/

U.S. Social Security Administration,

Annual Statistical Supplement to the Social Security Bulletin;

and unpublished data.

For more information:

http://www.ssa.gov/policy/docs/statcomps/supplement/2006/

referenced on dataset section Notes (#2)

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. Estimated number fully insured for retirement and/or survivor benefits
    as of end of year, except 1970 as of beginning of year.
  2. Includes self-employment. Averages per worker computed with unrounded earnings and worker amounts,
    thus may not agree with rounded table amounts.
  3. The maximum taxable earnings for HI was $125,000 in 1991, $130,200
    in 1992, and 135,000 in 1993. Beginning 1994 upper limit on earnings subject
    to HI taxes was repealed.
  4. As of January 1, 2006, each employee and employer pays
    7.65 percent and the self-employed pay 15.3 percent.
  5. Self-employed pays 11.3 percent in 1984, 11.8 percent in 1985,
    12.3 percent in 1986 and 1987, and 13.02 percent in 1988 and 1989.
    The additional amount is supplied from general revenues.
    Beginning 1990, self-employed pays 15.3 percent, and half of the
    tax is deductible for income tax purposes and for computing
    self-employment income subject to social security tax.
  6. 1970-1982, as of July 1; beginning 1983, as of January 1.

Headnotes

[108.4 represents 108,400,000. Includes Puerto Rico, Virgin Islands, American Samoa, and Guam.
Represents all reported employment. Data are estimated.
OASDHI = Old-age, survivors, disability, and health insurance;
SMI = Supplementary medical insurance]

Shape

table: [38, 30]

Snippet

Workers with insured status 1 Million 108.415 140.475 142.9 144.7 146.5 148.3 150.955 153.232 155.73 158.295 161.346 163.958 165.825 167.446 169.253 170.884 173.203 175.401 177.864 180.38 182.921 185.469 187.894 189.684 191.481 193.068 195.111 197.095
Male Million 62.945 76.637 77.6 78.3 79 79.6 80.711 81.703 82.744 83.808 85.239 86.458 87.217 87.865 88.555 89.232 90.208 91.121 92.164 93.244 94.342 95.627 96.687 97.435 98.139 99.091 100.033 100.912
Female Million 45.47 63.838 65.2 66.4 67.5 68.6 70.244 71.529 72.986 74.487 76.107 77.501 78.609 79.581 80.698 81.652 82.995 84.28 85.699 87.135 88.579 89.842 91.207 92.249 93.342 93.977 95.077 96.183
Under 25 years Million 19.076 25.712 25.3 24.4 23.2 22.4 22.027 21.672 21.369 21.268 21.378 21.254 20.761 20.103 19.513 18.995 18.794 18.812 19.102 19.659 20.259 20.831 21.157 20.997 20.59 20.096 19.804 19.544
25 to 34 years Million 22.86 36.47 37.2 37.9 38.6 39.4 40.07 40.618 41.035 41.254 41.547 41.56 41.288 40.738 40.277 39.794 39.448 38.909 38.256 37.541 36.966 36.582 36.367 36.306 36.268 36.13 36.144 36.278
35 to 44 years Million 18.906 23.025 24.5 25.9 27.2 28.6 29.889 31.184 32.262 33.535 34.919 36.458 37.223 38.063 38.92 39.773 40.589 41.239 41.806 42.257 42.51 42.49 42.279 41.848 41.454 41.129 40.815 40.405
45 to 54 years Million 19.2 18.614 18.6 18.6 18.8 19 19.257 19.747 20.615 21.445 22.118 22.768 24.222 25.599 26.869 28.218 29.533 30.844 31.904 33.121 34.494 35.944 36.805 37.583 38.395 39.288 40.154 40.902
55 to 59 years Million 7.925 9.27 9.2 9.2 9.2 9.1 9.018 8.947 8.795 8.708 8.746 8.755 8.815 9.005 9.268 9.479 9.741 10.164 10.79 11.323 11.809 12.182 13.067 13.856 14.556 15.355 16.222 16.726
60 to 64 years Million 6.686 8.244 8.5 8.5 8.8 8.7 8.838 8.734 8.787 8.709 8.711 8.728 8.607 8.513 8.535 8.412 8.513 8.544 8.82 9.093 9.244 9.533 9.989 10.508 11.148 11.521 11.923 12.622
65 to 69 years Million 5.262 6.984 7.1 7.2 7.3 7.3 7.538 7.69 7.837 7.942 8.116 8.161 8.123 8.167 8.213 8.143 8.135 8.098 8.069 7.985 8.025 8.052 8.196 8.353 8.653 8.899 9.148 9.522
30=. … snip …
Annual Statistical Supplement to the Social Security Bulletin;
and unpublished data.

Symbols

Notes (pg 2)

  • (NA) Not available.

Tablenum

0527 (or maybe 531)

Year

2008

History

Uploaded by (admin) Modified by (admin)