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

National Health Expenditures by Object 1990 to 2005, (Statistical Abstract 2008 Table 0124)

Photo of a Chimpanzee

Size: 7.2 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. Centers for Medicare and Medicaid Services,

U. S. Centers for Medicare and Medicaid Services,

Office of the Actuary, “National Health Expenditure Accounts”.

referenced on dataset section Data (#1)
U. S. Centers for Medicare and Medicaid Services, http://www.cms.hhs.gov/NationalHealthExpendData/

U. S. Centers for Medicare and Medicaid Services,

Office of the Actuary, “National Health Expenditure Accounts”.

For more information:

http://www.cms.hhs.gov/NationalHealthExpendData/

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. Includes nonpatient revenues, privately-funded construction, and industrial inplant.
  2. Includes services of registered and practical nurses in private duty, podiatrists, optometrists, physical therapists, clinical psychologists, chiropractors, naturopaths, and Christian Science practitioners.
  3. Includes expenditures for eyeglasses, hearing aids, orthopedic appliances, artificial limbs, crutches, wheelchairs, etc.
  4. Includes administrative expenses of federally financed health programs.
  5. Research and development expenditures of drug companies and other manufacturers and providers of medical equipment and supplies are excluded from research expenditures, but are included in the expenditure class in which the product falls.
  6. Represents expenditures for total medical sector acquisitions of structures and equipment including structures that house medical professionals’ offices.

Headnotes

[In billions of dollars (714.0 represents $254,900,000,000). Excludes Puerto Rico and island areas.

Shape

table: [32, 18]

Snippet

Object of expenditure 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 proj.
Total 714.018677683 781.610536021 849.048949769 912.55734377 962.196013362 1016.50325059 1068.89931236 1125.38055043 1190.89030145 1265.26985288 1353.25608893 1469.60451094 1602.83248747 1733.43599945 1858.88840563 1987.68862571 2122.48789635
Spent by:
Consumers 369.821479363 394.640462542 418.080547106 440.693361158 451.120512469 471.467089174 495.000530886 521.739511036 560.519762395 601.832574732 648.127710001 698.711573512 762.284231192 828.353943804 887.226065837 943.79692418 978.039733999
Out-of-pocket 136.097761135 140.100950356 143.347683167 145.168824713 142.921362585 146.2751581 152.088996548 162.48865707 175.485862038 184.133133544 192.942095405 199.964908707 211.271193241 224.533773274 235.764500182 249.444885019 250.608022247
Private insurance 233.723718228 254.539512186 274.732863939 295.524536446 308.199149884 325.191931075 342.911534338 359.250853965 385.033900357 417.699441188 455.185614596 498.746664805 551.013037952 603.82017053 651.461565655 694.352039161 727.431711751
Public 286.700340719 325.459145617 363.57595278 400.097891756 435.859330275 464.816683416 488.410514411 511.218302719 528.21409435 554.846848985 596.116127823 661.145289403 722.11682993 777.679324599 838.02564698 902.678562349 992.921644037
Other 1 57.496857601 61.5109278633 67.3924498822 71.7660908559 75.2161706184 80.2194780012 85.4882670652 92.4227366785 102.156444705 108.590429162 109.01225111 109.747648025 118.431426352 127.402731048 133.636692814 141.213139185 151.526486315
Spent for:
Health services and supplies 666.671139426 731.456451203 793.70944373 853.221153118 900.336628296 952.775435308 1002.87745561 1054.29316686 1111.68580208 1179.84529038 1264.44679082 1376.15956116 1498.82236434 1621.69670435 1738.94662318 1860.88994837 1987.70725835
18=. ... snip ...
Source: U. S. Centers for Medicare and Medicaid Services,
Office of the Actuary, “National Health Expenditure Accounts”.

Tablenum

0124

Year

2008

History

Uploaded by (admin) Modified by (admin)