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, district_state_type, ccd_district_type, ccd_charter, ccd_district_lvl, ccd_district_low_grade, ccd_district_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 districts order by native_american_int limit 101

This data as json, CSV

rowid	state	county	admin_level	district_nces_id	district_state_id	district	ccd_district_type	ccd_charter	ccd_district_lvl	ccd_district_low_grade	ccd_district_high_grade	year	grade	white	black	hispanic	native_american	asian	native_hawaiian_pacific_islander	multiracial	male	female	total	male_int	female_int	total_int
23667	MA	Plymouth	district	2501650	1	Abington	1			PK	12	2015	SP	*	*	*	*	*	*	*			5			5
23706	MA	Essex	district	2501860	7	Amesbury	1			PK	12	2015	SP	*	*	*	*	*	*	*			3			3
23801	MA	Norfolk	district	2502250	18	Avon	1			PK	12	2015	SP	*	*	*	*	*	*	*			3			3
24060	MA	Middlesex	district	2503270	49	Cambridge	1			PK	12	2015	SP	*	*	*	*	*	*	*			4			4
24128	MA	Suffolk	district	2503540	57	Chelsea	1			PK	12	2015	SP	*	*	*	*	*	*	*			4			4
24167	MA	Worcester	district	2503750	64	Clinton	1			PK	12	2015	SP	*	*	*	*	*	*	*			2			2
24214	MA	Essex	district	2503990	71	Danvers	1			PK	12	2015	SP	*	*	*	*	*	*	*			5			5
24229	MA	Bristol	district	2504020	72	Dartmouth	1			PK	12	2015	SP	*	*	*	*	*	*	*			1			1
24286	MA	Middlesex	district	2504320	79	Dracut	1			PK	12	2015	SP	*	*	*	*	*	*	*			3			3
24336	MA	Hampshire	district	2504590	86	Easthampton	1			PK	12	2015	SP	*	*	*	*	*	*	*			2			2
24351	MA	Hampden	district	2504500	87	East Longmeadow	1			PK	12	2015	SP	*	*	*	*	*	*	*			1			1
24377	MA	Dukes	district	2509090	89	Edgartown	1			PK	8	2015	pre_kindergarten	*	*	*	*	*	*	*	2	2	4	2	2	4
24441	MA	Barnstable	district	2504860	96	Falmouth	1			PK	12	2015	SP	*	*	*	*	*	*	*			4			4
24462	MA	Berkshire	district	2504920	98	Florida	1			PK	8	2015	grade_4	*	*	*	*	*	*	*	2	2	4	2	2	4
24509	MA	Norfolk	district	2505010	101	Franklin	1			PK	12	2015	SP	*	*	*	*	*	*	*			1			1
24555	MA	Dukes	district	2505340	109	Gosnold	1			04	5	2015	grade_4	*	*	*	*	*	*	*	*	*	1			1
24556	MA	Dukes	district	2505340	109	Gosnold	1			04	5	2015	grade_5	*	*	*	*	*	*	*	*	*	1			1
24613	MA	Hampshire	district	2505580	117	Hadley	1			PK	12	2015	SP	*	*	*	*	*	*	*			1			1
24623	MA	Berkshire	district	2505760	121	Hancock	1			PK	6	2015	grade_1	*	*	*	*	*	*	*	1	4	5	1	4	5
24625	MA	Berkshire	district	2505760	121	Hancock	1			PK	6	2015	grade_3	*	*	*	*	*	*	*	2	2	4	2	2	4
24626	MA	Berkshire	district	2505760	121	Hancock	1			PK	6	2015	grade_5	*	*	*	*	*	*	*	2	2	4	2	2	4
24628	MA	Berkshire	district	2505760	121	Hancock	1			PK	6	2015	kindergarten	*	*	*	*	*	*	*	2	3	5	2	3	5
24642	MA	Plymouth	district	2505790	122	Hanover	1			PK	12	2015	SP	*	*	*	*	*	*	*			3			3
24700	MA	Plymouth	district	2506090	131	Hingham	1			PK	12	2015	SP	*	*	*	*	*	*	*			5			5
24715	MA	Norfolk	district	2506150	133	Holbrook	1			PK	12	2015	SP	*	*	*	*	*	*	*			4			4
24738	MA	Middlesex	district	2506240	136	Holliston	1			PK	12	2015	SP	*	*	*	*	*	*	*			1			1
24781	MA	Middlesex	district	2506330	139	Hopkinton	1			PK	12	2015	SP	*	*	*	*	*	*	*			2			2
24824	MA	Essex	district	2506480	144	Ipswich	1			PK	12	2015	SP	*	*	*	*	*	*	*			2			2
24897	MA	Berkshire	district	2506750	152	Lenox	1			PK	12	2015	SP	*	*	*	*	*	*	*			1			1
25001	MA	Hampden	district	2507050	161	Ludlow	1			PK	12	2015	SP	*	*	*	*	*	*	*			5			5
25016	MA	Worcester	district	2507080	162	Lunenburg	1			PK	12	2015	SP	*	*	*	*	*	*	*			2			2
25089	MA	Essex	district	2507260	168	Marblehead	1			PK	12	2015	SP	*	*	*	*	*	*	*			2			2
25249	MA	Plymouth	district	2507770	182	Middleborough	1			PK	12	2015	SP	*	*	*	*	*	*	*			5			5
25272	MA	Worcester	district	2507860	185	Milford	1			PK	12	2015	SP	*	*	*	*	*	*	*			5			5
25287	MA	Worcester	district	2507890	186	Millbury	1			PK	12	2015	SP	*	*	*	*	*	*	*			4			4
25331	MA	Hampden	district	2508040	191	Monson	1			PK	12	2015	SP	*	*	*	*	*	*	*			3			3
25354	MA	Nantucket	district	2508250	197	Nantucket	1			PK	12	2015	SP	*	*	*	*	*	*	*			1			1
25383	MA	Norfolk	district	2508370	199	Needham	1			PK	12	2015	SP	*	*	*	*	*	*	*			2			2
25398	MA	Bristol	district	2508430	201	New Bedford	1			PK	12	2015	SP	*	*	*	*	*	*	*			1			1
25413	MA	Essex	district	2508580	204	Newburyport	1			PK	12	2015	SP	*	*	*	*	*	*	*			2			2
25465	MA	Hampshire	district	2508850	210	Northampton	1			PK	12	2015	SP	*	*	*	*	*	*	*			3			3
25519	MA	Worcester	district	2508940	214	Northbridge	1			PK	12	2015	SP	*	*	*	*	*	*	*			4			4
25644	MA	Hampden	district	2509300	227	Palmer	1			PK	12	2015	SP	*	*	*	*	*	*	*			5			5
25659	MA	Essex	district	2509360	229	Peabody	1			PK	12	2015	SP	*	*	*	*	*	*	*			1			1
25735	MA	Barnstable	district	2509840	242	Provincetown	1			PK	8	2015	grade_2	*	*	*	*	*	*	*	3	2	5	3	2	5
25771	MA	Norfolk	district	2509930	244	Randolph	1			PK	12	2015	SP	*	*	*	*	*	*	*			4			4
25833	MA	Plymouth	district	2510170	251	Rockland	1			PK	12	2015	SP	*	*	*	*	*	*	*			3			3
25850	MA	Franklin	district	2510230	253	Rowe	1			PK	6	2015	grade_1	*	*	*	*	*	*	*	2	3	5	2	3	5
25851	MA	Franklin	district	2510230	253	Rowe	1			PK	6	2015	grade_2	*	*	*	*	*	*	*	1	2	3	1	2	3
25855	MA	Franklin	district	2510230	253	Rowe	1			PK	6	2015	kindergarten	*	*	*	*	*	*	*	4	1	5	4	1	5
25902	MA	Berkshire	district	2510530	263	Savoy	1			PK	5	2015	grade_2	*	*	*	*	*	*	*	3	1	4	3	1	4
25903	MA	Berkshire	district	2510530	263	Savoy	1			PK	5	2015	grade_3	*	*	*	*	*	*	*	1	3	4	1	3	4
25904	MA	Berkshire	district	2510530	263	Savoy	1			PK	5	2015	grade_4	*	*	*	*	*	*	*	1	2	3	1	2	3
25920	MA	Plymouth	district	2510560	264	Scituate	1			PK	12	2015	SP	*	*	*	*	*	*	*			1			1
25970	MA	Worcester	district	2510770	271	Shrewsbury	1			PK	12	2015	SP	*	*	*	*	*	*	*			1			1
26003	MA	Middlesex	district	2510890	274	Somerville	1			PK	12	2015	SP	*	*	*	*	*	*	*			4			4
26080	MA	Middlesex	district	2511220	284	Stoneham	1			PK	12	2015	SP	*	*	*	*	*	*	*			1			1
26095	MA	Norfolk	district	2511250	285	Stoughton	1			PK	12	2015	SP	*	*	*	*	*	*	*			3			3
26150	MA	Essex	district	2511430	291	Swampscott	1			PK	12	2015	SP	*	*	*	*	*	*	*			1			1
26206	MA	Dukes	district	2512570	296	Tisbury	1			PK	8	2015	pre_kindergarten	*	*	*	*	*	*	*	4	1	5	4	1	5
26263	MA	Middlesex	district	2511910	305	Wakefield	1			PK	12	2015	SP	*	*	*	*	*	*	*			4			4
26301	MA	Middlesex	district	2512000	308	Waltham	1			PK	12	2015	SP	*	*	*	*	*	*	*			2			2
26316	MA	Hampshire	district	2512030	309	Ware	1			PK	12	2015	SP	*	*	*	*	*	*	*			4			4
26373	MA	Worcester	district	2512240	316	Webster	1			PK	12	2015	SP	*	*	*	*	*	*	*			5			5
26388	MA	Norfolk	district	2512270	317	Wellesley	1			PK	12	2015	SP	*	*	*	*	*	*	*			3			3
26410	MA	Worcester	district	2512600	321	Westborough	1			PK	12	2015	SP	*	*	*	*	*	*	*			2			2
26425	MA	Worcester	district	2512390	322	West Boylston	1			PK	12	2015	SP	*	*	*	*	*	*	*			2			2
26491	MA	Middlesex	district	2512750	330	Weston	1			PK	12	2015	SP	*	*	*	*	*	*	*			3			3
26588	MA	Middlesex	district	2513050	342	Wilmington	1			PK	12	2015	SP	*	*	*	*	*	*	*			4			4
26631	MA	Suffolk	district	2513170	346	Winthrop	1			PK	12	2015	SP	*	*	*	*	*	*	*			1			1
27224	MA	Hampshire	district	2501920	605	Amherst-Pelham	4			07	12	2015	SP	*	*	*	*	*	*	*			4			4
27303	MA	Worcester	district	2502715	622	Blackstone-Millville	4			PK	12	2015	SP	*	*	*	*	*	*	*			4			4
27341	MA	Berkshire	district	2503390	635	Central Berkshire	4			PK	12	2015	SP	*	*	*	*	*	*	*			3			3
27404	MA	Barnstable	district	2504560	660	Nauset	4			06	12	2015	SP	*	*	*	*	*	*	*			3			3
27433	MA	Franklin	district	2505100	670	Frontier	4			07	12	2015	SP	*	*	*	*	*	*	*			4			4
27446	MA	Hampshire	district	2505160	672	Gateway	4			PK	12	2015	SP	*	*	*	*	*	*	*			1			1
27461	MA	Middlesex	district	2505500	673	Groton-Dunstable	4			PK	12	2015	SP	*	*	*	*	*	*	*			5			5
27513	MA	Hampshire	district	2505740	683	Hampshire	4			07	12	2015	SP	*	*	*	*	*	*	*			3			3
27533	MA	Middlesex	district	2506930	695	Lincoln-Sudbury	4			09	12	2015	SP	*	*	*	*	*	*	*			2			2
27559	MA	Essex	district	2507410	705	Masconomet	4			07	12	2015	SP	*	*	*	*	*	*	*			1			1
27572	MA	Worcester	district	2507680	710	Mendon-Upton	4			PK	12	2015	SP	*	*	*	*	*	*	*			4			4
27596	MA	Berkshire	district	2508160	715	Mount Greylock	4			07	12	2015	SP	*	*	*	*	*	*	*			2			2
27686	MA	Essex	district	2509450	745	Pentucket	4			PK	12	2015	SP	*	*	*	*	*	*	*			5			5
27760	MA	Hampden	district	2500013	766	Southwick-Tolland-Granville Regional School District	4			PK	12	2015	SP	*	*	*	*	*	*	*			3			3
27775	MA	Worcester	district	2500002	767	Spencer-E Brookfield	4			PK	12	2015	SP	*	*	*	*	*	*	*			4			4
27851	MA	Plymouth	district	2512930	780	Whitman-Hanson	4			PK	12	2015	SP	*	*	*	*	*	*	*			3			3
27874	MA	Barnstable	district	2503310	815	Cape Cod Regional Vocational Technical	4			09	12	2015	SP	*	*	*	*	*	*	*			4			4
27932	MA	Hampden	district	2509310	860	Pathfinder Regional Vocational Technical	4			09	12	2015	SP	*	*	*	*	*	*	*			2			2
27941	MA	Bristol	district	2511020	872	Southeastern Regional Vocational Technical	4			09	12	2015	SP	*	*	*	*	*	*	*			1			1
58993	MA	Plymouth	district	2501650	1	Abington	1	NOTCHR	Other	PK	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			4.0			4
59004	MA	Bristol	district	2501740	3	Acushnet	1	NOTCHR	Elementary	PK	8	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			0.0			0
59034	MA	Essex	district	2501860	7	Amesbury	1	NOTCHR	Other	PK	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			1.0			1
59043	MA	Hampshire	district	2501890	8	Amherst	1	NOTCHR	Elementary	PK	6	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			0.0			0
59073	MA	Middlesex	district	2501980	10	Arlington	1	NOTCHR	Other	PK	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			1.0			1
59088	MA	Middlesex	district	2502100	14	Ashland	1	NOTCHR	Other	PK	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			0.0			0
59118	MA	Worcester	district	2502220	17	Auburn	1	NOTCHR	Other	PK	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			4.0			4
59133	MA	Norfolk	district	2502250	18	Avon	1	NOTCHR	Other	PK	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			4.0			4
59163	MA	Middlesex	district	2502400	23	Bedford	1	NOTCHR	Other	PK	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			0.0			0
59178	MA	Hampshire	district	2502430	24	Belchertown	1	NOTCHR	Other	PK	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			4.0			4
59193	MA	Norfolk	district	2502460	25	Bellingham	1	NOTCHR	Other	PK	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			0.0			0
59208	MA	Middlesex	district	2502490	26	Belmont	1	NOTCHR	Other	PK	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			0.0			0