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 = 19 and unit = "pcs"

✎ 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
15069 4104.19.50.30 7 Not split pcs         Preparations of Cereals, Flour, Starch or Milk; Pastrycooks' Products 19
15070 4104.19.50.40 8 Grains pcs         Preparations of Cereals, Flour, Starch or Milk; Pastrycooks' Products 19
15470 7113.19.50.21 6 Necklaces and neck chains pcs       [{"columns": ["units"], "marker": "1", "value": "See statistical note 2 to this chapter.", "type": "endnote"}] Preparations of Cereals, Flour, Starch or Milk; Pastrycooks' Products 19
15471 7113.19.50.25 6 Rings pcs       [{"columns": ["units"], "marker": "1", "value": "See statistical note 2 to this chapter.", "type": "endnote"}] Preparations of Cereals, Flour, Starch or Milk; Pastrycooks' Products 19
15472 7113.19.50.30 6 Earrings pcs       [{"columns": ["units"], "marker": "1", "value": "See statistical note 2 to this chapter.", "type": "endnote"}] Preparations of Cereals, Flour, Starch or Milk; Pastrycooks' Products 19
15473 7113.19.50.45 6 Other pcs       [{"columns": ["units"], "marker": "1", "value": "See statistical note 2 to this chapter.", "type": "endnote"}] Preparations of Cereals, Flour, Starch or Milk; Pastrycooks' Products 19
15474 7113.19.50.91 6 Articles of jewelry, of gold, other than rope, curb, cable, chain, necklaces, neck chains or clasps pcs         Preparations of Cereals, Flour, Starch or Milk; Pastrycooks' Products 19

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