2nd Survey Of Schools: ICT In Education

Directorate-General for Communications Networks, Content and Technology

@ecdgconnect.n_2nd_survey_of_schools_ict_in_education

Table List

4 tables(6.51 MB)

Table 1

Table 2

Table 3

Table 6

Table 3

@ecdgconnect.n_2nd_survey_of_schools_ict_in_education.table_3

1.08 MB
8749 rows
198 columns
Only the first 100 columns are shown

country COUNTRY	countryid COUNTRYID	cnt CNT	eu EU	level1 LEVEL1	level2 LEVEL2	level3a LEVEL3A	level3b LEVEL3B	schoolid SCHOOLID	princid PRINCID	wave WAVE	n_principal_part N Principal Part	n_teachers_part N Teachers Part	n_students_part N Students Part	n_parents_part N Parents Part	sc01q01a SC01Q01A	sc01q01b SC01Q01B	sc01q02a SC01Q02A	sc01q02b SC01Q02B	sc01q04a SC01Q04A	sc01q04b SC01Q04B	sc04q01 SC04Q01	sc06q01 SC06Q01	sc12q011 SC12Q011	sc12q012 SC12Q012	sc12q013 SC12Q013	sc12q014 SC12Q014	sc12q015 SC12Q015	sc12q016 SC12Q016	sc12q017 SC12Q017	sc11q01 SC11Q01	sc07q01a SC07Q01A	sc07q01b SC07Q01B	sc07q01d SC07Q01D	sc07q01e SC07Q01E	sc07q03a SC07Q03A	sc07q03b SC07Q03B	sc07q03d SC07Q03D	sc07q13a SC07Q13A	sc07q13b SC07Q13B	sc07q13d SC07Q13D	sc07q13e SC07Q13E	sc07q14a SC07Q14A	sc07q14b SC07Q14B	sc07q14d SC07Q14D	sc07q14e SC07Q14E	sc07q11a SC07Q11A	sc07q11b SC07Q11B	sc07q11d SC07Q11D	sc07q11e SC07Q11E	sc07q05a SC07Q05A	sc07q05b SC07Q05B	sc07q05d SC07Q05D	sc07q05e SC07Q05E	sc07q07a SC07Q07A	sc07q07b SC07Q07B	sc07q07d SC07Q07D	sc07q07e SC07Q07E	sc07q08a SC07Q08A	sc07q08b SC07Q08B	sc07q08d SC07Q08D	sc07q08e SC07Q08E	sc08q01 SC08Q01	sc09q01 SC09Q01	sc09q02 SC09Q02	sc09q03 SC09Q03	sc09q04 SC09Q04	sc13q01 SC13Q01	sc13q02 SC13Q02	sc13q03 SC13Q03	sc13q04 SC13Q04	sc14q01 SC14Q01	sc14q02 SC14Q02	sc14q03 SC14Q03	sc14q15 SC14Q15	sc14q06 SC14Q06	sc14q13 SC14Q13	sc14q04 SC14Q04	sc14q05 SC14Q05	sc14q12 SC14Q12	sc14q14 SC14Q14	sc14q07 SC14Q07	sc14q08 SC14Q08	sc14q09 SC14Q09	sc15q01 SC15Q01	sc15q02 SC15Q02	sc15q03 SC15Q03	sc15q04 SC15Q04	sc15q05 SC15Q05
Austria	Austria	German	Member State of EU	No	No	No	Yes		AT00001R9	2017	1								40	40	5	A large city (over 1 000 000 people)	No	Yes	No	No	No	No	No	144kbps to less than 2mbps			1				1			1								1				0				0				0		More than 90%					No	No	No	Yes	Yes	No	Yes	No	No	No	No							25% of fewer	None	25% of fewer	None	None
Austria	Austria	German	Member State of EU	Yes	No	No	No	AT00006R2	AT00006R2	2017	1	1		1	30	50					7	A village, hamlet or rural area ( less than 3 000 people)	No	Yes	No	Yes	No	No	No	Don’t know/Prefer not to say	22				1			0				0				0				0				4				0				76 to 90%		3	1		No	No	No	Yes	Yes	No	No	No	No	No	Yes	Yes						None	None	None	More than 50%	25% of fewer
Austria	Austria	German	Member State of EU	No	No	No	Yes		AT00010R9	2017	1	1	17						157	113	999999	A city (100 000 to less than 1 000 000 people)	No	Yes	Yes	Yes	No	No	No	Don’t know/Prefer not to say			16				1			0				3				3				0				1				0		More than 90%	16	2	1		Yes	Yes	No	No	Yes	No	No	Don't know/ Prefer not to say	Yes	No	No		Yes	Yes	Yes	Yes	Don't know/ Prefer not to say	Don't know/ Prefer not to say	Don't know/ Prefer not to say	Don't know/ Prefer not to say	Don't know/ Prefer not to say	Don't know/ Prefer not to say
Austria	Austria	German	Member State of EU	No	Yes	No	Yes	AT00013R9	AT00013R9	2017	1	1	17				161	135	999998	999998	45	A large city (over 1 000 000 people)	No	Yes	No	Yes	No	No	No	Don’t know/Prefer not to say				0		32	0				0				0				0				0				0				0	More than 90%	32		1	32	Yes	No	Yes	No	Yes	No	No	No	No	No	Yes	Don't know/ Prefer not to say						Don't know/ Prefer not to say	Don't know/ Prefer not to say	More than 50%	None	26-50%
Austria	Austria	German	Member State of EU	No	Yes	No	No	AT00034R2	AT00034R2	2017	1						999999	999999			25	A village, hamlet or rural area ( less than 3 000 people)	No	No	Yes	No	No	No	No	30mbps to less 100mbps		35				15			10				8				10				0				2				4			More than 90%	30	10	2	4	Yes	Yes	No	No	Yes	Yes	Yes	Yes	Yes	No	Yes	Yes	Yes	Yes	Yes	Yes	No	None	25% of fewer	25% of fewer	25% of fewer	25% of fewer
Austria	Austria	German	Member State of EU	Yes	No	No	No	AT00035R3	AT00035R3	2017	1	1			12	10					2	A village, hamlet or rural area ( less than 3 000 people)	Yes	No	No	No	No	No	No	10mbps to less 30mbps	16				1			0				0				0				0				0				0				More than 90%		16			No	No	Yes	No	No	Yes	No	No	No	No	Yes	No						None	None	None	None	None
Austria	Austria	German	Member State of EU	Yes	No	No	No	AT00059R9	AT00059R9	2017	1				80	97					15	A city (100 000 to less than 1 000 000 people)	No	No	Yes	Yes	No	No	No	Don’t know/Prefer not to say	22				6			0				16				36				0				0				0				More than 90%		20	2	18	Yes	No	Yes	No	Yes	No	No	No	No	No	Yes	Don't know/ Prefer not to say						26-50%	25% of fewer	25% of fewer	More than 50%	More than 50%
Austria	Austria	German	Member State of EU	No	No	No	Yes	AT00061R3	AT00061R3	2017	1								999998	999998	40	A town (15 000 to less than 100.000 people)	No	No	No	No	No	No	Yes	Don’t know/Prefer not to say			999998				999998			10								35				0				0				1		More than 90%	20	1	999998	15	Yes	Yes	Yes	No	Yes	Yes	Yes	Yes	Don't know/ Prefer not to say	Yes	Yes	Yes						Don't know/ Prefer not to say	Don't know/ Prefer not to say	Don't know/ Prefer not to say	Don't know/ Prefer not to say	Don't know/ Prefer not to say
Austria	Austria	German	Member State of EU	Yes	No	No	No	AT00095R3	AT00095R3	2017	1				161	113					22	A small town (3 000 to less than 15 000 people)	Yes	No	No	No	No	No	No	Don’t know/Prefer not to say	0				0			0				0				0				0				3				0				More than 90%		13			No	No	No	Yes	No	No	No	No	No	No	No							None	None	None	25% of fewer	None
Austria	Austria	German	Member State of EU	Yes	No	No	No	AT00099R9	AT00099R9	2017	1				144	124					20	A large city (over 1 000 000 people)	Yes	No	No	Yes	No	No	No	Don’t know/Prefer not to say	23				4			0				0				0				0				0				0				More than 90%		22			Yes	No	Yes	No	Yes	No	No	No	No	No	Don't know/ Prefer not to say							Don't know/ Prefer not to say	Don't know/ Prefer not to say	Don't know/ Prefer not to say	None	Don't know/ Prefer not to say


CREATE TABLE table_3 (
  "country" VARCHAR,
  "countryid" VARCHAR,
  "cnt" VARCHAR,
  "eu" VARCHAR,
  "level1" VARCHAR,
  "level2" VARCHAR,
  "level3a" VARCHAR,
  "level3b" VARCHAR,
  "schoolid" VARCHAR,
  "princid" VARCHAR,
  "wave" BIGINT,
  "n_principal_part" BIGINT,
  "n_teachers_part" BIGINT,
  "n_students_part" BIGINT,
  "n_parents_part" BIGINT,
  "sc01q01a" VARCHAR,
  "sc01q01b" VARCHAR,
  "sc01q02a" VARCHAR,
  "sc01q02b" VARCHAR,
  "sc01q03a" VARCHAR,
  "sc01q03b" VARCHAR,
  "sc01q04a" VARCHAR,
  "sc01q04b" VARCHAR,
  "sc04q01" BIGINT,
  "sc06q01" VARCHAR,
  "sc12q011" VARCHAR,
  "sc12q012" VARCHAR,
  "sc12q013" VARCHAR,
  "sc12q014" VARCHAR,
  "sc12q015" VARCHAR,
  "sc12q016" VARCHAR,
  "sc12q017" VARCHAR,
  "sc11q01" VARCHAR,
  "sc07q01a" VARCHAR,
  "sc07q01b" VARCHAR,
  "sc07q01c" VARCHAR,
  "sc07q01d" VARCHAR,
  "sc07q01e" VARCHAR,
  "sc07q03a" VARCHAR,
  "sc07q03b" VARCHAR,
  "sc07q03c" VARCHAR,
  "sc07q03d" VARCHAR,
  "sc07q03e" VARCHAR,
  "sc07q13a" VARCHAR,
  "sc07q13b" VARCHAR,
  "sc07q13c" VARCHAR,
  "sc07q13d" VARCHAR,
  "sc07q13e" VARCHAR,
  "sc07q14a" VARCHAR,
  "sc07q14b" VARCHAR,
  "sc07q14c" VARCHAR,
  "sc07q14d" VARCHAR,
  "sc07q14e" VARCHAR,
  "sc07q11a" VARCHAR,
  "sc07q11b" VARCHAR,
  "sc07q11c" VARCHAR,
  "sc07q11d" VARCHAR,
  "sc07q11e" VARCHAR,
  "sc07q05a" VARCHAR,
  "sc07q05b" VARCHAR,
  "sc07q05c" VARCHAR,
  "sc07q05d" VARCHAR,
  "sc07q05e" VARCHAR,
  "sc07q07a" VARCHAR,
  "sc07q07b" VARCHAR,
  "sc07q07c" VARCHAR,
  "sc07q07d" VARCHAR,
  "sc07q07e" VARCHAR,
  "sc07q08a" VARCHAR,
  "sc07q08b" VARCHAR,
  "sc07q08c" VARCHAR,
  "sc07q08d" VARCHAR,
  "sc07q08e" VARCHAR,
  "sc08q01" VARCHAR,
  "sc09q01" BIGINT,
  "sc09q02" BIGINT,
  "sc09q03" BIGINT,
  "sc09q04" BIGINT,
  "sc13q01" VARCHAR,
  "sc13q02" VARCHAR,
  "sc13q03" VARCHAR,
  "sc13q04" VARCHAR,
  "sc14q01" VARCHAR,
  "sc14q02" VARCHAR,
  "sc14q03" VARCHAR,
  "sc14q15" VARCHAR,
  "sc14q06" VARCHAR,
  "sc14q13" VARCHAR,
  "sc14q04" VARCHAR,
  "sc14q05" VARCHAR,
  "sc14q12" VARCHAR,
  "sc14q14" VARCHAR,
  "sc14q07" VARCHAR,
  "sc14q08" VARCHAR,
  "sc14q09" VARCHAR,
  "sc15q01" VARCHAR,
  "sc15q02" VARCHAR,
  "sc15q03" VARCHAR,
  "sc15q04" VARCHAR,
  "sc15q05" VARCHAR
);