enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 14,749 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id ▼ school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
3081831 3081831 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2019   pk_12_total 11.0 462.0 146.0 2.0   10.0         17.0   309.0 339.0             637     164   648 11 462 146 2   10         17   309 339         637   164   648
3081832 3081832 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2019   grade_6                                                   216                                             216
3081833 3081833 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2019   grade_7                                                   216                                             216
3081834 3081834 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2019   grade_8                                                   216                                             216
3081893 3081893 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2019   pk_12_total 19.0 768.0 14.0 3.0   41.0         20.0   503.0 362.0             712     326   865 19 768 14 3   41         20   503 362         712   326   865
3081894 3081894 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2019   grade_10                                                   213                                             213
3081895 3081895 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2019   grade_11                                                   195                                             195
3081896 3081896 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2019   grade_12                                                   179                                             179
3081897 3081897 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2019   grade_9                                                   278                                             278
3077419 3077419 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Middle 04 08 2019   pk_12_total 214.0 250.0 41.0 2.0   22.0       2.0 31.0   282.0 280.0             201     78   562 214 250 41 2   22       2 31   282 280         201   78   562
3077420 3077420 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Middle 04 08 2019   grade_4                                                   109                                             109
3077421 3077421 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Middle 04 08 2019   grade_5                                                   117                                             117
3077422 3077422 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Middle 04 08 2019   grade_6                                                   92                                             92
3077423 3077423 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Middle 04 08 2019   grade_7                                                   123                                             123
3077424 3077424 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Middle 04 08 2019   grade_8                                                   121                                             121
3078174 3078174 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No Elementary KG 05 2019   pk_12_total 295.0 1.0 4.0 1.0   41.0         16.0   182.0 176.0             97     48   358 295 1 4 1   41         16   182 176         97   48   358
3078175 3078175 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No Elementary KG 05 2019   grade_1                                                   57                                             57
3078176 3078176 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No Elementary KG 05 2019   grade_2                                                   56                                             56
3078177 3078177 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No Elementary KG 05 2019   grade_3                                                   66                                             66
3078178 3078178 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No Elementary KG 05 2019   grade_4                                                   69                                             69
3078179 3078179 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No Elementary KG 05 2019   grade_5                                                   58                                             58
3078180 3078180 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No Elementary KG 05 2019   kindergarten                                                   52                                             52
3078249 3078249 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2019   pk_12_total 533.0 4.0 48.0     15.0         9.0   325.0 284.0             108     55   609 533 4 48     15         9   325 284         108   55   609
3078250 3078250 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2019   grade_1                                                   122                                             122
3078251 3078251 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2019   grade_2                                                   138                                             138
3078252 3078252 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2019   grade_3                                                   108                                             108
3078253 3078253 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2019   grade_4                                                   125                                             125
3078254 3078254 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2019   kindergarten                                                   109                                             109
3078255 3078255 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2019   pre_kindergarten                                                   7                                             7
3078400 3078400 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No Elementary KG 05 2019   pk_12_total 287.0 7.0 10.0     5.0         6.0   158.0 157.0             55     50   315 287 7 10     5         6   158 157         55   50   315
3078401 3078401 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No Elementary KG 05 2019   grade_1                                                   38                                             38
3078402 3078402 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No Elementary KG 05 2019   grade_2                                                   48                                             48
3078403 3078403 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No Elementary KG 05 2019   grade_3                                                   60                                             60
3078404 3078404 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No Elementary KG 05 2019   grade_4                                                   55                                             55
3078405 3078405 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No Elementary KG 05 2019   grade_5                                                   50                                             50
3078406 3078406 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No Elementary KG 05 2019   kindergarten                                                   64                                             64
3082618 3082618 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2019   pk_12_total 329.0 2.0 28.0     3.0         4.0   189.0 177.0             180     58   366 329 2 28     3         4   189 177         180   58   366
3082619 3082619 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   29                                             29
3082620 3082620 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2019   grade_2                                                   31                                             31
3082621 3082621 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2019   grade_3                                                   36                                             36
3082622 3082622 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2019   grade_4                                                   27                                             27
3082623 3082623 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2019   grade_5                                                   40                                             40
3082624 3082624 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2019   kindergarten_4_year_old                                                   165                                             165
3082625 3082625 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2019   kindergarten                                                   38                                             38
3082659 3082659 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School   Regular School No Elementary PK 05 2019   pk_12_total 256.0   21.0 2.0   1.0         7.0   159.0 128.0             157     42   287 256   21 2   1         7   159 128         157   42   287
3082660 3082660 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School   Regular School No Elementary PK 05 2019   grade_1                                                   34                                             34
3082661 3082661 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School   Regular School No Elementary PK 05 2019   grade_2                                                   43                                             43
3082662 3082662 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School   Regular School No Elementary PK 05 2019   grade_3                                                   48                                             48
3082663 3082663 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School   Regular School No Elementary PK 05 2019   grade_4                                                   44                                             44
3082664 3082664 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School   Regular School No Elementary PK 05 2019   grade_5                                                   49                                             49
3082665 3082665 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School   Regular School No Elementary PK 05 2019   kindergarten_4_year_old                                                   31                                             31
3082666 3082666 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School   Regular School No Elementary PK 05 2019   kindergarten                                                   37                                             37
3082667 3082667 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School   Regular School No Elementary PK 05 2019   pre_kindergarten                                                   1                                             1
3082857 3082857 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Muskego Lakes Middle   Regular School No Middle 05 08 2019   pk_12_total 649.0 3.0 49.0     10.0         13.0   356.0 368.0             68     70   724 649 3 49     10         13   356 368         68   70   724
3082858 3082858 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Muskego Lakes Middle   Regular School No Middle 05 08 2019   grade_5                                                   168                                             168
3082859 3082859 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Muskego Lakes Middle   Regular School No Middle 05 08 2019   grade_6                                                   164                                             164
3082860 3082860 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Muskego Lakes Middle   Regular School No Middle 05 08 2019   grade_7                                                   190                                             190
3082861 3082861 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Muskego Lakes Middle   Regular School No Middle 05 08 2019   grade_8                                                   202                                             202
3083210 3083210 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No Elementary KG 05 2019   pk_12_total 310.0 1.0 12.0 1.0   3.0         8.0   161.0 174.0             71     30   335 310 1 12 1   3         8   161 174         71   30   335
3083211 3083211 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No Elementary KG 05 2019   grade_1                                                   59                                             59
3083212 3083212 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No Elementary KG 05 2019   grade_2                                                   55                                             55
3083213 3083213 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No Elementary KG 05 2019   grade_3                                                   55                                             55
3083214 3083214 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No Elementary KG 05 2019   grade_4                                                   53                                             53
3083215 3083215 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No Elementary KG 05 2019   grade_5                                                   53                                             53
3083216 3083216 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No Elementary KG 05 2019   kindergarten                                                   60                                             60
3083466 3083466 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2019   pk_12_total 316.0 8.0 58.0 3.0   10.0       1.0 17.0   224.0 189.0             84     49   413 316 8 58 3   10       1 17   224 189         84   49   413
3083467 3083467 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   61                                             61
3083468 3083468 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2019   grade_2                                                   60                                             60
3083469 3083469 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2019   grade_3                                                   75                                             75
3083470 3083470 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2019   grade_4                                                   69                                             69
3083471 3083471 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2019   grade_5                                                   76                                             76
3083472 3083472 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2019   kindergarten                                                   70                                             70
3083473 3083473 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                                                   2                                             2
3083978 3083978 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2019   pk_12_total 132.0 4.0 14.0               2.0   83.0 69.0             38     23   152 132 4 14               2   83 69         38   23   152
3083979 3083979 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2019   grade_1                                                   11                                             11
3083980 3083980 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2019   grade_2                                                   14                                             14
3083981 3083981 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2019   grade_3                                                   19                                             19
3083982 3083982 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2019   grade_4                                                   17                                             17
3083983 3083983 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2019   grade_5                                                   22                                             22
3083984 3083984 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   21                                             21
3083985 3083985 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2019   kindergarten_4_year_old                                                   26                                             26
3083986 3083986 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2019   kindergarten                                                   19                                             19
3083987 3083987 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten                                                   3                                             3
3084133 3084133 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2019   pk_12_total 74.0 1.0 4.0 1.0   1.0         4.0   45.0 40.0             51     12   85 74 1 4 1   1         4   45 40         51   12   85
3084134 3084134 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2019   grade_1                                                   7                                             7
3084135 3084135 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2019   grade_2                                                   12                                             12
3084136 3084136 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2019   grade_3                                                   12                                             12
3084137 3084137 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2019   grade_4                                                   8                                             8
3084138 3084138 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2019   grade_5                                                   11                                             11
3084139 3084139 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2019   grade_6                                                   7                                             7
3084140 3084140 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   9                                             9
3084141 3084141 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2019   grade_8                                                   10                                             10
3084142 3084142 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2019   kindergarten_4_year_old                                                   5                                             5
3084143 3084143 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2019   kindergarten                                                   4                                             4
3084391 3084391 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002508 10 BA Kennedy School   Regular School No Elementary PK 01 2019   pk_12_total 214.0   4.0 3.0   1.0         13.0   121.0 114.0             146     43   235 214   4 3   1         13   121 114         146   43   235
3084392 3084392 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002508 10 BA Kennedy School   Regular School No Elementary PK 01 2019   grade_1                                                   74                                             74
3084393 3084393 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002508 10 BA Kennedy School   Regular School No Elementary PK 01 2019   kindergarten_4_year_old                                                   79                                             79
3084394 3084394 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002508 10 BA Kennedy School   Regular School No Elementary PK 01 2019   kindergarten                                                   76                                             76
3084395 3084395 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002508 10 BA Kennedy School   Regular School No Elementary PK 01 2019   pre_kindergarten                                                   6                                             6
3085459 3085459 WI Door   school 5513500 5130 Public school Sevastopol 551350000229 10 Sevastopol Pre-School   Regular School No Prekindergarten PK PK 2019   pk_12_total 31.0   5.0     2.0             23.0 15.0             18     5   38 31   5     2             23 15         18   5   38

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