Financial Balance Sheets - Quarterly Data

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

@eurostat.nasq_10_f_bs

Table List

2 tables(48.26 MB)

Financial Balance Sheets - Quarterly Data - Raw

Financial Balance Sheets - Quarterly Data - Unpivoted

Financial Balance Sheets - Quarterly Data - Raw

@eurostat.nasq_10_f_bs.raw

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

23.32 MB
102296 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_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	1135220	1174326	1203291	1219847	1250071	1277673	1311258	1324904	1346711	1374570	1373679	1390040	1421271	1416585	1421646	1430563	1451455	1484230	1497914	1520192	1552937	1590117	1621175	1642448	1777148	1861482	1916001	1960780	2002970	2024123	2056922	2147483	2233317	2319562	2329811	2363307	2381791	2429549	2499703	2504798	2481319	2509170	2538166	2555519	2581921	2625654	2613735	2590733	2624257	2648541	2646244	2653343	2744721	2751688	2762960	2749413	2747233	2724285	2733933	2765269	2778013	2797694	2806308	2813074	2888919	2858378	2834117	2844301	2840506	2851731	2868210	2890400	2948375	2968817	2973001	3021544	3043805	3058316	3068164	3040586	3116063	3145147	3197461	3175281	3169852	3334402	3336952	3443450	3531616	3580702	3626697	3726033	3727622
Quarterly	Million euro	Total economy	Assets	Total financial assets/liabilities	Belgium	2305022.3	2340483.5	2368636.9	2502684.6	2527665.4	2571662.7	2608582.6	2623032.8	2614687.2	2677734.3	2658716.5	2735703.1	2753728.3	2690914.7	2612517.6	2655148.3	2656879	2739504.8	2739576.7	2833117.5	2920533.3	2966703.4	2995305.2	3100542.1	3223324.2	3308682.4	3347897.5	3444189	3554365.3	3571175.4	3658765.5	3786107.8	3902674.7	4037702.2	4066112.1	4249153	4271113.6	4308351.9	4464808.6	4262717.7	4212475.2	4316637.1	4354221.3	4445659.6	4434973.7	4518930.7	4468883.4	4519049.4	4527910.9	4576118.2	4607464.3	4728058.4	4800974.3	4845597.2	4853535.5	4755727	4812076.8	4806266.1	4807283.9	4854655.5	4854803.8	4897516.3	4934037.5	5051245.8	5294645	5216715.7	5185590.2	5217148.8	5373950.3	5459187.4	5472824.9	5486907.9	5516231	5494092.6	5450890.6	5454735.2	5390323.2	5418846	5340470.4	5226835.5	5463505.4	5477714.9	5636920.7	5608244	5507585.7	5711634.7	5697762.9	5847304.8	5996456.5	6140773.8	6226689.3	6307229.5	6314048.7
Quarterly	Million euro	Total economy	Assets	Total financial assets/liabilities	Bulgaria																																103295.8	108665	117003.8	129342	138707.4	142824.9	153074.4	161399.4	161211.3	162168.9	164630.8	167666.9	170713.3	172248.2	174052.6	177389.8	180449.4	180524.6	183650.7	187860.7	190076.2	191588.6	193782.1	198850.6	201343.2	202910.3	203681.4	206420.4	208011.6	211363.1	214616.5	221834.5	227776.4	233553	234469.3	237247.7	240464.8	244333.8	249665.6	255501.6	263296.3	265644.2	268729.4	273814.8	276271.6	276068.6	282285.5	288559.7	292277.3	297098.9	302130.6	310607.9	315458.1	316909.7	322456.8	335320.6	340067	351248.1	365644.7	384033.1	401205.6	407855.1
Quarterly	Million euro	Total economy	Assets	Total financial assets/liabilities	Cyprus																					242311.3	247478.8	251969.7	252363.8	256147.7	267269.6	273303.1	284857.7	289281.4	297102.7	306404.2	312194.7	318421.8	329502.1	337765.8	343963	350952.1	354424	375431.8	388688.5	406535.5	459951.5	457664.4	460133.8	472894	506255.6	475013.2	481087.7	487369.3	499040.8	516692.4	521353.4	559895.2	571552.8	582113.4	588431.7	579223.7	573582.3	568996.8	574903.6	587809.5	598218.7	612106.4	625117.8	646936.3	653602.8	663291.5	679767.7	671565.4	671937.8	674641.4	677448.8	694695.8	700551.1	688780.3	702807.8	734097.2	755515.4	785547.4	806536.5	844517.5	873680.2	890879.1	916239.6	898517.9	867854.3	841991.9	821156.4	847895.3	869667.3	884642.8	866727.7	866453.3
Quarterly	Million euro	Total economy	Assets	Total financial assets/liabilities	Czechia																					374409.1	390142.6	391452.3	404214.1	422556.6	434813.6	447311.7	461912.2	476009.9	482052.6	492718.9	513463.4	519426.2	525802.8	557658.9	591360.4	628475.6	680955.5	658611	605750.3	597697.2	640364.2	664401.3	643538.9	674074.3	678432.9	714736.9	700699.5	723761.6	732863.8	732813.1	714259.1	757995	739002.3	763915.4	776628.6	768463.8	761785.8	774187.1	753316.7	767832.3	772365.4	777638.3	777671.9	804335.3	816376.2	839675.3	841874.1	869216.4	877728.2	899273.5	916937	1027763.1	1068651.8	1085225	1113181.7	1144778.1	1130296.5	1159501.4	1154451.5	1185577.5	1220031.7	1217081.2	1217313.6	1193833.1	1243778.5	1236030.6	1263362	1328829.2	1390037.4	1441596.6	1481016.4	1584535.6
Quarterly	Million euro	Total economy	Assets	Total financial assets/liabilities	Germany	14555224	14838709	14725079	15669540	16021829	16081927	16355529	16553078	16653284	16803833	16576874	17233195	17360884	17131013	16760483	16873260	16980555	17419248	17313019	17504863	17823328	17862198	17925449	18134639	18453600	18883511	19249331	19363608	19302899	19441060	19694354	20016930	20424481	20843676	21085591	21581264	21734178	21718222	22154545	22224291	22135013	21654584	21582979	21599243	21931534	22757906	22376527	22110937	21756779	21881817	22494822	22659945	23372681	23732988	23920993	23783733	23440263	23115039	23097680	23208970	23318828	23594444	23936614	24353023	25580760	24965438	24931336	25207639	26673227	27196950	27507464	27814326	28484520	28563660	28903214	29144402	29624510	30081851	30322559	30266530	31369475	32038455	32712316	32740338	33103355	34452267	35124319	35667263	36660013	37323378	37993099	38726772	39304972
Quarterly	Million euro	Total economy	Assets	Total financial assets/liabilities	Denmark	1226677.7	1297837.5	1309284.4	1352984.2	1385613.8	1424837	1478243.9	1474230.1	1472639.5	1507676	1514545.8	1541789.3	1551419.8	1542000.3	1544404.4	1586941.1	1676814.6	1721262.6	1721130.8	1729541.6	1806950.6	1865790.6	1897412.4	1965220.3	2091099.1	2251784.1	2316150.4	2383838.8	2448431.5	2460612.7	2588264.6	2715127.8	2751617.8	2847272	2903683.9	2942355.9	2932261.4	2973738.5	2935976.2	2990413.5	2912708.3	2961575.4	3006404.9	3055965.6	3153677.1	3229026.6	3288264.5	3312476.3	3263687.2	3264551.7	3367423.4	3465092.1	3505510.6	3545789	3622805	3566154	3612882.1	3544804.3	3582943.4	3646827.3	3741280.1	3800288.4	3933090.4	4011253	4254930.5	4123370.1	4096630.9	4135754.7	4202519.1	4282497.3	4340515.3	4370621.4	4368605.5	4370327.8	4481731.3	4490953	4530277.2	4660694.3	4605979.8	4452962.2	4624589.4	4807112.1	4963548.4	4936128.5	4836695.9	5005101.4	5113669.7	5344425.7	5399726.4	5645993.4	5798464.6	6022930	6000247.5
Quarterly	Million euro	Total economy	Assets	Total financial assets/liabilities	Euro area – 20 countries (from 2023)	49556532	51047896	51163604	54653476	56530624	57216332	58044184	58243108	58397948	59166520	57574196	59694868	60677508	59818936	58429012	59715548	59796224	61969292	62439956	63987068	65605988	66701760	67292560	68923024	71085096	73341376	75201568	77152064	79586720	80450696	82630288	85319336	87879976	90267832	90918472	93239120	92373832	92723096	93028552	92009808	91118648	92972576	94297192	96016072	97648464	99477976	99621272	100437136	100713008	101700000	101918376	104009624	106517512	107349800	108169208	108832328	108326280	107917456	108087840	108984944	110192696	111646688	112756776	116994272	123675896	122412080	121839160	124156048	125866040	127868552	129659168	131426936	135244832	135638240	136437120	137231968	138514464	140803168	141433648	138795040	144287840	146249664	148934752	148691520	146847632	153269408	154709616	158292560	163721616	167655584	170133680	174076224	173521120
Quarterly	Million euro	Total economy	Assets	Total financial assets/liabilities	Estonia																					31079.9	33169.2	35206.5	37899	40756.3	41922.4	43608.5	46955.4	49573.4	51723.8	53955.9	58237.5	61180.4	65584.6	69644.7	72461.3	75149.6	78346	80333.1	81609.5	78656.9	76068.4	74089.6	72465.8	72036.7	72785.4	72388.1	74287.9	76465.1	78173.8	78169.5	79423.9	82664.1	84356.3	87100.5	89940.9	90806.8	92901.2	92901.2	96692	98701	100835.1	103038.7	108038.2	106750.5	110025.3	109814.3	113441	114877.7	117842.5	121289.6	124697.6	128073.2	130973.7	133844.5	138647.1	136718.9	139990.5	141049.3	143428.4	147539	153658.6	159623.5	161799.5	160789.3	173360.9	178698.4	183376.5	190758.2	195449.8	201848.6	214763.1	216807.7
Quarterly	Million euro	Total economy	Assets	Total financial assets/liabilities	Greece	571369.9	620432.6	699706.7	731511.6	693038.4	784367.6	764793.3	633104.2	612423.1	602426.2	602344.1	611896.3	581571.9	586122.8	590489.2	590244.7	598628.7	620056.3	637318.8	646200	655196.7	687681.5	698126.9	707301.1	743269.1	773019.4	807092.4	833304.3	850713.1	873232.3	892459.4	910495.6	948829.6	983456.2	993192.3	1042826.6	1014933	1021658	1018088	1034493.5	1063539.6	1109233.6	1110341.6	1112452.1	1136901	1178208.2	1169044.9	1138891.6	1115026.6	1127577.1	1098047.1	1078007.8	1026107.7	1062760	1051335.6	1085545.9	1030449.5	1011412.7	1015724.7	1012403.3	1011182	966095.2	940875.7	936782.7	966518.9	977032.3	956822.4	956506.2	936880.7	927606.9	908285.4	921212.3	907422.4	913764.7	888159.9	883757.4	875776.2	861729.9	867548.7	869178.9	862362.5	887348.1	913942	931943.4	904929.2	979702.3	1006585.1	1054124	1069062.2	1105817.6	1122180.1	1147036.6	1146240


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
);