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

7 rows where chapter_id = 29 and unit = "g"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: indent, footnotes

unit 1

id ▼ hts_code indent description unit general_rate special_rate column2_rate footnotes chapter_id
21065 2937.29.90.30 4 Salts and esters of prednisone g         Organic Chemicals 29
21066 2937.29.90.40 4 Salts and esters of prednisolone g         Organic Chemicals 29
21067 2937.29.90.50 4 Anabolic agents and androgens g         Organic Chemicals 29
21068 2937.29.90.95 4 Other g         Organic Chemicals 29
21075 3301.29.51.35 4 Of rose (attar of roses) g         Organic Chemicals 29
21250 7104.29.00.00 2 Other g 3% Free (A+,AU,BH,CL,CO,D,E,IL, JO,KR,MA, OM,P,PA,PE,S,SG) 30% [{"columns": ["general"], "marker": "1", "value": "See 9903.88.15. ", "type": "endnote"}] Organic Chemicals 29
21435 9705.29.00.00 2 Other g Free   Free [{"columns": ["other"], "marker": "1", "value": "See 9903.90.08. ", "type": "endnote"}, {"columns": ["general"], "marker": "1", "value": "See 9903.88.15. ", "type": "endnote"}] Organic Chemicals 29

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);