Other Changes In Volume - Quarterly Data

Eurostat code: nasq_10_f_oc · (1998-Q4 - 2024-Q4)

@eurostat.nasq_10_f_oc

Table List

2 tables(14.89 MB)

Other Changes In Volume - Quarterly Data - Raw

Other Changes In Volume - Quarterly Data - Unpivoted

Other Changes In Volume - Quarterly Data - Raw

@eurostat.nasq_10_f_oc.raw

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

7.25 MB
95869 rows
111 columns
Only the first 100 columns are shown

freq Freq	unit Unit	sector Sector	finpos Finpos	na_item Na Item	geo Geo	n_1998_q4 1998-Q4	n_1999_q1 1999-Q1	n_1999_q2 1999-Q2	n_1999_q3 1999-Q3	n_1999_q4 1999-Q4	n_2000_q1 2000-Q1	n_2000_q2 2000-Q2	n_2000_q3 2000-Q3	n_2000_q4 2000-Q4	n_2001_q1 2001-Q1	n_2001_q2 2001-Q2	n_2001_q3 2001-Q3	n_2001_q4 2001-Q4	n_2002_q1 2002-Q1	n_2002_q2 2002-Q2	n_2002_q3 2002-Q3	n_2002_q4 2002-Q4	n_2003_q1 2003-Q1	n_2003_q2 2003-Q2	n_2003_q3 2003-Q3	n_2003_q4 2003-Q4	n_2004_q1 2004-Q1	n_2004_q2 2004-Q2	n_2004_q3 2004-Q3	n_2004_q4 2004-Q4	n_2005_q1 2005-Q1	n_2005_q2 2005-Q2	n_2005_q3 2005-Q3	n_2005_q4 2005-Q4	n_2006_q1 2006-Q1	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
Quarterly	Million euro	Total economy	Assets	Total financial assets/liabilities	Austria		25184	9266	2962	-16450	-1274	3389	11122	-8854	-3787	6429	-13878	-2819	9551	-16251	-7886	9495	-11733	6886	-738	7884	6077	-6060	5620	-232	24236	28340	18698	35551	-43944	-2405	-671	31061	2823	-10211	-13780	-20882	69	-994	976	-18075	-981	-1357	5061	10841	-14604	-140	7639	-5915	1552	1980	1030	-11496	43440	-719	3090	6988	7368	1579	-336	34885	5339	-1184	-1353	13792	-6297	-241	3405	-9703	-407	1213	-187	-9173	-989	2	-5340	33294	-2730	-763	-1102	11350	13755	182	1987	6087	2658	-323	-18296	971	-1643	-2843	-759	2948	11731
Quarterly	Million euro	Total economy	Assets	Total financial assets/liabilities	Belgium																																																									10061.1	23902.2	-1073.3	-234.6	37380.3	-14107.5	-1215.1	1195.7	39867.1	4322.9	-659.4	-1007.4	1425.6	63612.1	-3637.9	157.6	9357.7	-21969.6	-891.2	-309.7	2436	4926.3	-921.2	1006.3	622.1	3773.8	107.5	3266.7	2208	1695.8	-607.4	14.3	-1063.2	8818.9	-764.7	7849.6	-2107.8	7234.9
Quarterly	Million euro	Total economy	Assets	Total financial assets/liabilities	Bulgaria																																		133.4	-2.6	256.7	53.7	-716.3	-34.8	-2.6	-10.2	-26.6	-19.4	666.7	-26.6	-29.7	-24.5	-27.6	-11.8	-39.9	-15.3	0.5	-75.7	-10.7	-61.4	-17.9	87.4	-101.7	-23.5	-63.9	-92.5	83.3	-51.6	-172.3	-1306.9	219.9	953.1	-96.1	-305.2	136	-135.5	75.7	228	263.8	-378.9	62.4	-1571.2	-332.3	-66	31.7	-426.4	361.5	-100.2	-82.8	-921.9	-262.3	-928.5	180	-455.6	-294.5	-31.2	92	-302.2	-1.5
Quarterly	Million euro	Total economy	Assets	Total financial assets/liabilities	Cyprus																																																									-3553.5	-2732.8	-3799.6	513.5	265.5	1978.1	-228.2	-2142	-191.6	2358.5	373.3	1492.3	895.5	-813.2	-917.8	-972.3	-1218.5	1689.7	-2242.4	-20242.7	-173	-734.6	-1733.5	-2603.4	-4639.9	1463.9	-1747.1	-3150.7	-2732.7	-3159.5	-169.9	978.9	-3704	7244.8	430.1	-2960.9	-4594.7	6174.7
Quarterly	Million euro	Total economy	Assets	Total financial assets/liabilities	Czechia																						-5.8	-0.2	-0.2	-266.3	-0.3	-0.3	53.3	540.1	-1	-0.6	-0.9	-478.6	-1	-0.6	-1	-72.4	-2.2		-2.2	-66.4	-0.7	-1.8	826.5	-624.8	-2.8	-3.2	-0.2	-258.9	30.8	-1.9	-4.4	-1109.5	-9.2	-1.7	-30.3	174.5	1504.3	-12.6	-25.4	0.2	1442	-7.1	-7.8	-0.4	-5.2	-9.2	-4.9	-0.4	-6.1	-0.2	-94.9	-539.7	-397.7	-94.9	543.8	-523.8	1235.3	-4850.3	1828.4	470.3	2700.5	864.1	-26.4	-2844.8	-350.9	1908.1	733.7	-2467.4	1919.1	1020	655.6	-2741.1	1439.5
Quarterly	Million euro	Total economy	Assets	Total financial assets/liabilities	Germany																																																									-8686	-16915	-9491	-117137	29914	-48161	-944	34539	37253	74788	-16048	-12194	-4531	1056881	-28366	-9196	40810	5064	-50191	-2630	-16537	242110	12676	4133	-1603	90512	-12660	11440	-1039	-10120	-29207	-17062	-39841	21133	254	1362	17090	190513
Quarterly	Million euro	Total economy	Assets	Total financial assets/liabilities	Denmark		14978.7	18389.2	-2313.5	7241.8	-8113.2	8663.2	18788.3	9517.8	-2815.3	-7653.5	14661.1	12	-19974.4	9793.9	-2245.3	18067.3	20133.2	1510.4	7422.5	4308.3	-11419.3	21577	-14915.8	40444	-22889.4	8359.9	2715.5	8394.9	7377	16295	7214.2	3002.1	1343.6	417	-10136.3	6797.3	788.8	19605.8	7165.2	-9499.7	6195.3	-5861.2	-1815.4	-4256.7	20066.1	-3237.6	-9643.3	40352.4	11969.4	-3783.8	4446	-4467.3	642.8	4661.1	-3051.8	-8656.1	9141	-1451.3	5186	50928.2	5027.7	-8939.9	-1214.8	7331.3	6744.5	-36101.9	-17840.4	-1363738.1	-3621.2	26165.8	3099	7118	1515.5	-3673.9	18462.7	25949.2	14762.5	14651.4	-929.9	1208.8	15941.2	8708.2	6910.8	19026.5	1077791.2	-2468.5	-83114.9	-8303.7	1254355	7181.1	-6851.6	9795.6	1341628.6
Quarterly	Million euro	Total economy	Assets	Total financial assets/liabilities	Estonia																																																									-422.4	1764.6	-290.8	-168.5	18.7	-160.8	-145.4	67.7	38	-220.9	-344.6	192.7	-115	-126	295.3	368.8	242.5	1410.1	157.4	-41.3	-101.6	-43.1	-76.8	548.1	187	-494.3	-160.8	-220.2	-363.7	-404.3	-228	155.8	-213.5	65.4	512.3	696.3	-3036.2	875.4
Quarterly	Million euro	Total economy	Assets	Total financial assets/liabilities	Greece																																														120.9	203.9	21.1	-8.8	217.8	-6.9		-838.9	-553.1	-2344	13.7	610.5	2055.4	1895	3083.2	-611.4	397.3	-10024.8	-1160.1	-1021.7	977.5	3347.3	-508.9	-569.7	1050.8	-626.9	-4725.6	13241.9	-792.4	-1388.6	-1251.7	-2464.9	-2598.6	-1723.8	-1506.5	-5402.5	-2033.4	-2134.8	-1881.5	495.6	1115.8	-846.4	-1694.4	-11564.9	-1379	971.5	-7075.6	-6329	682.6
Quarterly	Million euro	Total economy	Assets	Total financial assets/liabilities	Spain	-745.2	-1004.9	-288.6	-416.4	-8062.8	-3589.1	3709.8	-354.7	39769.6	253.7	7376.4	-190.4	7070.2	-18161.1	-2015.3	-375.3	-834.4	3952.5	-62.4	-102.8	-218.2	-7017.9	1423.4	-1522.1	3532.7	4764.2	35011	-2070.4	546.9	-251.3	3022.6	-13789	1093	-1178.6	-4985.3	-1020.8	10986.4	-988.6	-6041.9	-1117.5	-798.1	-4606	-1359.5	-391.5	-3353.2	-2640.2	2216.8	-3726.6	-85928	33960.9	-5361.7	-9874.6	192.9	-9919.4	-6544.3	-6735.4	-34817.4	13671.7	-10318.6	-2893.1	18055.6	17967.3	14805.4	-1924.9	40400	-72828.3	-14567.9	-9005	4320	-23486.9	-21685.9	-15161.2	-14206.6	9318.8	175	2735.9	-26342.7	-102.8	-4702.7	-21836.8	4504.5	-4158.5	-7318	-8168.2	-9507.4	7010.3	8076.3	10852.7	10466.2	-42171.7	-2824.6	-3720.4	-11227	-3860.6


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "sector" VARCHAR,
  "finpos" VARCHAR,
  "na_item" VARCHAR,
  "geo" VARCHAR,
  "n_1998_q4" DOUBLE,
  "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
);