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

Agricultural Imports-- Value by Selected Commodity: 1990 to 2006 (Statistical Abstract 2008 Table 0816)

Photo of a Chacma Baboon

Size: 6.4 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. Department of Agriculture, Economic Research Service, http://www.fas.usda.gov/ustrade

U.S. Department of Agriculture, Economic Research Service,

“Foreign Agricultural Trade of the United States (FATUS)”;

< http://www.ers.usda.gov/data/fatus/ > and

U.S. Department of Agriculture, Foreign Agricultural Service,

“U.S. Trade Internet System”;

< http://www.fas.usda.gov/us…
U.S. Department of Agriculture, Economic Research Service, http://www.ers.usda.gov/Briefing/AgTrade/

U.S. Department of Agriculture, Economic Research Service,

“Foreign Agricultural Trade of the United States (FATUS)”;

< http://www.ers.usda.gov/data/fatus/ > and

U.S. Department of Agriculture, Foreign Agricultural Service,

“U.S. Trade Internet System”;

< http://www.fas.usda.gov/us…

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 other commodities not shown separately.

Headnotes

[In millions of dollars (22,918 represents $22,918,000,000). Includes Puerto Rico, U.S. territories, and shipments under foreign aid programs. Excludes fish, forest products, distilled liquors, manufactured tobacco, and products made from cotton; but includes raw tobacco, raw cotton, rubber, beer and wine, and processed agricultural products]

Shape

table: [26, 22]

Snippet

Commodity 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 1990 2000 2005 2006
(million dollars) (million dollars) (million dollars) (million dollars) (million dollars) (million dollars) (million dollars) (million dollars) (million dollars) (million dollars) (million dollars) (million dollars) (million dollars) (million dollars) (million dollars) (million dollars) (million dollars) (percent) (percent) (percent) (percent)
Total 1 22918.180873 22875.391205 24793.298655 25131.41139 27023.861337 30255.386089 33511.738159 36148.698106 36895.634977 37672.825788 38974.477714 39365.977913 41909.187447 47376.089641 53976.863455 59317.052 65333.177 100 100 100 100
Cattle, live 978.297348 951.570242 1244.65294 1341.254099 1151.668702 1413.406974 1121.264379 1124.313146 1144.214914 1000.517611 1151.862445 1461.151609 1446.298006 866.525706 542.856188 1038.566736 1545.666 4.26865183332 2.95542753248 1.75087382293 2.36582096719
Beef and veal 1871.81879 1963.737916 1890.551728 1938.286735 1798.488109 1447.073451 1341.158129 1609.436698 1841.938215 2135.887075 2399.280374 2712.067156 2741.331344 2622.74248 3625.613031 3651.450405 3220.132 8.16739688186 6.15602957301 6.15581908049 4.92878526327
Pork 938.436072 795.336222 620.372773 693.752978 705.717439 686.181825 727.708133 754.19052 682.101274 752.722135 996.850975 1048.223114 1001.182608 1189.666262 1367.335595 1280.817301 1196.834 4.09472321211 2.55770194617 2.1592733587 1.83189315897
Dairy products 891.317547 785.807842 876.054033 891.525042 985.940362 1117.967009 1273.999288 1225.13875 1465.144641 1556.752481 1670.804918 1789.087404 1783.364862 1977.875201 2423.652872 2685.524139 2711.016 3.88912868757 4.28692061061 4.52740661994 4.14952421493
Grains and feeds 1187.733213 1317.396755 1582.194342 1770.257942 2301.858996 2311.976961 2656.54108 2962.745963 2877.597742 2988.760816 3075.790914 3320.002674 3666.407367 3910.236066 4291.686779 4526.508 5323.992 5.1824934081 7.89180790714 7.6310400591 8.1489868463
Fruits and preparations 2166.995127 2351.582853 2505.216692 2449.74974 2549.236675 2758.635793 3104.38127 3238.814542 3386.958787 3965.722908 3845.742836 3977.318475 4356.051 4721.891 5079.434 5842.102 6515.788 9.45535397861 9.86733642519 9.84894191977 9.97316876233
Vegetables and preparations 1979 1837 1769 2037 2276 2646 2947 3084 3668 3803 3958 4349 4659.346 5349.253 6076.608 6409.699 7008.182 8.63506580634 10.1553637974 10.8058286511 10.7268348515
Sugar and related products 1212.882664 1108.896401 1194.78265 1129.29167 1191.075193 1334.578874 1888.820573 1852.450688 1682.217116 1588.63525 1555.125716 1600.325339 1853.767466 2129.47475 2106.612854 2493.567 3045.201 5.29222921628 3.99011303605 4.20379455135 4.66103309196
22=. ... snip ...
“U.S. Trade Internet System”;
.

Tablenum

0816

Year

2008

History

Uploaded by (admin) Modified by (admin)