enrollments

Data source: Big Local News · About: Big Local

1,393 rows where grade = "pk_12_total", state = "MD" and year = 2021 sorted by white_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 1,393 ✖

grade ✖

  • pk_12_total · 1,393 ✖
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
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   *                                               *                                              
1315785 1315785 MD     school 2400510 16   Prince George's 240051000865 216 Annapolis Road Academy   Alternative School No Secondary 09 10 2021   pk_12_total   33 48     *         *                             83   33 48                                       83
1317149 1317149 MD     school   16   Prince George's   2217 Incarcerated Youth Center (JACS)             2021   pk_12_total   * *               *                             11                                             11
1317152 1317152 MD     school 2400510 16   Prince George's 240051001755 2218 Career and Technical Education Evening High   Career and Technical School No High 11 12 2021   pk_12_total   * 21   *           *                             27     21                                       27
1317154 1317154 MD     school 2400510 16   Prince George's 240051001067 2220 Community Based Classrooms   Alternative School No High 12 12 2021   pk_12_total   37 27     *         *                             68   37 27                                       68
1318169 1318169 MD     school 2400090 30   Baltimore City 240009000239 35 Harlem Park Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total   275 *   *           *                             282   275                                         282
1318185 1318185 MD     school 2400090 30   Baltimore City 240009000184 39 Dallas F. Nicholas, Sr., Elementary   Regular School No Elementary PK 05 2021   pk_12_total   190 16   * *     *   *                             217   190 16                                       217
1318313 1318313 MD     school 2400090 30   Baltimore City 240009000307 63 Rosemont Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total   341 *     *         *                             351   341                                         351
1318503 1318503 MD     school 2400090 30   Baltimore City 240009000303 142 Robert W. Coleman Elementary   Regular School No Elementary PK 05 2021   pk_12_total   227 *                                             234   227                                         234
1318511 1318511 MD     school 2400090 30   Baltimore City 240009000255 144 James Mosher Elementary   Regular School No Elementary PK 05 2021   pk_12_total   208 *           *   *                             221   208                                         221
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
1318654 1318654 MD     school 2400090 30   Baltimore City 240009001428 214 Guilford Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total   254 *     *         *                             262   254                                         262
1318980 1318980 MD     school 2400090 30   Baltimore City 240009001558 262 Empowerment Academy   Regular School Yes Elementary PK 08 2021   pk_12_total   284 *                                             287   284                                         287
1319038 1319038 MD     school 2400090 30   Baltimore City 240009000884 322 New Song Academy   Regular School Yes Elementary PK 08 2021   pk_12_total   172 *                                             174   172                                         174
1319117 1319117 MD     school 2400090 30   Baltimore City 240009001661 337 Afya Public Charter School   Regular School Yes Middle 08 08 2021   pk_12_total   105 *                                             112   105                                         112
1319187 1319187 MD     school 2400090 30   Baltimore City 240009001734 371 Lillie May Carroll Jackson School   Regular School Yes Middle 05 08 2021   pk_12_total   306 *                                             309   306                                         309
1319208 1319208 MD     school 2400090 30   Baltimore City 240009001736 375 Baltimore Collegiate School for Boys   Regular School Yes Middle 04 08 2021   pk_12_total   455 *   *       *   *                             466   455                                         466
1310253 1310253 MD     school 2400060 2   Anne Arundel 240006001402 2363 Broadneck High   Regular School No High 09 12 2021   pk_12_total 1634 158 234   * 63     *   130                             2233 1634 158 234     63         130                       2233
1310086 1310086 MD     school 2400060 2   Anne Arundel 240006000127 2013 Severna Park High   Regular School No High 09 12 2021   pk_12_total 1525 68 109   * 78     *   95                             1880 1525 68 109     78         95                       1880
1314898 1314898 MD     school 2400480 15   Montgomery 240048000942 424 Walter Johnson High   Regular School No High 09 12 2021   pk_12_total 1457 322 477   * 387     *   163                             2820 1457 322 477     387         163                       2820
1310696 1310696 MD     school 2400060 2   Anne Arundel 240006000055 4293 South River High   Regular School No High 09 12 2021   pk_12_total 1415 100 228   * 86     *   83                             1916 1415 100 228     86         83                       1916
1317272 1317272 MD     school 2400600 18   Saint Mary's 240060001218 303 Chopticon High   Regular School No High 09 12 2021   pk_12_total 1375 134 74   * 14     *   85                             1689 1375 134 74     14         85                       1689
1317281 1317281 MD     school 2400600 18   Saint Mary's 240060001356 306 Leonardtown High   Regular School No High 09 12 2021   pk_12_total 1366 162 117   * 58     *   138                             1846 1366 162 117     58         138                       1846
1314911 1314911 MD     school 2400480 15   Montgomery 240048000941 427 Walt Whitman High   Regular School No High 09 12 2021   pk_12_total 1285 81 205   * 278     *   138                             1991 1285 81 205     278         138                       1991
1314834 1314834 MD     school 2400480 15   Montgomery 240048000784 406 Bethesda-Chevy Chase High   Regular School No High 09 12 2021   pk_12_total 1263 333 400   * 139     *   130                             2270 1263 333 400     139         130                       2270
1312265 1312265 MD     school 2400210 6   Carroll 240021000552 707 Westminster High   Regular School No High 09 12 2021   pk_12_total 1242 70 84   * 56     *   59                             1515 1242 70 84     56         59                       1515
1310241 1310241 MD     school 2400060 2   Anne Arundel 240006000058 2273 Chesapeake High   Regular School No High 09 12 2021   pk_12_total 1183 57 94   * 27     *   43                             1412 1183 57 94     27         43                       1412
1313094 1313094 MD     school 2400330 10   Frederick 240033000638 912 Linganore High   Regular School No High 09 12 2021   pk_12_total 1162 33 115   * 23     *   57                             1393 1162 33 115     23         57                       1393
1312231 1312231 MD     school 2400210 6   Carroll 240021001672 602 Manchester Valley High   Regular School No High 09 12 2021   pk_12_total 1154 34 73   * 31     *   25                             1321 1154 34 73     31         25                       1321
1313655 1313655 MD     school 2400390 12   Harford 240039000683 373 Bel Air High   Regular School No High 09 12 2021   pk_12_total 1146 121 102   * 119     *   63                             1557 1146 121 102     119         63                       1557
1310099 1310099 MD     school 2400060 2   Anne Arundel 240006000126 2043 Severna Park Middle   Regular School No Middle 06 08 2021   pk_12_total 1130 55 76   * 69     *   75                             1412 1130 55 76     69         75                       1412
1313737 1313737 MD     school 2400390 12   Harford 240039000710 580 North Harford High   Regular School No High 09 12 2021   pk_12_total 1118 26 29   * 14         36                             1226 1118 26 29     14         36                       1226
1312038 1312038 MD     school 2400150 4   Calvert 240015000516 314 Northern High   Regular School No High 09 12 2021   pk_12_total 1096 166 87   * 33     *   94                             1483 1096 166 87     33         94                       1483
1311194 1311194 MD     school 2400120 3   Baltimore County 240012001432 772 Hereford High   Regular School No High 09 12 2021   pk_12_total 1093 33 57     57         45                             1285 1093 33 57     57         45                       1285
1313650 1313650 MD     school 2400390 12   Harford 240039001397 372 Bel Air Middle   Regular School No Middle 06 08 2021   pk_12_total 1067 113 90   * 106     *   61                             1441 1067 113 90     106         61                       1441
1312018 1312018 MD     school 2400150 4   Calvert 240015001342 217 Huntingtown High School   Regular School No High 09 12 2021   pk_12_total 1060 134 80   * 22         100                             1398 1060 134 80     22         100                       1398
1313052 1313052 MD     school 2400330 10   Frederick 240033000616 713 Urbana High   Regular School No High 09 12 2021   pk_12_total 1055 173 242   11 320     *   103                             1908 1055 173 242   11 320         103                       1908
1317977 1317977 MD     school 2400720 23   Worcester 240072001335 310 Stephen Decatur High   Regular School No High 09 12 2021   pk_12_total 1046 121 105   * 25     *   70                             1369 1046 121 105     25         70                       1369
1311404 1311404 MD     school 2400120 3   Baltimore County 240012000487 971 Towson High   Regular School No High 09 12 2021   pk_12_total 1036 303 99   * 133     *   102                             1677 1036 303 99     133         102                       1677
1313669 1313669 MD     school 2400390 12   Harford 240039001380 385 C. Milton Wright High   Regular School No High 09 12 2021   pk_12_total 1026 100 68   * 72     *   61                             1330 1026 100 68     72         61                       1330
1315207 1315207 MD     school 2400480 15   Montgomery 240048000956 602 Winston Churchill High   Regular School No High 09 12 2021   pk_12_total 1016 226 178   * 688     *   132                             2245 1016 226 178     688         132                       2245
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1312111 1312111 MD     school 2400180 5   Caroline 240018000523 703 North Caroline High School   Regular School No High 09 12 2021   pk_12_total 743 113 213   * 10     *   81                             1164 743 113 213     10         81                       1164
1313673 1313673 MD     school 2400390 12   Harford 240039090475 386 Fallston Middle School   Regular School No Middle 06 08 2021   pk_12_total 743 29 30   * 20         38                             864 743 29 30     20         38                       864
1313323 1313323 MD     school 2400330 10   Frederick 240033000655 2610 Walkersville High   Regular School No High 09 12 2021   pk_12_total 733 183 168   * 44     *   89                             1219 733 183 168     44         89                       1219
1310434 1310434 MD     school 2400060 2   Anne Arundel 240006001403 3263 Crofton Middle   Regular School No Middle 06 08 2021   pk_12_total 720 257 152   * 114     *   87                             1339 720 257 152     114         87                       1339
1310527 1310527 MD     school 2400060 2   Anne Arundel 240006000132 4023 Southern High   Regular School No High 09 12 2021   pk_12_total 719 73 176     10     *   53                             1032 719 73 176     10         53                       1032
1311936 1311936 MD     school 2400150 4   Calvert 240015000611 113 Patuxent High   Regular School No High 09 12 2021   pk_12_total 716 190 68   * 20         88                             1085 716 190 68     20         88                       1085
1309889 1309889 MD     school 2400030 1   Allegany 240003001636 2404 Mountain Ridge High School   Regular School No High 09 12 2021   pk_12_total 712 17 12   * *         23                             771 712 17 12               23                       771
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
1312586 1312586 MD     school 2400270 8   Charles 240027000596 106 La Plata High School   Regular School No High 09 12 2021   pk_12_total 703 247 73   * 38     *   107                             1174 703 247 73     38         107                       1174
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
1314435 1314435 MD     school 2400480 15   Montgomery 240048000902 201 Richard Montgomery High   Regular School No High 09 12 2021   pk_12_total 699 399 577   * 586     *   143                             2410 699 399 577     586         143                       2410
1312001 1312001 MD     school 2400150 4   Calvert 240015000508 213 Calvert High   Regular School No High 09 12 2021   pk_12_total 696 222 89   * 24     *   96                             1132 696 222 89     24         96                       1132
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
1313258 1313258 MD     school 2400330 10   Frederick 240033001550 2307 Tuscarora High   Regular School No High 09 12 2021   pk_12_total 690 356 379   * 125     *   87                             1645 690 356 379     125         87                       1645
1312548 1312548 MD     school 2400240 7   Cecil 240024000577 705 Perryville High   Regular School No High 09 12 2021   pk_12_total 677 36 36   * 10     *   46                             810 677 36 36     10         46                       810
1311266 1311266 MD     school 2400120 3   Baltimore County 240012001434 852 Ridgely Middle   Regular School No Middle 06 08 2021   pk_12_total 676 105 61   * 207     *   45                             1100 676 105 61     207         45                       1100
1313970 1313970 MD     school 2400420 13   Howard 240042001437 308 Marriotts Ridge High   Regular School No High 09 12 2021   pk_12_total 675 159 58   * 626     *   73                             1597 675 159 58     626         73                       1597
1312247 1312247 MD     school 2400210 6   Carroll 240021000553 703 Westminster West Middle   Regular School No Middle 06 08 2021   pk_12_total 671 59 108   * 28     *   33                             904 671 59 108     28         33                       904
1313866 1313866 MD     school 2400420 13   Howard 240042000743 207 Mount Hebron High   Regular School No High 09 12 2021   pk_12_total 660 205 152   * 555     *   58                             1635 660 205 152     555         58                       1635

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