Dataset: Use Table At Basic Prices

About this Dataset

Use Table At Basic Prices

This Eurostat dataset contains data on use table at basic prices, as collected and published by the Statistical Office of the European Union.

Tables included:

raw: Original table as downloaded from Eurostat.
tidy: A cleaned and transformed version of the raw table, where time period values appear as rows instead of columns (unpivoted format).

Last updated: 2025-05-27T23:00:00+0200

Tables

Use Table At Basic Prices - Raw

@eurostat.naio_10_cp1610.raw

38.09 MB
1337392 rows
40 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "ind_use" VARCHAR,
  "stk_flow" VARCHAR,
  "prd_ava" VARCHAR,
  "geo" VARCHAR,
  "n_1990" DOUBLE,
  "n_1991" DOUBLE,
  "n_1992" DOUBLE,
  "n_1993" DOUBLE,
  "n_1994" DOUBLE,
  "n_1995" DOUBLE,
  "n_1996" DOUBLE,
  "n_1997" DOUBLE,
  "n_1998" DOUBLE,
  "n_1999" DOUBLE,
  "n_2000" DOUBLE,
  "n_2001" DOUBLE,
  "n_2002" DOUBLE,
  "n_2003" DOUBLE,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE
);

Use Table At Basic Prices - Unpivoted

@eurostat.naio_10_cp1610.tidy

33.17 MB
10043383 rows
8 columns


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "ind_use" VARCHAR,
  "stk_flow" VARCHAR,
  "prd_ava" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);