Dataset: Euro Area Loans To Companies (2014-2023)

About this Dataset

Euro Area Loans To Companies (2014-2023)

The dataset contains

Three tables with the total loans of European banks by country for:

Companies
Consumption
House purchase

And the euro area interest rate trend (MRO)

Possible analyses

Loans EDA and visualization
investigate how loans have changed over time
test whether a change in official rates changes lending in the economy

Tables

Loans Compan Per Count

@kaggle.giuliofabbri_euro_area_loans_to_companies_2014_2023.loans_compan_per_count

25.26 KB
110 rows
20 columns


CREATE TABLE loans_compan_per_count (
  "data" VARCHAR,
  "austria" BIGINT,
  "belgium" BIGINT,
  "cyprus" BIGINT,
  "germany" BIGINT,
  "estonia" BIGINT,
  "spain" BIGINT,
  "finland" BIGINT,
  "france" BIGINT,
  "greece" BIGINT,
  "ireland" BIGINT,
  "italy" BIGINT,
  "lithuania" DOUBLE,
  "luxembourg" BIGINT,
  "latvia" BIGINT,
  "malta" BIGINT,
  "netherlands" BIGINT,
  "portugal" BIGINT,
  "slovenia" BIGINT,
  "slovakia" BIGINT
);

Loans Consum Per Count

@kaggle.giuliofabbri_euro_area_loans_to_companies_2014_2023.loans_consum_per_count

24.1 KB
110 rows
20 columns


CREATE TABLE loans_consum_per_count (
  "time" VARCHAR,
  "austria" BIGINT,
  "belgium" BIGINT,
  "cyprus" BIGINT,
  "germany" BIGINT,
  "estonia" BIGINT,
  "spain" BIGINT,
  "finland" BIGINT,
  "france" BIGINT,
  "greece" BIGINT,
  "ireland" BIGINT,
  "italy" BIGINT,
  "lithuania" DOUBLE,
  "luxembourg" BIGINT,
  "latvia" BIGINT,
  "malta" BIGINT,
  "netherlands" BIGINT,
  "portugal" BIGINT,
  "slovenia" BIGINT,
  "slovakia" BIGINT
);

Loans House Per Count

@kaggle.giuliofabbri_euro_area_loans_to_companies_2014_2023.loans_house_per_count

25.33 KB
110 rows
20 columns


CREATE TABLE loans_house_per_count (
  "time" VARCHAR,
  "austria" BIGINT,
  "belgium" BIGINT,
  "cyprus" BIGINT,
  "germany" BIGINT,
  "estonia" BIGINT,
  "spain" BIGINT,
  "finland" BIGINT,
  "france" BIGINT,
  "greece" BIGINT,
  "ireland" BIGINT,
  "italy" BIGINT,
  "lithuania" DOUBLE,
  "luxembourg" BIGINT,
  "latvia" BIGINT,
  "malta" BIGINT,
  "netherlands" BIGINT,
  "portugal" BIGINT,
  "slovenia" BIGINT,
  "slovakia" BIGINT
);

Loans Ue Companies Households Consumption

@kaggle.giuliofabbri_euro_area_loans_to_companies_2014_2023.loans_ue_companies_households_consumption

6.48 KB
110 rows
4 columns


CREATE TABLE loans_ue_companies_households_consumption (
  "time" VARCHAR,
  "non_financial_corporations" BIGINT,
  "households_and_non_profit_institutions_serving_households" BIGINT,
  "consumption" BIGINT
);