School Level Data For All Preferences In Primary Admissions Rounds

dfenumber DfENumber	schoolname SchoolName	year Year	places Places	placeallocated PlaceAllocated	placerefused PlaceRefused	placewithdrawn PlaceWithdrawn	withdrawnfromprocess WithdrawnFromProcess	n_1stpref 1stPref	n_2ndpref 2ndPref	n_3rdpref 3rdPref	n_4thpref 4thPref	n_5thpref 5thPref	unplaced Unplaced	sle SLE	catchment Catchment	sibling Sibling	distance Distance	total Total
8162000	Acomb Primary School	2015	45	45	7	91	2	42	48	38	11	6			49	3	93	145
8162431	Badger Hill Primary School	2015	30	27		38	2	21	26	14	4	2		1	8	11	47	67
8162386	Bishopthorpe Infant School	2015	60	60	1	70		58	31	21	14	7		1	44	4	82	131
8162024	Burton Green Primary School	2015	30	25		13		25	4	4	2	3		1	24	4	9	38
8162003	Carr Infant School	2015	90	90		44	3	71	20	14	8	9	15		73	3	46	137
8162018	Clifton Green Primary School	2015	60	46		31		45	15	14	2	1			30	12	35	77
8162430	Clifton with Rawcliffe Primary School	2015	90	90		41	1	89	29	10	1	3		1	79	9	43	132
8162013	Copmanthorpe Primary School	2015	60	60		59		55	19	23	11	11		1	42	9	67	119
8162007	Dringhouses Primary School	2015	45	47	29	79		67	29	26	22	11			46	15	94	155
8163151	Dunnington Ce Primary School	2015	30	23		18		23	4	9	5				20	1	20	41


CREATE TABLE admissions_summary_all_primary_2015 (
  "dfenumber" BIGINT,
  "schoolname" VARCHAR,
  "year" BIGINT,
  "places" BIGINT,
  "placeallocated" BIGINT,
  "placerefused" BIGINT,
  "placewithdrawn" BIGINT,
  "withdrawnfromprocess" 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
);