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
1189418	OR	school	4100003	2193	Falls City SD 57	410000301061	1005	Falls City Elementary School	Regular School	No	Elementary	KG	08	2018	grade_12	0.0	0
1189419	OR	school	4100003	2193	Falls City SD 57	410000301062	1006	Falls City High School	Regular School	No	High	09	12	2018	grade_12	18.0	18
1189937	OR	school	4100009	2336	Oregon Department of Education	410000900062	1832	Oregon School for the Deaf	Special Education School	No	Other	KG	12	2018	grade_12	34.0	34
1189936	OR	school	4100009	2336	Oregon Department of Education	410000901592	4040	Four Rivers Community School	Regular School	Yes	Other	KG	10	2018	grade_12	0.0	0
1189938	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_12	0.0	0
1189939	OR	school	4100009	2336	Oregon Department of Education	410000901784	4720	The Ivy School	Regular School	Yes	Elementary	01	08	2018	grade_12	0.0	0
1189935	OR	school	4100009	2336	Oregon Department of Education	410000901808	4850	Eagle Charter School	Regular School	Yes	Elementary	KG	05	2018	grade_12	0.0	0
1190412	OR	school	4100014	2116	Vale SD 84	410001400748	701	Vale Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1190416	OR	school	4100014	2116	Vale SD 84	410001400754	706	Willowcreek Elementary School	Regular School	No	Elementary	01	08	2018	grade_12	0.0	0
1190413	OR	school	4100014	2116	Vale SD 84	410001400761	713	Vale High School	Regular School	No	High	09	12	2018	grade_12	71.0	71
1190414	OR	school	4100014	2116	Vale SD 84	410001401026	1357	Vale Middle School	Regular School	No	Middle	07	08	2018	grade_12	0.0	0
1189446	OR	school	4100015	2137	Gervais SD 1	410001500821	776	Gervais Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1189448	OR	school	4100015	2137	Gervais SD 1	410001500831	786	Gervais Middle School	Regular School	No	Middle	06	08	2018	grade_12	0.0	0
1189447	OR	school	4100015	2137	Gervais SD 1	410001500853	808	Gervais High School	Regular School	No	High	09	12	2018	grade_12	78.0	78
1189449	OR	school	4100015	2137	Gervais SD 1	410001501588	4024	Samuel Brown Academy	Alternative School	No	High	06	12	2018	grade_12	24.0	24
1189445	OR	school	4100015	2137	Gervais SD 1	410001501859	5392	Frontier Charter Academy	Regular School	Yes	Middle	05	09	2018	grade_12	0.0	0
1190467	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601266	1213	Yamhill Carlton Elementary School	Regular School	No	Elementary	KG	04	2018	grade_12	0.0	0
1190468	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601288	1238	Yamhill Carlton High School	Regular School	No	High	09	12	2018	grade_12	87.0	87
1190469	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601730	4564	Yamhill Carlton Intermediate School	Regular School	No	Middle	05	08	2018	grade_12	0.0	0
1189526	OR	school	4100019	2099	Harrisburg SD 7J	410001900698	659	Harrisburg Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1189527	OR	school	4100019	2099	Harrisburg SD 7J	410001900731	689	Harrisburg High School	Regular School	No	High	09	12	2018	grade_12	83.0	83
1189528	OR	school	4100019	2099	Harrisburg SD 7J	410001901422	2723	Harrisburg Middle School	Regular School	No	Middle	06	08	2018	grade_12	0.0	0
1189859	OR	school	4100020	2143	North Santiam SD 29J	410002000693	656	Mari-Linn Elementary School	Regular School	No	Elementary	KG	08	2018	grade_12	0.0	0
1189863	OR	school	4100020	2143	North Santiam SD 29J	410002000765	717	Sublimity Elementary School	Regular School	No	Elementary	KG	08	2018	grade_12	0.0	0
1189860	OR	school	4100020	2143	North Santiam SD 29J	410002000833	788	Stayton Elementary School	Regular School	No	Elementary	KG	03	2018	grade_12	0.0	0
1189862	OR	school	4100020	2143	North Santiam SD 29J	410002000834	789	Stayton Middle School	Regular School	No	Middle	04	08	2018	grade_12	0.0	0
1189861	OR	school	4100020	2143	North Santiam SD 29J	410002000854	809	Stayton High School	Regular School	No	High	09	12	2018	grade_12	187.0	187
1190300	OR	school	4100021	2225	South Wasco County SD 1	410002101166	1108	Maupin Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1190301	OR	school	4100021	2225	South Wasco County SD 1	410002101167	1109	South Wasco County High School	Regular School	No	High	07	12	2018	grade_12	22.0	22
1189571	OR	school	4100023	2239	Hillsboro SD 1J	410002300209	1302	Tobias Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1189574	OR	school	4100023	2239	Hillsboro SD 1J	410002301168	1111	West Union Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1189540	OR	school	4100023	2239	Hillsboro SD 1J	410002301169	1112	Brookwood Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1189544	OR	school	4100023	2239	Hillsboro SD 1J	410002301171	1115	Eastwood Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1189573	OR	school	4100023	2239	Hillsboro SD 1J	410002301172	1114	W Verne McKinney Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1189562	OR	school	4100023	2239	Hillsboro SD 1J	410002301173	1117	Mooberry Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1189572	OR	school	4100023	2239	Hillsboro SD 1J	410002301175	1119	W L Henry Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1189541	OR	school	4100023	2239	Hillsboro SD 1J	410002301199	1147	Butternut Creek Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1189568	OR	school	4100023	2239	Hillsboro SD 1J	410002301200	1149	Reedville Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1189557	OR	school	4100023	2239	Hillsboro SD 1J	410002301201	1150	Ladd Acres Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1189575	OR	school	4100023	2239	Hillsboro SD 1J	410002301202	1151	Witch Hazel Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1189549	OR	school	4100023	2239	Hillsboro SD 1J	410002301203	1152	Groner K-8	Regular School	No	Elementary	KG	08	2018	grade_12	0.0	0
1189546	OR	school	4100023	2239	Hillsboro SD 1J	410002301242	1189	Farmington View Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1189563	OR	school	4100023	2239	Hillsboro SD 1J	410002301243	1190	North Plains Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1189542	OR	school	4100023	2239	Hillsboro SD 1J	410002301248	1368	Century High School	Regular School	No	High	09	12	2018	grade_12	362.0	362
1189567	OR	school	4100023	2239	Hillsboro SD 1J	410002301250	1196	R A Brown Middle School	Regular School	No	Middle	07	08	2018	grade_12	0.0	0
1189555	OR	school	4100023	2239	Hillsboro SD 1J	410002301251	1199	J W Poynter Middle School	Regular School	No	Middle	07	08	2018	grade_12	0.0	0
1189550	OR	school	4100023	2239	Hillsboro SD 1J	410002301252	1201	Hillsboro High School	Regular School	No	High	09	12	2018	grade_12	319.0	319
1189570	OR	school	4100023	2239	Hillsboro SD 1J	410002301253	1198	South Meadows Middle School	Regular School	No	Middle	07	08	2018	grade_12	0.0	0
1189554	OR	school	4100023	2239	Hillsboro SD 1J	410002301295	1148	Indian Hills Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1189558	OR	school	4100023	2239	Hillsboro SD 1J	410002301300	1110	Lenox Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1189561	OR	school	4100023	2239	Hillsboro SD 1J	410002301305	1116	Minter Bridge Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1189548	OR	school	4100023	2239	Hillsboro SD 1J	410002301306	1200	Glencoe High School	Regular School	No	High	09	12	2018	grade_12	368.0	368
1189545	OR	school	4100023	2239	Hillsboro SD 1J	410002301322	1197	Evergreen Jr High School	Regular School	No	Middle	07	08	2018	grade_12	0.0	0
1189556	OR	school	4100023	2239	Hillsboro SD 1J	410002301373	1285	Jackson Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1189564	OR	school	4100023	2239	Hillsboro SD 1J	410002301499	3160	Orenco Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1189565	OR	school	4100023	2239	Hillsboro SD 1J	410002301500	3159	Paul L Patterson Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1189543	OR	school	4100023	2239	Hillsboro SD 1J	410002301535	4206	City View Charter School	Regular School	Yes	Elementary	KG	08	2018	grade_12	0.0	0
1189559	OR	school	4100023	2239	Hillsboro SD 1J	410002301585	4018	Liberty High School	Regular School	No	High	09	12	2018	grade_12	380.0	380
1189560	OR	school	4100023	2239	Hillsboro SD 1J	410002301749	4642	Lincoln Street Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1189569	OR	school	4100023	2239	Hillsboro SD 1J	410002301750	4703	Rosedale Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1189566	OR	school	4100023	2239	Hillsboro SD 1J	410002301759	4643	Quatama Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1189547	OR	school	4100023	2239	Hillsboro SD 1J	410002301764	4641	Free Orchards Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1189551	OR	school	4100023	2239	Hillsboro SD 1J	410002301824	4973	Hillsboro Online Academy	Regular School	No	Other	KG	12	2018	grade_12	20.0	20
1189553	OR	school	4100023	2239	Hillsboro SD 1J	410002304174	3536	Imlay Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1189648	OR	school	4100040	2262	Knappa SD 4	410004000176	166	Hilda Lahti Elementary School	Regular School	No	Elementary	KG	08	2018	grade_12	0.0	0
1189649	OR	school	4100040	2262	Knappa SD 4	410004000179	169	Knappa High School	Regular School	No	High	09	12	2018	grade_12	34.0	34
1189904	OR	school	4100043	3477	ODE YCEP District	410004300490	1827	Robert S Farrell High School	Regular School	No	Not Reported	M	M	2018	grade_12	0.0	0
1189908	OR	school	4100043	3477	ODE YCEP District	410004300494	1828	William P Lord High School	Regular School	No	High	06	12	2018	grade_12	109.0	109
1189899	OR	school	4100043	3477	ODE YCEP District	410004301404	2258	Monroe School	Regular School	No	High	06	12	2018	grade_12	12.0	12
1189900	OR	school	4100043	3477	ODE YCEP District	410004301406	2260	New Bridge High School	Regular School	No	High	06	12	2018	grade_12	47.0	47
1189901	OR	school	4100043	3477	ODE YCEP District	410004301412	2387	Ocean Dunes High School	Regular School	No	High	09	12	2018	grade_12	0.0	0
1189903	OR	school	4100043	3477	ODE YCEP District	410004301413	2388	Riverside High School	Regular School	No	High	10	12	2018	grade_12	7.0	7
1189905	OR	school	4100043	3477	ODE YCEP District	410004301476	2385	South Jetty High School	Regular School	No	High	06	12	2018	grade_12	0.0	0
1189902	OR	school	4100043	3477	ODE YCEP District	410004301477	2386	RiverBend High School	Regular School	No	High	09	12	2018	grade_12	9.0	9
1189907	OR	school	4100043	3477	ODE YCEP District	410004301740	4588	Trask River High School	Regular School	No	High	06	12	2018	grade_12	14.0	14
1189906	OR	school	4100043	3477	ODE YCEP District	410004301744	4609	Three Lakes High School	Regular School	No	High	06	12	2018	grade_12	17.0	17
1189589	OR	school	4100047	3997	Ione SD R2	410004700862	3363	Ione Community Charter School	Regular School	Yes	Other	KG	12	2018	grade_12	12.0	12
1189864	OR	school	4100048	4131	North Wasco County SD 21	410004801151	1093	Chenowith Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1189868	OR	school	4100048	4131	North Wasco County SD 21	410004801153	1095	Mosier Community School	Regular School	Yes	Elementary	KG	08	2018	grade_12	0.0	0
1189865	OR	school	4100048	4131	North Wasco County SD 21	410004801155	1097	Colonel Wright Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1189867	OR	school	4100048	4131	North Wasco County SD 21	410004801156	1098	Dry Hollow Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1189871	OR	school	4100048	4131	North Wasco County SD 21	410004801158	1100	The Dalles Middle School	Regular School	No	Middle	06	08	2018	grade_12	0.0	0
1189870	OR	school	4100048	4131	North Wasco County SD 21	410004801159	1101	The Dalles High School	Regular School	No	High	09	12	2018	grade_12	199.0	199
1189872	OR	school	4100048	4131	North Wasco County SD 21	410004801833	5250	Wahtonka Community School	Alternative School	No	High	09	12	2018	grade_12	19.0	19
1189795	OR	school	4100640	1968	Myrtle Point SD 41	410064000233	214	Myrtle Crest School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1189796	OR	school	4100640	1968	Myrtle Point SD 41	410064000234	215	Myrtle Point High School	Regular School	No	High	07	12	2018	grade_12	41.0	41
1189014	OR	school	4100990	2063	Adel SD 21	410099000524	498	Adel Elementary School	Regular School	No	Middle	04	08	2018	grade_12	0.0	0
1189015	OR	school	4101020	2113	Adrian SD 61	410102000755	707	Adrian Elementary School	Regular School	No	Elementary	KG	08	2018	grade_12	0.0	0
1189016	OR	school	4101020	2113	Adrian SD 61	410102000756	708	Adrian High School	Regular School	No	High	09	12	2018	grade_12	29.0	29
1189484	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000017	639	Oak Grove Elementary School	Regular School	No	Elementary	02	05	2018	grade_12	0.0	0
1189481	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000029	637	North Albany Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1189476	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000031	635	Fir Grove Primary School	Regular School	No	Elementary	KG	01	2018	grade_12	0.0	0
1189474	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000669	631	Central Elementary School	Regular School	No	Elementary	03	05	2018	grade_12	0.0	0
1189478	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000670	640	Lafayette Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1189479	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000671	641	Liberty Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1189483	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000672	643	Oak Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1189488	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000673	644	Sunrise Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1189487	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000674	645	South Shore Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1189489	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000675	647	Takena Elementary School	Regular School	No	Elementary	KG	02	2018	grade_12	0.0	0
1189492	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000676	648	Waverly Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1189485	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000680	636	Periwinkle Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0