enrollments

Data source: Big Local News · About: Big Local

9,615 rows where state = "MD" and year = 2020 sorted by black descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 9,563 ✖
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
1242388 1242388 MD     school 2400480 15   Montgomery 240048000830 506 Flower Valley Elementary   Regular School No Elementary KG 05 2020   pk_12_total 202 85 134   * 35         42                             499 202 85 134     35         42                       499
1242939 1242939 MD     school 2400480 15   Montgomery 240048000908 795 Rock View Elementary   Regular School No Elementary PK 05 2020   pk_12_total 150 85 315   * 69     *   31                             654 150 85 315     69         31                       654
1238450 1238450 MD     school 2400120 3   Baltimore County 240012001753 219 Watershed Public Charter   Regular School Yes Elementary KG 03 2020   pk_12_total 50 84 *   * *         21                             170 50 84                 21                       170
1239281 1239281 MD     school 2400120 3   Baltimore County 240012000429 1520 Middleborough Elementary   Regular School No Elementary PK 05 2020   pk_12_total 226 84 11   * *         22                             349 226 84 11               22                       349
1241254 1241254 MD     school 2400420 13   Howard 240042000396 105 Rockburn Elementary   Regular School No Elementary PK 05 2020   pk_12_total 313 84 34   * 149         45                             628 313 84 34     149         45                       628
1244602 1244602 MD     school 2400540 17   Queen Anne's 240054001195 301 Queen Anne's County High School   Regular School No High 09 12 2020   pk_12_total 933 84 109   * *         50                             1187 933 84 109               50                       1187
1245231 1245231 MD     school 2400690 22   Wicomico 240069001306 102 Mardela Middle & High   Regular School No High 06 12 2020   pk_12_total 519 84 20   * *         47                             675 519 84 20               47                       675
1242674 1242674 MD     school 2400480 15   Montgomery 240048001513 653 Stone Mill Elementary   Regular School No Elementary PK 05 2020   pk_12_total 152 83 52     270         31                             588 152 83 52     270         31                       588
1246701 1246701 MD     school 2400090 30   Baltimore City 240009000194 400 Edmondson-Westside High   Career and Technical School No High 09 12 2020   pk_12_total 10 826 13   * *     *                                 853 10 826 13                                       853
1237902 1237902 MD     school 2400060 2   Anne Arundel 240006000109 3353 Old Mill High   Regular School No High 09 12 2020   pk_12_total 892 821 311   * 104     10   139                             2281 892 821 311     104     10   139                       2281
1243783 1243783 MD     school 2400510 16   Prince George's 240051001133 1220 Potomac High   Regular School No High 09 12 2020   pk_12_total * 820 338   * 14         14                             1196   820 338     14         14                       1196
1242256 1242256 MD     school 2400480 15   Montgomery 240048000803 403 Chevy Chase Elementary   Regular School No Elementary 03 05 2020   pk_12_total 259 82 47     40         38                             466 259 82 47     40         38                       466
1245207 1245207 MD     school 2400660 21   Washington 240066001273 2601 Lincolnshire Elementary   Regular School No Elementary PK 05 2020   pk_12_total 325 82 50     *         66                             529 325 82 50               66                       529
1246678 1246678 MD     school 2400090 30   Baltimore City 240009001691 377 Green Street Academy   Regular School Yes High 06 12 2020   pk_12_total 20 815 16     *                                       852 20 815 16                                       852
1239389 1239389 MD     school 2400150 4   Calvert 240015000778 114 St Leonard Elementary   Regular School No Elementary PK 05 2020   pk_12_total 315 81 64     *         52                             521 315 81 64               52                       521
1241901 1241901 MD     school 2400480 15   Montgomery 240048000947 207 Beall Elementary   Regular School No Elementary PK 05 2020   pk_12_total 203 81 133     71     *   41                             531 203 81 133     71         41                       531
1242858 1242858 MD     school 2400480 15   Montgomery 240048001537 779 Sargent Shriver Elementary   Regular School No Elementary PK 05 2020   pk_12_total 16 81 587   * 44         12                             744 16 81 587     44         12                       744
1244507 1244507 MD     school 2400510 16   Prince George's 240051001272 2109 Berwyn Heights Elementary   Regular School No Elementary KG 06 2020   pk_12_total 53 81 302     30         *                             473 53 81 302     30                                 473
1244715 1244715 MD     school 2400600 18   Saint Mary's 240060001231 404 Margaret Brent Middle   Regular School No Middle 06 08 2020   pk_12_total 848 81 42   * *     *   60                             1043 848 81 42               60                       1043
1242342 1242342 MD     school 2400480 15   Montgomery 240048000941 427 Walt Whitman High   Regular School No High 09 12 2020   pk_12_total 1366 80 179   * 284     *   126                             2039 1366 80 179     284         126                       2039
1242655 1242655 MD     school 2400480 15   Montgomery 240048000781 607 Bells Mill Elementary   Regular School No Elementary PK 05 2020   pk_12_total 276 80 58   * 181     *   45                             642 276 80 58     181         45                       642
1242922 1242922 MD     school 2400480 15   Montgomery 240048000881 791 New Hampshire Estates Elem   Regular School No Elementary PK 02 2020   pk_12_total 15 80 358     15         10                             478 15 80 358     15         10                       478
1246315 1246315 MD     school 2400090 30   Baltimore City 240009000147 243 Armistead Gardens Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 182 80 513   * 10         21                             809 182 80 513     10         21                       809
1246206 1246206 MD     school 2400090 30   Baltimore City 240009000161 231 The Belair-Edison School   Regular School Yes Elementary PK 06 2020   pk_12_total 10 795 12   *           11                             831 10 795 12               11                       831
1239346 1239346 MD     school 2400120 3   Baltimore County 240012000477 1573 Sparrows Point High   Regular School No High 09 12 2020   pk_12_total 881 79 52   * 10     *   41                             1067 881 79 52     10         41                       1067
1244527 1244527 MD     school 2400510 16   Prince George's 240051001006 2121 Cherokee Lane Elementary   Regular School No Elementary KG 06 2020   pk_12_total 13 79 460   * 18         *                             580 13 79 460     18                                 580
1244978 1244978 MD     school 2400660 21   Washington 240066001295 204 Williamsport High   Regular School No High 09 12 2020   pk_12_total 663 79 105   * *         47                             903 663 79 105               47                       903
1246736 1246736 MD     school 2400090 30   Baltimore City 240009000298 414 Paul Laurence Dunbar High   Regular School No High 09 12 2020   pk_12_total 15 788 52   * *         *                             868 15 788 52                                       868
1237461 1237461 MD     school 2400060 2   Anne Arundel 240006000110 1192 Overlook Elementary   Regular School No Elementary PK 05 2020   pk_12_total 191 78 72     13     *   21                             376 191 78 72     13         21                       376
1242757 1242757 MD     school 2400480 15   Montgomery 240048000877 757 Montgomery Blair High   Regular School No High 09 12 2020   pk_12_total 770 779 1085   * 450     *   134                             3223 770 779 1085     450         134                       3223
1243865 1243865 MD     school 2400510 16   Prince George's 240051001089 1314 Largo High   Regular School No High 09 12 2020   pk_12_total * 779 70   * *     *   11                             872   779 70               11                       872
1243681 1243681 MD     school 2400510 16   Prince George's 240051001052 1103 Gwynn Park High   Regular School No High 09 12 2020   pk_12_total 34 778 105   * 13     *   26                             961 34 778 105     13         26                       961
1245858 1245858 MD     school 2400090 30   Baltimore City 240009000273 88 Wildwood Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 771 20           *   *                             800   771 20                                       800
1237477 1237477 MD     school 2400060 2   Anne Arundel 240006000116 1212 Point Pleasant Elementary   Regular School No Elementary PK 05 2020   pk_12_total 325 77 84     10         49                             545 325 77 84     10         49                       545
1237524 1237524 MD     school 2400060 2   Anne Arundel 240006000127 2013 Severna Park High   Regular School No High 09 12 2020   pk_12_total 1589 77 97   * 81     *   84                             1932 1589 77 97     81         84                       1932
1239886 1239886 MD     school 2400240 7   Cecil 240024000570 311 Holly Hall Elementary   Regular School No Elementary PK 05 2020   pk_12_total 246 77 59   * *         43                             430 246 77 59               43                       430
1244965 1244965 MD     school 2400660 21   Washington 240066001290 201 Springfield Middle   Regular School No Middle 06 08 2020   pk_12_total 623 77 104   * 13         48                             866 623 77 104     13         48                       866
1237962 1237962 MD     school 2400060 2   Anne Arundel 240006000132 4023 Southern High   Regular School No High 09 12 2020   pk_12_total 729 75 132   * *     *   51                             996 729 75 132               51                       996
1238320 1238320 MD     school 2400120 3   Baltimore County 240012000406 115 Hillcrest Elementary   Regular School No Elementary PK 05 2020   pk_12_total 409 75 81   * 98     *   32                             698 409 75 81     98         32                       698
1239273 1239273 MD     school 2400120 3   Baltimore County 240012000437 1519 Orems Elementary   Regular School No Elementary PK 05 2020   pk_12_total 208 75 61   * 22         32                             403 208 75 61     22         32                       403
1239702 1239702 MD     school 2400210 6   Carroll 240021001185 704 Winters Mill High   Regular School No High 09 12 2020   pk_12_total 792 75 126   * 34     *   48                             1079 792 75 126     34         48                       1079
1241103 1241103 MD     school 2400390 12   Harford 240039000682 374 Southampton Middle   Regular School No Middle 06 08 2020   pk_12_total 1007 75 62   * 42         73                             1261 1007 75 62     42         73                       1261
1240165 1240165 MD     school 2400270 8   Charles 240027000615 621 Mattawoman Middle School   Regular School No Middle 06 08 2020   pk_12_total 52 748 107   * 52     *   62                             1026 52 748 107     52         62                       1026
1242070 1242070 MD     school 2400480 15   Montgomery 240048001541 249 Clarksburg High   Regular School No High 09 12 2020   pk_12_total 424 743 653   * 539     *   108                             2472 424 743 653     539         108                       2472
1238964 1238964 MD     school 2400120 3   Baltimore County 240012000349 1205 Berkshire Elementary   Regular School No Elementary PK 05 2020   pk_12_total 218 74 147   * *     *   31                             484 218 74 147               31                       484
1238986 1238986 MD     school 2400120 3   Baltimore County 240012000395 1210 Grange Elementary   Regular School No Elementary PK 05 2020   pk_12_total 297 74 55   * 14     *   44                             489 297 74 55     14         44                       489
1240059 1240059 MD     school 2400270 8   Charles 240027001492 302 Mt Hope/Nanjemoy Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 167 74 *   *           17                             264 167 74                 17                       264
1241974 1241974 MD     school 2400480 15   Montgomery 240048000849 228 Herbert Hoover Middle   Regular School No Middle 06 08 2020   pk_12_total 430 74 89     392     *   59                             1045 430 74 89     392         59                       1045
1245387 1245387 MD     school 2400720 23   Worcester 240072001334 207 Snow Hill High   Regular School No High 09 12 2020   pk_12_total 199 74 17     *         20                             315 199 74 17               20                       315
1246538 1246538 MD     school 2400090 30   Baltimore City 240009001571 332 The Green School of Baltimore   Regular School Yes Elementary KG 05 2020   pk_12_total 57 74 11           *   18                             161 57 74 11               18                       161
1242167 1242167 MD     school 2400480 15   Montgomery 240048001044 321 James Hubert Blake High   Regular School No High 09 12 2020   pk_12_total 285 737 518   * 184         67                             1795 285 737 518     184         67                       1795
1245833 1245833 MD     school 2400090 30   Baltimore City 240009000204 85 Fort Worthington Elementary/Middle   Regular School No Elementary KG 08 2020   pk_12_total 12 736 46   * *         *                             802 12 736 46                                       802
1240521 1240521 MD     school 2400330 10   Frederick 240033001536 716 Urbana Middle   Regular School No Middle 06 08 2020   pk_12_total 548 73 123   * 203     *   67                             1021 548 73 123     203         67                       1021
1240962 1240962 MD     school 2400390 12   Harford 240039001638 187 Patterson Mill High School   Regular School No High 09 12 2020   pk_12_total 600 73 59     54     *   37                             825 600 73 59     54         37                       825
1244681 1244681 MD     school 2400600 18   Saint Mary's 240060001228 301 Leonardtown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 358 73 21     *         34                             494 358 73 21               34                       494
1245836 1245836 MD     school 2400090 30   Baltimore City 240009000265 86 Lakewood Elementary   Regular School No Elementary PK KG 2020   pk_12_total   73 *               *                             83   73                                         83
1246105 1246105 MD     school 2400090 30   Baltimore City 240009000243 215 Highlandtown Elementary/Middle #215   Regular School No Elementary PK 08 2020   pk_12_total * 73 387     *     *   *                             476   73 387                                       476
1244081 1244081 MD     school 2400510 16   Prince George's 240051001475 1510 James Madison Middle   Regular School No Middle 06 08 2020   pk_12_total 17 721 106   * *     *   13                             870 17 721 106               13                       870
1246797 1246797 MD     school 2400090 30   Baltimore City 240009000209 450 Frederick Douglass High   Regular School No High 09 12 2020   pk_12_total * 721 39               *                             769   721 39                                       769
1238062 1238062 MD     school 2400060 2   Anne Arundel 240006000080 4192 Hillsmere Elementary   Regular School No Elementary PK 05 2020   pk_12_total 272 72 59   * *         15                             424 272 72 59               15                       424
1238296 1238296 MD     school 2400120 3   Baltimore County 240012000466 111 Maiden Choice School   Special Education School No Other PK 12 2020   pk_12_total 33 72 *     20         *                             137 33 72       20                                 137
1244381 1244381 MD     school 2400510 16   Prince George's 240051001126 1909 Parkdale High   Regular School No High 09 12 2020   pk_12_total 73 718 1473   * 61     *   18                             2354 73 718 1473     61         18                       2354
1246746 1246746 MD     school 2400090 30   Baltimore City 240009001313 416 Digital Harbor High School   Career and Technical School No High 09 12 2020   pk_12_total 80 715 346   * 13     *   *                             1162 80 715 346     13                                 1162
1239257 1239257 MD     school 2400120 3   Baltimore County 240012000345 1517 Battle Grove Elementary   Regular School No Elementary PK 05 2020   pk_12_total 177 71 53   * *     *   41                             346 177 71 53               41                       346
1239401 1239401 MD     school 2400150 4   Calvert 240015002946 116 Mill Creek Middle   Regular School No Middle 06 08 2020   pk_12_total 356 71 42   * *         42                             517 356 71 42               42                       517
1241201 1241201 MD     school 2400390 12   Harford 240039000707 638 Meadowvale Elementary   Regular School No Elementary PK 05 2020   pk_12_total 341 71 47   * *         54                             518 341 71 47               54                       518
1244190 1244190 MD     school 2400510 16   Prince George's 240051000999 1711 Carole Highlands Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 71 425     10         *                             515   71 425     10                                 515
1244253 1244253 MD     school 2400510 16   Prince George's 240051001573 1731 Rosa L. Parks Elementary   Regular School No Elementary PK 06 2020   pk_12_total 16 71 582     *     *   *                             674 16 71 582                                       674
1244495 1244495 MD     school 2400510 16   Prince George's 240051001063 2107 Hollywood Elementary   Regular School No Elementary PK 05 2020   pk_12_total 42 71 270     64         11                             458 42 71 270     64         11                       458
1244549 1244549 MD     school 2400510 16   Prince George's 240051001049 2141 Greenbelt Middle   Regular School No Middle 06 08 2020   pk_12_total 96 709 540   * 89     *   27                             1468 96 709 540     89         27                       1468
1243498 1243498 MD     school 2400510 16   Prince George's 240051000982 714 Benjamin Tasker Middle School   Regular School No Middle 06 08 2020   pk_12_total 124 708 118   * 48     *   21                             1031 124 708 118     48         21                       1031
1240084 1240084 MD     school 2400270 8   Charles 240027000607 605 Thomas Stone High School   Regular School No High 09 12 2020   pk_12_total 161 703 189   * 15     *   54                             1128 161 703 189     15         54                       1128
1240688 1240688 MD     school 2400330 10   Frederick 240033090473 2302 Hillcrest Elementary   Regular School No Elementary PK 05 2020   pk_12_total 41 70 561     46         31                             749 41 70 561     46         31                       749
1241226 1241226 MD     school 2400420 13   Howard 240042001189 80 Homewood School   Alternative School No High 06 12 2020   pk_12_total 30 70 14   * *         *                             122 30 70 14                                       122
1241318 1241318 MD     school 2400420 13   Howard 240042000744 208 Northfield Elementary   Regular School No Elementary KG 05 2020   pk_12_total 338 70 57   * 177         57                             702 338 70 57     177         57                       702
1242225 1242225 MD     school 2400480 15   Montgomery 240048001747 346 Bayard Rustin Elementary   Regular School No Elementary PK 05 2020   pk_12_total 183 70 209   * 190         64                             719 183 70 209     190         64                       719
1245888 1245888 MD     school 2400090 30   Baltimore City 240009000282 105 Moravia Park Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 698 26   * 10     14   *                             763   698 26     10     14                           763
1243889 1243889 MD     school 2400510 16   Prince George's 240051001472 1326 Kettering Middle   Regular School No Middle 06 08 2020   pk_12_total 11 697 97     *     *   *                             825 11 697 97                                       825
1243445 1243445 MD     school 2400510 16   Prince George's 240051001034 660 Drew Freeman Middle   Regular School No Middle 06 08 2020   pk_12_total 11 693 150   * *     *   *                             868 11 693 150                                       868
1243927 1243927 MD     school 2400510 16   Prince George's 240051001223 1348 Ernest Everett Just Middle   Regular School No Middle 06 08 2020   pk_12_total * 693 60   * *         10                             780   693 60               10                       780
1237779 1237779 MD     school 2400060 2   Anne Arundel 240006000092 3122 Manor View Elementary   Regular School No Elementary 01 05 2020   pk_12_total 114 69 65     *     *   42                             301 114 69 65               42                       301
1238454 1238454 MD     school 2400120 3   Baltimore County 240012001431 252 Northwest Academy of Health Sciences   Regular School No Middle 06 08 2020   pk_12_total 22 687 42   * 17     *   15                             785 22 687 42     17         15                       785
1246402 1246402 MD     school 2400090 30   Baltimore City 240009001390 256 Calvin M. Rodwell Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 681 35   * *         *                             729   681 35                                       729
1244097 1244097 MD     school 2400510 16   Prince George's 240051001697 1518 Barack Obama Elementary   Regular School No Elementary PK 05 2020   pk_12_total 14 680 40     *     *   12                             753 14 680 40               12                       753
1238257 1238257 MD     school 2400120 3   Baltimore County 240012000936 102 Westchester Elementary   Regular School No Elementary PK 05 2020   pk_12_total 457 68 59   * 102         30                             719 457 68 59     102         30                       719
1238653 1238653 MD     school 2400120 3   Baltimore County 240012000350 803 Lutherville Laboratory   Regular School No Elementary KG 05 2020   pk_12_total 186 68 35     50     *   28                             368 186 68 35     50         28                       368
1240749 1240749 MD     school 2400330 10   Frederick 240033000626 2504 Brunswick Elementary   Regular School No Elementary PK 05 2020   pk_12_total 535 68 93   * 17     *   45                             762 535 68 93     17         45                       762
1241832 1241832 MD     school 2400480 15   Montgomery 240048000897 152 Poolesville High   Regular School No High 09 12 2020   pk_12_total 581 68 94   * 397     *   61                             1205 581 68 94     397         61                       1205
1244689 1244689 MD     school 2400600 18   Saint Mary's 240060001216 302 Benjamin Banneker Elementary   Regular School No Elementary PK 05 2020   pk_12_total 481 68 28     *         39                             625 481 68 28               39                       625
1246258 1246258 MD     school 2400090 30   Baltimore City 240009000231 236 Hamilton Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 93 679 58     11     *   22                             864 93 679 58     11         22                       864
1239341 1239341 MD     school 2400120 3   Baltimore County 240012000412 1572 Kenwood High IB and Sports Science   Regular School No High 09 12 2020   pk_12_total 648 677 172   10 40     *   100                             1649 648 677 172   10 40         100                       1649
1240944 1240944 MD     school 2400390 12   Harford 240039000690 176 Edgewood High   Regular School No High 09 12 2020   pk_12_total 466 675 168   * 47     *   95                             1458 466 675 168     47         95                       1458
1245756 1245756 MD     school 2400090 30   Baltimore City 240009000285 66 Mount Royal Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 66 671 23   * *     *   *                             775 66 671 23                                       775
1239209 1239209 MD     school 2400120 3   Baltimore County 240012000384 1508 Essex Elementary   Regular School No Elementary PK 05 2020   pk_12_total 293 67 75   11 17     *   28                             493 293 67 75   11 17         28                       493
1240501 1240501 MD     school 2400330 10   Frederick 240033000652 702 Urbana Elementary   Regular School No Elementary PK 05 2020   pk_12_total 450 67 74   * 164         54                             813 450 67 74     164         54                       813
1241559 1241559 MD     school 2400420 13   Howard 240042001539 528 Dayton Oaks   Regular School No Elementary PK 05 2020   pk_12_total 385 67 39   * 176         51                             720 385 67 39     176         51                       720
1246696 1246696 MD     school 2400090 30   Baltimore City 240009001752 385 Baltimore International Academy West   Regular School Yes Elementary 06 06 2020   pk_12_total   67 *               *                             69   67                                         69
1238607 1238607 MD     school 2400120 3   Baltimore County 240012000390 472 Franklin High   Regular School No High 09 12 2020   pk_12_total 481 667 165   * 109     *   82                             1511 481 667 165     109         82                       1511
1239162 1239162 MD     school 2400120 3   Baltimore County 240012000438 1473 Overlea High   Regular School No High 09 12 2020   pk_12_total 173 665 105   * 28     *   45                             1020 173 665 105     28         45                       1020
1242957 1242957 MD     school 2400480 15   Montgomery 240048000926 798 Springbrook High   Regular School No High 09 12 2020   pk_12_total 107 665 708   * 217         47                             1746 107 665 708     217         47                       1746

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