School Level Data For Allocated Preferences In Primary Admissions Round

dfenumber DfENumber	schoolname SchoolName	year Year	places Places	place_allocated Place Allocated	n_1st_preference 1st Preference	n_2nd_preference 2nd Preference	n_3rd_preference 3rd Preference	n_4th_preference 4th Preference	unplaced Unplaced	sle SLE	catchment Catchment	sibling Sibling	distance Distance	total Total
8162000	Acomb Primary School	2022	45	45	42	2		1			38	7		45
8162431	Badger Hill Primary School	2022	30	30	24	5	1				5	10	15	30
8162386	Bishopthorpe Infant School	2022	50	25	23	1	1			1	17	2	5	25
8162024	Burton Green Primary School	2022	30	11	11						5	2	4	11
8162003	Carr Infant School	2022	90	50	45	3			2	1	35	2	10	50
8162018	Clifton Green Primary School	2022	60	55	54				1		26	11	17	55
8162430	Clifton with Rawcliffe Primary School	2022	90	88	88					2	63	5	18	88
8162013	Copmanthorpe Primary School	2022	60	35	35						32	1	2	35
8162007	Dringhouses Primary School	2022	45	45	43	1	1				24	11	10	45
8163151	Dunnington CE Primary School	2022	30	24	23		1				20		4	24


CREATE TABLE admissions_summary_allocated_primary_2022 (
  "dfenumber" BIGINT,
  "schoolname" VARCHAR,
  "year" BIGINT,
  "places" BIGINT,
  "place_allocated" BIGINT,
  "n_1st_preference" BIGINT,
  "n_2nd_preference" DOUBLE,
  "n_3rd_preference" DOUBLE,
  "n_4th_preference" DOUBLE,
  "unplaced" DOUBLE,
  "sle" BIGINT,
  "catchment" BIGINT,
  "sibling" DOUBLE,
  "distance" DOUBLE,
  "outsidespecifiedarea" BIGINT,
  "insidespecifiedarea" DOUBLE,
  "religion" BIGINT,
  "total" BIGINT
);