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 order by ccd_school_low_grade limit 101

Query parameters

This data as json, CSV

rowid	state	admin_level	district_nces_id	district_state_id	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	grade	total	total_int
266949	NH	school		457	Rivendell		29196	Rivendell Academy (E)	Interstate Schools						2020	grade_10	0.0	0
266950	NH	school		457	Rivendell		29197	Rivendell Academy (H)	Interstate Schools						2020	grade_10	11.0	11
353632	NH	school		357	Milford			Milford Early Education Experiences							2021	grade_10	0	0
355196	NH	school		453	Raymond			Raymond School District Preschool Program							2021	grade_10	0	0
355298	NH	school		457	Rivendell		29196	Rivendell Academy (E)	Interstate School						2021	grade_10	0	0
355315	NH	school		457	Rivendell		29197	Rivendell Academy (H)	Interstate School						2021	grade_10	10	10
266502	NH	school	3301650	33	Barrington	330165000013	22045	Barrington Elementary School		Regular School	No	Elementary	01	04	2020	grade_10	0.0	0
266588	NH	school	3302990	174	Fall Mountain Regional	330299000112	22960	Acworth Elementary School		Regular School	No	Elementary	01	04	2020	grade_10	0.0	0
266594	NH	school	3302990	174	Fall Mountain Regional	330299000117	22980	N. Charlestown Community School		Regular School	No	Elementary	01	05	2020	grade_10	0.0	0
266596	NH	school	3302990	174	Fall Mountain Regional	330299000119	22995	Sarah Porter School		Regular School	No	Elementary	01	04	2020	grade_10	0.0	0
266612	NH	school	3303240	199	Goffstown	330324000138	20695	Bartlett Elementary School		Regular School	No	Elementary	01	04	2020	grade_10	0.0	0
266615	NH	school	3303240	199	Goffstown	330324000139	20690	Maple Avenue School		Regular School	No	Elementary	01	04	2020	grade_10	0.0	0
266717	NH	school	3304410	319	Londonderry	330441000233	20485	Matthew Thornton Elementary School		Regular School	No	Elementary	01	05	2020	grade_10	0.0	0
266719	NH	school	3304410	319	Londonderry	330441000234	20470	North Londonderry Elementary School		Regular School	No	Elementary	01	05	2020	grade_10	0.0	0
266720	NH	school	3304410	319	Londonderry	330441000473	20475	South Londonderry Elementary School		Regular School	No	Elementary	01	05	2020	grade_10	0.0	0
266916	NH	school	3306720	534	Timberlane Regional	330672000596	27910	Sandown North Elementary School		Regular School	No	Elementary	01	05	2020	grade_10	0.0	0
266931	NH	school	3307115	572	Wilton-Lyndeborough Cooperative	330711500456	23060	Florence Rideout Elementary School		Regular School	No	Elementary	01	05	2020	grade_10	0.0	0
266972	NH	school	3303297	704	Mountain Village Charter School	330329700715	29154	Mountain Village Charter School	Public Charter Schools	Regular School	Yes	Elementary	01	08	2020	grade_10	0.0	0
266977	NH	school	3303290	735	Polaris Charter School	330329000706	29065	Polaris Charter School	Public Charter Schools	Regular School	Yes	Elementary	01	06	2020	grade_10	0.0	0
266981	NH	school	3300042	721	Strong Foundations Charter School	330004200683	28570	Strong Foundations Charter School	Public Charter Schools	Regular School	Yes	Elementary	01	08	2020	grade_10	0.0	0
348702	NH	school	3302990	174	Fall Mountain Regional	330299000112	22960	Acworth Elementary School	Public School	Regular School	No	Elementary	01	04	2021	grade_10	0	0
348974	NH	school	3301650	33	Barrington	330165000013	22045	Barrington Elementary School	Public School	Regular School	No	Elementary	01	04	2021	grade_10	0	0
349008	NH	school	3303240	199	Goffstown	330324000138	20695	Bartlett Elementary School	Public School	Regular School	No	Elementary	01	04	2021	grade_10	0	0
350691	NH	school	3307115	572	Wilton-Lyndeborough Cooperative	330711500456	23060	Florence Rideout Elementary School	Public School	Regular School	No	Elementary	01	05	2021	grade_10	0	0
353173	NH	school	3303240	199	Goffstown	330324000139	20690	Maple Avenue School	Public School	Regular School	No	Elementary	01	04	2021	grade_10	0	0
353360	NH	school	3304410	319	Londonderry	330441000233	20485	Matthew Thornton Elementary School	Public School	Regular School	No	Elementary	01	05	2021	grade_10	0	0
353904	NH	school	3303297	704	Mountain Village Charter School	330329700715	29154	Mountain Village Charter School	Charter Schools approved by the state	Regular School	Yes	Elementary	01	08	2021	grade_10	0	0
353972	NH	school	3302990	174	Fall Mountain Regional	330299000117	22980	N. Charlestown Community School	Public School	Regular School	No	Elementary	01	05	2021	grade_10	0	0
354363	NH	school	3304410	319	Londonderry	330441000234	20470	North Londonderry Elementary School	Public School	Regular School	No	Elementary	01	05	2021	grade_10	0	0
355587	NH	school	3306720	534	Timberlane Regional	330672000596	27910	Sandown North Elementary School	Public School	Regular School	No	Elementary	01	05	2021	grade_10	0	0
355621	NH	school	3302990	174	Fall Mountain Regional	330299000119	22995	Sarah Porter School	Public School	Regular School	No	Elementary	01	04	2021	grade_10	0	0
355808	NH	school	3304410	319	Londonderry	330441000473	20475	South Londonderry Elementary School	Public School	Regular School	No	Elementary	01	05	2021	grade_10	0	0
356029	NH	school	3300042	721	Strong Foundations Charter School	330004200683	28570	Strong Foundations Charter School	Charter Schools approved by the state	Regular School	Yes	Elementary	01	08	2021	grade_10	0	0
266595	NH	school	3302990	174	Fall Mountain Regional	330299000118	23005	North Walpole School		Regular School	No	Elementary	02	04	2020	grade_10	0.0	0
266663	NH	school	3303930	267	Hudson	330393000593	27900	Hills Garrison Elementary School		Regular School	No	Elementary	02	05	2020	grade_10	0.0	0
266665	NH	school	3303930	267	Hudson	330393000513	26765	Nottingham West Elementary School		Regular School	No	Elementary	02	05	2020	grade_10	0.0	0
266770	NH	school	3304830	357	Milford	330483000595	27895	Heron Pond Elementary School		Regular School	No	Elementary	02	05	2020	grade_10	0.0	0
351575	NH	school	3304830	357	Milford	330483000595	27895	Heron Pond Elementary School	Public School	Regular School	No	Elementary	02	05	2021	grade_10	0	0
351626	NH	school	3303930	267	Hudson	330393000593	27900	Hills Garrison Elementary School	Public School	Regular School	No	Elementary	02	05	2021	grade_10	0	0
354397	NH	school	3302990	174	Fall Mountain Regional	330299000118	23005	North Walpole School	Public School	Regular School	No	Elementary	02	04	2021	grade_10	0	0
354482	NH	school	3303930	267	Hudson	330393000513	26765	Nottingham West Elementary School	Public School	Regular School	No	Elementary	02	05	2021	grade_10	0	0
266538	NH	school	3302460	111	Concord	330246000053	20260	Broken Ground School		Regular School	No	Elementary	03	05	2020	grade_10	0.0	0
266583	NH	school	3302940	171	Errol	330294000105	20735	Errol Consolidated Elementary School		Regular School	No	Middle	03	08	2020	grade_10	0.0	0
266586	NH	school	3302970	173	Exeter	330297000108	20595	Lincoln Street Elementary School		Regular School	No	Elementary	03	05	2020	grade_10	0.0	0
266632	NH	school	3303510	225	Hampton	330351000470	20795	Adeline C. Marston School		Regular School	No	Elementary	03	05	2020	grade_10	0.0	0
266656	NH	school	3303870	261	Hooksett	330387000175	20540	Hooksett Memorial School		Regular School	No	Elementary	03	05	2020	grade_10	0.0	0
266777	NH	school	3304890	363	Monadnock Regional	330489000298	21715	Cutler Elementary School		Regular School	No	Elementary	03	06	2020	grade_10	0.0	0
266896	NH	school	3306240	491	Somersworth	330624000733	29203	Maple Wood Elementary School		Regular School	No	Elementary	03	05	2020	grade_10	0.0	0
266942	NH	school	3307300	582	Winnisquam Regional	330730000204	27070	Southwick School		Regular School	No	Elementary	03	05	2020	grade_10	0.0	0
348719	NH	school	3303510	225	Hampton	330351000470	20795	Adeline C. Marston School	Public School	Regular School	No	Elementary	03	05	2021	grade_10	0	0
349416	NH	school	3302460	111	Concord	330246000053	20260	Broken Ground School	Public School	Regular School	No	Elementary	03	05	2021	grade_10	0	0
350011	NH	school	3304890	363	Monadnock Regional	330489000298	21715	Cutler Elementary School	Public School	Regular School	No	Elementary	03	06	2021	grade_10	0	0
351847	NH	school	3303870	261	Hooksett	330387000175	20540	Hooksett Memorial School	Public School	Regular School	No	Elementary	03	05	2021	grade_10	0	0
352782	NH	school	3302970	173	Exeter	330297000108	20595	Lincoln Street Elementary School	Public School	Regular School	No	Elementary	03	05	2021	grade_10	0	0
353224	NH	school	3306240	491	Somersworth	330624000733	29203	Maple Wood Elementary School	Public School	Regular School	No	Elementary	03	05	2021	grade_10	0	0
355876	NH	school	3307300	582	Winnisquam Regional	330730000204	27070	Southwick School	Public School	Regular School	No	Elementary	03	05	2021	grade_10	0	0
266521	NH	school	3302070	71	Brookline	330207000670	27765	Captain Samuel Douglass Academy		Regular School	No	Middle	04	06	2020	grade_10	0.0	0
266601	NH	school	3303000	175	Farmington	330300000124	22055	Henry Wilson Memorial School		Regular School	No	Middle	04	08	2020	grade_10	0.0	0
266604	NH	school	3303090	185	Franklin	330309000511	26755	Franklin Middle School		Regular School	No	Middle	04	08	2020	grade_10	0.0	0
266621	NH	school	3303330	208	Governor Wentworth Regional	330333000565	27515	Crescent Lake School		Regular School	No	Middle	04	06	2020	grade_10	0.0	0
266638	NH	school	3303660	238	Haverhill Cooperative	330366000020	26875	Haverhill Cooperative Middle School		Regular School	No	Middle	04	08	2020	grade_10	0.0	0
266651	NH	school	3303840	259	Hollis	330384000566	27530	Hollis Upper Elementary School		Regular School	No	Middle	04	06	2020	grade_10	0.0	0
266660	NH	school	3303900	263	Hopkinton	330390000178	20965	Maple Street Elementary School		Regular School	No	Middle	04	06	2020	grade_10	0.0	0
349535	NH	school	3302070	71	Brookline	330207000670	27765	Captain Samuel Douglass Academy	Public School	Regular School	No	Middle	04	06	2021	grade_10	0	0
349977	NH	school	3303330	208	Governor Wentworth Regional	330333000565	27515	Crescent Lake School	Public School	Regular School	No	Middle	04	06	2021	grade_10	0	0
350776	NH	school	3303090	185	Franklin	330309000511	26755	Franklin Middle School	Public School	Regular School	No	Middle	04	08	2021	grade_10	0	0
351473	NH	school	3303660	238	Haverhill Cooperative	330366000020	26875	Haverhill Cooperative Middle School	Public School	Regular School	No	Middle	04	08	2021	grade_10	0	0
351558	NH	school	3303000	175	Farmington	330300000124	22055	Henry Wilson Memorial School	Public School	Regular School	No	Middle	04	08	2021	grade_10	0	0
351796	NH	school	3303840	259	Hollis	330384000566	27530	Hollis Upper Elementary School	Public School	Regular School	No	Middle	04	06	2021	grade_10	0	0
351932	NH	school	3305880	453	Raymond	330588000521	26525	Iber Holmes Gove Middle School	Public School	Regular School	No	Middle	04	08	2021	grade_10	0	0
353190	NH	school	3303900	263	Hopkinton	330390000178	20965	Maple Street Elementary School	Public School	Regular School	No	Middle	04	06	2021	grade_10	0	0
353462	NH	school	3306080	476	Sanborn Regional	330608000477	20635	Memorial School	Public School	Regular School	No	Middle	04	06	2021	grade_10	0	0
266494	NH	school	3301380	9	Allenstown	330138000002	22575	Armand R. Dupont School		Regular School	No	Middle	05	08	2020	grade_10	0.0	0
266496	NH	school	3301470	17	Amherst	330147000007	21745	Amherst Middle School		Regular School	No	Middle	05	08	2020	grade_10	0.0	0
266503	NH	school	3301650	33	Barrington	330165000014	22030	Barrington Middle School		Regular School	No	Middle	05	08	2020	grade_10	0.0	0
266508	NH	school	3301740	41	Bedford	330174000017	21005	McKelvie Intermediate School		Regular School	No	Middle	05	06	2020	grade_10	0.0	0
266519	NH	school	3301950	57	Bow	330195000029	20675	Bow Memorial School		Regular School	No	Middle	05	08	2020	grade_10	0.0	0
266547	NH	school	3302480	112	Contoocook Valley	330248000066	22210	Great Brook School		Regular School	No	Middle	05	08	2020	grade_10	0.0	0
266552	NH	school	3302480	112	Contoocook Valley	330248000073	22295	South Meadow School		Regular School	No	Middle	05	08	2020	grade_10	0.0	0
266570	NH	school	3302640	141	Dover	330264000089	20435	Dover Middle School		Regular School	No	Middle	05	08	2020	grade_10	0.0	0
266597	NH	school	3302990	174	Fall Mountain Regional	330299000120	22970	Vilas Elementary School		Regular School	No	Middle	05	08	2020	grade_10	0.0	0
266598	NH	school	3302990	174	Fall Mountain Regional	330299000122	23015	Walpole Elementary School		Regular School	No	Middle	05	08	2020	grade_10	0.0	0
266610	NH	school	3303180	191	Gilford	330318000044	26995	Gilford Middle School		Regular School	No	Middle	05	08	2020	grade_10	0.0	0
266616	NH	school	3303240	199	Goffstown	330324000536	26820	Mountain View Middle School		Regular School	No	Middle	05	08	2020	grade_10	0.0	0
266631	NH	school	3303480	223	Hampstead	330348000468	22750	Hampstead Middle School		Regular School	No	Middle	05	08	2020	grade_10	0.0	0
266700	NH	school	3304230	295	Lebanon	330423000219	21370	Lebanon Middle School		Regular School	No	Middle	05	08	2020	grade_10	0.0	0
266711	NH	school	3304350	315	Litchfield	330435000514	26640	Litchfield Middle School		Regular School	No	Middle	05	08	2020	grade_10	0.0	0
266738	NH	school	3304590	335	Manchester	330459000255	21525	Middle School At Parkside		Regular School	No	Middle	05	08	2020	grade_10	0.0	0
266747	NH	school	3304670	342	Mascenic Regional	330467000515	26685	Boynton Middle School		Regular School	No	Middle	05	08	2020	grade_10	0.0	0
266752	NH	school	3304680	343	Mascoma Valley Regional	330468000498	26405	Indian River School		Regular School	No	Middle	05	08	2020	grade_10	0.0	0
266756	NH	school	3304740	351	Merrimack	330474000277	21025	James Mastricola Upper Elementary School		Regular School	No	Middle	05	06	2020	grade_10	0.0	0
266788	NH	school	3304960	369	Moultonborough	330496000092	26960	Moultonborough Middle Level		Regular School	No	Middle	05	08	2020	grade_10	0.0	0
266834	NH	school	3305520	423	Oyster River Coop	330552000355	22790	Oyster River Middle School		Regular School	No	Middle	05	08	2020	grade_10	0.0	0
266841	NH	school	3305580	427	Pembroke	330558000042	26925	Three Rivers School		Regular School	No	Middle	05	08	2020	grade_10	0.0	0
266859	NH	school	3305880	453	Raymond	330588000521	26525	Iber Holmes Gove Middle School		Regular School	No	Middle	05	08	2020	grade_10	0.0	0
266876	NH	school	3306030	471	Rye	330603000399	22470	Rye Junior High School		Regular School	No	Middle	05	08	2020	grade_10	0.0	0
266890	NH	school	3306150	485	Seabrook	330615000601	27995	Seabrook Middle School		Regular School	No	Middle	05	08	2020	grade_10	0.0	0
266893	NH	school	3306180	486	Shaker Regional	330618000413	22150	Belmont Middle School		Regular School	No	Middle	05	08	2020	grade_10	0.0	0
266937	NH	school	3307170	575	Windham	330717000460	21135	Windham Center School		Regular School	No	Middle	05	06	2020	grade_10	0.0	0
348804	NH	school	3301470	17	Amherst	330147000007	21745	Amherst Middle School	Public School	Regular School	No	Middle	05	08	2021	grade_10	0	0
348872	NH	school	3301380	9	Allenstown	330138000002	22575	Armand R. Dupont School	Public School	Regular School	No	Middle	05	08	2021	grade_10	0	0