schools

Data source: Big Local News · About: Big Local

Custom SQL query returning 64 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	total	white_int	black_int	hispanic_int	native_american_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int	total_int
744493	MA	Worcester	school	2507680	710	Mendon-Upton	250768001202	7100510	Nipmuc Regional High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	4								4
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
744653	MA	Middlesex	school	2508790	735	North Middlesex	250879001415	7350505	North Middlesex Regional	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	5								5
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
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
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
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
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
740786	MA	Hampden	school	2509300	227	Palmer	250930001485	2270505	Palmer High	Regular School	No	3	08	12	2015	SP	*	*	*	*	*	*	*	5								5
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
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
744691	MA	Essex	school	2509450	745	Pentucket	250945001513	7450505	Pentucket Regional Sr High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	5								5
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
744654	MA	Middlesex	school	2508790	735	North Middlesex	250879002705	7350515	Peter Fitzpatrick School	Regular School	No	4	UG	UG	2015	SP	*	*	*	*	*	*	*	1								1
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
741169	MA	Norfolk	school	2509930	244	Randolph	250993001596	2440505	Randolph High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	4								4
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
741308	MA	Plymouth	school	2510170	251	Rockland	251017001643	2510505	Rockland Senior High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	3								3
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
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
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
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
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
736939	MA	Suffolk	school	2502790	35	Boston	250279000217	350690	Snowden International School at Copley	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
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
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
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
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
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
738609	MA	Essex	school	2505970	128	Haverhill	250597001706	1280073	TEACH	Regular School	No	4	02	12	2015	SP	*	*	*	*	*	*	*	5								5
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
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
736929	MA	Suffolk	school	2502790	35	Boston	250279002725	350657	TechBoston Academy	Regular School	No	4	06	12	2015	SP	*	*	*	*	*	*	*	1								1
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
736831	MA	Suffolk	school	2502790	35	Boston	250279000327	350535	The English High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	2								2
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
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
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
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
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
744177	MA	Berkshire	school	2503390	635	Central Berkshire	250339000467	6350505	Wahconah Regional High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	3								3
742361	MA	Middlesex	school	2511910	305	Wakefield	251191001951	3050505	Wakefield Memorial High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	4								4
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
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
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
742610	MA	Norfolk	school	2512270	317	Wellesley	251227002030	3170505	Wellesley Sr High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	3								3
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
736934	MA	Suffolk	school	2502790	35	Boston	250279002729	350658	West Roxbury Academy	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
742640	MA	Worcester	school	2512600	321	Westborough	251260002059	3210505	Westborough High	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	2								2
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
742784	MA	Middlesex	school	2512750	330	Weston	251275002087	3300505	Weston High	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
745026	MA	Plymouth	school	2512930	780	Whitman-Hanson	251293002135	7800505	Whitman Hanson Regional	Regular School	No	3	09	12	2015	SP	*	*	*	*	*	*	*	3								3
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
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