Financial Services - Quarterly Data
Eurostat code: ei_bsfs_q ยท (2007-Q3 - 2023-Q1)
@eurostat.ei_bsfs_q
Financial Services - Quarterly Data - Unpivoted
@eurostat.ei_bsfs_q.tidy
This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.
- 21.56 KB
- 9072 rows
- 7 columns
freqFreq | s_adjS Adj | nace_r2Nace R2 | indicIndic | geoGeo | time_periodTime Period | valueValue |
|---|---|---|---|---|---|---|
| Quarterly | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Financial and insurance activities | Capital expenditure development over the last 3 months | Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023) | 2007-Q3 | 8.7 |
| Quarterly | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Financial and insurance activities | Capital expenditure development over the last 3 months | European Union - 27 countries (from 2020) | 2007-Q3 | 6.9 |
| Quarterly | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Financial and insurance activities | Capital expenditure expectations over the next 3 months | Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023) | 2007-Q3 | 12.2 |
| Quarterly | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Financial and insurance activities | Capital expenditure expectations over the next 3 months | European Union - 27 countries (from 2020) | 2007-Q3 | 12.3 |
| Quarterly | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Financial and insurance activities | Competitive position development over the past 3 months (in your country) | Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023) | 2007-Q3 | 7.4 |
| Quarterly | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Financial and insurance activities | Competitive position development over the past 3 months (in your country) | European Union - 27 countries (from 2020) | 2007-Q3 | 13.8 |
| Quarterly | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Financial and insurance activities | Competitive position development over the past 3 months (within the euro area) | Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023) | 2007-Q3 | 0.2 |
| Quarterly | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Financial and insurance activities | Competitive position development over the past 3 months (within the euro area) | European Union - 27 countries (from 2020) | 2007-Q3 | 1 |
| Quarterly | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Financial and insurance activities | Competitive position development over the past 3 months (within the EU) | Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023) | 2007-Q3 | -2.1 |
| Quarterly | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Financial and insurance activities | Competitive position development over the past 3 months (within the EU) | European Union - 27 countries (from 2020) | 2007-Q3 | 0.4 |
CREATE TABLE tidy (
"freq" VARCHAR,
"s_adj" VARCHAR,
"nace_r2" VARCHAR,
"indic" VARCHAR,
"geo" VARCHAR,
"time_period" VARCHAR,
"value" DOUBLE
);