Data source: Big Local News · About: Big Local

103,197 rows where state = "WI" sorted by ccd_school_high_grade 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
122249 WI Pierce   school 5512240 4578 Public school Prescott 551224002762 100 Prescott 4K   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   94                                             94
122326 WI Racine   school 5512360 4620 Public school Racine Unified 551236002657 113 All District 4 Year Old Kindergarten   Regular School No 1.0 PK PK 2015   pk_12_total 161.0 80.0 63.0 1.0   4.0       1.0 15.0   146.0 179.0             71     17   325 161 80 63 1   4       1 15   146 179         71   17   325
122327 WI Racine   school 5512360 4620 Public school Racine Unified 551236002657 113 All District 4 Year Old Kindergarten   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   324                                             324
122328 WI Racine   school 5512360 4620 Public school Racine Unified 551236002657 113 All District 4 Year Old Kindergarten   Regular School No 1.0 PK PK 2015   pre_kindergarten                                                   1                                             1
122482 WI Racine   school 5512360 4620 Public school Racine Unified 551236000458 172 P-COC   Regular School No 1.0 PK PK 2015   pk_12_total 53.0 16.0 18.0     3.0       1.0 2.0   55.0 38.0             45     6   93 53 16 18     3       1 2   55 38         45   6   93
122483 WI Racine   school 5512360 4620 Public school Racine Unified 551236000458 172 P-COC   Regular School No 1.0 PK PK 2015   pre_kindergarten                                                   93                                             93
122497 WI Racine   school 5512360 4620 Public school Racine Unified 551236002708 114 Racine Early Education Center   Regular School No 1.0 PK PK 2015   pk_12_total 37.0 41.0 37.0 1.0             6.0   83.0 39.0             86     51   122 37 41 37 1             6   83 39         86   51   122
122498 WI Racine   school 5512360 4620 Public school Racine Unified 551236002708 114 Racine Early Education Center   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   106                                             106
122499 WI Racine   school 5512360 4620 Public school Racine Unified 551236002708 114 Racine Early Education Center   Regular School No 1.0 PK PK 2015   pre_kindergarten                                                   16                                             16
122623 WI Sauk   school 5512660 4753 Public school Reedsburg 551266002889 150 4K Community-Based   Regular School No 1.0 PK PK 2015   pk_12_total 72.0   7.0               1.0   41.0 39.0             31     8   80 72   7               1   41 39         31   8   80
122624 WI Sauk   school 5512660 4753 Public school Reedsburg 551266002889 150 4K Community-Based   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   80                                             80
122754 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281002528 150 Head Start   Regular School No 1.0 PK PK 2015   pk_12_total 24.0   3.0 2.0             1.0   17.0 13.0             22     3   30 24   3 2             1   17 13         22   3   30
122755 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281002528 150 Head Start   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   30                                             30
122756 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281002526 110 Hilltop Day Care & Preschool   Regular School No 1.0 PK PK 2015   pk_12_total 19.0   1.0                   11.0 9.0             4     1   20 19   1                   11 9         4   1   20
122757 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281002526 110 Hilltop Day Care & Preschool   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   20                                             20
122921 WI Pierce   school 5513050 4893 Public school River Falls 551305002924 130 River Falls 4 Children   Regular School No 1.0 PK PK 2015   pk_12_total 156.0 4.0 1.0               5.0   85.0 81.0             24     9   166 156 4 1               5   85 81         24   9   166
122922 WI Pierce   school 5513050 4893 Public school River Falls 551305002924 130 River Falls 4 Children   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   166                                             166
123288 WI Door   school 5513500 5130 Public school Sevastopol 551350000229 10 Sevastopol Pre-School   Regular School No 1.0 PK PK 2015   pk_12_total 40.0   2.0     1.0             22.0 21.0             17     5   43 40   2     1             22 21         17   5   43
123289 WI Door   school 5513500 5130 Public school Sevastopol 551350000229 10 Sevastopol Pre-School   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   43                                             43
123374 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365002423 93 Early Learning Center   Regular School No 1.0 PK PK 2015   pk_12_total 289.0 19.0 125.0 1.0   100.0         34.0   304.0 264.0             233     100   568 289 19 125 1   100         34   304 264         233   100   568
123375 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365002423 93 Early Learning Center   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   516                                             516
123376 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365002423 93 Early Learning Center   Regular School No 1.0 PK PK 2015   pre_kindergarten                                                   52                                             52
123851 WI Monroe   school 5514160 5460 Public school Sparta Area 551416002465 130 Sparta Charter Prekindergarten charter Regular School Yes 1.0 PK PK 2015   pk_12_total 144.0 2.0 29.0 2.0             5.0   96.0 86.0             101     32   182 144 2 29 2             5   96 86         101   32   182
123852 WI Monroe   school 5514160 5460 Public school Sparta Area 551416002465 130 Sparta Charter Prekindergarten charter Regular School Yes 1.0 PK PK 2015   kindergarten_4_year_old                                                   162                                             162
123853 WI Monroe   school 5514160 5460 Public school Sparta Area 551416002465 130 Sparta Charter Prekindergarten charter Regular School Yes 1.0 PK PK 2015   pre_kindergarten                                                   20                                             20
123898 WI Washburn   school 5514220 5474 Public school Spooner Area 551422002956 120 Little Rails Early Learning   Regular School No 1.0 PK PK 2015   pk_12_total 49.0 2.0 2.0     1.0         2.0   21.0 35.0             32     10   56 49 2 2     1         2   21 35         32   10   56
123899 WI Washburn   school 5514220 5474 Public school Spooner Area 551422002956 120 Little Rails Early Learning   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   49                                             49
123900 WI Washburn   school 5514220 5474 Public school Spooner Area 551422002956 120 Little Rails Early Learning   Regular School No 1.0 PK PK 2015   pre_kindergarten                                                   7                                             7
123948 WI Chippewa   school 5514430 5593 Public school Stanley-Boyd Area 551443001864 20 Boyd Elementary   Regular School No 1.0 PK PK 2015   pk_12_total 90.0                   4.0   46.0 48.0             52     15   94 90                   4   46 48         52   15   94
123949 WI Chippewa   school 5514430 5593 Public school Stanley-Boyd Area 551443001864 20 Boyd Elementary   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   85                                             85
123950 WI Chippewa   school 5514430 5593 Public school Stanley-Boyd Area 551443001864 20 Boyd Elementary   Regular School No 1.0 PK PK 2015   pre_kindergarten                                                   9                                             9
124043 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449002739 110 Point 4 the Future   Regular School No 1.0 PK PK 2015   pk_12_total 430.0 8.0 33.0 1.0   40.0         28.0   290.0 250.0             167     35   540 430 8 33 1   40         28   290 250         167   35   540
124044 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449002739 110 Point 4 the Future   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   540                                             540
124045 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001145 350 Preschool Options   Special Education School No 1.0 PK PK 2015   pk_12_total 1.0     1.0                 1.0 1.0             *     *   2 1     1                 1 1                 2
124046 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001145 350 Preschool Options   Special Education School No 1.0 PK PK 2015   pre_kindergarten                                                   2                                             2
124252 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002761 190 Sun Prairie Four Kids   Regular School No 1.0 PK PK 2015   pk_12_total 314.0 41.0 35.0 3.0   46.0         34.0   249.0 224.0                   34   473 314 41 35 3   46         34   249 224             34   473
124253 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002761 190 Sun Prairie Four Kids   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   473                                             473
124316 WI Douglas   school 5514670 5663 Public school Superior 551467002811 130 Superior Community Preschool   Regular School No 1.0 PK PK 2015   pk_12_total 210.0 6.0 1.0 1.0   1.0         16.0   105.0 130.0             3     45   235 210 6 1 1   1         16   105 130         3   45   235
124317 WI Douglas   school 5514670 5663 Public school Superior 551467002811 130 Superior Community Preschool   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   214                                             214
124318 WI Douglas   school 5514670 5663 Public school Superior 551467002811 130 Superior Community Preschool   Regular School No 1.0 PK PK 2015   pre_kindergarten                                                   21                                             21
124461 WI Monroe   school 5514910 5747 Public school Tomah Area 551491002797 120 Timber PUPS Learning Center   Regular School No 1.0 PK PK 2015   pk_12_total 103.0 5.0 6.0 3.0   1.0         5.0   64.0 59.0             59     25   123 103 5 6 3   1         5   64 59         59   25   123
124462 WI Monroe   school 5514910 5747 Public school Tomah Area 551491002797 120 Timber PUPS Learning Center   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   113                                             113
124463 WI Monroe   school 5514910 5747 Public school Tomah Area 551491002797 120 Timber PUPS Learning Center   Regular School No 1.0 PK PK 2015   pre_kindergarten                                                   10                                             10
124714 WI Dane   school 5515330 5901 Public school Verona Area 551533002285 110 Early Childhood   Regular School No 1.0 PK PK 2015   pk_12_total 12.0 1.0 6.0                   13.0 6.0             3     *   19 12 1 6                   13 6         3       19
124715 WI Dane   school 5515330 5901 Public school Verona Area 551533002285 110 Early Childhood   Regular School No 1.0 PK PK 2015   pre_kindergarten                                                   19                                             19
124765 WI Dane   school 5515330 5901 Public school Verona Area 551533002890 160 Verona Area K4   Regular School No 1.0 PK PK 2015   pk_12_total 225.0 16.0 48.0     14.0         7.0   155.0 155.0             31     15   310 225 16 48     14         7   155 155         31   15   310
124766 WI Dane   school 5515330 5901 Public school Verona Area 551533002890 160 Verona Area K4   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   310                                             310
124959 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575002661 110 Watertown 4 Kids   Regular School No 1.0 PK PK 2015   pk_12_total 160.0 7.0 30.0     1.0         9.0   100.0 107.0             7     28   207 160 7 30     1         9   100 107         7   28   207
124960 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575002661 110 Watertown 4 Kids   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   207                                             207
125102 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002926 110 Waukesha Early Learning Center   Regular School No 1.0 PK PK 2015   pk_12_total 536.0 47.0 181.0 1.0   53.0       1.0 4.0   400.0 423.0             213     185   823 536 47 181 1   53       1 4   400 423         213   185   823
125103 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002926 110 Waukesha Early Learning Center   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   720                                             720
125104 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002926 110 Waukesha Early Learning Center   Regular School No 1.0 PK PK 2015   pre_kindergarten                                                   103                                             103
125140 WI Dane   school 5515810 6181 Public school Waunakee Community 551581002869 150 Waunakee Community 4K School   Regular School No 1.0 PK PK 2015   pk_12_total 220.0 4.0 7.0     2.0         7.0   113.0 127.0             3     8   240 220 4 7     2         7   113 127         3   8   240
125141 WI Dane   school 5515810 6181 Public school Waunakee Community 551581002869 150 Waunakee Community 4K School   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   240                                             240
125171 WI Waupaca   school 5515840 6195 Public school Waupaca 551584003007 170 Waupaca Community 4-Year Old Kindergarten   Regular School No 1.0 PK PK 2015   pk_12_total 119.0 2.0 4.0     2.0         1.0   61.0 67.0             29     20   128 119 2 4     2         1   61 67         29   20   128
125172 WI Waupaca   school 5515840 6195 Public school Waupaca 551584003007 170 Waupaca Community 4-Year Old Kindergarten   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   128                                             128
125745 WI Washington   school 5516290 6307 Public school West Bend 551629002912 110 Rolf's Early Childhood Center   Special Education School No 1.0 PK PK 2015   pk_12_total 89.0 1.0 8.0     1.0         5.0   71.0 33.0             2     *   104 89 1 8     1         5   71 33         2       104
125746 WI Washington   school 5516290 6307 Public school West Bend 551629002912 110 Rolf's Early Childhood Center   Special Education School No 1.0 PK PK 2015   pre_kindergarten                                                   104                                             104
125750 WI Washington   school 5516290 6307 Public school West Bend 551629002133 180 Washington County Head Start & West Bend Title I   Regular School No 1.0 PK PK 2015   pk_12_total 123.0 8.0 3.0 1.0             3.0   64.0 74.0                   3   138 123 8 3 1             3   64 74             3   138
125751 WI Washington   school 5516290 6307 Public school West Bend 551629002133 180 Washington County Head Start & West Bend Title I   Regular School No 1.0 PK PK 2015   pre_kindergarten                                                   138                                             138
126023 WI Walworth   school 5516680 6461 Public school Whitewater Unified 551668002834 100 Whitewater 4K   Regular School No 1.0 PK PK 2015   pk_12_total 86.0 3.0 32.0     4.0         6.0   64.0 67.0             45     22   131 86 3 32     4         6   64 67         45   22   131
126024 WI Walworth   school 5516680 6461 Public school Whitewater Unified 551668002834 100 Whitewater 4K   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   119                                             119
126025 WI Walworth   school 5516680 6461 Public school Whitewater Unified 551668002834 100 Whitewater 4K   Regular School No 1.0 PK PK 2015   pre_kindergarten                                                   12                                             12
126035 WI Milwaukee   school 5506000 6470 Public school Whitnall 550600002673 130 CORE4 charter Regular School Yes 1.0 PK PK 2015   pk_12_total 86.0 4.0 13.0     4.0         5.0   55.0 57.0             11     12   112 86 4 13     4         5   55 57         11   12   112
126036 WI Milwaukee   school 5506000 6470 Public school Whitnall 550600002673 130 CORE4 charter Regular School Yes 1.0 PK PK 2015   kindergarten_4_year_old                                                   112                                             112
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

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