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 "grade" = :p0 and "state" = :p1 and (multiracial > :p3 or (multiracial = :p3 and rowid > :p2)) order by multiracial, 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	total
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	*	*	*	*	*	*	*	*
1122479	MA	Essex	school	2502640	30	Beverly	250264000173	300040	North Beverly Elementary	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122486	MA	Essex	school	2502640	30	Beverly	250264000175	300055	Ayers/Ryal Side School	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122490	MA	Essex	school	2502640	30	Beverly	250264000165	300305	Briscoe Middle	Regular School	No	Middle	06	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122502	MA	Middlesex	school	2502670	31	Billerica	250267000186	310005	Thomas Ditson	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122509	MA	Middlesex	school	2502670	31	Billerica	250267000179	310007	Frederick J Dutile	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122516	MA	Middlesex	school	2502670	31	Billerica	250267000181	310012	John F Kennedy	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122523	MA	Middlesex	school	2502670	31	Billerica	250267000184	310015	Parker	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122530	MA	Middlesex	school	2502670	31	Billerica	250267000180	310026	Hajjar Elementary	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122537	MA	Middlesex	school	2502670	31	Billerica	250267000178	310030	Eugene C Vining	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122541	MA	Middlesex	school	2502670	31	Billerica	250267000183	310305	Marshall Middle School	Regular School	No	Middle	06	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122545	MA	Middlesex	school	2502670	31	Billerica	250267000182	310310	Locke Middle	Regular School	No	Middle	06	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122556	MA	Suffolk	school	2502790	35	Boston	250279001768	350001	Lee Academy	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122560	MA	Suffolk	school	2502790	35	Boston	250279000011	350003	Baldwin Early Learning Center	Regular School	No	Elementary	PK	01	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122570	MA	Suffolk	school	2502790	35	Boston	250279002458	350004	Lyon K-8	Regular School	No	Elementary	KG	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122574	MA	Suffolk	school	2502790	35	Boston	250279002514	350006	ELC - West Zone	Regular School	No	Elementary	PK	01	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122580	MA	Suffolk	school	2502790	35	Boston	250279001115	350008	Dr. Catherine Ellison-Rosa Parks Early Ed School	Regular School	No	Elementary	PK	03	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122584	MA	Suffolk	school	2502790	35	Boston	250279001118	350009	East Boston Early Childhood Center	Regular School	No	Elementary	PK	01	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122588	MA	Suffolk	school	2502790	35	Boston	250279001126	350010	Haynes Early Education Center	Regular School	No	Elementary	PK	01	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122599	MA	Suffolk	school	2502790	35	Boston	250279002687	350012	Boston Teachers Union School	Regular School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122610	MA	Suffolk	school	2502790	35	Boston	250279000251	350013	Jackson Mann	Regular School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122615	MA	Suffolk	school	2502790	35	Boston	250279002839	350014	Pauline Agassiz Shaw Elementary School	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122620	MA	Suffolk	school	2502790	35	Boston	250279002806	350015	Higginson	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122631	MA	Suffolk	school	2502790	35	Boston	250279002622	350020	Curley K-8 School	Regular School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122637	MA	Suffolk	school	2502790	35	Boston	250279000198	350021	Beethoven	Regular School	No	Elementary	PK	03	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122651	MA	Suffolk	school	2502790	35	Boston	250279000214	350052	Charles Sumner	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122659	MA	Suffolk	school	2502790	35	Boston	250279000213	350054	Charles H Taylor	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122667	MA	Suffolk	school	2502790	35	Boston	250279000218	350062	Curtis Guild	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122676	MA	Suffolk	school	2502790	35	Boston	250279002835	350066	Dante Alighieri Montessori School	Regular School	No	Elementary	PK	06	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122684	MA	Suffolk	school	2502790	35	Boston	250279000220	350072	David A Ellis	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122692	MA	Suffolk	school	2502790	35	Boston	250279000222	350074	Dearborn	Regular School	No	Other	06	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122703	MA	Suffolk	school	2502790	35	Boston	250279000223	350077	Dennis C Haley	Regular School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122714	MA	Suffolk	school	2502790	35	Boston	250279000224	350080	Donald Mckay	Regular School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122722	MA	Suffolk	school	2502790	35	Boston	250279000227	350088	Edward Everett	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122733	MA	Suffolk	school	2502790	35	Boston	250279000230	350096	Eliot Elementary	Regular School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122741	MA	Suffolk	school	2502790	35	Boston	250279000232	350100	Ellis Mendell	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122752	MA	Suffolk	school	2502790	35	Boston	250279000239	350116	Franklin D Roosevelt	Regular School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122760	MA	Suffolk	school	2502790	35	Boston	250279000241	350122	George H Conley	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122768	MA	Suffolk	school	2502790	35	Boston	250279000247	350135	Henry Grew	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122776	MA	Suffolk	school	2502790	35	Boston	250279002569	350138	O W Holmes	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122784	MA	Suffolk	school	2502790	35	Boston	250279000249	350141	Hugh Roe O'Donnell	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122794	MA	Suffolk	school	2502790	35	Boston	250279000254	350146	James Condon Elementary	Regular School	No	Elementary	PK	07	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122804	MA	Suffolk	school	2502790	35	Boston	250279000259	350153	James W Hennigan	Regular School	No	Elementary	KG	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122812	MA	Suffolk	school	2502790	35	Boston	250279000255	350154	James J Chittick	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122820	MA	Suffolk	school	2502790	35	Boston	250279000257	350156	James Otis	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122828	MA	Suffolk	school	2502790	35	Boston	250279000265	350166	John F Kennedy	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122836	MA	Suffolk	school	2502790	35	Boston	250279000268	350167	UP Academy Holland	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122844	MA	Suffolk	school	2502790	35	Boston	250279000264	350172	John D Philbrick	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122848	MA	Suffolk	school	2502790	35	Boston	250279000269	350179	John W McCormack	Regular School	No	Middle	06	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1122856	MA	Suffolk	school	2502790	35	Boston	250279000270	350180	John Winthrop	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*