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 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	total	total_int
1693552	OR	school	4101620	1933	Astoria SD 1	410162000155	146	Astoria Senior High School	Regular School	No	High	09	12	2017	grade_5	0.0	0
1693553	OR	school	4101620	1933	Astoria SD 1	410162000156	147	Lewis & Clark Elementary School	Regular School	No	Elementary	03	05	2017	grade_5	148.0	148
645037	OR	school	4101660	2208	Athena-Weston SD 29RJ	410166001112	1053	Athena Elementary School	Regular School	No	Elementary	PK	03	2021	grade_5	0	0
645038	OR	school	4101660	2208	Athena-Weston SD 29RJ	410166001114	1055	Weston Middle School	Regular School	No	Middle	04	08	2021	grade_5	37	37
645039	OR	school	4101660	2208	Athena-Weston SD 29RJ	410166001115	1056	Weston-McEwen High School	Regular School	No	High	09	12	2021	grade_5	0	0
904991	OR	school	4101660	2208	Athena-Weston SD 29RJ	410166001112	1053	Athena Elementary School	Regular School	No	Elementary	KG	03	2020	grade_5	0	0
904992	OR	school	4101660	2208	Athena-Weston SD 29RJ	410166001114	1055	Weston Middle School	Regular School	No	Middle	04	08	2020	grade_5	42	42
904993	OR	school	4101660	2208	Athena-Weston SD 29RJ	410166001115	1056	Weston-McEwen High School	Regular School	No	High	09	12	2020	grade_5	0	0
1178827	OR	school	4101660	2208	Athena-Weston SD 29RJ	410166001112	1053	Athena Elementary School	Regular School	No	Elementary	KG	03	2018	grade_5	0.0	0
1178828	OR	school	4101660	2208	Athena-Weston SD 29RJ	410166001114	1055	Weston Middle School	Regular School	No	Middle	04	08	2018	grade_5	49.0	49
1178829	OR	school	4101660	2208	Athena-Weston SD 29RJ	410166001115	1056	Weston-McEwen High School	Regular School	No	High	09	12	2018	grade_5	0.0	0
1693554	OR	school	4101660	2208	Athena-Weston SD 29RJ	410166001112	1053	Athena Elementary School	Regular School	No	Elementary	KG	03	2017	grade_5	0.0	0
1693555	OR	school	4101660	2208	Athena-Weston SD 29RJ	410166001114	1055	Weston Middle School	Regular School	No	Elementary	04	08	2017	grade_5	44.0	44
1693556	OR	school	4101660	2208	Athena-Weston SD 29RJ	410166001115	1056	Weston-McEwen High School	Regular School	No	High	09	12	2017	grade_5	0.0	0
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
645052	OR	school	4101800	1969	Bandon SD 54	410180000237	218	Bandon Senior High School	Regular School	No	High	09	12	2021	grade_5	0	0
645053	OR	school	4101800	1969	Bandon SD 54	410180000235	216	Harbor Lights Middle School	Regular School	No	Middle	05	08	2021	grade_5	50	50
645054	OR	school	4101800	1969	Bandon SD 54	410180000236	217	Ocean Crest Elementary School	Regular School	No	Elementary	KG	04	2021	grade_5	0	0
905004	OR	school	4101800	1969	Bandon SD 54	410180000237	218	Bandon Senior High School	Regular School	No	High	09	12	2020	grade_5	0	0
905005	OR	school	4101800	1969	Bandon SD 54	410180000235	216	Harbor Lights Middle School	Regular School	No	Middle	05	08	2020	grade_5	52	52
905006	OR	school	4101800	1969	Bandon SD 54	410180000236	217	Ocean Crest Elementary School	Regular School	No	Elementary	KG	04	2020	grade_5	0	0
1178840	OR	school	4101800	1969	Bandon SD 54	410180000237	218	Bandon Senior High School	Regular School	No	High	09	12	2018	grade_5	0.0	0
1178841	OR	school	4101800	1969	Bandon SD 54	410180000235	216	Harbor Lights Middle School	Regular School	No	Middle	05	08	2018	grade_5	65.0	65
1178842	OR	school	4101800	1969	Bandon SD 54	410180000236	217	Ocean Crest Elementary School	Regular School	No	Elementary	KG	04	2018	grade_5	0.0	0
1693567	OR	school	4101800	1969	Bandon SD 54	410180000237	218	Bandon Senior High School	Regular School	No	High	09	12	2017	grade_5	0.0	0
1693568	OR	school	4101800	1969	Bandon SD 54	410180000235	216	Harbor Lights Middle School	Regular School	No	Middle	05	08	2017	grade_5	54.0	54
1693569	OR	school	4101800	1969	Bandon SD 54	410180000236	217	Ocean Crest Elementary School	Regular School	No	Elementary	KG	04	2017	grade_5	0.0	0
645055	OR	school	4101830	2240	Banks SD 13	410183001176	1120	Banks Elementary School	Regular School	No	Elementary	KG	05	2021	grade_5	83	83
645056	OR	school	4101830	2240	Banks SD 13	410183001180	1124	Banks High School	Regular School	No	High	09	12	2021	grade_5	0	0
645057	OR	school	4101830	2240	Banks SD 13	410183001179	1123	Banks Middle School	Regular School	No	Middle	06	08	2021	grade_5	0	0
645058	OR	school	4101830	2240	Banks SD 13		2240	Banks SD 13						2021	grade_5	0	0
905007	OR	school	4101830	2240	Banks SD 13	410183001176	1120	Banks Elementary School	Regular School	No	Elementary	KG	05	2020	grade_5	91	91
905008	OR	school	4101830	2240	Banks SD 13	410183001180	1124	Banks High School	Regular School	No	High	09	12	2020	grade_5	0	0
905009	OR	school	4101830	2240	Banks SD 13	410183001179	1123	Banks Middle School	Regular School	No	Middle	06	08	2020	grade_5	0	0
905010	OR	school	4101830	2240	Banks SD 13		2240	Banks SD 13						2020	grade_5	0	0
1178843	OR	school	4101830	2240	Banks SD 13	410183001176	1120	Banks Elementary School	Regular School	No	Elementary	KG	05	2018	grade_5	83.0	83
1178844	OR	school	4101830	2240	Banks SD 13	410183001180	1124	Banks High School	Regular School	No	High	09	12	2018	grade_5	0.0	0
1178845	OR	school	4101830	2240	Banks SD 13	410183001179	1123	Banks Middle School	Regular School	No	Middle	06	08	2018	grade_5	0.0	0
1178846	OR	school	4101830	2240	Banks SD 13		2240	Banks SD 13						2018	grade_5	1.0	1
1693570	OR	school	4101830	2240	Banks SD 13	410183001176	1120	Banks Elementary School	Regular School	No	Elementary	KG	05	2017	grade_5	81.0	81
1693571	OR	school	4101830	2240	Banks SD 13	410183001180	1124	Banks High School	Regular School	No	High	09	12	2017	grade_5	0.0	0
1693572	OR	school	4101830	2240	Banks SD 13	410183001179	1123	Banks Middle School	Regular School	No	Middle	06	08	2017	grade_5	0.0	0
1693573	OR	school	4101830	2240	Banks SD 13		2240	Banks SD 13						2017	grade_5	0.0	0
645059	OR	school	4101920	2243	Beaverton SD 48J	410192001239	1186	Aloha High School	Regular School	No	High	09	12	2021	grade_5	0	0
645060	OR	school	4101920	2243	Beaverton SD 48J	410192001204	1153	Aloha-Huber Park School	Regular School	No	Elementary	PK	08	2021	grade_5	118	118
645061	OR	school	4101920	2243	Beaverton SD 48J	410192001791	4805	Arco Iris Spanish Immersion School	Regular School	Yes	Elementary	KG	08	2021	grade_5	44	44
645062	OR	school	4101920	2243	Beaverton SD 48J	410192000213	1304	Arts and Communication Magnet Academy	Regular School	No	High	06	12	2021	grade_5	0	0
645063	OR	school	4101920	2243	Beaverton SD 48J	410192001205	1154	Barnes Elementary School	Regular School	No	Elementary	PK	05	2021	grade_5	79	79
645064	OR	school	4101920	2243	Beaverton SD 48J	410192001206	1155	Beaver Acres Elementary School	Regular School	No	Elementary	KG	05	2021	grade_5	123	123
645065	OR	school	4101920	2243	Beaverton SD 48J	410192001745	4638	Beaverton Academy of Science and Engineering	Regular School	No	High	06	12	2021	grade_5	0	0
645066	OR	school	4101920	2243	Beaverton SD 48J	410192001240	1187	Beaverton High School	Regular School	No	High	09	12	2021	grade_5	0	0
645067	OR	school	4101920	2243	Beaverton SD 48J		2243	Beaverton SD 48J						2021	grade_5	0	0
645068	OR	school	4101920	2243	Beaverton SD 48J	410192001207	1156	Bethany Elementary School	Regular School	No	Elementary	KG	05	2021	grade_5	80	80
645069	OR	school	4101920	2243	Beaverton SD 48J	410192001753	4671	Bonny Slope Elementary School	Regular School	No	Elementary	PK	05	2021	grade_5	109	109
645070	OR	school	4101920	2243	Beaverton SD 48J	410192001210	1158	Cedar Mill Elementary School	Regular School	No	Elementary	KG	05	2021	grade_5	77	77
645071	OR	school	4101920	2243	Beaverton SD 48J	410192001233	1180	Cedar Park Middle School	Regular School	No	Middle	06	08	2021	grade_5	0	0
645072	OR	school	4101920	2243	Beaverton SD 48J	410192001211	1159	Chehalem Elementary School	Regular School	No	Elementary	KG	05	2021	grade_5	87	87
645073	OR	school	4101920	2243	Beaverton SD 48J	410192000220	1305	Community School	Alternative School	No	High	09	12	2021	grade_5	0	0
645074	OR	school	4101920	2243	Beaverton SD 48J	410192000552	1319	Conestoga Middle School	Regular School	No	Middle	06	08	2021	grade_5	0	0
645075	OR	school	4101920	2243	Beaverton SD 48J	410192001212	1160	Cooper Mountain Elementary School	Regular School	No	Elementary	KG	05	2021	grade_5	70	70