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 order by ccd_school_high_grade 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	ccd_school_type	ccd_charter_school	ccd_school_lvl	ccd_school_low_grade	ccd_school_high_grade	year	grade	total	total_int
260578	NH	school	3302340	101	Claremont	330234000724	29184	Claremont Preschool Center	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	64.0	64
260641	NH	school	3302990	174	Fall Mountain Regional	330299000259	27395	Fall Mountain Regional -Pre School Program	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	15.0	15
260724	NH	school	3304040	276	Kearsarge Regional	330404000687	26565	James House Preschool	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	35.0	35
260733	NH	school	3304050	279	Keene	330405000723	29180	Jonathan Daniels School	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	114.0	114
260851	NH	school	3304980	371	Nashua	330498000714	29152	Nashua Title I Preschool	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	46.0	46
260854	NH	school	3304980	371	Nashua	330498000682	28610	Purple Panthers Preschool	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	35.0	35
260883	NH	school	3305520	423	Oyster River Coop	330552000735	29210	Oyster River Preschool Education Program	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	34.0	34
260902	NH	school	3305820	449	Portsmouth	330582000547	22560	PEEP School - Pre School Program	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	16.0	16
260929	NH	school	3306060	473	Salem	330606000740	29225	Salem Preschool	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	87.0	87
261074	NH	school	3302340	101	Claremont	330234000724	29184	Claremont Preschool Center	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten	0.0	0
261137	NH	school	3302990	174	Fall Mountain Regional	330299000259	27395	Fall Mountain Regional -Pre School Program	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten	0.0	0
261220	NH	school	3304040	276	Kearsarge Regional	330404000687	26565	James House Preschool	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten	0.0	0
261229	NH	school	3304050	279	Keene	330405000723	29180	Jonathan Daniels School	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten	0.0	0
261347	NH	school	3304980	371	Nashua	330498000714	29152	Nashua Title I Preschool	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten	0.0	0
261350	NH	school	3304980	371	Nashua	330498000682	28610	Purple Panthers Preschool	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten	0.0	0
261379	NH	school	3305520	423	Oyster River Coop	330552000735	29210	Oyster River Preschool Education Program	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten	0.0	0
261398	NH	school	3305820	449	Portsmouth	330582000547	22560	PEEP School - Pre School Program	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten	0.0	0
261425	NH	school	3306060	473	Salem	330606000740	29225	Salem Preschool	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten	0.0	0
261570	NH	school	3302340	101	Claremont	330234000724	29184	Claremont Preschool Center	Regular School	No	Prekindergarten	PK	PK	2020	readiness	0.0	0
261633	NH	school	3302990	174	Fall Mountain Regional	330299000259	27395	Fall Mountain Regional -Pre School Program	Regular School	No	Prekindergarten	PK	PK	2020	readiness	0.0	0
261716	NH	school	3304040	276	Kearsarge Regional	330404000687	26565	James House Preschool	Regular School	No	Prekindergarten	PK	PK	2020	readiness	0.0	0
261725	NH	school	3304050	279	Keene	330405000723	29180	Jonathan Daniels School	Regular School	No	Prekindergarten	PK	PK	2020	readiness	0.0	0
261843	NH	school	3304980	371	Nashua	330498000714	29152	Nashua Title I Preschool	Regular School	No	Prekindergarten	PK	PK	2020	readiness	0.0	0
261846	NH	school	3304980	371	Nashua	330498000682	28610	Purple Panthers Preschool	Regular School	No	Prekindergarten	PK	PK	2020	readiness	0.0	0
261875	NH	school	3305520	423	Oyster River Coop	330552000735	29210	Oyster River Preschool Education Program	Regular School	No	Prekindergarten	PK	PK	2020	readiness	0.0	0
261894	NH	school	3305820	449	Portsmouth	330582000547	22560	PEEP School - Pre School Program	Regular School	No	Prekindergarten	PK	PK	2020	readiness	0.0	0
261921	NH	school	3306060	473	Salem	330606000740	29225	Salem Preschool	Regular School	No	Prekindergarten	PK	PK	2020	readiness	0.0	0
262066	NH	school	3302340	101	Claremont	330234000724	29184	Claremont Preschool Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0.0	0
262129	NH	school	3302990	174	Fall Mountain Regional	330299000259	27395	Fall Mountain Regional -Pre School Program	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0.0	0
262212	NH	school	3304040	276	Kearsarge Regional	330404000687	26565	James House Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0.0	0
262221	NH	school	3304050	279	Keene	330405000723	29180	Jonathan Daniels School	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0.0	0
262339	NH	school	3304980	371	Nashua	330498000714	29152	Nashua Title I Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0.0	0
262342	NH	school	3304980	371	Nashua	330498000682	28610	Purple Panthers Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0.0	0
262371	NH	school	3305520	423	Oyster River Coop	330552000735	29210	Oyster River Preschool Education Program	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0.0	0
262390	NH	school	3305820	449	Portsmouth	330582000547	22560	PEEP School - Pre School Program	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0.0	0
262417	NH	school	3306060	473	Salem	330606000740	29225	Salem Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0.0	0
262562	NH	school	3302340	101	Claremont	330234000724	29184	Claremont Preschool Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0.0	0
262625	NH	school	3302990	174	Fall Mountain Regional	330299000259	27395	Fall Mountain Regional -Pre School Program	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0.0	0
262708	NH	school	3304040	276	Kearsarge Regional	330404000687	26565	James House Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0.0	0
262717	NH	school	3304050	279	Keene	330405000723	29180	Jonathan Daniels School	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0.0	0
262835	NH	school	3304980	371	Nashua	330498000714	29152	Nashua Title I Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0.0	0
262838	NH	school	3304980	371	Nashua	330498000682	28610	Purple Panthers Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0.0	0
262867	NH	school	3305520	423	Oyster River Coop	330552000735	29210	Oyster River Preschool Education Program	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0.0	0
262886	NH	school	3305820	449	Portsmouth	330582000547	22560	PEEP School - Pre School Program	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0.0	0
262913	NH	school	3306060	473	Salem	330606000740	29225	Salem Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0.0	0
263058	NH	school	3302340	101	Claremont	330234000724	29184	Claremont Preschool Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0.0	0
263121	NH	school	3302990	174	Fall Mountain Regional	330299000259	27395	Fall Mountain Regional -Pre School Program	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0.0	0
263204	NH	school	3304040	276	Kearsarge Regional	330404000687	26565	James House Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0.0	0
263213	NH	school	3304050	279	Keene	330405000723	29180	Jonathan Daniels School	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0.0	0
263331	NH	school	3304980	371	Nashua	330498000714	29152	Nashua Title I Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0.0	0
263334	NH	school	3304980	371	Nashua	330498000682	28610	Purple Panthers Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0.0	0
263363	NH	school	3305520	423	Oyster River Coop	330552000735	29210	Oyster River Preschool Education Program	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0.0	0
263382	NH	school	3305820	449	Portsmouth	330582000547	22560	PEEP School - Pre School Program	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0.0	0
263409	NH	school	3306060	473	Salem	330606000740	29225	Salem Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0.0	0
263554	NH	school	3302340	101	Claremont	330234000724	29184	Claremont Preschool Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0.0	0
263617	NH	school	3302990	174	Fall Mountain Regional	330299000259	27395	Fall Mountain Regional -Pre School Program	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0.0	0
263700	NH	school	3304040	276	Kearsarge Regional	330404000687	26565	James House Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0.0	0
263709	NH	school	3304050	279	Keene	330405000723	29180	Jonathan Daniels School	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0.0	0
263827	NH	school	3304980	371	Nashua	330498000714	29152	Nashua Title I Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0.0	0
263830	NH	school	3304980	371	Nashua	330498000682	28610	Purple Panthers Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0.0	0
263859	NH	school	3305520	423	Oyster River Coop	330552000735	29210	Oyster River Preschool Education Program	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0.0	0
263878	NH	school	3305820	449	Portsmouth	330582000547	22560	PEEP School - Pre School Program	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0.0	0
263905	NH	school	3306060	473	Salem	330606000740	29225	Salem Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0.0	0
264050	NH	school	3302340	101	Claremont	330234000724	29184	Claremont Preschool Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	0.0	0
264113	NH	school	3302990	174	Fall Mountain Regional	330299000259	27395	Fall Mountain Regional -Pre School Program	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	0.0	0
264196	NH	school	3304040	276	Kearsarge Regional	330404000687	26565	James House Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	0.0	0
264205	NH	school	3304050	279	Keene	330405000723	29180	Jonathan Daniels School	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	0.0	0
264323	NH	school	3304980	371	Nashua	330498000714	29152	Nashua Title I Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	0.0	0
264326	NH	school	3304980	371	Nashua	330498000682	28610	Purple Panthers Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	0.0	0
264355	NH	school	3305520	423	Oyster River Coop	330552000735	29210	Oyster River Preschool Education Program	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	0.0	0
264374	NH	school	3305820	449	Portsmouth	330582000547	22560	PEEP School - Pre School Program	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	0.0	0
264401	NH	school	3306060	473	Salem	330606000740	29225	Salem Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	0.0	0
264546	NH	school	3302340	101	Claremont	330234000724	29184	Claremont Preschool Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_6	0.0	0
264609	NH	school	3302990	174	Fall Mountain Regional	330299000259	27395	Fall Mountain Regional -Pre School Program	Regular School	No	Prekindergarten	PK	PK	2020	grade_6	0.0	0
264692	NH	school	3304040	276	Kearsarge Regional	330404000687	26565	James House Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_6	0.0	0
264701	NH	school	3304050	279	Keene	330405000723	29180	Jonathan Daniels School	Regular School	No	Prekindergarten	PK	PK	2020	grade_6	0.0	0
264819	NH	school	3304980	371	Nashua	330498000714	29152	Nashua Title I Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_6	0.0	0
264822	NH	school	3304980	371	Nashua	330498000682	28610	Purple Panthers Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_6	0.0	0
264851	NH	school	3305520	423	Oyster River Coop	330552000735	29210	Oyster River Preschool Education Program	Regular School	No	Prekindergarten	PK	PK	2020	grade_6	0.0	0
264870	NH	school	3305820	449	Portsmouth	330582000547	22560	PEEP School - Pre School Program	Regular School	No	Prekindergarten	PK	PK	2020	grade_6	0.0	0
264897	NH	school	3306060	473	Salem	330606000740	29225	Salem Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_6	0.0	0
265042	NH	school	3302340	101	Claremont	330234000724	29184	Claremont Preschool Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_7	0.0	0
265105	NH	school	3302990	174	Fall Mountain Regional	330299000259	27395	Fall Mountain Regional -Pre School Program	Regular School	No	Prekindergarten	PK	PK	2020	grade_7	0.0	0
265188	NH	school	3304040	276	Kearsarge Regional	330404000687	26565	James House Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_7	0.0	0
265197	NH	school	3304050	279	Keene	330405000723	29180	Jonathan Daniels School	Regular School	No	Prekindergarten	PK	PK	2020	grade_7	0.0	0
265315	NH	school	3304980	371	Nashua	330498000714	29152	Nashua Title I Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_7	0.0	0
265318	NH	school	3304980	371	Nashua	330498000682	28610	Purple Panthers Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_7	0.0	0
265347	NH	school	3305520	423	Oyster River Coop	330552000735	29210	Oyster River Preschool Education Program	Regular School	No	Prekindergarten	PK	PK	2020	grade_7	0.0	0
265366	NH	school	3305820	449	Portsmouth	330582000547	22560	PEEP School - Pre School Program	Regular School	No	Prekindergarten	PK	PK	2020	grade_7	0.0	0
265393	NH	school	3306060	473	Salem	330606000740	29225	Salem Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_7	0.0	0
265538	NH	school	3302340	101	Claremont	330234000724	29184	Claremont Preschool Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_8	0.0	0
265601	NH	school	3302990	174	Fall Mountain Regional	330299000259	27395	Fall Mountain Regional -Pre School Program	Regular School	No	Prekindergarten	PK	PK	2020	grade_8	0.0	0
265684	NH	school	3304040	276	Kearsarge Regional	330404000687	26565	James House Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_8	0.0	0
265693	NH	school	3304050	279	Keene	330405000723	29180	Jonathan Daniels School	Regular School	No	Prekindergarten	PK	PK	2020	grade_8	0.0	0
265811	NH	school	3304980	371	Nashua	330498000714	29152	Nashua Title I Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_8	0.0	0
265814	NH	school	3304980	371	Nashua	330498000682	28610	Purple Panthers Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_8	0.0	0
265843	NH	school	3305520	423	Oyster River Coop	330552000735	29210	Oyster River Preschool Education Program	Regular School	No	Prekindergarten	PK	PK	2020	grade_8	0.0	0
265862	NH	school	3305820	449	Portsmouth	330582000547	22560	PEEP School - Pre School Program	Regular School	No	Prekindergarten	PK	PK	2020	grade_8	0.0	0
265889	NH	school	3306060	473	Salem	330606000740	29225	Salem Preschool	Regular School	No	Prekindergarten	PK	PK	2020	grade_8	0.0	0
266034	NH	school	3302340	101	Claremont	330234000724	29184	Claremont Preschool Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_9	0.0	0
266097	NH	school	3302990	174	Fall Mountain Regional	330299000259	27395	Fall Mountain Regional -Pre School Program	Regular School	No	Prekindergarten	PK	PK	2020	grade_9	0.0	0