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
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
1174434	OR	school	4101350	2111	Annex SD 29		2111	Annex SD 29						2018	grade_2								0.0								0
1175892	OR	school	4101350	2111	Annex SD 29	410135000753	705	Annex Charter School	Regular School	Yes	Elementary	KG	08	2018	grade_3								11.0								11
1175893	OR	school	4101350	2111	Annex SD 29		2111	Annex SD 29						2018	grade_3								0.0								0
1177351	OR	school	4101350	2111	Annex SD 29	410135000753	705	Annex Charter School	Regular School	Yes	Elementary	KG	08	2018	grade_4								14.0								14
1177352	OR	school	4101350	2111	Annex SD 29		2111	Annex SD 29						2018	grade_4								0.0								0
1178810	OR	school	4101350	2111	Annex SD 29	410135000753	705	Annex Charter School	Regular School	Yes	Elementary	KG	08	2018	grade_5								7.0								7
1178811	OR	school	4101350	2111	Annex SD 29		2111	Annex SD 29						2018	grade_5								0.0								0
1180269	OR	school	4101350	2111	Annex SD 29	410135000753	705	Annex Charter School	Regular School	Yes	Elementary	KG	08	2018	grade_6								12.0								12
1180270	OR	school	4101350	2111	Annex SD 29		2111	Annex SD 29						2018	grade_6								0.0								0
1181728	OR	school	4101350	2111	Annex SD 29	410135000753	705	Annex Charter School	Regular School	Yes	Elementary	KG	08	2018	grade_7								11.0								11
1181729	OR	school	4101350	2111	Annex SD 29		2111	Annex SD 29						2018	grade_7								0.0								0
1183187	OR	school	4101350	2111	Annex SD 29	410135000753	705	Annex Charter School	Regular School	Yes	Elementary	KG	08	2018	grade_8								4.0								4
1183188	OR	school	4101350	2111	Annex SD 29		2111	Annex SD 29						2018	grade_8								0.0								0
1184646	OR	school	4101350	2111	Annex SD 29	410135000753	705	Annex Charter School	Regular School	Yes	Elementary	KG	08	2018	grade_9								0.0								0
1184647	OR	school	4101350	2111	Annex SD 29		2111	Annex SD 29						2018	grade_9								6.0								6
1186105	OR	school	4101350	2111	Annex SD 29	410135000753	705	Annex Charter School	Regular School	Yes	Elementary	KG	08	2018	grade_10								0.0								0
1186106	OR	school	4101350	2111	Annex SD 29		2111	Annex SD 29						2018	grade_10								2.0								2
1187564	OR	school	4101350	2111	Annex SD 29	410135000753	705	Annex Charter School	Regular School	Yes	Elementary	KG	08	2018	grade_11								0.0								0
1187565	OR	school	4101350	2111	Annex SD 29		2111	Annex SD 29						2018	grade_11								0.0								0
1189023	OR	school	4101350	2111	Annex SD 29	410135000753	705	Annex Charter School	Regular School	Yes	Elementary	KG	08	2018	grade_12								0.0								0
1189024	OR	school	4101350	2111	Annex SD 29		2111	Annex SD 29						2018	grade_12								8.0								8
1190482	OR	school	4101350	2111	Annex SD 29	410135000753	705	Annex Charter School	Regular School	Yes	Elementary	KG	08	2018	k_12_total	58.0	0.0	25.0	0.0	0.0	0.0	4.0		58	0	25	0	0	0	4
1190483	OR	school	4101350	2111	Annex SD 29		2111	Annex SD 29						2018	k_12_total	9.0	0.0	6.0	0.0	0.0	0.0	1.0		9	0	6	0	0	0	1
1171517	OR	school	4101470	2005	Arlington SD 3	410147000343	323	Arlington Community Charter School	Regular School	Yes	Other	KG	12	2018	kindergarten								11.0								11
1172976	OR	school	4101470	2005	Arlington SD 3	410147000343	323	Arlington Community Charter School	Regular School	Yes	Other	KG	12	2018	grade_1								8.0								8
1174435	OR	school	4101470	2005	Arlington SD 3	410147000343	323	Arlington Community Charter School	Regular School	Yes	Other	KG	12	2018	grade_2								13.0								13
1175894	OR	school	4101470	2005	Arlington SD 3	410147000343	323	Arlington Community Charter School	Regular School	Yes	Other	KG	12	2018	grade_3								10.0								10
1177353	OR	school	4101470	2005	Arlington SD 3	410147000343	323	Arlington Community Charter School	Regular School	Yes	Other	KG	12	2018	grade_4								11.0								11
1178812	OR	school	4101470	2005	Arlington SD 3	410147000343	323	Arlington Community Charter School	Regular School	Yes	Other	KG	12	2018	grade_5								16.0								16
1180271	OR	school	4101470	2005	Arlington SD 3	410147000343	323	Arlington Community Charter School	Regular School	Yes	Other	KG	12	2018	grade_6								14.0								14
1181730	OR	school	4101470	2005	Arlington SD 3	410147000343	323	Arlington Community Charter School	Regular School	Yes	Other	KG	12	2018	grade_7								19.0								19
1183189	OR	school	4101470	2005	Arlington SD 3	410147000343	323	Arlington Community Charter School	Regular School	Yes	Other	KG	12	2018	grade_8								12.0								12
1184648	OR	school	4101470	2005	Arlington SD 3	410147000343	323	Arlington Community Charter School	Regular School	Yes	Other	KG	12	2018	grade_9								14.0								14
1186107	OR	school	4101470	2005	Arlington SD 3	410147000343	323	Arlington Community Charter School	Regular School	Yes	Other	KG	12	2018	grade_10								7.0								7
1187566	OR	school	4101470	2005	Arlington SD 3	410147000343	323	Arlington Community Charter School	Regular School	Yes	Other	KG	12	2018	grade_11								10.0								10
1189025	OR	school	4101470	2005	Arlington SD 3	410147000343	323	Arlington Community Charter School	Regular School	Yes	Other	KG	12	2018	grade_12								10.0								10
1190484	OR	school	4101470	2005	Arlington SD 3	410147000343	323	Arlington Community Charter School	Regular School	Yes	Other	KG	12	2018	k_12_total	121.0	0.0	21.0	7.0	0.0	1.0	5.0		121	0	21	7	0	1	5
1171518	OR	school	4101500	2115	Arock SD 81	410150000759	711	W W Jones Elementary School	Regular School	No	Elementary	KG	08	2018	kindergarten								2.0								2
1172977	OR	school	4101500	2115	Arock SD 81	410150000759	711	W W Jones Elementary School	Regular School	No	Elementary	KG	08	2018	grade_1								3.0								3
1174436	OR	school	4101500	2115	Arock SD 81	410150000759	711	W W Jones Elementary School	Regular School	No	Elementary	KG	08	2018	grade_2								3.0								3
1175895	OR	school	4101500	2115	Arock SD 81	410150000759	711	W W Jones Elementary School	Regular School	No	Elementary	KG	08	2018	grade_3								3.0								3
1177354	OR	school	4101500	2115	Arock SD 81	410150000759	711	W W Jones Elementary School	Regular School	No	Elementary	KG	08	2018	grade_4								0.0								0
1178813	OR	school	4101500	2115	Arock SD 81	410150000759	711	W W Jones Elementary School	Regular School	No	Elementary	KG	08	2018	grade_5								1.0								1
1180272	OR	school	4101500	2115	Arock SD 81	410150000759	711	W W Jones Elementary School	Regular School	No	Elementary	KG	08	2018	grade_6								1.0								1
1181731	OR	school	4101500	2115	Arock SD 81	410150000759	711	W W Jones Elementary School	Regular School	No	Elementary	KG	08	2018	grade_7								0.0								0
1183190	OR	school	4101500	2115	Arock SD 81	410150000759	711	W W Jones Elementary School	Regular School	No	Elementary	KG	08	2018	grade_8								2.0								2
1184649	OR	school	4101500	2115	Arock SD 81	410150000759	711	W W Jones Elementary School	Regular School	No	Elementary	KG	08	2018	grade_9								0.0								0
1186108	OR	school	4101500	2115	Arock SD 81	410150000759	711	W W Jones Elementary School	Regular School	No	Elementary	KG	08	2018	grade_10								0.0								0
1187567	OR	school	4101500	2115	Arock SD 81	410150000759	711	W W Jones Elementary School	Regular School	No	Elementary	KG	08	2018	grade_11								0.0								0
1189026	OR	school	4101500	2115	Arock SD 81	410150000759	711	W W Jones Elementary School	Regular School	No	Elementary	KG	08	2018	grade_12								0.0								0
1190485	OR	school	4101500	2115	Arock SD 81	410150000759	711	W W Jones Elementary School	Regular School	No	Elementary	KG	08	2018	k_12_total	14.0	0.0	1.0	0.0	0.0	0.0	0.0		14	0	1	0	0	0	0
1171519	OR	school	4101560	2041	Ashland SD 5	410156000401	381	Ashland High School	Regular School	No	High	09	12	2018	kindergarten								0.0								0
1171520	OR	school	4101560	2041	Ashland SD 5	410156000400	380	Ashland Middle School	Regular School	No	Middle	06	08	2018	kindergarten								0.0								0
1171521	OR	school	4101560	2041	Ashland SD 5		2041	Ashland SD 5						2018	kindergarten								24.0								24
1171522	OR	school	4101560	2041	Ashland SD 5	410156000395	375	Bellview Elementary School	Regular School	No	Elementary	KG	05	2018	kindergarten								47.0								47
1171523	OR	school	4101560	2041	Ashland SD 5	410156000397	377	Helman Elementary School	Regular School	No	Elementary	KG	05	2018	kindergarten								64.0								64
1171524	OR	school	4101560	2041	Ashland SD 5	410156001654	4476	John Muir Elementary School	Regular School	No	Elementary	KG	08	2018	kindergarten								12.0								12
1171525	OR	school	4101560	2041	Ashland SD 5	410156000399	379	Walker Elementary School	Regular School	No	Elementary	KG	05	2018	kindergarten								46.0								46
1172978	OR	school	4101560	2041	Ashland SD 5	410156000401	381	Ashland High School	Regular School	No	High	09	12	2018	grade_1								0.0								0
1172979	OR	school	4101560	2041	Ashland SD 5	410156000400	380	Ashland Middle School	Regular School	No	Middle	06	08	2018	grade_1								0.0								0
1172980	OR	school	4101560	2041	Ashland SD 5		2041	Ashland SD 5						2018	grade_1								24.0								24
1172981	OR	school	4101560	2041	Ashland SD 5	410156000395	375	Bellview Elementary School	Regular School	No	Elementary	KG	05	2018	grade_1								52.0								52
1172982	OR	school	4101560	2041	Ashland SD 5	410156000397	377	Helman Elementary School	Regular School	No	Elementary	KG	05	2018	grade_1								51.0								51
1172983	OR	school	4101560	2041	Ashland SD 5	410156001654	4476	John Muir Elementary School	Regular School	No	Elementary	KG	08	2018	grade_1								13.0								13
1172984	OR	school	4101560	2041	Ashland SD 5	410156000399	379	Walker Elementary School	Regular School	No	Elementary	KG	05	2018	grade_1								59.0								59
1174437	OR	school	4101560	2041	Ashland SD 5	410156000401	381	Ashland High School	Regular School	No	High	09	12	2018	grade_2								0.0								0
1174438	OR	school	4101560	2041	Ashland SD 5	410156000400	380	Ashland Middle School	Regular School	No	Middle	06	08	2018	grade_2								0.0								0
1174439	OR	school	4101560	2041	Ashland SD 5		2041	Ashland SD 5						2018	grade_2								24.0								24
1174440	OR	school	4101560	2041	Ashland SD 5	410156000395	375	Bellview Elementary School	Regular School	No	Elementary	KG	05	2018	grade_2								51.0								51
1174441	OR	school	4101560	2041	Ashland SD 5	410156000397	377	Helman Elementary School	Regular School	No	Elementary	KG	05	2018	grade_2								51.0								51