Household Consumption by FunctionConsommation des ménages par fonction

Consommation des ménages par fonctionHousehold Consumption by Function

APIExecutable4/7Query nowOpen workbench Subscribe🇫🇷France

Annual dataset published by INSEE, the French national statistics institute, providing figures on households' final actual consumption broken down by function of consumption according to the COICOP classification. It covers national-level expenditure across categories such as food, housing, transport, and other goods and services. The data supports economic analysis of household spending patterns and is commonly used for national accounts, budget studies, and comparative research on consumption trends over time in France.Données annuelles de consommation finale effective des ménages par fonction de consommation (nomenclature COICOP).

Filter by dimension Run verified request Read the docs

Data schema (15 fields)

Click a field to see example values.

Field	Type	Description
TRANSFORMATION	string	Code indicating the data transformation applied (e.g. level, growth rate, index).Code indicating the data transformation applied (e.g. level, growth rate, index).
PRICES	string	Code indicating valuation basis, such as current or constant prices.Code indicating valuation basis, such as current or constant prices.
EXPENDITURE	string	COICOP consumption function code for the expenditure category.COICOP consumption function code for the expenditure category.
STO	string	Code identifying the statistical transaction type (e.g. final consumption expenditure).Code identifying the statistical transaction type (e.g. final consumption expenditure).
GEOTerritory	string	—
ACCOUNTING_ENTRYAccounting entry	string	Code indicating the accounting entry side, such as debit or credit.Code indicating the accounting entry side, such as debit or credit.
PRODUCT	string	Code identifying the product classification, if applicable.Code identifying the product classification, if applicable.
FREQFrequency	string	Code indicating the observation frequency, e.g. annual.Code indicating the observation frequency, e.g. annual.
REF_SECTORRef sector	string	Code identifying the institutional sector referenced by the data.Code identifying the institutional sector referenced by the data.
TIME_PERIODPeriod	string	Year or period to which the observation refers.Year or period to which the observation refers.
COUNTERPART_AREACounterpart area	string	Code identifying the counterpart geographic area or reference zone.Code identifying the counterpart geographic area or reference zone.
UNIT_MEASUREUnit	string	Code identifying the unit of measurement used for the value.Code identifying the unit of measurement used for the value.
INSTR_ASSETInstr asset	string	Code identifying the financial instrument or asset type, if applicable.Code identifying the financial instrument or asset type, if applicable.
ACTIVITY	string	Code identifying the economic activity classification, if applicable.Code identifying the economic activity classification, if applicable.
OBS_VALUE_NIVEAUValue	number	Numeric value of the household consumption observation.Numeric value of the household consumption observation.

Schema captured from melodi 4 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: P31

{
  "GEO": "2025-FRANCE-F",
  "STO": "P31",
  "FREQ": "A",
  "PRICES": "V",
  "PRODUCT": "_T",
  "ACTIVITY": "_T",
  "REF_SECTOR": "S14",
  "EXPENDITURE": "CP141",
  "INSTR_ASSET": "_Z",
  "TIME_PERIOD": "2018",
  "UNIT_MEASURE": "XDC",
  "TRANSFORMATION": "N",
  "ACCOUNTING_ENTRY": "D",
  "COUNTERPART_AREA": "W2",
  "OBS_VALUE_NIVEAU": null
}

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

{
  "GEO": "2025-FRANCE-F",
  "STO": "P31",
  "FREQ": "A",
  "PRICES": "V",
  "PRODUCT": "_T",
  "ACTIVITY": "_T",
  "REF_SECTOR": "S14",
  "EXPENDITURE": "CP141",
  "INSTR_ASSET": "_Z",
  "TIME_PERIOD": "2004",
  "UNIT_MEASURE": "XDC",
  "TRANSFORMATION": "N",
  "ACCOUNTING_ENTRY": "D",
  "COUNTERPART_AREA": "W2",
  "OBS_VALUE_NIVEAU": null
}

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

{
  "GEO": "2025-FRANCE-F",
  "STO": "P31",
  "FREQ": "A",
  "PRICES": "Y",
  "PRODUCT": "_T",
  "ACTIVITY": "_T",
  "REF_SECTOR": "S14",
  "EXPENDITURE": "CP022",
  "INSTR_ASSET": "_Z",
  "TIME_PERIOD": "2010",
  "UNIT_MEASURE": "XDC",
  "TRANSFORMATION": "N",
  "ACCOUNTING_ENTRY": "D",
  "COUNTERPART_AREA": "W2",
  "OBS_VALUE_NIVEAU": null
}

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

{
  "GEO": "2025-FRANCE-F",
  "STO": "P31",
  "FREQ": "A",
  "PRICES": "Y",
  "PRODUCT": "_T",
  "ACTIVITY": "_T",
  "REF_SECTOR": "S14",
  "EXPENDITURE": "CP141",
  "INSTR_ASSET": "_Z",
  "TIME_PERIOD": "1966",
  "UNIT_MEASURE": "XDC",
  "TRANSFORMATION": "N",
  "ACCOUNTING_ENTRY": "D",
  "COUNTERPART_AREA": "W2",
  "OBS_VALUE_NIVEAU": null
}

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

{
  "GEO": "2025-FRANCE-F",
  "STO": "P31",
  "FREQ": "A",
  "PRICES": "V",
  "PRODUCT": "_T",
  "ACTIVITY": "_T",
  "REF_SECTOR": "S14",
  "EXPENDITURE": "CP013",
  "INSTR_ASSET": "_Z",
  "TIME_PERIOD": "1986",
  "UNIT_MEASURE": "XDC",
  "TRANSFORMATION": "N",
  "ACCOUNTING_ENTRY": "D",
  "COUNTERPART_AREA": "W2",
  "OBS_VALUE_NIVEAU": null
}

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_COICOP

Query examples

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