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_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
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
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
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
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
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
266514	NH	school	3301860	51	Berlin	330186000024	20045	Berlin Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266529	NH	school	3302340	101	Claremont	330234000039	20115	Claremont Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266542	NH	school	3302460	111	Concord	330246000063	20270	Rundlett Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266566	NH	school	3302610	131	Derry Cooperative	330261000086	20420	Gilbert H. Hood Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266569	NH	school	3302610	131	Derry Cooperative	330261000194	27065	West Running Brook Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266575	NH	school	3302670	142	Dresden	330267000095	20825	Frances C. Richmond School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266581	NH	school	3302880	165	Epping	330288000540	26505	Epping Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266584	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266590	NH	school	3302990	174	Fall Mountain Regional	330299000114	22975	Charlestown Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266619	NH	school	3300035	203	Gorham Randolph Shelburne Cooperative	330003500047	27005	Gorham Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266633	NH	school	3303510	225	Hampton	330351000471	20790	Hampton Academy		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266645	NH	school	3303750	251	Hillsboro-Deering Cooperative	330375000481	20960	Hillsboro-Deering Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266648	NH	school	3303780	255	Hinsdale	330378000048	26985	Hinsdale Middle High School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266654	NH	school	3303870	261	Hooksett	330387000618	28050	David R. Cawley Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266664	NH	school	3303930	267	Hudson	330393000181	21060	Hudson Memorial School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266673	NH	school	3304030	274	Jaffrey-Rindge Cooperative	330403000190	22280	Jaffrey-Rindge Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266680	NH	school	3304040	276	Kearsarge Regional	330404000503	26535	Kearsarge Regional Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266687	NH	school	3304050	279	Keene	330405000203	21185	Keene Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266693	NH	school	3304140	285	Laconia	330414000211	21275	Laconia Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266705	NH	school	3304260	305	Lincoln-Woodstock Cooperative	330426000531	23105	Lin-Wood Public School (Middle)		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266715	NH	school	3304410	319	Londonderry	330441000232	20480	Londonderry Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266728	NH	school	3304590	335	Manchester	330459000576	27595	Henry J. McLaughlin Jr. Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266731	NH	school	3304590	335	Manchester	330459000251	21520	Hillside Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266742	NH	school	3304590	335	Manchester	330459000258	21575	Southside Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266764	NH	school	3304760	352	Merrimack Valley	330476000506	26585	Merrimack Valley Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266773	NH	school	3304830	357	Milford	330483000293	21760	Milford Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266776	NH	school	3300616	359	Milton	330061600296	26540	Nute Junior High School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266795	NH	school	3304980	371	Nashua	330498000317	21890	Elm Street Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266797	NH	school	3304980	371	Nashua	330498000319	21875	Fairgrounds Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266805	NH	school	3304980	371	Nashua	330498000325	21825	Pennichuck Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266816	NH	school	3305220	388	Newfound Area	330522000517	26680	Newfound Memorial Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266820	NH	school	3305280	399	Newmarket	330528000542	26560	Newmarket Jr.-Sr. High (Elem)		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266823	NH	school	3305310	401	Newport	330531000093	26970	Newport Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266828	NH	school	3305400	407	Northumberland	330540000529	26600	Groveton High School (Middle)		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266838	NH	school	3305550	425	Pelham	330555000357	21110	Pelham Memorial School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266856	NH	school	3305820	449	Portsmouth	330582000378	22510	Portsmouth Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266869	NH	school	3305940	461	Rochester	330594000395	22705	Rochester Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266884	NH	school	3306060	473	Salem	330606000409	22850	Woodbury School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266888	NH	school	3306080	476	Sanborn Regional	330608000476	20630	Sanborn Regional Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0