enrollments

Data source: Big Local News · About: Big Local

19,213 rows where state = "MD" sorted by white descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

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
1313019 1313019 MD     school 2400330 10   Frederick 240033000641 313 Middletown High   Regular School No High 09 12 2021   pk_12_total 992 22 74   * 17     *   40                             1149 992 22 74     17         40                       1149
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
1311805 1311805 MD     school 2400120 3   Baltimore County 240012000401 1515 Hawthorne Elementary   Regular School No Elementary PK 05 2021   pk_12_total 99 249 42   * *         43                             442 99 249 42               43                       442
1310691 1310691 MD     school 2400060 2   Anne Arundel 240006000054 4283 Central Middle   Regular School No Middle 06 08 2021   pk_12_total 988 61 173   * 48     *   69                             1345 988 61 173     48         69                       1345
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
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
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
1310330 1310330 MD     school 2400060 2   Anne Arundel 240006000078 3102 Hebron - Harman Elementary   Regular School No Elementary PK 05 2021   pk_12_total 98 285 161   * 75     *   64                             687 98 285 161     75         64                       687
1317458 1317458 MD     school 2400570 19   Somerset 240057001202 1401 Deal Island School   Regular School No Elementary PK 05 2021   pk_12_total 98 * *     *         *                             121 98                                           121
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
1310091 1310091 MD     school 2400060 2   Anne Arundel 240006000103 2023 Northeast High   Regular School No High 09 12 2021   pk_12_total 979 135 141   * 28     *   73                             1364 979 135 141     28         73                       1364
1312569 1312569 MD     school 2400240 7   Cecil 240024090469 905 Rising Sun High   Regular School No High 09 12 2021   pk_12_total 972 * 58   * *         27                             1076 972   58               27                       1076
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
1317074 1317074 MD     school 2400510 16   Prince George's 240051000512 2106 Greenbelt Elementary   Regular School No Elementary PK 05 2021   pk_12_total 97 319 75   * 42         15                             550 97 319 75     42         15                       550
1310081 1310081 MD     school 2400060 2   Anne Arundel 240006090441 1323 North County High   Regular School No High 09 12 2021   pk_12_total 963 634 463   * 118     *   138                             2327 963 634 463     118         138                       2327
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
1310618 1310618 MD     school 2400060 2   Anne Arundel 240006000074 4182 Germantown Elementary   Regular School No Elementary PK 05 2021   pk_12_total 96 107 271   * *         *                             485 96 107 271                                       485
1310721 1310721 MD     school 2400060 2   Anne Arundel 240006001724 6113 Monarch Global Academy PCS Laurel Campus   Regular School No Elementary KG 08 2021   pk_12_total 96 454 193   * 43     *   38                             828 96 454 193     43         38                       828
1311619 1311619 MD     school 2400120 3   Baltimore County 240012000344 1307 Baltimore Highlands Elementary   Regular School No Elementary PK 05 2021   pk_12_total 96 105 223   * *         33                             469 96 105 223               33                       469
1314758 1314758 MD     school 2400480 15   Montgomery 240048001673 337 William B. Gibbs, Jr. Elementary   Regular School No Elementary PK 05 2021   pk_12_total 96 155 113     151         36                             551 96 155 113     151         36                       551
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
1317211 1317211 MD     school 2400540 17   Queen Anne's 240054001076 405 Kent Island High School   Regular School No High 09 12 2021   pk_12_total 952 56 78     23     *   62                             1174 952 56 78     23         62                       1174
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
1312927 1312927 MD     school 2400330 10   Frederick 240033000649 204 Lincoln Elementary   Regular School No Elementary PK 05 2021   pk_12_total 95 213 213   * 22         59                             605 95 213 213     22         59                       605
1315245 1315245 MD     school 2400480 15   Montgomery 240048000876 652 Monocacy Elementary   Regular School No Elementary PK 05 2021   pk_12_total 95 * 21     *         *                             136 95   21                                       136
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
1316062 1316062 MD     school 2400510 16   Prince George's 240051001077 708 Kenilworth Elementary   Regular School No Elementary KG 05 2021   pk_12_total 95 186 53     21     *   18                             375 95 186 53     21         18                       375
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
1313639 1313639 MD     school 2400390 12   Harford 240039000717 348 Youths Benefit Elementary   Regular School No Elementary PK 05 2021   pk_12_total 942 22 44   * 27     *   37                             1082 942 22 44     27         37                       1082
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
1315418 1315418 MD     school 2400480 15   Montgomery 240048000878 776 Montgomery Knolls Elementary   Regular School No Elementary PK 02 2021   pk_12_total 94 127 215     25         29                             490 94 127 215     25         29                       490
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
1314936 1314936 MD     school 2400480 15   Montgomery 240048000921 503 Sherwood High   Regular School No High 09 12 2021   pk_12_total 938 290 363     225         96                             1912 938 290 363     225         96                       1912
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
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
1314915 1314915 MD     school 2400480 15   Montgomery 240048009000 428 Thomas W. Pyle Middle School   Regular School No Middle 06 08 2021   pk_12_total 931 41 149     214     *   97                             1433 931 41 149     214         97                       1433
1311279 1311279 MD     school 2400120 3   Baltimore County 240012000373 872 Dulaney High   Regular School No High 09 12 2021   pk_12_total 930 438 221   * 248     *   87                             1930 930 438 221     248         87                       1930
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
1315593 1315593 MD     school 2400480 15   Montgomery 240048000855 815 John F. Kennedy High   Regular School No High 09 12 2021   pk_12_total 93 416 1137   * 117         22                             1788 93 416 1137     117         22                       1788
1318820 1318820 MD     school 2400090 30   Baltimore City 240009000231 236 Hamilton Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 93 673 50   * 10     *   26                             854 93 673 50     10         26                       854
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
1310900 1310900 MD     school 2400120 3   Baltimore County 240012000355 174 Catonsville High   Regular School No High 09 12 2021   pk_12_total 929 443 100   * 233     *   94                             1809 929 443 100     233         94                       1809
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
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
1312859 1312859 MD     school 2400300 9   Dorchester 240030001423 707 Mace's Lane Middle School   Regular School No Middle 06 08 2021   pk_12_total 92 405 63     *     *   36                             603 92 405 63               36                       603
1313429 1313429 MD     school 2400390 12   Harford 240039000688 115 Edgewood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 92 190 39   * *     *   21                             349 92 190 39               21                       349
1314051 1314051 MD     school 2400420 13   Howard 240042000737 518 Harpers Choice Middle   Regular School No Middle 06 08 2021   pk_12_total 92 241 74   * 38     *   43                             490 92 241 74     38         43                       490
1312218 1312218 MD     school 2400210 6   Carroll 240021001161 510 Century High   Regular School No High 09 12 2021   pk_12_total 919 53 79   * 52     *   27                             1135 919 53 79     52         27                       1135
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
1310268 1310268 MD     school 2400060 2   Anne Arundel 240006000042 2423 Chesapeake Bay Middle   Regular School No Middle 06 08 2021   pk_12_total 908 31 60   * 15         43                             1062 908 31 60     15         43                       1062
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
1311503 1311503 MD     school 2400120 3   Baltimore County 240012000446 1171 Perry Hall High   Regular School No High 09 12 2021   pk_12_total 904 659 107   * 256     *   85                             2018 904 659 107     256         85                       2018
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
1313845 1313845 MD     school 2400420 13   Howard 240042001749 111 Hanover Hills   Regular School No Elementary PK 05 2021   pk_12_total 90 319 117   * 198         43                             774 90 319 117     198         43                       774
1314316 1314316 MD     school 2400480 15   Montgomery 240048000804 101 Clarksburg Elementary   Regular School No Elementary PK 05 2021   pk_12_total 90 190 115   * 242     *   51                             690 90 190 115     242         51                       690
1316576 1316576 MD     school 2400510 16   Prince George's 240051001245 1416 Dora Kennedy French Immersion   Regular School No Elementary KG 08 2021   pk_12_total 90 474 45   * 22     *   19                             654 90 474 45     22         19                       654
1318735 1318735 MD     school 2400090 30   Baltimore City 240009000326 226 Violetville Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 90 171 57   * 13     *   23                             358 90 171 57     13         23                       358
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
1310344 1310344 MD     school 2400060 2   Anne Arundel 240006000092 3122 Manor View Elementary   Regular School No Elementary 01 05 2021   pk_12_total 89 47 51   * *     *   37                             235 89 47 51               37                       235
1311141 1311141 MD     school 2400120 3   Baltimore County 240012000356 408 Cedarmere Elementary   Regular School No Elementary PK 05 2021   pk_12_total 89 214 159     46         16                             524 89 214 159     46         16                       524
1314205 1314205 MD     school 2400420 13   Howard 240042001699 616 Cradlerock Elementary   Regular School No Elementary PK 05 2021   pk_12_total 89 214 86   * 27         39                             456 89 214 86     27         39                       456
1316220 1316220 MD     school 2400510 16   Prince George's 240051000988 1011 Bond Mill Elementary   Regular School No Elementary KG 05 2021   pk_12_total 89 224 101   * 39     *   29                             488 89 224 101     39         29                       488
1313975 1313975 MD     school 2400420 13   Howard 240042000731 404 Glenelg High   Regular School No High 09 12 2021   pk_12_total 888 52 77   * 179         65                             1263 888 52 77     179         65                       1263
1311498 1311498 MD     school 2400120 3   Baltimore County 240012000447 1151 Perry Hall Middle   Regular School No Middle 06 08 2021   pk_12_total 885 502 86   * 312     *   86                             1878 885 502 86     312         86                       1878
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

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