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 multiracial 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
735672	MA	Plymouth	school	2501650	1	Abington	250165000001	10505	Abington High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	5								5
735734	MA	Essex	school	2501860	7	Amesbury	250186000034	70505	Amesbury High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	3								3
735950	MA	Norfolk	school	2502250	18	Avon	250225001295	180510	Avon Middle High School	Regular School	No	3	07	12	2015	SP	*	*	*	*	*	*	*	3								3
736816	MA	Suffolk	school	2502790	35	Boston	250279002016	350522	Excel High School	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	4								4
736821	MA	Suffolk	school	2502790	35	Boston	250279000261	350525	Jeremiah E Burke High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	4								4
736831	MA	Suffolk	school	2502790	35	Boston	250279000327	350535	The English High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	2								2
736853	MA	Suffolk	school	2502790	35	Boston	250279000837	350543	Greater Egleston Community High School	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	2								2
736903	MA	Suffolk	school	2502790	35	Boston	250279001902	350581	Community Academy of Science and Health	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	3								3
736929	MA	Suffolk	school	2502790	35	Boston	250279002725	350657	TechBoston Academy	Regular School	No	4	06	12	2015	SP	*	*	*	*	*	*	*	1								1
736934	MA	Suffolk	school	2502790	35	Boston	250279002729	350658	West Roxbury Academy	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	2								2
736939	MA	Suffolk	school	2502790	35	Boston	250279000217	350690	Snowden International School at Copley	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	1								1
737405	MA	Middlesex	school	2503270	49	Cambridge	250327000436	490506	Cambridge Rindge and Latin	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	4								4
737524	MA	Suffolk	school	2503540	57	Chelsea	250354000482	570505	Chelsea High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	4								4
737594	MA	Hampden	school	2503660	61	Chicopee	250366000496	610505	Chicopee High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	5								5
737624	MA	Worcester	school	2503750	64	Clinton	250375000513	640505	Clinton Senior High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	2								2
737708	MA	Essex	school	2503990	71	Danvers	250399000529	710505	Danvers High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	5								5
737735	MA	Bristol	school	2504020	72	Dartmouth	250402000540	720505	Dartmouth High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	1								1
737826	MA	Middlesex	school	2504320	79	Dracut	250432000579	790505	Dracut Senior High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	3								3
737890	MA	Hampshire	school	2504590	86	Easthampton	250459000612	860505	Easthampton High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	2								2
737908	MA	Hampden	school	2504500	87	East Longmeadow	250450000603	870505	East Longmeadow High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	1								1
738157	MA	Barnstable	school	2504860	96	Falmouth	250486000686	960505	Falmouth High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	4								4
738350	MA	Norfolk	school	2505010	101	Franklin	250501000737	1010505	Franklin High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	1								1
738505	MA	Hampshire	school	2505580	117	Hadley	250558000813	1170505	Hopkins Academy	Regular School	No	3	07	12	2015	SP	*	*	*	*	*	*	*	1								1
738539	MA	Plymouth	school	2505790	122	Hanover	250579000829	1220505	Hanover High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	3								3
738609	MA	Essex	school	2505970	128	Haverhill	250597001706	1280073	TEACH	Regular School	No	4	02	12	2015	SP	*	*	*	*	*	*	*	5								5
738668	MA	Plymouth	school	2506090	131	Hingham	250609000872	1310505	Hingham High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	5								5
738683	MA	Norfolk	school	2506150	133	Holbrook	250615000878	1330505	Holbrook Jr Sr High	Regular School	No	3	07	12	2015	SP	*	*	*	*	*	*	*	4								4
738706	MA	Middlesex	school	2506240	136	Holliston	250624000894	1360505	Holliston High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	1								1
738809	MA	Middlesex	school	2506330	139	Hopkinton	250633000920	1390505	Hopkinton High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	2								2
738871	MA	Essex	school	2506480	144	Ipswich	250648000935	1440505	Ipswich 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
739379	MA	Hampden	school	2507050	161	Ludlow	250705001056	1610505	Ludlow Senior High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	5								5
739394	MA	Worcester	school	2507080	162	Lunenburg	250708001058	1620505	Lunenburg High	Regular School	No	3	08	12	2015	SP	*	*	*	*	*	*	*	2								2
739521	MA	Essex	school	2507110	163	Lynn	250711001067	1630505	Classical High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	3								3
739526	MA	Essex	school	2507110	163	Lynn	250711001080	1630510	Lynn English High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	2								2
739629	MA	Essex	school	2507260	168	Marblehead	250726001123	1680005	Malcolm L Bell	Regular School	No	1	KG	03	2015	SP	*	*	*	*	*	*	*	1								1
739648	MA	Essex	school	2507260	168	Marblehead	250726001124	1680505	Marblehead High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	1								1
739934	MA	Plymouth	school	2507770	182	Middleborough	250777001227	1820505	Middleborough High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	5								5
739960	MA	Worcester	school	2507860	185	Milford	250786001239	1850505	Milford High	Regular School	No	3	08	12	2015	SP	*	*	*	*	*	*	*	5								5
739975	MA	Worcester	school	2507890	186	Millbury	250789001249	1860505	Millbury Junior/Senior High	Regular School	No	3	07	12	2015	SP	*	*	*	*	*	*	*	4								4
740038	MA	Hampden	school	2508040	191	Monson	250804001269	1910505	Monson Innovation High School	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	3								3
740061	MA	Nantucket	school	2508250	197	Nantucket	250825001282	1970505	Nantucket 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
740279	MA	Bristol	school	2508430	201	New Bedford	250843001336	2010505	New Bedford High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	1								1
740305	MA	Essex	school	2508580	204	Newburyport	250858001354	2040505	Newburyport High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	2								2
740418	MA	Middlesex	school	2508610	207	Newton	250861001375	2070510	Newton South High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	1								1
740489	MA	Hampshire	school	2508850	210	Northampton	250885001432	2100505	Northampton High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	3								3
740614	MA	Worcester	school	2508940	214	Northbridge	250894001445	2140505	Northbridge High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	4								4
740786	MA	Hampden	school	2509300	227	Palmer	250930001485	2270505	Palmer High	Regular School	No	3	08	12	2015	SP	*	*	*	*	*	*	*	5								5
740793	MA	Essex	school	2509360	229	Peabody	250936001501	2290005	Captain Samuel Brown	Regular School	No	1	KG	05	2015	SP	*	*	*	*	*	*	*	1								1
741169	MA	Norfolk	school	2509930	244	Randolph	250993001596	2440505	Randolph High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	4								4
741308	MA	Plymouth	school	2510170	251	Rockland	251017001643	2510505	Rockland Senior High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	3								3
741492	MA	Plymouth	school	2510560	264	Scituate	251056001693	2640505	Scituate High School	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
741682	MA	Middlesex	school	2510890	274	Somerville	251089001745	2740505	Somerville High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	4								4
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
742013	MA	Hampden	school	2511130	281	Springfield	251113002742	2810550	Springfield Public Day High School	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
742099	MA	Norfolk	school	2511250	285	Stoughton	251125001864	2850505	Stoughton High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	3								3
742168	MA	Essex	school	2511430	291	Swampscott	251143001884	2910010	Hadley	Regular School	No	1	KG	04	2015	SP	*	*	*	*	*	*	*	1								1
742361	MA	Middlesex	school	2511910	305	Wakefield	251191001951	3050505	Wakefield Memorial High	Regular School	No	3	09	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
742469	MA	Hampshire	school	2512030	309	Ware	251203001983	3090505	Ware Junior/Senior High School	Regular School	No	3	07	12	2015	SP	*	*	*	*	*	*	*	4								4
742559	MA	Worcester	school	2512240	316	Webster	251224002012	3160505	Bartlett Jr Sr High School	Regular School	No	3	07	12	2015	SP	*	*	*	*	*	*	*	5								5
742610	MA	Norfolk	school	2512270	317	Wellesley	251227002030	3170505	Wellesley Sr High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	3								3
742640	MA	Worcester	school	2512600	321	Westborough	251260002059	3210505	Westborough High	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
742784	MA	Middlesex	school	2512750	330	Weston	251275002087	3300505	Weston High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	3								3
742971	MA	Middlesex	school	2513050	342	Wilmington	251305002158	3420505	Wilmington High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	4								4
743038	MA	Suffolk	school	2513170	346	Winthrop	251317002180	3460505	Winthrop Sr High	Regular School	No	3	08	12	2015	SP	*	*	*	*	*	*	*	1								1
743997	MA	Hampshire	school	2501920	605	Amherst-Pelham	250192000042	6050505	Amherst Regional High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	4								4
744109	MA	Worcester	school	2502715	622	Blackstone-Millville	250271500192	6220505	Blackstone Millville RHS	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
744266	MA	Barnstable	school	2504560	660	Nauset	250456000610	6600505	Nauset Regional High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	3								3
744300	MA	Franklin	school	2505100	670	Frontier	250510000749	6700505	Frontier Regional	Regular School	No	3	07	12	2015	SP	*	*	*	*	*	*	*	4								4
744321	MA	Hampshire	school	2505160	672	Gateway	250516000758	6720505	Gateway Regional High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	1								1
744341	MA	Middlesex	school	2505500	673	Groton-Dunstable	250550000807	6730505	Groton Dunstable Regional	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	5								5
744420	MA	Hampshire	school	2505740	683	Hampshire	250574000825	6830505	Hampshire Regional High	Regular School	No	3	07	12	2015	SP	*	*	*	*	*	*	*	3								3
744440	MA	Middlesex	school	2506930	695	Lincoln-Sudbury	250693001011	6950505	Lincoln-Sudbury Regional High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	2								2
744472	MA	Essex	school	2507410	705	Masconomet	250741001146	7050505	Masconomet Regional High School	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	1								1
744493	MA	Worcester	school	2507680	710	Mendon-Upton	250768001202	7100510	Nipmuc Regional High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	4								4
744521	MA	Berkshire	school	2508160	715	Mount Greylock	250816001273	7150505	Mt Greylock Regional High	Regular School	No	3	07	12	2015	SP	*	*	*	*	*	*	*	2								2
744653	MA	Middlesex	school	2508790	735	North Middlesex	250879001415	7350505	North Middlesex Regional	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	5								5
744654	MA	Middlesex	school	2508790	735	North Middlesex	250879002705	7350515	Peter Fitzpatrick School	Regular School	No	4	UG	UG	2015	SP	*	*	*	*	*	*	*	1								1
744691	MA	Essex	school	2509450	745	Pentucket	250945001513	7450505	Pentucket Regional Sr High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	5								5
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
744853	MA	Worcester	school	2500002	767	Spencer-E Brookfield	250000201790	7670505	David Prouty High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	4								4
745026	MA	Plymouth	school	2512930	780	Whitman-Hanson	251293002135	7800505	Whitman Hanson Regional	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	3								3
745047	MA	Barnstable	school	2503310	815	Cape Cod Regional Vocational Technical	250331002264	8150605	Cape Cod Region Vocational Technical	Vocational Education School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	4								4
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
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
735805	MA	Essex	school	2501950	9	Andover	250195000045	90505	Andover High	Regular School	No	3	09	12	2015	SP	15	1	0	0	0	0	0	16	15	1	0	0	0	0	0	16
735935	MA	Worcester	school	2502220	17	Auburn	250222000100	170505	Auburn Senior 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
736119	MA	Essex	school	2502640	30	Beverly	250264000164	300505	Beverly High	Regular School	No	3	09	12	2015	SP	8	0	1	0	0	0	0	9	8	0	1	0	0	0	0	9
736167	MA	Middlesex	school	2502670	31	Billerica	250267000177	310505	Billerica Memorial High School	Regular School	No	3	09	12	2015	SP	9	0	0	0	0	0	0	9	9	0	0	0	0	0	0	9
736242	MA	Suffolk	school	2502790	35	Boston	250279000210	350036	Carter Developmental Center	Regular School	No	3	07	12	2015	SP	0	7	0	0	0	0	0	7	0	7	0	0	0	0	0	7
736798	MA	Suffolk	school	2502790	35	Boston	250279000208	350505	Brighton High	Regular School	No	3	09	12	2015	SP	1	5	8	0	0	0	0	14	1	5	8	0	0	0	0	14
736807	MA	Suffolk	school	2502790	35	Boston	250279000215	350515	Charlestown High	Regular School	No	3	09	12	2015	SP	10	19	8	0	4	0	0	41	10	19	8	0	4	0	0	41
736826	MA	Suffolk	school	2502790	35	Boston	250279000226	350530	East Boston High	Regular School	No	3	09	12	2015	SP	3	8	8	1	0	0	0	20	3	8	8	1	0	0	0	20
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
736873	MA	Suffolk	school	2502790	35	Boston	250279001692	350558	Boston Community Leadership Academy	Regular School	No	3	09	12	2015	SP	2	3	2	0	0	0	0	7	2	3	2	0	0	0	0	7