Data source: Big Local News · About: Big Local

103,197 rows where state = "WI" sorted by ccd_school_lvl descending

View and edit SQL

grade

year

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
3090836 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317001735 30 D C Everest Junior High   Regular School No Secondary 08 09 2018   pk_12_total 726.0 16.0 27.0 3.0   104.0         15.0   455.0 436.0             234     79   891 726 16 27 3   104         15   455 436         234   79   891
3090837 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317001735 30 D C Everest Junior High   Regular School No Secondary 08 09 2018   grade_8                                                   436                                             436
3090838 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317001735 30 D C Everest Junior High   Regular School No Secondary 08 09 2018   grade_9                                                   455                                             455
3096048 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003053 850 Daniel Webster Secondary School   Regular School No Secondary 06 11 2018   pk_12_total 1.0 83.0 2.0     1.0             47.0 40.0             75     7   87 1 83 2     1             47 40         75   7   87
3096049 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003053 850 Daniel Webster Secondary School   Regular School No Secondary 06 11 2018   grade_6                                                   30                                             30
3096050 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003053 850 Daniel Webster Secondary School   Regular School No Secondary 06 11 2018   grade_7                                                   16                                             16
3096051 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003053 850 Daniel Webster Secondary School   Regular School No Secondary 06 11 2018   grade_8                                                   41                                             41
3101077 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002810 220 Cardinal Heights Upper Middle   Regular School No Secondary 08 09 2018   pk_12_total 778.0 97.0 113.0     70.0         86.0   593.0 551.0             260     137   1144 778 97 113     70         86   593 551         260   137   1144
3101078 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002810 220 Cardinal Heights Upper Middle   Regular School No Secondary 08 09 2018   grade_8                                                   566                                             566
3101079 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002810 220 Cardinal Heights Upper Middle   Regular School No Secondary 08 09 2018   grade_9                                                   578                                             578
3103145 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002291 50 East Junior High   Regular School No Secondary 08 09 2018   pk_12_total 612.0 13.0 36.0 6.0   31.0         21.0   363.0 356.0             310     102   719 612 13 36 6   31         21   363 356         310   102   719
3103146 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002291 50 East Junior High   Regular School No Secondary 08 09 2018   grade_8                                                   366                                             366
3103147 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002291 50 East Junior High   Regular School No Secondary 08 09 2018   grade_9                                                   353                                             353
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
2320320 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317001735 30 D C Everest Junior High   Regular School No Secondary 08 09 2020   pk_12_total 629.0 14.0 47.0 4.0   122.0         21.0   442.0 395.0             308     91   837 629 14 47 4   122         21   442 395         308   91   837
2320321 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317001735 30 D C Everest Junior High   Regular School No Secondary 08 09 2020   grade_8                                                   429                                             429
2320322 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317001735 30 D C Everest Junior High   Regular School No Secondary 08 09 2020   grade_9                                                   408                                             408
2330647 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002810 220 Cardinal Heights Upper Middle   Regular School No Secondary 08 09 2020   pk_12_total 740.0 151.0 124.0 5.0   117.0       1.0 110.0   665.0 583.0             379     151   1248 740 151 124 5   117       1 110   665 583         379   151   1248
2330648 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002810 220 Cardinal Heights Upper Middle   Regular School No Secondary 08 09 2020   grade_8                                                   602                                             602
2330649 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002810 220 Cardinal Heights Upper Middle   Regular School No Secondary 08 09 2020   grade_9                                                   646                                             646
2335117 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317001735 30 D C Everest Junior High   Regular School No Secondary 08 09 2021   pk_12_total 634.0 19.0 60.0 5.0   120.0         33.0   455.0 416.0     37.0       342     87   871 634 19 60 5   120         33   455 416     37   342   87   871
2335118 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317001735 30 D C Everest Junior High   Regular School No Secondary 08 09 2021   grade_8                                                   444                                             444
2335119 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317001735 30 D C Everest Junior High   Regular School No Secondary 08 09 2021   grade_9                                                   427                                             427
2338509 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002887 250 La Crosse Polytechnic School charter Regular School Yes Secondary 06 11 2021   pk_12_total 88.0 5.0 1.0               9.0   58.0 45.0             47     4   103 88 5 1               9   58 45         47   4   103
2338510 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002887 250 La Crosse Polytechnic School charter Regular School Yes Secondary 06 11 2021   grade_10                                                   16                                             16
2338511 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002887 250 La Crosse Polytechnic School charter Regular School Yes Secondary 06 11 2021   grade_11                                                   13                                             13
2338512 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002887 250 La Crosse Polytechnic School charter Regular School Yes Secondary 06 11 2021   grade_6                                                   22                                             22
2338513 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002887 250 La Crosse Polytechnic School charter Regular School Yes Secondary 06 11 2021   grade_7                                                   17                                             17
2338514 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002887 250 La Crosse Polytechnic School charter Regular School Yes Secondary 06 11 2021   grade_8                                                   21                                             21
2338515 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002887 250 La Crosse Polytechnic School charter Regular School Yes Secondary 06 11 2021   grade_9                                                   14                                             14
3088902 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002976 165 Appleton Community 4K   Regular School No Prekindergarten PK PK 2018   pk_12_total 589.0 34.0 116.0 7.0   123.0       2.0 63.0   466.0 468.0             313     127   934 589 34 116 7   123       2 63   466 468         313   127   934
3088903 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002976 165 Appleton Community 4K   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   934                                             934
3089363 WI Sauk   school 5500810 280 Public school Baraboo 550081002803 150 Baraboo Early Learning Cooperative   Regular School No Prekindergarten PK PK 2018   pk_12_total 128.0 2.0 14.0 4.0   2.0         10.0   85.0 75.0             30     8   160 128 2 14 4   2         10   85 75         30   8   160
3089364 WI Sauk   school 5500810 280 Public school Baraboo 550081002803 150 Baraboo Early Learning Cooperative   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   160                                             160
3089365 WI Sauk   school 5500810 280 Public school Baraboo 550081002802 160 Baraboo Early Learning Cooperative Renewal Head Start of Baraboo   Regular School No Prekindergarten PK PK 2018   pk_12_total 10.0   5.0               1.0   8.0 8.0             10     1   16 10   5               1   8 8         10   1   16
3089366 WI Sauk   school 5500810 280 Public school Baraboo 550081002802 160 Baraboo Early Learning Cooperative Renewal Head Start of Baraboo   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   16                                             16
3089607 WI Rock   school 5501050 413 Public school Beloit 550105002855 150 Beloit Early Learning   Regular School No Prekindergarten PK PK 2018   pk_12_total 10.0 17.0 30.0               2.0   35.0 24.0             50     23   59 10 17 30               2   35 24         50   23   59
3089608 WI Rock   school 5501050 413 Public school Beloit 550105002855 150 Beloit Early Learning   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   42                                             42
3089609 WI Rock   school 5501050 413 Public school Beloit 550105002855 150 Beloit Early Learning   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                                                   17                                             17
3090067 WI Racine   school 5501890 777 Public school Burlington Area 550189002987 150 4K Community School   Regular School No Prekindergarten PK PK 2018   pk_12_total 33.0   4.0               2.0   24.0 15.0             10     5   39 33   4               2   24 15         10   5   39
3090068 WI Racine   school 5501890 777 Public school Burlington Area 550189002987 150 4K Community School   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   39                                             39
3090313 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002772 110 Early Learning Center   Special Education School No Prekindergarten PK PK 2018   pk_12_total 14.0                       10.0 4.0             1     *   14 14                       10 4         1       14
3090314 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002772 110 Early Learning Center   Special Education School No Prekindergarten PK PK 2018   pre_kindergarten                                                   13                                             13
3090315 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002772 110 Early Learning Center   Special Education School No Prekindergarten PK PK 2018   grade_unknown                                                   1                                             1
3090472 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255002784 100 Korger-Chestnut   Regular School No Prekindergarten PK PK 2018   pk_12_total 297.0 2.0 14.0 2.0   8.0       1.0 18.0   164.0 178.0             52     38   342 297 2 14 2   8       1 18   164 178         52   38   342
3090473 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255002784 100 Korger-Chestnut   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   333                                             333
3090474 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255002784 100 Korger-Chestnut   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                                                   9                                             9
3090560 WI Waupaca   school 5502670 1141 Public school Clintonville 550267000303 60 Dellwood Early Learning Center   Regular School No Prekindergarten PK PK 2018   pk_12_total 55.0 2.0 11.0 2.0             2.0   29.0 43.0             42     12   72 55 2 11 2             2   29 43         42   12   72
3090561 WI Waupaca   school 5502670 1141 Public school Clintonville 550267000303 60 Dellwood Early Learning Center   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   67                                             67
3090562 WI Waupaca   school 5502670 1141 Public school Clintonville 550267000303 60 Dellwood Early Learning Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                                                   5                                             5
3090602 WI Clark   school 5502730 1162 Public school Colby 550273000312 120 Little Stars Pre-School   Regular School No Prekindergarten PK PK 2018   pk_12_total 31.0   12.0 1.0             2.0   29.0 17.0             29     10   46 31   12 1             2   29 17         29   10   46
3090603 WI Clark   school 5502730 1162 Public school Colby 550273000312 120 Little Stars Pre-School   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   38                                             38
3090604 WI Clark   school 5502730 1162 Public school Colby 550273000312 120 Little Stars Pre-School   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                                                   8                                             8
3090822 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 2018   pk_12_total 320.0 4.0 27.0 1.0   25.0         7.0   204.0 180.0             59     30   384 320 4 27 1   25         7   204 180         59   30   384
3090823 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 2018   kindergarten_4_year_old                                                   384                                             384
3090942 WI Dane   school 5503180 1316 Public school De Forest Area 550318002368 100 Holum Education Center   Regular School No Prekindergarten PK PK 2018   pk_12_total 257.0 4.0 11.0 1.0   9.0         20.0   151.0 151.0             21     39   302 257 4 11 1   9         20   151 151         21   39   302
3090943 WI Dane   school 5503180 1316 Public school De Forest Area 550318002368 100 Holum Education Center   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   282                                             282
3090944 WI Dane   school 5503180 1316 Public school De Forest Area 550318002368 100 Holum Education Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                                                   20                                             20
3091231 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002778 120 Eau Claire Community Sites   Special Education School No Prekindergarten PK PK 2018   pk_12_total 452.0 3.0 29.0 1.0   37.0         37.0   272.0 287.0             22     65   559 452 3 29 1   37         37   272 287         22   65   559
3091232 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002778 120 Eau Claire Community Sites   Special Education School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   514                                             514
3091233 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002778 120 Eau Claire Community Sites   Special Education School No Prekindergarten PK PK 2018   pre_kindergarten                                                   45                                             45
3091305 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000423 200 Prairie Ridge Early Learning School   Regular School No Prekindergarten PK PK 2018   pk_12_total 210.0 13.0 33.0 2.0   64.0       1.0 18.0   190.0 151.0             226     40   341 210 13 33 2   64       1 18   190 151         226   40   341
3091306 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000423 200 Prairie Ridge Early Learning School   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   285                                             285
3091307 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000423 200 Prairie Ridge Early Learning School   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                                                   56                                             56
3091750 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 2018   pk_12_total 247.0 23.0 28.0     10.0         19.0   165.0 162.0             37     49   327 247 23 28     10         19   165 162         37   49   327
3091751 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 2018   kindergarten_4_year_old                                                   309                                             309
3091752 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 2018   pre_kindergarten                                                   18                                             18
3091862 WI Jefferson   school 5504740 1883 Public school Fort Atkinson 550474002749 130 Fort Atkinson 4K   Regular School No Prekindergarten PK PK 2018   pk_12_total 114.0 1.0 15.0     1.0             60.0 71.0             7         131 114 1 15     1             60 71         7       131
3091863 WI Jefferson   school 5504740 1883 Public school Fort Atkinson 550474002749 130 Fort Atkinson 4K   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   131                                             131
3092671 WI Milwaukee   school 5505910 2296 Public school Greendale 550591003347 110 Time 4 Learning Charter School charter Regular School Yes Prekindergarten PK PK 2018   pk_12_total 71.0 7.0 10.0 1.0   9.0         3.0   59.0 42.0             29     14   101 71 7 10 1   9         3   59 42         29   14   101
3092672 WI Milwaukee   school 5505910 2296 Public school Greendale 550591003347 110 Time 4 Learning Charter School charter Regular School Yes Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   101                                             101
3092779 WI Waukesha   school 5506030 2420 Public school Hamilton 550603002432 140 Willow Springs Learning Center   Regular School No Prekindergarten PK PK 2018   pk_12_total 218.0 3.0 13.0 1.0   14.0       1.0 8.0   141.0 117.0             31     37   258 218 3 13 1   14       1 8   141 117         31   37   258
3092780 WI Waukesha   school 5506030 2420 Public school Hamilton 550603002432 140 Willow Springs Learning Center   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   245                                             245
3092781 WI Waukesha   school 5506030 2420 Public school Hamilton 550603002432 140 Willow Springs Learning Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                                                   13                                             13
3092841 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627002794 130 Hayward 4 Learning   Regular School No Prekindergarten PK PK 2018   pk_12_total 46.0   3.0 11.0             3.0   32.0 31.0             1     6   63 46   3 11             3   32 31         1   6   63
3092842 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627002794 130 Hayward 4 Learning   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   63                                             63
3092963 WI La Crosse   school 5506540 2562 Public school Holmen 550654000709 80 Holmen Public Preschool   Regular School No Prekindergarten PK PK 2018   pk_12_total 178.0 1.0 2.0     17.0         10.0   115.0 93.0             49     27   208 178 1 2     17         10   115 93         49   27   208
3092964 WI La Crosse   school 5506540 2562 Public school Holmen 550654000709 80 Holmen Public Preschool   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   191                                             191
3092965 WI La Crosse   school 5506540 2562 Public school Holmen 550654000709 80 Holmen Public Preschool   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                                                   17                                             17
3093021 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002848 150 Hortonville Area K4 School   Regular School No Prekindergarten PK PK 2018   pk_12_total 152.0 1.0 9.0     1.0         4.0   78.0 89.0             14     10   167 152 1 9     1         4   78 89         14   10   167
3093022 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002848 150 Hortonville Area K4 School   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   167                                             167
3093069 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002814 130 Howard and Suamico 4K Collaborative   Regular School No Prekindergarten PK PK 2018   pk_12_total 316.0 1.0 17.0 3.0   8.0         16.0   205.0 156.0             1     29   361 316 1 17 3   8         16   205 156         1   29   361
3093070 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002814 130 Howard and Suamico 4K Collaborative   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   361                                             361
3093117 WI Saint Croix   school 5506690 2611 Public school Hudson 550669003069 190 Hudson 4K   Regular School No Prekindergarten PK PK 2018   pk_12_total 264.0 1.0 16.0     5.0         14.0   157.0 143.0             2     32   300 264 1 16     5         14   157 143         2   32   300

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