enrollments

Data source: Big Local News · About: Big Local

9,615 rows where state = "MD" and year = 2020 sorted by white 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
1237529 1237529 MD     school 2400060 2   Anne Arundel 240006000103 2023 Northeast High   Regular School No High 09 12 2020   pk_12_total 996 123 133   * 34     *   72                             1367 996 123 133     34         72                       1367
1240021 1240021 MD     school 2400240 7   Cecil 240024090469 905 Rising Sun High   Regular School No High 09 12 2020   pk_12_total 990 * 59   * 11         28                             1100 990   59     11         28                       1100
1241617 1241617 MD     school 2400420 13   Howard 240042000756 609 Talbott Springs Elementary   Regular School No Elementary PK 05 2020   pk_12_total 99 205 141   * 25         38                             509 99 205 141     25         38                       509
1242162 1242162 MD     school 2400480 15   Montgomery 240048000929 316 Stonegate Elementary   Regular School No Elementary KG 05 2020   pk_12_total 99 162 117   * 73     *   48                             501 99 162 117     73         48                       501
1243482 1243482 MD     school 2400510 16   Prince George's 240051001077 708 Kenilworth Elementary   Regular School No Elementary KG 05 2020   pk_12_total 99 182 63     20     *   22                             387 99 182 63     20         22                       387
1242346 1242346 MD     school 2400480 15   Montgomery 240048009000 428 Thomas W. Pyle Middle School   Regular School No Middle 06 08 2020   pk_12_total 987 49 163   * 214     *   118                             1534 987 49 163     214         118                       1534
1244633 1244633 MD     school 2400540 17   Queen Anne's 240054001076 405 Kent Island High School   Regular School No High 09 12 2020   pk_12_total 985 66 76   * 27     *   60                             1221 985 66 76     27         60                       1221
1238586 1238586 MD     school 2400120 3   Baltimore County 240012000356 408 Cedarmere Elementary   Regular School No Elementary PK 05 2020   pk_12_total 98 209 165   * 45     *   19                             539 98 209 165     45         19                       539
1242036 1242036 MD     school 2400480 15   Montgomery 240048000819 241 DuFief Elementary   Regular School No Elementary KG 05 2020   pk_12_total 98 46 41     100     *   30                             316 98 46 41     100         30                       316
1238724 1238724 MD     school 2400120 3   Baltimore County 240012000373 872 Dulaney High   Regular School No High 09 12 2020   pk_12_total 979 393 199   * 257     *   79                             1914 979 393 199     257         79                       1914
1240473 1240473 MD     school 2400330 10   Frederick 240033000641 313 Middletown High   Regular School No High 09 12 2020   pk_12_total 970 19 70   * 26         42                             1129 970 19 70     26         42                       1129
1241649 1241649 MD     school 2400420 13   Howard 240042001699 616 Cradlerock Elementary   Regular School No Elementary PK 05 2020   pk_12_total 97 231 88   * 36         44                             497 97 231 88     36         44                       497
1241786 1241786 MD     school 2400480 15   Montgomery 240048001417 107 Martin Luther King Jr. Middle   Regular School No Middle 06 08 2020   pk_12_total 97 257 267   * 96         46                             764 97 257 267     96         46                       764
1242761 1242761 MD     school 2400480 15   Montgomery 240048000893 761 Pine Crest Elementary   Regular School No Elementary 03 05 2020   pk_12_total 97 103 171     18         24                             413 97 103 171     18         24                       413
1243008 1243008 MD     school 2400480 15   Montgomery 240048000891 812 Parkland Middle   Regular School No Middle 06 08 2020   pk_12_total 97 247 599   * 164         30                             1141 97 247 599     164         30                       1141
1243013 1243013 MD     school 2400480 15   Montgomery 240048000855 815 John F. Kennedy High   Regular School No High 09 12 2020   pk_12_total 97 452 1116   * 124         26                             1817 97 452 1116     124         26                       1817
1238127 1238127 MD     school 2400060 2   Anne Arundel 240006000054 4283 Central Middle   Regular School No Middle 06 08 2020   pk_12_total 962 57 162   * 43     *   55                             1284 962 57 162     43         55                       1284
1240591 1240591 MD     school 2400330 10   Frederick 240033001688 920 Oakdale High   Regular School No High 09 12 2020   pk_12_total 961 63 116   * 68         54                             1267 961 63 116     68         54                       1267
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
1242366 1242366 MD     school 2400480 15   Montgomery 240048000921 503 Sherwood High   Regular School No High 09 12 2020   pk_12_total 957 312 371     224     *   99                             1964 957 312 371     224         99                       1964
1238943 1238943 MD     school 2400120 3   Baltimore County 240012000447 1151 Perry Hall Middle   Regular School No Middle 06 08 2020   pk_12_total 954 491 93   * 295     *   82                             1925 954 491 93     295         82                       1925
1240206 1240206 MD     school 2400270 8   Charles 240027001757 627 Billingsley Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 95 480 61   * 26     *   61                             725 95 480 61     26         61                       725
1242065 1242065 MD     school 2400480 15   Montgomery 240048000644 248 Forest Oak Middle   Regular School No Middle 06 08 2020   pk_12_total 95 228 547   * 52     *   26                             950 95 228 547     52         26                       950
1239668 1239668 MD     school 2400210 6   Carroll 240021001161 510 Century High   Regular School No High 09 12 2020   pk_12_total 945 50 73   * 40     *   27                             1139 945 50 73     40         27                       1139
1240186 1240186 MD     school 2400270 8   Charles 240027001565 624 William A. Diggs Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 94 523 58     30     *   66                             775 94 523 58     30         66                       775
1241459 1241459 MD     school 2400420 13   Howard 240042000720 510 Bryant Woods Elementary   Regular School No Elementary PK 05 2020   pk_12_total 94 244 56   * 15     *   37                             448 94 244 56     15         37                       448
1241634 1241634 MD     school 2400420 13   Howard 240042000749 612 Phelps Luck Elementary   Regular School No Elementary PK 05 2020   pk_12_total 94 218 230   * 40         50                             633 94 218 230     40         50                       633
1242155 1242155 MD     school 2400480 15   Montgomery 240048000890 315 Paint Branch High   Regular School No High 09 12 2020   pk_12_total 94 1187 420   * 240         53                             1996 94 1187 420     240         53                       1996
1238948 1238948 MD     school 2400120 3   Baltimore County 240012000446 1171 Perry Hall High   Regular School No High 09 12 2020   pk_12_total 939 591 93   * 255     *   85                             1969 939 591 93     255         85                       1969
1241083 1241083 MD     school 2400390 12   Harford 240039000717 348 Youths Benefit Elementary   Regular School No Elementary KG 05 2020   pk_12_total 939 14 40   * 24     *   34                             1057 939 14 40     24         34                       1057
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
1238054 1238054 MD     school 2400060 2   Anne Arundel 240006000074 4182 Germantown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 93 119 287   * *         *                             512 93 119 287                                       512
1238570 1238570 MD     school 2400120 3   Baltimore County 240012000460 406 Reisterstown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 93 242 161   * 36         31                             564 93 242 161     36         31                       564
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
1238346 1238346 MD     school 2400120 3   Baltimore County 240012000355 174 Catonsville High   Regular School No High 09 12 2020   pk_12_total 929 462 110   * 223     *   95                             1826 929 462 110     223         95                       1826
1240210 1240210 MD     school 2400270 8   Charles 240027000599 701 Matthew Henson Middle School   Regular School No Middle 06 08 2020   pk_12_total 92 552 80   * 19     *   64                             811 92 552 80     19         64                       811
1242529 1242529 MD     school 2400480 15   Montgomery 240048000875 556 Mill Creek Towne Elementary   Regular School No Elementary PK 05 2020   pk_12_total 92 100 206   * 66     *   39                             506 92 100 206     66         39                       506
1243639 1243639 MD     school 2400510 16   Prince George's 240051000988 1011 Bond Mill Elementary   Regular School No Elementary KG 05 2020   pk_12_total 92 238 100   * 39     *   32                             507 92 238 100     39         32                       507
1245268 1245268 MD     school 2400690 22   Wicomico 240069001304 515 Glen Avenue School   Regular School No Elementary 02 05 2020   pk_12_total 92 246 41   * *     *   26                             416 92 246 41               26                       416
1237514 1237514 MD     school 2400060 2   Anne Arundel 240006000094 1274 Marley Glen School   Special Education School No Other PK 11 2020   pk_12_total 91 32 15   * 11     *   *                             160 91 32 15     11                                 160
1241161 1241161 MD     school 2400390 12   Harford 240039000685 518 Darlington Elementary   Regular School No Elementary KG 05 2020   pk_12_total 91 * *     *         *                             104 91                                           104
1241496 1241496 MD     school 2400420 13   Howard 240042000737 518 Harpers Choice Middle   Regular School No Middle 06 08 2020   pk_12_total 91 236 80   * 36         47                             493 91 236 80     36         47                       493
1244030 1244030 MD     school 2400510 16   Prince George's 240051001152 1428 Samuel Ogle Middle   Regular School No Middle 06 08 2020   pk_12_total 91 554 172   * 41     *   22                             885 91 554 172     41         22                       885
1238578 1238578 MD     school 2400120 3   Baltimore County 240012001346 407 Glyndon Elementary   Regular School No Elementary PK 05 2020   pk_12_total 90 313 81   * 28     *   42                             559 90 313 81     28         42                       559
1241802 1241802 MD     school 2400480 15   Montgomery 240048001508 109 Waters Landing Elementary   Regular School No Elementary PK 05 2020   pk_12_total 90 265 248   * 29         25                             659 90 265 248     29         25                       659
1237706 1237706 MD     school 2400060 2   Anne Arundel 240006000042 2423 Chesapeake Bay Middle   Regular School No Middle 06 08 2020   pk_12_total 898 44 61   * 14         31                             1056 898 44 61     14         31                       1056
1241299 1241299 MD     school 2400420 13   Howard 240042000738 203 Howard High   Regular School No High 09 12 2020   pk_12_total 898 423 133   * 323     *   126                             1910 898 423 133     323         126                       1910
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
1240148 1240148 MD     school 2400270 8   Charles 240027001519 618 William B. Wade Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 89 407 71   * 42         74                             686 89 407 71     42         74                       686
1243607 1243607 MD     school 2400510 16   Prince George's 240051001701 917 Imagine Andrews Public Charter   Regular School Yes Elementary KG 08 2020   pk_12_total 89 303 31   * 17     *   17                             464 89 303 31     17         17                       464
1244940 1244940 MD     school 2400630 20   Talbot 240063001250 501 Tilghman Elementary   Regular School No Elementary PK 05 2020   pk_12_total 89   *               *                             101 89                                           101
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
1239836 1239836 MD     school 2400210 6   Carroll 240021000546 1401 South Carroll High   Regular School No High 09 12 2020   pk_12_total 881 18 68   * 22     *   17                             1011 881 18 68     22         17                       1011
1242003 1242003 MD     school 2400480 15   Montgomery 240048000934 234 Thomas S. Wootton High   Regular School No High 09 12 2020   pk_12_total 881 176 169   * 787     *   101                             2116 881 176 169     787         101                       2116
1241694 1241694 MD     school 2400420 13   Howard 240042000860 624 Murray Hill Middle   Regular School No Middle 06 08 2020   pk_12_total 88 320 155   * 118     *   50                             733 88 320 155     118         50                       733
1244130 1244130 MD     school 2400510 16   Prince George's 240051001064 1601 Hyattsville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 88 120 279   * *         *                             508 88 120 279                                       508
1241420 1241420 MD     school 2400420 13   Howard 240042000731 404 Glenelg High   Regular School No High 09 12 2020   pk_12_total 879 46 59   * 156     *   54                             1197 879 46 59     156         54                       1197
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
1242752 1242752 MD     school 2400480 15   Montgomery 240048000821 756 East Silver Spring Elementary   Regular School No Elementary PK 05 2020   pk_12_total 87 266 109   * 13     *   19                             497 87 266 109     13         19                       497
1244798 1244798 MD     school 2400600 18   Saint Mary's 240060001483 805 George Washington Carver Elementary   Regular School No Elementary PK 05 2020   pk_12_total 87 317 125   * *     *   59                             598 87 317 125               59                       598
1239651 1239651 MD     school 2400210 6   Carroll 240021001394 507 Liberty High   Regular School No High 09 12 2020   pk_12_total 861 44 54   * 43     *   33                             1044 861 44 54     43         33                       1044
1240328 1240328 MD     school 2400300 9   Dorchester 240030000617 711 Maple Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 86 265 68     13         46                             478 86 265 68     13         46                       478
1240380 1240380 MD     school 2400330 10   Frederick 240033000649 204 Lincoln Elementary   Regular School No Elementary PK 05 2020   pk_12_total 86 216 218   * 20         55                             598 86 216 218     20         55                       598
1241185 1241185 MD     school 2400390 12   Harford 240039000709 583 North Harford Middle   Regular School No Middle 06 08 2020   pk_12_total 851 * 20   * 11     *   33                             929 851   20     11         33                       929
1241641 1241641 MD     school 2400420 13   Howard 240042000740 613 Jeffers Hill Elementary   Regular School No Elementary KG 05 2020   pk_12_total 85 163 90     40         36                             414 85 163 90     40         36                       414
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
1239955 1239955 MD     school 2400240 7   Cecil 240024000575 514 North East High   Regular School No High 09 12 2020   pk_12_total 840 62 55   * 12         42                             1016 840 62 55     12         42                       1016
1242434 1242434 MD     school 2400480 15   Montgomery 240048090479 514 Judith A. Resnik Elementary   Regular School No Elementary PK 05 2020   pk_12_total 84 175 251   * 63         28                             602 84 175 251     63         28                       602
1242608 1242608 MD     school 2400480 15   Montgomery 240048001512 569 Strawberry Knoll Elementary   Regular School No Elementary PK 05 2020   pk_12_total 84 168 284   * 73         40                             651 84 168 284     73         40                       651
1238719 1238719 MD     school 2400120 3   Baltimore County 240012001422 855 Hereford Middle   Regular School No Middle 06 08 2020   pk_12_total 839 21 38     40         34                             972 839 21 38     40         34                       972
1241108 1241108 MD     school 2400390 12   Harford 240039000691 382 Fallston High   Regular School No High 09 12 2020   pk_12_total 839 39 36   * 21     *   35                             973 839 39 36     21         35                       973
1243995 1243995 MD     school 2400510 16   Prince George's 240051001245 1416 Dora Kennedy French Immersion   Regular School No Elementary KG 08 2020   pk_12_total 83 505 43   * 22         22                             676 83 505 43     22         22                       676
1239043 1239043 MD     school 2400120 3   Baltimore County 240012000444 1272 Patapsco High & Center for Arts   Regular School No High 09 12 2020   pk_12_total 820 331 148   15 15     *   104                             1434 820 331 148   15 15         104                       1434
1244134 1244134 MD     school 2400510 16   Prince George's 240051001065 1602 Hyattsville Middle   Regular School No Middle 06 08 2020   pk_12_total 82 237 567   * 11     *   *                             909 82 237 567     11                                 909
1241827 1241827 MD     school 2400480 15   Montgomery 240048001509 125 Quince Orchard High   Regular School No High 09 12 2020   pk_12_total 818 351 607   * 278     *   91                             2148 818 351 607     278         91                       2148
1237361 1237361 MD     school 2400060 2   Anne Arundel 240006000075 1033 Glen Burnie High   Regular School No High 09 12 2020   pk_12_total 812 624 420   * 86     *   120                             2076 812 624 420     86         120                       2076
1239587 1239587 MD     school 2400210 6   Carroll 240021000533 202 Francis Scott Key High   Regular School No High 09 12 2020   pk_12_total 811 31 39   * *     *   28                             922 811 31 39               28                       922
1241117 1241117 MD     school 2400390 12   Harford 240039090475 386 Fallston Middle School   Regular School No Middle 06 08 2020   pk_12_total 808 29 30   * 25         38                             934 808 29 30     25         38                       934
1245049 1245049 MD     school 2400660 21   Washington 240066001256 601 Boonsboro High   Regular School No High 09 12 2020   pk_12_total 807 12 30   * 21         31                             902 807 12 30     21         31                       902
1238147 1238147 MD     school 2400060 2   Anne Arundel 240006000056 4304 Central Special School   Special Education School No Other PK 12 2020   pk_12_total 80 32 23     *         *                             148 80 32 23                                       148
1244846 1244846 MD     school 2400570 19   Somerset 240057001743 107 Greenwood Elementary School   Regular School No Elementary 02 05 2020   pk_12_total 80 318 36   * *         26                             468 80 318 36               26                       468
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
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
1239193 1239193 MD     school 2400120 3   Baltimore County 240012000425 1506 Martin Boulevard Elementary   Regular School No Elementary PK 05 2020   pk_12_total 79 118 57   * *     *   39                             298 79 118 57               39                       298
1241810 1241810 MD     school 2400480 15   Montgomery 240048010502 110 S. Christa McAuliffe Elementary   Regular School No Elementary PK 05 2020   pk_12_total 79 209 186   * 38     *   37                             554 79 209 186     38         37                       554
1242781 1242781 MD     school 2400480 15   Montgomery 240048000844 767 Glen Haven Elementary   Regular School No Elementary PK 05 2020   pk_12_total 79 114 257   * 34     *   24                             511 79 114 257     34         24                       511
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
1246509 1246509 MD     school 2400090 30   Baltimore City 240009001478 326 City Neighbors Charter School   Regular School Yes Elementary KG 08 2020   pk_12_total 78 144 *               *                             231 78 144                                         231
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
1238602 1238602 MD     school 2400120 3   Baltimore County 240012001347 452 Owings Mills High   Regular School No High 09 12 2020   pk_12_total 77 642 385   * 54     *   25                             1189 77 642 385     54         25                       1189
1240320 1240320 MD     school 2400300 9   Dorchester 240030000621 710 Sandy Hill Elementary   Regular School No Elementary PK 05 2020   pk_12_total 77 241 35     *         34                             395 77 241 35               34                       395
1242584 1242584 MD     school 2400480 15   Montgomery 240048090456 565 Sequoyah Elementary   Regular School No Elementary KG 05 2020   pk_12_total 77 47 188     43         21                             376 77 47 188     43         21                       376
1246590 1246590 MD     school 2400090 30   Baltimore City 240009001680 346 City Neighbors Hamilton   Regular School Yes Elementary KG 08 2020   pk_12_total 77 126 11   * *         16                             234 77 126 11               16                       234
1237392 1237392 MD     school 2400060 2   Anne Arundel 240006000066 1102 Ferndale Early Education Center   Regular School No Elementary PK KG 2020   pk_12_total 76 33 28   * *         *                             151 76 33 28                                       151
1241567 1241567 MD     school 2400420 13   Howard 240042000733 602 Guilford Elementary   Regular School No Elementary PK 05 2020   pk_12_total 76 230 65     74         30                             475 76 230 65     74         30                       475
1246711 1246711 MD     school 2400090 30   Baltimore City 240009000297 405 Patterson High   Career and Technical School No High 09 12 2020   pk_12_total 76 549 524   * *         10                             1174 76 549 524               10                       1174
1241069 1241069 MD     school 2400390 12   Harford 240039000701 335 Homestead/Wakefield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 753 59 75   * 69     *   75                             1034 753 59 75     69         75                       1034
1240038 1240038 MD     school 2400270 8   Charles 240027000596 106 La Plata High School   Regular School No High 09 12 2020   pk_12_total 750 225 57   * 33     *   88                             1159 750 225 57     33         88                       1159
1240598 1240598 MD     school 2400330 10   Frederick 240033000648 1001 Sabillasville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 75 * *               *                             82 75                                           82
1242773 1242773 MD     school 2400480 15   Montgomery 240048000887 766 Oak View Elementary   Regular School No Elementary 03 05 2020   pk_12_total 75 51 277     10         10                             423 75 51 277     10         10                       423

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