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

2 rows where chapter_id = 25 and unit = "Dz Pcs"

✎ View and edit SQL

This data as json, CSV (advanced)

unit 1

  • Dz Pcs · 2 ✖
id ▼ hts_code indent description unit general_rate special_rate column2_rate footnotes chapter_id
20490 6913.90.30.00 3 Of earthenware, whether or not decorated, having a reddish-colored body and a lustrous glaze, and mottled, streaked or solidly colored brown to black with metallic oxide or salt Dz Pcs Free   25% [{"columns": ["general"], "marker": "1", "value": "See 9903.88.15. ", "type": "endnote"}] Salt; Sulfur; Earths and Stone; Plastering Materials, Lime and Cement 25
20491 6914.90.41.00 2 Ceramic ferrules of alumina or zirconia, not exceeding 3 mm in diameter or 25 mm in length, having a fiber channel opening and/or ceramic mating sleeves of alumina or zirconia Dz Pcs Free   45% [{"columns": ["general"], "marker": "1", "value": "See 9903.88.03. ", "type": "endnote"}] Salt; Sulfur; Earths and Stone; Plastering Materials, Lime and Cement 25

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