# Global Import-Export Route Profile (1995-2024)

Annual bilateral export flows enriched with distance, trade agreements, tariffs, shared ties, and selected exporter and importer economic indicators.

## What one row represents
one exporter-importer pair and calendar year

## Included measures and context
- Export value and growth
- Distance, agreement, and tariff context
- Selected country economic and relationship indicators

## Metric notes
- CAGR is the compound annual growth rate across a multi-year period.
- 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.
- Values ending in pp are percentage-point changes.
- Values ending in pct are percentages.
- Country fields ending in ISO3 use three-letter ISO 3166-1 country codes.

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

- `year` — `uint16`
- `exporter_iso3` — `string`
- `importer_iso3` — `string`
- `export_value_usd` — `float64`
- `yoy_growth_pct` — `float64`
- `cagr_3y_pct` — `float64`
- `distance_km` — `float64`
- `capital_distance_km` — `float64`
- `shares_land_border` — `uint8`
- `shares_official_language` — `uint8`
- `shares_ethnic_language` — `uint8`
- `shared_religion` — `uint8`
- `shared_legal_system` — `uint8`
- `shared_colonial_history` — `uint8`
- `has_fta` — `uint8`
- `rta_coverage_ratio` — `float64`
- `exporter_is_wto` — `uint8`
- `importer_is_wto` — `uint8`
- `exporter_is_eu` — `uint8`
- `importer_is_eu` — `uint8`
- `importer_gdp_million_usd` — `float64`
- `importer_gdp_per_capita_usd` — `float64`
- `importer_population` — `float64`
- `importer_biz_entry_days` — `float64`
- `importer_biz_entry_cost_pct` — `float64`
- `exporter_gdp_million_usd` — `float64`
- `exporter_gdp_per_capita_usd` — `float64`
- `diplomatic_disagreement` — `float64`
- `scientific_collaboration` — `float64`
- `avg_applied_tariff_pct` — `float64`
- `avg_mfn_tariff_pct` — `float64`
- `avg_preferential_tariff_pct` — `float64`
- `tariff_advantage_pp` — `float64`

## Coverage and size
- Coverage: 1995-2024 annual observations where available
- Records: 829,299
- Parquet file size: 23 MB
- Release: 1.0.0
- SHA-256: `52563be91b9dbec8246f7bd168acb8456eb522476942616d3a758a550e7e055f`

## 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-route-profile-v1/
- Original dataset record: https://huggingface.co/datasets/yugalinks/import-export-route-profile-v1