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 "year" = :p1 and (native_american > :p3 or (native_american = :p3 and rowid > :p2)) order by native_american, 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	white_int	black_int	hispanic_int	native_american_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int	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
735659	MA	Plymouth	school	2501650	1	Abington	250165002727	10002	Center Elementary School	Regular School	No	1	PK	KG	2015	pre_kindergarten	71	1	1	0	3	0	0	48	28	76	71	1	1	0	3	0	0	48	28	76
735662	MA	Plymouth	school	2501650	1	Abington	250165000434	10003	Beaver Brook Elementary School	Regular School	No	1	01	04	2015	grade_3	168	0	5	0	1	0	0	90	84	174	168	0	5	0	1	0	0	90	84	174
735664	MA	Plymouth	school	2501650	1	Abington	250165000006	10015	Woodsdale Elementary School	Regular School	No	2	05	06	2015	grade_5	146	1	6	0	3	0	0	84	72	156	146	1	6	0	3	0	0	84	72	156
735666	MA	Plymouth	school	2501650	1	Abington	250165000002	10405	Frolio Middle School	Regular School	No	2	07	08	2015	grade_7	146	2	4	0	2	0	2	77	79	156	146	2	4	0	2	0	2	77	79	156
735667	MA	Plymouth	school	2501650	1	Abington	250165000002	10405	Frolio Middle School	Regular School	No	2	07	08	2015	grade_8	131	6	7	0	4	1	0	74	75	149	131	6	7	0	4	1	0	74	75	149
735668	MA	Plymouth	school	2501650	1	Abington	250165000001	10505	Abington High	Regular School	No	3	09	12	2015	grade_9	113	1	15	0	0	0	2	61	70	131	113	1	15	0	0	0	2	61	70	131
735669	MA	Plymouth	school	2501650	1	Abington	250165000001	10505	Abington High	Regular School	No	3	09	12	2015	grade_10	82	3	10	0	0	0	1	46	50	96	82	3	10	0	0	0	1	46	50	96
735670	MA	Plymouth	school	2501650	1	Abington	250165000001	10505	Abington High	Regular School	No	3	09	12	2015	grade_11	105	6	2	0	2	0	2	59	58	117	105	6	2	0	2	0	2	59	58	117
735671	MA	Plymouth	school	2501650	1	Abington	250165000001	10505	Abington High	Regular School	No	3	09	12	2015	grade_12	117	1	8	0	2	0	0	57	71	128	117	1	8	0	2	0	0	57	71	128
735673	MA	Bristol	school	2501740	3	Acushnet	250174000014	30025	Acushnet Elementary School	Regular School	No	1	PK	04	2015	kindergarten	92	0	4	0	0	0	0	45	51	96	92	0	4	0	0	0	0	45	51	96
735674	MA	Bristol	school	2501740	3	Acushnet	250174000014	30025	Acushnet Elementary School	Regular School	No	1	PK	04	2015	pre_kindergarten	48	0	1	0	0	0	2	27	24	51	48	0	1	0	0	0	2	27	24	51
735675	MA	Bristol	school	2501740	3	Acushnet	250174000014	30025	Acushnet Elementary School	Regular School	No	1	PK	04	2015	grade_1	101	0	0	0	0	0	0	58	43	101	101	0	0	0	0	0	0	58	43	101
735676	MA	Bristol	school	2501740	3	Acushnet	250174000014	30025	Acushnet Elementary School	Regular School	No	1	PK	04	2015	grade_2	85	0	2	0	0	0	0	50	37	87	85	0	2	0	0	0	0	50	37	87
735677	MA	Bristol	school	2501740	3	Acushnet	250174000014	30025	Acushnet Elementary School	Regular School	No	1	PK	04	2015	grade_3	103	1	1	0	0	0	0	58	47	105	103	1	1	0	0	0	0	58	47	105
735678	MA	Bristol	school	2501740	3	Acushnet	250174000014	30025	Acushnet Elementary School	Regular School	No	1	PK	04	2015	grade_4	113	0	0	0	0	0	0	59	54	113	113	0	0	0	0	0	0	59	54	113
735679	MA	Bristol	school	2501740	3	Acushnet	250174000015	30305	Albert F Ford Middle School	Regular School	No	2	05	08	2015	grade_5	76	0	2	0	0	0	0	40	38	78	76	0	2	0	0	0	0	40	38	78
735680	MA	Bristol	school	2501740	3	Acushnet	250174000015	30305	Albert F Ford Middle School	Regular School	No	2	05	08	2015	grade_6	113	1	1	0	1	0	0	55	61	116	113	1	1	0	1	0	0	55	61	116