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 "year" = :p2 order by ccd_school_high_grade 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
1122560	MA	Suffolk	school	2502790	35	Boston	250279000011	350003	Baldwin Early Learning Center	Regular School	No	Elementary	PK	01	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	*	*	*	*	*	*	*	*
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	*	*	*	*	*	*	*	*
1124078	MA	Suffolk	school	2503540	57	Chelsea	250354000235	570003	Shurtleff Early Childhood	Regular School	No	Elementary	PK	01	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1124413	MA	Worcester	school	2504230	77	Douglas	250423002798	770005	Douglas Primary School	Regular School	No	Elementary	PK	01	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1125105	MA	Worcester	school	2505130	103	Gardner	250513000755	1030020	Waterford Street	Regular School	No	Elementary	PK	01	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1125203	MA	Worcester	school	2505370	110	Grafton	250537000788	1100005	South Grafton Elementary	Regular School	No	Elementary	PK	01	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1125207	MA	Worcester	school	2505370	110	Grafton	250537000787	1100025	North Grafton Elementary	Regular School	No	Elementary	PK	01	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1125649	MA	Middlesex	school	2506330	139	Hopkinton	250633000918	1390005	Center	Regular School	No	Elementary	KG	01	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1126313	MA	Hampden	school	2507050	161	Ludlow	250705002663	1610010	East Street Elementary School	Regular School	No	Elementary	PK	01	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1126627	MA	Essex	school	2507260	168	Marblehead	250726001120	1680015	Elbridge Gerry	Regular School	No	Elementary	KG	01	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1126779	MA	Norfolk	school	2507530	175	Medfield	250753000114	1750003	Memorial School	Regular School	No	Elementary	PK	01	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1126853	MA	Norfolk	school	2507590	177	Medway	250759001185	1770013	John D Mc Govern Elementary	Regular School	No	Elementary	PK	01	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1127765	MA	Worcester	school	2508940	214	Northbridge	250894002682	2140005	Northbridge Elementary	Regular School	No	Elementary	PK	01	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1127948	MA	Worcester	school	2509270	226	Oxford	250927001479	2260010	Alfred M Chaffee	Regular School	No	Elementary	PK	01	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1128861	MA	Worcester	school	2510770	271	Shrewsbury	251077002496	2710005	Beal School	Regular School	No	Elementary	KG	01	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1129034	MA	Worcester	school	2510980	276	Southborough	251098001761	2760008	Mary E Finn School	Regular School	No	Elementary	PK	01	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1129072	MA	Hampshire	school	2510920	278	South Hadley	251092001753	2780015	Plains Elementary	Regular School	No	Elementary	PK	01	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1129171	MA	Hampden	school	2511130	281	Springfield	251113001817	2810060	Margaret C Ells	Regular School	No	Elementary	PK	01	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1131780	MA	Worcester	school	2502040	610	Ashburnham-Westminster	250204000397	6100010	Meetinghouse School	Regular School	No	Elementary	KG	01	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1131906	MA	Bristol	school	2503030	625	Bridgewater-Raynham	250303002102	6250020	Merrill Elementary School	Regular School	No	Elementary	KG	01	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1132053	MA	Worcester	school	2504360	658	Dudley-Charlton Reg	250436000590	6580010	Mason Road School	Regular School	No	Elementary	PK	01	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1132057	MA	Worcester	school	2504360	658	Dudley-Charlton Reg	250436000585	6580020	Charlton Elementary	Regular School	No	Elementary	PK	01	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1132185	MA	Franklin	school	2505270	674	Gill-Montague	250527002816	6740015	Hillcrest Elementary School	Regular School	No	Elementary	PK	01	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1132241	MA	Hampden	school	2505730	680	Hampden-Wilbraham	250573001598	6800025	Mile Tree Elementary	Regular School	No	Elementary	PK	01	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1132436	MA	Worcester	school	2508280	720	Narragansett	250828001288	7200020	Templeton Center	Regular School	No	Elementary	KG	01	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1132640	MA	Worcester	school	2500001	753	Quabbin	250000102401	7530020	New Braintree Grade	Regular School	No	Elementary	PK	01	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1132703	MA	Berkshire	school	2511040	765	Southern Berkshire	251104001778	7650030	South Egremont	Regular School	No	Elementary	KG	01	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	*	*	*	*	*	*	*	*
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	*	*	*	*	*	*	*	*
1122334	MA	Middlesex	school	2502400	23	Bedford	250240000131	230010	Lt Elezer Davis	Regular School	No	Elementary	KG	02	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	*	*	*	*	*	*	*	*
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	*	*	*	*	*	*	*	*
1123035	MA	Suffolk	school	2502790	35	Boston	250279000303	350266	Dr. William Henderson Lower	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1123488	MA	Essex	school	2502880	38	Boxford	250288000357	380005	Harry Lee Cole	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1123563	MA	Barnstable	school	2502970	41	Brewster	250297000374	410005	Stony Brook Elementary	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1124131	MA	Hampden	school	2503660	61	Chicopee	250366000490	610010	Belcher	Regular School	No	Elementary	KG	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1124243	MA	Norfolk	school	2503780	65	Cohasset	250378000520	650010	Joseph Osgood	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1124482	MA	Plymouth	school	2504410	82	Duxbury	250441000593	820006	Chandler Elementary	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1124496	MA	Plymouth	school	2504440	83	East Bridgewater	250444000596	830005	Central	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1124554	MA	Hampden	school	2504500	87	East Longmeadow	250450000605	870013	Meadow Brook	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1124572	MA	Bristol	school	2504620	88	Easton	250462000980	880003	Center School	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1124577	MA	Bristol	school	2504620	88	Easton	250462000624	880015	Parkview Elementary	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1124582	MA	Bristol	school	2504620	88	Easton	250462002381	880020	Moreau Hall	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1124963	MA	Middlesex	school	2504980	100	Framingham	250498002823	1000005	King Elementary School	Regular School	No	Elementary	KG	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1125332	MA	Plymouth	school	2505790	122	Hanover	250579000828	1220005	Center Elementary	Regular School	No	Elementary	KG	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1125398	MA	Essex	school	2505970	128	Haverhill	250597000854	1280027	Greenleaf	Regular School	No	Elementary	KG	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1125437	MA	Essex	school	2505970	128	Haverhill	250597000867	1280080	Walnut Square	Regular School	No	Elementary	KG	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1125529	MA	Middlesex	school	2506240	136	Holliston	250624001172	1360010	Placentino Elementary	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1125543	MA	Hampden	school	2506270	137	Holyoke	250627001178	1370003	Joseph Metcalf School	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1125740	MA	Plymouth	school	2506540	145	Kingston	250654000943	1450005	Kingston Elementary	Regular School	No	Elementary	KG	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1125800	MA	Essex	school	2506660	149	Lawrence	250666000958	1490020	James F Hennessey	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1125920	MA	Worcester	school	2506720	151	Leicester	250672000974	1510010	Leicester Primary School	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1126096	MA	Middlesex	school	2506960	158	Littleton	250696001014	1580005	Shaker Lane Elementary	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1126333	MA	Worcester	school	2507080	162	Lunenburg	250708001957	1620010	Lunenburg Primary School	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1126603	MA	Bristol	school	2507230	167	Mansfield	250723001111	1670007	Everett W Robinson	Regular School	No	Elementary	KG	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1126735	MA	Barnstable	school	2507440	172	Mashpee	250744002528	1720005	Kenneth Coombs School	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1126990	MA	Essex	school	2507830	184	Middleton	250783002588	1840003	Fuller Meadow	Regular School	No	Elementary	KG	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1127000	MA	Worcester	school	2507860	185	Milford	250786001238	1850010	Memorial	Regular School	No	Elementary	KG	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1127004	MA	Worcester	school	2507860	185	Milford	250786001237	1850065	Brookside	Regular School	No	Elementary	KG	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1127560	MA	Norfolk	school	2508640	208	Norfolk	250864000317	2080015	H Olive Day	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1127933	MA	Franklin	school	2509180	223	Orange	250918002593	2230015	Fisher Hill	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1128694	MA	Barnstable	school	2510470	261	Sandwich	251047002857	2610002	Forestdale School	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1129053	MA	Worcester	school	2511010	277	Southbridge	251101001764	2770010	Eastford Road	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1129576	MA	Worcester	school	2511400	290	Sutton	251140001661	2900003	Sutton Early Learning	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1129626	MA	Bristol	school	2511460	292	Swansea	251146001892	2920015	Gardner	Regular School	No	Elementary	KG	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1129631	MA	Bristol	school	2511460	292	Swansea	251146000129	2920017	Mark G Hoyle Elementary	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1129716	MA	Middlesex	school	2511580	295	Tewksbury	251158001922	2950001	L F Dewing	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1129720	MA	Middlesex	school	2511580	295	Tewksbury	251158001921	2950010	Heath-Brook	Regular School	No	Elementary	KG	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1129789	MA	Worcester	school	2511850	304	Uxbridge	251185001936	3040005	Taft Early Learning Center	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1129973	MA	Plymouth	school	2512060	310	Wareham	251206001988	3100003	John William Decas	Regular School	No	Elementary	KG	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1130284	MA	Middlesex	school	2512660	326	Westford	251266002078	3260015	Nabnasset	Regular School	No	Elementary	KG	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1130288	MA	Middlesex	school	2512660	326	Westford	251266002077	3260025	Col John Robinson	Regular School	No	Elementary	KG	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1130296	MA	Middlesex	school	2512660	326	Westford	251266001740	3260055	Rita E. Miller Elementary School	Regular School	No	Elementary	KG	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1130347	MA	Bristol	school	2512780	331	Westport	251278002090	3310015	Alice A Macomber	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1130577	MA	Worcester	school	2513080	343	Winchendon	251308002161	3430040	Memorial	Regular School	No	Elementary	KG	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1130645	MA	Suffolk	school	2513170	346	Winthrop	251317001665	3460015	William P. Gorman/Fort Banks Elementary	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1131876	MA	Worcester	school	2502715	622	Blackstone-Millville	250271502372	6220008	John F Kennedy Elementary	Regular School	No	Elementary	KG	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1132572	MA	Essex	school	2509450	745	Pentucket	250945000414	7450020	Dr Frederick N Sweetsir	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1132724	MA	Hampden	school	2500013	766	Southwick-Tolland-Granville Regional School District	250001301783	7660010	Woodland School	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1132840	MA	Worcester	school	2511880	775	Wachusett	251188002693	7750005	Naquag Elementary School	Regular School	No	Elementary	KG	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1132947	MA	Plymouth	school	2512930	780	Whitman-Hanson	251293000199	7800025	Maquan Elementary	Regular School	No	Elementary	PK	02	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1133170	MA	Hampden	school	2500557	3510	Springfield Preparatory Charter	250055702842	35100205	Springfield Preparatory Charter School	Regular School	Yes	Elementary	KG	02	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	*	*	*	*	*	*	*	*
1122359	MA	Hampshire	school	2502430	24	Belchertown	250243000836	240018	Swift River Elementary	Regular School	No	Elementary	01	03	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	*	*	*	*	*	*	*	*
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	*	*	*	*	*	*	*	*
1122637	MA	Suffolk	school	2502790	35	Boston	250279000198	350021	Beethoven	Regular School	No	Elementary	PK	03	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1124222	MA	Worcester	school	2503750	64	Clinton	250375002379	640050	Clinton Elementary	Regular School	No	Elementary	PK	03	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1125237	MA	Hampshire	school	2505400	111	Granby	250540000791	1110010	West Street	Regular School	No	Elementary	PK	03	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1125500	MA	Norfolk	school	2506150	133	Holbrook	250615000880	1330018	John F Kennedy	Regular School	No	Elementary	PK	03	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1125618	MA	Hampden	school	2506270	137	Holyoke	250627002795	1370070	H.B. Lawrence School	Regular School	No	Elementary	KG	03	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1125652	MA	Middlesex	school	2506330	139	Hopkinton	250633000919	1390010	Elmwood	Regular School	No	Elementary	02	03	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*
1126074	MA	Middlesex	school	2506900	157	Lincoln	250690001009	1570006	Hanscom Primary	Regular School	No	Elementary	PK	03	2017	sped_beyond_grade_12	*	*	*	*	*	*	*	*