School Level Data For All Preferences In Secondary Admissions Rounds

dfenumber DfENumber	schoolname SchoolName	year Year	places Places	place_allocated Place Allocated	place_refused Place Refused	place_withdrawn Place Withdrawn	withdrawnfromprocess WithdrawnFromProcess	total Total	n_1stpref 1stPref	n_2ndpref 2ndPref	n_3rdpref 3rdPref	n_4thpref 4thPref	n_5thpref 5thPref	unplaced Unplaced	sle SLE	catchment Catchment	sibling Sibling	feeder_school Feeder School	distance Distance	insidespecifiedarea InsideSpecifiedArea	religion Religion	total_1 Total.1
8164702	All Saints RC School	2021	178	178	60	276	3	517	217	157	96	36	11		14		23	43	291		146	517
8164500	Archbishop Holgates CE School	2021	300	299		208	7	514	277	145	43	27	12	10	13	121	115		232		23	514
8164153	Fulford School	2021	240	260	33	241	4	538	288	132	80	23	15		5	280	4		249			538
8164063	Huntington School	2021	239	239	28	232	3	502	262	145	55	27	13		5	193	23		281			502
8164508	Joseph Rowntree School	2021	232	232	4	181	2	419	220	123	44	20	12		13	224	16		166			419
8164602	Manor CE Academy	2021	240	240	13	184	2	439	233	107	77	15	7		7		13	9	210	156	44	439
8164229	Millthorpe School	2021	212	212	44	249	2	507	224	170	86	20	7		8	267	8		224			507
8164000	Vale of York Academy	2021	150	160	5	64		229	157	27	21	13	11		1	195	2		31			229
8164001	York High School	2021	180	154		88	2	244	116	46	24	24	10	24	4	175	4		37			244


CREATE TABLE admissions_summary_all_secondary_2021 (
  "dfenumber" BIGINT,
  "schoolname" VARCHAR,
  "year" BIGINT,
  "places" BIGINT,
  "place_allocated" BIGINT,
  "place_refused" DOUBLE,
  "place_withdrawn" BIGINT,
  "withdrawnfromprocess" DOUBLE,
  "total" BIGINT,
  "n_1stpref" BIGINT,
  "n_2ndpref" BIGINT,
  "n_3rdpref" BIGINT,
  "n_4thpref" BIGINT,
  "n_5thpref" BIGINT,
  "unplaced" DOUBLE,
  "sle" BIGINT,
  "catchment" BIGINT,
  "sibling" BIGINT,
  "feeder_school" DOUBLE,
  "distance" BIGINT,
  "insidespecifiedarea" BIGINT,
  "religion" BIGINT,
  "total_1" BIGINT
);