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 "state" = :p0 and (native_american_int is not null or (native_american_int is null and rowid > :p1)) order by native_american_int, 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	total	male_int	female_int	total_int
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
740285	MA	Bristol	school	2508430	201	New Bedford	250843002681	2010515	Whaling City Junior/Senior High School	Regular School	No	4	06	12	2015	grade_6	*	*	*	*	*	*	*	1	1	2	1	1	2
740286	MA	Bristol	school	2508430	201	New Bedford	250843002681	2010515	Whaling City Junior/Senior High School	Regular School	No	4	06	12	2015	grade_7	*	*	*	*	*	*	*	3	2	5	3	2	5
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
740759	MA	Worcester	school	2509270	226	Oxford	250927002810	2260305	Project C.O.F.F.E.E.	Special Education School	No	4	05	12	2015	grade_7	*	*	*	*	*	*	*	1	1	2	1	1	2
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
741038	MA	Barnstable	school	2509840	242	Provincetown	250984002694	2420020	Provincetown Schools	Regular School	No	1	PK	08	2015	grade_2	*	*	*	*	*	*	*	3	2	5	3	2	5
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
741323	MA	Franklin	school	2510230	253	Rowe	251023001649	2530005	Rowe Elementary	Regular School	No	1	PK	06	2015	kindergarten	*	*	*	*	*	*	*	4	1	5	4	1	5
741325	MA	Franklin	school	2510230	253	Rowe	251023001649	2530005	Rowe Elementary	Regular School	No	1	PK	06	2015	grade_1	*	*	*	*	*	*	*	2	3	5	2	3	5
741326	MA	Franklin	school	2510230	253	Rowe	251023001649	2530005	Rowe Elementary	Regular School	No	1	PK	06	2015	grade_2	*	*	*	*	*	*	*	1	2	3	1	2	3
741453	MA	Berkshire	school	2510530	263	Savoy	251053001688	2630010	Emma L Miller Elementary School	Regular School	No	1	PK	05	2015	grade_2	*	*	*	*	*	*	*	3	1	4	3	1	4
741454	MA	Berkshire	school	2510530	263	Savoy	251053001688	2630010	Emma L Miller Elementary School	Regular School	No	1	PK	05	2015	grade_3	*	*	*	*	*	*	*	1	3	4	1	3	4
741455	MA	Berkshire	school	2510530	263	Savoy	251053001688	2630010	Emma L Miller Elementary School	Regular School	No	1	PK	05	2015	grade_4	*	*	*	*	*	*	*	1	2	3	1	2	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
741627	MA	Middlesex	school	2510890	274	Somerville	251089001738	2740083	John F Kennedy	Regular School	No	1	PK	08	2015	pre_kindergarten	*	*	*	*	*	*	*	4	1	5	4	1	5
741675	MA	Middlesex	school	2510890	274	Somerville	251089002498	2740410	Next Wave Junior High	Alternative Education School	No	2	06	08	2015	grade_6	*	*	*	*	*	*	*	2	*	2	2		2
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
742014	MA	Hampden	school	2511130	281	Springfield	251113002734	2810560	Liberty Preparatory Academy	Regular School	No	3	09	12	2015	grade_9	*	*	*	*	*	*	*	3	2	5	3	2	5
742016	MA	Hampden	school	2511130	281	Springfield	251113002734	2810560	Liberty Preparatory Academy	Regular School	No	3	09	12	2015	grade_12	*	*	*	*	*	*	*	4	1	5	4	1	5
742025	MA	Hampden	school	2511130	281	Springfield	251113002809	2810580	Gateway to College at Springfield Technical Community College	Alternative Education School	No	3	09	12	2015	grade_9	*	*	*	*	*	*	*	1	3	4	1	3	4
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
742279	MA	Dukes	school	2512570	296	Tisbury	251257002054	2960005	Tisbury Elementary	Regular School	No	1	PK	08	2015	pre_kindergarten	*	*	*	*	*	*	*	4	1	5	4	1	5
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
742480	MA	Plymouth	school	2512060	310	Wareham	251206002668	3100310	West Academy	Regular School	No	3	07	12	2015	grade_8	*	*	*	*	*	*	*	4		4	4		4
742481	MA	Plymouth	school	2512060	310	Wareham	251206002668	3100310	West Academy	Regular School	No	3	07	12	2015	grade_9	*	*	*	*	*	*	*	3		3	3		3
742482	MA	Plymouth	school	2512060	310	Wareham	251206002668	3100310	West Academy	Regular School	No	3	07	12	2015	grade_10	*	*	*	*	*	*	*	5		5	5		5
742483	MA	Plymouth	school	2512060	310	Wareham	251206002668	3100310	West Academy	Regular School	No	3	07	12	2015	grade_11	*	*	*	*	*	*	*	3		3	3		3
742508	MA	Middlesex	school	2512180	314	Watertown	251218002002	3140025	James Russell Lowell	Regular School	No	1	PK	05	2015	pre_kindergarten	*	*	*	*	*	*	*	1	2	3	1	2	3
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
742836	MA	Hampden	school	2512510	332	West Springfield	251251002790	3320515	21st Century Skills Academy	Regular School	No	3	09	12	2015	grade_11	*	*	*	*	*	*	*	2	*	2	2		2
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
744152	MA	Berkshire	school	2503390	635	Central Berkshire	250339002545	6350010	Berkshire Trail Elementary	Regular School	No	1	PK	05	2015	grade_2	*	*	*	*	*	*	*	3	1	4	3	1	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
744284	MA	Bristol	school	2505070	665	Freetown-Lakeville	250507001852	6650015	George R Austin Intermediate School	Regular School	No	1	03	05	2015	grade_3	*	*	*	*	*	*	*	1	1	2	1	1	2
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
744540	MA	Franklin	school	2507990	717	Mohawk Trail	250799000934	7170015	Heath Elementary	Regular School	No	1	PK	06	2015	grade_1	*	*	*	*	*	*	*	1	1	2	1	1	2
744541	MA	Franklin	school	2507990	717	Mohawk Trail	250799000934	7170015	Heath Elementary	Regular School	No	1	PK	06	2015	grade_2	*	*	*	*	*	*	*	2	3	5	2	3	5
744543	MA	Franklin	school	2507990	717	Mohawk Trail	250799000934	7170015	Heath Elementary	Regular School	No	1	PK	06	2015	grade_5	*	*	*	*	*	*	*	1	1	2	1	1	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
744701	MA	Franklin	school	2509600	750	Pioneer Valley	250960002613	7500007	Pearl E Rhodes Elementary	Regular School	No	1	PK	06	2015	pre_kindergarten	*	*	*	*	*	*	*	4	1	5	4	1	5
744702	MA	Franklin	school	2509600	750	Pioneer Valley	250960002613	7500007	Pearl E Rhodes Elementary	Regular School	No	1	PK	06	2015	grade_1	*	*	*	*	*	*	*	1	4	5	1	4	5
744703	MA	Franklin	school	2509600	750	Pioneer Valley	250960002613	7500007	Pearl E Rhodes Elementary	Regular School	No	1	PK	06	2015	grade_3	*	*	*	*	*	*	*	2	1	3	2	1	3
744705	MA	Franklin	school	2509600	750	Pioneer Valley	250960002613	7500007	Pearl E Rhodes Elementary	Regular School	No	1	PK	06	2015	grade_5	*	*	*	*	*	*	*	4	1	5	4	1	5
744715	MA	Franklin	school	2509600	750	Pioneer Valley	250960002615	7500009	Warwick Community School	Regular School	No	1	PK	06	2015	pre_kindergarten	*	*	*	*	*	*	*	2	3	5	2	3	5
744716	MA	Franklin	school	2509600	750	Pioneer Valley	250960002615	7500009	Warwick Community School	Regular School	No	1	PK	06	2015	grade_1	*	*	*	*	*	*	*	2	1	3	2	1	3
744793	MA	Berkshire	school	2511040	765	Southern Berkshire	251104001778	7650030	South Egremont	Regular School	No	1	KG	01	2015	grade_1	*	*	*	*	*	*	*	*	2	5		2	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
932550	MA	Plymouth	school	2501650	1	Abington	250165000001	10505	Abington High	Regular School	No	3	09	12	2016	sped_beyond_grade_12	*	*	*	*	*	*	*	2	3	5	2	3	5
932584	MA	Hampden	school	2501800	5	Agawam	250180000026	50303	Roberta G. Doering School	Regular School	No	2	04	08	2016	grade_7	*	*	*	*	*	*	*	2	1	3	2	1	3
932585	MA	Hampden	school	2501800	5	Agawam	250180000026	50303	Roberta G. Doering School	Regular School	No	2	04	08	2016	grade_8	*	*	*	*	*	*	*	2	1	3	2	1	3
932789	MA	Bristol	school	2502190	16	Attleboro	250219002831	160515	Attleboro Community Academy	Alternative Education School	No	3	09	12	2016	grade_10	*	*	*	*	*	*	*	1	4	5	1	4	5
932809	MA	Worcester	school	2502220	17	Auburn	250222000100	170505	Auburn Senior High	Regular School	No	3	09	12	2016	sped_beyond_grade_12	*	*	*	*	*	*	*	1	2	3	1	2	3
932824	MA	Norfolk	school	2502250	18	Avon	250225001295	180510	Avon Middle High School	Regular School	No	3	07	12	2016	sped_beyond_grade_12	*	*	*	*	*	*	*	1	1	2	1	1	2
932880	MA	Hampshire	school	2502430	24	Belchertown	250243000134	240505	Belchertown High	Regular School	No	3	09	12	2016	sped_beyond_grade_12	*	*	*	*	*	*	*	1	1	2	1	1	2
932899	MA	Norfolk	school	2502460	25	Bellingham	250246002543	250510	Paul J. Primavera Jr./Sr. High School	Alternative Education School	No	3	07	12	2016	grade_8	*	*	*	*	*	*	*	1	2	3	1	2	3
933108	MA	Suffolk	school	2502790	35	Boston	250279000210	350036	Carter Developmental Center	Regular School	No	4	06	12	2016	grade_10	*	*	*	*	*	*	*	1	2	3	1	2	3
933109	MA	Suffolk	school	2502790	35	Boston	250279000210	350036	Carter Developmental Center	Regular School	No	4	06	12	2016	grade_11	*	*	*	*	*	*	*	2	1	3	2	1	3
933139	MA	Suffolk	school	2502790	35	Boston	250279002835	350066	Dante Alighieri Montessori School	Regular School	No	1	PK	05	2016	grade_5	*	*	*	*	*	*	*	2	2	4	2	2	4
933595	MA	Suffolk	school	2502790	35	Boston	250279002677	350377	Higginson/Lewis K-8	Regular School	No	1	PK	08	2016	pre_kindergarten	*	*	*	*	*	*	*	1	1	2	1	1	2
933683	MA	Suffolk	school	2502790	35	Boston	250279002016	350522	Excel High School	Regular School	No	3	09	12	2016	sped_beyond_grade_12	*	*	*	*	*	*	*	3	1	4	3	1	4
933714	MA	Suffolk	school	2502790	35	Boston	250279000837	350543	Greater Egleston Community High School	Regular School	No	3	09	12	2016	grade_9	*	*	*	*	*	*	*	2	1	3	2	1	3
933796	MA	Suffolk	school	2502790	35	Boston	250279002729	350658	West Roxbury Academy	Regular School	No	3	09	12	2016	sped_beyond_grade_12	*	*	*	*	*	*	*	1	2	3	1	2	3
933811	MA	Suffolk	school	2502790	35	Boston	250279002374	350750	Horace Mann School for the Deaf	Special Education School	No	4	PK	12	2016	kindergarten	*	*	*	*	*	*	*	1	3	4	1	3	4
933817	MA	Suffolk	school	2502790	35	Boston	250279002374	350750	Horace Mann School for the Deaf	Special Education School	No	4	PK	12	2016	grade_7	*	*	*	*	*	*	*	1	2	3	1	2	3