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 and rowid > :p3 order by rowid 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
1695098	OR	school	4101920	2243	Beaverton SD 48J	410192001232	1179	William Walker Elementary School	Regular School	No	Elementary	KG	05	2017	grade_6	0.0	0
1695099	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198000607	1324	Amity Creek Elementary School	Regular School	No	Elementary	KG	05	2017	grade_6	0.0	0
1695100	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198000258	241	Bear Creek Elementary School	Regular School	No	Elementary	KG	05	2017	grade_6	0.0	0
1695101	OR	school	4101980	1976	Bend-LaPine Administrative SD 1		2916	Bend COIC Dropout Re-engagement Program						2017	grade_6	0.0	0
1695102	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198001845	5309	Bend International School	Regular School	Yes	Elementary	KG	08	2017	grade_6	15.0	15
1695103	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198000270	251	Bend Senior High School	Regular School	No	High	09	12	2017	grade_6	0.0	0
1695104	OR	school	4101980	1976	Bend-LaPine Administrative SD 1		1976	Bend-LaPine Administrative SD 1						2017	grade_6	2.0	2
1695105	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198001290	250	Buckingham Elementary School	Regular School	No	Elementary	KG	05	2017	grade_6	0.0	0
1695106	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198000259	242	Cascade Middle School	Regular School	No	Middle	06	08	2017	grade_6	253.0	253
1695107	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198000245	1308	Elk Meadow Elementary School	Regular School	No	Elementary	KG	05	2017	grade_6	0.0	0
1695108	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198001603	4129	Ensworth Elementary School	Regular School	No	Elementary	KG	05	2017	grade_6	0.0	0
1695109	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198000263	1309	High Desert Middle School	Regular School	No	Middle	06	08	2017	grade_6	255.0	255
1695110	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198001487	3218	High Lakes Elementary School	Regular School	No	Elementary	KG	05	2017	grade_6	0.0	0
1695111	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198001438	3219	Highland School at Kenwood Elementary School	Regular School	No	Elementary	KG	05	2017	grade_6	0.0	0
1695112	OR	school	4101980	1976	Bend-LaPine Administrative SD 1		4290	J Bar J Learning Centers - Boys Ranch Campus						2017	grade_6	0.0	0
1695113	OR	school	4101980	1976	Bend-LaPine Administrative SD 1		1448	J Bar J Learning Centers - Sisters Academy Campus						2017	grade_6	0.0	0
1695114	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198000265	246	Juniper Elementary School	Regular School	No	Elementary	KG	05	2017	grade_6	0.0	0
1695115	OR	school	4101980	1976	Bend-LaPine Administrative SD 1		4262	La Pine COIC Dropout Re-engagement Program						2017	grade_6	0.0	0
1695116	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198000262	245	LaPine Elementary School	Regular School	No	Elementary	KG	05	2017	grade_6	0.0	0
1695117	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198000264	1310	LaPine Middle School	Regular School	No	Middle	06	08	2017	grade_6	97.0	97
1695118	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198000272	253	LaPine Senior High School	Regular School	No	High	09	12	2017	grade_6	0.0	0
1695119	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198000546	1317	Lava Ridge Elementary School	Regular School	No	Elementary	KG	05	2017	grade_6	0.0	0
1695120	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198000688	1338	Marshall High School	Alternative School	No	High	09	12	2017	grade_6	0.0	0
1695121	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198000271	252	Mountain View Senior High School	Regular School	No	High	09	12	2017	grade_6	0.0	0
1695122	OR	school	4101980	1976	Bend-LaPine Administrative SD 1		3662	Oregon Youth Challenge						2017	grade_6	0.0	0
1695123	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198001839	5292	Pacific Crest Middle School	Regular School	No	Middle	06	08	2017	grade_6	206.0	206
1695124	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198000268	249	Pilot Butte Middle School	Regular School	No	Middle	06	08	2017	grade_6	221.0	221
1695125	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198001576	3947	Pine Ridge Elementary	Regular School	No	Elementary	KG	05	2017	grade_6	0.0	0
1695126	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198001747	4646	Ponderosa Elementary	Regular School	No	Elementary	KG	05	2017	grade_6	0.0	0
1695127	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198000266	247	R E Jewell Elementary School	Regular School	No	Elementary	KG	05	2017	grade_6	0.0	0
1695128	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198001436	3448	REALMS (Rimrock Expeditionary Alternative Learning Middle School)	Regular School	No	Middle	06	08	2017	grade_6	53.0	53
1695129	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198001794	4793	Rosland Elementary	Regular School	No	Elementary	KG	05	2017	grade_6	0.0	0
1695130	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198001844	5293	Silver Rail Elementary School	Regular School	No	Elementary	KG	05	2017	grade_6	0.0	0
1695131	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198001488	3217	Sky View Middle School	Regular School	No	Middle	06	08	2017	grade_6	206.0	206
1695132	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198001451	3216	Summit High School	Regular School	No	High	09	12	2017	grade_6	0.0	0
1695133	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198001350	1266	Three Rivers Elementary School	Regular School	No	Elementary	KG	08	2017	grade_6	45.0	45
1695134	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198001454	3221	Westside Village Magnet School at Kingston Elementary School	Regular School	No	Elementary	KG	08	2017	grade_6	32.0	32
1695135	OR	school	4101980	1976	Bend-LaPine Administrative SD 1	410198001758	4680	William E Miller Elementary	Regular School	No	Elementary	KG	05	2017	grade_6	0.0	0
1695136	OR	school	4102040	2088	Bethel SD 52		2088	Bethel SD 52						2017	grade_6	0.0	0
1695137	OR	school	4102040	2088	Bethel SD 52		4717	Bridgeway House						2017	grade_6	1.0	1
1695138	OR	school	4102040	2088	Bethel SD 52	410204000621	581	Cascade Middle School	Regular School	No	Middle	06	08	2017	grade_6	93.0	93
1695139	OR	school	4102040	2088	Bethel SD 52	410204000616	582	Clear Lake Elementary School	Regular School	No	Elementary	KG	05	2017	grade_6	0.0	0
1695140	OR	school	4102040	2088	Bethel SD 52	410204000617	583	Danebo Elementary School	Regular School	No	Elementary	KG	05	2017	grade_6	0.0	0
1695141	OR	school	4102040	2088	Bethel SD 52	410204000618	584	Fairfield Elementary School	Regular School	No	Elementary	KG	05	2017	grade_6	0.0	0
1695142	OR	school	4102040	2088	Bethel SD 52	410204000619	585	Irving Elementary School	Regular School	No	Elementary	KG	05	2017	grade_6	0.0	0
1695143	OR	school	4102040	2088	Bethel SD 52		1792	Jasper Mountain Center						2017	grade_6	1.0	1
1695144	OR	school	4102040	2088	Bethel SD 52	410204004178	3566	Kalapuya High School	Alternative School	No	High	09	12	2017	grade_6	0.0	0
1695145	OR	school	4102040	2088	Bethel SD 52		3545	Looking Glass Center Point School						2017	grade_6	0.0	0
1695146	OR	school	4102040	2088	Bethel SD 52		1532	Looking Glass Riverfront School & Career Center						2017	grade_6	0.0	0
1695147	OR	school	4102040	2088	Bethel SD 52		3760	Looking Glass Youth & Family Services Inc Pathways						2017	grade_6	0.0	0
1695148	OR	school	4102040	2088	Bethel SD 52	410204000620	586	Malabon Elementary School	Regular School	No	Elementary	KG	05	2017	grade_6	0.0	0
1695149	OR	school	4102040	2088	Bethel SD 52	410204001391	2264	Meadow View School	Regular School	No	Elementary	KG	08	2017	grade_6	93.0	93
1695150	OR	school	4102040	2088	Bethel SD 52		1861	Northwest Youth Corps						2017	grade_6	0.0	0
1695151	OR	school	4102040	2088	Bethel SD 52	410204004179	3567	Prairie Mountain School	Regular School	No	Elementary	KG	08	2017	grade_6	87.0	87
1695152	OR	school	4102040	2088	Bethel SD 52		1789	SAFE Center School						2017	grade_6	0.0	0
1695153	OR	school	4102040	2088	Bethel SD 52	410204000622	587	Shasta Middle School	Regular School	No	Middle	06	08	2017	grade_6	151.0	151
1695154	OR	school	4102040	2088	Bethel SD 52		1545	Wellsprings Friends School						2017	grade_6	0.0	0
1695155	OR	school	4102040	2088	Bethel SD 52	410204000623	588	Willamette High School	Regular School	No	High	09	12	2017	grade_6	0.0	0
1695156	OR	school	4102160	2095	Blachly SD 90		2095	Blachly SD 90						2017	grade_6	0.0	0
1695157	OR	school	4102160	2095	Blachly SD 90	410216000641	3401	Triangle Lake Charter School	Regular School	Yes	Other	KG	12	2017	grade_6	20.0	20
1695158	OR	school	4102190	2052	Black Butte SD 41	410219000449	428	Black Butte Elementary School	Regular School	No	Elementary	KG	08	2017	grade_6	1.0	1
1695159	OR	school	4102310	1974	Brookings-Harbor SD 17C	410231000253	235	Azalea Middle School	Regular School	No	Middle	06	08	2017	grade_6	105.0	105
1695160	OR	school	4102310	1974	Brookings-Harbor SD 17C	410231000255	237	Brookings-Harbor High School	Regular School	No	High	09	12	2017	grade_6	0.0	0
1695161	OR	school	4102310	1974	Brookings-Harbor SD 17C	410231000254	236	Kalmiopsis Elementary School	Regular School	No	Elementary	KG	05	2017	grade_6	0.0	0
1695162	OR	school	4101740	1896	Burnt River SD 30J	410174000013	3347	Burnt River School	Regular School	Yes	Other	KG	12	2017	grade_6	3.0	3
1695163	OR	school	4102580	2046	Butte Falls SD 91	410258000426	406	Butte Falls Charter School	Regular School	Yes	Other	KG	12	2017	grade_6	15.0	15
1695164	OR	school	4102610	1995	Camas Valley SD 21J	410261000315	3400	Camas Valley School	Regular School	Yes	Other	PK	12	2017	grade_6	14.0	14
1695165	OR	school	4102640	1929	Canby SD 86	410264001651	4434	Baker Prairie Middle School	Regular School	No	Middle	07	08	2017	grade_6	0.0	0
1695166	OR	school	4102640	1929	Canby SD 86	410264000148	140	Canby High School	Regular School	No	High	09	12	2017	grade_6	0.0	0
1695167	OR	school	4102640	1929	Canby SD 86		1929	Canby SD 86						2017	grade_6	6.0	6
1695168	OR	school	4102640	1929	Canby SD 86	410264000100	92	Carus School	Regular School	No	Elementary	KG	06	2017	grade_6	52.0	52
1695169	OR	school	4102640	1929	Canby SD 86	410264000165	1307	Cecile Trost Elementary School	Regular School	No	Elementary	KG	06	2017	grade_6	56.0	56
1695170	OR	school	4102640	1929	Canby SD 86	410264000132	124	Howard Eccles Elementary School	Regular School	No	Elementary	KG	06	2017	grade_6	85.0	85
1695171	OR	school	4102640	1929	Canby SD 86	410264000135	127	Ninety-One School	Regular School	No	Elementary	KG	08	2017	grade_6	51.0	51
1695172	OR	school	4102640	1929	Canby SD 86	410264001659	4435	Philander Lee Elementary School	Regular School	No	Elementary	KG	06	2017	grade_6	58.0	58
1695173	OR	school	4102640	1929	Canby SD 86	410264000130	122	William Knight Elementary School	Regular School	No	Elementary	KG	06	2017	grade_6	57.0	57
1695174	OR	school	4102780	2139	Cascade SD 5	410278000767	719	Aumsville Elementary School	Regular School	No	Elementary	KG	05	2017	grade_6	0.0	0
1695175	OR	school	4102780	2139	Cascade SD 5	410278000855	810	Cascade Junior High School	Regular School	No	Middle	06	08	2017	grade_6	179.0	179
1695176	OR	school	4102780	2139	Cascade SD 5	410278000856	811	Cascade Senior High School	Regular School	No	High	09	12	2017	grade_6	0.0	0
1695177	OR	school	4102780	2139	Cascade SD 5	410278000851	806	Cloverdale Elementary School	Regular School	No	Elementary	KG	05	2017	grade_6	0.0	0
1695178	OR	school	4102780	2139	Cascade SD 5	410278000835	790	Turner Elementary School	Regular School	No	Elementary	KG	05	2017	grade_6	0.0	0
1695179	OR	school	4102800	2185	Centennial SD 28J	410280001574	3649	Butler Creek Elementary School	Regular School	No	Elementary	KG	06	2017	grade_6	89.0	89
1695180	OR	school	4102800	2185	Centennial SD 28J	410280001020	967	Centennial High School	Regular School	No	High	09	12	2017	grade_6	0.0	0
1695181	OR	school	4102800	2185	Centennial SD 28J	410280001013	960	Centennial Middle School	Regular School	No	Middle	07	08	2017	grade_6	0.0	0
1695182	OR	school	4102800	2185	Centennial SD 28J	410280001221	1367	Centennial Park School	Alternative School	No	High	07	12	2017	grade_6	0.0	0
1695183	OR	school	4102800	2185	Centennial SD 28J		2185	Centennial SD 28J						2017	grade_6	8.0	8
1695184	OR	school	4102800	2185	Centennial SD 28J	410280001012	959	Lynch Meadows Elementary School	Regular School	No	Elementary	KG	06	2017	grade_6	69.0	69
1695185	OR	school	4102800	2185	Centennial SD 28J	410280001017	964	Lynch View Elementary School	Regular School	No	Elementary	KG	06	2017	grade_6	66.0	66
1695186	OR	school	4102800	2185	Centennial SD 28J	410280001018	965	Lynch Wood Elementary School	Regular School	No	Elementary	KG	06	2017	grade_6	71.0	71
1695187	OR	school	4102800	2185	Centennial SD 28J		2504	Mt Hood Community College						2017	grade_6	0.0	0
1695188	OR	school	4102800	2185	Centennial SD 28J	410280001015	962	Oliver Elementary School	Regular School	No	Elementary	KG	06	2017	grade_6	56.0	56
1695189	OR	school	4102800	2185	Centennial SD 28J		5268	Open School East						2017	grade_6	0.0	0
1695190	OR	school	4102800	2185	Centennial SD 28J	410280001016	963	Parklane Elementary School	Regular School	No	Elementary	KG	06	2017	grade_6	50.0	50
1695191	OR	school	4102800	2185	Centennial SD 28J	410280001019	966	Pleasant Valley Elementary School	Regular School	No	Elementary	KG	06	2017	grade_6	55.0	55
1695192	OR	school	4102800	2185	Centennial SD 28J		1885	Portland Youth Builders						2017	grade_6	0.0	0
1695193	OR	school	4102800	2185	Centennial SD 28J		1671	Serendipity						2017	grade_6	1.0	1
1695194	OR	school	4105760	1972	Central Curry SD 1	410576000257	239	Gold Beach High School	Regular School	No	High	09	12	2017	grade_6	0.0	0
1695195	OR	school	4105760	1972	Central Curry SD 1	410576000249	231	Riley Creek Elementary School	Regular School	No	Elementary	KG	08	2017	grade_6	33.0	33
1695196	OR	school	4102910	2105	Central Linn SD 552	410291000475	1311	Central Linn Elementary School	Regular School	No	Elementary	KG	06	2017	grade_6	56.0	56
1695197	OR	school	4102910	2105	Central Linn SD 552	410291000729	687	Central Linn High School	Regular School	No	High	07	12	2017	grade_6	0.0	0
1695198	OR	school	4102940	2042	Central Point SD 6	410294000402	382	Central Point Elementary School	Regular School	No	Elementary	KG	05	2017	grade_6	0.0	0