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,615 ✖
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
1240517 1240517 MD     school 2400330 10   Frederick 240033001429 715 Centerville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 452 99 139   * 206     *   73                             972 452 99 139     206         73                       972
1241306 1241306 MD     school 2400420 13   Howard 240042000753 204 St. Johns Lane Elementary   Regular School No Elementary KG 05 2020   pk_12_total 329 99 43   * 260     *   31                             764 329 99 43     260         31                       764
1242707 1242707 MD     school 2400480 15   Montgomery 240048001456 705 John T. Baker Middle School   Regular School No Middle 06 08 2020   pk_12_total 397 99 239     50     *   43                             830 397 99 239     50         43                       830
1243176 1243176 MD     school 2400510 16   Prince George's 240051001146 210 Rogers Heights Elementary   Regular School No Elementary PK 06 2020   pk_12_total 11 99 692     14     *   *                             820 11 99 692     14                                 820
1245116 1245116 MD     school 2400660 21   Washington 240066001274 1301 Maugansville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 462 99 107     22         59                             749 462 99 107     22         59                       749
1239495 1239495 MD     school 2400150 4   Calvert 240015001505 316 Sunderland Elementary   Regular School No Elementary PK 05 2020   pk_12_total 532 98 24     *         60                             723 532 98 24               60                       723
1241719 1241719 MD     school 2400450 14   Kent 240045000766 402 Kent County Middle School   Regular School No Middle 06 08 2020   pk_12_total 251 98 41   * *         27                             421 251 98 41               27                       421
1241885 1241885 MD     school 2400480 15   Montgomery 240048000840 204 Garrett Park Elementary   Regular School No Elementary PK 05 2020   pk_12_total 310 98 193   * 132     *   65                             802 310 98 193     132         65                       802
1242797 1242797 MD     school 2400480 15   Montgomery 240048000873 770 Flora M. Singer Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 230 98 255   * 45         53                             683 230 98 255     45         53                       683
1246807 1246807 MD     school 2400090 30   Baltimore City 240009000150 480 Baltimore City College   Regular School No High 09 12 2020   pk_12_total 254 970 126   * 24     *   21                             1402 254 970 126     24         21                       1402
1238236 1238236 MD     school 2400120 3   Baltimore County 240012001649 75 Crossroads Center   Alternative School No High 07 12 2020   pk_12_total 58 97 *   * *         16                             183 58 97                 16                       183
1238546 1238546 MD     school 2400120 3   Baltimore County 240012000388 403 Franklin Elementary   Regular School No Elementary PK 05 2020   pk_12_total 228 97 47     28         19                             419 228 97 47     28         19                       419
1239532 1239532 MD     school 2400180 5   Caroline 240018000526 302 Lockerman Middle School   Regular School No Middle 06 08 2020   pk_12_total 591 97 179     *         73                             949 591 97 179               73                       949
1240672 1240672 MD     school 2400330 10   Frederick 240033000661 2103 Yellow Springs Elementary   Regular School No Elementary KG 05 2020   pk_12_total 275 97 41   * 19     *   32                             470 275 97 41     19         32                       470
1241113 1241113 MD     school 2400390 12   Harford 240039001380 385 C. Milton Wright High   Regular School No High 09 12 2020   pk_12_total 1059 97 68   * 82     *   51                             1363 1059 97 68     82         51                       1363
1239570 1239570 MD     school 2400180 5   Caroline 240018000519 802 Colonel Richardson Middle School   Regular School No Middle 06 08 2020   pk_12_total 260 96 31   * *         35                             432 260 96 31               35                       432
1241322 1241322 MD     school 2400420 13   Howard 240042000748 209 Patapsco Middle   Regular School No Middle 06 08 2020   pk_12_total 306 96 77     247     *   17                             746 306 96 77     247         17                       746
1238476 1238476 MD     school 2400120 3   Baltimore County 240012000458 272 Randallstown High   Regular School No High 09 12 2020   pk_12_total 14 951 44   * 23         15                             1048 14 951 44     23         15                       1048
1239201 1239201 MD     school 2400120 3   Baltimore County 240012000360 1507 Chase Elementary   Regular School No Elementary PK 05 2020   pk_12_total 210 95 47   * *     *   42                             398 210 95 47               42                       398
1239425 1239425 MD     school 2400150 4   Calvert 240015000517 207 Calvert Elementary   Regular School No Elementary PK 05 2020   pk_12_total 326 95 27   * *         63                             516 326 95 27               63                       516
1242501 1242501 MD     school 2400480 15   Montgomery 240048000943 552 Washington Grove Elementary   Regular School No Elementary PK 05 2020   pk_12_total 37 95 292     24     *   13                             462 37 95 292     24         13                       462
1246326 1246326 MD     school 2400090 30   Baltimore City 240009000268 245 Leith Walk Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 945 60     *     *   *                             1023   945 60                                       1023
1238939 1238939 MD     school 2400120 3   Baltimore County 240012001750 1113 Honeygo Elementary   Regular School No Elementary PK 05 2020   pk_12_total 366 94 33   * 138     *   45                             680 366 94 33     138         45                       680
1243749 1243749 MD     school 2400510 16   Prince George's 240051001042 1214 Glassmanor Elementary   Regular School No Elementary KG 05 2020   pk_12_total * 94 223                                             319   94 223                                       319
1244372 1244372 MD     school 2400510 16   Prince George's 240051000975 1907 Beacon Heights Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 94 352   * *         *                             461   94 352                                       461
1237909 1237909 MD     school 2400060 2   Anne Arundel 240006001517 3362 Crofton Meadows Elementary   Regular School No Elementary KG 05 2020   pk_12_total 321 93 56     29         55                             554 321 93 56     29         55                       554
1241546 1241546 MD     school 2400420 13   Howard 240042001115 526 Lime Kiln Middle   Regular School No Middle 06 08 2020   pk_12_total 313 93 26   * 176         50                             660 313 93 26     176         50                       660
1242381 1242381 MD     school 2400480 15   Montgomery 240048000868 505 Lucy V. Barnsley Elementary   Regular School No Elementary KG 05 2020   pk_12_total 243 93 254   * 88         57                             737 243 93 254     88         57                       737
1238683 1238683 MD     school 2400120 3   Baltimore County 240012090440 810 Padonia International Elementary   Regular School No Elementary PK 05 2020   pk_12_total 53 92 259   * 98         21                             524 53 92 259     98         21                       524
1242592 1242592 MD     school 2400480 15   Montgomery 240048000829 566 Fields Road Elementary   Regular School No Elementary PK 05 2020   pk_12_total 131 92 169     65         30                             487 131 92 169     65         30                       487
1243544 1243544 MD     school 2400510 16   Prince George's 240051000973 802 Baden Elementary   Regular School No Elementary PK 06 2020   pk_12_total 51 92 48   *           16                             209 51 92 48               16                       209
1237445 1237445 MD     school 2400060 2   Anne Arundel 240006000102 1172 North Glen Elementary   Regular School No Elementary PK 05 2020   pk_12_total 87 91 82     14         31                             305 87 91 82     14         31                       305
1237533 1237533 MD     school 2400060 2   Anne Arundel 240006000072 2033 George Fox Middle   Regular School No Middle 06 08 2020   pk_12_total 626 91 85   * 18     *   55                             884 626 91 85     18         55                       884
1242789 1242789 MD     school 2400480 15   Montgomery 240048000888 769 Oakland Terrace Elementary   Regular School No Elementary PK 05 2020   pk_12_total 184 91 185     24         47                             531 184 91 185     24         47                       531
1245382 1245382 MD     school 2400720 23   Worcester 240072001332 205 Snow Hill Elementary   Regular School No Elementary PK 03 2020   pk_12_total 239 91 19   * *         30                             383 239 91 19               30                       383
1244070 1244070 MD     school 2400510 16   Prince George's 240051001036 1502 Frederick Douglass High   Regular School No High 09 12 2020   pk_12_total 16 905 68   * *     *   36                             1033 16 905 68               36                       1033
1240586 1240586 MD     school 2400330 10   Frederick 240033001165 919 Oakdale Elementary   Regular School No Elementary KG 05 2020   pk_12_total 503 89 73   * 95     *   25                             792 503 89 73     95         25                       792
1244151 1244151 MD     school 2400510 16   Prince George's 240051001110 1703 Mt Rainier Elementary   Regular School No Elementary PK 06 2020   pk_12_total 46 89 204     *         *                             350 46 89 204                                       350
1244698 1244698 MD     school 2400600 18   Saint Mary's 240060001229 305 Leonardtown Middle   Regular School No Middle 06 08 2020   pk_12_total 782 89 52   * 25     *   72                             1024 782 89 52     25         72                       1024
1238931 1238931 MD     school 2400120 3   Baltimore County 240012000397 1111 Gunpowder Elementary   Regular School No Elementary KG 05 2020   pk_12_total 342 88 12   * 67     *   26                             538 342 88 12     67         26                       538
1243527 1243527 MD     school 2400510 16   Prince George's 240051001384 723 C. Elizabeth Rieg Regional Center   Special Education School No Other KG 12 2020   pk_12_total 13 88 12     *                                       115 13 88 12                                       115
1238854 1238854 MD     school 2400120 3   Baltimore County 240012000443 972 Parkville High & Center for Math/Science   Regular School No High 09 12 2020   pk_12_total 460 873 492   10 162     *   74                             2074 460 873 492   10 162         74                       2074
1239376 1239376 MD     school 2400150 4   Calvert 240015001392 111 Southern Middle   Regular School No Middle 06 08 2020   pk_12_total 315 87 43     *         46                             495 315 87 43               46                       495
1239507 1239507 MD     school 2400150 4   Calvert 240015000967 318 Windy Hill Middle   Regular School No Middle 06 08 2020   pk_12_total 557 87 48   * 12     *   82                             789 557 87 48     12         82                       789
1240153 1240153 MD     school 2400270 8   Charles 240027000144 619 Westlake High School   Regular School No High 09 12 2020   pk_12_total 74 866 91   * 45     *   59                             1140 74 866 91     45         59                       1140
1244205 1244205 MD     school 2400510 16   Prince George's 240051001139 1713 Cesar Chavez Elementary   Regular School No Elementary KG 05 2020   pk_12_total 41 86 219   * *     *                                 354 41 86 219                                       354
1244761 1244761 MD     school 2400600 18   Saint Mary's 240060001685 606 Evergreen Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 515 86 100   * 35     *   75                             813 515 86 100     35         75                       813
1245823 1245823 MD     school 2400090 30   Baltimore City 240009000323 84 Thomas Johnson Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 381 86 44     *     *   32                             548 381 86 44               32                       548
1243733 1243733 MD     school 2400510 16   Prince George's 240051001123 1209 Oxon Hill High   Regular School No High 09 12 2020   pk_12_total 31 859 451   * 114     *   31                             1497 31 859 451     114         31                       1497
1246802 1246802 MD     school 2400090 30   Baltimore City 240009000168 454 Carver Vocational-Technical High   Career and Technical School No High 09 12 2020   pk_12_total * 859 13   * *         *                             885   859 13                                       885
1241358 1241358 MD     school 2400420 13   Howard 240042000173 216 Burleigh Manor Middle School   Regular School No Middle 06 08 2020   pk_12_total 242 85 34   * 404         41                             811 242 85 34     404         41                       811
1241503 1241503 MD     school 2400420 13   Howard 240042001382 520 Clemens Crossing Elementary   Regular School No Elementary KG 05 2020   pk_12_total 248 85 49   * 80     *   44                             508 248 85 49     80         44                       508
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

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