School Level Data For All Preferences In Secondary Admissions Rounds

dfecode DfECode	schoolname SchoolName	band_name Band Name	places Places	place_allocated Place Allocated	place_refused Place Refused	place_withdrawn Place Withdrawn	withdrawn_from_process Withdrawn From Process	total Total	n_1st_preference 1st Preference	n_2nd_preference 2nd Preference	n_3rd_preference 3rd Preference	n_4th_preference 4th Preference	n_5th_preference 5th Preference	total_1 Total.1	sle SLE	catchment Catchment	sibling Sibling	feeder_school Feeder School	distance Distance	religion Religion	inside_sepcified_area Inside Sepcified Area	other Other	total_2 Total.2
8164702	All Saints RC School	Community	178	178	29	267	6	480	193	149	93	42	3	480	10			66	259	139		4	480
8164500	Archbishop Holgates CE School	Community	263	263	43	206	6	518	286	152	47	23	10	518	16	145	103		253			1	518
8164500	Archbishop Holgates CE School	Foundation	37	37		4		41	36	2	2	1		41						41			41
8164153	Fulford School	Community	299	299	53	259	4	615	329	171	81	23	11	615	9	291	16	24	275				615
8164153	Fulford School	Staff	1	1				1	1					1								1	1
8164063	Huntington School	Community	239	239	37	206	6	488	271	141	44	23	9	488	16	200	17		255				488
8164508	Joseph Rowntree School	Community	210	210		173	3	386	187	113	51	17	18	386	14	185	13		174				386
8164602	Manor CE Academy	Community	206	206	1	185	9	401	196	130	47	20	8	401	10		31		202		158		401
8164602	Manor CE Academy	Foundation	29	29		7		36	29	6			1	36						36			36
8164602	Manor CE Academy	Staff	5	5		1		6	5	1				6								6	6


CREATE TABLE admissions_summary_all_secondary_2025 (
  "dfecode" BIGINT,
  "schoolname" VARCHAR,
  "band_name" VARCHAR,
  "places" BIGINT,
  "place_allocated" BIGINT,
  "place_refused" DOUBLE,
  "place_withdrawn" DOUBLE,
  "withdrawn_from_process" DOUBLE,
  "total" BIGINT,
  "n_1st_preference" BIGINT,
  "n_2nd_preference" DOUBLE,
  "n_3rd_preference" DOUBLE,
  "n_4th_preference" DOUBLE,
  "n_5th_preference" DOUBLE,
  "non_preference" DOUBLE,
  "n_6th" DOUBLE,
  "total_1" BIGINT,
  "sle" DOUBLE,
  "catchment" DOUBLE,
  "sibling" DOUBLE,
  "feeder_school" DOUBLE,
  "distance" DOUBLE,
  "unplaced" DOUBLE,
  "religion" DOUBLE,
  "inside_sepcified_area" DOUBLE,
  "other" DOUBLE,
  "total_2" BIGINT
);