enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pk_12_total · 2,691 ✖
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
1318158 1318158 MD     school 2400090 30   Baltimore City 240009000153 34 Charles Carroll Barrister Elementary   Regular School No Elementary PK 05 2021   pk_12_total 52 131 143   * *                                       336 52 131 143                                       336
1318286 1318286 MD     school 2400090 30   Baltimore City 240009000229 60 Gwynns Falls Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 284 *                                             286   284                                         286
1318294 1318294 MD     school 2400090 30   Baltimore City 240009000256 61 Dorothy I. Height Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 324 *   *                                         339   324                                         339
1318412 1318412 MD     school 2400090 30   Baltimore City 240009000337 87 Windsor Hills Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 215 13     *     *                                 237   215 13                                       237
1318461 1318461 MD     school 2400090 30   Baltimore City 240009000309 122 The Historic Samuel Coleridge-Taylor Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 218 *                                             220   218                                         220
1318484 1318484 MD     school 2400090 30   Baltimore City 240009000160 130 Booker T. Washington Middle   Regular School No Middle 06 08 2021   pk_12_total * 218 *                                             225   218                                         225
1318503 1318503 MD     school 2400090 30   Baltimore City 240009000303 142 Robert W. Coleman Elementary   Regular School No Elementary PK 05 2021   pk_12_total   227 *                                             234   227                                         234
1318597 1318597 MD     school 2400090 30   Baltimore City 240009000210 206 Furley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 13 411 25   * *                                       457 13 411 25                                       457
1318681 1318681 MD     school 2400090 30   Baltimore City 240009000340 219 Yorkwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 348 *   * *     *                                 363   348                                         363
1318969 1318969 MD     school 2400090 30   Baltimore City 240009000260 261 Lockerman Bundy Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 207 *   * *                                       215   207                                         215
1318980 1318980 MD     school 2400090 30   Baltimore City 240009001558 262 Empowerment Academy   Regular School Yes Elementary PK 08 2021   pk_12_total   284 *                                             287   284                                         287
1318995 1318995 MD     school 2400090 30   Baltimore City 240009000336 301 William S. Baer School   Special Education School No Other PK 12 2021   pk_12_total 14 112 20     *                                       148 14 112 20                                       148
1319001 1319001 MD     school 2400090 30   Baltimore City 240009000176 307 Claremont School   Special Education School No High 07 12 2021   pk_12_total * 47 *                                             51   47                                         51
1319011 1319011 MD     school 2400090 30   Baltimore City 240009001364 313 Lois T. Murray Elementary/Middle   Special Education School No Elementary KG 08 2021   pk_12_total * 34 *                                             44   34                                         44
1319038 1319038 MD     school 2400090 30   Baltimore City 240009000884 322 New Song Academy   Regular School Yes Elementary PK 08 2021   pk_12_total   172 *                                             174   172                                         174
1319094 1319094 MD     school 2400090 30   Baltimore City 240009001632 333 Independence School Local I   Regular School Yes High 09 12 2021   pk_12_total 15 138 *                                             155 15 138                                         155
1319117 1319117 MD     school 2400090 30   Baltimore City 240009001661 337 Afya Public Charter School   Regular School Yes Middle 08 08 2021   pk_12_total   105 *                                             112   105                                         112
1319171 1319171 MD     school 2400090 30   Baltimore City 240009001675 364 Bluford Drew Jemison STEM Academy West   Regular School No High 06 12 2021   pk_12_total * 220 *                                             226   220                                         226
1319187 1319187 MD     school 2400090 30   Baltimore City 240009001734 371 Lillie May Carroll Jackson School   Regular School Yes Middle 05 08 2021   pk_12_total   306 *                                             309   306                                         309
1319221 1319221 MD     school 2400090 30   Baltimore City 240009001691 377 Green Street Academy   Regular School Yes High 06 12 2021   pk_12_total 15 843 17     *                                       876 15 843 17                                       876
1319276 1319276 MD     school 2400090 30   Baltimore City 240009000236 413 Achievement Academy at Harbor City High   Alternative School No High 09 12 2021   pk_12_total * 350 20   *                                         372   350 20                                       372
1319309 1319309 MD     school 2400090 30   Baltimore City 240009001559 422 New Era Academy   Regular School No High 09 12 2021   pk_12_total 14 232 141     *                                       388 14 232 141                                       388
1319332 1319332 MD     school 2400090 30   Baltimore City 240009001530 432 Coppin Academy   Regular School Yes High 09 12 2021   pk_12_total * 351 *                                             359   351                                         359
1319357 1319357 MD     school 2400090 30   Baltimore City 240009000885 884 Eager Street Academy   Alternative School No High 09 12 2021   pk_12_total * 35 *           *                                 39   35                                         39
1237718 1237718 MD     school 2400060 2   Anne Arundel 240006000040 3013 Arundel High   Regular School No High 09 12 2020   pk_12_total 1089 595 177   * 127     12   198                             2200 1089 595 177     127     12   198                       2200
1310280 1310280 MD     school 2400060 2   Anne Arundel 240006000040 3013 Arundel High   Regular School No High 09 12 2021   pk_12_total 873 545 149   * 97     12   197                             1876 873 545 149     97     12   197                       1876
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
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
1242330 1242330 MD     school 2400480 15   Montgomery 240048000942 424 Walter Johnson High   Regular School No High 09 12 2020   pk_12_total 1431 291 471   * 380         165                             2747 1431 291 471     380         165                       2747
1314898 1314898 MD     school 2400480 15   Montgomery 240048000942 424 Walter Johnson High   Regular School No High 09 12 2021   pk_12_total 1457 322 477   * 387     *   163                             2820 1457 322 477     387         163                       2820
1310467 1310467 MD     school 2400060 2   Anne Arundel 240006000109 3353 Old Mill High   Regular School No High 09 12 2021   pk_12_total 906 829 344   * 117     10   153                             2364 906 829 344     117     10   153                       2364
1317744 1317744 MD     school 2400660 21   Washington 240066001275 2101 North Hagerstown High   Regular School No High 09 12 2021   pk_12_total 653 278 205   * 54     *   150                             1343 653 278 205     54         150                       1343
1245185 1245185 MD     school 2400660 21   Washington 240066001283 2503 Salem Avenue Elementary   Regular School No Elementary PK 05 2020   pk_12_total 308 180 132   * *     *   147                             772 308 180 132               147                       772
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
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
1314435 1314435 MD     school 2400480 15   Montgomery 240048000902 201 Richard Montgomery High   Regular School No High 09 12 2021   pk_12_total 699 399 577   * 586     *   143                             2410 699 399 577     586         143                       2410
1237902 1237902 MD     school 2400060 2   Anne Arundel 240006000109 3353 Old Mill High   Regular School No High 09 12 2020   pk_12_total 892 821 311   * 104     10   139                             2281 892 821 311     104     10   139                       2281
1240994 1240994 MD     school 2400390 12   Harford 240039000678 265 Aberdeen Middle   Regular School No Middle 06 08 2020   pk_12_total 411 488 131   * 26     *   139                             1203 411 488 131     26         139                       1203
1312726 1312726 MD     school 2400270 8   Charles 240027001416 623 North Point High School   Regular School No High 09 12 2021   pk_12_total 286 1130 141   * 108     *   139                             1813 286 1130 141     108         139                       1813
1315337 1315337 MD     school 2400480 15   Montgomery 240048000877 757 Montgomery Blair High   Regular School No High 09 12 2021   pk_12_total 780 773 1106   * 414     *   139                             3220 780 773 1106     414         139                       3220
1310081 1310081 MD     school 2400060 2   Anne Arundel 240006090441 1323 North County High   Regular School No High 09 12 2021   pk_12_total 963 634 463   * 118     *   138                             2327 963 634 463     118         138                       2327
1314911 1314911 MD     school 2400480 15   Montgomery 240048000941 427 Walt Whitman High   Regular School No High 09 12 2021   pk_12_total 1285 81 205   * 278     *   138                             1991 1285 81 205     278         138                       1991
1317281 1317281 MD     school 2400600 18   Saint Mary's 240060001356 306 Leonardtown High   Regular School No High 09 12 2021   pk_12_total 1366 162 117   * 58     *   138                             1846 1366 162 117     58         138                       1846
1310454 1310454 MD     school 2400060 2   Anne Arundel 240006000099 3323 Meade High   Regular School No High 09 12 2021   pk_12_total 245 1030 549   * 113     10   136                             2087 245 1030 549     113     10   136                       2087
1241877 1241877 MD     school 2400480 15   Montgomery 240048000902 201 Richard Montgomery High   Regular School No High 09 12 2020   pk_12_total 729 430 591   * 615     *   135                             2505 729 430 591     615         135                       2505
1242757 1242757 MD     school 2400480 15   Montgomery 240048000877 757 Montgomery Blair High   Regular School No High 09 12 2020   pk_12_total 770 779 1085   * 450     *   134                             3223 770 779 1085     450         134                       3223
1237519 1237519 MD     school 2400060 2   Anne Arundel 240006090441 1323 North County High   Regular School No High 09 12 2020   pk_12_total 1017 593 414   * 119     *   133                             2286 1017 593 414     119         133                       2286
1315207 1315207 MD     school 2400480 15   Montgomery 240048000956 602 Winston Churchill High   Regular School No High 09 12 2021   pk_12_total 1016 226 178   * 688     *   132                             2245 1016 226 178     688         132                       2245
1313547 1313547 MD     school 2400390 12   Harford 240039000678 265 Aberdeen Middle   Regular School No Middle 06 08 2021   pk_12_total 407 495 135   * 26     *   131                             1204 407 495 135     26         131                       1204
1237691 1237691 MD     school 2400060 2   Anne Arundel 240006001402 2363 Broadneck High   Regular School No High 09 12 2020   pk_12_total 1635 170 212   10 60     *   130                             2221 1635 170 212   10 60         130                       2221
1310253 1310253 MD     school 2400060 2   Anne Arundel 240006001402 2363 Broadneck High   Regular School No High 09 12 2021   pk_12_total 1634 158 234   * 63     *   130                             2233 1634 158 234     63         130                       2233
1314834 1314834 MD     school 2400480 15   Montgomery 240048000784 406 Bethesda-Chevy Chase High   Regular School No High 09 12 2021   pk_12_total 1263 333 400   * 139     *   130                             2270 1263 333 400     139         130                       2270
1317760 1317760 MD     school 2400660 21   Washington 240066001283 2503 Salem Avenue Elementary   Regular School No Elementary PK 05 2021   pk_12_total 261 166 125   * *     *   130                             687 261 166 125               130                       687
1237889 1237889 MD     school 2400060 2   Anne Arundel 240006000099 3323 Meade High   Regular School No High 09 12 2020   pk_12_total 259 1021 508   * 103     *   129                             2029 259 1021 508     103         129                       2029
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
1314615 1314615 MD     school 2400480 15   Montgomery 240048001040 246 Northwest High   Regular School No High 09 12 2021   pk_12_total 655 674 588   * 551         129                             2598 655 674 588     551         129                       2598
1242629 1242629 MD     school 2400480 15   Montgomery 240048000956 602 Winston Churchill High   Regular School No High 09 12 2020   pk_12_total 1063 212 178   * 687     *   128                             2274 1063 212 178     687         128                       2274
1244703 1244703 MD     school 2400600 18   Saint Mary's 240060001356 306 Leonardtown High   Regular School No High 09 12 2020   pk_12_total 1426 163 103   * 60     *   128                             1889 1426 163 103     60         128                       1889
1313854 1313854 MD     school 2400420 13   Howard 240042000738 203 Howard High   Regular School No High 09 12 2021   pk_12_total 824 411 142   * 317     *   127                             1828 824 411 142     317         127                       1828
1241299 1241299 MD     school 2400420 13   Howard 240042000738 203 Howard High   Regular School No High 09 12 2020   pk_12_total 898 423 133   * 323     *   126                             1910 898 423 133     323         126                       1910
1242057 1242057 MD     school 2400480 15   Montgomery 240048001040 246 Northwest High   Regular School No High 09 12 2020   pk_12_total 684 645 605   * 559     *   126                             2623 684 645 605     559         126                       2623
1242342 1242342 MD     school 2400480 15   Montgomery 240048000941 427 Walt Whitman High   Regular School No High 09 12 2020   pk_12_total 1366 80 179   * 284     *   126                             2039 1366 80 179     284         126                       2039
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
1237722 1237722 MD     school 2400060 2   Anne Arundel 240006000039 3023 Arundel Middle   Regular School No Middle 06 08 2020   pk_12_total 480 283 118   * 57     *   122                             1068 480 283 118     57         122                       1068
1244657 1244657 MD     school 2400600 18   Saint Mary's 240060001237 101 Spring Ridge Middle   Regular School No Middle 06 08 2020   pk_12_total 402 377 125   * 32     *   122                             1067 402 377 125     32         122                       1067
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
1245140 1245140 MD     school 2400660 21   Washington 240066001253 1701 Bester Elementary   Regular School No Elementary PK 05 2020   pk_12_total 210 145 90   * *         121                             570 210 145 90               121                       570
1309922 1309922 MD     school 2400060 2   Anne Arundel 240006000075 1033 Glen Burnie High   Regular School No High 09 12 2021   pk_12_total 798 625 472   * 101     *   121                             2132 798 625 472     101         121                       2132
1237361 1237361 MD     school 2400060 2   Anne Arundel 240006000075 1033 Glen Burnie High   Regular School No High 09 12 2020   pk_12_total 812 624 420   * 86     *   120                             2076 812 624 420     86         120                       2076
1242269 1242269 MD     school 2400480 15   Montgomery 240048000784 406 Bethesda-Chevy Chase High   Regular School No High 09 12 2020   pk_12_total 1300 322 388   * 121     *   120                             2257 1300 322 388     121         120                       2257
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
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
1317235 1317235 MD     school 2400600 18   Saint Mary's 240060001237 101 Spring Ridge Middle   Regular School No Middle 06 08 2021   pk_12_total 417 366 128   * 33     *   118                             1067 417 366 128     33         118                       1067
1310284 1310284 MD     school 2400060 2   Anne Arundel 240006000039 3023 Arundel Middle   Regular School No Middle 06 08 2021   pk_12_total 501 307 130   * 59     *   116                             1119 501 307 130     59         116                       1119
1239364 1239364 MD     school 2400150 4   Calvert 240015000504 101 Patuxent Appeal Elementary Campus   Regular School No Elementary PK 05 2020   pk_12_total 482 111 55   * *         115                             768 482 111 55               115                       768
1313501 1313501 MD     school 2400390 12   Harford 240039000689 177 Edgewood Middle   Regular School No Middle 06 08 2021   pk_12_total 353 532 157   * 24     *   113                             1186 353 532 157     24         113                       1186
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
1238132 1238132 MD     school 2400060 2   Anne Arundel 240006000055 4293 South River High   Regular School No High 09 12 2020   pk_12_total 1673 123 216   * 96     *   111                             2224 1673 123 216     96         111                       2224
1314628 1314628 MD     school 2400480 15   Montgomery 240048001541 249 Clarksburg High   Regular School No High 09 12 2021   pk_12_total 403 702 585   * 559         111                             2365 403 702 585     559         111                       2365
1314107 1314107 MD     school 2400420 13   Howard 240042001200 527 Reservoir High   Regular School No High 09 12 2021   pk_12_total 421 619 321   * 313     *   110                             1788 421 619 321     313         110                       1788
1317748 1317748 MD     school 2400660 21   Washington 240066001276 2102 Northern Middle   Regular School No Middle 06 08 2021   pk_12_total 391 171 113   * 21     *   109                             809 391 171 113     21         109                       809
1317752 1317752 MD     school 2400660 21   Washington 240066001293 2501 Western Heights Middle   Regular School No Middle 06 08 2021   pk_12_total 440 234 149     17     *   109                             950 440 234 149     17         109                       950
1242070 1242070 MD     school 2400480 15   Montgomery 240048001541 249 Clarksburg High   Regular School No High 09 12 2020   pk_12_total 424 743 653   * 539     *   108                             2472 424 743 653     539         108                       2472
1240948 1240948 MD     school 2400390 12   Harford 240039000689 177 Edgewood Middle   Regular School No Middle 06 08 2020   pk_12_total 350 518 148   * 26     *   107                             1160 350 518 148     26         107                       1160
1312414 1312414 MD     school 2400240 7   Cecil 240024000568 302 Elkton High   Regular School No High 09 12 2021   pk_12_total 493 290 151   * 13     *   107                             1061 493 290 151     13         107                       1061
1312586 1312586 MD     school 2400270 8   Charles 240027000596 106 La Plata High School   Regular School No High 09 12 2021   pk_12_total 703 247 73   * 38     *   107                             1174 703 247 73     38         107                       1174
1314858 1314858 MD     school 2400480 15   Montgomery 240048001118 413 North Bethesda Middle   Regular School No Middle 06 08 2021   pk_12_total 649 126 162   * 150         107                             1198 649 126 162     150         107                       1198
1245177 1245177 MD     school 2400660 21   Washington 240066001293 2501 Western Heights Middle   Regular School No Middle 06 08 2020   pk_12_total 481 235 160     19         106                             1001 481 235 160     19         106                       1001
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
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
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
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
1313052 1313052 MD     school 2400330 10   Frederick 240033000616 713 Urbana High   Regular School No High 09 12 2021   pk_12_total 1055 173 242   11 320     *   103                             1908 1055 173 242   11 320         103                       1908
1244995 1244995 MD     school 2400660 21   Washington 240066001263 304 E. Russell Hicks Middle   Regular School No Middle 06 08 2020   pk_12_total 392 206 137     24         102                             861 392 206 137     24         102                       861
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
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
1242003 1242003 MD     school 2400480 15   Montgomery 240048000934 234 Thomas S. Wootton High   Regular School No High 09 12 2020   pk_12_total 881 176 169   * 787     *   101                             2116 881 176 169     787         101                       2116
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
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
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

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