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
650924	OR	school	4101710	1894	Baker SD 5J	410171001783	4759	Baker Early College	Regular School	Yes	High	09	12	2021	grade_9	2	2
650925	OR	school	4101710	1894	Baker SD 5J	410171001878	5509	Baker Early Learning Center	Regular School	No	Elementary	KG	KG	2021	grade_9	0	0
650926	OR	school	4101710	1894	Baker SD 5J	410171000009	8	Baker High School	Regular School	No	High	09	12	2021	grade_9	120	120
650927	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2021	grade_9	0	0
650928	OR	school	4101710	1894	Baker SD 5J		1894	Baker SD 5J						2021	grade_9	-
650929	OR	school	4101710	1894	Baker SD 5J	410171001879	5604	Baker Virtual Academy	Regular School	No	Elementary	KG	06	2021	grade_9	0	0
650930	OR	school	4101710	1894	Baker SD 5J	410171001767	4728	Baker Web Academy	Regular School	Yes	Other	KG	12	2021	grade_9	249	249
650931	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	01	03	2021	grade_9	0	0
650932	OR	school	4101710	1894	Baker SD 5J	410171001516	3493	EAGLE CAP Innovative HS	Alternative School	No	High	07	12	2021	grade_9	20	20
650933	OR	school	4101710	1894	Baker SD 5J	410171000030	4	Haines Elementary School	Regular School	No	Elementary	KG	06	2021	grade_9	0	0
650934	OR	school	4101710	1894	Baker SD 5J	410171000034	5	Keating Elementary School	Regular School	No	Elementary	KG	06	2021	grade_9	0	0
650935	OR	school	4101710	1894	Baker SD 5J	410171000007	7	South Baker Intermediate School	Regular School	No	Middle	04	06	2021	grade_9	0	0
910830	OR	school	4101710	1894	Baker SD 5J	410171001783	4759	Baker Early College	Regular School	Yes	High	09	12	2020	grade_9	4	4
910831	OR	school	4101710	1894	Baker SD 5J	410171000009	8	Baker High School	Regular School	No	High	09	12	2020	grade_9	129	129
910832	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2020	grade_9	0	0
910833	OR	school	4101710	1894	Baker SD 5J		1894	Baker SD 5J						2020	grade_9	0	0
910834	OR	school	4101710	1894	Baker SD 5J	410171001767	4728	Baker Web Academy	Regular School	Yes	Other	KG	12	2020	grade_9	228	228
910835	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2020	grade_9	0	0
910836	OR	school	4101710	1894	Baker SD 5J	410171001516	3493	EAGLE CAP Innovative HS	Alternative School	No	High	07	12	2020	grade_9	5	5
910837	OR	school	4101710	1894	Baker SD 5J	410171000030	4	Haines Elementary School	Regular School	No	Elementary	KG	06	2020	grade_9	0	0
910838	OR	school	4101710	1894	Baker SD 5J	410171000034	5	Keating Elementary School	Regular School	No	Elementary	KG	06	2020	grade_9	0	0
910839	OR	school	4101710	1894	Baker SD 5J	410171000007	7	South Baker Intermediate School	Regular School	No	Middle	04	06	2020	grade_9	0	0
1184666	OR	school	4101710	1894	Baker SD 5J	410171001783	4759	Baker Early College	Regular School	Yes	High	09	12	2018	grade_9	1.0	1
1184667	OR	school	4101710	1894	Baker SD 5J	410171000009	8	Baker High School	Regular School	No	High	09	12	2018	grade_9	115.0	115
1184668	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2018	grade_9	0.0	0
1184669	OR	school	4101710	1894	Baker SD 5J		1894	Baker SD 5J						2018	grade_9	0.0	0
1184670	OR	school	4101710	1894	Baker SD 5J	410171001767	4728	Baker Web Academy	Regular School	Yes	Other	KG	12	2018	grade_9	155.0	155
1184671	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2018	grade_9	0.0	0
1184672	OR	school	4101710	1894	Baker SD 5J	410171001516	3493	EAGLE CAP Innovative HS	Alternative School	No	High	09	12	2018	grade_9	3.0	3
1184673	OR	school	4101710	1894	Baker SD 5J	410171000030	4	Haines Elementary School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0
1184674	OR	school	4101710	1894	Baker SD 5J	410171000034	5	Keating Elementary School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0
1184675	OR	school	4101710	1894	Baker SD 5J	410171000007	7	South Baker Intermediate School	Regular School	No	Middle	04	06	2018	grade_9	0.0	0
1699437	OR	school	4101710	1894	Baker SD 5J	410171001783	4759	Baker Early College	Regular School	Yes	High	09	12	2017	grade_9	1.0	1
1699438	OR	school	4101710	1894	Baker SD 5J	410171000009	8	Baker High School	Regular School	No	High	09	12	2017	grade_9	126.0	126
1699439	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2017	grade_9	0.0	0
1699440	OR	school	4101710	1894	Baker SD 5J		1894	Baker SD 5J						2017	grade_9	1.0	1
1699441	OR	school	4101710	1894	Baker SD 5J	410171001767	4728	Baker Web Academy	Regular School	Yes	Other	KG	12	2017	grade_9	125.0	125
1699442	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2017	grade_9	0.0	0
1699443	OR	school	4101710	1894	Baker SD 5J	410171001516	3493	EAGLE CAP Innovative HS	Alternative School	No	High	09	12	2017	grade_9	0.0	0
1699444	OR	school	4101710	1894	Baker SD 5J	410171000030	4	Haines Elementary School	Regular School	No	Elementary	KG	06	2017	grade_9	0.0	0
1699445	OR	school	4101710	1894	Baker SD 5J	410171000034	5	Keating Elementary School	Regular School	No	Elementary	KG	06	2017	grade_9	0.0	0
1699446	OR	school	4101710	1894	Baker SD 5J	410171000007	7	South Baker Intermediate School	Regular School	No	Elementary	04	06	2017	grade_9	0.0	0
651476	OR	school	4106600	1895	Huntington SD 16J	410660000011	3351	Huntington School	Regular School	Yes	Other	KG	12	2021	grade_9	0	0
911375	OR	school	4106600	1895	Huntington SD 16J	410660000011	3351	Huntington School	Regular School	Yes	Other	KG	12	2020	grade_9	6	6
1185209	OR	school	4106600	1895	Huntington SD 16J	410660000011	3351	Huntington School	Regular School	Yes	Other	KG	12	2018	grade_9	5.0	5
1699985	OR	school	4106600	1895	Huntington SD 16J	410660000011	3351	Huntington School	Regular School	Yes	Other	KG	12	2017	grade_9	6.0	6
651066	OR	school	4101740	1896	Burnt River SD 30J	410174000013	3347	Burnt River School	Regular School	Yes	Other	KG	12	2021	grade_9	4	4
910969	OR	school	4101740	1896	Burnt River SD 30J	410174000013	3347	Burnt River School	Regular School	Yes	Other	KG	12	2020	grade_9	2	2
1184803	OR	school	4101740	1896	Burnt River SD 30J	410174000013	3347	Burnt River School	Regular School	Yes	Other	KG	12	2018	grade_9	1.0	1
1699572	OR	school	4101740	1896	Burnt River SD 30J	410174000013	3347	Burnt River School	Regular School	Yes	Other	KG	12	2017	grade_9	1.0	1
651879	OR	school	4109720	1897	Pine Eagle SD 61	410972000016	15	Pine Eagle Charter School	Regular School	Yes	Other	KG	12	2021	grade_9	16	16
911773	OR	school	4109720	1897	Pine Eagle SD 61	410972000016	15	Pine Eagle Charter School	Regular School	Yes	Other	KG	12	2020	grade_9	14	14
1185609	OR	school	4109720	1897	Pine Eagle SD 61	410972000016	15	Pine Eagle Charter School	Regular School	Yes	Other	KG	12	2018	grade_9	16.0	16
1700390	OR	school	4109720	1897	Pine Eagle SD 61	410972000016	15	Pine Eagle Charter School	Regular School	Yes	Other	KG	12	2017	grade_9	8.0	8
651667	OR	school	4108430	1898	Monroe SD 1J	410843000027	1321	Monroe Grade School	Regular School	No	Elementary	KG	08	2021	grade_9	0	0
651668	OR	school	4108430	1898	Monroe SD 1J	410843000050	43	Monroe High School	Regular School	No	High	09	12	2021	grade_9	30	30
911564	OR	school	4108430	1898	Monroe SD 1J	410843000027	1321	Monroe Grade School	Regular School	No	Elementary	KG	08	2020	grade_9	0	0
911565	OR	school	4108430	1898	Monroe SD 1J	410843000050	43	Monroe High School	Regular School	No	High	09	12	2020	grade_9	33	33
1185394	OR	school	4108430	1898	Monroe SD 1J	410843000027	1321	Monroe Grade School	Regular School	No	Elementary	KG	08	2018	grade_9	0.0	0
1185395	OR	school	4108430	1898	Monroe SD 1J	410843000050	43	Monroe High School	Regular School	No	High	09	12	2018	grade_9	36.0	36
1700172	OR	school	4108430	1898	Monroe SD 1J	410843000027	1321	Monroe Grade School	Regular School	No	Elementary	KG	08	2017	grade_9	0.0	0
1700173	OR	school	4108430	1898	Monroe SD 1J	410843000050	43	Monroe High School	Regular School	No	High	09	12	2017	grade_9	34.0	34
650899	OR	school	4101200	1899	Alsea SD 7J	410120000019	17	Alsea Charter School	Regular School	Yes	Other	KG	12	2021	grade_9	29	29
910805	OR	school	4101200	1899	Alsea SD 7J	410120000019	17	Alsea Charter School	Regular School	Yes	Other	KG	12	2020	grade_9	27	27
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
1699411	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Elementary	KG	06	2017	grade_9	0.0	0
1699412	OR	school	4101200	1899	Alsea SD 7J	410120000019	17	Alsea High School	Regular School	No	High	07	12	2017	grade_9	10.0	10
651862	OR	school	4109600	1900	Philomath SD 17J	410960000020	18	Blodgett Elementary School	Regular School	No	Elementary	KG	04	2021	grade_9	0	0
651863	OR	school	4109600	1900	Philomath SD 17J	410960001481	3162	Clemens Primary School	Regular School	No	Elementary	KG	01	2021	grade_9	0	0
651864	OR	school	4109600	1900	Philomath SD 17J	410960000021	3440	Kings Valley Charter School	Regular School	Yes	Other	KG	12	2021	grade_9	11	11
651865	OR	school	4109600	1900	Philomath SD 17J	410960001880	5492	Philomath Academy	Alternative School	No	Other	KG	12	2021	grade_9	15	15
651866	OR	school	4109600	1900	Philomath SD 17J	410960000022	20	Philomath Elementary School	Regular School	No	Elementary	02	05	2021	grade_9	0	0
651867	OR	school	4109600	1900	Philomath SD 17J	410960000024	22	Philomath High School	Regular School	No	High	09	12	2021	grade_9	104	104
651868	OR	school	4109600	1900	Philomath SD 17J	410960000023	21	Philomath Middle School	Regular School	No	Middle	06	08	2021	grade_9	0	0
911757	OR	school	4109600	1900	Philomath SD 17J	410960000020	18	Blodgett Elementary School	Regular School	No	Elementary	KG	04	2020	grade_9	0	0
911758	OR	school	4109600	1900	Philomath SD 17J	410960001481	3162	Clemens Primary School	Regular School	No	Elementary	KG	01	2020	grade_9	0	0
911759	OR	school	4109600	1900	Philomath SD 17J	410960000021	3440	Kings Valley Charter School	Regular School	Yes	Other	KG	12	2020	grade_9	13	13
911760	OR	school	4109600	1900	Philomath SD 17J	410960000022	20	Philomath Elementary School	Regular School	No	Elementary	02	05	2020	grade_9	0	0
911761	OR	school	4109600	1900	Philomath SD 17J	410960000024	22	Philomath High School	Regular School	No	High	09	12	2020	grade_9	128	128
911762	OR	school	4109600	1900	Philomath SD 17J	410960000023	21	Philomath Middle School	Regular School	No	Middle	06	08	2020	grade_9	0	0
1185593	OR	school	4109600	1900	Philomath SD 17J	410960000020	18	Blodgett Elementary School	Regular School	No	Elementary	KG	04	2018	grade_9	0.0	0
1185594	OR	school	4109600	1900	Philomath SD 17J	410960001481	3162	Clemens Primary School	Regular School	No	Elementary	KG	01	2018	grade_9	0.0	0
1185595	OR	school	4109600	1900	Philomath SD 17J	410960000021	3440	Kings Valley Charter School	Regular School	Yes	Other	KG	12	2018	grade_9	16.0	16
1185596	OR	school	4109600	1900	Philomath SD 17J	410960000022	20	Philomath Elementary School	Regular School	No	Elementary	02	05	2018	grade_9	0.0	0
1185597	OR	school	4109600	1900	Philomath SD 17J	410960000024	22	Philomath High School	Regular School	No	High	09	12	2018	grade_9	131.0	131
1185598	OR	school	4109600	1900	Philomath SD 17J	410960000023	21	Philomath Middle School	Regular School	No	Middle	06	08	2018	grade_9	0.0	0
1700374	OR	school	4109600	1900	Philomath SD 17J	410960000020	18	Blodgett Elementary School	Regular School	No	Elementary	KG	04	2017	grade_9	0.0	0
1700375	OR	school	4109600	1900	Philomath SD 17J	410960001481	3162	Clemens Primary School	Regular School	No	Elementary	KG	01	2017	grade_9	0.0	0
1700376	OR	school	4109600	1900	Philomath SD 17J	410960000021	3440	Kings Valley Charter School	Regular School	Yes	Other	KG	12	2017	grade_9	14.0	14
1700377	OR	school	4109600	1900	Philomath SD 17J	410960000022	20	Philomath Elementary School	Regular School	No	Elementary	02	05	2017	grade_9	0.0	0
1700378	OR	school	4109600	1900	Philomath SD 17J	410960000024	22	Philomath High School	Regular School	No	High	09	12	2017	grade_9	102.0	102
1700379	OR	school	4109600	1900	Philomath SD 17J	410960000023	21	Philomath Middle School	Regular School	No	Middle	06	08	2017	grade_9	0.0	0
651145	OR	school	4103480	1901	Corvallis SD 509J	410348000032	27	Adams Elementary School	Regular School	No	Elementary	KG	05	2021	grade_9	0	0
651146	OR	school	4103480	1901	Corvallis SD 509J	410348000033	28	Cheldelin Middle School	Regular School	No	Middle	06	08	2021	grade_9	0	0
651147	OR	school	4103480	1901	Corvallis SD 509J	410348000047	40	Corvallis High School	Regular School	No	High	09	12	2021	grade_9	257	257
651148	OR	school	4103480	1901	Corvallis SD 509J		1901	Corvallis SD 509J						2021	grade_9	47	47
651149	OR	school	4103480	1901	Corvallis SD 509J	410348000048	41	Crescent Valley High School	Regular School	No	High	09	12	2021	grade_9	220	220
651150	OR	school	4103480	1901	Corvallis SD 509J	410348000570	1322	Franklin School	Regular School	No	Elementary	KG	08	2021	grade_9	0	0
651151	OR	school	4103480	1901	Corvallis SD 509J	410348000037	30	Garfield Elementary School	Regular School	No	Elementary	KG	05	2021	grade_9	0	0
651152	OR	school	4103480	1901	Corvallis SD 509J	410348000040	33	Husky Elementary School	Regular School	No	Elementary	KG	05	2021	grade_9	0	0