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

Annual unit values, quantities, and market price comparisons for exports from USA, Puerto Rico and US Virgin Islands across partners and HS6 products.

## 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: 2,013,071
- Parquet file size: 123 MB
- SHA-256: `ea097be585e7b57424b3adfa12ebb0d9fd45c1ce4bfeaa0c6723ba6adbde6726`

## 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/