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 "grade" = :p0 and "state" = :p1 order by district_state_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	ccd_school_type	ccd_charter_school	ccd_school_lvl	ccd_school_low_grade	ccd_school_high_grade	year	grade	total	total_int
645040	OR	school	4101710	1894	Baker SD 5J	410171001783	4759	Baker Early College	Regular School	Yes	High	09	12	2021	grade_5	0	0
645041	OR	school	4101710	1894	Baker SD 5J	410171001878	5509	Baker Early Learning Center	Regular School	No	Elementary	KG	KG	2021	grade_5	0	0
645042	OR	school	4101710	1894	Baker SD 5J	410171000009	8	Baker High School	Regular School	No	High	09	12	2021	grade_5	0	0
645043	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2021	grade_5	0	0
645044	OR	school	4101710	1894	Baker SD 5J		1894	Baker SD 5J						2021	grade_5	-
645045	OR	school	4101710	1894	Baker SD 5J	410171001879	5604	Baker Virtual Academy	Regular School	No	Elementary	KG	06	2021	grade_5	10	10
645046	OR	school	4101710	1894	Baker SD 5J	410171001767	4728	Baker Web Academy	Regular School	Yes	Other	KG	12	2021	grade_5	209	209
645047	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	01	03	2021	grade_5	0	0
645048	OR	school	4101710	1894	Baker SD 5J	410171001516	3493	EAGLE CAP Innovative HS	Alternative School	No	High	07	12	2021	grade_5	0	0
645049	OR	school	4101710	1894	Baker SD 5J	410171000030	4	Haines Elementary School	Regular School	No	Elementary	KG	06	2021	grade_5	16	16
645050	OR	school	4101710	1894	Baker SD 5J	410171000034	5	Keating Elementary School	Regular School	No	Elementary	KG	06	2021	grade_5	3	3
645051	OR	school	4101710	1894	Baker SD 5J	410171000007	7	South Baker Intermediate School	Regular School	No	Middle	04	06	2021	grade_5	90	90
904994	OR	school	4101710	1894	Baker SD 5J	410171001783	4759	Baker Early College	Regular School	Yes	High	09	12	2020	grade_5	0	0
904995	OR	school	4101710	1894	Baker SD 5J	410171000009	8	Baker High School	Regular School	No	High	09	12	2020	grade_5	0	0
904996	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2020	grade_5	0	0
904997	OR	school	4101710	1894	Baker SD 5J		1894	Baker SD 5J						2020	grade_5	0	0
904998	OR	school	4101710	1894	Baker SD 5J	410171001767	4728	Baker Web Academy	Regular School	Yes	Other	KG	12	2020	grade_5	115	115
904999	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2020	grade_5	0	0
905000	OR	school	4101710	1894	Baker SD 5J	410171001516	3493	EAGLE CAP Innovative HS	Alternative School	No	High	07	12	2020	grade_5	0	0
905001	OR	school	4101710	1894	Baker SD 5J	410171000030	4	Haines Elementary School	Regular School	No	Elementary	KG	06	2020	grade_5	23	23
905002	OR	school	4101710	1894	Baker SD 5J	410171000034	5	Keating Elementary School	Regular School	No	Elementary	KG	06	2020	grade_5	4	4
905003	OR	school	4101710	1894	Baker SD 5J	410171000007	7	South Baker Intermediate School	Regular School	No	Middle	04	06	2020	grade_5	119	119
1178830	OR	school	4101710	1894	Baker SD 5J	410171001783	4759	Baker Early College	Regular School	Yes	High	09	12	2018	grade_5	0.0	0
1178831	OR	school	4101710	1894	Baker SD 5J	410171000009	8	Baker High School	Regular School	No	High	09	12	2018	grade_5	0.0	0
1178832	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2018	grade_5	0.0	0
1178833	OR	school	4101710	1894	Baker SD 5J		1894	Baker SD 5J						2018	grade_5	0.0	0
1178834	OR	school	4101710	1894	Baker SD 5J	410171001767	4728	Baker Web Academy	Regular School	Yes	Other	KG	12	2018	grade_5	97.0	97
1178835	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2018	grade_5	0.0	0
1178836	OR	school	4101710	1894	Baker SD 5J	410171001516	3493	EAGLE CAP Innovative HS	Alternative School	No	High	09	12	2018	grade_5	0.0	0
1178837	OR	school	4101710	1894	Baker SD 5J	410171000030	4	Haines Elementary School	Regular School	No	Elementary	KG	06	2018	grade_5	17.0	17
1178838	OR	school	4101710	1894	Baker SD 5J	410171000034	5	Keating Elementary School	Regular School	No	Elementary	KG	06	2018	grade_5	6.0	6
1178839	OR	school	4101710	1894	Baker SD 5J	410171000007	7	South Baker Intermediate School	Regular School	No	Middle	04	06	2018	grade_5	115.0	115
1693557	OR	school	4101710	1894	Baker SD 5J	410171001783	4759	Baker Early College	Regular School	Yes	High	09	12	2017	grade_5	0.0	0
1693558	OR	school	4101710	1894	Baker SD 5J	410171000009	8	Baker High School	Regular School	No	High	09	12	2017	grade_5	0.0	0
1693559	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2017	grade_5	0.0	0
1693560	OR	school	4101710	1894	Baker SD 5J		1894	Baker SD 5J						2017	grade_5	0.0	0
1693561	OR	school	4101710	1894	Baker SD 5J	410171001767	4728	Baker Web Academy	Regular School	Yes	Other	KG	12	2017	grade_5	64.0	64
1693562	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2017	grade_5	0.0	0
1693563	OR	school	4101710	1894	Baker SD 5J	410171001516	3493	EAGLE CAP Innovative HS	Alternative School	No	High	09	12	2017	grade_5	0.0	0
1693564	OR	school	4101710	1894	Baker SD 5J	410171000030	4	Haines Elementary School	Regular School	No	Elementary	KG	06	2017	grade_5	25.0	25
1693565	OR	school	4101710	1894	Baker SD 5J	410171000034	5	Keating Elementary School	Regular School	No	Elementary	KG	06	2017	grade_5	2.0	2
1693566	OR	school	4101710	1894	Baker SD 5J	410171000007	7	South Baker Intermediate School	Regular School	No	Elementary	04	06	2017	grade_5	105.0	105
645592	OR	school	4106600	1895	Huntington SD 16J	410660000011	3351	Huntington School	Regular School	Yes	Other	KG	12	2021	grade_5	0	0
905539	OR	school	4106600	1895	Huntington SD 16J	410660000011	3351	Huntington School	Regular School	Yes	Other	KG	12	2020	grade_5	3	3
1179373	OR	school	4106600	1895	Huntington SD 16J	410660000011	3351	Huntington School	Regular School	Yes	Other	KG	12	2018	grade_5	7.0	7
1694105	OR	school	4106600	1895	Huntington SD 16J	410660000011	3351	Huntington School	Regular School	Yes	Other	KG	12	2017	grade_5	5.0	5
645182	OR	school	4101740	1896	Burnt River SD 30J	410174000013	3347	Burnt River School	Regular School	Yes	Other	KG	12	2021	grade_5	2	2
905133	OR	school	4101740	1896	Burnt River SD 30J	410174000013	3347	Burnt River School	Regular School	Yes	Other	KG	12	2020	grade_5	0	0
1178967	OR	school	4101740	1896	Burnt River SD 30J	410174000013	3347	Burnt River School	Regular School	Yes	Other	KG	12	2018	grade_5	1.0	1
1693692	OR	school	4101740	1896	Burnt River SD 30J	410174000013	3347	Burnt River School	Regular School	Yes	Other	KG	12	2017	grade_5	1.0	1
645995	OR	school	4109720	1897	Pine Eagle SD 61	410972000016	15	Pine Eagle Charter School	Regular School	Yes	Other	KG	12	2021	grade_5	19	19
905937	OR	school	4109720	1897	Pine Eagle SD 61	410972000016	15	Pine Eagle Charter School	Regular School	Yes	Other	KG	12	2020	grade_5	14	14
1179773	OR	school	4109720	1897	Pine Eagle SD 61	410972000016	15	Pine Eagle Charter School	Regular School	Yes	Other	KG	12	2018	grade_5	10.0	10
1694510	OR	school	4109720	1897	Pine Eagle SD 61	410972000016	15	Pine Eagle Charter School	Regular School	Yes	Other	KG	12	2017	grade_5	22.0	22
645783	OR	school	4108430	1898	Monroe SD 1J	410843000027	1321	Monroe Grade School	Regular School	No	Elementary	KG	08	2021	grade_5	25	25
645784	OR	school	4108430	1898	Monroe SD 1J	410843000050	43	Monroe High School	Regular School	No	High	09	12	2021	grade_5	0	0
905728	OR	school	4108430	1898	Monroe SD 1J	410843000027	1321	Monroe Grade School	Regular School	No	Elementary	KG	08	2020	grade_5	25	25
905729	OR	school	4108430	1898	Monroe SD 1J	410843000050	43	Monroe High School	Regular School	No	High	09	12	2020	grade_5	0	0
1179558	OR	school	4108430	1898	Monroe SD 1J	410843000027	1321	Monroe Grade School	Regular School	No	Elementary	KG	08	2018	grade_5	29.0	29
1179559	OR	school	4108430	1898	Monroe SD 1J	410843000050	43	Monroe High School	Regular School	No	High	09	12	2018	grade_5	0.0	0
1694292	OR	school	4108430	1898	Monroe SD 1J	410843000027	1321	Monroe Grade School	Regular School	No	Elementary	KG	08	2017	grade_5	32.0	32
1694293	OR	school	4108430	1898	Monroe SD 1J	410843000050	43	Monroe High School	Regular School	No	High	09	12	2017	grade_5	0.0	0
645015	OR	school	4101200	1899	Alsea SD 7J	410120000019	17	Alsea Charter School	Regular School	Yes	Other	KG	12	2021	grade_5	31	31
904969	OR	school	4101200	1899	Alsea SD 7J	410120000019	17	Alsea Charter School	Regular School	Yes	Other	KG	12	2020	grade_5	18	18
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
1693531	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Elementary	KG	06	2017	grade_5	12.0	12
1693532	OR	school	4101200	1899	Alsea SD 7J	410120000019	17	Alsea High School	Regular School	No	High	07	12	2017	grade_5	0.0	0
645978	OR	school	4109600	1900	Philomath SD 17J	410960000020	18	Blodgett Elementary School	Regular School	No	Elementary	KG	04	2021	grade_5	0	0
645979	OR	school	4109600	1900	Philomath SD 17J	410960001481	3162	Clemens Primary School	Regular School	No	Elementary	KG	01	2021	grade_5	0	0
645980	OR	school	4109600	1900	Philomath SD 17J	410960000021	3440	Kings Valley Charter School	Regular School	Yes	Other	KG	12	2021	grade_5	20	20
645981	OR	school	4109600	1900	Philomath SD 17J	410960001880	5492	Philomath Academy	Alternative School	No	Other	KG	12	2021	grade_5	10	10
645982	OR	school	4109600	1900	Philomath SD 17J	410960000022	20	Philomath Elementary School	Regular School	No	Elementary	02	05	2021	grade_5	80	80
645983	OR	school	4109600	1900	Philomath SD 17J	410960000024	22	Philomath High School	Regular School	No	High	09	12	2021	grade_5	0	0
645984	OR	school	4109600	1900	Philomath SD 17J	410960000023	21	Philomath Middle School	Regular School	No	Middle	06	08	2021	grade_5	0	0
905921	OR	school	4109600	1900	Philomath SD 17J	410960000020	18	Blodgett Elementary School	Regular School	No	Elementary	KG	04	2020	grade_5	0	0
905922	OR	school	4109600	1900	Philomath SD 17J	410960001481	3162	Clemens Primary School	Regular School	No	Elementary	KG	01	2020	grade_5	0	0
905923	OR	school	4109600	1900	Philomath SD 17J	410960000021	3440	Kings Valley Charter School	Regular School	Yes	Other	KG	12	2020	grade_5	17	17
905924	OR	school	4109600	1900	Philomath SD 17J	410960000022	20	Philomath Elementary School	Regular School	No	Elementary	02	05	2020	grade_5	105	105
905925	OR	school	4109600	1900	Philomath SD 17J	410960000024	22	Philomath High School	Regular School	No	High	09	12	2020	grade_5	0	0
905926	OR	school	4109600	1900	Philomath SD 17J	410960000023	21	Philomath Middle School	Regular School	No	Middle	06	08	2020	grade_5	0	0
1179757	OR	school	4109600	1900	Philomath SD 17J	410960000020	18	Blodgett Elementary School	Regular School	No	Elementary	KG	04	2018	grade_5	0.0	0
1179758	OR	school	4109600	1900	Philomath SD 17J	410960001481	3162	Clemens Primary School	Regular School	No	Elementary	KG	01	2018	grade_5	0.0	0
1179759	OR	school	4109600	1900	Philomath SD 17J	410960000021	3440	Kings Valley Charter School	Regular School	Yes	Other	KG	12	2018	grade_5	16.0	16
1179760	OR	school	4109600	1900	Philomath SD 17J	410960000022	20	Philomath Elementary School	Regular School	No	Elementary	02	05	2018	grade_5	99.0	99
1179761	OR	school	4109600	1900	Philomath SD 17J	410960000024	22	Philomath High School	Regular School	No	High	09	12	2018	grade_5	0.0	0
1179762	OR	school	4109600	1900	Philomath SD 17J	410960000023	21	Philomath Middle School	Regular School	No	Middle	06	08	2018	grade_5	0.0	0
1694494	OR	school	4109600	1900	Philomath SD 17J	410960000020	18	Blodgett Elementary School	Regular School	No	Elementary	KG	04	2017	grade_5	0.0	0
1694495	OR	school	4109600	1900	Philomath SD 17J	410960001481	3162	Clemens Primary School	Regular School	No	Elementary	KG	01	2017	grade_5	0.0	0
1694496	OR	school	4109600	1900	Philomath SD 17J	410960000021	3440	Kings Valley Charter School	Regular School	Yes	Other	KG	12	2017	grade_5	15.0	15
1694497	OR	school	4109600	1900	Philomath SD 17J	410960000022	20	Philomath Elementary School	Regular School	No	Elementary	02	05	2017	grade_5	112.0	112
1694498	OR	school	4109600	1900	Philomath SD 17J	410960000024	22	Philomath High School	Regular School	No	High	09	12	2017	grade_5	0.0	0
1694499	OR	school	4109600	1900	Philomath SD 17J	410960000023	21	Philomath Middle School	Regular School	No	Middle	06	08	2017	grade_5	0.0	0
645261	OR	school	4103480	1901	Corvallis SD 509J	410348000032	27	Adams Elementary School	Regular School	No	Elementary	KG	05	2021	grade_5	60	60
645262	OR	school	4103480	1901	Corvallis SD 509J	410348000033	28	Cheldelin Middle School	Regular School	No	Middle	06	08	2021	grade_5	0	0
645263	OR	school	4103480	1901	Corvallis SD 509J	410348000047	40	Corvallis High School	Regular School	No	High	09	12	2021	grade_5	0	0
645264	OR	school	4103480	1901	Corvallis SD 509J		1901	Corvallis SD 509J						2021	grade_5	46	46
645265	OR	school	4103480	1901	Corvallis SD 509J	410348000048	41	Crescent Valley High School	Regular School	No	High	09	12	2021	grade_5	0	0
645266	OR	school	4103480	1901	Corvallis SD 509J	410348000570	1322	Franklin School	Regular School	No	Elementary	KG	08	2021	grade_5	27	27
645267	OR	school	4103480	1901	Corvallis SD 509J	410348000037	30	Garfield Elementary School	Regular School	No	Elementary	KG	05	2021	grade_5	72	72
645268	OR	school	4103480	1901	Corvallis SD 509J	410348000040	33	Husky Elementary School	Regular School	No	Elementary	KG	05	2021	grade_5	70	70