enrollments

Data source: Big Local News · About: Big Local

19,213 rows where state = "MD" sorted by total_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

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 ▲
1246726 1246726 MD     school 2400090 30   Baltimore City 240009000280 410 Mergenthaler Vocational-Technical High   Career and Technical School No High 09 12 2020   pk_12_total 44 1555 108   * *         *                             1719 44 1555 108                                       1719
1317352 1317352 MD     school 2400600 18   Saint Mary's 240060001224 801 Great Mills High   Regular School No High 09 12 2021   pk_12_total 634 622 219   * 81     *   147                             1713 634 622 219     81         147                       1713
1315524 1315524 MD     school 2400480 15   Montgomery 240048001366 796 Northwood High School   Regular School No High 09 12 2021   pk_12_total 227 438 899   * 86         57                             1708 227 438 899     86         57                       1708
1242404 1242404 MD     school 2400480 15   Montgomery 240048000808 510 Col. Zadok Magruder High   Regular School No High 09 12 2020   pk_12_total 436 302 671   * 210         75                             1697 436 302 671     210         75                       1697
1241690 1241690 MD     school 2400420 13   Howard 240042000822 623 Long Reach High   Regular School No High 09 12 2020   pk_12_total 370 614 388   * 219     *   100                             1696 370 614 388     219         100                       1696
1241311 1241311 MD     school 2400420 13   Howard 240042000743 207 Mount Hebron High   Regular School No High 09 12 2020   pk_12_total 717 217 163   * 525     *   67                             1695 717 217 163     525         67                       1695
1315537 1315537 MD     school 2400480 15   Montgomery 240048000926 798 Springbrook High   Regular School No High 09 12 2021   pk_12_total 104 660 665   * 218     *   45                             1694 104 660 665     218         45                       1694
1317272 1317272 MD     school 2400600 18   Saint Mary's 240060001218 303 Chopticon High   Regular School No High 09 12 2021   pk_12_total 1375 134 74   * 14     *   85                             1689 1375 134 74     14         85                       1689
1316243 1316243 MD     school 2400510 16   Prince George's 240051001708 1015 Chesapeake Math and IT Public Charter   Regular School Yes Other KG 12 2021   pk_12_total 56 1363 165   * 69     *   23                             1683 56 1363 165     69         23                       1683
1310895 1310895 MD     school 2400120 3   Baltimore County 240012000502 172 Woodlawn High   Regular School No High 09 12 2021   pk_12_total 48 1265 247   * 86     *   22                             1680 48 1265 247     86         22                       1680
1311897 1311897 MD     school 2400120 3   Baltimore County 240012000412 1572 Kenwood High   Regular School No High 09 12 2021   pk_12_total 623 705 194   * 44     *   103                             1679 623 705 194     44         103                       1679
1244774 1244774 MD     school 2400600 18   Saint Mary's 240060001224 801 Great Mills High   Regular School No High 09 12 2020   pk_12_total 653 592 225   * 79     *   122                             1678 653 592 225     79         122                       1678
1311404 1311404 MD     school 2400120 3   Baltimore County 240012000487 971 Towson High   Regular School No High 09 12 2021   pk_12_total 1036 303 99   * 133     *   102                             1677 1036 303 99     133         102                       1677
1244694 1244694 MD     school 2400600 18   Saint Mary's 240060001218 303 Chopticon High   Regular School No High 09 12 2020   pk_12_total 1376 127 66   * 13     *   79                             1669 1376 127 66     13         79                       1669
1243662 1243662 MD     school 2400510 16   Prince George's 240051001708 1015 Chesapeake Math and IT Public Charter   Regular School Yes Other KG 12 2020   pk_12_total 60 1343 150   * 74     *   27                             1664 60 1343 150     74         27                       1664
1238341 1238341 MD     school 2400120 3   Baltimore County 240012000502 172 Woodlawn High Center for Pre-Eng. Res.   Regular School No High 09 12 2020   pk_12_total 41 1277 229   * 82     *   21                             1656 41 1277 229     82         21                       1656
1314329 1314329 MD     school 2400480 15   Montgomery 240048000918 104 Seneca Valley High   Regular School No High 09 12 2021   pk_12_total 213 616 569   * 168     *   83                             1652 213 616 569     168         83                       1652
1239341 1239341 MD     school 2400120 3   Baltimore County 240012000412 1572 Kenwood High IB and Sports Science   Regular School No High 09 12 2020   pk_12_total 648 677 172   10 40     *   100                             1649 648 677 172   10 40         100                       1649
1313258 1313258 MD     school 2400330 10   Frederick 240033001550 2307 Tuscarora High   Regular School No High 09 12 2021   pk_12_total 690 356 379   * 125     *   87                             1645 690 356 379     125         87                       1645
1243258 1243258 MD     school 2400510 16   Prince George's 240051001686 509 Accokeek Academy   Regular School No Elementary KG 08 2020   pk_12_total 63 1236 209   * 68     12   44                             1637 63 1236 209     68     12   44                       1637
1313866 1313866 MD     school 2400420 13   Howard 240042000743 207 Mount Hebron High   Regular School No High 09 12 2021   pk_12_total 660 205 152   * 555     *   58                             1635 660 205 152     555         58                       1635
1241551 1241551 MD     school 2400420 13   Howard 240042001200 527 Reservoir High   Regular School No High 09 12 2020   pk_12_total 421 531 274   * 289     *   105                             1624 421 531 274     289         105                       1624
1238849 1238849 MD     school 2400120 3   Baltimore County 240012000487 971 Towson High Law & Public Policy   Regular School No High 09 12 2020   pk_12_total 1003 292 88   * 144         89                             1619 1003 292 88     144         89                       1619
1319251 1319251 MD     school 2400090 30   Baltimore City 240009000151 403 Baltimore Polytechnic Institute   Regular School No High 09 12 2021   pk_12_total 279 993 200   * 109     *   30                             1619 279 993 200     109         30                       1619
1314977 1314977 MD     school 2400480 15   Montgomery 240048000808 510 Col. Zadok Magruder High   Regular School No High 09 12 2021   pk_12_total 380 284 651   * 214     *   71                             1606 380 284 651     214         71                       1606
1241346 1241346 MD     school 2400420 13   Howard 240042000722 214 Centennial High   Regular School No High 09 12 2020   pk_12_total 630 146 73   * 651     *   90                             1597 630 146 73     651         90                       1597
1313970 1313970 MD     school 2400420 13   Howard 240042001437 308 Marriotts Ridge High   Regular School No High 09 12 2021   pk_12_total 675 159 58   * 626     *   73                             1597 675 159 58     626         73                       1597
1315047 1315047 MD     school 2400480 15   Montgomery 240048001525 545 Watkins Mill High   Regular School No High 09 12 2021   pk_12_total 103 418 876   * 153     *   44                             1597 103 418 876     153         44                       1597
1314247 1314247 MD     school 2400420 13   Howard 240042000822 623 Long Reach High   Regular School No High 09 12 2021   pk_12_total 372 547 380   * 205     *   87                             1595 372 547 380     205         87                       1595
1240705 1240705 MD     school 2400330 10   Frederick 240033001550 2307 Tuscarora High   Regular School No High 09 12 2020   pk_12_total 701 340 338   * 112     *   92                             1590 701 340 338     112         92                       1590
1242472 1242472 MD     school 2400480 15   Montgomery 240048001525 545 Watkins Mill High   Regular School No High 09 12 2020   pk_12_total 107 424 870     137     *   51                             1590 107 424 870     137         51                       1590
1246706 1246706 MD     school 2400090 30   Baltimore City 240009000151 403 Baltimore Polytechnic Institute   Regular School No High 09 12 2020   pk_12_total 258 1030 162   * 104     *   21                             1584 258 1030 162     104         21                       1584
1319150 1319150 MD     school 2400090 30   Baltimore City 240009001681 347 KIPP Harmony Academy   Regular School Yes Elementary KG 08 2021   pk_12_total * 1542 21   * *     *   *                             1575   1542 21                                       1575
1245326 1245326 MD     school 2400690 22   Wicomico 240069001305 1307 James M. Bennett High   Regular School No High 09 12 2020   pk_12_total 606 565 235   15 65     *   77                             1567 606 565 235   15 65         77                       1567
1241099 1241099 MD     school 2400390 12   Harford 240039000683 373 Bel Air High   Regular School No High 09 12 2020   pk_12_total 1163 123 102   * 113     *   56                             1560 1163 123 102     113         56                       1560
1313655 1313655 MD     school 2400390 12   Harford 240039000683 373 Bel Air High   Regular School No High 09 12 2021   pk_12_total 1146 121 102   * 119     *   63                             1557 1146 121 102     119         63                       1557
1315839 1315839 MD     school 2400510 16   Prince George's 240051001686 509 Accokeek Academy   Regular School No Elementary KG 08 2021   pk_12_total 57 1150 216   * 66     12   38                             1543 57 1150 216     66     12   38                       1543
1312939 1312939 MD     school 2400330 10   Frederick 240033000632 209 Frederick High   Regular School No High 09 12 2021   pk_12_total 388 393 587   * 104     *   61                             1542 388 393 587     104         61                       1542
1242346 1242346 MD     school 2400480 15   Montgomery 240048009000 428 Thomas W. Pyle Middle School   Regular School No Middle 06 08 2020   pk_12_total 987 49 163   * 214     *   118                             1534 987 49 163     214         118                       1534
1239715 1239715 MD     school 2400210 6   Carroll 240021000552 707 Westminster High   Regular School No High 09 12 2020   pk_12_total 1289 60 69     48     *   55                             1522 1289 60 69     48         55                       1522
1246600 1246600 MD     school 2400090 30   Baltimore City 240009001681 347 KIPP Harmony Academy   Regular School Yes Elementary KG 08 2020   pk_12_total * 1490 23               *                             1520   1490 23                                       1520
1312265 1312265 MD     school 2400210 6   Carroll 240021000552 707 Westminster High   Regular School No High 09 12 2021   pk_12_total 1242 70 84   * 56     *   59                             1515 1242 70 84     56         59                       1515
1238607 1238607 MD     school 2400120 3   Baltimore County 240012000390 472 Franklin High   Regular School No High 09 12 2020   pk_12_total 481 667 165   * 109     *   82                             1511 481 667 165     109         82                       1511
1240393 1240393 MD     school 2400330 10   Frederick 240033000632 209 Frederick High   Regular School No High 09 12 2020   pk_12_total 384 375 561   * 116     *   65                             1508 384 375 561     116         65                       1508
1243733 1243733 MD     school 2400510 16   Prince George's 240051001123 1209 Oxon Hill High   Regular School No High 09 12 2020   pk_12_total 31 859 451   * 114     *   31                             1497 31 859 451     114         31                       1497
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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