Revaluation Account - Quarterly Data

Eurostat code: nasq_10_f_gl · (1999-Q1 - 2024-Q3)

@eurostat.nasq_10_f_gl

Table List

2 tables(5.14 MB)

Revaluation Account - Quarterly Data - Raw

Revaluation Account - Quarterly Data - Unpivoted

Revaluation Account - Quarterly Data - Raw

@eurostat.nasq_10_f_gl.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

2.73 MB
31460 rows
109 columns
Only the first 100 columns are shown

freq Freq	unit Unit	sector Sector	finpos Finpos	na_item Na Item	geo Geo	n_2006_q2 2006-Q2	n_2006_q3 2006-Q3	n_2006_q4 2006-Q4	n_2007_q1 2007-Q1	n_2007_q2 2007-Q2	n_2007_q3 2007-Q3	n_2007_q4 2007-Q4	n_2008_q1 2008-Q1	n_2008_q2 2008-Q2	n_2008_q3 2008-Q3	n_2008_q4 2008-Q4	n_2009_q1 2009-Q1	n_2009_q2 2009-Q2	n_2009_q3 2009-Q3	n_2009_q4 2009-Q4	n_2010_q1 2010-Q1	n_2010_q2 2010-Q2	n_2010_q3 2010-Q3	n_2010_q4 2010-Q4	n_2011_q1 2011-Q1	n_2011_q2 2011-Q2	n_2011_q3 2011-Q3	n_2011_q4 2011-Q4	n_2012_q1 2012-Q1	n_2012_q2 2012-Q2	n_2012_q3 2012-Q3	n_2012_q4 2012-Q4	n_2013_q1 2013-Q1	n_2013_q2 2013-Q2	n_2013_q3 2013-Q3	n_2013_q4 2013-Q4	n_2014_q1 2014-Q1	n_2014_q2 2014-Q2	n_2014_q3 2014-Q3	n_2014_q4 2014-Q4	n_2015_q1 2015-Q1	n_2015_q2 2015-Q2	n_2015_q3 2015-Q3	n_2015_q4 2015-Q4	n_2016_q1 2016-Q1	n_2016_q2 2016-Q2	n_2016_q3 2016-Q3	n_2016_q4 2016-Q4	n_2017_q1 2017-Q1	n_2017_q2 2017-Q2	n_2017_q3 2017-Q3	n_2017_q4 2017-Q4	n_2018_q1 2018-Q1	n_2018_q2 2018-Q2	n_2018_q3 2018-Q3	n_2018_q4 2018-Q4	n_2019_q1 2019-Q1	n_2019_q2 2019-Q2	n_2019_q3 2019-Q3	n_2019_q4 2019-Q4	n_2020_q1 2020-Q1	n_2020_q2 2020-Q2	n_2020_q3 2020-Q3	n_2020_q4 2020-Q4	n_2021_q1 2021-Q1	n_2021_q2 2021-Q2	n_2021_q3 2021-Q3	n_2021_q4 2021-Q4	n_2022_q1 2022-Q1	n_2022_q2 2022-Q2
Quarterly	Million euro	Total economy	Assets	Debt securities	Austria	-4459	3859	-2373	-70	-4274	-1971	-3285	-3158	-5531	-1109	-579	-3822	2834	8235	234	4707	2073	962	-6602	-4911	2194	2042	-3558	7107	2714	6132	2985	249	-5160	-1189	-1013	4291	4602	4447	2188	7339	-11321	-144	-102	3699	4755	1716	-5577	-2715
Quarterly	Million euro	Total economy	Assets	Debt securities	Belgium																											6879.5	-5674.3	-7623.4	-1631.5	-2301.5	7522.4	10140.2	8643.6	10635.5	10802.8	-21888.7	1670	-1155.4	3498.6	3312.5	893.1	-6700.5	-4730.2
Quarterly	Million euro	Total economy	Assets	Debt securities	Bulgaria																												-51.6	-146.7	-11.8	4.6	85.4	138.6	51.1	64.4	147.3	-292	110.4	82.8	76.7	104.3	225	-155.4	-27680.7
Quarterly	Million euro	Total economy	Assets	Debt securities	Cyprus																											32261.9	-2.5	-4.6	-1.9	-0.4	-66.6	71.8	406.6	-261.9	207.1	138.3	-33.8	57.3	59.9	130.8	53.7	11.4	-181.7
Quarterly	Million euro	Total economy	Assets	Debt securities	Czechia																												1474.6	-480.9	-1376	1555.9	-1684.3	229.7	223.4	-352.5	2050.9	-1360.2	-151.6	-906.4	-6780.8	-174.8	-36.2	197.2	-378
Quarterly	Million euro	Total economy	Assets	Debt securities	Germany																											-2542	-22669	-45697	-39339	-4409	45188	44255	58493	62792	101896	-167732	1043	5930	69984	44369	9296	-99340	-30170
Quarterly	Million euro	Total economy	Assets	Debt securities	Denmark																												-162.9	-8703.8	-5413.8	-2644.9	7269.3	4567.3	8509	4508.3	20026.4	-20333.8	-695.3	-1631.5	6751.7	9450.4	2156.2	-4133.5	-195
Quarterly	Million euro	Total economy	Assets	Debt securities	Euro area – 20 countries (from 2023)																												-19208.4	-147129.1	-26912.7	13164.4	198974.3	223127	251251.9	148653.4	531241.8	-557134.3	-3548.3	13246	84604.5	179794.1	35061.5	-182259.6	-106594.1	-203851.3	-59578	-187815.5	-99302.6	-65500.7	-119807	-13315.2	363608.2	213514.1	412503.5	-278432.1	-423274.5	356913.6	41126.5	84225.1	-190650	-111231.8	34686.9	-22361.7	-939797.3	-1059854
Quarterly	Million euro	Total economy	Assets	Debt securities	Estonia																	79.5	-83.1	-21.2	136.4	13.9	-12.5	-59.1	108	-12.8	75.8	-37.2	-20.8	4.8	-18.7	4.6	12.1	-3.7	18.6	-14.3	85.9	-62.2	20.8	-1.3	-64.5	37.4	15.8	-39.4	-108
Quarterly	Million euro	Total economy	Assets	Debt securities	Greece																												639.1	2621.1	886.4	-2103.4	1263.8	2360.6	-2276.5	-4760.9	-2269.9	-527.5	3139.3	1157.9	-898	-553.7	508.2	160	984.4


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "sector" VARCHAR,
  "finpos" VARCHAR,
  "na_item" VARCHAR,
  "geo" VARCHAR,
  "n_1999_q1" DOUBLE,
  "n_1999_q2" DOUBLE,
  "n_1999_q3" DOUBLE,
  "n_1999_q4" DOUBLE,
  "n_2000_q1" DOUBLE,
  "n_2000_q2" DOUBLE,
  "n_2000_q3" DOUBLE,
  "n_2000_q4" DOUBLE,
  "n_2001_q1" DOUBLE,
  "n_2001_q2" DOUBLE,
  "n_2001_q3" DOUBLE,
  "n_2001_q4" DOUBLE,
  "n_2002_q1" DOUBLE,
  "n_2002_q2" DOUBLE,
  "n_2002_q3" DOUBLE,
  "n_2002_q4" DOUBLE,
  "n_2003_q1" DOUBLE,
  "n_2003_q2" DOUBLE,
  "n_2003_q3" DOUBLE,
  "n_2003_q4" DOUBLE,
  "n_2004_q1" DOUBLE,
  "n_2004_q2" DOUBLE,
  "n_2004_q3" DOUBLE,
  "n_2004_q4" DOUBLE,
  "n_2005_q1" DOUBLE,
  "n_2005_q2" DOUBLE,
  "n_2005_q3" DOUBLE,
  "n_2005_q4" DOUBLE,
  "n_2006_q1" DOUBLE,
  "n_2006_q2" DOUBLE,
  "n_2006_q3" DOUBLE,
  "n_2006_q4" DOUBLE,
  "n_2007_q1" DOUBLE,
  "n_2007_q2" DOUBLE,
  "n_2007_q3" DOUBLE,
  "n_2007_q4" DOUBLE,
  "n_2008_q1" DOUBLE,
  "n_2008_q2" DOUBLE,
  "n_2008_q3" DOUBLE,
  "n_2008_q4" DOUBLE,
  "n_2009_q1" DOUBLE,
  "n_2009_q2" DOUBLE,
  "n_2009_q3" DOUBLE,
  "n_2009_q4" DOUBLE,
  "n_2010_q1" DOUBLE,
  "n_2010_q2" DOUBLE,
  "n_2010_q3" DOUBLE,
  "n_2010_q4" DOUBLE,
  "n_2011_q1" DOUBLE,
  "n_2011_q2" DOUBLE,
  "n_2011_q3" DOUBLE,
  "n_2011_q4" DOUBLE,
  "n_2012_q1" DOUBLE,
  "n_2012_q2" DOUBLE,
  "n_2012_q3" DOUBLE,
  "n_2012_q4" DOUBLE,
  "n_2013_q1" DOUBLE,
  "n_2013_q2" DOUBLE,
  "n_2013_q3" DOUBLE,
  "n_2013_q4" DOUBLE,
  "n_2014_q1" DOUBLE,
  "n_2014_q2" DOUBLE,
  "n_2014_q3" DOUBLE,
  "n_2014_q4" DOUBLE,
  "n_2015_q1" DOUBLE,
  "n_2015_q2" DOUBLE,
  "n_2015_q3" DOUBLE,
  "n_2015_q4" DOUBLE,
  "n_2016_q1" DOUBLE,
  "n_2016_q2" DOUBLE,
  "n_2016_q3" DOUBLE,
  "n_2016_q4" DOUBLE,
  "n_2017_q1" DOUBLE,
  "n_2017_q2" DOUBLE,
  "n_2017_q3" DOUBLE,
  "n_2017_q4" DOUBLE,
  "n_2018_q1" DOUBLE,
  "n_2018_q2" DOUBLE,
  "n_2018_q3" DOUBLE,
  "n_2018_q4" DOUBLE,
  "n_2019_q1" DOUBLE,
  "n_2019_q2" DOUBLE,
  "n_2019_q3" DOUBLE,
  "n_2019_q4" DOUBLE,
  "n_2020_q1" DOUBLE,
  "n_2020_q2" DOUBLE,
  "n_2020_q3" DOUBLE,
  "n_2020_q4" DOUBLE,
  "n_2021_q1" DOUBLE,
  "n_2021_q2" DOUBLE,
  "n_2021_q3" DOUBLE,
  "n_2021_q4" DOUBLE,
  "n_2022_q1" DOUBLE,
  "n_2022_q2" DOUBLE
);