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 school_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
267941	NH	school		457	Rivendell		29196	Rivendell Academy (E)	Interstate Schools						2020	grade_12	0.0	0
267942	NH	school		457	Rivendell		29197	Rivendell Academy (H)	Interstate Schools						2020	grade_12	15.0	15
353634	NH	school		357	Milford			Milford Early Education Experiences							2021	grade_12	0	0
355198	NH	school		453	Raymond			Raymond School District Preschool Program							2021	grade_12	0	0
355300	NH	school		457	Rivendell		29196	Rivendell Academy (E)	Interstate School						2021	grade_12	0	0
355317	NH	school		457	Rivendell		29197	Rivendell Academy (H)	Interstate School						2021	grade_12	17	17
267834	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School		Regular School	No	High	09	12	2020	grade_12	166.0	166
355045	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School	Public School	Regular School	No	High	09	13	2021	grade_12	160	160
267939	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academies and Joint Maintenance Agreements	Regular School	No	High	09	13	2020	grade_12	674.0	674
354892	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academy	Regular School	No	High	09	13	2021	grade_12	694	694
267938	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_12	179.0	179
349792	NH	school	3307330	998	Coe-Brown Northwood Academy	330733000519	22025	Coe-Brown Northwood Academy	Public Academy	Regular School	No	High	09	12	2021	grade_12	167	167
267935	NH	school	3307300	582	Winnisquam Regional	330730000467	22945	Union Sanborn School		Regular School	No	Elementary	PK	02	2020	grade_12	0.0	0
356371	NH	school	3307300	582	Winnisquam Regional	330730000467	22945	Union Sanborn School	Public School	Regular School	No	Elementary	PK	02	2021	grade_12	0	0
267937	NH	school	3307300	582	Winnisquam Regional	330730000466	22955	Winnisquam Regional Middle School		Regular School	No	Middle	06	08	2020	grade_12	0.0	0
356949	NH	school	3307300	582	Winnisquam Regional	330730000466	22955	Winnisquam Regional Middle School	Public School	Regular School	No	Middle	06	08	2021	grade_12	0	0
267936	NH	school	3307300	582	Winnisquam Regional	330730000465	22950	Winnisquam Regional High School		Regular School	No	High	09	12	2020	grade_12	89.0	89
356932	NH	school	3307300	582	Winnisquam Regional	330730000465	22950	Winnisquam Regional High School	Public School	Regular School	No	High	09	12	2021	grade_12	103	103
267933	NH	school	3307300	582	Winnisquam Regional	330730000464	22925	Sanbornton Central School		Regular School	No	Elementary	KG	05	2020	grade_12	0.0	0
355555	NH	school	3307300	582	Winnisquam Regional	330730000464	22925	Sanbornton Central School	Public School	Regular School	No	Elementary	KG	05	2021	grade_12	0	0
267934	NH	school	3307300	582	Winnisquam Regional	330730000204	27070	Southwick School		Regular School	No	Elementary	03	05	2020	grade_12	0.0	0
355878	NH	school	3307300	582	Winnisquam Regional	330730000204	27070	Southwick School	Public School	Regular School	No	Elementary	03	05	2021	grade_12	0	0
267932	NH	school	3307230	581	Winnacunnet Cooperative	330723000463	20780	Winnacunnet High School		Regular School	No	High	09	13	2020	grade_12	190.0	190
356915	NH	school	3307230	581	Winnacunnet Cooperative	330723000463	20780	Winnacunnet High School	Public School	Regular School	No	High	09	13	2021	grade_12	261	261
267930	NH	school	3307170	575	Windham	330717000692	28640	Windham High School		Regular School	No	High	09	13	2020	grade_12	240.0	240
356881	NH	school	3307170	575	Windham	330717000692	28640	Windham High School	Public School	Regular School	No	High	09	12	2021	grade_12	231	231
267931	NH	school	3307170	575	Windham	330717000495	21125	Windham Middle School		Regular School	No	Middle	07	08	2020	grade_12	0.0	0
356898	NH	school	3307170	575	Windham	330717000495	21125	Windham Middle School	Public School	Regular School	No	Middle	07	08	2021	grade_12	0	0
267928	NH	school	3307170	575	Windham	330717000461	21130	Golden Brook Elementary School		Regular School	No	Elementary	PK	04	2020	grade_12	0.0	0
351016	NH	school	3307170	575	Windham	330717000461	21130	Golden Brook Elementary School	Public School	Regular School	No	Elementary	PK	04	2021	grade_12	0	0
267929	NH	school	3307170	575	Windham	330717000460	21135	Windham Center School		Regular School	No	Middle	05	06	2020	grade_12	0.0	0
356864	NH	school	3307170	575	Windham	330717000460	21135	Windham Center School	Public School	Regular School	No	Middle	05	06	2021	grade_12	0	0
267927	NH	school	3307140	573	Winchester	330714000459	21735	Winchester School		Regular School	No	Elementary	PK	08	2020	grade_12	0.0	0
356830	NH	school	3307140	573	Winchester	330714000459	21735	Winchester School	Public School	Regular School	No	Elementary	PK	08	2021	grade_12	0	0
267926	NH	school	3307115	572	Wilton-Lyndeborough Cooperative	330711500457	23070	Wilton-Lyndeboro Senior High School		Regular School	No	High	09	12	2020	grade_12	29.0	29
356813	NH	school	3307115	572	Wilton-Lyndeborough Cooperative	330711500457	23070	Wilton-Lyndeboro Senior High School	Public School	Regular School	No	High	09	12	2021	grade_12	42	42
267923	NH	school	3307115	572	Wilton-Lyndeborough Cooperative	330711500456	23060	Florence Rideout Elementary School		Regular School	No	Elementary	01	05	2020	grade_12	0.0	0
350693	NH	school	3307115	572	Wilton-Lyndeborough Cooperative	330711500456	23060	Florence Rideout Elementary School	Public School	Regular School	No	Elementary	01	05	2021	grade_12	0	0
267924	NH	school	3307115	572	Wilton-Lyndeborough Cooperative	330711500237	23035	Lyndeborough Central School		Regular School	No	Elementary	PK	KG	2020	grade_12	0.0	0
352971	NH	school	3307115	572	Wilton-Lyndeborough Cooperative	330711500237	23035	Lyndeborough Central School	Public School	Regular School	No	Elementary	PK	KG	2021	grade_12	0	0
267925	NH	school	3307115	572	Wilton-Lyndeborough Cooperative	330711500110	26955	Wilton-Lyndeboro Middle School		Regular School	No	Middle	06	08	2020	grade_12	0.0	0
356796	NH	school	3307115	572	Wilton-Lyndeborough Cooperative	330711500110	26955	Wilton-Lyndeboro Middle School	Public School	Regular School	No	Middle	06	08	2021	grade_12	0	0
267921	NH	school	3307050	568	White Mountains Regional	330705000454	21480	White Mountains Regional High School		Regular School	No	High	09	12	2020	grade_12	81.0	81
356711	NH	school	3307050	568	White Mountains Regional	330705000454	21480	White Mountains Regional High School	Public School	Regular School	No	High	09	13	2021	grade_12	67	67
267920	NH	school	3307050	568	White Mountains Regional	330705000453	21475	Lancaster Elementary School		Regular School	No	Elementary	PK	08	2020	grade_12	0.0	0
352597	NH	school	3307050	568	White Mountains Regional	330705000453	21475	Lancaster Elementary School	Public School	Regular School	No	Elementary	PK	08	2021	grade_12	0	0
267922	NH	school	3307050	568	White Mountains Regional	330705000004	26930	Whitefield Elementary School		Regular School	No	Elementary	PK	08	2020	grade_12	0.0	0
356728	NH	school	3307050	568	White Mountains Regional	330705000004	26930	Whitefield Elementary School	Public School	Regular School	No	Elementary	KG	08	2021	grade_12	0	0
267919	NH	school	3307020	563	Westmoreland	330702000450	21230	Westmoreland School		Regular School	No	Elementary	KG	08	2020	grade_12	0.0	0
356660	NH	school	3307020	563	Westmoreland	330702000450	21230	Westmoreland School	Public School	Regular School	No	Elementary	KG	08	2021	grade_12	0	0
267918	NH	school	3306990	559	Wentworth	330699000449	22390	Wentworth Elementary School		Regular School	No	Elementary	KG	08	2020	grade_12	0.0	0
356626	NH	school	3306990	559	Wentworth	330699000449	22390	Wentworth Elementary School	Public School	Regular School	No	Elementary	KG	08	2021	grade_12	0	0
267916	NH	school	3306930	555	Weare	330693000025	26810	Center Woods School		Regular School	No	Elementary	PK	05	2020	grade_12	0.0	0
349571	NH	school	3306930	555	Weare	330693000025	26810	Center Woods School	Public School	Regular School	No	Elementary	PK	05	2021	grade_12	0	0
267917	NH	school	3306930	555	Weare	330693000023	20720	Weare Middle School		Regular School	No	Middle	06	08	2020	grade_12	0.0	0
356558	NH	school	3306930	555	Weare	330693000023	20720	Weare Middle School	Public School	Regular School	No	Middle	06	08	2021	grade_12	0	0
267915	NH	school	3306910	553	Waterville Valley	330691000446	22385	Waterville Valley Elementary School		Regular School	No	Elementary	KG	08	2020	grade_12	0.0	0
356541	NH	school	3306910	553	Waterville Valley	330691000446	22385	Waterville Valley Elementary School	Public School	Regular School	No	Elementary	KG	08	2021	grade_12	0	0
267914	NH	school	3306900	551	Washington	330690000445	20985	Washington Elementary School		Regular School	No	Elementary	KG	05	2020	grade_12	0.0	0
356524	NH	school	3306900	551	Washington	330690000445	20985	Washington Elementary School	Public School	Regular School	No	Elementary	KG	05	2021	grade_12	0	0
267913	NH	school	3306870	549	Warren	330687000444	20900	Warren Village School		Regular School	No	Elementary	PK	08	2020	grade_12	0.0	0
356507	NH	school	3306870	549	Warren	330687000444	20900	Warren Village School	Public School	Regular School	No	Elementary	PK	08	2021	grade_12	0	0
267912	NH	school	3306780	543	Wakefield	330678000442	22110	Paul Elementary School		Regular School	No	Elementary	PK	08	2020	grade_12	0.0	0
354671	NH	school	3306780	543	Wakefield	330678000442	22110	Paul Elementary School	Public School	Regular School	No	Elementary	PK	08	2021	grade_12	0	0
267911	NH	school	3306750	539	Unity	330675000441	20180	Unity Elementary School		Regular School	No	Elementary	PK	08	2020	grade_12	0.0	0
356388	NH	school	3306750	539	Unity	330675000441	20180	Unity Elementary School	Public School	Regular School	No	Elementary	PK	08	2021	grade_12	0	0
267908	NH	school	3306720	534	Timberlane Regional	330672000596	27910	Sandown North Elementary School		Regular School	No	Elementary	01	05	2020	grade_12	0.0	0
355589	NH	school	3306720	534	Timberlane Regional	330672000596	27910	Sandown North Elementary School	Public School	Regular School	No	Elementary	01	05	2021	grade_12	0	0
267910	NH	school	3306720	534	Timberlane Regional	330672000440	22760	Timberlane Regional Middle School		Regular School	No	Middle	06	08	2020	grade_12	0.0	0
356320	NH	school	3306720	534	Timberlane Regional	330672000440	22760	Timberlane Regional Middle School	Public School	Regular School	No	Middle	06	08	2021	grade_12	0	0
267909	NH	school	3306720	534	Timberlane Regional	330672000439	22770	Timberlane Regional High School		Regular School	No	High	09	12	2020	grade_12	292.0	292
356303	NH	school	3306720	534	Timberlane Regional	330672000439	22770	Timberlane Regional High School	Public School	Regular School	No	High	09	12	2021	grade_12	284	284
267907	NH	school	3306720	534	Timberlane Regional	330672000438	22775	Sandown Central School		Regular School	No	Elementary	PK	KG	2020	grade_12	0.0	0
355572	NH	school	3306720	534	Timberlane Regional	330672000438	22775	Sandown Central School	Public School	Regular School	No	Elementary	PK	KG	2021	grade_12	0	0
267906	NH	school	3306720	534	Timberlane Regional	330672000436	22765	Pollard Elementary School		Regular School	No	Elementary	PK	05	2020	grade_12	0.0	0
355079	NH	school	3306720	534	Timberlane Regional	330672000436	22765	Pollard Elementary School	Public School	Regular School	No	Elementary	PK	05	2021	grade_12	0	0
267905	NH	school	3306720	534	Timberlane Regional	330672000435	22745	Danville Elementary School		Regular School	No	Elementary	PK	05	2020	grade_12	0.0	0
350081	NH	school	3306720	534	Timberlane Regional	330672000435	22745	Danville Elementary School	Public School	Regular School	No	Elementary	PK	05	2021	grade_12	0	0
267904	NH	school	3306720	534	Timberlane Regional	330672000434	22740	Atkinson Academy		Regular School	No	Elementary	PK	05	2020	grade_12	0.0	0
348908	NH	school	3306720	534	Timberlane Regional	330672000434	22740	Atkinson Academy	Public School	Regular School	No	Elementary	PK	05	2021	grade_12	0	0
267903	NH	school	3306660	531	Thornton	330666000433	22380	Thornton Central School		Regular School	No	Elementary	KG	08	2020	grade_12	0.0	0
356252	NH	school	3306660	531	Thornton	330666000433	22380	Thornton Central School	Public School	Regular School	No	Elementary	KG	08	2021	grade_12	0	0
267902	NH	school	3306600	525	Tamworth	330660000432	20365	Kenneth A. Brett School		Regular School	No	Elementary	KG	08	2020	grade_12	0.0	0
352393	NH	school	3306600	525	Tamworth	330660000432	20365	Kenneth A. Brett School	Public School	Regular School	No	Elementary	KG	08	2021	grade_12	0	0
267901	NH	school	3306540	515	Sunapee	330654000431	22000	Sunapee Sr. High School		Regular School	No	High	09	13	2020	grade_12	35.0	35
356082	NH	school	3306540	515	Sunapee	330654000431	22000	Sunapee Sr. High School	Public School	Regular School	No	High	09	13	2021	grade_12	37	37
267899	NH	school	3306540	515	Sunapee	330654000430	22005	Sunapee Central School		Regular School	No	Elementary	KG	05	2020	grade_12	0.0	0
356048	NH	school	3306540	515	Sunapee	330654000430	22005	Sunapee Central School	Public School	Regular School	No	Elementary	KG	05	2021	grade_12	0	0
267900	NH	school	3306540	515	Sunapee	330654000101	26965	Sunapee Middle High School		Regular School	No	Middle	06	08	2020	grade_12	0.0	0
356065	NH	school	3306540	515	Sunapee	330654000101	26965	Sunapee Middle High School	Public School	Regular School	No	Middle	06	08	2021	grade_12	0	0
267898	NH	school	3306480	511	Stratham	330648000429	20615	Stratham Memorial School		Regular School	No	Elementary	PK	05	2020	grade_12	0.0	0
356014	NH	school	3306480	511	Stratham	330648000429	20615	Stratham Memorial School	Public School	Regular School	No	Elementary	PK	05	2021	grade_12	0	0
267897	NH	school	3306450	509	Stratford	330645000428	22915	Stratford Public School		Regular School	No	Elementary	PK	08	2020	grade_12	0.0	0
355997	NH	school	3306450	509	Stratford	330645000428	22915	Stratford Public School	Public School	Regular School	No	Elementary	PK	08	2021	grade_12	0	0
267896	NH	school	3306420	507	Strafford	330642000427	22100	Strafford School		Regular School	No	Elementary	KG	08	2020	grade_12	0.0	0
355980	NH	school	3306420	507	Strafford	330642000427	22100	Strafford School	Public School	Regular School	No	Elementary	PK	08	2021	grade_12	0	0
267895	NH	school	3306390	503	Stoddard	330639000426	20980	James Faulkner Elementary School		Regular School	No	Elementary	KG	05	2020	grade_12	0.0	0
352104	NH	school	3306390	503	Stoddard	330639000426	20980	James Faulkner Elementary School	Public School	Regular School	No	Elementary	KG	05	2021	grade_12	0	0
267894	NH	school	3306360	501	Stewartstown	330636000579	27560	Stewartstown Community School		Regular School	No	Elementary	PK	08	2020	grade_12	0.0	0
355963	NH	school	3306360	501	Stewartstown	330636000579	27560	Stewartstown Community School	Public School	Regular School	No	Elementary	PK	08	2021	grade_12	0	0
267893	NH	school	3306330	499	Stark	330633000423	22910	Stark Village School		Regular School	No	Elementary	KG	06	2020	grade_12	0.0	0