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
1174828	OR	school	4100003	2193	Falls City SD 57	410000301061	1005	Falls City Elementary School	Regular School	No	Elementary	KG	08	2018	grade_2	18.0	18
1174829	OR	school	4100003	2193	Falls City SD 57	410000301062	1006	Falls City High School	Regular School	No	High	09	12	2018	grade_2	0.0	0
1175347	OR	school	4100009	2336	Oregon Department of Education	410000900062	1832	Oregon School for the Deaf	Special Education School	No	Other	KG	12	2018	grade_2	9.0	9
1175346	OR	school	4100009	2336	Oregon Department of Education	410000901592	4040	Four Rivers Community School	Regular School	Yes	Other	KG	10	2018	grade_2	26.0	26
1175348	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_2	22.0	22
1175349	OR	school	4100009	2336	Oregon Department of Education	410000901784	4720	The Ivy School	Regular School	Yes	Elementary	01	08	2018	grade_2	38.0	38
1175345	OR	school	4100009	2336	Oregon Department of Education	410000901808	4850	Eagle Charter School	Regular School	Yes	Elementary	KG	05	2018	grade_2	24.0	24
1175822	OR	school	4100014	2116	Vale SD 84	410001400748	701	Vale Elementary School	Regular School	No	Elementary	KG	06	2018	grade_2	50.0	50
1175826	OR	school	4100014	2116	Vale SD 84	410001400754	706	Willowcreek Elementary School	Regular School	No	Elementary	01	08	2018	grade_2	9.0	9
1175823	OR	school	4100014	2116	Vale SD 84	410001400761	713	Vale High School	Regular School	No	High	09	12	2018	grade_2	0.0	0
1175824	OR	school	4100014	2116	Vale SD 84	410001401026	1357	Vale Middle School	Regular School	No	Middle	07	08	2018	grade_2	0.0	0
1174856	OR	school	4100015	2137	Gervais SD 1	410001500821	776	Gervais Elementary School	Regular School	No	Elementary	KG	05	2018	grade_2	72.0	72
1174858	OR	school	4100015	2137	Gervais SD 1	410001500831	786	Gervais Middle School	Regular School	No	Middle	06	08	2018	grade_2	0.0	0
1174857	OR	school	4100015	2137	Gervais SD 1	410001500853	808	Gervais High School	Regular School	No	High	09	12	2018	grade_2	0.0	0
1174859	OR	school	4100015	2137	Gervais SD 1	410001501588	4024	Samuel Brown Academy	Alternative School	No	High	06	12	2018	grade_2	0.0	0
1174855	OR	school	4100015	2137	Gervais SD 1	410001501859	5392	Frontier Charter Academy	Regular School	Yes	Middle	05	09	2018	grade_2	0.0	0
1175877	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601266	1213	Yamhill Carlton Elementary School	Regular School	No	Elementary	KG	04	2018	grade_2	67.0	67
1175878	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601288	1238	Yamhill Carlton High School	Regular School	No	High	09	12	2018	grade_2	0.0	0
1175879	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601730	4564	Yamhill Carlton Intermediate School	Regular School	No	Middle	05	08	2018	grade_2	0.0	0
1174936	OR	school	4100019	2099	Harrisburg SD 7J	410001900698	659	Harrisburg Elementary School	Regular School	No	Elementary	KG	05	2018	grade_2	72.0	72
1174937	OR	school	4100019	2099	Harrisburg SD 7J	410001900731	689	Harrisburg High School	Regular School	No	High	09	12	2018	grade_2	0.0	0
1174938	OR	school	4100019	2099	Harrisburg SD 7J	410001901422	2723	Harrisburg Middle School	Regular School	No	Middle	06	08	2018	grade_2	0.0	0
1175269	OR	school	4100020	2143	North Santiam SD 29J	410002000693	656	Mari-Linn Elementary School	Regular School	No	Elementary	KG	08	2018	grade_2	27.0	27
1175273	OR	school	4100020	2143	North Santiam SD 29J	410002000765	717	Sublimity Elementary School	Regular School	No	Elementary	KG	08	2018	grade_2	40.0	40
1175270	OR	school	4100020	2143	North Santiam SD 29J	410002000833	788	Stayton Elementary School	Regular School	No	Elementary	KG	03	2018	grade_2	91.0	91
1175272	OR	school	4100020	2143	North Santiam SD 29J	410002000834	789	Stayton Middle School	Regular School	No	Middle	04	08	2018	grade_2	0.0	0
1175271	OR	school	4100020	2143	North Santiam SD 29J	410002000854	809	Stayton High School	Regular School	No	High	09	12	2018	grade_2	0.0	0
1175710	OR	school	4100021	2225	South Wasco County SD 1	410002101166	1108	Maupin Elementary School	Regular School	No	Elementary	KG	06	2018	grade_2	16.0	16
1175711	OR	school	4100021	2225	South Wasco County SD 1	410002101167	1109	South Wasco County High School	Regular School	No	High	07	12	2018	grade_2	0.0	0
1174981	OR	school	4100023	2239	Hillsboro SD 1J	410002300209	1302	Tobias Elementary School	Regular School	No	Elementary	KG	06	2018	grade_2	46.0	46
1174984	OR	school	4100023	2239	Hillsboro SD 1J	410002301168	1111	West Union Elementary School	Regular School	No	Elementary	KG	06	2018	grade_2	65.0	65
1174950	OR	school	4100023	2239	Hillsboro SD 1J	410002301169	1112	Brookwood Elementary School	Regular School	No	Elementary	KG	06	2018	grade_2	49.0	49
1174954	OR	school	4100023	2239	Hillsboro SD 1J	410002301171	1115	Eastwood Elementary School	Regular School	No	Elementary	KG	06	2018	grade_2	57.0	57
1174983	OR	school	4100023	2239	Hillsboro SD 1J	410002301172	1114	W Verne McKinney Elementary School	Regular School	No	Elementary	KG	06	2018	grade_2	67.0	67
1174972	OR	school	4100023	2239	Hillsboro SD 1J	410002301173	1117	Mooberry Elementary School	Regular School	No	Elementary	KG	06	2018	grade_2	61.0	61
1174982	OR	school	4100023	2239	Hillsboro SD 1J	410002301175	1119	W L Henry Elementary School	Regular School	No	Elementary	KG	06	2018	grade_2	45.0	45
1174951	OR	school	4100023	2239	Hillsboro SD 1J	410002301199	1147	Butternut Creek Elementary School	Regular School	No	Elementary	KG	06	2018	grade_2	56.0	56
1174978	OR	school	4100023	2239	Hillsboro SD 1J	410002301200	1149	Reedville Elementary School	Regular School	No	Elementary	KG	06	2018	grade_2	33.0	33
1174967	OR	school	4100023	2239	Hillsboro SD 1J	410002301201	1150	Ladd Acres Elementary School	Regular School	No	Elementary	KG	06	2018	grade_2	82.0	82
1174985	OR	school	4100023	2239	Hillsboro SD 1J	410002301202	1151	Witch Hazel Elementary School	Regular School	No	Elementary	KG	06	2018	grade_2	75.0	75
1174959	OR	school	4100023	2239	Hillsboro SD 1J	410002301203	1152	Groner K-8	Regular School	No	Elementary	KG	08	2018	grade_2	30.0	30
1174956	OR	school	4100023	2239	Hillsboro SD 1J	410002301242	1189	Farmington View Elementary School	Regular School	No	Elementary	KG	06	2018	grade_2	47.0	47
1174973	OR	school	4100023	2239	Hillsboro SD 1J	410002301243	1190	North Plains Elementary School	Regular School	No	Elementary	KG	06	2018	grade_2	47.0	47
1174952	OR	school	4100023	2239	Hillsboro SD 1J	410002301248	1368	Century High School	Regular School	No	High	09	12	2018	grade_2	0.0	0
1174977	OR	school	4100023	2239	Hillsboro SD 1J	410002301250	1196	R A Brown Middle School	Regular School	No	Middle	07	08	2018	grade_2	0.0	0
1174965	OR	school	4100023	2239	Hillsboro SD 1J	410002301251	1199	J W Poynter Middle School	Regular School	No	Middle	07	08	2018	grade_2	0.0	0
1174960	OR	school	4100023	2239	Hillsboro SD 1J	410002301252	1201	Hillsboro High School	Regular School	No	High	09	12	2018	grade_2	0.0	0
1174980	OR	school	4100023	2239	Hillsboro SD 1J	410002301253	1198	South Meadows Middle School	Regular School	No	Middle	07	08	2018	grade_2	0.0	0
1174964	OR	school	4100023	2239	Hillsboro SD 1J	410002301295	1148	Indian Hills Elementary School	Regular School	No	Elementary	KG	06	2018	grade_2	72.0	72
1174968	OR	school	4100023	2239	Hillsboro SD 1J	410002301300	1110	Lenox Elementary School	Regular School	No	Elementary	KG	06	2018	grade_2	68.0	68
1174971	OR	school	4100023	2239	Hillsboro SD 1J	410002301305	1116	Minter Bridge Elementary School	Regular School	No	Elementary	KG	06	2018	grade_2	67.0	67
1174958	OR	school	4100023	2239	Hillsboro SD 1J	410002301306	1200	Glencoe High School	Regular School	No	High	09	12	2018	grade_2	0.0	0
1174955	OR	school	4100023	2239	Hillsboro SD 1J	410002301322	1197	Evergreen Jr High School	Regular School	No	Middle	07	08	2018	grade_2	0.0	0
1174966	OR	school	4100023	2239	Hillsboro SD 1J	410002301373	1285	Jackson Elementary School	Regular School	No	Elementary	KG	06	2018	grade_2	84.0	84
1174974	OR	school	4100023	2239	Hillsboro SD 1J	410002301499	3160	Orenco Elementary School	Regular School	No	Elementary	KG	06	2018	grade_2	92.0	92
1174975	OR	school	4100023	2239	Hillsboro SD 1J	410002301500	3159	Paul L Patterson Elementary School	Regular School	No	Elementary	KG	06	2018	grade_2	56.0	56
1174953	OR	school	4100023	2239	Hillsboro SD 1J	410002301535	4206	City View Charter School	Regular School	Yes	Elementary	KG	08	2018	grade_2	23.0	23
1174969	OR	school	4100023	2239	Hillsboro SD 1J	410002301585	4018	Liberty High School	Regular School	No	High	09	12	2018	grade_2	0.0	0
1174970	OR	school	4100023	2239	Hillsboro SD 1J	410002301749	4642	Lincoln Street Elementary School	Regular School	No	Elementary	KG	06	2018	grade_2	65.0	65
1174979	OR	school	4100023	2239	Hillsboro SD 1J	410002301750	4703	Rosedale Elementary School	Regular School	No	Elementary	KG	06	2018	grade_2	65.0	65
1174976	OR	school	4100023	2239	Hillsboro SD 1J	410002301759	4643	Quatama Elementary School	Regular School	No	Elementary	KG	06	2018	grade_2	71.0	71
1174957	OR	school	4100023	2239	Hillsboro SD 1J	410002301764	4641	Free Orchards Elementary School	Regular School	No	Elementary	KG	06	2018	grade_2	49.0	49
1174961	OR	school	4100023	2239	Hillsboro SD 1J	410002301824	4973	Hillsboro Online Academy	Regular School	No	Other	KG	12	2018	grade_2	3.0	3
1174963	OR	school	4100023	2239	Hillsboro SD 1J	410002304174	3536	Imlay Elementary School	Regular School	No	Elementary	KG	06	2018	grade_2	70.0	70
1175058	OR	school	4100040	2262	Knappa SD 4	410004000176	166	Hilda Lahti Elementary School	Regular School	No	Elementary	KG	08	2018	grade_2	33.0	33
1175059	OR	school	4100040	2262	Knappa SD 4	410004000179	169	Knappa High School	Regular School	No	High	09	12	2018	grade_2	0.0	0
1175314	OR	school	4100043	3477	ODE YCEP District	410004300490	1827	Robert S Farrell High School	Regular School	No	Not Reported	M	M	2018	grade_2	0.0	0
1175318	OR	school	4100043	3477	ODE YCEP District	410004300494	1828	William P Lord High School	Regular School	No	High	06	12	2018	grade_2	0.0	0
1175309	OR	school	4100043	3477	ODE YCEP District	410004301404	2258	Monroe School	Regular School	No	High	06	12	2018	grade_2	0.0	0
1175310	OR	school	4100043	3477	ODE YCEP District	410004301406	2260	New Bridge High School	Regular School	No	High	06	12	2018	grade_2	0.0	0
1175311	OR	school	4100043	3477	ODE YCEP District	410004301412	2387	Ocean Dunes High School	Regular School	No	High	09	12	2018	grade_2	0.0	0
1175313	OR	school	4100043	3477	ODE YCEP District	410004301413	2388	Riverside High School	Regular School	No	High	10	12	2018	grade_2	0.0	0
1175315	OR	school	4100043	3477	ODE YCEP District	410004301476	2385	South Jetty High School	Regular School	No	High	06	12	2018	grade_2	0.0	0
1175312	OR	school	4100043	3477	ODE YCEP District	410004301477	2386	RiverBend High School	Regular School	No	High	09	12	2018	grade_2	0.0	0
1175317	OR	school	4100043	3477	ODE YCEP District	410004301740	4588	Trask River High School	Regular School	No	High	06	12	2018	grade_2	0.0	0
1175316	OR	school	4100043	3477	ODE YCEP District	410004301744	4609	Three Lakes High School	Regular School	No	High	06	12	2018	grade_2	0.0	0
1174999	OR	school	4100047	3997	Ione SD R2	410004700862	3363	Ione Community Charter School	Regular School	Yes	Other	KG	12	2018	grade_2	9.0	9
1175274	OR	school	4100048	4131	North Wasco County SD 21	410004801151	1093	Chenowith Elementary School	Regular School	No	Elementary	KG	05	2018	grade_2	62.0	62
1175278	OR	school	4100048	4131	North Wasco County SD 21	410004801153	1095	Mosier Community School	Regular School	Yes	Elementary	KG	08	2018	grade_2	24.0	24
1175275	OR	school	4100048	4131	North Wasco County SD 21	410004801155	1097	Colonel Wright Elementary School	Regular School	No	Elementary	KG	05	2018	grade_2	46.0	46
1175277	OR	school	4100048	4131	North Wasco County SD 21	410004801156	1098	Dry Hollow Elementary School	Regular School	No	Elementary	KG	05	2018	grade_2	102.0	102
1175281	OR	school	4100048	4131	North Wasco County SD 21	410004801158	1100	The Dalles Middle School	Regular School	No	Middle	06	08	2018	grade_2	0.0	0
1175280	OR	school	4100048	4131	North Wasco County SD 21	410004801159	1101	The Dalles High School	Regular School	No	High	09	12	2018	grade_2	0.0	0
1175282	OR	school	4100048	4131	North Wasco County SD 21	410004801833	5250	Wahtonka Community School	Alternative School	No	High	09	12	2018	grade_2	0.0	0
1175205	OR	school	4100640	1968	Myrtle Point SD 41	410064000233	214	Myrtle Crest School	Regular School	No	Elementary	KG	06	2018	grade_2	45.0	45
1175206	OR	school	4100640	1968	Myrtle Point SD 41	410064000234	215	Myrtle Point High School	Regular School	No	High	07	12	2018	grade_2	0.0	0
1174424	OR	school	4100990	2063	Adel SD 21	410099000524	498	Adel Elementary School	Regular School	No	Middle	04	08	2018	grade_2	0.0	0
1174425	OR	school	4101020	2113	Adrian SD 61	410102000755	707	Adrian Elementary School	Regular School	No	Elementary	KG	08	2018	grade_2	20.0	20
1174426	OR	school	4101020	2113	Adrian SD 61	410102000756	708	Adrian High School	Regular School	No	High	09	12	2018	grade_2	0.0	0
1174894	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000017	639	Oak Grove Elementary School	Regular School	No	Elementary	02	05	2018	grade_2	63.0	63
1174891	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000029	637	North Albany Elementary School	Regular School	No	Elementary	KG	05	2018	grade_2	48.0	48
1174886	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000031	635	Fir Grove Primary School	Regular School	No	Elementary	KG	01	2018	grade_2	0.0	0
1174884	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000669	631	Central Elementary School	Regular School	No	Elementary	03	05	2018	grade_2	0.0	0
1174888	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000670	640	Lafayette Elementary School	Regular School	No	Elementary	KG	05	2018	grade_2	56.0	56
1174889	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000671	641	Liberty Elementary School	Regular School	No	Elementary	KG	05	2018	grade_2	53.0	53
1174893	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000672	643	Oak Elementary School	Regular School	No	Elementary	KG	05	2018	grade_2	59.0	59
1174898	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000673	644	Sunrise Elementary School	Regular School	No	Elementary	KG	05	2018	grade_2	53.0	53
1174897	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000674	645	South Shore Elementary School	Regular School	No	Elementary	KG	05	2018	grade_2	71.0	71
1174899	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000675	647	Takena Elementary School	Regular School	No	Elementary	KG	02	2018	grade_2	51.0	51
1174902	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000676	648	Waverly Elementary School	Regular School	No	Elementary	KG	05	2018	grade_2	33.0	33
1174895	OR	school	4101120	2100	Greater Albany Public SD 8J	410112000680	636	Periwinkle Elementary School	Regular School	No	Elementary	KG	05	2018	grade_2	73.0	73