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 (total > :p2 or (total = :p2 and rowid > :p1)) order by total, 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	male_int	female_int
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	*	*	*	*	*	*	*			*
1122636	MA	Suffolk	school	2502790	35	Boston	250279000198	350021	Beethoven	Regular School	No	Elementary	PK	03	2017	grade_3	*	*	*	*	*	*	*	4	1	*	4	1
1122637	MA	Suffolk	school	2502790	35	Boston	250279000198	350021	Beethoven	Regular School	No	Elementary	PK	03	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122638	MA	Suffolk	school	2502790	35	Boston	250279000210	350036	Carter Developmental Center	Regular School	No	High	07	12	2017	grade_7	*	*	*	*	*	*	*	1	2	*	1	2
1122639	MA	Suffolk	school	2502790	35	Boston	250279000210	350036	Carter Developmental Center	Regular School	No	High	07	12	2017	grade_9	*	*	*	*	*	*	*	1	1	*	1	1
1122640	MA	Suffolk	school	2502790	35	Boston	250279000210	350036	Carter Developmental Center	Regular School	No	High	07	12	2017	grade_10	*	*	*	*	*	*	*	3	2	*	3	2
1122641	MA	Suffolk	school	2502790	35	Boston	250279000210	350036	Carter Developmental Center	Regular School	No	High	07	12	2017	grade_11	*	*	*	*	*	*	*	1	2	*	1	2
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	*	*	*	*	*	*	*			*
1122674	MA	Suffolk	school	2502790	35	Boston	250279002835	350066	Dante Alighieri Montessori School	Regular School	No	Elementary	PK	06	2017	grade_5	*	*	*	*	*	*	*	3	1	*	3	1
1122675	MA	Suffolk	school	2502790	35	Boston	250279002835	350066	Dante Alighieri Montessori School	Regular School	No	Elementary	PK	06	2017	grade_6	*	*	*	*	*	*	*	2	2	*	2	2
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	*	*	*	*	*	*	*			*
1122864	MA	Suffolk	school	2502790	35	Boston	250279000275	350181	Joseph P Tynan	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122875	MA	Suffolk	school	2502790	35	Boston	250279000272	350182	Joseph J Hurley	Regular School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122886	MA	Suffolk	school	2502790	35	Boston	250279000273	350183	Joseph Lee	Regular School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122894	MA	Suffolk	school	2502790	35	Boston	250279000274	350184	Joseph P Manning	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122905	MA	Suffolk	school	2502790	35	Boston	250279000278	350190	Joyce Kilmer	Regular School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122913	MA	Suffolk	school	2502790	35	Boston	250279000244	350200	Harvard-Kent	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122921	MA	Suffolk	school	2502790	35	Boston	250279000283	350215	Manassah E Bradley	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122929	MA	Suffolk	school	2502790	35	Boston	250279000290	350226	Mattahunt	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122937	MA	Suffolk	school	2502790	35	Boston	250279000289	350227	Mather	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122948	MA	Suffolk	school	2502790	35	Boston	250279000291	350229	Maurice J Tobin	Regular School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122955	MA	Suffolk	school	2502790	35	Boston	250279000292	350231	Michael J Perkins	Regular School	No	Elementary	KG	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122963	MA	Suffolk	school	2502790	35	Boston	250279000294	350237	Mozart	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122974	MA	Suffolk	school	2502790	35	Boston	250279000315	350240	Richard J Murphy	Regular School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122982	MA	Suffolk	school	2502790	35	Boston	250279000295	350243	Nathan Hale	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1122993	MA	Suffolk	school	2502790	35	Boston	250279000297	350255	Oliver Hazard Perry	Regular School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123004	MA	Suffolk	school	2502790	35	Boston	250279002006	350257	Orchard Gardens	Regular School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123011	MA	Suffolk	school	2502790	35	Boston	250279000339	350258	William H Ohrenberger	Regular School	No	Elementary	03	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123022	MA	Suffolk	school	2502790	35	Boston	250279000692	350262	Lyndon	Regular School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123030	MA	Suffolk	school	2502790	35	Boston	250279000302	350264	Patrick J Kennedy	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123035	MA	Suffolk	school	2502790	35	Boston	250279000303	350266	Dr. William Henderson Lower	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123043	MA	Suffolk	school	2502790	35	Boston	250279000304	350268	Paul A Dever	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123051	MA	Suffolk	school	2502790	35	Boston	250279000308	350278	Phineas Bates	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123059	MA	Suffolk	school	2502790	35	Boston	250279000277	350286	Josiah Quincy	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123067	MA	Suffolk	school	2502790	35	Boston	250279000319	350298	Roger Clap	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123075	MA	Suffolk	school	2502790	35	Boston	250279000321	350302	Samuel Adams	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123083	MA	Suffolk	school	2502790	35	Boston	250279000322	350304	Samuel W Mason	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123094	MA	Suffolk	school	2502790	35	Boston	250279000323	350308	Sarah Greenwood	Regular School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123105	MA	Suffolk	school	2502790	35	Boston	250279000331	350326	Gardner Pilot Academy	Regular School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123113	MA	Suffolk	school	2502790	35	Boston	250279000332	350328	Thomas J Kenny	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123124	MA	Suffolk	school	2502790	35	Boston	250279000333	350346	Warren-Prescott	Regular School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123132	MA	Suffolk	school	2502790	35	Boston	250279000338	350360	William Ellery Channing	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123152	MA	Suffolk	school	2502790	35	Boston	250279000337	350366	William E Russell	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123163	MA	Suffolk	school	2502790	35	Boston	250279000343	350370	William Monroe Trotter	Regular School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123171	MA	Suffolk	school	2502790	35	Boston	250279000344	350374	Winship Elementary	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123182	MA	Suffolk	school	2502790	35	Boston	250279002689	350375	Edison K-8	Regular School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123193	MA	Suffolk	school	2502790	35	Boston	250279002669	350376	King K-8	Regular School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123194	MA	Suffolk	school	2502790	35	Boston	250279002677	350377	Higginson/Lewis K-8	Regular School	No	Elementary	KG	08	2017	kindergarten	*	*	*	*	*	*	*	1	1	*	1	1
1123202	MA	Suffolk	school	2502790	35	Boston	250279002677	350377	Higginson/Lewis K-8	Regular School	No	Elementary	KG	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123212	MA	Suffolk	school	2502790	35	Boston	250279002670	350378	Mildred Avenue K-8	Regular School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123223	MA	Suffolk	school	2502790	35	Boston	250279000693	350380	Young Achievers	Alternative School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123234	MA	Suffolk	school	2502790	35	Boston	250279000946	350382	Mission Hill School	Regular School	No	Elementary	PK	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123238	MA	Suffolk	school	2502790	35	Boston	250279002013	350383	Lilla G. Frederick Middle School	Regular School	No	Middle	06	08	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123246	MA	Suffolk	school	2502790	35	Boston	250279000201	350390	Blackstone	Regular School	No	Elementary	PK	05	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*
1123257	MA	Suffolk	school	2502790	35	Boston	250279000952	350426	Dr. William Henderson Upper	Regular School	No	Other	03	12	2017	sped_beyond_grade_12	*	*	*	*	*	*	*			*