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
1190472	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2018	grade_12	29.0	29
1190471	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2018	grade_12	0.0	0
1190470	OR	school	4100016	2251	Yamhill Carlton SD 1		2251	Yamhill Carlton SD 1						2018	grade_12	2.0	2
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
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
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
1190466	OR	school	4113530	2146	Woodburn SD 103	411353001715	4544	Woodburn Success	Regular School	No	High	07	12	2018	grade_12	45.0	45
1190465	OR	school	4113530	2146	Woodburn SD 103		2146	Woodburn SD 103						2018	grade_12	25.0	25
1190464	OR	school	4113530	2146	Woodburn SD 103	411353001723	4543	Woodburn Arts and Communications Academy	Regular School	No	High	09	12	2018	grade_12	88.0	88
1190463	OR	school	4113530	2146	Woodburn SD 103	411353001546	4230	Woodburn Arthur Academy	Regular School	Yes	Elementary	KG	05	2018	grade_12	0.0	0
1190462	OR	school	4113530	2146	Woodburn SD 103	411353001713	4542	Woodburn Academy of Art, Science and Technology	Regular School	No	High	09	12	2018	grade_12	91.0	91
1190461	OR	school	4113530	2146	Woodburn SD 103	411353001731	4541	Wellness, Business and Sports School	Regular School	No	High	09	12	2018	grade_12	69.0	69
1190460	OR	school	4113530	2146	Woodburn SD 103	411353000842	797	Washington Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1190459	OR	school	4113530	2146	Woodburn SD 103	411353001052	1360	Valor Middle School	Regular School	No	Middle	06	08	2018	grade_12	0.0	0
1190458	OR	school	4113530	2146	Woodburn SD 103	411353000841	796	Nellie Muir Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1190457	OR	school	4113530	2146	Woodburn SD 103	411353000843	1267	Lincoln Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1190456	OR	school	4113530	2146	Woodburn SD 103	411353001051	1359	Heritage Elementary	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1190455	OR	school	4113530	2146	Woodburn SD 103	411353000844	1268	French Prairie Middle School	Regular School	No	Middle	06	08	2018	grade_12	0.0	0
1190454	OR	school	4113530	2146	Woodburn SD 103	411353001714	4540	Academy of International Studies (at Woodburn)	Regular School	No	High	09	12	2018	grade_12	45.0	45
1190453	OR	school	4113490	2002	Winston-Dillard SD 116	411349000335	315	Winston Middle School	Regular School	No	Middle	07	08	2018	grade_12	0.0	0
1190452	OR	school	4113490	2002	Winston-Dillard SD 116	411349000331	311	McGovern Elementary School	Regular School	No	Middle	04	06	2018	grade_12	0.0	0
1190451	OR	school	4113490	2002	Winston-Dillard SD 116	411349000333	313	Lookingglass Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1190450	OR	school	4113490	2002	Winston-Dillard SD 116	411349000336	316	Douglas High School	Regular School	No	High	09	12	2018	grade_12	95.0	95
1190449	OR	school	4113490	2002	Winston-Dillard SD 116	411349001828	5201	Dillard Alternative High School	Alternative School	No	High	09	12	2018	grade_12	12.0	12
1190448	OR	school	4113490	2002	Winston-Dillard SD 116	411349001573	3624	Brockway Elementary School	Regular School	No	Elementary	KG	03	2018	grade_12	0.0	0
1190447	OR	school	4113350	2255	Willamina SD 30J	411335001338	1225	Willamina Middle School	Regular School	No	Middle	07	08	2018	grade_12	0.0	0
1190446	OR	school	4113350	2255	Willamina SD 30J	411335001277	1226	Willamina High School	Regular School	No	High	09	12	2018	grade_12	70.0	70
1190445	OR	school	4113350	2255	Willamina SD 30J	411335001276	1224	Willamina Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1190444	OR	school		2117	Willamette ESD		2117	Willamette ESD						2018	grade_12	1.0	1
1190443	OR	school		2117	Willamette ESD		2334	Oregon State Hospital Salem (educational program)						2018	grade_12	11.0	11
1190442	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317000574	1323	Wilsonville High School	Regular School	No	High	09	12	2018	grade_12	278.0	278
1190441	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001377	1286	Willamette Primary School	Regular School	No	Elementary	PK	05	2018	grade_12	0.0	0
1190440	OR	school	4113170	1922	West Linn-Wilsonville SD 3J		1922	West Linn-Wilsonville SD 3J						2018	grade_12	28.0	28
1190439	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317000058	51	West Linn High School	Regular School	No	High	09	12	2018	grade_12	445.0	445
1190438	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001825	5057	Trillium Creek Primary School	Regular School	No	Elementary	PK	05	2018	grade_12	0.0	0
1190437	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001437	3452	Three Rivers Charter School	Regular School	Yes	Middle	04	08	2018	grade_12	0.0	0
1190436	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317000055	48	Sunset Primary School	Regular School	No	Elementary	PK	05	2018	grade_12	0.0	0
1190435	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317000054	47	Stafford Primary School	Regular School	No	Elementary	PK	05	2018	grade_12	0.0	0
1190434	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001414	2787	Rosemont Ridge Middle School	Regular School	No	Middle	06	08	2018	grade_12	0.0	0
1190433	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001851	5377	Meridian Creek Middle School	Regular School	No	Middle	06	08	2018	grade_12	0.0	0
1190432	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001822	5056	Lowrie Primary School	Regular School	No	Elementary	PK	05	2018	grade_12	0.0	0
1190431	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001318	46	Inza R Wood Middle School	Regular School	No	Middle	06	08	2018	grade_12	0.0	0
1190430	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317000053	45	Cedaroak Park Primary School	Regular School	No	Elementary	PK	05	2018	grade_12	0.0	0
1190429	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001575	3913	Boones Ferry Primary School	Regular School	No	Elementary	PK	05	2018	grade_12	0.0	0
1190428	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001447	3455	Bolton Primary School	Regular School	No	Elementary	PK	05	2018	grade_12	0.0	0
1190427	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001356	1272	Boeckman Creek Primary School	Regular School	No	Elementary	PK	05	2018	grade_12	0.0	0
1190426	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317000056	1287	Athey Creek Middle School	Regular School	No	Middle	06	08	2018	grade_12	0.0	0
1190425	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001786	4773	Arts and Technology High School	Alternative School	No	High	09	12	2018	grade_12	33.0	33
1190424	OR	school	4113080	1936	Warrenton-Hammond SD 30	411308000167	157	Warrenton High School	Regular School	No	High	09	12	2018	grade_12	59.0	59
1190423	OR	school	4113080	1936	Warrenton-Hammond SD 30	411308000166	156	Warrenton Grade School	Regular School	No	Elementary	KG	08	2018	grade_12	0.0	0
1190422	OR	school	4112990	2220	Wallowa SD 12	411299001147	1089	Wallowa High School	Regular School	No	High	07	12	2018	grade_12	12.0	12
1190421	OR	school	4112990	2220	Wallowa SD 12	411299001371	1088	Wallowa Elementary School	Regular School	No	Elementary	PK	06	2018	grade_12	0.0	0
1190420	OR	school	4112930	1947	Vernonia SD 47J	411293001673	4396	Vernonia Middle School	Regular School	No	Middle	06	08	2018	grade_12	0.0	0
1190419	OR	school	4112930	1947	Vernonia SD 47J	411293000188	178	Vernonia High School	Regular School	No	High	09	12	2018	grade_12	62.0	62
1190418	OR	school	4112930	1947	Vernonia SD 47J	411293000187	177	Vernonia Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1190417	OR	school	4112930	1947	Vernonia SD 47J	411293000186	176	Mist Elementary School	Regular School	No	Elementary	KG	05	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
1190415	OR	school	4100014	2116	Vale SD 84		2116	Vale SD 84						2018	grade_12	11.0	11
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
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
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
1190411	OR	school	4112690	2213	Union SD 5	411269001133	1075	Union High School	Regular School	No	High	07	12	2018	grade_12	28.0	28
1190410	OR	school	4112690	2213	Union SD 5	411269001132	1074	Union Elementary School	Regular School	No	Elementary	KG	06	2018	grade_12	0.0	0
1190409	OR	school	4112600	2204	Umatilla SD 6R	411260001092	1033	Umatilla High School	Regular School	No	High	09	12	2018	grade_12	98.0	98
1190408	OR	school	4112600	2204	Umatilla SD 6R	411260001091	1032	McNary Heights Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1190407	OR	school	4112600	2204	Umatilla SD 6R	411260001090	1031	Clara Brownell Middle School	Regular School	No	Middle	06	08	2018	grade_12	0.0	0
1190406	OR	school	4112540	2210	Ukiah SD 80R	411254001122	3432	Ukiah School	Regular School	No	Other	KG	12	2018	grade_12	2.0	2
1190405	OR	school	4112360	2222	Troy SD 54	411236001150	1092	Troy Elementary School	Regular School	No	Elementary	KG	08	2018	grade_12	0.0	0
1190404	OR	school	4112320	2197	Tillamook SD 9		2197	Tillamook SD 9						2018	grade_12	0.0	0
1190403	OR	school	4112320	2197	Tillamook SD 9	411232001074	1016	Tillamook Junior High School	Regular School	No	Middle	07	08	2018	grade_12	0.0	0
1190402	OR	school	4112320	2197	Tillamook SD 9	411232001075	1017	Tillamook High School	Regular School	No	High	09	12	2018	grade_12	155.0	155
1190401	OR	school	4112320	2197	Tillamook SD 9	411232001072	1014	South Prairie Elementary School	Regular School	No	Elementary	02	03	2018	grade_12	0.0	0
1190400	OR	school	4112320	2197	Tillamook SD 9	411232001071	1013	Liberty Elementary School	Regular School	No	Elementary	KG	01	2018	grade_12	0.0	0
1190399	OR	school	4112320	2197	Tillamook SD 9	411232001070	1012	East Elementary School	Regular School	No	Middle	04	06	2018	grade_12	0.0	0
1190398	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224001197	1145	Twality Middle School	Regular School	No	Middle	06	08	2018	grade_12	0.0	0
1190397	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224000440	1301	Tualatin High School	Regular School	No	High	09	12	2018	grade_12	501.0	501
1190396	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224001195	1143	Tualatin Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1190395	OR	school	4112240	2242	Tigard-Tualatin SD 23J		2242	Tigard-Tualatin SD 23J						2018	grade_12	62.0	62
1190394	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224001198	1146	Tigard High School	Regular School	No	High	09	12	2018	grade_12	503.0	503
1190393	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224001196	1144	Thomas R Fowler Middle School	Regular School	No	Middle	06	08	2018	grade_12	0.0	0
1190392	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_12	0.0	0
1190391	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224001193	1140	Metzger Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1190390	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224001299	1137	Mary Woodward Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1190389	OR	school	4112240	2242	Tigard-Tualatin SD 23J		2273	Janus Youth Programs--Cordero House						2018	grade_12	3.0	3
1190388	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224001192	1139	James Templeton Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1190387	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224000381	1300	Hazelbrook Middle School	Regular School	No	Middle	06	08	2018	grade_12	0.0	0
1190386	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224001298	1142	Edward Byrom Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1190385	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224001191	1138	Durham Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1190384	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224001722	2714	Durham Center	Alternative School	No	High	06	12	2018	grade_12	58.0	58
1190383	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224001261	1369	Deer Creek Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1190382	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224001190	1136	Charles F Tigard Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1190381	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224001331	1135	Bridgeport Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1190380	OR	school	4112240	2242	Tigard-Tualatin SD 23J	411224001668	4364	Alberta Rider Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1190379	OR	school	4106900	2055	Three Rivers/Josephine County SD	410690001812	5063	Woodland Charter School	Regular School	Yes	Elementary	01	08	2018	grade_12	0.0	0
1190378	OR	school	4106900	2055	Three Rivers/Josephine County SD	410690000477	453	Williams Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1190377	OR	school	4106900	2055	Three Rivers/Josephine County SD		1877	The Inn Between Educational Program, DBA Inn Sight						2018	grade_12	6.0	6
1190376	OR	school	4106900	2055	Three Rivers/Josephine County SD	410690001797	4823	Sunny Wolf Charter School	Regular School	Yes	Elementary	KG	05	2018	grade_12	0.0	0
1190375	OR	school	4106900	2055	Three Rivers/Josephine County SD	410690000481	457	North Valley High School	Regular School	No	High	09	12	2018	grade_12	133.0	133
1190374	OR	school	4106900	2055	Three Rivers/Josephine County SD	410690000473	451	Manzanita Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1190373	OR	school	4106900	2055	Three Rivers/Josephine County SD	410690000472	450	Madrona Elementary School	Regular School	No	Elementary	KG	05	2018	grade_12	0.0	0
1190372	OR	school	4106900	2055	Three Rivers/Josephine County SD	410690000471	449	Lorna Byrne Middle School	Regular School	No	Middle	05	08	2018	grade_12	0.0	0