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 (school_nces_id > :p2 or (school_nces_id = :p2 and rowid > :p1)) order by school_nces_id, 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
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
349958	NH	school	3300017	172	Exeter Region Cooperative	330001700107	20590	Cooperative Middle School	Public School	Regular School	No	Middle	06	08	2021	readiness	0	0
261022	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Public Charter Schools	Regular School	Yes	High	09	12	2020	pre_kindergarten	0.0	0
261518	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Public Charter Schools	Regular School	Yes	High	09	12	2020	kindergarten	0.0	0
262014	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Public Charter Schools	Regular School	Yes	High	09	12	2020	readiness	0.0	0
262510	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Public Charter Schools	Regular School	Yes	High	09	12	2020	grade_1	0.0	0
263006	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Public Charter Schools	Regular School	Yes	High	09	12	2020	grade_2	0.0	0
263502	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Public Charter Schools	Regular School	Yes	High	09	12	2020	grade_3	0.0	0
263998	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Public Charter Schools	Regular School	Yes	High	09	12	2020	grade_4	0.0	0
264494	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Public Charter Schools	Regular School	Yes	High	09	12	2020	grade_5	0.0	0
264990	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Public Charter Schools	Regular School	Yes	High	09	12	2020	grade_6	0.0	0
265486	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Public Charter Schools	Regular School	Yes	High	09	12	2020	grade_7	0.0	0
265982	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Public Charter Schools	Regular School	Yes	High	09	12	2020	grade_8	0.0	0
266478	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Public Charter Schools	Regular School	Yes	High	09	12	2020	grade_9	1.0	1
266974	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Public Charter Schools	Regular School	Yes	High	09	12	2020	grade_10	12.0	12
267470	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Public Charter Schools	Regular School	Yes	High	09	12	2020	grade_11	26.0	26
267966	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Public Charter Schools	Regular School	Yes	High	09	12	2020	grade_12	14.0	14
268462	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Public Charter Schools	Regular School	Yes	High	09	12	2020	post_graduate	0.0	0
268958	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Public Charter Schools	Regular School	Yes	High	09	12	2020	pk_12_total	53.0	53
354328	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Charter Schools approved by the state	Regular School	Yes	High	10	12	2021	grade_1	0	0
354329	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Charter Schools approved by the state	Regular School	Yes	High	10	12	2021	grade_10	5	5
354330	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Charter Schools approved by the state	Regular School	Yes	High	10	12	2021	grade_11	16	16
354331	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Charter Schools approved by the state	Regular School	Yes	High	10	12	2021	grade_12	26	26
354332	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Charter Schools approved by the state	Regular School	Yes	High	10	12	2021	grade_2	0	0
354333	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Charter Schools approved by the state	Regular School	Yes	High	10	12	2021	grade_3	0	0
354334	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Charter Schools approved by the state	Regular School	Yes	High	10	12	2021	grade_4	0	0
354335	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Charter Schools approved by the state	Regular School	Yes	High	10	12	2021	grade_5	0	0
354336	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Charter Schools approved by the state	Regular School	Yes	High	10	12	2021	grade_6	0	0
354337	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Charter Schools approved by the state	Regular School	Yes	High	10	12	2021	grade_7	0	0
354338	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Charter Schools approved by the state	Regular School	Yes	High	10	12	2021	grade_8	0	0
354339	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Charter Schools approved by the state	Regular School	Yes	High	10	12	2021	grade_9	0	0
354340	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Charter Schools approved by the state	Regular School	Yes	High	10	12	2021	kindergarten	0	0
354341	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Charter Schools approved by the state	Regular School	Yes	High	10	12	2021	pk_12_total	47	47
354342	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Charter Schools approved by the state	Regular School	Yes	High	10	12	2021	post_graduate	0	0
354343	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Charter Schools approved by the state	Regular School	Yes	High	10	12	2021	pre_kindergarten	0	0
354344	NH	school	3300030	703	North Country Charter Academy	330003000605	28395	North Country Charter Academy (H)	Charter Schools approved by the state	Regular School	Yes	High	10	12	2021	readiness	0	0
261023	NH	school	3300030	703	North Country Charter Academy	330003000613	28505	North Country Charter Academy (M)	Public Charter Schools	Regular School	Yes	Middle	08	08	2020	pre_kindergarten	0.0	0
261519	NH	school	3300030	703	North Country Charter Academy	330003000613	28505	North Country Charter Academy (M)	Public Charter Schools	Regular School	Yes	Middle	08	08	2020	kindergarten	0.0	0
262015	NH	school	3300030	703	North Country Charter Academy	330003000613	28505	North Country Charter Academy (M)	Public Charter Schools	Regular School	Yes	Middle	08	08	2020	readiness	0.0	0
262511	NH	school	3300030	703	North Country Charter Academy	330003000613	28505	North Country Charter Academy (M)	Public Charter Schools	Regular School	Yes	Middle	08	08	2020	grade_1	0.0	0
263007	NH	school	3300030	703	North Country Charter Academy	330003000613	28505	North Country Charter Academy (M)	Public Charter Schools	Regular School	Yes	Middle	08	08	2020	grade_2	0.0	0
263503	NH	school	3300030	703	North Country Charter Academy	330003000613	28505	North Country Charter Academy (M)	Public Charter Schools	Regular School	Yes	Middle	08	08	2020	grade_3	0.0	0
263999	NH	school	3300030	703	North Country Charter Academy	330003000613	28505	North Country Charter Academy (M)	Public Charter Schools	Regular School	Yes	Middle	08	08	2020	grade_4	0.0	0
264495	NH	school	3300030	703	North Country Charter Academy	330003000613	28505	North Country Charter Academy (M)	Public Charter Schools	Regular School	Yes	Middle	08	08	2020	grade_5	0.0	0
264991	NH	school	3300030	703	North Country Charter Academy	330003000613	28505	North Country Charter Academy (M)	Public Charter Schools	Regular School	Yes	Middle	08	08	2020	grade_6	0.0	0
265487	NH	school	3300030	703	North Country Charter Academy	330003000613	28505	North Country Charter Academy (M)	Public Charter Schools	Regular School	Yes	Middle	08	08	2020	grade_7	0.0	0
265983	NH	school	3300030	703	North Country Charter Academy	330003000613	28505	North Country Charter Academy (M)	Public Charter Schools	Regular School	Yes	Middle	08	08	2020	grade_8	1.0	1
266479	NH	school	3300030	703	North Country Charter Academy	330003000613	28505	North Country Charter Academy (M)	Public Charter Schools	Regular School	Yes	Middle	08	08	2020	grade_9	0.0	0
266975	NH	school	3300030	703	North Country Charter Academy	330003000613	28505	North Country Charter Academy (M)	Public Charter Schools	Regular School	Yes	Middle	08	08	2020	grade_10	0.0	0
267471	NH	school	3300030	703	North Country Charter Academy	330003000613	28505	North Country Charter Academy (M)	Public Charter Schools	Regular School	Yes	Middle	08	08	2020	grade_11	0.0	0
267967	NH	school	3300030	703	North Country Charter Academy	330003000613	28505	North Country Charter Academy (M)	Public Charter Schools	Regular School	Yes	Middle	08	08	2020	grade_12	0.0	0
268463	NH	school	3300030	703	North Country Charter Academy	330003000613	28505	North Country Charter Academy (M)	Public Charter Schools	Regular School	Yes	Middle	08	08	2020	post_graduate	0.0	0
268959	NH	school	3300030	703	North Country Charter Academy	330003000613	28505	North Country Charter Academy (M)	Public Charter Schools	Regular School	Yes	Middle	08	08	2020	pk_12_total	1.0	1
261027	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Public Charter Schools	Regular School	Yes	Elementary	KG	08	2020	pre_kindergarten	0.0	0
261523	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Public Charter Schools	Regular School	Yes	Elementary	KG	08	2020	kindergarten	38.0	38
262019	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Public Charter Schools	Regular School	Yes	Elementary	KG	08	2020	readiness	0.0	0
262515	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Public Charter Schools	Regular School	Yes	Elementary	KG	08	2020	grade_1	34.0	34
263011	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Public Charter Schools	Regular School	Yes	Elementary	KG	08	2020	grade_2	31.0	31
263507	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Public Charter Schools	Regular School	Yes	Elementary	KG	08	2020	grade_3	32.0	32
264003	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Public Charter Schools	Regular School	Yes	Elementary	KG	08	2020	grade_4	31.0	31
264499	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Public Charter Schools	Regular School	Yes	Elementary	KG	08	2020	grade_5	33.0	33
264995	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Public Charter Schools	Regular School	Yes	Elementary	KG	08	2020	grade_6	32.0	32
265491	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Public Charter Schools	Regular School	Yes	Elementary	KG	08	2020	grade_7	33.0	33
265987	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Public Charter Schools	Regular School	Yes	Elementary	KG	08	2020	grade_8	33.0	33
266483	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Public Charter Schools	Regular School	Yes	Elementary	KG	08	2020	grade_9	0.0	0
266979	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Public Charter Schools	Regular School	Yes	Elementary	KG	08	2020	grade_10	0.0	0
267475	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Public Charter Schools	Regular School	Yes	Elementary	KG	08	2020	grade_11	0.0	0
267971	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Public Charter Schools	Regular School	Yes	Elementary	KG	08	2020	grade_12	0.0	0
268467	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Public Charter Schools	Regular School	Yes	Elementary	KG	08	2020	post_graduate	0.0	0
268963	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Public Charter Schools	Regular School	Yes	Elementary	KG	08	2020	pk_12_total	297.0	297
355688	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Charter Schools approved by the state	Regular School	Yes	Elementary	KG	08	2021	grade_1	35	35
355689	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Charter Schools approved by the state	Regular School	Yes	Elementary	KG	08	2021	grade_10	0	0
355690	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Charter Schools approved by the state	Regular School	Yes	Elementary	KG	08	2021	grade_11	0	0
355691	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Charter Schools approved by the state	Regular School	Yes	Elementary	KG	08	2021	grade_12	0	0
355692	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Charter Schools approved by the state	Regular School	Yes	Elementary	KG	08	2021	grade_2	33	33
355693	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Charter Schools approved by the state	Regular School	Yes	Elementary	KG	08	2021	grade_3	31	31
355694	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Charter Schools approved by the state	Regular School	Yes	Elementary	KG	08	2021	grade_4	33	33
355695	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Charter Schools approved by the state	Regular School	Yes	Elementary	KG	08	2021	grade_5	33	33
355696	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Charter Schools approved by the state	Regular School	Yes	Elementary	KG	08	2021	grade_6	32	32
355697	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Charter Schools approved by the state	Regular School	Yes	Elementary	KG	08	2021	grade_7	36	36
355698	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Charter Schools approved by the state	Regular School	Yes	Elementary	KG	08	2021	grade_8	33	33
355699	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Charter Schools approved by the state	Regular School	Yes	Elementary	KG	08	2021	grade_9	0	0
355700	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Charter Schools approved by the state	Regular School	Yes	Elementary	KG	08	2021	kindergarten	30	30
355701	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Charter Schools approved by the state	Regular School	Yes	Elementary	KG	08	2021	pk_12_total	296	296
355702	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Charter Schools approved by the state	Regular School	Yes	Elementary	KG	08	2021	post_graduate	0	0
355703	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Charter Schools approved by the state	Regular School	Yes	Elementary	KG	08	2021	pre_kindergarten	0	0
355704	NH	school	3300031	705	Seacoast Charter School	330003100606	28400	Seacoast Charter School	Charter Schools approved by the state	Regular School	Yes	Elementary	KG	08	2021	readiness	0	0
260667	NH	school	3300035	203	Gorham Randolph Shelburne Cooperative	330003500047	27005	Gorham Middle School		Regular School	No	Middle	06	08	2020	pre_kindergarten	0.0	0
261163	NH	school	3300035	203	Gorham Randolph Shelburne Cooperative	330003500047	27005	Gorham Middle School		Regular School	No	Middle	06	08	2020	kindergarten	0.0	0
261659	NH	school	3300035	203	Gorham Randolph Shelburne Cooperative	330003500047	27005	Gorham Middle School		Regular School	No	Middle	06	08	2020	readiness	0.0	0
262155	NH	school	3300035	203	Gorham Randolph Shelburne Cooperative	330003500047	27005	Gorham Middle School		Regular School	No	Middle	06	08	2020	grade_1	0.0	0
262651	NH	school	3300035	203	Gorham Randolph Shelburne Cooperative	330003500047	27005	Gorham Middle School		Regular School	No	Middle	06	08	2020	grade_2	0.0	0
263147	NH	school	3300035	203	Gorham Randolph Shelburne Cooperative	330003500047	27005	Gorham Middle School		Regular School	No	Middle	06	08	2020	grade_3	0.0	0
263643	NH	school	3300035	203	Gorham Randolph Shelburne Cooperative	330003500047	27005	Gorham Middle School		Regular School	No	Middle	06	08	2020	grade_4	0.0	0
264139	NH	school	3300035	203	Gorham Randolph Shelburne Cooperative	330003500047	27005	Gorham Middle School		Regular School	No	Middle	06	08	2020	grade_5	0.0	0
264635	NH	school	3300035	203	Gorham Randolph Shelburne Cooperative	330003500047	27005	Gorham Middle School		Regular School	No	Middle	06	08	2020	grade_6	27.0	27
265131	NH	school	3300035	203	Gorham Randolph Shelburne Cooperative	330003500047	27005	Gorham Middle School		Regular School	No	Middle	06	08	2020	grade_7	39.0	39
265627	NH	school	3300035	203	Gorham Randolph Shelburne Cooperative	330003500047	27005	Gorham Middle School		Regular School	No	Middle	06	08	2020	grade_8	33.0	33
266123	NH	school	3300035	203	Gorham Randolph Shelburne Cooperative	330003500047	27005	Gorham Middle School		Regular School	No	Middle	06	08	2020	grade_9	0.0	0
266619	NH	school	3300035	203	Gorham Randolph Shelburne Cooperative	330003500047	27005	Gorham Middle School		Regular School	No	Middle	06	08	2020	grade_10	0.0	0
267115	NH	school	3300035	203	Gorham Randolph Shelburne Cooperative	330003500047	27005	Gorham Middle School		Regular School	No	Middle	06	08	2020	grade_11	0.0	0