enrollments

Data source: Big Local News · About: Big Local

2,791 rows where grade = "pk_12_total" and state = "MD" sorted by hispanic_int 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
1237303 1237303 MD     school 2400030 1   Allegany 240003000017 1001 George's Creek Elementary   Regular School No Elementary PK 05 2020   pk_12_total 282                   *                             285 282                                           285
1238199 1238199 MD     school 2400120 3   Baltimore County 240012001760 56 Central EDLP at Loch Raven High School   Alternative School No High 12 12 2020   pk_12_total * *                                               *                                              
1238203 1238203 MD     school 2400120 3   Baltimore County 240012000925 57 Home Assignments-Elementary   Alternative School No Middle 04 06 2020   pk_12_total   *                                               *                                              
1238210 1238210 MD     school 2400120 3   Baltimore County 240012000935 58 Home Assignments-Secondary   Alternative School No High 07 12 2020   pk_12_total * 17                 *                             26   17                                         26
1239771 1239771 MD     school 2400210 6   Carroll 240021001349 718 PRIDE School   Alternative School No Elementary 01 05 2020   pk_12_total * *                                               *                                              
1239802 1239802 MD     school 2400210 6   Carroll 240021001350 903 Flexible Student Support   Alternative School No High 09 12 2020   pk_12_total 19         *         *                             22 19                                           22
1244872 1244872 MD     school 2400570 19   Somerset 240057001203 1003 Ewell School   Regular School No Elementary PK 07 2020   pk_12_total *                                                 *                                              
1245710 1245710 MD     school 2400090 30   Baltimore City 240009000229 60 Gwynns Falls Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 313                                               316   313                                         316
1246466 1246466 MD     school 2400090 30   Baltimore City 240009001369 314 Sharp-Leadenhall Elementary   Special Education School No Elementary 01 05 2020   pk_12_total * 15                 *                             18   15                                         18
1246580 1246580 MD     school 2400090 30   Baltimore City 240009001662 345 Joseph C. Briscoe Academy   Special Education School No High 06 12 2020   pk_12_total * 50                                               57   50                                         57
1309864 1309864 MD     school 2400030 1   Allegany 240003000017 1001 George's Creek Elementary   Regular School No Elementary PK 05 2021   pk_12_total 241         *         *                             244 241                                           244
1310749 1310749 MD     school 2400120 3   Baltimore County 240012001756 51 Northwest EDLP at Milford Mill Academy   Alternative School No High 10 12 2021   pk_12_total   *                                               *                                              
1310760 1310760 MD     school 2400120 3   Baltimore County 240012001760 56 Central EDLP at Loch Raven High School   Alternative School No High 12 12 2021   pk_12_total *                                                 *                                              
1310765 1310765 MD     school 2400120 3   Baltimore County 240012000935 58 Home Assignments-Secondary   Alternative School No High 08 12 2021   pk_12_total * *                                               12                                             12
1310783 1310783 MD     school 2400120 3   Baltimore County 240012000831 72 Rosedale Center   Alternative School No High 07 12 2021   pk_12_total * 17                 *                             25   17                                         25
1311972 1311972 MD     school 2400150 4   Calvert 240015000509 206 Calvert Country School   Special Education School No Other 03 12 2021   pk_12_total 23 *     * *         *                             38 23                                           38
1312350 1312350 MD     school 2400210 6   Carroll 240021001350 903 Flexible Student Support   Alternative School No High 09 12 2021   pk_12_total 28 *                                               32 28                                           32
1313347 1313347 MD     school 2400360 11   Garrett 240036000668 1301 Grantsville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 171                   *                             172 171                                           172
1317447 1317447 MD     school 2400570 19   Somerset 240057001203 1003 Ewell School   Regular School No Middle 01 07 2021   pk_12_total *                                                 *                                              
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
1318527 1318527 MD     school 2400090 30   Baltimore City 240009000158 150 Mary Ann Winterling Elementary at Bentalou   Regular School No Elementary PK 05 2021   pk_12_total   179                 *                             185   179                                         185
1319017 1319017 MD     school 2400090 30   Baltimore City 240009001369 314 Sharp-Leadenhall Elementary   Special Education School No Elementary 01 05 2021   pk_12_total * 23                 *                             27   23                                         27
1243086 1243086 MD     school 2400510 16   Prince George's 240051001059 102 High Point High   Regular School No High 09 12 2020   pk_12_total 47 513 2093   * 73     *   11                             2747 47 513 2093     73         11                       2747
1315666 1315666 MD     school 2400510 16   Prince George's 240051001059 102 High Point High   Regular School No High 09 12 2021   pk_12_total 50 449 2042   * 71     *   12                             2634 50 449 2042     71         12                       2634
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
1244164 1244164 MD     school 2400510 16   Prince George's 240051001114 1708 Northwestern High   Regular School No High 09 12 2020   pk_12_total 57 625 1604   * 26     *   15                             2335 57 625 1604     26         15                       2335
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
1244381 1244381 MD     school 2400510 16   Prince George's 240051001126 1909 Parkdale High   Regular School No High 09 12 2020   pk_12_total 73 718 1473   * 61     *   18                             2354 73 718 1473     61         18                       2354
1315747 1315747 MD     school 2400510 16   Prince George's 240051000987 208 Bladensburg High   Regular School No High 09 12 2021   pk_12_total 26 463 1396   * 32     *   *                             1933 26 463 1396     32                                 1933
1243167 1243167 MD     school 2400510 16   Prince George's 240051000987 208 Bladensburg High   Regular School No High 09 12 2020   pk_12_total 25 477 1389   * 30     *   *                             1936 25 477 1389     30                                 1936
1315068 1315068 MD     school 2400480 15   Montgomery 240048000838 551 Gaithersburg High   Regular School No High 09 12 2021   pk_12_total 274 497 1366   * 151         69                             2359 274 497 1366     151         69                       2359
1242493 1242493 MD     school 2400480 15   Montgomery 240048000838 551 Gaithersburg High   Regular School No High 09 12 2020   pk_12_total 306 526 1327     165         73                             2397 306 526 1327     165         73                       2397
1315448 1315448 MD     school 2400480 15   Montgomery 240048000951 782 Wheaton High   Regular School No High 09 12 2021   pk_12_total 216 461 1274   * 268     *   57                             2280 216 461 1274     268         57                       2280
1242868 1242868 MD     school 2400480 15   Montgomery 240048000951 782 Wheaton High   Regular School No High 09 12 2020   pk_12_total 202 433 1248     244     *   51                             2179 202 433 1248     244         51                       2179
1244499 1244499 MD     school 2400510 16   Prince George's 240051000993 2108 Buck Lodge Middle   Regular School No Middle 06 08 2020   pk_12_total 14 106 1159   * 13     *   *                             1302 14 106 1159     13                                 1302
1317086 1317086 MD     school 2400510 16   Prince George's 240051000993 2108 Buck Lodge Middle   Regular School No Middle 06 08 2021   pk_12_total * 111 1158   * 10         *                             1295   111 1158     10                                 1295
1315593 1315593 MD     school 2400480 15   Montgomery 240048000855 815 John F. Kennedy High   Regular School No High 09 12 2021   pk_12_total 93 416 1137   * 117         22                             1788 93 416 1137     117         22                       1788
1243013 1243013 MD     school 2400480 15   Montgomery 240048000855 815 John F. Kennedy High   Regular School No High 09 12 2020   pk_12_total 97 452 1116   * 124         26                             1817 97 452 1116     124         26                       1817
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
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
1244244 1244244 MD     school 2400510 16   Prince George's 240051001257 1730 Mary Harris   Regular School No Elementary PK 05 2020   pk_12_total 32 43 1000   * *         *                             1091 32 43 1000                                       1091
1242944 1242944 MD     school 2400480 15   Montgomery 240048001366 796 Northwood High School   Regular School No High 09 12 2020   pk_12_total 248 449 965   * 85         55                             1805 248 449 965     85         55                       1805
1316957 1316957 MD     school 2400510 16   Prince George's 240051001186 1908 William Wirt Middle   Regular School No Middle 06 08 2021   pk_12_total 25 219 962   * 64     *   *                             1280 25 219 962     64                                 1280
1244376 1244376 MD     school 2400510 16   Prince George's 240051001186 1908 William Wirt Middle   Regular School No Middle 06 08 2020   pk_12_total 23 215 940   * 40     *   *                             1224 23 215 940     40                                 1224
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
1317017 1317017 MD     school 2400510 16   Prince George's 240051001004 2011 Charles Carroll Middle   Regular School No Middle 06 08 2021   pk_12_total 23 356 922   * 25         *                             1330 23 356 922     25                                 1330
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
1244218 1244218 MD     school 2400510 16   Prince George's 240051001112 1718 Nicholas Orem Middle   Regular School No Middle 06 08 2020   pk_12_total 12 193 912   * *     *   *                             1129 12 193 912                                       1129
1316799 1316799 MD     school 2400510 16   Prince George's 240051001112 1718 Nicholas Orem Middle   Regular School No Middle 06 08 2021   pk_12_total 18 201 905   * *     *   *                             1139 18 201 905                                       1139
1244436 1244436 MD     school 2400510 16   Prince George's 240051001004 2011 Charles Carroll Middle   Regular School No Middle 06 08 2020   pk_12_total 23 378 903   * 19     *   *                             1329 23 378 903     19                                 1329
1315524 1315524 MD     school 2400480 15   Montgomery 240048001366 796 Northwood High School   Regular School No High 09 12 2021   pk_12_total 227 438 899   * 86         57                             1708 227 438 899     86         57                       1708
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
1315047 1315047 MD     school 2400480 15   Montgomery 240048001525 545 Watkins Mill High   Regular School No High 09 12 2021   pk_12_total 103 418 876   * 153     *   44                             1597 103 418 876     153         44                       1597
1316543 1316543 MD     school 2400510 16   Prince George's 240051001023 1409 Duval High   Regular School No High 09 12 2021   pk_12_total 53 1187 872   * 60     *   20                             2206 53 1187 872     60         20                       2206
1242472 1242472 MD     school 2400480 15   Montgomery 240048001525 545 Watkins Mill High   Regular School No High 09 12 2020   pk_12_total 107 424 870     137     *   51                             1590 107 424 870     137         51                       1590
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
1244227 1244227 MD     school 2400510 16   Prince George's 240051001087 1719 Langley Park/McCormick Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 34 837   * *     *   *                             890   34 837                                       890
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
1243962 1243962 MD     school 2400510 16   Prince George's 240051001023 1409 Duval High   Regular School No High 09 12 2020   pk_12_total 42 1154 829   * 57     *   30                             2123 42 1154 829     57         30                       2123
1243097 1243097 MD     school 2400510 16   Prince George's 240051000978 104 Beltsville Academy   Regular School No Elementary PK 08 2020   pk_12_total 72 190 823   * 54     *   18                             1162 72 190 823     54         18                       1162
1315677 1315677 MD     school 2400510 16   Prince George's 240051000978 104 Beltsville Academy   Regular School No Elementary PK 08 2021   pk_12_total 65 187 820   * 51         15                             1143 65 187 820     51         15                       1143
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
1316817 1316817 MD     school 2400510 16   Prince George's 240051000510 1725 Cool Spring Elementary   Regular School No Elementary PK 06 2021   pk_12_total 10 23 784   *           *                             834 10 23 784                                       834
1243214 1243214 MD     school 2400510 16   Prince George's 240051001368 217 Port Towns Elementary   Regular School No Elementary PK 06 2020   pk_12_total 16 351 751   * *     *   *                             1132 16 351 751                                       1132
1246186 1246186 MD     school 2400090 30   Baltimore City 240009000257 228 John Ruhrah Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 62 35 741   * *         *                             851 62 35 741                                       851
1242093 1242093 MD     school 2400480 15   Montgomery 240048000788 304 JoAnn Leleck at Broad Acres Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 101 739   * 21         *                             874   101 739     21                                 874
1316808 1316808 MD     school 2400510 16   Prince George's 240051001087 1719 Langley Park/McCormick Elementary   Regular School No Elementary PK 06 2021   pk_12_total * 33 737   * *         *                             783   33 737                                       783
1246269 1246269 MD     school 2400090 30   Baltimore City 240009000244 237 Highlandtown Elementary/Middle #237   Regular School No Elementary PK 08 2020   pk_12_total 18 122 732   * *         *                             882 18 122 732                                       882
1318746 1318746 MD     school 2400090 30   Baltimore City 240009000257 228 John Ruhrah Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 68 42 730   * *         *                             854 68 42 730                                       854
1243620 1243620 MD     school 2400510 16   Prince George's 240051001092 1008 Laurel High   Regular School No High 09 12 2020   pk_12_total 71 1023 728   * 77     *   35                             1943 71 1023 728     77         35                       1943
1316201 1316201 MD     school 2400510 16   Prince George's 240051001092 1008 Laurel High   Regular School No High 09 12 2021   pk_12_total 71 1069 728   * 75     *   35                             1986 71 1069 728     75         35                       1986
1318831 1318831 MD     school 2400090 30   Baltimore City 240009000244 237 Highlandtown Elementary/Middle #237   Regular School No Elementary PK 08 2021   pk_12_total 15 115 720     *     *   *                             860 15 115 720                                       860
1242957 1242957 MD     school 2400480 15   Montgomery 240048000926 798 Springbrook High   Regular School No High 09 12 2020   pk_12_total 107 665 708   * 217         47                             1746 107 665 708     217         47                       1746
1314652 1314652 MD     school 2400480 15   Montgomery 240048000788 304 JoAnn Leleck at Broad Acres Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 96 697   * 18         *                             821   96 697     18                                 821
1243176 1243176 MD     school 2400510 16   Prince George's 240051001146 210 Rogers Heights Elementary   Regular School No Elementary PK 06 2020   pk_12_total 11 99 692     14     *   *                             820 11 99 692     14                                 820
1242509 1242509 MD     school 2400480 15   Montgomery 240048000836 553 Gaithersburg Elementary   Regular School No Elementary PK 05 2020   pk_12_total 25 127 684   * 16         12                             865 25 127 684     16         12                       865
1242404 1242404 MD     school 2400480 15   Montgomery 240048000808 510 Col. Zadok Magruder High   Regular School No High 09 12 2020   pk_12_total 436 302 671   * 210         75                             1697 436 302 671     210         75                       1697
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
1311603 1311603 MD     school 2400120 3   Baltimore County 240012000377 1273 Dundalk High   Regular School No High 09 12 2021   pk_12_total 691 335 661   16 37     *   99                             1842 691 335 661   16 37         99                       1842
1315084 1315084 MD     school 2400480 15   Montgomery 240048000836 553 Gaithersburg Elementary   Regular School No Elementary PK 05 2021   pk_12_total 22 110 656   * 16     *   17                             825 22 110 656     16         17                       825
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
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
1314977 1314977 MD     school 2400480 15   Montgomery 240048000808 510 Col. Zadok Magruder High   Regular School No High 09 12 2021   pk_12_total 380 284 651   * 214     *   71                             1606 380 284 651     214         71                       1606
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
1242577 1242577 MD     school 2400480 15   Montgomery 240048000924 564 South Lake Elementary   Regular School No Elementary PK 05 2020   pk_12_total 10 176 632   * 49     *   23                             893 10 176 632     49         23                       893
1315756 1315756 MD     school 2400510 16   Prince George's 240051001146 210 Rogers Heights Elementary   Regular School No Elementary PK 06 2021   pk_12_total 10 90 629     *         *                             740 10 90 629                                       740
1244354 1244354 MD     school 2400510 16   Prince George's 240051001140 1901 Riverdale Elementary   Regular School No Elementary PK 05 2020   pk_12_total 19 57 628     10         *                             720 19 57 628     10                                 720
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
1244198 1244198 MD     school 2400510 16   Prince George's 240051001093 1712 Lewisdale Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 61 624   * *         *                             699   61 624                                       699
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
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
1242846 1242846 MD     school 2400480 15   Montgomery 240048000946 777 Weller Road Elementary   Regular School No Elementary PK 05 2020   pk_12_total 25 49 619   * 39         14                             747 25 49 619     39         14                       747
1314386 1314386 MD     school 2400480 15   Montgomery 240048001509 125 Quince Orchard High   Regular School No High 09 12 2021   pk_12_total 789 351 616   * 244     *   88                             2091 789 351 616     244         88                       2091
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
1241827 1241827 MD     school 2400480 15   Montgomery 240048001509 125 Quince Orchard High   Regular School No High 09 12 2020   pk_12_total 818 351 607   * 278     *   91                             2148 818 351 607     278         91                       2148
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
1315588 1315588 MD     school 2400480 15   Montgomery 240048000891 812 Parkland Middle   Regular School No Middle 06 08 2021   pk_12_total 100 272 605   * 150         28                             1158 100 272 605     150         28                       1158
1244142 1244142 MD     school 2400510 16   Prince George's 240051001723 1604 Edward M. Felegy ES   Regular School No Elementary PK 05 2020   pk_12_total 16 173 602   * *     *   *                             807 16 173 602                                       807
1243008 1243008 MD     school 2400480 15   Montgomery 240048000891 812 Parkland Middle   Regular School No Middle 06 08 2020   pk_12_total 97 247 599   * 164         30                             1141 97 247 599     164         30                       1141
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

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