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 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
1686207	OR	school	4101710	1894	Baker SD 5J	410171001783	4759	Baker Early College	Regular School	Yes	High	09	12	2017	kindergarten	0.0	0
1686208	OR	school	4101710	1894	Baker SD 5J	410171000009	8	Baker High School	Regular School	No	High	09	12	2017	kindergarten	0.0	0
1686209	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2017	kindergarten	0.0	0
1686210	OR	school	4101710	1894	Baker SD 5J		1894	Baker SD 5J						2017	kindergarten	0.0	0
1686211	OR	school	4101710	1894	Baker SD 5J	410171001767	4728	Baker Web Academy	Regular School	Yes	Other	KG	12	2017	kindergarten	60.0	60
1686212	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2017	kindergarten	112.0	112
1686213	OR	school	4101710	1894	Baker SD 5J	410171001516	3493	EAGLE CAP Innovative HS	Alternative School	No	High	09	12	2017	kindergarten	0.0	0
1686214	OR	school	4101710	1894	Baker SD 5J	410171000030	4	Haines Elementary School	Regular School	No	Elementary	KG	06	2017	kindergarten	23.0	23
1686215	OR	school	4101710	1894	Baker SD 5J	410171000034	5	Keating Elementary School	Regular School	No	Elementary	KG	06	2017	kindergarten	3.0	3
1686216	OR	school	4101710	1894	Baker SD 5J	410171000007	7	South Baker Intermediate School	Regular School	No	Elementary	04	06	2017	kindergarten	0.0	0
1687677	OR	school	4101710	1894	Baker SD 5J	410171001783	4759	Baker Early College	Regular School	Yes	High	09	12	2017	grade_1	0.0	0
1687678	OR	school	4101710	1894	Baker SD 5J	410171000009	8	Baker High School	Regular School	No	High	09	12	2017	grade_1	0.0	0
1687679	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2017	grade_1	0.0	0
1687680	OR	school	4101710	1894	Baker SD 5J		1894	Baker SD 5J						2017	grade_1	0.0	0
1687681	OR	school	4101710	1894	Baker SD 5J	410171001767	4728	Baker Web Academy	Regular School	Yes	Other	KG	12	2017	grade_1	49.0	49
1687682	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2017	grade_1	117.0	117
1687683	OR	school	4101710	1894	Baker SD 5J	410171001516	3493	EAGLE CAP Innovative HS	Alternative School	No	High	09	12	2017	grade_1	0.0	0
1687684	OR	school	4101710	1894	Baker SD 5J	410171000030	4	Haines Elementary School	Regular School	No	Elementary	KG	06	2017	grade_1	19.0	19
1687685	OR	school	4101710	1894	Baker SD 5J	410171000034	5	Keating Elementary School	Regular School	No	Elementary	KG	06	2017	grade_1	4.0	4
1687686	OR	school	4101710	1894	Baker SD 5J	410171000007	7	South Baker Intermediate School	Regular School	No	Elementary	04	06	2017	grade_1	0.0	0
1689147	OR	school	4101710	1894	Baker SD 5J	410171001783	4759	Baker Early College	Regular School	Yes	High	09	12	2017	grade_2	0.0	0
1689148	OR	school	4101710	1894	Baker SD 5J	410171000009	8	Baker High School	Regular School	No	High	09	12	2017	grade_2	0.0	0
1689149	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2017	grade_2	0.0	0
1689150	OR	school	4101710	1894	Baker SD 5J		1894	Baker SD 5J						2017	grade_2	0.0	0
1689151	OR	school	4101710	1894	Baker SD 5J	410171001767	4728	Baker Web Academy	Regular School	Yes	Other	KG	12	2017	grade_2	57.0	57
1689152	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2017	grade_2	110.0	110
1689153	OR	school	4101710	1894	Baker SD 5J	410171001516	3493	EAGLE CAP Innovative HS	Alternative School	No	High	09	12	2017	grade_2	0.0	0
1689154	OR	school	4101710	1894	Baker SD 5J	410171000030	4	Haines Elementary School	Regular School	No	Elementary	KG	06	2017	grade_2	21.0	21
1689155	OR	school	4101710	1894	Baker SD 5J	410171000034	5	Keating Elementary School	Regular School	No	Elementary	KG	06	2017	grade_2	3.0	3
1689156	OR	school	4101710	1894	Baker SD 5J	410171000007	7	South Baker Intermediate School	Regular School	No	Elementary	04	06	2017	grade_2	0.0	0
1690617	OR	school	4101710	1894	Baker SD 5J	410171001783	4759	Baker Early College	Regular School	Yes	High	09	12	2017	grade_3	0.0	0
1690618	OR	school	4101710	1894	Baker SD 5J	410171000009	8	Baker High School	Regular School	No	High	09	12	2017	grade_3	0.0	0
1690619	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2017	grade_3	0.0	0
1690620	OR	school	4101710	1894	Baker SD 5J		1894	Baker SD 5J						2017	grade_3	0.0	0
1690621	OR	school	4101710	1894	Baker SD 5J	410171001767	4728	Baker Web Academy	Regular School	Yes	Other	KG	12	2017	grade_3	48.0	48
1690622	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2017	grade_3	129.0	129
1690623	OR	school	4101710	1894	Baker SD 5J	410171001516	3493	EAGLE CAP Innovative HS	Alternative School	No	High	09	12	2017	grade_3	0.0	0
1690624	OR	school	4101710	1894	Baker SD 5J	410171000030	4	Haines Elementary School	Regular School	No	Elementary	KG	06	2017	grade_3	24.0	24
1690625	OR	school	4101710	1894	Baker SD 5J	410171000034	5	Keating Elementary School	Regular School	No	Elementary	KG	06	2017	grade_3	5.0	5
1690626	OR	school	4101710	1894	Baker SD 5J	410171000007	7	South Baker Intermediate School	Regular School	No	Elementary	04	06	2017	grade_3	0.0	0
1692087	OR	school	4101710	1894	Baker SD 5J	410171001783	4759	Baker Early College	Regular School	Yes	High	09	12	2017	grade_4	0.0	0
1692088	OR	school	4101710	1894	Baker SD 5J	410171000009	8	Baker High School	Regular School	No	High	09	12	2017	grade_4	0.0	0
1692089	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2017	grade_4	0.0	0
1692090	OR	school	4101710	1894	Baker SD 5J		1894	Baker SD 5J						2017	grade_4	0.0	0
1692091	OR	school	4101710	1894	Baker SD 5J	410171001767	4728	Baker Web Academy	Regular School	Yes	Other	KG	12	2017	grade_4	63.0	63
1692092	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2017	grade_4	0.0	0
1692093	OR	school	4101710	1894	Baker SD 5J	410171001516	3493	EAGLE CAP Innovative HS	Alternative School	No	High	09	12	2017	grade_4	0.0	0
1692094	OR	school	4101710	1894	Baker SD 5J	410171000030	4	Haines Elementary School	Regular School	No	Elementary	KG	06	2017	grade_4	22.0	22
1692095	OR	school	4101710	1894	Baker SD 5J	410171000034	5	Keating Elementary School	Regular School	No	Elementary	KG	06	2017	grade_4	5.0	5
1692096	OR	school	4101710	1894	Baker SD 5J	410171000007	7	South Baker Intermediate School	Regular School	No	Elementary	04	06	2017	grade_4	113.0	113
1693557	OR	school	4101710	1894	Baker SD 5J	410171001783	4759	Baker Early College	Regular School	Yes	High	09	12	2017	grade_5	0.0	0
1693558	OR	school	4101710	1894	Baker SD 5J	410171000009	8	Baker High School	Regular School	No	High	09	12	2017	grade_5	0.0	0
1693559	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2017	grade_5	0.0	0
1693560	OR	school	4101710	1894	Baker SD 5J		1894	Baker SD 5J						2017	grade_5	0.0	0
1693561	OR	school	4101710	1894	Baker SD 5J	410171001767	4728	Baker Web Academy	Regular School	Yes	Other	KG	12	2017	grade_5	64.0	64
1693562	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2017	grade_5	0.0	0
1693563	OR	school	4101710	1894	Baker SD 5J	410171001516	3493	EAGLE CAP Innovative HS	Alternative School	No	High	09	12	2017	grade_5	0.0	0
1693564	OR	school	4101710	1894	Baker SD 5J	410171000030	4	Haines Elementary School	Regular School	No	Elementary	KG	06	2017	grade_5	25.0	25
1693565	OR	school	4101710	1894	Baker SD 5J	410171000034	5	Keating Elementary School	Regular School	No	Elementary	KG	06	2017	grade_5	2.0	2
1693566	OR	school	4101710	1894	Baker SD 5J	410171000007	7	South Baker Intermediate School	Regular School	No	Elementary	04	06	2017	grade_5	105.0	105
1695027	OR	school	4101710	1894	Baker SD 5J	410171001783	4759	Baker Early College	Regular School	Yes	High	09	12	2017	grade_6	0.0	0
1695028	OR	school	4101710	1894	Baker SD 5J	410171000009	8	Baker High School	Regular School	No	High	09	12	2017	grade_6	0.0	0
1695029	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2017	grade_6	0.0	0
1695030	OR	school	4101710	1894	Baker SD 5J		1894	Baker SD 5J						2017	grade_6	0.0	0
1695031	OR	school	4101710	1894	Baker SD 5J	410171001767	4728	Baker Web Academy	Regular School	Yes	Other	KG	12	2017	grade_6	85.0	85
1695032	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2017	grade_6	0.0	0
1695033	OR	school	4101710	1894	Baker SD 5J	410171001516	3493	EAGLE CAP Innovative HS	Alternative School	No	High	09	12	2017	grade_6	0.0	0
1695034	OR	school	4101710	1894	Baker SD 5J	410171000030	4	Haines Elementary School	Regular School	No	Elementary	KG	06	2017	grade_6	21.0	21
1695035	OR	school	4101710	1894	Baker SD 5J	410171000034	5	Keating Elementary School	Regular School	No	Elementary	KG	06	2017	grade_6	3.0	3
1695036	OR	school	4101710	1894	Baker SD 5J	410171000007	7	South Baker Intermediate School	Regular School	No	Elementary	04	06	2017	grade_6	103.0	103
1696497	OR	school	4101710	1894	Baker SD 5J	410171001783	4759	Baker Early College	Regular School	Yes	High	09	12	2017	grade_7	0.0	0
1696498	OR	school	4101710	1894	Baker SD 5J	410171000009	8	Baker High School	Regular School	No	High	09	12	2017	grade_7	0.0	0
1696499	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2017	grade_7	98.0	98
1696500	OR	school	4101710	1894	Baker SD 5J		1894	Baker SD 5J						2017	grade_7	0.0	0
1696501	OR	school	4101710	1894	Baker SD 5J	410171001767	4728	Baker Web Academy	Regular School	Yes	Other	KG	12	2017	grade_7	86.0	86
1696502	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2017	grade_7	0.0	0
1696503	OR	school	4101710	1894	Baker SD 5J	410171001516	3493	EAGLE CAP Innovative HS	Alternative School	No	High	09	12	2017	grade_7	0.0	0
1696504	OR	school	4101710	1894	Baker SD 5J	410171000030	4	Haines Elementary School	Regular School	No	Elementary	KG	06	2017	grade_7	0.0	0
1696505	OR	school	4101710	1894	Baker SD 5J	410171000034	5	Keating Elementary School	Regular School	No	Elementary	KG	06	2017	grade_7	0.0	0
1696506	OR	school	4101710	1894	Baker SD 5J	410171000007	7	South Baker Intermediate School	Regular School	No	Elementary	04	06	2017	grade_7	0.0	0
1697967	OR	school	4101710	1894	Baker SD 5J	410171001783	4759	Baker Early College	Regular School	Yes	High	09	12	2017	grade_8	0.0	0
1697968	OR	school	4101710	1894	Baker SD 5J	410171000009	8	Baker High School	Regular School	No	High	09	12	2017	grade_8	0.0	0
1697969	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2017	grade_8	108.0	108
1697970	OR	school	4101710	1894	Baker SD 5J		1894	Baker SD 5J						2017	grade_8	1.0	1
1697971	OR	school	4101710	1894	Baker SD 5J	410171001767	4728	Baker Web Academy	Regular School	Yes	Other	KG	12	2017	grade_8	121.0	121
1697972	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2017	grade_8	0.0	0
1697973	OR	school	4101710	1894	Baker SD 5J	410171001516	3493	EAGLE CAP Innovative HS	Alternative School	No	High	09	12	2017	grade_8	0.0	0
1697974	OR	school	4101710	1894	Baker SD 5J	410171000030	4	Haines Elementary School	Regular School	No	Elementary	KG	06	2017	grade_8	0.0	0
1697975	OR	school	4101710	1894	Baker SD 5J	410171000034	5	Keating Elementary School	Regular School	No	Elementary	KG	06	2017	grade_8	0.0	0
1697976	OR	school	4101710	1894	Baker SD 5J	410171000007	7	South Baker Intermediate School	Regular School	No	Elementary	04	06	2017	grade_8	0.0	0
1699437	OR	school	4101710	1894	Baker SD 5J	410171001783	4759	Baker Early College	Regular School	Yes	High	09	12	2017	grade_9	1.0	1
1699438	OR	school	4101710	1894	Baker SD 5J	410171000009	8	Baker High School	Regular School	No	High	09	12	2017	grade_9	126.0	126
1699439	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2017	grade_9	0.0	0
1699440	OR	school	4101710	1894	Baker SD 5J		1894	Baker SD 5J						2017	grade_9	1.0	1
1699441	OR	school	4101710	1894	Baker SD 5J	410171001767	4728	Baker Web Academy	Regular School	Yes	Other	KG	12	2017	grade_9	125.0	125
1699442	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2017	grade_9	0.0	0
1699443	OR	school	4101710	1894	Baker SD 5J	410171001516	3493	EAGLE CAP Innovative HS	Alternative School	No	High	09	12	2017	grade_9	0.0	0
1699444	OR	school	4101710	1894	Baker SD 5J	410171000030	4	Haines Elementary School	Regular School	No	Elementary	KG	06	2017	grade_9	0.0	0
1699445	OR	school	4101710	1894	Baker SD 5J	410171000034	5	Keating Elementary School	Regular School	No	Elementary	KG	06	2017	grade_9	0.0	0
1699446	OR	school	4101710	1894	Baker SD 5J	410171000007	7	South Baker Intermediate School	Regular School	No	Elementary	04	06	2017	grade_9	0.0	0
1700907	OR	school	4101710	1894	Baker SD 5J	410171001783	4759	Baker Early College	Regular School	Yes	High	09	12	2017	grade_10	54.0	54