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,546 ✖
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
1311215 1311215 MD     school 2400120 3   Baltimore County 240012001433 805 Timonium Elementary   Regular School No Elementary KG 05 2021   pk_12_total 286 22 36     75     *   24                             444 286 22 36     75         24                       444
1311399 1311399 MD     school 2400120 3   Baltimore County 240012000451 957 Pine Grove Middle   Regular School No Middle 06 08 2021   pk_12_total 366 385 45   * 75     *   49                             926 366 385 45     75         49                       926
1314058 1314058 MD     school 2400420 13   Howard 240042001382 520 Clemens Crossing Elementary   Regular School No Elementary KG 05 2021   pk_12_total 234 132 55   * 75     *   51                             549 234 132 55     75         51                       549
1316201 1316201 MD     school 2400510 16   Prince George's 240051001092 1008 Laurel High   Regular School No High 09 12 2021   pk_12_total 71 1069 728   * 75     *   35                             1986 71 1069 728     75         35                       1986
1314566 1314566 MD     school 2400480 15   Montgomery 240048000934 234 Thomas S. Wootton High   Regular School No High 09 12 2021   pk_12_total 817 211 169   * 743         95                             2037 817 211 169     743         95                       2037
1311486 1311486 MD     school 2400120 3   Baltimore County 240012000397 1111 Gunpowder Elementary   Regular School No Elementary KG 05 2021   pk_12_total 297 88 15   * 74         19                             494 297 88 15     74         19                       494
1314459 1314459 MD     school 2400480 15   Montgomery 240048000947 207 Beall Elementary   Regular School No Elementary PK 05 2021   pk_12_total 204 82 114     74     *   41                             516 204 82 114     74         41                       516
1316962 1316962 MD     school 2400510 16   Prince George's 240051001126 1909 Parkdale High   Regular School No High 09 12 2021   pk_12_total 80 717 1560   * 74     *   15                             2453 80 717 1560     74         15                       2453
1313669 1313669 MD     school 2400390 12   Harford 240039001380 385 C. Milton Wright High   Regular School No High 09 12 2021   pk_12_total 1026 100 68   * 72     *   61                             1330 1026 100 68     72         61                       1330
1314972 1314972 MD     school 2400480 15   Montgomery 240048000796 508 Candlewood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 165 60 69     72     *   30                             398 165 60 69     72         30                       398
1315104 1315104 MD     school 2400480 15   Montgomery 240048000875 556 Mill Creek Towne Elementary   Regular School No Elementary PK 05 2021   pk_12_total 86 83 205   * 72     *   33                             482 86 83 205     72         33                       482
1311712 1311712 MD     school 2400120 3   Baltimore County 240012000442 1452 Parkville Middle   Regular School No Middle 06 08 2021   pk_12_total 435 429 78   * 71     *   61                             1076 435 429 78     71         61                       1076
1314636 1314636 MD     school 2400480 15   Montgomery 240048000794 302 Burtonsville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 31 372 118   * 71         14                             608 31 372 118     71         14                       608
1314673 1314673 MD     school 2400480 15   Montgomery 240048001524 308 Cloverly Elementary   Regular School No Elementary PK 05 2021   pk_12_total 116 126 129     71     *   33                             476 116 126 129     71         33                       476
1314709 1314709 MD     school 2400480 15   Montgomery 240048000839 313 Galway Elementary   Regular School No Elementary PK 05 2021   pk_12_total 25 447 194     71         13                             750 25 447 194     71         13                       750
1315666 1315666 MD     school 2400510 16   Prince George's 240051001059 102 High Point High   Regular School No High 09 12 2021   pk_12_total 50 449 2042   * 71     *   12                             2634 50 449 2042     71         12                       2634
1313132 1313132 MD     school 2400330 10   Frederick 240033001163 918 Oakdale Middle   Regular School No Middle 06 08 2021   pk_12_total 601 72 101   * 70     *   50                             899 601 72 101     70         50                       899
1313624 1313624 MD     school 2400390 12   Harford 240039000701 335 Homestead/Wakefield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 710 54 81   * 70     *   75                             996 710 54 81     70         75                       996
1310099 1310099 MD     school 2400060 2   Anne Arundel 240006000126 2043 Severna Park Middle   Regular School No Middle 06 08 2021   pk_12_total 1130 55 76   * 69     *   75                             1412 1130 55 76     69         75                       1412
1311148 1311148 MD     school 2400120 3   Baltimore County 240012001730 410 Lyons Mill Elementary   Regular School No Elementary KG 05 2021   pk_12_total 22 543 18   * 69         27                             685 22 543 18     69         27                       685
1315413 1315413 MD     school 2400480 15   Montgomery 240048001457 775 Eastern Middle School   Regular School No Middle 06 08 2021   pk_12_total 197 185 478     69     *   36                             966 197 185 478     69         36                       966
1315714 1315714 MD     school 2400510 16   Prince George's 240051001101 110 Martin Luther King Jr. Middle   Regular School No Middle 06 08 2021   pk_12_total 31 443 413     69     *   20                             981 31 443 413     69         20                       981
1316243 1316243 MD     school 2400510 16   Prince George's 240051001708 1015 Chesapeake Math and IT Public Charter   Regular School Yes Other KG 12 2021   pk_12_total 56 1363 165   * 69     *   23                             1683 56 1363 165     69         23                       1683
1315207 1315207 MD     school 2400480 15   Montgomery 240048000956 602 Winston Churchill High   Regular School No High 09 12 2021   pk_12_total 1016 226 178   * 688     *   132                             2245 1016 226 178     688         132                       2245
1314123 1314123 MD     school 2400420 13   Howard 240042000733 602 Guilford Elementary   Regular School No Elementary PK 05 2021   pk_12_total 69 261 70     68         32                             500 69 261 70     68         32                       500
1317902 1317902 MD     school 2400690 22   Wicomico 240069001305 1307 James M. Bennett High   Regular School No High 09 12 2021   pk_12_total 575 475 155   * 68     *   77                             1362 575 475 155     68         77                       1362
1311419 1311419 MD     school 2400120 3   Baltimore County 240012000230 975 George W. Carver Center for Arts & Technology   Career and Technical School No High 09 12 2021   pk_12_total 458 354 63   * 66     *   50                             997 458 354 63     66         50                       997
1311868 1311868 MD     school 2400120 3   Baltimore County 240012001653 1533 Vincent Farm Elementary   Regular School No Elementary PK 05 2021   pk_12_total 253 330 50   * 66     *   41                             742 253 330 50     66         41                       742
1312912 1312912 MD     school 2400330 10   Frederick 240033001355 109 Tuscarora Elementary   Regular School No Elementary PK 05 2021   pk_12_total 192 184 192   * 66     *   64                             701 192 184 192     66         64                       701
1312976 1312976 MD     school 2400330 10   Frederick 240033090471 223 Ballenger Creek Elementary   Regular School No Elementary PK 05 2021   pk_12_total 197 138 128   * 66     *   67                             602 197 138 128     66         67                       602
1315029 1315029 MD     school 2400480 15   Montgomery 240048001127 521 Shady Grove Middle   Regular School No Middle 06 08 2021   pk_12_total 115 130 241     66         26                             578 115 130 241     66         26                       578
1315839 1315839 MD     school 2400510 16   Prince George's 240051001686 509 Accokeek Academy   Regular School No Elementary KG 08 2021   pk_12_total 57 1150 216   * 66     12   38                             1543 57 1150 216     66     12   38                       1543
1315009 1315009 MD     school 2400480 15   Montgomery 240048090479 514 Judith A. Resnik Elementary   Regular School No Elementary PK 05 2021   pk_12_total 81 162 246   * 65     *   34                             591 81 162 246     65         34                       591
1315168 1315168 MD     school 2400480 15   Montgomery 240048000829 566 Fields Road Elementary   Regular School No Elementary PK 05 2021   pk_12_total 122 85 154   * 65         31                             458 122 85 154     65         31                       458
1315184 1315184 MD     school 2400480 15   Montgomery 240048001512 569 Strawberry Knoll Elementary   Regular School No Elementary PK 05 2021   pk_12_total 65 163 265   * 65         35                             594 65 163 265     65         35                       594
1311325 1311325 MD     school 2400120 3   Baltimore County 240012000399 911 Hampton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 343 148 53   * 64         34                             645 343 148 53     64         34                       645
1314701 1314701 MD     school 2400480 15   Montgomery 240048000955 312 William Tyler Page Elementary   Regular School No Elementary PK 05 2021   pk_12_total 85 281 158   * 64     *   32                             622 85 281 158     64         32                       622
1314766 1314766 MD     school 2400480 15   Montgomery 240048001567 340 Great Seneca Creek Elementary   Regular School No Elementary PK 05 2021   pk_12_total 103 194 145   * 64         28                             538 103 194 145     64         28                       538
1315613 1315613 MD     school 2400480 15   Montgomery 240048000909 819 Rock Creek Valley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 128 35 171     64         24                             422 128 35 171     64         24                       422
1316538 1316538 MD     school 2400510 16   Prince George's 240051001474 1408 Glenn Dale Elementary   Regular School No Elementary KG 05 2021   pk_12_total 32 352 112   * 64         10                             571 32 352 112     64         10                       571
1316957 1316957 MD     school 2400510 16   Prince George's 240051001186 1908 William Wirt Middle   Regular School No Middle 06 08 2021   pk_12_total 25 219 962   * 64     *   *                             1280 25 219 962     64                                 1280
1310253 1310253 MD     school 2400060 2   Anne Arundel 240006001402 2363 Broadneck High   Regular School No High 09 12 2021   pk_12_total 1634 158 234   * 63     *   130                             2233 1634 158 234     63         130                       2233
1314190 1314190 MD     school 2400420 13   Howard 240042000749 612 Phelps Luck Elementary   Regular School No Elementary PK 05 2021   pk_12_total 146 170 204     63         42                             625 146 170 204     63         42                       625
1314854 1314854 MD     school 2400480 15   Montgomery 240048000949 412 Westland Middle   Regular School No Middle 06 08 2021   pk_12_total 434 60 140   * 63         62                             764 434 60 140     63         62                       764
1315025 1315025 MD     school 2400480 15   Montgomery 240048090451 518 Brooke Grove Elementary   Regular School No Elementary PK 05 2021   pk_12_total 162 127 66   * 63         31                             450 162 127 66     63         31                       450
1315055 1315055 MD     school 2400480 15   Montgomery 240048001511 546 Goshen Elementary   Regular School No Elementary PK 05 2021   pk_12_total 77 123 236     63         23                             522 77 123 236     63         23                       522
1315136 1315136 MD     school 2400480 15   Montgomery 240048000901 562 Redland Middle   Regular School No Middle 06 08 2021   pk_12_total 126 142 281   * 63         32                             646 126 142 281     63         32                       646
1313970 1313970 MD     school 2400420 13   Howard 240042001437 308 Marriotts Ridge High   Regular School No High 09 12 2021   pk_12_total 675 159 58   * 626     *   73                             1597 675 159 58     626         73                       1597
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

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