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,550 ✖
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
1315168 1315168 MD     school 2400480 15   Montgomery 240048000829 566 Fields Road Elementary   Regular School No Elementary PK 05 2021   pk_12_total 122 85 154   * 65         31                             458 122 85 154     65         31                       458
1315519 1315519 MD     school 2400480 15   Montgomery 240048000908 795 Rock View Elementary   Regular School No Elementary PK 05 2021   pk_12_total 133 85 307   * 58     *   37                             625 133 85 307     58         37                       625
1319291 1319291 MD     school 2400090 30   Baltimore City 240009001313 416 Digital Harbor High School   Career and Technical School No High 09 12 2021   pk_12_total 77 846 373   * *     *   *                             1315 77 846 373                                       1315
1319221 1319221 MD     school 2400090 30   Baltimore City 240009001691 377 Green Street Academy   Regular School Yes High 06 12 2021   pk_12_total 15 843 17     *                                       876 15 843 17                                       876
1310790 1310790 MD     school 2400120 3   Baltimore County 240012001649 75 Crossroads Center   Alternative School No High 07 12 2021   pk_12_total 63 84 *   * *         12                             169 63 84                 12                       169
1313144 1313144 MD     school 2400330 10   Frederick 240033001688 920 Oakdale High   Regular School No High 09 12 2021   pk_12_total 983 84 135   * 90     *   62                             1362 983 84 135     90         62                       1362
1314821 1314821 MD     school 2400480 15   Montgomery 240048000803 403 Chevy Chase Elementary   Regular School No Elementary 03 05 2021   pk_12_total 243 84 42     40         32                             441 243 84 42     40         32                       441
1317276 1317276 MD     school 2400600 18   Saint Mary's 240060001229 305 Leonardtown Middle   Regular School No Middle 06 08 2021   pk_12_total 802 84 53   * 20     *   67                             1029 802 84 53     20         67                       1029
1317958 1317958 MD     school 2400720 23   Worcester 240072001332 205 Snow Hill Elementary   Regular School No Elementary PK 03 2021   pk_12_total 194 84 22   * *         28                             332 194 84 22               28                       332
1316365 1316365 MD     school 2400510 16   Prince George's 240051001133 1220 Potomac High   Regular School No High 09 12 2021   pk_12_total 10 835 312   * 10     *   12                             1187 10 835 312     10         12                       1187
1315076 1315076 MD     school 2400480 15   Montgomery 240048000943 552 Washington Grove Elementary   Regular School No Elementary PK 05 2021   pk_12_total 28 83 253   * 20     *   17                             403 28 83 253     20         17                       403
1315104 1315104 MD     school 2400480 15   Montgomery 240048000875 556 Mill Creek Towne Elementary   Regular School No Elementary PK 05 2021   pk_12_total 86 83 205   * 72     *   33                             482 86 83 205     72         33                       482
1316953 1316953 MD     school 2400510 16   Prince George's 240051000975 1907 Beacon Heights Elementary   Regular School No Elementary PK 06 2021   pk_12_total * 83 317   * *                                       412   83 317                                       412
1310467 1310467 MD     school 2400060 2   Anne Arundel 240006000109 3353 Old Mill High   Regular School No High 09 12 2021   pk_12_total 906 829 344   * 117     10   153                             2364 906 829 344     117     10   153                       2364
1316315 1316315 MD     school 2400510 16   Prince George's 240051001123 1209 Oxon Hill High   Regular School No High 09 12 2021   pk_12_total 36 827 451   * 107     10   30                             1467 36 827 451     107     10   30                       1467
1319246 1319246 MD     school 2400090 30   Baltimore City 240009000194 400 Edmondson-Westside High   Career and Technical School No High 09 12 2021   pk_12_total 11 826 24   * *     *   *                             867 11 826 24                                       867
1319281 1319281 MD     school 2400090 30   Baltimore City 240009000298 414 Paul Laurence Dunbar High   Regular School No High 09 12 2021   pk_12_total 22 826 66   * *     *   *                             928 22 826 66                                       928
1316262 1316262 MD     school 2400510 16   Prince George's 240051001052 1103 Gwynn Park High   Regular School No High 09 12 2021   pk_12_total 31 825 117   * 16     *   28                             1025 31 825 117     16         28                       1025
1314459 1314459 MD     school 2400480 15   Montgomery 240048000947 207 Beall Elementary   Regular School No Elementary PK 05 2021   pk_12_total 204 82 114     74     *   41                             516 204 82 114     74         41                       516
1316446 1316446 MD     school 2400510 16   Prince George's 240051001089 1314 Largo High   Regular School No High 09 12 2021   pk_12_total * 817 67   * *     *   10                             909   817 67               10                       909
1311944 1311944 MD     school 2400150 4   Calvert 240015000778 114 St Leonard Elementary   Regular School No Elementary PK 05 2021   pk_12_total 282 81 55     *         55                             480 282 81 55               55                       480
1314536 1314536 MD     school 2400480 15   Montgomery 240048000849 228 Herbert Hoover Middle   Regular School No Middle 06 08 2021   pk_12_total 400 81 76   * 399     *   63                             1021 400 81 76     399         63                       1021
1314911 1314911 MD     school 2400480 15   Montgomery 240048000941 427 Walt Whitman High   Regular School No High 09 12 2021   pk_12_total 1285 81 205   * 278     *   138                             1991 1285 81 205     278         138                       1991
1317339 1317339 MD     school 2400600 18   Saint Mary's 240060001685 606 Evergreen Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 483 81 78   * 39     *   58                             741 483 81 78     39         58                       741
1315369 1315369 MD     school 2400480 15   Montgomery 240048000888 769 Oakland Terrace Elementary   Regular School No Elementary PK 05 2021   pk_12_total 183 80 182   * 24         42                             512 183 80 182     24         42                       512
1316732 1316732 MD     school 2400510 16   Prince George's 240051001110 1703 Mt Rainier Elementary   Regular School No Elementary PK 06 2021   pk_12_total 30 80 212     *         *                             328 30 80 212                                       328
1312252 1312252 MD     school 2400210 6   Carroll 240021001185 704 Winters Mill High   Regular School No High 09 12 2021   pk_12_total 780 79 125   * 38     *   55                             1080 780 79 125     38         55                       1080
1315438 1315438 MD     school 2400480 15   Montgomery 240048001537 779 Sargent Shriver Elementary   Regular School No Elementary PK 05 2021   pk_12_total 19 79 576   * 42         16                             736 19 79 576     42         16                       736
1313074 1313074 MD     school 2400330 10   Frederick 240033001762 717 Sugarloaf Elementary   Regular School No Elementary KG 05 2021   pk_12_total 291 78 78   * 133         39                             620 291 78 78     133         39                       620
1315337 1315337 MD     school 2400480 15   Montgomery 240048000877 757 Montgomery Blair High   Regular School No High 09 12 2021   pk_12_total 780 773 1106   * 414     *   139                             3220 780 773 1106     414         139                       3220
1311519 1311519 MD     school 2400120 3   Baltimore County 240012000349 1205 Berkshire Elementary   Regular School No Elementary PK 05 2021   pk_12_total 196 77 110   * *     *   29                             423 196 77 110               29                       423
1315560 1315560 MD     school 2400480 15   Montgomery 240048000832 803 Forest Knolls Elementary   Regular School No Elementary PK 05 2021   pk_12_total 172 77 219   * 27     *   45                             543 172 77 219     27         45                       543
1316331 1316331 MD     school 2400510 16   Prince George's 240051001042 1214 Glassmanor Elementary   Regular School No Elementary KG 05 2021   pk_12_total * 77 204               *                             284   77 204                                       284
1310022 1310022 MD     school 2400060 2   Anne Arundel 240006000110 1192 Overlook Elementary   Regular School No Elementary PK 05 2021   pk_12_total 182 76 57   * 14     *   24                             355 182 76 57     14         24                       355
1314509 1314509 MD     school 2400480 15   Montgomery 240048000828 219 Farmland Elementary   Regular School No Elementary PK 05 2021   pk_12_total 326 76 84   * 255         32                             774 326 76 84     255         32                       774
1315502 1315502 MD     school 2400480 15   Montgomery 240048000881 791 New Hampshire Estates Elem   Regular School No Elementary PK 02 2021   pk_12_total 16 76 338     *         12                             448 16 76 338               12                       448
1317963 1317963 MD     school 2400720 23   Worcester 240072001334 207 Snow Hill High   Regular School No High 09 12 2021   pk_12_total 229 76 11   * *         18                             337 229 76 11               18                       337
1312713 1312713 MD     school 2400270 8   Charles 240027000615 621 Mattawoman Middle School   Regular School No Middle 06 08 2021   pk_12_total 37 756 116   * 54     *   56                             1024 37 756 116     54         56                       1024
1318953 1318953 MD     school 2400090 30   Baltimore City 240009001390 256 Calvin M. Rodwell Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 753 46   * *         *                             817   753 46                                       817
1311717 1311717 MD     school 2400120 3   Baltimore County 240012000438 1473 Overlea High   Regular School No High 09 12 2021   pk_12_total 181 751 119   * 39     *   52                             1148 181 751 119     39         52                       1148
1314727 1314727 MD     school 2400480 15   Montgomery 240048001044 321 James Hubert Blake High   Regular School No High 09 12 2021   pk_12_total 277 751 540   * 179         64                             1815 277 751 540     179         64                       1815
1318877 1318877 MD     school 2400090 30   Baltimore City 240009000147 243 Armistead Gardens Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 154 75 518   * *         26                             780 154 75 518               26                       780
1316662 1316662 MD     school 2400510 16   Prince George's 240051001475 1510 James Madison Middle   Regular School No Middle 06 08 2021   pk_12_total 19 743 110   * *     *   *                             895 19 743 110                                       895
1310014 1310014 MD     school 2400060 2   Anne Arundel 240006000105 1182 Oakwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 137 74 69   * 26         30                             339 137 74 69     26         30                       339
1310874 1310874 MD     school 2400120 3   Baltimore County 240012000406 115 Hillcrest Elementary   Regular School No Elementary PK 05 2021   pk_12_total 387 74 80   * 123     *   26                             692 387 74 80     123         26                       692
1311813 1311813 MD     school 2400120 3   Baltimore County 240012000345 1517 Battle Grove Elementary   Regular School No Elementary PK 05 2021   pk_12_total 155 74 58   * *     *   42                             334 155 74 58               42                       334
1313659 1313659 MD     school 2400390 12   Harford 240039000682 374 Southampton Middle   Regular School No Middle 06 08 2021   pk_12_total 923 74 59   * 59         56                             1173 923 74 59     59         56                       1173
1315233 1315233 MD     school 2400480 15   Montgomery 240048000781 607 Bells Mill Elementary   Regular School No Elementary PK 05 2021   pk_12_total 233 74 56   * 171     *   43                             579 233 74 56     171         43                       579
1315253 1315253 MD     school 2400480 15   Montgomery 240048001513 653 Stone Mill Elementary   Regular School No Elementary PK 05 2021   pk_12_total 129 74 43     245         30                             521 129 74 43     245         30                       521
1316786 1316786 MD     school 2400510 16   Prince George's 240051001139 1713 Cesar Chavez Elementary   Regular School No Elementary KG 05 2021   pk_12_total 44 74 247     *     *                                 371 44 74 247                                       371
1317114 1317114 MD     school 2400510 16   Prince George's 240051001006 2121 Cherokee Lane Elementary   Regular School No Elementary KG 06 2021   pk_12_total 13 74 446     17         *                             558 13 74 446     17                                 558
1317553 1317553 MD     school 2400660 21   Washington 240066001295 204 Williamsport High   Regular School No High 09 12 2021   pk_12_total 660 74 104   * 10         52                             901 660 74 104     10         52                       901
1317807 1317807 MD     school 2400690 22   Wicomico 240069001306 102 Mardela Middle & High   Regular School No High 06 12 2021   pk_12_total 515 74 26   * *         53                             674 515 74 26               53                       674
1310527 1310527 MD     school 2400060 2   Anne Arundel 240006000132 4023 Southern High   Regular School No High 09 12 2021   pk_12_total 719 73 176     10     *   53                             1032 719 73 176     10         53                       1032
1310626 1310626 MD     school 2400060 2   Anne Arundel 240006000080 4192 Hillsmere Elementary   Regular School No Elementary PK 05 2021   pk_12_total 249 73 55     *         15                             398 249 73 55               15                       398
1311829 1311829 MD     school 2400120 3   Baltimore County 240012000437 1519 Orems Elementary   Regular School No Elementary PK 05 2021   pk_12_total 179 73 56   * 24         26                             363 179 73 56     24         26                       363
1314391 1314391 MD     school 2400480 15   Montgomery 240048000897 152 Poolesville High   Regular School No High 09 12 2021   pk_12_total 551 73 113   * 431         65                             1236 551 73 113     431         65                       1236
1311956 1311956 MD     school 2400150 4   Calvert 240015002946 116 Mill Creek Middle   Regular School No Middle 06 08 2021   pk_12_total 330 72 36   * *         47                             488 330 72 36               47                       488
1313132 1313132 MD     school 2400330 10   Frederick 240033001163 918 Oakdale Middle   Regular School No Middle 06 08 2021   pk_12_total 601 72 101   * 70     *   50                             899 601 72 101     70         50                       899
1317293 1317293 MD     school 2400600 18   Saint Mary's 240060001231 404 Margaret Brent Middle   Regular School No Middle 06 08 2021   pk_12_total 807 72 48   * *     *   65                             1002 807 72 48               65                       1002
1316078 1316078 MD     school 2400510 16   Prince George's 240051000982 714 Benjamin Tasker Middle School   Regular School No Middle 06 08 2021   pk_12_total 129 718 127   * 53     *   28                             1068 129 718 127     53         28                       1068
1316962 1316962 MD     school 2400510 16   Prince George's 240051001126 1909 Parkdale High   Regular School No High 09 12 2021   pk_12_total 80 717 1560   * 74     *   15                             2453 80 717 1560     74         15                       2453
1316469 1316469 MD     school 2400510 16   Prince George's 240051001472 1326 Kettering Middle   Regular School No Middle 06 08 2021   pk_12_total * 714 130     *     *   11                             875   714 130               11                       875
1318423 1318423 MD     school 2400090 30   Baltimore City 240009000273 88 Wildwood Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 713 15           *   *                             734   713 15                                       734
1310811 1310811 MD     school 2400120 3   Baltimore County 240012000936 102 Westchester Elementary   Regular School No Elementary PK 05 2021   pk_12_total 415 71 55   * 93         31                             668 415 71 55     93         31                       668
1310850 1310850 MD     school 2400120 3   Baltimore County 240012000466 111 Maiden Choice School   Special Education School No Other PK 12 2021   pk_12_total 29 71 *     16         *                             130 29 71       16                                 130
1311527 1311527 MD     school 2400120 3   Baltimore County 240012000347 1206 Bear Creek Elementary   Regular School No Elementary PK 05 2021   pk_12_total 264 71 62   * *         45                             457 264 71 62               45                       457
1313873 1313873 MD     school 2400420 13   Howard 240042000744 208 Northfield Elementary   Regular School No Elementary KG 05 2021   pk_12_total 324 71 51   * 232     *   54                             736 324 71 51     232         54                       736
1312632 1312632 MD     school 2400270 8   Charles 240027000607 605 Thomas Stone High School   Regular School No High 09 12 2021   pk_12_total 138 708 186   * 19     *   59                             1115 138 708 186     19         59                       1115
1311897 1311897 MD     school 2400120 3   Baltimore County 240012000412 1572 Kenwood High   Regular School No High 09 12 2021   pk_12_total 623 705 194   * 44     *   103                             1679 623 705 194     44         103                       1679
1316507 1316507 MD     school 2400510 16   Prince George's 240051001223 1348 Ernest Everett Just Middle   Regular School No Middle 06 08 2021   pk_12_total * 705 67   * *     *   *                             802   705 67                                       802
1314628 1314628 MD     school 2400480 15   Montgomery 240048001541 249 Clarksburg High   Regular School No High 09 12 2021   pk_12_total 403 702 585   * 559         111                             2365 403 702 585     559         111                       2365
1312265 1312265 MD     school 2400210 6   Carroll 240021000552 707 Westminster High   Regular School No High 09 12 2021   pk_12_total 1242 70 84   * 56     *   59                             1515 1242 70 84     56         59                       1515
1314115 1314115 MD     school 2400420 13   Howard 240042001539 528 Dayton Oaks   Regular School No Elementary PK 05 2021   pk_12_total 346 70 37   * 177         51                             683 346 70 37     177         51                       683
1311009 1311009 MD     school 2400120 3   Baltimore County 240012001431 252 Northwest Academy of Health Sciences   Regular School No Middle 06 08 2021   pk_12_total 17 695 46   * *     *   12                             784 17 695 46               12                       784
1310038 1310038 MD     school 2400060 2   Anne Arundel 240006000116 1212 Point Pleasant Elementary   Regular School No Elementary PK 05 2021   pk_12_total 289 69 99     12         41                             510 289 69 99     12         41                       510
1313515 1313515 MD     school 2400390 12   Harford 240039001638 187 Patterson Mill High School   Regular School No High 09 12 2021   pk_12_total 599 69 58     53     *   54                             836 599 69 58     53         54                       836
1314561 1314561 MD     school 2400480 15   Montgomery 240048000827 233 Fallsmead Elementary   Regular School No Elementary PK 05 2021   pk_12_total 182 69 48   * 191     *   26                             520 182 69 48     191         26                       520
1319342 1319342 MD     school 2400090 30   Baltimore City 240009000209 450 Frederick Douglass High   Regular School No High 09 12 2021   pk_12_total 13 687 55     *         *                             759 13 687 55                                       759
1310086 1310086 MD     school 2400060 2   Anne Arundel 240006000127 2013 Severna Park High   Regular School No High 09 12 2021   pk_12_total 1525 68 109   * 78     *   95                             1880 1525 68 109     78         95                       1880
1310513 1310513 MD     school 2400060 2   Anne Arundel 240006001425 3414 Ruth Parker Eason School   Special Education School No Other PK 12 2021   pk_12_total 46 68 19     *     *   *                             149 46 68 19                                       149
1311208 1311208 MD     school 2400120 3   Baltimore County 240012000350 803 Lutherville Laboratory   Regular School No Elementary KG 05 2021   pk_12_total 164 68 30     46     *   29                             338 164 68 30     46         29                       338
1313274 1313274 MD     school 2400330 10   Frederick 240033000657 2403 Waverley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 31 68 363   * 33         12                             511 31 68 363     33         12                       511
1317267 1317267 MD     school 2400600 18   Saint Mary's 240060001216 302 Benjamin Banneker Elementary   Regular School No Elementary PK 05 2021   pk_12_total 413 68 18     *         32                             536 413 68 18               32                       536
1318665 1318665 MD     school 2400090 30   Baltimore City 240009000243 215 Highlandtown Elementary/Middle #215   Regular School No Elementary PK 08 2021   pk_12_total 11 68 377     *     *   *                             463 11 68 377                                       463
1319089 1319089 MD     school 2400090 30   Baltimore City 240009001571 332 The Green School of Baltimore   Regular School Yes Elementary KG 05 2021   pk_12_total 61 68 *               24                             162 61 68                 24                       162
1313497 1313497 MD     school 2400390 12   Harford 240039000690 176 Edgewood High   Regular School No High 09 12 2021   pk_12_total 412 678 169   * 43     *   102                             1413 412 678 169     43         102                       1413
1316450 1316450 MD     school 2400510 16   Prince George's 240051001211 1320 G. James Gholson Middle   Regular School No Middle 06 08 2021   pk_12_total * 676 254   * *         *                             949   676 254                                       949
1316678 1316678 MD     school 2400510 16   Prince George's 240051001697 1518 Barack Obama Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 675 41     *     *   13                             743   675 41               13                       743
1314615 1314615 MD     school 2400480 15   Montgomery 240048001040 246 Northwest High   Regular School No High 09 12 2021   pk_12_total 655 674 588   * 551         129                             2598 655 674 588     551         129                       2598
1318820 1318820 MD     school 2400090 30   Baltimore City 240009000231 236 Hamilton Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 93 673 50   * 10     *   26                             854 93 673 50     10         26                       854
1319122 1319122 MD     school 2400090 30   Baltimore City 240009001663 341 The Reach! Partnership School   Regular School No High 09 12 2021   pk_12_total * 672 14               *                             695   672 14                                       695
1317136 1317136 MD     school 2400510 16   Prince George's 240051001049 2141 Greenbelt Middle   Regular School No Middle 06 08 2021   pk_12_total 102 671 562   * 91     *   35                             1471 102 671 562     91         35                       1471
1310264 1310264 MD     school 2400060 2   Anne Arundel 240006000124 2413 Severn River Middle   Regular School No Middle 06 08 2021   pk_12_total 588 67 87   * 16         41                             801 588 67 87     16         41                       801
1314300 1314300 MD     school 2400480 15   Montgomery 240048000864 51 Laytonsville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 138 67 106     29     *   27                             369 138 67 106     29         27                       369
1317094 1317094 MD     school 2400510 16   Prince George's 240051001272 2109 Berwyn Heights Elementary   Regular School No Elementary KG 06 2021   pk_12_total 55 67 298     19         *                             447 55 67 298     19                                 447
1317799 1317799 MD     school 2400660 21   Washington 240066001266 2701 Fountaindale Elementary   Regular School No Elementary PK 05 2021   pk_12_total 194 67 39     22         37                             359 194 67 39     22         37                       359
1317926 1317926 MD     school 2400690 22   Wicomico 240069001149 1502 Westside Intermediate   Regular School No Elementary 02 05 2021   pk_12_total 229 67 27   * *         34                             363 229 67 27               34                       363
1310999 1310999 MD     school 2400120 3   Baltimore County 240012001159 217 New Town Elementary   Regular School No Elementary PK 05 2021   pk_12_total 40 667 35   * 34     *   34                             818 40 667 35     34         34                       818
1316025 1316025 MD     school 2400510 16   Prince George's 240051001034 660 Drew Freeman Middle   Regular School No Middle 06 08 2021   pk_12_total * 662 157   * *     *   *                             838   662 157                                       838

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