Household consumption by productConsommation des ménages par produit

Consommation des ménages par produitHousehold consumption by product

APIExecutable4/7Query nowOpen workbench Subscribe🇫🇷France

This API, published by INSEE (French national statistics institute), provides annual data on the actual final consumption expenditure of households, broken down by product category and by durability (durable, semi-durable, and non-durable goods). The data are part of France's national accounts framework and allow users to track how household spending is distributed across different types of goods and services over time. It is freely accessible without authentication and covers the national territory of France.Données annuelles de consommation finale effective des ménages par produit et par durabilité.

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 for the data transformation applied, e.g. growth rate or level.Code for the data transformation applied, e.g. growth rate or level.
GEOTerritory	string	Geographic area code for the observation.Geographic area code for the observation.
ACCOUNTING_ENTRYAccounting entry	string	Code indicating the accounting entry type, e.g. use or resource.Code indicating the accounting entry type, e.g. use or resource.
PRICES	string	Code for the price valuation used, e.g. current or constant prices.Code for the price valuation used, e.g. current or constant prices.
PRODUCT	string	Product classification code (CPA) for the consumption category.Product classification code (CPA) for the consumption category.
FREQFrequency	string	Frequency of the observation, e.g. annual.Frequency of the observation, e.g. annual.
REF_SECTORRef sector	string	Code identifying the reference institutional sector, e.g. households.Code identifying the reference institutional sector, e.g. households.
TIME_PERIODPeriod	string	Reference year of the observation.Reference year of the observation.
COUNTERPART_AREACounterpart area	string	Code identifying the counterpart geographic area.Code identifying the counterpart geographic area.
UNIT_MEASUREUnit	string	Code for the unit of measurement of the value.Code for the unit of measurement of the value.
STO	string	Code identifying the statistical transaction type, e.g. actual consumption.Code identifying the statistical transaction type, e.g. actual consumption.
OBS_VALUE_NIVEAUValue	number	Observed value of the indicator at level.Observed value of the indicator at level.

Schema captured from melodi 7 days 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: P4

{
  "GEO": "2025-FRANCE-F",
  "STO": "P4",
  "FREQ": "A",
  "PRICES": "D",
  "PRODUCT": "CPA_I56",
  "REF_SECTOR": "S14B",
  "TIME_PERIOD": "2012",
  "UNIT_MEASURE": "PT",
  "TRANSFORMATION": "GY",
  "ACCOUNTING_ENTRY": "D",
  "COUNTERPART_AREA": "W0",
  "OBS_VALUE_NIVEAU": 2.851
}

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

{
  "GEO": "2025-FRANCE-F",
  "STO": "P4",
  "FREQ": "A",
  "PRICES": "D",
  "PRODUCT": "CPA_J59",
  "REF_SECTOR": "S14B",
  "TIME_PERIOD": "2004",
  "UNIT_MEASURE": "XDC",
  "TRANSFORMATION": "N",
  "ACCOUNTING_ENTRY": "D",
  "COUNTERPART_AREA": "W0",
  "OBS_VALUE_NIVEAU": 131.792
}

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

{
  "GEO": "2025-FRANCE-F",
  "STO": "P4",
  "FREQ": "A",
  "PRICES": "D",
  "PRODUCT": "CPA_J59",
  "REF_SECTOR": "S14B",
  "TIME_PERIOD": "2012",
  "UNIT_MEASURE": "IX",
  "TRANSFORMATION": "GY_IX",
  "ACCOUNTING_ENTRY": "D",
  "COUNTERPART_AREA": "W0",
  "OBS_VALUE_NIVEAU": 99.957
}

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

{
  "GEO": "2025-FRANCE-F",
  "STO": "P4",
  "FREQ": "A",
  "PRICES": "V",
  "PRODUCT": "CPA_I56",
  "REF_SECTOR": "S14B",
  "TIME_PERIOD": "2006",
  "UNIT_MEASURE": "PT",
  "TRANSFORMATION": "GY",
  "ACCOUNTING_ENTRY": "D",
  "COUNTERPART_AREA": "W0",
  "OBS_VALUE_NIVEAU": 4.702
}

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

{
  "GEO": "2025-FRANCE-F",
  "STO": "P4",
  "FREQ": "A",
  "PRICES": "V",
  "PRODUCT": "CPA_I56",
  "REF_SECTOR": "S14B",
  "TIME_PERIOD": "2005",
  "UNIT_MEASURE": "XDC",
  "TRANSFORMATION": "N",
  "ACCOUNTING_ENTRY": "D",
  "COUNTERPART_AREA": "W0",
  "OBS_VALUE_NIVEAU": 48090.6
}

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_CONSO_MENAGES_PRODUITS

Query examples

curl -s 'https://api.insee.fr/melodi/data/DD_CNA_CONSO_MENAGES_PRODUITS?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.