USER LIST SETS

All Import Commodities: Customs Value by Customs Value
For ALL Countries

U.S. Imports For Consumption

Annual Data

 

NAIC Number 1997
In 1,000 Dollars
334
COMPUTER AND ELECTRONIC PRODUCTS		 173,260,913
336
TRANSPORTATION EQUIPMENT		 149,260,345
333
MACHINERY, EXCEPT ELECTRICAL		 65,317,197
325
CHEMICALS		 51,602,943
211
OIL AND GAS		 50,030,240
315
APPAREL AND ACCESSORIES		 47,083,701
339
MISCELLANEOUS MANUFACTURED COMMODITIES		 42,906,066
331
PRIMARY METAL MANUFACTURING		 35,786,522
335
ELECTRICAL EQUIPMENT, APPLIANCES, AND COMPONENT		 26,984,506
980
GOODS RETURNED TO CANADA (EXPORTS ONLY); U.S. GOODS RETURNED AND REIMPORTED ITEMS (IMPORTS ONLY)		 21,982,709
324
PETROLEUM AND COAL PRODUCTS		 20,584,390
332
FABRICATED METAL PRODUCTS, NESOI		 20,530,468
316
LEATHER AND ALLIED PRODUCTS		 19,277,283
311
FOOD MANUFACTURING		 16,585,793
322
PAPER		 14,661,942
Subtotal : 755,855,016
All Other: 106,571,329
Total 862,426,346

~~~~~~~~~~




Sources: Data on this site have been compiled from tariff and trade data from the U.S. Department of Commerce, the U.S. Treasury, and the U.S. International Trade Commission.

-

Display percent distribution of values within year

HOW TO PRINT WIDE REPORTS
Choice 1) Print in "landscape". In the
Netscape browser, this is done by going to
"file", "print", "properties", and clicking on
"landscape".

Choice 2) Select a smaller font for your report.
Choices are on the page just before the report.

HOW TO SAVE YOUR REPORT TO A SPREADSHEET
There are two methods:
Method 1:
To generate a text tab delimitated file to import into Lotus, Excel or Other Desktop tools press the "Download File" button. This will generate the file and allow you to download the file to your PC. (Caution all values and quantities will be in single units)
Select a Delimiter:



Method 2:
(Works best with the more current versions
of the spreadsheet programs.)
(Values will be as seen on screen)

1.) Save the file as a text file (Note--the saved file MUST have .txt at the end of the filename, such as fruit.txt)

2.) Go to Lotus 97 or Excel 4.0

3.)"Open" the saved .txt file.

4.) For Lotus:
Under "parsing options", select "Automatically parse based on file layout", hit "OK"

For Excel:
Under "Original data type", select "fixed width", Hit "next. Move break lines so they are just to the right of each column of data, hit "enter" then finish".

5.) Sort results to remove blank rows if desired.


User Name JAFFEE2
List Name All Import Commodities
Country List ALL Countries
Display Data Field CONS_CUSTOMS_VALUE
Aggregation Level HTS3
Display Description YES
Time-Line Annual
Current Month 12
Current Year 2002
Current QTR 04
Scale In 1000