1.3 GB across 33 parts, newest sealed 13 November 2026 at 00:10 UTC. The first build wrote 33 parts and 26.7M rows.
All 3 checks passed.
One row per key passed.
Enough rows passed.
Share in range passed.
direction
string
Whether the row is an import into or an export from the United States.
import54%
export46%
Valid
26,653,212 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid
month
date
The statistical month, written as its first day.
2024-01-012026-07-01
per quarter
Valid
26,653,212 · 100%
Missing
0 · 0%
Distinct
33 · 0% of valid
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.
410 distinct values, no chart
Valid
26,653,212 · 100%
Missing
0 · 0%
Distinct
410 · 0% of valid
hs6
string
The six-digit Harmonized System product code.
5,621 distinct values, no chart
Valid
26,653,212 · 100%
Missing
0 · 0%
Distinct
5,621 · 0% of valid
country_code
string
The four-digit Census Schedule C code of the partner country.
233 distinct values, no chart
Valid
26,653,212 · 100%
Missing
0 · 0%
Distinct
233 · 0% of valid
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.
CLEVELAND, OH6%
NEW ORLEANS, LA5%
NEWARK, NJ5%
Other (387)
Valid
26,481,406 · 99.4%
Missing
171,806 · 0.6%
Missing over time
Distinct
399 · 0% of valid
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.
CA14%
NY11%
FL10%
Other (39)
Valid
26,346,609 · 98.8%
Missing
306,603 · 1.2%
Missing over time
Distinct
51 · 0% of valid
district_code
string
The two-digit customs district, the first two digits of the port code.
46 distinct values, no chart
Valid
26,653,212 · 100%
Missing
0 · 0%
Distinct
46 · 0% of valid
district_name
string
The customs district name from Census Schedule D.
NEW YORK CITY, NY13%
LOS ANGELES, CA9%
MIAMI, FL9%
Other (32)
Valid
26,481,406 · 99.4%
Missing
171,806 · 0.6%
Missing over time
Distinct
44 · 0% of valid
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.
297 distinct values, no chart
Valid
22,737,851 · 85.3%
Missing
3,915,361 · 14.7%
Missing over time
Distinct
297 · 0% of valid
Min
17.999711000000001
25%
32.018042999999999
Median
37.727238999999997
75%
41.478462
Max
64.836530999999994
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.
297 distinct values, no chart
Valid
22,737,851 · 85.3%
Missing
3,915,361 · 14.7%
Missing over time
Distinct
297 · 0% of valid
Min
-156.46561600000001
25%
-100.881851
Median
-84.422674999999998
75%
-79.972896000000006
Max
-65.657625999999993
country_name
string
The partner country name from Census Schedule C.
China8%
Canada8%
Germany (Federal Republic of Germany)5%
Other (221)
Valid
26,653,212 · 100%
Missing
0 · 0%
Distinct
233 · 0% of valid
country_iso2
string
The two-letter ISO code of the partner country from Census Schedule C.
233 distinct values, no chart
Valid
26,653,212 · 100%
Missing
0 · 0%
Distinct
233 · 0% of valid
country_region
string
The world region of the partner country, read from the first digit of the Schedule C code.
Asia36%
Europe35%
Central America and Caribbean11%
Valid
26,653,212 · 100%
Missing
0 · 0%
Distinct
7 · 0% of valid
hs6_description
string
The description of the six-digit product code.
5,598 distinct values, no chart
Valid
26,586,212 · 99.7%
Missing
67,000 · 0.3%
Missing over time
Distinct
5,598 · 0% of valid
hs4
string
The four-digit Harmonized System heading of the product.
1,239 distinct values, no chart
Valid
26,653,212 · 100%
Missing
0 · 0%
Distinct
1,239 · 0% of valid
hs4_description
string
The description of the four-digit heading.
1,229 distinct values, no chart
Valid
26,421,226 · 99.1%
Missing
231,986 · 0.9%
Missing over time
Distinct
1,229 · 0% of valid
hs2
string
The two-digit Harmonized System chapter of the product.
98 distinct values, no chart
Valid
26,653,212 · 100%
Missing
0 · 0%
Distinct
98 · 0% of valid
hs2_description
string
The description of the two-digit chapter.
Machinery and mechanical appliances, boilers, nuclear reactors; parts thereof16%
Electrical machinery and equipment and parts thereof; sound recorders and reproducers; television image and sound recorders and reproducers, parts and accessories of such articles13%
Optical, photographic, cinematographic, measuring, checking, medical or surgical instruments and apparatus; parts and accessories7%
Other (86)
Valid
26,653,212 · 100%
Missing
0 · 0%
Distinct
98 · 0% of valid
product_group
string
A short readable product group assigned from the chapter number.
Machinery16%
Electronics and electrical equipment13%
Textiles and apparel11%
Other (11)
Valid
26,653,212 · 100%
Missing
0 · 0%
Distinct
23 · 0% of valid
value_usd
integer
Trade value in the month in US dollars. General imports value for imports and total exports value for exports.
118618149947
Valid
26,653,212 · 100%
Missing
0 · 0%
Distinct
2,212,491 · 8.3% of valid
Min
1
25%
6407
Median
24310
75%
112398
Max
18618149947
air_value_usd
integer
The part of the value that moved by air, in US dollars.
018614745373
Valid
26,653,212 · 100%
Missing
0 · 0%
Distinct
1,063,489 · 4% of valid
Min
0
25%
0
Median
0
75%
13273
Max
18614745373
vessel_value_usd
integer
The part of the value that moved by vessel, in US dollars.
02475307085
Valid
26,653,212 · 100%
Missing
0 · 0%
Distinct
1,436,510 · 5.4% of valid
Min
0
25%
0
Median
0
75%
16082
Max
2475307085
containerized_vessel_value_usd
integer
The part of the vessel value that moved in containers, in US dollars.
01202827501
Valid
26,653,212 · 100%
Missing
0 · 0%
Distinct
1,319,179 · 4.9% of valid
Min
0
25%
0
Median
0
75%
12000
Max
1202827501
other_mode_value_usd
integer
Value that moved by neither air nor vessel, mostly truck, rail and pipeline, in US dollars.
09010187217
Valid
26,653,212 · 100%
Missing
0 · 0%
Distinct
997,847 · 3.7% of valid
Min
0
25%
0
Median
0
75%
0
Max
9010187217
air_weight_kg
integer
Shipping weight moved by air, in kilograms.
018221366
Valid
26,653,212 · 100%
Missing
0 · 0%
Distinct
92,328 · 0.3% of valid
Min
0
25%
0
Median
0
75%
115
Max
18221366
vessel_weight_kg
integer
Shipping weight moved by vessel, in kilograms.
03069659207
Valid
26,653,212 · 100%
Missing
0 · 0%
Distinct
737,842 · 2.8% of valid
Min
0
25%
0
Median
0
75%
1334
Max
3069659207
containerized_vessel_weight_kg
integer
Shipping weight moved by vessel in containers, in kilograms.
0179801045
Valid
26,653,212 · 100%
Missing
0 · 0%
Distinct
647,313 · 2.4% of valid
Min
0
25%
0
Median
0
75%
924
Max
179801045
ytd_value_usd
integer
Year-to-date trade value through the month in US dollars, as the publisher reports it.
256299417690
Valid
26,653,212 · 100%
Missing
0 · 0%
Distinct
4,460,691 · 16.7% of valid
Min
2
25%
19120
Median
98068
75%
530375
Max
56299417690
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.
0.0001606219808121804850000000
Valid
22,522,314 · 84.5%
Missing
4,130,898 · 15.5%
Missing over time
Distinct
14,069,246 · 62.5% of valid
Min
0.00016062198081218048
25%
9.4702338766832028
Median
42.236387782204517
75%
212.4924623115578
Max
50000000
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.
118618149947
Valid
9,565,425 · 35.9%
Missing
17,087,787 · 64.1%
Missing over time
Distinct
1,601,586 · 16.7% of valid
Min
1
25%
11916
Median
49609
75%
221591
Max
18618149947
yoy_change_pct
number
Percent change of the value against the same month one year earlier.
-99.9996607834442765445171.795454547
Valid
9,565,425 · 35.9%
Missing
17,087,787 · 64.1%
Missing over time
Distinct
9,211,046 · 96.3% of valid
Min
-99.99966078344427
25%
-54.157369166170071
Median
0
75%
115.75932394055485
Max
65445171.795454547
port_product_value_usd
integer
The port's value in the product that month across all partner countries, in US dollars.
25129103165676
Valid
26,653,212 · 100%
Missing
0 · 0%
Distinct
1,892,893 · 7.1% of valid
Min
251
25%
79775
Median
483393
75%
2550602
Max
29103165676
national_product_value_usd
integer
The value of the product that month across all US ports and partner countries, in US dollars.
25137734075957
Valid
26,653,212 · 100%
Missing
0 · 0%
Distinct
331,131 · 1.2% of valid
Min
251
25%
10772900
Median
41117780
75%
135834520
Max
37734075957
port_share_of_national_pct
decimal
The port's share of national trade in the product that month, in percent.
0.0000100.0000
Valid
26,653,212 · 100%
Missing
0 · 0%
Distinct
458,473 · 1.7% of valid
Min
0.0000
25%
0.3514
Median
1.5761
75%
5.2784
Max
100.0000
tariff_lines
integer
The number of eight-digit tariff lines under the product in the current US Harmonized Tariff Schedule.
150
Valid
26,413,738 · 99.1%
Missing
239,474 · 0.9%
Missing over time
Distinct
31 · 0% of valid
Min
1
25%
1
Median
2
75%
4
Max
50
tariff_free_lines
integer
How many of those tariff lines have a general duty rate of Free.
031
Valid
26,413,738 · 99.1%
Missing
239,474 · 0.9%
Missing over time
Distinct
14 · 0% of valid
Min
0
25%
0
Median
1
75%
1
Max
31
tariff_specific_duty_lines
integer
How many of those tariff lines charge a duty per unit or per weight, alone or with a percent.
026
Valid
26,413,738 · 99.1%
Missing
239,474 · 0.9%
Missing over time
Distinct
17 · 0% of valid
Min
0
25%
0
Median
0
75%
0
Max
26
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.
0.000350.000
Valid
25,969,800 · 97.4%
Missing
683,412 · 2.6%
Missing over time
Distinct
647 · 0% of valid
Min
0.000
25%
0.000
Median
2.000
75%
4.500
Max
350.000
tariff_ad_valorem_min_pct
decimal
The lowest percent part of the general duty rate among the tariff lines.
0.000350.000
Valid
25,969,800 · 97.4%
Missing
683,412 · 2.6%
Missing over time
Distinct
155 · 0% of valid
Min
0.000
25%
0.000
Median
0.000
75%
3.100
Max
350.000
tariff_ad_valorem_max_pct
decimal
The highest percent part of the general duty rate among the tariff lines.
0.000350.000
Valid
25,969,800 · 97.4%
Missing
683,412 · 2.6%
Missing over time
Distinct
197 · 0% of valid
Min
0.000
25%
0.000
Median
2.700
75%
6.000
Max
350.000
tariff_rate_text
string
The general duty rate as written when every tariff line under the product shares one rate.
268 distinct values, no chart
Valid
26,413,738 · 99.1%
Missing
239,474 · 0.9%
Missing over time
Distinct
268 · 0% of valid
Table profile
Profile of the served version, all rows, computed 16 Nov 2026, 17:17 UTC
Warning
Freshness
Latest event 73 d before this version
Warning
Gaps
107 empty weeks, 8 Jan 2024 to 22 Jan 2024, 5 Feb 2024 to 19 Feb 2024, 4 Mar 2024 to 25 Mar 2024 and 29 more
Warning
Anomalies
Spike on 26 Feb 2024, 822,740 rows against about 0, and 19 more
Passed
Unique keys
Every direction · month · port_code · hs6 · country_code is unique
Rows per week
Rows per 2 weeks by direction · port_code · hs6 · country_code, 10 of 3,776,228