Foreign TradeÉchanges extérieurs

Échanges extérieursForeign Trade

APIExecutable4/7Query nowOpen workbench Subscribe🇫🇷France

Annual data on France's foreign trade, covering imports, exports, trade balance, and breakdowns by geographic zone. Published by INSEE, the French national statistics institute, as part of its national accounts data catalogue, the dataset provides a national-level view of external trade flows useful for economic analysis and monitoring trends in France's trade relationships with other countries and regions over time.Données annuelles d’échanges extérieurs de la France (importations, exportations, solde, zones géographiques).

Filter by dimension Run verified request Read the docs

Data schema (12 fields)

Click a field to see example values.

Field	Type	Description
TRANSFORMATION	string	Code indicating the data transformation applied (e.g. raw, index).Code indicating the data transformation applied (e.g. raw, index).
GEOTerritory	string	Geographic reference area code for the reporting territory.Geographic reference area code for the reporting territory.
ACCOUNTING_ENTRYAccounting entry	string	Code for the accounting entry type (e.g. credit, debit, balance).Code for the accounting entry type (e.g. credit, debit, balance).
PRICES	string	Code indicating price valuation basis (e.g. current or constant prices).Code indicating price valuation basis (e.g. current or constant prices).
PRODUCT	string	Classification code identifying the product or activity category.Classification code identifying the product or activity category.
FREQFrequency	string	Code for the data frequency, here annual.Code for the data frequency, here annual.
REF_SECTORRef sector	string	Code identifying the institutional reference sector.Code identifying the institutional reference sector.
TIME_PERIODPeriod	string	Year to which the observation refers.Year to which the observation refers.
COUNTERPART_AREACounterpart area	string	Code for the counterpart geographic area in the trade flow.Code for the counterpart geographic area in the trade flow.
UNIT_MEASUREUnit	string	Code for the unit of measurement of the observed value.Code for the unit of measurement of the observed value.
STO	string	Code identifying the statistical transaction type.Code identifying the statistical transaction type.
OBS_VALUE_NIVEAUValue	number	Observed numeric value (level) for the given indicator.Observed numeric value (level) for the given indicator.

Schema captured from melodi 6 hours ago.

Query the data

Pick columns and a sort, then fetch a live preview straight from the source. Choose an API-filterable column (marked ▾) under “Where” to pick from its list of values.

Where=

Sort by

Sample data (5 records)

Record 1GEO: 2025-FRANCE-F · STO: _TC

{
  "GEO": "2025-FRANCE-F",
  "STO": "_TC",
  "FREQ": "A",
  "PRICES": "V",
  "PRODUCT": "CPA_J",
  "REF_SECTOR": "S1",
  "TIME_PERIOD": "1974",
  "UNIT_MEASURE": "PT",
  "TRANSFORMATION": "N",
  "ACCOUNTING_ENTRY": "_Z",
  "COUNTERPART_AREA": "W0",
  "OBS_VALUE_NIVEAU": 54.408
}

Record 2GEO: 2025-FRANCE-F · STO: _TC

{
  "GEO": "2025-FRANCE-F",
  "STO": "_TC",
  "FREQ": "A",
  "PRICES": "V",
  "PRODUCT": "CPA_J",
  "REF_SECTOR": "S1",
  "TIME_PERIOD": "1973",
  "UNIT_MEASURE": "PT",
  "TRANSFORMATION": "N",
  "ACCOUNTING_ENTRY": "_Z",
  "COUNTERPART_AREA": "W0",
  "OBS_VALUE_NIVEAU": 51.774
}

Record 3GEO: 2025-FRANCE-F · STO: _TC

{
  "GEO": "2025-FRANCE-F",
  "STO": "_TC",
  "FREQ": "A",
  "PRICES": "V",
  "PRODUCT": "CPA_J",
  "REF_SECTOR": "S1",
  "TIME_PERIOD": "1972",
  "UNIT_MEASURE": "PT",
  "TRANSFORMATION": "N",
  "ACCOUNTING_ENTRY": "_Z",
  "COUNTERPART_AREA": "W0",
  "OBS_VALUE_NIVEAU": 51.841
}

Record 4GEO: 2025-FRANCE-F · STO: _TC

{
  "GEO": "2025-FRANCE-F",
  "STO": "_TC",
  "FREQ": "A",
  "PRICES": "V",
  "PRODUCT": "CPA_M_N",
  "REF_SECTOR": "S1",
  "TIME_PERIOD": "2019",
  "UNIT_MEASURE": "PT",
  "TRANSFORMATION": "N",
  "ACCOUNTING_ENTRY": "_Z",
  "COUNTERPART_AREA": "W0",
  "OBS_VALUE_NIVEAU": 115.951
}

Record 5GEO: 2025-FRANCE-F · STO: P6

{
  "GEO": "2025-FRANCE-F",
  "STO": "P6",
  "FREQ": "A",
  "PRICES": "V",
  "PRODUCT": "CPA_C13T15",
  "REF_SECTOR": "S1",
  "TIME_PERIOD": "1985",
  "UNIT_MEASURE": "XDC",
  "TRANSFORMATION": "N",
  "ACCOUNTING_ENTRY": "D",
  "COUNTERPART_AREA": "W1",
  "OBS_VALUE_NIVEAU": 7565
}

Live sample captured at profiling time — values may have changed upstream.

Verification Status

Using the API

Configuration

Base URL: https://api.insee.fr/melodi/data/DD_CNA_ECH_EXT

Query examples

curl -s 'https://api.insee.fr/melodi/data/DD_CNA_ECH_EXT?maxResult=20' -H 'Accept: application/json'

First 20 observations (dimensions + measures) as JSON.

Full API documentation ↗

Machine-readable & source

JSON

Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.