Section 6: Foreign Trade Products Available on CD-ROM


  The entire monthly Foreign Trade data base is available on a
commodity-by-country-by-customs district basis on compact disc for use
with microcomputer (CD-ROM Compact Disc - Read Only Memory). Each
monthly disc contains current month data as well as year-to-date
information on each commodity.

  Foreign Trade Division has also made available on a CD-ROM disc U.S.
Exports Commodity Classification Schedule B. This new reference CD-ROM
will help data users find the Schedule B commodity classification and
exact description of data products. The disc has user-friendly software
which allows you quickly access the commodity number from commonly used
names or key words in the description of your product.

  All CD-ROM products are available from Customer Services Division,
Bureau of the Census, Washington, DC 20233.

Abstract

U.S. Exports of Merchandise on CD-ROM

[Machine-readable data file] / prepared by the Bureau of the Census. -Washington: The Bureau [producer and distributor], 1990.

Type of File:

Summary Statistics.

Universe Descriptions:

The universe is reported U.S. export statistics, both government and nongovernment shipments, of domestic and foreign merchandise (including non-monetary gold and silver) from the U.S. Customs districts (the 50 states, District of Columbia and Puerto Rico), U.S. Foreign Trade Zones, and the U.S. Virgin Islands to foreign countries.

Subject-Matter Description:

The file provides U.S. exports of domestic and foreign merchandise by Harmonized Schedule B Commodity Code. It contains quantity, value, and shipping weight by country of destination, customs district of exportation, and method of transportation.

Smaller files provide totals for commodity, country of destination, and U.S. Customs districts of exportation.

These data are provided for current month and year-to-date.

Geographic Coverage:

Data are provided for customs districts of exportation.

Technical Description:

File Structure: dBASE III format. There are 9 database files and 10 index files. The database and index files provide information about detailed exports as well as information about commodites, countries, districts of exportation, and the Harmonized Commodity Description and coding system (HS). Further details on these files are provided in Chapter IV of the technical documentation, file on CD-ROM.

Reference Materials:

U.S. Merchandise Trade (FT 900 and Supplement). This report presents U.S. export data on a free-alongside-ship (f.a.s.) valuse basis and provides general import data both on a customs value and cost, insurance, freight (c.i.f.) value basis. Total exports, imports, and merchandise trade balances are shown for each month of the current and preceding calendar years. This monthly report is available for the Forign Trade Division, Bureau of the Census, Washington, DC 20233. The cost is $10 per month or $120 for an annual subscription. Portions of the report are available on CENDATA(TM), the Census Bureau's online information service, and on the internet.

U.S. Merchandise Trade: Exports, General imports, and Imports for consumption SITC Commodity by Country (FT 925). This publication presents both customs and c.i.f. value information for general imports and imports for cunsumption in terms of Standard International Trade Classification (SITC) commodites. The publication also shows f.a.s. value for SITC commodity exports. It includes both current month and year-to-date information. SITC commodity by country information is shown for those cuntries where the average monthly value of eash SITC commodity for either exports or imports based on the year-to-date value is $50,000 or more.

Releated Public Domain Software:

The Census Bureau has placed various software that can be used with CD-ROM's i the public domain. This sortware is available to users from the following two sources:

File Availability:

The CD-ROM may be ordered from Customer Services using the order form in Appendix A. The subscription rate for monthly releases from January to December is $1200 per year. The introductory subscription for September - December 1989 data files is $400. Individual CD-Rom's cost $150.


FILES ON CD-ROM

U.S. Exports of Merchandise on CD-ROM

These fles are in dBASE III format. There are 9 database files and 10 index files. The index files pertain to the database files as they are shown below. To access each index, use the key listed with the index.

    EXP_DETL.DBF        Detail Database
    EXP_DETL.CDY        Index File - Key: DOM_OR_FOR + COMMODITY(1)
    EXP_DETL.CTY        Index File - Key: CTY_CODE
    EXP_DETL.DST        Index File - Key: DIST_CODE

    EXP_COMM.DBF        Commodity Summary Database
    EXP_COMM.NDX        Index File - Key: DOM_OR_FOR + COMMODITY

    EXP_CTY.DBF         Country Summary Database
    EXP_CTY.NDX         Index File - Key: CTY_CODE

    EXP_DIST.DBF        District of Export Summary Database
    EXP_DIST.NDX        Index File - Key: DIST_CODE

    CONCORD.DBF         Harmonized Commodity Masters - Exports Concordance Database
    CONCORD.NDX         Index File - Key: COMMODITY

    HSDESC.DBF          Harmonized Commodity Masters - Commodity Descriptions
    HSDESC2.NDX         Index File - Key: LEFT(COMMODITY,2)
    HSDESC4.NDX         Index File - Key: LEFT(COMMODITY,4)
    HSDESC6.NDX         Index File - Key: COMMODITY

    SITCDESC.DBF        Harmonized Commodity Masters - SITC Descriptions

    COUNTRY.DBF         Country Name Database

    DISTRICT.DBF        Customs District Name Database

(1) Unique index file. This points to the first occurance of each key value.

Export Detail Database

EXP_DETL.DBF

Field   Field      Field  Field           Field
Number  Name       Type   Size   Decimal  Description   

1       DOM_OR_FOR  C      1      0       Domestic/Foreign Exports
                                           Domestic = 1,Foreign = 2
2       COMMODITY   C     10      0       Export Harmonized Code
3       COMM_DESC   C     50      0       Commodity Description
4       CTY_CODE    C      4      0       Country Code
5       CTY_DESC    C      7      0       Country Description
6       DIST_CODE   C      2      0       District of Exportation
7       DIST_DESC   C      7      0       District Name
8       STAT_MONTH  C      2      0       Statistical Month
9       CARDS_MO    N      8      0       Number of Detailed Records, Current Month
10      CARDS_YR    N      8      0       Number of Detailed Records, Year to Date
11      UNIT_QY1    C      3      0       First Unit of Quantity(e.g. number)
12      ALL_QY1_MO  N     12      0       Amount of First Unit of Quantity, Current Month
13      ALL_QY1_YR  N     12      0       Amount of First Unit of Quantity, Year to Date
14      UNIT_QY2    C      3      0       Second Unit of Quantity(if required)
15      ALL_QY2_MO  N     12      0       Amount of 2nd Unit of Quantity, Current Month
16      ALL_QY2_YR  N     12      0       Amount of 2nd Unit of Quantity, Year to Date
17      ALL_VAL_MO  N     12      0       F.A.S. Value, Current Month
18      ALL_VAL_YR  N     12      0       F.A.S. Value, Year to Date      
19      VES_WGT_MO  N     12      0       Shippments by Vessel, Shipping Weight, Current Month
20      VES_WGT_YR  N     12      0       Shippments by Vessel, Shipping Weight, Year to Date
21      VES_VAL_MO  N     12      0       Shippments by Vessel, F.A.S. Value, Current Month
22      VES_VAL_YR  N     12      0       Shippments by Vessel, F.A.S. Value, Year to Date
23      AIR_WGT_MO  N     12      0       Shippments by Air, Shipping Weight, Current Month
24      AIR_WGT_YR  N     12      0       Shippments by Air, Shipping Weight, Year to Date
25      AIR_VAL_MO  N     12      0       Shippments by Air, F.A.S. Value, Current Month
26      AIR_VAL_YR  N     12      0       Shippments by Air, F.A.S. Value, Year to Date

          Total Size:    274

Commodity Summary Database

EXP_COMM.DBF

Field   Field      Field  Field           Field
Number  Name       Type   Size   Decimal  Description   


1       DOM_OR_FOR  C      1      0       Domestic/Foreign Exports
                                           Domestic = 1,Foreign = 2
2       COMMODITY   C     10      0       Export Harmonized Code
3       COMM_DESC   C     50      0       Commodity Description
4       STAT_MONTH  C      2      0       Statistical Month
5       CARDS_MO    N      8      0       Number of Detailed Records, Current Month
6       CARDS_YR    N      8      0       Number of Detailed Records, Year to Date
7       UNIT_QY1    C      3      0       First Unit of Quantity(e.g. number)
8       ALL_QY1_MO  N     12      0       Amount of First Unit of Quantity, Current Month
9       ALL_QY1_YR  N     12      0       Amount of First Unit of Quantity, Year to Date
10      UNIT_QY1    C      3      0       Second Unit of Quantity(if required)
11      ALL_QY2_MO  N     12      0       Amount of 2nd Unit of Quantity, Current Month
12      ALL_QY2_YR  N     12      0       Amount of 2nd Unit of Quantity, Year to Date
13      ALL_VAL_MO  N     12      0       F.A.S. Value, Current Month
14      ALL_VAL_YR  N     12      0       F.A.S. Value, Year to Date      
15      VES_WGT_MO  N     12      0       Shippments by Vessel, Shipping Weight, Current Month
16      VES_WGT_YR  N     12      0       Shippments by Vessel, Shipping Weight, Year to Date
17      VES_VAL_MO  N     12      0       Shippments by Vessel, F.A.S. Value, Current Month
18      VES_VAL_YR  N     12      0       Shippments by Vessel, F.A.S. Value, Year to Date
19      AIR_WGT_MO  N     12      0       Shippments by Air, Shipping Weight, Current Month
20      AIR_WGT_YR  N     12      0       Shippments by Air, Shipping Weight, Year to Date
21      AIR_VAL_MO  N     12      0       Shippments by Air, F.A.S. Value, Current Month
22      AIR_VAL_YR  N     12      0       Shippments by Air, F.A.S. Value, Year to Date

          Total Size:    254

Country Summary Database

EXP_CTY.DBF

Field   Field      Field  Field           Field
Number  Name       Type   Size   Decimal  Description   


 1      CTY_CODE    C      4      0       Country Code
 2      CTY_DESC    C      7      0       Country Description
 3      STAT_MONTH  C      2      0       Statistical Month
 4      CARDS_MO    N      8      0       Number of Detailed Records, Current Month
 5      CARDS_YR    N      8      0       Number of Detailed Records, Year to Date
 6      ALL_VAL_MO  N     12      0       F.A.S. Value, Current Month
 7      ALL_VAL_YR  N     12      0       F.A.S. Value, Year to Date      
 8      VES_WGT_MO  N     12      0       Shippments by Vessel, Shipping Weight, Current Month
 9      VES_WGT_YR  N     12      0       Shippments by Vessel, Shipping Weight, Year to Date
10      VES_VAL_MO  N     12      0       Shippments by Vessel, F.A.S. Value, Current Month
11      VES_VAL_YR  N     12      0       Shippments by Vessel, F.A.S. Value, Year to Date
12      AIR_WGT_MO  N     12      0       Shippments by Air, Shipping Weight, Current Month
13      AIR_WGT_YR  N     12      0       Shippments by Air, Shipping Weight, Year to Date
14      AIR_VAL_MO  N     12      0       Shippments by Air, F.A.S. Value, Current Month
15      AIR_VAL_YR  N     12      0       Shippments by Air, F.A.S. Value, Year to Date

          Total Size:    150

District of Export Summary Database

EXP_DIST.DBF

Field   Field      Field  Field           Field
Number  Name       Type   Size   Decimal  Description   


 1      DIST_CODE   C      2      0       District of Exportation
 2      DIST_DESC   C      7      0       District Name
 3      STAT_MONTH  C      2      0       Statistical Month
 4      CARDS_MO    N      8      0       Number of Detailed Records, Current Month
 5      CARDS_YR    N      8      0       Number of Detailed Records, Year to Date
 6      ALL_VAL_MO  N     12      0       F.A.S. Value, Current Month
 7      ALL_VAL_YR  N     12      0       F.A.S. Value, Year to Date      
 8      VES_WGT_MO  N     12      0       Shippments by Vessel, Shipping Weight, Current Month
 9      VES_WGT_YR  N     12      0       Shippments by Vessel, Shipping Weight, Year to Date
10      VES_VAL_MO  N     12      0       Shippments by Vessel, F.A.S. Value, Current Month
11      VES_VAL_YR  N     12      0       Shippments by Vessel, F.A.S. Value, Year to Date
12      AIR_WGT_MO  N     12      0       Shippments by Air, Shipping Weight, Current Month
13      AIR_WGT_YR  N     12      0       Shippments by Air, Shipping Weight, Year to Date
14      AIR_VAL_MO  N     12      0       Shippments by Air, F.A.S. Value, Current Month
15      AIR_VAL_YR  N     12      0       Shippments by Air, F.A.S. Value, Year to Date

          Total Size:    148

Harmonized Commodity Masters - Exports Concordance Database

CONCORD.DBF

Field   Field      Field  Field           Field
Number  Name       Type   Size   Decimal  Description   


 1      ID_CODE     C      1      0       Identification Code = 1
 2      COMMODITY   C     10      0       Export Harmonized Commodity Code
 3      FILL1       C      2      0       Filler
 4      DESCRIP_1   C    150      0       Description of 10-digit Commodity
 5      FILL2       C      1      0       Filler
 6      DESCRIP_2   C     50      0       Abreviated Version of Description
 7      FILL3       C      1      0       Filler
 8      QUANTITY_1  C      3      0       Alphabetic Abbreviation of the first 
                                          reporting unit of quantity as required
                                          by HTSUSA
 9      FILL4       C      1      0       Filler
10      QUANTITY_2  C      3      0       Second Unit of Quantity if Required 
                                          by HTSUSA
11      FILL5       C      1      0       Filler
12      SITC        C      5      0       Standard International Trade Classification
                                          Revision 3 Code
13      FIlL6       C      1      0       Filler
14      END_USE     C      5      0       End Use Classification Code
15      FILL7       C      1      0       Filler
16      SIC         C      4      0       Standard Industry Classification Code
17      FILL8       C      7      0       Filler
18      USDA        C      1      0       Agriculture or Non-Agriculture Product Code
19      FILL9       C      1      0       Filler
         
         Total Size:     249     

Harmonized Commodity Masters
Commodity Descriptions Database

HSDESC.DBF

Field   Field      Field  Field           Field
Number  Name       Type   Size   Decimal  Description   


 1      ID_CODE     C      1      0       Identification Code = 6
 2      COMMODITY   C      6      0       Export Harmonized Code - 2, 4, or 6 Digit Level
 3      FILL1       C      6      0       Filler
 4      DESCRIPTN   C    150      0       Description of Harmonized Code
 5      FILL2       C      1      0       Filler
 6      ABBREVIATN  C     50      0       Abreviated Version of Description

         Total Size:     215     

Harmonized Commodity Masters
Standard International Trade Classification Descriptions Database

SITCDESC.DBF

Field   Field      Field  Field           Field
Number  Name       Type   Size   Decimal  Description   


 1      ID_CODE     C      1      0       Identification Code = 5
 2      SITC_CODE   C      5      0       SITC REV3 Code - 1, 2, 3, 4, or 5 Digit Level
 3      FILL1       C      7      0       Filler
 4      DESCRIPTN   C    150      0       Description of SITC REV3 product
 5      FILL2       C      1      0       Filler
 6      ABBREVIATN  C     50      0       Abreviated Description 

         Total Size:     215     

Country Name Database

COUNTRY.DBF

Field   Field      Field  Field           Field
Number  Name       Type   Size   Decimal  Description   


 1      CTY_CODE    C      4      0       Country Code
 2      CTY_DESC    C      7      0       Country Abbreviation
 3      CTY_NAME    C     30      0       Country Name

         Total Size:      42

Customs District Name Database

DISTRICT.DBF

Field   Field      Field  Field           Field
Number  Name       Type   Size   Decimal  Description   


 1      CTY_CODE    C      2      0       District Code
 2      CTY_DESC    C      7      0       District Abbreviation
 3      CTY_NAME    C     30      0       District Name

         Total Size:      40

Abstract

U.S. Imports of Merchandise on CD-ROM

[Machine-readable data file] / prepared by the Bureau of the Census. -Washington: The Bureau [producer and distributor], 1990.

Type of File:

Summary Statistics.

Universe Descriptions:

The Universe is reported U.S. import statistics, incuding both government and nongovernment shipments of merchandise into the U.S. Customs Territory (the 50 states, District of Columbia and Puerto Rico), U.S. Foreign Trade Zones, and the U.S. Virgin Islands from foreign countries.

Subject-Matter Description:

The file provides net quantity, value data (all methods of transportation combined), value and shipping weight data for vessel and air shipments in terms of commodity by country of origin, by customs district of entry, by customs district of unlading, and by rate provision.

Smaller files provide totals for each commodity, totals for each country of origin, and totals for each customs district of entry and customs district of unlading.

These data are provided for current month and year-to-date.

Geographic Coverage:

Data are provided for countries of origin and customs distiricts of import for current month and year-to-date.

Technical Description:

File Structure: dBASE III format. There are 10 database files and 11 index files. The database and index files provide information about commodities, countries, districts of entry, districts of unlading, and the Harmonized Commodity Description and Coding System (HS). Further details on these files are provided in Charpter IV of the technical documentation, Files on CD-ROM.

Reference Materials:

U.S. Exports and Imports of Merchandise on CD-ROM Technical Documentation. One copy accompanies each order. Additional copies are avalable for $5 from Customer Services, Bureau of the Census, Washington, DC 20233.

Related Printed Reports:

U.S. Merchandise Trade (FT 900 and Supplement). This report presents U.S. export data on a free-alongside-ship (f.a.s.) valuse basis and provides general import data both on a customs value and cost, insurance, freight (c.i.f.) value basis. Total exports, imports, and merchandise trade balances are shown for each month of the current and preceding calendar years. This monthly report is available for the Forign Trade Division, Bureau of the Census, Washington, DC 20233. The cost is $10 per month or $120 for an annual subscription. Portions of the report are available on CENDATA(TM), the Census Bureau's online information service, and on the internet.

U.S. Merchandise Trade: Exports, General imports, and Imports for consumption SITC Commodity by Country (FT 925). This publication presents both customs and c.i.f. value information for general imports and imports for cunsumption in terms of Standard International Trade Classification (SITC) commodites. The publication also shows f.a.s. value for SITC commodity exports. It includes both current month and year-to-date information. SITC commodity by country information is shown for those cuntries where the average monthly value of eash SITC commodity for either exports or imports based on the year-to-date value is $50,000 or more.


FILES ON CD-ROM

U.S. Imports of Merchandise on CD-ROM

These fles are in dBASE III format. There are 10 database files and 11 index files. The index files pertain to the database files as they are shown below. To access each index, use the key listed with the index.

    IMP_DETL.DBF        Detail Database
    IMP_DETL.CDY        Index File - Key: COMMODITY(1)
    IMP_DETL.CTY        Index File - Key: CTY_CODE
    IMP_DETL.DST        Index File - Key: DIST_CODE

    IMP_COMM.DBF        Commodity Summary Database
    IMP_COMM.NDX        Index File - Key: COMMODITY

    IMP_CTY.DBF         Country Summary Database
    IMP_CTY.NDX         Index File - Key: CTY_CODE

    IMP_DE.DBF          District of Entry Summary Database
    IMP_DE.NDX          Index File - Key: DIST_ENTRY

    IMP_DU.DBF          District of Unlading Summary Database
    IMP_DU.NDX          Index File - Key: DIST_UNLAD

    CONCORD.DBF         Harmonized Commodity Masters - Imports Concordance Database
    CONCORD.NDX         Index File - Key: COMMODITY

    HSDESC.DBF          Harmonized Commodity Masters - Commodity Descriptions
    HSDESC2.NDX         Index File - Key: LEFT(COMMODITY,2)
    HSDESC4.NDX         Index File - Key: LEFT(COMMODITY,4)
    HSDESC6.NDX         Index File - Key: COMMODITY

    SITCDESC.DBF        Harmonized Commodity Masters - SITC Descriptions

    COUNTRY.DBF         Country Name Database

    DISTRICT.DBF        Customs District Name Database

(1) Unique index file. This points to the first occurance of each key value.

Import Detail Database

IMP_DETL.DBF

Field   Field      Field  Field           Field
Number  Name       Type   Size   Decimal  Description   

 1      COMMODITY   C     10      0       Export Harmonized Code
 2      COMM_DESC   C     50      0       Commodity Description
 3      UNIT_QY1    C      3      0       First Unit of Quantity(e.g. number)
 4      UNIT_QY2    C      3      0       Second Unit of Quantity(if required)
 5      CTY_CODE    C      4      0       Country Code
 6      CTY_DESC    C      7      0       Country Description
 7      CTY_SUBCO   C      1      0       Country Subcode
 8      DIST_ENTRY  C      2      0       District of Entry
 9      D_E_DESC    C      7      0       District of Entry Name
10      DIST_UNLAD  C      2      0       District of Unlading
11      D_U_DESC    C      7      0       District of Unlading Name
12      RATE_PROV   C      2      0       Rate Provision Code
13      STAT_MONTH  C      2      0       Statistical Month
14      CARDS_MO    N      8      0       Number of Detailed Records, Current Month
15      CARDS_YR    N      8      0       Number of Detailed Records, Year to Date
16      CON_QY1_MO  N     12      0       Imports for Consumption, 1st Unit of Quantity, Current Month
17      CON_QY1_YR  N     12      0       Imports for Consumption, 1st Unit of Quantity, Year to Date
18      CON_QY2_MO  N     12      0       Imports for Consumption, 2nd Unit of Quantity, Current Month
19      CON_QY2_YR  N     12      0       Imports for Consumption, 2nd Unit of Quantity, Year to Date
20      CON_VAL_MO  N     12      0       Imports for Consumption, Customs Value, Current Month
21      CON_VAL_YR  N     12      0       Imports for Consumption, Customs Value, Year to Date      
22      DUT_VAL_MO  N     12      0       Dutiable Value, Current Month
23      DUT_VAL_YR  N     12      0       Dutiable Value, Year to Date      
24      CAL_DUT_MO  N     12      0       Calculated Duty, Current Month
25      CAL_DUT_YR  N     12      0       Claculated Duty, Year to Date      
26      CON_CHA_MO  N     12      0       Imports for Consumption, Import Charges, Current Month
27      CON_CHA_YR  N     12      0       Imports for Consumption, Import Charges, Year to Date      
28      CON_CIF_MO  N     12      0       Imports for Consumption, CIF Import Value, Current Month
29      CON_CIF_YR  N     12      0       Imports for Consumption, CIF Import Value, Year to Date      
30      GEN_QY1_MO  N     12      0       General Imports, 1st Unit of Quantity, Current Month
31      GEN_QY1_YR  N     12      0       General Imports, 1st Unit of Quantity, Year to Date
32      GEN_QY2_MO  N     12      0       General Imports, 2nd Unit of Quantity, Current Month
33      GEN_QY2_YR  N     12      0       General Imports, 2nd Unit of Quantity, Year to Date
34      GEN_VAL_MO  N     12      0       General Imports, Customs Value, Current Month
35      GEN_VAL_YR  N     12      0       General Imports, Customs Value, Year to Date      
36      GEN_CHA_MO  N     12      0       General Imports, Import Charges, Current Month
37      GEN_CHA_YR  N     12      0       General Imports, Import Charges, Year to Date      
38      GEN_CIF_MO  N     12      0       General Imports, CIF Import Value, Current Month
39      GEN_CIF_YR  N     12      0       General Imports, CIF Import Value, Year to Date      
40      VES_VAL_MO  N     12      0       Shippments by Vessel, Customs Value, Current Month
41      VES_VAL_YR  N     12      0       Shippments by Vessel, Customs Value, Year to Date
42      VES_WGT_MO  N     12      0       Shippments by Vessel, Shipping Weight, Current Month
43      VES_WGT_YR  N     12      0       Shippments by Vessel, Shipping Weight, Year to Date
44      VES_CHA_MO  N     12      0       Shippments by Vessel, Import Charges, Current Month
45      VES_CHA_YR  N     12      0       Shippments by Vessel, Import Charges, Year to Date
46      AIR_VAL_MO  N     12      0       Shippments by Air, Customs Value, Current Month
47      AIR_VAL_YR  N     12      0       Shippments by Air, Customs Value, Year to Date
48      AIR_WGT_MO  N     12      0       Shippments by Air, Shipping Weight, Current Month
49      AIR_WGT_YR  N     12      0       Shippments by Air, Shipping Weight, Year to Date
50      AIR_CHA_MO  N     12      0       Shippments by Air, Import Charges, Current Month
51      AIR_CHA_YR  N     12      0       Shippments by Air, Import Charges, Year to Date

          Total Size:    549

Commodity Summary Database

IMP_COMM.DBF

Field   Field      Field  Field           Field
Number  Name       Type   Size   Decimal  Description   

 1      COMMODITY   C     10      0       Export Harmonized Code
 2      COMM_DESC   C     50      0       Commodity Description
 3      UNIT_QY1    C      3      0       First Unit of Quantity(e.g. number)
 4      UNIT_QY2    C      3      0       Second Unit of Quantity(if required)
 5      STAT_MONTH  C      2      0       Statistical Month
 6      CARDS_MO    N      8      0       Number of Detailed Records, Current Month
 7      CARDS_YR    N      8      0       Number of Detailed Records, Year to Date
 8      CON_QY1_MO  N     12      0       Imports for Consumption, 1st Unit of Quantity, Current Month
 9      CON_QY1_YR  N     12      0       Imports for Consumption, 1st Unit of Quantity, Year to Date
10      CON_QY2_MO  N     12      0       Imports for Consumption, 2nd Unit of Quantity, Current Month
11      CON_QY2_YR  N     12      0       Imports for Consumption, 2nd Unit of Quantity, Year to Date
12      CON_VAL_MO  N     12      0       Imports for Consumption, Customs Value, Current Month
13      CON_VAL_YR  N     12      0       Imports for Consumption, Customs Value, Year to Date      
14      DUT_VAL_MO  N     12      0       Dutiable Value, Current Month
15      DUT_VAL_YR  N     12      0       Dutiable Value, Year to Date      
16      CAL_DUT_MO  N     12      0       Calculated Duty, Current Month
17      CAL_DUT_YR  N     12      0       Claculated Duty, Year to Date      
18      CON_CHA_MO  N     12      0       Imports for Consumption, Import Charges, Current Month
19      CON_CHA_YR  N     12      0       Imports for Consumption, Import Charges, Year to Date      
20      CON_CIF_MO  N     12      0       Imports for Consumption, CIF Import Value, Current Month
21      CON_CIF_YR  N     12      0       Imports for Consumption, CIF Import Value, Year to Date      
22      GEN_QY1_MO  N     12      0       General Imports, 1st Unit of Quantity, Current Month
23      GEN_QY1_YR  N     12      0       General Imports, 1st Unit of Quantity, Year to Date
24      GEN_QY2_MO  N     12      0       General Imports, 2nd Unit of Quantity, Current Month
25      GEN_QY2_YR  N     12      0       General Imports, 2nd Unit of Quantity, Year to Date
26      GEN_VAL_MO  N     12      0       General Imports, Customs Value, Current Month
27      GEN_VAL_YR  N     12      0       General Imports, Customs Value, Year to Date      
28      GEN_CHA_MO  N     12      0       General Imports, Import Charges, Current Month
29      GEN_CHA_YR  N     12      0       General Imports, Import Charges, Year to Date      
30      GEN_CIF_MO  N     12      0       General Imports, CIF Import Value, Current Month
31      GEN_CIF_YR  N     12      0       General Imports, CIF Import Value, Year to Date      
32      VES_VAL_MO  N     12      0       Shippments by Vessel, Customs Value, Current Month
33      VES_VAL_YR  N     12      0       Shippments by Vessel, Customs Value, Year to Date
34      VES_WGT_MO  N     12      0       Shippments by Vessel, Shipping Weight, Current Month
35      VES_WGT_YR  N     12      0       Shippments by Vessel, Shipping Weight, Year to Date
36      VES_CHA_MO  N     12      0       Shippments by Vessel, Import Charges, Current Month
37      VES_CHA_YR  N     12      0       Shippments by Vessel, Import Charges, Year to Date
38      AIR_VAL_MO  N     12      0       Shippments by Air, Customs Value, Current Month
39      AIR_VAL_YR  N     12      0       Shippments by Air, Customs Value, Year to Date
40      AIR_WGT_MO  N     12      0       Shippments by Air, Shipping Weight, Current Month
41      AIR_WGT_YR  N     12      0       Shippments by Air, Shipping Weight, Year to Date
42      AIR_CHA_MO  N     12      0       Shippments by Air, Import Charges, Current Month
43      AIR_CHA_YR  N     12      0       Shippments by Air, Import Charges, Year to Date

          Total Size:    517

Country Summary Database

IMP_CTY.DBF

Field   Field      Field  Field           Field
Number  Name       Type   Size   Decimal  Description   

 1      CTY_CODE    C      4      0       Country Code
 2      CTY_DESC    C      7      0       Country Description
 3      STAT_MONTH  C      2      0       Statistical Month
 4      FILLER      C      3      0       Filler
 5      CARDS_MO    N      8      0       Number of Detailed Records, Current Month
 6      CARDS_YR    N      8      0       Number of Detailed Records, Year to Date
 7      CON_VAL_MO  N     12      0       Imports for Consumption, Customs Value, Current Month
 8      CON_VAL_YR  N     12      0       Imports for Consumption, Customs Value, Year to Date      
 9      DUT_VAL_MO  N     12      0       Dutiable Value, Current Month
10      DUT_VAL_YR  N     12      0       Dutiable Value, Year to Date      
11      CAL_DUT_MO  N     12      0       Calculated Duty, Current Month
12      CAL_DUT_YR  N     12      0       Claculated Duty, Year to Date      
13      CON_CHA_MO  N     12      0       Imports for Consumption, Import Charges, Current Month
14      CON_CHA_YR  N     12      0       Imports for Consumption, Import Charges, Year to Date      
15      CON_CIF_MO  N     12      0       Imports for Consumption, CIF Import Value, Current Month
16      CON_CIF_YR  N     12      0       Imports for Consumption, CIF Import Value, Year to Date      
17      GEN_VAL_MO  N     12      0       General Imports, Customs Value, Current Month
18      GEN_VAL_YR  N     12      0       General Imports, Customs Value, Year to Date      
19      GEN_CHA_MO  N     12      0       General Imports, Import Charges, Current Month
20      GEN_CHA_YR  N     12      0       General Imports, Import Charges, Year to Date      
21      GEN_CIF_MO  N     12      0       General Imports, CIF Import Value, Current Month
22      GEN_CIF_YR  N     12      0       General Imports, CIF Import Value, Year to Date      
23      VES_VAL_MO  N     12      0       Shippments by Vessel, Customs Value, Current Month
24      VES_VAL_YR  N     12      0       Shippments by Vessel, Customs Value, Year to Date
25      VES_WGT_MO  N     12      0       Shippments by Vessel, Shipping Weight, Current Month
26      VES_WGT_YR  N     12      0       Shippments by Vessel, Shipping Weight, Year to Date
27      VES_CHA_MO  N     12      0       Shippments by Vessel, Import Charges, Current Month
28      VES_CHA_YR  N     12      0       Shippments by Vessel, Import Charges, Year to Date
29      AIR_VAL_MO  N     12      0       Shippments by Air, Customs Value, Current Month
30      AIR_VAL_YR  N     12      0       Shippments by Air, Customs Value, Year to Date
31      AIR_WGT_MO  N     12      0       Shippments by Air, Shipping Weight, Current Month
32      AIR_WGT_YR  N     12      0       Shippments by Air, Shipping Weight, Year to Date
33      AIR_CHA_MO  N     12      0       Shippments by Air, Import Charges, Current Month
34      AIR_CHA_YR  N     12      0       Shippments by Air, Import Charges, Year to Date

          Total Size:    369

District of Entry Summary Database

IMP_DE.DBF

Field   Field      Field  Field           Field
Number  Name       Type   Size   Decimal  Description   

 1      DIST_ENTRY  C      2      0       District of Entry
 2      D_E_DESC    C      7      0       District of Entry Name
 3      STAT_MONTH  C      2      0       Statistical Month
 4      FILLER      N      1      0       Filler
 5      CARDS_MO    N      8      0       Number of Detailed Records, Current Month
 6      CARDS_YR    N      8      0       Number of Detailed Records, Year to Date
 7      CON_VAL_MO  N     12      0       Imports for Consumption, Customs Value, Current Month
 8      CON_VAL_YR  N     12      0       Imports for Consumption, Customs Value, Year to Date      
 9      DUT_VAL_MO  N     12      0       Dutiable Value, Current Month
10      DUT_VAL_YR  N     12      0       Dutiable Value, Year to Date      
11      CAL_DUT_MO  N     12      0       Calculated Duty, Current Month
12      CAL_DUT_YR  N     12      0       Claculated Duty, Year to Date      
13      CON_CHA_MO  N     12      0       Imports for Consumption, Import Charges, Current Month
14      CON_CHA_YR  N     12      0       Imports for Consumption, Import Charges, Year to Date      
15      CON_CIF_MO  N     12      0       Imports for Consumption, CIF Import Value, Current Month
16      CON_CIF_YR  N     12      0       Imports for Consumption, CIF Import Value, Year to Date      
17      GEN_VAL_MO  N     12      0       General Imports, Customs Value, Current Month
18      GEN_VAL_YR  N     12      0       General Imports, Customs Value, Year to Date      
19      GEN_CHA_MO  N     12      0       General Imports, Import Charges, Current Month
20      GEN_CHA_YR  N     12      0       General Imports, Import Charges, Year to Date      
21      GEN_CIF_MO  N     12      0       General Imports, CIF Import Value, Current Month
22      GEN_CIF_YR  N     12      0       General Imports, CIF Import Value, Year to Date      
23      VES_VAL_MO  N     12      0       Shippments by Vessel, Customs Value, Current Month
24      VES_VAL_YR  N     12      0       Shippments by Vessel, Customs Value, Year to Date
25      VES_WGT_MO  N     12      0       Shippments by Vessel, Shipping Weight, Current Month
26      VES_WGT_YR  N     12      0       Shippments by Vessel, Shipping Weight, Year to Date
27      VES_CHA_MO  N     12      0       Shippments by Vessel, Import Charges, Current Month
28      VES_CHA_YR  N     12      0       Shippments by Vessel, Import Charges, Year to Date
29      AIR_VAL_MO  N     12      0       Shippments by Air, Customs Value, Current Month
30      AIR_VAL_YR  N     12      0       Shippments by Air, Customs Value, Year to Date
31      AIR_WGT_MO  N     12      0       Shippments by Air, Shipping Weight, Current Month
32      AIR_WGT_YR  N     12      0       Shippments by Air, Shipping Weight, Year to Date
33      AIR_CHA_MO  N     12      0       Shippments by Air, Import Charges, Current Month
34      AIR_CHA_YR  N     12      0       Shippments by Air, Import Charges, Year to Date

          Total Size:    365

District of Unlading Summary Database

IMP_DU.DBF

Field   Field      Field  Field           Field
Number  Name       Type   Size   Decimal  Description   

 1      DIST_UNLAD  C      2      0       District of Unlading
 2      D_U_DESC    C      7      0       District of Unlading Name
 3      STAT_MONTH  C      2      0       Statistical Month
 4      FILLER      N      1      0       Filler
 5      CARDS_MO    N      8      0       Number of Detailed Records, Current Month
 6      CARDS_YR    N      8      0       Number of Detailed Records, Year to Date
 7      CON_VAL_MO  N     12      0       Imports for Consumption, Customs Value, Current Month
 8      CON_VAL_YR  N     12      0       Imports for Consumption, Customs Value, Year to Date      
 9      DUT_VAL_MO  N     12      0       Dutiable Value, Current Month
10      DUT_VAL_YR  N     12      0       Dutiable Value, Year to Date      
11      CAL_DUT_MO  N     12      0       Calculated Duty, Current Month
12      CAL_DUT_YR  N     12      0       Claculated Duty, Year to Date      
13      CON_CHA_MO  N     12      0       Imports for Consumption, Import Charges, Current Month
14      CON_CHA_YR  N     12      0       Imports for Consumption, Import Charges, Year to Date      
15      CON_CIF_MO  N     12      0       Imports for Consumption, CIF Import Value, Current Month
16      CON_CIF_YR  N     12      0       Imports for Consumption, CIF Import Value, Year to Date      
17      GEN_VAL_MO  N     12      0       General Imports, Customs Value, Current Month
18      GEN_VAL_YR  N     12      0       General Imports, Customs Value, Year to Date      
19      GEN_CHA_MO  N     12      0       General Imports, Import Charges, Current Month
20      GEN_CHA_YR  N     12      0       General Imports, Import Charges, Year to Date      
21      GEN_CIF_MO  N     12      0       General Imports, CIF Import Value, Current Month
22      GEN_CIF_YR  N     12      0       General Imports, CIF Import Value, Year to Date      
23      VES_VAL_MO  N     12      0       Shippments by Vessel, Customs Value, Current Month
24      VES_VAL_YR  N     12      0       Shippments by Vessel, Customs Value, Year to Date
25      VES_WGT_MO  N     12      0       Shippments by Vessel, Shipping Weight, Current Month
26      VES_WGT_YR  N     12      0       Shippments by Vessel, Shipping Weight, Year to Date
27      VES_CHA_MO  N     12      0       Shippments by Vessel, Import Charges, Current Month
28      VES_CHA_YR  N     12      0       Shippments by Vessel, Import Charges, Year to Date
29      AIR_VAL_MO  N     12      0       Shippments by Air, Customs Value, Current Month
30      AIR_VAL_YR  N     12      0       Shippments by Air, Customs Value, Year to Date
31      AIR_WGT_MO  N     12      0       Shippments by Air, Shipping Weight, Current Month
32      AIR_WGT_YR  N     12      0       Shippments by Air, Shipping Weight, Year to Date
33      AIR_CHA_MO  N     12      0       Shippments by Air, Import Charges, Current Month
34      AIR_CHA_YR  N     12      0       Shippments by Air, Import Charges, Year to Date

          Total Size:    365

Harmonized Commodity Masters - Imports Concordance Database

CONCORD.DBF

Field   Field      Field  Field           Field
Number  Name       Type   Size   Decimal  Description   


 1      ID_CODE     C      1      0       Identification Code = 2
 2      COMMODITY   C     10      0       Import Harmonized Commodity Code
 3      FILL1       C      2      0       Filler
 4      DESCRIP_1   C    150      0       Description of 10-digit Commodity
 5      FILL2       C      1      0       Filler
 6      DESCRIP_2   C     50      0       Abreviated Version of Description
 7      FILL3       C      1      0       Filler
 8      QUANTITY_1  C      3      0       Alphabetic Abbreviation of the first 
                                          reporting unit of quantity as required
                                          by HTSUSA
 9      FILL4       C      1      0       Filler
10      QUANTITY_2  C      3      0       Second Unit of Quantity if Required 
                                          by HTSUSA
11      FILL5       C      1      0       Filler
12      SITC        C      5      0       Standard International Trade Classification
                                          Revision 3 Code
13      FIlL6       C      1      0       Filler
14      END_USE     C      5      0       End Use Classification Code
15      FILL7       C      1      0       Filler
16      SIC         C      4      0       Standard Industry Classification Code
17      FILL8       C      7      0       Filler
18      USDA        C      1      0       Agriculture or Non-Agriculture Product Code
19      FILL9       C      1      0       Filler
         
         Total Size:     249     

Harmonized Commodity Masters
Commodity Descriptions Database

HSDESC.DBF

Field   Field      Field  Field           Field
Number  Name       Type   Size   Decimal  Description   


 1      ID_CODE     C      1      0       Identification Code = 6
 2      COMMODITY   C      6      0       Export Harmonized Code - 2, 4, or 6 Digit Level
 3      FILL1       C      6      0       Filler
 4      DESCRIPTN   C    150      0       Description of Harmonized Code
 5      FILL2       C      1      0       Filler
 6      ABBREVIATN  C     50      0       Abreviated Version of Description

         Total Size:     215     

Harmonized Commodity Masters
Standard International Trade Classification Descriptions Database

SITCDESC.DBF

Field   Field      Field  Field           Field
Number  Name       Type   Size   Decimal  Description   


 1      ID_CODE     C      1      0       Identification Code = 5
 2      SITC_CODE   C      5      0       SITC REV3 Code - 1, 2, 3, 4, or 5 Digit Level
 3      FILL1       C      7      0       Filler
 4      DESCRIPTN   C    150      0       Description of SITC REV3 product
 5      FILL2       C      1      0       Filler
 6      ABBREVIATN  C     50      0       Abreviated Description 

         Total Size:     215     

Country Name Database

COUNTRY.DBF

Field   Field      Field  Field           Field
Number  Name       Type   Size   Decimal  Description   


 1      CTY_CODE    C      4      0       Country Code
 2      CTY_DESC    C      7      0       Country Abbreviation
 3      CTY_NAME    C     30      0       Country Name

         Total Size:      42

Customs District Name Database

DISTRICT.DBF

Field   Field      Field  Field           Field
Number  Name       Type   Size   Decimal  Description   


 1      CTY_CODE    C      2      0       District Code
 2      CTY_DESC    C      7      0       District Abbreviation
 3      CTY_NAME    C     30      0       District Name

         Total Size:      40
Questions about the CD-ROM should be directed to Data User Services Division, Systems and Programming Branch, Bureau of the Census, Washington, DC 20233. (301) 763-INFO(4636).

Questions about the subject matter should be directed to Foreign Trade Data Services Branch, Bureau of the Census, Washington, DC 20233. (301) 457-2311.