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

U.S. Exports and Imports for Consumption of Merchandise by Customs District: 1980 to 2006 (Statistical Abstract 2008 Table 1274)

Photo of a Adolescent Chacma Baboon

Size: 13.8 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. Census Bureau http://www.census.gov/foreign-trade/Press-Release/ft920_index.html

U.S. Census Bureau

1980-1988, U.S. Highlights of Export and Import Trade, series FT 990;

1989-1990, U.S. Merchandise Trade: Selected Highlights, series FT 920;

1991-2004, U.S. Export History and U.S. Import History on compact disc;

beginning 2005, U.S. Merchandise Trade: Selected Highlights, …
U.S. Census Bureau http://www.census.gov/foreign-trade/www/

U.S. Census Bureau

1980-1988, U.S. Highlights of Export and Import Trade, series FT 990;

1989-1990, U.S. Merchandise Trade: Selected Highlights, series FT 920;

1991-2004, U.S. Export History and U.S. Import History on compact disc;

beginning 2005, U.S. Merchandise Trade: Selected Highlights, …

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. Totals shown for exports reflect the value of estimated parcel post
    and Special Category shipments, and beginning 1987, adjustments for
    undocumented exports to Canada are not distributed by coastal area
    or customs district. Beginning 1985, the value of bituminous coal
    exported through Norfolk, VA; Charleston, SC; and Mobile, AL is
    reflected in the total but not distributed by district.
  2. Beginning 1985, excludes exports of bituminous coal.

Headnotes

[In billions of dollars (220.8 represents $220,800,000,000).
Exports are f.a.s. (free alongside ship) vlue all years;
imports are on customs-value basis for years 1985 to present;
f.a.s. value basis for 1980.
For methodology, see Foreign Trade Statistics in Appendix III]

Shape

table: [62, 49]

Snippet

1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006
Unit 1980 1985 1986 1987 1988 1989 1980 1985 1986 1987 1988 1989
Total 1 00 Billion dollars 220.8 213.1 217.3 252.9 320.4 363.8 393 421.730011428 448.163612021 465.090972324 512.626476328 584.742005461 625.074999447 689.18243122 682.137748539 695.797225018 780 731 693.1 723.743176992 817.9 904.37982 1037.1429 244 343.6 368.7 402.1 437.1 468 490.6 482.083119933 525.260193557 575.074716324 657.285999916 738.612855783 789.885803942 861.724568586 905.709680248 1016.88582292 1205.6 1132.6 1152.5 1250.0968 1460.2 1662.37969 1845.0532
Anchorage, Alaska 31 Billion dollars 1 1.3 1.3 1.7 2.2 2.6 3.7 4.575655158 5.096419839 4.758025556 5.333754748 5.900961949 6.129053468 7.591682826 7.718746427 8.833805227 5.9 7.7 7.3 8.442121574 8.73713 12.05734 14.8655 0.2 0.2 0.3 0.1 0.2 0.4 0.7 0.856848148 1.328244056 1.998196927 3.615233845 5.657211721 6.932194369 7.206233852 7.331728185 9.245384403 13.4 11.5 11.3 9.164709512 10.477 10.22649 11.39853
Baltimore, Maryland 13 Billion dollars 9 5.5 4.9 5.4 6.8 7.7 6.7 8.007006693 7.742487836 7.617438319 8.249265447 9.024071065 8.262064098 7.582782957 6.612076142 5.875412161 6.2 5.7 5.1 6.049522481 7.15268 9.00676 9.99575 6 8.8 11 11.8 12.1 11.8 11.2 10.09255739 10.765343747 11.705183506 13.40003124 14.399225303 13.978183551 14.693346838 16.279844626 17.740178785 18.6 18.4 19.5 22.730389292 26.66688 29.50779 29.62839
Boston, Massachusetts 04 Billion dollars 0.8 3 3.8 4.4 5.7 6.2 5.6 4.288789591 4.409849615 4.365183701 4.739595791 4.578318173 4.973237693 5.669850544 5.994638215 6.824816459 7 7 6.8 6.994692726 9.7411 9.93299 10.50097 5 8.2 9.2 12 12.6 12 12.2 11.771979933 12.001817394 11.696199934 12.607313157 13.364447489 13.708057172 14.726370214 14.65059695 16.014162608 18.7 16.8 15.4 16.405357554 19.18086 21.44439 22.61456
Buffalo, New York 09 Billion dollars 6.3 8.4 8.2 9.5 10.5 9.5 15.8 15.827075155 18.063193834 19.531808533 21.303318588 30.51394297 32.29825873 39.214075491 38.750988389 37.457659985 38.2 31.1 25.7 28.843177449 33.64711 34.72055 37.8163 7.4 14.7 15.5 15.4 18.1 19 19.2 18.718104697 21.21809706 24.221723313 27.04613372 29.053220458 29.30815949 30.376426831 35.403288815 39.724726305 38.4 34.7 34.3 35.926615224 40.8657 42.11408 44.31856
Charleston, South Carolina 2 16 Billion dollars 3.1 2.9 3 3.6 5 6.2 6.7 7.178204312 7.265147541 7.301823087 7.941368203 10.092959374 10.800713489 12.30361532 11.908610929 11.454707372 12.6 13.5 11.9 13.614124095 15.41914 16.12095 16.22834 1.8 3.3 4.9 5.9 6.1 6.5 6.8 6.252450028 6.640852899 7.480941181 8.592752582 10.416265855 11.557568962 12.265015954 14.049071591 14.541204062 16.9 17.2 17.5 20.978917113 25.99513 30.89317 32.35079
Chicago, Illinois 39 Billion dollars 4.2 5.4 6.1 6.9 8.7 10 10.2 11.33910278 11.888218165 13.149506291 15.243237839 18.40823236 18.711415231 19.601389773 19.178618012 19.127735477 21.7 21.5 19.6 21.287980524 25.92294 29.96286 32.21835 4.1 11.4 12.3 13.8 16.1 17.4 18.3 19.348208623 22.429121475 25.134560113 28.511988057 31.28729618 33.508103261 37.066440117 38.54023002 43.096659178 51.1 49.1 53 58.290377192 69.09207 78.54669 88.47115
Cleveland, Ohio 41 Billion dollars 1.8 2.1 2.7 3.4 3.4 3.9 4 4.031790928 4.127098696 4.33821508 5.292033595 7.816138132 10.241219216 14.042120841 15.146877412 17.472566217 22.7 18 16.5 17.247663987 19.04602 20.79719 21.38675 1.5 3.8 5.4 7.3 8.3 9.2 11.3 11.807872495 13.802780754 15.473551375 18.212438643 21.724702027 23.64346491 26.186293228 27.382544555 29.728365753 36.5 35.2 33.3 36.144445306 44.55276 51.20161 59.00097
49=. … snip …
beginning 2006, U.S. Merchandise Trade: Selected Highlights, December 2006, series FT920. See also
http://www.census.gov/foreign-trade/Press-Release/ft920_index.html

Symbols

Notes (pg 2)

  • (NA) Not available.
  • (Z) Less than $50 million.

Tablenum

1274

Year

2008

History

Uploaded by (admin) Modified by (admin)