enrollments

Data source: Big Local News · About: Big Local

2,791 rows where grade = "pk_12_total" and state = "MD" sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pk_12_total · 2,591 ✖
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
1314182 1314182 MD     school 2400420 13   Howard 240042000745 611 Oakland Mills High   Regular School No High 09 12 2021   pk_12_total 245 553 281   * 95     *   90                             1269 245 553 281     95         90                       1269
1316957 1316957 MD     school 2400510 16   Prince George's 240051001186 1908 William Wirt Middle   Regular School No Middle 06 08 2021   pk_12_total 25 219 962   * 64     *   *                             1280 25 219 962     64                                 1280
1317008 1317008 MD     school 2400510 16   Prince George's 240051001175 2009 Thomas Johnson Middle   Regular School No Middle 06 08 2021   pk_12_total 30 625 578   * 35     *   *                             1282 30 625 578     35                                 1282
1238127 1238127 MD     school 2400060 2   Anne Arundel 240006000054 4283 Central Middle   Regular School No Middle 06 08 2020   pk_12_total 962 57 162   * 43     *   55                             1284 962 57 162     43         55                       1284
1311194 1311194 MD     school 2400120 3   Baltimore County 240012001432 772 Hereford High   Regular School No High 09 12 2021   pk_12_total 1093 33 57     57         45                             1285 1093 33 57     57         45                       1285
1241856 1241856 MD     school 2400480 15   Montgomery 240048000493 157 Roberto W. Clemente Middle   Regular School No Middle 06 08 2020   pk_12_total 156 383 397   * 270         79                             1287 156 383 397     270         79                       1287
1310711 1310711 MD     school 2400060 2   Anne Arundel 240006000056 4304 Central Special School   Special Education School No Other PK 12 2021   pk_12_total 67 27 26     *         *                             129 67 27 26                                       129
1238639 1238639 MD     school 2400120 3   Baltimore County 240012001432 772 Hereford High   Regular School No High 09 12 2020   pk_12_total 1120 31 56     49         39                             1295 1120 31 56     49         39                       1295
1317086 1317086 MD     school 2400510 16   Prince George's 240051000993 2108 Buck Lodge Middle   Regular School No Middle 06 08 2021   pk_12_total * 111 1158   * 10         *                             1295   111 1158     10                                 1295
1311664 1311664 MD     school 2400120 3   Baltimore County 240012000416 1371 Lansdowne High   Regular School No High 09 12 2021   pk_12_total 462 330 342   10 100         52                             1296 462 330 342   10 100         52                       1296
1310850 1310850 MD     school 2400120 3   Baltimore County 240012000466 111 Maiden Choice School   Special Education School No Other PK 12 2021   pk_12_total 29 71 *     16         *                             130 29 71       16                                 130
1317699 1317699 MD     school 2400660 21   Washington 240066001258 1401 Cascade Elementary   Regular School No Elementary PK 05 2021   pk_12_total 121 * *   * *         *                             130 121                                           130
1244499 1244499 MD     school 2400510 16   Prince George's 240051000993 2108 Buck Lodge Middle   Regular School No Middle 06 08 2020   pk_12_total 14 106 1159   * 13     *   *                             1302 14 106 1159     13                                 1302
1240541 1240541 MD     school 2400330 10   Frederick 240033000638 912 Linganore High   Regular School No High 09 12 2020   pk_12_total 1131 22 97   * 12     *   46                             1311 1131 22 97     12         46                       1311
1245169 1245169 MD     school 2400660 21   Washington 240066001275 2101 North Hagerstown High   Regular School No High 09 12 2020   pk_12_total 687 259 183   * 50     *   129                             1311 687 259 183     50         129                       1311
1311026 1311026 MD     school 2400120 3   Baltimore County 240012000432 271 Milford Mill Academy   Regular School No High 09 12 2021   pk_12_total 22 1155 84   * 15         33                             1312 22 1155 84     15         33                       1312
1319291 1319291 MD     school 2400090 30   Baltimore City 240009001313 416 Digital Harbor High School   Career and Technical School No High 09 12 2021   pk_12_total 77 846 373   * *     *   *                             1315 77 846 373                                       1315
1314222 1314222 MD     school 2400420 13   Howard 240042000735 619 Hammond High   Regular School No High 09 12 2021   pk_12_total 319 523 230   * 142     *   97                             1316 319 523 230     142         97                       1316
1312231 1312231 MD     school 2400210 6   Carroll 240021001672 602 Manchester Valley High   Regular School No High 09 12 2021   pk_12_total 1154 34 73   * 31     *   25                             1321 1154 34 73     31         25                       1321
1239681 1239681 MD     school 2400210 6   Carroll 240021001672 602 Manchester Valley High   Regular School No High 09 12 2020   pk_12_total 1169 32 70   * 30         22                             1325 1169 32 70     30         22                       1325
1239109 1239109 MD     school 2400120 3   Baltimore County 240012000416 1371 Lansdowne High & Academy of Finance   Regular School No High 09 12 2020   pk_12_total 494 329 335   * 110         52                             1326 494 329 335     110         52                       1326
1245401 1245401 MD     school 2400720 23   Worcester 240072001335 310 Stephen Decatur High   Regular School No High 09 12 2020   pk_12_total 1015 137 96   * 23     *   55                             1328 1015 137 96     23         55                       1328
1244436 1244436 MD     school 2400510 16   Prince George's 240051001004 2011 Charles Carroll Middle   Regular School No Middle 06 08 2020   pk_12_total 23 378 903   * 19     *   *                             1329 23 378 903     19                                 1329
1240843 1240843 MD     school 2400360 11   Garrett 240036000673 1904 Route 40 Elementary   Regular School No Elementary PK 05 2020   pk_12_total 130   *               *                             133 130                                           133
1313669 1313669 MD     school 2400390 12   Harford 240039001380 385 C. Milton Wright High   Regular School No High 09 12 2021   pk_12_total 1026 100 68   * 72     *   61                             1330 1026 100 68     72         61                       1330
1317017 1317017 MD     school 2400510 16   Prince George's 240051001004 2011 Charles Carroll Middle   Regular School No Middle 06 08 2021   pk_12_total 23 356 922   * 25         *                             1330 23 356 922     25                                 1330
1243946 1243946 MD     school 2400510 16   Prince George's 240051001726 1351 Chesapeake Math and IT South Public Charter   Regular School Yes Other KG 12 2020   pk_12_total 13 1261 27   * 16     *   12                             1335 13 1261 27     16         12                       1335
1310434 1310434 MD     school 2400060 2   Anne Arundel 240006001403 3263 Crofton Middle   Regular School No Middle 06 08 2021   pk_12_total 720 257 152   * 114     *   87                             1339 720 257 152     114         87                       1339
1317744 1317744 MD     school 2400660 21   Washington 240066001275 2101 North Hagerstown High   Regular School No High 09 12 2021   pk_12_total 653 278 205   * 54     *   150                             1343 653 278 205     54         150                       1343
1237869 1237869 MD     school 2400060 2   Anne Arundel 240006001403 3263 Crofton Middle   Regular School No Middle 06 08 2020   pk_12_total 746 271 136   * 105     *   76                             1345 746 271 136     105         76                       1345
1244983 1244983 MD     school 2400660 21   Washington 240066001288 301 South Hagerstown High   Regular School No High 09 12 2020   pk_12_total 586 358 167   * 50     *   179                             1345 586 358 167     50         179                       1345
1310691 1310691 MD     school 2400060 2   Anne Arundel 240006000054 4283 Central Middle   Regular School No Middle 06 08 2021   pk_12_total 988 61 173   * 48     *   69                             1345 988 61 173     48         69                       1345
1240801 1240801 MD     school 2400360 11   Garrett 240036000665 1408 Crellin Elementary   Regular School No Elementary KG 05 2020   pk_12_total 127   *               *                             135 127                                           135
1241484 1241484 MD     school 2400420 13   Howard 240042000762 516 Wilde Lake High   Regular School No High 09 12 2020   pk_12_total 337 630 175   * 110     *   94                             1351 337 630 175     110         94                       1351
1242679 1242679 MD     school 2400480 15   Montgomery 240048001455 701 Damascus High   Regular School No High 09 12 2020   pk_12_total 648 177 315   * 140     *   69                             1353 648 177 315     140         69                       1353
1313688 1313688 MD     school 2400390 12   Harford 240039000703 391 John Archer School   Special Education School No Other PK 12 2021   pk_12_total 65 41 16     *         10                             136 65 41 16               10                       136
1315245 1315245 MD     school 2400480 15   Montgomery 240048000876 652 Monocacy Elementary   Regular School No Elementary PK 05 2021   pk_12_total 95 * 21     *         *                             136 95   21                                       136
1313144 1313144 MD     school 2400330 10   Frederick 240033001688 920 Oakdale High   Regular School No High 09 12 2021   pk_12_total 983 84 135   * 90     *   62                             1362 983 84 135     90         62                       1362
1317902 1317902 MD     school 2400690 22   Wicomico 240069001305 1307 James M. Bennett High   Regular School No High 09 12 2021   pk_12_total 575 475 155   * 68     *   77                             1362 575 475 155     68         77                       1362
1241113 1241113 MD     school 2400390 12   Harford 240039001380 385 C. Milton Wright High   Regular School No High 09 12 2020   pk_12_total 1059 97 68   * 82     *   51                             1363 1059 97 68     82         51                       1363
1310091 1310091 MD     school 2400060 2   Anne Arundel 240006000103 2023 Northeast High   Regular School No High 09 12 2021   pk_12_total 979 135 141   * 28     *   73                             1364 979 135 141     28         73                       1364
1238462 1238462 MD     school 2400120 3   Baltimore County 240012000372 254 Deer Park Middle Magnet School   Regular School No Middle 06 08 2020   pk_12_total 37 1183 74   * 29     *   36                             1365 37 1183 74     29         36                       1365
1237529 1237529 MD     school 2400060 2   Anne Arundel 240006000103 2023 Northeast High   Regular School No High 09 12 2020   pk_12_total 996 123 133   * 34     *   72                             1367 996 123 133     34         72                       1367
1317977 1317977 MD     school 2400720 23   Worcester 240072001335 310 Stephen Decatur High   Regular School No High 09 12 2021   pk_12_total 1046 121 105   * 25     *   70                             1369 1046 121 105     25         70                       1369
1238296 1238296 MD     school 2400120 3   Baltimore County 240012000466 111 Maiden Choice School   Special Education School No Other PK 12 2020   pk_12_total 33 72 *     20         *                             137 33 72       20                                 137
1314478 1314478 MD     school 2400480 15   Montgomery 240048000857 211 Julius West Middle   Regular School No Middle 06 08 2021   pk_12_total 441 221 390   * 237     *   77                             1375 441 221 390     237         77                       1375
1241535 1241535 MD     school 2400420 13   Howard 240042000816 524 River Hill High   Regular School No High 09 12 2020   pk_12_total 599 136 84     470         89                             1378 599 136 84     470         89                       1378
1314039 1314039 MD     school 2400420 13   Howard 240042000762 516 Wilde Lake High   Regular School No High 09 12 2021   pk_12_total 328 654 187   * 100     *   105                             1379 328 654 187     100         105                       1379
1317558 1317558 MD     school 2400660 21   Washington 240066001288 301 South Hagerstown High   Regular School No High 09 12 2021   pk_12_total 582 351 212   * 47     *   187                             1381 582 351 212     47         187                       1381
1241920 1241920 MD     school 2400480 15   Montgomery 240048000857 211 Julius West Middle   Regular School No Middle 06 08 2020   pk_12_total 443 228 377   * 250     *   76                             1382 443 228 377     250         76                       1382
1237679 1237679 MD     school 2400060 2   Anne Arundel 240006000058 2273 Chesapeake High   Regular School No High 09 12 2020   pk_12_total 1161 57 82   * 26     *   54                             1388 1161 57 82     26         54                       1388
1244883 1244883 MD     school 2400570 19   Somerset 240057001202 1401 Deal Island School   Regular School No Elementary PK 05 2020   pk_12_total 115 12 *     *         *                             139 115 12                                         139
1312798 1312798 MD     school 2400270 8   Charles 240027001727 802 St. Charles High School   Regular School No High 09 12 2021   pk_12_total 154 997 101   11 30     *   96                             1392 154 997 101   11 30         96                       1392
1313094 1313094 MD     school 2400330 10   Frederick 240033000638 912 Linganore High   Regular School No High 09 12 2021   pk_12_total 1162 33 115   * 23     *   57                             1393 1162 33 115     23         57                       1393
1316526 1316526 MD     school 2400510 16   Prince George's 240051001726 1351 Chesapeake Math and IT South Public Charter   Regular School Yes Other KG 12 2021   pk_12_total 13 1322 24   * 17     *   10                             1393 13 1322 24     17         10                       1393
1241666 1241666 MD     school 2400420 13   Howard 240042000735 619 Hammond High   Regular School No High 09 12 2020   pk_12_total 344 565 233   * 147     *   99                             1394 344 565 233     147         99                       1394
1312018 1312018 MD     school 2400150 4   Calvert 240015001342 217 Huntingtown High School   Regular School No High 09 12 2021   pk_12_total 1060 134 80   * 22         100                             1398 1060 134 80     22         100                       1398
1238189 1238189 MD     school 2400120 3   Baltimore County 240012001751 52 Southwest EDLP at Woodlawn High School   Alternative School No High 09 12 2020   pk_12_total * * *     *         *                             14                                             14
1246543 1246543 MD     school 2400090 30   Baltimore City 240009001632 333 Independence School Local I   Regular School Yes High 09 12 2020   pk_12_total * 127 *     *         *                             140   127                                         140
1313339 1313339 MD     school 2400360 11   Garrett 240036000667 1202 Friendsville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 131   *               *                             140 131                                           140
1246807 1246807 MD     school 2400090 30   Baltimore City 240009000150 480 Baltimore City College   Regular School No High 09 12 2020   pk_12_total 254 970 126   * 24     *   21                             1402 254 970 126     24         21                       1402
1311598 1311598 MD     school 2400120 3   Baltimore County 240012000444 1272 Patapsco High and Center for Arts   Regular School No High 09 12 2021   pk_12_total 799 327 134   15 14     *   112                             1402 799 327 134   15 14         112                       1402
1318790 1318790 MD     school 2400090 30   Baltimore City 240009000306 233 Roland Park Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 511 617 75   * 119     *   72                             1402 511 617 75     119         72                       1402
1315258 1315258 MD     school 2400480 15   Montgomery 240048001455 701 Damascus High   Regular School No High 09 12 2021   pk_12_total 628 182 369   * 149     *   72                             1404 628 182 369     149         72                       1404
1239463 1239463 MD     school 2400150 4   Calvert 240015001342 217 Huntingtown High School   Regular School No High 09 12 2020   pk_12_total 1085 116 83   * 25         97                             1408 1085 116 83     25         97                       1408
1240251 1240251 MD     school 2400270 8   Charles 240027001727 802 St. Charles High School   Regular School No High 09 12 2020   pk_12_total 175 1005 90   11 29     *   97                             1410 175 1005 90   11 29         97                       1410
1310099 1310099 MD     school 2400060 2   Anne Arundel 240006000126 2043 Severna Park Middle   Regular School No Middle 06 08 2021   pk_12_total 1130 55 76   * 69     *   75                             1412 1130 55 76     69         75                       1412
1310241 1310241 MD     school 2400060 2   Anne Arundel 240006000058 2273 Chesapeake High   Regular School No High 09 12 2021   pk_12_total 1183 57 94   * 27     *   43                             1412 1183 57 94     27         43                       1412
1313497 1313497 MD     school 2400390 12   Harford 240039000690 176 Edgewood High   Regular School No High 09 12 2021   pk_12_total 412 678 169   * 43     *   102                             1413 412 678 169     43         102                       1413
1240786 1240786 MD     school 2400360 11   Garrett 240036000667 1202 Friendsville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 133 * *               *                             142 133                                           142
1237948 1237948 MD     school 2400060 2   Anne Arundel 240006001425 3414 Ruth Parker Eason School   Special Education School No Other PK 12 2020   pk_12_total 51 63 19     *         *                             143 51 63 19                                       143
1240999 1240999 MD     school 2400390 12   Harford 240039000679 270 Aberdeen High   Regular School No High 09 12 2020   pk_12_total 517 543 145   * 91     *   119                             1431 517 543 145     91         119                       1431
1314915 1314915 MD     school 2400480 15   Montgomery 240048009000 428 Thomas W. Pyle Middle School   Regular School No Middle 06 08 2021   pk_12_total 931 41 149     214     *   97                             1433 931 41 149     214         97                       1433
1239043 1239043 MD     school 2400120 3   Baltimore County 240012000444 1272 Patapsco High & Center for Arts   Regular School No High 09 12 2020   pk_12_total 820 331 148   15 15     *   104                             1434 820 331 148   15 15         104                       1434
1241094 1241094 MD     school 2400390 12   Harford 240039001397 372 Bel Air Middle   Regular School No Middle 06 08 2020   pk_12_total 1062 107 89   * 101     *   69                             1435 1062 107 89     101         69                       1435
1314549 1314549 MD     school 2400480 15   Montgomery 240048000912 230 Rockville High   Regular School No High 09 12 2021   pk_12_total 405 211 598   * 161     *   58                             1436 405 211 598     161         58                       1436
1319352 1319352 MD     school 2400090 30   Baltimore City 240009000150 480 Baltimore City College   Regular School No High 09 12 2021   pk_12_total 256 972 146   * 25     *   32                             1439 256 972 146     25         32                       1439
1241987 1241987 MD     school 2400480 15   Montgomery 240048000912 230 Rockville High   Regular School No High 09 12 2020   pk_12_total 437 194 593   * 155     *   55                             1440 437 194 593     155         55                       1440
1313552 1313552 MD     school 2400390 12   Harford 240039000679 270 Aberdeen High   Regular School No High 09 12 2021   pk_12_total 498 576 140   10 85     *   125                             1441 498 576 140   10 85         125                       1441
1313650 1313650 MD     school 2400390 12   Harford 240039001397 372 Bel Air Middle   Regular School No Middle 06 08 2021   pk_12_total 1067 113 90   * 106     *   61                             1441 1067 113 90     106         61                       1441
1237537 1237537 MD     school 2400060 2   Anne Arundel 240006000126 2043 Severna Park Middle   Regular School No Middle 06 08 2020   pk_12_total 1162 52 87   * 66     *   77                             1453 1162 52 87     66         77                       1453
1246228 1246228 MD     school 2400090 30   Baltimore City 240009000306 233 Roland Park Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 576 599 69   * 136     *   62                             1453 576 599 69     136         62                       1453
1311162 1311162 MD     school 2400120 3   Baltimore County 240012000390 472 Franklin High   Regular School No High 09 12 2021   pk_12_total 429 647 190   * 109     *   76                             1457 429 647 190     109         76                       1457
1240944 1240944 MD     school 2400390 12   Harford 240039000690 176 Edgewood High   Regular School No High 09 12 2020   pk_12_total 466 675 168   * 47     *   95                             1458 466 675 168     47         95                       1458
1241451 1241451 MD     school 2400420 13   Howard 240042000719 509 Atholton High   Regular School No High 09 12 2020   pk_12_total 580 369 137   * 287         85                             1460 580 369 137     287         85                       1460
1313901 1313901 MD     school 2400420 13   Howard 240042000722 214 Centennial High   Regular School No High 09 12 2021   pk_12_total 566 131 82     611     *   75                             1467 566 131 82     611         75                       1467
1316315 1316315 MD     school 2400510 16   Prince George's 240051001123 1209 Oxon Hill High   Regular School No High 09 12 2021   pk_12_total 36 827 451   * 107     10   30                             1467 36 827 451     107     10   30                       1467
1244549 1244549 MD     school 2400510 16   Prince George's 240051001049 2141 Greenbelt Middle   Regular School No Middle 06 08 2020   pk_12_total 96 709 540   * 89     *   27                             1468 96 709 540     89         27                       1468
1314090 1314090 MD     school 2400420 13   Howard 240042000816 524 River Hill High   Regular School No High 09 12 2021   pk_12_total 643 139 83   * 515         89                             1470 643 139 83     515         89                       1470
1317136 1317136 MD     school 2400510 16   Prince George's 240051001049 2141 Greenbelt Middle   Regular School No Middle 06 08 2021   pk_12_total 102 671 562   * 91     *   35                             1471 102 671 562     91         35                       1471
1241415 1241415 MD     school 2400420 13   Howard 240042001437 308 Marriotts Ridge High   Regular School No High 09 12 2020   pk_12_total 676 136 46   * 548         63                             1472 676 136 46     548         63                       1472
1314006 1314006 MD     school 2400420 13   Howard 240042000719 509 Atholton High   Regular School No High 09 12 2021   pk_12_total 516 436 160   * 268         91                             1472 516 436 160     268         91                       1472
1238147 1238147 MD     school 2400060 2   Anne Arundel 240006000056 4304 Central Special School   Special Education School No Other PK 12 2020   pk_12_total 80 32 23     *         *                             148 80 32 23                                       148
1313560 1313560 MD     school 2400390 12   Harford 240039000480 292 Center for Educational Opportunity   Alternative School No High 06 12 2021   pk_12_total 79 48 *     *         14                             148 79 48                 14                       148
1318995 1318995 MD     school 2400090 30   Baltimore City 240009000336 301 William S. Baer School   Special Education School No Other PK 12 2021   pk_12_total 14 112 20     *                                       148 14 112 20                                       148
1312038 1312038 MD     school 2400150 4   Calvert 240015000516 314 Northern High   Regular School No High 09 12 2021   pk_12_total 1096 166 87   * 33     *   94                             1483 1096 166 87     33         94                       1483
1239483 1239483 MD     school 2400150 4   Calvert 240015000516 314 Northern High   Regular School No High 09 12 2020   pk_12_total 1101 163 92   * 28     *   97                             1484 1101 163 92     28         97                       1484
1240493 1240493 MD     school 2400330 10   Frederick 240033000659 603 Wolfsville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 130 * *   *           *                             149 130                                           149
1310513 1310513 MD     school 2400060 2   Anne Arundel 240006001425 3414 Ruth Parker Eason School   Special Education School No Other PK 12 2021   pk_12_total 46 68 19     *     *   *                             149 46 68 19                                       149
1311017 1311017 MD     school 2400120 3   Baltimore County 240012000372 254 Deer Park Middle Magnet School   Regular School No Middle 06 08 2021   pk_12_total 33 1297 88   * 34         38                             1495 33 1297 88     34         38                       1495

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