Data source: Big Local News · About: Big Local

14,617 rows where state = "WI" and year = 2016 sorted by ccd_school_high_grade descending

View and edit SQL

year

  • 2016 · 14,617
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
281973 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002976 165 Appleton Community 4K   Regular School No 1.0 PK PK 2016   pk_12_total 659.0 35.0 97.0 4.0   128.0       2.0 51.0   529.0 447.0             348     141   976 659 35 97 4   128       2 51   529 447         348   141   976
281974 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002976 165 Appleton Community 4K   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   976                                             976
282428 WI Sauk   school 5500810 280 Public school Baraboo 550081002803 150 Baraboo Early Learning Cooperative   Regular School No 1.0 PK PK 2016   pk_12_total 120.0 2.0 16.0 4.0   1.0         9.0   76.0 76.0             30     19   152 120 2 16 4   1         9   76 76         30   19   152
282429 WI Sauk   school 5500810 280 Public school Baraboo 550081002803 150 Baraboo Early Learning Cooperative   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   152                                             152
282430 WI Sauk   school 5500810 280 Public school Baraboo 550081002802 160 Baraboo Early Learning Cooperative Renewal Head Start of Baraboo   Regular School No 1.0 PK PK 2016   pk_12_total 25.0 2.0 6.0               1.0   17.0 17.0             14     4   34 25 2 6               1   17 17         14   4   34
282431 WI Sauk   school 5500810 280 Public school Baraboo 550081002802 160 Baraboo Early Learning Cooperative Renewal Head Start of Baraboo   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   34                                             34
282677 WI Rock   school 5501050 413 Public school Beloit 550105002855 150 Beloit Early Learning   Regular School No 1.0 PK PK 2016   pk_12_total 18.0 14.0 17.0 6.0             3.0   32.0 26.0             39     15   58 18 14 17 6             3   32 26         39   15   58
282678 WI Rock   school 5501050 413 Public school Beloit 550105002855 150 Beloit Early Learning   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   50                                             50
282679 WI Rock   school 5501050 413 Public school Beloit 550105002855 150 Beloit Early Learning   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   8                                             8
283118 WI Racine   school 5501890 777 Public school Burlington Area 550189002987 150 4K Community School   Regular School No 1.0 PK PK 2016   pk_12_total 41.0 1.0 7.0               1.0   23.0 27.0             13     1   50 41 1 7               1   23 27         13   1   50
283119 WI Racine   school 5501890 777 Public school Burlington Area 550189002987 150 4K Community School   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   50                                             50
283509 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255002784 100 Korger-Chestnut   Regular School No 1.0 PK PK 2016   pk_12_total 371.0 1.0 7.0 1.0   8.0         13.0   211.0 190.0             66     68   401 371 1 7 1   8         13   211 190         66   68   401
283510 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255002784 100 Korger-Chestnut   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   363                                             363
283511 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255002784 100 Korger-Chestnut   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   38                                             38
283597 WI Waupaca   school 5502670 1141 Public school Clintonville 550267000303 60 Dellwood Early Learning Center   Regular School No 1.0 PK PK 2016   pk_12_total 78.0   10.0               1.0   42.0 47.0             56     17   89 78   10               1   42 47         56   17   89
283598 WI Waupaca   school 5502670 1141 Public school Clintonville 550267000303 60 Dellwood Early Learning Center   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   81                                             81
283599 WI Waupaca   school 5502670 1141 Public school Clintonville 550267000303 60 Dellwood Early Learning Center   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   8                                             8
283639 WI Clark   school 5502730 1162 Public school Colby 550273000312 120 Little Stars Pre-School   Regular School No 1.0 PK PK 2016   pk_12_total 48.0   19.0               1.0   34.0 34.0             39     19   68 48   19               1   34 34         39   19   68
283640 WI Clark   school 5502730 1162 Public school Colby 550273000312 120 Little Stars Pre-School   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   49                                             49
283641 WI Clark   school 5502730 1162 Public school Colby 550273000312 120 Little Stars Pre-School   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   19                                             19
283879 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317002963 190 DCE 4K Community Partnership   Regular School No 1.0 PK PK 2016   pk_12_total 275.0 1.0 16.0 3.0   34.0       1.0 12.0   180.0 162.0                   24   342 275 1 16 3   34       1 12   180 162             24   342
283880 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317002963 190 DCE 4K Community Partnership   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   342                                             342
283962 WI Dane   school 5503180 1316 Public school De Forest Area 550318002368 100 Holum Education Center   Regular School No 1.0 PK PK 2016   pk_12_total 232.0 5.0 8.0     14.0         13.0   132.0 140.0             14     32   272 232 5 8     14         13   132 140         14   32   272
283963 WI Dane   school 5503180 1316 Public school De Forest Area 550318002368 100 Holum Education Center   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   259                                             259
283964 WI Dane   school 5503180 1316 Public school De Forest Area 550318002368 100 Holum Education Center   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   13                                             13
284298 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002778 120 Main Street School   Special Education School No 1.0 PK PK 2016   pk_12_total 48.0 2.0 10.0     14.0         14.0   54.0 34.0             58     52   88 48 2 10     14         14   54 34         58   52   88
284299 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002778 120 Main Street School   Special Education School No 1.0 PK PK 2016   pre_kindergarten                                                   88                                             88
284341 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000423 200 Prairie Ridge Early Learning School   Regular School No 1.0 PK PK 2016   pk_12_total 581.0 16.0 38.0 6.0   92.0       1.0 45.0   376.0 403.0             308     60   779 581 16 38 6   92       1 45   376 403         308   60   779
284342 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000423 200 Prairie Ridge Early Learning School   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   779                                             779
284563 WI Pierce   school 5504320 1659 Public school Ellsworth Community 550432000466 80 Lindgren Early Learning Center   Regular School No 1.0 PK PK 2016   pk_12_total 128.0 1.0 2.0     1.0         2.0   75.0 59.0             28     17   134 128 1 2     1         2   75 59         28   17   134
284564 WI Pierce   school 5504320 1659 Public school Ellsworth Community 550432000466 80 Lindgren Early Learning Center   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   126                                             126
284565 WI Pierce   school 5504320 1659 Public school Ellsworth Community 550432000466 80 Lindgren Early Learning Center   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   8                                             8
284898 WI Jefferson   school 5504740 1883 Public school Fort Atkinson 550474002749 130 Fort Atkinson 4K   Regular School No 1.0 PK PK 2016   pk_12_total 127.0 1.0 13.0                   68.0 73.0             1     11   141 127 1 13                   68 73         1   11   141
284899 WI Jefferson   school 5504740 1883 Public school Fort Atkinson 550474002749 130 Fort Atkinson 4K   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   141                                             141
285719 WI Milwaukee   school 5505910 2296 Public school Greendale 550591003347 110 Time 4 Learning Charter School charter Regular School Yes 1.0 PK PK 2016   pk_12_total 74.0 1.0 11.0 1.0   7.0         6.0   56.0 44.0             22     12   100 74 1 11 1   7         6   56 44         22   12   100
285720 WI Milwaukee   school 5505910 2296 Public school Greendale 550591003347 110 Time 4 Learning Charter School charter Regular School Yes 1.0 PK PK 2016   kindergarten_4_year_old                                                   100                                             100
285827 WI Waukesha   school 5506030 2420 Public school Hamilton 550603002432 140 Willow Springs Learning Center   Regular School No 1.0 PK PK 2016   pk_12_total 232.0 6.0 9.0 2.0   8.0         9.0   139.0 127.0                   43   266 232 6 9 2   8         9   139 127             43   266
285828 WI Waukesha   school 5506030 2420 Public school Hamilton 550603002432 140 Willow Springs Learning Center   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   244                                             244
285829 WI Waukesha   school 5506030 2420 Public school Hamilton 550603002432 140 Willow Springs Learning Center   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   22                                             22
285890 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627002794 130 Hayward 4 Learning   Regular School No 1.0 PK PK 2016   pk_12_total 47.0 1.0 1.0 3.0                 24.0 28.0             18     4   52 47 1 1 3                 24 28         18   4   52
285891 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627002794 130 Hayward 4 Learning   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   52                                             52
286011 WI La Crosse   school 5506540 2562 Public school Holmen 550654000709 80 Holmen Public Preschool   Regular School No 1.0 PK PK 2016   pk_12_total 206.0 1.0 3.0     16.0         10.0   126.0 110.0             55     42   236 206 1 3     16         10   126 110         55   42   236
286012 WI La Crosse   school 5506540 2562 Public school Holmen 550654000709 80 Holmen Public Preschool   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   218                                             218
286013 WI La Crosse   school 5506540 2562 Public school Holmen 550654000709 80 Holmen Public Preschool   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   18                                             18
286068 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002848 150 Hortonville Area K4 School   Regular School No 1.0 PK PK 2016   pk_12_total 160.0 3.0 8.0 1.0   2.0         4.0   89.0 89.0             6     5   178 160 3 8 1   2         4   89 89         6   5   178
286069 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002848 150 Hortonville Area K4 School   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   178                                             178
286119 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002814 130 Howard and Suamico 4K Collaborative   Regular School No 1.0 PK PK 2016   pk_12_total 324.0 2.0 12.0 2.0   8.0         31.0   191.0 188.0                   36   379 324 2 12 2   8         31   191 188             36   379
286120 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002814 130 Howard and Suamico 4K Collaborative   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   379                                             379
286423 WI Rock   school 5507020 2695 Public school Janesville 550702002770 100 Preschool 4 Janesville   Regular School No 1.0 PK PK 2016   pk_12_total 377.0 22.0 51.0 3.0   9.0         43.0   259.0 246.0             131     21   505 377 22 51 3   9         43   259 246         131   21   505
286424 WI Rock   school 5507020 2695 Public school Janesville 550702002770 100 Preschool 4 Janesville   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   505                                             505
286623 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000811 250 Chavez Learning Station   Regular School No 1.0 PK PK 2016   pk_12_total 21.0 36.0 48.0     1.0         11.0   73.0 44.0             *     10   117 21 36 48     1         11   73 44             10   117
286624 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000811 250 Chavez Learning Station   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   75                                             75
286625 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000811 250 Chavez Learning Station   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   42                                             42
286735 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002779 105 Kenosha 4 Year Old Kindergarten   Regular School No 1.0 PK PK 2016   pk_12_total 59.0 19.0 30.0               11.0   58.0 61.0             55     7   119 59 19 30               11   58 61         55   7   119
286736 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002779 105 Kenosha 4 Year Old Kindergarten   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   119                                             119
286925 WI Waukesha   school 5503510 1376 Public school Kettle Moraine 550351002852 100 Kettle Moraine 4K   Regular School No 1.0 PK PK 2016   pk_12_total 102.0   13.0     4.0         6.0   60.0 65.0             8     7   125 102   13     4         6   60 65         8   7   125
286926 WI Waukesha   school 5503510 1376 Public school Kettle Moraine 550351002852 100 Kettle Moraine 4K   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   125                                             125
287059 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No 1.0 PK PK 2016   pk_12_total 290.0 1.0 7.0 1.0   3.0         11.0   149.0 164.0             40     44   313 290 1 7 1   3         11   149 164         40   44   313
287060 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   301                                             301
287061 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   12                                             12
287181 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002467 114 La Crosse Offsite Preschool   Regular School No 1.0 PK PK 2016   pk_12_total 106.0 2.0 4.0     3.0         10.0   67.0 58.0             27     4   125 106 2 4     3         10   67 58         27   4   125
287182 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002467 114 La Crosse Offsite Preschool   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   125                                             125
287529 WI Columbia   school 5508190 3150 Public school Lodi 550819002846 130 Lodi-4-Kids   Regular School No 1.0 PK PK 2016   pk_12_total 88.0   4.0 1.0   1.0         1.0   53.0 42.0             1     10   95 88   4 1   1         1   53 42         1   10   95
287530 WI Columbia   school 5508190 3150 Public school Lodi 550819002846 130 Lodi-4-Kids   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   95                                             95
287615 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No 1.0 PK PK 2016   pk_12_total 383.0 153.0 176.0     57.0         84.0   443.0 410.0             47     134   853 383 153 176     57         84   443 410         47   134   853
287616 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   766                                             766
287617 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   87                                             87
288195 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882002672 130 Marshfield K4   Regular School No 1.0 PK PK 2016   pk_12_total 204.0 2.0 12.0 1.0   7.0         8.0   126.0 108.0             50     7   234 204 2 12 1   7         8   126 108         50   7   234
288196 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882002672 130 Marshfield K4   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   234                                             234
288280 WI Dane   school 5508910 3381 Public school McFarland 550891002902 150 4K McFarland   Regular School No 1.0 PK PK 2016   pk_12_total 109.0   2.0     4.0         10.0   67.0 58.0             6     11   125 109   2     4         10   67 58         6   11   125
288281 WI Dane   school 5508910 3381 Public school McFarland 550891002902 150 4K McFarland   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   125                                             125
288534 WI Dunn   school 5509090 3444 Public school Menomonie Area 550909002940 150 School District of the Menomonie Area 4K   Regular School No 1.0 PK PK 2016   pk_12_total 209.0 4.0 7.0     13.0         6.0   137.0 102.0             18     19   239 209 4 7     13         6   137 102         18   19   239
288535 WI Dunn   school 5509090 3444 Public school Menomonie Area 550909002940 150 School District of the Menomonie Area 4K   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   239                                             239
288569 WI Ozaukee   school 5509130 3479 Public school Mequon-Thiensville 550913002992 150 Range Line Early Childhood   Regular School No 1.0 PK PK 2016   pk_12_total 23.0 3.0                     13.0 13.0                   12   26 23 3                     13 13             12   26
288570 WI Ozaukee   school 5509130 3479 Public school Mequon-Thiensville 550913002992 150 Range Line Early Childhood   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   17                                             17
288571 WI Ozaukee   school 5509130 3479 Public school Mequon-Thiensville 550913002992 150 Range Line Early Childhood   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   9                                             9
288643 WI Lincoln   school 5509210 3500 Public school Merrill Area 550921000746 240 Pine River School for Young Learners (PRSYL)   Regular School No 1.0 PK PK 2016   pk_12_total 183.0 1.0 6.0 1.0   1.0         9.0   99.0 102.0             110     36   201 183 1 6 1   1         9   99 102         110   36   201
288644 WI Lincoln   school 5509210 3500 Public school Merrill Area 550921000746 240 Pine River School for Young Learners (PRSYL)   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   157                                             157
288645 WI Lincoln   school 5509210 3500 Public school Merrill Area 550921000746 240 Pine River School for Young Learners (PRSYL)   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   44                                             44
288704 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002888 110 MCPASD 4K   Regular School No 1.0 PK PK 2016   pk_12_total 241.0 11.0 40.0     35.0         24.0   173.0 178.0                   23   351 241 11 40     35         24   173 178             23   351
288705 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002888 110 MCPASD 4K   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   351                                             351
290323 WI Buffalo   school 5509780 3668 Public school Mondovi 550978001284 20 Anthony Elementary   Regular School No 1.0 PK PK 2016   pk_12_total 55.0   8.0               4.0   36.0 31.0             25     20   67 55   8               4   36 31         25   20   67
290324 WI Buffalo   school 5509780 3668 Public school Mondovi 550978001284 20 Anthony Elementary   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   64                                             64
290325 WI Buffalo   school 5509780 3668 Public school Mondovi 550978001284 20 Anthony Elementary   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   3                                             3
290366 WI Dane   school 5509810 3675 Public school Monona Grove 550981002703 130 Together 4 Kids School   Regular School No 1.0 PK PK 2016   pk_12_total 67.0 2.0 3.0     1.0         5.0   41.0 37.0             14     4   78 67 2 3     1         5   41 37         14   4   78
290367 WI Dane   school 5509810 3675 Public school Monona Grove 550981002703 130 Together 4 Kids School   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   78                                             78
290490 WI Dane   school 5509990 3794 Public school Mount Horeb Area 550999002994 150 Mount Horeb Area Community 4K   Regular School No 1.0 PK PK 2016   pk_12_total 120.0 3.0 3.0                   66.0 60.0                   8   126 120 3 3                   66 60             8   126
290491 WI Dane   school 5509990 3794 Public school Mount Horeb Area 550999002994 150 Mount Horeb Area Community 4K   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   126                                             126
290526 WI Waukesha   school 5510060 3822 Public school Mukwonago 551006003024 140 District 4K   Regular School No 1.0 PK PK 2016   pk_12_total 170.0 1.0 13.0     1.0         6.0   101.0 90.0             12     16   191 170 1 13     1         6   101 90         12   16   191
290527 WI Waukesha   school 5510060 3822 Public school Mukwonago 551006003024 140 District 4K   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   191                                             191
290717 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032001354 280 Washington Early Learning Center   Regular School No 1.0 PK PK 2016   pk_12_total 314.0 6.0 22.0 1.0   10.0         7.0   200.0 160.0             87     86   360 314 6 22 1   10         7   200 160         87   86   360
290718 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032001354 280 Washington Early Learning Center   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   321                                             321
290719 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032001354 280 Washington Early Learning Center   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   39                                             39
290760 WI Wood   school 5510380 3906 Public school Nekoosa 551038003014 150 Nekoosa 4K   Regular School No 1.0 PK PK 2016   pk_12_total 61.0   8.0 2.0             5.0   41.0 35.0             21     11   76 61   8 2             5   41 35         21   11   76
290761 WI Wood   school 5510380 3906 Public school Nekoosa 551038003014 150 Nekoosa 4K   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   70                                             70
290762 WI Wood   school 5510380 3906 Public school Nekoosa 551038003014 150 Nekoosa 4K   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   6                                             6
290988 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062002757 150 NR4Kids Charter School charter Regular School Yes 1.0 PK PK 2016   pk_12_total 239.0 2.0 3.0     4.0         7.0   124.0 131.0             3     17   255 239 2 3     4         7   124 131         3   17   255
290989 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062002757 150 NR4Kids Charter School charter Regular School Yes 1.0 PK PK 2016   kindergarten_4_year_old                                                   255                                             255
291253 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083002659 160 Early Learning Academy   Regular School No 1.0 PK PK 2016   pk_12_total 184.0 7.0 35.0 1.0   28.0       1.0 9.0   131.0 134.0             26     22   265 184 7 35 1   28       1 9   131 134         26   22   265
291254 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083002659 160 Early Learning Academy   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   265                                             265

Next page

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]);