# Global Import-Export Product Overview (1995-2024)

An HS6 product overview combining its description and classification with recent trade values, growth, price observations, trading-partner counts, and coverage indicators.

## What one row represents
one HS6 product code

## Included measures and context
- Product description and classification
- Recent trade value, growth, concentration, and volatility
- Price, route-risk, data-freshness, and coverage measures where available

## Metric notes
- HS6 codes identify products at the six-digit Harmonized System level.
- CAGR is the compound annual growth rate across a multi-year period.
- HHI summarizes concentration; higher values indicate activity is concentrated among fewer participants.
- Year-over-year growth compares a value with the previous year; a negative percentage indicates a decline.
- Fields marked USD are monetary values denominated in US dollars.
- Count fields report the number of items named in the field, such as products, partners, or routes.
- Values ending in pct are percentages.

## Fields
Column names are shown exactly as they appear in the Parquet file. The schema lists the same fields, and the sample file shows example values.

- `hs_code` — `string`
- `hs_description` — `string`
- `hs_chapter` — `string`
- `hs_heading` — `string`
- `substitution_elasticity` — `float64`
- `price_range_label` — `string`
- `trade_type_label` — `string`
- `first_data_year` — `uint16`
- `latest_data_year` — `uint16`
- `years_with_data` — `uint16`
- `latest_trade_usd` — `float64`
- `trade_avg_3y_usd` — `float64`
- `trade_avg_5y_usd` — `float64`
- `trade_avg_10y_usd` — `float64`
- `historical_peak_usd` — `float64`
- `historical_peak_year` — `uint16`
- `latest_below_peak_pct` — `float64`
- `yoy_growth_latest_pct` — `float64`
- `cagr_3y_latest_pct` — `float64`
- `cagr_5y_calculated_pct` — `float64`
- `cagr_10y_calculated_pct` — `float64`
- `positive_growth_year_share_pct` — `float64`
- `trend_acceleration_pct` — `float64`
- `trend_label` — `string`
- `exporter_concentration_hhi` — `float64`
- `importer_concentration_hhi` — `float64`
- `volatility_score` — `float64`
- `active_importer_count` — `uint16`
- `active_exporter_count` — `uint16`
- `active_corridor_count` — `uint32`
- `latest_price_year` — `uint16`
- `median_price_across_exporters_usd_per_ton` — `float64`
- `priced_exporter_count` — `uint16`
- `monitored_risk_lane_count` — `uint32`
- `watch_lane_count` — `uint32`
- `high_attention_lane_count` — `uint32`
- `critical_attention_lane_count` — `uint32`
- `data_freshness_years` — `uint8`
- `coverage_score` — `float64`
- `confidence_label` — `string`
- `data_status` — `string`
- `refreshed_at` — `timestamp[ms, tz=UTC]`

## Coverage and size
- Coverage: 1995-2024 annual observations where available
- Records: 5,386
- Parquet file size: 1 MB
- Release: 1.0.0
- SHA-256: `d0d827146d7f1ddd3d0e6c2ec53461d4bfcc579790eb84a16f546b47dd691c90`

## Files
- `data.parquet` — complete dataset
- `manifest.json` — dataset description, coverage, record count, and download details
- `schema.json` — field names, row definition, included measures, and metric notes
- `sample.json` — example records
- `README.md` — these notes

## Read the Parquet file with Python
```python
import pandas as pd

data = pd.read_parquet("data.parquet")
print(data.head())
```

Install `pandas` and `pyarrow` if they are not already available: `python -m pip install pandas pyarrow`.

## Sources and related files
- OECD BIMTS HS2017-6D
- Dataset page: https://www.yugalinks.com/datasets/import-export/import-export-product-overview-v1/
- Original dataset record: https://huggingface.co/datasets/yugalinks/import-export-product-overview-v1