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
1182123	OR	school	4100003	2193	Falls City SD 57	410000301061	1005	Falls City Elementary School	Regular School	No	Elementary	KG	08	2018	grade_7	12.0	12
1182124	OR	school	4100003	2193	Falls City SD 57	410000301062	1006	Falls City High School	Regular School	No	High	09	12	2018	grade_7	0.0	0
1182642	OR	school	4100009	2336	Oregon Department of Education	410000900062	1832	Oregon School for the Deaf	Special Education School	No	Other	KG	12	2018	grade_7	7.0	7
1182641	OR	school	4100009	2336	Oregon Department of Education	410000901592	4040	Four Rivers Community School	Regular School	Yes	Other	KG	10	2018	grade_7	28.0	28
1182643	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_7	22.0	22
1182644	OR	school	4100009	2336	Oregon Department of Education	410000901784	4720	The Ivy School	Regular School	Yes	Elementary	01	08	2018	grade_7	16.0	16
1182640	OR	school	4100009	2336	Oregon Department of Education	410000901808	4850	Eagle Charter School	Regular School	Yes	Elementary	KG	05	2018	grade_7	0.0	0
1183117	OR	school	4100014	2116	Vale SD 84	410001400748	701	Vale Elementary School	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0
1183121	OR	school	4100014	2116	Vale SD 84	410001400754	706	Willowcreek Elementary School	Regular School	No	Elementary	01	08	2018	grade_7	7.0	7
1183118	OR	school	4100014	2116	Vale SD 84	410001400761	713	Vale High School	Regular School	No	High	09	12	2018	grade_7	0.0	0
1183119	OR	school	4100014	2116	Vale SD 84	410001401026	1357	Vale Middle School	Regular School	No	Middle	07	08	2018	grade_7	54.0	54
1182151	OR	school	4100015	2137	Gervais SD 1	410001500821	776	Gervais Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182153	OR	school	4100015	2137	Gervais SD 1	410001500831	786	Gervais Middle School	Regular School	No	Middle	06	08	2018	grade_7	85.0	85
1182152	OR	school	4100015	2137	Gervais SD 1	410001500853	808	Gervais High School	Regular School	No	High	09	12	2018	grade_7	0.0	0
1182154	OR	school	4100015	2137	Gervais SD 1	410001501588	4024	Samuel Brown Academy	Alternative School	No	High	06	12	2018	grade_7	0.0	0
1182150	OR	school	4100015	2137	Gervais SD 1	410001501859	5392	Frontier Charter Academy	Regular School	Yes	Middle	05	09	2018	grade_7	26.0	26
1183172	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601266	1213	Yamhill Carlton Elementary School	Regular School	No	Elementary	KG	04	2018	grade_7	0.0	0
1183173	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601288	1238	Yamhill Carlton High School	Regular School	No	High	09	12	2018	grade_7	0.0	0
1183174	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601730	4564	Yamhill Carlton Intermediate School	Regular School	No	Middle	05	08	2018	grade_7	75.0	75
1182231	OR	school	4100019	2099	Harrisburg SD 7J	410001900698	659	Harrisburg Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182232	OR	school	4100019	2099	Harrisburg SD 7J	410001900731	689	Harrisburg High School	Regular School	No	High	09	12	2018	grade_7	0.0	0
1182233	OR	school	4100019	2099	Harrisburg SD 7J	410001901422	2723	Harrisburg Middle School	Regular School	No	Middle	06	08	2018	grade_7	62.0	62
1182564	OR	school	4100020	2143	North Santiam SD 29J	410002000693	656	Mari-Linn Elementary School	Regular School	No	Elementary	KG	08	2018	grade_7	25.0	25
1182568	OR	school	4100020	2143	North Santiam SD 29J	410002000765	717	Sublimity Elementary School	Regular School	No	Elementary	KG	08	2018	grade_7	42.0	42
1182565	OR	school	4100020	2143	North Santiam SD 29J	410002000833	788	Stayton Elementary School	Regular School	No	Elementary	KG	03	2018	grade_7	0.0	0
1182567	OR	school	4100020	2143	North Santiam SD 29J	410002000834	789	Stayton Middle School	Regular School	No	Middle	04	08	2018	grade_7	118.0	118
1182566	OR	school	4100020	2143	North Santiam SD 29J	410002000854	809	Stayton High School	Regular School	No	High	09	12	2018	grade_7	0.0	0
1183005	OR	school	4100021	2225	South Wasco County SD 1	410002101166	1108	Maupin Elementary School	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0
1183006	OR	school	4100021	2225	South Wasco County SD 1	410002101167	1109	South Wasco County High School	Regular School	No	High	07	12	2018	grade_7	20.0	20
1182276	OR	school	4100023	2239	Hillsboro SD 1J	410002300209	1302	Tobias Elementary School	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0
1182279	OR	school	4100023	2239	Hillsboro SD 1J	410002301168	1111	West Union Elementary School	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0
1182245	OR	school	4100023	2239	Hillsboro SD 1J	410002301169	1112	Brookwood Elementary School	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0
1182249	OR	school	4100023	2239	Hillsboro SD 1J	410002301171	1115	Eastwood Elementary School	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0
1182278	OR	school	4100023	2239	Hillsboro SD 1J	410002301172	1114	W Verne McKinney Elementary School	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0
1182267	OR	school	4100023	2239	Hillsboro SD 1J	410002301173	1117	Mooberry Elementary School	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0
1182277	OR	school	4100023	2239	Hillsboro SD 1J	410002301175	1119	W L Henry Elementary School	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0
1182246	OR	school	4100023	2239	Hillsboro SD 1J	410002301199	1147	Butternut Creek Elementary School	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0
1182273	OR	school	4100023	2239	Hillsboro SD 1J	410002301200	1149	Reedville Elementary School	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0
1182262	OR	school	4100023	2239	Hillsboro SD 1J	410002301201	1150	Ladd Acres Elementary School	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0
1182280	OR	school	4100023	2239	Hillsboro SD 1J	410002301202	1151	Witch Hazel Elementary School	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0
1182254	OR	school	4100023	2239	Hillsboro SD 1J	410002301203	1152	Groner K-8	Regular School	No	Elementary	KG	08	2018	grade_7	24.0	24
1182251	OR	school	4100023	2239	Hillsboro SD 1J	410002301242	1189	Farmington View Elementary School	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0
1182268	OR	school	4100023	2239	Hillsboro SD 1J	410002301243	1190	North Plains Elementary School	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0
1182247	OR	school	4100023	2239	Hillsboro SD 1J	410002301248	1368	Century High School	Regular School	No	High	09	12	2018	grade_7	0.0	0
1182272	OR	school	4100023	2239	Hillsboro SD 1J	410002301250	1196	R A Brown Middle School	Regular School	No	Middle	07	08	2018	grade_7	372.0	372
1182260	OR	school	4100023	2239	Hillsboro SD 1J	410002301251	1199	J W Poynter Middle School	Regular School	No	Middle	07	08	2018	grade_7	384.0	384
1182255	OR	school	4100023	2239	Hillsboro SD 1J	410002301252	1201	Hillsboro High School	Regular School	No	High	09	12	2018	grade_7	0.0	0
1182275	OR	school	4100023	2239	Hillsboro SD 1J	410002301253	1198	South Meadows Middle School	Regular School	No	Middle	07	08	2018	grade_7	356.0	356
1182259	OR	school	4100023	2239	Hillsboro SD 1J	410002301295	1148	Indian Hills Elementary School	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0
1182263	OR	school	4100023	2239	Hillsboro SD 1J	410002301300	1110	Lenox Elementary School	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0
1182266	OR	school	4100023	2239	Hillsboro SD 1J	410002301305	1116	Minter Bridge Elementary School	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0
1182253	OR	school	4100023	2239	Hillsboro SD 1J	410002301306	1200	Glencoe High School	Regular School	No	High	09	12	2018	grade_7	0.0	0
1182250	OR	school	4100023	2239	Hillsboro SD 1J	410002301322	1197	Evergreen Jr High School	Regular School	No	Middle	07	08	2018	grade_7	417.0	417
1182261	OR	school	4100023	2239	Hillsboro SD 1J	410002301373	1285	Jackson Elementary School	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0
1182269	OR	school	4100023	2239	Hillsboro SD 1J	410002301499	3160	Orenco Elementary School	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0
1182270	OR	school	4100023	2239	Hillsboro SD 1J	410002301500	3159	Paul L Patterson Elementary School	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0
1182248	OR	school	4100023	2239	Hillsboro SD 1J	410002301535	4206	City View Charter School	Regular School	Yes	Elementary	KG	08	2018	grade_7	12.0	12
1182264	OR	school	4100023	2239	Hillsboro SD 1J	410002301585	4018	Liberty High School	Regular School	No	High	09	12	2018	grade_7	0.0	0
1182265	OR	school	4100023	2239	Hillsboro SD 1J	410002301749	4642	Lincoln Street Elementary School	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0
1182274	OR	school	4100023	2239	Hillsboro SD 1J	410002301750	4703	Rosedale Elementary School	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0
1182271	OR	school	4100023	2239	Hillsboro SD 1J	410002301759	4643	Quatama Elementary School	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0
1182252	OR	school	4100023	2239	Hillsboro SD 1J	410002301764	4641	Free Orchards Elementary School	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0
1182256	OR	school	4100023	2239	Hillsboro SD 1J	410002301824	4973	Hillsboro Online Academy	Regular School	No	Other	KG	12	2018	grade_7	18.0	18
1182258	OR	school	4100023	2239	Hillsboro SD 1J	410002304174	3536	Imlay Elementary School	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0
1182353	OR	school	4100040	2262	Knappa SD 4	410004000176	166	Hilda Lahti Elementary School	Regular School	No	Elementary	KG	08	2018	grade_7	38.0	38
1182354	OR	school	4100040	2262	Knappa SD 4	410004000179	169	Knappa High School	Regular School	No	High	09	12	2018	grade_7	0.0	0
1182609	OR	school	4100043	3477	ODE YCEP District	410004300490	1827	Robert S Farrell High School	Regular School	No	Not Reported	M	M	2018	grade_7	0.0	0
1182613	OR	school	4100043	3477	ODE YCEP District	410004300494	1828	William P Lord High School	Regular School	No	High	06	12	2018	grade_7	0.0	0
1182604	OR	school	4100043	3477	ODE YCEP District	410004301404	2258	Monroe School	Regular School	No	High	06	12	2018	grade_7	0.0	0
1182605	OR	school	4100043	3477	ODE YCEP District	410004301406	2260	New Bridge High School	Regular School	No	High	06	12	2018	grade_7	0.0	0
1182606	OR	school	4100043	3477	ODE YCEP District	410004301412	2387	Ocean Dunes High School	Regular School	No	High	09	12	2018	grade_7	0.0	0
1182608	OR	school	4100043	3477	ODE YCEP District	410004301413	2388	Riverside High School	Regular School	No	High	10	12	2018	grade_7	0.0	0
1182610	OR	school	4100043	3477	ODE YCEP District	410004301476	2385	South Jetty High School	Regular School	No	High	06	12	2018	grade_7	0.0	0
1182607	OR	school	4100043	3477	ODE YCEP District	410004301477	2386	RiverBend High School	Regular School	No	High	09	12	2018	grade_7	0.0	0
1182612	OR	school	4100043	3477	ODE YCEP District	410004301740	4588	Trask River High School	Regular School	No	High	06	12	2018	grade_7	0.0	0
1182611	OR	school	4100043	3477	ODE YCEP District	410004301744	4609	Three Lakes High School	Regular School	No	High	06	12	2018	grade_7	0.0	0
1182294	OR	school	4100047	3997	Ione SD R2	410004700862	3363	Ione Community Charter School	Regular School	Yes	Other	KG	12	2018	grade_7	14.0	14
1182569	OR	school	4100048	4131	North Wasco County SD 21	410004801151	1093	Chenowith Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182573	OR	school	4100048	4131	North Wasco County SD 21	410004801153	1095	Mosier Community School	Regular School	Yes	Elementary	KG	08	2018	grade_7	25.0	25
1182570	OR	school	4100048	4131	North Wasco County SD 21	410004801155	1097	Colonel Wright Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182572	OR	school	4100048	4131	North Wasco County SD 21	410004801156	1098	Dry Hollow Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182576	OR	school	4100048	4131	North Wasco County SD 21	410004801158	1100	The Dalles Middle School	Regular School	No	Middle	06	08	2018	grade_7	187.0	187
1182575	OR	school	4100048	4131	North Wasco County SD 21	410004801159	1101	The Dalles High School	Regular School	No	High	09	12	2018	grade_7	0.0	0
1182577	OR	school	4100048	4131	North Wasco County SD 21	410004801833	5250	Wahtonka Community School	Alternative School	No	High	09	12	2018	grade_7	0.0	0
1182500	OR	school	4100640	1968	Myrtle Point SD 41	410064000233	214	Myrtle Crest School	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0
1182501	OR	school	4100640	1968	Myrtle Point SD 41	410064000234	215	Myrtle Point High School	Regular School	No	High	07	12	2018	grade_7	41.0	41
1181719	OR	school	4100990	2063	Adel SD 21	410099000524	498	Adel Elementary School	Regular School	No	Middle	04	08	2018	grade_7	2.0	2
1181720	OR	school	4101020	2113	Adrian SD 61	410102000755	707	Adrian Elementary School	Regular School	No	Elementary	KG	08	2018	grade_7	24.0	24
1181721	OR	school	4101020	2113	Adrian SD 61	410102000756	708	Adrian High School	Regular School	No	High	09	12	2018	grade_7	0.0	0
1182189	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000017	639	Oak Grove Elementary School	Regular School	No	Elementary	02	05	2018	grade_7	0.0	0
1182186	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000029	637	North Albany Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182181	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000031	635	Fir Grove Primary School	Regular School	No	Elementary	KG	01	2018	grade_7	0.0	0
1182179	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000669	631	Central Elementary School	Regular School	No	Elementary	03	05	2018	grade_7	0.0	0
1182183	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000670	640	Lafayette Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182184	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000671	641	Liberty Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182188	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000672	643	Oak Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182193	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000673	644	Sunrise Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182192	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000674	645	South Shore Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182194	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000675	647	Takena Elementary School	Regular School	No	Elementary	KG	02	2018	grade_7	0.0	0
1182197	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000676	648	Waverly Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182190	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000680	636	Periwinkle Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0