enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 9,498 ✖
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 ▲
1317902 1317902 MD     school 2400690 22   Wicomico 240069001305 1307 James M. Bennett High   Regular School No High 09 12 2021   pk_12_total 575 475 155   * 68     *   77                             1362 575 475 155     68         77                       1362
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
1317744 1317744 MD     school 2400660 21   Washington 240066001275 2101 North Hagerstown High   Regular School No High 09 12 2021   pk_12_total 653 278 205   * 54     *   150                             1343 653 278 205     54         150                       1343
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
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
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
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
1314222 1314222 MD     school 2400420 13   Howard 240042000735 619 Hammond High   Regular School No High 09 12 2021   pk_12_total 319 523 230   * 142     *   97                             1316 319 523 230     142         97                       1316
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
1311026 1311026 MD     school 2400120 3   Baltimore County 240012000432 271 Milford Mill Academy   Regular School No High 09 12 2021   pk_12_total 22 1155 84   * 15         33                             1312 22 1155 84     15         33                       1312
1311664 1311664 MD     school 2400120 3   Baltimore County 240012000416 1371 Lansdowne High   Regular School No High 09 12 2021   pk_12_total 462 330 342   10 100         52                             1296 462 330 342   10 100         52                       1296
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
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
1317008 1317008 MD     school 2400510 16   Prince George's 240051001175 2009 Thomas Johnson Middle   Regular School No Middle 06 08 2021   pk_12_total 30 625 578   * 35     *   *                             1282 30 625 578     35                                 1282
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
1314182 1314182 MD     school 2400420 13   Howard 240042000745 611 Oakland Mills High   Regular School No High 09 12 2021   pk_12_total 245 553 281   * 95     *   90                             1269 245 553 281     95         90                       1269
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
1311152 1311152 MD     school 2400120 3   Baltimore County 240012000389 451 Franklin Middle   Regular School No Middle 06 08 2021   pk_12_total 271 625 197   * 88     *   73                             1258 271 625 197     88         73                       1258
1314391 1314391 MD     school 2400480 15   Montgomery 240048000897 152 Poolesville High   Regular School No High 09 12 2021   pk_12_total 551 73 113   * 431         65                             1236 551 73 113     431         65                       1236
1319266 1319266 MD     school 2400090 30   Baltimore City 240009000330 407 Western High   Regular School No High 09 12 2021   pk_12_total 56 1090 68   * 11     *   *                             1236 56 1090 68     11                                 1236
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
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
1311167 1311167 MD     school 2400120 3   Baltimore County 240012001547 473 New Town High   Regular School No High 09 12 2021   pk_12_total 16 1117 27   * 13         40                             1214 16 1117 27     13         40                       1214
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
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
1311912 1311912 MD     school 2400120 3   Baltimore County 240012000379 1575 Eastern Technical High School   Career and Technical School No High 09 12 2021   pk_12_total 577 243 56   * 272     *   53                             1207 577 243 56     272         53                       1207
1313547 1313547 MD     school 2400390 12   Harford 240039000678 265 Aberdeen Middle   Regular School No Middle 06 08 2021   pk_12_total 407 495 135   * 26     *   131                             1204 407 495 135     26         131                       1204
1314858 1314858 MD     school 2400480 15   Montgomery 240048001118 413 North Bethesda Middle   Regular School No Middle 06 08 2021   pk_12_total 649 126 162   * 150         107                             1198 649 126 162     150         107                       1198
1309930 1309930 MD     school 2400060 2   Anne Arundel 240006000087 1053 Lindale Middle   Regular School No Middle 06 08 2021   pk_12_total 490 347 222   * 51     *   80                             1194 490 347 222     51         80                       1194
1317834 1317834 MD     school 2400690 22   Wicomico 240069001320 513 Wicomico High   Regular School No High 09 12 2021   pk_12_total 306 592 178   * 32     *   77                             1190 306 592 178     32         77                       1190
1316365 1316365 MD     school 2400510 16   Prince George's 240051001133 1220 Potomac High   Regular School No High 09 12 2021   pk_12_total 10 835 312   * 10     *   12                             1187 10 835 312     10         12                       1187
1313501 1313501 MD     school 2400390 12   Harford 240039000689 177 Edgewood Middle   Regular School No Middle 06 08 2021   pk_12_total 353 532 157   * 24     *   113                             1186 353 532 157     24         113                       1186
1315034 1315034 MD     school 2400480 15   Montgomery 240048001441 522 Lakelands Park Middle   Regular School No Middle 06 09 2021   pk_12_total 409 181 301   * 210         80                             1182 409 181 301     210         80                       1182
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
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
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
1317463 1317463 MD     school 2400630 20   Talbot 240063001242 101 Easton High   Regular School No High 09 12 2021   pk_12_total 655 160 263   * 29     *   61                             1170 655 160 263     29         61                       1170
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
1315237 1315237 MD     school 2400480 15   Montgomery 240048001128 647 Silver Spring International Middle   Regular School No Middle 06 08 2021   pk_12_total 299 260 500   * 51         48                             1160 299 260 500     51         48                       1160
1315324 1315324 MD     school 2400480 15   Montgomery 240048000933 755 Takoma Park Middle School   Regular School No Middle 06 08 2021   pk_12_total 345 394 189   * 161         67                             1158 345 394 189     161         67                       1158
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
1311391 1311391 MD     school 2400120 3   Baltimore County 240012000374 953 Dumbarton Middle   Regular School No Middle 06 08 2021   pk_12_total 656 151 167     103     *   71                             1152 656 151 167     103         71                       1152
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
1311717 1311717 MD     school 2400120 3   Baltimore County 240012000438 1473 Overlea High   Regular School No High 09 12 2021   pk_12_total 181 751 119   * 39     *   52                             1148 181 751 119     39         52                       1148
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
1312701 1312701 MD     school 2400270 8   Charles 240027000144 619 Westlake High School   Regular School No High 09 12 2021   pk_12_total 68 877 89   * 42     *   57                             1139 68 877 89     42         57                       1139
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
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
1311884 1311884 MD     school 2400120 3   Baltimore County 240012001440 1556 Middle River Middle   Regular School No Middle 06 08 2021   pk_12_total 355 540 124   * 32     *   77                             1132 355 540 124     32         77                       1132
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
1311157 1311157 MD     school 2400120 3   Baltimore County 240012001347 452 Owings Mills High   Regular School No High 09 12 2021   pk_12_total 59 619 363   * 48     *   26                             1120 59 619 363     48         26                       1120
1310284 1310284 MD     school 2400060 2   Anne Arundel 240006000039 3023 Arundel Middle   Regular School No Middle 06 08 2021   pk_12_total 501 307 130   * 59     *   116                             1119 501 307 130     59         116                       1119
1312632 1312632 MD     school 2400270 8   Charles 240027000607 605 Thomas Stone High School   Regular School No High 09 12 2021   pk_12_total 138 708 186   * 19     *   59                             1115 138 708 186     19         59                       1115
1316651 1316651 MD     school 2400510 16   Prince George's 240051001036 1502 Frederick Douglass High   Regular School No High 09 12 2021   pk_12_total 17 992 69   * *     *   28                             1115 17 992 69               28                       1115
1317911 1317911 MD     school 2400690 22   Wicomico 240069001309 1309 Parkside High   Regular School No High 09 12 2021   pk_12_total 577 368 67   * 33         64                             1113 577 368 67     33         64                       1113
1316213 1316213 MD     school 2400510 16   Prince George's 240051001024 1010 Dwight D. Eisenhower Middle   Regular School No Middle 06 08 2021   pk_12_total 35 540 495   * 25     *   14                             1112 35 540 495     25         14                       1112
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
1311031 1311031 MD     school 2400120 3   Baltimore County 240012000458 272 Randallstown High   Regular School No High 09 12 2021   pk_12_total 16 1001 44     22         14                             1097 16 1001 44     22         14                       1097
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
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
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
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
1315225 1315225 MD     school 2400480 15   Montgomery 240048001526 606 Cabin John Middle School   Regular School No Middle 06 08 2021   pk_12_total 414 137 104   * 357         64                             1077 414 137 104     357         64                       1077
1311712 1311712 MD     school 2400120 3   Baltimore County 240012000442 1452 Parkville Middle   Regular School No Middle 06 08 2021   pk_12_total 435 429 78   * 71     *   61                             1076 435 429 78     71         61                       1076
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
1316078 1316078 MD     school 2400510 16   Prince George's 240051000982 714 Benjamin Tasker Middle School   Regular School No Middle 06 08 2021   pk_12_total 129 718 127   * 53     *   28                             1068 129 718 127     53         28                       1068
1317235 1317235 MD     school 2400600 18   Saint Mary's 240060001237 101 Spring Ridge Middle   Regular School No Middle 06 08 2021   pk_12_total 417 366 128   * 33     *   118                             1067 417 366 128     33         118                       1067
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
1310531 1310531 MD     school 2400060 2   Anne Arundel 240006000036 4033 Annapolis Middle   Regular School No Middle 06 08 2021   pk_12_total 157 309 549   * 19     *   25                             1061 157 309 549     19         25                       1061
1312414 1312414 MD     school 2400240 7   Cecil 240024000568 302 Elkton High   Regular School No High 09 12 2021   pk_12_total 493 290 151   * 13     *   107                             1061 493 290 151     13         107                       1061
1312573 1312573 MD     school 2400270 8   Charles 240027000601 104 Milton M. Somers Middle School   Regular School No Middle 06 08 2021   pk_12_total 386 437 103   * 37     *   83                             1049 386 437 103     37         83                       1049
1315302 1315302 MD     school 2400480 15   Montgomery 240048000863 708 Kingsview Middle   Regular School No Middle 06 08 2021   pk_12_total 232 280 187   * 276     *   67                             1048 232 280 187     276         67                       1048
1317471 1317471 MD     school 2400630 20   Talbot 240063001244 104 Easton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 304 217 424     33         70                             1048 304 217 424     33         70                       1048
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
1310458 1310458 MD     school 2400060 2   Anne Arundel 240006000107 3333 Old Mill Middle North   Regular School No Middle 06 08 2021   pk_12_total 312 479 145   * 42     *   59                             1042 312 479 145     42         59                       1042
1314414 1314414 MD     school 2400480 15   Montgomery 240048000493 157 Roberto W. Clemente Middle   Regular School No Middle 06 08 2021   pk_12_total 120 304 359   * 203     *   51                             1040 120 304 359     203         51                       1040
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
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
1316262 1316262 MD     school 2400510 16   Prince George's 240051001052 1103 Gwynn Park High   Regular School No High 09 12 2021   pk_12_total 31 825 117   * 16     *   28                             1025 31 825 117     16         28                       1025
1312713 1312713 MD     school 2400270 8   Charles 240027000615 621 Mattawoman Middle School   Regular School No Middle 06 08 2021   pk_12_total 37 756 116   * 54     *   56                             1024 37 756 116     54         56                       1024
1312819 1312819 MD     school 2400270 8   Charles 240027000597 1002 Henry E. Lackey High School   Regular School No High 09 12 2021   pk_12_total 276 578 72   * 22     *   66                             1024 276 578 72     22         66                       1024
1314553 1314553 MD     school 2400480 15   Montgomery 240048001450 232 Tilden Middle School   Regular School No Middle 06 08 2021   pk_12_total 423 141 227   * 173     *   55                             1022 423 141 227     173         55                       1022
1314536 1314536 MD     school 2400480 15   Montgomery 240048000849 228 Herbert Hoover Middle   Regular School No Middle 06 08 2021   pk_12_total 400 81 76   * 399     *   63                             1021 400 81 76     399         63                       1021
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
1310462 1310462 MD     school 2400060 2   Anne Arundel 240006000108 3343 Old Mill Middle South   Regular School No Middle 06 08 2021   pk_12_total 495 237 169   * 33     *   80                             1018 495 237 169     33         80                       1018
1318888 1318888 MD     school 2400090 30   Baltimore City 240009000268 245 Leith Walk Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 950 48   * *     *   *                             1018   950 48                                       1018
1314578 1314578 MD     school 2400480 15   Montgomery 240048001447 237 Robert Frost Middle School   Regular School No Middle 06 08 2021   pk_12_total 375 105 81   * 399     *   54                             1017 375 105 81     399         54                       1017
1311659 1311659 MD     school 2400120 3   Baltimore County 240012000342 1356 Arbutus Middle   Regular School No Middle 06 08 2021   pk_12_total 522 205 46   * 140     *   83                             1004 522 205 46     140         83                       1004
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
1312591 1312591 MD     school 2400270 8   Charles 240027000600 108 Maurice J. McDonough High School   Regular School No High 09 12 2021   pk_12_total 310 479 116   * 27     *   64                             999 310 479 116     27         64                       999
1315617 1315617 MD     school 2400480 15   Montgomery 240048000820 820 Earle B. Wood Middle   Regular School No Middle 06 08 2021   pk_12_total 253 130 444   * 112     *   56                             998 253 130 444     112         56                       998
1311419 1311419 MD     school 2400120 3   Baltimore County 240012000230 975 George W. Carver Center for Arts & Technology   Career and Technical School No High 09 12 2021   pk_12_total 458 354 63   * 66     *   50                             997 458 354 63     66         50                       997
1313624 1313624 MD     school 2400390 12   Harford 240039000701 335 Homestead/Wakefield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 710 54 81   * 70     *   75                             996 710 54 81     70         75                       996
1315476 1315476 MD     school 2400480 15   Montgomery 240048001446 787 A. Mario Loiederman Middle   Regular School No Middle 06 08 2021   pk_12_total 149 150 622   * 42         30                             996 149 150 622     42         30                       996
1312201 1312201 MD     school 2400210 6   Carroll 240021001394 507 Liberty High   Regular School No High 09 12 2021   pk_12_total 815 55 44     38     *   34                             993 815 55 44     38         34                       993
1313565 1313565 MD     school 2400390 12   Harford 240039000694 304 Harford Technical High   Career and Technical School No High 09 12 2021   pk_12_total 702 133 75   * 32     *   47                             993 702 133 75     32         47                       993
1316825 1316825 MD     school 2400510 16   Prince George's 240051001257 1730 Mary Harris   Regular School No Elementary PK 05 2021   pk_12_total * 44 927   * *     *   *                             991   44 927                                       991
1311907 1311907 MD     school 2400120 3   Baltimore County 240012000362 1574 Chesapeake High   Regular School No High 09 12 2021   pk_12_total 251 553 116   * 12     *   51                             988 251 553 116     12         51                       988
1315298 1315298 MD     school 2400480 15   Montgomery 240048000660 707 Rocky Hill Middle   Regular School No Middle 06 08 2021   pk_12_total 154 276 285   * 216     *   51                             986 154 276 285     216         51                       986
1319347 1319347 MD     school 2400090 30   Baltimore City 240009000168 454 Carver Vocational-Technical High   Career and Technical School No High 09 12 2021   pk_12_total 15 942 24   * *         *                             985 15 942 24                                       985

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