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	2014	45	45	4	84	1	33	47	30	14	10		1	42	4	87	134
8162431	Badger Hill Primary School	2014	30	25		31		23	22	6	5			2	4	12	38	56
8162386	Bishopthorpe Infant School	2014	60	60	2	78	2	58	36	29	13	6		2	49	6	85	142
8162024	Burton Green Primary School	2014	30	30		14	1	29	8	4	2	1	1		28	1	15	45
8162003	Carr Infant School	2014	80	81		52	2	75	28	14	10	8			72	8	55	135
8162018	Clifton Green Primary School	2014	55	53		24	3	48	14	10	2	3	3		39	12	26	80
8162430	Clifton with Rawcliffe Primary School	2014	90	90	14	59	2	100	44	13	5	3		1	90	6	68	165
8162013	Copmanthorpe Primary School	2014	60	59		43	2	53	20	9	13	9			38	9	57	104
8162007	Dringhouses Primary School	2014	45	45	14	67	5	58	27	21	15	10		3	38	8	82	131
8163151	Dunnington Ce Primary School	2014	40	38		7	1	38	5	3				1	36	1	8	46


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