enrollments

Data source: Big Local News · About: Big Local

19,213 rows where state = "MD" sorted by multiracial 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
1240506 1240506 MD     school 2400330 10   Frederick 240033000616 713 Urbana High   Regular School No High 09 12 2020   pk_12_total 1082 164 221   * 276     *   99                             1851 1082 164 221     276         99                       1851
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
1242291 1242291 MD     school 2400480 15   Montgomery 240048001118 413 North Bethesda Middle   Regular School No Middle 06 08 2020   pk_12_total 695 120 161   * 151     *   99                             1233 695 120 161     151         99                       1233
1242366 1242366 MD     school 2400480 15   Montgomery 240048000921 503 Sherwood High   Regular School No High 09 12 2020   pk_12_total 957 312 371     224     *   99                             1964 957 312 371     224         99                       1964
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
1245305 1245305 MD     school 2400690 22   Wicomico 240069001300 1103 Delmar Elementary   Regular School No Elementary PK 04 2020   pk_12_total 587 146 75   * 24     *   98                             932 587 146 75     24         98                       932
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
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
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
1241626 1241626 MD     school 2400420 13   Howard 240042000745 611 Oakland Mills High   Regular School No High 09 12 2020   pk_12_total 253 545 263     86     *   97                             1246 253 545 263     86         97                       1246
1245011 1245011 MD     school 2400660 21   Washington 240066001707 328 Ruth Ann Monroe Primary   Regular School No Elementary PK 02 2020   pk_12_total 203 181 94   * 19         97                             596 203 181 94     19         97                       596
1245173 1245173 MD     school 2400660 21   Washington 240066001276 2102 Northern Middle   Regular School No Middle 06 08 2020   pk_12_total 383 184 109     23     *   97                             799 383 184 109     23         97                       799
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
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
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
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
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
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
1239446 1239446 MD     school 2400150 4   Calvert 240015000508 213 Calvert High   Regular School No High 09 12 2020   pk_12_total 737 224 81   * 21     *   93                             1161 737 224 81     21         93                       1161
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
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
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
1244809 1244809 MD     school 2400600 18   Saint Mary's 240060001220 807 Esperanza Middle   Regular School No Middle 06 08 2020   pk_12_total 461 200 81     31     *   92                             867 461 200 81     31         92                       867
1239866 1239866 MD     school 2400240 7   Cecil 240024000568 302 Elkton High   Regular School No High 09 12 2020   pk_12_total 480 288 128   * 13     *   91                             1005 480 288 128     13         91                       1005
1241827 1241827 MD     school 2400480 15   Montgomery 240048001509 125 Quince Orchard High   Regular School No High 09 12 2020   pk_12_total 818 351 607   * 278     *   91                             2148 818 351 607     278         91                       2148
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
1238956 1238956 MD     school 2400120 3   Baltimore County 240012000375 1202 Dundalk Elementary   Regular School No Elementary PK 05 2020   pk_12_total 265 234 174   10       *   90                             776 265 234 174   10           90                       776
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
1244011 1244011 MD     school 2400510 16   Prince George's 240051000990 1423 Bowie High   Regular School No High 09 12 2020   pk_12_total 240 1645 359   * 84     *   90                             2428 240 1645 359     84         90                       2428
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
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
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
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
1241542 1241542 MD     school 2400420 13   Howard 240042000859 525 Fulton Elementary   Regular School No Elementary KG 05 2020   pk_12_total 423 164 47   * 296     *   89                             1021 423 164 47     296         89                       1021
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
1237222 1237222 MD     school 2400030 1   Allegany 240003001359 401 South Penn Elementary   Regular School No Elementary PK 05 2020   pk_12_total 421 51 *     *         88                             571 421 51                 88                       571
1240038 1240038 MD     school 2400270 8   Charles 240027000596 106 La Plata High School   Regular School No High 09 12 2020   pk_12_total 750 225 57   * 33     *   88                             1159 750 225 57     33         88                       1159
1240931 1240931 MD     school 2400390 12   Harford 240039000716 140 William Paca/Old Post Road Elementary   Regular School No Elementary PK 05 2020   pk_12_total 210 386 158   10 13         88                             865 210 386 158   10 13         88                       865
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
1240770 1240770 MD     school 2400330 10   Frederick 240033000655 2610 Walkersville High   Regular School No High 09 12 2020   pk_12_total 747 161 145   * 39     *   86                             1185 747 161 145     39         86                       1185
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
1238948 1238948 MD     school 2400120 3   Baltimore County 240012000446 1171 Perry Hall High   Regular School No High 09 12 2020   pk_12_total 939 591 93   * 255     *   85                             1969 939 591 93     255         85                       1969
1239381 1239381 MD     school 2400150 4   Calvert 240015000611 113 Patuxent High   Regular School No High 09 12 2020   pk_12_total 698 186 65   * 24     *   85                             1063 698 186 65     24         85                       1063
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
1245148 1245148 MD     school 2400660 21   Washington 240066001278 1802 Pangborn Elementary   Regular School No Elementary PK 05 2020   pk_12_total 289 184 158   * 22         85                             739 289 184 158     22         85                       739
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
1237524 1237524 MD     school 2400060 2   Anne Arundel 240006000127 2013 Severna Park High   Regular School No High 09 12 2020   pk_12_total 1589 77 97   * 81     *   84                             1932 1589 77 97     81         84                       1932
1240884 1240884 MD     school 2400390 12   Harford 240039000686 120 Deerfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 194 370 83   * 17     *   84                             752 194 370 83     17         84                       752
1240401 1240401 MD     school 2400330 10   Frederick 240033000645 210 North Frederick Elementary   Regular School No Elementary PK 05 2020   pk_12_total 250 122 182     31     *   83                             669 250 122 182     31         83                       669
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
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
1238943 1238943 MD     school 2400120 3   Baltimore County 240012000447 1151 Perry Hall Middle   Regular School No Middle 06 08 2020   pk_12_total 954 491 93   * 295     *   82                             1925 954 491 93     295         82                       1925
1239507 1239507 MD     school 2400150 4   Calvert 240015000967 318 Windy Hill Middle   Regular School No Middle 06 08 2020   pk_12_total 557 87 48   * 12     *   82                             789 557 87 48     12         82                       789
1242337 1242337 MD     school 2400480 15   Montgomery 240048000776 425 Ashburton Elementary   Regular School No Elementary KG 05 2020   pk_12_total 362 153 160   * 160     *   81                             922 362 153 160     160         81                       922
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
1237832 1237832 MD     school 2400060 2   Anne Arundel 240006000119 3192 Ridgeway Elementary   Regular School No Elementary KG 05 2020   pk_12_total 333 145 99     25     *   80                             686 333 145 99     25         80                       686
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
1237373 1237373 MD     school 2400060 2   Anne Arundel 240006000095 1063 Marley Middle   Regular School No Middle 06 08 2020   pk_12_total 359 255 213   * 28     *   79                             938 359 255 213     28         79                       938
1238724 1238724 MD     school 2400120 3   Baltimore County 240012000373 872 Dulaney High   Regular School No High 09 12 2020   pk_12_total 979 393 199   * 257     *   79                             1914 979 393 199     257         79                       1914
1240025 1240025 MD     school 2400270 8   Charles 240027000601 104 Milton M. Somers Middle School   Regular School No Middle 06 08 2020   pk_12_total 444 428 86   * 45     *   79                             1086 444 428 86     45         79                       1086
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
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
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
1241193 1241193 MD     school 2400390 12   Harford 240039000695 632 Havre de Grace Elementary   Regular School No Elementary PK 05 2020   pk_12_total 326 130 60     14     *   78                             609 326 130 60     14         78                       609
1242457 1242457 MD     school 2400480 15   Montgomery 240048001441 522 Lakelands Park Middle   Regular School No Middle 06 08 2020   pk_12_total 443 199 298   * 181         78                             1200 443 199 298     181         78                       1200
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

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