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,598 ✖
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
1312798 1312798 MD     school 2400270 8   Charles 240027001727 802 St. Charles High School   Regular School No High 09 12 2021   pk_12_total 154 997 101   11 30     *   96                             1392 154 997 101   11 30         96                       1392
1319251 1319251 MD     school 2400090 30   Baltimore City 240009000151 403 Baltimore Polytechnic Institute   Regular School No High 09 12 2021   pk_12_total 279 993 200   * 109     *   30                             1619 279 993 200     109         30                       1619
1316651 1316651 MD     school 2400510 16   Prince George's 240051001036 1502 Frederick Douglass High   Regular School No High 09 12 2021   pk_12_total 17 992 69   * *     *   28                             1115 17 992 69               28                       1115
1310390 1310390 MD     school 2400060 2   Anne Arundel 240006000114 3182 Pershing Hill Elementary   Regular School No Elementary KG 05 2021   pk_12_total 216 99 97   * 14     *   60                             491 216 99 97     14         60                       491
1314085 1314085 MD     school 2400420 13   Howard 240042090478 523 Pointers Run Elementary   Regular School No Elementary PK 05 2021   pk_12_total 312 99 43   * 259         65                             779 312 99 43     259         65                       779
1314923 1314923 MD     school 2400480 15   Montgomery 240048000920 501 Sherwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 184 98 86   * 51         46                             467 184 98 86     51         46                       467
1316124 1316124 MD     school 2400510 16   Prince George's 240051000973 802 Baden Elementary   Regular School No Elementary PK 06 2021   pk_12_total 37 98 46   *           16                             198 37 98 46               16                       198
1319352 1319352 MD     school 2400090 30   Baltimore City 240009000150 480 Baltimore City College   Regular School No High 09 12 2021   pk_12_total 256 972 146   * 25     *   32                             1439 256 972 146     25         32                       1439
1310219 1310219 MD     school 2400060 2   Anne Arundel 240006000129 2212 Solley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 453 97 92   * 32     *   57                             735 453 97 92     32         57                       735
1317691 1317691 MD     school 2400660 21   Washington 240066001274 1301 Maugansville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 394 97 115     22         56                             684 394 97 115     22         56                       684
1311101 1311101 MD     school 2400120 3   Baltimore County 240012000388 403 Franklin Elementary   Regular School No Elementary PK 05 2021   pk_12_total 203 96 49     28         24                             400 203 96 49     28         24                       400
1312082 1312082 MD     school 2400180 5   Caroline 240018000526 302 Lockerman Middle School   Regular School No Middle 06 08 2021   pk_12_total 544 96 184     *         69                             902 544 96 184               69                       902
1314652 1314652 MD     school 2400480 15   Montgomery 240048000788 304 JoAnn Leleck at Broad Acres Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 96 697   * 18         *                             821   96 697     18                                 821
1318888 1318888 MD     school 2400090 30   Baltimore City 240009000268 245 Leith Walk Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 950 48   * *     *   *                             1018   950 48                                       1018
1319347 1319347 MD     school 2400090 30   Baltimore City 240009000168 454 Carver Vocational-Technical High   Career and Technical School No High 09 12 2021   pk_12_total 15 942 24   * *         *                             985 15 942 24                                       985
1310803 1310803 MD     school 2400120 3   Baltimore County 240012000353 101 Catonsville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 301 94 50     140     *   52                             638 301 94 50     140         52                       638
1313913 1313913 MD     school 2400420 13   Howard 240042000173 216 Burleigh Manor Middle School   Regular School No Middle 06 08 2021   pk_12_total 267 93 45   * 391         44                             844 267 93 45     391         44                       844
1311409 1311409 MD     school 2400120 3   Baltimore County 240012000443 972 Parkville High   Regular School No High 09 12 2021   pk_12_total 423 925 485   * 161     *   71                             2075 423 925 485     161         71                       2075
1312050 1312050 MD     school 2400150 4   Calvert 240015001505 316 Sunderland Elementary   Regular School No Elementary PK 05 2021   pk_12_total 444 92 31     *         54                             624 444 92 31               54                       624
1314931 1314931 MD     school 2400480 15   Montgomery 240048000889 502 Olney Elementary   Regular School No Elementary PK 05 2021   pk_12_total 312 92 98   * 90     *   40                             634 312 92 98     90         40                       634
1311931 1311931 MD     school 2400150 4   Calvert 240015001392 111 Southern Middle   Regular School No Middle 06 08 2021   pk_12_total 289 91 44   * *         40                             469 289 91 44               40                       469
1313067 1313067 MD     school 2400330 10   Frederick 240033001536 716 Urbana Middle   Regular School No Middle 06 08 2021   pk_12_total 483 91 112   * 208     *   70                             967 483 91 112     208         70                       967
1313809 1313809 MD     school 2400420 13   Howard 240042000396 105 Rockburn Elementary   Regular School No Elementary PK 05 2021   pk_12_total 277 91 36   * 168         35                             611 277 91 36     168         35                       611
1314001 1314001 MD     school 2400420 13   Howard 240042000724 505 Clarksville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 143 91 44     201         22                             501 143 91 44     201         22                       501
1313877 1313877 MD     school 2400420 13   Howard 240042000748 209 Patapsco Middle   Regular School No Middle 06 08 2021   pk_12_total 277 90 75   * 226     *   22                             693 277 90 75     226         22                       693
1315532 1315532 MD     school 2400480 15   Montgomery 240048000848 797 Harmony Hills Elementary   Regular School No Elementary PK 05 2021   pk_12_total 22 90 540   * 28     *   *                             690 22 90 540     28                                 690
1315756 1315756 MD     school 2400510 16   Prince George's 240051001146 210 Rogers Heights Elementary   Regular School No Elementary PK 06 2021   pk_12_total 10 90 629     *         *                             740 10 90 629                                       740
1317540 1317540 MD     school 2400660 21   Washington 240066001290 201 Springfield Middle   Regular School No Middle 06 08 2021   pk_12_total 581 90 104   * 14     *   68                             859 581 90 104     14         68                       859
1310006 1310006 MD     school 2400060 2   Anne Arundel 240006000102 1172 North Glen Elementary   Regular School No Elementary PK 05 2021   pk_12_total 85 89 87     15         27                             303 85 89 87     15         27                       303
1310053 1310053 MD     school 2400060 2   Anne Arundel 240006000118 1242 Richard Henry Lee Elementary   Regular School No Elementary KG 05 2021   pk_12_total 178 89 138   * 20     *   45                             472 178 89 138     20         45                       472
1311757 1311757 MD     school 2400120 3   Baltimore County 240012000360 1507 Chase Elementary   Regular School No Elementary PK 05 2021   pk_12_total 180 89 54     *     *   29                             355 180 89 54               29                       355
1312062 1312062 MD     school 2400150 4   Calvert 240015000967 318 Windy Hill Middle   Regular School No Middle 06 08 2021   pk_12_total 517 89 54   * *     *   77                             746 517 89 54               77                       746
1314952 1314952 MD     school 2400480 15   Montgomery 240048000868 505 Lucy V. Barnsley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 214 89 246   * 88     *   57                             701 214 89 246     88         57                       701
1315506 1315506 MD     school 2400480 15   Montgomery 240048001207 792 Newport Mill Middle   Regular School No Middle 06 08 2021   pk_12_total 95 89 401   * 53         28                             670 95 89 401     53         28                       670
1317050 1317050 MD     school 2400510 16   Prince George's 240051001142 2016 Robert Frost Elementary   Regular School No Elementary KG 05 2021   pk_12_total 13 89 164     *         *                             275 13 89 164                                       275
1317180 1317180 MD     school 2400540 17   Queen Anne's 240054001195 301 Queen Anne's County High School   Regular School No High 09 12 2021   pk_12_total 938 89 111   * 11         59                             1210 938 89 111     11         59                       1210
1318768 1318768 MD     school 2400090 30   Baltimore City 240009000161 231 The Belair-Edison School   Regular School Yes Elementary PK 08 2021   pk_12_total 12 881 12   *           20                             927 12 881 12               20                       927
1310095 1310095 MD     school 2400060 2   Anne Arundel 240006000072 2033 George Fox Middle   Regular School No Middle 06 08 2021   pk_12_total 634 88 88   * 18     *   62                             899 634 88 88     18         62                       899
1311486 1311486 MD     school 2400120 3   Baltimore County 240012000397 1111 Gunpowder Elementary   Regular School No Elementary KG 05 2021   pk_12_total 297 88 15   * 74         19                             494 297 88 15     74         19                       494
1312701 1312701 MD     school 2400270 8   Charles 240027000144 619 Westlake High School   Regular School No High 09 12 2021   pk_12_total 68 877 89   * 42     *   57                             1139 68 877 89     42         57                       1139
1311902 1311902 MD     school 2400120 3   Baltimore County 240012000477 1573 Sparrows Point High   Regular School No High 09 12 2021   pk_12_total 877 87 70   * 14     *   43                             1097 877 87 70     14         43                       1097
1313861 1313861 MD     school 2400420 13   Howard 240042000753 204 St. Johns Lane Elementary   Regular School No Elementary KG 05 2021   pk_12_total 249 87 34   * 278     *   28                             679 249 87 34     278         28                       679
1314960 1314960 MD     school 2400480 15   Montgomery 240048000830 506 Flower Valley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 172 87 123   * 43         44                             470 172 87 123     43         44                       470
1316107 1316107 MD     school 2400510 16   Prince George's 240051001384 723 C. Elizabeth Rieg Regional Center   Special Education School No Other KG 12 2021   pk_12_total 12 87 12     *                                       114 12 87 12                                       114
1316740 1316740 MD     school 2400510 16   Prince George's 240051001176 1706 Thomas S. Stone Elementary   Regular School No Elementary PK 05 2021   pk_12_total 12 87 360   * *     *                                 466 12 87 360                                       466
1310595 1310595 MD     school 2400060 2   Anne Arundel 240006000064 4142 Eastport Elementary   Regular School No Elementary PK 05 2021   pk_12_total 39 86 147   * *         *                             283 39 86 147                                       283
1315377 1315377 MD     school 2400480 15   Montgomery 240048000873 770 Flora M. Singer Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 210 86 230   * 42         43                             613 210 86 230     42         43                       613
1318388 1318388 MD     school 2400090 30   Baltimore City 240009000323 84 Thomas Johnson Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 354 86 47     *     *   25                             516 354 86 47               25                       516
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

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