enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1317590 1317590 MD     school 2400660 21   Washington 240066001261 401 Clear Spring Middle   Regular School No Middle 06 08 2021   pk_12_total 307 * 12     *         13                             340 307   12               13                       340
1317598 1317598 MD     school 2400660 21   Washington 240066001259 402 Clear Spring Elementary   Regular School No Elementary PK 05 2021   pk_12_total 335 * *               *                             348 335                                           348
1317603 1317603 MD     school 2400660 21   Washington 240066001260 403 Clear Spring High   Regular School No High 09 12 2021   pk_12_total 424 * 22     *         14                             470 424   22               14                       470
1317619 1317619 MD     school 2400660 21   Washington 240066001269 502 Hancock Elementary   Regular School No Elementary PK 05 2021   pk_12_total 205 * *     *         *                             213 205                                           213
1317671 1317671 MD     school 2400660 21   Washington 240066001277 903 Old Forge Elementary   Regular School No Elementary PK 05 2021   pk_12_total 265 * 17               11                             298 265   17               11                       298
1317683 1317683 MD     school 2400660 21   Washington 240066001280 1101 Pleasant Valley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 183 * *   * *         *                             204 183                                           204
1317699 1317699 MD     school 2400660 21   Washington 240066001258 1401 Cascade Elementary   Regular School No Elementary PK 05 2021   pk_12_total 121 * *   * *         *                             130 121                                           130
1317739 1317739 MD     school 2400660 21   Washington 240066001265 2002 Fountain Rock Elementary   Regular School No Elementary PK 05 2021   pk_12_total 219 * 21     *         *                             258 219   21                                       258
1317775 1317775 MD     school 2400660 21   Washington 240066001289 2505 Marshall Street School   Special Education School No Other PK 12 2021   pk_12_total 24 * *     *         *                             41 24                                           41
1317821 1317821 MD     school 2400690 22   Wicomico 240069001312 406 Pittsville Elementary & Middle   Regular School No Middle 04 08 2021   pk_12_total 322 * 23   * *         29                             387 322   23               29                       387
1317917 1317917 MD     school 2400690 22   Wicomico 240069001322 1404 Willards Elementary   Regular School No Elementary PK 03 2021   pk_12_total 209 * 23   * *     *   22                             260 209   23               22                       260
1237567 1237567 MD     school 2400060 2   Anne Arundel 240006000046 2082 Bodkin Elementary   Regular School No Elementary KG 05 2020   pk_12_total 485 10 35     *         25                             557 485 10 35               25                       557
1238197 1238197 MD     school 2400120 3   Baltimore County 240012001759 55 Southeast EDLP at Dundalk High School   Alternative School No High 10 12 2020   pk_12_total * 10 *               *                             18   10                                         18
1238878 1238878 MD     school 2400120 3   Baltimore County 240012000467 1002 Jacksonville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 469 10 24     25     *   21                             550 469 10 24     25         21                       550
1240008 1240008 MD     school 2400240 7   Cecil 240024000566 801 Conowingo Elementary   Regular School No Elementary PK 05 2020   pk_12_total 427 10 14   *           11                             464 427 10 14               11                       464
1244737 1244737 MD     school 2400600 18   Saint Mary's 240060001232 504 Mechanicsville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 238 10 16   * *         19                             287 238 10 16               19                       287
1245096 1245096 MD     school 2400660 21   Washington 240066001277 903 Old Forge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 299 10 13     *         12                             335 299 10 13               12                       335
1312226 1312226 MD     school 2400210 6   Carroll 240021000536 601 Manchester Elementary   Regular School No Elementary PK 05 2021   pk_12_total 525 10 37     *     *   17                             599 525 10 37               17                       599
1313580 1313580 MD     school 2400390 12   Harford 240039000684 316 Churchville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 284 10 15   * *         25                             338 284 10 15               25                       338
1317315 1317315 MD     school 2400600 18   Saint Mary's 240060001232 504 Mechanicsville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 232 10 13   * *     *   20                             280 232 10 13               20                       280
1317649 1317649 MD     school 2400660 21   Washington 240066001286 702 Smithsburg Elementary   Regular School No Elementary PK 05 2021   pk_12_total 270 10 17   *           22                             320 270 10 17               22                       320
1237657 1237657 MD     school 2400060 2   Anne Arundel 240006000129 2212 Solley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 498 100 94   * 32     *   70                             798 498 100 94     32         70                       798
1242529 1242529 MD     school 2400480 15   Montgomery 240048000875 556 Mill Creek Towne Elementary   Regular School No Elementary PK 05 2020   pk_12_total 92 100 206   * 66     *   39                             506 92 100 206     66         39                       506
1245359 1245359 MD     school 2400690 22   Wicomico 240069001303 1602 Fruitland Intermediate   Regular School No Elementary 03 05 2020   pk_12_total 210 100 52   * 17         35                             416 210 100 52     17         35                       416
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
1311980 1311980 MD     school 2400150 4   Calvert 240015000517 207 Calvert Elementary   Regular School No Elementary PK 05 2021   pk_12_total 307 100 25   *           61                             496 307 100 25               61                       496
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
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
1314276 1314276 MD     school 2400450 14   Kent 240045000766 402 Kent County Middle School   Regular School No Middle 06 08 2021   pk_12_total 219 100 37     *         22                             380 219 100 37               22                       380
1315687 1315687 MD     school 2400510 16   Prince George's 240051001134 107 Frances Fuchs Early Childhood Center   Special Education School No Prekindergarten PK PK 2021   pk_12_total 11 100 117   * 14     *   *                             249 11 100 117     14                                 249
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
1240251 1240251 MD     school 2400270 8   Charles 240027001727 802 St. Charles High School   Regular School No High 09 12 2020   pk_12_total 175 1005 90   11 29     *   97                             1410 175 1005 90   11 29         97                       1410
1242093 1242093 MD     school 2400480 15   Montgomery 240048000788 304 JoAnn Leleck at Broad Acres Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 101 739   * 21         *                             874   101 739     21                                 874
1310474 1310474 MD     school 2400060 2   Anne Arundel 240006001517 3362 Crofton Meadows Elementary   Regular School No Elementary KG 05 2021   pk_12_total 284 101 49     32         61                             527 284 101 49     32         61                       527
1312120 1312120 MD     school 2400180 5   Caroline 240018000519 802 Colonel Richardson Middle School   Regular School No Middle 06 08 2021   pk_12_total 226 101 28   * *     *   38                             404 226 101 28               38                       404
1246721 1246721 MD     school 2400090 30   Baltimore City 240009000330 407 Western High   Regular School No High 09 12 2020   pk_12_total 57 1016 48   * 10     *   *                             1142 57 1016 48     10                                 1142
1241956 1241956 MD     school 2400480 15   Montgomery 240048000869 220 Luxmanor Elementary   Regular School No Elementary PK 05 2020   pk_12_total 220 102 160     157         39                             678 220 102 160     157         39                       678
1311463 1311463 MD     school 2400120 3   Baltimore County 240012000358 1107 Chapel Hill Elementary   Regular School No Elementary KG 05 2021   pk_12_total 327 102 17     116     *   30                             593 327 102 17     116         30                       593
1312454 1312454 MD     school 2400240 7   Cecil 240024000581 316 Thomson Estates Elementary   Regular School No Elementary PK 05 2021   pk_12_total 209 102 69   * 11     *   60                             453 209 102 69     11         60                       453
1315286 1315286 MD     school 2400480 15   Montgomery 240048001456 705 John T. Baker Middle School   Regular School No Middle 06 08 2021   pk_12_total 369 102 227     49         50                             797 369 102 227     49         50                       797
1317931 1317931 MD     school 2400690 22   Wicomico 240069001151 1601 Fruitland Primary   Regular School No Elementary PK 02 2021   pk_12_total 181 102 31   * 13     *   48                             378 181 102 31     13         48                       378
1237889 1237889 MD     school 2400060 2   Anne Arundel 240006000099 3323 Meade High   Regular School No High 09 12 2020   pk_12_total 259 1021 508   * 103     *   129                             2029 259 1021 508     103         129                       2029
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
1238908 1238908 MD     school 2400120 3   Baltimore County 240012000358 1107 Chapel Hill Elementary   Regular School No Elementary KG 05 2020   pk_12_total 355 103 25     132         31                             646 355 103 25     132         31                       646
1239433 1239433 MD     school 2400150 4   Calvert 240015001655 208 Barstow Elementary   Regular School No Elementary PK 05 2020   pk_12_total 432 103 39   * *     *   73                             658 432 103 39               73                       658
1240033 1240033 MD     school 2400270 8   Charles 240027000609 105 Walter J. Mitchell Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 387 103 63   * 14     *   55                             626 387 103 63     14         55                       626
1242761 1242761 MD     school 2400480 15   Montgomery 240048000893 761 Pine Crest Elementary   Regular School No Elementary 03 05 2020   pk_12_total 97 103 171     18         24                             413 97 103 171     18         24                       413
1310307 1310307 MD     school 2400060 2   Anne Arundel 240006000060 3072 Crofton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 413 103 55   * 36     *   41                             653 413 103 55     36         41                       653
1246706 1246706 MD     school 2400090 30   Baltimore City 240009000151 403 Baltimore Polytechnic Institute   Regular School No High 09 12 2020   pk_12_total 258 1030 162   * 104     *   21                             1584 258 1030 162     104         21                       1584
1310454 1310454 MD     school 2400060 2   Anne Arundel 240006000099 3323 Meade High   Regular School No High 09 12 2021   pk_12_total 245 1030 549   * 113     10   136                             2087 245 1030 549     113     10   136                       2087
1237492 1237492 MD     school 2400060 2   Anne Arundel 240006000118 1242 Richard Henry Lee Elementary   Regular School No Elementary KG 05 2020   pk_12_total 212 104 127   * 20         40                             506 212 104 127     20         40                       506
1238031 1238031 MD     school 2400060 2   Anne Arundel 240006000064 4142 Eastport Elementary   Regular School No Elementary PK 05 2020   pk_12_total 38 104 144   * *         10                             300 38 104 144               10                       300
1240434 1240434 MD     school 2400330 10   Frederick 240033001549 225 Gov. Thomas Johnson Middle   Regular School No Middle 06 08 2020   pk_12_total 258 104 124   * 31     *   31                             553 258 104 124     31         31                       553
1245006 1245006 MD     school 2400660 21   Washington 240066001667 325 Rockland Woods Elementary   Regular School No Elementary PK 05 2020   pk_12_total 357 104 97   * 26     *   64                             652 357 104 97     26         64                       652
1313120 1313120 MD     school 2400330 10   Frederick 240033090472 916 Spring Ridge Elementary   Regular School No Elementary PK 05 2021   pk_12_total 206 104 65     16     *   45                             437 206 104 65     16         45                       437
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
1241530 1241530 MD     school 2400420 13   Howard 240042090478 523 Pointers Run Elementary   Regular School No Elementary PK 05 2020   pk_12_total 414 105 33   * 291     *   67                             912 414 105 33     291         67                       912
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
1244159 1244159 MD     school 2400510 16   Prince George's 240051001176 1706 Thomas S. Stone Elementary   Regular School No Elementary PK 05 2020   pk_12_total 18 105 425   * *     *   *                             557 18 105 425                                       557
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
1311494 1311494 MD     school 2400120 3   Baltimore County 240012001750 1113 Honeygo Elementary   Regular School No Elementary PK 05 2021   pk_12_total 347 105 28   * 130     *   47                             661 347 105 28     130         47                       661
1311619 1311619 MD     school 2400120 3   Baltimore County 240012000344 1307 Baltimore Highlands Elementary   Regular School No Elementary PK 05 2021   pk_12_total 96 105 223   * *         33                             469 96 105 223               33                       469
1312581 1312581 MD     school 2400270 8   Charles 240027000609 105 Walter J. Mitchell Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 377 105 55   * 13     *   59                             613 377 105 55     13         59                       613
1313920 1313920 MD     school 2400420 13   Howard 240042000856 217 Hollifield Station Elementary   Regular School No Elementary KG 05 2021   pk_12_total 172 105 100   * 359     *   26                             768 172 105 100     359         26                       768
1314443 1314443 MD     school 2400480 15   Montgomery 240048000840 204 Garrett Park Elementary   Regular School No Elementary PK 05 2021   pk_12_total 277 105 168     114     *   62                             729 277 105 168     114         62                       729
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
1314944 1314944 MD     school 2400480 15   Montgomery 240048000950 504 Westover Elementary   Regular School No Elementary PK 05 2021   pk_12_total 57 105 69     28     *   21                             281 57 105 69     28         21                       281
1315341 1315341 MD     school 2400480 15   Montgomery 240048000893 761 Pine Crest Elementary   Regular School No Elementary 03 05 2021   pk_12_total 112 105 170     32         27                             446 112 105 170     32         27                       446
1319117 1319117 MD     school 2400090 30   Baltimore City 240009001661 337 Afya Public Charter School   Regular School Yes Middle 08 08 2021   pk_12_total   105 *                                             112   105                                         112
1242354 1242354 MD     school 2400480 15   Montgomery 240048000920 501 Sherwood Elementary   Regular School No Elementary PK 05 2020   pk_12_total 218 106 90   * 53     *   53                             524 218 106 90     53         53                       524
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
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
1244856 1244856 MD     school 2400570 19   Somerset 240057001201 702 Crisfield Academy and High School   Regular School No High 08 12 2020   pk_12_total 244 106 45   * *         18                             415 244 106 45               18                       415
1311262 1311262 MD     school 2400120 3   Baltimore County 240012001722 814 Mays Chapel Elementary   Regular School No Elementary PK 05 2021   pk_12_total 279 106 92   * 142         45                             668 279 106 92     142         45                       668
1314102 1314102 MD     school 2400420 13   Howard 240042001115 526 Lime Kiln Middle   Regular School No Middle 06 08 2021   pk_12_total 274 106 27   * 176     *   56                             642 274 106 27     176         56                       642
1238612 1238612 MD     school 2400120 3   Baltimore County 240012001547 473 New Town High   Regular School No High 09 12 2020   pk_12_total 22 1067 31     11         37                             1168 22 1067 31     11         37                       1168
1316201 1316201 MD     school 2400510 16   Prince George's 240051001092 1008 Laurel High   Regular School No High 09 12 2021   pk_12_total 71 1069 728   * 75     *   35                             1986 71 1069 728     75         35                       1986
1240567 1240567 MD     school 2400330 10   Frederick 240033090472 916 Spring Ridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 242 107 55   * 21     *   53                             482 242 107 55     21         53                       482
1241094 1241094 MD     school 2400390 12   Harford 240039001397 372 Bel Air Middle   Regular School No Middle 06 08 2020   pk_12_total 1062 107 89   * 101     *   69                             1435 1062 107 89     101         69                       1435
1310618 1310618 MD     school 2400060 2   Anne Arundel 240006000074 4182 Germantown Elementary   Regular School No Elementary PK 05 2021   pk_12_total 96 107 271   * *         *                             485 96 107 271                                       485
1315063 1315063 MD     school 2400480 15   Montgomery 240048001454 549 Flower Hill Elementary   Regular School No Elementary PK 05 2021   pk_12_total 31 107 222     55         26                             441 31 107 222     55         26                       441
1237389 1237389 MD     school 2400060 2   Anne Arundel 240006000049 1092 Brooklyn Park Elementary   Regular School No Elementary PK 05 2020   pk_12_total 199 108 104   * *         30                             450 199 108 104               30                       450
1239922 1239922 MD     school 2400240 7   Cecil 240024000560 401 Cecil Manor Elementary   Regular School No Elementary PK 05 2020   pk_12_total 191 108 61     *         47                             408 191 108 61               47                       408
1240757 1240757 MD     school 2400330 10   Frederick 240033000656 2606 Walkersville Middle   Regular School No Middle 06 08 2020   pk_12_total 570 108 117     24     *   56                             876 570 108 117     24         56                       876
1241715 1241715 MD     school 2400450 14   Kent 240045000768 301 Kent County High   Regular School No High 09 12 2020   pk_12_total 385 108 41               34                             568 385 108 41               34                       568
1244961 1244961 MD     school 2400660 21   Washington 240066001740 190 Jonathan Hager Elementary   Regular School No Elementary PK 05 2020   pk_12_total 150 108 56   * *     *   55                             385 150 108 56               55                       385
1311635 1311635 MD     school 2400120 3   Baltimore County 240012000461 1310 Relay Elementary   Regular School No Elementary PK 05 2021   pk_12_total 299 108 39   * 113         55                             616 299 108 39     113         55                       616
1311988 1311988 MD     school 2400150 4   Calvert 240015001655 208 Barstow Elementary   Regular School No Elementary PK 05 2021   pk_12_total 389 108 37     *     *   65                             605 389 108 37               65                       605
1313310 1313310 MD     school 2400330 10   Frederick 240033000656 2606 Walkersville Middle   Regular School No Middle 06 08 2021   pk_12_total 519 108 131   * 23     *   53                             836 519 108 131     23         53                       836
1314517 1314517 MD     school 2400480 15   Montgomery 240048000869 220 Luxmanor Elementary   Regular School No Elementary PK 05 2021   pk_12_total 193 108 143     170         42                             656 193 108 143     170         42                       656
1315361 1315361 MD     school 2400480 15   Montgomery 240048000844 767 Glen Haven Elementary   Regular School No Elementary PK 05 2021   pk_12_total 79 108 237     31     *   24                             480 79 108 237     31         24                       480
1317935 1317935 MD     school 2400690 22   Wicomico 240069001303 1602 Fruitland Intermediate   Regular School No Elementary 03 05 2021   pk_12_total 196 108 55   * 23         34                             417 196 108 55     23         34                       417
1238711 1238711 MD     school 2400120 3   Baltimore County 240012001434 852 Ridgely Middle   Regular School No Middle 06 08 2020   pk_12_total 689 109 64   * 196     *   49                             1113 689 109 64     196         49                       1113
1242805 1242805 MD     school 2400480 15   Montgomery 240048000913 771 Rolling Terrace Elementary   Regular School No Elementary PK 05 2020   pk_12_total 56 109 581     17         12                             775 56 109 581     17         12                       775
1242952 1242952 MD     school 2400480 15   Montgomery 240048000848 797 Harmony Hills Elementary   Regular School No Elementary PK 05 2020   pk_12_total 23 109 573     36         *                             745 23 109 573     36                                 745
1317434 1317434 MD     school 2400570 19   Somerset 240057001201 702 Crisfield Academy and High School   Regular School No High 08 12 2021   pk_12_total 229 109 45     *         17                             401 229 109 45               17                       401
1318847 1318847 MD     school 2400090 30   Baltimore City 240009000224 240 Graceland Park/O'Donnell Heights Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 35 109 459     *         *                             608 35 109 459                                       608
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
1237612 1237612 MD     school 2400060 2   Anne Arundel 240006000084 2152 Jones Elementary   Regular School No Elementary KG 05 2020   pk_12_total 242 11 19     21         17                             310 242 11 19     21         17                       310
1238077 1238077 MD     school 2400060 2   Anne Arundel 240006000097 4212 Mayo Elementary   Regular School No Elementary KG 05 2020   pk_12_total 279 11 34     *     *   19                             347 279 11 34               19                       347

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