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_state_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
1181748	OR	school	4101710	1894	Baker SD 5J	410171001783	4759	Baker Early College	Regular School	Yes	High	09	12	2018	grade_7	0.0	0
1181749	OR	school	4101710	1894	Baker SD 5J	410171000009	8	Baker High School	Regular School	No	High	09	12	2018	grade_7	0.0	0
1181750	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2018	grade_7	131.0	131
1181751	OR	school	4101710	1894	Baker SD 5J		1894	Baker SD 5J						2018	grade_7	0.0	0
1181752	OR	school	4101710	1894	Baker SD 5J	410171001767	4728	Baker Web Academy	Regular School	Yes	Other	KG	12	2018	grade_7	129.0	129
1181753	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2018	grade_7	0.0	0
1181754	OR	school	4101710	1894	Baker SD 5J	410171001516	3493	EAGLE CAP Innovative HS	Alternative School	No	High	09	12	2018	grade_7	0.0	0
1181755	OR	school	4101710	1894	Baker SD 5J	410171000030	4	Haines Elementary School	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0
1181756	OR	school	4101710	1894	Baker SD 5J	410171000034	5	Keating Elementary School	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0
1181757	OR	school	4101710	1894	Baker SD 5J	410171000007	7	South Baker Intermediate School	Regular School	No	Middle	04	06	2018	grade_7	0.0	0
1182291	OR	school	4106600	1895	Huntington SD 16J	410660000011	3351	Huntington School	Regular School	Yes	Other	KG	12	2018	grade_7	6.0	6
1181885	OR	school	4101740	1896	Burnt River SD 30J	410174000013	3347	Burnt River School	Regular School	Yes	Other	KG	12	2018	grade_7	1.0	1
1182691	OR	school	4109720	1897	Pine Eagle SD 61	410972000016	15	Pine Eagle Charter School	Regular School	Yes	Other	KG	12	2018	grade_7	9.0	9
1182476	OR	school	4108430	1898	Monroe SD 1J	410843000027	1321	Monroe Grade School	Regular School	No	Elementary	KG	08	2018	grade_7	34.0	34
1182477	OR	school	4108430	1898	Monroe SD 1J	410843000050	43	Monroe High School	Regular School	No	High	09	12	2018	grade_7	0.0	0
1181722	OR	school	4101200	1899	Alsea SD 7J	410120000019	17	Alsea Charter School	Regular School	Yes	Other	KG	12	2018	grade_7	11.0	11
1181723	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Not Reported	M	M	2018	grade_7	0.0	0
1182675	OR	school	4109600	1900	Philomath SD 17J	410960000020	18	Blodgett Elementary School	Regular School	No	Elementary	KG	04	2018	grade_7	0.0	0
1182676	OR	school	4109600	1900	Philomath SD 17J	410960001481	3162	Clemens Primary School	Regular School	No	Elementary	KG	01	2018	grade_7	0.0	0
1182677	OR	school	4109600	1900	Philomath SD 17J	410960000021	3440	Kings Valley Charter School	Regular School	Yes	Other	KG	12	2018	grade_7	12.0	12
1182678	OR	school	4109600	1900	Philomath SD 17J	410960000022	20	Philomath Elementary School	Regular School	No	Elementary	02	05	2018	grade_7	0.0	0
1182679	OR	school	4109600	1900	Philomath SD 17J	410960000024	22	Philomath High School	Regular School	No	High	09	12	2018	grade_7	0.0	0
1182680	OR	school	4109600	1900	Philomath SD 17J	410960000023	21	Philomath Middle School	Regular School	No	Middle	06	08	2018	grade_7	119.0	119
1181963	OR	school	4103480	1901	Corvallis SD 509J	410348000032	27	Adams Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1181964	OR	school	4103480	1901	Corvallis SD 509J	410348000033	28	Cheldelin Middle School	Regular School	No	Middle	06	08	2018	grade_7	182.0	182
1181965	OR	school	4103480	1901	Corvallis SD 509J	410348000047	40	Corvallis High School	Regular School	No	High	09	12	2018	grade_7	0.0	0
1181966	OR	school	4103480	1901	Corvallis SD 509J		1901	Corvallis SD 509J						2018	grade_7	9.0	9
1181967	OR	school	4103480	1901	Corvallis SD 509J	410348000048	41	Crescent Valley High School	Regular School	No	High	09	12	2018	grade_7	0.0	0
1181968	OR	school	4103480	1901	Corvallis SD 509J	410348000570	1322	Franklin School	Alternative School	No	Elementary	KG	08	2018	grade_7	57.0	57
1181969	OR	school	4103480	1901	Corvallis SD 509J	410348000037	30	Garfield Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1181970	OR	school	4103480	1901	Corvallis SD 509J	410348000040	33	Hoover Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1181971	OR	school	4103480	1901	Corvallis SD 509J	410348001743	4637	Inavale Community Partners dba Muddy Creek Charter School	Regular School	Yes	Elementary	KG	05	2018	grade_7	0.0	0
1181972	OR	school	4103480	1901	Corvallis SD 509J	410348000042	35	Jefferson Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1181973	OR	school	4103480	1901	Corvallis SD 509J	410348000043	36	Lincoln Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1181974	OR	school	4103480	1901	Corvallis SD 509J	410348000045	38	Linus Pauling Middle School	Regular School	No	Middle	06	08	2018	grade_7	245.0	245
1181975	OR	school	4103480	1901	Corvallis SD 509J	410348000044	37	Mt View Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1181976	OR	school	4103480	1901	Corvallis SD 509J	410348000046	39	Wilson Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1181977	OR	school	4103480	1901	Corvallis SD 509J		1874	YES House Alternative School						2018	grade_7	1.0	1
1181938	OR	school		1902	Clackamas ESD		1902	Clackamas ESD						2018	grade_7	20.0	20
1183130	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001786	4773	Arts and Technology High School	Alternative School	No	High	09	12	2018	grade_7	0.0	0
1183131	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317000056	1287	Athey Creek Middle School	Regular School	No	Middle	06	08	2018	grade_7	217.0	217
1183132	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001356	1272	Boeckman Creek Primary School	Regular School	No	Elementary	PK	05	2018	grade_7	0.0	0
1183133	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001447	3455	Bolton Primary School	Regular School	No	Elementary	PK	05	2018	grade_7	0.0	0
1183134	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001575	3913	Boones Ferry Primary School	Regular School	No	Elementary	PK	05	2018	grade_7	0.0	0
1183135	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317000053	45	Cedaroak Park Primary School	Regular School	No	Elementary	PK	05	2018	grade_7	0.0	0
1183136	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001318	46	Inza R Wood Middle School	Regular School	No	Middle	06	08	2018	grade_7	177.0	177
1183137	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001822	5056	Lowrie Primary School	Regular School	No	Elementary	PK	05	2018	grade_7	0.0	0
1183138	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001851	5377	Meridian Creek Middle School	Regular School	No	Middle	06	08	2018	grade_7	108.0	108
1183139	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001414	2787	Rosemont Ridge Middle School	Regular School	No	Middle	06	08	2018	grade_7	273.0	273
1183140	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317000054	47	Stafford Primary School	Regular School	No	Elementary	PK	05	2018	grade_7	0.0	0
1183141	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317000055	48	Sunset Primary School	Regular School	No	Elementary	PK	05	2018	grade_7	0.0	0
1183142	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001437	3452	Three Rivers Charter School	Regular School	Yes	Middle	04	08	2018	grade_7	21.0	21
1183143	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001825	5057	Trillium Creek Primary School	Regular School	No	Elementary	PK	05	2018	grade_7	0.0	0
1183144	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317000058	51	West Linn High School	Regular School	No	High	09	12	2018	grade_7	0.0	0
1183145	OR	school	4113170	1922	West Linn-Wilsonville SD 3J		1922	West Linn-Wilsonville SD 3J						2018	grade_7	0.0	0
1183146	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317001377	1286	Willamette Primary School	Regular School	No	Elementary	PK	05	2018	grade_7	0.0	0
1183147	OR	school	4113170	1922	West Linn-Wilsonville SD 3J	411317000574	1323	Wilsonville High School	Regular School	No	High	09	12	2018	grade_7	0.0	0
1182367	OR	school	4107230	1923	Lake Oswego SD 7J	410723000060	53	Forest Hills Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182368	OR	school	4107230	1923	Lake Oswego SD 7J	410723001308	54	Hallinan Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182369	OR	school	4107230	1923	Lake Oswego SD 7J	410723000061	55	Lake Grove Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182370	OR	school	4107230	1923	Lake Oswego SD 7J	410723000066	59	Lake Oswego Middle School	Regular School	No	Middle	06	08	2018	grade_7	301.0	301
1182371	OR	school	4107230	1923	Lake Oswego SD 7J		1923	Lake Oswego SD 7J						2018	grade_7	2.0	2
1182372	OR	school	4107230	1923	Lake Oswego SD 7J	410723000068	61	Lake Oswego Senior High School	Regular School	No	High	09	12	2018	grade_7	0.0	0
1182373	OR	school	4107230	1923	Lake Oswego SD 7J	410723000069	62	Lakeridge High School	Regular School	No	High	09	12	2018	grade_7	0.0	0
1182374	OR	school	4107230	1923	Lake Oswego SD 7J	410723000067	60	Lakeridge Middle School	Regular School	No	Middle	06	08	2018	grade_7	284.0	284
1182375	OR	school	4107230	1923	Lake Oswego SD 7J	410723001378	1288	Oak Creek Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182376	OR	school	4107230	1923	Lake Oswego SD 7J	410723000064	56	River Grove Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182377	OR	school	4107230	1923	Lake Oswego SD 7J	410723001307	58	Westridge Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182525	OR	school	4108830	1924	North Clackamas SD 12	410883004189	3530	Alder Creek Middle School	Regular School	No	Middle	06	08	2018	grade_7	333.0	333
1182526	OR	school	4108830	1924	North Clackamas SD 12	410883000070	4762	Ardenwald Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182527	OR	school	4108830	1924	North Clackamas SD 12	410883000072	65	Bilquist Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182528	OR	school	4108830	1924	North Clackamas SD 12	410883001658	4475	Cascade Heights Public Charter School	Regular School	Yes	Elementary	KG	08	2018	grade_7	23.0	23
1182529	OR	school	4108830	1924	North Clackamas SD 12	410883000093	85	Clackamas High School	Regular School	No	High	09	12	2018	grade_7	0.0	0
1182530	OR	school	4108830	1924	North Clackamas SD 12	410883001544	4226	Clackamas Middle College	Regular School	Yes	High	09	12	2018	grade_7	0.0	0
1182531	OR	school	4108830	1924	North Clackamas SD 12	410883001543	4223	Clackamas Web Academy	Regular School	Yes	Other	01	12	2018	grade_7	27.0	27
1182532	OR	school	4108830	1924	North Clackamas SD 12	410883001584	4005	El Puente	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182533	OR	school	4108830	1924	North Clackamas SD 12	410883000076	4763	Happy Valley Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182534	OR	school	4108830	1924	North Clackamas SD 12	410883001782	4715	Happy Valley Middle School	Regular School	No	Middle	06	08	2018	grade_7	346.0	346
1182535	OR	school	4108830	1924	North Clackamas SD 12	410883000085	4764	Lewelling Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182536	OR	school	4108830	1924	North Clackamas SD 12	410883000079	4765	Linwood Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182537	OR	school	4108830	1924	North Clackamas SD 12	410883001686	4369	Milwaukie Academy of the Arts	Regular School	Yes	High	09	12	2018	grade_7	0.0	0
1182538	OR	school	4108830	1924	North Clackamas SD 12	410883000081	73	Milwaukie Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182539	OR	school	4108830	1924	North Clackamas SD 12	410883000094	86	Milwaukie High School	Regular School	No	High	09	12	2018	grade_7	0.0	0
1182540	OR	school	4108830	1924	North Clackamas SD 12	410883001354	1264	Mount Scott Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182541	OR	school	4108830	1924	North Clackamas SD 12	410883001583	4004	New Urban High School	Regular School	No	High	09	12	2018	grade_7	0.0	0
1182542	OR	school	4108830	1924	North Clackamas SD 12		1924	North Clackamas SD 12						2018	grade_7	3.0	3
1182543	OR	school	4108830	1924	North Clackamas SD 12	410883001484	3342	Oak Grove Elementary	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182544	OR	school	4108830	1924	North Clackamas SD 12	410883000008	4766	Oregon Trail Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182545	OR	school	4108830	1924	North Clackamas SD 12	410883000095	87	Putnam High School	Regular School	No	High	09	12	2018	grade_7	0.0	0
1182546	OR	school	4108830	1924	North Clackamas SD 12	410883000084	76	Riverside Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182547	OR	school	4108830	1924	North Clackamas SD 12	410883001379	4767	Rock Creek Middle School	Regular School	No	Middle	06	08	2018	grade_7	300.0	300
1182548	OR	school	4108830	1924	North Clackamas SD 12	410883000092	84	Rowe Middle School	Regular School	No	Middle	06	08	2018	grade_7	255.0	255
1182549	OR	school	4108830	1924	North Clackamas SD 12	410883001775	4713	Scouters Mountain Elementary	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182550	OR	school	4108830	1924	North Clackamas SD 12	410883001317	2733	Sojourner School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182551	OR	school	4108830	1924	North Clackamas SD 12	410883001483	3198	Spring Mountain Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182552	OR	school	4108830	1924	North Clackamas SD 12	410883000086	78	Sunnyside Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182553	OR	school	4108830	1924	North Clackamas SD 12	410883001777	4714	Verne A Duncan Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182554	OR	school	4108830	1924	North Clackamas SD 12	410883000087	79	View Acres Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182555	OR	school	4108830	1924	North Clackamas SD 12	410883000080	72	Whitcomb Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182467	OR	school	4108310	1925	Molalla River SD 35	410831000101	93	Clarkes Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0
1182468	OR	school	4108310	1925	Molalla River SD 35	410831001325	94	Molalla Elementary School	Regular School	No	Elementary	KG	05	2018	grade_7	0.0	0