enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 9,498 ✖
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
1317807 1317807 MD     school 2400690 22   Wicomico 240069001306 102 Mardela Middle & High   Regular School No High 06 12 2021   pk_12_total 515 74 26   * *         53                             674 515 74 26               53                       674
1310527 1310527 MD     school 2400060 2   Anne Arundel 240006000132 4023 Southern High   Regular School No High 09 12 2021   pk_12_total 719 73 176     10     *   53                             1032 719 73 176     10         53                       1032
1310626 1310626 MD     school 2400060 2   Anne Arundel 240006000080 4192 Hillsmere Elementary   Regular School No Elementary PK 05 2021   pk_12_total 249 73 55     *         15                             398 249 73 55               15                       398
1311829 1311829 MD     school 2400120 3   Baltimore County 240012000437 1519 Orems Elementary   Regular School No Elementary PK 05 2021   pk_12_total 179 73 56   * 24         26                             363 179 73 56     24         26                       363
1314391 1314391 MD     school 2400480 15   Montgomery 240048000897 152 Poolesville High   Regular School No High 09 12 2021   pk_12_total 551 73 113   * 431         65                             1236 551 73 113     431         65                       1236
1311956 1311956 MD     school 2400150 4   Calvert 240015002946 116 Mill Creek Middle   Regular School No Middle 06 08 2021   pk_12_total 330 72 36   * *         47                             488 330 72 36               47                       488
1313132 1313132 MD     school 2400330 10   Frederick 240033001163 918 Oakdale Middle   Regular School No Middle 06 08 2021   pk_12_total 601 72 101   * 70     *   50                             899 601 72 101     70         50                       899
1317293 1317293 MD     school 2400600 18   Saint Mary's 240060001231 404 Margaret Brent Middle   Regular School No Middle 06 08 2021   pk_12_total 807 72 48   * *     *   65                             1002 807 72 48               65                       1002
1316078 1316078 MD     school 2400510 16   Prince George's 240051000982 714 Benjamin Tasker Middle School   Regular School No Middle 06 08 2021   pk_12_total 129 718 127   * 53     *   28                             1068 129 718 127     53         28                       1068
1316962 1316962 MD     school 2400510 16   Prince George's 240051001126 1909 Parkdale High   Regular School No High 09 12 2021   pk_12_total 80 717 1560   * 74     *   15                             2453 80 717 1560     74         15                       2453
1316469 1316469 MD     school 2400510 16   Prince George's 240051001472 1326 Kettering Middle   Regular School No Middle 06 08 2021   pk_12_total * 714 130     *     *   11                             875   714 130               11                       875
1318423 1318423 MD     school 2400090 30   Baltimore City 240009000273 88 Wildwood Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 713 15           *   *                             734   713 15                                       734
1310811 1310811 MD     school 2400120 3   Baltimore County 240012000936 102 Westchester Elementary   Regular School No Elementary PK 05 2021   pk_12_total 415 71 55   * 93         31                             668 415 71 55     93         31                       668
1310850 1310850 MD     school 2400120 3   Baltimore County 240012000466 111 Maiden Choice School   Special Education School No Other PK 12 2021   pk_12_total 29 71 *     16         *                             130 29 71       16                                 130
1311527 1311527 MD     school 2400120 3   Baltimore County 240012000347 1206 Bear Creek Elementary   Regular School No Elementary PK 05 2021   pk_12_total 264 71 62   * *         45                             457 264 71 62               45                       457
1313873 1313873 MD     school 2400420 13   Howard 240042000744 208 Northfield Elementary   Regular School No Elementary KG 05 2021   pk_12_total 324 71 51   * 232     *   54                             736 324 71 51     232         54                       736
1312632 1312632 MD     school 2400270 8   Charles 240027000607 605 Thomas Stone High School   Regular School No High 09 12 2021   pk_12_total 138 708 186   * 19     *   59                             1115 138 708 186     19         59                       1115
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
1316507 1316507 MD     school 2400510 16   Prince George's 240051001223 1348 Ernest Everett Just Middle   Regular School No Middle 06 08 2021   pk_12_total * 705 67   * *     *   *                             802   705 67                                       802
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
1312265 1312265 MD     school 2400210 6   Carroll 240021000552 707 Westminster High   Regular School No High 09 12 2021   pk_12_total 1242 70 84   * 56     *   59                             1515 1242 70 84     56         59                       1515
1314115 1314115 MD     school 2400420 13   Howard 240042001539 528 Dayton Oaks   Regular School No Elementary PK 05 2021   pk_12_total 346 70 37   * 177         51                             683 346 70 37     177         51                       683
1311009 1311009 MD     school 2400120 3   Baltimore County 240012001431 252 Northwest Academy of Health Sciences   Regular School No Middle 06 08 2021   pk_12_total 17 695 46   * *     *   12                             784 17 695 46               12                       784
1310038 1310038 MD     school 2400060 2   Anne Arundel 240006000116 1212 Point Pleasant Elementary   Regular School No Elementary PK 05 2021   pk_12_total 289 69 99     12         41                             510 289 69 99     12         41                       510
1313515 1313515 MD     school 2400390 12   Harford 240039001638 187 Patterson Mill High School   Regular School No High 09 12 2021   pk_12_total 599 69 58     53     *   54                             836 599 69 58     53         54                       836
1314561 1314561 MD     school 2400480 15   Montgomery 240048000827 233 Fallsmead Elementary   Regular School No Elementary PK 05 2021   pk_12_total 182 69 48   * 191     *   26                             520 182 69 48     191         26                       520
1319342 1319342 MD     school 2400090 30   Baltimore City 240009000209 450 Frederick Douglass High   Regular School No High 09 12 2021   pk_12_total 13 687 55     *         *                             759 13 687 55                                       759
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
1310513 1310513 MD     school 2400060 2   Anne Arundel 240006001425 3414 Ruth Parker Eason School   Special Education School No Other PK 12 2021   pk_12_total 46 68 19     *     *   *                             149 46 68 19                                       149
1311208 1311208 MD     school 2400120 3   Baltimore County 240012000350 803 Lutherville Laboratory   Regular School No Elementary KG 05 2021   pk_12_total 164 68 30     46     *   29                             338 164 68 30     46         29                       338
1313274 1313274 MD     school 2400330 10   Frederick 240033000657 2403 Waverley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 31 68 363   * 33         12                             511 31 68 363     33         12                       511
1317267 1317267 MD     school 2400600 18   Saint Mary's 240060001216 302 Benjamin Banneker Elementary   Regular School No Elementary PK 05 2021   pk_12_total 413 68 18     *         32                             536 413 68 18               32                       536
1318665 1318665 MD     school 2400090 30   Baltimore City 240009000243 215 Highlandtown Elementary/Middle #215   Regular School No Elementary PK 08 2021   pk_12_total 11 68 377     *     *   *                             463 11 68 377                                       463
1319089 1319089 MD     school 2400090 30   Baltimore City 240009001571 332 The Green School of Baltimore   Regular School Yes Elementary KG 05 2021   pk_12_total 61 68 *               24                             162 61 68                 24                       162
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
1316450 1316450 MD     school 2400510 16   Prince George's 240051001211 1320 G. James Gholson Middle   Regular School No Middle 06 08 2021   pk_12_total * 676 254   * *         *                             949   676 254                                       949
1316678 1316678 MD     school 2400510 16   Prince George's 240051001697 1518 Barack Obama Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 675 41     *     *   13                             743   675 41               13                       743
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
1318820 1318820 MD     school 2400090 30   Baltimore City 240009000231 236 Hamilton Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 93 673 50   * 10     *   26                             854 93 673 50     10         26                       854
1319122 1319122 MD     school 2400090 30   Baltimore City 240009001663 341 The Reach! Partnership School   Regular School No High 09 12 2021   pk_12_total * 672 14               *                             695   672 14                                       695
1317136 1317136 MD     school 2400510 16   Prince George's 240051001049 2141 Greenbelt Middle   Regular School No Middle 06 08 2021   pk_12_total 102 671 562   * 91     *   35                             1471 102 671 562     91         35                       1471
1310264 1310264 MD     school 2400060 2   Anne Arundel 240006000124 2413 Severn River Middle   Regular School No Middle 06 08 2021   pk_12_total 588 67 87   * 16         41                             801 588 67 87     16         41                       801
1314300 1314300 MD     school 2400480 15   Montgomery 240048000864 51 Laytonsville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 138 67 106     29     *   27                             369 138 67 106     29         27                       369
1317094 1317094 MD     school 2400510 16   Prince George's 240051001272 2109 Berwyn Heights Elementary   Regular School No Elementary KG 06 2021   pk_12_total 55 67 298     19         *                             447 55 67 298     19                                 447
1317799 1317799 MD     school 2400660 21   Washington 240066001266 2701 Fountaindale Elementary   Regular School No Elementary PK 05 2021   pk_12_total 194 67 39     22         37                             359 194 67 39     22         37                       359
1317926 1317926 MD     school 2400690 22   Wicomico 240069001149 1502 Westside Intermediate   Regular School No Elementary 02 05 2021   pk_12_total 229 67 27   * *         34                             363 229 67 27               34                       363
1310999 1310999 MD     school 2400120 3   Baltimore County 240012001159 217 New Town Elementary   Regular School No Elementary PK 05 2021   pk_12_total 40 667 35   * 34     *   34                             818 40 667 35     34         34                       818
1316025 1316025 MD     school 2400510 16   Prince George's 240051001034 660 Drew Freeman Middle   Regular School No Middle 06 08 2021   pk_12_total * 662 157   * *     *   *                             838   662 157                                       838
1315537 1315537 MD     school 2400480 15   Montgomery 240048000926 798 Springbrook High   Regular School No High 09 12 2021   pk_12_total 104 660 665   * 218     *   45                             1694 104 660 665     218         45                       1694
1318332 1318332 MD     school 2400090 30   Baltimore City 240009000285 66 Mount Royal Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 77 660 26   * *     *   *                             781 77 660 26                                       781
1311837 1311837 MD     school 2400120 3   Baltimore County 240012000429 1520 Middleborough Elementary   Regular School No Elementary PK 05 2021   pk_12_total 200 66 14   * *         22                             306 200 66 14               22                       306
1312434 1312434 MD     school 2400240 7   Cecil 240024000570 311 Holly Hall Elementary   Regular School No Elementary PK 05 2021   pk_12_total 217 66 59   * *         42                             390 217 66 59               42                       390
1313294 1313294 MD     school 2400330 10   Frederick 240033000627 2503 Brunswick High   Regular School No High 09 12 2021   pk_12_total 590 66 81   * 12         47                             797 590 66 81     12         47                       797
1317082 1317082 MD     school 2400510 16   Prince George's 240051001063 2107 Hollywood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 31 66 247     76         11                             431 31 66 247     76         11                       431
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
1316344 1316344 MD     school 2400510 16   Prince George's 240051001017 1217 Crossland High   Regular School No High 09 12 2021   pk_12_total 10 656 274   * 10     *   *                             957 10 656 274     10                                 957
1318398 1318398 MD     school 2400090 30   Baltimore City 240009000204 85 Fort Worthington Elementary/Middle   Regular School No Elementary KG 08 2021   pk_12_total 10 656 55   * *         *                             736 10 656 55                                       736
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
1310061 1310061 MD     school 2400060 2   Anne Arundel 240006000142 1262 Woodside Elementary   Regular School No Elementary PK 05 2021   pk_12_total 110 65 145     *     *   10                             340 110 65 145               10                       340
1313821 1313821 MD     school 2400420 13   Howard 240042000813 107 Ilchester Elementary   Regular School No Elementary PK 05 2021   pk_12_total 260 65 34   * 155     *   39                             556 260 65 34     155         39                       556
1315192 1315192 MD     school 2400480 15   Montgomery 240048000818 570 Diamond Elementary   Regular School No Elementary PK 05 2021   pk_12_total 200 65 79     397     *   38                             780 200 65 79     397         38                       780
1315274 1315274 MD     school 2400480 15   Montgomery 240048000801 703 Cedar Grove Elementary   Regular School No Elementary PK 05 2021   pk_12_total 87 65 50   * 156         19                             379 87 65 50     156         19                       379
1316771 1316771 MD     school 2400510 16   Prince George's 240051000999 1711 Carole Highlands Elementary   Regular School No Elementary PK 06 2021   pk_12_total * 65 385     *         *                             462   65 385                                       462
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
1318453 1318453 MD     school 2400090 30   Baltimore City 240009000282 105 Moravia Park Elementary   Regular School No Elementary PK 05 2021   pk_12_total 17 646 26   * 11     *   *                             714 17 646 26     11                                 714
1319104 1319104 MD     school 2400090 30   Baltimore City 240009001631 335 Baltimore International Academy   Regular School Yes Elementary KG 08 2021   pk_12_total 36 645 43   * *     *   25                             752 36 645 43               25                       752
1311541 1311541 MD     school 2400120 3   Baltimore County 240012000395 1210 Grange Elementary   Regular School No Elementary PK 05 2021   pk_12_total 265 64 54   * 12     *   46                             446 265 64 54     12         46                       446
1313781 1313781 MD     school 2400420 13   Howard 240042001189 80 Homewood School   Alternative School No High 07 12 2021   pk_12_total 36 64 12     *         *                             120 36 64 12                                       120
1314786 1314786 MD     school 2400480 15   Montgomery 240048001747 346 Bayard Rustin Elementary   Regular School No Elementary PK 05 2021   pk_12_total 182 64 200   * 175         61                             686 182 64 200     175         61                       686
1311021 1311021 MD     school 2400120 3   Baltimore County 240012001574 256 Windsor Mill Middle   Regular School No Middle 06 08 2021   pk_12_total * 635 29   * *     *   13                             691   635 29               13                       691
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
1316853 1316853 MD     school 2400510 16   Prince George's 240051001029 1806 Fairmont Heights High   Regular School No High 09 12 2021   pk_12_total 20 630 239   * *     *   *                             910 20 630 239                                       910
1311765 1311765 MD     school 2400120 3   Baltimore County 240012000384 1508 Essex Elementary   Regular School No Elementary PK 05 2021   pk_12_total 253 63 69   * 12     *   29                             435 253 63 69     12         29                       435
1312474 1312474 MD     school 2400240 7   Cecil 240024000574 504 North East Middle   Regular School No Middle 06 08 2021   pk_12_total 637 63 47   * *     *   42                             798 637 63 47               42                       798
1313302 1313302 MD     school 2400330 10   Frederick 240033000626 2504 Brunswick Elementary   Regular School No Elementary PK 05 2021   pk_12_total 478 63 82   * 18         51                             694 478 63 82     18         51                       694
1317259 1317259 MD     school 2400600 18   Saint Mary's 240060001228 301 Leonardtown Elementary   Regular School No Elementary PK 05 2021   pk_12_total 310 63 24     12         27                             436 310 63 24     12         27                       436
1318534 1318534 MD     school 2400090 30   Baltimore City 240009000171 159 The Historic Cherry Hill Elementary/Middle   Regular School No Middle 03 08 2021   pk_12_total * 629 31   *           *                             674   629 31                                       674
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
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
1317008 1317008 MD     school 2400510 16   Prince George's 240051001175 2009 Thomas Johnson Middle   Regular School No Middle 06 08 2021   pk_12_total 30 625 578   * 35     *   *                             1282 30 625 578     35                                 1282
1311076 1311076 MD     school 2400120 3   Baltimore County 240012000448 352 Pikesville Middle   Regular School No Middle 06 08 2021   pk_12_total 157 624 103   * 43     *   32                             967 157 624 103     43         32                       967
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
1309942 1309942 MD     school 2400060 2   Anne Arundel 240006000043 1082 Belle Grove Elementary   Regular School No Elementary PK 05 2021   pk_12_total 108 62 73   * 11         32                             287 108 62 73     11         32                       287
1312042 1312042 MD     school 2400150 4   Calvert 240015000515 315 Northern Middle   Regular School No Middle 06 08 2021   pk_12_total 510 62 26   * 15     *   56                             672 510 62 26     15         56                       672
1312503 1312503 MD     school 2400240 7   Cecil 240024000575 514 North East High   Regular School No High 09 12 2021   pk_12_total 843 62 58   * 10         43                             1020 843 62 58     10         43                       1020
1313757 1313757 MD     school 2400390 12   Harford 240039000707 638 Meadowvale Elementary   Regular School No Elementary PK 05 2021   pk_12_total 301 62 41   * *         44                             454 301 62 41               44                       454
1313909 1313909 MD     school 2400420 13   Howard 240042090449 215 Waverly Elementary   Regular School No Elementary PK 05 2021   pk_12_total 276 62 33   * 475         48                             899 276 62 33     475         48                       899
1314410 1314410 MD     school 2400480 15   Montgomery 240048000185 156 Lois P. Rockwell Elementary   Regular School No Elementary PK 05 2021   pk_12_total 189 62 122   * 51     *   33                             460 189 62 122     51         33                       460
1311157 1311157 MD     school 2400120 3   Baltimore County 240012001347 452 Owings Mills High   Regular School No High 09 12 2021   pk_12_total 59 619 363   * 48     *   26                             1120 59 619 363     48         26                       1120
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
1316478 1316478 MD     school 2400510 16   Prince George's 240051001473 1330 Kenmoor Middle   Regular School No Middle 06 08 2021   pk_12_total 42 618 246   * 45         *                             962 42 618 246     45                                 962
1318713 1318713 MD     school 2400090 30   Baltimore City 240009000299 223 Pimlico Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 618 39     *     *   *                             667   618 39                                       667
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
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
1316893 1316893 MD     school 2400510 16   Prince George's 240051001174 1814 Thomas G. Pullen School   Regular School No Elementary KG 08 2021   pk_12_total 21 616 69   * *     *   22                             743 21 616 69               22                       743
1316745 1316745 MD     school 2400510 16   Prince George's 240051001114 1708 Northwestern High   Regular School No High 09 12 2021   pk_12_total 49 610 1613   * 18     *   14                             2313 49 610 1613     18         14                       2313
1310539 1310539 MD     school 2400060 2   Anne Arundel 240006000131 4053 Southern Middle   Regular School No Middle 06 08 2021   pk_12_total 516 61 152   * *         58                             790 516 61 152               58                       790
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
1314062 1314062 MD     school 2400420 13   Howard 240042000725 521 Clarksville Middle   Regular School No Middle 06 08 2021   pk_12_total 266 61 20   * 338         29                             716 266 61 20     338         29                       716
1315568 1315568 MD     school 2400480 15   Montgomery 240048000858 805 Kemp Mill Elementary   Regular School No Elementary PK 05 2021   pk_12_total 21 61 361     *         *                             458 21 61 361                                       458

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