FIX FORMATTED ASCII FILE RECORD LENGTH: 235
| POSITION | FIELD NAME | DESCRIPTION |
|---|---|---|
| 1-10 | commodity | 10-Digit Harmonized Tariff Schedule (HTS) Code |
| 11-160 | descriptn | 150-Digit HTS Description |
| 161-210 | abbreviatn | 50-Digit HTS Description |
| 211-213 | unit_qy1 | 3-Digit Unit of Quanitity 1 |
| 214-216 | unit_qy2 | 3-Digit Unit of Quanitity 2 |
| 217-221 | sitc | 5-Digit SITC Code |
| 222-226 | end_use | 5-Digit ENDUSE Code |
| 227-232 | naics | 6-Digit NAICS Code |
| 233-233 | usda | 1-Digit USDA Code |
| 234-235 | hitech | 2-Digit HITECH Code |
| 236-245 | years_ap | 10-Digit All 2-Digit Years HS Code Has Data During 5 Year History |
FIX FORMATTED ASCII FILE RECORD LENGTH: 51
| POSITION | FIELD NAME | DESCRIPTION |
|---|---|---|
| 1-4 | cty_code | 4-Digit Country Code |
| 5-11 | cty_desc | 7-Digit Country Description |
| 12-41 | cty_name | 30-Digit Country Name |
| 42-51 | years_ap | 10-Digit All 2-Digit Years Country Code Was Valid During 5 Year History |
FIX FORMATTED ASCII FILE RECORD LENGTH: 49
| POSITION | FIELD NAME | DESCRIPTION |
|---|---|---|
| 1-2 | dist_code | 2-Digit Distrcit Code |
| 3-9 | dist_desc | 7-Digit District Description |
| 10-39 | dist_name | 30-Digit District Name |
| 40-49 | years_ap | 10-Digit All 2-Digit Years District Code Was Valid During 5 Year History |
FIX FORMATTED ASCII FILE RECORD LENGTH: 105
| POSITION | FIELD NAME | DESCRIPTION |
|---|---|---|
| 1-5 | enduse | 5-Digit ENDUSE Code* |
| 6-105 | eudesc | 100-Digit ENDUSE Description |
* Includes 1-, 2-, 3-, and 5-Digit end-use codes.
FIX FORMATTED ASCII FILE RECORD LENGTH: 32
| POSITION | FIELD NAME | DESCRIPTION |
|---|---|---|
| 1-2 | hitech | 2-Digit HITECH Code |
| 3-32 | hidesc | 30-Digit HITECH Description |
FIX FORMATTED ASCII FILE RECORD LENGTH: 206
| POSITION | FIELD NAME | DESCRIPTION |
|---|---|---|
| 1-6 | commodity | 6-Digit Harmonized Code* |
| 7-156 | descriptn | 150-Digit Commodity Description |
| 157-206 | abbreviatn | 50-Digit Commodity Description |
* Includes 2-, 4- and 6-Digit HS codes.
FIX FORMATTED ASCII FILE RECORD LENGTH: 373
| POSITION | FIELD NAME | DESCRIPTION |
|---|---|---|
| 1-10 | commodity | 10-Digit Harmonized Tariff Schedule (HTS) Code |
| 11-60 | comm_desc | 50-Digit HTS Description |
| 61-63 | unit_qy1 | 3-Digit Unit of Quantity 1 |
| 64-73 | years_ap | 10-Digit All 2-Digit Years HS Code Has Data During 5 Year History |
| 74-88 | con_qy1_[Y1] | 15-Digit Imports for Consumption, Quantity 1, First Year in Series, where [Y1] is the 2-digit year |
| 89-103 | con_val_[Y1] | 15-Digit Imports for Consumption, Total Value, First Year in Series, where [Y1] is the 2-digit year |
| 104-118 | gen_qy1_[Y1] | 15-Digit General Imports, Quantity 1, First Year in Series, where [Y1] is the 2-digit year |
| 119-133 | gen_val_[Y1] | 15-Digit General Imports, Total Value, Second Year in Series, where [Y1] is the 2-digit year |
| 134-148 | con_qy1_[Y2] | 15-Digit Imports for Consumption, Quantity 1, Second Year in Series, where [Y1] is the 2-digit year |
| 149-163 | con_val_[Y2] | 15-Digit Imports for Consumption, Total Value, Second Year in Series, where [Y1] is the 2-digit year |
| 164-178 | gen_qy1_[Y2] | 15-Digit General Imports, Quantity 1, Second Year in Series, where [Y1] is the 2-digit year |
| 179-193 | gen_val_[Y2] | 15-Digit General Imports, Total Value, Second Year in Series, where [Y1] is the 2-digit year |
| 194-208 | con_qy1_[Y3] | 15-Digit Imports for Consumption, Quantity 1, Third Year in Series, where [Y1] is the 2-digit year |
| 209-223 | con_val_[Y3] | 15-Digit Imports for Consumption, Total Value, Third Year in Series, where [Y1] is the 2-digit year |
| 224-238 | gen_qy1_[Y3] | 15-Digit General Imports, Quantity 1, Third Year in Series, where [Y1] is the 2-digit year |
| 239-253 | gen_val_[Y3] | 15-Digit General Imports, Total Value, Third Year in Series, where [Y1] is the 2-digit year |
| 254-268 | con_qy1_[Y4] | 15-Digit Imports for Consumption, Quantity 1, Fourth Year in Series, where [Y1] is the 2-digit year |
| 269-283 | con_val_[Y4] | 15-Digit Imports for Consumption, Total Value, Fourth Year in Series, where [Y1] is the 2-digit year |
| 284-298 | gen_qy1_[Y4] | 15-Digit General Imports, Quantity 1, Fourth Year in Series, where [Y1] is the 2-digit year |
| 299-313 | gen_val_[Y4] | 15-Digit General Imports, Total Value, Fourth Year in Series, where [Y1] is the 2-digit year |
| 314-328 | con_qy1_[05] | 15-Digit Imports for Consumption, Quantity 1, Fifth Year in Series, where [Y1] is the 2-digit year |
| 329-343 | con_val_[05] | 15-Digit Imports for Consumption, Total Value, Fifth Year in Series, where [Y1] is the 2-digit year |
| 344-358 | gen_qy1_[05] | 15-Digit General Imports, Quantity 1, Fifth Year in Series, where [Y1] is the 2-digit year |
| 359-373 | gen_val_[05] | 15-Digit General Imports, Total Value, Fifth Year in Series, where [Y1] is the 2-digit year |
FIX FORMATTED ASCII FILE RECORD LENGTH: 194
| POSITION | FIELD NAME | DESCRIPTION |
|---|---|---|
| 1-4 | cty_code | 4-Digit Country Code |
| 5-34 | cty_name | 30-Digit Country Name |
| 35-44 | years_ap | 10-Digit All 2-Digit Years HS Code has Data During 5 Year History |
| 45-59 | con_val_[Y1] | 15-Digit Imports for Consumption, Total Value, First Year in Series, where [Y1] is the 2-digit year |
| 60-74 | gen_val_[Y1] | 15-Digit General Imports, Total Value, First Year in Series, where [Y1] is the 2-digit year |
| 75-89 | con_val_[Y2] | 15-Digit Imports for Consumption, Total Value, Second Year in Series, where [Y1] is the 2-digit year |
| 90-104 | gen_val_[Y2] | 15-Digit General Imports, Total Value, Second Year in Series, where [Y1] is the 2-digit year |
| 105-119 | con_val_[Y3] | 15-Digit Imports for Consumption, Total Value, ThirdYear in Series, where [Y1] is the 2-digit year |
| 120-134 | gen_val_[Y3] | 15-Digit General Imports, Total Value, Third Year in Series, where [Y1] is the 2-digit year |
| 135-149 | con_val_[Y4] | 15-Digit Imports for Consumption, Total Value, Fourth Year in Series, where [Y1] is the 2-digit year |
| 150-164 | gen_val_[Y4] | 15-Digit General Imports, Total Value, Fourth Year in Series, where [Y1] is the 2-digit year |
| 165-179 | con_val_[Y5] | 15-Digit Imports for Consumption, Total Value, Fifth Year in Series, where [Y1] is the 2-digit year |
| 180-194 | gen_val_[Y5] | 15-Digit General Imports, Total Value, Fifth Year in Series, where [Y1] is the 2-digit year |
FIX FORMATTED ASCII FILE RECORD LENGTH: 192
| POSITION | FIELD NAME | DESCRIPTION |
|---|---|---|
| 1-2 | cty_code | 4-Digit Country Code |
| 3-32 | cty_name | 30-Digit Country Name |
| 33-42 | years_ap | 10-Digit All 2-Digit Years HS Code has Data During 5 Year History |
| 43-57 | con_val_[Y1] | 15-Digit Imports for Consumption, Total Value, First Year in Series, where [Y1] is the 2-digit year |
| 58-72 | gen_val_[Y1] | 15-Digit General Imports, Total Value, First Year in Series, where [Y1] is the 2-digit year |
| 73-87 | con_val_[Y2] | 15-Digit Imports for Consumption, Total Value, Second Year in Series, where [Y1] is the 2-digit year |
| 88-102 | gen_val_[Y2] | 15-Digit General Imports, Total Value, Second Year in Series, where [Y1] is the 2-digit year |
| 103-117 | con_val_[Y3] | 15-Digit Imports for Consumption, Total Value, ThirdYear in Series, where [Y1] is the 2-digit year |
| 118-132 | gen_val_[Y3] | 15-Digit General Imports, Total Value, Third Year in Series, where [Y1] is the 2-digit year |
| 133-147 | con_val_[Y4] | 15-Digit Imports for Consumption, Total Value, Fourth Year in Series, where [Y1] is the 2-digit year |
| 148-162 | gen_val_[Y4] | 15-Digit General Imports, Total Value, Fourth Year in Series, where [Y1] is the 2-digit year |
| 163-177 | con_val_[Y5] | 15-Digit Imports for Consumption, Total Value, Fifth Year in Series, where [Y1] is the 2-digit year |
| 178-192 | gen_val_[Y5] | 15-Digit General Imports, Total Value, Fifth Year in Series, where [Y1] is the 2-digit year |
FIX FORMATTED ASCII FILE RECORD LENGTH: 441
| POSITION | FIELD NAME | DESCRIPTION |
|---|---|---|
| 1-10 | commodity | 10-Digit Harmonized Tariff Schedule (HTS) Code |
| 11-60 | abbreviatn | 50-Digit HTS Description |
| 61-63 | unit_qy1 | 3-Digit Unit of Quantity 1 |
| 64-67 | cty_code | 4-Digit Country Code |
| 68-97 | cty_name | 30-Digit Country Name |
| 98-99 |
cty_subco |
2-Digit Country Subcode |
| 100-101 | dist_entry | 2-Digit District of Entry Code |
| 102-131 | dist_name | 30-Digit District Name |
| 132-141 | years_ap | 10-Digit All 2-Digit Years HS Code Has Data During 5 Year History |
| 142-156 | con_qy1_[Y1] | 15-Digit Imports for Consumption, Quantity 1, First Year in Series, where [Y1] is the 2-digit year |
| 157-171 | con_val_[Y1] | 15-Digit Imports for Consumption, Total Value, First Year in Series, where [Y1] is the 2-digit year |
| 172-186 | gen_qy1_[Y1] | 15-Digit General Imports, Quantity 1, First Year in Series, where [Y1] is the 2-digit year |
| 187-201 | gen_val_[Y1] | 15-Digit General Imports, Total Value, Second Year in Series, where [Y1] is the 2-digit year |
| 202-216 | con_qy1_[Y2] | 15-Digit Imports for Consumption, Quantity 1, Second Year in Series, where [Y1] is the 2-digit year |
| 217-231 | con_val_[Y2] | 15-Digit Imports for Consumption, Total Value, Second Year in Series, where [Y1] is the 2-digit year |
| 232-246 | gen_qy1_[Y2] | 15-Digit General Imports, Quantity 1, Second Year in Series, where [Y1] is the 2-digit year |
| 247-261 | gen_val_[Y2] | 15-Digit General Imports, Total Value, Second Year in Series, where [Y1] is the 2-digit year |
| 262-276 | con_qy1_[Y3] | 15-Digit Imports for Consumption, Quantity 1, Third Year in Series, where [Y1] is the 2-digit year |
| 277-291 | con_val_[Y3] | 15-Digit Imports for Consumption, Total Value, Third Year in Series, where [Y1] is the 2-digit year |
| 292-306 | gen_qy1_[Y3] | 15-Digit General Imports, Quantity 1, Third Year in Series, where [Y1] is the 2-digit year |
| 307-321 | gen_val_[Y3] | 15-Digit General Imports, Total Value, Third Year in Series, where [Y1] is the 2-digit year |
| 322-336 | con_qy1_[Y4] | 15-Digit Imports for Consumption, Quantity 1, Fourth Year in Series, where [Y1] is the 2-digit year |
| 337-351 | con_val_[Y4] | 15-Digit Imports for Consumption, Total Value, Fourth Year in Series, where [Y1] is the 2-digit year |
| 352-366 | gen_qy1_[Y4] | 15-Digit General Imports, Quantity 1, Fourth Year in Series, where [Y1] is the 2-digit year |
| 367-381 | gen_val_[Y4] | 15-Digit General Imports, Total Value, Fourth Year in Series, where [Y1] is the 2-digit year |
| 382-396 | con_qy1_[Y5] | 15-Digit Imports for Consumption, Quantity 1, Fifth Year in Series, where [Y1] is the 2-digit year |
| 397-411 | con_val_[Y5] | 15-Digit Imports for Consumption, Total Value, Fifth Year in Series, where [Y1] is the 2-digit year |
| 412-426 | gen_qy1_[Y5] | 15-Digit General Imports, Quantity 1, Fifth Year in Series, where [Y1] is the 2-digit year |
| 427-441 | gen_val_[Y5] | 15-Digit General Imports, Total Value, Fifth Year in Series, where [Y1] is the 2-digit year |
FIX FORMATTED ASCII FILE RECORD LENGTH: 56
| POSITION | FIELD NAME | DESCRIPTION |
|---|---|---|
| 1-6 | naics | 6-Digit NAICS Code* |
| 7-56 | naicdesc | 50-Digit NAICS Description |
* Includes 2-, 3-, 4-, 5-, and 6-Digit NAICS codes.
FIX FORMATTED ASCII FILE RECORD LENGTH: 205
| POSITION | FIELD NAME | DESCRIPTION |
|---|---|---|
| 1-5 | sitc | 5-Digit SITC Code* |
| 6-155 | sitcdesc | 150-Digit SITC Description |
| 156-205 | sitcabrev | 50-Digit SITC Description |
* Includes 1-, 2-, 3-, 4-, and 5-Digit SITC codes.