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

3 rows where chapter_id = 36 and unit = "doz."

✎ View and edit SQL

This data as json, CSV (advanced)

unit 1

  • doz. · 3 ✖
id ▼ hts_code indent description unit general_rate special_rate column2_rate footnotes chapter_id
24214 6103.49.80.36 5 Subject to wool restraints (459) doz.         Explosives; Pyrotechnic Products; Matches; Pyrophoric Alloys; Certain Combustible Preparations 36
24215 6203.42.45.36 9 Other (347) doz.         Explosives; Pyrotechnic Products; Matches; Pyrophoric Alloys; Certain Combustible Preparations 36
24216 6204.62.80.36 10 Imported as parts of playsuits (237) doz.         Explosives; Pyrotechnic Products; Matches; Pyrophoric Alloys; Certain Combustible Preparations 36

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