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

15 rows where chapter_id = 10 and unit = "carat"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: indent, description, general_rate, special_rate, column2_rate, footnotes

unit 1

  • carat · 15 ✖
id ▼ hts_code indent description unit general_rate special_rate column2_rate footnotes chapter_id
8188 7102.10.00.00 1 Unsorted carat Free   Free [{"columns": ["general"], "marker": "1", "value": "See 9903.88.15. ", "type": "endnote"}] Cereals 10
8190 7102.21.10.10 4 Carbonados carat         Cereals 10
8191 7102.21.10.20 4 Other carat         Cereals 10
8192 7102.29.00.10 4 Carbonados carat         Cereals 10
8194 7102.39.00.10 3 Weighing not over 0.5 carat each carat         Cereals 10
8196 7103.10.20.00 2 Unworked carat Free   Free [{"columns": ["general"], "marker": "1", "value": "See 9903.88.15. ", "type": "endnote"}, {"columns": ["other"], "marker": "1", "value": "See 9903.90.08. ", "type": "endnote"}] Cereals 10
8197 7103.10.40.00 2 Other carat 10.5% Free (A,AU,BH,CL,CO,D,E,IL,JO,KR,MA,OM,P,PA,PE,S,SG) 50% [{"columns": ["general"], "marker": "1", "value": "See 9903.88.15. ", "type": "endnote"}] Cereals 10
8199 7103.91.00.10 3 Rubies carat         Cereals 10
8200 7103.99.10.00 3 Cut but not set, and suitable for use in the manufacture of jewelry carat Free   10% [{"columns": ["general"], "marker": "1", "value": "See 9903.88.15. ", "type": "endnote"}, {"columns": ["other"], "marker": "1", "value": "See 9903.90.08. ", "type": "endnote"}] Cereals 10
8201 7103.99.50.00 3 Other carat 10.5% Free (A*,AU,BH,CL,CO,D,E,IL,JO,KR,MA,OM,P,PA,PE,S,SG) 50% [{"columns": ["general"], "marker": "1", "value": "See 9903.88.15. ", "type": "endnote"}] Cereals 10
8206 7105.10.00.11 3 80 mesh or finer carat         Cereals 10
8207 7105.10.00.15 3 Other carat         Cereals 10
8208 7105.10.00.20 3 Coated with metal carat         Cereals 10
8209 7105.10.00.30 4 80 mesh or finer carat         Cereals 10
8210 7105.10.00.50 4 Other carat         Cereals 10

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