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 school_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	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
1686209	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2017	kindergarten								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
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
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
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
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
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
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
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
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
1700909	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2017	grade_10								0.0								0
1702379	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2017	grade_11								0.0								0
1703849	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2017	grade_12								0.0								0
1705319	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2017	k_12_total	166.0	0.0	27.0		1.0	0.0	10.0		166	0	27		1	0	10
1171537	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2018	kindergarten								0.0								0
1172996	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2018	grade_1								0.0								0
1174455	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2018	grade_2								0.0								0
1175914	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2018	grade_3								0.0								0
1177373	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2018	grade_4								0.0								0
1178832	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2018	grade_5								0.0								0
1180291	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2018	grade_6								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
1183209	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2018	grade_8								98.0								98
1184668	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2018	grade_9								0.0								0
1186127	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2018	grade_10								0.0								0
1187586	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2018	grade_11								0.0								0
1189045	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2018	grade_12								0.0								0
1190504	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2018	k_12_total	189.0	0.0	27.0	3.0	3.0	0.0	7.0		189	0	27	3	3	0	7
897701	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2020	kindergarten								0								0
899160	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2020	grade_1								0								0
900619	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2020	grade_2								0								0
902078	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2020	grade_3								0								0
903537	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2020	grade_4								0								0
904996	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2020	grade_5								0								0
906455	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2020	grade_6								0								0
907914	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2020	grade_7								143								143
909373	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2020	grade_8								129								129
910832	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2020	grade_9								0								0
912291	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2020	grade_10								0								0
913750	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2020	grade_11								0								0
915209	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2020	grade_12								0								0
916668	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2020	k_12_total	206	0	39	8	0	0	19		206	0	39	8	0	0	19
637688	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2021	kindergarten								0								0
639159	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2021	grade_1								0								0
640630	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2021	grade_2								0								0
642101	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2021	grade_3								0								0
643572	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2021	grade_4								0								0
645043	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2021	grade_5								0								0
646514	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2021	grade_6								0								0
647985	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2021	grade_7								144								144
649456	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2021	grade_8								118								118
650927	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2021	grade_9								0								0
652398	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2021	grade_10								0								0
653869	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2021	grade_11								0								0
655340	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2021	grade_12								0								0
656811	OR	school	4101710	1894	Baker SD 5J	410171000001	1	Baker Middle School	Regular School	No	Middle	07	08	2021	k_12_total	234	0	2	11	0	0	15		234	0	2	11	0	0	15
1686212	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2017	kindergarten								112.0								112
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
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
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
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
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
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
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
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
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
1700912	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2017	grade_10								0.0								0
1702382	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2017	grade_11								0.0								0
1703852	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2017	grade_12								0.0								0
1705322	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2017	k_12_total	402.0	1.0	46.0		0.0	0.0	12.0		402	1	46		0	0	12
1171540	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2018	kindergarten								121.0								121
1172999	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2018	grade_1								108.0								108
1174458	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2018	grade_2								110.0								110
1175917	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2018	grade_3								111.0								111
1177376	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2018	grade_4								0.0								0
1178835	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2018	grade_5								0.0								0
1180294	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2018	grade_6								0.0								0
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
1183212	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2018	grade_8								0.0								0
1184671	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2018	grade_9								0.0								0
1186130	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2018	grade_10								0.0								0
1187589	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2018	grade_11								0.0								0
1189048	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2018	grade_12								0.0								0
1190507	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2018	k_12_total	390.0	2.0	36.0	4.0	0.0	1.0	17.0		390	2	36	4	0	1	17
897704	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2020	kindergarten								113								113
899163	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2020	grade_1								102								102
900622	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2020	grade_2								108								108
902081	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2020	grade_3								103								103
903540	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2020	grade_4								0								0
904999	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2020	grade_5								0								0
906458	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2020	grade_6								0								0
907917	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2020	grade_7								0								0
909376	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2020	grade_8								0								0
910835	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2020	grade_9								0								0
912294	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2020	grade_10								0								0
913753	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2020	grade_11								0								0
915212	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2020	grade_12								0								0
916671	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	KG	03	2020	k_12_total	366	0	33	2	3	0	22		366	0	33	2	3	0	22
637692	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	01	03	2021	kindergarten								0								0
639163	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	01	03	2021	grade_1								96								96
640634	OR	school	4101710	1894	Baker SD 5J	410171000002	2	Brooklyn Primary School	Regular School	No	Elementary	01	03	2021	grade_2								73								73