Dataset

Mean Hourly Earnings and Weekly Hours by Selected

Added By Infochimps

The Statistical Abstract files are distributed by the US Census Department as Microsoft Excel files. These files have data mixed with notes and references, multiple tables per sheet, and, worst of all, the table headers are not easily matched to their rows and columns.

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 (this is table 624):

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

This dataset consists of a table of 56 rows and 7 columns.

Covers civilian workers in private industry establishments and state and local governments in the 50 states and DC. Excludes private households, federal government and agriculture. Based on survey of 25,723 establishments representing over 84 million workers; see source and Appendix III for details about the National Compensation Survey

Footnotes

  1. Earnings are straight time hourly wages or salary, including incentive pay,
    cost-of-living adjustments, and hazard pay. Excludes premium pay for overtime, vacations
    and holidays, nonproduction bonuses and tips.
  2. Based on definition used by each establishment.
  3. Workers whose wages are determined through collective bargaining.
  4. Time worker wages are based solely on an hourly rate or salary. Incentive workers
    wages are based at least in part on productivity payments such as piece rates or commissions.
  5. For private industry only. See footnotes 3 and 4, Table 614, for composition of goods
    and service producing industries.
  6. Private establishments employing 1 to 99 workers and state and local government
    establishments employing 50 to 99 workers.
  7. Composition of regions:
    NEW ENGLAND: Maine, New Hampshire, Vermont, Massachusetts, Rhode Island, Connecticut.
    MIDDLE ATLANTIC: New York, New Jersey, and Pennsylvania.
    EAST NORTH CENTRAL: Ohio, Indiana, Illinois, Michigan, Wisconsin.
    WEST NORTH CENTRAL: Minnesota, Iowa, Missouri, North Dakota, South Dakota, Nebraska,
    Kansas.
    SOUTH ATLANTIC: Delaware, Maryland, District of Columbia, Virginia, West Virginia,
    North Carolina, South Carolina, Georgia, Florida.
    EAST SOUTH CENTRAL: Kentucky, Tennessee, Alabama, Mississippi.
    WEST SOUTH CENTRAL: Arkansas, Louisiana, Oklahoma, Texas.
    MOUNTAIN: Montana, Idaho, Wyoming, Colorado, New Mexico, Arizona, Utah, Nevada.
    PACIFIC: Washington, Oregon, California, Alaska, Hawaii.
  8. Earnings are straight time hourly wages or salary, including incentive pay,
    cost-of-living adjustments, and hazard pay. Excludes premium pay for overtime, vacations
    and holidays, nonproduction bonuses and tips.
  9. Based on definition used by each establishment.
  10. Workers whose wages are determined through collective bargaining.
  11. Time worker wages are based solely on an hourly rate or salary. Incentive workers
    wages are based at least in part on productivity payments such as piece rates or commissions.
  12. For private industry only.
  13. Private establishments employing 1 to 99 workers and state and local government
    establishments employing 50 to 99 workers.
  14. Composition of regions:
    NEW ENGLAND: Maine, New Hampshire, Vermont, Massachusetts, Rhode Island, Connecticut.
    MIDDLE ATLANTIC: New York, New Jersey, and Pennsylvania.
    EAST NORTH CENTRAL: Ohio, Indiana, Illinois, Michigan, Wisconsin.
    WEST NORTH CENTRAL: Minnesota, Iowa, Missouri, North Dakota, South Dakota, Nebraska, and
    Kansas.
    SOUTH ATLANTIC: Delaware, Maryland, District of Columbia, Virginia, West Virginia.
    North Carolina, South Carolina, Georgia, Florida.
    EAST SOUTH CENTRAL: Kentucky, Tennessee, Alabama, Mississippi.
    WEST SOUTH CENTRAL: Arkansas, Louisiana, Oklahoma, and Texas.
    MOUNTAIN: Montana, Idaho, Wyoming, Colorado, New Mexico, Arizona, Utah, Nevada.
    PACIFIC: Washington, Oregon, California, Alaska, and Hawaii.
  15. Earnings are straight time hourly wages or salary, including incentive pay,
    cost-of-living adjustments, and hazard pay. Excludes premium pay for overtime, vacations
    and holidays, nonproduction bonuses and tips.
  16. Based on definition used by each establishment.
  17. Workers whose wages are determined through collective bargaining.
  18. Time worker wages are based solely on an hourly rate or salary. Incentive workers
    wages are based at least in part on productivity payments such as piece rates or commissions.
  19. For private industry only.
  20. Private establishments employing 1 to 99 workers and state and local government
    establishments employing 50 to 99 workers.
  21. Composition of regions:
    NEW ENGLAND: Maine, New Hampshire, Vermont, Massachusetts, Rhode Island, Connecticut.
    MIDDLE ATLANTIC: New York, New Jersey, and Pennsylvania.
    EAST NORTH CENTRAL: Ohio, Indiana, Illinois, Michigan, Wisconsin.
    WEST NORTH CENTRAL: Minnesota, Iowa, Missouri, North Dakota, South Dakota, Nebraska, and
    Kansas.
    SOUTH ATLANTIC: Delaware, Maryland, District of Columbia, Virginia, West Virginia.
    North Carolina, South Carolina, Georgia, Florida.
    EAST SOUTH CENTRAL: Kentucky, Tennessee, Alabama, Mississippi.
    WEST SOUTH CENTRAL: Arkansas, Louisiana, Oklahoma, and Texas.
    MOUNTAIN: Montana, Idaho, Wyoming, Colorado, New Mexico, Arizona, Utah, Nevada.
    PACIFIC: Washington, Oregon, California, Alaska, and Hawaii.

License

Public Domain (Government Work)

This dataset was prepared by the government and is therefore in the public domain. There are no restrictions upon its use.