About this Dataset

Quarterly Sector Accounts (for 'Developer API')

This dataset provides the whole set of OECD Quarterly Sector Accounts data 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

See User Guide on Quarterly National Accounts (QNA) in OECD Data Explorer: QNA User guide

Tables

Observations

@oecd.oecd_sdd_nad_dsd_nasec1_df_qsa_v1_1.observations

14.25 MB
2,475,405 rows
26 columns

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