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

8 rows where chapter_id = 6 and unit = "No."

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: indent, general_rate, column2_rate, footnotes

unit 1

id ▼ hts_code indent description unit general_rate special_rate column2_rate footnotes chapter_id
3826 8465.91.00.06 5 Panel saws No.         Live Trees and Other Plants; Bulbs, Roots and the Like; Cut Flowers and Ornamental Foliage 6
3827 8465.92.00.06 5 Routers No.         Live Trees and Other Plants; Bulbs, Roots and the Like; Cut Flowers and Ornamental Foliage 6
3828 8529.90.06.00 5 Other No. Free   35% [{"columns": ["general"], "marker": "1", "value": "See 9903.88.01.", "type": "endnote"}, {"columns": ["units"], "marker": "1", "value": "Report quantity as indicated in additional U.S. note 4(b) to this chapter.", "type": "endnote"}] Live Trees and Other Plants; Bulbs, Roots and the Like; Cut Flowers and Ornamental Foliage 6
3830 8708.99.06.00 4 Double flanged wheel hub units incorporating ball bearings No. Free   Free [{"columns": ["general"], "marker": "1", "value": "See 9903.88.03.", "type": "endnote"}] Live Trees and Other Plants; Bulbs, Roots and the Like; Cut Flowers and Ornamental Foliage 6
3831 8903.99.06.00 4 Canoes No. Free   35% [{"columns": ["general"], "marker": "1", "value": "See 9903.88.03. ", "type": "endnote"}] Live Trees and Other Plants; Bulbs, Roots and the Like; Cut Flowers and Ornamental Foliage 6
3833 9401.71.00.06 3 Bouncers with seats No.         Live Trees and Other Plants; Bulbs, Roots and the Like; Cut Flowers and Ornamental Foliage 6
3834 9401.79.00.06 3 Stationary activity centers for children No.         Live Trees and Other Plants; Bulbs, Roots and the Like; Cut Flowers and Ornamental Foliage 6
3835 9401.80.40.06 7 Household No.         Live Trees and Other Plants; Bulbs, Roots and the Like; Cut Flowers and Ornamental Foliage 6

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