schools

Data source: Big Local News · About: Big Local

Custom SQL query returning 101 rows (hide)

select rowid, state, county, county_state_id, admin_level, district_nces_id, district_state_id, district_state_type, district, school_nces_id, school_state_id, school, school_state_type, ccd_school_type, ccd_charter_school, ccd_school_lvl, ccd_school_low_grade, ccd_school_high_grade, year, term, grade, white, black, hispanic, native_american, native_american_alaskan_native, asian, native_hawaiian, asian_pacific_islander, native_hawaiian_pacific_islander, pacific_islander, multiracial, unknown_race, male, female, non_binary, unknown_gender, ell, ell_percent, homeless, homeless_percent, low_income, free_and_reduced, free_and_reduced_percent, disability, section_504, total, white_int, black_int, hispanic_int, native_american_int, native_american_alaskan_native_int, asian_int, native_hawaiian_int, asian_pacific_islander_int, native_hawaiian_pacific_islander_int, pacific_islander_int, multiracial_int, unknown_race_int, male_int, female_int, non_binary_int, unknown_gender_int, ell_int, homeless_int, low_income_int, free_and_reduced_int, disability_int, section_504_int, total_int from enrollments where "state" = :p0 and (total > :p2 or (total = :p2 and rowid > :p1)) order by total, rowid limit 101

Query parameters

This data as json, CSV

rowid	state	county	admin_level	district_nces_id	district_state_id	district	school_nces_id	school_state_id	school	ccd_school_type	ccd_charter_school	ccd_school_lvl	ccd_school_low_grade	ccd_school_high_grade	year	grade	white	black	hispanic	native_american	asian	native_hawaiian_pacific_islander	multiracial	male	female	total	male_int	female_int
1123257	MA	Suffolk	school	2502790	35	Boston	250279000952	350426	Dr. William Henderson Upper	Regular School	No	Other	03	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123261	MA	Suffolk	school	2502790	35	Boston	250279000216	350430	Clarence R Edwards Middle	Regular School	No	Middle	06	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123265	MA	Suffolk	school	2502790	35	Boston	250279000334	350445	Washington Irving Middle	Regular School	No	Middle	06	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123269	MA	Suffolk	school	2502790	35	Boston	250279000258	350485	James P Timilty Middle	Regular School	No	Middle	06	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123279	MA	Suffolk	school	2502790	35	Boston	250279002015	350507	Boston International High School	Regular School	No	High	09	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123285	MA	Suffolk	school	2502790	35	Boston	250279001617	350518	Community Academy	Regular School	No	High	09	12	2017	grade_9	*	*	*	*	*	*	*	2	*	*	2
1123289	MA	Suffolk	school	2502790	35	Boston	250279001617	350518	Community Academy	Regular School	No	High	09	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123294	MA	Suffolk	school	2502790	35	Boston	250279002016	350522	Excel High School	Regular School	No	High	09	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123299	MA	Suffolk	school	2502790	35	Boston	250279000261	350525	Jeremiah E Burke High	Regular School	No	High	09	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123319	MA	Suffolk	school	2502790	35	Boston	250279000695	350540	Fenway High School	Alternative School	No	High	09	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123324	MA	Suffolk	school	2502790	35	Boston	250279000698	350541	Another Course To College	Alternative School	No	High	09	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123329	MA	Suffolk	school	2502790	35	Boston	250279000704	350542	New Mission High School	Alternative School	No	High	09	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123330	MA	Suffolk	school	2502790	35	Boston	250279000837	350543	Greater Egleston Community High School	Regular School	No	High	09	12	2017	grade_9	*	*	*	*	*	*	*	1	1	*	1	1
1123334	MA	Suffolk	school	2502790	35	Boston	250279000837	350543	Greater Egleston Community High School	Regular School	No	High	09	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123341	MA	Suffolk	school	2502790	35	Boston	250279000204	350545	Boston Latin Academy	Regular School	No	High	07	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123346	MA	Suffolk	school	2502790	35	Boston	250279001128	350546	Boston Arts Academy	Alternative School	No	High	09	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123349	MA	Suffolk	school	2502790	35	Boston	250279001511	350548	Boston Adult Academy	Alternative School	No	High	11	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123354	MA	Suffolk	school	2502790	35	Boston	250279002753	350549	Margarita Muniz Academy	Regular School	No	High	09	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123359	MA	Suffolk	school	2502790	35	Boston	250279001692	350558	Boston Community Leadership Academy	Regular School	No	High	09	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123366	MA	Suffolk	school	2502790	35	Boston	250279000203	350560	Boston Latin	Regular School	No	High	07	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123381	MA	Suffolk	school	2502790	35	Boston	250279000205	350575	O'Bryant School Math/Science	Regular School	No	High	07	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123386	MA	Suffolk	school	2502790	35	Boston	250279001898	350579	Urban Science Academy	Regular School	No	High	09	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123396	MA	Suffolk	school	2502790	35	Boston	250279002676	350651	Dorchester Academy	Regular School	No	High	09	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123401	MA	Suffolk	school	2502790	35	Boston	250279002674	350655	Lyon Upper 9-12	Regular School	No	High	09	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123412	MA	Suffolk	school	2502790	35	Boston	250279002721	350656	Mario Umana Academy	Regular School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123420	MA	Suffolk	school	2502790	35	Boston	250279002725	350657	TechBoston Academy	Regular School	No	Other	06	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123430	MA	Suffolk	school	2502790	35	Boston	250279000217	350690	Snowden International School at Copley	Regular School	No	High	09	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123441	MA	Suffolk	school	2502790	35	Boston	250279000312	350691	Rafael Hernandez	Regular School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123444	MA	Suffolk	school	2502790	35	Boston	250279002374	350750	Horace Mann School for the Deaf	Special Education School	No	Other	PK	12	2017	grade_1	*	*	*	*	*	*	*	2	3	*	2	3
1123449	MA	Suffolk	school	2502790	35	Boston	250279002374	350750	Horace Mann School for the Deaf	Special Education School	No	Other	PK	12	2017	grade_8	*	*	*	*	*	*	*	1	2	*	1	2
1123454	MA	Suffolk	school	2502790	35	Boston	250279002374	350750	Horace Mann School for the Deaf	Special Education School	No	Other	PK	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123456	MA	Suffolk	school	2502790	35	Boston	250279002848	350755	Boston Collaborative High School	Alternative School	No	High	07	12	2017	grade_9	*	*	*	*	*	*	*	2	2	*	2	2
1123460	MA	Suffolk	school	2502790	35	Boston	250279002848	350755	Boston Collaborative High School	Alternative School	No	High	07	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123467	MA	Barnstable	school	2502820	36	Bourne	250282002664	360005	Bournedale Elementary School	Regular School	No	Elementary	PK	04	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123473	MA	Barnstable	school	2502820	36	Bourne	250282000353	360010	Peebles Elementary School	Regular School	No	Elementary	KG	04	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123478	MA	Barnstable	school	2502820	36	Bourne	250282001517	360325	Bourne Middle School	Regular School	No	Middle	05	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123483	MA	Barnstable	school	2502820	36	Bourne	250282000348	360505	Bourne High School	Regular School	No	High	09	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123488	MA	Essex	school	2502880	38	Boxford	250288000357	380005	Harry Lee Cole	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123493	MA	Essex	school	2502880	38	Boxford	250288000358	380013	Spofford Pond	Regular School	No	Elementary	03	06	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123501	MA	Worcester	school	2502910	39	Boylston	250291000359	390005	Boylston Elementary	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123508	MA	Norfolk	school	2502940	40	Braintree	250294002570	400005	Hollis	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123510	MA	Norfolk	school	2502940	40	Braintree	250294002789	400009	Monatiquot Kindergarten Center	Regular School	No	Elementary	KG	KG	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123517	MA	Norfolk	school	2502940	40	Braintree	250294000365	400015	Highlands	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123524	MA	Norfolk	school	2502940	40	Braintree	250294000367	400020	Mary E Flaherty School	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123530	MA	Norfolk	school	2502940	40	Braintree	250294000368	400025	Liberty	Regular School	No	Elementary	01	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123537	MA	Norfolk	school	2502940	40	Braintree	250294000360	400033	Archie T Morrison	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123544	MA	Norfolk	school	2502940	40	Braintree	250294000363	400050	Donald Ross	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123548	MA	Norfolk	school	2502940	40	Braintree	250294000364	400305	East Middle School	Regular School	No	Middle	06	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123552	MA	Norfolk	school	2502940	40	Braintree	250294000372	400310	South Middle School	Regular School	No	Middle	06	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123563	MA	Barnstable	school	2502970	41	Brewster	250297000374	410005	Stony Brook Elementary	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123567	MA	Barnstable	school	2502970	41	Brewster	250297000841	410010	Eddy Elementary	Regular School	No	Elementary	03	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123576	MA	Hampden	school	2503060	43	Brimfield	250306000381	430005	Brimfield Elementary	Regular School	No	Elementary	PK	06	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123583	MA	Plymouth	school	2503090	44	Brockton	250309000388	440001	Dr W Arnone Community School	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123590	MA	Plymouth	school	2503090	44	Brockton	250309002649	440002	Mary E. Baker School	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123597	MA	Plymouth	school	2503090	44	Brockton	250309002655	440003	Manthala George Jr. School	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123599	MA	Plymouth	school	2503090	44	Brockton	250309002792	440007	Barrett Russell School	Regular School	No	Elementary	KG	KG	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123606	MA	Plymouth	school	2503090	44	Brockton	250309000386	440010	Brookfield	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123613	MA	Plymouth	school	2503090	44	Brockton	250309000401	440017	John F Kennedy	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123623	MA	Plymouth	school	2503090	44	Brockton	250309000390	440023	Edgar B Davis	Regular School	No	Elementary	KG	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123630	MA	Plymouth	school	2503090	44	Brockton	250309000396	440045	Hancock	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123633	MA	Plymouth	school	2503090	44	Brockton	250309000221	440050	Gilmore School Early Childhood Center	Regular School	No	Elementary	PK	KG	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123640	MA	Plymouth	school	2503090	44	Brockton	250309000398	440055	Huntington	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123647	MA	Plymouth	school	2503090	44	Brockton	250309001132	440065	Louis F Angelo Elementary	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123654	MA	Plymouth	school	2503090	44	Brockton	250309000405	440078	Oscar F Raymond	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123655	MA	Plymouth	school	2503090	44	Brockton	250309000966	440080	Frederick Douglass Academy	Regular School	No	High	07	12	2017	grade_8	*	*	*	*	*	*	*	3	1	*	3	1
1123658	MA	Plymouth	school	2503090	44	Brockton	250309000966	440080	Frederick Douglass Academy	Regular School	No	High	07	12	2017	grade_12	*	*	*	*	*	*	*	1	2	*	1	2
1123659	MA	Plymouth	school	2503090	44	Brockton	250309000966	440080	Frederick Douglass Academy	Regular School	No	High	07	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123666	MA	Plymouth	school	2503090	44	Brockton	250309000387	440110	Downey	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123667	MA	Plymouth	school	2503090	44	Brockton	250309002544	440400	Goddard Alternative School	Alternative School	No	Other	05	12	2017	grade_5	*	*	*	*	*	*	*	1	1	*	1	1
1123668	MA	Plymouth	school	2503090	44	Brockton	250309002544	440400	Goddard Alternative School	Alternative School	No	Other	05	12	2017	grade_7	*	*	*	*	*	*	*	4	1	*	4	1
1123674	MA	Plymouth	school	2503090	44	Brockton	250309002544	440400	Goddard Alternative School	Alternative School	No	Other	05	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123678	MA	Plymouth	school	2503090	44	Brockton	250309000389	440405	East Middle School	Regular School	No	Middle	06	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123682	MA	Plymouth	school	2503090	44	Brockton	250309000404	440410	North Middle School	Regular School	No	Middle	06	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123686	MA	Plymouth	school	2503090	44	Brockton	250309000407	440415	South Middle School	Regular School	No	Middle	06	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123690	MA	Plymouth	school	2503090	44	Brockton	250309000410	440420	West Middle School	Regular School	No	Middle	06	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123694	MA	Plymouth	school	2503090	44	Brockton	250309002688	440421	Ashfield Middle School	Regular School	No	Middle	06	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123698	MA	Plymouth	school	2503090	44	Brockton	250309002691	440422	Joseph F. Plouffe Academy	Regular School	No	Middle	06	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123712	MA	Plymouth	school	2503090	44	Brockton	250309002752	440520	Edison Academy	Regular School	No	High	09	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123721	MA	Worcester	school	2503120	45	Brookfield	250312000413	450005	Brookfield Elementary	Regular School	No	Elementary	PK	06	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123723	MA	Norfolk	school	2503150	46	Brookline	250315002776	460001	Brookline Early Education Program at Beacon	Regular School	No	Elementary	PK	PK	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123725	MA	Suffolk	school	2503150	46	Brookline	250315002793	460002	Brookline Early Education Program at Putterham	Regular School	No	Elementary	PK	PK	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123735	MA	Norfolk	school	2503150	46	Brookline	250315000416	460005	Edith C Baker	Regular School	No	Elementary	KG	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123745	MA	Norfolk	school	2503150	46	Brookline	250315000417	460015	Edward Devotion	Regular School	No	Elementary	KG	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123756	MA	Norfolk	school	2503150	46	Brookline	250315000421	460020	Michael Driscoll	Regular School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123767	MA	Norfolk	school	2503150	46	Brookline	250315000418	460025	Heath	Regular School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123777	MA	Norfolk	school	2503150	46	Brookline	250315000420	460030	Lawrence	Regular School	No	Elementary	KG	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123787	MA	Norfolk	school	2503150	46	Brookline	250315000423	460035	William H Lincoln	Regular School	No	Elementary	KG	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123797	MA	Norfolk	school	2503150	46	Brookline	250315000422	460040	Pierce	Regular School	No	Elementary	KG	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123808	MA	Norfolk	school	2503150	46	Brookline	250315000419	460045	John D Runkle	Regular School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123810	MA	Norfolk	school	2503150	46	Brookline	250315002027	460060	The Lynch Center	Regular School	No	Elementary	PK	PK	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123823	MA	Middlesex	school	2503240	48	Burlington	250324000427	480007	Fox Hill	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123830	MA	Middlesex	school	2503240	48	Burlington	250324000431	480015	Memorial	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123837	MA	Middlesex	school	2503240	48	Burlington	250324000432	480020	Pine Glen Elementary	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123844	MA	Middlesex	school	2503240	48	Burlington	250324000844	480035	Francis Wyman Elementary	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123848	MA	Middlesex	school	2503240	48	Burlington	250324000429	480303	Marshall Simonds Middle	Regular School	No	Middle	06	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123854	MA	Middlesex	school	2503240	48	Burlington	250324000426	480505	Burlington High	Regular School	No	High	09	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123862	MA	Middlesex	school	2503270	49	Cambridge	250327000435	490005	Maria L. Baldwin	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123873	MA	Middlesex	school	2503270	49	Cambridge	250327001621	490006	Amigos School	Regular School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123881	MA	Middlesex	school	2503270	49	Cambridge	250327000020	490007	Cambridgeport	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123889	MA	Middlesex	school	2503270	49	Cambridge	250327000441	490020	Haggerty	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123897	MA	Middlesex	school	2503270	49	Cambridge	250327000443	490030	Martin Luther King Jr.	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*