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

6 rows where chapter_id = 30 and unit = "gross"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: indent

unit 1

  • gross · 6 ✖
id ▼ hts_code indent description unit general_rate special_rate column2_rate footnotes chapter_id
21790 3926.90.65.30 4 Valued over $1.35 but not over $1.70 per gross gross         Pharmaceutical Products 30
21838 4421.91.80.30 5 Valued over $1.35 but not over $1.70/gross gross         Pharmaceutical Products 30
21839 4421.99.80.30 5 Valued over $1.35 but not over $1.70/gross gross         Pharmaceutical Products 30
22857 9606.30.40.00 2 Button blanks of casein gross Free   45% [{"columns": ["general"], "marker": "1", "value": "See 9903.88.03. ", "type": "endnote"}] Pharmaceutical Products 30
22858 9606.30.80.00 2 Other gross 6% Free (A,AU,BH,CL,CO,D,E,IL,JO,KR,MA,OM,P,PA,PE,S,SG) 45% [{"columns": ["general"], "marker": "1", "value": "See 9903.88.03. ", "type": "endnote"}] Pharmaceutical Products 30
22862 9609.90.80.00 2 Other gross Free   50¢/gross + 30% [{"columns": ["general"], "marker": "1", "value": "See 9903.88.15. ", "type": "endnote"}] Pharmaceutical Products 30

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 4077.579ms · Data license: Public Domain · Data source: US International Trade Commission