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 (school > :p3 or (school = :p3 and rowid > :p2)) order by school, 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
2039831	MA	Bristol	school	2501740	3	Acushnet	250174000015	30305	Albert F Ford Middle School	Regular School	No	Middle	05	08	2019	grade_5	97	1	3	0	1	0	0	60	42		102.0	97	1	3	0	1	0	0	60	42	102
741642	MA	Middlesex	school	2510890	274	Somerville	251089001739	2740087	Albert F. Argenziano School at Lincoln Park	Regular School	No	1	PK	08	2015	grade_5	13	5	29	0	7	0	3	30	27		57	13	5	29	0	7	0	3	30	27	57
938445	MA	Middlesex	school	2510890	274	Somerville	251089001739	2740087	Albert F. Argenziano School at Lincoln Park	Regular School	No	1	PK	08	2016	grade_5	25	3	29	0	9	0	0	36	30		66	25	3	29	0	9	0	0	36	30	66
1128971	MA	Middlesex	school	2510890	274	Somerville	251089001739	2740087	Albert F. Argenziano School at Lincoln Park	Regular School	No	Elementary	PK	08	2017	grade_5	16	2	16	0	5	0	3	21	21		42	16	2	16	0	5	0	3	21	21	42
1370672	MA	Middlesex	school	2510890	274	Somerville	251089001739	2740087	Albert F. Argenziano School at Lincoln Park	Regular School	No	Elementary	PK	08	2020	grade_5	22	2	14	0	6	0	4	27	21	*	48.0	22	2	14	0	6	0	4	27	21	48
2045748	MA	Middlesex	school	2510890	274	Somerville	251089001739	2740087	Albert F. Argenziano School at Lincoln Park	Regular School	No	Elementary	PK	08	2019	grade_5	26	2	15	0	4	0	1	24	24		48.0	26	2	15	0	4	0	1	24	24	48
737645	MA	Middlesex	school	2503840	67	Concord	250384000521	670005	Alcott	Regular School	No	1	PK	05	2015	grade_5	62	5	6	1	5	0	3	30	52		82	62	5	6	1	5	0	3	30	52	82
934504	MA	Middlesex	school	2503840	67	Concord	250384000521	670005	Alcott	Regular School	No	1	PK	05	2016	grade_5	58	6	2	0	4	0	1	38	33		71	58	6	2	0	4	0	1	38	33	71
1124258	MA	Middlesex	school	2503840	67	Concord	250384000521	670005	Alcott	Regular School	No	Elementary	PK	05	2017	grade_5	46	6	7	1	4	0	7	29	42		71	46	6	7	1	4	0	7	29	42	71
1366726	MA	Middlesex	school	2503840	67	Concord	250384000521	670005	Alcott	Regular School	No	Elementary	PK	05	2020	grade_5	49	5	4	0	7	0	9	33	41	*	74.0	49	5	4	0	7	0	9	33	41	74
2041796	MA	Middlesex	school	2503840	67	Concord	250384000521	670005	Alcott	Regular School	No	Elementary	PK	05	2019	grade_5	55	10	7	0	5	0	3	38	42		80.0	55	10	7	0	5	0	3	38	42	80
737833	MA	Plymouth	school	2504410	82	Duxbury	250441000968	820004	Alden School	Regular School	No	1	03	05	2015	grade_5	225	0	5	1	4	0	8	127	116		243	225	0	5	1	4	0	8	127	116	243
934687	MA	Plymouth	school	2504410	82	Duxbury	250441000968	820004	Alden School	Regular School	No	1	03	05	2016	grade_5	230	0	3	0	2	0	9	137	107		244	230	0	3	0	2	0	9	137	107	244
1124476	MA	Plymouth	school	2504410	82	Duxbury	250441000968	820004	Alden School	Regular School	No	Elementary	03	05	2017	grade_5	220	0	3	0	5	0	11	118	121		239	220	0	3	0	5	0	11	118	121	239
1366911	MA	Plymouth	school	2504410	82	Duxbury	250441000968	820004	Alden School	Regular School	No	Elementary	03	05	2020	grade_5	170	1	4	0	3	0	18	102	94	*	196.0	170	1	4	0	3	0	18	102	94	196
2041981	MA	Plymouth	school	2504410	82	Duxbury	250441000968	820004	Alden School	Regular School	No	Elementary	03	05	2019	grade_5	215	1	7	0	2	0	4	125	104		229.0	215	1	7	0	2	0	4	125	104	229
738906	MA	Essex	school	2506660	149	Lawrence	250666000950	1490015	Alexander B Bruce	Regular School	No	1	03	08	2015	grade_5	3	1	80	0	0	0	0	42	42		84	3	1	80	0	0	0	0	42	42	84
935755	MA	Essex	school	2506660	149	Lawrence	250666000950	1490015	Alexander B Bruce	Regular School	No	1	03	08	2016	grade_5	8	0	93	0	3	0	0	47	57		104	8	0	93	0	3	0	0	47	57	104
1125780	MA	Essex	school	2506660	149	Lawrence	250666000950	1490015	Alexander B Bruce	Regular School	No	Elementary	03	08	2017	grade_5	4	2	80	0	2	0	0	48	40		88	4	2	80	0	2	0	0	48	40	88
1367979	MA	Essex	school	2506660	149	Lawrence	250666000950	1490015	Alexander B Bruce	Regular School	No	Middle	03	08	2020	grade_5	4	0	74	0	1	0	0	33	46	*	79.0	4	0	74	0	1	0	0	33	46	79
2043063	MA	Essex	school	2506660	149	Lawrence	250666000950	1490015	Alexander B Bruce	Regular School	No	Middle	03	08	2019	grade_5	2	1	91	0	2	0	0	47	49		96.0	2	1	91	0	2	0	0	47	49	96
741848	MA	Hampden	school	2511130	281	Springfield	251113001809	2810095	Alfred G. Zanetti Montessori Magnet School	Regular School	No	1	PK	08	2015	grade_5	7	10	15	0	1	0	3	15	21		36	7	10	15	0	1	0	3	15	21	36
938654	MA	Hampden	school	2511130	281	Springfield	251113001809	2810095	Alfred G. Zanetti Montessori Magnet School	Regular School	No	1	PK	08	2016	grade_5	11	9	14	0	0	0	1	15	20		35	11	9	14	0	0	0	1	15	20	35
1129214	MA	Hampden	school	2511130	281	Springfield	251113001809	2810095	Alfred G. Zanetti Montessori Magnet School	Regular School	No	Elementary	PK	08	2017	grade_5	10	14	14	0	0	0	2	18	22		40	10	14	14	0	0	0	2	18	22	40
1370883	MA	Hampden	school	2511130	281	Springfield	251113001809	2810095	Alfred G. Zanetti Montessori Magnet School	Regular School	No	Elementary	PK	08	2020	grade_5	10	14	19	0	0	0	2	21	24	*	45.0	10	14	19	0	0	0	2	21	24	45
2045958	MA	Hampden	school	2511130	281	Springfield	251113001809	2810095	Alfred G. Zanetti Montessori Magnet School	Regular School	No	Elementary	PK	08	2019	grade_5	6	7	27	0	0	0	0	19	21		40.0	6	7	27	0	0	0	0	19	21	40
740184	MA	Bristol	school	2508430	201	New Bedford	250843001326	2010063	Alfred J Gomes	Regular School	No	1	PK	05	2015	grade_5	23	14	58	1	2	0	2	49	51		100	23	14	58	1	2	0	2	49	51	100
937028	MA	Bristol	school	2508430	201	New Bedford	250843001326	2010063	Alfred J Gomes	Regular School	No	1	PK	05	2016	grade_5	21	20	51	1	0	0	3	40	56		96	21	20	51	1	0	0	3	40	56	96
1127280	MA	Bristol	school	2508430	201	New Bedford	250843001326	2010063	Alfred J Gomes	Regular School	No	Elementary	PK	05	2017	grade_5	16	11	42	0	0	0	2	32	39		71	16	11	42	0	0	0	2	32	39	71
1369248	MA	Bristol	school	2508430	201	New Bedford	250843001326	2010063	Alfred J Gomes	Regular School	No	Elementary	KG	05	2020	grade_5	10	17	55	1	0	0	3	55	31	*	86.0	10	17	55	1	0	0	3	55	31	86
2044321	MA	Bristol	school	2508430	201	New Bedford	250843001326	2010063	Alfred J Gomes	Regular School	No	Elementary	KG	05	2019	grade_5	8	16	51	0	1	0	2	40	38		78.0	8	16	51	0	1	0	2	40	38	78
741920	MA	Hampden	school	2511130	281	Springfield	251113001792	2810175	Alice B Beal Elementary	Regular School	No	1	KG	05	2015	grade_5	11	6	22	0	2	0	2	26	17		43	11	6	22	0	2	0	2	26	17	43
938726	MA	Hampden	school	2511130	281	Springfield	251113001792	2810175	Alice B Beal Elementary	Regular School	No	1	KG	05	2016	grade_5	9	9	22	0	2	0	1	22	21		43	9	9	22	0	2	0	1	22	21	43
1129297	MA	Hampden	school	2511130	281	Springfield	251113001792	2810175	Alice B Beal Elementary	Regular School	No	Elementary	KG	05	2017	grade_5	2	4	28	0	9	0	0	22	21		43	2	4	28	0	9	0	0	22	21	43
1370957	MA	Hampden	school	2511130	281	Springfield	251113001792	2810175	Alice B Beal Elementary	Regular School	No	Elementary	KG	05	2020	grade_5	4	10	20	0	6	0	0	24	16	*	40.0	4	10	20	0	6	0	0	24	16	40
2046032	MA	Hampden	school	2511130	281	Springfield	251113001792	2810175	Alice B Beal Elementary	Regular School	No	Elementary	KG	05	2019	grade_5	9	4	26	0	3	0	1	29	14		43.0	9	4	26	0	3	0	1	29	14	43
741176	MA	Middlesex	school	2509990	246	Reading	250999001604	2460002	Alice M Barrows	Regular School	No	1	KG	05	2015	grade_5	57	0	1	0	2	0	0	30	30		60	57	0	1	0	2	0	0	30	30	60
938004	MA	Middlesex	school	2509990	246	Reading	250999001604	2460002	Alice M Barrows	Regular School	No	1	KG	05	2016	grade_5	58	0	2	0	2	0	0	28	34		62	58	0	2	0	2	0	0	28	34	62
1128437	MA	Middlesex	school	2509990	246	Reading	250999001604	2460002	Alice M Barrows	Regular School	No	Elementary	KG	05	2017	grade_5	58	1	0	1	4	0	3	31	36		67	58	1	0	1	4	0	3	31	36	67
1370232	MA	Middlesex	school	2509990	246	Reading	250999001604	2460002	Alice M Barrows	Regular School	No	Elementary	KG	05	2020	grade_5	61	1	0	0	1	0	0	28	35	*	63.0	61	1	0	0	1	0	0	28	35	63
2045305	MA	Middlesex	school	2509990	246	Reading	250999001604	2460002	Alice M Barrows	Regular School	No	Elementary	KG	05	2019	grade_5	51	1	0	0	5	0	1	33	25		58.0	51	1	0	0	5	0	1	33	25	58
740895	MA	Berkshire	school	2509630	236	Pittsfield	250963001516	2360010	Allendale	Regular School	No	1	KG	05	2015	grade_5	40	3	3	0	0	0	4	24	26		50	40	3	3	0	0	0	4	24	26	50
937723	MA	Berkshire	school	2509630	236	Pittsfield	250963001516	2360010	Allendale	Regular School	No	1	KG	05	2016	grade_5	37	7	4	0	1	0	6	25	30		55	37	7	4	0	1	0	6	25	30	55
1128104	MA	Berkshire	school	2509630	236	Pittsfield	250963001516	2360010	Allendale	Regular School	No	Elementary	KG	05	2017	grade_5	40	1	5	1	0	0	4	30	21		51	40	1	5	1	0	0	4	30	21	51
1369950	MA	Berkshire	school	2509630	236	Pittsfield	250963001516	2360010	Allendale	Regular School	No	Elementary	KG	05	2020	grade_5	35	5	7	0	2	0	4	23	30	*	53.0	35	5	7	0	2	0	4	23	30	53
2045024	MA	Berkshire	school	2509630	236	Pittsfield	250963001516	2360010	Allendale	Regular School	No	Elementary	KG	05	2019	grade_5	25	6	10	0	0	0	3	20	24		44.0	25	6	10	0	0	0	3	20	24	44
743415	MA	Bristol	school	2500525	409	Alma del Mar Charter School (District)	250052502708	4090205	Alma del Mar Charter School	Regular School	Yes	1	KG	05	2015	grade_5	14	7	16	1	2	0	1	19	22		41	14	7	16	1	2	0	1	19	22	41
940233	MA	Bristol	school	2500525	409	Alma del Mar Charter School (District)	250052502708	4090205	Alma del Mar Charter School	Regular School	Yes	1	KG	06	2016	grade_5	12	7	18	0	0	0	3	19	21		40	12	7	18	0	0	0	3	19	21	40
1131106	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_5	18	5	15	0	0	0	2	17	23		40	18	5	15	0	0	0	2	17	23	40
1372448	MA	Bristol	school	2500525	409	Alma del Mar Charter School (District)	250052502708	4090205	Alma del Mar Charter School	Regular School	Yes	Elementary	KG	08	2020	grade_5	8	6	37	0	0	0	0	26	25	*	51.0	8	6	37	0	0	0	0	26	25	51
2047521	MA	Bristol	school	2500525	409	Alma del Mar Charter School (District)	250052502708	4090205	Alma del Mar Charter School	Regular School	Yes	Elementary	KG	08	2019	grade_5	16	7	27	0	0	0	0	17	33		50.0	16	7	27	0	0	0	0	17	33	50
1679712	MA	Bristol	school	2500525	409	Alma del Mar Charter School (District)	250052502708	4090205	Alma del Mar Charter School (District) - Alma del Mar Charter School	Regular School	Yes	Elementary	KG	08	2021	grade_5	15	6	27	1	0	0	0	22	27	*	49.0	15	6	27	1	0	0	0	22	27	49
2237931	MA	Bristol	school	2500525	409	Alma del Mar Charter School (District)	250052502708	4090205	Alma del Mar Charter School (District): Alma del Mar Charter School	Regular School	Yes	Elementary	KG	08	2018	grade_5	10	8	25	0	0	0	3	18	28		46.0	10	8	25	0	0	0	3	18	28	46
743016	MA	Middlesex	school	2513110	344	Winchester	251311002164	3440045	Ambrose Elementary	Regular School	No	1	KG	05	2015	grade_5	68	0	2	0	1	0	3	42	32		74	68	0	2	0	1	0	3	42	32	74
939825	MA	Middlesex	school	2513110	344	Winchester	251311002164	3440045	Ambrose Elementary	Regular School	No	1	KG	05	2016	grade_5	84	0	2	0	1	0	3	49	41		90	84	0	2	0	1	0	3	49	41	90
1130630	MA	Middlesex	school	2513110	344	Winchester	251311002164	3440045	Ambrose Elementary	Regular School	No	Elementary	KG	05	2017	grade_5	71	0	0	0	4	0	3	35	43		78	71	0	0	0	4	0	3	35	43	78
1372046	MA	Middlesex	school	2513110	344	Winchester	251311002164	3440045	Ambrose Elementary	Regular School	No	Elementary	KG	05	2020	grade_5	67	0	2	0	2	0	3	42	32	*	74.0	67	0	2	0	2	0	3	42	32	74
2047120	MA	Middlesex	school	2513110	344	Winchester	251311002164	3440045	Ambrose Elementary	Regular School	No	Elementary	KG	05	2019	grade_5	70	0	2	0	1	0	2	41	34		75.0	70	0	2	0	1	0	2	41	34	75
1672074	MA	Essex	school	2501860	7	Amesbury	250186000035	70013	Amesbury - Amesbury Middle	Regular School	No	Middle	05	08	2021	grade_5	129	3	15	1	2	0	7	81	76	*	157.0	129	3	15	1	2	0	7	81	76	157
735726	MA	Essex	school	2501860	7	Amesbury	250186000035	70013	Amesbury Middle	Regular School	No	2	05	08	2015	grade_5	166	1	3	0	3	0	4	96	81		177	166	1	3	0	3	0	4	96	81	177
932604	MA	Essex	school	2501860	7	Amesbury	250186000035	70013	Amesbury Middle	Regular School	No	2	05	08	2016	grade_5	149	1	8	0	0	0	8	85	81		166	149	1	8	0	0	0	8	85	81	166
1122030	MA	Essex	school	2501860	7	Amesbury	250186000035	70013	Amesbury Middle	Regular School	No	Middle	05	08	2017	grade_5	150	3	14	0	3	1	2	79	94		173	150	3	14	0	3	1	2	79	94	173
1364850	MA	Essex	school	2501860	7	Amesbury	250186000035	70013	Amesbury Middle	Regular School	No	Middle	05	08	2020	grade_5	150	1	16	1	5	0	8	96	85	*	181.0	150	1	16	1	5	0	8	96	85	181
2039877	MA	Essex	school	2501860	7	Amesbury	250186000035	70013	Amesbury Middle	Regular School	No	Middle	05	08	2019	grade_5	133	4	15	0	2	0	8	94	68		162.0	133	4	15	0	2	0	8	94	68	162
2228836	MA	Essex	school	2501860	7	Amesbury	250186000035	70013	Amesbury: Amesbury Middle	Regular School	No	Middle	05	08	2018	grade_5	145	1	13	1	2	1	4	81	86		167.0	145	1	13	1	2	1	4	81	86	167
1672092	MA	Hampshire	school	2501890	8	Amherst	250189000038	80009	Amherst - Crocker Farm Elementary	Regular School	No	Elementary	PK	06	2021	grade_5	30	7	10	0	9	0	0	29	27	*	56.0	30	7	10	0	9	0	0	29	27	56
1672099	MA	Hampshire	school	2501890	8	Amherst	250189000039	80020	Amherst - Fort River Elementary	Regular School	No	Elementary	KG	06	2021	grade_5	24	2	9	0	8	1	1	24	21	*	45.0	24	2	9	0	8	1	1	24	21	45
1672106	MA	Hampshire	school	2501890	8	Amherst	250189000041	80050	Amherst - Wildwood Elementary	Regular School	No	Elementary	KG	06	2021	grade_5	31	9	12	0	5	0	3	30	30	*	60.0	31	9	12	0	5	0	3	30	30	60
2228857	MA	Hampshire	school	2501890	8	Amherst	250189000038	80009	Amherst: Crocker Farm Elementary	Regular School	No	Elementary	PK	06	2018	grade_5	15	7	8	0	7	0	2	19	20		39.0	15	7	8	0	7	0	2	19	20	39
2228865	MA	Hampshire	school	2501890	8	Amherst	250189000039	80020	Amherst: Fort River Elementary	Regular School	No	Elementary	KG	06	2018	grade_5	36	7	17	0	8	0	5	45	28		73.0	36	7	17	0	8	0	5	45	28	73
2228873	MA	Hampshire	school	2501890	8	Amherst	250189000041	80050	Amherst: Wildwood Elementary	Regular School	No	Elementary	KG	06	2018	grade_5	30	6	12	0	12	0	10	41	29		70.0	30	6	12	0	12	0	10	41	29	70
737315	MA	Middlesex	school	2503270	49	Cambridge	250327001621	490006	Amigos School	Regular School	No	1	PK	08	2015	grade_5	8	1	12	0	1	0	5	14	13		27	8	1	12	0	1	0	5	14	13	27
934175	MA	Middlesex	school	2503270	49	Cambridge	250327001621	490006	Amigos School	Regular School	No	1	PK	08	2016	grade_5	15	2	14	0	1	0	6	13	25		38	15	2	14	0	1	0	6	13	25	38
1123869	MA	Middlesex	school	2503270	49	Cambridge	250327001621	490006	Amigos School	Regular School	No	Elementary	PK	08	2017	grade_5	13	0	18	0	1	0	2	10	24		34	13	0	18	0	1	0	2	10	24	34
1366393	MA	Middlesex	school	2503270	49	Cambridge	250327001621	490006	Amigos School	Regular School	No	Elementary	PK	08	2020	grade_5	12	2	24	0	1	0	6	23	22	*	45.0	12	2	24	0	1	0	6	23	22	45
2041463	MA	Middlesex	school	2503270	49	Cambridge	250327001621	490006	Amigos School	Regular School	No	Elementary	PK	08	2019	grade_5	13	4	19	0	2	0	5	24	19		43.0	13	4	19	0	2	0	5	24	19	43
740538	MA	Bristol	school	2508730	212	North Attleborough	250873001401	2120007	Amvet Boulevard	Regular School	No	1	KG	05	2015	grade_5	50	1	5	1	3	0	6	31	35		66	50	1	5	1	3	0	6	31	35	66
937368	MA	Bristol	school	2508730	212	North Attleborough	250873001401	2120007	Amvet Boulevard	Regular School	No	1	KG	05	2016	grade_5	68	1	2	0	4	0	4	44	35		79	68	1	2	0	4	0	4	44	35	79
1127684	MA	Bristol	school	2508730	212	North Attleborough	250873001401	2120007	Amvet Boulevard	Regular School	No	Elementary	KG	05	2017	grade_5	66	2	3	0	6	0	3	38	42		80	66	2	3	0	6	0	3	38	42	80
1369594	MA	Bristol	school	2508730	212	North Attleborough	250873001401	2120007	Amvet Boulevard	Regular School	No	Elementary	KG	05	2020	grade_5	46	4	4	0	9	0	4	31	36	*	67.0	46	4	4	0	9	0	4	31	36	67
2044667	MA	Bristol	school	2508730	212	North Attleborough	250873001401	2120007	Amvet Boulevard	Regular School	No	Elementary	KG	05	2019	grade_5	54	3	7	2	4	0	2	31	41		72.0	54	3	7	2	4	0	2	31	41	72
1672113	MA	Essex	school	2501950	9	Andover	250195000047	90003	Andover - Bancroft Elementary	Regular School	No	Elementary	KG	05	2021	grade_5	74	2	9	0	8	0	6	56	43	*	99.0	74	2	9	0	8	0	6	56	43	99
1672126	MA	Essex	school	2501950	9	Andover	250195000048	90010	Andover - Henry C Sanborn Elementary	Regular School	No	Elementary	KG	05	2021	grade_5	51	1	1	0	17	0	2	36	36	*	72.0	51	1	1	0	17	0	2	36	36	72
1672119	MA	Essex	school	2501950	9	Andover	250195001676	90004	Andover - High Plain Elementary	Regular School	No	Elementary	KG	05	2021	grade_5	48	5	7	0	28	0	3	50	41	*	91.0	48	5	7	0	28	0	3	50	41	91
1672132	MA	Essex	school	2501950	9	Andover	250195000050	90020	Andover - South Elementary	Regular School	No	Elementary	KG	05	2021	grade_5	66	1	5	1	15	0	2	38	52	*	90.0	66	1	5	1	15	0	2	38	52	90
1672138	MA	Essex	school	2501950	9	Andover	250195000051	90025	Andover - West Elementary	Regular School	No	Elementary	KG	05	2021	grade_5	74	2	7	0	22	0	1	52	54	*	106.0	74	2	7	0	22	0	1	52	54	106
2228881	MA	Essex	school	2501950	9	Andover	250195000047	90003	Andover: Bancroft Elementary	Regular School	No	Elementary	KG	05	2018	grade_5	88	3	8	1	10	0	5	58	57		115.0	88	3	8	1	10	0	5	58	57	115
2228897	MA	Essex	school	2501950	9	Andover	250195000048	90010	Andover: Henry C Sanborn Elementary	Regular School	No	Elementary	KG	05	2018	grade_5	46	1	4	0	22	0	0	33	40		73.0	46	1	4	0	22	0	0	33	40	73
2228888	MA	Essex	school	2501950	9	Andover	250195001676	90004	Andover: High Plain Elementary	Regular School	No	Elementary	KG	05	2018	grade_5	48	2	9	0	37	0	0	61	35		96.0	48	2	9	0	37	0	0	61	35	96
2228904	MA	Essex	school	2501950	9	Andover	250195000050	90020	Andover: South Elementary	Regular School	No	Elementary	KG	05	2018	grade_5	63	0	3	0	20	1	0	45	42		87.0	63	0	3	0	20	1	0	45	42	87
2228911	MA	Essex	school	2501950	9	Andover	250195000051	90025	Andover: West Elementary	Regular School	No	Elementary	KG	05	2018	grade_5	77	2	7	1	19	0	7	68	45		113.0	77	2	7	1	19	0	7	68	45	113
939745	MA	Hampshire	school	2512990	340	Williamsburg	251299002767	3400020	Anne T. Dunphy School	Regular School	No	1	PK	06	2016	grade_5	26	0	0	0	0	0	0	16	10		26	26	0	0	0	0	0	0	16	10	26
1130531	MA	Hampshire	school	2512990	340	Williamsburg	251299002767	3400020	Anne T. Dunphy School	Regular School	No	Elementary	PK	06	2017	grade_5	27	0	0	0	0	0	0	15	12		27	27	0	0	0	0	0	0	15	12	27
1371974	MA	Hampshire	school	2512990	340	Williamsburg	251299002767	3400020	Anne T. Dunphy School	Regular School	No	Elementary	PK	06	2020	grade_5	17	1	1	0	0	0	0	7	12	*	19.0	17	1	1	0	0	0	0	7	12	19
2047048	MA	Hampshire	school	2512990	340	Williamsburg	251299002767	3400020	Anne T. Dunphy School	Regular School	No	Elementary	PK	06	2019	grade_5	19	0	0	0	1	0	0	11	9		20.0	19	0	0	0	1	0	0	11	9	20
740514	MA	Essex	school	2508700	211	North Andover	250870000767	2110018	Annie L Sargent School	Regular School	No	1	KG	05	2015	grade_5	89	2	2	0	1	0	1	46	49		95	89	2	2	0	1	0	1	46	49	95
937349	MA	Essex	school	2508700	211	North Andover	250870000767	2110018	Annie L Sargent School	Regular School	No	1	KG	05	2016	grade_5	77	0	1	1	2	0	4	41	44		85	77	0	1	1	2	0	4	41	44	85
1127661	MA	Essex	school	2508700	211	North Andover	250870000767	2110018	Annie L Sargent School	Regular School	No	Elementary	KG	05	2017	grade_5	83	3	3	1	5	0	1	62	34		96	83	3	3	1	5	0	1	62	34	96
1369576	MA	Essex	school	2508700	211	North Andover	250870000767	2110018	Annie L Sargent School	Regular School	No	Elementary	01	05	2020	grade_5	85	3	5	1	7	0	3	57	47	*	104.0	85	3	5	1	7	0	3	57	47	104
2044649	MA	Essex	school	2508700	211	North Andover	250870000767	2110018	Annie L Sargent School	Regular School	No	Elementary	01	05	2019	grade_5	74	1	7	0	8	0	4	40	54		94.0	74	1	7	0	8	0	4	40	54	94
737026	MA	Norfolk	school	2502940	40	Braintree	250294000360	400033	Archie T Morrison	Regular School	No	1	KG	05	2015	grade_5	51	5	2	0	7	0	0	32	33		65	51	5	2	0	7	0	0	32	33	65