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
655337	OR	school	4101710	1894	Baker SD 5J	410171001783	4759	Baker Early College	Regular School	Yes	High	09	12	2021	grade_12	142	142
655338	OR	school	4101710	1894	Baker SD 5J	410171001878	5509	Baker Early Learning Center	Regular School	No	Elementary	KG	KG	2021	grade_12	0	0
655339	OR	school	4101710	1894	Baker SD 5J	410171000009	8	Baker High School	Regular School	No	High	09	12	2021	grade_12	79	79
655340	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2021	grade_12	0	0
655341	OR	school	4101710	1894	Baker SD 5J		1894	Baker SD 5J						2021	grade_12	-
655342	OR	school	4101710	1894	Baker SD 5J	410171001879	5604	Baker Virtual Academy	Regular School	No	Elementary	KG	06	2021	grade_12	0	0
655343	OR	school	4101710	1894	Baker SD 5J	410171001767	4728	Baker Web Academy	Regular School	Yes	Other	KG	12	2021	grade_12	190	190
655344	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	01	03	2021	grade_12	0	0
655345	OR	school	4101710	1894	Baker SD 5J	410171001516	3493	EAGLE CAP Innovative HS	Alternative School	No	High	07	12	2021	grade_12	31	31
655346	OR	school	4101710	1894	Baker SD 5J	410171000030	4	Haines Elementary School	Regular School	No	Elementary	KG	06	2021	grade_12	0	0
655347	OR	school	4101710	1894	Baker SD 5J	410171000034	5	Keating Elementary School	Regular School	No	Elementary	KG	06	2021	grade_12	0	0
655348	OR	school	4101710	1894	Baker SD 5J	410171000007	7	South Baker Intermediate School	Regular School	No	Middle	04	06	2021	grade_12	0	0
915207	OR	school	4101710	1894	Baker SD 5J	410171001783	4759	Baker Early College	Regular School	Yes	High	09	12	2020	grade_12	153	153
915208	OR	school	4101710	1894	Baker SD 5J	410171000009	8	Baker High School	Regular School	No	High	09	12	2020	grade_12	108	108
915209	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2020	grade_12	0	0
915210	OR	school	4101710	1894	Baker SD 5J		1894	Baker SD 5J						2020	grade_12	0	0
915211	OR	school	4101710	1894	Baker SD 5J	410171001767	4728	Baker Web Academy	Regular School	Yes	Other	KG	12	2020	grade_12	184	184
915212	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2020	grade_12	0	0
915213	OR	school	4101710	1894	Baker SD 5J	410171001516	3493	EAGLE CAP Innovative HS	Alternative School	No	High	07	12	2020	grade_12	15	15
915214	OR	school	4101710	1894	Baker SD 5J	410171000030	4	Haines Elementary School	Regular School	No	Elementary	KG	06	2020	grade_12	0	0
915215	OR	school	4101710	1894	Baker SD 5J	410171000034	5	Keating Elementary School	Regular School	No	Elementary	KG	06	2020	grade_12	0	0
915216	OR	school	4101710	1894	Baker SD 5J	410171000007	7	South Baker Intermediate School	Regular School	No	Middle	04	06	2020	grade_12	0	0
1189043	OR	school	4101710	1894	Baker SD 5J	410171001783	4759	Baker Early College	Regular School	Yes	High	09	12	2018	grade_12	105.0	105
1189044	OR	school	4101710	1894	Baker SD 5J	410171000009	8	Baker High School	Regular School	No	High	09	12	2018	grade_12	105.0	105
1189045	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2018	grade_12	0.0	0
1189046	OR	school	4101710	1894	Baker SD 5J		1894	Baker SD 5J						2018	grade_12	7.0	7
1189047	OR	school	4101710	1894	Baker SD 5J	410171001767	4728	Baker Web Academy	Regular School	Yes	Other	KG	12	2018	grade_12	89.0	89
1189048	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2018	grade_12	0.0	0
1189049	OR	school	4101710	1894	Baker SD 5J	410171001516	3493	EAGLE CAP Innovative HS	Alternative School	No	High	09	12	2018	grade_12	14.0	14
1189050	OR	school	4101710	1894	Baker SD 5J	410171000030	4	Haines Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1189051	OR	school	4101710	1894	Baker SD 5J	410171000034	5	Keating Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1189052	OR	school	4101710	1894	Baker SD 5J	410171000007	7	South Baker Intermediate School	Regular School	No	Middle	04	06	2018	grade_12	0.0	0
1703847	OR	school	4101710	1894	Baker SD 5J	410171001783	4759	Baker Early College	Regular School	Yes	High	09	12	2017	grade_12	90.0	90
1703848	OR	school	4101710	1894	Baker SD 5J	410171000009	8	Baker High School	Regular School	No	High	09	12	2017	grade_12	110.0	110
1703849	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2017	grade_12	0.0	0
1703850	OR	school	4101710	1894	Baker SD 5J		1894	Baker SD 5J						2017	grade_12	7.0	7
1703851	OR	school	4101710	1894	Baker SD 5J	410171001767	4728	Baker Web Academy	Regular School	Yes	Other	KG	12	2017	grade_12	64.0	64
1703852	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2017	grade_12	0.0	0
1703853	OR	school	4101710	1894	Baker SD 5J	410171001516	3493	EAGLE CAP Innovative HS	Alternative School	No	High	09	12	2017	grade_12	6.0	6
1703854	OR	school	4101710	1894	Baker SD 5J	410171000030	4	Haines Elementary School	Regular School	No	Elementary	KG	06	2017	grade_12	0.0	0
1703855	OR	school	4101710	1894	Baker SD 5J	410171000034	5	Keating Elementary School	Regular School	No	Elementary	KG	06	2017	grade_12	0.0	0
1703856	OR	school	4101710	1894	Baker SD 5J	410171000007	7	South Baker Intermediate School	Regular School	No	Elementary	04	06	2017	grade_12	0.0	0
655889	OR	school	4106600	1895	Huntington SD 16J	410660000011	3351	Huntington School	Regular School	Yes	Other	KG	12	2021	grade_12	3	3
915752	OR	school	4106600	1895	Huntington SD 16J	410660000011	3351	Huntington School	Regular School	Yes	Other	KG	12	2020	grade_12	9	9
1189586	OR	school	4106600	1895	Huntington SD 16J	410660000011	3351	Huntington School	Regular School	Yes	Other	KG	12	2018	grade_12	3.0	3
1704395	OR	school	4106600	1895	Huntington SD 16J	410660000011	3351	Huntington School	Regular School	Yes	Other	KG	12	2017	grade_12	7.0	7
655479	OR	school	4101740	1896	Burnt River SD 30J	410174000013	3347	Burnt River School	Regular School	Yes	Other	KG	12	2021	grade_12	3	3
915346	OR	school	4101740	1896	Burnt River SD 30J	410174000013	3347	Burnt River School	Regular School	Yes	Other	KG	12	2020	grade_12	4	4
1189180	OR	school	4101740	1896	Burnt River SD 30J	410174000013	3347	Burnt River School	Regular School	Yes	Other	KG	12	2018	grade_12	2.0	2
1703982	OR	school	4101740	1896	Burnt River SD 30J	410174000013	3347	Burnt River School	Regular School	Yes	Other	KG	12	2017	grade_12	7.0	7
656292	OR	school	4109720	1897	Pine Eagle SD 61	410972000016	15	Pine Eagle Charter School	Regular School	Yes	Other	KG	12	2021	grade_12	18	18
916150	OR	school	4109720	1897	Pine Eagle SD 61	410972000016	15	Pine Eagle Charter School	Regular School	Yes	Other	KG	12	2020	grade_12	10	10
1189986	OR	school	4109720	1897	Pine Eagle SD 61	410972000016	15	Pine Eagle Charter School	Regular School	Yes	Other	KG	12	2018	grade_12	16.0	16
1704800	OR	school	4109720	1897	Pine Eagle SD 61	410972000016	15	Pine Eagle Charter School	Regular School	Yes	Other	KG	12	2017	grade_12	15.0	15
656080	OR	school	4108430	1898	Monroe SD 1J	410843000027	1321	Monroe Grade School	Regular School	No	Elementary	KG	08	2021	grade_12	0	0
656081	OR	school	4108430	1898	Monroe SD 1J	410843000050	43	Monroe High School	Regular School	No	High	09	12	2021	grade_12	33	33
915941	OR	school	4108430	1898	Monroe SD 1J	410843000027	1321	Monroe Grade School	Regular School	No	Elementary	KG	08	2020	grade_12	0	0
915942	OR	school	4108430	1898	Monroe SD 1J	410843000050	43	Monroe High School	Regular School	No	High	09	12	2020	grade_12	22	22
1189771	OR	school	4108430	1898	Monroe SD 1J	410843000027	1321	Monroe Grade School	Regular School	No	Elementary	KG	08	2018	grade_12	0.0	0
1189772	OR	school	4108430	1898	Monroe SD 1J	410843000050	43	Monroe High School	Regular School	No	High	09	12	2018	grade_12	35.0	35
1704582	OR	school	4108430	1898	Monroe SD 1J	410843000027	1321	Monroe Grade School	Regular School	No	Elementary	KG	08	2017	grade_12	0.0	0
1704583	OR	school	4108430	1898	Monroe SD 1J	410843000050	43	Monroe High School	Regular School	No	High	09	12	2017	grade_12	27.0	27
655312	OR	school	4101200	1899	Alsea SD 7J	410120000019	17	Alsea Charter School	Regular School	Yes	Other	KG	12	2021	grade_12	34	34
915182	OR	school	4101200	1899	Alsea SD 7J	410120000019	17	Alsea Charter School	Regular School	Yes	Other	KG	12	2020	grade_12	66	66
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
1703821	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Elementary	KG	06	2017	grade_12	0.0	0
1703822	OR	school	4101200	1899	Alsea SD 7J	410120000019	17	Alsea High School	Regular School	No	High	07	12	2017	grade_12	15.0	15
656275	OR	school	4109600	1900	Philomath SD 17J	410960000020	18	Blodgett Elementary School	Regular School	No	Elementary	KG	04	2021	grade_12	0	0
656276	OR	school	4109600	1900	Philomath SD 17J	410960001481	3162	Clemens Primary School	Regular School	No	Elementary	KG	01	2021	grade_12	0	0
656277	OR	school	4109600	1900	Philomath SD 17J	410960000021	3440	Kings Valley Charter School	Regular School	Yes	Other	KG	12	2021	grade_12	12	12
656278	OR	school	4109600	1900	Philomath SD 17J	410960001880	5492	Philomath Academy	Alternative School	No	Other	KG	12	2021	grade_12	31	31
656279	OR	school	4109600	1900	Philomath SD 17J	410960000022	20	Philomath Elementary School	Regular School	No	Elementary	02	05	2021	grade_12	0	0
656280	OR	school	4109600	1900	Philomath SD 17J	410960000024	22	Philomath High School	Regular School	No	High	09	12	2021	grade_12	100	100
656281	OR	school	4109600	1900	Philomath SD 17J	410960000023	21	Philomath Middle School	Regular School	No	Middle	06	08	2021	grade_12	0	0
916134	OR	school	4109600	1900	Philomath SD 17J	410960000020	18	Blodgett Elementary School	Regular School	No	Elementary	KG	04	2020	grade_12	0	0
916135	OR	school	4109600	1900	Philomath SD 17J	410960001481	3162	Clemens Primary School	Regular School	No	Elementary	KG	01	2020	grade_12	0	0
916136	OR	school	4109600	1900	Philomath SD 17J	410960000021	3440	Kings Valley Charter School	Regular School	Yes	Other	KG	12	2020	grade_12	10	10
916137	OR	school	4109600	1900	Philomath SD 17J	410960000022	20	Philomath Elementary School	Regular School	No	Elementary	02	05	2020	grade_12	0	0
916138	OR	school	4109600	1900	Philomath SD 17J	410960000024	22	Philomath High School	Regular School	No	High	09	12	2020	grade_12	117	117
916139	OR	school	4109600	1900	Philomath SD 17J	410960000023	21	Philomath Middle School	Regular School	No	Middle	06	08	2020	grade_12	0	0
1189970	OR	school	4109600	1900	Philomath SD 17J	410960000020	18	Blodgett Elementary School	Regular School	No	Elementary	KG	04	2018	grade_12	0.0	0
1189971	OR	school	4109600	1900	Philomath SD 17J	410960001481	3162	Clemens Primary School	Regular School	No	Elementary	KG	01	2018	grade_12	0.0	0
1189972	OR	school	4109600	1900	Philomath SD 17J	410960000021	3440	Kings Valley Charter School	Regular School	Yes	Other	KG	12	2018	grade_12	11.0	11
1189973	OR	school	4109600	1900	Philomath SD 17J	410960000022	20	Philomath Elementary School	Regular School	No	Elementary	02	05	2018	grade_12	0.0	0
1189974	OR	school	4109600	1900	Philomath SD 17J	410960000024	22	Philomath High School	Regular School	No	High	09	12	2018	grade_12	115.0	115
1189975	OR	school	4109600	1900	Philomath SD 17J	410960000023	21	Philomath Middle School	Regular School	No	Middle	06	08	2018	grade_12	0.0	0
1704784	OR	school	4109600	1900	Philomath SD 17J	410960000020	18	Blodgett Elementary School	Regular School	No	Elementary	KG	04	2017	grade_12	0.0	0
1704785	OR	school	4109600	1900	Philomath SD 17J	410960001481	3162	Clemens Primary School	Regular School	No	Elementary	KG	01	2017	grade_12	0.0	0
1704786	OR	school	4109600	1900	Philomath SD 17J	410960000021	3440	Kings Valley Charter School	Regular School	Yes	Other	KG	12	2017	grade_12	12.0	12
1704787	OR	school	4109600	1900	Philomath SD 17J	410960000022	20	Philomath Elementary School	Regular School	No	Elementary	02	05	2017	grade_12	0.0	0
1704788	OR	school	4109600	1900	Philomath SD 17J	410960000024	22	Philomath High School	Regular School	No	High	09	12	2017	grade_12	115.0	115
1704789	OR	school	4109600	1900	Philomath SD 17J	410960000023	21	Philomath Middle School	Regular School	No	Middle	06	08	2017	grade_12	0.0	0
655558	OR	school	4103480	1901	Corvallis SD 509J	410348000032	27	Adams Elementary School	Regular School	No	Elementary	KG	05	2021	grade_12	0	0
655559	OR	school	4103480	1901	Corvallis SD 509J	410348000033	28	Cheldelin Middle School	Regular School	No	Middle	06	08	2021	grade_12	0	0
655560	OR	school	4103480	1901	Corvallis SD 509J	410348000047	40	Corvallis High School	Regular School	No	High	09	12	2021	grade_12	280	280
655561	OR	school	4103480	1901	Corvallis SD 509J		1901	Corvallis SD 509J						2021	grade_12	97	97
655562	OR	school	4103480	1901	Corvallis SD 509J	410348000048	41	Crescent Valley High School	Regular School	No	High	09	12	2021	grade_12	214	214
655563	OR	school	4103480	1901	Corvallis SD 509J	410348000570	1322	Franklin School	Regular School	No	Elementary	KG	08	2021	grade_12	0	0
655564	OR	school	4103480	1901	Corvallis SD 509J	410348000037	30	Garfield Elementary School	Regular School	No	Elementary	KG	05	2021	grade_12	0	0
655565	OR	school	4103480	1901	Corvallis SD 509J	410348000040	33	Husky Elementary School	Regular School	No	Elementary	KG	05	2021	grade_12	0	0