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 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
2228755	MA	Plymouth	school	2501650	1	Abington	250165002727	10001	Abington: Abington Early Education Program	Regular School	No	Prekindergarten	PK	PK	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228758	MA	Plymouth	school	2501650	1	Abington	250165000006	10015	Abington: Woodsdale Elementary School	Regular School	No	Elementary	03	04	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228762	MA	Plymouth	school	2501650	1	Abington	250165000434	10020	Abington: Beaver Brook Elementary	Regular School	No	Elementary	KG	02	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228767	MA	Plymouth	school	2501650	1	Abington	250165000002	10405	Abington: Abington Middle School	Regular School	No	Middle	05	08	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228779	MA	Bristol	school	2501740	3	Acushnet	250174000014	30025	Acushnet: Acushnet Elementary School	Regular School	No	Elementary	PK	04	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228784	MA	Bristol	school	2501740	3	Acushnet	250174000015	30305	Acushnet: Albert F Ford Middle School	Regular School	No	Middle	05	08	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228786	MA	Hampden	school	2501800	5	Agawam	250180001499	50003	Agawam: Agawam Early Childhood Center	Regular School	No	Prekindergarten	PK	PK	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228792	MA	Hampden	school	2501800	5	Agawam	250180000028	50010	Agawam: Clifford M Granger	Regular School	No	Elementary	KG	04	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228798	MA	Hampden	school	2501800	5	Agawam	250180000027	50020	Agawam: Benjamin J Phelps	Regular School	No	Elementary	KG	04	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228804	MA	Hampden	school	2501800	5	Agawam	250180000032	50025	Agawam: Robinson Park	Regular School	No	Elementary	KG	04	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228810	MA	Hampden	school	2501800	5	Agawam	250180000030	50030	Agawam: James Clark School	Regular School	No	Elementary	KG	04	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228813	MA	Hampden	school	2501800	5	Agawam	250180000026	50303	Agawam: Roberta G. Doering School	Regular School	No	Middle	05	08	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228816	MA	Hampden	school	2501800	5	Agawam	250180000025	50405	Agawam: Agawam Junior High	Regular School	No	Middle	07	08	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228828	MA	Essex	school	2501860	7	Amesbury	250186000033	70005	Amesbury: Amesbury Elementary	Regular School	No	Elementary	PK	04	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228835	MA	Essex	school	2501860	7	Amesbury	250186000036	70010	Amesbury: Charles C Cashman Elementary	Regular School	No	Elementary	PK	04	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228840	MA	Essex	school	2501860	7	Amesbury	250186000035	70013	Amesbury: Amesbury Middle	Regular School	No	Middle	05	08	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228850	MA	Essex	school	2501860	7	Amesbury	250186002841	70515	Amesbury: Amesbury Innovation High School	Regular School	No	High	09	12	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228859	MA	Hampshire	school	2501890	8	Amherst	250189000038	80009	Amherst: Crocker Farm Elementary	Regular School	No	Elementary	PK	06	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228867	MA	Hampshire	school	2501890	8	Amherst	250189000039	80020	Amherst: Fort River Elementary	Regular School	No	Elementary	KG	06	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228875	MA	Hampshire	school	2501890	8	Amherst	250189000041	80050	Amherst: Wildwood Elementary	Regular School	No	Elementary	KG	06	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228882	MA	Essex	school	2501950	9	Andover	250195000047	90003	Andover: Bancroft Elementary	Regular School	No	Elementary	KG	05	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228889	MA	Essex	school	2501950	9	Andover	250195001676	90004	Andover: High Plain Elementary	Regular School	No	Elementary	KG	05	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228891	MA	Essex	school	2501950	9	Andover	250195002366	90005	Andover: Shawsheen School	Regular School	No	Prekindergarten	PK	PK	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228898	MA	Essex	school	2501950	9	Andover	250195000048	90010	Andover: Henry C Sanborn Elementary	Regular School	No	Elementary	KG	05	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228905	MA	Essex	school	2501950	9	Andover	250195000050	90020	Andover: South Elementary	Regular School	No	Elementary	KG	05	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228912	MA	Essex	school	2501950	9	Andover	250195000051	90025	Andover: West Elementary	Regular School	No	Elementary	KG	05	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228916	MA	Essex	school	2501950	9	Andover	250195002510	90305	Andover: Doherty Middle	Regular School	No	Middle	06	08	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228920	MA	Essex	school	2501950	9	Andover	250195002511	90310	Andover: Andover West Middle	Regular School	No	Middle	06	08	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228924	MA	Essex	school	2501950	9	Andover	250195001678	90350	Andover: Wood Hill Middle School	Regular School	No	Middle	06	08	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228936	MA	Middlesex	school	2501980	10	Arlington	250198000059	100005	Arlington: John A Bishop	Regular School	No	Elementary	KG	05	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228943	MA	Middlesex	school	2501980	10	Arlington	250198000054	100010	Arlington: Brackett	Regular School	No	Elementary	KG	05	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228950	MA	Middlesex	school	2501980	10	Arlington	250198000057	100025	Arlington: Cyrus E Dallin	Regular School	No	Elementary	KG	05	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228957	MA	Middlesex	school	2501980	10	Arlington	250198000058	100030	Arlington: Hardy	Regular School	No	Elementary	KG	05	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228959	MA	Middlesex	school	2501980	10	Arlington	250198001681	100038	Arlington: Menotomy Preschool	Regular School	No	Prekindergarten	PK	PK	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228966	MA	Middlesex	school	2501980	10	Arlington	250198000065	100045	Arlington: Peirce	Regular School	No	Elementary	KG	05	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228973	MA	Middlesex	school	2501980	10	Arlington	250198000066	100050	Arlington: Thompson	Regular School	No	Elementary	KG	05	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228980	MA	Middlesex	school	2501980	10	Arlington	250198000062	100055	Arlington: M Norcross Stratton	Regular School	No	Elementary	KG	05	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228984	MA	Middlesex	school	2501980	10	Arlington	250198000063	100410	Arlington: Ottoson Middle	Regular School	No	Middle	06	08	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228989	MA	Middlesex	school	2501980	10	Arlington	250198000053	100505	Arlington: Arlington High	Regular School	No	High	09	12	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228991	MA	Middlesex	school	2502100	14	Ashland	250210002455	140005	Ashland: William Pittaway Elementary	Regular School	No	Prekindergarten	PK	PK	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228995	MA	Middlesex	school	2502100	14	Ashland	250210000072	140010	Ashland: Henry E Warren Elementary	Regular School	No	Elementary	KG	02	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2228999	MA	Middlesex	school	2502100	14	Ashland	250210000071	140015	Ashland: David Mindess	Regular School	No	Elementary	03	05	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229003	MA	Middlesex	school	2502100	14	Ashland	250210000938	140405	Ashland: Ashland Middle	Regular School	No	Middle	06	08	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229008	MA	Middlesex	school	2502100	14	Ashland	250210000070	140505	Ashland: Ashland High	Regular School	No	High	09	12	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229014	MA	Bristol	school	2502190	16	Attleboro	250219000097	160001	Attleboro: A. Irvin Studley Elementary School	Regular School	No	Elementary	KG	04	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229016	MA	Bristol	school	2502190	16	Attleboro	250219001610	160008	Attleboro: Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229022	MA	Bristol	school	2502190	16	Attleboro	250219000098	160035	Attleboro: Thomas Willett Elementary School	Regular School	No	Elementary	KG	04	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229028	MA	Bristol	school	2502190	16	Attleboro	250219000090	160040	Attleboro: Hyman Fine Elementary School	Regular School	No	Elementary	KG	04	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229034	MA	Bristol	school	2502190	16	Attleboro	250219000089	160045	Attleboro: Hill-Roberts Elementary School	Regular School	No	Elementary	KG	04	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229040	MA	Bristol	school	2502190	16	Attleboro	250219001294	160050	Attleboro: Peter Thacher Elementary School	Regular School	No	Elementary	KG	04	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229045	MA	Bristol	school	2502190	16	Attleboro	250219000096	160305	Attleboro: Robert J. Coelho Middle School	Regular School	No	Middle	05	08	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229050	MA	Bristol	school	2502190	16	Attleboro	250219000087	160315	Attleboro: Cyril K. Brennan Middle School	Regular School	No	Middle	05	08	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229055	MA	Bristol	school	2502190	16	Attleboro	250219000945	160320	Attleboro: Wamsutta Middle School	Regular School	No	Middle	05	08	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229063	MA	Bristol	school	2502190	16	Attleboro	250219002831	160515	Attleboro: Attleboro Community Academy	Alternative School	No	High	09	12	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229067	MA	Worcester	school	2502220	17	Auburn	250222000101	170010	Auburn: Bryn Mawr	Regular School	No	Elementary	KG	02	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229072	MA	Worcester	school	2502220	17	Auburn	250222000103	170025	Auburn: Pakachoag School	Regular School	No	Elementary	PK	02	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229076	MA	Worcester	school	2502220	17	Auburn	250222002846	170030	Auburn: Swanson Road Intermediate School	Regular School	No	Elementary	03	05	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229080	MA	Worcester	school	2502220	17	Auburn	250222002567	170305	Auburn: Auburn Middle	Regular School	No	Middle	06	08	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229095	MA	Norfolk	school	2502250	18	Avon	250225000108	180010	Avon: Ralph D Butler	Regular School	No	Elementary	PK	06	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229104	MA	Barnstable	school	2502310	20	Barnstable	250231002851	200001	Barnstable: Enoch Cobb Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229109	MA	Barnstable	school	2502310	20	Barnstable	250231000125	200005	Barnstable: West Barnstable Elementary	Regular School	No	Elementary	KG	03	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229114	MA	Barnstable	school	2502310	20	Barnstable	250231000118	200010	Barnstable: Centerville Elementary	Regular School	No	Elementary	KG	03	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229119	MA	Barnstable	school	2502310	20	Barnstable	250231000121	200025	Barnstable: Hyannis West Elementary	Regular School	No	Elementary	KG	03	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229124	MA	Barnstable	school	2502310	20	Barnstable	250231002679	200045	Barnstable: West Villages Elementary School	Regular School	No	Elementary	KG	03	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229127	MA	Barnstable	school	2502310	20	Barnstable	250231002748	200050	Barnstable: Barnstable United Elementary School	Regular School	No	Elementary	04	05	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229130	MA	Barnstable	school	2502310	20	Barnstable	250231002678	200315	Barnstable: Barnstable Intermediate School	Regular School	No	Middle	06	07	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229140	MA	Middlesex	school	2502400	23	Bedford	250240000131	230010	Bedford: Lt Elezer Davis	Regular School	No	Elementary	KG	02	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229144	MA	Middlesex	school	2502400	23	Bedford	250240000132	230012	Bedford: Lt Job Lane School	Regular School	No	Elementary	03	05	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229148	MA	Middlesex	school	2502400	23	Bedford	250240000130	230305	Bedford: John Glenn Middle	Regular School	No	Middle	06	08	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229154	MA	Middlesex	school	2502400	23	Bedford	250240000128	230505	Bedford: Bedford High	Regular School	No	High	09	12	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229157	MA	Hampshire	school	2502430	24	Belchertown	250243000136	240005	Belchertown: Cold Spring	Regular School	No	Elementary	PK	KG	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229161	MA	Hampshire	school	2502430	24	Belchertown	250243001871	240006	Belchertown: Chestnut Hill Community School	Regular School	No	Middle	04	06	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229165	MA	Hampshire	school	2502430	24	Belchertown	250243000836	240018	Belchertown: Swift River Elementary	Regular School	No	Elementary	01	03	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229168	MA	Hampshire	school	2502430	24	Belchertown	250243001873	240025	Belchertown: Jabish Middle School	Regular School	No	Middle	07	08	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229175	MA	Norfolk	school	2502460	25	Bellingham	250246000670	250003	Bellingham: Bellingham Early Childhood Center	Regular School	No	Prekindergarten	PK	PK	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229180	MA	Norfolk	school	2502460	25	Bellingham	250246000142	250020	Bellingham: South Elementary	Regular School	No	Elementary	KG	03	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229185	MA	Norfolk	school	2502460	25	Bellingham	250246000141	250025	Bellingham: Stall Brook	Regular School	No	Elementary	KG	03	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229190	MA	Norfolk	school	2502460	25	Bellingham	250246001683	250315	Bellingham: Bellingham Memorial School	Regular School	No	Middle	04	07	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229196	MA	Norfolk	school	2502460	25	Bellingham	250246000139	250505	Bellingham: Bellingham High School	Regular School	No	High	08	12	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229202	MA	Norfolk	school	2502460	25	Bellingham	250246002543	250510	Bellingham: Keough Memorial Academy	Alternative School	No	High	08	12	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229208	MA	Middlesex	school	2502490	26	Belmont	250249000148	260005	Belmont: Winn Brook	Regular School	No	Elementary	KG	04	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229214	MA	Middlesex	school	2502490	26	Belmont	250249000146	260010	Belmont: Mary Lee Burbank	Regular School	No	Elementary	KG	04	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229220	MA	Middlesex	school	2502490	26	Belmont	250249000144	260015	Belmont: Daniel Butler	Regular School	No	Elementary	KG	04	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229227	MA	Middlesex	school	2502490	26	Belmont	250249000147	260035	Belmont: Roger E Wellington	Regular School	No	Elementary	PK	04	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229232	MA	Middlesex	school	2502490	26	Belmont	250249000149	260305	Belmont: Winthrop L Chenery Middle	Regular School	No	Middle	05	08	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229237	MA	Middlesex	school	2502490	26	Belmont	250249000143	260505	Belmont: Belmont High	Regular School	No	High	09	12	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229244	MA	Bristol	school	2502520	27	Berkley	250252002513	270010	Berkley: Berkley Community School	Regular School	No	Elementary	PK	04	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229249	MA	Bristol	school	2502520	27	Berkley	250252001613	270305	Berkley: Berkley Middle School	Regular School	No	Middle	05	08	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229257	MA	Worcester	school	2502550	28	Berlin	250255000159	280005	Berlin: Berlin Memorial	Regular School	No	Elementary	PK	05	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229259	MA	Essex	school	2502640	30	Beverly	250264002854	300002	Beverly: McKeown School	Regular School	No	Prekindergarten	PK	PK	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229266	MA	Essex	school	2502640	30	Beverly	250264000167	300010	Beverly: Centerville Elementary	Regular School	No	Elementary	KG	05	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229273	MA	Essex	school	2502640	30	Beverly	250264000168	300015	Beverly: Cove Elementary	Regular School	No	Elementary	KG	05	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229280	MA	Essex	school	2502640	30	Beverly	250264000169	300033	Beverly: Hannah Elementary	Regular School	No	Elementary	KG	05	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229294	MA	Essex	school	2502640	30	Beverly	250264000175	300055	Beverly: Ayers/Ryal Side School	Regular School	No	Elementary	KG	05	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229298	MA	Essex	school	2502640	30	Beverly	250264000165	300305	Beverly: Briscoe Middle	Regular School	No	Middle	06	08	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229310	MA	Middlesex	school	2502670	31	Billerica	250267000186	310005	Billerica: Thomas Ditson	Regular School	No	Elementary	KG	05	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229317	MA	Middlesex	school	2502670	31	Billerica	250267000179	310007	Billerica: Frederick J Dutile	Regular School	No	Elementary	KG	05	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229324	MA	Middlesex	school	2502670	31	Billerica	250267000181	310012	Billerica: John F Kennedy	Regular School	No	Elementary	KG	05	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229331	MA	Middlesex	school	2502670	31	Billerica	250267000184	310015	Billerica: Parker	Regular School	No	Elementary	KG	05	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229338	MA	Middlesex	school	2502670	31	Billerica	250267000180	310026	Billerica: Hajjar Elementary	Regular School	No	Elementary	KG	05	2018	sped_beyond_grade_12	*	*	*	*	*	*	*
2229345	MA	Middlesex	school	2502670	31	Billerica	250267000178	310030	Billerica: Eugene C Vining	Regular School	No	Elementary	KG	05	2018	sped_beyond_grade_12	*	*	*	*	*	*	*