School Level Data For All Preferences In Secondary 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	outsidespecifiedarea OutsideSpecifiedArea	insidespecifiedarea InsideSpecifiedArea	religion Religion	feeder Feeder	total Total
8164702	All Saints Rc School	2014	178	165		187	2	154	127	49	15	9		6		23	159			118	48	354
8164500	Archbishop Holgates CE School	2014	183	183	21	94	1	188	76	25	5	5		5	126	49	119					299
8164500	Archbishop Holgates CE School	2014	33	33		2		33	2											35		35
8164003	Canon Lee School	2014	190	120		50		104	28	16	8	4	10	2	142	3	13					170
8164153	Fulford School	2014	208	220	28	163	3	240	115	38	17	4		7	241	3	163					414
8164063	Huntington School	2014	239	239	23	190		255	125	50	18	4		5	177	34	236					452
8164508	Joseph Rowntree School	2014	220	220	26	179	1	237	135	42	9	3		7	208	18	193					426
8164602	Manor CE Academy	2014	90	90	54	149	1	139	91	49	6	9		12				167	115			294
8164602	Manor CE Academy	2014	110	110	3	6	2	113	7	1										121		121
8164229	Millthorpe School	2014	204	204		182	2	171	126	66	16	2	7	7	172	22	180					388


CREATE TABLE admissions_summary_all_secondary_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
);