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 (black > :p3 or (black = :p3 and rowid > :p2)) order by black, 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	hispanic	native_american	asian	native_hawaiian_pacific_islander	multiracial	male	female	total	white_int	hispanic_int	native_american_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int	male_int	female_int	total_int
742287	MA	Dukes	school	2512570	296	Tisbury	251257002054	2960005	Tisbury Elementary	Regular School	No	1	PK	08	2015	grade_8	23	5	0	0	0	2	23	7	30	23	5	0	0	0	2	23	7	30
742795	MA	Bristol	school	2512780	331	Westport	251278002093	3310505	Westport High	Regular School	No	3	08	12	2015	grade_8	16	2	0	0	0	0	4	14	18	16	2	0	0	0	0	4	14	18
743435	MA	Franklin	school	2500076	413	Four Rivers Charter Public (District)	250007602086	4130505	Four Rivers Charter Public School	Regular School	Yes	3	07	12	2015	grade_8	29	3	0	0	0	4	16	20	36	29	3	0	0	0	4	16	20	36
743636	MA	Norfolk	school	2500030	447	Benjamin Franklin Classical Charter Public (District)	250003000547	4470205	Benjamin Franklin Classical Charter Public School	Regular School	Yes	1	KG	08	2015	grade_8	39	0	0	11	0	1	21	30	51	39	0	0	11	0	1	21	30	51
743653	MA	Hampshire	school	2500031	450	Hilltown Cooperative Charter Public (District)	250003100549	4500105	Hilltown Cooperative Charter Public School	Regular School	Yes	1	KG	08	2015	grade_8	17	0	0	0	0	0	7	10	17	17	0	0	0	0	0	7	10	17
743675	MA	Essex	school	2500032	454	Lawrence Family Development Charter (District)	250003200553	4540205	Lawrence Family Development Charter School	Regular School	Yes	1	KG	08	2015	grade_8	0	58	0	0	0	0	21	37	58	0	58	0	0	0	0	21	37	58
743777	MA	Middlesex	school	2500038	478	Francis W. Parker Charter Essential (District)	250003800581	4780505	Francis W. Parker Charter Essential School	Regular School	Yes	3	07	12	2015	grade_8	64	2	0	2	0	1	33	36	69	64	2	0	2	0	1	33	36	69
743807	MA	Essex	school	2500062	482	River Valley Charter (District)	250006201446	4820050	River Valley Charter School	Regular School	Yes	1	KG	08	2015	grade_8	22	3	0	2	0	1	14	14	28	22	3	0	2	0	1	14	14	28
744013	MA	Worcester	school	2502040	610	Ashburnham-Westminster	250204000831	6100305	Overlook Middle School	Regular School	No	2	06	08	2015	grade_8	175	4	0	4	0	7	91	99	190	175	4	0	4	0	7	91	99	190
744218	MA	Bristol	school	2504200	650	Dighton-Rehoboth	250420000400	6500305	Dighton Middle School	Regular School	No	2	05	08	2015	grade_8	80	0	0	2	0	3	54	31	85	80	0	0	2	0	3	54	31	85
744254	MA	Worcester	school	2504360	658	Dudley-Charlton Reg	250436001597	6580310	Charlton Middle School	Regular School	No	2	05	08	2015	grade_8	176	9	0	3	0	3	98	93	191	176	9	0	3	0	3	98	93	191
744314	MA	Hampshire	school	2505160	672	Gateway	250516002667	6720405	Gateway Regional Junior High School	Regular School	No	2	07	08	2015	grade_8	76	5	0	0	0	0	47	34	81	76	5	0	0	0	0	47	34	81
744385	MA	Essex	school	2505670	675	Hamilton-Wenham	250567001276	6750310	Miles River Middle	Regular School	No	2	06	08	2015	grade_8	139	4	0	6	1	3	80	73	153	139	4	0	6	1	3	80	73	153
744406	MA	Hampden	school	2505730	680	Hampden-Wilbraham	250573002547	6800305	Thornton Burgess	Regular School	No	2	05	08	2015	grade_8	58	5	0	1	0	4	39	29	68	58	5	0	1	0	4	39	29	68
744415	MA	Hampshire	school	2505740	683	Hampshire	250574000825	6830505	Hampshire Regional High	Regular School	No	3	07	12	2015	grade_8	114	3	0	0	0	2	63	56	119	114	3	0	0	0	2	63	56	119
744456	MA	Essex	school	2500067	698	Manchester Essex Regional	250006702653	6980030	Manchester Essex Regional Middle School	Regular School	No	2	06	08	2015	grade_8	118	0	0	0	0	2	55	65	120	118	0	0	0	0	2	55	65	120
744467	MA	Essex	school	2507410	705	Masconomet	250741001097	7050405	Masconomet Regional Middle School	Regular School	No	2	07	08	2015	grade_8	305	8	2	8	0	8	177	154	331	305	8	2	8	0	8	177	154	331
744606	MA	Worcester	school	2508310	725	Nashoba	250831001868	7250310	Hale	Regular School	No	2	06	08	2015	grade_8	72	2	0	4	0	3	37	44	81	72	2	0	4	0	3	37	44	81
744803	MA	Berkshire	school	2511040	765	Southern Berkshire	251104001774	7650505	Mt Everett Regional	Regular School	No	3	07	12	2015	grade_8	46	1	0	0	0	5	21	31	52	46	1	0	0	0	5	21	31	52
744822	MA	Hampden	school	2500013	766	Southwick-Tolland-Granville Regional School District	250001302773	7660205	Granville Village School	Regular School	No	1	KG	08	2015	grade_8	14	1	0	0	0	1	7	9	16	14	1	0	0	0	1	7	9	16
744890	MA	Essex	school	2511740	773	Triton	251174001470	7730405	Triton Regional Middle School	Regular School	No	2	07	08	2015	grade_8	219	7	0	3	0	2	113	118	231	219	7	0	3	0	2	113	118	231
744911	MA	Dukes	school	2500043	774	Up-Island Regional	250004301927	7740020	West Tisbury Elementary	Regular School	No	1	PK	08	2015	grade_8	26	3	1	0	0	0	15	15	30	26	3	1	0	0	0	15	15	30
744965	MA	Worcester	school	2511880	775	Wachusett	251188001280	7750310	Central Tree Middle	Regular School	No	2	06	08	2015	grade_8	148	5	0	5	0	2	70	90	160	148	5	0	5	0	2	70	90	160
744969	MA	Worcester	school	2511880	775	Wachusett	251188001494	7750315	Chocksett Middle School	Regular School	No	2	05	08	2015	grade_8	105	4	0	4	0	0	57	56	113	105	4	0	4	0	0	57	56	113
932875	MA	Hampshire	school	2502430	24	Belchertown	250243001873	240025	Jabish Middle School	Regular School	No	2	07	08	2016	grade_8	185	9	0	3	0	2	104	95	199	185	9	0	3	0	2	104	95	199
933311	MA	Suffolk	school	2502790	35	Boston	250279000272	350182	Joseph J Hurley	Regular School	No	1	PK	08	2016	grade_8	1	16	0	0	0	0	10	7	17	1	16	0	0	0	0	10	7	17
933810	MA	Suffolk	school	2502790	35	Boston	250279000312	350691	Rafael Hernandez	Regular School	No	1	PK	08	2016	grade_8	0	27	0	0	0	0	11	16	27	0	27	0	0	0	0	11	16	27
934409	MA	Hampden	school	2503660	61	Chicopee	250366000720	610021	Chicopee Academy	Alternative Education School	No	4	06	12	2016	grade_8	5	11	0	0	0	0	13	3	16	5	11	0	0	0	0	13	3	16
934468	MA	Berkshire	school	2503720	63	Clarksburg	250372000510	630010	Clarksburg Elementary	Regular School	No	1	KG	08	2016	grade_8	15	1	0	0	0	0	7	9	16	15	1	0	0	0	0	7	9	16
934640	MA	Worcester	school	2504230	77	Douglas	250423002788	770305	Douglas Middle School	Regular School	No	2	06	08	2016	grade_8	136	2	0	3	1	4	65	81	146	136	2	0	3	1	4	65	81	146
934792	MA	Dukes	school	2509090	89	Edgartown	250909001469	890005	Edgartown Elementary	Regular School	No	1	PK	08	2016	grade_8	35	3	0	0	0	1	21	18	39	35	3	0	0	0	1	21	18	39
935196	MA	Norfolk	school	2505010	101	Franklin	250501000871	1010310	Remington Middle	Regular School	No	2	06	08	2016	grade_8	140	3	0	8	2	7	81	79	160	140	3	0	8	2	7	81	79	160
935199	MA	Norfolk	school	2505010	101	Franklin	250501000738	1010405	Horace Mann	Regular School	No	2	06	08	2016	grade_8	137	1	1	7	0	5	76	75	151	137	1	1	7	0	5	76	75	151
935233	MA	Essex	school	2505220	105	Georgetown	250522002764	1050305	Georgetown Middle School	Regular School	No	2	07	08	2016	grade_8	120	2	0	0	0	4	62	64	126	120	2	0	0	0	4	62	64	126
935310	MA	Hampshire	school	2505400	111	Granby	250540000790	1110505	Granby Jr Sr High School	Regular School	No	3	07	12	2016	grade_8	58	6	0	3	0	0	35	32	67	58	6	0	3	0	0	35	32	67
935351	MA	Hampshire	school	2505580	117	Hadley	250558000813	1170505	Hopkins Academy	Regular School	No	3	07	12	2016	grade_8	36	3	0	2	1	0	23	19	42	36	3	0	2	1	0	23	19	42
935384	MA	Plymouth	school	2505790	122	Hanover	250579002548	1220305	Hanover Middle	Regular School	No	2	05	08	2016	grade_8	195	2	0	3	0	0	104	96	200	195	2	0	3	0	0	104	96	200
935413	MA	Hampshire	school	2505940	127	Hatfield	250594000845	1270505	Smith Academy	Regular School	No	3	07	12	2016	grade_8	31	2	0	0	0	2	19	16	35	31	2	0	0	0	2	19	16	35
935573	MA	Hampden	school	2506270	137	Holyoke	250627000910	1370025	Morgan Full Service Community School	Regular School	No	1	PK	08	2016	grade_8	2	36	0	1	0	0	21	18	39	2	36	0	1	0	0	21	18	39
935578	MA	Hampden	school	2506270	137	Holyoke	250627002645	1370030	William R. Peck School	Regular School	No	2	04	08	2016	grade_8	2	63	0	1	0	2	40	28	68	2	63	0	1	0	2	40	28	68
935587	MA	Hampden	school	2506270	137	Holyoke	250627000904	1370040	Kelly Elementary	Regular School	No	1	KG	08	2016	grade_8	0	47	0	0	0	0	20	27	47	0	47	0	0	0	0	20	27	47
935606	MA	Hampden	school	2506270	137	Holyoke	250627000907	1370055	Lt Clayre Sullivan Elementary	Regular School	No	1	KG	08	2016	grade_8	13	45	0	0	0	2	30	30	60	13	45	0	0	0	2	30	30	60
935715	MA	Essex	school	2506480	144	Ipswich	250648000937	1440305	Ipswich Middle School	Regular School	No	2	06	08	2016	grade_8	145	6	0	3	0	4	77	81	158	145	6	0	3	0	4	77	81	158
935762	MA	Essex	school	2506660	149	Lawrence	250666001945	1490017	Arlington Middle School	Regular School	No	2	05	08	2016	grade_8	2	138	0	0	0	0	70	70	140	2	138	0	0	0	0	70	70	140
935816	MA	Essex	school	2506660	149	Lawrence	250666000955	1490080	Emily G Wetherbee	Regular School	No	1	KG	08	2016	grade_8	5	67	0	4	0	0	38	38	76	5	67	0	4	0	0	38	38	76
935865	MA	Essex	school	2506660	149	Lawrence	250666002625	1490537	School for Exceptional Studies	Regular School	No	4	01	12	2016	grade_8	4	7	0	0	0	0	9	2	11	4	7	0	0	0	0	9	2	11
935884	MA	Berkshire	school	2506690	150	Lee	250669000970	1500505	Lee Middle/High School	Regular School	No	3	07	12	2016	grade_8	47	5	0	1	0	0	27	26	53	47	5	0	1	0	0	27	26	53
935912	MA	Berkshire	school	2506750	152	Lenox	250675000978	1520505	Lenox Memorial High	Regular School	No	4	06	12	2016	grade_8	58	7	0	1	0	1	31	36	67	58	7	0	1	0	1	31	36	67
936816	MA	Worcester	school	2507890	186	Millbury	250789001249	1860505	Millbury Junior/Senior High	Regular School	No	3	07	12	2016	grade_8	130	12	0	0	0	2	64	80	144	130	12	0	0	0	2	64	80	144
936880	MA	Hampden	school	2508040	191	Monson	250804001655	1910310	Granite Valley Middle	Regular School	No	2	05	08	2016	grade_8	87	2	0	0	1	2	42	50	92	87	2	0	0	1	2	42	50	92
937439	MA	Worcester	school	2508940	214	Northbridge	250894002591	2140305	Northbridge Middle	Regular School	No	2	05	08	2016	grade_8	153	12	0	1	0	8	85	89	174	153	12	0	1	0	8	85	89	174
937453	MA	Worcester	school	2508760	215	North Brookfield	250876001411	2150505	North Brookfield High	Regular School	No	3	07	12	2016	grade_8	51	2	0	1	0	1	31	24	55	51	2	0	1	0	1	31	24	55
938104	MA	Berkshire	school	2510080	249	Richmond	251008001635	2490005	Richmond Consolidated	Regular School	No	1	PK	08	2016	grade_8	20	1	0	0	0	0	11	10	21	20	1	0	0	0	0	11	10	21
939121	MA	Middlesex	school	2511760	301	Tyngsborough	251176001715	3010305	Tyngsborough Middle	Regular School	No	2	06	08	2016	grade_8	131	6	0	13	0	7	73	84	157	131	6	0	13	0	7	73	84	157
939555	MA	Middlesex	school	2512660	326	Westford	251266000170	3260310	Blanchard Middle	Regular School	No	2	06	08	2016	grade_8	149	3	0	40	0	2	101	93	194	149	3	0	40	0	2	101	93	194
939600	MA	Bristol	school	2512780	331	Westport	251278002094	3310305	Westport Junior High School	Regular School	No	2	07	08	2016	grade_8	118	4	1	2	0	3	70	58	128	118	4	1	2	0	3	70	58	128
939785	MA	Middlesex	school	2513080	343	Winchendon	251308002796	3430315	Murdock Middle School	Regular School	No	2	06	08	2016	grade_8	93	6	0	8	0	2	48	61	109	93	6	0	8	0	2	48	61	109
940256	MA	Franklin	school	2500076	413	Four Rivers Charter Public (District)	250007602086	4130505	Four Rivers Charter Public School	Regular School	Yes	3	07	12	2016	grade_8	34	0	0	1	0	2	16	21	37	34	0	0	1	0	2	16	21	37
940476	MA	Hampshire	school	2500031	450	Hilltown Cooperative Charter Public (District)	250003100549	4500105	Hilltown Cooperative Charter Public School	Regular School	Yes	1	KG	08	2016	grade_8	15	2	0	1	0	5	11	12	23	15	2	0	1	0	5	11	12	23
940489	MA	Hampden	school	2500087	453	Holyoke Community Charter (District)	250008701997	4530005	Holyoke Community Charter School	Regular School	Yes	1	KG	08	2016	grade_8	9	69	0	0	0	2	38	42	80	9	69	0	0	0	2	38	42	80
940499	MA	Essex	school	2500032	454	Lawrence Family Development Charter (District)	250003200553	4540205	Lawrence Family Development Charter School	Regular School	Yes	1	PK	08	2016	grade_8	0	62	0	0	0	0	27	35	62	0	62	0	0	0	0	27	35	62
940508	MA	Essex	school	2500083	455	Hill View Montessori Charter Public (District)	250008301846	4550050	Hill View Montessori Charter Public School	Regular School	Yes	1	KG	08	2016	grade_8	26	7	0	0	0	0	11	22	33	26	7	0	0	0	0	11	22	33
940606	MA	Middlesex	school	2500038	478	Francis W. Parker Charter Essential (District)	250003800581	4780505	Francis W. Parker Charter Essential School	Regular School	Yes	3	07	12	2016	grade_8	64	4	0	1	0	1	38	32	70	64	4	0	1	0	1	38	32	70
940636	MA	Essex	school	2500062	482	River Valley Charter (District)	250006201446	4820050	River Valley Charter School	Regular School	Yes	1	KG	08	2016	grade_8	29	0	0	1	0	0	13	17	30	29	0	0	1	0	0	13	17	30
940640	MA	Plymouth	school	2500057	483	Rising Tide Charter Public (District)	250005701271	4830305	Rising Tide Charter Public School	Regular School	Yes	4	05	12	2016	grade_8	81	3	1	3	0	1	38	51	89	81	3	1	3	0	1	38	51	89
940938	MA	Worcester	school	2502715	622	Blackstone-Millville	250271501082	6220405	Frederick W. Hartnett Middle School	Regular School	No	2	06	08	2016	grade_8	140	8	0	1	0	1	70	80	150	140	8	0	1	0	1	70	80	150
940999	MA	Berkshire	school	2503390	635	Central Berkshire	250339000466	6350305	Nessacus Regional Middle School	Regular School	No	2	06	08	2016	grade_8	121	7	0	0	0	2	71	59	130	121	7	0	0	0	2	71	59	130
941140	MA	Hampshire	school	2505160	672	Gateway	250516002667	6720405	Gateway Regional Junior High School	Regular School	No	2	07	08	2016	grade_8	72	3	0	0	0	3	31	47	78	72	3	0	0	0	3	31	47	78
941211	MA	Essex	school	2505670	675	Hamilton-Wenham	250567001276	6750310	Miles River Middle	Regular School	No	2	06	08	2016	grade_8	128	3	0	4	0	0	52	83	135	128	3	0	4	0	0	52	83	135
941232	MA	Hampden	school	2505730	680	Hampden-Wilbraham	250573002547	6800305	Thornton Burgess	Regular School	No	2	05	08	2016	grade_8	67	1	0	2	0	5	41	34	75	67	1	0	2	0	5	41	34	75
941241	MA	Hampshire	school	2505740	683	Hampshire	250574000825	6830505	Hampshire Regional High	Regular School	No	3	07	12	2016	grade_8	136	2	0	0	0	4	70	72	142	136	2	0	0	0	4	70	72	142
941281	MA	Essex	school	2500067	698	Manchester Essex Regional	250006702653	6980030	Manchester Essex Regional Middle School	Regular School	No	2	06	08	2016	grade_8	116	2	0	2	0	0	53	67	120	116	2	0	2	0	0	53	67	120
941292	MA	Essex	school	2507410	705	Masconomet	250741001097	7050405	Masconomet Regional Middle School	Regular School	No	2	07	08	2016	grade_8	299	8	1	8	0	7	161	162	323	299	8	1	8	0	7	161	162	323
941340	MA	Berkshire	school	2508160	715	Mount Greylock	250816001273	7150505	Mt Greylock Regional High	Regular School	No	3	07	12	2016	grade_8	86	4	0	1	0	2	49	44	93	86	4	0	1	0	2	49	44	93
941377	MA	Franklin	school	2507990	717	Mohawk Trail	250799001265	7170505	Mohawk Trail Regional High	Regular School	No	3	07	12	2016	grade_8	56	4	0	4	0	4	29	39	68	56	4	0	4	0	4	29	39	68
941424	MA	Worcester	school	2508310	725	Nashoba	250831001102	7250025	Florence Sawyer School	Regular School	No	1	PK	08	2016	grade_8	78	3	0	2	0	1	41	43	84	78	3	0	2	0	1	41	43	84
941430	MA	Worcester	school	2508310	725	Nashoba	250831001868	7250310	Hale	Regular School	No	2	06	08	2016	grade_8	82	2	0	1	0	2	43	44	87	82	2	0	1	0	2	43	44	87
941509	MA	Essex	school	2509450	745	Pentucket	250945001512	7450405	Pentucket Regional Middle	Regular School	No	2	07	08	2016	grade_8	245	6	0	1	0	0	140	112	252	245	6	0	1	0	0	140	112	252
941546	MA	Franklin	school	2509600	750	Pioneer Valley	250960001515	7500505	Pioneer Valley Regional	Regular School	No	3	07	12	2016	grade_8	72	1	0	0	0	2	35	40	75	72	1	0	0	0	2	35	40	75
941581	MA	Worcester	school	2500001	753	Quabbin	250000102003	7530405	Quabbin Regional Middle School	Regular School	No	2	07	08	2016	grade_8	191	8	0	2	0	8	106	103	209	191	8	0	2	0	8	106	103	209
941628	MA	Berkshire	school	2511040	765	Southern Berkshire	251104001774	7650505	Mt Everett Regional	Regular School	No	3	07	12	2016	grade_8	46	7	0	0	0	2	30	25	55	46	7	0	0	0	2	30	25	55
941732	MA	Dukes	school	2500043	774	Up-Island Regional	250004301927	7740020	West Tisbury Elementary	Regular School	No	1	PK	08	2016	grade_8	35	0	1	1	0	1	23	15	38	35	0	1	1	0	1	23	15	38
941777	MA	Worcester	school	2511880	775	Wachusett	251188001553	7750045	Thomas Prince	Regular School	No	1	KG	08	2016	grade_8	48	0	0	0	0	2	24	26	50	48	0	0	0	0	2	24	26	50
941790	MA	Worcester	school	2511880	775	Wachusett	251188001494	7750315	Chocksett Middle School	Regular School	No	2	05	08	2016	grade_8	102	4	0	3	0	0	58	51	109	102	4	0	3	0	0	58	51	109
1122874	MA	Suffolk	school	2502790	35	Boston	250279000272	350182	Joseph J Hurley	Regular School	No	Elementary	PK	08	2017	grade_8	0	17	0	0	0	0	5	12	17	0	17	0	0	0	0	5	12	17
1124016	MA	Middlesex	school	2503330	51	Carlisle	250333000457	510025	Carlisle School	Regular School	No	Elementary	PK	08	2017	grade_8	54	0	0	9	0	5	35	33	68	54	0	0	9	0	5	35	33	68
1124028	MA	Plymouth	school	2503360	52	Carver	250336002662	520405	Carver Middle/High School	Regular School	No	Other	06	12	2017	grade_8	150	1	0	0	1	3	79	76	155	150	1	0	0	1	3	79	76	155
1124215	MA	Berkshire	school	2503720	63	Clarksburg	250372000510	630010	Clarksburg Elementary	Regular School	No	Elementary	KG	08	2017	grade_8	16	0	0	0	0	0	6	10	16	16	0	0	0	0	0	6	10	16
1125132	MA	Essex	school	2505220	105	Georgetown	250522002764	1050305	Georgetown Middle School	Regular School	No	Middle	07	08	2017	grade_8	112	0	0	1	0	1	59	55	114	112	0	0	1	0	1	59	55	114
1125285	MA	Franklin	school	2505490	114	Greenfield	250549000801	1140505	Greenfield High	Regular School	No	High	08	12	2017	grade_8	66	15	0	2	0	7	53	37	90	66	15	0	2	0	7	53	37	90
1125301	MA	Hampshire	school	2505580	117	Hadley	250558000813	1170505	Hopkins Academy	Regular School	No	High	07	12	2017	grade_8	45	2	0	0	0	2	28	21	49	45	2	0	0	0	2	28	21	49
1125399	MA	Essex	school	2505970	128	Haverhill	250597001698	1280033	Haverhill Alternative School	Regular School	No	High	07	12	2017	grade_8	5	4	0	0	0	0	7	2	9	5	4	0	0	0	0	7	2	9
1125553	MA	Hampden	school	2506270	137	Holyoke	250627000908	1370015	Lt Elmer J McMahon Elementary	Regular School	No	Elementary	PK	08	2017	grade_8	10	33	1	0	0	0	29	15	44	10	33	1	0	0	0	29	15	44
1125564	MA	Hampden	school	2506270	137	Holyoke	250627000910	1370025	Morgan Full Service Community School	Regular School	No	Elementary	PK	08	2017	grade_8	0	39	0	0	0	0	19	20	39	0	39	0	0	0	0	19	20	39
1125570	MA	Hampden	school	2506270	137	Holyoke	250627002645	1370030	William R. Peck School	Regular School	No	Elementary	04	08	2017	grade_8	5	65	0	0	0	0	37	33	70	5	65	0	0	0	0	37	33	70
1125580	MA	Hampden	school	2506270	137	Holyoke	250627000904	1370040	Kelly Elementary	Regular School	No	Elementary	KG	08	2017	grade_8	1	40	0	2	0	0	17	26	43	1	40	0	2	0	0	17	26	43
1125591	MA	Hampden	school	2506270	137	Holyoke	250627002581	1370045	E N White Elementary	Regular School	No	Elementary	PK	08	2017	grade_8	8	35	0	0	0	2	21	24	45	8	35	0	0	0	2	21	24	45
1125639	MA	Worcester	school	2506300	138	Hopedale	250630000915	1380505	Hopedale Jr Sr High	Regular School	No	High	07	12	2017	grade_8	81	1	1	4	0	1	43	45	88	81	1	1	4	0	1	43	45	88
1125814	MA	Essex	school	2506660	149	Lawrence	250666002623	1490027	Parthum Middle School	Regular School	No	Middle	05	08	2017	grade_8	11	113	0	1	0	1	70	56	126	11	113	0	1	0	1	70	56	126
1125853	MA	Essex	school	2506660	149	Lawrence	250666000955	1490080	Emily G Wetherbee	Regular School	No	Elementary	KG	08	2017	grade_8	4	87	0	4	0	1	52	44	96	4	87	0	4	0	1	52	44	96
1125857	MA	Essex	school	2506660	149	Lawrence	250666002758	1490085	Spark Academy	Regular School	No	Middle	06	08	2017	grade_8	8	147	0	5	0	0	75	85	160	8	147	0	5	0	0	75	85	160