My Health My School Survey

Leeds City Council

@ukgov.my_health_my_school_survey

Table List

2 tables(3.62 MB)

School Survey 2018-19

School Survey 2019-20

School Survey 2018-19

@ukgov.my_health_my_school_survey.school_survey_2018_19

2.46 MB
21955 rows
568 columns
Only the first 100 columns are shown

unnamed_0 Unnamed: 0	unnamed_1 Unnamed: 1	unnamed_2 Unnamed: 2	unnamed_3 Unnamed: 3	unnamed_4 Unnamed: 4	unnamed_5 Unnamed: 5	unnamed_6 Unnamed: 6	unnamed_7 Unnamed: 7	unnamed_8 Unnamed: 8	unnamed_9 Unnamed: 9	unnamed_10 Unnamed: 10	unnamed_11 Unnamed: 11	unnamed_12 Unnamed: 12	in_a_normal_week_how_often_do_you_have_the_following_t_f554a708 In A Normal Week, How Often Do You Have The Following (this Means Not Just A Snack Or A Drink)?	unnamed_14 Unnamed: 14	on_a_normal_day_how_many_portions_of_the_following_do_you_have On A Normal Day, How Many Portions Of The Following Do You Have?	unnamed_16 Unnamed: 16	unnamed_17 Unnamed: 17	unnamed_18 Unnamed: 18	unnamed_19 Unnamed: 19	unnamed_20 Unnamed: 20	unnamed_21 Unnamed: 21	how_much_do_you_agree_or_disagree_with_the_following_s_68564efd How Much Do You Agree Or Disagree With The Following Statements?	unnamed_23 Unnamed: 23	unnamed_24 Unnamed: 24	unnamed_25 Unnamed: 25	unnamed_26 Unnamed: 26	unnamed_27 Unnamed: 27	unnamed_28 Unnamed: 28	unnamed_29 Unnamed: 29	unnamed_30 Unnamed: 30	unnamed_31 Unnamed: 31	unnamed_32 Unnamed: 32	unnamed_33 Unnamed: 33	unnamed_34 Unnamed: 34	unnamed_35 Unnamed: 35	unnamed_36 Unnamed: 36	unnamed_37 Unnamed: 37	unnamed_38 Unnamed: 38	unnamed_39 Unnamed: 39	unnamed_40 Unnamed: 40	unnamed_41 Unnamed: 41	unnamed_42 Unnamed: 42	how_many_minutes_a_week_are_you_physically_active_for How Many Minutes A Week Are You Physically Active For?	unnamed_44 Unnamed: 44	unnamed_45 Unnamed: 45	unnamed_46 Unnamed: 46	in_the_last_four_weeks_not_through_school_college_whic_05eec398 In The Last Four Weeks, Not Through School/college, Which Of The Following Activities Have You Done?	unnamed_48 Unnamed: 48	unnamed_49 Unnamed: 49	unnamed_50 Unnamed: 50	unnamed_51 Unnamed: 51	does_anything_stop_you_from_taking_part_in_physical_activities Does Anything Stop You From Taking Part In Physical Activities?	unnamed_53 Unnamed: 53	unnamed_54 Unnamed: 54	unnamed_55 Unnamed: 55	unnamed_56 Unnamed: 56	unnamed_57 Unnamed: 57	unnamed_58 Unnamed: 58	unnamed_59 Unnamed: 59	unnamed_60 Unnamed: 60	unnamed_61 Unnamed: 61	unnamed_62 Unnamed: 62	unnamed_63 Unnamed: 63	unnamed_64 Unnamed: 64	unnamed_65 Unnamed: 65	unnamed_66 Unnamed: 66	unnamed_67 Unnamed: 67	unnamed_68 Unnamed: 68	unnamed_69 Unnamed: 69	unnamed_70 Unnamed: 70	unnamed_71 Unnamed: 71	in_the_last_12_months_what_sports_activities_have_you__a5a54c75 In The Last 12 Months, What Sports/activities Have You Done In PE Lessons?	unnamed_73 Unnamed: 73	unnamed_74 Unnamed: 74	unnamed_75 Unnamed: 75	unnamed_76 Unnamed: 76	unnamed_77 Unnamed: 77	unnamed_78 Unnamed: 78	unnamed_79 Unnamed: 79	unnamed_80 Unnamed: 80	unnamed_81 Unnamed: 81	unnamed_82 Unnamed: 82	unnamed_83 Unnamed: 83	unnamed_84 Unnamed: 84	unnamed_85 Unnamed: 85	unnamed_86 Unnamed: 86	unnamed_87 Unnamed: 87	unnamed_88 Unnamed: 88	unnamed_89 Unnamed: 89	unnamed_90 Unnamed: 90	unnamed_91 Unnamed: 91	unnamed_92 Unnamed: 92	unnamed_93 Unnamed: 93	unnamed_94 Unnamed: 94	unnamed_95 Unnamed: 95	unnamed_96 Unnamed: 96	unnamed_97 Unnamed: 97	unnamed_98 Unnamed: 98	has_pe_encouraged_you_to_do_any_of_the_following Has PE Encouraged You To Do Any Of The Following ….?
Individaul ID	school_classification_list	school_local_authority_filter_classification	questionnaire_login_year_group_name	Please select your gender	How would you describe your sexual identity?	Which of these describes you?	Do you have, or do you consider yourself to have, a disability?	Where do you live?	Do you have a free school meal?	Which of these describes you as a student?	In a normal week, how often do you have breakfast (this means not just a snack or a drink)?	On a normal school/college day, where do you eat breakfast?	Evening meal/Dinner	Lunch	Fruit & vegetables (can include up to one medium glass of fruit juice)	High energy drinks (e.g. Red Bull, Monster)	Sweetened drinks (e.g. Pepsi, fruit juice)	Unsweetened drinks (e.g. milk, water)	Snacks (crisps, chocolate bar, packet of sweets, biscuits)	How often do you brush your teeth?	How often do you visit the dentist?	I enjoy eating in my school/college dining area	My school/college encourages me to drink water regularly	Queuing time is short in the dining area	I like the food provided by my school/college and it tastes nice	Pupils/students behave well in the dining area	I can usually find a place to sit and eat my lunch in the dining area	At this school/college, I have enough time to eat my lunch	How often do you have breakfast (this means not just a snack or a drink)?	How many snacks (crisps, chocolate bar, packet of sweets, biscuits) do you eat a day?	How many portions of fruit and vegetables do you eat a day (can include one medium glass of fruit juice)?	How many sweetened drinks (e.g. Pepsi, fruit juice) do you drink a day	How many unsweetened drinks (e.g. milk, water) do you drink a day?	How many high energy drinks (e.g. Red Bull, Monster) do you drink a day?	Do you brush your teeth every day?	Do you go to the dentist?	Do pupils/students behave well in the dining area?	Do you enjoy eating in the school dining area?	Do you like the food provided by your school and does it taste nice?	Does your school encourage you to drink water regularly?	How do you usually travel to college?	How many minutes a day, do you usually spend sitting down watching TV/playing computer games/using the internet/using a mobile phone?	Outside of school/college - playing out/recreational	At school/college but not in lesson times (e.g. break/lunch times/after school)	Outside of school/college - organised sports/dance (e.g. football, rugby, cricket, dance, Zumba, gymnastics, cycling, martial arts)	In school/college lessons (e.g. PE lessons)	Been to the gym	Visited a park or play area	Taken part in organised sports/dance (e.g. football, rugby, cricket, dance, Zumba, gymnastics, cycling, martial arts)	Been swimming	In a normal week how many times are you physically active for 30 minutes or more?	My parents/carers worry about me	Activities don’t cater for my disability	Nothing appeals to me	Too much school/college work	Other	Nothing available in my area	Nothing stops me, I do take part in physical activity	Nothing available when I want to do it	I don’t have the confidence	I have no one to go with	I have a job	Nothing stops me from taking part, I choose not to	Costs too much	I can't get there	I don't have the time	I don't know how to find out what's on offer	Do you visit a park or play area after school, on an evening or at the weekend?	Do you go swimming after school, on an evening or at the weekend?	Do you take part in organised sports/dance (e.g. football, rugby, cricket, Zumba, gymnastics, cycling, martial arts) after school, on an evening or at the weekend?	Do you go to the gym after school, on an evening or at the weekend?	Cricket	Athletics	Other	Yoga	Volleyball	Tennis	Basketball	Cycling	Dance	Dodgeball	Football	Gymnastics	Judo	Karate	Multi-skills	Netball	Rounders	Running	Hockey	Swimming	Skipping	Tag Rugby	Rugby	I have not taken part in PE this year as it has not been timetabled for my year group	I have not taken part in PE this year due to personal reasons	Have you enjoyed PE this year?	In the last 12 months, have you represented school in a sports event? (e.g. Football, Multi-skills, Netball, Dance competition)	Attend an after school club
1	Secondary	Leeds	Year 11	Female	Heterosexual	White (British, Irish, Traveller or Irish Heritage, Gypsy, Roma and any other White background)	No	I live with my parent(s)	No, I don’t have a free school meal		Most days (4-6 days)	At home	Everyday (7 days a week)	Most days (4 to 6 days a week)	4	None	None	2	1	Every day	Twice a year or more	Disagree	Strongly disagree	Disagree	Agree	Not sure	Disagree	Agree														181 - 240 minutes (3 hours 1 minute - 4 hours)	60-1 minutes	60-1 minutes	0 minutes (None)	60-1 minutes	No	No	No	No	9	X			X					X	X				X	X								X							X						X										No	No	No
2	Secondary	Leeds	Year 12	Female	Heterosexual	Other Ethnic Group	No	I live with my parent(s)		I am a post 16 student who attended another school in Year 10 & 11	Most days (4-6 days)	At home	Everyday (7 days a week)	Some days (1 to 3 days a week)	1	None	None	4	None	Twice a day	Twice a year or more	Strongly disagree	Not sure	Strongly disagree	Not sure	Not sure	Disagree	Disagree													Bus	121 - 180 minutes (2 hours 1 minute - 3 hours)	60-1 minutes	0 minutes (None)	0 minutes (None)	0 minutes (None)	No	Yes	No	No	4			X
3	Secondary	Leeds	Year 12	Male	Bisexual	White (British, Irish, Traveller or Irish Heritage, Gypsy, Roma and any other White background)	No	I live with my parent(s)		I am a post 16 student at the school I attended in Year 10 & 11	Some days (2-3 days)	At home	Everyday (7 days a week)	Everyday (7 days a week)	2	None	None	5 or more	2	Every day	Less than once a year for a check up	Not sure	Not sure	Strongly disagree	Not sure	Disagree	Not sure	Agree													Bus	361+ minutes (over 6 hours 1 minute)	120-61 minutes	0 minutes (None)	0 minutes (None)	0 minutes (None)	No	Yes	No	No	1									X			X
4	Secondary	Leeds	Year 9	Male	Heterosexual	White (British, Irish, Traveller or Irish Heritage, Gypsy, Roma and any other White background)	Yes	I live with my parent(s)	No, I don’t have a free school meal		Every day (7 days)	At home	Everyday (7 days a week)	Everyday (7 days a week)	5 or more	None	1	5 or more	1	Twice a day	Once a year for a check up	Disagree	Not sure	Disagree	Agree	Not sure	Not sure	Agree														1 - 60 minutes (Up to 1 hour)	60-1 minutes	60-1 minutes	241+ minutes	120-61 minutes	No	Yes	Yes	Yes	9							X															X				X	X			X									X	X						Yes	Yes	No
5	Secondary	Leeds	Year 9	Female	Heterosexual	Asian (Asian British, Indian, Pakistani, Bangladeshi, Chinese and any other Asian background)	No	I live with my parent(s)	No, I don’t have a free school meal		Every day (7 days)	At home	Everyday (7 days a week)	Everyday (7 days a week)	1	None	1	4	1	Twice a day	Less than once a year for a check up	Not sure	Agree	Disagree	Agree	Not sure	Disagree	Agree														61 - 120 minutes (1 hour 1 minute - 2 hours)	60-1 minutes	60-1 minutes	60-1 minutes	120-61 minutes	No	Yes	Yes	Yes	5							X															X							X	X	X					X	X						X			Yes	No	Yes
6	Secondary	Leeds	Year 12	Female	Heterosexual	White (British, Irish, Traveller or Irish Heritage, Gypsy, Roma and any other White background)	No	I live with my parent(s)		I am a post 16 student at the school I attended in Year 10 & 11	Rarely (1 day)	At home	Everyday (7 days a week)	Most days (4 to 6 days a week)	1	None	2	3	2	After every meal	Twice a year or more	Strongly disagree	Disagree	Not sure	Not sure	Not sure	Disagree	Agree													Walk	301 - 360 minutes (5 hours 1 minute - 6 hours)	120-61 minutes	60-1 minutes	120-61 minutes	0 minutes (None)	No	No	Yes	No	4			X	X					X
7	Secondary	Leeds	Year 11	Female	Bisexual	Other Ethnic Group	No	I live with my parent(s)	I don't know		Rarely (1 day)	On the way to school/college	Most days (4 to 6 days a week)	Everyday (7 days a week)	3	None	1	3	2	Every 2 or 3 days	Twice a year or more	Disagree	Disagree	Disagree	Agree	Agree	Agree	Not sure														121 - 180 minutes (2 hours 1 minute - 3 hours)	0 minutes (None)	60-1 minutes	0 minutes (None)	60-1 minutes	No	No	No	No	1			X	X				X						X	X								X						X						X		X									Yes	No	Yes
8	Secondary	Leeds	Year 9	Male	Heterosexual	White (British, Irish, Traveller or Irish Heritage, Gypsy, Roma and any other White background)	No	I live with my parent(s)	No, I don’t have a free school meal		Some days (2-3 days)	At home	Everyday (7 days a week)	Everyday (7 days a week)	3	None	1	5 or more	1	Every day	Twice a year or more	Disagree	Not sure	Disagree	Not sure	Not sure	Not sure	Agree														181 - 240 minutes (3 hours 1 minute - 4 hours)	60-1 minutes	120-61 minutes	60-1 minutes	120-61 minutes	No	Yes	Yes	No	4				X					X												X	X	X			X	X			X	X	X				X		X	X				X			Yes	No	No
9	Secondary	Leeds	Year 11	Female	Heterosexual	Mixed (White and Black Caribbean, White and Black African, White and Asian and any other Mixed background)	No	I live with my parent(s)	No, I don’t have a free school meal		Most days (4-6 days)	At home	Everyday (7 days a week)	Most days (4 to 6 days a week)	3	None	2	3	4	Twice a day	Twice a year or more	Strongly agree	Strongly disagree	Disagree	Agree	Agree	Disagree	Disagree														241 - 300 minutes (4 hours 1 minute - 5 hours)	120-61 minutes	0 minutes (None)	180-121 minutes	60-1 minutes	No	Yes	No	No	3							X																		X					X						X	X									Yes	No	No


CREATE TABLE school_survey_2018_19 (
  "unnamed_0" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "in_a_normal_week_how_often_do_you_have_the_following_t_f554a708" VARCHAR,
  "unnamed_14" VARCHAR,
  "on_a_normal_day_how_many_portions_of_the_following_do_you_have" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "how_much_do_you_agree_or_disagree_with_the_following_s_68564efd" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR,
  "unnamed_33" VARCHAR,
  "unnamed_34" VARCHAR,
  "unnamed_35" VARCHAR,
  "unnamed_36" VARCHAR,
  "unnamed_37" VARCHAR,
  "unnamed_38" VARCHAR,
  "unnamed_39" VARCHAR,
  "unnamed_40" VARCHAR,
  "unnamed_41" VARCHAR,
  "unnamed_42" VARCHAR,
  "how_many_minutes_a_week_are_you_physically_active_for" VARCHAR,
  "unnamed_44" VARCHAR,
  "unnamed_45" VARCHAR,
  "unnamed_46" VARCHAR,
  "in_the_last_four_weeks_not_through_school_college_whic_05eec398" VARCHAR,
  "unnamed_48" VARCHAR,
  "unnamed_49" VARCHAR,
  "unnamed_50" VARCHAR,
  "unnamed_51" VARCHAR,
  "does_anything_stop_you_from_taking_part_in_physical_activities" VARCHAR,
  "unnamed_53" VARCHAR,
  "unnamed_54" VARCHAR,
  "unnamed_55" VARCHAR,
  "unnamed_56" VARCHAR,
  "unnamed_57" VARCHAR,
  "unnamed_58" VARCHAR,
  "unnamed_59" VARCHAR,
  "unnamed_60" VARCHAR,
  "unnamed_61" VARCHAR,
  "unnamed_62" VARCHAR,
  "unnamed_63" VARCHAR,
  "unnamed_64" VARCHAR,
  "unnamed_65" VARCHAR,
  "unnamed_66" VARCHAR,
  "unnamed_67" VARCHAR,
  "unnamed_68" VARCHAR,
  "unnamed_69" VARCHAR,
  "unnamed_70" VARCHAR,
  "unnamed_71" VARCHAR,
  "in_the_last_12_months_what_sports_activities_have_you__a5a54c75" VARCHAR,
  "unnamed_73" VARCHAR,
  "unnamed_74" VARCHAR,
  "unnamed_75" VARCHAR,
  "unnamed_76" VARCHAR,
  "unnamed_77" VARCHAR,
  "unnamed_78" VARCHAR,
  "unnamed_79" VARCHAR,
  "unnamed_80" VARCHAR,
  "unnamed_81" VARCHAR,
  "unnamed_82" VARCHAR,
  "unnamed_83" VARCHAR,
  "unnamed_84" VARCHAR,
  "unnamed_85" VARCHAR,
  "unnamed_86" VARCHAR,
  "unnamed_87" VARCHAR,
  "unnamed_88" VARCHAR,
  "unnamed_89" VARCHAR,
  "unnamed_90" VARCHAR,
  "unnamed_91" VARCHAR,
  "unnamed_92" VARCHAR,
  "unnamed_93" VARCHAR,
  "unnamed_94" VARCHAR,
  "unnamed_95" VARCHAR,
  "unnamed_96" VARCHAR,
  "unnamed_97" VARCHAR,
  "unnamed_98" VARCHAR,
  "has_pe_encouraged_you_to_do_any_of_the_following" VARCHAR
);