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 "year" = :p1 and (total_int > :p3 or (total_int = :p3 and rowid > :p2)) order by total_int, 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	ccd_school_type	ccd_charter_school	ccd_school_lvl	ccd_school_low_grade	ccd_school_high_grade	year	grade	native_american	native_hawaiian_pacific_islander	native_american_int	native_hawaiian_pacific_islander_int
1812981	AK	school	200180	5	Anchorage Schools	20018000065	50110	Chester Valley Elementary	Regular School	No	Elementary	PK	6	2021	grade_11		0.0		0
1812982	AK	school	200180	5	Anchorage Schools	20018000065	50110	Chester Valley Elementary	Regular School	No	Elementary	PK	6	2021	grade_12		0.0		0
1812988	AK	school	200180	5	Anchorage Schools	20018000065	50110	Chester Valley Elementary	Regular School	No	Elementary	PK	6	2021	grade_7		0.0		0
1812989	AK	school	200180	5	Anchorage Schools	20018000065	50110	Chester Valley Elementary	Regular School	No	Elementary	PK	6	2021	grade_8		0.0		0
1812990	AK	school	200180	5	Anchorage Schools	20018000065	50110	Chester Valley Elementary	Regular School	No	Elementary	PK	6	2021	grade_9		0.0		0
1812996	AK	school	200180	5	Anchorage Schools	20018000066	50120	Chinook Elementary	Regular School	No	Elementary	PK	6	2021	grade_10	0.0	0.0	0	0
1812997	AK	school	200180	5	Anchorage Schools	20018000066	50120	Chinook Elementary	Regular School	No	Elementary	PK	6	2021	grade_11	0.0	0.0	0	0
1812998	AK	school	200180	5	Anchorage Schools	20018000066	50120	Chinook Elementary	Regular School	No	Elementary	PK	6	2021	grade_12	0.0	0.0	0	0
1813004	AK	school	200180	5	Anchorage Schools	20018000066	50120	Chinook Elementary	Regular School	No	Elementary	PK	6	2021	grade_7	0.0	0.0	0	0
1813005	AK	school	200180	5	Anchorage Schools	20018000066	50120	Chinook Elementary	Regular School	No	Elementary	PK	6	2021	grade_8	0.0	0.0	0	0
1813006	AK	school	200180	5	Anchorage Schools	20018000066	50120	Chinook Elementary	Regular School	No	Elementary	PK	6	2021	grade_9	0.0	0.0	0	0
1813012	AK	school	200180	5	Anchorage Schools	20018000067	50130	Chugach Optional Elementary	Regular School	No	Elementary	PK	6	2021	grade_10	0.0		0
1813013	AK	school	200180	5	Anchorage Schools	20018000067	50130	Chugach Optional Elementary	Regular School	No	Elementary	PK	6	2021	grade_11	0.0		0
1813014	AK	school	200180	5	Anchorage Schools	20018000067	50130	Chugach Optional Elementary	Regular School	No	Elementary	PK	6	2021	grade_12	0.0		0
1813020	AK	school	200180	5	Anchorage Schools	20018000067	50130	Chugach Optional Elementary	Regular School	No	Elementary	PK	6	2021	grade_7	0.0		0
1813021	AK	school	200180	5	Anchorage Schools	20018000067	50130	Chugach Optional Elementary	Regular School	No	Elementary	PK	6	2021	grade_8	0.0		0
1813022	AK	school	200180	5	Anchorage Schools	20018000067	50130	Chugach Optional Elementary	Regular School	No	Elementary	PK	6	2021	grade_9	0.0		0
1813026	AK	school	200180	5	Anchorage Schools	20018000067	50130	Chugach Optional Elementary	Regular School	No	Elementary	PK	6	2021	pre_kindergarten	0.0		0
1813027	AK	school	200180	5	Anchorage Schools	20018000505	50140	Gruening Middle School	Regular School	No	Middle	06	8	2021	grade_1	0.0	0.0	0	0
1813028	AK	school	200180	5	Anchorage Schools	20018000505	50140	Gruening Middle School	Regular School	No	Middle	06	8	2021	grade_10	0.0	0.0	0	0
1813029	AK	school	200180	5	Anchorage Schools	20018000505	50140	Gruening Middle School	Regular School	No	Middle	06	8	2021	grade_11	0.0	0.0	0	0
1813030	AK	school	200180	5	Anchorage Schools	20018000505	50140	Gruening Middle School	Regular School	No	Middle	06	8	2021	grade_12	0.0	0.0	0	0
1813031	AK	school	200180	5	Anchorage Schools	20018000505	50140	Gruening Middle School	Regular School	No	Middle	06	8	2021	grade_2	0.0	0.0	0	0
1813032	AK	school	200180	5	Anchorage Schools	20018000505	50140	Gruening Middle School	Regular School	No	Middle	06	8	2021	grade_3	0.0	0.0	0	0
1813033	AK	school	200180	5	Anchorage Schools	20018000505	50140	Gruening Middle School	Regular School	No	Middle	06	8	2021	grade_4	0.0	0.0	0	0
1813034	AK	school	200180	5	Anchorage Schools	20018000505	50140	Gruening Middle School	Regular School	No	Middle	06	8	2021	grade_5	0.0	0.0	0	0
1813038	AK	school	200180	5	Anchorage Schools	20018000505	50140	Gruening Middle School	Regular School	No	Middle	06	8	2021	grade_9	0.0	0.0	0	0
1813040	AK	school	200180	5	Anchorage Schools	20018000505	50140	Gruening Middle School	Regular School	No	Middle	06	8	2021	kindergarten	0.0	0.0	0	0
1813042	AK	school	200180	5	Anchorage Schools	20018000505	50140	Gruening Middle School	Regular School	No	Middle	06	8	2021	pre_kindergarten	0.0	0.0	0	0
1813044	AK	school	200180	5	Anchorage Schools	20018000068	50150	Chugiak Elementary	Regular School	No	Elementary	PK	6	2021	grade_10	0.0	0.0	0	0
1813045	AK	school	200180	5	Anchorage Schools	20018000068	50150	Chugiak Elementary	Regular School	No	Elementary	PK	6	2021	grade_11	0.0	0.0	0	0
1813046	AK	school	200180	5	Anchorage Schools	20018000068	50150	Chugiak Elementary	Regular School	No	Elementary	PK	6	2021	grade_12	0.0	0.0	0	0
1813051	AK	school	200180	5	Anchorage Schools	20018000068	50150	Chugiak Elementary	Regular School	No	Elementary	PK	6	2021	grade_6	0.0	0.0	0	0
1813052	AK	school	200180	5	Anchorage Schools	20018000068	50150	Chugiak Elementary	Regular School	No	Elementary	PK	6	2021	grade_7	0.0	0.0	0	0
1813053	AK	school	200180	5	Anchorage Schools	20018000068	50150	Chugiak Elementary	Regular School	No	Elementary	PK	6	2021	grade_8	0.0	0.0	0	0
1813054	AK	school	200180	5	Anchorage Schools	20018000068	50150	Chugiak Elementary	Regular School	No	Elementary	PK	6	2021	grade_9	0.0	0.0	0	0
1813058	AK	school	200180	5	Anchorage Schools	20018000068	50150	Chugiak Elementary	Regular School	No	Elementary	PK	6	2021	pre_kindergarten	0.0	0.0	0	0
1813059	AK	school	200180	5	Anchorage Schools	20018000069	50160	Chugiak High School	Regular School	No	High	09	12	2021	grade_1	0.0	0.0	0	0
1813063	AK	school	200180	5	Anchorage Schools	20018000069	50160	Chugiak High School	Regular School	No	High	09	12	2021	grade_2	0.0	0.0	0	0
1813064	AK	school	200180	5	Anchorage Schools	20018000069	50160	Chugiak High School	Regular School	No	High	09	12	2021	grade_3	0.0	0.0	0	0
1813065	AK	school	200180	5	Anchorage Schools	20018000069	50160	Chugiak High School	Regular School	No	High	09	12	2021	grade_4	0.0	0.0	0	0
1813066	AK	school	200180	5	Anchorage Schools	20018000069	50160	Chugiak High School	Regular School	No	High	09	12	2021	grade_5	0.0	0.0	0	0
1813067	AK	school	200180	5	Anchorage Schools	20018000069	50160	Chugiak High School	Regular School	No	High	09	12	2021	grade_6	0.0	0.0	0	0
1813068	AK	school	200180	5	Anchorage Schools	20018000069	50160	Chugiak High School	Regular School	No	High	09	12	2021	grade_7	0.0	0.0	0	0
1813069	AK	school	200180	5	Anchorage Schools	20018000069	50160	Chugiak High School	Regular School	No	High	09	12	2021	grade_8	0.0	0.0	0	0
1813072	AK	school	200180	5	Anchorage Schools	20018000069	50160	Chugiak High School	Regular School	No	High	09	12	2021	kindergarten	0.0	0.0	0	0
1813074	AK	school	200180	5	Anchorage Schools	20018000069	50160	Chugiak High School	Regular School	No	High	09	12	2021	pre_kindergarten	0.0	0.0	0	0
1813076	AK	school	200180	5	Anchorage Schools	20018000070	50170	College Gate Elementary	Regular School	No	Elementary	PK	6	2021	grade_10	0.0	0.0	0	0
1813077	AK	school	200180	5	Anchorage Schools	20018000070	50170	College Gate Elementary	Regular School	No	Elementary	PK	6	2021	grade_11	0.0	0.0	0	0
1813078	AK	school	200180	5	Anchorage Schools	20018000070	50170	College Gate Elementary	Regular School	No	Elementary	PK	6	2021	grade_12	0.0	0.0	0	0
1813084	AK	school	200180	5	Anchorage Schools	20018000070	50170	College Gate Elementary	Regular School	No	Elementary	PK	6	2021	grade_7	0.0	0.0	0	0
1813085	AK	school	200180	5	Anchorage Schools	20018000070	50170	College Gate Elementary	Regular School	No	Elementary	PK	6	2021	grade_8	0.0	0.0	0	0
1813086	AK	school	200180	5	Anchorage Schools	20018000070	50170	College Gate Elementary	Regular School	No	Elementary	PK	6	2021	grade_9	0.0	0.0	0	0
1813092	AK	school	200180	5	Anchorage Schools	20018000071	50180	Creekside Park Elementary	Regular School	No	Elementary	PK	6	2021	grade_10	0.0	0.0	0	0
1813093	AK	school	200180	5	Anchorage Schools	20018000071	50180	Creekside Park Elementary	Regular School	No	Elementary	PK	6	2021	grade_11	0.0	0.0	0	0
1813094	AK	school	200180	5	Anchorage Schools	20018000071	50180	Creekside Park Elementary	Regular School	No	Elementary	PK	6	2021	grade_12	0.0	0.0	0	0
1813099	AK	school	200180	5	Anchorage Schools	20018000071	50180	Creekside Park Elementary	Regular School	No	Elementary	PK	6	2021	grade_6	0.0	0.0	0	0
1813100	AK	school	200180	5	Anchorage Schools	20018000071	50180	Creekside Park Elementary	Regular School	No	Elementary	PK	6	2021	grade_7	0.0	0.0	0	0
1813101	AK	school	200180	5	Anchorage Schools	20018000071	50180	Creekside Park Elementary	Regular School	No	Elementary	PK	6	2021	grade_8	0.0	0.0	0	0
1813102	AK	school	200180	5	Anchorage Schools	20018000071	50180	Creekside Park Elementary	Regular School	No	Elementary	PK	6	2021	grade_9	0.0	0.0	0	0
1813108	AK	school	200180	5	Anchorage Schools	20018000072	50190	Denali Montessori Elementary	Regular School	No	Elementary	PK	6	2021	grade_10	0.0	0.0	0	0
1813109	AK	school	200180	5	Anchorage Schools	20018000072	50190	Denali Montessori Elementary	Regular School	No	Elementary	PK	6	2021	grade_11	0.0	0.0	0	0
1813110	AK	school	200180	5	Anchorage Schools	20018000072	50190	Denali Montessori Elementary	Regular School	No	Elementary	PK	6	2021	grade_12	0.0	0.0	0	0
1813116	AK	school	200180	5	Anchorage Schools	20018000072	50190	Denali Montessori Elementary	Regular School	No	Elementary	PK	6	2021	grade_7	0.0	0.0	0	0
1813117	AK	school	200180	5	Anchorage Schools	20018000072	50190	Denali Montessori Elementary	Regular School	No	Elementary	PK	6	2021	grade_8	0.0	0.0	0	0
1813118	AK	school	200180	5	Anchorage Schools	20018000072	50190	Denali Montessori Elementary	Regular School	No	Elementary	PK	6	2021	grade_9	0.0	0.0	0	0
1813123	AK	school	200180	5	Anchorage Schools	20018000073	50200	Dimond High School	Regular School	No	High	09	12	2021	grade_1	0.0	0.0	0	0
1813127	AK	school	200180	5	Anchorage Schools	20018000073	50200	Dimond High School	Regular School	No	High	09	12	2021	grade_2	0.0	0.0	0	0
1813128	AK	school	200180	5	Anchorage Schools	20018000073	50200	Dimond High School	Regular School	No	High	09	12	2021	grade_3	0.0	0.0	0	0
1813129	AK	school	200180	5	Anchorage Schools	20018000073	50200	Dimond High School	Regular School	No	High	09	12	2021	grade_4	0.0	0.0	0	0
1813130	AK	school	200180	5	Anchorage Schools	20018000073	50200	Dimond High School	Regular School	No	High	09	12	2021	grade_5	0.0	0.0	0	0
1813131	AK	school	200180	5	Anchorage Schools	20018000073	50200	Dimond High School	Regular School	No	High	09	12	2021	grade_6	0.0	0.0	0	0
1813132	AK	school	200180	5	Anchorage Schools	20018000073	50200	Dimond High School	Regular School	No	High	09	12	2021	grade_7	0.0	0.0	0	0
1813133	AK	school	200180	5	Anchorage Schools	20018000073	50200	Dimond High School	Regular School	No	High	09	12	2021	grade_8	0.0	0.0	0	0
1813136	AK	school	200180	5	Anchorage Schools	20018000073	50200	Dimond High School	Regular School	No	High	09	12	2021	kindergarten	0.0	0.0	0	0
1813138	AK	school	200180	5	Anchorage Schools	20018000073	50200	Dimond High School	Regular School	No	High	09	12	2021	pre_kindergarten	0.0	0.0	0	0
1813139	AK	school	200180	5	Anchorage Schools	20018000075	50220	East High School	Regular School	No	High	09	12	2021	grade_1	0.0	0.0	0	0
1813143	AK	school	200180	5	Anchorage Schools	20018000075	50220	East High School	Regular School	No	High	09	12	2021	grade_2	0.0	0.0	0	0
1813144	AK	school	200180	5	Anchorage Schools	20018000075	50220	East High School	Regular School	No	High	09	12	2021	grade_3	0.0	0.0	0	0
1813145	AK	school	200180	5	Anchorage Schools	20018000075	50220	East High School	Regular School	No	High	09	12	2021	grade_4	0.0	0.0	0	0
1813146	AK	school	200180	5	Anchorage Schools	20018000075	50220	East High School	Regular School	No	High	09	12	2021	grade_5	0.0	0.0	0	0
1813147	AK	school	200180	5	Anchorage Schools	20018000075	50220	East High School	Regular School	No	High	09	12	2021	grade_6	0.0	0.0	0	0
1813148	AK	school	200180	5	Anchorage Schools	20018000075	50220	East High School	Regular School	No	High	09	12	2021	grade_7	0.0	0.0	0	0
1813149	AK	school	200180	5	Anchorage Schools	20018000075	50220	East High School	Regular School	No	High	09	12	2021	grade_8	0.0	0.0	0	0
1813152	AK	school	200180	5	Anchorage Schools	20018000075	50220	East High School	Regular School	No	High	09	12	2021	kindergarten	0.0	0.0	0	0
1813154	AK	school	200180	5	Anchorage Schools	20018000075	50220	East High School	Regular School	No	High	09	12	2021	pre_kindergarten	0.0	0.0	0	0
1813156	AK	school	200180	5	Anchorage Schools	20018000056	50240	Aurora Elementary	Regular School	No	Elementary	PK	6	2021	grade_10	0.0	0.0	0	0
1813157	AK	school	200180	5	Anchorage Schools	20018000056	50240	Aurora Elementary	Regular School	No	Elementary	PK	6	2021	grade_11	0.0	0.0	0	0
1813158	AK	school	200180	5	Anchorage Schools	20018000056	50240	Aurora Elementary	Regular School	No	Elementary	PK	6	2021	grade_12	0.0	0.0	0	0
1813164	AK	school	200180	5	Anchorage Schools	20018000056	50240	Aurora Elementary	Regular School	No	Elementary	PK	6	2021	grade_7	0.0	0.0	0	0
1813165	AK	school	200180	5	Anchorage Schools	20018000056	50240	Aurora Elementary	Regular School	No	Elementary	PK	6	2021	grade_8	0.0	0.0	0	0
1813166	AK	school	200180	5	Anchorage Schools	20018000056	50240	Aurora Elementary	Regular School	No	Elementary	PK	6	2021	grade_9	0.0	0.0	0	0
1813170	AK	school	200180	5	Anchorage Schools	20018000056	50240	Aurora Elementary	Regular School	No	Elementary	PK	6	2021	pre_kindergarten	0.0	0.0	0	0
1813172	AK	school	200180	5	Anchorage Schools	20018000099	50250	Orion Elementary School	Regular School	No	Elementary	PK	6	2021	grade_10		0.0		0
1813173	AK	school	200180	5	Anchorage Schools	20018000099	50250	Orion Elementary School	Regular School	No	Elementary	PK	6	2021	grade_11		0.0		0
1813174	AK	school	200180	5	Anchorage Schools	20018000099	50250	Orion Elementary School	Regular School	No	Elementary	PK	6	2021	grade_12		0.0		0
1813180	AK	school	200180	5	Anchorage Schools	20018000099	50250	Orion Elementary School	Regular School	No	Elementary	PK	6	2021	grade_7		0.0		0
1813181	AK	school	200180	5	Anchorage Schools	20018000099	50250	Orion Elementary School	Regular School	No	Elementary	PK	6	2021	grade_8		0.0		0
1813182	AK	school	200180	5	Anchorage Schools	20018000099	50250	Orion Elementary School	Regular School	No	Elementary	PK	6	2021	grade_9		0.0		0
1813186	AK	school	200180	5	Anchorage Schools	20018000099	50250	Orion Elementary School	Regular School	No	Elementary	PK	6	2021	pre_kindergarten		0.0		0
1813188	AK	school	200180	5	Anchorage Schools	20018000076	50300	Fairview Elementary	Regular School	No	Elementary	PK	6	2021	grade_10	0.0	0.0	0	0