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 "state" = :p0 and "year" = :p1 order by ccd_school_high_grade 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	white	black	hispanic	native_american_alaskan_native	asian	native_hawaiian_pacific_islander	multiracial	total	white_int	black_int	hispanic_int	native_american_alaskan_native_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int	total_int
1171510	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Not Reported	M	M	2018	kindergarten								0.0								0
1172148	OR	school	4107200	2212	La Grande SD 1	410720001768	1071	Willow Elementary School	Regular School	No	Not Reported	M	M	2018	kindergarten								0.0								0
1172396	OR	school	4100043	3477	ODE YCEP District	410004300490	1827	Robert S Farrell High School	Regular School	No	Not Reported	M	M	2018	kindergarten								0.0								0
1172574	OR	school	4110040	2180	Portland SD 1J	411004001537	4212	Self Enhancement, Inc/SEI Academy	Regular School	Yes	Not Reported	M	M	2018	kindergarten								0.0								0
1172969	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Not Reported	M	M	2018	grade_1								0.0								0
1173607	OR	school	4107200	2212	La Grande SD 1	410720001768	1071	Willow Elementary School	Regular School	No	Not Reported	M	M	2018	grade_1								0.0								0
1173855	OR	school	4100043	3477	ODE YCEP District	410004300490	1827	Robert S Farrell High School	Regular School	No	Not Reported	M	M	2018	grade_1								0.0								0
1174033	OR	school	4110040	2180	Portland SD 1J	411004001537	4212	Self Enhancement, Inc/SEI Academy	Regular School	Yes	Not Reported	M	M	2018	grade_1								0.0								0
1174428	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Not Reported	M	M	2018	grade_2								0.0								0
1175066	OR	school	4107200	2212	La Grande SD 1	410720001768	1071	Willow Elementary School	Regular School	No	Not Reported	M	M	2018	grade_2								0.0								0
1175314	OR	school	4100043	3477	ODE YCEP District	410004300490	1827	Robert S Farrell High School	Regular School	No	Not Reported	M	M	2018	grade_2								0.0								0
1175492	OR	school	4110040	2180	Portland SD 1J	411004001537	4212	Self Enhancement, Inc/SEI Academy	Regular School	Yes	Not Reported	M	M	2018	grade_2								0.0								0
1175887	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Not Reported	M	M	2018	grade_3								0.0								0
1176525	OR	school	4107200	2212	La Grande SD 1	410720001768	1071	Willow Elementary School	Regular School	No	Not Reported	M	M	2018	grade_3								0.0								0
1176773	OR	school	4100043	3477	ODE YCEP District	410004300490	1827	Robert S Farrell High School	Regular School	No	Not Reported	M	M	2018	grade_3								0.0								0
1176951	OR	school	4110040	2180	Portland SD 1J	411004001537	4212	Self Enhancement, Inc/SEI Academy	Regular School	Yes	Not Reported	M	M	2018	grade_3								0.0								0
1177346	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Not Reported	M	M	2018	grade_4								0.0								0
1177984	OR	school	4107200	2212	La Grande SD 1	410720001768	1071	Willow Elementary School	Regular School	No	Not Reported	M	M	2018	grade_4								0.0								0
1178232	OR	school	4100043	3477	ODE YCEP District	410004300490	1827	Robert S Farrell High School	Regular School	No	Not Reported	M	M	2018	grade_4								0.0								0
1178410	OR	school	4110040	2180	Portland SD 1J	411004001537	4212	Self Enhancement, Inc/SEI Academy	Regular School	Yes	Not Reported	M	M	2018	grade_4								0.0								0
1178805	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Not Reported	M	M	2018	grade_5								0.0								0
1179443	OR	school	4107200	2212	La Grande SD 1	410720001768	1071	Willow Elementary School	Regular School	No	Not Reported	M	M	2018	grade_5								0.0								0
1179691	OR	school	4100043	3477	ODE YCEP District	410004300490	1827	Robert S Farrell High School	Regular School	No	Not Reported	M	M	2018	grade_5								0.0								0
1179869	OR	school	4110040	2180	Portland SD 1J	411004001537	4212	Self Enhancement, Inc/SEI Academy	Regular School	Yes	Not Reported	M	M	2018	grade_5								0.0								0
1180264	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Not Reported	M	M	2018	grade_6								0.0								0
1180902	OR	school	4107200	2212	La Grande SD 1	410720001768	1071	Willow Elementary School	Regular School	No	Not Reported	M	M	2018	grade_6								0.0								0
1181150	OR	school	4100043	3477	ODE YCEP District	410004300490	1827	Robert S Farrell High School	Regular School	No	Not Reported	M	M	2018	grade_6								0.0								0
1181328	OR	school	4110040	2180	Portland SD 1J	411004001537	4212	Self Enhancement, Inc/SEI Academy	Regular School	Yes	Not Reported	M	M	2018	grade_6								0.0								0
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
1182361	OR	school	4107200	2212	La Grande SD 1	410720001768	1071	Willow Elementary School	Regular School	No	Not Reported	M	M	2018	grade_7								0.0								0
1182609	OR	school	4100043	3477	ODE YCEP District	410004300490	1827	Robert S Farrell High School	Regular School	No	Not Reported	M	M	2018	grade_7								0.0								0
1182787	OR	school	4110040	2180	Portland SD 1J	411004001537	4212	Self Enhancement, Inc/SEI Academy	Regular School	Yes	Not Reported	M	M	2018	grade_7								0.0								0
1183182	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Not Reported	M	M	2018	grade_8								0.0								0
1183820	OR	school	4107200	2212	La Grande SD 1	410720001768	1071	Willow Elementary School	Regular School	No	Not Reported	M	M	2018	grade_8								0.0								0
1184068	OR	school	4100043	3477	ODE YCEP District	410004300490	1827	Robert S Farrell High School	Regular School	No	Not Reported	M	M	2018	grade_8								0.0								0
1184246	OR	school	4110040	2180	Portland SD 1J	411004001537	4212	Self Enhancement, Inc/SEI Academy	Regular School	Yes	Not Reported	M	M	2018	grade_8								0.0								0
1184641	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Not Reported	M	M	2018	grade_9								0.0								0
1185279	OR	school	4107200	2212	La Grande SD 1	410720001768	1071	Willow Elementary School	Regular School	No	Not Reported	M	M	2018	grade_9								0.0								0
1185527	OR	school	4100043	3477	ODE YCEP District	410004300490	1827	Robert S Farrell High School	Regular School	No	Not Reported	M	M	2018	grade_9								0.0								0
1185705	OR	school	4110040	2180	Portland SD 1J	411004001537	4212	Self Enhancement, Inc/SEI Academy	Regular School	Yes	Not Reported	M	M	2018	grade_9								0.0								0
1186100	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Not Reported	M	M	2018	grade_10								0.0								0
1186738	OR	school	4107200	2212	La Grande SD 1	410720001768	1071	Willow Elementary School	Regular School	No	Not Reported	M	M	2018	grade_10								0.0								0
1186986	OR	school	4100043	3477	ODE YCEP District	410004300490	1827	Robert S Farrell High School	Regular School	No	Not Reported	M	M	2018	grade_10								0.0								0
1187164	OR	school	4110040	2180	Portland SD 1J	411004001537	4212	Self Enhancement, Inc/SEI Academy	Regular School	Yes	Not Reported	M	M	2018	grade_10								0.0								0
1187559	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Not Reported	M	M	2018	grade_11								0.0								0
1188197	OR	school	4107200	2212	La Grande SD 1	410720001768	1071	Willow Elementary School	Regular School	No	Not Reported	M	M	2018	grade_11								0.0								0
1188445	OR	school	4100043	3477	ODE YCEP District	410004300490	1827	Robert S Farrell High School	Regular School	No	Not Reported	M	M	2018	grade_11								0.0								0
1188623	OR	school	4110040	2180	Portland SD 1J	411004001537	4212	Self Enhancement, Inc/SEI Academy	Regular School	Yes	Not Reported	M	M	2018	grade_11								0.0								0
1189018	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Not Reported	M	M	2018	grade_12								0.0								0
1189656	OR	school	4107200	2212	La Grande SD 1	410720001768	1071	Willow Elementary School	Regular School	No	Not Reported	M	M	2018	grade_12								0.0								0
1189904	OR	school	4100043	3477	ODE YCEP District	410004300490	1827	Robert S Farrell High School	Regular School	No	Not Reported	M	M	2018	grade_12								0.0								0
1190082	OR	school	4110040	2180	Portland SD 1J	411004001537	4212	Self Enhancement, Inc/SEI Academy	Regular School	Yes	Not Reported	M	M	2018	grade_12								0.0								0
1190477	OR	school	4101200	1899	Alsea SD 7J	410120001502	16	Alsea Elementary School	Regular School	No	Not Reported	M	M	2018	k_12_total	0.0	0.0	0.0	0.0	0.0	0.0	0.0		0	0	0	0	0	0	0
1191115	OR	school	4107200	2212	La Grande SD 1	410720001768	1071	Willow Elementary School	Regular School	No	Not Reported	M	M	2018	k_12_total	0.0	0.0	0.0	0.0	0.0	0.0	0.0		0	0	0	0	0	0	0
1191363	OR	school	4100043	3477	ODE YCEP District	410004300490	1827	Robert S Farrell High School	Regular School	No	Not Reported	M	M	2018	k_12_total	0.0	0.0	0.0	0.0	0.0	0.0	0.0		0	0	0	0	0	0	0
1191541	OR	school	4110040	2180	Portland SD 1J	411004001537	4212	Self Enhancement, Inc/SEI Academy	Regular School	Yes	Not Reported	M	M	2018	k_12_total	0.0	0.0	0.0	0.0	0.0	0.0	0.0		0	0	0	0	0	0	0
1171747	OR	school	4103390	1964	Coquille SD 8	410339000200	189	Lincoln School of Early Learning	Regular School	No	Elementary	PK	KG	2018	kindergarten								77.0								77
1171943	OR	school	4105610	1931	Gladstone SD 115	410561001774	4719	Gladstone Center for Children and Families	Regular School	No	Elementary	PK	KG	2018	kindergarten								131.0								131
1172455	OR	school	4109510	2207	Pendleton SD 16	410951001838	5287	Pendleton Early Learning Center	Regular School	No	Elementary	PK	KG	2018	kindergarten								255.0								255
1172607	OR	school	4110350	1977	Redmond SD 2J	411035001850	5340	Redmond Early Learning Center at Hugh Hartman	Regular School	No	Elementary	PK	KG	2018	kindergarten								390.0								390
1173206	OR	school	4103390	1964	Coquille SD 8	410339000200	189	Lincoln School of Early Learning	Regular School	No	Elementary	PK	KG	2018	grade_1								0.0								0
1173402	OR	school	4105610	1931	Gladstone SD 115	410561001774	4719	Gladstone Center for Children and Families	Regular School	No	Elementary	PK	KG	2018	grade_1								0.0								0
1173914	OR	school	4109510	2207	Pendleton SD 16	410951001838	5287	Pendleton Early Learning Center	Regular School	No	Elementary	PK	KG	2018	grade_1								0.0								0
1174066	OR	school	4110350	1977	Redmond SD 2J	411035001850	5340	Redmond Early Learning Center at Hugh Hartman	Regular School	No	Elementary	PK	KG	2018	grade_1								0.0								0
1174665	OR	school	4103390	1964	Coquille SD 8	410339000200	189	Lincoln School of Early Learning	Regular School	No	Elementary	PK	KG	2018	grade_2								0.0								0
1174861	OR	school	4105610	1931	Gladstone SD 115	410561001774	4719	Gladstone Center for Children and Families	Regular School	No	Elementary	PK	KG	2018	grade_2								0.0								0
1175373	OR	school	4109510	2207	Pendleton SD 16	410951001838	5287	Pendleton Early Learning Center	Regular School	No	Elementary	PK	KG	2018	grade_2								0.0								0
1175525	OR	school	4110350	1977	Redmond SD 2J	411035001850	5340	Redmond Early Learning Center at Hugh Hartman	Regular School	No	Elementary	PK	KG	2018	grade_2								0.0								0
1176124	OR	school	4103390	1964	Coquille SD 8	410339000200	189	Lincoln School of Early Learning	Regular School	No	Elementary	PK	KG	2018	grade_3								0.0								0
1176320	OR	school	4105610	1931	Gladstone SD 115	410561001774	4719	Gladstone Center for Children and Families	Regular School	No	Elementary	PK	KG	2018	grade_3								0.0								0
1176832	OR	school	4109510	2207	Pendleton SD 16	410951001838	5287	Pendleton Early Learning Center	Regular School	No	Elementary	PK	KG	2018	grade_3								0.0								0
1176984	OR	school	4110350	1977	Redmond SD 2J	411035001850	5340	Redmond Early Learning Center at Hugh Hartman	Regular School	No	Elementary	PK	KG	2018	grade_3								0.0								0
1177583	OR	school	4103390	1964	Coquille SD 8	410339000200	189	Lincoln School of Early Learning	Regular School	No	Elementary	PK	KG	2018	grade_4								0.0								0
1177779	OR	school	4105610	1931	Gladstone SD 115	410561001774	4719	Gladstone Center for Children and Families	Regular School	No	Elementary	PK	KG	2018	grade_4								0.0								0
1178291	OR	school	4109510	2207	Pendleton SD 16	410951001838	5287	Pendleton Early Learning Center	Regular School	No	Elementary	PK	KG	2018	grade_4								0.0								0
1178443	OR	school	4110350	1977	Redmond SD 2J	411035001850	5340	Redmond Early Learning Center at Hugh Hartman	Regular School	No	Elementary	PK	KG	2018	grade_4								0.0								0
1179042	OR	school	4103390	1964	Coquille SD 8	410339000200	189	Lincoln School of Early Learning	Regular School	No	Elementary	PK	KG	2018	grade_5								0.0								0
1179238	OR	school	4105610	1931	Gladstone SD 115	410561001774	4719	Gladstone Center for Children and Families	Regular School	No	Elementary	PK	KG	2018	grade_5								0.0								0
1179750	OR	school	4109510	2207	Pendleton SD 16	410951001838	5287	Pendleton Early Learning Center	Regular School	No	Elementary	PK	KG	2018	grade_5								0.0								0
1179902	OR	school	4110350	1977	Redmond SD 2J	411035001850	5340	Redmond Early Learning Center at Hugh Hartman	Regular School	No	Elementary	PK	KG	2018	grade_5								0.0								0
1180501	OR	school	4103390	1964	Coquille SD 8	410339000200	189	Lincoln School of Early Learning	Regular School	No	Elementary	PK	KG	2018	grade_6								0.0								0
1180697	OR	school	4105610	1931	Gladstone SD 115	410561001774	4719	Gladstone Center for Children and Families	Regular School	No	Elementary	PK	KG	2018	grade_6								0.0								0
1181209	OR	school	4109510	2207	Pendleton SD 16	410951001838	5287	Pendleton Early Learning Center	Regular School	No	Elementary	PK	KG	2018	grade_6								0.0								0
1181361	OR	school	4110350	1977	Redmond SD 2J	411035001850	5340	Redmond Early Learning Center at Hugh Hartman	Regular School	No	Elementary	PK	KG	2018	grade_6								0.0								0
1181960	OR	school	4103390	1964	Coquille SD 8	410339000200	189	Lincoln School of Early Learning	Regular School	No	Elementary	PK	KG	2018	grade_7								0.0								0
1182156	OR	school	4105610	1931	Gladstone SD 115	410561001774	4719	Gladstone Center for Children and Families	Regular School	No	Elementary	PK	KG	2018	grade_7								0.0								0
1182668	OR	school	4109510	2207	Pendleton SD 16	410951001838	5287	Pendleton Early Learning Center	Regular School	No	Elementary	PK	KG	2018	grade_7								0.0								0
1182820	OR	school	4110350	1977	Redmond SD 2J	411035001850	5340	Redmond Early Learning Center at Hugh Hartman	Regular School	No	Elementary	PK	KG	2018	grade_7								0.0								0
1183419	OR	school	4103390	1964	Coquille SD 8	410339000200	189	Lincoln School of Early Learning	Regular School	No	Elementary	PK	KG	2018	grade_8								0.0								0
1183615	OR	school	4105610	1931	Gladstone SD 115	410561001774	4719	Gladstone Center for Children and Families	Regular School	No	Elementary	PK	KG	2018	grade_8								0.0								0
1184127	OR	school	4109510	2207	Pendleton SD 16	410951001838	5287	Pendleton Early Learning Center	Regular School	No	Elementary	PK	KG	2018	grade_8								0.0								0
1184279	OR	school	4110350	1977	Redmond SD 2J	411035001850	5340	Redmond Early Learning Center at Hugh Hartman	Regular School	No	Elementary	PK	KG	2018	grade_8								0.0								0
1184878	OR	school	4103390	1964	Coquille SD 8	410339000200	189	Lincoln School of Early Learning	Regular School	No	Elementary	PK	KG	2018	grade_9								0.0								0
1185074	OR	school	4105610	1931	Gladstone SD 115	410561001774	4719	Gladstone Center for Children and Families	Regular School	No	Elementary	PK	KG	2018	grade_9								0.0								0
1185586	OR	school	4109510	2207	Pendleton SD 16	410951001838	5287	Pendleton Early Learning Center	Regular School	No	Elementary	PK	KG	2018	grade_9								0.0								0
1185738	OR	school	4110350	1977	Redmond SD 2J	411035001850	5340	Redmond Early Learning Center at Hugh Hartman	Regular School	No	Elementary	PK	KG	2018	grade_9								0.0								0
1186337	OR	school	4103390	1964	Coquille SD 8	410339000200	189	Lincoln School of Early Learning	Regular School	No	Elementary	PK	KG	2018	grade_10								0.0								0
1186533	OR	school	4105610	1931	Gladstone SD 115	410561001774	4719	Gladstone Center for Children and Families	Regular School	No	Elementary	PK	KG	2018	grade_10								0.0								0
1187045	OR	school	4109510	2207	Pendleton SD 16	410951001838	5287	Pendleton Early Learning Center	Regular School	No	Elementary	PK	KG	2018	grade_10								0.0								0
1187197	OR	school	4110350	1977	Redmond SD 2J	411035001850	5340	Redmond Early Learning Center at Hugh Hartman	Regular School	No	Elementary	PK	KG	2018	grade_10								0.0								0
1187796	OR	school	4103390	1964	Coquille SD 8	410339000200	189	Lincoln School of Early Learning	Regular School	No	Elementary	PK	KG	2018	grade_11								0.0								0