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 (total_int is not null or (total_int is null and rowid > :p2)) order by total_int, 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	non_binary	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
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
1125187	MA	Dukes	school	2505340	109	Gosnold	250534000725	1090005	Cuttyhunk Elementary	Regular School	No	Middle	06	07	2017	grade_1	*	*	*	*	*	*	*	*	*		*
1125261	MA	Franklin	school	2505490	114	Greenfield	250549002771	1140030	Green River	Regular School	No	Elementary	04	04	2017	grade_1	*	*	*	*	*	*	*	*	*		*
1125316	MA	Berkshire	school	2505760	121	Hancock	250576000826	1210005	Hancock Elementary	Regular School	No	Elementary	PK	06	2017	grade_1	*	*	*	*	*	*	*	3	1		*								3	1
1126446	MA	Essex	school	2507110	163	Lynn	250711002527	1630080	William R Fallon	Regular School	No	Elementary	KG	06	2017	grade_1	*	*	*	*	*	*	*	4	*		*								4
1128614	MA	Franklin	school	2510230	253	Rowe	251023001649	2530005	Rowe Elementary	Regular School	No	Elementary	PK	06	2017	grade_1	*	*	*	*	*	*	*	1	2		*								1	2
1128749	MA	Berkshire	school	2510530	263	Savoy	251053001688	2630010	Emma L Miller Elementary School	Regular School	No	Elementary	PK	05	2017	grade_1	*	*	*	*	*	*	*	2	1		*								2	1
1132818	MA	Dukes	school	2500043	774	Up-Island Regional	250004300508	7740010	Chilmark Elementary	Regular School	No	Elementary	KG	05	2017	grade_1	*	*	*	*	*	*	*	2	2		*								2	2
1368458	MA	Worcester	school	2507080	162	Lunenburg	250708002882	1620605	Advanced Community Experience Program	Special Education School	No	Ungraded	UG	UG	2020	grade_1	*	*	*	*	*	*	*	*	*	*	0.0										0
1374308	MA	Dukes	school	2505340	109	Gosnold	250534000725	1090005	Cuttyhunk Elementary	Regular School	No	Ungraded	UG	UG	2020	grade_1	*	*	*	*	*	*	*	*	*	*	0.0										0
1674751	MA	Dukes	school	2505340	109	Gosnold	250534000725	1090005	Gosnold - Cuttyhunk Elementary	Regular School	No	Middle	07	07	2021	grade_1	*	*	*	*	*	*	*	*	*	*	0.0										0
1675699	MA	Worcester	school	2507080	162	Lunenburg	250708002882	1620605	Lunenburg - Advanced Community Experience Program	Special Education School	No	Ungraded	UG	UG	2021	grade_1	*	*	*	*	*	*	*	*	*	*	0.0										0
2230204	MA	Suffolk	school		35	Boston		350652							2018	grade_1	*	*	*	*	*	*	*	*	*		0.0										0
2231638	MA	Bristol	school	2504830	95	Fall River	250483002858	950515	Fall River: Fall River Gateway to College @ BCC	Regular School	No	High	12	12	2018	grade_1	*	*	*	*	*	*	*	*	*		0.0										0
2232016	MA	Dukes	school	2505340	109	Gosnold	250534000725	1090005	Gosnold: Cuttyhunk Elementary	Regular School	No	Middle	07	08	2018	grade_1	*	*	*	*	*	*	*	*	*		0.0										0
2237222	MA	Hampden	school	2512510	332	West Springfield	251251002790	3320515	West Springfield: 21st Century Skills Academy	Regular School	No	High	12	12	2018	grade_1	*	*	*	*	*	*	*	*	*		0.0										0
2042765	MA	Essex	school	2505970	128	Haverhill	250597001706	1280073	TEACH	Regular School	No	Other	01	12	2019	grade_1	*	*	*	*	*	*	*	1	*		1.0								1		1
2233065	MA	Middlesex	school	2507020	160	Lowell	250702002726	1600085	Lowell: Laura Lee Therapeutic Day School	Regular School	No	Middle	KG	08	2018	grade_1	*	*	*	*	*	*	*	1	*		1.0								1		1
739315	MA	Middlesex	school	2507020	160	Lowell	250702002726	1600085	Laura Lee Therapeutic Day School	Regular School	No	1	01	07	2015	grade_1	*	*	*	*	*	*	*	2	*		2								2		2
744540	MA	Franklin	school	2507990	717	Mohawk Trail	250799000934	7170015	Heath Elementary	Regular School	No	1	PK	06	2015	grade_1	*	*	*	*	*	*	*	1	1		2								1	1	2
1367063	MA	Middlesex	school	2504770	93	Everett	250477002787	930030	Devens School	Regular School	No	Other	KG	12	2020	grade_1	*	*	*	*	*	*	*	1	1	*	2.0								1	1	2
1368058	MA	Essex	school	2506660	149	Lawrence	250666002625	1490537	School for Exceptional Studies	Regular School	No	Other	KG	12	2020	grade_1	*	*	*	*	*	*	*	1	1	*	2.0								1	1	2
1370773	MA	Hampden	school	2511130	281	Springfield	251113002723	2810005	Springfield Public Day Elementary School	Regular School	No	Elementary	01	05	2020	grade_1	*	*	*	*	*	*	*	1	1	*	2.0								1	1	2
1678029	MA	Hampden	school	2511130	281	Springfield	251113002723	2810005	Springfield - Springfield Public Day Elementary School	Regular School	No	Elementary	01	05	2021	grade_1	*	*	*	*	*	*	*	1	1	*	2.0								1	1	2
2229998	MA	Suffolk	school	2502790	35	Boston	250279002677	350377	Boston: Higginson/Lewis K-8	Regular School	No	Elementary	01	08	2018	grade_1	*	*	*	*	*	*	*	1	1		2.0								1	1	2
2232238	MA	Essex	school	2505970	128	Haverhill	250597001706	1280073	Haverhill: TEACH	Regular School	No	Other	KG	12	2018	grade_1	*	*	*	*	*	*	*	1	1		2.0								1	1	2
737738	MA	Norfolk	school	2504050	73	Dedham	250405000460	730005	Early Childhood Center	Regular School	No	1	PK	01	2015	grade_1	*	*	*	*	*	*	*	2	1		3								2	1	3
744716	MA	Franklin	school	2509600	750	Pioneer Valley	250960002615	7500009	Warwick Community School	Regular School	No	1	PK	06	2015	grade_1	*	*	*	*	*	*	*	2	1		3								2	1	3
936244	MA	Essex	school	2507110	163	Lynn	250711002801	1630004	Early Childhood Center	Regular School	No	1	PK	05	2016	grade_1	*	*	*	*	*	*	*	2	1		3								2	1	3
938515	MA	Worcester	school	2511010	277	Southbridge	251101001764	2770010	Eastford Road	Regular School	No	1	PK	02	2016	grade_1	*	*	*	*	*	*	*	1	2		3								1	2	3
1366043	MA	Suffolk	school	2502790	35	Boston	250279002374	350750	Horace Mann School for the Deaf	Special Education School	No	Other	01	12	2020	grade_1	*	*	*	*	*	*	*	1	2	*	3.0								1	2	3
1368553	MA	Essex	school	2507110	163	Lynn	250711002527	1630080	William R Fallon	Regular School	No	Elementary	01	05	2020	grade_1	*	*	*	*	*	*	*	2	*	*	3.0								2		3
1373777	MA	Franklin	school	2509600	750	Pioneer Valley	250960002615	7500009	Warwick Community School	Regular School	No	Elementary	01	06	2020	grade_1	*	*	*	*	*	*	*	1	2	*	3.0								1	2	3
1677194	MA	Berkshire	school	2509630	236	Pittsfield	250963002914	2360030	Pittsfield - Crosby Educational Academy	Special Education School	No	Elementary	01	05	2021	grade_1	*	*	*	*	*	*	*	1	2	*	3.0								1	2	3
1677738	MA	Berkshire	school	2510530	263	Savoy	251053001688	2630010	Savoy - Emma L Miller Elementary School	Regular School	No	Elementary	PK	06	2021	grade_1	*	*	*	*	*	*	*	2	1	*	3.0								2	1	3
1680950	MA	Middlesex	school	2508790	735	North Middlesex	250879002686	7350002	North Middlesex - Squannacook Early Childhood Center	Regular School	No	Elementary	02	04	2021	grade_1	*	*	*	*	*	*	*	2	1	*	3.0								2	1	3
2043542	MA	Essex	school	2507110	163	Lynn	250711002801	1630004	Early Childhood Center	Regular School	No	Elementary	PK	05	2019	grade_1	*	*	*	*	*	*	*	1	2		3.0								1	2	3
739478	MA	Essex	school	2507110	163	Lynn	250711002527	1630080	William R Fallon	Regular School	No	1	01	06	2015	grade_1	*	*	*	*	*	*	*	3	1		4								3	1	4
935451	MA	Essex	school	2505970	128	Haverhill	250597001706	1280073	TEACH	Regular School	No	4	01	12	2016	grade_1	*	*	*	*	*	*	*	3	1		4								3	1	4
1370382	MA	Franklin	school	2510230	253	Rowe	251023001649	2530005	Rowe Elementary	Regular School	No	Elementary	PK	06	2020	grade_1	*	*	*	*	*	*	*	1	3	*	4.0								1	3	4
1675795	MA	Essex	school	2507110	163	Lynn	250711002527	1630080	Lynn - William R Fallon	Regular School	No	Elementary	01	05	2021	grade_1	*	*	*	*	*	*	*	4	*	*	4.0								4		4
736673	MA	Suffolk	school	2502790	35	Boston	250279000342	350363	William McKinley	Regular School	No	4	KG	12	2015	grade_1	*	*	*	*	*	*	*	2	3		5								2	3	5
738515	MA	Berkshire	school	2505760	121	Hancock	250576000826	1210005	Hancock Elementary	Regular School	No	1	PK	06	2015	grade_1	*	*	*	*	*	*	*	1	4		5								1	4	5
739009	MA	Essex	school	2506660	149	Lawrence	250666002625	1490537	School for Exceptional Studies	Regular School	No	4	01	12	2015	grade_1	*	*	*	*	*	*	*	4	1		5								4	1	5
741325	MA	Franklin	school	2510230	253	Rowe	251023001649	2530005	Rowe Elementary	Regular School	No	1	PK	06	2015	grade_1	*	*	*	*	*	*	*	2	3		5								2	3	5
744702	MA	Franklin	school	2509600	750	Pioneer Valley	250960002613	7500007	Pearl E Rhodes Elementary	Regular School	No	1	PK	06	2015	grade_1	*	*	*	*	*	*	*	1	4		5								1	4	5
744793	MA	Berkshire	school	2511040	765	Southern Berkshire	251104001778	7650030	South Egremont	Regular School	No	1	KG	01	2015	grade_1	*	*	*	*	*	*	*	*	2		5									2	5
935365	MA	Berkshire	school	2505760	121	Hancock	250576000826	1210005	Hancock Elementary	Regular School	No	1	PK	06	2016	grade_1	*	*	*	*	*	*	*	2	3		5								2	3	5
1367597	MA	Berkshire	school	2505760	121	Hancock	250576000826	1210005	Hancock Elementary	Regular School	No	Elementary	PK	06	2020	grade_1	*	*	*	*	*	*	*	2	3	*	5.0								2	3	5
1675663	MA	Middlesex	school	2507020	160	Lowell	250702002876	1600605	Lowell - Dr. Janice Adie Day School	Special Education School	No	Other	PK	12	2021	grade_1	*	*	*	*	*	*	*	4	1	*	5.0								4	1	5
2043143	MA	Essex	school	2506660	149	Lawrence	250666002625	1490537	School for Exceptional Studies	Regular School	No	Other	01	12	2019	grade_1	*	*	*	*	*	*	*	4	1		5.0								4	1	5
2233130	MA	Middlesex	school	2507020	160	Lowell	250702002876	1600605	Lowell: Lowell Day School on Broadway	Special Education School	No	Elementary	PK	06	2018	grade_1	*	*	*	*	*	*	*	4	1		5.0								4	1	5
736952	MA	Suffolk	school	2502790	35	Boston	250279002374	350750	Horace Mann School for the Deaf	Special Education School	No	4	PK	12	2015	grade_1	1	2	1	0	2	0	0	5	1		6	1	2	1	0	2	0	0	5	1	6
936326	MA	Essex	school	2507110	163	Lynn	250711002527	1630080	William R Fallon	Regular School	No	1	KG	06	2016	grade_1	2	0	3	0	0	0	1	5	1		6	2	0	3	0	0	0	1	5	1	6
938544	MA	Hampden	school	2511130	281	Springfield	251113002723	2810005	Springfield Public Day Elementary School	Regular School	No	1	KG	05	2016	grade_1	3	1	2	0	0	0	0	4	2		6	3	1	2	0	0	0	0	4	2	6
940204	MA	Hampshire	school	2513260	349	Worthington	251326002850	3490010	R. H. Conwell	Regular School	No	1	PK	06	2016	grade_1	5	0	0	0	0	0	1	3	3		6	5	0	0	0	0	0	1	3	3	6
1128900	MA	Franklin	school	2510800	272	Shutesbury	251080001720	2720005	Shutesbury Elementary	Regular School	No	Elementary	PK	06	2017	grade_1	6	0	0	0	0	0	0	5	1		6	6	0	0	0	0	0	0	5	1	6
1132403	MA	Franklin	school	2507990	717	Mohawk Trail	250799000934	7170015	Heath Elementary	Regular School	No	Elementary	PK	06	2017	grade_1	6	0	0	0	0	0	0	4	2		6	6	0	0	0	0	0	0	4	2	6
1132592	MA	Franklin	school	2509600	750	Pioneer Valley	250960002613	7500007	Pearl E Rhodes Elementary	Regular School	No	Elementary	PK	06	2017	grade_1	6	0	0	0	0	0	0	4	2		6	6	0	0	0	0	0	0	4	2	6
1132607	MA	Franklin	school	2509600	750	Pioneer Valley	250960002615	7500009	Warwick Community School	Regular School	No	Elementary	KG	06	2017	grade_1	6	0	0	0	0	0	0	3	3		6	6	0	0	0	0	0	0	3	3	6
1681190	MA	Dukes	school	2500043	774	Up-Island Regional	250004300508	7740010	Up-Island Regional - Chilmark Elementary	Regular School	No	Elementary	KG	05	2021	grade_1	5	0	0	0	1	0	0	4	2	*	6.0	5	0	0	0	1	0	0	4	2	6
2042363	MA	Berkshire	school	2504920	98	Florida	250492000706	980005	Abbott Memorial	Regular School	No	Elementary	PK	08	2019	grade_1	6	0	0	0	0	0	0	4	2		6.0	6	0	0	0	0	0	0	4	2	6
2043505	MA	Middlesex	school	2507020	160	Lowell	250702002876	1600605	Dr. Janice Adie Day School	Special Education School	No	Other	PK	11	2019	grade_1	1	2	3	0	0	0	0	5	1		6.0	1	2	3	0	0	0	0	5	1	6
2048666	MA	Franklin	school	2507990	717	Mohawk Trail	250799000425	7170010	Colrain Central	Regular School	No	Elementary	PK	06	2019	grade_1	6	0	0	0	0	0	0	4	2		6.0	6	0	0	0	0	0	0	4	2	6
2233268	MA	Essex	school	2507110	163	Lynn	250711002527	1630080	Lynn: William R Fallon	Regular School	No	Elementary	KG	06	2018	grade_1	0	0	5	0	0	0	1	5	1		6.0	0	0	5	0	0	0	1	5	1	6
935059	MA	Berkshire	school	2504920	98	Florida	250492000706	980005	Abbott Memorial	Regular School	No	1	PK	08	2016	grade_1	7	0	0	0	0	0	0	2	5		7	7	0	0	0	0	0	0	2	5	7
938151	MA	Franklin	school	2510230	253	Rowe	251023001649	2530005	Rowe Elementary	Regular School	No	1	PK	06	2016	grade_1	6	0	1	0	0	0	0	4	3		7	6	0	1	0	0	0	0	4	3	7
941618	MA	Berkshire	school	2511040	765	Southern Berkshire	251104001778	7650030	South Egremont	Regular School	No	1	KG	01	2016	grade_1	7	0	0	0	0	0	0	2	5		7	7	0	0	0	0	0	0	2	5	7
1124921	MA	Berkshire	school	2504920	98	Florida	250492000706	980005	Abbott Memorial	Regular School	No	Elementary	PK	08	2017	grade_1	7	0	0	0	0	0	0	3	4		7	7	0	0	0	0	0	0	3	4	7
1132702	MA	Berkshire	school	2511040	765	Southern Berkshire	251104001778	7650030	South Egremont	Regular School	No	Elementary	KG	01	2017	grade_1	6	0	1	0	0	0	0	5	*		7	6	0	1	0	0	0	0	5		7
1368421	MA	Middlesex	school	2507020	160	Lowell	250702002876	1600605	Dr. Janice Adie Day School	Special Education School	No	Other	PK	12	2020	grade_1	1	3	1	0	1	0	1	5	2	*	7.0	1	3	1	0	1	0	1	5	2	7
1674525	MA	Berkshire	school	2504920	98	Florida	250492000706	980005	Florida - Abbott Memorial	Regular School	No	Elementary	PK	08	2021	grade_1	7	0	0	0	0	0	0	3	4	*	7.0	7	0	0	0	0	0	0	3	4	7
1679682	MA	Hampshire	school	2513260	349	Worthington	251326002850	3490010	Worthington - R. H. Conwell	Regular School	No	Elementary	PK	06	2021	grade_1	6	0	0	1	0	0	0	3	4	*	7.0	6	0	0	1	0	0	0	3	4	7
1680866	MA	Franklin	school	2507990	717	Mohawk Trail	250799000425	7170010	Mohawk Trail - Colrain Central	Regular School	No	Elementary	PK	06	2021	grade_1	6	0	1	0	0	0	0	6	1	*	7.0	6	0	1	0	0	0	0	6	1	7
2045456	MA	Franklin	school	2510230	253	Rowe	251023001649	2530005	Rowe Elementary	Regular School	No	Elementary	PK	06	2019	grade_1	5	0	1	0	0	0	1	3	4		7.0	5	0	1	0	0	0	1	3	4	7
2048831	MA	Franklin	school	2509600	750	Pioneer Valley	250960002613	7500007	Pearl E Rhodes Elementary	Regular School	No	Elementary	PK	04	2019	grade_1	6	0	1	0	0	0	0	2	5		7.0	6	0	1	0	0	0	0	2	5	7
2229937	MA	Suffolk	school	2502790	35	Boston	250279000342	350363	Boston: William McKinley	Regular School	No	Other	01	12	2018	grade_1	1	1	4	0	0	0	1	6	1		7.0	1	1	4	0	0	0	1	6	1	7
2230263	MA	Suffolk	school	2502790	35	Boston	250279002374	350750	Boston: Horace Mann School for the Deaf	Special Education School	No	Other	PK	12	2018	grade_1	3	2	2	0	0	0	0	6	1		7.0	3	2	2	0	0	0	0	6	1	7
2231749	MA	Berkshire	school	2504920	98	Florida	250492000706	980005	Florida: Abbott Memorial	Regular School	No	Elementary	PK	08	2018	grade_1	7	0	0	0	0	0	0	3	4		7.0	7	0	0	0	0	0	0	3	4	7
2235571	MA	Berkshire	school	2510530	263	Savoy	251053001688	2630010	Savoy: Emma L Miller Elementary School	Regular School	No	Elementary	PK	05	2018	grade_1	6	0	1	0	0	0	0	4	3		7.0	6	0	1	0	0	0	0	4	3	7
2239417	MA	Franklin	school	2509600	750	Pioneer Valley	250960002613	7500007	Pioneer Valley: Pearl E Rhodes Elementary	Regular School	No	Elementary	PK	06	2018	grade_1	7	0	0	0	0	0	0	3	4		7.0	7	0	0	0	0	0	0	3	4	7
934795	MA	Franklin	school	2504710	91	Erving	250471000626	910030	Erving Elementary	Regular School	No	1	PK	06	2016	grade_1	5	0	0	0	0	0	3	3	5		8	5	0	0	0	0	0	3	3	5	8
941524	MA	Franklin	school	2509600	750	Pioneer Valley	250960002613	7500007	Pearl E Rhodes Elementary	Regular School	No	1	PK	06	2016	grade_1	8	0	0	0	0	0	0	3	5		8	8	0	0	0	0	0	0	3	5	8
941718	MA	Dukes	school	2500043	774	Up-Island Regional	250004300508	7740010	Chilmark Elementary	Regular School	No	1	KG	05	2016	grade_1	4	0	0	0	0	0	4	6	2		8	4	0	0	0	0	0	4	6	2	8
1125878	MA	Essex	school	2506660	149	Lawrence	250666002625	1490537	School for Exceptional Studies	Regular School	No	Other	01	12	2017	grade_1	1	0	7	0	0	0	0	5	3		8	1	0	7	0	0	0	0	5	3	8
1677340	MA	Barnstable	school	2509840	242	Provincetown	250984002694	2420020	Provincetown - Provincetown Schools	Regular School	No	Elementary	PK	08	2021	grade_1	4	2	1	0	0	0	1	3	5	*	8.0	4	2	1	0	0	0	1	3	5	8
2041096	MA	Suffolk	school	2502790	35	Boston	250279002374	350750	Horace Mann School for the Deaf	Special Education School	No	Other	PK	12	2019	grade_1	2	4	2	0	0	0	0	5	3		8.0	2	4	2	0	0	0	0	5	3	8
2048918	MA	Berkshire	school	2511040	765	Southern Berkshire	251104001775	7650018	New Marlborough Central	Regular School	No	Elementary	PK	04	2019	grade_1	5	0	1	1	0	0	1	2	6		8.0	5	0	1	1	0	0	1	2	6	8
741452	MA	Berkshire	school	2510530	263	Savoy	251053001688	2630010	Emma L Miller Elementary School	Regular School	No	1	PK	05	2015	grade_1	9	0	0	0	0	0	0	1	8		9	9	0	0	0	0	0	0	1	8	9
742613	MA	Barnstable	school	2512300	318	Wellfleet	251230002031	3180005	Wellfleet Elementary	Regular School	No	1	PK	05	2015	grade_1	8	0	0	0	0	0	1	4	5		9	8	0	0	0	0	0	1	4	5	9
745187	MA	Norfolk	school	2500556	3902	TEC Connections Academy Commonwealth Virtual School District	250055602817	39020900	TEC Connections Academy Commonwealth Virtual School	Regular School	No	4	KG	12	2015	grade_1	7	0	0	0	0	0	2	6	3		9	7	0	0	0	0	0	2	6	3	9
935858	MA	Essex	school	2506660	149	Lawrence	250666002625	1490537	School for Exceptional Studies	Regular School	No	4	01	12	2016	grade_1	1	0	8	0	0	0	0	6	3		9	1	0	8	0	0	0	0	6	3	9
937866	MA	Barnstable	school	2509840	242	Provincetown	250984002694	2420020	Provincetown Schools	Regular School	No	1	PK	08	2016	grade_1	8	0	0	0	0	0	1	3	6		9	8	0	0	0	0	0	1	3	6	9
941539	MA	Franklin	school	2509600	750	Pioneer Valley	250960002615	7500009	Warwick Community School	Regular School	No	1	PK	06	2016	grade_1	9	0	0	0	0	0	0	4	5		9	9	0	0	0	0	0	0	4	5	9
1367292	MA	Berkshire	school	2504920	98	Florida	250492000706	980005	Abbott Memorial	Regular School	No	Elementary	PK	08	2020	grade_1	9	0	0	0	0	0	0	5	4	*	9.0	9	0	0	0	0	0	0	5	4	9
1674847	MA	Berkshire	school	2505760	121	Hancock	250576000826	1210005	Hancock - Hancock Elementary	Regular School	No	Elementary	PK	06	2021	grade_1	9	0	0	0	0	0	0	3	6	*	9.0	9	0	0	0	0	0	0	3	6	9
2042093	MA	Franklin	school	2504710	91	Erving	250471000626	910030	Erving Elementary	Regular School	No	Elementary	PK	06	2019	grade_1	9	0	0	0	0	0	0	5	4		9.0	9	0	0	0	0	0	0	5	4	9
2045013	MA	Worcester	school	2509540	234	Petersham	250954001514	2340005	Petersham Center	Regular School	No	Elementary	KG	06	2019	grade_1	7	0	2	0	0	0	0	7	2		9.0	7	0	2	0	0	0	0	7	2	9
2046870	MA	Hampshire	school	2512690	327	Westhampton	251269002083	3270005	Westhampton Elementary School	Regular School	No	Elementary	PK	06	2019	grade_1	8	0	1	0	0	0	0	2	7		9.0	8	0	1	0	0	0	0	2	7	9
2237897	MA	Hampshire	school	2513260	349	Worthington	251326002850	3490010	Worthington: R. H. Conwell	Regular School	No	Elementary	PK	06	2018	grade_1	9	0	0	0	0	0	0	1	8		9.0	9	0	0	0	0	0	0	1	8	9
2239432	MA	Franklin	school	2509600	750	Pioneer Valley	250960002615	7500009	Pioneer Valley: Warwick Community School	Regular School	No	Elementary	PK	06	2018	grade_1	9	0	0	0	0	0	0	7	2		9.0	9	0	0	0	0	0	0	7	2	9