Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id ▼ school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
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 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 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 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
289587 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle School   Regular School No 2.0 06 08 2016   pk_12_total 28.0 454.0 184.0 4.0   8.0         6.0   358.0 326.0             581     187   684 28 454 184 4   8         6   358 326         581   187   684
289588 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle School   Regular School No 2.0 06 08 2016   grade_6                                                   216                                             216
289589 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle School   Regular School No 2.0 06 08 2016   grade_7                                                   230                                             230
289590 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle School   Regular School No 2.0 06 08 2016   grade_8                                                   238                                             238
333457 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2017   pk_12_total 9.0 481.0 189.0 2.0   7.0         14.0   363.0 339.0             625     176   702 9 481 189 2   7         14   363 339         625   176   702
333458 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2017   grade_6                                                   216                                             216
333459 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2017   grade_7                                                   239                                             239
333460 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2017   grade_8                                                   247                                             247
3096538 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2018   pk_12_total 11.0 468.0 150.0 4.0   9.0         21.0   340.0 323.0             537     171   663 11 468 150 4   9         21   340 323         537   171   663
3096539 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2018   grade_6                                                   187                                             187
3096540 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2018   grade_7                                                   229                                             229
3096541 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2018   grade_8                                                   247                                             247
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 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2019   grade_6                                                   216                                             216
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 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2019   grade_8                                                   216                                             216
2326076 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2020   pk_12_total 8.0 451.0 133.0 4.0   8.0       1.0 16.0   285.0 336.0             610     141   621 8 451 133 4   8       1 16   285 336         610   141   621
2326077 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2020   grade_6                                                   189                                             189
2326078 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2020   grade_7                                                   216                                             216
2326079 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2020   grade_8                                                   216                                             216
2340970 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2021   pk_12_total 11.0 355.0 123.0 3.0   8.0       1.0 16.0   233.0 284.0     48.0       511     123   517 11 355 123 3   8       1 16   233 284     48   511   123   517
2340971 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2021   grade_6                                                   154                                             154
2340972 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2021   grade_7                                                   168                                             168
2340973 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2021   grade_8                                                   195                                             195
333519 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2017   pk_12_total 48.0 727.0 24.0 2.0   63.0         12.0   482.0 394.0             732     291   876 48 727 24 2   63         12   482 394         732   291   876
333520 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2017   grade_10                                                   181                                             181
333521 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2017   grade_11                                                   188                                             188
333522 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2017   grade_12                                                   184                                             184
333523 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2017   grade_9                                                   323                                             323
3096600 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2018   pk_12_total 36.0 681.0 21.0 1.0   50.0         12.0   481.0 320.0             603     272   801 36 681 21 1   50         12   481 320         603   272   801
3096601 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2018   grade_10                                                   198                                             198
3096602 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2018   grade_11                                                   158                                             158
3096603 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2018   grade_12                                                   177                                             177
3096604 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2018   grade_9                                                   268                                             268
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 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2019   grade_10                                                   213                                             213
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 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2019   grade_12                                                   179                                             179
3081897 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2019   grade_9                                                   278                                             278
2326138 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2020   pk_12_total 14.0 952.0 27.0 2.0   31.0         23.0   568.0 481.0             868     344   1049 14 952 27 2   31         23   568 481         868   344   1049
2326139 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2020   grade_10                                                   277                                             277
2326140 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2020   grade_11                                                   240                                             240
2326141 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2020   grade_12                                                   215                                             215
2326142 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2020   grade_9                                                   317                                             317
2341031 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2021   pk_12_total 11.0 1085.0 48.0 3.0   29.0         27.0   660.0 543.0     14.0       1091     362   1203 11 1085 48 3   29         27   660 543     14   1091   362   1203
2341032 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2021   grade_10                                                   316                                             316
2341033 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2021   grade_11                                                   297                                             297
2341034 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2021   grade_12                                                   246                                             246
2341035 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001215 8 Marshall High   Regular School No High 09 12 2021   grade_9                                                   344                                             344
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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

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