Baselight

Euro Area Loans To Companies (2014-2023)

Business loans (2014-2023) for time series analysis made by European banks

@kaggle.giuliofabbri_euro_area_loans_to_companies_2014_2023

Loading...
Loading...

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:

  1. Companies
  2. Consumption
  3. House purchase

And the euro area interest rate trend (MRO)

Possible analyses

  1. Loans EDA and visualization
  2. investigate how loans have changed over time
  3. 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
Loading...

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
Loading...

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
Loading...

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
Loading...

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

Share link

Anyone who has the link will be able to view this.