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 (ccd_school_type > :p4 or (ccd_school_type = :p4 and rowid > :p3)) order by ccd_school_type, rowid limit 101

Query parameters

This data as json, CSV

rowid	state	admin_level	district_nces_id	district_state_id	district	school_state_id	school	year	grade	total	total_int
1694211	OR	school	4107500	2097	Lincoln County SD	614	Olalla Center for Children & Families	2017	grade_5	1.0	1
1694224	OR	school		2098	Linn Benton Lincoln ESD	42	Childrens Farm Home	2017	grade_5	0.0	0
1694225	OR	school		2098	Linn Benton Lincoln ESD	1271	Old Mill Center for Children & Families	2017	grade_5	0.0	0
1694226	OR	school		2098	Linn Benton Lincoln ESD	5160	Wake Robin School	2017	grade_5	0.0	0
1694229	OR	school	4107590	2092	Lowell SD 71	1792	Jasper Mountain Center	2017	grade_5	0.0	0
1694231	OR	school	4107590	2092	Lowell SD 71	2092	Lowell SD 71	2017	grade_5	0.0	0
1694234	OR	school		2112	Malheur County SD 51	2112	Malheur County SD 51	2017	grade_5	0.0	0
1694235	OR	school		2106	Malheur ESD Region 14	2106	Malheur ESD Region 14	2017	grade_5	0.0	0
1694246	OR	school	4108010	2256	McMinnville SD 40	2256	McMinnville SD 40	2017	grade_5	0.0	0
1694267	OR	school	4108040	2048	Medford SD 549C	2048	Medford SD 549C	2017	grade_5	32.0	32
1694288	OR	school	4108310	1925	Molalla River SD 35	1925	Molalla River SD 35	2017	grade_5	0.0	0
1694300	OR	school	4108520	2147	Morrow SD 1	2147	Morrow SD 1	2017	grade_5	0.0	0
1694308	OR	school	4180180	2148	Multnomah ESD	4203	Doernbecher Childrens Hospital (educational program)	2017	grade_5	1.0	1
1694310	OR	school	4180180	2148	Multnomah ESD	953	Kerr Youth Center/Wynne Watts School	2017	grade_5	1.0	1
1694311	OR	school	4180180	2148	Multnomah ESD	1800	Legacy Emanuel Hospital (educational program)	2017	grade_5	1.0	1
1694312	OR	school	4180180	2148	Multnomah ESD	1648	Morrison Center Counterpoint Program	2017	grade_5	0.0	0
1694313	OR	school	4180180	2148	Multnomah ESD	2148	Multnomah ESD	2017	grade_5	6.0	6
1694314	OR	school	4180180	2148	Multnomah ESD	1806	Shriners Hospital (educational program)	2017	grade_5	0.0	0
1694323	OR	school	4108700	2199	Nestucca Valley SD 101J	2199	Nestucca Valley SD 101J	2017	grade_5	0.0	0
1694333	OR	school	4108720	2254	Newberg SD 29J	3369	Sitka Academy	2017	grade_5	0.0	0
1694335	OR	school	4108820	1966	North Bend SD 13	4603	Kairos - Coastline	2017	grade_5	0.0	0
1694336	OR	school	4108820	1966	North Bend SD 13	3615	Lighthouse Charter School	2017	grade_5	0.0	0
1694339	OR	school	4108820	1966	North Bend SD 13	1966	North Bend SD 13	2017	grade_5	0.0	0
1694360	OR	school	4108830	1924	North Clackamas SD 12	1924	North Clackamas SD 12	2017	grade_5	3.0	3
1694390	OR	school	4100048	4131	North Wasco County SD 21	1262	Mid-Columbia Alternative School Based Treatment Center (MAST)	2017	grade_5	0.0	0
1694393	OR	school	4100048	4131	North Wasco County SD 21	4131	North Wasco County SD 21	2017	grade_5	3.0	3
1694397	OR	school		2230	Northwest Regional ESD	1167	Levi Anderson Learning Center	2017	grade_5	0.0	0
1694398	OR	school		2230	Northwest Regional ESD	1284	Lifeworks Northwest	2017	grade_5	1.0	1
1694399	OR	school		2230	Northwest Regional ESD	2230	Northwest Regional ESD	2017	grade_5	1.0	1
1694403	OR	school	4109000	2110	Nyssa SD 26	2110	Nyssa SD 26	2017	grade_5	0.0	0
1694410	OR	school		3476	ODE JDEP District	2831	COIC Skill Lab	2017	grade_5	0.0	0
1694411	OR	school		3476	ODE JDEP District	2848	Donald E Long School	2017	grade_5	0.0	0
1694412	OR	school		3476	ODE JDEP District	2836	Jackson County Juvenile	2017	grade_5	0.0	0
1694413	OR	school		3476	ODE JDEP District	2839	Klamath County Juvenile	2017	grade_5	0.0	0
1694414	OR	school		3476	ODE JDEP District	2841	Lane County Dept of Youth	2017	grade_5	0.0	0
1694415	OR	school		3476	ODE JDEP District	2842	Lincoln County Juvenile	2017	grade_5	0.0	0
1694416	OR	school		3476	ODE JDEP District	2843	Linn County Juvenile Detention	2017	grade_5	0.0	0
1694417	OR	school		3476	ODE JDEP District	2846	Marion County Juvenile Detention	2017	grade_5	0.0	0
1694418	OR	school		3476	ODE JDEP District	2832	Mt Nebo Alt Ed	2017	grade_5	0.0	0
1694419	OR	school		3476	ODE JDEP District	3129	NORCOR Education Detention Center	2017	grade_5	0.0	0
1694420	OR	school		3476	ODE JDEP District	2858	Yamhill County Juvenile	2017	grade_5	0.0	0
1694421	OR	school		5334	ODE ORR	5334	ODE ORR	2017	grade_5	0.0	0
1694438	OR	school	4109270	2108	Ontario SD 8C	2108	Ontario SD 8C	2017	grade_5	0.0	0
1694450	OR	school	4109330	1928	Oregon City SD 62	1928	Oregon City SD 62	2017	grade_5	0.0	0
1694453	OR	school	4109330	1928	Oregon City SD 62	4522	Park Academy	2017	grade_5	0.0	0
1694455	OR	school	4109330	1928	Oregon City SD 62	1671	Serendipity	2017	grade_5	0.0	0
1694457	OR	school	4109330	1928	Oregon City SD 62	1684	Tucker-Maxon Oral School	2017	grade_5	1.0	1
1694469	OR	school	4110890	1926	Oregon Trail SD 46	1926	Oregon Trail SD 46	2017	grade_5	8.0	8
1694477	OR	school	4109480	2181	Parkrose SD 3	2181	Parkrose SD 3	2017	grade_5	2.0	2
1694483	OR	school	4109510	2207	Pendleton SD 16	2270	Homestead Youth & Family Services	2017	grade_5	0.0	0
1694504	OR	school	4109630	2039	Phoenix-Talent SD 4	2039	Phoenix-Talent SD 4	2017	grade_5	0.0	0
1694512	OR	school	4109870	2081	Pleasant Hill SD 1	1792	Jasper Mountain Center	2017	grade_5	0.0	0
1694515	OR	school	4109870	2081	Pleasant Hill SD 1	2081	Pleasant Hill SD 1	2017	grade_5	0.0	0
1694531	OR	school	4110040	2180	Portland SD 1J	907	Boys & Girls Aid Society/Johns Landing School	2017	grade_5	0.0	0
1694543	OR	school	4110040	2180	Portland SD 1J	1628	De Paul Treatment Centers Inc	2017	grade_5	0.0	0
1694560	OR	school	4110040	2180	Portland SD 1J	908	Janus Youth Programs	2017	grade_5	0.0	0
1694578	OR	school	4110040	2180	Portland SD 1J	2275	Morrison Child & Family Services, Breakthrough	2017	grade_5	0.0	0
1694579	OR	school	4110040	2180	Portland SD 1J	1279	Morrison Child & Family Services, Hand In Hand	2017	grade_5	0.0	0
1694580	OR	school	4110040	2180	Portland SD 1J	1803	Mt Scott Park Center for Learning	2017	grade_5	0.0	0
1694582	OR	school	4110040	2180	Portland SD 1J	4587	NAYA Early College Academy	2017	grade_5	0.0	0
1694583	OR	school	4110040	2180	Portland SD 1J	3012	New Avenues for Youth	2017	grade_5	0.0	0
1694584	OR	school	4110040	2180	Portland SD 1J	1281	Nickerson Center ADTP	2017	grade_5	0.0	0
1694587	OR	school	4110040	2180	Portland SD 1J	3021	Open School North	2017	grade_5	0.0	0
1694588	OR	school	4110040	2180	Portland SD 1J	4508	Outside In-Urban Ed	2017	grade_5	0.0	0
1694589	OR	school	4110040	2180	Portland SD 1J	880	Parry Center for Children	2017	grade_5	9.0	9
1694590	OR	school	4110040	2180	Portland SD 1J	3584	Parry Center SCIP	2017	grade_5	3.0	3
1694593	OR	school	4110040	2180	Portland SD 1J	2506	Portland Community College	2017	grade_5	0.0	0
1694594	OR	school	4110040	2180	Portland SD 1J	2180	Portland SD 1J	2017	grade_5	71.0	71
1694596	OR	school	4110040	2180	Portland SD 1J	1885	Portland Youth Builders	2017	grade_5	0.0	0
1694602	OR	school	4110040	2180	Portland SD 1J	1669	Rosemary Anderson High School	2017	grade_5	0.0	0
1694605	OR	school	4110040	2180	Portland SD 1J	5305	SAGE Youth Residential Program	2017	grade_5	0.0	0
1694607	OR	school	4110040	2180	Portland SD 1J	4477	SE Works Youth Center	2017	grade_5	0.0	0
1694618	OR	school	4110040	2180	Portland SD 1J	921	White Shield Home	2017	grade_5	0.0	0
1694620	OR	school	4110040	2180	Portland SD 1J	4405	Wildflowers	2017	grade_5	0.0	0
1694626	OR	school	4110040	2180	Portland SD 1J	1835	Youth Progress Learning Center	2017	grade_5	0.0	0
1694638	OR	school	4110350	1977	Redmond SD 2J	1841	Redmond COIC Dropout Re-engagement Program	2017	grade_5	0.0	0
1694642	OR	school	4110350	1977	Redmond SD 2J	1977	Redmond SD 2J	2017	grade_5	1.0	1
1694664	OR	school	4110520	2182	Reynolds SD 7	2182	Reynolds SD 7	2017	grade_5	10.0	10
1694683	OR	school	4110820	2142	Salem-Keizer SD 24J	3582	Catholic Community Services	2017	grade_5	0.0	0
1694727	OR	school	4110820	2142	Salem-Keizer SD 24J	2142	Salem-Keizer SD 24J	2017	grade_5	0.0	0
1694753	OR	school	4110980	1944	Scappoose SD 1J	1944	Scappoose SD 1J	2017	grade_5	0.0	0
1694780	OR	school	4111290	2244	Sherwood SD 88J	2244	Sherwood SD 88J	2017	grade_5	0.0	0
1694804	OR	school	4111580	2087	South Lane SD 45J3	4717	Bridgeway House	2017	grade_5	0.0	0
1694805	OR	school	4111580	2087	South Lane SD 45J3	2418	Childs Way Alternative School	2017	grade_5	0.0	0
1694810	OR	school	4111580	2087	South Lane SD 45J3	1792	Jasper Mountain Center	2017	grade_5	1.0	1
1694814	OR	school	4111580	2087	South Lane SD 45J3	1532	Looking Glass Riverfront School & Career Center	2017	grade_5	0.0	0
1694815	OR	school	4111580	2087	South Lane SD 45J3	1861	Northwest Youth Corps	2017	grade_5	0.0	0
1694816	OR	school	4111580	2087	South Lane SD 45J3	2087	South Lane SD 45J3	2017	grade_5	0.0	0
1694824	OR	school		2025	Southern Oregon ESD	1481	Community Works/Lithia Springs School	2017	grade_5	0.0	0
1694825	OR	school		2025	Southern Oregon ESD	2434	Family Solutions - Ashland	2017	grade_5	0.0	0
1694826	OR	school		2025	Southern Oregon ESD	3652	Family Solutions - Central Point	2017	grade_5	0.0	0
1694827	OR	school		2025	Southern Oregon ESD	1275	Family Solutions - Grants Pass	2017	grade_5	0.0	0
1694828	OR	school		2025	Southern Oregon ESD	3653	Family Solutions - Medford	2017	grade_5	0.0	0
1694829	OR	school		2025	Southern Oregon ESD	2025	Southern Oregon ESD	2017	grade_5	8.0	8
1694833	OR	school	4111670	2083	Springfield SD 19	4717	Bridgeway House	2017	grade_5	3.0	3
1694841	OR	school	4111670	2083	Springfield SD 19	1792	Jasper Mountain Center	2017	grade_5	4.0	4
1694842	OR	school	4111670	2083	Springfield SD 19	3545	Looking Glass Center Point School	2017	grade_5	0.0	0
1694843	OR	school	4111670	2083	Springfield SD 19	1532	Looking Glass Riverfront School & Career Center	2017	grade_5	0.0	0
1694848	OR	school	4111670	2083	Springfield SD 19	1789	SAFE Center School	2017	grade_5	4.0	4
1694850	OR	school	4111670	2083	Springfield SD 19	2083	Springfield SD 19	2017	grade_5	1.0	1
1694851	OR	school	4111670	2083	Springfield SD 19	1252	The Child Center	2017	grade_5	6.0	6