enrollments

Data source: Big Local News · About: Big Local

1,393 rows where grade = "pk_12_total", state = "MD" and year = 2021 sorted by black

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 1,293 ✖

grade ✖

  • pk_12_total · 1,293 ✖
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1310136 1310136 MD     school 2400060 2   Anne Arundel 240006000051 2092 Cape St. Claire Elementary   Regular School No Elementary KG 05 2021   pk_12_total 427 11 68   * 16     *   41                             566 427 11 68     16         41                       566
1310412 1310412 MD     school 2400060 2   Anne Arundel 240006000130 3212 South Shore Elementary   Regular School No Elementary KG 05 2021   pk_12_total 175 11 52   * *         22                             268 175 11 52               22                       268
1312239 1312239 MD     school 2400210 6   Carroll 240021001652 603 Ebb Valley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 474 11 14   * 10     *   13                             527 474 11 14     10         13                       527
1312371 1312371 MD     school 2400210 6   Carroll 240021001414 1304 Parr's Ridge Elementary   Regular School No Elementary PK 02 2021   pk_12_total 292 11 57     *     *   17                             384 292 11 57               17                       384
1312934 1312934 MD     school 2400330 10   Frederick 240033001410 208 Heather Ridge   Alternative School No High 07 12 2021   pk_12_total 22 11 *   *           *                             44 22 11                                         44
1314586 1314586 MD     school 2400480 15   Montgomery 240048000809 238 Cold Spring Elementary   Regular School No Elementary PK 05 2021   pk_12_total 139 11 14     128         25                             317 139 11 14     128         25                       317
1317655 1317655 MD     school 2400660 21   Washington 240066001484 705 Washington County Job Development Center   Special Education School No High 12 12 2021   pk_12_total 18 11 *               *                             34 18 11                                         34
1317707 1317707 MD     school 2400660 21   Washington 240066001268 1602 Greenbrier Elementary   Regular School No Elementary PK 05 2021   pk_12_total 170 11 11     18         10                             220 170 11 11     18         10                       220
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
1313765 1313765 MD     school 2400390 12   Harford 240039000711 639 Roye-Williams Elementary   Regular School No Elementary PK 05 2021   pk_12_total 164 110 74   * *     *   52                             410 164 110 74               52                       410
1314272 1314272 MD     school 2400450 14   Kent 240045000768 301 Kent County High   Regular School No High 09 12 2021   pk_12_total 371 110 55   * *         41                             580 371 110 55               41                       580
1314324 1314324 MD     school 2400480 15   Montgomery 240048000843 102 Germantown Elementary   Regular School No Elementary PK 05 2021   pk_12_total 47 110 75   * 50     *   16                             301 47 110 75     50         16                       301
1315084 1315084 MD     school 2400480 15   Montgomery 240048000836 553 Gaithersburg Elementary   Regular School No Elementary PK 05 2021   pk_12_total 22 110 656   * 16     *   17                             825 22 110 656     16         17                       825
1315385 1315385 MD     school 2400480 15   Montgomery 240048000913 771 Rolling Terrace Elementary   Regular School No Elementary PK 05 2021   pk_12_total 44 111 536     15         21                             727 44 111 536     15         21                       727
1316711 1316711 MD     school 2400510 16   Prince George's 240051001064 1601 Hyattsville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 86 111 262   * *         *                             477 86 111 262                                       477
1317086 1317086 MD     school 2400510 16   Prince George's 240051000993 2108 Buck Lodge Middle   Regular School No Middle 06 08 2021   pk_12_total * 111 1158   * 10         *                             1295   111 1158     10                                 1295
1311167 1311167 MD     school 2400120 3   Baltimore County 240012001547 473 New Town High   Regular School No High 09 12 2021   pk_12_total 16 1117 27   * 13         40                             1214 16 1117 27     13         40                       1214
1309950 1309950 MD     school 2400060 2   Anne Arundel 240006000049 1092 Brooklyn Park Elementary   Regular School No Elementary PK 05 2021   pk_12_total 177 112 116   * *     *   24                             440 177 112 116               24                       440
1313225 1313225 MD     school 2400330 10   Frederick 240033000661 2103 Yellow Springs Elementary   Regular School No Elementary KG 05 2021   pk_12_total 266 112 65   * 22     *   31                             498 266 112 65     22         31                       498
1314131 1314131 MD     school 2400420 13   Howard 240042000718 603 Atholton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 206 112 52     35         46                             451 206 112 52     35         46                       451
1316282 1316282 MD     school 2400510 16   Prince George's 240051001121 1201 Oxon Hill Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 112 91     14         *                             228   112 91     14                                 228
1317581 1317581 MD     school 2400660 21   Washington 240066001667 325 Rockland Woods Elementary   Regular School No Elementary PK 05 2021   pk_12_total 323 112 91   * 19     *   55                             604 323 112 91     19         55                       604
1318995 1318995 MD     school 2400090 30   Baltimore City 240009000336 301 William S. Baer School   Special Education School No Other PK 12 2021   pk_12_total 14 112 20     *                                       148 14 112 20                                       148
1311797 1311797 MD     school 2400120 3   Baltimore County 240012000430 1514 Middlesex Elementary   Regular School No Elementary PK 05 2021   pk_12_total 139 113 78     *         31                             370 139 113 78               31                       370
1312111 1312111 MD     school 2400180 5   Caroline 240018000523 703 North Caroline High School   Regular School No High 09 12 2021   pk_12_total 743 113 213   * 10     *   81                             1164 743 113 213     10         81                       1164
1312947 1312947 MD     school 2400330 10   Frederick 240033000645 210 North Frederick Elementary   Regular School No Elementary PK 05 2021   pk_12_total 232 113 160     27         67                             599 232 113 160     27         67                       599
1313650 1313650 MD     school 2400390 12   Harford 240039001397 372 Bel Air Middle   Regular School No Middle 06 08 2021   pk_12_total 1067 113 90   * 106     *   61                             1441 1067 113 90     106         61                       1441
1312726 1312726 MD     school 2400270 8   Charles 240027001416 623 North Point High School   Regular School No High 09 12 2021   pk_12_total 286 1130 141   * 108     *   139                             1813 286 1130 141     108         139                       1813
1311571 1311571 MD     school 2400120 3   Baltimore County 240012000470 1216 Sandy Plains Elementary   Regular School No Elementary PK 05 2021   pk_12_total 250 114 93   * 19         51                             534 250 114 93     19         51                       534
1313774 1313774 MD     school 2400390 12   Harford 240039000696 679 Havre de Grace Middle   Regular School No Middle 06 08 2021   pk_12_total 364 114 49   * *     *   78                             613 364 114 49               78                       613
1316795 1316795 MD     school 2400510 16   Prince George's 240051000965 1714 Adelphi Elementary   Regular School No Elementary PK 06 2021   pk_12_total 14 114 554   * 14         *                             702 14 114 554     14                                 702
1317536 1317536 MD     school 2400660 21   Washington 240066001740 190 Jonathan Hager Elementary   Regular School No Elementary PK 05 2021   pk_12_total 129 114 56   * *     *   57                             372 129 114 56               57                       372
1313849 1313849 MD     school 2400420 13   Howard 240042001444 202 Ellicott Mills Middle   Regular School No Middle 06 08 2021   pk_12_total 294 115 41   * 283     *   51                             789 294 115 41     283         51                       789
1316970 1316970 MD     school 2400510 16   Prince George's 240051001154 2003 Seabrook Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 115 199     10         *                             330   115 199     10                                 330
1318831 1318831 MD     school 2400090 30   Baltimore City 240009000244 237 Highlandtown Elementary/Middle #237   Regular School No Elementary PK 08 2021   pk_12_total 15 115 720     *     *   *                             860 15 115 720                                       860
1315839 1315839 MD     school 2400510 16   Prince George's 240051001686 509 Accokeek Academy   Regular School No Elementary KG 08 2021   pk_12_total 57 1150 216   * 66     12   38                             1543 57 1150 216     66     12   38                       1543
1311026 1311026 MD     school 2400120 3   Baltimore County 240012000432 271 Milford Mill Academy   Regular School No High 09 12 2021   pk_12_total 22 1155 84   * 15         33                             1312 22 1155 84     15         33                       1312
1310046 1310046 MD     school 2400060 2   Anne Arundel 240006000117 1232 Quarterfield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 146 116 85     47     *   49                             445 146 116 85     47         49                       445
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
1317043 1317043 MD     school 2400510 16   Prince George's 240051001085 2014 Lamont Elementary   Regular School No Elementary PK 05 2021   pk_12_total 27 116 333   * 10         *                             493 27 116 333     10                                 493
1317969 1317969 MD     school 2400720 23   Worcester 240072001333 208 Snow Hill Middle   Regular School No Middle 04 08 2021   pk_12_total 232 116 18   * *         35                             407 232 116 18               35                       407
1312116 1312116 MD     school 2400180 5   Caroline 240018000518 801 Colonel Richardson High School   Regular School No High 09 12 2021   pk_12_total 328 117 31     12         34                             522 328 117 31     12         34                       522
1312470 1312470 MD     school 2400240 7   Cecil 240024000560 401 Cecil Manor Elementary   Regular School No Elementary PK 05 2021   pk_12_total 148 117 58     *         49                             374 148 117 58               49                       374
1313139 1313139 MD     school 2400330 10   Frederick 240033001165 919 Oakdale Elementary   Regular School No Elementary KG 05 2021   pk_12_total 527 117 102   * 135     *   40                             926 527 117 102     135         40                       926
1313169 1313169 MD     school 2400330 10   Frederick 240033001715 1301 Frederick Classical Charter   Regular School Yes Elementary KG 08 2021   pk_12_total 155 117 47   * 30     *   23                             376 155 117 47     30         23                       376
1311920 1311920 MD     school 2400150 4   Calvert 240015000504 101 Patuxent Appeal Elementary Campus   Regular School No Elementary PK 05 2021   pk_12_total 394 118 52     *     *   99                             667 394 118 52               99                       667
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
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
1316753 1316753 MD     school 2400510 16   Prince George's 240051001009 1709 Chillum Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 118 220   * *                                       347   118 220                                       347
1316944 1316944 MD     school 2400510 16   Prince George's 240051001178 1902 University Park Elementary   Regular School No Elementary PK 06 2021   pk_12_total 122 118 187   * 33     *   *                             467 122 118 187     33                                 467

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