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 district_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
1179205	OR	school	4100003	2193	Falls City SD 57	410000301061	1005	Falls City Elementary School	Regular School	No	Elementary	KG	08	2018	grade_5	19.0	19
1179206	OR	school	4100003	2193	Falls City SD 57	410000301062	1006	Falls City High School	Regular School	No	High	09	12	2018	grade_5	0.0	0
1179722	OR	school	4100009	2336	Oregon Department of Education	410000901808	4850	Eagle Charter School	Regular School	Yes	Elementary	KG	05	2018	grade_5	24.0	24
1179723	OR	school	4100009	2336	Oregon Department of Education	410000901592	4040	Four Rivers Community School	Regular School	Yes	Other	KG	10	2018	grade_5	27.0	27
1179724	OR	school	4100009	2336	Oregon Department of Education	410000900062	1832	Oregon School for the Deaf	Special Education School	No	Other	KG	12	2018	grade_5	3.0	3
1179725	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_5	24.0	24
1179726	OR	school	4100009	2336	Oregon Department of Education	410000901784	4720	The Ivy School	Regular School	Yes	Elementary	01	08	2018	grade_5	45.0	45
1180199	OR	school	4100014	2116	Vale SD 84	410001400748	701	Vale Elementary School	Regular School	No	Elementary	KG	06	2018	grade_5	63.0	63
1180200	OR	school	4100014	2116	Vale SD 84	410001400761	713	Vale High School	Regular School	No	High	09	12	2018	grade_5	0.0	0
1180201	OR	school	4100014	2116	Vale SD 84	410001401026	1357	Vale Middle School	Regular School	No	Middle	07	08	2018	grade_5	0.0	0
1180202	OR	school	4100014	2116	Vale SD 84		2116	Vale SD 84						2018	grade_5	0.0	0
1180203	OR	school	4100014	2116	Vale SD 84	410001400754	706	Willowcreek Elementary School	Regular School	No	Elementary	01	08	2018	grade_5	9.0	9
1179232	OR	school	4100015	2137	Gervais SD 1	410001501859	5392	Frontier Charter Academy	Regular School	Yes	Middle	05	09	2018	grade_5	27.0	27
1179233	OR	school	4100015	2137	Gervais SD 1	410001500821	776	Gervais Elementary School	Regular School	No	Elementary	KG	05	2018	grade_5	80.0	80
1179234	OR	school	4100015	2137	Gervais SD 1	410001500853	808	Gervais High School	Regular School	No	High	09	12	2018	grade_5	0.0	0
1179235	OR	school	4100015	2137	Gervais SD 1	410001500831	786	Gervais Middle School	Regular School	No	Middle	06	08	2018	grade_5	0.0	0
1179236	OR	school	4100015	2137	Gervais SD 1	410001501588	4024	Samuel Brown Academy	Alternative School	No	High	06	12	2018	grade_5	0.0	0
1180254	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601266	1213	Yamhill Carlton Elementary School	Regular School	No	Elementary	KG	04	2018	grade_5	0.0	0
1180255	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601288	1238	Yamhill Carlton High School	Regular School	No	High	09	12	2018	grade_5	0.0	0
1180256	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601730	4564	Yamhill Carlton Intermediate School	Regular School	No	Middle	05	08	2018	grade_5	77.0	77
1180257	OR	school	4100016	2251	Yamhill Carlton SD 1		2251	Yamhill Carlton SD 1						2018	grade_5	12.0	12
1179313	OR	school	4100019	2099	Harrisburg SD 7J	410001900698	659	Harrisburg Elementary School	Regular School	No	Elementary	KG	05	2018	grade_5	70.0	70
1179314	OR	school	4100019	2099	Harrisburg SD 7J	410001900731	689	Harrisburg High School	Regular School	No	High	09	12	2018	grade_5	0.0	0
1179315	OR	school	4100019	2099	Harrisburg SD 7J	410001901422	2723	Harrisburg Middle School	Regular School	No	Middle	06	08	2018	grade_5	0.0	0
1179646	OR	school	4100020	2143	North Santiam SD 29J	410002000693	656	Mari-Linn Elementary School	Regular School	No	Elementary	KG	08	2018	grade_5	27.0	27
1179647	OR	school	4100020	2143	North Santiam SD 29J	410002000833	788	Stayton Elementary School	Regular School	No	Elementary	KG	03	2018	grade_5	0.0	0
1179648	OR	school	4100020	2143	North Santiam SD 29J	410002000854	809	Stayton High School	Regular School	No	High	09	12	2018	grade_5	0.0	0
1179649	OR	school	4100020	2143	North Santiam SD 29J	410002000834	789	Stayton Middle School	Regular School	No	Middle	04	08	2018	grade_5	97.0	97
1179650	OR	school	4100020	2143	North Santiam SD 29J	410002000765	717	Sublimity Elementary School	Regular School	No	Elementary	KG	08	2018	grade_5	48.0	48
1180087	OR	school	4100021	2225	South Wasco County SD 1	410002101166	1108	Maupin Elementary School	Regular School	No	Elementary	KG	06	2018	grade_5	14.0	14
1180088	OR	school	4100021	2225	South Wasco County SD 1	410002101167	1109	South Wasco County High School	Regular School	No	High	07	12	2018	grade_5	0.0	0
1179327	OR	school	4100023	2239	Hillsboro SD 1J	410002301169	1112	Brookwood Elementary School	Regular School	No	Elementary	KG	06	2018	grade_5	40.0	40
1179328	OR	school	4100023	2239	Hillsboro SD 1J	410002301199	1147	Butternut Creek Elementary School	Regular School	No	Elementary	KG	06	2018	grade_5	55.0	55
1179329	OR	school	4100023	2239	Hillsboro SD 1J	410002301248	1368	Century High School	Regular School	No	High	09	12	2018	grade_5	0.0	0
1179330	OR	school	4100023	2239	Hillsboro SD 1J	410002301535	4206	City View Charter School	Regular School	Yes	Elementary	KG	08	2018	grade_5	24.0	24
1179331	OR	school	4100023	2239	Hillsboro SD 1J	410002301171	1115	Eastwood Elementary School	Regular School	No	Elementary	KG	06	2018	grade_5	61.0	61
1179332	OR	school	4100023	2239	Hillsboro SD 1J	410002301322	1197	Evergreen Jr High School	Regular School	No	Middle	07	08	2018	grade_5	0.0	0
1179333	OR	school	4100023	2239	Hillsboro SD 1J	410002301242	1189	Farmington View Elementary School	Regular School	No	Elementary	KG	06	2018	grade_5	47.0	47
1179334	OR	school	4100023	2239	Hillsboro SD 1J	410002301764	4641	Free Orchards Elementary School	Regular School	No	Elementary	KG	06	2018	grade_5	55.0	55
1179335	OR	school	4100023	2239	Hillsboro SD 1J	410002301306	1200	Glencoe High School	Regular School	No	High	09	12	2018	grade_5	0.0	0
1179336	OR	school	4100023	2239	Hillsboro SD 1J	410002301203	1152	Groner K-8	Regular School	No	Elementary	KG	08	2018	grade_5	30.0	30
1179337	OR	school	4100023	2239	Hillsboro SD 1J	410002301252	1201	Hillsboro High School	Regular School	No	High	09	12	2018	grade_5	0.0	0
1179338	OR	school	4100023	2239	Hillsboro SD 1J	410002301824	4973	Hillsboro Online Academy	Regular School	No	Other	KG	12	2018	grade_5	11.0	11
1179339	OR	school	4100023	2239	Hillsboro SD 1J		2239	Hillsboro SD 1J						2018	grade_5	0.0	0
1179340	OR	school	4100023	2239	Hillsboro SD 1J	410002304174	3536	Imlay Elementary School	Regular School	No	Elementary	KG	06	2018	grade_5	68.0	68
1179341	OR	school	4100023	2239	Hillsboro SD 1J	410002301295	1148	Indian Hills Elementary School	Regular School	No	Elementary	KG	06	2018	grade_5	81.0	81
1179342	OR	school	4100023	2239	Hillsboro SD 1J	410002301251	1199	J W Poynter Middle School	Regular School	No	Middle	07	08	2018	grade_5	0.0	0
1179343	OR	school	4100023	2239	Hillsboro SD 1J	410002301373	1285	Jackson Elementary School	Regular School	No	Elementary	KG	06	2018	grade_5	81.0	81
1179344	OR	school	4100023	2239	Hillsboro SD 1J	410002301201	1150	Ladd Acres Elementary School	Regular School	No	Elementary	KG	06	2018	grade_5	87.0	87
1179345	OR	school	4100023	2239	Hillsboro SD 1J	410002301300	1110	Lenox Elementary School	Regular School	No	Elementary	KG	06	2018	grade_5	73.0	73
1179346	OR	school	4100023	2239	Hillsboro SD 1J	410002301585	4018	Liberty High School	Regular School	No	High	09	12	2018	grade_5	0.0	0
1179347	OR	school	4100023	2239	Hillsboro SD 1J	410002301749	4642	Lincoln Street Elementary School	Regular School	No	Elementary	KG	06	2018	grade_5	68.0	68
1179348	OR	school	4100023	2239	Hillsboro SD 1J	410002301305	1116	Minter Bridge Elementary School	Regular School	No	Elementary	KG	06	2018	grade_5	87.0	87
1179349	OR	school	4100023	2239	Hillsboro SD 1J	410002301173	1117	Mooberry Elementary School	Regular School	No	Elementary	KG	06	2018	grade_5	67.0	67
1179350	OR	school	4100023	2239	Hillsboro SD 1J	410002301243	1190	North Plains Elementary School	Regular School	No	Elementary	KG	06	2018	grade_5	42.0	42
1179351	OR	school	4100023	2239	Hillsboro SD 1J	410002301499	3160	Orenco Elementary School	Regular School	No	Elementary	KG	06	2018	grade_5	99.0	99
1179352	OR	school	4100023	2239	Hillsboro SD 1J	410002301500	3159	Paul L Patterson Elementary School	Regular School	No	Elementary	KG	06	2018	grade_5	64.0	64
1179353	OR	school	4100023	2239	Hillsboro SD 1J	410002301759	4643	Quatama Elementary School	Regular School	No	Elementary	KG	06	2018	grade_5	74.0	74
1179354	OR	school	4100023	2239	Hillsboro SD 1J	410002301250	1196	R A Brown Middle School	Regular School	No	Middle	07	08	2018	grade_5	0.0	0
1179355	OR	school	4100023	2239	Hillsboro SD 1J	410002301200	1149	Reedville Elementary School	Regular School	No	Elementary	KG	06	2018	grade_5	42.0	42
1179356	OR	school	4100023	2239	Hillsboro SD 1J	410002301750	4703	Rosedale Elementary School	Regular School	No	Elementary	KG	06	2018	grade_5	78.0	78
1179357	OR	school	4100023	2239	Hillsboro SD 1J	410002301253	1198	South Meadows Middle School	Regular School	No	Middle	07	08	2018	grade_5	0.0	0
1179358	OR	school	4100023	2239	Hillsboro SD 1J	410002300209	1302	Tobias Elementary School	Regular School	No	Elementary	KG	06	2018	grade_5	56.0	56
1179359	OR	school	4100023	2239	Hillsboro SD 1J	410002301175	1119	W L Henry Elementary School	Regular School	No	Elementary	KG	06	2018	grade_5	50.0	50
1179360	OR	school	4100023	2239	Hillsboro SD 1J	410002301172	1114	W Verne McKinney Elementary School	Regular School	No	Elementary	KG	06	2018	grade_5	76.0	76
1179361	OR	school	4100023	2239	Hillsboro SD 1J	410002301168	1111	West Union Elementary School	Regular School	No	Elementary	KG	06	2018	grade_5	57.0	57
1179362	OR	school	4100023	2239	Hillsboro SD 1J	410002301202	1151	Witch Hazel Elementary School	Regular School	No	Elementary	KG	06	2018	grade_5	78.0	78
1179435	OR	school	4100040	2262	Knappa SD 4	410004000176	166	Hilda Lahti Elementary School	Regular School	No	Elementary	KG	08	2018	grade_5	35.0	35
1179436	OR	school	4100040	2262	Knappa SD 4	410004000179	169	Knappa High School	Regular School	No	High	09	12	2018	grade_5	0.0	0
1179686	OR	school	4100043	3477	ODE YCEP District	410004301404	2258	Monroe School	Regular School	No	High	06	12	2018	grade_5	0.0	0
1179687	OR	school	4100043	3477	ODE YCEP District	410004301406	2260	New Bridge High School	Regular School	No	High	06	12	2018	grade_5	0.0	0
1179688	OR	school	4100043	3477	ODE YCEP District	410004301412	2387	Ocean Dunes High School	Regular School	No	High	09	12	2018	grade_5	0.0	0
1179689	OR	school	4100043	3477	ODE YCEP District	410004301477	2386	RiverBend High School	Regular School	No	High	09	12	2018	grade_5	0.0	0
1179690	OR	school	4100043	3477	ODE YCEP District	410004301413	2388	Riverside High School	Regular School	No	High	10	12	2018	grade_5	0.0	0
1179691	OR	school	4100043	3477	ODE YCEP District	410004300490	1827	Robert S Farrell High School	Regular School	No	Not Reported	M	M	2018	grade_5	0.0	0
1179692	OR	school	4100043	3477	ODE YCEP District	410004301476	2385	South Jetty High School	Regular School	No	High	06	12	2018	grade_5	0.0	0
1179693	OR	school	4100043	3477	ODE YCEP District	410004301744	4609	Three Lakes High School	Regular School	No	High	06	12	2018	grade_5	0.0	0
1179694	OR	school	4100043	3477	ODE YCEP District	410004301740	4588	Trask River High School	Regular School	No	High	06	12	2018	grade_5	0.0	0
1179695	OR	school	4100043	3477	ODE YCEP District	410004300494	1828	William P Lord High School	Regular School	No	High	06	12	2018	grade_5	0.0	0
1179376	OR	school	4100047	3997	Ione SD R2	410004700862	3363	Ione Community Charter School	Regular School	Yes	Other	KG	12	2018	grade_5	12.0	12
1179651	OR	school	4100048	4131	North Wasco County SD 21	410004801151	1093	Chenowith Elementary School	Regular School	No	Elementary	KG	05	2018	grade_5	64.0	64
1179652	OR	school	4100048	4131	North Wasco County SD 21	410004801155	1097	Colonel Wright Elementary School	Regular School	No	Elementary	KG	05	2018	grade_5	45.0	45
1179653	OR	school	4100048	4131	North Wasco County SD 21		1262	Crossroads						2018	grade_5	1.0	1
1179654	OR	school	4100048	4131	North Wasco County SD 21	410004801156	1098	Dry Hollow Elementary School	Regular School	No	Elementary	KG	05	2018	grade_5	87.0	87
1179655	OR	school	4100048	4131	North Wasco County SD 21	410004801153	1095	Mosier Community School	Regular School	Yes	Elementary	KG	08	2018	grade_5	19.0	19
1179656	OR	school	4100048	4131	North Wasco County SD 21		4131	North Wasco County SD 21						2018	grade_5	0.0	0
1179657	OR	school	4100048	4131	North Wasco County SD 21	410004801159	1101	The Dalles High School	Regular School	No	High	09	12	2018	grade_5	0.0	0
1179658	OR	school	4100048	4131	North Wasco County SD 21	410004801158	1100	The Dalles Middle School	Regular School	No	Middle	06	08	2018	grade_5	0.0	0
1179659	OR	school	4100048	4131	North Wasco County SD 21	410004801833	5250	Wahtonka Community School	Alternative School	No	High	09	12	2018	grade_5	0.0	0
1179582	OR	school	4100640	1968	Myrtle Point SD 41	410064000233	214	Myrtle Crest School	Regular School	No	Elementary	KG	06	2018	grade_5	49.0	49
1179583	OR	school	4100640	1968	Myrtle Point SD 41	410064000234	215	Myrtle Point High School	Regular School	No	High	07	12	2018	grade_5	0.0	0
1178801	OR	school	4100990	2063	Adel SD 21	410099000524	498	Adel Elementary School	Regular School	No	Middle	04	08	2018	grade_5	2.0	2
1178802	OR	school	4101020	2113	Adrian SD 61	410102000755	707	Adrian Elementary School	Regular School	No	Elementary	KG	08	2018	grade_5	26.0	26
1178803	OR	school	4101020	2113	Adrian SD 61	410102000756	708	Adrian High School	Regular School	No	High	09	12	2018	grade_5	0.0	0
1179259	OR	school	4101120	2100	Greater Albany Public SD 8J	410112001577	3950	Albany Options School	Alternative School	No	High	09	12	2018	grade_5	0.0	0
1179260	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000732	632	Calapooia Middle School	Regular School	No	Middle	06	08	2018	grade_5	0.0	0
1179261	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000669	631	Central Elementary School	Regular School	No	Elementary	03	05	2018	grade_5	59.0	59
1179262	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000725	633	Clover Ridge Elementary School	Regular School	No	Elementary	KG	02	2018	grade_5	0.0	0
1179263	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000031	635	Fir Grove Primary School	Regular School	No	Elementary	KG	01	2018	grade_5	0.0	0
1179264	OR	school	4101120	2100	Greater Albany Public SD 8J		2100	Greater Albany Public SD 8J						2018	grade_5	5.0	5
1179265	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000670	640	Lafayette Elementary School	Regular School	No	Elementary	KG	05	2018	grade_5	48.0	48