Data source: Big Local News · About: Big Local

14,749 rows where state = "WI" and year = 2019 sorted by ccd_school_lvl descending

View and edit SQL

year

  • 2019 · 14,749
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
3075424 WI Dane   school 5502100 896 Public school Cambridge 550210003093 400 Koshkonong Trails School charter Regular School Yes Secondary 07 10 2019   pk_12_total 12.0                       7.0 5.0             4     3   12 12                       7 5         4   3   12
3075425 WI Dane   school 5502100 896 Public school Cambridge 550210003093 400 Koshkonong Trails School charter Regular School Yes Secondary 07 10 2019   grade_10                                                   2                                             2
3075426 WI Dane   school 5502100 896 Public school Cambridge 550210003093 400 Koshkonong Trails School charter Regular School Yes Secondary 07 10 2019   grade_7                                                   3                                             3
3075427 WI Dane   school 5502100 896 Public school Cambridge 550210003093 400 Koshkonong Trails School charter Regular School Yes Secondary 07 10 2019   grade_8                                                   7                                             7
3076095 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317001735 30 D C Everest Junior High   Regular School No Secondary 08 09 2019   pk_12_total 671.0 14.0 32.0 3.0   115.0         19.0   449.0 405.0             255     86   854 671 14 32 3   115         19   449 405         255   86   854
3076096 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317001735 30 D C Everest Junior High   Regular School No Secondary 08 09 2019   grade_8                                                   411                                             411
3076097 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317001735 30 D C Everest Junior High   Regular School No Secondary 08 09 2019   grade_9                                                   443                                             443
3077019 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468002966 210 Fond du Lac STEM Institute charter Regular School Yes Secondary 06 11 2019   pk_12_total 115.0 8.0 10.0               6.0   83.0 56.0             59     16   139 115 8 10               6   83 56         59   16   139
3077020 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468002966 210 Fond du Lac STEM Institute charter Regular School Yes Secondary 06 11 2019   grade_10                                                   16                                             16
3077021 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468002966 210 Fond du Lac STEM Institute charter Regular School Yes Secondary 06 11 2019   grade_11                                                   12                                             12
3077022 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468002966 210 Fond du Lac STEM Institute charter Regular School Yes Secondary 06 11 2019   grade_6                                                   36                                             36
3077023 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468002966 210 Fond du Lac STEM Institute charter Regular School Yes Secondary 06 11 2019   grade_7                                                   26                                             26
3077024 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468002966 210 Fond du Lac STEM Institute charter Regular School Yes Secondary 06 11 2019   grade_8                                                   29                                             29
3077025 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468002966 210 Fond du Lac STEM Institute charter Regular School Yes Secondary 06 11 2019   grade_9                                                   20                                             20
3086353 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002810 220 Cardinal Heights Upper Middle   Regular School No Secondary 08 09 2019   pk_12_total 790.0 124.0 115.0 2.0   98.0         100.0   644.0 585.0             325     134   1229 790 124 115 2   98         100   644 585         325   134   1229
3086354 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002810 220 Cardinal Heights Upper Middle   Regular School No Secondary 08 09 2019   grade_8                                                   631                                             631
3086355 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002810 220 Cardinal Heights Upper Middle   Regular School No Secondary 08 09 2019   grade_9                                                   598                                             598
3074146 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002976 165 Appleton Community 4K   Regular School No Prekindergarten PK PK 2019   pk_12_total 625.0 36.0 99.0 3.0   106.0       2.0 62.0   467.0 466.0             404     121   933 625 36 99 3   106       2 62   467 466         404   121   933
3074147 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002976 165 Appleton Community 4K   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   933                                             933
3074607 WI Sauk   school 5500810 280 Public school Baraboo 550081002803 150 Baraboo Early Learning Cooperative   Regular School No Prekindergarten PK PK 2019   pk_12_total 123.0 1.0 10.0 1.0   2.0         5.0   80.0 62.0             34     28   142 123 1 10 1   2         5   80 62         34   28   142
3074608 WI Sauk   school 5500810 280 Public school Baraboo 550081002803 150 Baraboo Early Learning Cooperative   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   142                                             142
3074609 WI Sauk   school 5500810 280 Public school Baraboo 550081002802 160 Baraboo Early Learning Cooperative RHS Renewal Head Start of Baraboo   Regular School No Prekindergarten PK PK 2019   pk_12_total 13.0 1.0 2.0               1.0   11.0 6.0             8     4   17 13 1 2               1   11 6         8   4   17
3074610 WI Sauk   school 5500810 280 Public school Baraboo 550081002802 160 Baraboo Early Learning Cooperative RHS Renewal Head Start of Baraboo   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   17                                             17
3074737 WI Dodge   school 5500960 336 Public school Beaver Dam Unified 550096003082 150 BDUSD4Kids   Regular School No Prekindergarten PK PK 2019   pk_12_total 152.0 2.0 35.0 1.0   1.0         8.0   104.0 95.0             97     26   199 152 2 35 1   1         8   104 95         97   26   199
3074738 WI Dodge   school 5500960 336 Public school Beaver Dam Unified 550096003082 150 BDUSD4Kids   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   199                                             199
3074854 WI Rock   school 5501050 413 Public school Beloit 550105002855 150 Beloit Early Learning   Regular School No Prekindergarten PK PK 2019   pk_12_total 16.0 11.0 20.0               3.0   33.0 17.0             36     14   50 16 11 20               3   33 17         36   14   50
3074855 WI Rock   school 5501050 413 Public school Beloit 550105002855 150 Beloit Early Learning   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   41                                             41
3074856 WI Rock   school 5501050 413 Public school Beloit 550105002855 150 Beloit Early Learning   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   9                                             9
3075303 WI Racine   school 5501890 777 Public school Burlington Area 550189002987 150 4K Community School   Regular School No Prekindergarten PK PK 2019   pk_12_total 35.0 1.0 7.0     1.0         2.0   22.0 24.0             18     6   46 35 1 7     1         2   22 24         18   6   46
3075304 WI Racine   school 5501890 777 Public school Burlington Area 550189002987 150 4K Community School   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   46                                             46
3075563 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002772 110 Early Learning Center   Special Education School No Prekindergarten PK PK 2019   pk_12_total 8.0                       4.0 4.0                   *   8 8                       4 4                 8
3075564 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002772 110 Early Learning Center   Special Education School No Prekindergarten PK PK 2019   pre_kindergarten                                                   8                                             8
3075722 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255002784 100 Korger-Chestnut   Regular School No Prekindergarten PK PK 2019   pk_12_total 331.0 2.0 9.0 2.0   11.0         11.0   174.0 192.0             63     36   366 331 2 9 2   11         11   174 192         63   36   366
3075723 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255002784 100 Korger-Chestnut   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   356                                             356
3075724 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255002784 100 Korger-Chestnut   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   10                                             10
3075810 WI Waupaca   school 5502670 1141 Public school Clintonville 550267000303 60 Dellwood Early Learning Center   Regular School No Prekindergarten PK PK 2019   pk_12_total 61.0 3.0 2.0 1.0                 38.0 29.0             32     18   67 61 3 2 1                 38 29         32   18   67
3075811 WI Waupaca   school 5502670 1141 Public school Clintonville 550267000303 60 Dellwood Early Learning Center   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   55                                             55
3075812 WI Waupaca   school 5502670 1141 Public school Clintonville 550267000303 60 Dellwood Early Learning Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   12                                             12
3075851 WI Clark   school 5502730 1162 Public school Colby 550273000312 120 Little Stars Pre-School   Regular School No Prekindergarten PK PK 2019   pk_12_total 37.0   9.0                   22.0 24.0             24     6   46 37   9                   22 24         24   6   46
3075852 WI Clark   school 5502730 1162 Public school Colby 550273000312 120 Little Stars Pre-School   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   46                                             46
3076081 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317002963 190 D C Everest 4K Community Partnership   Regular School No Prekindergarten PK PK 2019   pk_12_total 288.0 6.0 22.0 1.0   33.0       1.0 9.0   172.0 188.0             53     28   360 288 6 22 1   33       1 9   172 188         53   28   360
3076082 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317002963 190 D C Everest 4K Community Partnership   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   360                                             360
3076201 WI Dane   school 5503180 1316 Public school De Forest Area 550318002368 100 Holum Education Center   Regular School No Prekindergarten PK PK 2019   pk_12_total 265.0 2.0 11.0 2.0   10.0         18.0   157.0 151.0             24     36   308 265 2 11 2   10         18   157 151         24   36   308
3076202 WI Dane   school 5503180 1316 Public school De Forest Area 550318002368 100 Holum Education Center   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   295                                             295
3076203 WI Dane   school 5503180 1316 Public school De Forest Area 550318002368 100 Holum Education Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   13                                             13
3076485 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002778 120 Eau Claire Community Sites   Special Education School No Prekindergarten PK PK 2019   pk_12_total 440.0 14.0 20.0 1.0   24.0       1.0 35.0   282.0 253.0             13     68   535 440 14 20 1   24       1 35   282 253         13   68   535
3076486 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002778 120 Eau Claire Community Sites   Special Education School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   484                                             484
3076487 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002778 120 Eau Claire Community Sites   Special Education School No Prekindergarten PK PK 2019   pre_kindergarten                                                   51                                             51
3076559 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000423 200 Prairie Ridge Early Learning School   Regular School No Prekindergarten PK PK 2019   pk_12_total 199.0 15.0 32.0 4.0   57.0       2.0 21.0   167.0 163.0             233     42   330 199 15 32 4   57       2 21   167 163         233   42   330
3076560 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000423 200 Prairie Ridge Early Learning School   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   271                                             271
3076561 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000423 200 Prairie Ridge Early Learning School   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   59                                             59
3076998 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468003042 130 Early Learning in Fond du Lac   Regular School No Prekindergarten PK PK 2019   pk_12_total 229.0 35.0 33.0 1.0   5.0       1.0 9.0   171.0 142.0             30     49   313 229 35 33 1   5       1 9   171 142         30   49   313
3076999 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468003042 130 Early Learning in Fond du Lac   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   295                                             295
3077000 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468003042 130 Early Learning in Fond du Lac   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   18                                             18
3077113 WI Jefferson   school 5504740 1883 Public school Fort Atkinson 550474002749 130 Fort Atkinson 4K   Regular School No Prekindergarten PK PK 2019   pk_12_total 108.0 1.0 19.0     3.0         5.0   73.0 63.0             27     10   136 108 1 19     3         5   73 63         27   10   136
3077114 WI Jefferson   school 5504740 1883 Public school Fort Atkinson 550474002749 130 Fort Atkinson 4K   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   136                                             136
3077649 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002589 110 Green Bay Head Start   Regular School No Prekindergarten PK PK 2019   pk_12_total 42.0 31.0 92.0 7.0   16.0         22.0   115.0 95.0             *     34   210 42 31 92 7   16         22   115 95             34   210
3077650 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002589 110 Green Bay Head Start   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   127                                             127
3077651 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002589 110 Green Bay Head Start   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   83                                             83
3077896 WI Milwaukee   school 5505910 2296 Public school Greendale 550591003347 110 Time 4 Learning Charter School charter Regular School Yes Prekindergarten PK PK 2019   pk_12_total 88.0 1.0 11.0     6.0         7.0   62.0 51.0             34     20   113 88 1 11     6         7   62 51         34   20   113
3077897 WI Milwaukee   school 5505910 2296 Public school Greendale 550591003347 110 Time 4 Learning Charter School charter Regular School Yes Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   113                                             113
3078003 WI Waukesha   school 5506030 2420 Public school Hamilton 550603002432 140 Willow Springs Learning Center   Regular School No Prekindergarten PK PK 2019   pk_12_total 218.0 6.0 18.0     21.0       1.0 12.0   140.0 136.0             37     35   276 218 6 18     21       1 12   140 136         37   35   276
3078004 WI Waukesha   school 5506030 2420 Public school Hamilton 550603002432 140 Willow Springs Learning Center   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   259                                             259
3078005 WI Waukesha   school 5506030 2420 Public school Hamilton 550603002432 140 Willow Springs Learning Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   17                                             17
3078066 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627002794 130 Hayward 4 Learning   Regular School No Prekindergarten PK PK 2019   pk_12_total 44.0   2.0 6.0                 27.0 25.0             7     5   52 44   2 6                 27 25         7   5   52
3078067 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627002794 130 Hayward 4 Learning   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   52                                             52
3078190 WI La Crosse   school 5506540 2562 Public school Holmen 550654000709 80 Holmen Public Preschool   Regular School No Prekindergarten PK PK 2019   pk_12_total 199.0 3.0 6.0 1.0   17.0         10.0   126.0 110.0             60     39   236 199 3 6 1   17         10   126 110         60   39   236
3078191 WI La Crosse   school 5506540 2562 Public school Holmen 550654000709 80 Holmen Public Preschool   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   211                                             211
3078192 WI La Crosse   school 5506540 2562 Public school Holmen 550654000709 80 Holmen Public Preschool   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   25                                             25
3078261 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002848 150 Hortonville Area K4 School   Regular School No Prekindergarten PK PK 2019   pk_12_total 120.0 2.0 4.0 1.0   2.0         1.0   63.0 67.0             12     2   130 120 2 4 1   2         1   63 67         12   2   130
3078262 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002848 150 Hortonville Area K4 School   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   130                                             130
3078310 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002814 130 Howard and Suamico 4K Collaborative   Regular School No Prekindergarten PK PK 2019   pk_12_total 308.0 2.0 9.0 2.0   2.0         21.0   179.0 165.0             65     40   344 308 2 9 2   2         21   179 165         65   40   344
3078311 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002814 130 Howard and Suamico 4K Collaborative   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   344                                             344
3078359 WI Saint Croix   school 5506690 2611 Public school Hudson 550669003069 190 Hudson 4K   Regular School No Prekindergarten PK PK 2019   pk_12_total 289.0 4.0 9.0 1.0   7.0         10.0   175.0 145.0             1     26   320 289 4 9 1   7         10   175 145         1   26   320
3078360 WI Saint Croix   school 5506690 2611 Public school Hudson 550669003069 190 Hudson 4K   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   320                                             320
3078621 WI Rock   school 5507020 2695 Public school Janesville 550702002770 100 Preschool 4 Janesville   Regular School No Prekindergarten PK PK 2019   pk_12_total 372.0 31.0 70.0 1.0   3.0         48.0   269.0 256.0             108     19   525 372 31 70 1   3         48   269 256         108   19   525
3078622 WI Rock   school 5507020 2695 Public school Janesville 550702002770 100 Preschool 4 Janesville   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   525                                             525
3078824 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000811 250 Chavez Learning Station   Regular School No Prekindergarten PK PK 2019   pk_12_total 27.0 62.0 60.0 1.0   1.0         13.0   93.0 71.0             *     19   164 27 62 60 1   1         13   93 71             19   164
3078825 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000811 250 Chavez Learning Station   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   84                                             84
3078826 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000811 250 Chavez Learning Station   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   80                                             80
3078936 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002779 105 Kenosha 4 Year Old Kindergarten   Regular School No Prekindergarten PK PK 2019   pk_12_total 66.0 10.0 16.0 1.0   1.0         15.0   59.0 50.0             3     6   109 66 10 16 1   1         15   59 50         3   6   109
3078937 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002779 105 Kenosha 4 Year Old Kindergarten   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   109                                             109
3079121 WI Waukesha   school 5503510 1376 Public school Kettle Moraine 550351002852 100 Kettle Moraine 4K   Regular School No Prekindergarten PK PK 2019   pk_12_total 75.0   6.0               2.0   39.0 44.0             6     4   83 75   6               2   39 44         6   4   83
3079122 WI Waukesha   school 5503510 1376 Public school Kettle Moraine 550351002852 100 Kettle Moraine 4K   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   83                                             83
3079261 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Prekindergarten PK PK 2019   pk_12_total 293.0 6.0 14.0 1.0   7.0         12.0   183.0 150.0             57     40   333 293 6 14 1   7         12   183 150         57   40   333
3079262 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   314                                             314
3079263 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   19                                             19
3079377 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002467 114 La Crosse Offsite Preschool   Regular School No Prekindergarten PK PK 2019   pk_12_total 99.0 1.0 4.0     2.0         4.0   47.0 63.0             20     5   110 99 1 4     2         4   47 63         20   5   110
3079378 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002467 114 La Crosse Offsite Preschool   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   110                                             110
3079826 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No Prekindergarten PK PK 2019   pk_12_total 365.0 144.0 162.0     59.0         81.0   410.0 401.0             366     134   811 365 144 162     59         81   410 401         366   134   811
3079827 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   716                                             716
3079828 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                                                   95                                             95
3080407 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882002672 130 Marshfield K4   Regular School No Prekindergarten PK PK 2019   pk_12_total 188.0 3.0 12.0     7.0         3.0   111.0 102.0             40     24   213 188 3 12     7         3   111 102         40   24   213
3080408 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882002672 130 Marshfield K4   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   213                                             213
3080507 WI Dane   school 5508910 3381 Public school McFarland 550891002902 150 4K McFarland   Regular School No Prekindergarten PK PK 2019   pk_12_total 135.0 2.0 2.0     13.0         10.0   82.0 80.0             31     15   162 135 2 2     13         10   82 80         31   15   162
3080508 WI Dane   school 5508910 3381 Public school McFarland 550891002902 150 4K McFarland   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   162                                             162
3080761 WI Dunn   school 5509090 3444 Public school Menomonie Area 550909002940 150 School District of the Menomonie Area 4K   Regular School No Prekindergarten PK PK 2019   pk_12_total 214.0 3.0 6.0 1.0   19.0         15.0   131.0 127.0             101     17   258 214 3 6 1   19         15   131 127         101   17   258
3080762 WI Dunn   school 5509090 3444 Public school Menomonie Area 550909002940 150 School District of the Menomonie Area 4K   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   258                                             258
3080798 WI Ozaukee   school 5509130 3479 Public school Mequon-Thiensville 550913002992 150 Range Line Early Childhood   Regular School No Prekindergarten PK PK 2019   pk_12_total 12.0   1.0               1.0   10.0 4.0                       14 12   1               1   10 4                 14
3080799 WI Ozaukee   school 5509130 3479 Public school Mequon-Thiensville 550913002992 150 Range Line Early Childhood   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   14                                             14

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