enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pk_12_total · 2,775 ✖
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
1243258 1243258 MD     school 2400510 16   Prince George's 240051001686 509 Accokeek Academy   Regular School No Elementary KG 08 2020   pk_12_total 63 1236 209   * 68     12   44                             1637 63 1236 209     68     12   44                       1637
1315839 1315839 MD     school 2400510 16   Prince George's 240051001686 509 Accokeek Academy   Regular School No Elementary KG 08 2021   pk_12_total 57 1150 216   * 66     12   38                             1543 57 1150 216     66     12   38                       1543
1246731 1246731 MD     school 2400090 30   Baltimore City 240009000236 413 Achievement Academy at Harbor City High   Alternative School No High 09 12 2020   pk_12_total * 404 26   *                                         433   404 26                                       433
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
1244214 1244214 MD     school 2400510 16   Prince George's 240051000965 1714 Adelphi Elementary   Regular School No Elementary PK 06 2020   pk_12_total 17 128 615   * 11         *                             775 17 128 615     11                                 775
1316795 1316795 MD     school 2400510 16   Prince George's 240051000965 1714 Adelphi Elementary   Regular School No Elementary PK 06 2021   pk_12_total 14 114 554   * 14         *                             702 14 114 554     14                                 702
1246567 1246567 MD     school 2400090 30   Baltimore City 240009001661 337 Afya Public Charter School   Regular School Yes Middle 07 08 2020   pk_12_total   215 12               *                             228   215 12                                       228
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
1242909 1242909 MD     school 2400480 15   Montgomery 240048000773 789 Albert Einstein High   Regular School No High 09 12 2020   pk_12_total 407 321 882   * 139         65                             1818 407 321 882     139         65                       1818
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
1245954 1245954 MD     school 2400090 30   Baltimore City 240009000145 145 Alexander Hamilton Elementary   Regular School No Elementary PK 05 2020   pk_12_total   157 *               *                             160   157                                         160
1318519 1318519 MD     school 2400090 30   Baltimore City 240009000145 145 Alexander Hamilton Elementary   Regular School No Elementary PK 05 2021   pk_12_total   154                 *                             156   154                                         156
1237267 1237267 MD     school 2400030 1   Allegany 240003000001 606 Allegany High   Regular School No High 09 12 2020   pk_12_total 631 21 15   * 11         41                             721 631 21 15     11         41                       721
1309828 1309828 MD     school 2400030 1   Allegany 240003000001 606 Allegany High   Regular School No High 09 12 2021   pk_12_total 628 24 20   * 11     *   50                             736 628 24 20     11         50                       736
1243358 1243358 MD     school 2400510 16   Prince George's 240051000966 632 Allenwood Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 254 168   * *         *                             435   254 168                                       435
1315937 1315937 MD     school 2400510 16   Prince George's 240051000966 632 Allenwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 177 133   * *         *                             322   177 133                                       322
1242029 1242029 MD     school 2400480 15   Montgomery 240048001451 239 Alternative Programs   Alternative School No High 07 12 2020   pk_12_total 10 63 43     *         *                             126 10 63 43                                       126
1243412 1243412 MD     school 2400510 16   Prince George's 240051001683 645 Andrew Jackson Academy   Regular School No Elementary PK 08 2020   pk_12_total * 423 60     *     *   *                             504   423 60                                       504
1315992 1315992 MD     school 2400510 16   Prince George's 240051001683 645 Andrew Jackson Academy   Regular School No Elementary PK 08 2021   pk_12_total * 427 50     *     *   *                             499   427 50                                       499
1238000 1238000 MD     school 2400060 2   Anne Arundel 240006000035 4092 Annapolis Elementary   Regular School No Elementary PK 05 2020   pk_12_total 37 133 41     *         *                             214 37 133 41                                       214
1310564 1310564 MD     school 2400060 2   Anne Arundel 240006000035 4092 Annapolis Elementary   Regular School No Elementary PK 05 2021   pk_12_total 26 120 38     *         *                             194 26 120 38                                       194
1237957 1237957 MD     school 2400060 2   Anne Arundel 240006000037 4013 Annapolis High   Regular School No High 09 12 2020   pk_12_total 635 560 790   * 50     *   62                             2103 635 560 790     50         62                       2103
1310522 1310522 MD     school 2400060 2   Anne Arundel 240006000037 4013 Annapolis High   Regular School No High 09 12 2021   pk_12_total 638 547 835   * 51     *   60                             2134 638 547 835     51         60                       2134
1237966 1237966 MD     school 2400060 2   Anne Arundel 240006000036 4033 Annapolis Middle   Regular School No Middle 06 08 2020   pk_12_total 208 297 498   * 13     *   26                             1044 208 297 498     13         26                       1044
1310531 1310531 MD     school 2400060 2   Anne Arundel 240006000036 4033 Annapolis Middle   Regular School No Middle 06 08 2021   pk_12_total 157 309 549   * 19     *   25                             1061 157 309 549     19         25                       1061
1243205 1243205 MD     school 2400510 16   Prince George's 240051000865 216 Annapolis Road Academy   Alternative School No Secondary 09 10 2020   pk_12_total   66 51               *                             120   66 51                                       120
1315785 1315785 MD     school 2400510 16   Prince George's 240051000865 216 Annapolis Road Academy   Alternative School No Secondary 09 10 2021   pk_12_total   33 48     *         *                             83   33 48                                       83
1237670 1237670 MD     school 2400060 2   Anne Arundel 240006000899 2233 Anne Arundel Evening High   Alternative School No High 09 12 2020   pk_12_total 150 66 55   * *         22                             296 150 66 55               22                       296
1310232 1310232 MD     school 2400060 2   Anne Arundel 240006000899 2233 Anne Arundel Evening High   Alternative School No High 09 12 2021   pk_12_total 106 55 54     *         *                             227 106 55 54                                       227
1243801 1243801 MD     school 2400510 16   Prince George's 240051000969 1229 Apple Grove Elementary   Regular School No Elementary PK 06 2020   pk_12_total 11 261 224     12     *                                 512 11 261 224     12                                 512
1316382 1316382 MD     school 2400510 16   Prince George's 240051000969 1229 Apple Grove Elementary   Regular School No Elementary PK 06 2021   pk_12_total * 231 208   * 10     *                                 460   231 208     10                                 460
1239056 1239056 MD     school 2400120 3   Baltimore County 240012000341 1302 Arbutus Elementary   Regular School No Elementary PK 05 2020   pk_12_total 201 24 13   * 138     *   25                             404 201 24 13     138         25                       404
1311611 1311611 MD     school 2400120 3   Baltimore County 240012000341 1302 Arbutus Elementary   Regular School No Elementary PK 05 2021   pk_12_total 186 24 16   * 136         26                             390 186 24 16     136         26                       390
1239104 1239104 MD     school 2400120 3   Baltimore County 240012000342 1356 Arbutus Middle   Regular School No Middle 06 08 2020   pk_12_total 489 214 40   * 136     *   67                             951 489 214 40     136         67                       951
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
1242917 1242917 MD     school 2400480 15   Montgomery 240048001643 790 Arcola Elementary   Regular School No Elementary PK 05 2020   pk_12_total 27 148 518   * 42     *   *                             748 27 148 518     42                                 748
1315497 1315497 MD     school 2400480 15   Montgomery 240048001643 790 Arcola Elementary   Regular School No Elementary PK 05 2021   pk_12_total 26 134 485   * 38     *   16                             703 26 134 485     38         16                       703
1244423 1244423 MD     school 2400510 16   Prince George's 240051000970 2008 Ardmore Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 340 82     *     *   *                             435   340 82                                       435
1317004 1317004 MD     school 2400510 16   Prince George's 240051000970 2008 Ardmore Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 334 91     *     *   *                             434   334 91                                       434
1243045 1243045 MD     school 2400480 15   Montgomery 240048000409 823 Argyle Middle   Regular School No Middle 06 08 2020   pk_12_total 72 256 582   * 88         25                             1024 72 256 582     88         25                       1024
1315625 1315625 MD     school 2400480 15   Montgomery 240048000409 823 Argyle Middle   Regular School No Middle 06 08 2021   pk_12_total 79 249 599   * 78         36                             1043 79 249 599     78         36                       1043
1246236 1246236 MD     school 2400090 30   Baltimore City 240009000146 234 Arlington Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 307 81               *                             392   307 81                                       392
1318798 1318798 MD     school 2400090 30   Baltimore City 240009000146 234 Arlington Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 313 84               *                             405   313 84                                       405
1246315 1246315 MD     school 2400090 30   Baltimore City 240009000147 243 Armistead Gardens Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 182 80 513   * 10         21                             809 182 80 513     10         21                       809
1318877 1318877 MD     school 2400090 30   Baltimore City 240009000147 243 Armistead Gardens Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 154 75 518   * *         26                             780 154 75 518               26                       780
1237544 1237544 MD     school 2400060 2   Anne Arundel 240006000038 2052 Arnold Elementary   Regular School No Elementary KG 05 2020   pk_12_total 427 33 30   * 21     *   29                             543 427 33 30     21         29                       543
1310106 1310106 MD     school 2400060 2   Anne Arundel 240006000038 2052 Arnold Elementary   Regular School No Elementary KG 05 2021   pk_12_total 357 38 26   * 19         38                             481 357 38 26     19         38                       481
1243401 1243401 MD     school 2400510 16   Prince George's 240051000971 640 Arrowhead Elementary   Regular School No Elementary PK 05 2020   pk_12_total 16 266 119   * *         *                             406 16 266 119                                       406
1315981 1315981 MD     school 2400510 16   Prince George's 240051000971 640 Arrowhead Elementary   Regular School No Elementary PK 05 2021   pk_12_total 13 241 117   * *         *                             376 13 241 117                                       376
1240120 1240120 MD     school 2400270 8   Charles 240027000582 612 Arthur Middleton Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 57 313 107     19         55                             551 57 313 107     19         55                       551
1312668 1312668 MD     school 2400270 8   Charles 240027000582 612 Arthur Middleton Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 51 301 114     18     *   59                             545 51 301 114     18         59                       545
1245974 1245974 MD     school 2400090 30   Baltimore City 240009000148 164 Arundel Elementary   Regular School No Elementary PK 02 2020   pk_12_total * 502 12               *                             523   502 12                                       523
1318539 1318539 MD     school 2400090 30   Baltimore City 240009000148 164 Arundel Elementary   Regular School No Elementary PK 02 2021   pk_12_total * 425 11               *                             445   425 11                                       445
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
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
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
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
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
1241575 1241575 MD     school 2400420 13   Howard 240042000718 603 Atholton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 255 121 46     40     *   41                             504 255 121 46     40         41                       504
1314131 1314131 MD     school 2400420 13   Howard 240042000718 603 Atholton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 206 112 52     35         46                             451 206 112 52     35         46                       451
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
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
1246782 1246782 MD     school 2400090 30   Baltimore City 240009001387 430 Augusta Fells Savage Institute of Visual Arts   Regular School No High 09 12 2020   pk_12_total * 421 *     *         *                             434   421                                         434
1319327 1319327 MD     school 2400090 30   Baltimore City 240009001387 430 Augusta Fells Savage Institute of Visual Arts   Regular School No High 09 12 2021   pk_12_total * 463 *   * *         *                             481   463                                         481
1243792 1243792 MD     school 2400510 16   Prince George's 240051000972 1221 Avalon Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 232 125   * *     *   *                             374   232 125                                       374
1316373 1316373 MD     school 2400510 16   Prince George's 240051000972 1221 Avalon Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 174 97   * *     *   *                             285   174 97                                       285
1238241 1238241 MD     school 2400120 3   Baltimore County 240012001711 77 BCDC Educational Center   Alternative School No High 09 12 2020   pk_12_total * 24 *                                             33   24                                         33
1310795 1310795 MD     school 2400120 3   Baltimore County 240012001711 77 BCDC Educational Center   Alternative School No High 09 12 2021   pk_12_total * 19 *                                             31   19                                         31
1243544 1243544 MD     school 2400510 16   Prince George's 240051000973 802 Baden Elementary   Regular School No Elementary PK 06 2020   pk_12_total 51 92 48   *           16                             209 51 92 48               16                       209
1316124 1316124 MD     school 2400510 16   Prince George's 240051000973 802 Baden Elementary   Regular School No Elementary PK 06 2021   pk_12_total 37 98 46   *           16                             198 37 98 46               16                       198
1239995 1239995 MD     school 2400240 7   Cecil 240024000556 704 Bainbridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 240 11 *   *       *   23                             284 240 11                 23                       284
1312543 1312543 MD     school 2400240 7   Cecil 240024000556 704 Bainbridge Elementary   Regular School No Elementary PK 05 2021   pk_12_total 221 12 *   *           23                             265 221 12                 23                       265
1240982 1240982 MD     school 2400390 12   Harford 240039000680 212 Bakerfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 143 141 82     15         45                             426 143 141 82     15         45                       426
1313535 1313535 MD     school 2400390 12   Harford 240039000680 212 Bakerfield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 137 126 69     *         42                             383 137 126 69               42                       383
1240430 1240430 MD     school 2400330 10   Frederick 240033090471 223 Ballenger Creek Elementary   Regular School No Elementary PK 05 2020   pk_12_total 218 113 124   * 61     *   64                             586 218 113 124     61         64                       586
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
1240692 1240692 MD     school 2400330 10   Frederick 240033090446 2305 Ballenger Creek Middle   Regular School No Middle 06 08 2020   pk_12_total 362 172 168   * 60     *   47                             817 362 172 168     60         47                       817
1313245 1313245 MD     school 2400330 10   Frederick 240033090446 2305 Ballenger Creek Middle   Regular School No Middle 06 08 2021   pk_12_total 338 161 180   * 51     *   62                             800 338 161 180     51         62                       800
1246807 1246807 MD     school 2400090 30   Baltimore City 240009000150 480 Baltimore City College   Regular School No High 09 12 2020   pk_12_total 254 970 126   * 24     *   21                             1402 254 970 126     24         21                       1402
1319352 1319352 MD     school 2400090 30   Baltimore City 240009000150 480 Baltimore City College   Regular School No High 09 12 2021   pk_12_total 256 972 146   * 25     *   32                             1439 256 972 146     25         32                       1439
1246665 1246665 MD     school 2400090 30   Baltimore City 240009001736 375 Baltimore Collegiate School for Boys   Regular School Yes Middle 04 08 2020   pk_12_total * 421 *   *           *                             432   421                                         432
1319208 1319208 MD     school 2400090 30   Baltimore City 240009001736 375 Baltimore Collegiate School for Boys   Regular School Yes Middle 04 08 2021   pk_12_total   455 *   *       *   *                             466   455                                         466
1246686 1246686 MD     school 2400090 30   Baltimore City 240009001703 382 Baltimore Design School   Regular School No High 06 12 2020   pk_12_total 18 477 12   * *         *                             511 18 477 12                                       511
1319229 1319229 MD     school 2400090 30   Baltimore City 240009001703 382 Baltimore Design School   Regular School No High 06 12 2021   pk_12_total 19 491 13   * *         *                             529 19 491 13                                       529
1239064 1239064 MD     school 2400120 3   Baltimore County 240012000344 1307 Baltimore Highlands Elementary   Regular School No Elementary PK 05 2020   pk_12_total 122 120 249   * 10         42                             551 122 120 249     10         42                       551
1311619 1311619 MD     school 2400120 3   Baltimore County 240012000344 1307 Baltimore Highlands Elementary   Regular School No Elementary PK 05 2021   pk_12_total 96 105 223   * *         33                             469 96 105 223               33                       469
1246553 1246553 MD     school 2400090 30   Baltimore City 240009001631 335 Baltimore International Academy   Regular School Yes Elementary KG 08 2020   pk_12_total 27 641 40     *     *   24                             736 27 641 40               24                       736
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
1246696 1246696 MD     school 2400090 30   Baltimore City 240009001752 385 Baltimore International Academy West   Regular School Yes Elementary 06 06 2020   pk_12_total   67 *               *                             69   67                                         69
1319241 1319241 MD     school 2400090 30   Baltimore City 240009001752 385 Baltimore International Academy West   Regular School Yes Elementary KG 07 2021   pk_12_total * 143 *               *                             150   143                                         150
1246608 1246608 MD     school 2400090 30   Baltimore City 240009001682 348 Baltimore Leadership School for Young Women   Regular School Yes High 06 12 2020   pk_12_total * 523 *   *           *                             539   523                                         539
1319158 1319158 MD     school 2400090 30   Baltimore City 240009001682 348 Baltimore Leadership School for Young Women   Regular School Yes High 06 12 2021   pk_12_total * 514 *   *           *                             531   514                                         531
1246564 1246564 MD     school 2400090 30   Baltimore City 240009001657 336 Baltimore Montessori Public Charter School   Regular School Yes Elementary PK 08 2020   pk_12_total 123 306 10   * *         13                             456 123 306 10               13                       456
1319115 1319115 MD     school 2400090 30   Baltimore City 240009001657 336 Baltimore Montessori Public Charter School   Regular School Yes Elementary PK 08 2021   pk_12_total 119 323 16   *           19                             479 119 323 16               19                       479
1246706 1246706 MD     school 2400090 30   Baltimore City 240009000151 403 Baltimore Polytechnic Institute   Regular School No High 09 12 2020   pk_12_total 258 1030 162   * 104     *   21                             1584 258 1030 162     104         21                       1584
1319251 1319251 MD     school 2400090 30   Baltimore City 240009000151 403 Baltimore Polytechnic Institute   Regular School No High 09 12 2021   pk_12_total 279 993 200   * 109     *   30                             1619 279 993 200     109         30                       1619
1246741 1246741 MD     school 2400090 30   Baltimore City 240009001391 415 Baltimore School for the Arts   Regular School No High 09 12 2020   pk_12_total 176 218 23   * 10     *   *                             438 176 218 23     10                                 438
1319286 1319286 MD     school 2400090 30   Baltimore City 240009001391 415 Baltimore School for the Arts   Regular School No High 09 12 2021   pk_12_total 161 229 27   * *     *   *                             433 161 229 27                                       433
1242317 1242317 MD     school 2400480 15   Montgomery 240048000779 420 Bannockburn Elementary   Regular School No Elementary KG 05 2020   pk_12_total 307 22 50     52         30                             461 307 22 50     52         30                       461

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