# USA, Puerto Rico and US Virgin Islands price trends by partner and HS6

Observed price trends for HS6 products imported by USA, Puerto Rico and US Virgin Islands across exporter partners.

## What one row represents
one year, exporter, importer, and HS6 product lane

## Included data
- Unit values and quantities
- Trade value and market price comparisons
- Price trend or position measures

## Metric notes
- USD fields are monetary values denominated in US dollars.
- Country fields use three-letter ISO 3166-1 country codes.
- HS6 identifies a product at the six-digit Harmonized System level.
- Growth percentages compare reported values across the relevant periods; calculated and projected fields are identified in the schema.

## Fields
- `year` — `UInt16`
- `exporter_iso3` — `FixedString(3)`
- `importer_iso3` — `FixedString(3)`
- `hs_code` — `FixedString(6)`
- `unit_value_usd_per_ton` — `Float64`
- `quantity_metric_tons` — `Float64`
- `trade_value_usd` — `Float64`
- `market_median_price_usd_per_ton` — `Float64`
- `market_min_price_usd_per_ton` — `Float64`
- `market_max_price_usd_per_ton` — `Float64`
- `num_price_competitors` — `UInt32`
- `price_vs_median_pct` — `Nullable(Float64)`
- `price_position` — `Nullable(String)`

## Coverage and size
- Coverage: 1995-2024 where reported
- Records: 984,433
- Parquet file size: 48 MB
- SHA-256: `71078b8bbbd43a99d4dd841fb4113e2839f0708041684da4e729c26c1959f1bb`

## Files
- `data.parquet` - complete dataset
- `manifest.json` - release metadata and checksums
- `schema.json` - field names, types, and metric notes
- `sample.json` - example records
- `README.md` - dataset documentation

## Read with Python
```python
import pandas as pd
data = pd.read_parquet("data.parquet")
print(data.head())
```

## Sources
- OECD Balanced International Merchandise Trade Statistics (BIMTS)
- Yugalinks calculated price measures from reported trade values and quantities
- OECD Terms & Conditions: https://www.oecd.org/termsandconditions/