enrollments

Data source: Big Local News · About: Big Local

2,791 rows where grade = "pk_12_total" and state = "MD" sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pk_12_total · 2,591 ✖
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
1241333 1241333 MD     school 2400420 13   Howard 240042000727 211 Dunloggin Middle   Regular School No Middle 06 08 2020   pk_12_total 237 105 40     217     *   27                             628 237 105 40     217         27                       628
1241358 1241358 MD     school 2400420 13   Howard 240042000173 216 Burleigh Manor Middle School   Regular School No Middle 06 08 2020   pk_12_total 242 85 34   * 404         41                             811 242 85 34     404         41                       811
1241392 1241392 MD     school 2400420 13   Howard 240042000403 304 Mount View Middle   Regular School No Middle 06 08 2020   pk_12_total 390 44 35   * 331         51                             853 390 44 35     331         51                       853
1241410 1241410 MD     school 2400420 13   Howard 240042001552 307 Folly Quarter Middle   Regular School No Middle 06 08 2020   pk_12_total 388 45 27   * 189     *   49                             700 388 45 27     189         49                       700
1241424 1241424 MD     school 2400420 13   Howard 240042000732 405 Glenwood Middle   Regular School No Middle 06 08 2020   pk_12_total 372 27 47   * 41         27                             515 372 27 47     41         27                       515
1241463 1241463 MD     school 2400420 13   Howard 240042000763 512 Wilde Lake Middle   Regular School No Middle 06 08 2020   pk_12_total 164 317 91   * 51         62                             687 164 317 91     51         62                       687
1241496 1241496 MD     school 2400420 13   Howard 240042000737 518 Harpers Choice Middle   Regular School No Middle 06 08 2020   pk_12_total 91 236 80   * 36         47                             493 91 236 80     36         47                       493
1241507 1241507 MD     school 2400420 13   Howard 240042000725 521 Clarksville Middle   Regular School No Middle 06 08 2020   pk_12_total 294 54 22   * 306     *   31                             710 294 54 22     306         31                       710
1241546 1241546 MD     school 2400420 13   Howard 240042001115 526 Lime Kiln Middle   Regular School No Middle 06 08 2020   pk_12_total 313 93 26   * 176         50                             660 313 93 26     176         50                       660
1241601 1241601 MD     school 2400420 13   Howard 240042000736 607 Hammond Middle School   Regular School No Middle 06 08 2020   pk_12_total 252 161 64   * 69         55                             602 252 161 64     69         55                       602
1241621 1241621 MD     school 2400420 13   Howard 240042000746 610 Oakland Mills Middle   Regular School No Middle 06 08 2020   pk_12_total 134 183 121     19         41                             498 134 183 121     19         41                       498
1241653 1241653 MD     school 2400420 13   Howard 240042001700 617 Lake Elkhorn Middle   Regular School No Middle 06 08 2020   pk_12_total 71 293 106     49         45                             564 71 293 106     49         45                       564
1241678 1241678 MD     school 2400420 13   Howard 240042001522 621 Patuxent Valley Middle   Regular School No Middle 06 08 2020   pk_12_total 124 295 127   * 109     *   40                             698 124 295 127     109         40                       698
1241694 1241694 MD     school 2400420 13   Howard 240042000860 624 Murray Hill Middle   Regular School No Middle 06 08 2020   pk_12_total 88 320 155   * 118     *   50                             733 88 320 155     118         50                       733
1241719 1241719 MD     school 2400450 14   Kent 240045000766 402 Kent County Middle School   Regular School No Middle 06 08 2020   pk_12_total 251 98 41   * *         27                             421 251 98 41               27                       421
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
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
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
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
1241856 1241856 MD     school 2400480 15   Montgomery 240048000493 157 Roberto W. Clemente Middle   Regular School No Middle 06 08 2020   pk_12_total 156 383 397   * 270         79                             1287 156 383 397     270         79                       1287
1241920 1241920 MD     school 2400480 15   Montgomery 240048000857 211 Julius West Middle   Regular School No Middle 06 08 2020   pk_12_total 443 228 377   * 250     *   76                             1382 443 228 377     250         76                       1382
1241974 1241974 MD     school 2400480 15   Montgomery 240048000849 228 Herbert Hoover Middle   Regular School No Middle 06 08 2020   pk_12_total 430 74 89     392     *   59                             1045 430 74 89     392         59                       1045
1241991 1241991 MD     school 2400480 15   Montgomery 240048001450 232 Tilden Middle School   Regular School No Middle 06 08 2020   pk_12_total 434 125 213   * 166     *   48                             989 434 125 213     166         48                       989
1242015 1242015 MD     school 2400480 15   Montgomery 240048001447 237 Robert Frost Middle School   Regular School No Middle 06 08 2020   pk_12_total 387 116 77   * 399         45                             1028 387 116 77     399         45                       1028
1242061 1242061 MD     school 2400480 15   Montgomery 240048000861 247 John H. Poole Middle   Regular School No Middle 06 08 2020   pk_12_total 268 24 51   * 26         20                             390 268 24 51     26         20                       390
1242065 1242065 MD     school 2400480 15   Montgomery 240048000644 248 Forest Oak Middle   Regular School No Middle 06 08 2020   pk_12_total 95 228 547   * 52     *   26                             950 95 228 547     52         26                       950
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
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
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
1242217 1242217 MD     school 2400480 15   Montgomery 240048001739 345 Hallie Wells Middle School   Regular School No Middle 06 08 2020   pk_12_total 212 178 116   * 307         59                             873 212 178 116     307         59                       873
1242287 1242287 MD     school 2400480 15   Montgomery 240048000949 412 Westland Middle   Regular School No Middle 06 08 2020   pk_12_total 477 66 147   * 60     *   56                             808 477 66 147     60         56                       808
1242291 1242291 MD     school 2400480 15   Montgomery 240048001118 413 North Bethesda Middle   Regular School No Middle 06 08 2020   pk_12_total 695 120 161   * 151     *   99                             1233 695 120 161     151         99                       1233
1242346 1242346 MD     school 2400480 15   Montgomery 240048009000 428 Thomas W. Pyle Middle School   Regular School No Middle 06 08 2020   pk_12_total 987 49 163   * 214     *   118                             1534 987 49 163     214         118                       1534
1242392 1242392 MD     school 2400480 15   Montgomery 240048000957 507 William H. Farquhar Middle   Regular School No Middle 06 08 2020   pk_12_total 254 177 121   * 110         31                             694 254 177 121     110         31                       694
1242453 1242453 MD     school 2400480 15   Montgomery 240048001127 521 Shady Grove Middle   Regular School No Middle 06 08 2020   pk_12_total 124 119 238     70     *   23                             575 124 119 238     70         23                       575
1242457 1242457 MD     school 2400480 15   Montgomery 240048001441 522 Lakelands Park Middle   Regular School No Middle 06 08 2020   pk_12_total 443 199 298   * 181         78                             1200 443 199 298     181         78                       1200
1242513 1242513 MD     school 2400480 15   Montgomery 240048000837 554 Gaithersburg Middle   Regular School No Middle 06 08 2020   pk_12_total 131 180 453   * 62         50                             877 131 180 453     62         50                       877
1242533 1242533 MD     school 2400480 15   Montgomery 240048000879 557 Montgomery Village Middle School   Regular School No Middle 06 08 2020   pk_12_total 46 210 449   * 58         25                             790 46 210 449     58         25                       790
1242561 1242561 MD     school 2400480 15   Montgomery 240048000901 562 Redland Middle   Regular School No Middle 06 08 2020   pk_12_total 127 143 252   * 71         38                             635 127 143 252     71         38                       635
1242647 1242647 MD     school 2400480 15   Montgomery 240048001526 606 Cabin John Middle School   Regular School No Middle 06 08 2020   pk_12_total 408 120 84   * 365         62                             1040 408 120 84     365         62                       1040
1242659 1242659 MD     school 2400480 15   Montgomery 240048001128 647 Silver Spring International Middle   Regular School No Middle 06 08 2020   pk_12_total 294 250 492   * 62         52                             1153 294 250 492     62         52                       1153
1242707 1242707 MD     school 2400480 15   Montgomery 240048001456 705 John T. Baker Middle School   Regular School No Middle 06 08 2020   pk_12_total 397 99 239     50     *   43                             830 397 99 239     50         43                       830
1242719 1242719 MD     school 2400480 15   Montgomery 240048000660 707 Rocky Hill Middle   Regular School No Middle 06 08 2020   pk_12_total 186 220 154   * 261     *   57                             883 186 220 154     261         57                       883
1242723 1242723 MD     school 2400480 15   Montgomery 240048000863 708 Kingsview Middle   Regular School No Middle 06 08 2020   pk_12_total 232 265 149     277     *   57                             983 232 265 149     277         57                       983
1242744 1242744 MD     school 2400480 15   Montgomery 240048000933 755 Takoma Park Middle School   Regular School No Middle 06 08 2020   pk_12_total 341 395 197   * 169         58                             1162 341 395 197     169         58                       1162
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
1242850 1242850 MD     school 2400480 15   Montgomery 240048001458 778 Sligo Middle   Regular School No Middle 06 08 2020   pk_12_total 198 134 308   * 54         27                             722 198 134 308     54         27                       722
1242896 1242896 MD     school 2400480 15   Montgomery 240048001446 787 A. Mario Loiederman Middle   Regular School No Middle 06 08 2020   pk_12_total 142 154 626   * 43         30                             999 142 154 626     43         30                       999
1242926 1242926 MD     school 2400480 15   Montgomery 240048001207 792 Newport Mill Middle   Regular School No Middle 06 08 2020   pk_12_total 108 106 388   * 51         42                             702 108 106 388     51         42                       702
1243004 1243004 MD     school 2400480 15   Montgomery 240048000954 811 White Oak Middle   Regular School No Middle 06 08 2020   pk_12_total 38 264 455     68     *   18                             845 38 264 455     68         18                       845
1243008 1243008 MD     school 2400480 15   Montgomery 240048000891 812 Parkland Middle   Regular School No Middle 06 08 2020   pk_12_total 97 247 599   * 164         30                             1141 97 247 599     164         30                       1141
1243025 1243025 MD     school 2400480 15   Montgomery 240048000806 818 Col. E. Brooke Lee Middle   Regular School No Middle 06 08 2020   pk_12_total 35 178 483   * 58     *   14                             771 35 178 483     58         14                       771
1243037 1243037 MD     school 2400480 15   Montgomery 240048000820 820 Earle B. Wood Middle   Regular School No Middle 06 08 2020   pk_12_total 249 126 456     111     *   51                             994 249 126 456     111         51                       994
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
1243049 1243049 MD     school 2400480 15   Montgomery 240048001741 835 Silver Creek Middle   Regular School No Middle 06 08 2020   pk_12_total 423 190 173     56         45                             887 423 190 173     56         45                       887
1243057 1243057 MD     school 2400480 15   Montgomery 240048001460 916 Rock Terrace School   Special Education School No High 06 12 2020   pk_12_total 27 26 24     11         *                             92 27 26 24     11                                 92
1243134 1243134 MD     school 2400510 16   Prince George's 240051001101 110 Martin Luther King Jr. Middle   Regular School No Middle 06 08 2020   pk_12_total 44 490 367   * 70     *   26                             1003 44 490 367     70         26                       1003
1243319 1243319 MD     school 2400510 16   Prince George's 240051001464 615 Benjamin Stoddert Middle   Regular School No Middle 06 08 2020   pk_12_total * 565 121     *     *                                 696   565 121                                       696
1243349 1243349 MD     school 2400510 16   Prince George's 240051001465 622 Thurgood Marshall Middle School   Regular School No Middle 06 08 2020   pk_12_total * 448 150   * *     *   *                             625   448 150                                       625
1243445 1243445 MD     school 2400510 16   Prince George's 240051001034 660 Drew Freeman Middle   Regular School No Middle 06 08 2020   pk_12_total 11 693 150   * *     *   *                             868 11 693 150                                       868
1243498 1243498 MD     school 2400510 16   Prince George's 240051000982 714 Benjamin Tasker Middle School   Regular School No Middle 06 08 2020   pk_12_total 124 708 118   * 48     *   21                             1031 124 708 118     48         21                       1031
1243577 1243577 MD     school 2400510 16   Prince George's 240051001095 912 Isaac J. Gourdine Middle   Regular School No Middle 06 08 2020   pk_12_total 17 388 183   * 16     *   *                             611 17 388 183     16                                 611
1243589 1243589 MD     school 2400510 16   Prince George's 240051001469 915 Stephen Decatur Middle   Regular School No Middle 06 08 2020   pk_12_total 25 561 162   * 12     *   *                             769 25 561 162     12                                 769
1243632 1243632 MD     school 2400510 16   Prince George's 240051001024 1010 Dwight D. Eisenhower Middle   Regular School No Middle 06 08 2020   pk_12_total 46 524 437   * 17     *   21                             1052 46 524 437     17         21                       1052
1243685 1243685 MD     school 2400510 16   Prince George's 240051001051 1104 Gwynn Park Middle   Regular School No Middle 06 08 2020   pk_12_total 21 543 72     *     *   22                             662 21 543 72               22                       662
1243823 1243823 MD     school 2400510 16   Prince George's 240051001471 1234 Oxon Hill Middle   Regular School No Middle 06 08 2020   pk_12_total 24 355 434   * 39     *   *                             865 24 355 434     39                                 865
1243869 1243869 MD     school 2400510 16   Prince George's 240051001211 1320 G. James Gholson Middle   Regular School No Middle 06 08 2020   pk_12_total 12 625 252   * *     *                                 898 12 625 252                                       898
1243889 1243889 MD     school 2400510 16   Prince George's 240051001472 1326 Kettering Middle   Regular School No Middle 06 08 2020   pk_12_total 11 697 97     *     *   *                             825 11 697 97                                       825
1243898 1243898 MD     school 2400510 16   Prince George's 240051001473 1330 Kenmoor Middle   Regular School No Middle 06 08 2020   pk_12_total 41 620 245   * 48     *   *                             964 41 620 245     48                                 964
1243927 1243927 MD     school 2400510 16   Prince George's 240051001223 1348 Ernest Everett Just Middle   Regular School No Middle 06 08 2020   pk_12_total * 693 60   * *         10                             780   693 60               10                       780
1244030 1244030 MD     school 2400510 16   Prince George's 240051001152 1428 Samuel Ogle Middle   Regular School No Middle 06 08 2020   pk_12_total 91 554 172   * 41     *   22                             885 91 554 172     41         22                       885
1244081 1244081 MD     school 2400510 16   Prince George's 240051001475 1510 James Madison Middle   Regular School No Middle 06 08 2020   pk_12_total 17 721 106   * *     *   13                             870 17 721 106               13                       870
1244134 1244134 MD     school 2400510 16   Prince George's 240051001065 1602 Hyattsville Middle   Regular School No Middle 06 08 2020   pk_12_total 82 237 567   * 11     *   *                             909 82 237 567     11                                 909
1244218 1244218 MD     school 2400510 16   Prince George's 240051001112 1718 Nicholas Orem Middle   Regular School No Middle 06 08 2020   pk_12_total 12 193 912   * *     *   *                             1129 12 193 912                                       1129
1244324 1244324 MD     school 2400510 16   Prince George's 240051001477 1819 Walker Mill Middle   Regular School No Middle 06 08 2020   pk_12_total 12 601 73   * *     *   *                             705 12 601 73                                       705
1244376 1244376 MD     school 2400510 16   Prince George's 240051001186 1908 William Wirt Middle   Regular School No Middle 06 08 2020   pk_12_total 23 215 940   * 40     *   *                             1224 23 215 940     40                                 1224
1244427 1244427 MD     school 2400510 16   Prince George's 240051001175 2009 Thomas Johnson Middle   Regular School No Middle 06 08 2020   pk_12_total 32 639 553   * 35     *   *                             1269 32 639 553     35                                 1269
1244436 1244436 MD     school 2400510 16   Prince George's 240051001004 2011 Charles Carroll Middle   Regular School No Middle 06 08 2020   pk_12_total 23 378 903   * 19     *   *                             1329 23 378 903     19                                 1329
1244499 1244499 MD     school 2400510 16   Prince George's 240051000993 2108 Buck Lodge Middle   Regular School No Middle 06 08 2020   pk_12_total 14 106 1159   * 13     *   *                             1302 14 106 1159     13                                 1302
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
1244557 1244557 MD     school 2400510 16   Prince George's 240051001718 2142 College Park Academy   Regular School Yes High 06 12 2020   pk_12_total 53 390 174     17         27                             661 53 390 174     17         27                       661
1244610 1244610 MD     school 2400540 17   Queen Anne's 240054001190 303 Centreville Middle School   Regular School No Middle 06 08 2020   pk_12_total 454 35 39   * *         28                             562 454 35 39               28                       562
1244628 1244628 MD     school 2400540 17   Queen Anne's 240054001196 404 Stevensville Middle School   Regular School No Middle 06 08 2020   pk_12_total 434 38 39   * *         27                             546 434 38 39               27                       546
1244645 1244645 MD     school 2400540 17   Queen Anne's 240054001644 407 Matapeake Middle School   Regular School No Middle 06 08 2020   pk_12_total 296 * 25     *         19                             352 296   25               19                       352
1244657 1244657 MD     school 2400600 18   Saint Mary's 240060001237 101 Spring Ridge Middle   Regular School No Middle 06 08 2020   pk_12_total 402 377 125   * 32     *   122                             1067 402 377 125     32         122                       1067
1244698 1244698 MD     school 2400600 18   Saint Mary's 240060001229 305 Leonardtown Middle   Regular School No Middle 06 08 2020   pk_12_total 782 89 52   * 25     *   72                             1024 782 89 52     25         72                       1024
1244715 1244715 MD     school 2400600 18   Saint Mary's 240060001231 404 Margaret Brent Middle   Regular School No Middle 06 08 2020   pk_12_total 848 81 42   * *     *   60                             1043 848 81 42               60                       1043
1244809 1244809 MD     school 2400600 18   Saint Mary's 240060001220 807 Esperanza Middle   Regular School No Middle 06 08 2020   pk_12_total 461 200 81     31     *   92                             867 461 200 81     31         92                       867
1244875 1244875 MD     school 2400570 19   Somerset 240057001377 1303 Somerset 6/7 Intermediate School   Regular School No Middle 06 07 2020   pk_12_total 129 205 40     *         23                             402 129 205 40               23                       402
1244900 1244900 MD     school 2400630 20   Talbot 240063001243 106 Easton Middle   Regular School No Middle 06 08 2020   pk_12_total 444 149 209     24     *   42                             869 444 149 209     24         42                       869
1244908 1244908 MD     school 2400630 20   Talbot 240063001248 202 St. Michaels Middle/High School   Regular School No High 06 12 2020   pk_12_total 333 41 31     *         22                             430 333 41 31               22                       430
1244965 1244965 MD     school 2400660 21   Washington 240066001290 201 Springfield Middle   Regular School No Middle 06 08 2020   pk_12_total 623 77 104   * 13         48                             866 623 77 104     13         48                       866
1244995 1244995 MD     school 2400660 21   Washington 240066001263 304 E. Russell Hicks Middle   Regular School No Middle 06 08 2020   pk_12_total 392 206 137     24         102                             861 392 206 137     24         102                       861
1245015 1245015 MD     school 2400660 21   Washington 240066001261 401 Clear Spring Middle   Regular School No Middle 06 08 2020   pk_12_total 312 * 23     *         15                             356 312   23               15                       356
1245036 1245036 MD     school 2400660 21   Washington 240066001270 501 Hancock Middle Senior High   Regular School No High 06 12 2020   pk_12_total 236   *     *         *                             248 236                                           248
1245053 1245053 MD     school 2400660 21   Washington 240066001255 602 Boonsboro Middle   Regular School No Middle 06 08 2020   pk_12_total 602 29 26   * 18         26                             702 602 29 26     18         26                       702
1245078 1245078 MD     school 2400660 21   Washington 240066001287 704 Smithsburg Middle   Regular School No Middle 06 08 2020   pk_12_total 452 41 42   * 10         35                             582 452 41 42     10         35                       582
1245173 1245173 MD     school 2400660 21   Washington 240066001276 2102 Northern Middle   Regular School No Middle 06 08 2020   pk_12_total 383 184 109     23     *   97                             799 383 184 109     23         97                       799
1245177 1245177 MD     school 2400660 21   Washington 240066001293 2501 Western Heights Middle   Regular School No Middle 06 08 2020   pk_12_total 481 235 160     19         106                             1001 481 235 160     19         106                       1001
1245231 1245231 MD     school 2400690 22   Wicomico 240069001306 102 Mardela Middle & High   Regular School No High 06 12 2020   pk_12_total 519 84 20   * *         47                             675 519 84 20               47                       675

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