# US imports and exports by port and product, 2024-2026

**See what every US port imports and exports each month, by product and partner country.** US Census Bureau port trade statistics are joined to port names and locations, country names and regions, product descriptions and current US tariff rates. Compare ports for one product, follow a trade lane year over year, or measure a port's share of national trade in a product. The table holds 26,653,212…

US imports and exports by port and product, 2024-2026 is an open, machine-readable dataset published on Mostly Right as immutable Parquet versions, with a documented column schema, a JSON query API and a direct download. Its first rows are free to read and it is open to AI agents.

## Facts

- Slug: `us-imports-and-exports-by-port-and-product-2024-2026`
- Canonical page: https://mostlyright.md/datasets/us-imports-and-exports-by-port-and-product-2024-2026
- Publisher: mostlyrightmd (https://mostlyright.md/publishers/mostlyrightmd)
- Published: 2026-11-13T14:15:23.484Z
- Tables: 7
- Formats: Apache Parquet (download), JSON (query and sample)
- Cost: the first 500 rows of each table are free to everyone; querying and downloading need a free account and count against a monthly free allowance unless the workspace is subscribed
- Metadata API: `GET https://mostlyright.md/api/v2/public/datasets/us-imports-and-exports-by-port-and-product-2024-2026`
- Topics: international trade, us ports, imports, exports, harmonized system, tariffs, customs districts, census bureau

## Table directory

Tables follow the publisher's curated order. Display labels do not change table identifiers.

Start here: port_trade_monthly — table id: 1a308a42-9533-41dc-a8fc-70b335d7172e

- source_port_trade_2025h1 — table id: 8c757e89-7180-451a-b653-1113c243a984; published name: source_port_trade_2025h1; https://mostlyright.md/datasets/us-imports-and-exports-by-port-and-product-2024-2026/tables?table=source-port-trade-2025h1
- source_port_trade_2025h2 — table id: b3d1de11-e69a-4d8e-bf8b-ddcc31cbabfc; published name: source_port_trade_2025h2; https://mostlyright.md/datasets/us-imports-and-exports-by-port-and-product-2024-2026/tables?table=source-port-trade-2025h2
- port_trade_monthly — table id: 1a308a42-9533-41dc-a8fc-70b335d7172e; published name: port_trade_monthly; https://mostlyright.md/datasets/us-imports-and-exports-by-port-and-product-2024-2026/tables?table=port-trade-monthly
- source_port_trade_2024h1 — table id: 78d0fa26-6145-4bdc-bc7c-e4cd00864daf; published name: source_port_trade_2024h1; https://mostlyright.md/datasets/us-imports-and-exports-by-port-and-product-2024-2026/tables?table=source-port-trade-2024h1
- source_port_trade_2026h2 — table id: 3fc4b0df-7730-435b-b256-3b97216b05e7; published name: source_port_trade_2026h2; https://mostlyright.md/datasets/us-imports-and-exports-by-port-and-product-2024-2026/tables?table=source-port-trade-2026h2
- source_port_trade_2026h1 — table id: f2984c94-9e37-4d3e-b665-9c0ed8701e11; published name: source_port_trade_2026h1; https://mostlyright.md/datasets/us-imports-and-exports-by-port-and-product-2024-2026/tables?table=source-port-trade-2026h1
- source_port_trade_2024h2 — table id: 74a2f19d-d2d8-482c-854a-68a8b283cb33; published name: source_port_trade_2024h2; https://mostlyright.md/datasets/us-imports-and-exports-by-port-and-product-2024-2026/tables?table=source-port-trade-2024h2

## How to use it

1. Read a table's schema — no account needed.
2. Fetch its published sample rows — no account needed.
   The first 500 rows of every table, in stored order, are free to everyone, with or without an account. Without an account you get that sample and ranked row search on public tables (search_table). An empty search query pages through a table in stored order. There is no filter, sort or download without an account.
3. Log in at https://mostlyright.md/login, connect this dataset to a workspace on its page, and create an `mr_use_` key.
4. Query bounded JSON, or download the complete Parquet snapshot and read it locally.
   A free workspace may read 100,000 rows and run 1,000 queries a UTC month past the sample. The allowance is shared by everyone in the workspace, and a free workspace may have any number of members. Reads count against the workspace whose data or key they use. A subscribed workspace is never counted, for anyone working in it.

Agents can do all of this over MCP at `https://mostlyright.md/api/mcp` — searching, reading schemas and sampling rows work with no credential at all.

## Table: source_port_trade_2025h1

- Table id: `8c757e89-7180-451a-b653-1113c243a984`
- Slug: `source-port-trade-2025h1`
- Immutable version: `4d27c6f4-7d60-5134-96aa-335d638347f5`
- Schema: `GET https://mostlyright.md/api/v2/public/tables/8c757e89-7180-451a-b653-1113c243a984/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/8c757e89-7180-451a-b653-1113c243a984/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/8c757e89-7180-451a-b653-1113c243a984/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/8c757e89-7180-451a-b653-1113c243a984/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (13)

| Column | Type | Description |
| --- | --- | --- |
| `direction` | string | Whether the row is an import into or an export from the United States. |
| `month` | date | The statistical month, written as its first day. |
| `port_code` | string | The four-digit Census Schedule D code of the US port. |
| `hs6` | string | The six-digit Harmonized System product code. |
| `country_code` | string | The four-digit Census Schedule C code of the partner country. |
| `value_usd` | integer | Trade value in the month in US dollars. |
| `air_value_usd` | integer | The part of the value that moved by air, in US dollars. |
| `air_weight_kg` | integer | Shipping weight moved by air, in kilograms. |
| `vessel_value_usd` | integer | The part of the value that moved by vessel, in US dollars. |
| `vessel_weight_kg` | integer | Shipping weight moved by vessel, in kilograms. |
| `containerized_vessel_value_usd` | integer | The part of the vessel value that moved in containers, in US dollars. |
| `containerized_vessel_weight_kg` | integer | Shipping weight moved by vessel in containers, in kilograms. |
| `ytd_value_usd` | integer | Year-to-date trade value through the month in US dollars, as the publisher reports it. |

## Table: source_port_trade_2025h2

- Table id: `b3d1de11-e69a-4d8e-bf8b-ddcc31cbabfc`
- Slug: `source-port-trade-2025h2`
- Immutable version: `a7291faa-2ac8-515b-bd60-4a227c928296`
- Schema: `GET https://mostlyright.md/api/v2/public/tables/b3d1de11-e69a-4d8e-bf8b-ddcc31cbabfc/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/b3d1de11-e69a-4d8e-bf8b-ddcc31cbabfc/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/b3d1de11-e69a-4d8e-bf8b-ddcc31cbabfc/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/b3d1de11-e69a-4d8e-bf8b-ddcc31cbabfc/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (13)

| Column | Type | Description |
| --- | --- | --- |
| `direction` | string | Whether the row is an import into or an export from the United States. |
| `month` | date | The statistical month, written as its first day. |
| `port_code` | string | The four-digit Census Schedule D code of the US port. |
| `hs6` | string | The six-digit Harmonized System product code. |
| `country_code` | string | The four-digit Census Schedule C code of the partner country. |
| `value_usd` | integer | Trade value in the month in US dollars. |
| `air_value_usd` | integer | The part of the value that moved by air, in US dollars. |
| `air_weight_kg` | integer | Shipping weight moved by air, in kilograms. |
| `vessel_value_usd` | integer | The part of the value that moved by vessel, in US dollars. |
| `vessel_weight_kg` | integer | Shipping weight moved by vessel, in kilograms. |
| `containerized_vessel_value_usd` | integer | The part of the vessel value that moved in containers, in US dollars. |
| `containerized_vessel_weight_kg` | integer | Shipping weight moved by vessel in containers, in kilograms. |
| `ytd_value_usd` | integer | Year-to-date trade value through the month in US dollars, as the publisher reports it. |

## Table: port_trade_monthly

- Table id: `1a308a42-9533-41dc-a8fc-70b335d7172e`
- Slug: `port-trade-monthly`
- Immutable version: `67031fd1-8506-5bc1-ac71-2904c8e6322d`
- Schema: `GET https://mostlyright.md/api/v2/public/tables/1a308a42-9533-41dc-a8fc-70b335d7172e/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/1a308a42-9533-41dc-a8fc-70b335d7172e/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/1a308a42-9533-41dc-a8fc-70b335d7172e/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/1a308a42-9533-41dc-a8fc-70b335d7172e/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (42)

| Column | Type | Description |
| --- | --- | --- |
| `direction` | string | Whether the row is an import into or an export from the United States. |
| `month` | date | The statistical month, written as its first day. |
| `port_code` | string | The four-digit Census Schedule D code of the US port. Imports use the port of unlading and exports the port of export. |
| `hs6` | string | The six-digit Harmonized System product code. |
| `country_code` | string | The four-digit Census Schedule C code of the partner country. |
| `port_name` | string | The port name from Census Schedule D. Empty for codes that Schedule D does not list, such as low-value and mail estimates. |
| `port_state` | string | The two-letter state or territory at the end of the port name, or of the district name where the port name has none. |
| `district_code` | string | The two-digit customs district, the first two digits of the port code. |
| `district_name` | string | The customs district name from Census Schedule D. |
| `port_latitude` | number | Latitude of the port city in decimal degrees, from the Census Gazetteer place with the same city name and state. Empty where no entry matches. |
| `port_longitude` | number | Longitude of the port city in decimal degrees, from the Census Gazetteer place with the same city name and state. Empty where no entry matches. |
| `country_name` | string | The partner country name from Census Schedule C. |
| `country_iso2` | string | The two-letter ISO code of the partner country from Census Schedule C. |
| `country_region` | string | The world region of the partner country, read from the first digit of the Schedule C code. |
| `hs6_description` | string | The description of the six-digit product code. |
| `hs4` | string | The four-digit Harmonized System heading of the product. |
| `hs4_description` | string | The description of the four-digit heading. |
| `hs2` | string | The two-digit Harmonized System chapter of the product. |
| `hs2_description` | string | The description of the two-digit chapter. |
| `product_group` | string | A short readable product group assigned from the chapter number. |
| `value_usd` | integer | Trade value in the month in US dollars. General imports value for imports and total exports value for exports. |
| `air_value_usd` | integer | The part of the value that moved by air, in US dollars. |
| `vessel_value_usd` | integer | The part of the value that moved by vessel, in US dollars. |
| `containerized_vessel_value_usd` | integer | The part of the vessel value that moved in containers, in US dollars. |
| `other_mode_value_usd` | integer | Value that moved by neither air nor vessel, mostly truck, rail and pipeline, in US dollars. |
| `air_weight_kg` | integer | Shipping weight moved by air, in kilograms. |
| `vessel_weight_kg` | integer | Shipping weight moved by vessel, in kilograms. |
| `containerized_vessel_weight_kg` | integer | Shipping weight moved by vessel in containers, in kilograms. |
| `ytd_value_usd` | integer | Year-to-date trade value through the month in US dollars, as the publisher reports it. |
| `unit_value_usd_per_kg` | number | Air and vessel value divided by air and vessel shipping weight, in US dollars per kilogram. Empty where no weight is reported. |
| `prior_year_value_usd` | integer | Trade value of the same port, product, country and direction in the same month one year earlier. Empty where that month has no row or is outside the table. |
| `yoy_change_pct` | number | Percent change of the value against the same month one year earlier. |
| `port_product_value_usd` | integer | The port's value in the product that month across all partner countries, in US dollars. |
| `national_product_value_usd` | integer | The value of the product that month across all US ports and partner countries, in US dollars. |
| `port_share_of_national_pct` | decimal | The port's share of national trade in the product that month, in percent. |
| `tariff_lines` | integer | The number of eight-digit tariff lines under the product in the current US Harmonized Tariff Schedule. |
| `tariff_free_lines` | integer | How many of those tariff lines have a general duty rate of Free. |
| `tariff_specific_duty_lines` | integer | How many of those tariff lines charge a duty per unit or per weight, alone or with a percent. |
| `tariff_ad_valorem_avg_pct` | decimal | The simple average of the percent part of the general duty rate across the tariff lines that have one, counting Free as zero. |
| `tariff_ad_valorem_min_pct` | decimal | The lowest percent part of the general duty rate among the tariff lines. |
| `tariff_ad_valorem_max_pct` | decimal | The highest percent part of the general duty rate among the tariff lines. |
| `tariff_rate_text` | string | The general duty rate as written when every tariff line under the product shares one rate. |

## Table: source_port_trade_2024h1

- Table id: `78d0fa26-6145-4bdc-bc7c-e4cd00864daf`
- Slug: `source-port-trade-2024h1`
- Immutable version: `b7b1f6b7-a336-5843-9a4f-4a90566ca3c4`
- Schema: `GET https://mostlyright.md/api/v2/public/tables/78d0fa26-6145-4bdc-bc7c-e4cd00864daf/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/78d0fa26-6145-4bdc-bc7c-e4cd00864daf/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/78d0fa26-6145-4bdc-bc7c-e4cd00864daf/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/78d0fa26-6145-4bdc-bc7c-e4cd00864daf/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (13)

| Column | Type | Description |
| --- | --- | --- |
| `direction` | string | Whether the row is an import into or an export from the United States. |
| `month` | date | The statistical month, written as its first day. |
| `port_code` | string | The four-digit Census Schedule D code of the US port. |
| `hs6` | string | The six-digit Harmonized System product code. |
| `country_code` | string | The four-digit Census Schedule C code of the partner country. |
| `value_usd` | integer | Trade value in the month in US dollars. |
| `air_value_usd` | integer | The part of the value that moved by air, in US dollars. |
| `air_weight_kg` | integer | Shipping weight moved by air, in kilograms. |
| `vessel_value_usd` | integer | The part of the value that moved by vessel, in US dollars. |
| `vessel_weight_kg` | integer | Shipping weight moved by vessel, in kilograms. |
| `containerized_vessel_value_usd` | integer | The part of the vessel value that moved in containers, in US dollars. |
| `containerized_vessel_weight_kg` | integer | Shipping weight moved by vessel in containers, in kilograms. |
| `ytd_value_usd` | integer | Year-to-date trade value through the month in US dollars, as the publisher reports it. |

## Table: source_port_trade_2026h2

- Table id: `3fc4b0df-7730-435b-b256-3b97216b05e7`
- Slug: `source-port-trade-2026h2`
- Immutable version: `81cc4b15-1dcb-5a1e-a6a9-80e4d24e1893`
- Schema: `GET https://mostlyright.md/api/v2/public/tables/3fc4b0df-7730-435b-b256-3b97216b05e7/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/3fc4b0df-7730-435b-b256-3b97216b05e7/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/3fc4b0df-7730-435b-b256-3b97216b05e7/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/3fc4b0df-7730-435b-b256-3b97216b05e7/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (13)

| Column | Type | Description |
| --- | --- | --- |
| `direction` | string | Whether the row is an import into or an export from the United States. |
| `month` | date | The statistical month, written as its first day. |
| `port_code` | string | The four-digit Census Schedule D code of the US port. |
| `hs6` | string | The six-digit Harmonized System product code. |
| `country_code` | string | The four-digit Census Schedule C code of the partner country. |
| `value_usd` | integer | Trade value in the month in US dollars. |
| `air_value_usd` | integer | The part of the value that moved by air, in US dollars. |
| `air_weight_kg` | integer | Shipping weight moved by air, in kilograms. |
| `vessel_value_usd` | integer | The part of the value that moved by vessel, in US dollars. |
| `vessel_weight_kg` | integer | Shipping weight moved by vessel, in kilograms. |
| `containerized_vessel_value_usd` | integer | The part of the vessel value that moved in containers, in US dollars. |
| `containerized_vessel_weight_kg` | integer | Shipping weight moved by vessel in containers, in kilograms. |
| `ytd_value_usd` | integer | Year-to-date trade value through the month in US dollars, as the publisher reports it. |

## Table: source_port_trade_2026h1

- Table id: `f2984c94-9e37-4d3e-b665-9c0ed8701e11`
- Slug: `source-port-trade-2026h1`
- Immutable version: `e0e7c658-d754-55de-9e57-ba3f10f79c0a`
- Schema: `GET https://mostlyright.md/api/v2/public/tables/f2984c94-9e37-4d3e-b665-9c0ed8701e11/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/f2984c94-9e37-4d3e-b665-9c0ed8701e11/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/f2984c94-9e37-4d3e-b665-9c0ed8701e11/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/f2984c94-9e37-4d3e-b665-9c0ed8701e11/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (13)

| Column | Type | Description |
| --- | --- | --- |
| `direction` | string | Whether the row is an import into or an export from the United States. |
| `month` | date | The statistical month, written as its first day. |
| `port_code` | string | The four-digit Census Schedule D code of the US port. |
| `hs6` | string | The six-digit Harmonized System product code. |
| `country_code` | string | The four-digit Census Schedule C code of the partner country. |
| `value_usd` | integer | Trade value in the month in US dollars. |
| `air_value_usd` | integer | The part of the value that moved by air, in US dollars. |
| `air_weight_kg` | integer | Shipping weight moved by air, in kilograms. |
| `vessel_value_usd` | integer | The part of the value that moved by vessel, in US dollars. |
| `vessel_weight_kg` | integer | Shipping weight moved by vessel, in kilograms. |
| `containerized_vessel_value_usd` | integer | The part of the vessel value that moved in containers, in US dollars. |
| `containerized_vessel_weight_kg` | integer | Shipping weight moved by vessel in containers, in kilograms. |
| `ytd_value_usd` | integer | Year-to-date trade value through the month in US dollars, as the publisher reports it. |

## Table: source_port_trade_2024h2

- Table id: `74a2f19d-d2d8-482c-854a-68a8b283cb33`
- Slug: `source-port-trade-2024h2`
- Immutable version: `11b93b98-850d-5ce7-976d-29beb31c2d43`
- Schema: `GET https://mostlyright.md/api/v2/public/tables/74a2f19d-d2d8-482c-854a-68a8b283cb33/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/74a2f19d-d2d8-482c-854a-68a8b283cb33/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/74a2f19d-d2d8-482c-854a-68a8b283cb33/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/74a2f19d-d2d8-482c-854a-68a8b283cb33/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (13)

| Column | Type | Description |
| --- | --- | --- |
| `direction` | string | Whether the row is an import into or an export from the United States. |
| `month` | date | The statistical month, written as its first day. |
| `port_code` | string | The four-digit Census Schedule D code of the US port. |
| `hs6` | string | The six-digit Harmonized System product code. |
| `country_code` | string | The four-digit Census Schedule C code of the partner country. |
| `value_usd` | integer | Trade value in the month in US dollars. |
| `air_value_usd` | integer | The part of the value that moved by air, in US dollars. |
| `air_weight_kg` | integer | Shipping weight moved by air, in kilograms. |
| `vessel_value_usd` | integer | The part of the value that moved by vessel, in US dollars. |
| `vessel_weight_kg` | integer | Shipping weight moved by vessel, in kilograms. |
| `containerized_vessel_value_usd` | integer | The part of the vessel value that moved in containers, in US dollars. |
| `containerized_vessel_weight_kg` | integer | Shipping weight moved by vessel in containers, in kilograms. |
| `ytd_value_usd` | integer | Year-to-date trade value through the month in US dollars, as the publisher reports it. |

## Citing this dataset

Cite the dataset by name and canonical URL (https://mostlyright.md/datasets/us-imports-and-exports-by-port-and-product-2024-2026), the table, and the immutable `version_id` the rows came from. A query response carries `table.version_id` and `table.content_digest`; a download carries a strong ETag and a `Content-Digest` header.
