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 "grade" = :p0 and "state" = :p1 and "year" = :p2 order by total_int 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	white_int	black_int	hispanic_int	native_american_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int	male_int	female_int	total_int
1122005	MA	Hampden	school	2501800	5	Agawam	250180000026	50303	Roberta G. Doering School	Regular School	No	Middle	05	08	2017	grade_7	*	*	*	*	*	*	*	2	1	*								2	1
1122638	MA	Suffolk	school	2502790	35	Boston	250279000210	350036	Carter Developmental Center	Regular School	No	High	07	12	2017	grade_7	*	*	*	*	*	*	*	1	2	*								1	2
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
1124658	MA	Middlesex	school	2504770	93	Everett	250477002787	930030	Devens School	Regular School	No	Other	KG	12	2017	grade_7	*	*	*	*	*	*	*	2	2	*								2	2
1125193	MA	Dukes	school	2505340	109	Gosnold	250534000725	1090005	Cuttyhunk Elementary	Regular School	No	Middle	06	07	2017	grade_7	*	*	*	*	*	*	*	*	*	*
1125267	MA	Franklin	school	2505490	114	Greenfield	250549002771	1140030	Green River	Regular School	No	Elementary	04	04	2017	grade_7	*	*	*	*	*	*	*	*	*	*
1125425	MA	Essex	school	2505970	128	Haverhill	250597001706	1280073	TEACH	Regular School	No	Other	01	12	2017	grade_7	*	*	*	*	*	*	*	2	1	*								2	1
1129009	MA	Middlesex	school	2510890	274	Somerville	251089002498	2740410	Next Wave Junior High	Alternative School	No	Middle	06	08	2017	grade_7	*	*	*	*	*	*	*	3	*	*								3
1131924	MA	Plymouth	school	2503030	625	Bridgewater-Raynham	250303002866	6250415	Therapeutic Day School	Special Education School	No	Other	05	12	2017	grade_7	*	*	*	*	*	*	*	1	*	*								1
1124811	MA	Bristol	school	2504830	95	Fall River	250483002838	950335	Resiliency Middle School	Regular School	No	Middle	06	08	2017	grade_7	3	0	2	1	0	0	0	4	2	6	3	0	2	1	0	0	0	4	2	6
1126252	MA	Middlesex	school	2507020	160	Lowell	250702002726	1600085	Laura Lee Therapeutic Day School	Regular School	No	Elementary	02	07	2017	grade_7	2	0	3	0	0	0	1	6	*	6	2	0	3	0	0	0	1	6		6
1123448	MA	Suffolk	school	2502790	35	Boston	250279002374	350750	Horace Mann School for the Deaf	Special Education School	No	Other	PK	12	2017	grade_7	1	2	3	0	1	0	0	4	3	7	1	2	3	0	1	0	0	4	3	7
1124819	MA	Bristol	school	2504830	95	Fall River	250483002852	950340	Stone Day School	Regular School	No	Elementary	02	08	2017	grade_7	1	2	2	0	0	0	2	6	*	7	1	2	2	0	0	0	2	6		7
1127389	MA	Bristol	school	2508430	201	New Bedford	250843002590	2010510	Trinity Day Academy	Regular School	No	Other	06	12	2017	grade_7	3	1	4	0	0	0	0	5	3	8	3	1	4	0	0	0	0	5	3	8
1124147	MA	Hampden	school	2503660	61	Chicopee	250366000720	610021	Chicopee Academy	Alternative School	No	Other	06	12	2017	grade_7	1	0	9	0	0	0	0	9	1	10	1	0	9	0	0	0	0	9	1	10
1128279	MA	Barnstable	school	2509840	242	Provincetown	250984002694	2420020	Provincetown Schools	Regular School	No	Elementary	PK	08	2017	grade_7	4	2	4	0	0	0	0	4	6	10	4	2	4	0	0	0	0	4	6	10
1124927	MA	Berkshire	school	2504920	98	Florida	250492000706	980005	Abbott Memorial	Regular School	No	Elementary	PK	08	2017	grade_7	11	0	0	0	0	0	0	6	5	11	11	0	0	0	0	0	0	6	5	11
1126503	MA	Essex	school	2507110	163	Lynn	250711002647	1630525	Fecteau-Leary Junior/Senior High School	Regular School	No	High	07	12	2017	grade_7	3	0	7	0	0	0	1	9	2	11	3	0	7	0	0	0	1	9	2	11
1129370	MA	Hampden	school	2511130	281	Springfield	251113002744	2810360	Balliet Middle School	Regular School	No	Middle	06	08	2017	grade_7	1	2	8	0	0	0	0	7	4	11	1	2	8	0	0	0	0	7	4	11
1125884	MA	Essex	school	2506660	149	Lawrence	250666002625	1490537	School for Exceptional Studies	Regular School	No	Other	01	12	2017	grade_7	2	1	10	0	0	0	0	11	2	13	2	1	10	0	0	0	0	11	2	13
1122991	MA	Suffolk	school	2502790	35	Boston	250279000297	350255	Oliver Hazard Perry	Regular School	No	Elementary	PK	08	2017	grade_7	5	4	4	0	1	0	0	13	1	14	5	4	4	0	1	0	0	13	1	14
1131456	MA	Dukes	school	2500035	466	Martha's Vineyard Charter (District)	250003500569	4660550	Martha's Vineyard Charter School	Regular School	Yes	Other	KG	12	2017	grade_7	10	2	1	0	0	0	1	5	9	14	10	2	1	0	0	0	1	5	9	14
1129358	MA	Hampden	school	2511130	281	Springfield	251113002740	2810345	Springfield Public Day Middle School	Regular School	No	Middle	06	08	2017	grade_7	1	4	11	0	0	0	0	12	4	16	1	4	11	0	0	0	0	12	4	16
1122568	MA	Suffolk	school	2502790	35	Boston	250279002458	350004	Lyon K-8	Regular School	No	Elementary	KG	08	2017	grade_7	5	3	9	0	0	0	0	11	6	17	5	3	9	0	0	0	0	11	6	17
1122873	MA	Suffolk	school	2502790	35	Boston	250279000272	350182	Joseph J Hurley	Regular School	No	Elementary	PK	08	2017	grade_7	1	0	18	0	0	0	0	10	9	19	1	0	18	0	0	0	0	10	9	19
1123191	MA	Suffolk	school	2502790	35	Boston	250279002669	350376	King K-8	Regular School	No	Elementary	PK	08	2017	grade_7	1	14	4	0	0	0	0	10	9	19	1	14	4	0	0	0	0	10	9	19
1124214	MA	Berkshire	school	2503720	63	Clarksburg	250372000510	630010	Clarksburg Elementary	Regular School	No	Elementary	KG	08	2017	grade_7	16	0	1	0	1	0	1	10	9	19	16	0	1	0	1	0	1	10	9	19
1131272	MA	Suffolk	school	2500070	438	Codman Academy Charter Public (District)	250007001667	4380505	Codman Academy Charter Public School	Regular School	Yes	Other	PK	12	2017	grade_7	0	15	4	0	0	0	1	8	12	20	0	15	4	0	0	0	1	8	12	20
1123232	MA	Suffolk	school	2502790	35	Boston	250279000946	350382	Mission Hill School	Regular School	No	Elementary	PK	08	2017	grade_7	6	5	9	0	0	0	1	15	6	21	6	5	9	0	0	0	1	15	6	21
1128555	MA	Berkshire	school	2510080	249	Richmond	251008001635	2490005	Richmond Consolidated	Regular School	No	Elementary	PK	08	2017	grade_7	20	0	1	0	0	0	0	7	14	21	20	0	1	0	0	0	0	7	14	21
1122903	MA	Suffolk	school	2502790	35	Boston	250279000278	350190	Joyce Kilmer	Regular School	No	Elementary	PK	08	2017	grade_7	7	8	7	0	0	0	0	12	10	22	7	8	7	0	0	0	0	12	10	22
1123092	MA	Suffolk	school	2502790	35	Boston	250279000323	350308	Sarah Greenwood	Regular School	No	Elementary	PK	08	2017	grade_7	0	8	14	0	0	0	0	8	14	22	0	8	14	0	0	0	0	8	14	22
1131298	MA	Essex	school	2500027	440	Community Day Charter Public School - Prospect (District)	250002700535	4400205	Community Day Charter Public School - Prospect	Regular School	Yes	Elementary	PK	08	2017	grade_7	2	0	19	0	1	0	0	12	10	22	2	0	19	0	1	0	0	12	10	22
1123871	MA	Middlesex	school	2503270	49	Cambridge	250327001621	490006	Amigos School	Regular School	No	Elementary	PK	08	2017	grade_7	8	1	11	0	1	0	4	13	12	25	8	1	11	0	1	0	4	13	12	25
1127568	MA	Berkshire	school	2508670	209	North Adams	250867001388	2090008	Colegrove Park Elementary	Regular School	No	Elementary	KG	07	2017	grade_7	24	0	0	0	0	0	1	11	14	25	24	0	0	0	0	0	1	11	14	25
1122731	MA	Suffolk	school	2502790	35	Boston	250279000230	350096	Eliot Elementary	Regular School	No	Elementary	PK	08	2017	grade_7	7	7	9	1	1	0	1	12	14	26	7	7	9	1	1	0	1	12	14	26
1123122	MA	Suffolk	school	2502790	35	Boston	250279000333	350346	Warren-Prescott	Regular School	No	Elementary	PK	08	2017	grade_7	7	5	12	0	2	0	0	18	8	26	7	5	12	0	2	0	0	18	8	26
1123439	MA	Suffolk	school	2502790	35	Boston	250279000312	350691	Rafael Hernandez	Regular School	No	Elementary	PK	08	2017	grade_7	1	0	25	0	0	0	0	9	17	26	1	0	25	0	0	0	0	9	17	26
1127921	MA	Dukes	school	2504650	221	Oak Bluffs	250465000625	2210005	Oak Bluffs Elementary	Regular School	No	Elementary	PK	08	2017	grade_7	15	5	4	0	0	2	0	19	7	26	15	5	4	0	0	2	0	19	7	26
1122946	MA	Suffolk	school	2502790	35	Boston	250279000291	350229	Maurice J Tobin	Regular School	No	Elementary	PK	08	2017	grade_7	0	8	19	0	0	0	1	15	13	28	0	8	19	0	0	0	1	15	13	28
1123161	MA	Suffolk	school	2502790	35	Boston	250279000343	350370	William Monroe Trotter	Regular School	No	Elementary	PK	08	2017	grade_7	0	15	11	0	0	1	1	17	11	28	0	15	11	0	0	1	1	17	11	28
1127587	MA	Berkshire	school	2508670	209	North Adams	250867001390	2090035	Brayton	Regular School	No	Elementary	PK	07	2017	grade_7	24	0	2	0	0	0	2	16	12	28	24	0	2	0	0	0	2	16	12	28
1123020	MA	Suffolk	school	2502790	35	Boston	250279000692	350262	Lyndon	Regular School	No	Elementary	PK	08	2017	grade_7	5	4	19	0	0	0	2	11	19	30	5	4	19	0	0	0	2	11	19	30
1123138	MA	Suffolk	school	2502790	35	Boston	250279000342	350363	William McKinley	Regular School	No	Other	01	12	2017	grade_7	1	11	14	0	0	0	4	23	7	30	1	11	14	0	0	0	4	23	7	30
1129216	MA	Hampden	school	2511130	281	Springfield	251113001809	2810095	Alfred G. Zanetti Montessori Magnet School	Regular School	No	Elementary	PK	08	2017	grade_7	6	9	14	0	0	0	2	15	16	31	6	9	14	0	0	0	2	15	16	31
1131416	MA	Essex	school	2500083	455	Hill View Montessori Charter Public (District)	250008301846	4550050	Hill View Montessori Charter Public School	Regular School	Yes	Elementary	KG	08	2017	grade_7	20	1	8	1	0	0	1	10	21	31	20	1	8	1	0	0	1	10	21	31
1131543	MA	Essex	school	2500062	482	River Valley Charter (District)	250006201446	4820050	River Valley Charter School	Regular School	Yes	Elementary	KG	08	2017	grade_7	29	0	0	0	0	0	2	10	21	31	29	0	0	0	0	0	2	10	21	31
1131380	MA	Hampshire	school	2500031	450	Hilltown Cooperative Charter Public (District)	250003100549	4500105	Hilltown Cooperative Charter Public School	Regular School	Yes	Elementary	KG	08	2017	grade_7	23	0	6	0	1	0	2	14	18	32	23	0	6	0	1	0	2	14	18	32
1124604	MA	Dukes	school	2509090	89	Edgartown	250909001469	890005	Edgartown Elementary	Regular School	No	Elementary	PK	08	2017	grade_7	27	1	6	0	0	0	0	23	11	34	27	1	6	0	0	0	0	23	11	34
1122597	MA	Suffolk	school	2502790	35	Boston	250279002687	350012	Boston Teachers Union School	Regular School	No	Elementary	PK	08	2017	grade_7	1	10	20	0	1	0	3	25	10	35	1	10	20	0	1	0	3	25	10	35
1127577	MA	Berkshire	school	2508670	209	North Adams	250867001389	2090015	Greylock	Regular School	No	Elementary	KG	07	2017	grade_7	29	1	2	0	0	0	4	16	20	36	29	1	2	0	0	0	4	16	20	36
1131134	MA	Franklin	school	2500076	413	Four Rivers Charter Public (District)	250007602086	4130505	Four Rivers Charter Public School	Regular School	Yes	High	07	12	2017	grade_7	33	1	1	0	0	0	1	18	18	36	33	1	1	0	0	0	1	18	18	36
1125563	MA	Hampden	school	2506270	137	Holyoke	250627000910	1370025	Morgan Full Service Community School	Regular School	No	Elementary	PK	08	2017	grade_7	1	1	34	0	1	0	0	14	23	37	1	1	34	0	1	0	0	14	23	37
1131323	MA	Suffolk	school	2500029	444	Neighborhood House Charter (District)	250002900545	4440205	Neighborhood House Charter School	Regular School	Yes	Elementary	PK	08	2017	grade_7	8	23	4	2	1	0	0	23	15	38	8	23	4	2	1	0	0	23	15	38
1123103	MA	Suffolk	school	2502790	35	Boston	250279000331	350326	Gardner Pilot Academy	Regular School	No	Elementary	PK	08	2017	grade_7	5	7	23	0	4	0	0	18	21	39	5	7	23	0	4	0	0	18	21	39
1129746	MA	Dukes	school	2512570	296	Tisbury	251257002054	2960005	Tisbury Elementary	Regular School	No	Elementary	PK	08	2017	grade_7	23	0	9	3	1	0	3	19	20	39	23	0	9	3	1	0	3	19	20	39
1131108	MA	Bristol	school	2500525	409	Alma del Mar Charter School (District)	250052502708	4090205	Alma del Mar Charter School	Regular School	Yes	Elementary	KG	07	2017	grade_7	15	7	13	0	2	0	3	17	23	40	15	7	13	0	2	0	3	17	23	40
1131287	MA	Suffolk	school	2500060	439	Conservatory Lab Charter (District)	250006001439	4390050	Conservatory Lab Charter School	Regular School	Yes	Elementary	PK	08	2017	grade_7	3	27	11	0	0	0	0	20	21	41	3	27	11	0	0	0	0	20	21	41
1122701	MA	Suffolk	school	2502790	35	Boston	250279000223	350077	Dennis C Haley	Regular School	No	Elementary	PK	08	2017	grade_7	5	18	18	0	1	0	0	22	20	42	5	18	18	0	1	0	0	22	20	42
1125300	MA	Hampshire	school	2505580	117	Hadley	250558000813	1170505	Hopkins Academy	Regular School	No	High	07	12	2017	grade_7	34	2	3	1	0	1	1	24	18	42	34	2	3	1	0	1	1	24	18	42
1128660	MA	Essex	school	2510380	258	Salem	251038000773	2580050	Saltonstall School	Regular School	No	Elementary	KG	08	2017	grade_7	20	2	15	0	0	0	5	21	21	42	20	2	15	0	0	0	5	21	21	42
1128643	MA	Essex	school	2510380	258	Salem	251038002559	2580025	Nathaniel Bowditch	Regular School	No	Elementary	KG	08	2017	grade_7	10	0	33	0	0	0	0	24	19	43	10	0	33	0	0	0	0	24	19	43
1131446	MA	Essex	school	2500034	464	Marblehead Community Charter Public (District)	250003400567	4640305	Marblehead Community Charter Public School	Regular School	Yes	Elementary	04	08	2017	grade_7	41	1	0	0	1	0	1	24	20	44	41	1	0	0	1	0	1	24	20	44
1132885	MA	Worcester	school	2511880	775	Wachusett	251188001553	7750045	Thomas Prince	Regular School	No	Elementary	KG	08	2017	grade_7	38	0	4	0	2	0	0	21	23	44	38	0	4	0	2	0	0	21	23	44
1125371	MA	Hampshire	school	2505940	127	Hatfield	250594000845	1270505	Smith Academy	Regular School	No	High	07	12	2017	grade_7	41	0	0	0	3	0	2	19	27	46	41	0	0	0	3	0	2	19	27	46
1128951	MA	Middlesex	school	2510890	274	Somerville	251089001731	2740075	Arthur D Healey	Regular School	No	Elementary	PK	08	2017	grade_7	21	1	20	0	2	0	2	23	23	46	21	1	20	0	2	0	2	23	23	46
1132713	MA	Berkshire	school	2511040	765	Southern Berkshire	251104001774	7650505	Mt Everett Regional	Regular School	No	High	07	12	2017	grade_7	42	1	1	0	0	0	2	27	19	46	42	1	1	0	0	0	2	27	19	46
1132832	MA	Dukes	school	2500043	774	Up-Island Regional	250004301927	7740020	West Tisbury Elementary	Regular School	No	Elementary	PK	08	2017	grade_7	38	1	1	3	1	0	2	33	13	46	38	1	1	3	1	0	2	33	13	46
1123200	MA	Suffolk	school	2502790	35	Boston	250279002677	350377	Higginson/Lewis K-8	Regular School	No	Elementary	KG	08	2017	grade_7	0	18	24	1	0	0	4	25	22	47	0	18	24	1	0	0	4	25	22	47
1125905	MA	Berkshire	school	2506690	150	Lee	250669000970	1500505	Lee Middle/High School	Regular School	No	High	07	12	2017	grade_7	38	0	6	0	1	0	2	28	19	47	38	0	6	0	1	0	2	28	19	47
1131017	MA	Worcester	school	2513230	348	Worcester	251323001076	3480285	University Pk Campus School	Regular School	No	High	07	12	2017	grade_7	4	4	29	0	9	0	1	30	17	47	4	4	29	0	9	0	1	30	17	47
1122750	MA	Suffolk	school	2502790	35	Boston	250279000239	350116	Franklin D Roosevelt	Regular School	No	Elementary	PK	08	2017	grade_7	3	19	26	0	0	0	0	22	26	48	3	19	26	0	0	0	0	22	26	48
1124762	MA	Bristol	school	2504830	95	Fall River	250483000666	950045	John J Doran	Regular School	No	Elementary	PK	08	2017	grade_7	30	3	13	0	0	0	2	26	22	48	30	3	13	0	0	0	2	26	22	48
1128973	MA	Middlesex	school	2510890	274	Somerville	251089001739	2740087	Albert F. Argenziano School at Lincoln Park	Regular School	No	Elementary	PK	08	2017	grade_7	18	2	19	0	7	0	2	20	28	48	18	2	19	0	7	0	2	20	28	48
1126089	MA	Middlesex	school	2506900	157	Lincoln	250690001008	1570305	Hanscom Middle	Regular School	No	Elementary	04	08	2017	grade_7	27	5	9	0	1	0	7	24	24	49	27	5	9	0	1	0	7	24	24	49
1131664	MA	Hampshire	school	2500517	497	Pioneer Valley Chinese Immersion Charter (District)	250051702619	4970205	Pioneer Valley Chinese Immersion Charter School	Regular School	Yes	Other	KG	12	2017	grade_7	32	1	1	0	10	0	5	23	26	49	32	1	1	0	10	0	5	23	26	49
1122802	MA	Suffolk	school	2502790	35	Boston	250279000259	350153	James W Hennigan	Regular School	No	Elementary	KG	08	2017	grade_7	0	13	35	0	2	0	0	25	25	50	0	13	35	0	2	0	0	25	25	50
1123221	MA	Suffolk	school	2502790	35	Boston	250279000693	350380	Young Achievers	Alternative School	No	Elementary	PK	08	2017	grade_7	1	25	23	0	0	0	1	31	19	50	1	25	23	0	0	0	1	31	19	50
1125590	MA	Hampden	school	2506270	137	Holyoke	250627002581	1370045	E N White Elementary	Regular School	No	Elementary	PK	08	2017	grade_7	6	1	42	0	0	0	1	25	25	50	6	1	42	0	0	0	1	25	25	50
1126182	MA	Middlesex	school	2507020	160	Lowell	250702001038	1600018	Pyne Arts	Regular School	No	Elementary	PK	08	2017	grade_7	33	2	9	0	4	0	2	28	22	50	33	2	9	0	4	0	2	28	22	50
1131252	MA	Middlesex	school	2500086	436	Community Charter School of Cambridge (District)	250008601996	4360305	Community Charter School of Cambridge	Regular School	Yes	Other	06	12	2017	grade_7	4	28	13	0	4	0	1	25	25	50	4	28	13	0	4	0	1	25	25	50
1131361	MA	Norfolk	school	2500030	447	Benjamin Franklin Classical Charter Public (District)	250003000547	4470205	Benjamin Franklin Classical Charter Public School	Regular School	Yes	Elementary	KG	08	2017	grade_7	30	4	0	0	15	0	1	23	27	50	30	4	0	0	15	0	1	23	27	50
1126568	MA	Middlesex	school	2507170	165	Malden	250717001351	1650027	Forestdale	Regular School	No	Elementary	KG	08	2017	grade_7	23	9	11	0	3	0	5	21	30	51	23	9	11	0	3	0	5	21	30	51
1128994	MA	Middlesex	school	2510890	274	Somerville	251089000891	2740115	West Somerville Neighborhood	Regular School	No	Elementary	PK	08	2017	grade_7	26	9	10	0	3	0	3	27	24	51	26	9	10	0	3	0	3	27	24	51
1131395	MA	Hampden	school	2500087	453	Holyoke Community Charter (District)	250008701997	4530005	Holyoke Community Charter School	Regular School	Yes	Elementary	KG	08	2017	grade_7	2	3	44	0	0	0	2	18	33	51	2	3	44	0	0	0	2	18	33	51
1122686	MA	Suffolk	school	2502790	35	Boston	250279000222	350074	Dearborn	Regular School	No	Other	06	12	2017	grade_7	0	40	12	0	0	0	0	24	28	52	0	40	12	0	0	0	0	24	28	52
1123765	MA	Norfolk	school	2503150	46	Brookline	250315000418	460025	Heath	Regular School	No	Elementary	PK	08	2017	grade_7	35	4	3	0	7	0	3	22	30	52	35	4	3	0	7	0	3	22	30	52
1125552	MA	Hampden	school	2506270	137	Holyoke	250627000908	1370015	Lt Elmer J McMahon Elementary	Regular School	No	Elementary	PK	08	2017	grade_7	14	0	37	0	0	0	1	30	22	52	14	0	37	0	0	0	1	30	22	52
1125600	MA	Hampden	school	2506270	137	Holyoke	250627000907	1370055	Lt Clayre Sullivan Elementary	Regular School	No	Elementary	KG	08	2017	grade_7	6	0	44	0	0	0	2	26	26	52	6	0	44	0	0	0	2	26	26	52
1131406	MA	Essex	school	2500032	454	Lawrence Family Development Charter (District)	250003200553	4540205	Lawrence Family Development Charter School	Regular School	Yes	Elementary	PK	08	2017	grade_7	0	1	51	0	0	0	0	19	33	52	0	1	51	0	0	0	0	19	33	52
1125579	MA	Hampden	school	2506270	137	Holyoke	250627000904	1370040	Kelly Elementary	Regular School	No	Elementary	KG	08	2017	grade_7	1	1	51	0	0	0	0	30	23	53	1	1	51	0	0	0	0	30	23	53
1127785	MA	Worcester	school	2508760	215	North Brookfield	250876001411	2150505	North Brookfield High	Regular School	No	High	07	12	2017	grade_7	47	0	4	0	0	0	2	23	30	53	47	0	4	0	0	0	2	23	30	53
1124625	MA	Middlesex	school	2504770	93	Everett	250477000631	930010	Sumner G. Whittier School	Regular School	No	Elementary	KG	08	2017	grade_7	10	7	33	0	3	0	1	25	29	54	10	7	33	0	3	0	1	25	29	54
1128983	MA	Middlesex	school	2510890	274	Somerville	251089001736	2740111	E Somerville Community	Regular School	No	Elementary	KG	08	2017	grade_7	5	5	42	0	1	1	0	26	28	54	5	5	42	0	1	1	0	26	28	54
1122608	MA	Suffolk	school	2502790	35	Boston	250279000251	350013	Jackson Mann	Regular School	No	Elementary	PK	08	2017	grade_7	6	27	22	0	1	0	1	32	25	57	6	27	22	0	1	0	1	32	25	57
1125611	MA	Hampden	school	2506270	137	Holyoke	250627000909	1370060	Maurice A Donahue Elementary	Regular School	No	Elementary	PK	08	2017	grade_7	6	3	49	0	0	0	0	36	22	58	6	3	49	0	0	0	0	36	22	58
1122290	MA	Norfolk	school	2502250	18	Avon	250225001295	180510	Avon Middle High School	Regular School	No	High	07	12	2017	grade_7	39	12	2	0	3	0	3	33	26	59	39	12	2	0	3	0	3	33	26	59
1123251	MA	Suffolk	school	2502790	35	Boston	250279000952	350426	Dr. William Henderson Upper	Regular School	No	Other	03	12	2017	grade_7	13	25	13	0	5	0	3	31	28	59	13	25	13	0	5	0	3	31	28	59
1126262	MA	Middlesex	school	2507020	160	Lowell	250702001954	1600090	Bartlett Community Partnership	Regular School	No	Elementary	PK	08	2017	grade_7	12	7	18	0	22	0	0	30	29	59	12	7	18	0	22	0	0	30	29	59
1129386	MA	Hampden	school	2511130	281	Springfield	251113002818	2810475	Conservatory of the Arts	Regular School	No	Other	06	11	2017	grade_7	3	12	43	0	0	0	1	17	42	59	3	12	43	0	0	0	1	17	42	59
1131118	MA	Suffolk	school	2500526	411	Boston Green Academy Horace Mann Charter School (District)	250052602703	4110305	Boston Green Academy Horace Mann Charter School	Regular School	Yes	Other	06	12	2017	grade_7	2	38	16	0	1	0	2	35	24	59	2	38	16	0	1	0	2	35	24	59