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
649453	OR	school	4101710	1894	Baker SD 5J	410171001783	4759	Baker Early College	Regular School	Yes	High	09	12	2021	grade_8	0	0
649454	OR	school	4101710	1894	Baker SD 5J	410171001878	5509	Baker Early Learning Center	Regular School	No	Elementary	KG	KG	2021	grade_8	0	0
649455	OR	school	4101710	1894	Baker SD 5J	410171000009	8	Baker High School	Regular School	No	High	09	12	2021	grade_8	0	0
649456	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2021	grade_8	118	118
649457	OR	school	4101710	1894	Baker SD 5J		1894	Baker SD 5J						2021	grade_8	-
649458	OR	school	4101710	1894	Baker SD 5J	410171001879	5604	Baker Virtual Academy	Regular School	No	Elementary	KG	06	2021	grade_8	0	0
649459	OR	school	4101710	1894	Baker SD 5J	410171001767	4728	Baker Web Academy	Regular School	Yes	Other	KG	12	2021	grade_8	288	288
649460	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	01	03	2021	grade_8	0	0
649461	OR	school	4101710	1894	Baker SD 5J	410171001516	3493	EAGLE CAP Innovative HS	Alternative School	No	High	07	12	2021	grade_8	24	24
649462	OR	school	4101710	1894	Baker SD 5J	410171000030	4	Haines Elementary School	Regular School	No	Elementary	KG	06	2021	grade_8	0	0
649463	OR	school	4101710	1894	Baker SD 5J	410171000034	5	Keating Elementary School	Regular School	No	Elementary	KG	06	2021	grade_8	0	0
649464	OR	school	4101710	1894	Baker SD 5J	410171000007	7	South Baker Intermediate School	Regular School	No	Middle	04	06	2021	grade_8	0	0
909371	OR	school	4101710	1894	Baker SD 5J	410171001783	4759	Baker Early College	Regular School	Yes	High	09	12	2020	grade_8	0	0
909372	OR	school	4101710	1894	Baker SD 5J	410171000009	8	Baker High School	Regular School	No	High	09	12	2020	grade_8	0	0
909373	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2020	grade_8	129	129
909374	OR	school	4101710	1894	Baker SD 5J		1894	Baker SD 5J						2020	grade_8	0	0
909375	OR	school	4101710	1894	Baker SD 5J	410171001767	4728	Baker Web Academy	Regular School	Yes	Other	KG	12	2020	grade_8	206	206
909376	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2020	grade_8	0	0
909377	OR	school	4101710	1894	Baker SD 5J	410171001516	3493	EAGLE CAP Innovative HS	Alternative School	No	High	07	12	2020	grade_8	1	1
909378	OR	school	4101710	1894	Baker SD 5J	410171000030	4	Haines Elementary School	Regular School	No	Elementary	KG	06	2020	grade_8	0	0
909379	OR	school	4101710	1894	Baker SD 5J	410171000034	5	Keating Elementary School	Regular School	No	Elementary	KG	06	2020	grade_8	0	0
909380	OR	school	4101710	1894	Baker SD 5J	410171000007	7	South Baker Intermediate School	Regular School	No	Middle	04	06	2020	grade_8	0	0
1183207	OR	school	4101710	1894	Baker SD 5J	410171001783	4759	Baker Early College	Regular School	Yes	High	09	12	2018	grade_8	0.0	0
1183208	OR	school	4101710	1894	Baker SD 5J	410171000009	8	Baker High School	Regular School	No	High	09	12	2018	grade_8	0.0	0
1183209	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2018	grade_8	98.0	98
1183210	OR	school	4101710	1894	Baker SD 5J		1894	Baker SD 5J						2018	grade_8	0.0	0
1183211	OR	school	4101710	1894	Baker SD 5J	410171001767	4728	Baker Web Academy	Regular School	Yes	Other	KG	12	2018	grade_8	144.0	144
1183212	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2018	grade_8	0.0	0
1183213	OR	school	4101710	1894	Baker SD 5J	410171001516	3493	EAGLE CAP Innovative HS	Alternative School	No	High	09	12	2018	grade_8	0.0	0
1183214	OR	school	4101710	1894	Baker SD 5J	410171000030	4	Haines Elementary School	Regular School	No	Elementary	KG	06	2018	grade_8	0.0	0
1183215	OR	school	4101710	1894	Baker SD 5J	410171000034	5	Keating Elementary School	Regular School	No	Elementary	KG	06	2018	grade_8	0.0	0
1183216	OR	school	4101710	1894	Baker SD 5J	410171000007	7	South Baker Intermediate School	Regular School	No	Middle	04	06	2018	grade_8	0.0	0
1697967	OR	school	4101710	1894	Baker SD 5J	410171001783	4759	Baker Early College	Regular School	Yes	High	09	12	2017	grade_8	0.0	0
1697968	OR	school	4101710	1894	Baker SD 5J	410171000009	8	Baker High School	Regular School	No	High	09	12	2017	grade_8	0.0	0
1697969	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2017	grade_8	108.0	108
1697970	OR	school	4101710	1894	Baker SD 5J		1894	Baker SD 5J						2017	grade_8	1.0	1
1697971	OR	school	4101710	1894	Baker SD 5J	410171001767	4728	Baker Web Academy	Regular School	Yes	Other	KG	12	2017	grade_8	121.0	121
1697972	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2017	grade_8	0.0	0
1697973	OR	school	4101710	1894	Baker SD 5J	410171001516	3493	EAGLE CAP Innovative HS	Alternative School	No	High	09	12	2017	grade_8	0.0	0
1697974	OR	school	4101710	1894	Baker SD 5J	410171000030	4	Haines Elementary School	Regular School	No	Elementary	KG	06	2017	grade_8	0.0	0
1697975	OR	school	4101710	1894	Baker SD 5J	410171000034	5	Keating Elementary School	Regular School	No	Elementary	KG	06	2017	grade_8	0.0	0
1697976	OR	school	4101710	1894	Baker SD 5J	410171000007	7	South Baker Intermediate School	Regular School	No	Elementary	04	06	2017	grade_8	0.0	0
650005	OR	school	4106600	1895	Huntington SD 16J	410660000011	3351	Huntington School	Regular School	Yes	Other	KG	12	2021	grade_8	1	1
909916	OR	school	4106600	1895	Huntington SD 16J	410660000011	3351	Huntington School	Regular School	Yes	Other	KG	12	2020	grade_8	6	6
1183750	OR	school	4106600	1895	Huntington SD 16J	410660000011	3351	Huntington School	Regular School	Yes	Other	KG	12	2018	grade_8	7.0	7
1698515	OR	school	4106600	1895	Huntington SD 16J	410660000011	3351	Huntington School	Regular School	Yes	Other	KG	12	2017	grade_8	4.0	4
649595	OR	school	4101740	1896	Burnt River SD 30J	410174000013	3347	Burnt River School	Regular School	Yes	Other	KG	12	2021	grade_8	3	3
909510	OR	school	4101740	1896	Burnt River SD 30J	410174000013	3347	Burnt River School	Regular School	Yes	Other	KG	12	2020	grade_8	1	1
1183344	OR	school	4101740	1896	Burnt River SD 30J	410174000013	3347	Burnt River School	Regular School	Yes	Other	KG	12	2018	grade_8	1.0	1
1698102	OR	school	4101740	1896	Burnt River SD 30J	410174000013	3347	Burnt River School	Regular School	Yes	Other	KG	12	2017	grade_8	2.0	2
650408	OR	school	4109720	1897	Pine Eagle SD 61	410972000016	15	Pine Eagle Charter School	Regular School	Yes	Other	KG	12	2021	grade_8	12	12
910314	OR	school	4109720	1897	Pine Eagle SD 61	410972000016	15	Pine Eagle Charter School	Regular School	Yes	Other	KG	12	2020	grade_8	19	19
1184150	OR	school	4109720	1897	Pine Eagle SD 61	410972000016	15	Pine Eagle Charter School	Regular School	Yes	Other	KG	12	2018	grade_8	20.0	20
1698920	OR	school	4109720	1897	Pine Eagle SD 61	410972000016	15	Pine Eagle Charter School	Regular School	Yes	Other	KG	12	2017	grade_8	23.0	23
650196	OR	school	4108430	1898	Monroe SD 1J	410843000027	1321	Monroe Grade School	Regular School	No	Elementary	KG	08	2021	grade_8	22	22
650197	OR	school	4108430	1898	Monroe SD 1J	410843000050	43	Monroe High School	Regular School	No	High	09	12	2021	grade_8	0	0
910105	OR	school	4108430	1898	Monroe SD 1J	410843000027	1321	Monroe Grade School	Regular School	No	Elementary	KG	08	2020	grade_8	29	29
910106	OR	school	4108430	1898	Monroe SD 1J	410843000050	43	Monroe High School	Regular School	No	High	09	12	2020	grade_8	0	0
1183935	OR	school	4108430	1898	Monroe SD 1J	410843000027	1321	Monroe Grade School	Regular School	No	Elementary	KG	08	2018	grade_8	34.0	34
1183936	OR	school	4108430	1898	Monroe SD 1J	410843000050	43	Monroe High School	Regular School	No	High	09	12	2018	grade_8	0.0	0
1698702	OR	school	4108430	1898	Monroe SD 1J	410843000027	1321	Monroe Grade School	Regular School	No	Elementary	KG	08	2017	grade_8	40.0	40
1698703	OR	school	4108430	1898	Monroe SD 1J	410843000050	43	Monroe High School	Regular School	No	High	09	12	2017	grade_8	0.0	0
649428	OR	school	4101200	1899	Alsea SD 7J	410120000019	17	Alsea Charter School	Regular School	Yes	Other	KG	12	2021	grade_8	45	45
909346	OR	school	4101200	1899	Alsea SD 7J	410120000019	17	Alsea Charter School	Regular School	Yes	Other	KG	12	2020	grade_8	17	17
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
1697941	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Elementary	KG	06	2017	grade_8	0.0	0
1697942	OR	school	4101200	1899	Alsea SD 7J	410120000019	17	Alsea High School	Regular School	No	High	07	12	2017	grade_8	11.0	11
650391	OR	school	4109600	1900	Philomath SD 17J	410960000020	18	Blodgett Elementary School	Regular School	No	Elementary	KG	04	2021	grade_8	0	0
650392	OR	school	4109600	1900	Philomath SD 17J	410960001481	3162	Clemens Primary School	Regular School	No	Elementary	KG	01	2021	grade_8	0	0
650393	OR	school	4109600	1900	Philomath SD 17J	410960000021	3440	Kings Valley Charter School	Regular School	Yes	Other	KG	12	2021	grade_8	17	17
650394	OR	school	4109600	1900	Philomath SD 17J	410960001880	5492	Philomath Academy	Alternative School	No	Other	KG	12	2021	grade_8	19	19
650395	OR	school	4109600	1900	Philomath SD 17J	410960000022	20	Philomath Elementary School	Regular School	No	Elementary	02	05	2021	grade_8	0	0
650396	OR	school	4109600	1900	Philomath SD 17J	410960000024	22	Philomath High School	Regular School	No	High	09	12	2021	grade_8	0	0
650397	OR	school	4109600	1900	Philomath SD 17J	410960000023	21	Philomath Middle School	Regular School	No	Middle	06	08	2021	grade_8	92	92
910298	OR	school	4109600	1900	Philomath SD 17J	410960000020	18	Blodgett Elementary School	Regular School	No	Elementary	KG	04	2020	grade_8	0	0
910299	OR	school	4109600	1900	Philomath SD 17J	410960001481	3162	Clemens Primary School	Regular School	No	Elementary	KG	01	2020	grade_8	0	0
910300	OR	school	4109600	1900	Philomath SD 17J	410960000021	3440	Kings Valley Charter School	Regular School	Yes	Other	KG	12	2020	grade_8	14	14
910301	OR	school	4109600	1900	Philomath SD 17J	410960000022	20	Philomath Elementary School	Regular School	No	Elementary	02	05	2020	grade_8	0	0
910302	OR	school	4109600	1900	Philomath SD 17J	410960000024	22	Philomath High School	Regular School	No	High	09	12	2020	grade_8	0	0
910303	OR	school	4109600	1900	Philomath SD 17J	410960000023	21	Philomath Middle School	Regular School	No	Middle	06	08	2020	grade_8	131	131
1184134	OR	school	4109600	1900	Philomath SD 17J	410960000020	18	Blodgett Elementary School	Regular School	No	Elementary	KG	04	2018	grade_8	0.0	0
1184135	OR	school	4109600	1900	Philomath SD 17J	410960001481	3162	Clemens Primary School	Regular School	No	Elementary	KG	01	2018	grade_8	0.0	0
1184136	OR	school	4109600	1900	Philomath SD 17J	410960000021	3440	Kings Valley Charter School	Regular School	Yes	Other	KG	12	2018	grade_8	18.0	18
1184137	OR	school	4109600	1900	Philomath SD 17J	410960000022	20	Philomath Elementary School	Regular School	No	Elementary	02	05	2018	grade_8	0.0	0
1184138	OR	school	4109600	1900	Philomath SD 17J	410960000024	22	Philomath High School	Regular School	No	High	09	12	2018	grade_8	0.0	0
1184139	OR	school	4109600	1900	Philomath SD 17J	410960000023	21	Philomath Middle School	Regular School	No	Middle	06	08	2018	grade_8	112.0	112
1698904	OR	school	4109600	1900	Philomath SD 17J	410960000020	18	Blodgett Elementary School	Regular School	No	Elementary	KG	04	2017	grade_8	0.0	0
1698905	OR	school	4109600	1900	Philomath SD 17J	410960001481	3162	Clemens Primary School	Regular School	No	Elementary	KG	01	2017	grade_8	0.0	0
1698906	OR	school	4109600	1900	Philomath SD 17J	410960000021	3440	Kings Valley Charter School	Regular School	Yes	Other	KG	12	2017	grade_8	12.0	12
1698907	OR	school	4109600	1900	Philomath SD 17J	410960000022	20	Philomath Elementary School	Regular School	No	Elementary	02	05	2017	grade_8	0.0	0
1698908	OR	school	4109600	1900	Philomath SD 17J	410960000024	22	Philomath High School	Regular School	No	High	09	12	2017	grade_8	0.0	0
1698909	OR	school	4109600	1900	Philomath SD 17J	410960000023	21	Philomath Middle School	Regular School	No	Middle	06	08	2017	grade_8	121.0	121
649674	OR	school	4103480	1901	Corvallis SD 509J	410348000032	27	Adams Elementary School	Regular School	No	Elementary	KG	05	2021	grade_8	0	0
649675	OR	school	4103480	1901	Corvallis SD 509J	410348000033	28	Cheldelin Middle School	Regular School	No	Middle	06	08	2021	grade_8	154	154
649676	OR	school	4103480	1901	Corvallis SD 509J	410348000047	40	Corvallis High School	Regular School	No	High	09	12	2021	grade_8	0	0
649677	OR	school	4103480	1901	Corvallis SD 509J		1901	Corvallis SD 509J						2021	grade_8	92	92
649678	OR	school	4103480	1901	Corvallis SD 509J	410348000048	41	Crescent Valley High School	Regular School	No	High	09	12	2021	grade_8	0	0
649679	OR	school	4103480	1901	Corvallis SD 509J	410348000570	1322	Franklin School	Regular School	No	Elementary	KG	08	2021	grade_8	50	50
649680	OR	school	4103480	1901	Corvallis SD 509J	410348000037	30	Garfield Elementary School	Regular School	No	Elementary	KG	05	2021	grade_8	0	0
649681	OR	school	4103480	1901	Corvallis SD 509J	410348000040	33	Husky Elementary School	Regular School	No	Elementary	KG	05	2021	grade_8	0	0