About this Dataset

Annual Household Final Consumption Expenditure By Purpose (COICOP 2018) (for 'Developer API')

This dataset provides the whole set of OECD annual households final consumption expenditure data (COICOP 2018) and is recommended for users who wish to query a large amount of data. It is not designed for visualising results using the Table and Chart buttons. To access the ‘Developer API query builder’, click on the ‘Developer API’ button above.

The application programming interface (API), based on the SDMX standard, allows a developer to access the data using simple RESTful URL and HTTP header options for various choices of response formats including JSON. The query filter is generated according to the current data selection. To change the data selection, use the filters on the left.

To get started check the API documentation
.For any question contact us

Tables

Observations

@oecd.oecd_sdd_nad_dsd_namain10_df_table5a_t500_v2_0.observations

1.75 MB
306,256 rows
21 columns

CREATE TABLE observations (
  "dataflow" VARCHAR,
  "freq" VARCHAR,
  "ref_area" VARCHAR,
  "sector" VARCHAR,
  "counterpart_sector" VARCHAR,
  "transaction" VARCHAR,
  "instr_asset" VARCHAR,
  "activity" VARCHAR,
  "expenditure" VARCHAR,
  "unit_measure" VARCHAR,
  "price_base" VARCHAR,
  "transformation" VARCHAR,
  "table_identifier" VARCHAR,
  "time_period" BIGINT,
  "obs_value" DOUBLE,
  "ref_year_price" VARCHAR,
  "conf_status" BOOLEAN,
  "decimals" BIGINT,
  "obs_status" VARCHAR,
  "unit_mult" BIGINT,
  "currency" VARCHAR
);