home / hts

Menu
  • Search all tables

hts_entries

Tariff line items with duty rates, units, and classification hierarchy. Search uses full-text search on the description column. To look up a specific HTS code, use the column filter rather than the search box.

Data license: Public Domain · Data source: US International Trade Commission

12 rows where chapter_id = 38

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: general_rate, column2_rate

unit 4

  • No. 4
  • kg 4
  • doz. 3
  • - 1
id ▼ hts_code indent description unit general_rate special_rate column2_rate footnotes chapter_id
24261 0102.39.00.38 5 Female No.         Miscellaneous Chemical Products 38
24262 0702.00.60.38 4 Other kg         Miscellaneous Chemical Products 38
24263 2005.99.50 4 Pimientos (<i>Capsicum anuum</i>)   8.1% Free (A+,AU,BH,CL,CO,D,E,IL,JO,KR,MA,OM,P,PA,PE,S,SG) 38.5% [{"columns": ["general"], "marker": "1", "value": "See 9903.88.03. ", "type": "endnote"}] Miscellaneous Chemical Products 38
24264 3004.90.92.38 6 Containing midazolam or its salts kg         Miscellaneous Chemical Products 38
24265 6005.38.00.80 4 Other (222) kg         Miscellaneous Chemical Products 38
24266 6103.49.80.38 5 Subject to man-made fiber restraints (659) doz.         Miscellaneous Chemical Products 38
24267 6104.69.80.38 6 Trousers and breeches (847) doz.         Miscellaneous Chemical Products 38
24268 6113.00.90.38 4 Men's or boys' (347) doz.         Miscellaneous Chemical Products 38
24269 7208.38.00.90 4 Other kg         Miscellaneous Chemical Products 38
24270 8431.49.90.38 7 Wheel and tire assemblies No.         Miscellaneous Chemical Products 38
24271 8504.90.96.38 6 Stacked cores for incorporation into transformers No.         Miscellaneous Chemical Products 38
24272 9114.90.38.00 3 Other No. 4.2% Free (A+,AU,B,BH,CL,CO,D,E,IL,JO,KR,MA, OM,P,PA,PE,S,SG) 65% [{"columns": ["general"], "marker": "1", "value": "See 9903.88.15. ", "type": "endnote"}] Miscellaneous Chemical Products 38

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE hts_entries (
        id              INTEGER PRIMARY KEY AUTOINCREMENT,
        hts_code        TEXT NOT NULL UNIQUE,
        indent          INTEGER,
        description     TEXT,
        unit            TEXT,
        general_rate    TEXT,
        special_rate    TEXT,
        column2_rate    TEXT,
        footnotes       TEXT,
        chapter_id      INTEGER REFERENCES chapters(id)
    );
CREATE INDEX idx_hts_code ON hts_entries(hts_code);
CREATE INDEX idx_description ON hts_entries(description);
Powered by Datasette · Queries took 4393.325ms · Data license: Public Domain · Data source: US International Trade Commission