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 rowid desc 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
1187554	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2018	grade_10	22.0	22
1187553	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2018	grade_10	0.0	0
1187552	OR	school	4100016	2251	Yamhill Carlton SD 1		2251	Yamhill Carlton SD 1						2018	grade_10	1.0	1
1187551	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601730	4564	Yamhill Carlton Intermediate School	Regular School	No	Middle	05	08	2018	grade_10	0.0	0
1187550	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601288	1238	Yamhill Carlton High School	Regular School	No	High	09	12	2018	grade_10	73.0	73
1187549	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601266	1213	Yamhill Carlton Elementary School	Regular School	No	Elementary	KG	04	2018	grade_10	0.0	0
1187548	OR	school	4113530	2146	Woodburn SD 103	411353001715	4544	Woodburn Success	Regular School	No	High	07	12	2018	grade_10	12.0	12
1187547	OR	school	4113530	2146	Woodburn SD 103		2146	Woodburn SD 103						2018	grade_10	0.0	0
1187546	OR	school	4113530	2146	Woodburn SD 103	411353001723	4543	Woodburn Arts and Communications Academy	Regular School	No	High	09	12	2018	grade_10	98.0	98
1187545	OR	school	4113530	2146	Woodburn SD 103	411353001546	4230	Woodburn Arthur Academy	Regular School	Yes	Elementary	KG	05	2018	grade_10	0.0	0
1187544	OR	school	4113530	2146	Woodburn SD 103	411353001713	4542	Woodburn Academy of Art, Science and Technology	Regular School	No	High	09	12	2018	grade_10	97.0	97
1187543	OR	school	4113530	2146	Woodburn SD 103	411353001731	4541	Wellness, Business and Sports School	Regular School	No	High	09	12	2018	grade_10	101.0	101
1187542	OR	school	4113530	2146	Woodburn SD 103	411353000842	797	Washington Elementary School	Regular School	No	Elementary	KG	05	2018	grade_10	0.0	0
1187541	OR	school	4113530	2146	Woodburn SD 103	411353001052	1360	Valor Middle School	Regular School	No	Middle	06	08	2018	grade_10	0.0	0
1187540	OR	school	4113530	2146	Woodburn SD 103	411353000841	796	Nellie Muir Elementary School	Regular School	No	Elementary	KG	05	2018	grade_10	0.0	0
1187539	OR	school	4113530	2146	Woodburn SD 103	411353000843	1267	Lincoln Elementary School	Regular School	No	Elementary	KG	05	2018	grade_10	0.0	0
1187538	OR	school	4113530	2146	Woodburn SD 103	411353001051	1359	Heritage Elementary	Regular School	No	Elementary	KG	05	2018	grade_10	0.0	0
1187537	OR	school	4113530	2146	Woodburn SD 103	411353000844	1268	French Prairie Middle School	Regular School	No	Middle	06	08	2018	grade_10	0.0	0
1187536	OR	school	4113530	2146	Woodburn SD 103	411353001714	4540	Academy of International Studies (at Woodburn)	Regular School	No	High	09	12	2018	grade_10	93.0	93
1187535	OR	school	4113490	2002	Winston-Dillard SD 116	411349000335	315	Winston Middle School	Regular School	No	Middle	07	08	2018	grade_10	0.0	0
1187534	OR	school	4113490	2002	Winston-Dillard SD 116	411349000331	311	McGovern Elementary School	Regular School	No	Middle	04	06	2018	grade_10	0.0	0
1187533	OR	school	4113490	2002	Winston-Dillard SD 116	411349000333	313	Lookingglass Elementary School	Regular School	No	Elementary	KG	06	2018	grade_10	0.0	0
1187532	OR	school	4113490	2002	Winston-Dillard SD 116	411349000336	316	Douglas High School	Regular School	No	High	09	12	2018	grade_10	93.0	93
1187531	OR	school	4113490	2002	Winston-Dillard SD 116	411349001828	5201	Dillard Alternative High School	Alternative School	No	High	09	12	2018	grade_10	2.0	2
1187530	OR	school	4113490	2002	Winston-Dillard SD 116	411349001573	3624	Brockway Elementary School	Regular School	No	Elementary	KG	03	2018	grade_10	0.0	0
1187529	OR	school	4113350	2255	Willamina SD 30J	411335001338	1225	Willamina Middle School	Regular School	No	Middle	07	08	2018	grade_10	0.0	0
1187528	OR	school	4113350	2255	Willamina SD 30J	411335001277	1226	Willamina High School	Regular School	No	High	09	12	2018	grade_10	55.0	55
1187527	OR	school	4113350	2255	Willamina SD 30J	411335001276	1224	Willamina Elementary School	Regular School	No	Elementary	KG	06	2018	grade_10	0.0	0
1187526	OR	school		2117	Willamette ESD		2117	Willamette ESD						2018	grade_10	0.0	0
1187525	OR	school		2117	Willamette ESD		2334	Oregon State Hospital Salem (educational program)						2018	grade_10	0.0	0
1187524	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317000574	1323	Wilsonville High School	Regular School	No	High	09	12	2018	grade_10	296.0	296
1187523	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001377	1286	Willamette Primary School	Regular School	No	Elementary	PK	05	2018	grade_10	0.0	0
1187522	OR	school	4113170	1922	West Linn-Wilsonville SD 3J		1922	West Linn-Wilsonville SD 3J						2018	grade_10	0.0	0
1187521	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317000058	51	West Linn High School	Regular School	No	High	09	12	2018	grade_10	471.0	471
1187520	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001825	5057	Trillium Creek Primary School	Regular School	No	Elementary	PK	05	2018	grade_10	0.0	0
1187519	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001437	3452	Three Rivers Charter School	Regular School	Yes	Middle	04	08	2018	grade_10	0.0	0
1187518	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317000055	48	Sunset Primary School	Regular School	No	Elementary	PK	05	2018	grade_10	0.0	0
1187517	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317000054	47	Stafford Primary School	Regular School	No	Elementary	PK	05	2018	grade_10	0.0	0
1187516	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001414	2787	Rosemont Ridge Middle School	Regular School	No	Middle	06	08	2018	grade_10	0.0	0
1187515	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001851	5377	Meridian Creek Middle School	Regular School	No	Middle	06	08	2018	grade_10	0.0	0
1187514	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001822	5056	Lowrie Primary School	Regular School	No	Elementary	PK	05	2018	grade_10	0.0	0
1187513	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001318	46	Inza R Wood Middle School	Regular School	No	Middle	06	08	2018	grade_10	0.0	0
1187512	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317000053	45	Cedaroak Park Primary School	Regular School	No	Elementary	PK	05	2018	grade_10	0.0	0
1187511	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001575	3913	Boones Ferry Primary School	Regular School	No	Elementary	PK	05	2018	grade_10	0.0	0
1187510	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001447	3455	Bolton Primary School	Regular School	No	Elementary	PK	05	2018	grade_10	0.0	0
1187509	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001356	1272	Boeckman Creek Primary School	Regular School	No	Elementary	PK	05	2018	grade_10	0.0	0
1187508	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317000056	1287	Athey Creek Middle School	Regular School	No	Middle	06	08	2018	grade_10	0.0	0
1187507	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001786	4773	Arts and Technology High School	Alternative School	No	High	09	12	2018	grade_10	15.0	15
1187506	OR	school	4113080	1936	Warrenton-Hammond SD 30	411308000167	157	Warrenton High School	Regular School	No	High	09	12	2018	grade_10	82.0	82
1187505	OR	school	4113080	1936	Warrenton-Hammond SD 30	411308000166	156	Warrenton Grade School	Regular School	No	Elementary	KG	08	2018	grade_10	0.0	0
1187504	OR	school	4112990	2220	Wallowa SD 12	411299001147	1089	Wallowa High School	Regular School	No	High	07	12	2018	grade_10	9.0	9
1187503	OR	school	4112990	2220	Wallowa SD 12	411299001371	1088	Wallowa Elementary School	Regular School	No	Elementary	PK	06	2018	grade_10	0.0	0
1187502	OR	school	4112930	1947	Vernonia SD 47J	411293001673	4396	Vernonia Middle School	Regular School	No	Middle	06	08	2018	grade_10	0.0	0
1187501	OR	school	4112930	1947	Vernonia SD 47J	411293000188	178	Vernonia High School	Regular School	No	High	09	12	2018	grade_10	52.0	52
1187500	OR	school	4112930	1947	Vernonia SD 47J	411293000187	177	Vernonia Elementary School	Regular School	No	Elementary	KG	05	2018	grade_10	0.0	0
1187499	OR	school	4112930	1947	Vernonia SD 47J	411293000186	176	Mist Elementary School	Regular School	No	Elementary	KG	05	2018	grade_10	0.0	0
1187498	OR	school	4100014	2116	Vale SD 84	410001400754	706	Willowcreek Elementary School	Regular School	No	Elementary	01	08	2018	grade_10	0.0	0
1187497	OR	school	4100014	2116	Vale SD 84		2116	Vale SD 84						2018	grade_10	3.0	3
1187496	OR	school	4100014	2116	Vale SD 84	410001401026	1357	Vale Middle School	Regular School	No	Middle	07	08	2018	grade_10	0.0	0
1187495	OR	school	4100014	2116	Vale SD 84	410001400761	713	Vale High School	Regular School	No	High	09	12	2018	grade_10	69.0	69
1187494	OR	school	4100014	2116	Vale SD 84	410001400748	701	Vale Elementary School	Regular School	No	Elementary	KG	06	2018	grade_10	0.0	0
1187493	OR	school	4112690	2213	Union SD 5	411269001133	1075	Union High School	Regular School	No	High	07	12	2018	grade_10	36.0	36
1187492	OR	school	4112690	2213	Union SD 5	411269001132	1074	Union Elementary School	Regular School	No	Elementary	KG	06	2018	grade_10	0.0	0
1187491	OR	school	4112600	2204	Umatilla SD 6R	411260001092	1033	Umatilla High School	Regular School	No	High	09	12	2018	grade_10	105.0	105
1187490	OR	school	4112600	2204	Umatilla SD 6R	411260001091	1032	McNary Heights Elementary School	Regular School	No	Elementary	KG	05	2018	grade_10	0.0	0
1187489	OR	school	4112600	2204	Umatilla SD 6R	411260001090	1031	Clara Brownell Middle School	Regular School	No	Middle	06	08	2018	grade_10	0.0	0
1187488	OR	school	4112540	2210	Ukiah SD 80R	411254001122	3432	Ukiah School	Regular School	No	Other	KG	12	2018	grade_10	4.0	4
1187487	OR	school	4112360	2222	Troy SD 54	411236001150	1092	Troy Elementary School	Regular School	No	Elementary	KG	08	2018	grade_10	0.0	0
1187486	OR	school	4112320	2197	Tillamook SD 9		2197	Tillamook SD 9						2018	grade_10	0.0	0
1187485	OR	school	4112320	2197	Tillamook SD 9	411232001074	1016	Tillamook Junior High School	Regular School	No	Middle	07	08	2018	grade_10	0.0	0
1187484	OR	school	4112320	2197	Tillamook SD 9	411232001075	1017	Tillamook High School	Regular School	No	High	09	12	2018	grade_10	158.0	158
1187483	OR	school	4112320	2197	Tillamook SD 9	411232001072	1014	South Prairie Elementary School	Regular School	No	Elementary	02	03	2018	grade_10	0.0	0
1187482	OR	school	4112320	2197	Tillamook SD 9	411232001071	1013	Liberty Elementary School	Regular School	No	Elementary	KG	01	2018	grade_10	0.0	0
1187481	OR	school	4112320	2197	Tillamook SD 9	411232001070	1012	East Elementary School	Regular School	No	Middle	04	06	2018	grade_10	0.0	0
1187480	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224001197	1145	Twality Middle School	Regular School	No	Middle	06	08	2018	grade_10	0.0	0
1187479	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224000440	1301	Tualatin High School	Regular School	No	High	09	12	2018	grade_10	495.0	495
1187478	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224001195	1143	Tualatin Elementary School	Regular School	No	Elementary	KG	05	2018	grade_10	0.0	0
1187477	OR	school	4112240	2242	Tigard-Tualatin SD 23J		2242	Tigard-Tualatin SD 23J						2018	grade_10	1.0	1
1187476	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224001198	1146	Tigard High School	Regular School	No	High	09	12	2018	grade_10	490.0	490
1187475	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224001196	1144	Thomas R Fowler Middle School	Regular School	No	Middle	06	08	2018	grade_10	0.0	0
1187474	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224004176	3579	Multi-sensory Instruction Teaching Children Hands-On (MITCH)	Regular School	Yes	Elementary	KG	08	2018	grade_10	0.0	0
1187473	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224001193	1140	Metzger Elementary School	Regular School	No	Elementary	KG	05	2018	grade_10	0.0	0
1187472	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224001299	1137	Mary Woodward Elementary School	Regular School	No	Elementary	KG	05	2018	grade_10	0.0	0
1187471	OR	school	4112240	2242	Tigard-Tualatin SD 23J		2273	Janus Youth Programs--Cordero House						2018	grade_10	2.0	2
1187470	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224001192	1139	James Templeton Elementary School	Regular School	No	Elementary	KG	05	2018	grade_10	0.0	0
1187469	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224000381	1300	Hazelbrook Middle School	Regular School	No	Middle	06	08	2018	grade_10	0.0	0
1187468	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224001298	1142	Edward Byrom Elementary School	Regular School	No	Elementary	KG	05	2018	grade_10	0.0	0
1187467	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224001191	1138	Durham Elementary School	Regular School	No	Elementary	KG	05	2018	grade_10	0.0	0
1187466	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224001722	2714	Durham Center	Alternative School	No	High	06	12	2018	grade_10	20.0	20
1187465	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224001261	1369	Deer Creek Elementary School	Regular School	No	Elementary	KG	05	2018	grade_10	0.0	0
1187464	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224001190	1136	Charles F Tigard Elementary School	Regular School	No	Elementary	KG	05	2018	grade_10	0.0	0
1187463	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224001331	1135	Bridgeport Elementary School	Regular School	No	Elementary	KG	05	2018	grade_10	0.0	0
1187462	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224001668	4364	Alberta Rider Elementary School	Regular School	No	Elementary	KG	05	2018	grade_10	0.0	0
1187461	OR	school	4106900	2055	Three Rivers/Josephine County SD	410690001812	5063	Woodland Charter School	Regular School	Yes	Elementary	01	08	2018	grade_10	0.0	0
1187460	OR	school	4106900	2055	Three Rivers/Josephine County SD	410690000477	453	Williams Elementary School	Regular School	No	Elementary	KG	05	2018	grade_10	0.0	0
1187459	OR	school	4106900	2055	Three Rivers/Josephine County SD		1877	The Inn Between Educational Program, DBA Inn Sight						2018	grade_10	3.0	3
1187458	OR	school	4106900	2055	Three Rivers/Josephine County SD	410690001797	4823	Sunny Wolf Charter School	Regular School	Yes	Elementary	KG	05	2018	grade_10	0.0	0
1187457	OR	school	4106900	2055	Three Rivers/Josephine County SD	410690000481	457	North Valley High School	Regular School	No	High	09	12	2018	grade_10	137.0	137
1187456	OR	school	4106900	2055	Three Rivers/Josephine County SD	410690000473	451	Manzanita Elementary School	Regular School	No	Elementary	KG	05	2018	grade_10	0.0	0
1187455	OR	school	4106900	2055	Three Rivers/Josephine County SD	410690000472	450	Madrona Elementary School	Regular School	No	Elementary	KG	05	2018	grade_10	0.0	0
1187454	OR	school	4106900	2055	Three Rivers/Josephine County SD	410690000471	449	Lorna Byrne Middle School	Regular School	No	Middle	05	08	2018	grade_10	0.0	0