enrollments

Data source: Big Local News · About: Big Local

9,598 rows where state = "MD" and year = 2021 sorted by multiracial descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 9,598 ✖
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
1311603 1311603 MD     school 2400120 3   Baltimore County 240012000377 1273 Dundalk High   Regular School No High 09 12 2021   pk_12_total 691 335 661   16 37     *   99                             1842 691 335 661   16 37         99                       1842
1311920 1311920 MD     school 2400150 4   Calvert 240015000504 101 Patuxent Appeal Elementary Campus   Regular School No Elementary PK 05 2021   pk_12_total 394 118 52     *     *   99                             667 394 118 52               99                       667
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
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
1312001 1312001 MD     school 2400150 4   Calvert 240015000508 213 Calvert High   Regular School No High 09 12 2021   pk_12_total 696 222 89   * 24     *   96                             1132 696 222 89     24         96                       1132
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
1314936 1314936 MD     school 2400480 15   Montgomery 240048000921 503 Sherwood High   Regular School No High 09 12 2021   pk_12_total 938 290 363     225         96                             1912 938 290 363     225         96                       1912
1317723 1317723 MD     school 2400660 21   Washington 240066001278 1802 Pangborn Elementary   Regular School No Elementary PK 05 2021   pk_12_total 243 177 158     16         96                             690 243 177 158     16         96                       690
1310086 1310086 MD     school 2400060 2   Anne Arundel 240006000127 2013 Severna Park High   Regular School No High 09 12 2021   pk_12_total 1525 68 109   * 78     *   95                             1880 1525 68 109     78         95                       1880
1314566 1314566 MD     school 2400480 15   Montgomery 240048000934 234 Thomas S. Wootton High   Regular School No High 09 12 2021   pk_12_total 817 211 169   * 743         95                             2037 817 211 169     743         95                       2037
1310900 1310900 MD     school 2400120 3   Baltimore County 240012000355 174 Catonsville High   Regular School No High 09 12 2021   pk_12_total 929 443 100   * 233     *   94                             1809 929 443 100     233         94                       1809
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
1317715 1317715 MD     school 2400660 21   Washington 240066001253 1701 Bester Elementary   Regular School No Elementary PK 05 2021   pk_12_total 176 131 85   * *         94                             491 176 131 85               94                       491
1313437 1313437 MD     school 2400390 12   Harford 240039000686 120 Deerfield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 168 352 92   * 12     *   93                             720 168 352 92     12         93                       720
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
1317570 1317570 MD     school 2400660 21   Washington 240066001263 304 E. Russell Hicks Middle   Regular School No Middle 06 08 2021   pk_12_total 395 215 157   * 31         91                             890 395 215 157     31         91                       890
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
1313323 1313323 MD     school 2400330 10   Frederick 240033000655 2610 Walkersville High   Regular School No High 09 12 2021   pk_12_total 733 183 168   * 44     *   89                             1219 733 183 168     44         89                       1219
1313484 1313484 MD     school 2400390 12   Harford 240039000716 140 William Paca/Old Post Road Elementary   Regular School No Elementary PK 05 2021   pk_12_total 199 378 150   * 11         89                             836 199 378 150     11         89                       836
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
1311936 1311936 MD     school 2400150 4   Calvert 240015000611 113 Patuxent High   Regular School No High 09 12 2021   pk_12_total 716 190 68   * 20         88                             1085 716 190 68     20         88                       1085
1314386 1314386 MD     school 2400480 15   Montgomery 240048001509 125 Quince Orchard High   Regular School No High 09 12 2021   pk_12_total 789 351 616   * 244     *   88                             2091 789 351 616     244         88                       2091
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
1311279 1311279 MD     school 2400120 3   Baltimore County 240012000373 872 Dulaney High   Regular School No High 09 12 2021   pk_12_total 930 438 221   * 248     *   87                             1930 930 438 221     248         87                       1930
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
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
1314906 1314906 MD     school 2400480 15   Montgomery 240048000776 425 Ashburton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 343 143 162   * 159     *   87                             900 343 143 162     159         87                       900
1311498 1311498 MD     school 2400120 3   Baltimore County 240012000447 1151 Perry Hall Middle   Regular School No Middle 06 08 2021   pk_12_total 885 502 86   * 312     *   86                             1878 885 502 86     312         86                       1878
1311511 1311511 MD     school 2400120 3   Baltimore County 240012000375 1202 Dundalk Elementary   Regular School No Elementary PK 05 2021   pk_12_total 233 221 176   * *     *   86                             732 233 221 176               86                       732
1317825 1317825 MD     school 2400690 22   Wicomico 240069001319 510 Wicomico Middle   Regular School No Middle 06 08 2021   pk_12_total 189 372 155   * 17     *   86                             829 189 372 155     17         86                       829
1309783 1309783 MD     school 2400030 1   Allegany 240003001359 401 South Penn Elementary   Regular School No Elementary PK 05 2021   pk_12_total 361 40 *     *         85                             497 361 40                 85                       497
1311503 1311503 MD     school 2400120 3   Baltimore County 240012000446 1171 Perry Hall High   Regular School No High 09 12 2021   pk_12_total 904 659 107   * 256     *   85                             2018 904 659 107     256         85                       2018
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
1317387 1317387 MD     school 2400600 18   Saint Mary's 240060001220 807 Esperanza Middle   Regular School No Middle 06 08 2021   pk_12_total 459 193 80     38     *   85                             858 459 193 80     38         85                       858
1310696 1310696 MD     school 2400060 2   Anne Arundel 240006000055 4293 South River High   Regular School No High 09 12 2021   pk_12_total 1415 100 228   * 86     *   83                             1916 1415 100 228     86         83                       1916
1311659 1311659 MD     school 2400120 3   Baltimore County 240012000342 1356 Arbutus Middle   Regular School No Middle 06 08 2021   pk_12_total 522 205 46   * 140     *   83                             1004 522 205 46     140         83                       1004
1312573 1312573 MD     school 2400270 8   Charles 240027000601 104 Milton M. Somers Middle School   Regular School No Middle 06 08 2021   pk_12_total 386 437 103   * 37     *   83                             1049 386 437 103     37         83                       1049
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
1315489 1315489 MD     school 2400480 15   Montgomery 240048000773 789 Albert Einstein High   Regular School No High 09 12 2021   pk_12_total 462 336 916   * 117         83                             1921 462 336 916     117         83                       1921
1312111 1312111 MD     school 2400180 5   Caroline 240018000523 703 North Caroline High School   Regular School No High 09 12 2021   pk_12_total 743 113 213   * 10     *   81                             1164 743 113 213     10         81                       1164
1309930 1309930 MD     school 2400060 2   Anne Arundel 240006000087 1053 Lindale Middle   Regular School No Middle 06 08 2021   pk_12_total 490 347 222   * 51     *   80                             1194 490 347 222     51         80                       1194
1310462 1310462 MD     school 2400060 2   Anne Arundel 240006000108 3343 Old Mill Middle South   Regular School No Middle 06 08 2021   pk_12_total 495 237 169   * 33     *   80                             1018 495 237 169     33         80                       1018
1315034 1315034 MD     school 2400480 15   Montgomery 240048001441 522 Lakelands Park Middle   Regular School No Middle 06 09 2021   pk_12_total 409 181 301   * 210         80                             1182 409 181 301     210         80                       1182
1310442 1310442 MD     school 2400060 2   Anne Arundel 240006000069 3272 Four Seasons Elementary   Regular School No Elementary PK 05 2021   pk_12_total 338 139 57   * 49     *   79                             665 338 139 57     49         79                       665
1312738 1312738 MD     school 2400270 8   Charles 240027001647 625 Theodore G. Davis Middle School   Regular School No Middle 06 08 2021   pk_12_total 70 601 98   * 30     *   79                             885 70 601 98     30         79                       885
1313460 1313460 MD     school 2400390 12   Harford 240039000468 125 Church Creek Elementary   Regular School No Elementary PK 05 2021   pk_12_total 231 284 59     24     *   79                             678 231 284 59     24         79                       678
1317586 1317586 MD     school 2400660 21   Washington 240066001707 328 Ruth Ann Monroe Primary   Regular School No Elementary PK 02 2021   pk_12_total 176 178 99   * 22         79                             556 176 178 99     22         79                       556
1309934 1309934 MD     school 2400060 2   Anne Arundel 240006000095 1063 Marley Middle   Regular School No Middle 06 08 2021   pk_12_total 335 265 241   * 32     *   78                             956 335 265 241     32         78                       956
1313774 1313774 MD     school 2400390 12   Harford 240039000696 679 Havre de Grace Middle   Regular School No Middle 06 08 2021   pk_12_total 364 114 49   * *     *   78                             613 364 114 49               78                       613
1317881 1317881 MD     school 2400690 22   Wicomico 240069001300 1103 Delmar Elementary   Regular School No Elementary PK 04 2021   pk_12_total 505 158 68   * 33         78                             843 505 158 68     33         78                       843
1311884 1311884 MD     school 2400120 3   Baltimore County 240012001440 1556 Middle River Middle   Regular School No Middle 06 08 2021   pk_12_total 355 540 124   * 32     *   77                             1132 355 540 124     32         77                       1132
1312062 1312062 MD     school 2400150 4   Calvert 240015000967 318 Windy Hill Middle   Regular School No Middle 06 08 2021   pk_12_total 517 89 54   * *     *   77                             746 517 89 54               77                       746
1313468 1313468 MD     school 2400390 12   Harford 240039000706 131 Magnolia Elementary   Regular School No Elementary PK 05 2021   pk_12_total 47 336 52   * *         77                             517 47 336 52               77                       517
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
1317395 1317395 MD     school 2400600 18   Saint Mary's 240060001234 808 Park Hall Elementary   Regular School No Elementary PK 05 2021   pk_12_total 187 216 50   * 13     *   77                             547 187 216 50     13         77                       547
1317834 1317834 MD     school 2400690 22   Wicomico 240069001320 513 Wicomico High   Regular School No High 09 12 2021   pk_12_total 306 592 178   * 32     *   77                             1190 306 592 178     32         77                       1190
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
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
1311593 1311593 MD     school 2400120 3   Baltimore County 240012001438 1255 General John Stricker Middle   Regular School No Middle 06 08 2021   pk_12_total 487 152 104   11 16         76                             846 487 152 104   11 16         76                       846
1312058 1312058 MD     school 2400150 4   Calvert 240015000790 317 Windy Hill Elementary   Regular School No Elementary PK 05 2021   pk_12_total 447 50 50   * 12     *   76                             637 447 50 50     12         76                       637
1312418 1312418 MD     school 2400240 7   Cecil 240024000567 303 Elkton Middle   Regular School No Middle 06 08 2021   pk_12_total 216 178 95   * *     *   76                             574 216 178 95               76                       574
1314098 1314098 MD     school 2400420 13   Howard 240042000859 525 Fulton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 306 132 41   * 281         76                             838 306 132 41     281         76                       838
1316592 1316592 MD     school 2400510 16   Prince George's 240051000990 1423 Bowie High   Regular School No High 09 12 2021   pk_12_total 237 1608 381   * 94     *   76                             2406 237 1608 381     94         76                       2406
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
1313624 1313624 MD     school 2400390 12   Harford 240039000701 335 Homestead/Wakefield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 710 54 81   * 70     *   75                             996 710 54 81     70         75                       996
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
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
1311152 1311152 MD     school 2400120 3   Baltimore County 240012000389 451 Franklin Middle   Regular School No Middle 06 08 2021   pk_12_total 271 625 197   * 88     *   73                             1258 271 625 197     88         73                       1258
1312026 1312026 MD     school 2400150 4   Calvert 240015000505 302 Beach Elementary   Regular School No Elementary PK 05 2021   pk_12_total 313 51 42   * *     *   73                             483 313 51 42               73                       483
1313452 1313452 MD     school 2400390 12   Harford 240039000162 123 Abingdon Elementary   Regular School No Elementary PK 05 2021   pk_12_total 357 150 44   * 19     *   73                             649 357 150 44     19         73                       649
1313510 1313510 MD     school 2400390 12   Harford 240039001352 184 Magnolia Middle   Regular School No Middle 06 08 2021   pk_12_total 209 405 109   * 14         73                             812 209 405 109     14         73                       812
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
1312644 1312644 MD     school 2400270 8   Charles 240027000595 608 John Hanson Middle School   Regular School No Middle 06 08 2021   pk_12_total 135 488 129   * 17     *   72                             849 135 488 129     17         72                       849
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
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
1310288 1310288 MD     school 2400060 2   Anne Arundel 240006000090 3033 MacArthur Middle   Regular School No Middle 06 08 2021   pk_12_total 172 460 135   * 48     *   71                             898 172 460 135     48         71                       898
1311391 1311391 MD     school 2400120 3   Baltimore County 240012000374 953 Dumbarton Middle   Regular School No Middle 06 08 2021   pk_12_total 656 151 167     103     *   71                             1152 656 151 167     103         71                       1152
1311409 1311409 MD     school 2400120 3   Baltimore County 240012000443 972 Parkville High   Regular School No High 09 12 2021   pk_12_total 423 925 485   * 161     *   71                             2075 423 925 485     161         71                       2075
1312696 1312696 MD     school 2400270 8   Charles 240027001519 618 William B. Wade Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 72 385 50   * 39         71                             619 72 385 50     39         71                       619
1312956 1312956 MD     school 2400330 10   Frederick 240033000634 213 Gov. Thomas Johnson High   Regular School No High 09 12 2021   pk_12_total 582 412 586   * 82     *   71                             1744 582 412 586     82         71                       1744
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
1310383 1310383 MD     school 2400060 2   Anne Arundel 240006000106 3172 Odenton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 177 140 102   * 28     *   70                             519 177 140 102     28         70                       519
1313067 1313067 MD     school 2400330 10   Frederick 240033001536 716 Urbana Middle   Regular School No Middle 06 08 2021   pk_12_total 483 91 112   * 208     *   70                             967 483 91 112     208         70                       967
1317471 1317471 MD     school 2400630 20   Talbot 240063001244 104 Easton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 304 217 424     33         70                             1048 304 217 424     33         70                       1048
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
1309917 1309917 MD     school 2400060 2   Anne Arundel 240006000050 1023 Brooklyn Park Middle   Regular School No Middle 06 08 2021   pk_12_total 370 221 190   * 18     *   69                             875 370 221 190     18         69                       875
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
1312082 1312082 MD     school 2400180 5   Caroline 240018000526 302 Lockerman Middle School   Regular School No Middle 06 08 2021   pk_12_total 544 96 184     *         69                             902 544 96 184               69                       902
1313318 1313318 MD     school 2400330 10   Frederick 240033000654 2607 Walkersville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 291 132 116   * 18     *   69                             631 291 132 116     18         69                       631
1315068 1315068 MD     school 2400480 15   Montgomery 240048000838 551 Gaithersburg High   Regular School No High 09 12 2021   pk_12_total 274 497 1366   * 151         69                             2359 274 497 1366     151         69                       2359
1317874 1317874 MD     school 2400690 22   Wicomico 240069001145 910 Salisbury Middle   Regular School No Middle 06 08 2021   pk_12_total 222 475 83   * 41     *   69                             897 222 475 83     41         69                       897
1310397 1310397 MD     school 2400060 2   Anne Arundel 240006000119 3192 Ridgeway Elementary   Regular School No Elementary KG 05 2021   pk_12_total 285 148 95   * 34     *   68                             632 285 148 95     34         68                       632
1312721 1312721 MD     school 2400270 8   Charles 240027000805 622 Berry Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 59 404 84   * 55     *   68                             675 59 404 84     55         68                       675
1317540 1317540 MD     school 2400660 21   Washington 240066001290 201 Springfield Middle   Regular School No Middle 06 08 2021   pk_12_total 581 90 104   * 14     *   68                             859 581 90 104     14         68                       859
1317675 1317675 MD     school 2400660 21   Washington 240066000418 1002 Eastern Elementary   Regular School No Elementary 03 05 2021   pk_12_total 141 118 81   * *         68                             418 141 118 81               68                       418
1317906 1317906 MD     school 2400690 22   Wicomico 240069001299 1308 Bennett Middle   Regular School No Middle 06 08 2021   pk_12_total 380 351 137   * 34     *   68                             980 380 351 137     34         68                       980
1312078 1312078 MD     school 2400180 5   Caroline 240018000520 301 Denton Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 381 130 39     17         67                             634 381 130 39     17         67                       634
1312766 1312766 MD     school 2400270 8   Charles 240027000592 703 J. C. Parks Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 52 364 83   * 20     *   67                             592 52 364 83     20         67                       592
1312947 1312947 MD     school 2400330 10   Frederick 240033000645 210 North Frederick Elementary   Regular School No Elementary PK 05 2021   pk_12_total 232 113 160     27         67                             599 232 113 160     27         67                       599
1312976 1312976 MD     school 2400330 10   Frederick 240033090471 223 Ballenger Creek Elementary   Regular School No Elementary PK 05 2021   pk_12_total 197 138 128   * 66     *   67                             602 197 138 128     66         67                       602

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