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 "state" = :p0 and (district_nces_id < :p2 or district_nces_id is null or (district_nces_id = :p2 and rowid > :p1)) order by district_nces_id desc, rowid 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
355329	NH	school		457	Rivendell		29197	Rivendell Academy (H)	Interstate School						2021	pre_kindergarten	0	0
355330	NH	school		457	Rivendell		29197	Rivendell Academy (H)	Interstate School						2021	readiness	0	0
260890	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School		Regular School	No	High	09	12	2020	pre_kindergarten	0.0	0
261386	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School		Regular School	No	High	09	12	2020	kindergarten	0.0	0
261882	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School		Regular School	No	High	09	12	2020	readiness	0.0	0
262378	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School		Regular School	No	High	09	12	2020	grade_1	0.0	0
262874	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School		Regular School	No	High	09	12	2020	grade_2	0.0	0
263370	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School		Regular School	No	High	09	12	2020	grade_3	0.0	0
263866	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School		Regular School	No	High	09	12	2020	grade_4	0.0	0
264362	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School		Regular School	No	High	09	12	2020	grade_5	0.0	0
264858	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School		Regular School	No	High	09	12	2020	grade_6	0.0	0
265354	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School		Regular School	No	High	09	12	2020	grade_7	0.0	0
265850	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School		Regular School	No	High	09	12	2020	grade_8	0.0	0
266346	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School		Regular School	No	High	09	12	2020	grade_9	153.0	153
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
267338	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School		Regular School	No	High	09	12	2020	grade_11	162.0	162
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
268330	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School		Regular School	No	High	09	12	2020	post_graduate	0.0	0
268826	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School		Regular School	No	High	09	12	2020	pk_12_total	635.0	635
355042	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School	Public School	Regular School	No	High	09	13	2021	grade_1	0	0
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
355044	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School	Public School	Regular School	No	High	09	13	2021	grade_11	149	149
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
355046	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School	Public School	Regular School	No	High	09	13	2021	grade_2	0	0
355047	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School	Public School	Regular School	No	High	09	13	2021	grade_3	0	0
355048	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School	Public School	Regular School	No	High	09	13	2021	grade_4	0	0
355049	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School	Public School	Regular School	No	High	09	13	2021	grade_5	0	0
355050	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School	Public School	Regular School	No	High	09	13	2021	grade_6	0	0
355051	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School	Public School	Regular School	No	High	09	13	2021	grade_7	0	0
355052	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School	Public School	Regular School	No	High	09	13	2021	grade_8	0	0
355053	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School	Public School	Regular School	No	High	09	13	2021	grade_9	176	176
355054	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School	Public School	Regular School	No	High	09	13	2021	kindergarten	0	0
355055	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School	Public School	Regular School	No	High	09	13	2021	pk_12_total	639	639
355056	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School	Public School	Regular School	No	High	09	13	2021	post_graduate	2	2
355057	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School	Public School	Regular School	No	High	09	13	2021	pre_kindergarten	0	0
355058	NH	school	3399965	428	Pemi-Baker Regional	339996500369	22350	Plymouth Regional High School	Public School	Regular School	No	High	09	13	2021	readiness	0	0
260995	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academies and Joint Maintenance Agreements	Regular School	No	High	09	13	2020	pre_kindergarten	0.0	0
261491	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academies and Joint Maintenance Agreements	Regular School	No	High	09	13	2020	kindergarten	0.0	0
261987	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academies and Joint Maintenance Agreements	Regular School	No	High	09	13	2020	readiness	0.0	0
262483	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academies and Joint Maintenance Agreements	Regular School	No	High	09	13	2020	grade_1	0.0	0
262979	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academies and Joint Maintenance Agreements	Regular School	No	High	09	13	2020	grade_2	0.0	0
263475	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academies and Joint Maintenance Agreements	Regular School	No	High	09	13	2020	grade_3	0.0	0
263971	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academies and Joint Maintenance Agreements	Regular School	No	High	09	13	2020	grade_4	0.0	0
264467	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academies and Joint Maintenance Agreements	Regular School	No	High	09	13	2020	grade_5	0.0	0
264963	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academies and Joint Maintenance Agreements	Regular School	No	High	09	13	2020	grade_6	0.0	0
265459	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academies and Joint Maintenance Agreements	Regular School	No	High	09	13	2020	grade_7	0.0	0
265955	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academies and Joint Maintenance Agreements	Regular School	No	High	09	13	2020	grade_8	0.0	0
266451	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academies and Joint Maintenance Agreements	Regular School	No	High	09	13	2020	grade_9	864.0	864
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
267443	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academies and Joint Maintenance Agreements	Regular School	No	High	09	13	2020	grade_11	797.0	797
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
268435	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academies and Joint Maintenance Agreements	Regular School	No	High	09	13	2020	post_graduate	10.0	10
268931	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academies and Joint Maintenance Agreements	Regular School	No	High	09	13	2020	pk_12_total	3141.0	3141
354889	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academy	Regular School	No	High	09	13	2021	grade_1	0	0
354890	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academy	Regular School	No	High	09	13	2021	grade_10	757	757
354891	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academy	Regular School	No	High	09	13	2021	grade_11	773	773
354892	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academy	Regular School	No	High	09	13	2021	grade_12	694	694
354893	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academy	Regular School	No	High	09	13	2021	grade_2	0	0
354894	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academy	Regular School	No	High	09	13	2021	grade_3	0	0
354895	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academy	Regular School	No	High	09	13	2021	grade_4	0	0
354896	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academy	Regular School	No	High	09	13	2021	grade_5	0	0
354897	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academy	Regular School	No	High	09	13	2021	grade_6	0	0
354898	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academy	Regular School	No	High	09	13	2021	grade_7	0	0
354899	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academy	Regular School	No	High	09	13	2021	grade_8	0	0
354900	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academy	Regular School	No	High	09	13	2021	grade_9	929	929
354901	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academy	Regular School	No	High	09	13	2021	kindergarten	0	0
354902	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academy	Regular School	No	High	09	13	2021	pk_12_total	3163	3163
354903	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academy	Regular School	No	High	09	13	2021	post_graduate	10	10
354904	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academy	Regular School	No	High	09	13	2021	pre_kindergarten	0	0
354905	NH	school	3307360	999	Pinkerton Academy	330736000510	20395	Pinkerton Academy	Public Academy	Regular School	No	High	09	13	2021	readiness	0	0
260994	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	pre_kindergarten	0.0	0
261490	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	kindergarten	0.0	0
261986	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	readiness	0.0	0
262482	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_1	0.0	0
262978	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_2	0.0	0
263474	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_3	0.0	0
263970	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_4	0.0	0
264466	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_5	0.0	0
264962	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_6	0.0	0
265458	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_7	0.0	0
265954	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_8	0.0	0
266450	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_9	182.0	182
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
267442	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_11	173.0	173
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
268434	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	post_graduate	0.0	0
268930	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	pk_12_total	690.0	690
349789	NH	school	3307330	998	Coe-Brown Northwood Academy	330733000519	22025	Coe-Brown Northwood Academy	Public Academy	Regular School	No	High	09	12	2021	grade_1	0	0
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
349791	NH	school	3307330	998	Coe-Brown Northwood Academy	330733000519	22025	Coe-Brown Northwood Academy	Public Academy	Regular School	No	High	09	12	2021	grade_11	159	159
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
349793	NH	school	3307330	998	Coe-Brown Northwood Academy	330733000519	22025	Coe-Brown Northwood Academy	Public Academy	Regular School	No	High	09	12	2021	grade_2	0	0
349794	NH	school	3307330	998	Coe-Brown Northwood Academy	330733000519	22025	Coe-Brown Northwood Academy	Public Academy	Regular School	No	High	09	12	2021	grade_3	0	0
349795	NH	school	3307330	998	Coe-Brown Northwood Academy	330733000519	22025	Coe-Brown Northwood Academy	Public Academy	Regular School	No	High	09	12	2021	grade_4	0	0
349796	NH	school	3307330	998	Coe-Brown Northwood Academy	330733000519	22025	Coe-Brown Northwood Academy	Public Academy	Regular School	No	High	09	12	2021	grade_5	0	0
349797	NH	school	3307330	998	Coe-Brown Northwood Academy	330733000519	22025	Coe-Brown Northwood Academy	Public Academy	Regular School	No	High	09	12	2021	grade_6	0	0
349798	NH	school	3307330	998	Coe-Brown Northwood Academy	330733000519	22025	Coe-Brown Northwood Academy	Public Academy	Regular School	No	High	09	12	2021	grade_7	0	0
349799	NH	school	3307330	998	Coe-Brown Northwood Academy	330733000519	22025	Coe-Brown Northwood Academy	Public Academy	Regular School	No	High	09	12	2021	grade_8	0	0
349800	NH	school	3307330	998	Coe-Brown Northwood Academy	330733000519	22025	Coe-Brown Northwood Academy	Public Academy	Regular School	No	High	09	12	2021	grade_9	176	176
349801	NH	school	3307330	998	Coe-Brown Northwood Academy	330733000519	22025	Coe-Brown Northwood Academy	Public Academy	Regular School	No	High	09	12	2021	kindergarten	0	0
349802	NH	school	3307330	998	Coe-Brown Northwood Academy	330733000519	22025	Coe-Brown Northwood Academy	Public Academy	Regular School	No	High	09	12	2021	pk_12_total	673	673