School Level Data For All Preferences In Primary Admissions Rounds

dfenumber DfENumber	schoolname SchoolName	year Year	places Places	placeallocated PlaceAllocated	placerefused PlaceRefused	placewithdrawn PlaceWithdrawn	withdrawn_from_process Withdrawn From Process	n_1stpref 1stPref	n_2ndpref 2ndPref	n_3rdpref 3rdPref	n_4thpref 4thPref	n_5thpref 5thPref	sle SLE	catchment Catchment	sibling Sibling	distance Distance	total Total
8162000	Acomb Primary School	2019	45	45	11	83	2	56	40	28	9	8		40	7	94	141
8162431	Badger Hill Primary School	2019	30	30	6	40	3	28	26	11	6	8	1	8	11	59	79
8162386	Bishopthorpe Infant School	2019	60	51		82	5	53	39	21	19	6	2	35	4	97	138
8162024	Burton Green Primary School	2019	30	14		12		14	4	5	2	1		14	3	9	26
8162003	Carr Infant School	2019	90	67		41		65	24	8	7	4		65	2	41	108
8162018	Clifton Green Primary School	2019	60	58		24	3	57	10	11	5	2		30	10	45	85
8162430	Clifton with Rawcliffe Primary School	2019	90	90	1	37	1	89	27	11	2		1	82	6	40	129
8162013	Copmanthorpe Primary School	2019	60	51		49		50	24	11	9	6	2	43	4	51	100
8162007	Dringhouses Primary School	2019	45	45	10	96	2	51	37	34	22	9	1	38	6	108	153
8163151	Dunnington CE Primary School	2019	30	19		9		18	5	4		1		17		11	28


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