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	2013	178	174		150	2	166	104	40	10	6		1		23	127			119	42	326
8164500	Archbishop Holgates CE School	2013	216	201		94	1	192	71	17	14	2		3	126	65	73			29		296
8164003	Canon Lee School	2013	190	111		53		107	26	17	7	6	1		140	1	22					164
8164153	Fulford School	2013	208	213	31	167	3	243	99	47	16	9		10	231	4	169					414
8164063	Huntington School	2013	239	237		163		230	106	45	11	8		3	170	22	205					400
8164508	Joseph Rowntree School	2013	220	196		140	2	195	92	35	11	5		5	170	20	143					338
8164602	Manor CE School	2013	180	180	56	160		234	116	34	8	4		5				172	96	123		396
8164229	Millthorpe School	2013	204	170		186	1	144	121	73	11	4	4	3	181	13	156					357
8164703	York High School	2013	180	180		87		170	50	30	8	8	1	5	218	12	31					267


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