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	unplaced Unplaced	sle SLE	catchment Catchment	sibling Sibling	distance Distance	total Total
8162000	Acomb Primary School	2023	45	45	45				2	33	9	1	45
8162431	Badger Hill Primary School	2023	30	26	22	1	1	2		7	8	9	26
8162386	Bishopthorpe Infant School	2023	50	32	31	1				22	3	7	32
8162024	Burton Green Primary School	2023	30	19	19					10	3	6	19
8162003	Carr Infant School	2023	60	60	58	2				46	6	8	60
8162018	Clifton Green Primary School	2023	60	39	39					25	4	10	39
8162430	Clifton with Rawcliffe Primary School	2023	90	69	68	1			1	46	11	11	69
8162013	Copmanthorpe Primary School	2023	60	29	29					27	1	1	29
8162007	Dringhouses Primary School	2023	45	45	43	1	1			23	6	16	45
8163151	Dunnington CE Primary School	2023	30	22	21	1			1	16		5	22


CREATE TABLE admissions_summary_allocated_primary_2023 (
  "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" VARCHAR,
  "insidespecifiedarea" DOUBLE,
  "religion" BIGINT,
  "total" BIGINT
);