enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
1238304 1238304 MD     school 2400120 3   Baltimore County 240012002945 112 Dogwood Elementary   Regular School No Elementary PK 05 2020   pk_12_total 20 555 30   17 40     *   19                             682 20 555 30   17 40         19                       682
1311655 1311655 MD     school 2400120 3   Baltimore County 240012000417 1351 Lansdowne Middle   Regular School No Middle 06 08 2021   pk_12_total 211 252 316   17 58     *   55                             910 211 252 316   17 58         55                       910
1239100 1239100 MD     school 2400120 3   Baltimore County 240012000417 1351 Lansdowne Middle   Regular School No Middle 06 08 2020   pk_12_total 201 246 292   16 62     *   48                             866 201 246 292   16 62         48                       866
1311603 1311603 MD     school 2400120 3   Baltimore County 240012000377 1273 Dundalk High   Regular School No High 09 12 2021   pk_12_total 691 335 661   16 37     *   99                             1842 691 335 661   16 37         99                       1842
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
1245326 1245326 MD     school 2400690 22   Wicomico 240069001305 1307 James M. Bennett High   Regular School No High 09 12 2020   pk_12_total 606 565 235   15 65     *   77                             1567 606 565 235   15 65         77                       1567
1311598 1311598 MD     school 2400120 3   Baltimore County 240012000444 1272 Patapsco High and Center for Arts   Regular School No High 09 12 2021   pk_12_total 799 327 134   15 14     *   112                             1402 799 327 134   15 14         112                       1402
1239034 1239034 MD     school 2400120 3   Baltimore County 240012000408 1253 Holabird Middle   Regular School No Middle 04 08 2020   pk_12_total 459 130 289   14 25         53                             970 459 130 289   14 25         53                       970
1239048 1239048 MD     school 2400120 3   Baltimore County 240012000377 1273 Dundalk High   Regular School No High 09 12 2020   pk_12_total 690 349 593   14 43     *   89                             1782 690 349 593   14 43         89                       1782
1239038 1239038 MD     school 2400120 3   Baltimore County 240012001438 1255 General John Stricker Middle   Regular School No Middle 06 08 2020   pk_12_total 452 149 89   13 13         77                             793 452 149 89   13 13         77                       793
1310858 1310858 MD     school 2400120 3   Baltimore County 240012002945 112 Dogwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 15 467 27   13 37     *   18                             578 15 467 27   13 37         18                       578
1240272 1240272 MD     school 2400270 8   Charles 240027000597 1002 Henry E. Lackey High School   Regular School No High 09 12 2020   pk_12_total 283 563 47   12 20     *   64                             990 283 563 47   12 20         64                       990
1241329 1241329 MD     school 2400420 13   Howard 240042000723 210 Centennial Lane Elementary   Regular School No Elementary KG 05 2020   pk_12_total 223 39 29   12 360         56                             719 223 39 29   12 360         56                       719
1239088 1239088 MD     school 2400120 3   Baltimore County 240012000415 1311 Lansdowne Elementary   Regular School No Elementary PK 05 2020   pk_12_total 229 134 165   11 38         54                             631 229 134 165   11 38         54                       631
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
1239249 1239249 MD     school 2400120 3   Baltimore County 240012000401 1515 Hawthorne Elementary   Regular School No Elementary PK 05 2020   pk_12_total 119 294 44   11 *         54                             525 119 294 44   11           54                       525
1240251 1240251 MD     school 2400270 8   Charles 240027001727 802 St. Charles High School   Regular School No High 09 12 2020   pk_12_total 175 1005 90   11 29     *   97                             1410 175 1005 90   11 29         97                       1410
1244519 1244519 MD     school 2400510 16   Prince George's 240051001027 2114 Eleanor Roosevelt High   Regular School No High 09 12 2020   pk_12_total 267 1489 547   11 237     *   71                             2629 267 1489 547   11 237         71                       2629
1311593 1311593 MD     school 2400120 3   Baltimore County 240012001438 1255 General John Stricker Middle   Regular School No Middle 06 08 2021   pk_12_total 487 152 104   11 16         76                             846 487 152 104   11 16         76                       846
1311880 1311880 MD     school 2400120 3   Baltimore County 240012000478 1554 Stemmers Run Middle   Regular School No Middle 06 08 2021   pk_12_total 379 249 93   11 18         56                             806 379 249 93   11 18         56                       806
1312798 1312798 MD     school 2400270 8   Charles 240027001727 802 St. Charles High School   Regular School No High 09 12 2021   pk_12_total 154 997 101   11 30     *   96                             1392 154 997 101   11 30         96                       1392
1313052 1313052 MD     school 2400330 10   Frederick 240033000616 713 Urbana High   Regular School No High 09 12 2021   pk_12_total 1055 173 242   11 320     *   103                             1908 1055 173 242   11 320         103                       1908
1237691 1237691 MD     school 2400060 2   Anne Arundel 240006001402 2363 Broadneck High   Regular School No High 09 12 2020   pk_12_total 1635 170 212   10 60     *   130                             2221 1635 170 212   10 60         130                       2221
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
1238956 1238956 MD     school 2400120 3   Baltimore County 240012000375 1202 Dundalk Elementary   Regular School No Elementary PK 05 2020   pk_12_total 265 234 174   10       *   90                             776 265 234 174   10           90                       776
1239028 1239028 MD     school 2400120 3   Baltimore County 240012000376 1251 Dundalk Middle   Regular School No Middle 06 08 2020   pk_12_total 245 217 248   10 17     *   53                             793 245 217 248   10 17         53                       793
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
1240931 1240931 MD     school 2400390 12   Harford 240039000716 140 William Paca/Old Post Road Elementary   Regular School No Elementary PK 05 2020   pk_12_total 210 386 158   10 13         88                             865 210 386 158   10 13         88                       865
1311589 1311589 MD     school 2400120 3   Baltimore County 240012000408 1253 Holabird Middle   Regular School No Middle 04 08 2021   pk_12_total 433 123 291   10 31     *   56                             945 433 123 291   10 31         56                       945
1311664 1311664 MD     school 2400120 3   Baltimore County 240012000416 1371 Lansdowne High   Regular School No High 09 12 2021   pk_12_total 462 330 342   10 100         52                             1296 462 330 342   10 100         52                       1296
1313552 1313552 MD     school 2400390 12   Harford 240039000679 270 Aberdeen High   Regular School No High 09 12 2021   pk_12_total 498 576 140   10 85     *   125                             1441 498 576 140   10 85         125                       1441
1313884 1313884 MD     school 2400420 13   Howard 240042000723 210 Centennial Lane Elementary   Regular School No Elementary KG 05 2021   pk_12_total 209 34 30   10 332         40                             655 209 34 30   10 332         40                       655
1237247 1237247 MD     school 2400030 1   Allegany 240003000024 502 Northeast Elementary   Regular School No Elementary PK 05 2020   pk_12_total 268 16 *   * *         30                             319 268 16                 30                       319
1237262 1237262 MD     school 2400030 1   Allegany 240003000032 603 West Side Elementary   Regular School No Elementary PK 05 2020   pk_12_total 288 17 *   * *         52                             367 288 17                 52                       367
1237267 1237267 MD     school 2400030 1   Allegany 240003000001 606 Allegany High   Regular School No High 09 12 2020   pk_12_total 631 21 15   * 11         41                             721 631 21 15     11         41                       721
1237315 1237315 MD     school 2400030 1   Allegany 240003000023 1301 Mount Savage Middle   Regular School No Middle 06 08 2020   pk_12_total 369 * *   * *     *   12                             394 369                   12                       394
1237323 1237323 MD     school 2400030 1   Allegany 240003001546 1302 Mt. Savage Elementary   Regular School No Elementary PK 05 2020   pk_12_total 185   *   *           *                             191 185                                           191
1237328 1237328 MD     school 2400030 1   Allegany 240003001636 2404 Mountain Ridge High School   Regular School No High 09 12 2020   pk_12_total 729 17 *   * *         24                             784 729 17                 24                       784
1237336 1237336 MD     school 2400030 1   Allegany 240003000003 2801 Beall Elementary   Regular School No Elementary PK 05 2020   pk_12_total 386 * *   * *         30                             441 386                   30                       441
1237344 1237344 MD     school 2400030 1   Allegany 240003001338 2901 Cash Valley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 242 13 *   * *         12                             279 242 13                 12                       279
1237356 1237356 MD     school 2400060 2   Anne Arundel 240006000050 1023 Brooklyn Park Middle   Regular School No Middle 06 08 2020   pk_12_total 350 217 185   * 16     *   64                             837 350 217 185     16         64                       837
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
1237365 1237365 MD     school 2400060 2   Anne Arundel 240006000059 1043 Corkran Middle School   Regular School No Middle 06 08 2020   pk_12_total 237 176 167   * 25     *   46                             657 237 176 167     25         46                       657
1237369 1237369 MD     school 2400060 2   Anne Arundel 240006000087 1053 Lindale Middle   Regular School No Middle 06 08 2020   pk_12_total 480 302 202   * 64     *   71                             1126 480 302 202     64         71                       1126
1237373 1237373 MD     school 2400060 2   Anne Arundel 240006000095 1063 Marley Middle   Regular School No Middle 06 08 2020   pk_12_total 359 255 213   * 28     *   79                             938 359 255 213     28         79                       938
1237381 1237381 MD     school 2400060 2   Anne Arundel 240006000043 1082 Belle Grove Elementary   Regular School No Elementary PK 05 2020   pk_12_total 120 64 75   * 13     *   35                             309 120 64 75     13         35                       309
1237389 1237389 MD     school 2400060 2   Anne Arundel 240006000049 1092 Brooklyn Park Elementary   Regular School No Elementary PK 05 2020   pk_12_total 199 108 104   * *         30                             450 199 108 104               30                       450
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
1237398 1237398 MD     school 2400060 2   Anne Arundel 240006000071 1112 George T. Cromwell Elementary   Regular School No Elementary 01 05 2020   pk_12_total 160 35 77   * 10     *   17                             301 160 35 77     10         17                       301
1237406 1237406 MD     school 2400060 2   Anne Arundel 240006001515 1122 Freetown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 146 184 90   * 15     *   34                             471 146 184 90     15         34                       471
1237414 1237414 MD     school 2400060 2   Anne Arundel 240006000077 1132 Glendale Elementary   Regular School No Elementary PK 05 2020   pk_12_total 192 41 134   * *     *   34                             412 192 41 134               34                       412
1237422 1237422 MD     school 2400060 2   Anne Arundel 240006000081 1142 Hilltop Elementary   Regular School No Elementary PK 05 2020   pk_12_total 176 235 186   * 23     *   56                             679 176 235 186     23         56                       679
1237437 1237437 MD     school 2400060 2   Anne Arundel 240006000093 1162 Marley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 228 257 213   * 63     *   61                             831 228 257 213     63         61                       831
1237453 1237453 MD     school 2400060 2   Anne Arundel 240006000105 1182 Oakwood Elementary   Regular School No Elementary PK 05 2020   pk_12_total 137 66 79   * 28     *   21                             334 137 66 79     28         21                       334
1237469 1237469 MD     school 2400060 2   Anne Arundel 240006000111 1202 Park Elementary   Regular School No Elementary PK 05 2020   pk_12_total 176 127 160   * 16     *   38                             519 176 127 160     16         38                       519
1237485 1237485 MD     school 2400060 2   Anne Arundel 240006000117 1232 Quarterfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 165 120 78   * 54     *   48                             468 165 120 78     54         48                       468
1237492 1237492 MD     school 2400060 2   Anne Arundel 240006000118 1242 Richard Henry Lee Elementary   Regular School No Elementary KG 05 2020   pk_12_total 212 104 127   * 20         40                             506 212 104 127     20         40                       506
1237500 1237500 MD     school 2400060 2   Anne Arundel 240006000142 1262 Woodside Elementary   Regular School No Elementary PK 05 2020   pk_12_total 128 63 153   * 10     *   12                             368 128 63 153     10         12                       368
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
1237519 1237519 MD     school 2400060 2   Anne Arundel 240006090441 1323 North County High   Regular School No High 09 12 2020   pk_12_total 1017 593 414   * 119     *   133                             2286 1017 593 414     119         133                       2286
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
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
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
1237537 1237537 MD     school 2400060 2   Anne Arundel 240006000126 2043 Severna Park Middle   Regular School No Middle 06 08 2020   pk_12_total 1162 52 87   * 66     *   77                             1453 1162 52 87     66         77                       1453
1237544 1237544 MD     school 2400060 2   Anne Arundel 240006000038 2052 Arnold Elementary   Regular School No Elementary KG 05 2020   pk_12_total 427 33 30   * 21     *   29                             543 427 33 30     21         29                       543
1237552 1237552 MD     school 2400060 2   Anne Arundel 240006000044 2062 Belvedere Elementary   Regular School No Elementary PK 05 2020   pk_12_total 381 30 56   * 21     *   42                             532 381 30 56     21         42                       532
1237560 1237560 MD     school 2400060 2   Anne Arundel 240006000045 2072 Benfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 350 * 21   * *         28                             410 350   21               28                       410
1237574 1237574 MD     school 2400060 2   Anne Arundel 240006000051 2092 Cape St. Claire Elementary   Regular School No Elementary KG 05 2020   pk_12_total 473 17 70   * 14     *   48                             625 473 17 70     14         48                       625
1237581 1237581 MD     school 2400060 2   Anne Arundel 240006000067 2102 Folger Mckinsey Elementary   Regular School No Elementary KG 05 2020   pk_12_total 525 16 29   * 19         22                             612 525 16 29     19         22                       612
1237597 1237597 MD     school 2400060 2   Anne Arundel 240006000079 2132 High Point Elementary   Regular School No Elementary PK 05 2020   pk_12_total 463 46 100   * 14         53                             680 463 46 100     14         53                       680
1237605 1237605 MD     school 2400060 2   Anne Arundel 240006000082 2142 Jacobsville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 447 39 48   * 10         33                             578 447 39 48     10         33                       578
1237627 1237627 MD     school 2400060 2   Anne Arundel 240006000104 2172 Oak Hill Elementary   Regular School No Elementary PK 05 2020   pk_12_total 575 27 26   * 43     *   43                             716 575 27 26     43         43                       716
1237642 1237642 MD     school 2400060 2   Anne Arundel 240006000121 2192 Riviera Beach Elementary   Regular School No Elementary PK 05 2020   pk_12_total 252 12 16   * *         22                             312 252 12 16               22                       312
1237649 1237649 MD     school 2400060 2   Anne Arundel 240006000125 2202 Severna Park Elementary   Regular School No Elementary KG 05 2020   pk_12_total 381 * 15   * 22         16                             442 381   15     22         16                       442
1237657 1237657 MD     school 2400060 2   Anne Arundel 240006000129 2212 Solley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 498 100 94   * 32     *   70                             798 498 100 94     32         70                       798
1237665 1237665 MD     school 2400060 2   Anne Arundel 240006000134 2222 Sunset Elementary   Regular School No Elementary PK 05 2020   pk_12_total 342 30 29   * 10     *   33                             446 342 30 29     10         33                       446
1237670 1237670 MD     school 2400060 2   Anne Arundel 240006000899 2233 Anne Arundel Evening High   Alternative School No High 09 12 2020   pk_12_total 150 66 55   * *         22                             296 150 66 55               22                       296
1237674 1237674 MD     school 2400060 2   Anne Arundel 240006000091 2243 Magothy River Middle   Regular School No Middle 06 08 2020   pk_12_total 555 38 65   * 16     *   45                             723 555 38 65     16         45                       723
1237679 1237679 MD     school 2400060 2   Anne Arundel 240006000058 2273 Chesapeake High   Regular School No High 09 12 2020   pk_12_total 1161 57 82   * 26     *   54                             1388 1161 57 82     26         54                       1388
1237686 1237686 MD     school 2400060 2   Anne Arundel 240006000047 2322 Broadneck Elementary   Regular School No Elementary KG 05 2020   pk_12_total 586 41 71   * 25     *   49                             774 586 41 71     25         49                       774
1237698 1237698 MD     school 2400060 2   Anne Arundel 240006001516 2372 Windsor Farm Elementary   Regular School No Elementary KG 05 2020   pk_12_total 388 41 87   * *         37                             564 388 41 87               37                       564
1237702 1237702 MD     school 2400060 2   Anne Arundel 240006000124 2413 Severn River Middle   Regular School No Middle 06 08 2020   pk_12_total 597 60 93   * 19         39                             809 597 60 93     19         39                       809
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
1237718 1237718 MD     school 2400060 2   Anne Arundel 240006000040 3013 Arundel High   Regular School No High 09 12 2020   pk_12_total 1089 595 177   * 127     12   198                             2200 1089 595 177     127     12   198                       2200
1237722 1237722 MD     school 2400060 2   Anne Arundel 240006000039 3023 Arundel Middle   Regular School No Middle 06 08 2020   pk_12_total 480 283 118   * 57     *   122                             1068 480 283 118     57         122                       1068
1237726 1237726 MD     school 2400060 2   Anne Arundel 240006000090 3033 MacArthur Middle   Regular School No Middle 06 08 2020   pk_12_total 191 505 127   * 53     *   67                             959 191 505 127     53         67                       959
1237734 1237734 MD     school 2400060 2   Anne Arundel 240006000048 3062 Brock Bridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 44 245 251   * 40     *   16                             600 44 245 251     40         16                       600
1237742 1237742 MD     school 2400060 2   Anne Arundel 240006000060 3072 Crofton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 502 157 81   * 36         49                             828 502 157 81     36         49                       828
1237749 1237749 MD     school 2400060 2   Anne Arundel 240006000061 3082 Crofton Woods Elementary   Regular School No Elementary KG 05 2020   pk_12_total 525 48 69   * 54     *   63                             763 525 48 69     54         63                       763
1237765 1237765 MD     school 2400060 2   Anne Arundel 240006000078 3102 Hebron - Harman Elementary   Regular School No Elementary PK 05 2020   pk_12_total 117 323 161   * 78         76                             759 117 323 161     78         76                       759
1237773 1237773 MD     school 2400060 2   Anne Arundel 240006000083 3112 Jessup Elementary   Regular School No Elementary PK 05 2020   pk_12_total 186 169 142   * 35         63                             596 186 169 142     35         63                       596
1237787 1237787 MD     school 2400060 2   Anne Arundel 240006000096 3132 Maryland City Elementary   Regular School No Elementary PK 05 2020   pk_12_total 17 150 196   * *         11                             384 17 150 196               11                       384
1237795 1237795 MD     school 2400060 2   Anne Arundel 240006000098 3142 Meade Heights Elementary   Regular School No Elementary PK 05 2020   pk_12_total 71 258 62   * *         30                             429 71 258 62               30                       429
1237803 1237803 MD     school 2400060 2   Anne Arundel 240006000137 3152 Van Bokkelen Elementary   Regular School No Elementary PK 05 2020   pk_12_total 17 304 118   * *     *   20                             465 17 304 118               20                       465
1237825 1237825 MD     school 2400060 2   Anne Arundel 240006000114 3182 Pershing Hill Elementary   Regular School No Elementary KG 05 2020   pk_12_total 255 117 113   * 12     *   67                             568 255 117 113     12         67                       568
1237840 1237840 MD     school 2400060 2   Anne Arundel 240006000123 3202 Severn Elementary   Regular School No Elementary PK 05 2020   pk_12_total 125 285 65   * 30     *   43                             553 125 285 65     30         43                       553
1237847 1237847 MD     school 2400060 2   Anne Arundel 240006000130 3212 South Shore Elementary   Regular School No Elementary KG 05 2020   pk_12_total 230 * 57   * *         36                             340 230   57               36                       340
1237855 1237855 MD     school 2400060 2   Anne Arundel 240006000138 3222 Waugh Chapel Elementary   Regular School No Elementary PK 05 2020   pk_12_total 326 128 80   * 48     *   49                             633 326 128 80     48         49                       633
1237858 1237858 MD     school 2400060 2   Anne Arundel 240006000140 3232 West Meade Early Education Center   Regular School No Elementary PK KG 2020   pk_12_total 123 33 64   * 14         21                             256 123 33 64     14         21                       256
1237865 1237865 MD     school 2400060 2   Anne Arundel 240006002944 3242 Piney Orchard Elementary   Regular School No Elementary KG 05 2020   pk_12_total 341 127 63   * 39         71                             643 341 127 63     39         71                       643

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