enrollments

Data source: Big Local News · About: Big Local

19,213 rows where state = "MD" sorted by white descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
1241694 1241694 MD     school 2400420 13   Howard 240042000860 624 Murray Hill Middle   Regular School No Middle 06 08 2020   pk_12_total 88 320 155   * 118     *   50                             733 88 320 155     118         50                       733
1244130 1244130 MD     school 2400510 16   Prince George's 240051001064 1601 Hyattsville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 88 120 279   * *         *                             508 88 120 279                                       508
1311309 1311309 MD     school 2400120 3   Baltimore County 240012000453 909 Pleasant Plains Elementary   Regular School No Elementary PK 05 2021   pk_12_total 88 283 115   * 11     *   25                             525 88 283 115     11         25                       525
1314251 1314251 MD     school 2400420 13   Howard 240042000860 624 Murray Hill Middle   Regular School No Middle 06 08 2021   pk_12_total 88 315 152   * 118         48                             723 88 315 152     118         48                       723
1314466 1314466 MD     school 2400480 15   Montgomery 240048000862 209 Lakewood Elementary   Regular School No Elementary KG 05 2021   pk_12_total 88 46 45   * 207     *   26                             415 88 46 45     207         26                       415
1314501 1314501 MD     school 2400480 15   Montgomery 240048000937 216 Travilah Elementary   Regular School No Elementary PK 05 2021   pk_12_total 88 29 38     153     *   13                             323 88 29 38     153         13                       323
1316069 1316069 MD     school 2400510 16   Prince George's 240051001177 711 Tulip Grove Elementary   Regular School No Elementary KG 05 2021   pk_12_total 88 183 46   * *         *                             335 88 183 46                                       335
1241420 1241420 MD     school 2400420 13   Howard 240042000731 404 Glenelg High   Regular School No High 09 12 2020   pk_12_total 879 46 59   * 156     *   54                             1197 879 46 59     156         54                       1197
1311902 1311902 MD     school 2400120 3   Baltimore County 240012000477 1573 Sparrows Point High   Regular School No High 09 12 2021   pk_12_total 877 87 70   * 14     *   43                             1097 877 87 70     14         43                       1097
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
1237445 1237445 MD     school 2400060 2   Anne Arundel 240006000102 1172 North Glen Elementary   Regular School No Elementary PK 05 2020   pk_12_total 87 91 82     14         31                             305 87 91 82     14         31                       305
1242752 1242752 MD     school 2400480 15   Montgomery 240048000821 756 East Silver Spring Elementary   Regular School No Elementary PK 05 2020   pk_12_total 87 266 109   * 13     *   19                             497 87 266 109     13         19                       497
1244798 1244798 MD     school 2400600 18   Saint Mary's 240060001483 805 George Washington Carver Elementary   Regular School No Elementary PK 05 2020   pk_12_total 87 317 125   * *     *   59                             598 87 317 125               59                       598
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
1239651 1239651 MD     school 2400210 6   Carroll 240021001394 507 Liberty High   Regular School No High 09 12 2020   pk_12_total 861 44 54   * 43     *   33                             1044 861 44 54     43         33                       1044
1240328 1240328 MD     school 2400300 9   Dorchester 240030000617 711 Maple Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 86 265 68     13         46                             478 86 265 68     13         46                       478
1240380 1240380 MD     school 2400330 10   Frederick 240033000649 204 Lincoln Elementary   Regular School No Elementary PK 05 2020   pk_12_total 86 216 218   * 20         55                             598 86 216 218     20         55                       598
1314173 1314173 MD     school 2400420 13   Howard 240042000756 609 Talbott Springs Elementary   Regular School No Elementary PK 05 2021   pk_12_total 86 181 137     21         42                             467 86 181 137     21         42                       467
1314594 1314594 MD     school 2400480 15   Montgomery 240048000819 241 DuFief Elementary   Regular School No Elementary PK 05 2021   pk_12_total 86 46 45     93     *   34                             305 86 46 45     93         34                       305
1314714 1314714 MD     school 2400480 15   Montgomery 240048000890 315 Paint Branch High   Regular School No High 09 12 2021   pk_12_total 86 1218 451   * 257         49                             2064 86 1218 451     257         49                       2064
1315104 1315104 MD     school 2400480 15   Montgomery 240048000875 556 Mill Creek Towne Elementary   Regular School No Elementary PK 05 2021   pk_12_total 86 83 205   * 72     *   33                             482 86 83 205     72         33                       482
1315332 1315332 MD     school 2400480 15   Montgomery 240048000821 756 East Silver Spring Elementary   Regular School No Elementary PK 05 2021   pk_12_total 86 252 103     14     *   24                             481 86 252 103     14         24                       481
1316711 1316711 MD     school 2400510 16   Prince George's 240051001064 1601 Hyattsville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 86 111 262   * *         *                             477 86 111 262                                       477
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
1241641 1241641 MD     school 2400420 13   Howard 240042000740 613 Jeffers Hill Elementary   Regular School No Elementary KG 05 2020   pk_12_total 85 163 90     40         36                             414 85 163 90     40         36                       414
1310006 1310006 MD     school 2400060 2   Anne Arundel 240006000102 1172 North Glen Elementary   Regular School No Elementary PK 05 2021   pk_12_total 85 89 87     15         27                             303 85 89 87     15         27                       303
1311317 1311317 MD     school 2400120 3   Baltimore County 240012000435 910 Oakleigh Elementary   Regular School No Elementary PK 05 2021   pk_12_total 85 277 66   * 24         39                             493 85 277 66     24         39                       493
1312875 1312875 MD     school 2400300 9   Dorchester 240030000617 711 Maple Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 85 248 75     10         36                             454 85 248 75     10         36                       454
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
1314701 1314701 MD     school 2400480 15   Montgomery 240048000955 312 William Tyler Page Elementary   Regular School No Elementary PK 05 2021   pk_12_total 85 281 158   * 64     *   32                             622 85 281 158     64         32                       622
1244715 1244715 MD     school 2400600 18   Saint Mary's 240060001231 404 Margaret Brent Middle   Regular School No Middle 06 08 2020   pk_12_total 848 81 42   * *     *   60                             1043 848 81 42               60                       1043
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
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
1239955 1239955 MD     school 2400240 7   Cecil 240024000575 514 North East High   Regular School No High 09 12 2020   pk_12_total 840 62 55   * 12         42                             1016 840 62 55     12         42                       1016
1242434 1242434 MD     school 2400480 15   Montgomery 240048090479 514 Judith A. Resnik Elementary   Regular School No Elementary PK 05 2020   pk_12_total 84 175 251   * 63         28                             602 84 175 251     63         28                       602
1242608 1242608 MD     school 2400480 15   Montgomery 240048001512 569 Strawberry Knoll Elementary   Regular School No Elementary PK 05 2020   pk_12_total 84 168 284   * 73         40                             651 84 168 284     73         40                       651
1312734 1312734 MD     school 2400270 8   Charles 240027001565 624 William A. Diggs Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 84 525 60     30     *   59                             762 84 525 60     30         59                       762
1314014 1314014 MD     school 2400420 13   Howard 240042000720 510 Bryant Woods Elementary   Regular School No Elementary PK 05 2021   pk_12_total 84 174 49   * 19     *   32                             360 84 174 49     19         32                       360
1315160 1315160 MD     school 2400480 15   Montgomery 240048090456 565 Sequoyah Elementary   Regular School No Elementary PK 05 2021   pk_12_total 84 49 172     40         23                             368 84 49 172     40         23                       368
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
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
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
1243995 1243995 MD     school 2400510 16   Prince George's 240051001245 1416 Dora Kennedy French Immersion   Regular School No Elementary KG 08 2020   pk_12_total 83 505 43   * 22         22                             676 83 505 43     22         22                       676
1313854 1313854 MD     school 2400420 13   Howard 240042000738 203 Howard High   Regular School No High 09 12 2021   pk_12_total 824 411 142   * 317     *   127                             1828 824 411 142     317         127                       1828
1239043 1239043 MD     school 2400120 3   Baltimore County 240012000444 1272 Patapsco High & Center for Arts   Regular School No High 09 12 2020   pk_12_total 820 331 148   15 15     *   104                             1434 820 331 148   15 15         104                       1434
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
1312785 1312785 MD     school 2400270 8   Charles 240027000591 710 Indian Head Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 82 246 37     *         46                             416 82 246 37               46                       416
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
1314566 1314566 MD     school 2400480 15   Montgomery 240048000934 234 Thomas S. Wootton High   Regular School No High 09 12 2021   pk_12_total 817 211 169   * 743         95                             2037 817 211 169     743         95                       2037
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
1237361 1237361 MD     school 2400060 2   Anne Arundel 240006000075 1033 Glen Burnie High   Regular School No High 09 12 2020   pk_12_total 812 624 420   * 86     *   120                             2076 812 624 420     86         120                       2076
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
1311044 1311044 MD     school 2400120 3   Baltimore County 240012000492 304 Wellwood International School   Regular School No Elementary KG 05 2021   pk_12_total 81 308 42   * 46         16                             496 81 308 42     46         16                       496
1315009 1315009 MD     school 2400480 15   Montgomery 240048090479 514 Judith A. Resnik Elementary   Regular School No Elementary PK 05 2021   pk_12_total 81 162 246   * 65     *   34                             591 81 162 246     65         34                       591
1317515 1317515 MD     school 2400630 20   Talbot 240063001250 501 Tilghman Elementary   Regular School No Elementary PK 05 2021   pk_12_total 81   *               *                             86 81                                           86
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
1245049 1245049 MD     school 2400660 21   Washington 240066001256 601 Boonsboro High   Regular School No High 09 12 2020   pk_12_total 807 12 30   * 21         31                             902 807 12 30     21         31                       902
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
1317276 1317276 MD     school 2400600 18   Saint Mary's 240060001229 305 Leonardtown Middle   Regular School No Middle 06 08 2021   pk_12_total 802 84 53   * 20     *   67                             1029 802 84 53     20         67                       1029
1238147 1238147 MD     school 2400060 2   Anne Arundel 240006000056 4304 Central Special School   Special Education School No Other PK 12 2020   pk_12_total 80 32 23     *         *                             148 80 32 23                                       148
1244846 1244846 MD     school 2400570 19   Somerset 240057001743 107 Greenwood Elementary School   Regular School No Elementary 02 05 2020   pk_12_total 80 318 36   * *         26                             468 80 318 36               26                       468
1246746 1246746 MD     school 2400090 30   Baltimore City 240009001313 416 Digital Harbor High School   Career and Technical School No High 09 12 2020   pk_12_total 80 715 346   * 13     *   *                             1162 80 715 346     13                                 1162
1311133 1311133 MD     school 2400120 3   Baltimore County 240012001346 407 Glyndon Elementary   Regular School No Elementary PK 05 2021   pk_12_total 80 281 86   * 21     *   38                             512 80 281 86     21         38                       512
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
1314722 1314722 MD     school 2400480 15   Montgomery 240048000929 316 Stonegate Elementary   Regular School No Elementary PK 05 2021   pk_12_total 80 181 111     81     *   39                             494 80 181 111     81         39                       494
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
1317424 1317424 MD     school 2400570 19   Somerset 240057001743 107 Greenwood Elementary School   Regular School No Elementary 02 05 2021   pk_12_total 80 307 41     *         19                             454 80 307 41               19                       454
1319256 1319256 MD     school 2400090 30   Baltimore City 240009000297 405 Patterson High   Career and Technical School No High 09 12 2021   pk_12_total 80 581 535   * *         *                             1213 80 581 535                                       1213
1311598 1311598 MD     school 2400120 3   Baltimore County 240012000444 1272 Patapsco High and Center for Arts   Regular School No High 09 12 2021   pk_12_total 799 327 134   15 14     *   112                             1402 799 327 134   15 14         112                       1402
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
1239702 1239702 MD     school 2400210 6   Carroll 240021001185 704 Winters Mill High   Regular School No High 09 12 2020   pk_12_total 792 75 126   * 34     *   48                             1079 792 75 126     34         48                       1079
1239193 1239193 MD     school 2400120 3   Baltimore County 240012000425 1506 Martin Boulevard Elementary   Regular School No Elementary PK 05 2020   pk_12_total 79 118 57   * *     *   39                             298 79 118 57               39                       298
1241810 1241810 MD     school 2400480 15   Montgomery 240048010502 110 S. Christa McAuliffe Elementary   Regular School No Elementary PK 05 2020   pk_12_total 79 209 186   * 38     *   37                             554 79 209 186     38         37                       554
1242781 1242781 MD     school 2400480 15   Montgomery 240048000844 767 Glen Haven Elementary   Regular School No Elementary PK 05 2020   pk_12_total 79 114 257   * 34     *   24                             511 79 114 257     34         24                       511
1313560 1313560 MD     school 2400390 12   Harford 240039000480 292 Center for Educational Opportunity   Alternative School No High 06 12 2021   pk_12_total 79 48 *     *         14                             148 79 48                 14                       148
1315361 1315361 MD     school 2400480 15   Montgomery 240048000844 767 Glen Haven Elementary   Regular School No Elementary PK 05 2021   pk_12_total 79 108 237     31     *   24                             480 79 108 237     31         24                       480
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
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
1313741 1313741 MD     school 2400390 12   Harford 240039000709 583 North Harford Middle   Regular School No Middle 06 08 2021   pk_12_total 788 * 29   * *     *   37                             878 788   29               37                       878
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
1244698 1244698 MD     school 2400600 18   Saint Mary's 240060001229 305 Leonardtown Middle   Regular School No Middle 06 08 2020   pk_12_total 782 89 52   * 25     *   72                             1024 782 89 52     25         72                       1024
1312252 1312252 MD     school 2400210 6   Carroll 240021001185 704 Winters Mill High   Regular School No High 09 12 2021   pk_12_total 780 79 125   * 38     *   55                             1080 780 79 125     38         55                       1080
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
1246509 1246509 MD     school 2400090 30   Baltimore City 240009001478 326 City Neighbors Charter School   Regular School Yes Elementary KG 08 2020   pk_12_total 78 144 *               *                             231 78 144                                         231
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
1238602 1238602 MD     school 2400120 3   Baltimore County 240012001347 452 Owings Mills High   Regular School No High 09 12 2020   pk_12_total 77 642 385   * 54     *   25                             1189 77 642 385     54         25                       1189
1240320 1240320 MD     school 2400300 9   Dorchester 240030000621 710 Sandy Hill Elementary   Regular School No Elementary PK 05 2020   pk_12_total 77 241 35     *         34                             395 77 241 35               34                       395
1242584 1242584 MD     school 2400480 15   Montgomery 240048090456 565 Sequoyah Elementary   Regular School No Elementary KG 05 2020   pk_12_total 77 47 188     43         21                             376 77 47 188     43         21                       376
1246590 1246590 MD     school 2400090 30   Baltimore City 240009001680 346 City Neighbors Hamilton   Regular School Yes Elementary KG 08 2020   pk_12_total 77 126 11   * *         16                             234 77 126 11               16                       234
1314197 1314197 MD     school 2400420 13   Howard 240042000740 613 Jeffers Hill Elementary   Regular School No Elementary KG 05 2021   pk_12_total 77 144 90     41         21                             373 77 144 90     41         21                       373
1315055 1315055 MD     school 2400480 15   Montgomery 240048001511 546 Goshen Elementary   Regular School No Elementary PK 05 2021   pk_12_total 77 123 236     63         23                             522 77 123 236     63         23                       522
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
1319140 1319140 MD     school 2400090 30   Baltimore City 240009001680 346 City Neighbors Hamilton   Regular School Yes Elementary KG 08 2021   pk_12_total 77 127 11   * *         14                             234 77 127 11               14                       234
1319291 1319291 MD     school 2400090 30   Baltimore City 240009001313 416 Digital Harbor High School   Career and Technical School No High 09 12 2021   pk_12_total 77 846 373   * *     *   *                             1315 77 846 373                                       1315
1312137 1312137 MD     school 2400210 6   Carroll 240021000533 202 Francis Scott Key High   Regular School No High 09 12 2021   pk_12_total 767 25 48   * *     *   35                             885 767 25 48               35                       885
1317624 1317624 MD     school 2400660 21   Washington 240066001256 601 Boonsboro High   Regular School No High 09 12 2021   pk_12_total 761 15 40   * 18         37                             873 761 15 40     18         37                       873
1237392 1237392 MD     school 2400060 2   Anne Arundel 240006000066 1102 Ferndale Early Education Center   Regular School No Elementary PK KG 2020   pk_12_total 76 33 28   * *         *                             151 76 33 28                                       151
1241567 1241567 MD     school 2400420 13   Howard 240042000733 602 Guilford Elementary   Regular School No Elementary PK 05 2020   pk_12_total 76 230 65     74         30                             475 76 230 65     74         30                       475
1246711 1246711 MD     school 2400090 30   Baltimore City 240009000297 405 Patterson High   Career and Technical School No High 09 12 2020   pk_12_total 76 549 524   * *         10                             1174 76 549 524               10                       1174
1314209 1314209 MD     school 2400420 13   Howard 240042001700 617 Lake Elkhorn Middle   Regular School No Middle 06 08 2021   pk_12_total 76 326 114     47         37                             600 76 326 114     47         37                       600

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