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 order by total 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
1121948	MA	Plymouth	school	2501650	1	Abington	250165002727	10002	Center Elementary School	Regular School	No	Elementary	PK	KG	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1121953	MA	Plymouth	school	2501650	1	Abington	250165000434	10003	Beaver Brook Elementary School	Regular School	No	Elementary	01	04	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1121956	MA	Plymouth	school	2501650	1	Abington	250165000006	10015	Woodsdale Elementary School	Regular School	No	Middle	05	06	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1121959	MA	Plymouth	school	2501650	1	Abington	250165000002	10405	Frolio Middle School	Regular School	No	Middle	07	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1121964	MA	Plymouth	school	2501650	1	Abington	250165000001	10505	Abington High	Regular School	No	High	09	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1121971	MA	Bristol	school	2501740	3	Acushnet	250174000014	30025	Acushnet Elementary School	Regular School	No	Elementary	PK	04	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1121976	MA	Bristol	school	2501740	3	Acushnet	250174000015	30305	Albert F Ford Middle School	Regular School	No	Middle	05	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1121978	MA	Hampden	school	2501800	5	Agawam	250180001499	50003	Agawam Early Childhood Center	Regular School	No	Elementary	PK	PK	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1121984	MA	Hampden	school	2501800	5	Agawam	250180000028	50010	Clifford M Granger	Regular School	No	Elementary	KG	04	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1121990	MA	Hampden	school	2501800	5	Agawam	250180000027	50020	Benjamin J Phelps	Regular School	No	Elementary	KG	04	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1121996	MA	Hampden	school	2501800	5	Agawam	250180000032	50025	Robinson Park	Regular School	No	Elementary	KG	04	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122002	MA	Hampden	school	2501800	5	Agawam	250180000030	50030	James Clark School	Regular School	No	Elementary	KG	04	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122005	MA	Hampden	school	2501800	5	Agawam	250180000026	50303	Roberta G. Doering School	Regular School	No	Middle	05	08	2017	grade_7	*	*	*	*	*	*	*	2	1	*	2	1
1122006	MA	Hampden	school	2501800	5	Agawam	250180000026	50303	Roberta G. Doering School	Regular School	No	Middle	05	08	2017	grade_8	*	*	*	*	*	*	*	1	1	*	1	1
1122007	MA	Hampden	school	2501800	5	Agawam	250180000026	50303	Roberta G. Doering School	Regular School	No	Middle	05	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122010	MA	Hampden	school	2501800	5	Agawam	250180000025	50405	Agawam Junior High	Regular School	No	Middle	07	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122022	MA	Essex	school	2501860	7	Amesbury	250186000033	70005	Amesbury Elementary	Regular School	No	Elementary	PK	04	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122029	MA	Essex	school	2501860	7	Amesbury	250186000036	70010	Charles C Cashman Elementary	Regular School	No	Elementary	PK	04	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122034	MA	Essex	school	2501860	7	Amesbury	250186000035	70013	Amesbury Middle	Regular School	No	Middle	05	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122039	MA	Essex	school	2501860	7	Amesbury	250186000034	70505	Amesbury High	Regular School	No	High	09	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122041	MA	Essex	school	2501860	7	Amesbury	250186002841	70515	Amesbury Innovation High School	Regular School	No	High	09	12	2017	grade_10	*	*	*	*	*	*	*	1	1	*	1	1
1122044	MA	Essex	school	2501860	7	Amesbury	250186002841	70515	Amesbury Innovation High School	Regular School	No	High	09	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122053	MA	Hampshire	school	2501890	8	Amherst	250189000038	80009	Crocker Farm Elementary	Regular School	No	Elementary	PK	06	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122061	MA	Hampshire	school	2501890	8	Amherst	250189000039	80020	Fort River Elementary	Regular School	No	Elementary	KG	06	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122069	MA	Hampshire	school	2501890	8	Amherst	250189000041	80050	Wildwood Elementary	Regular School	No	Elementary	KG	06	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122076	MA	Essex	school	2501950	9	Andover	250195000047	90003	Bancroft Elementary	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122083	MA	Essex	school	2501950	9	Andover	250195001676	90004	High Plain Elementary	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122085	MA	Essex	school	2501950	9	Andover	250195002366	90005	Shawsheen School	Regular School	No	Elementary	PK	PK	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122092	MA	Essex	school	2501950	9	Andover	250195000048	90010	Henry C Sanborn Elementary	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122099	MA	Essex	school	2501950	9	Andover	250195000050	90020	South Elementary	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122106	MA	Essex	school	2501950	9	Andover	250195000051	90025	West Elementary	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122110	MA	Essex	school	2501950	9	Andover	250195002510	90305	Doherty Middle	Regular School	No	Middle	06	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122114	MA	Essex	school	2501950	9	Andover	250195002511	90310	Andover West Middle	Regular School	No	Middle	06	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122118	MA	Essex	school	2501950	9	Andover	250195001678	90350	Wood Hill Middle School	Regular School	No	Middle	06	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122130	MA	Middlesex	school	2501980	10	Arlington	250198000059	100005	John A Bishop	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122137	MA	Middlesex	school	2501980	10	Arlington	250198000054	100010	Brackett	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122144	MA	Middlesex	school	2501980	10	Arlington	250198000057	100025	Cyrus E Dallin	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122151	MA	Middlesex	school	2501980	10	Arlington	250198000058	100030	Hardy	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122153	MA	Middlesex	school	2501980	10	Arlington	250198001681	100038	Menotomy Preschool	Regular School	No	Elementary	PK	PK	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122160	MA	Middlesex	school	2501980	10	Arlington	250198000065	100045	Peirce	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122167	MA	Middlesex	school	2501980	10	Arlington	250198000066	100050	Thompson	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122174	MA	Middlesex	school	2501980	10	Arlington	250198000062	100055	M Norcross Stratton	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122178	MA	Middlesex	school	2501980	10	Arlington	250198000063	100410	Ottoson Middle	Regular School	No	Middle	06	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122183	MA	Middlesex	school	2501980	10	Arlington	250198000053	100505	Arlington High	Regular School	No	High	09	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122185	MA	Middlesex	school	2502100	14	Ashland	250210002455	140005	William Pittaway Elementary	Regular School	No	Elementary	PK	PK	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122189	MA	Middlesex	school	2502100	14	Ashland	250210000072	140010	Henry E Warren Elementary	Regular School	No	Elementary	KG	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122193	MA	Middlesex	school	2502100	14	Ashland	250210000071	140015	David Mindess	Regular School	No	Elementary	03	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122197	MA	Middlesex	school	2502100	14	Ashland	250210000938	140405	Ashland Middle	Regular School	No	Middle	06	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122202	MA	Middlesex	school	2502100	14	Ashland	250210000070	140505	Ashland High	Regular School	No	High	09	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122208	MA	Bristol	school	2502190	16	Attleboro	250219000097	160001	A. Irvin Studley Elementary School	Regular School	No	Elementary	KG	04	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122210	MA	Bristol	school	2502190	16	Attleboro	250219001610	160008	Early Learning Center	Regular School	No	Elementary	PK	PK	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122216	MA	Bristol	school	2502190	16	Attleboro	250219000098	160035	Thomas Willett Elementary School	Regular School	No	Elementary	KG	04	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122222	MA	Bristol	school	2502190	16	Attleboro	250219000090	160040	Hyman Fine Elementary School	Regular School	No	Elementary	KG	04	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122228	MA	Bristol	school	2502190	16	Attleboro	250219000089	160045	Hill-Roberts Elementary School	Regular School	No	Elementary	KG	04	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122234	MA	Bristol	school	2502190	16	Attleboro	250219001294	160050	Peter Thacher Elementary School	Regular School	No	Elementary	KG	04	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122239	MA	Bristol	school	2502190	16	Attleboro	250219000096	160305	Robert J. Coelho Middle School	Regular School	No	Middle	05	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122244	MA	Bristol	school	2502190	16	Attleboro	250219000087	160315	Cyril K. Brennan Middle School	Regular School	No	Middle	05	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122249	MA	Bristol	school	2502190	16	Attleboro	250219000945	160320	Wamsutta Middle School	Regular School	No	Middle	05	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122258	MA	Bristol	school	2502190	16	Attleboro	250219002831	160515	Attleboro Community Academy	Alternative School	No	High	09	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122262	MA	Worcester	school	2502220	17	Auburn	250222000101	170010	Bryn Mawr	Regular School	No	Elementary	KG	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122266	MA	Worcester	school	2502220	17	Auburn	250222000103	170025	Pakachoag School	Regular School	No	Elementary	KG	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122270	MA	Worcester	school	2502220	17	Auburn	250222002846	170030	Swanson Road Intermediate School	Regular School	No	Elementary	03	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122274	MA	Worcester	school	2502220	17	Auburn	250222002567	170305	Auburn Middle	Regular School	No	Middle	06	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122280	MA	Worcester	school	2502220	17	Auburn	250222000100	170505	Auburn Senior High	Regular School	No	High	09	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122289	MA	Norfolk	school	2502250	18	Avon	250225000108	180010	Ralph D Butler	Regular School	No	Elementary	PK	06	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122296	MA	Norfolk	school	2502250	18	Avon	250225001295	180510	Avon Middle High School	Regular School	No	High	07	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122298	MA	Barnstable	school	2502310	20	Barnstable	250231002851	200001	Enoch Cobb Early Learning Center	Regular School	No	Elementary	PK	PK	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122303	MA	Barnstable	school	2502310	20	Barnstable	250231000125	200005	West Barnstable Elementary	Regular School	No	Elementary	KG	03	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122308	MA	Barnstable	school	2502310	20	Barnstable	250231000118	200010	Centerville Elementary	Regular School	No	Elementary	KG	03	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122313	MA	Barnstable	school	2502310	20	Barnstable	250231000121	200025	Hyannis West Elementary	Regular School	No	Elementary	KG	03	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122318	MA	Barnstable	school	2502310	20	Barnstable	250231002679	200045	West Villages Elementary School	Regular School	No	Elementary	KG	03	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122321	MA	Barnstable	school	2502310	20	Barnstable	250231002748	200050	Barnstable United Elementary School	Regular School	No	Elementary	04	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122324	MA	Barnstable	school	2502310	20	Barnstable	250231002678	200315	Barnstable Intermediate School	Regular School	No	Middle	06	07	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122334	MA	Middlesex	school	2502400	23	Bedford	250240000131	230010	Lt Elezer Davis	Regular School	No	Elementary	KG	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122338	MA	Middlesex	school	2502400	23	Bedford	250240000132	230012	Lt Job Lane School	Regular School	No	Elementary	03	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122342	MA	Middlesex	school	2502400	23	Bedford	250240000130	230305	John Glenn Middle	Regular School	No	Middle	06	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122348	MA	Middlesex	school	2502400	23	Bedford	250240000128	230505	Bedford High	Regular School	No	High	09	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122351	MA	Hampshire	school	2502430	24	Belchertown	250243000136	240005	Cold Spring	Regular School	No	Elementary	PK	KG	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122355	MA	Hampshire	school	2502430	24	Belchertown	250243001871	240006	Chestnut Hill Community School	Regular School	No	Elementary	04	06	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122359	MA	Hampshire	school	2502430	24	Belchertown	250243000836	240018	Swift River Elementary	Regular School	No	Elementary	01	03	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122362	MA	Hampshire	school	2502430	24	Belchertown	250243001873	240025	Jabish Middle School	Regular School	No	Middle	07	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122367	MA	Hampshire	school	2502430	24	Belchertown	250243000134	240505	Belchertown High	Regular School	No	High	09	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122369	MA	Norfolk	school	2502460	25	Bellingham	250246000670	250003	Bellingham Early Childhood Center	Regular School	No	Elementary	PK	PK	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122374	MA	Norfolk	school	2502460	25	Bellingham	250246000142	250020	South Elementary	Regular School	No	Elementary	KG	03	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122379	MA	Norfolk	school	2502460	25	Bellingham	250246000141	250025	Stall Brook	Regular School	No	Elementary	KG	03	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122384	MA	Norfolk	school	2502460	25	Bellingham	250246001683	250315	Bellingham Memorial School	Regular School	No	Elementary	04	07	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122390	MA	Norfolk	school	2502460	25	Bellingham	250246000139	250505	Bellingham High School	Regular School	No	High	08	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122394	MA	Norfolk	school	2502460	25	Bellingham	250246002543	250510	Keough Memorial Academy	Alternative School	No	High	07	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122400	MA	Middlesex	school	2502490	26	Belmont	250249000148	260005	Winn Brook	Regular School	No	Elementary	KG	04	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122406	MA	Middlesex	school	2502490	26	Belmont	250249000146	260010	Mary Lee Burbank	Regular School	No	Elementary	KG	04	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122412	MA	Middlesex	school	2502490	26	Belmont	250249000144	260015	Daniel Butler	Regular School	No	Elementary	KG	04	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122419	MA	Middlesex	school	2502490	26	Belmont	250249000147	260035	Roger E Wellington	Regular School	No	Elementary	PK	04	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122424	MA	Middlesex	school	2502490	26	Belmont	250249000149	260305	Winthrop L Chenery Middle	Regular School	No	Middle	05	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122429	MA	Middlesex	school	2502490	26	Belmont	250249000143	260505	Belmont High	Regular School	No	High	09	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122436	MA	Bristol	school	2502520	27	Berkley	250252002513	270010	Berkley Community School	Regular School	No	Elementary	PK	04	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122441	MA	Bristol	school	2502520	27	Berkley	250252001613	270305	Berkley Middle School	Regular School	No	Middle	05	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122449	MA	Worcester	school	2502550	28	Berlin	250255000159	280005	Berlin Memorial	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122451	MA	Essex	school	2502640	30	Beverly	250264002854	300002	McKeown School	Regular School	No	Elementary	PK	PK	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122458	MA	Essex	school	2502640	30	Beverly	250264000167	300010	Centerville Elementary	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122465	MA	Essex	school	2502640	30	Beverly	250264000168	300015	Cove Elementary	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122472	MA	Essex	school	2502640	30	Beverly	250264000169	300033	Hannah Elementary	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*