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 school_nces_id 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
260723	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School		Regular School	No	High	09	12	2020	pre_kindergarten	0.0	0
261219	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School		Regular School	No	High	09	12	2020	kindergarten	0.0	0
261715	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School		Regular School	No	High	09	12	2020	readiness	0.0	0
262211	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School		Regular School	No	High	09	12	2020	grade_1	0.0	0
262707	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School		Regular School	No	High	09	12	2020	grade_2	0.0	0
263203	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School		Regular School	No	High	09	12	2020	grade_3	0.0	0
263699	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School		Regular School	No	High	09	12	2020	grade_4	0.0	0
264195	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School		Regular School	No	High	09	12	2020	grade_5	0.0	0
264691	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School		Regular School	No	High	09	12	2020	grade_6	0.0	0
265187	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School		Regular School	No	High	09	12	2020	grade_7	0.0	0
265683	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School		Regular School	No	High	09	12	2020	grade_8	0.0	0
266179	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School		Regular School	No	High	09	12	2020	grade_9	146.0	146
266675	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School		Regular School	No	High	09	12	2020	grade_10	143.0	143
267171	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School		Regular School	No	High	09	12	2020	grade_11	175.0	175
267667	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School		Regular School	No	High	09	12	2020	grade_12	146.0	146
268163	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School		Regular School	No	High	09	12	2020	post_graduate	0.0	0
268659	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School		Regular School	No	High	09	12	2020	pk_12_total	610.0	610
352237	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School	Public School	Regular School	No	High	09	12	2021	grade_1	0	0
352238	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School	Public School	Regular School	No	High	09	12	2021	grade_10	146	146
352239	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School	Public School	Regular School	No	High	09	12	2021	grade_11	132	132
352240	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School	Public School	Regular School	No	High	09	12	2021	grade_12	169	169
352241	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School	Public School	Regular School	No	High	09	12	2021	grade_2	0	0
352242	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School	Public School	Regular School	No	High	09	12	2021	grade_3	0	0
352243	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School	Public School	Regular School	No	High	09	12	2021	grade_4	0	0
352244	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School	Public School	Regular School	No	High	09	12	2021	grade_5	0	0
352245	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School	Public School	Regular School	No	High	09	12	2021	grade_6	0	0
352246	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School	Public School	Regular School	No	High	09	12	2021	grade_7	0	0
352247	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School	Public School	Regular School	No	High	09	12	2021	grade_8	0	0
352248	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School	Public School	Regular School	No	High	09	12	2021	grade_9	167	167
352249	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School	Public School	Regular School	No	High	09	12	2021	kindergarten	0	0
352250	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School	Public School	Regular School	No	High	09	12	2021	pk_12_total	614	614
352251	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School	Public School	Regular School	No	High	09	12	2021	post_graduate	0	0
352252	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School	Public School	Regular School	No	High	09	12	2021	pre_kindergarten	0	0
352253	NH	school	3300003	275	John Stark Regional	330000300500	26380	John Stark Regional High School	Public School	Regular School	No	High	09	12	2021	readiness	0	0
260633	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School		Regular School	No	High	09	13	2020	pre_kindergarten	0.0	0
261129	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School		Regular School	No	High	09	13	2020	kindergarten	0.0	0
261625	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School		Regular School	No	High	09	13	2020	readiness	0.0	0
262121	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School		Regular School	No	High	09	13	2020	grade_1	0.0	0
262617	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School		Regular School	No	High	09	13	2020	grade_2	0.0	0
263113	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School		Regular School	No	High	09	13	2020	grade_3	0.0	0
263609	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School		Regular School	No	High	09	13	2020	grade_4	0.0	0
264105	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School		Regular School	No	High	09	13	2020	grade_5	0.0	0
264601	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School		Regular School	No	High	09	13	2020	grade_6	0.0	0
265097	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School		Regular School	No	High	09	13	2020	grade_7	0.0	0
265593	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School		Regular School	No	High	09	13	2020	grade_8	0.0	0
266089	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School		Regular School	No	High	09	13	2020	grade_9	437.0	437
266585	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School		Regular School	No	High	09	13	2020	grade_10	392.0	392
267081	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School		Regular School	No	High	09	13	2020	grade_11	409.0	409
267577	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School		Regular School	No	High	09	13	2020	grade_12	404.0	404
268073	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School		Regular School	No	High	09	13	2020	post_graduate	1.0	1
268569	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School		Regular School	No	High	09	13	2020	pk_12_total	1643.0	1643
350588	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School	Public School	Regular School	No	High	09	12	2021	grade_1	0	0
350589	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School	Public School	Regular School	No	High	09	12	2021	grade_10	420	420
350590	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School	Public School	Regular School	No	High	09	12	2021	grade_11	384	384
350591	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School	Public School	Regular School	No	High	09	12	2021	grade_12	400	400
350592	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School	Public School	Regular School	No	High	09	12	2021	grade_2	0	0
350593	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School	Public School	Regular School	No	High	09	12	2021	grade_3	0	0
350594	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School	Public School	Regular School	No	High	09	12	2021	grade_4	0	0
350595	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School	Public School	Regular School	No	High	09	12	2021	grade_5	0	0
350596	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School	Public School	Regular School	No	High	09	12	2021	grade_6	0	0
350597	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School	Public School	Regular School	No	High	09	12	2021	grade_7	0	0
350598	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School	Public School	Regular School	No	High	09	12	2021	grade_8	0	0
350599	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School	Public School	Regular School	No	High	09	12	2021	grade_9	368	368
350600	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School	Public School	Regular School	No	High	09	12	2021	kindergarten	0	0
350601	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School	Public School	Regular School	No	High	09	12	2021	pk_12_total	1572	1572
350602	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School	Public School	Regular School	No	High	09	12	2021	post_graduate	0	0
350603	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School	Public School	Regular School	No	High	09	12	2021	pre_kindergarten	0	0
350604	NH	school	3300017	172	Exeter Region Cooperative	330001700106	20600	Exeter High School	Public School	Regular School	No	High	09	12	2021	readiness	0	0
260632	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School		Regular School	No	Middle	06	08	2020	pre_kindergarten	0.0	0
261128	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School		Regular School	No	Middle	06	08	2020	kindergarten	0.0	0
261624	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School		Regular School	No	Middle	06	08	2020	readiness	0.0	0
262120	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School		Regular School	No	Middle	06	08	2020	grade_1	0.0	0
262616	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School		Regular School	No	Middle	06	08	2020	grade_2	0.0	0
263112	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School		Regular School	No	Middle	06	08	2020	grade_3	0.0	0
263608	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School		Regular School	No	Middle	06	08	2020	grade_4	0.0	0
264104	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School		Regular School	No	Middle	06	08	2020	grade_5	0.0	0
264600	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School		Regular School	No	Middle	06	08	2020	grade_6	356.0	356
265096	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School		Regular School	No	Middle	06	08	2020	grade_7	387.0	387
265592	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School		Regular School	No	Middle	06	08	2020	grade_8	373.0	373
266088	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School		Regular School	No	Middle	06	08	2020	grade_9	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
267080	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School		Regular School	No	Middle	06	08	2020	grade_11	0.0	0
267576	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School		Regular School	No	Middle	06	08	2020	grade_12	0.0	0
268072	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School		Regular School	No	Middle	06	08	2020	post_graduate	0.0	0
268568	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School		Regular School	No	Middle	06	08	2020	pk_12_total	1116.0	1116
349942	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School	Public School	Regular School	No	Middle	06	08	2021	grade_1	0	0
349943	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School	Public School	Regular School	No	Middle	06	08	2021	grade_10	0	0
349944	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School	Public School	Regular School	No	Middle	06	08	2021	grade_11	0	0
349945	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School	Public School	Regular School	No	Middle	06	08	2021	grade_12	0	0
349946	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School	Public School	Regular School	No	Middle	06	08	2021	grade_2	0	0
349947	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School	Public School	Regular School	No	Middle	06	08	2021	grade_3	0	0
349948	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School	Public School	Regular School	No	Middle	06	08	2021	grade_4	0	0
349949	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School	Public School	Regular School	No	Middle	06	08	2021	grade_5	0	0
349950	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School	Public School	Regular School	No	Middle	06	08	2021	grade_6	338	338
349951	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School	Public School	Regular School	No	Middle	06	08	2021	grade_7	335	335
349952	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School	Public School	Regular School	No	Middle	06	08	2021	grade_8	384	384
349953	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School	Public School	Regular School	No	Middle	06	08	2021	grade_9	0	0
349954	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School	Public School	Regular School	No	Middle	06	08	2021	kindergarten	0	0
349955	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School	Public School	Regular School	No	Middle	06	08	2021	pk_12_total	1057	1057
349956	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School	Public School	Regular School	No	Middle	06	08	2021	post_graduate	0	0
349957	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School	Public School	Regular School	No	Middle	06	08	2021	pre_kindergarten	0	0