enrollments

Data source: Big Local News · About: Big Local

93 rows where grade = "kindergarten_3_year_old", state = "WI" and year = 2016

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 93 ✖

grade ✖

  • kindergarten_3_year_old · 93 ✖
Link 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
288788 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
288797 288797 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes 1.0 PK 05 2016   kindergarten_3_year_old                                                   49                                             49
288817 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 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 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 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 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 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
288921 288921 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001133 93 Bruce Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   1                                             1
288930 288930 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001134 94 Bryant Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   4                                             4
288942 288942 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001135 95 Burbank Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   4                                             4
288954 288954 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001136 98 Burdick Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   2                                             2
288989 288989 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001829 108 Carson Academy   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   39                                             39
289023 289023 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001140 110 Clarke Street Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   4                                             4
289032 289032 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001141 114 Clemens Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   1                                             1
289044 289044 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001142 113 Clement Avenue Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   2                                             2
289061 289061 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001143 116 Congress Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   77                                             77
289074 289074 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001144 117 Cooper Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   2                                             2
289086 289086 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001045 501 Craig Montessori School   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   76                                             76
289098 289098 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001146 122 Curtin Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   1                                             1
289121 289121 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001148 125 Doerfler Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   20                                             20
289133 289133 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001154 143 Eighty-First Street Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   55                                             55
289151 289151 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001157 150 Emerson Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   5                                             5
289160 289160 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001158 152 Engleburg Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   4                                             4
289184 289184 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001160 158 Fernwood Montessori   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   73                                             73
289196 289196 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001162 170 Fifty-Third Street Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   1                                             1
289205 289205 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001163 173 Forest Home Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   67                                             67
289217 289217 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001165 179 Franklin Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   6                                             6
289226 289226 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001166 182 Fratney Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   2                                             2
289238 289238 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001169 185 Gaenslen Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   10                                             10
289250 289250 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001172 191 Garland Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   3                                             3
289259 289259 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001173 192 Goodrich Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   4                                             4
289276 289276 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001175 193 Grant Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   4                                             4
289288 289288 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001176 196 Grantosa Drive Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   10                                             10
289300 289300 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001179 202 Greenfield Bilingual   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   2                                             2
289345 289345 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001183 208 Hartford Avenue Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   3                                             3
289362 289362 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001185 212 Hawthorne Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   30                                             30
289374 289374 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000680 214 Hayes Bilingual School   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   32                                             32
289386 289386 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001187 217 Hi-Mount Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   1                                             1
289398 289398 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001847 852 Highland Community School charter Regular School Yes 1.0 PK 08 2016   kindergarten_3_year_old                                                   47                                             47
289410 289410 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001188 218 Holmes Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   2                                             2
289419 289419 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001246 334 Honey Creek Elementary charter Regular School Yes 1.0 PK 05 2016   kindergarten_3_year_old                                                   5                                             5
289431 289431 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001208 253 Hopkins Lloyd   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   2                                             2
289437 289437 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002911 112 Howard Avenue Montessori School   Regular School No 1.0 PK 02 2016   kindergarten_3_year_old                                                   42                                             42
289449 289449 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001190 223 Humboldt Park Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   5                                             5
289469 289469 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001261 377 Jackson Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   43                                             43
289483 289483 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001195 232 Kagel Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   23                                             23
289496 289496 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001196 235 Keefe Avenue Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   21                                             21
289505 289505 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001197 237 Kilbourn Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   39                                             39
289526 289526 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001178 199 King Jr Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   29                                             29
289535 289535 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001200 337 Kluge Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   22                                             22
289563 289563 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001202 238 LaFollette Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   2                                             2
289575 289575 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001204 241 Lancaster Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   1                                             1
289584 289584 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001206 250 Lincoln Avenue Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   60                                             60
289600 289600 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001209 256 Longfellow Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   11                                             11
289609 289609 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001210 257 Lowell Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   6                                             6
289625 289625 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002931 870 MacDowell Montessori School K3-12   Regular School No 4.0 PK 12 2016   kindergarten_3_year_old                                                   76                                             76
289637 289637 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001213 265 Manitoba Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   4                                             4
289646 289646 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001214 267 Maple Tree Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   57                                             57
289658 289658 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001216 268 Maryland Montessori   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   51                                             51
289680 289680 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002464 525 Metcalfe Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   2                                             2
289742 289742 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002340 140 Milwaukee French Immersion   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   3                                             3
289767 289767 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002415 362 Milwaukee Parkside School   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   9                                             9
289787 289787 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001191 226 Milwaukee Sign Language Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   2                                             2
289796 289796 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001161 167 Milwaukee Spanish Immersion   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   11                                             11
289808 289808 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001219 274 Mitchell Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   40                                             40
289820 289820 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001220 277 Morgandale Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   7                                             7
289837 289837 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001224 283 Neeskara Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   6                                             6
289844 289844 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001341 1141 Next Door Charter charter Regular School Yes 1.0 PK KG 2016   kindergarten_3_year_old                                                   2                                             2
289853 289853 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001225 289 Ninety-Fifth Street Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   1                                             1
289884 289884 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002993 840 Obama School of Career and Technical Education   Regular School No 4.0 PK 12 2016   kindergarten_3_year_old                                                   26                                             26
289893 289893 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001231 301 Parkview Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   2                                             2
289902 289902 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001233 307 Pierce Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   31                                             31
289926 289926 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001236 313 Riley Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   5                                             5
289938 289938 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001174 194 River Trail Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   2                                             2
289955 289955 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002601 177 Rogers Street Academy   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   12                                             12
289976 289976 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001240 319 Sherman Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   45                                             45
289985 289985 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002744 107 Siefert Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   45                                             45
289994 289994 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001243 325 Silver Spring Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   37                                             37
290019 290019 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001156 149 Starms Early Childhood   Regular School No 1.0 PK KG 2016   kindergarten_3_year_old                                                   123                                             123
290031 290031 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001249 343 Story Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   7                                             7
290040 290040 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001250 344 Stuart Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   1                                             1
290063 290063 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002439 154 Thurston Woods Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   42                                             42
290075 290075 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001258 365 Townsend Street Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   4                                             4
290092 290092 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001259 368 Trowbridge Street Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   1                                             1
290116 290116 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001264 387 Victory Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   2                                             2
290128 290128 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001265 390 Vieau Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   7                                             7
290149 290149 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001512 130 Westside Academy   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   28                                             28
290161 290161 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001270 397 Whitman Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   2                                             2
290170 290170 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001271 398 Whittier Elementary charter Regular School Yes 1.0 PK 05 2016   kindergarten_3_year_old                                                   2                                             2
290191 290191 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000681 399 WI Conservatory of Lifelong Learning   Regular School No 4.0 PK 12 2016   kindergarten_3_year_old                                                   2                                             2
290200 290200 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002342 295 Zablocki Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   16                                             16
293193 293193 WI Milwaukee   school 5500043 8107 Non District Charter Schools School for Early Development and 550004302497 1279 School for Early Development and Achievement (SEDA) charter Regular School Yes 1.0 PK 02 2016   kindergarten_3_year_old                                                   5                                             5

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);