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 district_nces_id desc 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
266842	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School		Regular School	No	High	09	12	2020	grade_10	154.0	154
355043	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School	Public School	Regular School	No	High	09	13	2021	grade_10	152	152
266947	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academies and Joint Maintenance Agreements	Regular School	No	High	09	13	2020	grade_10	796.0	796
354890	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academy	Regular School	No	High	09	13	2021	grade_10	757	757
266946	NH	school	3307330	998	Coe-Brown Northwood Academy	330733000519	22025	Coe-Brown Northwood Academy	Public Academies and Joint Maintenance Agreements	Regular School	No	High	09	12	2020	grade_10	156.0	156
349790	NH	school	3307330	998	Coe-Brown Northwood Academy	330733000519	22025	Coe-Brown Northwood Academy	Public Academy	Regular School	No	High	09	12	2021	grade_10	171	171
266941	NH	school	3307300	582	Winnisquam Regional	330730000464	22925	Sanbornton Central School		Regular School	No	Elementary	KG	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
266943	NH	school	3307300	582	Winnisquam Regional	330730000467	22945	Union Sanborn School		Regular School	No	Elementary	PK	02	2020	grade_10	0.0	0
266944	NH	school	3307300	582	Winnisquam Regional	330730000465	22950	Winnisquam Regional High School		Regular School	No	High	09	12	2020	grade_10	109.0	109
266945	NH	school	3307300	582	Winnisquam Regional	330730000466	22955	Winnisquam Regional Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
355553	NH	school	3307300	582	Winnisquam Regional	330730000464	22925	Sanbornton Central School	Public School	Regular School	No	Elementary	KG	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
356369	NH	school	3307300	582	Winnisquam Regional	330730000467	22945	Union Sanborn School	Public School	Regular School	No	Elementary	PK	02	2021	grade_10	0	0
356930	NH	school	3307300	582	Winnisquam Regional	330730000465	22950	Winnisquam Regional High School	Public School	Regular School	No	High	09	12	2021	grade_10	111	111
356947	NH	school	3307300	582	Winnisquam Regional	330730000466	22955	Winnisquam Regional Middle School	Public School	Regular School	No	Middle	06	08	2021	grade_10	0	0
266940	NH	school	3307230	581	Winnacunnet Cooperative	330723000463	20780	Winnacunnet High School		Regular School	No	High	09	13	2020	grade_10	300.0	300
356913	NH	school	3307230	581	Winnacunnet Cooperative	330723000463	20780	Winnacunnet High School	Public School	Regular School	No	High	09	13	2021	grade_10	282	282
266936	NH	school	3307170	575	Windham	330717000461	21130	Golden Brook Elementary School		Regular School	No	Elementary	PK	04	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
266938	NH	school	3307170	575	Windham	330717000692	28640	Windham High School		Regular School	No	High	09	13	2020	grade_10	249.0	249
266939	NH	school	3307170	575	Windham	330717000495	21125	Windham Middle School		Regular School	No	Middle	07	08	2020	grade_10	0.0	0
351014	NH	school	3307170	575	Windham	330717000461	21130	Golden Brook Elementary School	Public School	Regular School	No	Elementary	PK	04	2021	grade_10	0	0
356862	NH	school	3307170	575	Windham	330717000460	21135	Windham Center School	Public School	Regular School	No	Middle	05	06	2021	grade_10	0	0
356879	NH	school	3307170	575	Windham	330717000692	28640	Windham High School	Public School	Regular School	No	High	09	12	2021	grade_10	269	269
356896	NH	school	3307170	575	Windham	330717000495	21125	Windham Middle School	Public School	Regular School	No	Middle	07	08	2021	grade_10	0	0
266935	NH	school	3307140	573	Winchester	330714000459	21735	Winchester School		Regular School	No	Elementary	PK	08	2020	grade_10	0.0	0
356828	NH	school	3307140	573	Winchester	330714000459	21735	Winchester School	Public School	Regular School	No	Elementary	PK	08	2021	grade_10	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
266932	NH	school	3307115	572	Wilton-Lyndeborough Cooperative	330711500237	23035	Lyndeborough Central School		Regular School	No	Elementary	PK	KG	2020	grade_10	0.0	0
266933	NH	school	3307115	572	Wilton-Lyndeborough Cooperative	330711500110	26955	Wilton-Lyndeboro Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266934	NH	school	3307115	572	Wilton-Lyndeborough Cooperative	330711500457	23070	Wilton-Lyndeboro Senior High School		Regular School	No	High	09	12	2020	grade_10	43.0	43
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
352969	NH	school	3307115	572	Wilton-Lyndeborough Cooperative	330711500237	23035	Lyndeborough Central School	Public School	Regular School	No	Elementary	PK	KG	2021	grade_10	0	0
356794	NH	school	3307115	572	Wilton-Lyndeborough Cooperative	330711500110	26955	Wilton-Lyndeboro Middle School	Public School	Regular School	No	Middle	06	08	2021	grade_10	0	0
356811	NH	school	3307115	572	Wilton-Lyndeborough Cooperative	330711500457	23070	Wilton-Lyndeboro Senior High School	Public School	Regular School	No	High	09	12	2021	grade_10	45	45
266928	NH	school	3307050	568	White Mountains Regional	330705000453	21475	Lancaster Elementary School		Regular School	No	Elementary	PK	08	2020	grade_10	0.0	0
266929	NH	school	3307050	568	White Mountains Regional	330705000454	21480	White Mountains Regional High School		Regular School	No	High	09	12	2020	grade_10	81.0	81
266930	NH	school	3307050	568	White Mountains Regional	330705000004	26930	Whitefield Elementary School		Regular School	No	Elementary	PK	08	2020	grade_10	0.0	0
352595	NH	school	3307050	568	White Mountains Regional	330705000453	21475	Lancaster Elementary School	Public School	Regular School	No	Elementary	PK	08	2021	grade_10	0	0
356709	NH	school	3307050	568	White Mountains Regional	330705000454	21480	White Mountains Regional High School	Public School	Regular School	No	High	09	13	2021	grade_10	88	88
356726	NH	school	3307050	568	White Mountains Regional	330705000004	26930	Whitefield Elementary School	Public School	Regular School	No	Elementary	KG	08	2021	grade_10	0	0
266927	NH	school	3307020	563	Westmoreland	330702000450	21230	Westmoreland School		Regular School	No	Elementary	KG	08	2020	grade_10	0.0	0
356658	NH	school	3307020	563	Westmoreland	330702000450	21230	Westmoreland School	Public School	Regular School	No	Elementary	KG	08	2021	grade_10	0	0
266926	NH	school	3306990	559	Wentworth	330699000449	22390	Wentworth Elementary School		Regular School	No	Elementary	KG	08	2020	grade_10	0.0	0
356624	NH	school	3306990	559	Wentworth	330699000449	22390	Wentworth Elementary School	Public School	Regular School	No	Elementary	KG	08	2021	grade_10	0	0
266924	NH	school	3306930	555	Weare	330693000025	26810	Center Woods School		Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
266925	NH	school	3306930	555	Weare	330693000023	20720	Weare Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
349569	NH	school	3306930	555	Weare	330693000025	26810	Center Woods School	Public School	Regular School	No	Elementary	PK	05	2021	grade_10	0	0
356556	NH	school	3306930	555	Weare	330693000023	20720	Weare Middle School	Public School	Regular School	No	Middle	06	08	2021	grade_10	0	0
266923	NH	school	3306910	553	Waterville Valley	330691000446	22385	Waterville Valley Elementary School		Regular School	No	Elementary	KG	08	2020	grade_10	0.0	0
356539	NH	school	3306910	553	Waterville Valley	330691000446	22385	Waterville Valley Elementary School	Public School	Regular School	No	Elementary	KG	08	2021	grade_10	0	0
266922	NH	school	3306900	551	Washington	330690000445	20985	Washington Elementary School		Regular School	No	Elementary	KG	05	2020	grade_10	0.0	0
356522	NH	school	3306900	551	Washington	330690000445	20985	Washington Elementary School	Public School	Regular School	No	Elementary	KG	05	2021	grade_10	0	0
266921	NH	school	3306870	549	Warren	330687000444	20900	Warren Village School		Regular School	No	Elementary	PK	08	2020	grade_10	0.0	0
356505	NH	school	3306870	549	Warren	330687000444	20900	Warren Village School	Public School	Regular School	No	Elementary	PK	08	2021	grade_10	0	0
266920	NH	school	3306780	543	Wakefield	330678000442	22110	Paul Elementary School		Regular School	No	Elementary	PK	08	2020	grade_10	0.0	0
354669	NH	school	3306780	543	Wakefield	330678000442	22110	Paul Elementary School	Public School	Regular School	No	Elementary	PK	08	2021	grade_10	0	0
266919	NH	school	3306750	539	Unity	330675000441	20180	Unity Elementary School		Regular School	No	Elementary	PK	08	2020	grade_10	0.0	0
356386	NH	school	3306750	539	Unity	330675000441	20180	Unity Elementary School	Public School	Regular School	No	Elementary	PK	08	2021	grade_10	0	0
266912	NH	school	3306720	534	Timberlane Regional	330672000434	22740	Atkinson Academy		Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
266913	NH	school	3306720	534	Timberlane Regional	330672000435	22745	Danville Elementary School		Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
266914	NH	school	3306720	534	Timberlane Regional	330672000436	22765	Pollard Elementary School		Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
266915	NH	school	3306720	534	Timberlane Regional	330672000438	22775	Sandown Central School		Regular School	No	Elementary	PK	KG	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
266917	NH	school	3306720	534	Timberlane Regional	330672000439	22770	Timberlane Regional High School		Regular School	No	High	09	12	2020	grade_10	247.0	247
266918	NH	school	3306720	534	Timberlane Regional	330672000440	22760	Timberlane Regional Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
348906	NH	school	3306720	534	Timberlane Regional	330672000434	22740	Atkinson Academy	Public School	Regular School	No	Elementary	PK	05	2021	grade_10	0	0
350079	NH	school	3306720	534	Timberlane Regional	330672000435	22745	Danville Elementary School	Public School	Regular School	No	Elementary	PK	05	2021	grade_10	0	0
355077	NH	school	3306720	534	Timberlane Regional	330672000436	22765	Pollard Elementary School	Public School	Regular School	No	Elementary	PK	05	2021	grade_10	0	0
355570	NH	school	3306720	534	Timberlane Regional	330672000438	22775	Sandown Central School	Public School	Regular School	No	Elementary	PK	KG	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
356301	NH	school	3306720	534	Timberlane Regional	330672000439	22770	Timberlane Regional High School	Public School	Regular School	No	High	09	12	2021	grade_10	268	268
356318	NH	school	3306720	534	Timberlane Regional	330672000440	22760	Timberlane Regional Middle School	Public School	Regular School	No	Middle	06	08	2021	grade_10	0	0
266911	NH	school	3306660	531	Thornton	330666000433	22380	Thornton Central School		Regular School	No	Elementary	KG	08	2020	grade_10	0.0	0
356250	NH	school	3306660	531	Thornton	330666000433	22380	Thornton Central School	Public School	Regular School	No	Elementary	KG	08	2021	grade_10	0	0
266910	NH	school	3306600	525	Tamworth	330660000432	20365	Kenneth A. Brett School		Regular School	No	Elementary	KG	08	2020	grade_10	0.0	0
352391	NH	school	3306600	525	Tamworth	330660000432	20365	Kenneth A. Brett School	Public School	Regular School	No	Elementary	KG	08	2021	grade_10	0	0
266907	NH	school	3306540	515	Sunapee	330654000430	22005	Sunapee Central School		Regular School	No	Elementary	KG	05	2020	grade_10	0.0	0
266908	NH	school	3306540	515	Sunapee	330654000101	26965	Sunapee Middle High School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
266909	NH	school	3306540	515	Sunapee	330654000431	22000	Sunapee Sr. High School		Regular School	No	High	09	13	2020	grade_10	32.0	32
356046	NH	school	3306540	515	Sunapee	330654000430	22005	Sunapee Central School	Public School	Regular School	No	Elementary	KG	05	2021	grade_10	0	0
356063	NH	school	3306540	515	Sunapee	330654000101	26965	Sunapee Middle High School	Public School	Regular School	No	Middle	06	08	2021	grade_10	0	0
356080	NH	school	3306540	515	Sunapee	330654000431	22000	Sunapee Sr. High School	Public School	Regular School	No	High	09	13	2021	grade_10	37	37
266906	NH	school	3306480	511	Stratham	330648000429	20615	Stratham Memorial School		Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
356012	NH	school	3306480	511	Stratham	330648000429	20615	Stratham Memorial School	Public School	Regular School	No	Elementary	PK	05	2021	grade_10	0	0
266905	NH	school	3306450	509	Stratford	330645000428	22915	Stratford Public School		Regular School	No	Elementary	PK	08	2020	grade_10	0.0	0
355995	NH	school	3306450	509	Stratford	330645000428	22915	Stratford Public School	Public School	Regular School	No	Elementary	PK	08	2021	grade_10	0	0
266904	NH	school	3306420	507	Strafford	330642000427	22100	Strafford School		Regular School	No	Elementary	KG	08	2020	grade_10	0.0	0
355978	NH	school	3306420	507	Strafford	330642000427	22100	Strafford School	Public School	Regular School	No	Elementary	PK	08	2021	grade_10	0	0
266903	NH	school	3306390	503	Stoddard	330639000426	20980	James Faulkner Elementary School		Regular School	No	Elementary	KG	05	2020	grade_10	0.0	0
352102	NH	school	3306390	503	Stoddard	330639000426	20980	James Faulkner Elementary School	Public School	Regular School	No	Elementary	KG	05	2021	grade_10	0	0
266902	NH	school	3306360	501	Stewartstown	330636000579	27560	Stewartstown Community School		Regular School	No	Elementary	PK	08	2020	grade_10	0.0	0
355961	NH	school	3306360	501	Stewartstown	330636000579	27560	Stewartstown Community School	Public School	Regular School	No	Elementary	PK	08	2021	grade_10	0	0
266901	NH	school	3306330	499	Stark	330633000423	22910	Stark Village School		Regular School	No	Elementary	KG	06	2020	grade_10	0.0	0