enrollments

Data source: Big Local News · About: Big Local

103,197 rows where state = "WI" sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

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
288679 288679 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2016   grade_7                                                   5                                             5
288680 288680 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2016   grade_8                                                   3                                             3
288681 288681 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2016   grade_9                                                   3                                             3
332540 332540 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2017   pk_12_total 43.0 4.0 4.0     1.0         5.0   22.0 35.0             8     10   57 43 4 4     1         5   22 35         8   10   57
332541 332541 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2017   grade_10                                                   4                                             4
332542 332542 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2017   grade_11                                                   8                                             8
332543 332543 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2017   grade_12                                                   16                                             16
332544 332544 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2017   grade_2                                                   1                                             1
332545 332545 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2017   grade_3                                                   1                                             1
332546 332546 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2017   grade_4                                                   7                                             7
332547 332547 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2017   grade_6                                                   7                                             7
332548 332548 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2017   grade_7                                                   7                                             7
332549 332549 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2017   grade_8                                                   2                                             2
332550 332550 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2017   grade_9                                                   3                                             3
332551 332551 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2017   kindergarten                                                   1                                             1
2325171 2325171 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2020   pk_12_total 3.0   1.0                   2.0 2.0             *     *   4 3   1                   2 2                 4
2325172 2325172 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2020   grade_5                                                   1                                             1
2325173 2325173 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2020   grade_6                                                   1                                             1
2325174 2325174 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2020   grade_7                                                   1                                             1
2325175 2325175 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2020   grade_8                                                   1                                             1
3080899 3080899 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2019   pk_12_total 9.0 2.0                 1.0   5.0 7.0             1     3   12 9 2                 1   5 7         1   3   12
3080900 3080900 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2019   grade_1                                                   1                                             1
3080901 3080901 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2019   grade_12                                                   3                                             3
3080902 3080902 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2019   grade_2                                                   1                                             1
3080903 3080903 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2019   grade_3                                                   1                                             1
3080904 3080904 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2019   grade_5                                                   1                                             1
3080905 3080905 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2019   grade_6                                                   1                                             1
3080906 3080906 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2019   grade_7                                                   1                                             1
3080907 3080907 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2019   grade_8                                                   3                                             3
3095613 3095613 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2018   pk_12_total 32.0 2.0 2.0     1.0         1.0   20.0 18.0             3     6   38 32 2 2     1         1   20 18         3   6   38
3095614 3095614 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2018   grade_1                                                   1                                             1
3095615 3095615 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2018   grade_10                                                   3                                             3
3095616 3095616 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2018   grade_11                                                   5                                             5
3095617 3095617 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2018   grade_12                                                   12                                             12
3095618 3095618 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2018   grade_2                                                   1                                             1
3095619 3095619 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2018   grade_4                                                   1                                             1
3095620 3095620 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2018   grade_5                                                   3                                             3
3095621 3095621 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2018   grade_7                                                   4                                             4
3095622 3095622 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2018   grade_8                                                   7                                             7
3095623 3095623 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2018   kindergarten                                                   1                                             1
287059 287059 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No 1.0 PK PK 2016   pk_12_total 290.0 1.0 7.0 1.0   3.0         11.0   149.0 164.0             40     44   313 290 1 7 1   3         11   149 164         40   44   313
287060 287060 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   301                                             301
287061 287061 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   12                                             12
330942 330942 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Elementary PK PK 2017   pk_12_total 297.0 2.0 11.0     4.0         9.0   172.0 151.0             47     37   323 297 2 11     4         9   172 151         47   37   323
330943 330943 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Elementary PK PK 2017   kindergarten_4_year_old                                                   22                                             22
330944 330944 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Elementary PK PK 2017   pre_kindergarten                                                   301                                             301
2323511 2323511 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Prekindergarten PK PK 2020   pk_12_total 291.0 3.0 14.0     9.0         14.0   181.0 150.0             63     41   331 291 3 14     9         14   181 150         63   41   331
2323512 2323512 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   314                                             314
2323513 2323513 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   17                                             17
2338395 2338395 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Prekindergarten PK PK 2021   pk_12_total 260.0 3.0 25.0     9.0         14.0   161.0 150.0             64     38   311 260 3 25     9         14   161 150         64   38   311
2338396 2338396 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   292                                             292
2338397 2338397 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   19                                             19
3079261 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 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 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
3094010 3094010 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Prekindergarten PK PK 2018   pk_12_total 251.0 6.0 10.0 2.0   10.0         13.0   172.0 120.0             30     41   292 251 6 10 2   10         13   172 120         30   41   292
3094011 3094011 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   279                                             279
3094012 3094012 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                                                   13                                             13
113136 113136 WI Racine   school 5501890 777 Public school Burlington Area 550189002987 150 4K Community School   Regular School No 1.0 PK PK 2015   pk_12_total 56.0 2.0 8.0     2.0         3.0   34.0 37.0             20     4   71 56 2 8     2         3   34 37         20   4   71
113137 113137 WI Racine   school 5501890 777 Public school Burlington Area 550189002987 150 4K Community School   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   71                                             71
283118 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 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
327015 327015 WI Racine   school 5501890 777 Public school Burlington Area 550189002987 150 4K Community School   Regular School No Elementary PK PK 2017   pk_12_total 29.0   8.0               1.0   21.0 17.0             17     3   38 29   8               1   21 17         17   3   38
327016 327016 WI Racine   school 5501890 777 Public school Burlington Area 550189002987 150 4K Community School   Regular School No Elementary PK PK 2017   kindergarten_4_year_old                                                   38                                             38
2319518 2319518 WI Racine   school 5501890 777 Public school Burlington Area 550189002987 150 4K Community School   Regular School No Prekindergarten PK PK 2020   pk_12_total 34.0   7.0               3.0   20.0 24.0             16     1   44 34   7               3   20 24         16   1   44
2319519 2319519 WI Racine   school 5501890 777 Public school Burlington Area 550189002987 150 4K Community School   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   44                                             44
2334297 2334297 WI Racine   school 5501890 777 Public school Burlington Area 550189002987 150 4K Community School   Regular School No Prekindergarten PK PK 2021   pk_12_total 25.0   4.0               2.0   15.0 16.0             9     2   31 25   4               2   15 16         9   2   31
2334298 2334298 WI Racine   school 5501890 777 Public school Burlington Area 550189002987 150 4K Community School   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   31                                             31
3075303 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 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
3090067 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 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
122623 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 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
292596 292596 WI Sauk   school 5512660 4753 Public school Reedsburg 551266002889 150 4K Community-Based   Regular School No 1.0 PK PK 2016   pk_12_total 85.0 1.0 8.0 1.0   3.0         3.0   51.0 50.0             50     12   101 85 1 8 1   3         3   51 50         50   12   101
292597 292597 WI Sauk   school 5512660 4753 Public school Reedsburg 551266002889 150 4K Community-Based   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   101                                             101
336481 336481 WI Sauk   school 5512660 4753 Public school Reedsburg 551266002889 150 4K Community-Based   Regular School No Elementary PK PK 2017   pk_12_total 76.0 2.0 9.0 1.0             1.0   52.0 37.0             31     10   89 76 2 9 1             1   52 37         31   10   89
336482 336482 WI Sauk   school 5512660 4753 Public school Reedsburg 551266002889 150 4K Community-Based   Regular School No Elementary PK PK 2017   kindergarten_4_year_old                                                   89                                             89
2329101 2329101 WI Sauk   school 5512660 4753 Public school Reedsburg 551266002889 150 4K Community-Based   Regular School No Prekindergarten PK PK 2020   pk_12_total 60.0 2.0 5.0               3.0   39.0 31.0             7     11   70 60 2 5               3   39 31         7   11   70
2329102 2329102 WI Sauk   school 5512660 4753 Public school Reedsburg 551266002889 150 4K Community-Based   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   70                                             70
2343997 2343997 WI Sauk   school 5512660 4753 Public school Reedsburg 551266002889 150 4K Community-Based   Regular School No Prekindergarten PK PK 2021   pk_12_total 49.0   12.0 2.0             3.0   30.0 36.0     7.0       29     4   66 49   12 2             3   30 36     7   29   4   66
2343998 2343998 WI Sauk   school 5512660 4753 Public school Reedsburg 551266002889 150 4K Community-Based   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   66                                             66
3084835 3084835 WI Sauk   school 5512660 4753 Public school Reedsburg 551266002889 150 4K Community-Based   Regular School No Prekindergarten PK PK 2019   pk_12_total 91.0 3.0 9.0 3.0             4.0   55.0 55.0             50     9   110 91 3 9 3             4   55 55         50   9   110
3084836 3084836 WI Sauk   school 5512660 4753 Public school Reedsburg 551266002889 150 4K Community-Based   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   110                                             110
3099554 3099554 WI Sauk   school 5512660 4753 Public school Reedsburg 551266002889 150 4K Community-Based   Regular School No Prekindergarten PK PK 2018   pk_12_total 91.0 1.0 5.0 2.0   1.0         2.0   52.0 50.0             39     12   102 91 1 5 2   1         2   52 50         39   12   102
3099555 3099555 WI Sauk   school 5512660 4753 Public school Reedsburg 551266002889 150 4K Community-Based   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   102                                             102
118285 118285 WI Dane   school 5508910 3381 Public school McFarland 550891002902 150 4K McFarland   Regular School No 1.0 PK PK 2015   pk_12_total 118.0   8.0     6.0         5.0   82.0 55.0             6     19   137 118   8     6         5   82 55         6   19   137
118286 118286 WI Dane   school 5508910 3381 Public school McFarland 550891002902 150 4K McFarland   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   137                                             137
288280 288280 WI Dane   school 5508910 3381 Public school McFarland 550891002902 150 4K McFarland   Regular School No 1.0 PK PK 2016   pk_12_total 109.0   2.0     4.0         10.0   67.0 58.0             6     11   125 109   2     4         10   67 58         6   11   125
288281 288281 WI Dane   school 5508910 3381 Public school McFarland 550891002902 150 4K McFarland   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   125                                             125
332148 332148 WI Dane   school 5508910 3381 Public school McFarland 550891002902 150 4K McFarland   Regular School No Elementary PK PK 2017   pk_12_total 131.0 1.0 8.0     3.0         6.0   78.0 71.0             15     15   149 131 1 8     3         6   78 71         15   15   149
332149 332149 WI Dane   school 5508910 3381 Public school McFarland 550891002902 150 4K McFarland   Regular School No Elementary PK PK 2017   kindergarten_4_year_old                                                   149                                             149
2324779 2324779 WI Dane   school 5508910 3381 Public school McFarland 550891002902 150 4K McFarland   Regular School No Prekindergarten PK PK 2020   pk_12_total 122.0   8.0     2.0         9.0   77.0 64.0             17     17   141 122   8     2         9   77 64         17   17   141
2324780 2324780 WI Dane   school 5508910 3381 Public school McFarland 550891002902 150 4K McFarland   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   141                                             141
2339668 2339668 WI Dane   school 5508910 3381 Public school McFarland 550891002902 150 4K McFarland   Regular School No Prekindergarten PK PK 2021   pk_12_total 84.0 3.0 5.0     2.0         10.0   50.0 54.0             12     11   104 84 3 5     2         10   50 54         12   11   104
2339669 2339669 WI Dane   school 5508910 3381 Public school McFarland 550891002902 150 4K McFarland   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   104                                             104
3080507 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 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
3095223 3095223 WI Dane   school 5508910 3381 Public school McFarland 550891002902 150 4K McFarland   Regular School No Prekindergarten PK PK 2018   pk_12_total 132.0   6.0 1.0   2.0         9.0   74.0 76.0             14     14   150 132   6 1   2         9   74 76         14   14   150
3095224 3095224 WI Dane   school 5508910 3381 Public school McFarland 550891002902 150 4K McFarland   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   150                                             150

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