enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 9,598 ✖
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
1313019 1313019 MD     school 2400330 10   Frederick 240033000641 313 Middletown High   Regular School No High 09 12 2021   pk_12_total 992 22 74   * 17     *   40                             1149 992 22 74     17         40                       1149
1311805 1311805 MD     school 2400120 3   Baltimore County 240012000401 1515 Hawthorne Elementary   Regular School No Elementary PK 05 2021   pk_12_total 99 249 42   * *         43                             442 99 249 42               43                       442
1310691 1310691 MD     school 2400060 2   Anne Arundel 240006000054 4283 Central Middle   Regular School No Middle 06 08 2021   pk_12_total 988 61 173   * 48     *   69                             1345 988 61 173     48         69                       1345
1313144 1313144 MD     school 2400330 10   Frederick 240033001688 920 Oakdale High   Regular School No High 09 12 2021   pk_12_total 983 84 135   * 90     *   62                             1362 983 84 135     90         62                       1362
1310330 1310330 MD     school 2400060 2   Anne Arundel 240006000078 3102 Hebron - Harman Elementary   Regular School No Elementary PK 05 2021   pk_12_total 98 285 161   * 75     *   64                             687 98 285 161     75         64                       687
1317458 1317458 MD     school 2400570 19   Somerset 240057001202 1401 Deal Island School   Regular School No Elementary PK 05 2021   pk_12_total 98 * *     *         *                             121 98                                           121
1310091 1310091 MD     school 2400060 2   Anne Arundel 240006000103 2023 Northeast High   Regular School No High 09 12 2021   pk_12_total 979 135 141   * 28     *   73                             1364 979 135 141     28         73                       1364
1312569 1312569 MD     school 2400240 7   Cecil 240024090469 905 Rising Sun High   Regular School No High 09 12 2021   pk_12_total 972 * 58   * *         27                             1076 972   58               27                       1076
1317074 1317074 MD     school 2400510 16   Prince George's 240051000512 2106 Greenbelt Elementary   Regular School No Elementary PK 05 2021   pk_12_total 97 319 75   * 42         15                             550 97 319 75     42         15                       550
1310081 1310081 MD     school 2400060 2   Anne Arundel 240006090441 1323 North County High   Regular School No High 09 12 2021   pk_12_total 963 634 463   * 118     *   138                             2327 963 634 463     118         138                       2327
1310618 1310618 MD     school 2400060 2   Anne Arundel 240006000074 4182 Germantown Elementary   Regular School No Elementary PK 05 2021   pk_12_total 96 107 271   * *         *                             485 96 107 271                                       485
1310721 1310721 MD     school 2400060 2   Anne Arundel 240006001724 6113 Monarch Global Academy PCS Laurel Campus   Regular School No Elementary KG 08 2021   pk_12_total 96 454 193   * 43     *   38                             828 96 454 193     43         38                       828
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
1314758 1314758 MD     school 2400480 15   Montgomery 240048001673 337 William B. Gibbs, Jr. Elementary   Regular School No Elementary PK 05 2021   pk_12_total 96 155 113     151         36                             551 96 155 113     151         36                       551
1317211 1317211 MD     school 2400540 17   Queen Anne's 240054001076 405 Kent Island High School   Regular School No High 09 12 2021   pk_12_total 952 56 78     23     *   62                             1174 952 56 78     23         62                       1174
1312927 1312927 MD     school 2400330 10   Frederick 240033000649 204 Lincoln Elementary   Regular School No Elementary PK 05 2021   pk_12_total 95 213 213   * 22         59                             605 95 213 213     22         59                       605
1315245 1315245 MD     school 2400480 15   Montgomery 240048000876 652 Monocacy Elementary   Regular School No Elementary PK 05 2021   pk_12_total 95 * 21     *         *                             136 95   21                                       136
1315506 1315506 MD     school 2400480 15   Montgomery 240048001207 792 Newport Mill Middle   Regular School No Middle 06 08 2021   pk_12_total 95 89 401   * 53         28                             670 95 89 401     53         28                       670
1316062 1316062 MD     school 2400510 16   Prince George's 240051001077 708 Kenilworth Elementary   Regular School No Elementary KG 05 2021   pk_12_total 95 186 53     21     *   18                             375 95 186 53     21         18                       375
1313639 1313639 MD     school 2400390 12   Harford 240039000717 348 Youths Benefit Elementary   Regular School No Elementary PK 05 2021   pk_12_total 942 22 44   * 27     *   37                             1082 942 22 44     27         37                       1082
1315418 1315418 MD     school 2400480 15   Montgomery 240048000878 776 Montgomery Knolls Elementary   Regular School No Elementary PK 02 2021   pk_12_total 94 127 215     25         29                             490 94 127 215     25         29                       490
1314936 1314936 MD     school 2400480 15   Montgomery 240048000921 503 Sherwood High   Regular School No High 09 12 2021   pk_12_total 938 290 363     225         96                             1912 938 290 363     225         96                       1912
1317180 1317180 MD     school 2400540 17   Queen Anne's 240054001195 301 Queen Anne's County High School   Regular School No High 09 12 2021   pk_12_total 938 89 111   * 11         59                             1210 938 89 111     11         59                       1210
1314915 1314915 MD     school 2400480 15   Montgomery 240048009000 428 Thomas W. Pyle Middle School   Regular School No Middle 06 08 2021   pk_12_total 931 41 149     214     *   97                             1433 931 41 149     214         97                       1433
1311279 1311279 MD     school 2400120 3   Baltimore County 240012000373 872 Dulaney High   Regular School No High 09 12 2021   pk_12_total 930 438 221   * 248     *   87                             1930 930 438 221     248         87                       1930
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
1318820 1318820 MD     school 2400090 30   Baltimore City 240009000231 236 Hamilton Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 93 673 50   * 10     *   26                             854 93 673 50     10         26                       854
1310900 1310900 MD     school 2400120 3   Baltimore County 240012000355 174 Catonsville High   Regular School No High 09 12 2021   pk_12_total 929 443 100   * 233     *   94                             1809 929 443 100     233         94                       1809
1313659 1313659 MD     school 2400390 12   Harford 240039000682 374 Southampton Middle   Regular School No Middle 06 08 2021   pk_12_total 923 74 59   * 59         56                             1173 923 74 59     59         56                       1173
1312859 1312859 MD     school 2400300 9   Dorchester 240030001423 707 Mace's Lane Middle School   Regular School No Middle 06 08 2021   pk_12_total 92 405 63     *     *   36                             603 92 405 63               36                       603
1313429 1313429 MD     school 2400390 12   Harford 240039000688 115 Edgewood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 92 190 39   * *     *   21                             349 92 190 39               21                       349
1314051 1314051 MD     school 2400420 13   Howard 240042000737 518 Harpers Choice Middle   Regular School No Middle 06 08 2021   pk_12_total 92 241 74   * 38     *   43                             490 92 241 74     38         43                       490
1312218 1312218 MD     school 2400210 6   Carroll 240021001161 510 Century High   Regular School No High 09 12 2021   pk_12_total 919 53 79   * 52     *   27                             1135 919 53 79     52         27                       1135
1310268 1310268 MD     school 2400060 2   Anne Arundel 240006000042 2423 Chesapeake Bay Middle   Regular School No Middle 06 08 2021   pk_12_total 908 31 60   * 15         43                             1062 908 31 60     15         43                       1062
1310467 1310467 MD     school 2400060 2   Anne Arundel 240006000109 3353 Old Mill High   Regular School No High 09 12 2021   pk_12_total 906 829 344   * 117     10   153                             2364 906 829 344     117     10   153                       2364
1311503 1311503 MD     school 2400120 3   Baltimore County 240012000446 1171 Perry Hall High   Regular School No High 09 12 2021   pk_12_total 904 659 107   * 256     *   85                             2018 904 659 107     256         85                       2018
1313845 1313845 MD     school 2400420 13   Howard 240042001749 111 Hanover Hills   Regular School No Elementary PK 05 2021   pk_12_total 90 319 117   * 198         43                             774 90 319 117     198         43                       774
1314316 1314316 MD     school 2400480 15   Montgomery 240048000804 101 Clarksburg Elementary   Regular School No Elementary PK 05 2021   pk_12_total 90 190 115   * 242     *   51                             690 90 190 115     242         51                       690
1316576 1316576 MD     school 2400510 16   Prince George's 240051001245 1416 Dora Kennedy French Immersion   Regular School No Elementary KG 08 2021   pk_12_total 90 474 45   * 22     *   19                             654 90 474 45     22         19                       654
1318735 1318735 MD     school 2400090 30   Baltimore City 240009000326 226 Violetville Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 90 171 57   * 13     *   23                             358 90 171 57     13         23                       358
1310344 1310344 MD     school 2400060 2   Anne Arundel 240006000092 3122 Manor View Elementary   Regular School No Elementary 01 05 2021   pk_12_total 89 47 51   * *     *   37                             235 89 47 51               37                       235
1311141 1311141 MD     school 2400120 3   Baltimore County 240012000356 408 Cedarmere Elementary   Regular School No Elementary PK 05 2021   pk_12_total 89 214 159     46         16                             524 89 214 159     46         16                       524
1314205 1314205 MD     school 2400420 13   Howard 240042001699 616 Cradlerock Elementary   Regular School No Elementary PK 05 2021   pk_12_total 89 214 86   * 27         39                             456 89 214 86     27         39                       456
1316220 1316220 MD     school 2400510 16   Prince George's 240051000988 1011 Bond Mill Elementary   Regular School No Elementary KG 05 2021   pk_12_total 89 224 101   * 39     *   29                             488 89 224 101     39         29                       488
1313975 1313975 MD     school 2400420 13   Howard 240042000731 404 Glenelg High   Regular School No High 09 12 2021   pk_12_total 888 52 77   * 179         65                             1263 888 52 77     179         65                       1263
1311498 1311498 MD     school 2400120 3   Baltimore County 240012000447 1151 Perry Hall Middle   Regular School No Middle 06 08 2021   pk_12_total 885 502 86   * 312     *   86                             1878 885 502 86     312         86                       1878
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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