All Schools In Camden And Surrounding Boroughs

London Borough of Camden

@ukgov.all_schools_in_camden_and_surrounding_boroughs

Table List

1 table(175.27 KB)

Table 1

@ukgov.all_schools_in_camden_and_surrounding_boroughs.table_1

175.27 KB
656 rows
79 columns

unique_reference_number Unique Reference Number	local_authority_code Local Authority Code	local_authority_name Local Authority Name	establishment_number Establishment Number	establishment_name Establishment Name	type_of_establishment Type Of Establishment	establishment_status Establishment Status	reason_establishment_opened Reason Establishment Opened	reason_establishment_closed Reason Establishment Closed	phase_of_education Phase Of Education	statutory_low_age Statutory Low Age	statutory_high_age Statutory High Age	boarders Boarders	official_sixth_form Official Sixth Form	gender Gender	religious_character Religious Character	diocese Diocese	admissions_policy Admissions Policy	school_capacity School Capacity	special_classes Special Classes	number_of_pupils Number Of Pupils	number_of_boys Number Of Boys	number_of_girls Number Of Girls	percentage_claiming_free_school_meals Percentage Claiming Free School Meals	trust_school Trust School	trust_name Trust Name	school_sponsored School Sponsored	federation Federation	unique_property_reference_number Unique Property Reference Number	further_education_type Further Education Type	ofsted_special_measures Ofsted Special Measures	street Street	locality Locality	address_3 Address 3	town Town	postcode Postcode	website Website	telephone_number Telephone Number	head_title Head Title	head_first_name Head First Name	head_last_name Head Last Name	head_preferred_job_title Head Preferred Job Title	teen_mothers Teen Mothers	child_care_facilities Child Care Facilities	special_education_needs_pupil_referral_unit Special Education Needs Pupil Referral Unit	emotional_behavioural_difficulties Emotional Behavioural Difficulties	education_by_other Education By Other	section_41_approved Section 41 Approved	special_education_needs_1 Special Education Needs 1	region Region	administrative_ward Administrative Ward	parliamentary_constituency Parliamentary Constituency	urban_rural Urban Rural	gssla_code GSSLA Code	easting Easting	northing Northing	middle_super_output_area Middle Super Output Area	lower_super_output_area Lower Super Output Area	boarding_establishment Boarding Establishment	previous_local_authority_code Previous Local Authority Code	previous_establishment_number Previous Establishment Number	longitude Longitude	latitude Latitude	spatial_accuracy Spatial Accuracy	last_uploaded Last Uploaded	location Location
139243	309	Haringey	7904	Area 51 Education Ltd	Special post 16 institution	Open	New Provision		Not applicable	19	25		Not applicable	Mixed	None	Not applicable			Not applicable					Not applicable		Not applicable	Not applicable	10024163	Not applicable	Not applicable	1 Mallard Place	Coburg Road		London	N22 6TS	http://www.area51ed.org.uk/	2088817739		Nicki	Quarterman	CEO	Not applicable		Not applicable	Not applicable		Approved		London	Noel Park	Hornsey and Wood Green	(England/Wales) Urban major conurbation	E09000014	530711	190006	Haringey 016	Haringey 016B		999		-0.114376	51.593749	Unknown	Fri Apr 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	(51.593749, -0.114376)
149158	202	Camden	6006	City Junior School	Other independent school	Open	New Provision		Not applicable	7	11		Does not have a sixth form	Mixed		Not applicable		225	Not applicable	144	37	107		Not applicable		Not applicable	Not applicable			Not applicable	CITY JUNIOR SCHOOL	4 GRAY'S INN PLACE	LONDON		WC1R 5EY	http://www.cityjuniorschool.org.uk	2078475512	Ms	Rachel	Thompson		Not applicable		Not applicable	Not applicable		Not approved		London	Holborn & Covent Garden	Holborn and St Pancras	(England/Wales) Urban major conurbation	E09000007	531010	181703	Camden 028	Camden 028B	Does not have boarders	999		-0.113152	51.519064	Unknown	Fri Apr 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	(51.519064, -0.113152)
150298	202	Camden	6010	Wildwood Nature School	Other independent school	Open	New Provision		Not applicable	4	11		Does not have a sixth form	Mixed		Not applicable		40	Not applicable					Not applicable		Not applicable	Not applicable			Not applicable	St Mary Brookfield Hall	York Rise		London	NW5 1SB		7870651598		Tara	Royle		Not applicable		Not applicable	Not applicable		Not approved		London	Highgate	Holborn and St Pancras	(England/Wales) Urban major conurbation	E09000007	528735	186194	Camden 003	Camden 003A		999		-0.144281	51.559947	Unknown	Fri Apr 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	(51.559947, -0.144281)
137502	302	Barnet	6001	Peninim	Other independent school	Open	New Provision		Not applicable	2	11	No boarders	Does not have a sixth form	Girls	None	Not applicable	Not applicable	110	Not applicable	113	27	86		Not applicable		Not applicable	Not applicable	10075169	Not applicable	Not applicable	37 Elmcroft Crescent		Barnet	London	NW11 9TB		2080042224	Mrs	Chaya	Shlesinger	Headteacher	Not applicable		Not applicable	Not applicable		Not approved		London	Golders Green	Finchley and Golders Green	(England/Wales) Urban major conurbation	E09000003	524149	187733	Barnet 037	Barnet 037D	Does not have boarders	999		-0.20986	51.574805	Unknown	Fri Apr 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	(51.574805, -0.20986)
146552	302	Barnet	7900	Oakbridge Special Education	Special post 16 institution	Open	Not Recorded		Not applicable	19	25	No boarders	Not applicable	Mixed	Does not apply	Not applicable		33	Not applicable					Not applicable		Not applicable	Not applicable	10068038		Not applicable	30 High Street			Edgware	HA8 7EQ	https://oakbridgesen.org	2030260611	Ms	Lynda	Walker		Not applicable		Not applicable	Not applicable		Not approved		London	Burnt Oak	Hendon	(England/Wales) Urban major conurbation	E09000003	526353	189442	Barnet 018	Barnet 018C		999		-0.177458	51.589674	Unknown	Fri Apr 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	(51.589674, -0.177458)
139594	302	Barnet	4001	The Archer Academy	Free schools	Open	New Provision		Secondary	11	16	Not applicable	Does not have a sixth form	Mixed	None		Non-selective	810	Not applicable	813	420	393	9.8	Supported by a single-academy trust	THE ARCHER ACADEMY	-	Not applicable	10041683	Not applicable	Not applicable	Eagans Close			London	N2 8GA	http://thearcheracademy.org.uk/	2083654110		Lucy	Harrison		Not applicable		Not applicable	Not applicable		Not applicable		London	East Finchley	Finchley and Golders Green	(England/Wales) Urban major conurbation	E09000003	526880	189661	Barnet 029	Barnet 029A		999		-0.169776	51.591524	Unknown	Fri Apr 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	(51.591524, -0.169776)
148421	302	Barnet	8600	Woodhouse College	Academy 16-19 converter	Open	Academy Converter		16 plus	16	19	No boarders	Has a sixth form	Mixed	Does not apply	Not applicable	Non-selective	1500	Not applicable					Supported by a multi-academy trust	FRONTIER LEARNING TRUST	-	Not applicable	10087582		Not applicable	Woodhouse Road			London	N12 9EY	http://www.woodhouse.ac.uk	2084451210	Ms	Sugra	Alibhai		Not applicable		Not applicable	Not applicable		Not applicable		London	Woodhouse	Finchley and Golders Green	(England/Wales) Urban major conurbation	E09000003	526894	191882	Barnet 019	Barnet 019E		999	4015	-0.168771	51.61148	Unknown	Fri Apr 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	(51.61148, -0.168771)
140495	206	Islington	2000	Whitehall Park School	Free schools	Open	New Provision		Primary	4	11		Does not have a sixth form	Mixed	None		Non-selective	390	Not applicable	266	130	136	42.6	Supported by a multi-academy trust	BELLEVUE PLACE EDUCATION TRUST	-	Not applicable	10046818	Not applicable	Not applicable	106 Hornsey Lane			London	N6 5EP	http://www.whitehallparkschool.co.uk/	2075610113	Mrs	Nicola	Coyle		Not applicable		Not applicable	Not applicable		Not applicable		London	Hillrise	Islington North	(England/Wales) Urban major conurbation	E09000019	529459	187564	Islington 002	Islington 002C		999		-0.133339	51.572093	Unknown	Fri Apr 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	(51.572093, -0.133339)
102175	309	Haringey	7000	Blanche Nevile School	Community special school	Open	Not applicable	Not applicable	Not applicable	3	16	No boarders	Not applicable	Mixed	Does not apply	Not applicable	Not applicable	68	Not applicable	67	31	36	43.1	Not applicable		Not applicable	Not under a federation	10014913	Not applicable	Not applicable	Burlington Road		Muswell Hill	London	N10 1NJ	http://www.blanchenevile.org.uk	2084422750	Ms	Helen	Taylor	Headteacher	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	HI - Hearing Impairment	London	Fortis Green	Hornsey and Wood Green	(England/Wales) Urban major conurbation	E09000014	528067	190032	Haringey 014	Haringey 014C		999		-0.152514	51.59459	Unknown	Fri Apr 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	(51.59459, -0.152514)
102120	309	Haringey	2057	Tiverton Primary School	Community school	Open	Not applicable	Not applicable	Primary	3	11	No boarders	Does not have a sixth form	Mixed	Does not apply	Not applicable	Not applicable	420	No Special Classes	293	148	145	51.5	Not applicable		Not applicable	Not under a federation	10080059	Not applicable	Not applicable	Pulford Road			London	N15 6SP	http://www.tivertonprimary.co.uk	2088003779	Miss	Amardeep	Panesar	Headteacher	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable	Not applicable		London	Hermitage & Gardens	Tottenham	(England/Wales) Urban major conurbation	E09000014	532741	188181	Haringey 032	Haringey 032C		999		-0.085777	51.576875	Unknown	Fri Apr 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	(51.576875, -0.085777)


CREATE TABLE table_1 (
  "unique_reference_number" BIGINT,
  "local_authority_code" BIGINT,
  "local_authority_name" VARCHAR,
  "establishment_number" DOUBLE,
  "establishment_name" VARCHAR,
  "type_of_establishment" VARCHAR,
  "establishment_status" VARCHAR,
  "reason_establishment_opened" VARCHAR,
  "open_date" VARCHAR,
  "reason_establishment_closed" VARCHAR,
  "close_date" VARCHAR,
  "phase_of_education" VARCHAR,
  "statutory_low_age" DOUBLE,
  "statutory_high_age" DOUBLE,
  "boarders" VARCHAR,
  "official_sixth_form" VARCHAR,
  "gender" VARCHAR,
  "religious_character" VARCHAR,
  "diocese" VARCHAR,
  "admissions_policy" VARCHAR,
  "school_capacity" DOUBLE,
  "special_classes" VARCHAR,
  "census_date" VARCHAR,
  "number_of_pupils" DOUBLE,
  "number_of_boys" DOUBLE,
  "number_of_girls" DOUBLE,
  "percentage_claiming_free_school_meals" DOUBLE,
  "trust_school" VARCHAR,
  "trust_name" VARCHAR,
  "school_sponsored" VARCHAR,
  "school_sponsor" VARCHAR,
  "federation" VARCHAR,
  "federation_name" VARCHAR,
  "unique_property_reference_number" DOUBLE,
  "further_higher_education_identifier" DOUBLE,
  "further_education_type" VARCHAR,
  "ofsted_last_inspected" VARCHAR,
  "ofsted_special_measures" VARCHAR,
  "last_changed_date" VARCHAR,
  "street" VARCHAR,
  "locality" VARCHAR,
  "address_3" VARCHAR,
  "town" VARCHAR,
  "county" VARCHAR,
  "postcode" VARCHAR,
  "website" VARCHAR,
  "telephone_number" DOUBLE,
  "head_title" VARCHAR,
  "head_first_name" VARCHAR,
  "head_last_name" VARCHAR,
  "head_preferred_job_title" VARCHAR,
  "teen_mothers" VARCHAR,
  "teen_mothers_places" DOUBLE,
  "child_care_facilities" VARCHAR,
  "special_education_needs_pupil_referral_unit" VARCHAR,
  "emotional_behavioural_difficulties" VARCHAR,
  "full_time_provision" VARCHAR,
  "education_by_other" VARCHAR,
  "section_41_approved" VARCHAR,
  "special_education_needs_1" VARCHAR,
  "special_education_needs_2" VARCHAR,
  "region" VARCHAR,
  "administrative_ward" VARCHAR,
  "parliamentary_constituency" VARCHAR,
  "urban_rural" VARCHAR,
  "gssla_code" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "middle_super_output_area" VARCHAR,
  "lower_super_output_area" VARCHAR,
  "boarding_establishment" VARCHAR,
  "previous_local_authority_code" BIGINT,
  "previous_local_authority_name" VARCHAR,
  "previous_establishment_number" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "spatial_accuracy" VARCHAR,
  "last_uploaded" TIMESTAMP,
  "location" VARCHAR
);