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 "year" = :p2 order by school_nces_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
1185041	OR	school	4100003	2193	Falls City SD 57	410000301061	1005	Falls City Elementary School	Regular School	No	Elementary	KG	08	2018	grade_9	0.0	0
1185042	OR	school	4100003	2193	Falls City SD 57	410000301062	1006	Falls City High School	Regular School	No	High	09	12	2018	grade_9	18.0	18
1185560	OR	school	4100009	2336	Oregon Department of Education	410000900062	1832	Oregon School for the Deaf	Special Education School	No	Other	KG	12	2018	grade_9	10.0	10
1185559	OR	school	4100009	2336	Oregon Department of Education	410000901592	4040	Four Rivers Community School	Regular School	Yes	Other	KG	10	2018	grade_9	21.0	21
1185561	OR	school	4100009	2336	Oregon Department of Education	410000901734	4604	The Cottonwood School of Civics and Science	Regular School	Yes	Elementary	KG	08	2018	grade_9	0.0	0
1185562	OR	school	4100009	2336	Oregon Department of Education	410000901784	4720	The Ivy School	Regular School	Yes	Elementary	01	08	2018	grade_9	0.0	0
1185558	OR	school	4100009	2336	Oregon Department of Education	410000901808	4850	Eagle Charter School	Regular School	Yes	Elementary	KG	05	2018	grade_9	0.0	0
1186035	OR	school	4100014	2116	Vale SD 84	410001400748	701	Vale Elementary School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0
1186039	OR	school	4100014	2116	Vale SD 84	410001400754	706	Willowcreek Elementary School	Regular School	No	Elementary	01	08	2018	grade_9	0.0	0
1186036	OR	school	4100014	2116	Vale SD 84	410001400761	713	Vale High School	Regular School	No	High	09	12	2018	grade_9	77.0	77
1186037	OR	school	4100014	2116	Vale SD 84	410001401026	1357	Vale Middle School	Regular School	No	Middle	07	08	2018	grade_9	0.0	0
1185069	OR	school	4100015	2137	Gervais SD 1	410001500821	776	Gervais Elementary School	Regular School	No	Elementary	KG	05	2018	grade_9	0.0	0
1185071	OR	school	4100015	2137	Gervais SD 1	410001500831	786	Gervais Middle School	Regular School	No	Middle	06	08	2018	grade_9	0.0	0
1185070	OR	school	4100015	2137	Gervais SD 1	410001500853	808	Gervais High School	Regular School	No	High	09	12	2018	grade_9	94.0	94
1185072	OR	school	4100015	2137	Gervais SD 1	410001501588	4024	Samuel Brown Academy	Alternative School	No	High	06	12	2018	grade_9	2.0	2
1185068	OR	school	4100015	2137	Gervais SD 1	410001501859	5392	Frontier Charter Academy	Regular School	Yes	Middle	05	09	2018	grade_9	32.0	32
1186090	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601266	1213	Yamhill Carlton Elementary School	Regular School	No	Elementary	KG	04	2018	grade_9	0.0	0
1186091	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601288	1238	Yamhill Carlton High School	Regular School	No	High	09	12	2018	grade_9	77.0	77
1186092	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601730	4564	Yamhill Carlton Intermediate School	Regular School	No	Middle	05	08	2018	grade_9	0.0	0
1185149	OR	school	4100019	2099	Harrisburg SD 7J	410001900698	659	Harrisburg Elementary School	Regular School	No	Elementary	KG	05	2018	grade_9	0.0	0
1185150	OR	school	4100019	2099	Harrisburg SD 7J	410001900731	689	Harrisburg High School	Regular School	No	High	09	12	2018	grade_9	65.0	65
1185151	OR	school	4100019	2099	Harrisburg SD 7J	410001901422	2723	Harrisburg Middle School	Regular School	No	Middle	06	08	2018	grade_9	0.0	0
1185482	OR	school	4100020	2143	North Santiam SD 29J	410002000693	656	Mari-Linn Elementary School	Regular School	No	Elementary	KG	08	2018	grade_9	0.0	0
1185486	OR	school	4100020	2143	North Santiam SD 29J	410002000765	717	Sublimity Elementary School	Regular School	No	Elementary	KG	08	2018	grade_9	0.0	0
1185483	OR	school	4100020	2143	North Santiam SD 29J	410002000833	788	Stayton Elementary School	Regular School	No	Elementary	KG	03	2018	grade_9	0.0	0
1185485	OR	school	4100020	2143	North Santiam SD 29J	410002000834	789	Stayton Middle School	Regular School	No	Middle	04	08	2018	grade_9	0.0	0
1185484	OR	school	4100020	2143	North Santiam SD 29J	410002000854	809	Stayton High School	Regular School	No	High	09	12	2018	grade_9	176.0	176
1185923	OR	school	4100021	2225	South Wasco County SD 1	410002101166	1108	Maupin Elementary School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0
1185924	OR	school	4100021	2225	South Wasco County SD 1	410002101167	1109	South Wasco County High School	Regular School	No	High	07	12	2018	grade_9	19.0	19
1185194	OR	school	4100023	2239	Hillsboro SD 1J	410002300209	1302	Tobias Elementary School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0
1185197	OR	school	4100023	2239	Hillsboro SD 1J	410002301168	1111	West Union Elementary School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0
1185163	OR	school	4100023	2239	Hillsboro SD 1J	410002301169	1112	Brookwood Elementary School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0
1185167	OR	school	4100023	2239	Hillsboro SD 1J	410002301171	1115	Eastwood Elementary School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0
1185196	OR	school	4100023	2239	Hillsboro SD 1J	410002301172	1114	W Verne McKinney Elementary School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0
1185185	OR	school	4100023	2239	Hillsboro SD 1J	410002301173	1117	Mooberry Elementary School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0
1185195	OR	school	4100023	2239	Hillsboro SD 1J	410002301175	1119	W L Henry Elementary School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0
1185164	OR	school	4100023	2239	Hillsboro SD 1J	410002301199	1147	Butternut Creek Elementary School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0
1185191	OR	school	4100023	2239	Hillsboro SD 1J	410002301200	1149	Reedville Elementary School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0
1185180	OR	school	4100023	2239	Hillsboro SD 1J	410002301201	1150	Ladd Acres Elementary School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0
1185198	OR	school	4100023	2239	Hillsboro SD 1J	410002301202	1151	Witch Hazel Elementary School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0
1185172	OR	school	4100023	2239	Hillsboro SD 1J	410002301203	1152	Groner K-8	Regular School	No	Elementary	KG	08	2018	grade_9	0.0	0
1185169	OR	school	4100023	2239	Hillsboro SD 1J	410002301242	1189	Farmington View Elementary School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0
1185186	OR	school	4100023	2239	Hillsboro SD 1J	410002301243	1190	North Plains Elementary School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0
1185165	OR	school	4100023	2239	Hillsboro SD 1J	410002301248	1368	Century High School	Regular School	No	High	09	12	2018	grade_9	394.0	394
1185190	OR	school	4100023	2239	Hillsboro SD 1J	410002301250	1196	R A Brown Middle School	Regular School	No	Middle	07	08	2018	grade_9	0.0	0
1185178	OR	school	4100023	2239	Hillsboro SD 1J	410002301251	1199	J W Poynter Middle School	Regular School	No	Middle	07	08	2018	grade_9	0.0	0
1185173	OR	school	4100023	2239	Hillsboro SD 1J	410002301252	1201	Hillsboro High School	Regular School	No	High	09	12	2018	grade_9	325.0	325
1185193	OR	school	4100023	2239	Hillsboro SD 1J	410002301253	1198	South Meadows Middle School	Regular School	No	Middle	07	08	2018	grade_9	0.0	0
1185177	OR	school	4100023	2239	Hillsboro SD 1J	410002301295	1148	Indian Hills Elementary School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0
1185181	OR	school	4100023	2239	Hillsboro SD 1J	410002301300	1110	Lenox Elementary School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0
1185184	OR	school	4100023	2239	Hillsboro SD 1J	410002301305	1116	Minter Bridge Elementary School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0
1185171	OR	school	4100023	2239	Hillsboro SD 1J	410002301306	1200	Glencoe High School	Regular School	No	High	09	12	2018	grade_9	393.0	393
1185168	OR	school	4100023	2239	Hillsboro SD 1J	410002301322	1197	Evergreen Jr High School	Regular School	No	Middle	07	08	2018	grade_9	0.0	0
1185179	OR	school	4100023	2239	Hillsboro SD 1J	410002301373	1285	Jackson Elementary School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0
1185187	OR	school	4100023	2239	Hillsboro SD 1J	410002301499	3160	Orenco Elementary School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0
1185188	OR	school	4100023	2239	Hillsboro SD 1J	410002301500	3159	Paul L Patterson Elementary School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0
1185166	OR	school	4100023	2239	Hillsboro SD 1J	410002301535	4206	City View Charter School	Regular School	Yes	Elementary	KG	08	2018	grade_9	0.0	0
1185182	OR	school	4100023	2239	Hillsboro SD 1J	410002301585	4018	Liberty High School	Regular School	No	High	09	12	2018	grade_9	388.0	388
1185183	OR	school	4100023	2239	Hillsboro SD 1J	410002301749	4642	Lincoln Street Elementary School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0
1185192	OR	school	4100023	2239	Hillsboro SD 1J	410002301750	4703	Rosedale Elementary School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0
1185189	OR	school	4100023	2239	Hillsboro SD 1J	410002301759	4643	Quatama Elementary School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0
1185170	OR	school	4100023	2239	Hillsboro SD 1J	410002301764	4641	Free Orchards Elementary School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0
1185174	OR	school	4100023	2239	Hillsboro SD 1J	410002301824	4973	Hillsboro Online Academy	Regular School	No	Other	KG	12	2018	grade_9	16.0	16
1185176	OR	school	4100023	2239	Hillsboro SD 1J	410002304174	3536	Imlay Elementary School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0
1185271	OR	school	4100040	2262	Knappa SD 4	410004000176	166	Hilda Lahti Elementary School	Regular School	No	Elementary	KG	08	2018	grade_9	0.0	0
1185272	OR	school	4100040	2262	Knappa SD 4	410004000179	169	Knappa High School	Regular School	No	High	09	12	2018	grade_9	30.0	30
1185527	OR	school	4100043	3477	ODE YCEP District	410004300490	1827	Robert S Farrell High School	Regular School	No	Not Reported	M	M	2018	grade_9	0.0	0
1185531	OR	school	4100043	3477	ODE YCEP District	410004300494	1828	William P Lord High School	Regular School	No	High	06	12	2018	grade_9	6.0	6
1185522	OR	school	4100043	3477	ODE YCEP District	410004301404	2258	Monroe School	Regular School	No	High	06	12	2018	grade_9	0.0	0
1185523	OR	school	4100043	3477	ODE YCEP District	410004301406	2260	New Bridge High School	Regular School	No	High	06	12	2018	grade_9	2.0	2
1185524	OR	school	4100043	3477	ODE YCEP District	410004301412	2387	Ocean Dunes High School	Regular School	No	High	09	12	2018	grade_9	0.0	0
1185526	OR	school	4100043	3477	ODE YCEP District	410004301413	2388	Riverside High School	Regular School	No	High	10	12	2018	grade_9	0.0	0
1185528	OR	school	4100043	3477	ODE YCEP District	410004301476	2385	South Jetty High School	Regular School	No	High	06	12	2018	grade_9	0.0	0
1185525	OR	school	4100043	3477	ODE YCEP District	410004301477	2386	RiverBend High School	Regular School	No	High	09	12	2018	grade_9	0.0	0
1185530	OR	school	4100043	3477	ODE YCEP District	410004301740	4588	Trask River High School	Regular School	No	High	06	12	2018	grade_9	2.0	2
1185529	OR	school	4100043	3477	ODE YCEP District	410004301744	4609	Three Lakes High School	Regular School	No	High	06	12	2018	grade_9	2.0	2
1185212	OR	school	4100047	3997	Ione SD R2	410004700862	3363	Ione Community Charter School	Regular School	Yes	Other	KG	12	2018	grade_9	14.0	14
1185487	OR	school	4100048	4131	North Wasco County SD 21	410004801151	1093	Chenowith Elementary School	Regular School	No	Elementary	KG	05	2018	grade_9	0.0	0
1185491	OR	school	4100048	4131	North Wasco County SD 21	410004801153	1095	Mosier Community School	Regular School	Yes	Elementary	KG	08	2018	grade_9	0.0	0
1185488	OR	school	4100048	4131	North Wasco County SD 21	410004801155	1097	Colonel Wright Elementary School	Regular School	No	Elementary	KG	05	2018	grade_9	0.0	0
1185490	OR	school	4100048	4131	North Wasco County SD 21	410004801156	1098	Dry Hollow Elementary School	Regular School	No	Elementary	KG	05	2018	grade_9	0.0	0
1185494	OR	school	4100048	4131	North Wasco County SD 21	410004801158	1100	The Dalles Middle School	Regular School	No	Middle	06	08	2018	grade_9	0.0	0
1185493	OR	school	4100048	4131	North Wasco County SD 21	410004801159	1101	The Dalles High School	Regular School	No	High	09	12	2018	grade_9	218.0	218
1185495	OR	school	4100048	4131	North Wasco County SD 21	410004801833	5250	Wahtonka Community School	Alternative School	No	High	09	12	2018	grade_9	4.0	4
1185418	OR	school	4100640	1968	Myrtle Point SD 41	410064000233	214	Myrtle Crest School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0
1185419	OR	school	4100640	1968	Myrtle Point SD 41	410064000234	215	Myrtle Point High School	Regular School	No	High	07	12	2018	grade_9	44.0	44
1184637	OR	school	4100990	2063	Adel SD 21	410099000524	498	Adel Elementary School	Regular School	No	Middle	04	08	2018	grade_9	0.0	0
1184638	OR	school	4101020	2113	Adrian SD 61	410102000755	707	Adrian Elementary School	Regular School	No	Elementary	KG	08	2018	grade_9	0.0	0
1184639	OR	school	4101020	2113	Adrian SD 61	410102000756	708	Adrian High School	Regular School	No	High	09	12	2018	grade_9	22.0	22
1185107	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000017	639	Oak Grove Elementary School	Regular School	No	Elementary	02	05	2018	grade_9	0.0	0
1185104	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000029	637	North Albany Elementary School	Regular School	No	Elementary	KG	05	2018	grade_9	0.0	0
1185099	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000031	635	Fir Grove Primary School	Regular School	No	Elementary	KG	01	2018	grade_9	0.0	0
1185097	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000669	631	Central Elementary School	Regular School	No	Elementary	03	05	2018	grade_9	0.0	0
1185101	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000670	640	Lafayette Elementary School	Regular School	No	Elementary	KG	05	2018	grade_9	0.0	0
1185102	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000671	641	Liberty Elementary School	Regular School	No	Elementary	KG	05	2018	grade_9	0.0	0
1185106	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000672	643	Oak Elementary School	Regular School	No	Elementary	KG	05	2018	grade_9	0.0	0
1185111	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000673	644	Sunrise Elementary School	Regular School	No	Elementary	KG	05	2018	grade_9	0.0	0
1185110	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000674	645	South Shore Elementary School	Regular School	No	Elementary	KG	05	2018	grade_9	0.0	0
1185112	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000675	647	Takena Elementary School	Regular School	No	Elementary	KG	02	2018	grade_9	0.0	0
1185115	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000676	648	Waverly Elementary School	Regular School	No	Elementary	KG	05	2018	grade_9	0.0	0
1185108	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000680	636	Periwinkle Elementary School	Regular School	No	Elementary	KG	05	2018	grade_9	0.0	0