enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pk_12_total · 2,791 ✖
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
1241010 1241010 MD     school 2400390 12   Harford 240039000694 304 Harford Technical High   Career and Technical School No High 09 12 2020   pk_12_total 698 145 81   * 34     *   38                             999 698 145 81     34         38                       999
1242896 1242896 MD     school 2400480 15   Montgomery 240048001446 787 A. Mario Loiederman Middle   Regular School No Middle 06 08 2020   pk_12_total 142 154 626   * 43         30                             999 142 154 626     43         30                       999
1312591 1312591 MD     school 2400270 8   Charles 240027000600 108 Maurice J. McDonough High School   Regular School No High 09 12 2021   pk_12_total 310 479 116   * 27     *   64                             999 310 479 116     27         64                       999
1238525 1238525 MD     school 2400120 3   Baltimore County 240012000441 353 Sudbrook Magnet Middle   Regular School No Middle 06 08 2020   pk_12_total 115 608 178   * 64         29                             998 115 608 178     64         29                       998
1245497 1245497 MD     school 2400090 30   Baltimore City 240009000264 12 Lakeland Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 39 324 621   * *         *                             998 39 324 621                                       998
1315617 1315617 MD     school 2400480 15   Montgomery 240048000820 820 Earle B. Wood Middle   Regular School No Middle 06 08 2021   pk_12_total 253 130 444   * 112     *   56                             998 253 130 444     112         56                       998
1311419 1311419 MD     school 2400120 3   Baltimore County 240012000230 975 George W. Carver Center for Arts & Technology   Career and Technical School No High 09 12 2021   pk_12_total 458 354 63   * 66     *   50                             997 458 354 63     66         50                       997
1237962 1237962 MD     school 2400060 2   Anne Arundel 240006000132 4023 Southern High   Regular School No High 09 12 2020   pk_12_total 729 75 132   * *     *   51                             996 729 75 132               51                       996
1313624 1313624 MD     school 2400390 12   Harford 240039000701 335 Homestead/Wakefield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 710 54 81   * 70     *   75                             996 710 54 81     70         75                       996
1315476 1315476 MD     school 2400480 15   Montgomery 240048001446 787 A. Mario Loiederman Middle   Regular School No Middle 06 08 2021   pk_12_total 149 150 622   * 42         30                             996 149 150 622     42         30                       996
1243037 1243037 MD     school 2400480 15   Montgomery 240048000820 820 Earle B. Wood Middle   Regular School No Middle 06 08 2020   pk_12_total 249 126 456     111     *   51                             994 249 126 456     111         51                       994
1312201 1312201 MD     school 2400210 6   Carroll 240021001394 507 Liberty High   Regular School No High 09 12 2021   pk_12_total 815 55 44     38     *   34                             993 815 55 44     38         34                       993
1313565 1313565 MD     school 2400390 12   Harford 240039000694 304 Harford Technical High   Career and Technical School No High 09 12 2021   pk_12_total 702 133 75   * 32     *   47                             993 702 133 75     32         47                       993
1316825 1316825 MD     school 2400510 16   Prince George's 240051001257 1730 Mary Harris   Regular School No Elementary PK 05 2021   pk_12_total * 44 927   * *     *   *                             991   44 927                                       991
1237897 1237897 MD     school 2400060 2   Anne Arundel 240006000108 3343 Old Mill Middle South   Regular School No Middle 06 08 2020   pk_12_total 477 225 174     38     *   72                             990 477 225 174     38         72                       990
1240272 1240272 MD     school 2400270 8   Charles 240027000597 1002 Henry E. Lackey High School   Regular School No High 09 12 2020   pk_12_total 283 563 47   12 20     *   64                             990 283 563 47   12 20         64                       990
1241991 1241991 MD     school 2400480 15   Montgomery 240048001450 232 Tilden Middle School   Regular School No Middle 06 08 2020   pk_12_total 434 125 213   * 166     *   48                             989 434 125 213     166         48                       989
1311907 1311907 MD     school 2400120 3   Baltimore County 240012000362 1574 Chesapeake High   Regular School No High 09 12 2021   pk_12_total 251 553 116   * 12     *   51                             988 251 553 116     12         51                       988
1315298 1315298 MD     school 2400480 15   Montgomery 240048000660 707 Rocky Hill Middle   Regular School No Middle 06 08 2021   pk_12_total 154 276 285   * 216     *   51                             986 154 276 285     216         51                       986
1319347 1319347 MD     school 2400090 30   Baltimore City 240009000168 454 Carver Vocational-Technical High   Career and Technical School No High 09 12 2021   pk_12_total 15 942 24   * *         *                             985 15 942 24                                       985
1312384 1312384 MD     school 2400210 6   Carroll 240021000546 1401 South Carroll High   Regular School No High 09 12 2021   pk_12_total 842 15 78   * 23     *   22                             984 842 15 78     23         22                       984
1318073 1318073 MD     school 2400090 30   Baltimore City 240009000264 12 Lakeland Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 37 288 642   * *         10                             984 37 288 642               10                       984
1242723 1242723 MD     school 2400480 15   Montgomery 240048000863 708 Kingsview Middle   Regular School No Middle 06 08 2020   pk_12_total 232 265 149     277     *   57                             983 232 265 149     277         57                       983
1315794 1315794 MD     school 2400510 16   Prince George's 240051001368 217 Port Towns Elementary   Regular School No Elementary PK 06 2021   pk_12_total 14 310 652   * *     *   *                             982 14 310 652                                       982
1315714 1315714 MD     school 2400510 16   Prince George's 240051001101 110 Martin Luther King Jr. Middle   Regular School No Middle 06 08 2021   pk_12_total 31 443 413     69     *   20                             981 31 443 413     69         20                       981
1317906 1317906 MD     school 2400690 22   Wicomico 240069001299 1308 Bennett Middle   Regular School No Middle 06 08 2021   pk_12_total 380 351 137   * 34     *   68                             980 380 351 137     34         68                       980
1313717 1313717 MD     school 2400390 12   Harford 240039000685 518 Darlington Elementary   Regular School No Elementary KG 05 2021   pk_12_total 80 * *     *         *                             98 80                                           98
1312960 1312960 MD     school 2400330 10   Frederick 240033001413 219 Monocacy Middle   Regular School No Middle 06 08 2021   pk_12_total 246 226 388   * 42     *   64                             978 246 226 388     42         64                       978
1314743 1314743 MD     school 2400480 15   Montgomery 240048090450 335 Briggs Chaney Middle   Regular School No Middle 06 08 2021   pk_12_total 64 521 247   * 102     *   41                             978 64 521 247     102         41                       978
1313664 1313664 MD     school 2400390 12   Harford 240039000691 382 Fallston High   Regular School No High 09 12 2021   pk_12_total 838 35 41   * 25     *   35                             977 838 35 41     25         35                       977
1243762 1243762 MD     school 2400510 16   Prince George's 240051001017 1217 Crossland High   Regular School No High 09 12 2020   pk_12_total 13 626 320   * 11         *                             975 13 626 320     11                                 975
1241108 1241108 MD     school 2400390 12   Harford 240039000691 382 Fallston High   Regular School No High 09 12 2020   pk_12_total 839 39 36   * 21     *   35                             973 839 39 36     21         35                       973
1238521 1238521 MD     school 2400120 3   Baltimore County 240012000448 352 Pikesville Middle   Regular School No Middle 06 08 2020   pk_12_total 162 642 86   * 39     *   34                             972 162 642 86     39         34                       972
1238719 1238719 MD     school 2400120 3   Baltimore County 240012001422 855 Hereford Middle   Regular School No Middle 06 08 2020   pk_12_total 839 21 38     40         34                             972 839 21 38     40         34                       972
1240517 1240517 MD     school 2400330 10   Frederick 240033001429 715 Centerville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 452 99 139   * 206     *   73                             972 452 99 139     206         73                       972
1311080 1311080 MD     school 2400120 3   Baltimore County 240012000441 353 Sudbrook Magnet Middle   Regular School No Middle 06 08 2021   pk_12_total 105 574 213   * 54     *   22                             972 105 574 213     54         22                       972
1239034 1239034 MD     school 2400120 3   Baltimore County 240012000408 1253 Holabird Middle   Regular School No Middle 04 08 2020   pk_12_total 459 130 289   14 25         53                             970 459 130 289   14 25         53                       970
1241934 1241934 MD     school 2400480 15   Montgomery 240048000799 215 Carl Sandburg Center   Special Education School No Elementary KG 05 2020   pk_12_total 17 36 33     10         *                             97 17 36 33     10                                 97
1240414 1240414 MD     school 2400330 10   Frederick 240033001413 219 Monocacy Middle   Regular School No Middle 06 08 2020   pk_12_total 268 224 380   * 40     *   49                             969 268 224 380     40         49                       969
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
1313067 1313067 MD     school 2400330 10   Frederick 240033001536 716 Urbana Middle   Regular School No Middle 06 08 2021   pk_12_total 483 91 112   * 208     *   70                             967 483 91 112     208         70                       967
1314693 1314693 MD     school 2400480 15   Montgomery 240048090453 311 Francis Scott Key Middle   Regular School No Middle 06 08 2021   pk_12_total 26 404 433   * 81     *   19                             966 26 404 433     81         19                       966
1315413 1315413 MD     school 2400480 15   Montgomery 240048001457 775 Eastern Middle School   Regular School No Middle 06 08 2021   pk_12_total 197 185 478     69     *   36                             966 197 185 478     69         36                       966
1245330 1245330 MD     school 2400690 22   Wicomico 240069001299 1308 Bennett Middle   Regular School No Middle 06 08 2020   pk_12_total 389 337 122   * 35     *   71                             965 389 337 122     35         71                       965
1243898 1243898 MD     school 2400510 16   Prince George's 240051001473 1330 Kenmoor Middle   Regular School No Middle 06 08 2020   pk_12_total 41 620 245   * 48     *   *                             964 41 620 245     48                                 964
1241381 1241381 MD     school 2400420 13   Howard 240042001646 219 Veterans Elementary   Regular School No Elementary PK 05 2020   pk_12_total 217 130 75   * 499     *   33                             962 217 130 75     499         33                       962
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
1238864 1238864 MD     school 2400120 3   Baltimore County 240012000230 975 George W. Carver Center for Arts & Technology   Career and Technical School No High 09 12 2020   pk_12_total 439 349 58   * 63     *   44                             961 439 349 58     63         44                       961
1239351 1239351 MD     school 2400120 3   Baltimore County 240012000362 1574 Chesapeake High   Regular School No High 09 12 2020   pk_12_total 267 525 102   * *     *   50                             961 267 525 102               50                       961
1243681 1243681 MD     school 2400510 16   Prince George's 240051001052 1103 Gwynn Park High   Regular School No High 09 12 2020   pk_12_total 34 778 105   * 13     *   26                             961 34 778 105     13         26                       961
1238844 1238844 MD     school 2400120 3   Baltimore County 240012000451 957 Pine Grove Middle   Regular School No Middle 06 08 2020   pk_12_total 410 375 50   * 69     *   49                             960 410 375 50     69         49                       960
1237726 1237726 MD     school 2400060 2   Anne Arundel 240006000090 3033 MacArthur Middle   Regular School No Middle 06 08 2020   pk_12_total 191 505 127   * 53     *   67                             959 191 505 127     53         67                       959
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
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
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
1241354 1241354 MD     school 2400420 13   Howard 240042090449 215 Waverly Elementary   Regular School No Elementary PK 05 2020   pk_12_total 328 59 30   * 481         48                             951 328 59 30     481         48                       951
1313936 1313936 MD     school 2400420 13   Howard 240042001646 219 Veterans Elementary   Regular School No Elementary PK 05 2021   pk_12_total 225 146 70   * 449     *   49                             951 225 146 70     449         49                       951
1242065 1242065 MD     school 2400480 15   Montgomery 240048000644 248 Forest Oak Middle   Regular School No Middle 06 08 2020   pk_12_total 95 228 547   * 52     *   26                             950 95 228 547     52         26                       950
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
1243467 1243467 MD     school 2400510 16   Prince George's 240051001424 705 Tall Oaks High   Alternative School No High 11 12 2020   pk_12_total * 63 25   * *                                       95   63 25                                       95
1239532 1239532 MD     school 2400180 5   Caroline 240018000526 302 Lockerman Middle School   Regular School No Middle 06 08 2020   pk_12_total 591 97 179     *         73                             949 591 97 179               73                       949
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
1240405 1240405 MD     school 2400330 10   Frederick 240033000658 211 West Frederick Middle   Regular School No Middle 06 08 2020   pk_12_total 242 229 374     47     *   52                             947 242 229 374     47         52                       947
1241822 1241822 MD     school 2400480 15   Montgomery 240048000759 115 Neelsville Middle   Regular School No Middle 06 08 2020   pk_12_total 48 287 499   * 81     *   24                             945 48 287 499     81         24                       945
1311589 1311589 MD     school 2400120 3   Baltimore County 240012000408 1253 Holabird Middle   Regular School No Middle 04 08 2021   pk_12_total 433 123 291   10 31     *   56                             945 433 123 291   10 31         56                       945
1243202 1243202 MD     school 2400510 16   Prince George's 240051001171 214 Templeton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 59 183 527   * 164     *   *                             943 59 183 527     164                                 943
1314493 1314493 MD     school 2400480 15   Montgomery 240048000799 215 Carl Sandburg Center   Special Education School No Elementary KG 05 2021   pk_12_total 11 39 31     10         *                             94 11 39 31     10                                 94
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
1242183 1242183 MD     school 2400480 15   Montgomery 240048090450 335 Briggs Chaney Middle   Regular School No Middle 06 08 2020   pk_12_total 64 504 236     98     *   33                             936 64 504 236     98         33                       936
1239697 1239697 MD     school 2400210 6   Carroll 240021000553 703 Westminster West Middle   Regular School No Middle 06 08 2020   pk_12_total 725 44 94   * 29     *   36                             935 725 44 94     29         36                       935
1241117 1241117 MD     school 2400390 12   Harford 240039090475 386 Fallston Middle School   Regular School No Middle 06 08 2020   pk_12_total 808 29 30   * 25         38                             934 808 29 30     25         38                       934
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
1314778 1314778 MD     school 2400480 15   Montgomery 240048001739 345 Hallie Wells Middle School   Regular School No Middle 06 08 2021   pk_12_total 192 201 132   * 345         59                             930 192 201 132     345         59                       930
1238825 1238825 MD     school 2400120 3   Baltimore County 240012001435 923 White Oak School   Special Education School No Elementary PK 05 2020   pk_12_total 39 36 *     *         *                             93 39 36                                         93
1243121 1243121 MD     school 2400510 16   Prince George's 240051001354 108 James E. Duckworth Regional Center   Special Education School No Other KG 12 2020   pk_12_total * 33 52     *         *                             93   33 52                                       93
1241185 1241185 MD     school 2400390 12   Harford 240039000709 583 North Harford Middle   Regular School No Middle 06 08 2020   pk_12_total 851 * 20   * 11     *   33                             929 851   20     11         33                       929
1319281 1319281 MD     school 2400090 30   Baltimore City 240009000298 414 Paul Laurence Dunbar High   Regular School No High 09 12 2021   pk_12_total 22 826 66   * *     *   *                             928 22 826 66                                       928
1318768 1318768 MD     school 2400090 30   Baltimore City 240009000161 231 The Belair-Edison School   Regular School Yes Elementary PK 08 2021   pk_12_total 12 881 12   *           20                             927 12 881 12               20                       927
1311399 1311399 MD     school 2400120 3   Baltimore County 240012000451 957 Pine Grove Middle   Regular School No Middle 06 08 2021   pk_12_total 366 385 45   * 75     *   49                             926 366 385 45     75         49                       926
1313139 1313139 MD     school 2400330 10   Frederick 240033001165 919 Oakdale Elementary   Regular School No Elementary KG 05 2021   pk_12_total 527 117 102   * 135     *   40                             926 527 117 102     135         40                       926
1312951 1312951 MD     school 2400330 10   Frederick 240033000658 211 West Frederick Middle   Regular School No Middle 06 08 2021   pk_12_total 227 204 382   * 46     *   62                             925 227 204 382     46         62                       925
1241234 1241234 MD     school 2400420 13   Howard 240042000728 101 Elkridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 342 244 76   * 186     *   71                             923 342 244 76     186         71                       923
1238530 1238530 MD     school 2400120 3   Baltimore County 240012000449 371 Pikesville High   Regular School No High 09 12 2020   pk_12_total 301 464 76   * 54     *   21                             922 301 464 76     54         21                       922
1239587 1239587 MD     school 2400210 6   Carroll 240021000533 202 Francis Scott Key High   Regular School No High 09 12 2020   pk_12_total 811 31 39   * *     *   28                             922 811 31 39               28                       922
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
1316404 1316404 MD     school 2400510 16   Prince George's 240051001471 1234 Oxon Hill Middle   Regular School No Middle 06 08 2021   pk_12_total 24 360 492   * 36     *   *                             922 24 360 492     36                                 922
1310905 1310905 MD     school 2400120 3   Baltimore County 240012000248 175 Western School of Technology   Career and Technical School No High 09 12 2021   pk_12_total 136 514 48   * 190     *   28                             920 136 514 48     190         28                       920
1311274 1311274 MD     school 2400120 3   Baltimore County 240012001422 855 Hereford Middle   Regular School No Middle 06 08 2021   pk_12_total 787 24 36   * 38         34                             920 787 24 36     38         34                       920
1314623 1314623 MD     school 2400480 15   Montgomery 240048000644 248 Forest Oak Middle   Regular School No Middle 06 08 2021   pk_12_total 85 212 534     61     *   26                             920 85 212 534     61         26                       920
1243057 1243057 MD     school 2400480 15   Montgomery 240048001460 916 Rock Terrace School   Special Education School No High 06 12 2020   pk_12_total 27 26 24     11         *                             92 27 26 24     11                                 92
1315782 1315782 MD     school 2400510 16   Prince George's 240051001171 214 Templeton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 40 151 520     202     *   *                             917 40 151 520     202                                 917
1244236 1244236 MD     school 2400510 16   Prince George's 240051000510 1725 Cool Spring Elementary   Regular School No Elementary PK 06 2020   pk_12_total 12 26 867   * *         *                             915 12 26 867                                       915
1241530 1241530 MD     school 2400420 13   Howard 240042090478 523 Pointers Run Elementary   Regular School No Elementary PK 05 2020   pk_12_total 414 105 33   * 291     *   67                             912 414 105 33     291         67                       912
1238715 1238715 MD     school 2400120 3   Baltimore County 240012000366 853 Cockeysville Middle   Regular School No Middle 06 08 2020   pk_12_total 391 251 154   * 71     *   41                             910 391 251 154     71         41                       910
1311655 1311655 MD     school 2400120 3   Baltimore County 240012000417 1351 Lansdowne Middle   Regular School No Middle 06 08 2021   pk_12_total 211 252 316   17 58     *   55                             910 211 252 316   17 58         55                       910
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
1241294 1241294 MD     school 2400420 13   Howard 240042001444 202 Ellicott Mills Middle   Regular School No Middle 06 08 2020   pk_12_total 361 153 43   * 296     *   52                             909 361 153 43     296         52                       909
1244134 1244134 MD     school 2400510 16   Prince George's 240051001065 1602 Hyattsville Middle   Regular School No Middle 06 08 2020   pk_12_total 82 237 567   * 11     *   *                             909 82 237 567     11                                 909
1316446 1316446 MD     school 2400510 16   Prince George's 240051001089 1314 Largo High   Regular School No High 09 12 2021   pk_12_total * 817 67   * *     *   10                             909   817 67               10                       909
1245555 1245555 MD     school 2400090 30   Baltimore City 240009000180 27 Commodore John Rogers Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 48 530 308   * 11         *                             907 48 530 308     11                                 907

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