enrollments

Data source: Big Local News · About: Big Local

14,653 rows where state = "WI" and year = 2015 sorted by school_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 14,653 ✖
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
119617 119617 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle School   Regular School No 2.0 06 08 2015   pk_12_total 35.0 399.0 189.0 2.0   20.0         1.0   339.0 307.0             579     170   646 35 399 189 2   20         1   339 307         579   170   646
119618 119618 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle School   Regular School No 2.0 06 08 2015   grade_6                                                   194                                             194
119619 119619 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle School   Regular School No 2.0 06 08 2015   grade_7                                                   203                                             203
119620 119620 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle School   Regular School No 2.0 06 08 2015   grade_8                                                   249                                             249
114077 114077 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No 1.0 PK 05 2015   pk_12_total 149.0 1.0 71.0               3.0   124.0 100.0             137     38   224 149 1 71               3   124 100         137   38   224
114078 114078 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   29                                             29
114079 114079 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   35                                             35
114080 114080 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No 1.0 PK 05 2015   grade_3                                                   30                                             30
114081 114081 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   40                                             40
114082 114082 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No 1.0 PK 05 2015   grade_5                                                   40                                             40
114083 114083 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No 1.0 PK 05 2015   kindergarten_4_year_old                                                   17                                             17
114084 114084 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No 1.0 PK 05 2015   kindergarten                                                   26                                             26
114085 114085 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   7                                             7
115226 115226 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No 2.0 04 08 2015   pk_12_total 286.0 180.0 29.0 7.0   32.0       1.0 11.0   273.0 273.0             169     74   546 286 180 29 7   32       1 11   273 273         169   74   546
115227 115227 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No 2.0 04 08 2015   grade_4                                                   97                                             97
115228 115228 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No 2.0 04 08 2015   grade_5                                                   109                                             109
115229 115229 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No 2.0 04 08 2015   grade_6                                                   120                                             120
115230 115230 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No 2.0 04 08 2015   grade_7                                                   118                                             118
115231 115231 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No 2.0 04 08 2015   grade_8                                                   102                                             102
115999 115999 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No 1.0 KG 05 2015   pk_12_total 332.0   8.0 1.0   44.0         9.0   202.0 192.0             112     49   394 332   8 1   44         9   202 192         112   49   394
116000 116000 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No 1.0 KG 05 2015   grade_1                                                   58                                             58
116001 116001 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No 1.0 KG 05 2015   grade_2                                                   70                                             70
116002 116002 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No 1.0 KG 05 2015   grade_3                                                   65                                             65
116003 116003 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No 1.0 KG 05 2015   grade_4                                                   75                                             75
116004 116004 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No 1.0 KG 05 2015   grade_5                                                   64                                             64
116005 116005 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No 1.0 KG 05 2015   kindergarten                                                   62                                             62
116061 116061 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No 1.0 PK 04 2015   pk_12_total 471.0 3.0 36.0 8.0   5.0         11.0   260.0 274.0             76     54   534 471 3 36 8   5         11   260 274         76   54   534
116062 116062 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No 1.0 PK 04 2015   grade_1                                                   99                                             99
116063 116063 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No 1.0 PK 04 2015   grade_2                                                   108                                             108
116064 116064 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No 1.0 PK 04 2015   grade_3                                                   119                                             119
116065 116065 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No 1.0 PK 04 2015   grade_4                                                   97                                             97
116066 116066 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No 1.0 PK 04 2015   kindergarten                                                   111                                             111
116210 116210 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No 1.0 KG 05 2015   pk_12_total 358.0 6.0 13.0 1.0   9.0         9.0   197.0 199.0             71     70   396 358 6 13 1   9         9   197 199         71   70   396
116211 116211 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No 1.0 KG 05 2015   grade_1                                                   53                                             53
116212 116212 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No 1.0 KG 05 2015   grade_2                                                   64                                             64
116213 116213 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No 1.0 KG 05 2015   grade_3                                                   72                                             72
116214 116214 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No 1.0 KG 05 2015   grade_4                                                   73                                             73
116215 116215 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No 1.0 KG 05 2015   grade_5                                                   70                                             70
116216 116216 WI Saint Croix   school 5506690 2611 Public school Hudson 550669002332 10 Willow River Elementary   Regular School No 1.0 KG 05 2015   kindergarten                                                   64                                             64
118287 118287 WI Dane   school 5508910 3381 Public school McFarland 550891001033 10 Conrad Elvehjem Early Learning Center   Regular School No 1.0 PK KG 2015   pk_12_total 148.0 1.0 3.0 1.0   4.0         9.0   99.0 67.0             18     19   166 148 1 3 1   4         9   99 67         18   19   166
118288 118288 WI Dane   school 5508910 3381 Public school McFarland 550891001033 10 Conrad Elvehjem Early Learning Center   Regular School No 1.0 PK KG 2015   kindergarten                                                   157                                             157
118289 118289 WI Dane   school 5508910 3381 Public school McFarland 550891001033 10 Conrad Elvehjem Early Learning Center   Regular School No 1.0 PK KG 2015   pre_kindergarten                                                   9                                             9
120419 120419 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2015   pk_12_total 387.0 6.0 31.0 1.0   4.0         10.0   223.0 216.0             206     60   439 387 6 31 1   4         10   223 216         206   60   439
120420 120420 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   43                                             43
120421 120421 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   44                                             44
120422 120422 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2015   grade_3                                                   48                                             48
120423 120423 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   42                                             42
120424 120424 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2015   grade_5                                                   47                                             47
120425 120425 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2015   kindergarten_4_year_old                                                   174                                             174
120426 120426 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2015   kindergarten                                                   41                                             41
120452 120452 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2015   pk_12_total 321.0 8.0 26.0 3.0           1.0 5.0   190.0 174.0             207     42   364 321 8 26 3           1 5   190 174         207   42   364
120453 120453 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2015   grade_1                                                   43                                             43
120454 120454 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2015   grade_2                                                   46                                             46
120455 120455 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2015   grade_3                                                   44                                             44
120456 120456 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2015   grade_4                                                   51                                             51
120457 120457 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2015   grade_5                                                   50                                             50
120458 120458 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2015   grade_6                                                   47                                             47
120459 120459 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2015   kindergarten_4_year_old                                                   41                                             41
120460 120460 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2015   kindergarten                                                   40                                             40
120461 120461 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2015   pre_kindergarten                                                   2                                             2
120608 120608 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Bay Lane Middle   Regular School No 2.0 05 08 2015   pk_12_total 650.0 4.0 33.0     6.0       1.0 9.0   360.0 343.0             100     50   703 650 4 33     6       1 9   360 343         100   50   703
120609 120609 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Bay Lane Middle   Regular School No 2.0 05 08 2015   grade_5                                                   166                                             166
120610 120610 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Bay Lane Middle   Regular School No 2.0 05 08 2015   grade_6                                                   194                                             194
120611 120611 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Bay Lane Middle   Regular School No 2.0 05 08 2015   grade_7                                                   160                                             160
120612 120612 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Bay Lane Middle   Regular School No 2.0 05 08 2015   grade_8                                                   183                                             183
121013 121013 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No 1.0 PK 05 2015   pk_12_total 311.0 2.0 11.0 1.0   1.0       1.0 4.0   165.0 166.0             109     53   331 311 2 11 1   1       1 4   165 166         109   53   331
121014 121014 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   62                                             62
121015 121015 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   47                                             47
121016 121016 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No 1.0 PK 05 2015   grade_3                                                   50                                             50
121017 121017 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   56                                             56
121018 121018 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No 1.0 PK 05 2015   grade_5                                                   44                                             44
121019 121019 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No 1.0 PK 05 2015   kindergarten                                                   60                                             60
121020 121020 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062000225 10 New Richmond Paperjack Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   12                                             12
121262 121262 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No 1.0 PK 05 2015   pk_12_total 360.0 6.0 47.0 3.0   18.0         9.0   238.0 205.0             107     52   443 360 6 47 3   18         9   238 205         107   52   443
121263 121263 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   75                                             75
121264 121264 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   68                                             68
121265 121265 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No 1.0 PK 05 2015   grade_3                                                   78                                             78
121266 121266 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   79                                             79
121267 121267 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No 1.0 PK 05 2015   grade_5                                                   71                                             71
121268 121268 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No 1.0 PK 05 2015   kindergarten                                                   65                                             65
121269 121269 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001406 10 Carollton Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   7                                             7
121768 121768 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2015   pk_12_total 159.0 2.0 12.0                   95.0 78.0             47     21   173 159 2 12                   95 78         47   21   173
121769 121769 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2015   grade_1                                                   21                                             21
121770 121770 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2015   grade_2                                                   19                                             19
121771 121771 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2015   grade_3                                                   14                                             14
121772 121772 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2015   grade_4                                                   30                                             30
121773 121773 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2015   grade_5                                                   22                                             22
121774 121774 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   21                                             21
121775 121775 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2015   kindergarten_4_year_old                                                   21                                             21
121776 121776 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2015   kindergarten                                                   24                                             24
121777 121777 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2015   pre_kindergarten                                                   1                                             1
121912 121912 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2015   pk_12_total 76.0 1.0 4.0 3.0             4.0   44.0 44.0             53     12   88 76 1 4 3             4   44 44         53   12   88
121913 121913 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2015   grade_1                                                   11                                             11
121914 121914 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2015   grade_2                                                   4                                             4
121915 121915 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2015   grade_3                                                   9                                             9
121916 121916 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2015   grade_4                                                   9                                             9
121917 121917 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2015   grade_5                                                   2                                             2
121918 121918 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2015   grade_6                                                   9                                             9
121919 121919 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2015   grade_7                                                   17                                             17
121920 121920 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2015   grade_8                                                   12                                             12

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