School Level Data For Allocated Preferences In Primary Admissions Round

dfenumber DfENumber	schoolname SchoolName	year Year	places Places	placeallocated PlaceAllocated	n_1stpref 1stPref	n_2ndpref 2ndPref	n_4thpref 4thPref	sle SLE	catchment Catchment	sibling Sibling	distance Distance	total Total
8162000	Acomb Primary School	2019	45	45	44	1			29	7	9	45
8162431	Badger Hill Primary School	2019	30	30	25	5		1	5	10	14	30
8162386	Bishopthorpe Infant School	2019	60	51	48	3		1	32	3	15	51
8162024	Burton Green Primary School	2019	30	14	14				11	3		14
8162003	Carr Infant School	2019	90	67	65	2			51	2	14	67
8162018	Clifton Green Primary School	2019	60	58	57	1			28	10	20	58
8162430	Clifton with Rawcliffe Primary School	2019	90	90	88	1	1	1	68	6	15	90
8162013	Copmanthorpe Primary School	2019	60	51	50	1		2	41	4	4	51
8162007	Dringhouses Primary School	2019	45	45	45			1	23	5	16	45
8163151	Dunnington CE Primary School	2019	30	19	18	1			17		2	19


CREATE TABLE admissions_summary_allocated_primary_2019 (
  "dfenumber" BIGINT,
  "schoolname" VARCHAR,
  "year" BIGINT,
  "places" BIGINT,
  "placeallocated" BIGINT,
  "n_1stpref" BIGINT,
  "n_2ndpref" BIGINT,
  "n_3rdpref" BIGINT,
  "n_4thpref" BIGINT,
  "n_5thpref" BIGINT,
  "unplaced" BIGINT,
  "sle" BIGINT,
  "catchment" BIGINT,
  "sibling" BIGINT,
  "distance" BIGINT,
  "outsidespecifiedarea" BIGINT,
  "insidespecifiedarea" BIGINT,
  "religion" BIGINT,
  "feeder" BIGINT,
  "other" BIGINT,
  "total" BIGINT
);