enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 9,398 ✖
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
1316905 1316905 MD     school 2400510 16   Prince George's 240051001477 1819 Walker Mill Middle   Regular School No Middle 06 08 2021   pk_12_total 13 608 118   * *     *   10                             760 13 608 118               10                       760
1312738 1312738 MD     school 2400270 8   Charles 240027001647 625 Theodore G. Davis Middle School   Regular School No Middle 06 08 2021   pk_12_total 70 601 98   * 30     *   79                             885 70 601 98     30         79                       885
1318054 1318054 MD     school 2400090 30   Baltimore City 240009000253 10 James McHenry Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 24 601 31     *         11                             670 24 601 31               11                       670
1311286 1311286 MD     school 2400120 3   Baltimore County 240012000479 905 Stoneleigh Elementary   Regular School No Elementary KG 05 2021   pk_12_total 451 60 59     41         40                             651 451 60 59     41         40                       651
1313421 1313421 MD     school 2400390 12   Harford 240039000715 113 William S. James Elementary   Regular School No Elementary KG 05 2021   pk_12_total 344 60 33     15         28                             480 344 60 33     15         28                       480
1314854 1314854 MD     school 2400480 15   Montgomery 240048000949 412 Westland Middle   Regular School No Middle 06 08 2021   pk_12_total 434 60 140   * 63         62                             764 434 60 140     63         62                       764
1314972 1314972 MD     school 2400480 15   Montgomery 240048000796 508 Candlewood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 165 60 69     72     *   30                             398 165 60 69     72         30                       398
1317663 1317663 MD     school 2400660 21   Washington 240066000752 902 Paramount Elementary   Regular School No Elementary PK 05 2021   pk_12_total 221 60 54     27         32                             394 221 60 54     27         32                       394
1317783 1317783 MD     school 2400660 21   Washington 240066001273 2601 Lincolnshire Elementary   Regular School No Elementary PK 05 2021   pk_12_total 293 60 57     *         51                             466 293 60 57               51                       466
1318043 1318043 MD     school 2400090 30   Baltimore City 240009000175 8 City Springs Elementary/Middle   Regular School Yes Elementary PK 08 2021   pk_12_total 10 594 24   *           *                             633 10 594 24                                       633
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
1318809 1318809 MD     school 2400090 30   Baltimore City 240009000222 235 Glenmount Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 13 592 35     *         *                             652 13 592 35                                       652
1312672 1312672 MD     school 2400270 8   Charles 240027000583 613 Benjamin Stoddert Middle School   Regular School No Middle 06 08 2021   pk_12_total 52 590 110   * 25     *   56                             838 52 590 110     25         56                       838
1311058 1311058 MD     school 2400120 3   Baltimore County 240012000387 308 Fort Garrison Elementary   Regular School No Elementary PK 05 2021   pk_12_total 203 59 *   * *         *                             283 203 59                                         283
1312033 1312033 MD     school 2400150 4   Calvert 240015000513 312 Mount Harmony Elementary   Regular School No Elementary KG 05 2021   pk_12_total 407 59 56   * 20         51                             595 407 59 56     20         51                       595
1312243 1312243 MD     school 2400210 6   Carroll 240021000550 701 Westminster East Middle   Regular School No Middle 06 08 2021   pk_12_total 538 59 83     16     *   33                             730 538 59 83     16         33                       730
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
1312482 1312482 MD     school 2400240 7   Cecil 240024000573 506 North East Elementary   Regular School No Elementary PK 05 2021   pk_12_total 374 59 35   * *     *   46                             522 374 59 35               46                       522
1317972 1317972 MD     school 2400720 23   Worcester 240072000880 308 Stephen Decatur Middle   Regular School No Middle 07 08 2021   pk_12_total 484 59 75   * 13         58                             691 484 59 75     13         58                       691
1317980 1317980 MD     school 2400720 23   Worcester 240072001323 311 Berlin Intermediate   Regular School No Middle 05 06 2021   pk_12_total 458 59 69     17         55                             658 458 59 69     17         55                       658
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
1310314 1310314 MD     school 2400060 2   Anne Arundel 240006000061 3082 Crofton Woods Elementary   Regular School No Elementary KG 05 2021   pk_12_total 458 58 65   * 60     *   65                             715 458 58 65     60         65                       715
1312009 1312009 MD     school 2400150 4   Calvert 240015090465 215 Plum Point Elementary   Regular School No Elementary PK 05 2021   pk_12_total 436 58 38     16         54                             602 436 58 38     16         54                       602
1312615 1312615 MD     school 2400270 8   Charles 240027000610 501 Dr. Thomas L. Higdon Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 257 58 13     *     *   27                             362 257 58 13               27                       362
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
1316779 1316779 MD     school 2400510 16   Prince George's 240051001093 1712 Lewisdale Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 58 547   * *         *                             614   58 547                                       614
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
1318899 1318899 MD     school 2400090 30   Baltimore City 240009000155 246 Beechfield Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 26 578 30   * *     *   *                             643 26 578 30                                       643
1311013 1311013 MD     school 2400120 3   Baltimore County 240012000501 253 Woodlawn Middle   Regular School No Middle 06 08 2021   pk_12_total 11 577 49   * *     *   13                             657 11 577 49               13                       657
1319261 1319261 MD     school 2400090 30   Baltimore City 240009000203 406 Forest Park High   Regular School No High 09 12 2021   pk_12_total 11 577 133     *     *   *                             726 11 577 133                                       726
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
1315853 1315853 MD     school 2400510 16   Prince George's 240051001038 511 Friendly High   Regular School No High 09 12 2021   pk_12_total 23 575 177     27         14                             816 23 575 177     27         14                       816
1311080 1311080 MD     school 2400120 3   Baltimore County 240012000441 353 Sudbrook Magnet Middle   Regular School No Middle 06 08 2021   pk_12_total 105 574 213   * 54     *   22                             972 105 574 213     54         22                       972
1319182 1319182 MD     school 2400090 30   Baltimore City 240009001670 368 Elmer A. Henderson: A Johns Hopkins Partnership   Regular School No Elementary PK 08 2021   pk_12_total * 573 11   * *         *                             592   573 11                                       592
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
1312904 1312904 MD     school 2400330 10   Frederick 240033000628 108 Carroll Manor Elementary   Regular School No Elementary PK 05 2021   pk_12_total 368 57 73   * 16         23                             538 368 57 73     16         23                       538
1313519 1313519 MD     school 2400390 12   Harford 240039001642 188 Patterson Mill Middle School   Regular School No Middle 06 08 2021   pk_12_total 500 57 67   * 58     *   52                             742 500 57 67     58         52                       742
1314817 1314817 MD     school 2400480 15   Montgomery 240048000785 401 Bethesda Elementary   Regular School No Elementary PK 05 2021   pk_12_total 296 57 105     108         53                             619 296 57 105     108         53                       619
1316188 1316188 MD     school 2400510 16   Prince George's 240051001763 918 James Ryder Randall Early Childhood Center   Special Education School No Prekindergarten PK PK 2021   pk_12_total * 57 17     *         *                             88   57 17                                       88
1317731 1317731 MD     school 2400660 21   Washington 240066001281 1805 Potomac Heights Elementary   Regular School No Elementary PK 05 2021   pk_12_total 159 57 52   * *         51                             323 159 57 52               51                       323
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
1318910 1318910 MD     school 2400090 30   Baltimore City 240009000182 247 Cross Country Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 24 563 103   * *     *   *                             700 24 563 103                                       700
1316503 1316503 MD     school 2400510 16   Prince George's 240051001222 1347 Cora L. Rice Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 560 32   * *     *   *                             606   560 32                                       606
1312438 1312438 MD     school 2400240 7   Cecil 240024000564 313 Cherry Hill Middle   Regular School No Middle 06 08 2021   pk_12_total 277 56 52               29                             414 277 56 52               29                       414
1312607 1312607 MD     school 2400270 8   Charles 240027001492 302 Mt Hope/Nanjemoy Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 145 56 *   *           22                             230 145 56                 22                       230
1314532 1314532 MD     school 2400480 15   Montgomery 240048000904 227 Ritchie Park Elementary   Regular School No Elementary KG 05 2021   pk_12_total 187 56 53   * 60     *   26                             384 187 56 53     60         26                       384
1316047 1316047 MD     school 2400510 16   Prince George's 240051001424 705 Tall Oaks High   Alternative School No High 11 12 2021   pk_12_total * 56 40               *                             101   56 40                                       101
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
1316168 1316168 MD     school 2400510 16   Prince George's 240051001469 915 Stephen Decatur Middle   Regular School No Middle 06 08 2021   pk_12_total 20 558 178   * 14     *   *                             782 20 558 178     14                                 782
1319317 1319317 MD     school 2400090 30   Baltimore City 240009001381 427 Academy for College and Career Exploration   Regular School No High 06 12 2021   pk_12_total 44 556 99   * *     *   *                             715 44 556 99                                       715
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
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
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
1310159 1310159 MD     school 2400060 2   Anne Arundel 240006000079 2132 High Point Elementary   Regular School No Elementary PK 05 2021   pk_12_total 443 55 103   * 13     *   51                             669 443 55 103     13         51                       669
1310232 1310232 MD     school 2400060 2   Anne Arundel 240006000899 2233 Anne Arundel Evening High   Alternative School No High 09 12 2021   pk_12_total 106 55 54     *         *                             227 106 55 54                                       227
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
1314430 1314430 MD     school 2400480 15   Montgomery 240048090454 159 Rachel Carson Elementary   Regular School No Elementary PK 05 2021   pk_12_total 363 55 168     149         57                             792 363 55 168     149         57                       792
1316834 1316834 MD     school 2400510 16   Prince George's 240051001573 1731 Rosa L. Parks Elementary   Regular School No Elementary PK 06 2021   pk_12_total 14 55 524   * *         *                             597 14 55 524                                       597
1310522 1310522 MD     school 2400060 2   Anne Arundel 240006000037 4013 Annapolis High   Regular School No High 09 12 2021   pk_12_total 638 547 835   * 51     *   60                             2134 638 547 835     51         60                       2134
1314247 1314247 MD     school 2400420 13   Howard 240042000822 623 Long Reach High   Regular School No High 09 12 2021   pk_12_total 372 547 380   * 205     *   87                             1595 372 547 380     205         87                       1595
1317066 1317066 MD     school 2400510 16   Prince George's 240051001764 2023 Legend Public Charter School   Regular School Yes Elementary KG 05 2021   pk_12_total * 547 21   * *         11                             592   547 21               11                       592
1311888 1311888 MD     school 2400120 3   Baltimore County 240012000370 1557 Deep Creek Middle   Regular School No Middle 06 08 2021   pk_12_total 182 546 106   * *     *   60                             907 182 546 106               60                       907
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
1318234 1318234 MD     school 2400090 30   Baltimore City 240009000329 51 Waverly Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 544 22   * *     *   *                             589   544 22                                       589
1311148 1311148 MD     school 2400120 3   Baltimore County 240012001730 410 Lyons Mill Elementary   Regular School No Elementary KG 05 2021   pk_12_total 22 543 18   * 69         27                             685 22 543 18     69         27                       685
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
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
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
1314993 1314993 MD     school 2400480 15   Montgomery 240048000846 512 Greenwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 301 54 70     37     *   38                             501 301 54 70     37         38                       501
1317491 1317491 MD     school 2400630 20   Talbot 240063001247 204 St. Michaels Elementary   Regular School No Elementary PK 05 2021   pk_12_total 217 54 32     *         20                             327 217 54 32               20                       327
1311395 1311395 MD     school 2400120 3   Baltimore County 240012000419 954 Loch Raven Technical Academy   Regular School No Middle 06 08 2021   pk_12_total 156 539 63   * 22     *   31                             817 156 539 63     22         31                       817
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
1316012 1316012 MD     school 2400510 16   Prince George's 240051001555 648 Samuel P. Massie Academy   Regular School No Elementary PK 08 2021   pk_12_total * 532 24     *         *                             564   532 24                                       564
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
1312619 1312619 MD     school 2400270 8   Charles 240027000604 503 Piccowaxen Middle School   Regular School No Middle 06 08 2021   pk_12_total 327 53 27   * *     *   27                             443 327 53 27               27                       443
1313609 1313609 MD     school 2400390 12   Harford 240039000712 329 Prospect Mill Elementary   Regular School No Elementary PK 05 2021   pk_12_total 381 53 48     39         45                             566 381 53 48     39         45                       566
1315353 1315353 MD     school 2400480 15   Montgomery 240048000887 766 Oak View Elementary   Regular School No Elementary 03 05 2021   pk_12_total 67 53 270     17         12                             419 67 53 270     17         12                       419
1316441 1316441 MD     school 2400510 16   Prince George's 240051001731 1313 Kenmoor Early Childhood Center   Special Education School No Prekindergarten PK PK 2021   pk_12_total * 53 60   * *         *                             122   53 60                                       122
1312758 1312758 MD     school 2400270 8   Charles 240027000599 701 Matthew Henson Middle School   Regular School No Middle 06 08 2021   pk_12_total 73 529 95   * 17     *   65                             784 73 529 95     17         65                       784
1316145 1316145 MD     school 2400510 16   Prince George's 240051001167 908 Surrattsville High   Regular School No High 09 12 2021   pk_12_total 11 528 114   * 10     *   *                             673 11 528 114     10                                 673
1316266 1316266 MD     school 2400510 16   Prince George's 240051001051 1104 Gwynn Park Middle   Regular School No Middle 06 08 2021   pk_12_total 27 526 82   * *     *   20                             662 27 526 82               20                       662
1312734 1312734 MD     school 2400270 8   Charles 240027001565 624 William A. Diggs Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 84 525 60     30     *   59                             762 84 525 60     30         59                       762
1311708 1311708 MD     school 2400120 3   Baltimore County 240012001439 1451 Golden Ring Middle   Regular School No Middle 06 08 2021   pk_12_total 136 523 112   * 42         33                             851 136 523 112     42         33                       851
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
1315929 1315929 MD     school 2400510 16   Prince George's 240051001465 622 Thurgood Marshall Middle School   Regular School No Middle 06 08 2021   pk_12_total * 522 212   * 12         *                             762   522 212     12                                 762
1314743 1314743 MD     school 2400480 15   Montgomery 240048090450 335 Briggs Chaney Middle   Regular School No Middle 06 08 2021   pk_12_total 64 521 247   * 102     *   41                             978 64 521 247     102         41                       978
1319296 1319296 MD     school 2400090 30   Baltimore City 240009001331 419 Reginald F. Lewis High   Regular School No High 09 12 2021   pk_12_total 14 520 74   * *     *   *                             615 14 520 74                                       615
1313047 1313047 MD     school 2400330 10   Frederick 240033000652 702 Urbana Elementary   Regular School No Elementary PK 05 2021   pk_12_total 322 52 78   * 144         51                             651 322 52 78     144         51                       651
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
1314486 1314486 MD     school 2400480 15   Montgomery 240048000874 212 Meadow Hall Elementary   Regular School No Elementary PK 05 2021   pk_12_total 75 52 230   * 28         20                             406 75 52 230     28         20                       406
1315456 1315456 MD     school 2400480 15   Montgomery 240048000892 783 Kensington Parkwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 346 52 83     56         59                             596 346 52 83     56         59                       596
1310905 1310905 MD     school 2400120 3   Baltimore County 240012000248 175 Western School of Technology   Career and Technical School No High 09 12 2021   pk_12_total 136 514 48   * 190     *   28                             920 136 514 48     190         28                       920
1318866 1318866 MD     school 2400090 30   Baltimore City 240009000293 242 Northwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 514 10   *       *   *                             537   514 10                                       537
1319158 1319158 MD     school 2400090 30   Baltimore City 240009001682 348 Baltimore Leadership School for Young Women   Regular School Yes High 06 12 2021   pk_12_total * 514 *   *           *                             531   514                                         531
1310890 1310890 MD     school 2400120 3   Baltimore County 240012000411 155 Southwest Academy   Regular School No Middle 06 08 2021   pk_12_total 31 513 109   * 111     *   28                             794 31 513 109     111         28                       794
1312746 1312746 MD     school 2400270 8   Charles 240027001656 626 Mary B. Neal Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 26 512 57   * 35         47                             678 26 512 57     35         47                       678
1310248 1310248 MD     school 2400060 2   Anne Arundel 240006000047 2322 Broadneck Elementary   Regular School No Elementary KG 05 2021   pk_12_total 546 51 66   * 30         55                             749 546 51 66     30         55                       749
1312026 1312026 MD     school 2400150 4   Calvert 240015000505 302 Beach Elementary   Regular School No Elementary PK 05 2021   pk_12_total 313 51 42   * *     *   73                             483 313 51 42               73                       483
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
1313241 1313241 MD     school 2400330 10   Frederick 240033090473 2302 Hillcrest Elementary   Regular School No Elementary PK 05 2021   pk_12_total 40 51 550     43         30                             714 40 51 550     43         30                       714

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