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

U.S. Petroleum Balance -- Production, Foreign Trade, Stocks, and Refined Products: 1980 to 2005 (Statistical Abstract 2008 Table 0875)

Photo of a Chacma Baboon

Size: 13.6 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. Energy Information Administration,

U.S. Energy Information Administration,

Petroleum Supply Annual, volume 1 (released 23 October 2006).

referenced on dataset section Data (#1)
U.S. Energy Information Administration, http://www.eia.doe.gov/oil_gas/petroleum/data_publications/petroleum_supply_annual/psa_volume1/psa_volume1.html

U.S. Energy Information Administration,

Petroleum Supply Annual, volume 1 (released 23 October 2006).

For more information:

http://www.eia.doe.gov/oil_gas/petroleum/data_publications/petroleum_supply_annual/psa_volume1/psa_volume1.html

Definitions

Barrel (petroleum): A unit of volume equal t…

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. See footnote 2, Table 876.
  2. SPR = Strategic petroleum reserve.
  3. Includes ethane.

Headnotes

[In millions of barrels (6,242 represents 6,242,000,000). For information on the methodology and accuracy of petroleum supply information, see < http://tonto.eia.doe.gov/FTPROOT/features/art0209.pdf >. Minus sign (-) indicates decrease]

Shape

table: [78, 27]

Snippet

(Million barrels)
Petroleum products supplied for .……..domestic use 6242 5861 5583 5559 5756 5740 5942 6083 6308 6324 6201 6101 6234 6291 6467.128 7087.28 6701.059 6796.411 6904.756 7124.558 7210.594 7171.777 7212.876 7312.229 7587.601 7592.789
Production of products, total 5765 5432 5204 5160 5392 5363 5604 5680 5849 5874 5934 5933 6050 6182 6244.337 6940.409 6510.823 6670.929 6732.993 6774.281 6903.266 6941.935 6924.778 6979.29 7198.076 (NA)
Crude input to refineries 4934 4552 4297 4265 4408 4381 4641 4692 4835 4891 4894 4855 4909 4969 5061.111 5718.122 5195.265 5351.466 5434.383 5403.45 5514.395 5521.637 5455.53 5585.875 5663.861 5555.332
Oil, field production 1 3138 3129 3157 3171 3250 3274 3168 3047 2979 2779 2685 2707 2617 2499 2431.476 2405.6 2366.017 2354.831 2281.919 2146.732 2125.03 2117.511 2097.124 2073.453 1983.302 1890.106
Alaska 592 587 619 626 631 666 681 716 738 684 647 656 627 577 568.948 541.654 509.999 472.949 428.851 383.198 354 351.412 359.335 355.582 332.465 315.42
Lower 48 States 2555 2541 2538 2545 2619 2608 2487 2331 2241 2095 2037 2050 1997 1922 1862.529 1852.615 1856.017 1881.882 1853.069 1763.533 1771 1766.099 1737.789 1717.871 1650.836 1574.686
Net imports 1821 1522 1187 1155 1188 1094 1468 1651 1807 2081 2112 2068 2194 2441 2542.052 2604.301 2707.628 2962.991 3137.482 3143.632 3301.464 3397.508 3332.879 3523.158 3682.28 3684.352
Imports (gross excluding SPR) 2 1910 1511 1213 1130 1182 1125 1507 1679 1845 2112 2142 2111 2223 2472 2573.587 2638.81 2747.839 3002.299 3177.584 3183.622 3316.81 3400.982 3330.408 3527.696 3692.063 3677.082
SPR 2 imports 16 93 60 85 72 43 18 27 19 20 10 0 4 5 4.485 0 0 0 0 3.041 3.006 3.912 5.767 0 0 0
Exports -105 83 86 60 66 75 56 55 57 52 40 42 32 36 36.02 34.509 40.211 39.308 40.102 43.031 18.352 7.386 3.296 4.538 9.783 11.619
27=. ... snip ...
Source: U.S. Energy Information Administration,
Petroleum Supply Annual, volume 1 (released 23 October 2006).

Symbols

Notes (pg 2)

  • (NA) Not available. – Represents zero.

Tablenum

0875

Year

2008

History

Uploaded by (admin) Modified by (admin)