School Level Data For All Preferences In Primary Admissions Rounds

dfenumber DfENumber	schoolname SchoolName	year Year	places Places	place_allocated Place Allocated	place_refused Place Refused	place_withdrawn Place Withdrawn	withdrawn_from_process Withdrawn From Process	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	unplaced Unplaced	sle SLE	catchment Catchment	sibling Sibling	distance Distance	total Total
8162000	Acomb Primary School	2022	45	45	23	76		64	43	23	9	5		1	49	14	80	144
8162431	Badger Hill Primary School	2022	30	30	2	44	1	25	27	12	7	6			9	10	58	77
8162386	Bishopthorpe Infant School	2022	50	25		50		23	24	18	8	2		1	18	2	54	75
8162024	Burton Green Primary School	2022	30	11		21		11	10	8	2	1			9	2	21	32
8162003	Carr Infant School	2022	90	50		34	2	45	16	13	6	4	2	2	47	2	33	86
8162018	Clifton Green Primary School	2022	60	55		24	1	54	10	7	4	4	1	1	34	11	33	80
8162430	Clifton with Rawcliffe Primary School	2022	90	88		38	2	89	28	8	3			3	70	5	50	128
8162013	Copmanthorpe Primary School	2022	60	35		15		35	6	1	6	2			33	1	16	50
8162007	Dringhouses Primary School	2022	45	45	11	65		53	29	21	11	7			28	11	82	121
8163151	Dunnington CE Primary School	2022	30	24		17	1	23	8	6	4	1			20		22	42


CREATE TABLE admissions_summary_all_primary_2022 (
  "dfenumber" DOUBLE,
  "schoolname" VARCHAR,
  "year" DOUBLE,
  "places" DOUBLE,
  "place_allocated" DOUBLE,
  "place_refused" DOUBLE,
  "place_withdrawn" DOUBLE,
  "withdrawn_from_process" DOUBLE,
  "n_1st_preference" DOUBLE,
  "n_2nd_preference" DOUBLE,
  "n_3rd_preference" DOUBLE,
  "n_4th_preference" DOUBLE,
  "n_5th_preference" DOUBLE,
  "unplaced" DOUBLE,
  "sle" DOUBLE,
  "catchment" DOUBLE,
  "sibling" DOUBLE,
  "distance" DOUBLE,
  "outsidespecifiedarea" DOUBLE,
  "insidespecifiedarea" DOUBLE,
  "religion" DOUBLE,
  "total" DOUBLE
);