enrollments

Data source: Big Local News · About: Big Local

1,398 rows where grade = "pk_12_total", state = "MD" and year = 2020 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 1,298 ✖

grade ✖

  • pk_12_total · 1,298 ✖
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
1241103 1241103 MD     school 2400390 12   Harford 240039000682 374 Southampton Middle   Regular School No Middle 06 08 2020   pk_12_total 1007 75 62   * 42         73                             1261 1007 75 62     42         73                       1261
1240591 1240591 MD     school 2400330 10   Frederick 240033001688 920 Oakdale High   Regular School No High 09 12 2020   pk_12_total 961 63 116   * 68         54                             1267 961 63 116     68         54                       1267
1244427 1244427 MD     school 2400510 16   Prince George's 240051001175 2009 Thomas Johnson Middle   Regular School No Middle 06 08 2020   pk_12_total 32 639 553   * 35     *   *                             1269 32 639 553     35                                 1269
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1244574 1244574 MD     school 2400510 16   Prince George's 240051001755 2218 Career and Technical Education Evening High   Career and Technical School No Secondary 11 11 2020   pk_12_total   * 12   *           *                             15     12                                       15
1245124 1245124 MD     school 2400660 21   Washington 240066001258 1401 Cascade Elementary   Regular School No Elementary PK 05 2020   pk_12_total 139 * *     *         *                             150 139                                           150
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
1237392 1237392 MD     school 2400060 2   Anne Arundel 240006000066 1102 Ferndale Early Education Center   Regular School No Elementary PK KG 2020   pk_12_total 76 33 28   * *         *                             151 76 33 28                                       151
1242666 1242666 MD     school 2400480 15   Montgomery 240048000876 652 Monocacy Elementary   Regular School No Elementary KG 05 2020   pk_12_total 106 * 21     *         14                             151 106   21               14                       151
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
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
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
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
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
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
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
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
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
1244578 1244578 MD     school 2400510 16   Prince George's 240051001476 2300 Prekindergarten Offsites   Regular School No Prekindergarten PK PK 2020   pk_12_total * 12 *               *                             16   12                                         16
1237514 1237514 MD     school 2400060 2   Anne Arundel 240006000094 1274 Marley Glen School   Special Education School No Other PK 11 2020   pk_12_total 91 32 15   * 11     *   *                             160 91 32 15     11                                 160
1245954 1245954 MD     school 2400090 30   Baltimore City 240009000145 145 Alexander Hamilton Elementary   Regular School No Elementary PK 05 2020   pk_12_total   157 *               *                             160   157                                         160
1246538 1246538 MD     school 2400090 30   Baltimore City 240009001571 332 The Green School of Baltimore   Regular School Yes Elementary KG 05 2020   pk_12_total 57 74 11           *   18                             161 57 74 11               18                       161
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
1246491 1246491 MD     school 2400090 30   Baltimore City 240009001291 323 The Crossroads School   Regular School Yes Middle 06 08 2020   pk_12_total * 114 37   *           *                             162   114 37                                       162
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
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
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
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
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
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
1246444 1246444 MD     school 2400090 30   Baltimore City 240009000336 301 William S. Baer School   Special Education School No Other PK 12 2020   pk_12_total 15 126 21     *                                       167 15 126 21                                       167
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
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
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
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
1238450 1238450 MD     school 2400120 3   Baltimore County 240012001753 219 Watershed Public Charter   Regular School Yes Elementary KG 03 2020   pk_12_total 50 84 *   * *         21                             170 50 84                 21                       170
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
1240410 1240410 MD     school 2400330 10   Frederick 240033000634 213 Gov. Thomas Johnson High   Regular School No High 09 12 2020   pk_12_total 615 390 542   * 83     *   92                             1730 615 390 542     83         92                       1730
1242957 1242957 MD     school 2400480 15   Montgomery 240048000926 798 Springbrook High   Regular School No High 09 12 2020   pk_12_total 107 665 708   * 217         47                             1746 107 665 708     217         47                       1746
1239048 1239048 MD     school 2400120 3   Baltimore County 240012000377 1273 Dundalk High   Regular School No High 09 12 2020   pk_12_total 690 349 593   14 43     *   89                             1782 690 349 593   14 43         89                       1782
1242167 1242167 MD     school 2400480 15   Montgomery 240048001044 321 James Hubert Blake High   Regular School No High 09 12 2020   pk_12_total 285 737 518   * 184         67                             1795 285 737 518     184         67                       1795
1238193 1238193 MD     school 2400120 3   Baltimore County 240012001754 53 Northeast EDLP at Parkville High School   Alternative School No High 10 12 2020   pk_12_total * * *                                             18                                             18
1238197 1238197 MD     school 2400120 3   Baltimore County 240012001759 55 Southeast EDLP at Dundalk High School   Alternative School No High 10 12 2020   pk_12_total * 10 *               *                             18   10                                         18
1246466 1246466 MD     school 2400090 30   Baltimore City 240009001369 314 Sharp-Leadenhall Elementary   Special Education School No Elementary 01 05 2020   pk_12_total * 15                 *                             18   15                                         18
1242944 1242944 MD     school 2400480 15   Montgomery 240048001366 796 Northwood High School   Regular School No High 09 12 2020   pk_12_total 248 449 965   * 85         55                             1805 248 449 965     85         55                       1805
1240178 1240178 MD     school 2400270 8   Charles 240027001416 623 North Point High School   Regular School No High 09 12 2020   pk_12_total 295 1112 135   * 114     *   146                             1814 295 1112 135     114         146                       1814
1243013 1243013 MD     school 2400480 15   Montgomery 240048000855 815 John F. Kennedy High   Regular School No High 09 12 2020   pk_12_total 97 452 1116   * 124         26                             1817 97 452 1116     124         26                       1817
1242909 1242909 MD     school 2400480 15   Montgomery 240048000773 789 Albert Einstein High   Regular School No High 09 12 2020   pk_12_total 407 321 882   * 139         65                             1818 407 321 882     139         65                       1818
1238346 1238346 MD     school 2400120 3   Baltimore County 240012000355 174 Catonsville High   Regular School No High 09 12 2020   pk_12_total 929 462 110   * 223     *   95                             1826 929 462 110     223         95                       1826
1238236 1238236 MD     school 2400120 3   Baltimore County 240012001649 75 Crossroads Center   Alternative School No High 07 12 2020   pk_12_total 58 97 *   * *         16                             183 58 97                 16                       183
1240297 1240297 MD     school 2400300 9   Dorchester 240030000624 302 Vienna Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 131 26 *     *         18                             183 131 26                 18                       183
1239320 1239320 MD     school 2400120 3   Baltimore County 240012001406 1534 Oliver Beach Elementary   Regular School No Elementary PK 05 2020   pk_12_total 161 * *     *         15                             185 161                   15                       185
1245772 1245772 MD     school 2400090 30   Baltimore City 240009000312 73 Sarah M. Roach Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 174 *                                             185   174                                         185

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