FL_EXP.ASC ---------- FILES ON CD-ROM U.S. Exports of Merchandise on CD-ROM These files 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. The detailed database structure appears on the page listed. EXP_DETL.DBF Export Detail Database P.1-11 EXP_DETL.CDY Index File - Key: DOM_OR_FOR + COMMODITY(1) EXP_DETL.CTY Index File - Key: DOM_OR_FOR + CTY_CODE EXP_DETL.DST Index File - Key: DOM_OR_FOR + DIST_CODE EXP_COMM.DBF Commodity Summary Database P.1-13 EXP_COMM.NDX Index File - Key: DOM_OR_FOR + COMMODITY EXP_CTY.DBF ountry Summary Database P.1-15 EXP_CTY.NDX ndex File - Key: CTY_CODE EXP_DIST.DBF District of Export Summary Database P.1-17 EXP_DIST.NDX Index File - Key: DIST_CODE CONCORD.DBF Harmonized Commodity Masters  Exports Concordance Database P.1-19 CONCORD.NDX Index File - Key: COMMODITY HSDESC.DBF Harmonized Commodity Masters  Commodity Descriptions P.1-21 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 P.1-21 COUNTRY.DBF Country Name Database P.1-23 DISTRICT.DBF Customs District Name Database P.1-23 ---------- (1)Unique index file. This points only to the first occurrence of each key value. Export Detail Database EXP_DETL.DBF Field Field Field Number Field Name Type Size Decimal Field Description 1 DOM_OR_FOR C 1 0 Domestic Exports or 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 DISTRICT 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 Second Unit of Quantity, Current Month 16 ALL_QY2_YR N 12 0 Amount of Second 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 Shipments by Vessel, Shipping Weight, Current Month 20 VES_WGT_YR N 12 0 Shipments by Vessel, Shipping Weight, Year to Date 21 VES_VAL_MO N 12 0 Shipments by Vessel, F.A.S. Value, Current Month 22 VES_VAL_YR N 12 0 Shipments by Vessel, F.A.S. Value, Year to Date 23 AIR_WGT_MO N 12 0 Shipments by Air, Shipping Weight, Current Month 24 AIR_WGT_YR N 12 0 Shipments by Air, Shipping Weight, Year to Date 25 AIR_VAL_MO N 12 0 Shipments by Air, F.A.S. Value, Current Month 26 AIR_VAL_YR N 12 0 Shipments by Air, F.A.S. Value, Year to Date Total Size 274 Commodity Summary Database EXP_COMM.DBF Field Field Field Number Field Name Type Size Decimal Field Description 1 DOM_OR_FOR C 1 0 Domestic Exports or 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 Quantity, Current Month 9 ALL_QY1_YR N 12 0 Amount of Quantity, Year to Date 10 UNIT_QY2 C 3 0 Second Unit of Quantity (if required) 11 ALL_QY2_MO N 12 0 Amount of Second Unit of Quantity, Current Month 12 ALL_QY2_YR N 12 0 Amount of Second 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 Shipments by Vessel, Shipping Weight, Current Month 16 VES_WGT_YR N 12 0 Shipments by Vessel, Shipping Weight, Year to Date 17 VES_VAL_MO N 12 0 Shipments by Vessel, F.A.S. Value, Current Month 18 VES_VAL_YR N 12 0 Shipments by Vessel, F.A.S. Value, Year to Date 19 AIR_WGT_MO N 12 0 Shipments by Air, Shipping Weight, Current Month 20 AIR_WGT_YR N 12 0 Shipments by Air, Shipping Weight, Year to Date 21 AIR_VAL_MO N 12 0 Shipments by Air, F.A.S. Value, Current Month 22 AIR_VAL_YR N 12 0 Shipments by Air, F.A.S. Value, Year to Date Total Size 254 Country Summary Database EXP_CTY.DBF Field Field Field Number Field Name Type Size Decimal Field 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 Shipments by Vessel, Shipping Weight, Current Month 9 VES_WGT_YR N 12 0 Shipments by Vessel, Shipping Weight, Year to Date 10 VES_VAL_MO N 12 0 Shipments by Vessel, F.A.S. Value, Current Month 11 VES_VAL_YR N 12 0 Shipments by Vessel, F.A.S. Value, Year to Date 12 AIR_WGT_MO N 12 0 Shipments by Air, Shipping Weight, Current Month 13 AIR_WGT_YR N 12 0 Shipments by Air, Shipping Weight, Year to Date 14 AIR_VAL_MO N 12 0 Shipments by Air, F.A.S. Value, Current Month 15 AIR_VAL_YR N 12 0 Shipments by Air, F.A.S. Value, Year to Date Total Size 150 District of Export Summary Database EXP_DIST.DBF Field Field Field Number Field Name Type Size Decimal Field Description 1 DIST_CODE C 2 0 District of Export Code 2 DIST_DESC C 7 0 District of Export 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 Shipments by Vessel, Shipping Weight, Current Month 9 VES_WGT_YR N 12 0 Shipments by Vessel, Shipping Weight, Year to Date 10 VES_VAL_MO N 12 0 Shipments by Vessel, F.A.S. Value, Current Month 11 VES_VAL_YR N 12 0 Shipments by Vessel, F.A.S. Value, Year to Date 12 AIR_WGT_MO N 12 0 Shipments by Air, Shipping Weight, Current Month 13 AIR_WGT_YR N 12 0 Shipments by Air, Shipping Weight, Year to Date 14 AIR_VAL_MO N 12 0 Shipments by Air, F.A.S. Value, Current Month 15 AIR_VAL_YR N 12 0 Shipments by Air, F.A.S. Value, Year to Date Total Size 148 Harmonized Commodity Masters - Exports Concordance Database CONCORD.DBF Field Field Field Number Field Name Type Size Decimal Field 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 Abbreviated 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 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 HSDESC.DBF Field Field Field Number Field Name Type Size Decimal Field Description 1 ID_CODE C 1 0 Identification Code = 6 2 COMMODITY C 6 0 Import 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 Abbreviated version of description of Harmonized Code Total Size 215 Harmonized Comodity Masters Standard International Trade Classification Descriptions SITCDESC.DBF Field Field Field Number Field Name Type Size Decimal Field 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 Abbreviated description of SITC REV3 product Total Size 215 Country Name Database COUNTRY.DBF Field Field Field Number Field Name Type Size Decimal Field 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 42 Customs District Name Database DISTRICT.DBF Field Field Field Number Field Name Type Size Decimal Field Description 1 DIST_CODE C 2 0 District Code 2 DIST_DESC C 7 0 District Abbreviation 3 DIST_NAME C 30 0 District Name Total Size 40 *