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_3rdpref 3rdPref	sle SLE	catchment Catchment	sibling Sibling	distance Distance	total Total
8162000	Acomb Primary School	2018	45	45	45				33	11	1	45
8162431	Badger Hill Primary School	2018	30	24	20	4			4	10	10	24
8162386	Bishopthorpe Infant School	2018	60	59	59				48	4	7	59
8162024	Burton Green Primary School	2018	30	21	21			1	11	7	2	21
8162003	Carr Infant School	2018	90	90	85	4	1		64	10	16	90
8162018	Clifton Green Primary School	2018	60	54	52	1	1		29	8	17	54
8162430	Clifton with Rawcliffe Primary School	2018	90	79	79				63	5	11	79
8162013	Copmanthorpe Primary School	2018	60	52	52				46	3	3	52
8162007	Dringhouses Primary School	2018	45	45	43	2			29	7	9	45
8163151	Dunnington CE Primary School	2018	30	30	30				30			30


CREATE TABLE admissions_summary_allocated_primary_2018 (
  "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
);