enrollments

Data source: Big Local News · About: Big Local

9,598 rows where state = "MD" and year = 2021 sorted by asian descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 9,498 ✖
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
1311696 1311696 MD     school 2400120 3   Baltimore County 240012000459 1406 Red House Run Elementary   Regular School No Elementary PK 05 2021   pk_12_total 197 173 116   * 62         24                             575 197 173 116     62         24                       575
1313444 1313444 MD     school 2400390 12   Harford 240039000485 121 Emmorton Elementary   Regular School No Elementary KG 05 2021   pk_12_total 352 49 49     62         52                             564 352 49 49     62         52                       564
1315116 1315116 MD     school 2400480 15   Montgomery 240048000953 558 Whetstone Elementary   Regular School No Elementary PK 05 2021   pk_12_total 46 173 387   * 62         21                             693 46 173 387     62         21                       693
1315310 1315310 MD     school 2400480 15   Montgomery 240048090480 747 Dr. Charles R. Drew Elementary   Regular School No Elementary PK 05 2021   pk_12_total 62 211 108   * 62     *   22                             468 62 211 108     62         22                       468
1313901 1313901 MD     school 2400420 13   Howard 240042000722 214 Centennial High   Regular School No High 09 12 2021   pk_12_total 566 131 82     611     *   75                             1467 566 131 82     611         75                       1467
1314623 1314623 MD     school 2400480 15   Montgomery 240048000644 248 Forest Oak Middle   Regular School No Middle 06 08 2021   pk_12_total 85 212 534     61     *   26                             920 85 212 534     61         26                       920
1310314 1310314 MD     school 2400060 2   Anne Arundel 240006000061 3082 Crofton Woods Elementary   Regular School No Elementary KG 05 2021   pk_12_total 458 58 65   * 60     *   65                             715 458 58 65     60         65                       715
1314532 1314532 MD     school 2400480 15   Montgomery 240048000904 227 Ritchie Park Elementary   Regular School No Elementary KG 05 2021   pk_12_total 187 56 53   * 60     *   26                             384 187 56 53     60         26                       384
1316543 1316543 MD     school 2400510 16   Prince George's 240051001023 1409 Duval High   Regular School No High 09 12 2021   pk_12_total 53 1187 872   * 60     *   20                             2206 53 1187 872     60         20                       2206
1310284 1310284 MD     school 2400060 2   Anne Arundel 240006000039 3023 Arundel Middle   Regular School No Middle 06 08 2021   pk_12_total 501 307 130   * 59     *   116                             1119 501 307 130     59         116                       1119
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
1314435 1314435 MD     school 2400480 15   Montgomery 240048000902 201 Richard Montgomery High   Regular School No High 09 12 2021   pk_12_total 699 399 577   * 586     *   143                             2410 699 399 577     586         143                       2410
1310420 1310420 MD     school 2400060 2   Anne Arundel 240006000138 3222 Waugh Chapel Elementary   Regular School No Elementary PK 05 2021   pk_12_total 300 135 90   * 58     *   44                             631 300 135 90     58         44                       631
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
1313519 1313519 MD     school 2400390 12   Harford 240039001642 188 Patterson Mill Middle School   Regular School No Middle 06 08 2021   pk_12_total 500 57 67   * 58     *   52                             742 500 57 67     58         52                       742
1314602 1314602 MD     school 2400480 15   Montgomery 240048000191 242 Dr. Sally K. Ride Elementary   Regular School No Elementary PK 05 2021   pk_12_total 41 168 180     58     *   27                             475 41 168 180     58         27                       475
1315519 1315519 MD     school 2400480 15   Montgomery 240048000908 795 Rock View Elementary   Regular School No Elementary PK 05 2021   pk_12_total 133 85 307   * 58     *   37                             625 133 85 307     58         37                       625
1317281 1317281 MD     school 2400600 18   Saint Mary's 240060001356 306 Leonardtown High   Regular School No High 09 12 2021   pk_12_total 1366 162 117   * 58     *   138                             1846 1366 162 117     58         138                       1846
1309998 1309998 MD     school 2400060 2   Anne Arundel 240006000093 1162 Marley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 202 267 192   * 57     *   52                             778 202 267 192     57         52                       778
1311194 1311194 MD     school 2400120 3   Baltimore County 240012001432 772 Hereford High   Regular School No High 09 12 2021   pk_12_total 1093 33 57     57         45                             1285 1093 33 57     57         45                       1285
1314829 1314829 MD     school 2400480 15   Montgomery 240048000923 405 Somerset Elementary   Regular School No Elementary PK 05 2021   pk_12_total 290 43 69     57     *   40                             500 290 43 69     57         40                       500
1315088 1315088 MD     school 2400480 15   Montgomery 240048000837 554 Gaithersburg Middle   Regular School No Middle 06 08 2021   pk_12_total 114 175 463   * 57         58                             868 114 175 463     57         58                       868
1312265 1312265 MD     school 2400210 6   Carroll 240021000552 707 Westminster High   Regular School No High 09 12 2021   pk_12_total 1242 70 84   * 56     *   59                             1515 1242 70 84     56         59                       1515
1314474 1314474 MD     school 2400480 15   Montgomery 240048000872 210 Maryvale Elementary   Regular School No Elementary PK 05 2021   pk_12_total 132 150 186     56         47                             571 132 150 186     56         47                       571
1314870 1314870 MD     school 2400480 15   Montgomery 240048000958 417 Wood Acres Elementary   Regular School No Elementary PK 05 2021   pk_12_total 397 16 72     56     *   41                             583 397 16 72     56         41                       583
1315108 1315108 MD     school 2400480 15   Montgomery 240048000879 557 Montgomery Village Middle School   Regular School No Middle 06 08 2021   pk_12_total 40 220 438   * 56         20                             776 40 220 438     56         20                       776
1315456 1315456 MD     school 2400480 15   Montgomery 240048000892 783 Kensington Parkwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 346 52 83     56         59                             596 346 52 83     56         59                       596
1316512 1316512 MD     school 2400510 16   Prince George's 240051001704 1350 Academy of Health Sciences at PGCC   Regular School No High 09 12 2021   pk_12_total 22 388 57   * 56         *                             534 22 388 57     56                                 534
1314628 1314628 MD     school 2400480 15   Montgomery 240048001541 249 Clarksburg High   Regular School No High 09 12 2021   pk_12_total 403 702 585   * 559         111                             2365 403 702 585     559         111                       2365
1313866 1313866 MD     school 2400420 13   Howard 240042000743 207 Mount Hebron High   Regular School No High 09 12 2021   pk_12_total 660 205 152   * 555     *   58                             1635 660 205 152     555         58                       1635
1314615 1314615 MD     school 2400480 15   Montgomery 240048001040 246 Northwest High   Regular School No High 09 12 2021   pk_12_total 655 674 588   * 551         129                             2598 655 674 588     551         129                       2598
1312721 1312721 MD     school 2400270 8   Charles 240027000805 622 Berry Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 59 404 84   * 55     *   68                             675 59 404 84     55         68                       675
1314451 1314451 MD     school 2400480 15   Montgomery 240048000939 206 Twinbrook Elementary   Regular School No Elementary PK 05 2021   pk_12_total 61 47 324   * 55         20                             508 61 47 324     55         20                       508
1315063 1315063 MD     school 2400480 15   Montgomery 240048001454 549 Flower Hill Elementary   Regular School No Elementary PK 05 2021   pk_12_total 31 107 222     55         26                             441 31 107 222     55         26                       441
1311080 1311080 MD     school 2400120 3   Baltimore County 240012000441 353 Sudbrook Magnet Middle   Regular School No Middle 06 08 2021   pk_12_total 105 574 213   * 54     *   22                             972 105 574 213     54         22                       972
1312713 1312713 MD     school 2400270 8   Charles 240027000615 621 Mattawoman Middle School   Regular School No Middle 06 08 2021   pk_12_total 37 756 116   * 54     *   56                             1024 37 756 116     54         56                       1024
1317744 1317744 MD     school 2400660 21   Washington 240066001275 2101 North Hagerstown High   Regular School No High 09 12 2021   pk_12_total 653 278 205   * 54     *   150                             1343 653 278 205     54         150                       1343
1310835 1310835 MD     school 2400120 3   Baltimore County 240012000410 105 Johnnycake Elementary   Regular School No Elementary PK 05 2021   pk_12_total 39 270 140   * 53     *   22                             531 39 270 140     53         22                       531
1313253 1313253 MD     school 2400330 10   Frederick 240033000807 2306 Orchard Grove Elementary   Regular School No Elementary PK 05 2021   pk_12_total 150 205 144   * 53     *   46                             603 150 205 144     53         46                       603
1313515 1313515 MD     school 2400390 12   Harford 240039001638 187 Patterson Mill High School   Regular School No High 09 12 2021   pk_12_total 599 69 58     53     *   54                             836 599 69 58     53         54                       836
1315096 1315096 MD     school 2400480 15   Montgomery 240048000916 555 Rosemont Elementary   Regular School No Elementary PK 05 2021   pk_12_total 45 186 278   * 53     *   34                             602 45 186 278     53         34                       602
1315401 1315401 MD     school 2400480 15   Montgomery 240048000907 773 Rock Creek Forest Elementary   Regular School No Elementary PK 05 2021   pk_12_total 237 139 258   * 53         45                             734 237 139 258     53         45                       734
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
1315629 1315629 MD     school 2400480 15   Montgomery 240048001741 835 Silver Creek Middle   Regular School No Middle 06 08 2021   pk_12_total 395 191 154     53         45                             838 395 191 154     53         45                       838
1316078 1316078 MD     school 2400510 16   Prince George's 240051000982 714 Benjamin Tasker Middle School   Regular School No Middle 06 08 2021   pk_12_total 129 718 127   * 53     *   28                             1068 129 718 127     53         28                       1068
1311479 1311479 MD     school 2400120 3   Baltimore County 240012000021 1110 Seven Oaks Elementary   Regular School No Elementary PK 05 2021   pk_12_total 212 134 34   * 52         43                             476 212 134 34     52         43                       476
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
1314090 1314090 MD     school 2400420 13   Howard 240042000816 524 River Hill High   Regular School No High 09 12 2021   pk_12_total 643 139 83   * 515         89                             1470 643 139 83     515         89                       1470
1309930 1309930 MD     school 2400060 2   Anne Arundel 240006000087 1053 Lindale Middle   Regular School No Middle 06 08 2021   pk_12_total 490 347 222   * 51     *   80                             1194 490 347 222     51         80                       1194
1310299 1310299 MD     school 2400060 2   Anne Arundel 240006001761 3063 Crofton High School   Regular School No Secondary 09 10 2021   pk_12_total 458 146 75   * 51     *   47                             783 458 146 75     51         47                       783
1310430 1310430 MD     school 2400060 2   Anne Arundel 240006002944 3242 Piney Orchard Elementary   Regular School No Elementary KG 05 2021   pk_12_total 386 204 97   * 51     *   64                             808 386 204 97     51         64                       808
1310522 1310522 MD     school 2400060 2   Anne Arundel 240006000037 4013 Annapolis High   Regular School No High 09 12 2021   pk_12_total 638 547 835   * 51     *   60                             2134 638 547 835     51         60                       2134
1313245 1313245 MD     school 2400330 10   Frederick 240033090446 2305 Ballenger Creek Middle   Regular School No Middle 06 08 2021   pk_12_total 338 161 180   * 51     *   62                             800 338 161 180     51         62                       800
1314410 1314410 MD     school 2400480 15   Montgomery 240048000185 156 Lois P. Rockwell Elementary   Regular School No Elementary PK 05 2021   pk_12_total 189 62 122   * 51     *   33                             460 189 62 122     51         33                       460
1314923 1314923 MD     school 2400480 15   Montgomery 240048000920 501 Sherwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 184 98 86   * 51         46                             467 184 98 86     51         46                       467
1315237 1315237 MD     school 2400480 15   Montgomery 240048001128 647 Silver Spring International Middle   Regular School No Middle 06 08 2021   pk_12_total 299 260 500   * 51         48                             1160 299 260 500     51         48                       1160
1315430 1315430 MD     school 2400480 15   Montgomery 240048001458 778 Sligo Middle   Regular School No Middle 06 08 2021   pk_12_total 192 155 310   * 51         28                             738 192 155 310     51         28                       738
1315677 1315677 MD     school 2400510 16   Prince George's 240051000978 104 Beltsville Academy   Regular School No Elementary PK 08 2021   pk_12_total 65 187 820   * 51         15                             1143 65 187 820     51         15                       1143
1314324 1314324 MD     school 2400480 15   Montgomery 240048000843 102 Germantown Elementary   Regular School No Elementary PK 05 2021   pk_12_total 47 110 75   * 50     *   16                             301 47 110 75     50         16                       301
1314739 1314739 MD     school 2400480 15   Montgomery 240048001510 334 Greencastle Elementary   Regular School No Elementary PK 05 2021   pk_12_total 22 502 148   * 50         19                             743 22 502 148     50         19                       743
1314885 1314885 MD     school 2400480 15   Montgomery 240048000779 420 Bannockburn Elementary   Regular School No Elementary PK 05 2021   pk_12_total 257 20 40     50         34                             401 257 20 40     50         34                       401
1315221 1315221 MD     school 2400480 15   Montgomery 240048000798 604 Carderock Springs Elementary   Regular School No Elementary KG 05 2021   pk_12_total 175 13 46   * 50     *   33                             319 175 13 46     50         33                       319
1316430 1316430 MD     school 2400510 16   Prince George's 240051000729 1309 William Paca Elementary   Regular School No Elementary PK 05 2021   pk_12_total 24 298 164   * 50     *   *                             544 24 298 164     50                                 544
1310442 1310442 MD     school 2400060 2   Anne Arundel 240006000069 3272 Four Seasons Elementary   Regular School No Elementary PK 05 2021   pk_12_total 338 139 57   * 49     *   79                             665 338 139 57     49         79                       665
1311680 1311680 MD     school 2400120 3   Baltimore County 240012000391 1404 Fullerton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 204 222 58   * 49     *   37                             574 204 222 58     49         37                       574
1314230 1314230 MD     school 2400420 13   Howard 240042001507 620 Bollman Bridge Elementary   Regular School No Elementary PK 05 2021   pk_12_total 158 282 177     49     *   41                             709 158 282 177     49         41                       709
1315286 1315286 MD     school 2400480 15   Montgomery 240048001456 705 John T. Baker Middle School   Regular School No Middle 06 08 2021   pk_12_total 369 102 227     49         50                             797 369 102 227     49         50                       797
1316636 1316636 MD     school 2400510 16   Prince George's 240051001461 1438 Whitehall Elementary   Regular School No Elementary KG 05 2021   pk_12_total 134 300 75   * 49     *   17                             577 134 300 75     49         17                       577
1310288 1310288 MD     school 2400060 2   Anne Arundel 240006000090 3033 MacArthur Middle   Regular School No Middle 06 08 2021   pk_12_total 172 460 135   * 48     *   71                             898 172 460 135     48         71                       898
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
1311085 1311085 MD     school 2400120 3   Baltimore County 240012000449 371 Pikesville High   Regular School No High 09 12 2021   pk_12_total 312 431 82   * 48     *   29                             905 312 431 82     48         29                       905
1311157 1311157 MD     school 2400120 3   Baltimore County 240012001347 452 Owings Mills High   Regular School No High 09 12 2021   pk_12_total 59 619 363   * 48     *   26                             1120 59 619 363     48         26                       1120
1313979 1313979 MD     school 2400420 13   Howard 240042000732 405 Glenwood Middle   Regular School No Middle 06 08 2021   pk_12_total 367 29 40   * 48     *   24                             510 367 29 40     48         24                       510
1315132 1315132 MD     school 2400480 15   Montgomery 240048000944 561 Watkins Mill Elementary   Regular School No Elementary PK 05 2021   pk_12_total 25 182 463   * 48     *   26                             749 25 182 463     48         26                       749
1313909 1313909 MD     school 2400420 13   Howard 240042090449 215 Waverly Elementary   Regular School No Elementary PK 05 2021   pk_12_total 276 62 33   * 475         48                             899 276 62 33     475         48                       899
1310046 1310046 MD     school 2400060 2   Anne Arundel 240006000117 1232 Quarterfield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 146 116 85     47     *   49                             445 146 116 85     47         49                       445
1312205 1312205 MD     school 2400210 6   Carroll 240021000835 508 Oklahoma Road Middle   Regular School No Middle 06 08 2021   pk_12_total 571 43 31   * 47     *   26                             721 571 43 31     47         26                       721
1314209 1314209 MD     school 2400420 13   Howard 240042001700 617 Lake Elkhorn Middle   Regular School No Middle 06 08 2021   pk_12_total 76 326 114     47         37                             600 76 326 114     47         37                       600
1317558 1317558 MD     school 2400660 21   Washington 240066001288 301 South Hagerstown High   Regular School No High 09 12 2021   pk_12_total 582 351 212   * 47     *   187                             1381 582 351 212     47         187                       1381
1311044 1311044 MD     school 2400120 3   Baltimore County 240012000492 304 Wellwood International School   Regular School No Elementary KG 05 2021   pk_12_total 81 308 42   * 46         16                             496 81 308 42     46         16                       496
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
1311208 1311208 MD     school 2400120 3   Baltimore County 240012000350 803 Lutherville Laboratory   Regular School No Elementary KG 05 2021   pk_12_total 164 68 30     46     *   29                             338 164 68 30     46         29                       338
1312951 1312951 MD     school 2400330 10   Frederick 240033000658 211 West Frederick Middle   Regular School No Middle 06 08 2021   pk_12_total 227 204 382   * 46     *   62                             925 227 204 382     46         62                       925
1314689 1314689 MD     school 2400480 15   Montgomery 240048000797 310 Cannon Road Elementary   Regular School No Elementary PK 05 2021   pk_12_total 19 137 203   * 46     *   13                             421 19 137 203     46         13                       421
1312995 1312995 MD     school 2400330 10   Frederick 240033001357 227 Crestwood Middle   Regular School No Middle 06 08 2021   pk_12_total 173 206 196   * 45     *   45                             670 173 206 196     45         45                       670
1314026 1314026 MD     school 2400420 13   Howard 240042000742 514 Longfellow Elementary   Regular School No Elementary PK 05 2021   pk_12_total 101 167 127   * 45     *   43                             485 101 167 127     45         43                       485
1314369 1314369 MD     school 2400480 15   Montgomery 240048010502 110 S. Christa McAuliffe Elementary   Regular School No Elementary PK 05 2021   pk_12_total 70 207 204   * 45     *   35                             565 70 207 204     45         35                       565
1314398 1314398 MD     school 2400480 15   Montgomery 240048000896 153 Poolesville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 280 37 71     45     *   40                             474 280 37 71     45         40                       474
1314660 1314660 MD     school 2400480 15   Montgomery 240048000854 305 Jackson Road Elementary   Regular School No Elementary PK 05 2021   pk_12_total 26 347 261   * 45         15                             696 26 347 261     45         15                       696
1314681 1314681 MD     school 2400480 15   Montgomery 240048090452 309 Burnt Mills Elementary   Regular School No Elementary PK 05 2021   pk_12_total 47 341 138   * 45         34                             607 47 341 138     45         34                       607
1315152 1315152 MD     school 2400480 15   Montgomery 240048000924 564 South Lake Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 147 564   * 45     *   21                             790   147 564     45         21                       790
1316478 1316478 MD     school 2400510 16   Prince George's 240051001473 1330 Kenmoor Middle   Regular School No Middle 06 08 2021   pk_12_total 42 618 246   * 45         *                             962 42 618 246     45                                 962
1313936 1313936 MD     school 2400420 13   Howard 240042001646 219 Veterans Elementary   Regular School No Elementary PK 05 2021   pk_12_total 225 146 70   * 449     *   49                             951 225 146 70     449         49                       951
1311456 1311456 MD     school 2400120 3   Baltimore County 240012000351 1106 Carney Elementary   Regular School No Elementary PK 05 2021   pk_12_total 178 341 31   * 44         33                             628 178 341 31     44         33                       628
1311897 1311897 MD     school 2400120 3   Baltimore County 240012000412 1572 Kenwood High   Regular School No High 09 12 2021   pk_12_total 623 705 194   * 44     *   103                             1679 623 705 194     44         103                       1679
1312181 1312181 MD     school 2400210 6   Carroll 240021000547 504 Sykesville Middle   Regular School No Middle 06 08 2021   pk_12_total 614 37 34   * 44     *   30                             762 614 37 34     44         30                       762
1313323 1313323 MD     school 2400330 10   Frederick 240033000655 2610 Walkersville High   Regular School No High 09 12 2021   pk_12_total 733 183 168   * 44     *   89                             1219 733 183 168     44         89                       1219
1314308 1314308 MD     school 2400480 15   Montgomery 240048001494 100 Clopper Mill Elementary   Regular School No Elementary PK 05 2021   pk_12_total 35 161 215   * 44         21                             478 35 161 215     44         21                       478
1315605 1315605 MD     school 2400480 15   Montgomery 240048000806 818 Col. E. Brooke Lee Middle   Regular School No Middle 06 08 2021   pk_12_total 41 201 492   * 44         14                             795 41 201 492     44         14                       795
1314391 1314391 MD     school 2400480 15   Montgomery 240048000897 152 Poolesville High   Regular School No High 09 12 2021   pk_12_total 551 73 113   * 431         65                             1236 551 73 113     431         65                       1236

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