Survey On Access To Finance Of Enterprises - SAFE

European Central Bank

@ecb.survey_on_access_to_finance_of_enterprises_safe

Table List

1 table(98.08 MB)

Table 1

@ecb.survey_on_access_to_finance_of_enterprises_safe.table_1

98.08 MB
4644933 rows
33 columns

key KEY	freq FREQ	ref_area REF AREA	firm_size FIRM SIZE	firm_sector FIRM SECTOR	safe_question SAFE QUESTION	safe_item SAFE ITEM	safe_answer SAFE ANSWER	safe_filter SAFE FILTER	safe_denom SAFE DENOM	time_period TIME PERIOD	obs_value OBS VALUE	obs_status OBS STATUS	obs_conf OBS CONF	time_format TIME FORMAT	collection COLLECTION	decimals DECIMALS	title TITLE	title_compl TITLE COMPL	unit UNIT	unit_mult UNIT MULT
SAFE.H.DE.ALL.A.0.0.0.Q0.ZZZZ.P6.AL.WP	H	DE	ALL	A	Q0	ZZZZ	P6	AL	WP	2009-S2	10.97135	A	F	P6M	V	3	Germany - All firm sizes - Q0. Most pressing problem	Residency of the firm Germany - All firm sizes - All sectors - All turnover breakdowns included - All ages included - All types of ownership, all export classes included - Question Q0. Most pressing problem - Regulation - Including not applicable responses - Weighted percentage of responses	PC	-2
SAFE.H.DE.ALL.A.0.0.0.Q0.ZZZZ.P6.AL.WP	H	DE	ALL	A	Q0	ZZZZ	P6	AL	WP	2010-S1	8.171747	A	F	P6M	V	3	Germany - All firm sizes - Q0. Most pressing problem	Residency of the firm Germany - All firm sizes - All sectors - All turnover breakdowns included - All ages included - All types of ownership, all export classes included - Question Q0. Most pressing problem - Regulation - Including not applicable responses - Weighted percentage of responses	PC	-2
SAFE.H.DE.ALL.A.0.0.0.Q0.ZZZZ.P6.AL.WP	H	DE	ALL	A	Q0	ZZZZ	P6	AL	WP	2010-S2	8.634303	A	F	P6M	V	3	Germany - All firm sizes - Q0. Most pressing problem	Residency of the firm Germany - All firm sizes - All sectors - All turnover breakdowns included - All ages included - All types of ownership, all export classes included - Question Q0. Most pressing problem - Regulation - Including not applicable responses - Weighted percentage of responses	PC	-2
SAFE.H.DE.ALL.A.0.0.0.Q0.ZZZZ.P6.AL.WP	H	DE	ALL	A	Q0	ZZZZ	P6	AL	WP	2011-S1	9.055389	A	F	P6M	V	3	Germany - All firm sizes - Q0. Most pressing problem	Residency of the firm Germany - All firm sizes - All sectors - All turnover breakdowns included - All ages included - All types of ownership, all export classes included - Question Q0. Most pressing problem - Regulation - Including not applicable responses - Weighted percentage of responses	PC	-2
SAFE.H.DE.ALL.A.0.0.0.Q0.ZZZZ.P6.AL.WP	H	DE	ALL	A	Q0	ZZZZ	P6	AL	WP	2011-S2	11.23478	A	F	P6M	V	3	Germany - All firm sizes - Q0. Most pressing problem	Residency of the firm Germany - All firm sizes - All sectors - All turnover breakdowns included - All ages included - All types of ownership, all export classes included - Question Q0. Most pressing problem - Regulation - Including not applicable responses - Weighted percentage of responses	PC	-2
SAFE.H.DE.ALL.A.0.0.0.Q0.ZZZZ.P6.AL.WP	H	DE	ALL	A	Q0	ZZZZ	P6	AL	WP	2012-S1	12.2469	A	F	P6M	V	3	Germany - All firm sizes - Q0. Most pressing problem	Residency of the firm Germany - All firm sizes - All sectors - All turnover breakdowns included - All ages included - All types of ownership, all export classes included - Question Q0. Most pressing problem - Regulation - Including not applicable responses - Weighted percentage of responses	PC	-2
SAFE.H.DE.ALL.A.0.0.0.Q0.ZZZZ.P6.AL.WP	H	DE	ALL	A	Q0	ZZZZ	P6	AL	WP	2012-S2	13.08563	A	F	P6M	V	3	Germany - All firm sizes - Q0. Most pressing problem	Residency of the firm Germany - All firm sizes - All sectors - All turnover breakdowns included - All ages included - All types of ownership, all export classes included - Question Q0. Most pressing problem - Regulation - Including not applicable responses - Weighted percentage of responses	PC	-2
SAFE.H.DE.ALL.A.0.0.0.Q0.ZZZZ.P6.AL.WP	H	DE	ALL	A	Q0	ZZZZ	P6	AL	WP	2013-S1	14.38377	A	F	P6M	V	3	Germany - All firm sizes - Q0. Most pressing problem	Residency of the firm Germany - All firm sizes - All sectors - All turnover breakdowns included - All ages included - All types of ownership, all export classes included - Question Q0. Most pressing problem - Regulation - Including not applicable responses - Weighted percentage of responses	PC	-2
SAFE.H.DE.ALL.A.0.0.0.Q0.ZZZZ.P6.AL.WP	H	DE	ALL	A	Q0	ZZZZ	P6	AL	WP	2013-S2	13.77862	A	F	P6M	V	3	Germany - All firm sizes - Q0. Most pressing problem	Residency of the firm Germany - All firm sizes - All sectors - All turnover breakdowns included - All ages included - All types of ownership, all export classes included - Question Q0. Most pressing problem - Regulation - Including not applicable responses - Weighted percentage of responses	PC	-2
SAFE.H.DE.ALL.A.0.0.0.Q0.ZZZZ.P6.AL.WP	H	DE	ALL	A	Q0	ZZZZ	P6	AL	WP	2014-S1	12.08116	A	F	P6M	V	3	Germany - All firm sizes - Q0. Most pressing problem	Residency of the firm Germany - All firm sizes - All sectors - All turnover breakdowns included - All ages included - All types of ownership, all export classes included - Question Q0. Most pressing problem - Regulation - Including not applicable responses - Weighted percentage of responses	PC	-2


CREATE TABLE table_1 (
  "key" VARCHAR,
  "freq" VARCHAR,
  "ref_area" VARCHAR,
  "firm_size" VARCHAR,
  "firm_sector" VARCHAR,
  "firm_turnover" BIGINT,
  "firm_age" BIGINT,
  "firm_ownership" BIGINT,
  "safe_question" VARCHAR,
  "safe_item" VARCHAR,
  "safe_answer" VARCHAR,
  "safe_filter" VARCHAR,
  "safe_denom" VARCHAR,
  "time_period" VARCHAR,
  "obs_value" DOUBLE,
  "obs_status" VARCHAR,
  "obs_conf" VARCHAR,
  "obs_pre_break" VARCHAR,
  "obs_com" VARCHAR,
  "time_format" VARCHAR,
  "breaks" VARCHAR,
  "collection" VARCHAR,
  "compiling_org" VARCHAR,
  "diss_org" VARCHAR,
  "publ_ecb" VARCHAR,
  "publ_mu" VARCHAR,
  "publ_public" VARCHAR,
  "compilation" VARCHAR,
  "decimals" BIGINT,
  "title" VARCHAR,
  "title_compl" VARCHAR,
  "unit" VARCHAR,
  "unit_mult" BIGINT
);