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

U.S. Foreign Trade in Selected Mineral Fuels: 1970 to 2005 (Statistical Abstract 2008 Table 0900)

Photo of a Monkey

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

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,

Annual Energy Review, annual.

referenced on dataset section Data (#1)

U.S. Energy Information Administration, http://www.eia.doe.gov/emeu/aer/contents.html

U.S. Energy Information Administration,

Annual Energy Review, annual.

For more information:

http://www.eia.doe.gov/emeu/aer/contents.html

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. Preliminary.
  2. Beginning 1977, includes strategic petroleum reserve imports.

Headnotes

[821 represents 821,000,000,000 cubic feet. Minus sign (-) indicates an excess of imports over exports.]

Shape

table: [22, 38]

Snippet

Natural gas:
Imports Billion cubic feet 820.78 934.548 1019.496 1032.901 959.284 953.008 963.768 1011.001 965.545 1253.383 984.767 903.949 933.336 918.407 843.06 949.715 750.449 992.532 1293.812 1381.52 1532.259 1773.313 2137.504 2350.115 2623.839 2841.048 2937.413 2994.173 3152.058 3585.505 3781.603 3976.939 4015.463 3943.749 4258.558 4285.348
Exports Billion cubic feet 69.813 80.212 78.013 77.169 76.789 72.675 64.711 55.626 52.532 55.673 48.731 59.372 51.728 54.638 54.753 55.268 61.271 54.02 73.638 106.871 85.565 129.244 216.282 140.183 161.738 154.119 153.393 157.006 159.007 163.415 243.716 373.278 516.233 679.922 854.138 787.1
Net trade Billion cubic feet -750.967 -854.336 -941.483 -955.732 -882.495 -880.333 -899.057 -955.375 -913.013 -1197.71 -936.036 -844.577 -881.608 -863.769 -788.307 -894.447 -689.178 -938.512 -1220.174 -1274.649 -1446.694 -1644.069 -1921.222 -2209.932 -2462.101 -2686.929 -2784.02 -2837.167 -2993.051 -3422.09 -3537.887 -3603.661 -3499.23 -3263.827 -3404.42 -3498.248
Crude oil:
Imports 2 Million barrels 483.293 613.417 811.135 1183.996 1269.155 1498.181 1935.012 2414.327 2319.826 2379.541 1926.162 1604.703 1273.214 1215.225 1253.949 1168.297 1524.978 1705.922 1869.005 2132.761 2151.387 2110.532 2226.341 2477.23 2578.072 2638.81 2747.839 3002.299 3177.584 3186.663 3319.816 3404.894 3336.175 3527.696 3692.063 3670.403
Exports Million barrels 4.991 0.503 0.187 0.697 1.074 2.146 2.941 18.255 57.728 85.707 104.935 83.166 86.279 59.948 66.233 74.513 56.205 54.964 56.713 51.683 39.653 42.385 32.473 35.834 36.02 34.509 40.211 39.308 40.102 43.031 18.352 7.386 3.296 4.538 9.783 15.089
Net trade Million barrels -478.302 -612.914 -810.948 -1183.299 -1268.081 -1496.035 -1932.071 -2396.072 -2262.098 -2293.834 -1821.227 -1521.537 -1186.935 -1155.277 -1187.716 -1093.784 -1468.773 -1650.958 -1812.292 -2081.078 -2111.734 -2068.147 -2193.868 -2441.396 -2542.052 -2604.301 -2707.628 -2962.991 -3137.482 -3143.632 -3301.464 -3397.508 -3332.879 -3523.158 -3682.28 -3655.314
Petroleum products:
Imports Million barrels 764.769 819.463 924.179 1099.497 961.792 712.154 741.399 800.319 732.819 706.946 602.541 583.717 593.144 628.519 735.987 681.211 746.604 731.437 840.135 809.338 775.008 673.231 660.556 669.224 705.549 585.943 721.289 706.671 730.862 774.411 874.27 928.144 872.363 948.805 1119.041 1266.956
38=. ... snip ...
Source: U.S. Energy Information Administration,
Annual Energy Review, annual.

Symbols

Notes (pg 2)

  • (Z) Less than 500,000 barrels or 50,000 short tons.

Tablenum

0900

Year

2008

History

Uploaded by (admin) Modified by (admin)