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

U.S. Exports, General Imports, and Merchandise Trade Balance by Selected SITC Commodity Group (Statistical Abstract 2008 Table 1279)

Photo of a Adolescent Chacma Baboon

Size: 11.8 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. Census Bureau, http://www.census.gov/foreign-trade/Press-Release/2006pr/final_revisions/

U.S. Census Bureau,

U.S. International Trade in Goods and Services, series FT 900, Final Reports.

< http://www.census.gov/foreign-trade/Press-Release/2003pr/12/ft900.pdf > (released February 13, 2004) and

< http://www.census.gov/foreign-trade/Press-Release/2003pr/12/#ft900 > (relea…

U.S. Census Bureau, http://www.census.gov/foreign-trade/www/

U.S. Census Bureau,

U.S. International Trade in Goods and Services, series FT 900, Final Reports.

< http://www.census.gov/foreign-trade/Press-Release/2003pr/12/ft900.pdf > (released February 13, 2004) and

< http://www.census.gov/foreign-trade/Press-Release/2003pr/12/#ft900 > (relea…

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. F.a.s. basis.
  2. Customs value basis.
  3. Includes other commodities not shown separately.

Headnotes

Shape

table: [107, 29]

Snippet

1990 1995 2000 2001 2002 2003 2004 2005 2006 1990 1995 2000 2001 2002 2003 2004 2005 2006 1990 1995 2000 2001 2002 2003 2004 2005 2006
Unit
Total Million dollars 393592.3 584742 781918 729100 693103 713122 818775 905978 1036635 495310.517767 743445 1218022 1140999 1161366 1260674 1469704 1673455 1853938 -101718.217767 -158703 -436104 -411899 -468263 -547552 -650929 -767477 -817303
Agricultural commodities Million dollars 38722.9 54850 51296 53705 53115 59561 61383 63139 70912 22343.1 29258 39186 39544 42012 47453 54222 59530 65459 16379.8 25592 12110 14161 11103 12108 7161 3609 5453
Animal feeds Million dollars 2868.228789 3667 3780 4221 3824 3878 3808 4029 4534 283.824568 472 597 574 605 636 778 699 828 2584.404221 3195 3183 3647 3219 3242 3030 3330 3706
Cereal flour Million dollars 685.719172 1163 1310 1412 1578 1672 1802 2015 2339 568.519266 1082 1753 1895 2170 2497 2730 3010 3357 117.199906 81 -443 -483 -592 -825 -928 -995 -1018
Coffee Million dollars 11.773913 15 9 16 8 5 7 5 4 1766.377561 2985 2350 1357 1369 1612 1868 2502 2829 -1754.603648 -2970 -2341 -1341 -1361 -1607 -1861 -2497 -2825
Corn Million dollars 6195.462311 7521 4695 4755 5108 4934 6132 5062 7251 23.275157 66 160 135 137 151 127 125 179 6172.187154 7455 4535 4620 4971 4783 6005 4937 7072
Cotton, raw and linters Million dollars 2799.464488 3711 1893 2174 2031 3376 4251 3929 4514 19.943622 29 28 27 25 28 18 20 15 2779.520866 3682 1865 2147 2006 3348 4233 3909 4499
Hides and skins Million dollars 1612.497745 1621 1426 1813 1594 1643 1581 1629 1834 94.442628 140 109 100 84 74 80 79 62 1518.055117 1481 1317 1713 1510 1569 1501 1550 1772
29=. … snip
<http://www.census.gov/foreign-trade/Press-Release/2005pr/final_revisions/> (released 09 June 2006)
<http://www.census.gov/foreign-trade/Press-Release/2006pr/final_revisions/> (released 8 June 2007)

Symbols

Notes (pg 2)

  • (X) Not applicable.

Tablenum

1279

Year

2008

History

Uploaded by (admin) Modified by (admin)