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 (district > :p3 or (district = :p3 and rowid > :p2)) order by district, 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	white	black	hispanic	native_american_alaskan_native	asian	native_hawaiian_pacific_islander	multiracial	total	white_int	black_int	hispanic_int	native_american_alaskan_native_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int	total_int
1183179	OR	school	4101020	2113	Adrian SD 61	410102000755	707	Adrian Elementary School	Regular School	No	Elementary	KG	08	2018	grade_8								23.0								23
1183180	OR	school	4101020	2113	Adrian SD 61	410102000756	708	Adrian High School	Regular School	No	High	09	12	2018	grade_8								0.0								0
1184638	OR	school	4101020	2113	Adrian SD 61	410102000755	707	Adrian Elementary School	Regular School	No	Elementary	KG	08	2018	grade_9								0.0								0
1184639	OR	school	4101020	2113	Adrian SD 61	410102000756	708	Adrian High School	Regular School	No	High	09	12	2018	grade_9								22.0								22
1186097	OR	school	4101020	2113	Adrian SD 61	410102000755	707	Adrian Elementary School	Regular School	No	Elementary	KG	08	2018	grade_10								0.0								0
1186098	OR	school	4101020	2113	Adrian SD 61	410102000756	708	Adrian High School	Regular School	No	High	09	12	2018	grade_10								28.0								28
1187556	OR	school	4101020	2113	Adrian SD 61	410102000755	707	Adrian Elementary School	Regular School	No	Elementary	KG	08	2018	grade_11								0.0								0
1187557	OR	school	4101020	2113	Adrian SD 61	410102000756	708	Adrian High School	Regular School	No	High	09	12	2018	grade_11								15.0								15
1189015	OR	school	4101020	2113	Adrian SD 61	410102000755	707	Adrian Elementary School	Regular School	No	Elementary	KG	08	2018	grade_12								0.0								0
1189016	OR	school	4101020	2113	Adrian SD 61	410102000756	708	Adrian High School	Regular School	No	High	09	12	2018	grade_12								29.0								29
1190474	OR	school	4101020	2113	Adrian SD 61	410102000755	707	Adrian Elementary School	Regular School	No	Elementary	KG	08	2018	k_12_total	164.0	0.0	42.0	0.0	0.0	0.0	1.0		164	0	42	0	0	0	1
1190475	OR	school	4101020	2113	Adrian SD 61	410102000756	708	Adrian High School	Regular School	No	High	09	12	2018	k_12_total	70.0	0.0	19.0	1.0	2.0	0.0	2.0		70	0	19	1	2	0	2
1171509	OR	school	4101200	1899	Alsea SD 7J	410120000019	17	Alsea Charter School	Regular School	Yes	Other	KG	12	2018	kindergarten								13.0								13
1171510	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Not Reported	M	M	2018	kindergarten								0.0								0
1172968	OR	school	4101200	1899	Alsea SD 7J	410120000019	17	Alsea Charter School	Regular School	Yes	Other	KG	12	2018	grade_1								7.0								7
1172969	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Not Reported	M	M	2018	grade_1								0.0								0
1174427	OR	school	4101200	1899	Alsea SD 7J	410120000019	17	Alsea Charter School	Regular School	Yes	Other	KG	12	2018	grade_2								8.0								8
1174428	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Not Reported	M	M	2018	grade_2								0.0								0
1175886	OR	school	4101200	1899	Alsea SD 7J	410120000019	17	Alsea Charter School	Regular School	Yes	Other	KG	12	2018	grade_3								15.0								15
1175887	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Not Reported	M	M	2018	grade_3								0.0								0
1177345	OR	school	4101200	1899	Alsea SD 7J	410120000019	17	Alsea Charter School	Regular School	Yes	Other	KG	12	2018	grade_4								19.0								19
1177346	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Not Reported	M	M	2018	grade_4								0.0								0
1178804	OR	school	4101200	1899	Alsea SD 7J	410120000019	17	Alsea Charter School	Regular School	Yes	Other	KG	12	2018	grade_5								13.0								13
1178805	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Not Reported	M	M	2018	grade_5								0.0								0
1180263	OR	school	4101200	1899	Alsea SD 7J	410120000019	17	Alsea Charter School	Regular School	Yes	Other	KG	12	2018	grade_6								14.0								14
1180264	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Not Reported	M	M	2018	grade_6								0.0								0
1181722	OR	school	4101200	1899	Alsea SD 7J	410120000019	17	Alsea Charter School	Regular School	Yes	Other	KG	12	2018	grade_7								11.0								11
1181723	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Not Reported	M	M	2018	grade_7								0.0								0
1183181	OR	school	4101200	1899	Alsea SD 7J	410120000019	17	Alsea Charter School	Regular School	Yes	Other	KG	12	2018	grade_8								7.0								7
1183182	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Not Reported	M	M	2018	grade_8								0.0								0
1184640	OR	school	4101200	1899	Alsea SD 7J	410120000019	17	Alsea Charter School	Regular School	Yes	Other	KG	12	2018	grade_9								10.0								10
1184641	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Not Reported	M	M	2018	grade_9								0.0								0
1186099	OR	school	4101200	1899	Alsea SD 7J	410120000019	17	Alsea Charter School	Regular School	Yes	Other	KG	12	2018	grade_10								11.0								11
1186100	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Not Reported	M	M	2018	grade_10								0.0								0
1187558	OR	school	4101200	1899	Alsea SD 7J	410120000019	17	Alsea Charter School	Regular School	Yes	Other	KG	12	2018	grade_11								15.0								15
1187559	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Not Reported	M	M	2018	grade_11								0.0								0
1189017	OR	school	4101200	1899	Alsea SD 7J	410120000019	17	Alsea Charter School	Regular School	Yes	Other	KG	12	2018	grade_12								15.0								15
1189018	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Not Reported	M	M	2018	grade_12								0.0								0
1190476	OR	school	4101200	1899	Alsea SD 7J	410120000019	17	Alsea Charter School	Regular School	Yes	Other	KG	12	2018	k_12_total	129.0	1.0	19.0	1.0	0.0	0.0	8.0		129	1	19	1	0	0	8
1190477	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Not Reported	M	M	2018	k_12_total	0.0	0.0	0.0	0.0	0.0	0.0	0.0		0	0	0	0	0	0	0
1171511	OR	school	4101230	2252	Amity SD 4J	410123001260	1208	Amity Elementary School	Regular School	No	Elementary	KG	05	2018	kindergarten								54.0								54
1171512	OR	school	4101230	2252	Amity SD 4J	410123001263	1210	Amity High School	Regular School	No	High	09	12	2018	kindergarten								0.0								0
1171513	OR	school	4101230	2252	Amity SD 4J	410123001320	1209	Amity Middle School	Regular School	No	Middle	06	08	2018	kindergarten								0.0								0
1171514	OR	school	4101230	2252	Amity SD 4J	410123001653	4505	Eola Hills Charter School	Regular School	Yes	Other	01	12	2018	kindergarten								0.0								0
1172970	OR	school	4101230	2252	Amity SD 4J	410123001260	1208	Amity Elementary School	Regular School	No	Elementary	KG	05	2018	grade_1								53.0								53
1172971	OR	school	4101230	2252	Amity SD 4J	410123001263	1210	Amity High School	Regular School	No	High	09	12	2018	grade_1								0.0								0
1172972	OR	school	4101230	2252	Amity SD 4J	410123001320	1209	Amity Middle School	Regular School	No	Middle	06	08	2018	grade_1								0.0								0
1172973	OR	school	4101230	2252	Amity SD 4J	410123001653	4505	Eola Hills Charter School	Regular School	Yes	Other	01	12	2018	grade_1								0.0								0
1174429	OR	school	4101230	2252	Amity SD 4J	410123001260	1208	Amity Elementary School	Regular School	No	Elementary	KG	05	2018	grade_2								51.0								51
1174430	OR	school	4101230	2252	Amity SD 4J	410123001263	1210	Amity High School	Regular School	No	High	09	12	2018	grade_2								0.0								0
1174431	OR	school	4101230	2252	Amity SD 4J	410123001320	1209	Amity Middle School	Regular School	No	Middle	06	08	2018	grade_2								0.0								0
1174432	OR	school	4101230	2252	Amity SD 4J	410123001653	4505	Eola Hills Charter School	Regular School	Yes	Other	01	12	2018	grade_2								0.0								0
1175888	OR	school	4101230	2252	Amity SD 4J	410123001260	1208	Amity Elementary School	Regular School	No	Elementary	KG	05	2018	grade_3								54.0								54
1175889	OR	school	4101230	2252	Amity SD 4J	410123001263	1210	Amity High School	Regular School	No	High	09	12	2018	grade_3								0.0								0
1175890	OR	school	4101230	2252	Amity SD 4J	410123001320	1209	Amity Middle School	Regular School	No	Middle	06	08	2018	grade_3								0.0								0
1175891	OR	school	4101230	2252	Amity SD 4J	410123001653	4505	Eola Hills Charter School	Regular School	Yes	Other	01	12	2018	grade_3								0.0								0
1177347	OR	school	4101230	2252	Amity SD 4J	410123001260	1208	Amity Elementary School	Regular School	No	Elementary	KG	05	2018	grade_4								67.0								67
1177348	OR	school	4101230	2252	Amity SD 4J	410123001263	1210	Amity High School	Regular School	No	High	09	12	2018	grade_4								0.0								0
1177349	OR	school	4101230	2252	Amity SD 4J	410123001320	1209	Amity Middle School	Regular School	No	Middle	06	08	2018	grade_4								0.0								0
1177350	OR	school	4101230	2252	Amity SD 4J	410123001653	4505	Eola Hills Charter School	Regular School	Yes	Other	01	12	2018	grade_4								2.0								2
1178806	OR	school	4101230	2252	Amity SD 4J	410123001260	1208	Amity Elementary School	Regular School	No	Elementary	KG	05	2018	grade_5								81.0								81
1178807	OR	school	4101230	2252	Amity SD 4J	410123001263	1210	Amity High School	Regular School	No	High	09	12	2018	grade_5								0.0								0
1178808	OR	school	4101230	2252	Amity SD 4J	410123001320	1209	Amity Middle School	Regular School	No	Middle	06	08	2018	grade_5								0.0								0
1178809	OR	school	4101230	2252	Amity SD 4J	410123001653	4505	Eola Hills Charter School	Regular School	Yes	Other	01	12	2018	grade_5								0.0								0
1180265	OR	school	4101230	2252	Amity SD 4J	410123001260	1208	Amity Elementary School	Regular School	No	Elementary	KG	05	2018	grade_6								0.0								0
1180266	OR	school	4101230	2252	Amity SD 4J	410123001263	1210	Amity High School	Regular School	No	High	09	12	2018	grade_6								0.0								0
1180267	OR	school	4101230	2252	Amity SD 4J	410123001320	1209	Amity Middle School	Regular School	No	Middle	06	08	2018	grade_6								67.0								67
1180268	OR	school	4101230	2252	Amity SD 4J	410123001653	4505	Eola Hills Charter School	Regular School	Yes	Other	01	12	2018	grade_6								2.0								2
1181724	OR	school	4101230	2252	Amity SD 4J	410123001260	1208	Amity Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7								0.0								0
1181725	OR	school	4101230	2252	Amity SD 4J	410123001263	1210	Amity High School	Regular School	No	High	09	12	2018	grade_7								0.0								0
1181726	OR	school	4101230	2252	Amity SD 4J	410123001320	1209	Amity Middle School	Regular School	No	Middle	06	08	2018	grade_7								69.0								69
1181727	OR	school	4101230	2252	Amity SD 4J	410123001653	4505	Eola Hills Charter School	Regular School	Yes	Other	01	12	2018	grade_7								0.0								0
1183183	OR	school	4101230	2252	Amity SD 4J	410123001260	1208	Amity Elementary School	Regular School	No	Elementary	KG	05	2018	grade_8								0.0								0
1183184	OR	school	4101230	2252	Amity SD 4J	410123001263	1210	Amity High School	Regular School	No	High	09	12	2018	grade_8								0.0								0
1183185	OR	school	4101230	2252	Amity SD 4J	410123001320	1209	Amity Middle School	Regular School	No	Middle	06	08	2018	grade_8								64.0								64
1183186	OR	school	4101230	2252	Amity SD 4J	410123001653	4505	Eola Hills Charter School	Regular School	Yes	Other	01	12	2018	grade_8								4.0								4
1184642	OR	school	4101230	2252	Amity SD 4J	410123001260	1208	Amity Elementary School	Regular School	No	Elementary	KG	05	2018	grade_9								0.0								0
1184643	OR	school	4101230	2252	Amity SD 4J	410123001263	1210	Amity High School	Regular School	No	High	09	12	2018	grade_9								69.0								69
1184644	OR	school	4101230	2252	Amity SD 4J	410123001320	1209	Amity Middle School	Regular School	No	Middle	06	08	2018	grade_9								0.0								0
1184645	OR	school	4101230	2252	Amity SD 4J	410123001653	4505	Eola Hills Charter School	Regular School	Yes	Other	01	12	2018	grade_9								3.0								3
1186101	OR	school	4101230	2252	Amity SD 4J	410123001260	1208	Amity Elementary School	Regular School	No	Elementary	KG	05	2018	grade_10								0.0								0
1186102	OR	school	4101230	2252	Amity SD 4J	410123001263	1210	Amity High School	Regular School	No	High	09	12	2018	grade_10								63.0								63
1186103	OR	school	4101230	2252	Amity SD 4J	410123001320	1209	Amity Middle School	Regular School	No	Middle	06	08	2018	grade_10								0.0								0
1186104	OR	school	4101230	2252	Amity SD 4J	410123001653	4505	Eola Hills Charter School	Regular School	Yes	Other	01	12	2018	grade_10								6.0								6
1187560	OR	school	4101230	2252	Amity SD 4J	410123001260	1208	Amity Elementary School	Regular School	No	Elementary	KG	05	2018	grade_11								0.0								0
1187561	OR	school	4101230	2252	Amity SD 4J	410123001263	1210	Amity High School	Regular School	No	High	09	12	2018	grade_11								73.0								73
1187562	OR	school	4101230	2252	Amity SD 4J	410123001320	1209	Amity Middle School	Regular School	No	Middle	06	08	2018	grade_11								0.0								0
1187563	OR	school	4101230	2252	Amity SD 4J	410123001653	4505	Eola Hills Charter School	Regular School	Yes	Other	01	12	2018	grade_11								7.0								7
1189019	OR	school	4101230	2252	Amity SD 4J	410123001260	1208	Amity Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12								0.0								0
1189020	OR	school	4101230	2252	Amity SD 4J	410123001263	1210	Amity High School	Regular School	No	High	09	12	2018	grade_12								76.0								76
1189021	OR	school	4101230	2252	Amity SD 4J	410123001320	1209	Amity Middle School	Regular School	No	Middle	06	08	2018	grade_12								0.0								0
1189022	OR	school	4101230	2252	Amity SD 4J	410123001653	4505	Eola Hills Charter School	Regular School	Yes	Other	01	12	2018	grade_12								13.0								13
1190478	OR	school	4101230	2252	Amity SD 4J	410123001260	1208	Amity Elementary School	Regular School	No	Elementary	KG	05	2018	k_12_total	287.0	1.0	46.0	5.0	1.0	0.0	20.0		287	1	46	5	1	0	20
1190479	OR	school	4101230	2252	Amity SD 4J	410123001263	1210	Amity High School	Regular School	No	High	09	12	2018	k_12_total	226.0	0.0	37.0	2.0	2.0	0.0	14.0		226	0	37	2	2	0	14
1190480	OR	school	4101230	2252	Amity SD 4J	410123001320	1209	Amity Middle School	Regular School	No	Middle	06	08	2018	k_12_total	161.0	1.0	29.0	1.0	2.0	1.0	5.0		161	1	29	1	2	1	5
1190481	OR	school	4101230	2252	Amity SD 4J	410123001653	4505	Eola Hills Charter School	Regular School	Yes	Other	01	12	2018	k_12_total	24.0	1.0	5.0	2.0	1.0	0.0	4.0		24	1	5	2	1	0	4
1171515	OR	school	4101350	2111	Annex SD 29	410135000753	705	Annex Charter School	Regular School	Yes	Elementary	KG	08	2018	kindergarten								11.0								11
1171516	OR	school	4101350	2111	Annex SD 29		2111	Annex SD 29						2018	kindergarten								0.0								0
1172974	OR	school	4101350	2111	Annex SD 29	410135000753	705	Annex Charter School	Regular School	Yes	Elementary	KG	08	2018	grade_1								7.0								7
1172975	OR	school	4101350	2111	Annex SD 29		2111	Annex SD 29						2018	grade_1								0.0								0
1174433	OR	school	4101350	2111	Annex SD 29	410135000753	705	Annex Charter School	Regular School	Yes	Elementary	KG	08	2018	grade_2								10.0								10