MFI Interest Rate Statistics - MIR
European Central Bank
@ecb.mfi_interest_rate_statistics_mir
Table 1
@ecb.mfi_interest_rate_statistics_mir.table_1
- 3.77 MB
- 1551168 rows
- 36 columns
keyKEY | freqFREQ | ref_areaREF AREA | bs_rep_sectorBS REP SECTOR | bs_itemBS ITEM | maturity_not_irateMATURITY NOT IRATE | data_type_mirDATA TYPE MIR | amount_catAMOUNT CAT | bs_count_sectorBS COUNT SECTOR | currency_transCURRENCY TRANS | ir_bus_covIR BUS COV | time_periodTIME PERIOD | obs_valueOBS VALUE | obs_statusOBS STATUS | obs_confOBS CONF | obs_pre_breakOBS PRE BREAK | obs_comOBS COM | time_formatTIME FORMAT | breaksBREAKS | collectionCOLLECTION | compiling_orgCOMPILING ORG | diss_orgDISS ORG | dom_ser_idsDOM SER IDS | publ_ecbPUBL ECB | publ_muPUBL MU | publ_publicPUBL PUBLIC | unit_index_baseUNIT INDEX BASE | compilationCOMPILATION | coverageCOVERAGE | decimalsDECIMALS | nat_titleNAT TITLE | source_agencySOURCE AGENCY | titleTITLE | title_complTITLE COMPL | unitUNIT | unit_multUNIT MULT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MIR.M.AT.B.A20.A.R.A.2240.EUR.O | M | AT | B | A20 | A | R | A | 2240 | EUR | O | Wed Jan 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time) | 4.88 | A | F | P1M | A | 4 | AT2 | Bank interest rates - loans to corporations (outstanding amounts) - Austria | Austria, Annualised agreed rate (AAR) / Narrowly defined effective rate (NDER), Credit and other institutions (MFI except MMFs and central banks) reporting sector - Loans, Total original maturity, Outstanding amount business coverage, Non-Financial corporations (S.11) sector, denominated in Euro | PCPA | ||||||||||||||
| MIR.M.AT.B.A20.A.R.A.2240.EUR.O | M | AT | B | A20 | A | R | A | 2240 | EUR | O | Sat Feb 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time) | 4.82 | A | F | P1M | A | 4 | AT2 | Bank interest rates - loans to corporations (outstanding amounts) - Austria | Austria, Annualised agreed rate (AAR) / Narrowly defined effective rate (NDER), Credit and other institutions (MFI except MMFs and central banks) reporting sector - Loans, Total original maturity, Outstanding amount business coverage, Non-Financial corporations (S.11) sector, denominated in Euro | PCPA | ||||||||||||||
| MIR.M.AT.B.A20.A.R.A.2240.EUR.O | M | AT | B | A20 | A | R | A | 2240 | EUR | O | Sat Mar 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time) | 4.71 | A | F | P1M | A | 4 | AT2 | Bank interest rates - loans to corporations (outstanding amounts) - Austria | Austria, Annualised agreed rate (AAR) / Narrowly defined effective rate (NDER), Credit and other institutions (MFI except MMFs and central banks) reporting sector - Loans, Total original maturity, Outstanding amount business coverage, Non-Financial corporations (S.11) sector, denominated in Euro | PCPA | ||||||||||||||
| MIR.M.AT.B.A20.A.R.A.2240.EUR.O | M | AT | B | A20 | A | R | A | 2240 | EUR | O | Tue Apr 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time) | 4.54 | A | F | P1M | A | 4 | AT2 | Bank interest rates - loans to corporations (outstanding amounts) - Austria | Austria, Annualised agreed rate (AAR) / Narrowly defined effective rate (NDER), Credit and other institutions (MFI except MMFs and central banks) reporting sector - Loans, Total original maturity, Outstanding amount business coverage, Non-Financial corporations (S.11) sector, denominated in Euro | PCPA | ||||||||||||||
| MIR.M.AT.B.A20.A.R.A.2240.EUR.O | M | AT | B | A20 | A | R | A | 2240 | EUR | O | Thu May 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time) | 4.5 | A | F | P1M | A | 4 | AT2 | Bank interest rates - loans to corporations (outstanding amounts) - Austria | Austria, Annualised agreed rate (AAR) / Narrowly defined effective rate (NDER), Credit and other institutions (MFI except MMFs and central banks) reporting sector - Loans, Total original maturity, Outstanding amount business coverage, Non-Financial corporations (S.11) sector, denominated in Euro | PCPA | ||||||||||||||
| MIR.M.AT.B.A20.A.R.A.2240.EUR.O | M | AT | B | A20 | A | R | A | 2240 | EUR | O | Sun Jun 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time) | 4.44 | A | F | P1M | A | 4 | AT2 | Bank interest rates - loans to corporations (outstanding amounts) - Austria | Austria, Annualised agreed rate (AAR) / Narrowly defined effective rate (NDER), Credit and other institutions (MFI except MMFs and central banks) reporting sector - Loans, Total original maturity, Outstanding amount business coverage, Non-Financial corporations (S.11) sector, denominated in Euro | PCPA | ||||||||||||||
| MIR.M.AT.B.A20.A.R.A.2240.EUR.O | M | AT | B | A20 | A | R | A | 2240 | EUR | O | Tue Jul 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time) | 4.27 | A | F | P1M | A | 4 | AT2 | Bank interest rates - loans to corporations (outstanding amounts) - Austria | Austria, Annualised agreed rate (AAR) / Narrowly defined effective rate (NDER), Credit and other institutions (MFI except MMFs and central banks) reporting sector - Loans, Total original maturity, Outstanding amount business coverage, Non-Financial corporations (S.11) sector, denominated in Euro | PCPA | ||||||||||||||
| MIR.M.AT.B.A20.A.R.A.2240.EUR.O | M | AT | B | A20 | A | R | A | 2240 | EUR | O | Fri Aug 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time) | 4.26 | A | F | P1M | A | 4 | AT2 | Bank interest rates - loans to corporations (outstanding amounts) - Austria | Austria, Annualised agreed rate (AAR) / Narrowly defined effective rate (NDER), Credit and other institutions (MFI except MMFs and central banks) reporting sector - Loans, Total original maturity, Outstanding amount business coverage, Non-Financial corporations (S.11) sector, denominated in Euro | PCPA | ||||||||||||||
| MIR.M.AT.B.A20.A.R.A.2240.EUR.O | M | AT | B | A20 | A | R | A | 2240 | EUR | O | Mon Sep 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time) | 4.24 | A | F | P1M | A | 4 | AT2 | Bank interest rates - loans to corporations (outstanding amounts) - Austria | Austria, Annualised agreed rate (AAR) / Narrowly defined effective rate (NDER), Credit and other institutions (MFI except MMFs and central banks) reporting sector - Loans, Total original maturity, Outstanding amount business coverage, Non-Financial corporations (S.11) sector, denominated in Euro | PCPA | ||||||||||||||
| MIR.M.AT.B.A20.A.R.A.2240.EUR.O | M | AT | B | A20 | A | R | A | 2240 | EUR | O | Wed Oct 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time) | 4.22 | A | F | P1M | A | 4 | AT2 | Bank interest rates - loans to corporations (outstanding amounts) - Austria | Austria, Annualised agreed rate (AAR) / Narrowly defined effective rate (NDER), Credit and other institutions (MFI except MMFs and central banks) reporting sector - Loans, Total original maturity, Outstanding amount business coverage, Non-Financial corporations (S.11) sector, denominated in Euro | PCPA |
CREATE TABLE table_1 (
"key" VARCHAR,
"freq" VARCHAR,
"ref_area" VARCHAR,
"bs_rep_sector" VARCHAR,
"bs_item" VARCHAR,
"maturity_not_irate" VARCHAR,
"data_type_mir" VARCHAR,
"amount_cat" VARCHAR,
"bs_count_sector" BIGINT,
"currency_trans" VARCHAR,
"ir_bus_cov" VARCHAR,
"time_period" TIMESTAMP,
"obs_value" DOUBLE,
"obs_status" VARCHAR,
"obs_conf" VARCHAR,
"obs_pre_break" DOUBLE,
"obs_com" VARCHAR,
"time_format" VARCHAR,
"breaks" VARCHAR,
"collection" VARCHAR,
"compiling_org" VARCHAR,
"diss_org" VARCHAR,
"dom_ser_ids" VARCHAR,
"publ_ecb" VARCHAR,
"publ_mu" VARCHAR,
"publ_public" VARCHAR,
"unit_index_base" VARCHAR,
"compilation" VARCHAR,
"coverage" VARCHAR,
"decimals" BIGINT,
"nat_title" VARCHAR,
"source_agency" VARCHAR,
"title" VARCHAR,
"title_compl" VARCHAR,
"unit" VARCHAR,
"unit_mult" BIGINT
);