BACI International Trade Database (HS 2017)

Bilateral trade flows at the 6-digit HS 2017 product level from the BACI database, published by CEPII and distributed by the Observatory of Economic Complexity (OEC). One row per year × exporter × importer × HS product. Covers ~200 countries. Values in USD; quantities in metric tons.

trade global trade/global/baci-hs17 trade baci hs17 bilateral exports imports products oec

View sample data (table) — free preview, same rows as GET /api/datasets/baci-hs17/sample

Catalog

Browse and search all available datasets.

Catalog — browse all datasets
GET /api/catalog — catalog in JSON
GET /api/catalog?q=… — search the catalog

Dataset API

Endpoints for this dataset — schema, filter values, preview, and querying.

GET /api/datasets/baci-hs17 — schema and filters
Sample preview (table) · GET /api/datasets/baci-hs17/sample — free sample (up to 100 rows)
GET /api/datasets/baci-hs17/members/{col} — valid values for a filterable column
GET /api/datasets/baci-hs17/query — query with filters (API key required)

Access

BotMarket is free — query this dataset at no cost.

Get your free API key — one per email, no payment required
GET /api/datasets/baci-hs17/query — query with your key as Bearer token

Source

Name: Observatory of Economic Complexity (OEC)
URL: https://oec.world/en/resources/datasets
License: CC BY 4.0

Size and Format

Rows: 79,258,376
Columns: 12
Size (bytes): 942,980,265
Formats: parquet, csv

Access

Queries: Free
Max rows per query: 1000
Free sample: Yes

Temporal Coverage

end: 2024
start: 1995
frequency: annual

Geographic Coverage

level: country
coding: ISO Alpha-3 (lowercase)
region: Global (~200 countries)

Query Filters

Columns you can use as query params in GET /api/datasets/baci-hs17/query.

year Members (JSON)
exporter_id Members (JSON)
importer_id Members (JSON)
hs_code Members (JSON)

Schema (Columns)

Column	Type	Description	Filterable
`year`	integer	Year of the trade flow	Yes
`exporter_id`	string	Exporting country (ISO Alpha-3, lowercase)	Yes
`exporter_name`	string	Exporting country name	No
`importer_id`	string	Importing country (ISO Alpha-3, lowercase)	Yes
`importer_name`	string	Importing country name	No
`hs_code`	string	HS 2017 product code (6-digit, zero-padded)	Yes
`product_name`	string	HS product description	No
`hs_revision`	integer	HS classification revision year	No
`value`	number	Trade value in USD	No
`quantity`	number	Trade quantity	No
`unit_abbrevation`	string	Unit of quantity (abbreviation)	No
`unit_name`	string	Unit of quantity (full name)	No

← Back to catalog