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 order by ccd_charter_school limit 101

Query parameters

This data as json, CSV

rowid	state	county	admin_level	district_nces_id	district_state_id	district_state_type	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
118787	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001239	316	Academy of Accelerated Learning	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	6	6
118816	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001121	75	Alcott Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	1	1
118825	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001122	73	Allen-Field Elementary	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	15	15
118856	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001124	77	Auer Avenue Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	4	4
118875	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001170	188	Barbee Elementary	Regular School	No	1.0	PK	06	2015	kindergarten_3_year_old	74	74
118885	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001126	81	Barton Elementary	Regular School	No	1.0	PK	06	2015	kindergarten_3_year_old	3	3
118903	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001256	356	Bethune Academy	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	1	1
118918	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002395	89	Brown Street Academy	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	4	4
118927	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001132	92	Browning Elementary	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	3	3
118936	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001133	93	Bruce Elementary	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	2	2
118945	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001134	94	Bryant Elementary	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	3	3
118957	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001135	95	Burbank Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	3	3
118969	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001136	98	Burdick Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	6	6
119003	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001829	108	Carson Academy	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	37	37
119016	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002602	178	Carver Academy	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	1	1
119039	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001140	110	Clarke Street Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	3	3
119048	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001141	114	Clemens Elementary	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	1	1
119060	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001142	113	Clement Avenue Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	6	6
119077	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001143	116	Congress Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	83	83
119090	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001144	117	Cooper Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	1	1
119102	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001045	501	Craig Montessori School	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	78	78
119114	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001146	122	Curtin Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	2	2
119137	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001148	125	Doerfler Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	12	12
119149	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001154	143	Eighty-First Street Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	45	45
119158	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002438	148	Elm Creative Arts Elementary	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	6	6
119167	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001157	150	Emerson Elementary	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	4	4
119176	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001158	152	Engleburg Elementary	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	4	4
119199	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001160	158	Fernwood Montessori	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	73	73
119211	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001162	170	Fifty-Third Street Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	2	2
119220	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001163	173	Forest Home Elementary	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	65	65
119233	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001165	179	Franklin Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	12	12
119242	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001166	182	Fratney Elementary	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	5	5
119254	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001169	185	Gaenslen Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	8	8
119266	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001172	191	Garland Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	1	1
119275	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001173	192	Goodrich Elementary	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	6	6
119292	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001175	193	Grant Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	3	3
119305	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001176	196	Grantosa Drive Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	13	13
119317	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001179	202	Greenfield Bilingual	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	5	5
119336	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001181	205	Hampton Elementary	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	28	28
119364	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001183	208	Hartford Avenue Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	1	1
119381	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001185	212	Hawthorne Elementary	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	32	32
119394	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960000680	214	Hayes Bilingual School	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	33	33
119407	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001187	217	Hi-Mount Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	3	3
119431	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001188	218	Holmes Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	4	4
119452	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001208	253	Hopkins Lloyd	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	3	3
119457	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002911	112	Howard Avenue Montessori School	Regular School	No	1.0	PK	01	2015	kindergarten_3_year_old	40	40
119469	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001190	223	Humboldt Park Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	8	8
119489	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001261	377	Jackson Elementary	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	34	34
119504	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001195	232	Kagel Elementary	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	30	30
119517	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001196	235	Keefe Avenue Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	24	24
119527	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001197	237	Kilbourn Elementary	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	47	47
119549	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001178	199	King Jr Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	24	24
119558	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001200	337	Kluge Elementary	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	12	12
119592	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001202	238	LaFollette Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	2	2
119604	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001204	241	Lancaster Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	2	2
119613	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001206	250	Lincoln Avenue Elementary	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	60	60
119630	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001209	256	Longfellow Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	16	16
119640	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001210	257	Lowell Elementary	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	6	6
119656	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002931	870	MacDowell Montessori School K3-12	Regular School	No	4.0	PK	12	2015	kindergarten_3_year_old	85	85
119668	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001213	265	Manitoba Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	2	2
119677	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001214	267	Maple Tree Elementary	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	58	58
119690	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001216	268	Maryland Montessori	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	53	53
119711	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002464	525	Metcalfe Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	5	5
119771	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002340	140	Milwaukee French Immersion	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	2	2
119780	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001155	146	Milwaukee German Immersion	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	6	6
119797	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002415	362	Milwaukee Parkside School	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	5	5
119817	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001191	226	Milwaukee Sign Language Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	2	2
119826	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001161	167	Milwaukee Spanish Immersion	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	18	18
119838	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001219	274	Mitchell Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	36	36
119850	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001220	277	Morgandale Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	5	5
119867	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001224	283	Neeskara Elementary	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	11	11
119882	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001225	289	Ninety-Fifth Street Elementary	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	1	1
119915	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002993	840	Obama School of Career and Technical Education	Regular School	No	4.0	PK	12	2015	kindergarten_3_year_old	3	3
119924	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001231	301	Parkview Elementary	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	4	4
119933	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001233	307	Pierce Elementary	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	29	29
119961	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001236	313	Riley Elementary	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	14	14
119974	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001174	194	River Trail Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	1	1
119991	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002601	177	Rogers Street Academy	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	16	16
120012	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001240	319	Sherman Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	48	48
120022	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002744	107	Siefert Elementary	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	45	45
120032	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001243	325	Silver Spring Elementary	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	31	31
120062	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001156	149	Starms Early Childhood	Regular School	No	1.0	PK	KG	2015	kindergarten_3_year_old	116	116
120074	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001249	343	Story Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	9	9
120083	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001250	344	Stuart Elementary	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	4	4
120095	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001255	360	Thoreau Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	1	1
120107	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002439	154	Thurston Woods Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	53	53
120120	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001258	365	Townsend Street Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	3	3
120137	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001259	368	Trowbridge Street Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	1	1
120160	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001264	387	Victory Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	2	2
120172	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001265	390	Vieau Elementary	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	8	8
120193	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001512	130	Westside Academy	Regular School	No	1.0	PK	08	2015	kindergarten_3_year_old	31	31
120205	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001270	397	Whitman Elementary	Regular School	No	1.0	PK	07	2015	kindergarten_3_year_old	3	3
120234	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960000681	399	WI Conservatory of Lifelong Learning	Regular School	No	4.0	PK	12	2015	kindergarten_3_year_old	2	2
120243	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002342	295	Zablocki Elementary	Regular School	No	1.0	PK	05	2015	kindergarten_3_year_old	15	15
288788	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001239	316	Academy of Accelerated Learning	Regular School	No	1.0	PK	05	2016	kindergarten_3_year_old	4	4
288817	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001122	73	Allen-Field Elementary	Regular School	No	1.0	PK	05	2016	kindergarten_3_year_old	13	13
288848	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001124	77	Auer Avenue Elementary	Regular School	No	1.0	PK	08	2016	kindergarten_3_year_old	3	3
288863	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001170	188	Barbee Elementary	Regular School	No	1.0	PK	06	2016	kindergarten_3_year_old	72	72
288889	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001256	356	Bethune Academy	Regular School	No	1.0	PK	08	2016	kindergarten_3_year_old	4	4
288903	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002395	89	Brown Street Academy	Regular School	No	1.0	PK	05	2016	kindergarten_3_year_old	4	4
288912	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001132	92	Browning Elementary	Regular School	No	1.0	PK	05	2016	kindergarten_3_year_old	5	5