enrollments

Data source: Big Local News · About: Big Local

19,213 rows where state = "MD" sorted by asian 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
1241242 1241242 MD     school 2400420 13   Howard 240042090448 103 Deep Run Elementary   Regular School No Elementary PK 05 2020   pk_12_total 162 110 348   * 99         42                             767 162 110 348     99         42                       767
1242325 1242325 MD     school 2400480 15   Montgomery 240048000963 422 Wyngate Elementary   Regular School No Elementary PK 05 2020   pk_12_total 448 33 90     99     *   70                             741 448 33 90     99         70                       741
1238320 1238320 MD     school 2400120 3   Baltimore County 240012000406 115 Hillcrest Elementary   Regular School No Elementary PK 05 2020   pk_12_total 409 75 81   * 98     *   32                             698 409 75 81     98         32                       698
1238683 1238683 MD     school 2400120 3   Baltimore County 240012090440 810 Padonia International Elementary   Regular School No Elementary PK 05 2020   pk_12_total 53 92 259   * 98         21                             524 53 92 259     98         21                       524
1242183 1242183 MD     school 2400480 15   Montgomery 240048090450 335 Briggs Chaney Middle   Regular School No Middle 06 08 2020   pk_12_total 64 504 236     98     *   33                             936 64 504 236     98         33                       936
1314381 1314381 MD     school 2400480 15   Montgomery 240048000759 115 Neelsville Middle   Regular School No Middle 06 08 2021   pk_12_total 54 235 420   * 98         32                             842 54 235 420     98         32                       842
1242310 1242310 MD     school 2400480 15   Montgomery 240048000793 419 Burning Tree Elementary   Regular School No Elementary KG 05 2020   pk_12_total 263 36 46     97     *   26                             469 263 36 46     97         26                       469
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
1238132 1238132 MD     school 2400060 2   Anne Arundel 240006000055 4293 South River High   Regular School No High 09 12 2020   pk_12_total 1673 123 216   * 96     *   111                             2224 1673 123 216     96         111                       2224
1241786 1241786 MD     school 2400480 15   Montgomery 240048001417 107 Martin Luther King Jr. Middle   Regular School No Middle 06 08 2020   pk_12_total 97 257 267   * 96         46                             764 97 257 267     96         46                       764
1237884 1237884 MD     school 2400060 2   Anne Arundel 240006001658 3282 Nantucket Elementary   Regular School No Elementary KG 05 2020   pk_12_total 361 219 57   * 95     *   44                             779 361 219 57     95         44                       779
1240586 1240586 MD     school 2400330 10   Frederick 240033001165 919 Oakdale Elementary   Regular School No Elementary KG 05 2020   pk_12_total 503 89 73   * 95     *   25                             792 503 89 73     95         25                       792
1243142 1243142 MD     school 2400510 16   Prince George's 240051001660 111 Vansville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 34 407 215   * 95     *   21                             775 34 407 215     95         21                       775
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
1314877 1314877 MD     school 2400480 15   Montgomery 240048000793 419 Burning Tree Elementary   Regular School No Elementary KG 05 2021   pk_12_total 230 37 35     95     *   22                             420 230 37 35     95         22                       420
1314893 1314893 MD     school 2400480 15   Montgomery 240048000963 422 Wyngate Elementary   Regular School No Elementary PK 05 2021   pk_12_total 404 28 89     95     *   56                             673 404 28 89     95         56                       673
1316592 1316592 MD     school 2400510 16   Prince George's 240051000990 1423 Bowie High   Regular School No High 09 12 2021   pk_12_total 237 1608 381   * 94     *   76                             2406 237 1608 381     94         76                       2406
1238265 1238265 MD     school 2400120 3   Baltimore County 240012000495 103 Westowne Elementary   Regular School No Elementary PK 05 2020   pk_12_total 250 256 45   * 93     *   45                             698 250 256 45     93         45                       698
1238336 1238336 MD     school 2400120 3   Baltimore County 240012000411 155 Southwest Academy   Regular School No Middle 06 08 2020   pk_12_total 30 564 106   * 93         26                             823 30 564 106     93         26                       823
1241590 1241590 MD     school 2400420 13   Howard 240042000757 605 Thunder Hill Elementary   Regular School No Elementary KG 05 2020   pk_12_total 158 134 49   * 93     *   39                             475 158 134 49     93         39                       475
1310811 1310811 MD     school 2400120 3   Baltimore County 240012000936 102 Westchester Elementary   Regular School No Elementary PK 05 2021   pk_12_total 415 71 55   * 93         31                             668 415 71 55     93         31                       668
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
1314341 1314341 MD     school 2400480 15   Montgomery 240048000834 106 Fox Chapel Elementary   Regular School No Elementary PK 05 2021   pk_12_total 63 137 266   * 92     *   27                             589 63 137 266     92         27                       589
1315722 1315722 MD     school 2400510 16   Prince George's 240051001660 111 Vansville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 30 391 193     92     *   25                             732 30 391 193     92         25                       732
1240999 1240999 MD     school 2400390 12   Harford 240039000679 270 Aberdeen High   Regular School No High 09 12 2020   pk_12_total 517 543 145   * 91     *   119                             1431 517 543 145     91         119                       1431
1241774 1241774 MD     school 2400480 15   Montgomery 240048000903 105 Ridgeview Middle   Regular School No Middle 06 08 2020   pk_12_total 296 124 239   * 91         31                             784 296 124 239     91         31                       784
1241844 1241844 MD     school 2400480 15   Montgomery 240048000181 155 Rosa M. Parks Middle   Regular School No Middle 06 08 2020   pk_12_total 484 121 116     91         56                             868 484 121 116     91         56                       868
1242052 1242052 MD     school 2400480 15   Montgomery 240048000404 244 Thurgood Marshall Elementary   Regular School No Elementary PK 05 2020   pk_12_total 200 114 190   * 91     *   24                             621 200 114 190     91         24                       621
1311238 1311238 MD     school 2400120 3   Baltimore County 240012090440 810 Padonia International Elementary   Regular School No Elementary PK 05 2021   pk_12_total 50 110 237   * 91         19                             508 50 110 237     91         19                       508
1313987 1313987 MD     school 2400420 13   Howard 240042000721 406 Bushy Park Elementary   Regular School No Elementary PK 05 2021   pk_12_total 412 31 29   * 91     *   37                             602 412 31 29     91         37                       602
1317136 1317136 MD     school 2400510 16   Prince George's 240051001049 2141 Greenbelt Middle   Regular School No Middle 06 08 2021   pk_12_total 102 671 562   * 91     *   35                             1471 102 671 562     91         35                       1471
1241432 1241432 MD     school 2400420 13   Howard 240042000721 406 Bushy Park Elementary   Regular School No Elementary PK 05 2020   pk_12_total 455 32 26   * 90     *   31                             638 455 32 26     90         31                       638
1242134 1242134 MD     school 2400480 15   Montgomery 240048090453 311 Francis Scott Key Middle   Regular School No Middle 06 08 2020   pk_12_total 27 437 420   * 90     *   26                             1004 27 437 420     90         26                       1004
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
1314931 1314931 MD     school 2400480 15   Montgomery 240048000889 502 Olney Elementary   Regular School No Elementary PK 05 2021   pk_12_total 312 92 98   * 90     *   40                             634 312 92 98     90         40                       634
1244549 1244549 MD     school 2400510 16   Prince George's 240051001049 2141 Greenbelt Middle   Regular School No Middle 06 08 2020   pk_12_total 96 709 540   * 89     *   27                             1468 96 709 540     89         27                       1468
1310449 1310449 MD     school 2400060 2   Anne Arundel 240006001658 3282 Nantucket Elementary   Regular School No Elementary KG 05 2021   pk_12_total 317 192 64   * 89     *   38                             705 317 192 64     89         38                       705
1314146 1314146 MD     school 2400420 13   Howard 240042000757 605 Thunder Hill Elementary   Regular School No Elementary KG 05 2021   pk_12_total 118 162 81   * 89         29                             481 118 162 81     89         29                       481
1314333 1314333 MD     school 2400480 15   Montgomery 240048000903 105 Ridgeview Middle   Regular School No Middle 06 08 2021   pk_12_total 288 116 261   * 89         34                             792 288 116 261     89         34                       792
1241782 1241782 MD     school 2400480 15   Montgomery 240048000834 106 Fox Chapel Elementary   Regular School No Elementary PK 05 2020   pk_12_total 61 155 278   * 88     *   25                             611 61 155 278     88         25                       611
1242171 1242171 MD     school 2400480 15   Montgomery 240048000783 333 Benjamin Banneker Middle   Regular School No Middle 06 08 2020   pk_12_total 26 583 177   * 88         24                             900 26 583 177     88         24                       900
1242361 1242361 MD     school 2400480 15   Montgomery 240048000889 502 Olney Elementary   Regular School No Elementary KG 05 2020   pk_12_total 345 105 94   * 88     *   49                             683 345 105 94     88         49                       683
1242381 1242381 MD     school 2400480 15   Montgomery 240048000868 505 Lucy V. Barnsley Elementary   Regular School No Elementary KG 05 2020   pk_12_total 243 93 254   * 88         57                             737 243 93 254     88         57                       737
1243045 1243045 MD     school 2400480 15   Montgomery 240048000409 823 Argyle Middle   Regular School No Middle 06 08 2020   pk_12_total 72 256 582   * 88         25                             1024 72 256 582     88         25                       1024
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
1314153 1314153 MD     school 2400420 13   Howard 240042000734 606 Hammond Elementary   Regular School No Elementary KG 05 2021   pk_12_total 265 144 63   * 88     *   57                             620 265 144 63     88         57                       620
1314952 1314952 MD     school 2400480 15   Montgomery 240048000868 505 Lucy V. Barnsley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 214 89 246   * 88     *   57                             701 214 89 246     88         57                       701
1310819 1310819 MD     school 2400120 3   Baltimore County 240012000495 103 Westowne Elementary   Regular School No Elementary PK 05 2021   pk_12_total 226 241 50   * 87     *   50                             659 226 241 50     87         50                       659
1313063 1313063 MD     school 2400330 10   Frederick 240033001429 715 Centerville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 177 58 67     87         50                             439 177 58 67     87         50                       439
1313797 1313797 MD     school 2400420 13   Howard 240042090448 103 Deep Run Elementary   Regular School No Elementary PK 05 2021   pk_12_total 137 100 320   * 87         31                             680 137 100 320     87         31                       680
1315601 1315601 MD     school 2400480 15   Montgomery 240048000845 817 Glenallan Elementary   Regular School No Elementary PK 05 2021   pk_12_total 72 219 305   * 87         21                             707 72 219 305     87         21                       707
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
1241626 1241626 MD     school 2400420 13   Howard 240042000745 611 Oakland Mills High   Regular School No High 09 12 2020   pk_12_total 253 545 263     86     *   97                             1246 253 545 263     86         97                       1246
1242283 1242283 MD     school 2400480 15   Montgomery 240048000787 410 Bradley Hills Elementary   Regular School No Elementary KG 05 2020   pk_12_total 372 13 37     86         58                             566 372 13 37     86         58                       566
1243021 1243021 MD     school 2400480 15   Montgomery 240048000845 817 Glenallan Elementary   Regular School No Elementary PK 05 2020   pk_12_total 71 228 336   * 86         22                             744 71 228 336     86         22                       744
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
1310895 1310895 MD     school 2400120 3   Baltimore County 240012000502 172 Woodlawn High   Regular School No High 09 12 2021   pk_12_total 48 1265 247   * 86     *   22                             1680 48 1265 247     86         22                       1680
1311270 1311270 MD     school 2400120 3   Baltimore County 240012000366 853 Cockeysville Middle   Regular School No Middle 06 08 2021   pk_12_total 373 217 159   * 86         42                             878 373 217 159     86         42                       878
1314610 1314610 MD     school 2400480 15   Montgomery 240048000404 244 Thurgood Marshall Elementary   Regular School No Elementary PK 05 2021   pk_12_total 163 118 166   * 86     *   20                             556 163 118 166     86         20                       556
1315524 1315524 MD     school 2400480 15   Montgomery 240048001366 796 Northwood High School   Regular School No High 09 12 2021   pk_12_total 227 438 899   * 86         57                             1708 227 438 899     86         57                       1708
1242944 1242944 MD     school 2400480 15   Montgomery 240048001366 796 Northwood High School   Regular School No High 09 12 2020   pk_12_total 248 449 965   * 85         55                             1805 248 449 965     85         55                       1805
1310886 1310886 MD     school 2400120 3   Baltimore County 240012000354 151 Catonsville Middle   Regular School No Middle 06 08 2021   pk_12_total 455 171 68   * 85     *   36                             821 455 171 68     85         36                       821
1313552 1313552 MD     school 2400390 12   Harford 240039000679 270 Aberdeen High   Regular School No High 09 12 2021   pk_12_total 498 576 140   10 85     *   125                             1441 498 576 140   10 85         125                       1441
1314402 1314402 MD     school 2400480 15   Montgomery 240048000181 155 Rosa M. Parks Middle   Regular School No Middle 06 08 2021   pk_12_total 465 135 121     85         58                             864 465 135 121     85         58                       864
1244011 1244011 MD     school 2400510 16   Prince George's 240051000990 1423 Bowie High   Regular School No High 09 12 2020   pk_12_total 240 1645 359   * 84     *   90                             2428 240 1645 359     84         90                       2428
1313101 1313101 MD     school 2400330 10   Frederick 240033000635 913 Green Valley Elementary   Regular School No Elementary KG 05 2021   pk_12_total 306 51 66     84         38                             545 306 51 66     84         38                       545
1240410 1240410 MD     school 2400330 10   Frederick 240033000634 213 Gov. Thomas Johnson High   Regular School No High 09 12 2020   pk_12_total 615 390 542   * 83     *   92                             1730 615 390 542     83         92                       1730
1313943 1313943 MD     school 2400420 13   Howard 240042000760 302 West Friendship Elementary   Regular School No Elementary KG 05 2021   pk_12_total 225 22 20     83     *   25                             376 225 22 20     83         25                       376
1314157 1314157 MD     school 2400420 13   Howard 240042000736 607 Hammond Middle School   Regular School No Middle 06 08 2021   pk_12_total 250 153 72   * 83     *   51                             612 250 153 72     83         51                       612
1315584 1315584 MD     school 2400480 15   Montgomery 240048000954 811 White Oak Middle   Regular School No Middle 06 08 2021   pk_12_total 40 255 462   * 83     *   18                             860 40 255 462     83         18                       860
1238341 1238341 MD     school 2400120 3   Baltimore County 240012000502 172 Woodlawn High Center for Pre-Eng. Res.   Regular School No High 09 12 2020   pk_12_total 41 1277 229   * 82     *   21                             1656 41 1277 229     82         21                       1656
1241113 1241113 MD     school 2400390 12   Harford 240039001380 385 C. Milton Wright High   Regular School No High 09 12 2020   pk_12_total 1059 97 68   * 82     *   51                             1363 1059 97 68     82         51                       1363
1312956 1312956 MD     school 2400330 10   Frederick 240033000634 213 Gov. Thomas Johnson High   Regular School No High 09 12 2021   pk_12_total 582 412 586   * 82     *   71                             1744 582 412 586     82         71                       1744
1314850 1314850 MD     school 2400480 15   Montgomery 240048000787 410 Bradley Hills Elementary   Regular School No Elementary PK 05 2021   pk_12_total 309 13 44     82         49                             497 309 13 44     82         49                       497
1315294 1315294 MD     school 2400480 15   Montgomery 240048001514 706 Clearspring Elementary   Regular School No Elementary PK 05 2021   pk_12_total 193 118 132   * 82     *   33                             562 193 118 132     82         33                       562
1237524 1237524 MD     school 2400060 2   Anne Arundel 240006000127 2013 Severna Park High   Regular School No High 09 12 2020   pk_12_total 1589 77 97   * 81     *   84                             1932 1589 77 97     81         84                       1932
1241822 1241822 MD     school 2400480 15   Montgomery 240048000759 115 Neelsville Middle   Regular School No Middle 06 08 2020   pk_12_total 48 287 499   * 81     *   24                             945 48 287 499     81         24                       945
1314693 1314693 MD     school 2400480 15   Montgomery 240048090453 311 Francis Scott Key Middle   Regular School No Middle 06 08 2021   pk_12_total 26 404 433   * 81     *   19                             966 26 404 433     81         19                       966
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
1317352 1317352 MD     school 2400600 18   Saint Mary's 240060001224 801 Great Mills High   Regular School No High 09 12 2021   pk_12_total 634 622 219   * 81     *   147                             1713 634 622 219     81         147                       1713
1241503 1241503 MD     school 2400420 13   Howard 240042001382 520 Clemens Crossing Elementary   Regular School No Elementary KG 05 2020   pk_12_total 248 85 49   * 80     *   44                             508 248 85 49     80         44                       508
1314731 1314731 MD     school 2400480 15   Montgomery 240048000783 333 Benjamin Banneker Middle   Regular School No Middle 06 08 2021   pk_12_total 22 565 175   * 80         21                             864 22 565 175     80         21                       864
1238597 1238597 MD     school 2400120 3   Baltimore County 240012000389 451 Franklin Middle   Regular School No Middle 06 08 2020   pk_12_total 279 600 205   * 79     *   77                             1242 279 600 205     79         77                       1242
1241388 1241388 MD     school 2400420 13   Howard 240042000760 302 West Friendship Elementary   Regular School No Elementary KG 05 2020   pk_12_total 251 21 16     79     *   25                             393 251 21 16     79         25                       393
1244774 1244774 MD     school 2400600 18   Saint Mary's 240060001224 801 Great Mills High   Regular School No High 09 12 2020   pk_12_total 653 592 225   * 79     *   122                             1678 653 592 225     79         122                       1678
1310736 1310736 MD     school 2400060 2   Anne Arundel 240006001401 6223 Chesapeake Science Point   Regular School Yes High 06 12 2021   pk_12_total 138 203 42   * 79     *   36                             500 138 203 42     79         36                       500
1315124 1315124 MD     school 2400480 15   Montgomery 240048000792 559 Brown Station Elementary   Regular School No Elementary PK 05 2021   pk_12_total 48 140 322   * 79         20                             612 48 140 322     79         20                       612
1242003 1242003 MD     school 2400480 15   Montgomery 240048000934 234 Thomas S. Wootton High   Regular School No High 09 12 2020   pk_12_total 881 176 169   * 787     *   101                             2116 881 176 169     787         101                       2116
1237765 1237765 MD     school 2400060 2   Anne Arundel 240006000078 3102 Hebron - Harman Elementary   Regular School No Elementary PK 05 2020   pk_12_total 117 323 161   * 78         76                             759 117 323 161     78         76                       759
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
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
1238281 1238281 MD     school 2400120 3   Baltimore County 240012000410 105 Johnnycake Elementary   Regular School No Elementary PK 05 2020   pk_12_total 52 368 163   * 77     *   23                             690 52 368 163     77         23                       690
1242114 1242114 MD     school 2400480 15   Montgomery 240048001524 308 Cloverly Elementary   Regular School No Elementary PK 05 2020   pk_12_total 128 134 134     77     *   37                             511 128 134 134     77         37                       511
1242549 1242549 MD     school 2400480 15   Montgomery 240048000792 559 Brown Station Elementary   Regular School No Elementary PK 05 2020   pk_12_total 53 172 310   * 77         19                             636 53 172 310     77         19                       636
1242833 1242833 MD     school 2400480 15   Montgomery 240048001457 775 Eastern Middle School   Regular School No Middle 06 08 2020   pk_12_total 195 189 509   * 77     *   37                             1010 195 189 509     77         37                       1010
1243620 1243620 MD     school 2400510 16   Prince George's 240051001092 1008 Laurel High   Regular School No High 09 12 2020   pk_12_total 71 1023 728   * 77     *   35                             1943 71 1023 728     77         35                       1943
1313833 1313833 MD     school 2400420 13   Howard 240042001717 109 Ducketts Lane   Regular School No Elementary PK 05 2021   pk_12_total 108 260 144   * 77     *   37                             630 108 260 144     77         37                       630
1314217 1314217 MD     school 2400420 13   Howard 240042000761 618 Laurel Woods Elementary   Regular School No Elementary PK 05 2021   pk_12_total 31 312 206   * 77     *   28                             656 31 312 206     77         28                       656
1317082 1317082 MD     school 2400510 16   Prince George's 240051001063 2107 Hollywood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 31 66 247     76         11                             431 31 66 247     76         11                       431
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

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