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

10 rows where chapter_id = 19 and unit = "bbl"

✎ View and edit SQL

This data as json, CSV (advanced)

unit 1

  • bbl · 10 ✖
id ▼ hts_code indent description unit general_rate special_rate column2_rate footnotes chapter_id
14907 2710.19.30.20 5 Automotive, diesel or marine engine lubricating oils bbl         Preparations of Cereals, Flour, Starch or Milk; Pastrycooks' Products 19
14908 2710.19.30.30 5 Turbine lubricating oil, including marine bbl         Preparations of Cereals, Flour, Starch or Milk; Pastrycooks' Products 19
14909 2710.19.30.40 5 Automotive gear oils bbl         Preparations of Cereals, Flour, Starch or Milk; Pastrycooks' Products 19
14910 2710.19.30.50 5 Steam cylinder oils bbl         Preparations of Cereals, Flour, Starch or Milk; Pastrycooks' Products 19
14911 2710.19.30.70 5 Quenching or cutting oils bbl         Preparations of Cereals, Flour, Starch or Milk; Pastrycooks' Products 19
14912 2710.19.30.80 5 Other bbl         Preparations of Cereals, Flour, Starch or Milk; Pastrycooks' Products 19
14914 2710.19.45.30 6 Medicinal grade bbl         Preparations of Cereals, Flour, Starch or Milk; Pastrycooks' Products 19
14915 2710.19.45.40 6 Other bbl         Preparations of Cereals, Flour, Starch or Milk; Pastrycooks' Products 19
14916 2710.19.45.45 5 Insulating or transformer oils bbl         Preparations of Cereals, Flour, Starch or Milk; Pastrycooks' Products 19
14917 2710.19.45.90 5 Other bbl         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);
Powered by Datasette · Queries took 1769.215ms · Data license: Public Domain · Data source: US International Trade Commission