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 order by school desc 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	total	white_int	black_int	hispanic_int	native_american_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int	total_int
743038	MA	Suffolk	school	2513170	346	Winthrop	251317002180	3460505	Winthrop Sr High	Regular School	No	3	08	12	2015	SP	*	*	*	*	*	*	*	1								1
742971	MA	Middlesex	school	2513050	342	Wilmington	251305002158	3420505	Wilmington High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	4								4
736684	MA	Suffolk	school	2502790	35	Boston	250279000342	350363	William McKinley	Regular School	No	4	KG	12	2015	SP	6	18	4	0	0	0	2	30	6	18	4	0	0	0	2	30
745026	MA	Plymouth	school	2512930	780	Whitman-Hanson	251293002135	7800505	Whitman Hanson Regional	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	3								3
742925	MA	Norfolk	school	2512840	336	Weymouth	251284002123	3360505	Weymouth High School	Regular School	No	3	09	12	2015	SP	6	1	0	0	0	0	0	7	6	1	0	0	0	0	0	7
742784	MA	Middlesex	school	2512750	330	Weston	251275002087	3300505	Weston High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	3								3
742723	MA	Hampden	school	2512630	325	Westfield	251263002073	3250505	Westfield High	Regular School	No	3	09	12	2015	SP	22	3	2	0	0	0	0	27	22	3	2	0	0	0	0	27
742640	MA	Worcester	school	2512600	321	Westborough	251260002059	3210505	Westborough High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	2								2
742835	MA	Hampden	school	2512510	332	West Springfield	251251002052	3320505	West Springfield High	Regular School	No	3	09	12	2015	SP	10	1	1	0	0	0	0	12	10	1	1	0	0	0	0	12
736934	MA	Suffolk	school	2502790	35	Boston	250279002729	350658	West Roxbury Academy	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	2								2
742655	MA	Worcester	school	2512390	322	West Boylston	251239002035	3220505	West Boylston Junior/Senior High	Regular School	No	4	06	12	2015	SP	*	*	*	*	*	*	*	2								2
742610	MA	Norfolk	school	2512270	317	Wellesley	251227002030	3170505	Wellesley Sr High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	3								3
742493	MA	Plymouth	school	2512060	310	Wareham	251206001991	3100505	Wareham Senior High	Regular School	No	3	09	12	2015	SP	5	0	1	0	0	0	1	7	5	0	1	0	0	0	1	7
742469	MA	Hampshire	school	2512030	309	Ware	251203001983	3090505	Ware Junior/Senior High School	Regular School	No	3	07	12	2015	SP	*	*	*	*	*	*	*	4								4
742454	MA	Middlesex	school	2512000	308	Waltham	251200001979	3080505	Waltham Sr High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	2								2
742405	MA	Norfolk	school	2511970	307	Walpole	251197001964	3070505	Walpole High	Regular School	No	3	09	12	2015	SP	5	0	0	0	1	0	0	6	5	0	0	0	1	0	0	6
742361	MA	Middlesex	school	2511910	305	Wakefield	251191001951	3050505	Wakefield Memorial High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	4								4
744177	MA	Berkshire	school	2503390	635	Central Berkshire	250339000467	6350505	Wahconah Regional High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	3								3
744974	MA	Worcester	school	2511880	775	Wachusett	251188001940	7750505	Wachusett Regional High	Regular School	No	3	09	12	2015	SP	11	0	0	0	0	0	0	11	11	0	0	0	0	0	0	11
742331	MA	Worcester	school	2511850	304	Uxbridge	251185001938	3040505	Uxbridge High	Regular School	No	3	09	12	2015	SP	8	0	0	0	0	0	0	8	8	0	0	0	0	0	0	8
736898	MA	Suffolk	school	2502790	35	Boston	250279001898	350579	Urban Science Academy	Regular School	No	3	09	12	2015	SP	1	7	0	0	1	0	0	9	1	7	0	0	1	0	0	9
744363	MA	Franklin	school	2505270	674	Gill-Montague	250527000768	6740505	Turners Fall High	Regular School	No	3	09	12	2015	SP	7	0	2	0	0	0	0	9	7	0	2	0	0	0	0	9
744895	MA	Essex	school	2511740	773	Triton	251174001932	7730505	Triton Regional High School	Regular School	No	3	09	12	2015	SP	6	0	0	0	0	0	0	6	6	0	0	0	0	0	0	6
736831	MA	Suffolk	school	2502790	35	Boston	250279000327	350535	The English High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	2								2
742277	MA	Middlesex	school	2511580	295	Tewksbury	251158001926	2950505	Tewksbury Memorial High	Regular School	No	3	09	12	2015	SP	8	0	0	0	0	0	0	8	8	0	0	0	0	0	0	8
736929	MA	Suffolk	school	2502790	35	Boston	250279002725	350657	TechBoston Academy	Regular School	No	4	06	12	2015	SP	*	*	*	*	*	*	*	1								1
742253	MA	Bristol	school	2511520	293	Taunton	251152001915	2930505	Taunton High	Regular School	No	3	08	12	2015	SP	7	2	3	0	0	0	1	13	7	2	3	0	0	0	1	13
744860	MA	Worcester	school	2511490	770	Tantasqua	251149001900	7700505	Tantasqua Regional Sr High	Regular School	No	3	09	12	2015	SP	5	1	0	0	0	0	0	6	5	1	0	0	0	0	0	6
738609	MA	Essex	school	2505970	128	Haverhill	250597001706	1280073	TEACH	Regular School	No	4	02	12	2015	SP	*	*	*	*	*	*	*	5								5
742099	MA	Norfolk	school	2511250	285	Stoughton	251125001864	2850505	Stoughton High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	3								3
742059	MA	Middlesex	school	2511220	284	Stoneham	251122002295	2840505	Stoneham High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	1								1
742013	MA	Hampden	school	2511130	281	Springfield	251113002742	2810550	Springfield Public Day High School	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	3								3
742008	MA	Hampden	school	2511130	281	Springfield	251113000901	2810530	Springfield High School of Science and Technology	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	5								5
741998	MA	Hampden	school	2511130	281	Springfield	251113002444	2810500	Springfield Central High	Regular School	No	3	09	12	2015	SP	1	1	5	0	0	0	0	7	1	1	5	0	0	0	0	7
744831	MA	Hampden	school	2500013	766	Southwick-Tolland-Granville Regional School District	250001301782	7660505	Southwick-Tolland Regional High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	3								3
745114	MA	Bristol	school	2511020	872	Southeastern Regional Vocational Technical	251102002290	8720605	Southeastern Regional Vocational Technical	Vocational Education School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	1								1
741738	MA	Hampshire	school	2510920	278	South Hadley	251092001754	2780505	South Hadley High	Regular School	No	3	09	12	2015	SP	9	0	0	0	0	0	0	9	9	0	0	0	0	0	0	9
741682	MA	Middlesex	school	2510890	274	Somerville	251089001745	2740505	Somerville High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	4								4
736939	MA	Suffolk	school	2502790	35	Boston	250279000217	350690	Snowden International School at Copley	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	1								1
741576	MA	Worcester	school	2510770	271	Shrewsbury	251077001717	2710505	Shrewsbury Sr High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	1								1
741492	MA	Plymouth	school	2510560	264	Scituate	251056001693	2640505	Scituate High School	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	1								1
739021	MA	Essex	school	2506660	149	Lawrence	250666002625	1490537	School for Exceptional Studies	Regular School	No	4	01	12	2015	SP	1	0	5	0	0	0	0	6	1	0	5	0	0	0	0	6
741449	MA	Essex	school	2510500	262	Saugus	251050001684	2620505	Saugus High	Regular School	No	3	09	12	2015	SP	5	0	1	0	0	0	0	6	5	0	1	0	0	0	0	6
741386	MA	Essex	school	2510380	258	Salem	251038001664	2580505	Salem High	Regular School	No	3	09	12	2015	SP	3	0	4	0	0	0	0	7	3	0	4	0	0	0	0	7
742033	MA	Hampden	school	2511130	281	Springfield	251113002293	2810620	Roger L. Putnam Vocational Technical Academy	Vocational Education School	No	3	09	12	2015	SP	5	8	16	0	0	0	3	32	5	8	16	0	0	0	3	32
741308	MA	Plymouth	school	2510170	251	Rockland	251017001643	2510505	Rockland Senior High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	3								3
741263	MA	Suffolk	school	2510050	248	Revere	251005001630	2480505	Revere High	Regular School	No	3	09	12	2015	SP	2	0	4	0	0	0	0	6	2	0	4	0	0	0	0	6
741169	MA	Norfolk	school	2509930	244	Randolph	250993001596	2440505	Randolph High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	4								4
736887	MA	Suffolk	school	2502790	35	Boston	250279001296	350565	Quincy Upper School	Regular School	No	4	06	12	2015	SP	3	6	6	0	0	0	0	15	3	6	6	0	0	0	0	15
744654	MA	Middlesex	school	2508790	735	North Middlesex	250879002705	7350515	Peter Fitzpatrick School	Regular School	No	4	UG	UG	2015	SP	*	*	*	*	*	*	*	1								1
739004	MA	Essex	school	2506660	149	Lawrence	250666002616	1490535	Performing & Fine Arts High School	Regular School	No	3	09	12	2015	SP	0	0	8	0	2	0	0	10	0	0	8	0	2	0	0	10
744691	MA	Essex	school	2509450	745	Pentucket	250945001513	7450505	Pentucket Regional Sr High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	5								5
740882	MA	Plymouth	school	2509420	231	Pembroke	250942001824	2310505	Pembroke High School	Regular School	No	3	09	12	2015	SP	6	0	0	0	0	0	0	6	6	0	0	0	0	0	0	6
745105	MA	Hampden	school	2509310	860	Pathfinder Regional Vocational Technical	250931002285	8600605	Pathfinder Vocational Technical	Vocational Education School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	2								2
740786	MA	Hampden	school	2509300	227	Palmer	250930001485	2270505	Palmer High	Regular School	No	3	08	12	2015	SP	*	*	*	*	*	*	*	5								5
740771	MA	Worcester	school	2509270	226	Oxford	250927001482	2260505	Oxford High	Regular School	No	3	09	12	2015	SP	9	0	1	0	0	0	0	10	9	0	1	0	0	0	0	10
744018	MA	Worcester	school	2502040	610	Ashburnham-Westminster	250204000069	6100505	Oakmont Regional High School	Regular School	No	3	09	12	2015	SP	8	0	0	0	0	0	0	8	8	0	0	0	0	0	0	8
740728	MA	Norfolk	school	2509060	220	Norwood	250906001466	2200505	Norwood High	Regular School	No	3	09	12	2015	SP	7	0	0	0	0	0	0	7	7	0	0	0	0	0	0	7
740614	MA	Worcester	school	2508940	214	Northbridge	250894001445	2140505	Northbridge High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	4								4
740489	MA	Hampshire	school	2508850	210	Northampton	250885001432	2100505	Northampton High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	3								3
741136	MA	Norfolk	school	2509870	243	Quincy	250987001577	2430510	North Quincy High	Regular School	No	3	09	12	2015	SP	8	2	1	0	6	0	1	18	8	2	1	0	6	0	1	18
744653	MA	Middlesex	school	2508790	735	North Middlesex	250879001415	7350505	North Middlesex Regional	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	5								5
740571	MA	Bristol	school	2508730	212	North Attleborough	250873001405	2120505	North Attleboro High	Regular School	No	3	09	12	2015	SP	6	0	0	0	0	0	0	6	6	0	0	0	0	0	0	6
744493	MA	Worcester	school	2507680	710	Mendon-Upton	250768001202	7100510	Nipmuc Regional High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	4								4
740418	MA	Middlesex	school	2508610	207	Newton	250861001375	2070510	Newton South High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	1								1
740413	MA	Middlesex	school	2508610	207	Newton	250861001374	2070505	Newton North High	Regular School	No	3	09	12	2015	SP	21	1	0	0	4	0	0	26	21	1	0	0	4	0	0	26
740305	MA	Essex	school	2508580	204	Newburyport	250858001354	2040505	Newburyport High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	2								2
740279	MA	Bristol	school	2508430	201	New Bedford	250843001336	2010505	New Bedford High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	1								1
740138	MA	Norfolk	school	2508370	199	Needham	250837001315	1990505	Needham High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	2								2
744266	MA	Barnstable	school	2504560	660	Nauset	250456000610	6600505	Nauset Regional High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	3								3
744611	MA	Worcester	school	2508310	725	Nashoba	250831001289	7250505	Nashoba Regional	Regular School	No	3	09	12	2015	SP	11	0	1	0	0	0	0	12	11	0	1	0	0	0	0	12
740061	MA	Nantucket	school	2508250	197	Nantucket	250825001282	1970505	Nantucket High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	1								1
744521	MA	Berkshire	school	2508160	715	Mount Greylock	250816001273	7150505	Mt Greylock Regional High	Regular School	No	3	07	12	2015	SP	*	*	*	*	*	*	*	2								2
744081	MA	Berkshire	school	2502530	618	Berkshire Hills	250253000154	6180505	Monument Mt Regional High	Regular School	No	3	09	12	2015	SP	10	0	0	0	0	0	0	10	10	0	0	0	0	0	0	10
740038	MA	Hampden	school	2508040	191	Monson	250804001269	1910505	Monson Innovation High School	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	3								3
744514	MA	Barnstable	school	2500544	712	Monomoy Regional School District	250054402836	7120515	Monomoy Regional High School	Regular School	No	3	08	12	2015	SP	8	0	0	0	0	0	0	8	8	0	0	0	0	0	0	8
740023	MA	Norfolk	school	2507980	189	Milton	250798001262	1890505	Milton High	Regular School	No	3	09	12	2015	SP	5	5	0	0	0	0	0	10	5	5	0	0	0	0	0	10
739975	MA	Worcester	school	2507890	186	Millbury	250789001249	1860505	Millbury Junior/Senior High	Regular School	No	3	07	12	2015	SP	*	*	*	*	*	*	*	4								4
739960	MA	Worcester	school	2507860	185	Milford	250786001239	1850505	Milford High	Regular School	No	3	08	12	2015	SP	*	*	*	*	*	*	*	5								5
739934	MA	Plymouth	school	2507770	182	Middleborough	250777001227	1820505	Middleborough High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	5								5
739914	MA	Essex	school	2507740	181	Methuen	250774001213	1810505	Methuen High	Regular School	No	3	09	12	2015	SP	13	1	6	0	1	0	0	21	13	1	6	0	1	0	0	21
739810	MA	Middlesex	school	2507560	176	Medford	250756001176	1760505	Medford High	Regular School	No	3	09	12	2015	SP	7	1	0	0	0	0	0	8	7	1	0	0	0	0	0	8
744472	MA	Essex	school	2507410	705	Masconomet	250741001146	7050505	Masconomet Regional High School	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	1								1
744465	MA	Dukes	school	2507380	700	Martha's Vineyard	250738001145	7000505	Martha's Vineyard Regional High	Regular School	No	3	09	12	2015	SP	5	0	1	0	0	0	0	6	5	0	1	0	0	0	0	6
739681	MA	Middlesex	school	2507320	170	Marlborough	250732001133	1700505	Marlborough High	Regular School	No	3	09	12	2015	SP	9	1	2	0	0	0	1	13	9	1	2	0	0	0	1	13
739648	MA	Essex	school	2507260	168	Marblehead	250726001124	1680505	Marblehead High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	1								1
739624	MA	Bristol	school	2507230	167	Mansfield	250723001114	1670505	Mansfield High	Regular School	No	3	09	12	2015	SP	11	1	1	0	1	1	1	16	11	1	1	0	1	1	1	16
739629	MA	Essex	school	2507260	168	Marblehead	250726001123	1680005	Malcolm L Bell	Regular School	No	1	KG	03	2015	SP	*	*	*	*	*	*	*	1								1
736836	MA	Suffolk	school	2502790	35	Boston	250279000282	350537	Madison Park High	Vocational Education School	No	3	09	12	2015	SP	3	12	5	0	2	0	0	22	3	12	5	0	2	0	0	22
739540	MA	Essex	school	2507110	163	Lynn	250711002277	1630605	Lynn Vocational Technical Institute	Vocational Education School	No	3	07	12	2015	SP	4	3	10	0	4	0	1	22	4	3	10	0	4	0	1	22
739526	MA	Essex	school	2507110	163	Lynn	250711001080	1630510	Lynn English High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	2								2
739394	MA	Worcester	school	2507080	162	Lunenburg	250708001058	1620505	Lunenburg High	Regular School	No	3	08	12	2015	SP	*	*	*	*	*	*	*	2								2
739379	MA	Hampden	school	2507050	161	Ludlow	250705001056	1610505	Ludlow Senior High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	5								5
739364	MA	Middlesex	school	2507020	160	Lowell	250702001041	1600505	Lowell High	Regular School	No	3	09	12	2015	SP	6	2	6	0	7	0	0	21	6	2	6	0	7	0	0	21
744440	MA	Middlesex	school	2506930	695	Lincoln-Sudbury	250693001011	6950505	Lincoln-Sudbury Regional High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	2								2
739068	MA	Berkshire	school	2506750	152	Lenox	250675000978	1520505	Lenox Memorial High	Regular School	No	4	06	12	2015	SP	*	*	*	*	*	*	*	1								1
744433	MA	Norfolk	school	2506510	690	King Philip	250651000940	6900505	King Philip Regional High	Regular School	No	3	09	12	2015	SP	13	0	0	0	0	0	0	13	13	0	0	0	0	0	0	13
736821	MA	Suffolk	school	2502790	35	Boston	250279000261	350525	Jeremiah E Burke High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	4								4
738871	MA	Essex	school	2506480	144	Ipswich	250648000935	1440505	Ipswich High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	2								2
738991	MA	Essex	school	2506660	149	Lawrence	250666002633	1490532	Humanities & Leadership Development High School	Regular School	No	3	09	12	2015	SP	0	0	6	0	0	0	0	6	0	0	6	0	0	0	0	6
736963	MA	Suffolk	school	2502790	35	Boston	250279002374	350750	Horace Mann School for the Deaf	Special Education School	No	4	PK	12	2015	SP	0	3	4	0	2	0	0	9	0	3	4	0	2	0	0	9