enrollments

Data source: Big Local News · About: Big Local

2,791 rows where grade = "pk_12_total" and state = "MD" sorted by total descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pk_12_total · 2,691 ✖
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
1311888 1311888 MD     school 2400120 3   Baltimore County 240012000370 1557 Deep Creek Middle   Regular School No Middle 06 08 2021   pk_12_total 182 546 106   * *     *   60                             907 182 546 106               60                       907
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
1312247 1312247 MD     school 2400210 6   Carroll 240021000553 703 Westminster West Middle   Regular School No Middle 06 08 2021   pk_12_total 671 59 108   * 28     *   33                             904 671 59 108     28         33                       904
1244978 1244978 MD     school 2400660 21   Washington 240066001295 204 Williamsport High   Regular School No High 09 12 2020   pk_12_total 663 79 105   * *         47                             903 663 79 105               47                       903
1240043 1240043 MD     school 2400270 8   Charles 240027000600 108 Maurice J. McDonough High School   Regular School No High 09 12 2020   pk_12_total 287 438 95   * 20     *   60                             902 287 438 95     20         60                       902
1245049 1245049 MD     school 2400660 21   Washington 240066001256 601 Boonsboro High   Regular School No High 09 12 2020   pk_12_total 807 12 30   * 21         31                             902 807 12 30     21         31                       902
1312082 1312082 MD     school 2400180 5   Caroline 240018000526 302 Lockerman Middle School   Regular School No Middle 06 08 2021   pk_12_total 544 96 184     *         69                             902 544 96 184               69                       902
1239332 1239332 MD     school 2400120 3   Baltimore County 240012000370 1557 Deep Creek Middle   Regular School No Middle 06 08 2020   pk_12_total 202 539 97   * *         55                             901 202 539 97               55                       901
1317553 1317553 MD     school 2400660 21   Washington 240066001295 204 Williamsport High   Regular School No High 09 12 2021   pk_12_total 660 74 104   * 10         52                             901 660 74 104     10         52                       901
1242171 1242171 MD     school 2400480 15   Montgomery 240048000783 333 Benjamin Banneker Middle   Regular School No Middle 06 08 2020   pk_12_total 26 583 177   * 88         24                             900 26 583 177     88         24                       900
1314906 1314906 MD     school 2400480 15   Montgomery 240048000776 425 Ashburton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 343 143 162   * 159     *   87                             900 343 143 162     159         87                       900
1310095 1310095 MD     school 2400060 2   Anne Arundel 240006000072 2033 George Fox Middle   Regular School No Middle 06 08 2021   pk_12_total 634 88 88   * 18     *   62                             899 634 88 88     18         62                       899
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
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
1243869 1243869 MD     school 2400510 16   Prince George's 240051001211 1320 G. James Gholson Middle   Regular School No Middle 06 08 2020   pk_12_total 12 625 252   * *     *                                 898 12 625 252                                       898
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
1317874 1317874 MD     school 2400690 22   Wicomico 240069001145 910 Salisbury Middle   Regular School No Middle 06 08 2021   pk_12_total 222 475 83   * 41     *   69                             897 222 475 83     41         69                       897
1316662 1316662 MD     school 2400510 16   Prince George's 240051001475 1510 James Madison Middle   Regular School No Middle 06 08 2021   pk_12_total 19 743 110   * *     *   *                             895 19 743 110                                       895
1240096 1240096 MD     school 2400270 8   Charles 240027000595 608 John Hanson Middle School   Regular School No Middle 06 08 2020   pk_12_total 147 517 128   * 20     *   75                             893 147 517 128     20         75                       893
1241872 1241872 MD     school 2400480 15   Montgomery 240048090454 159 Rachel Carson Elementary   Regular School No Elementary PK 05 2020   pk_12_total 414 60 196     158         65                             893 414 60 196     158         65                       893
1242577 1242577 MD     school 2400480 15   Montgomery 240048000924 564 South Lake Elementary   Regular School No Elementary PK 05 2020   pk_12_total 10 176 632   * 49     *   23                             893 10 176 632     49         23                       893
1238351 1238351 MD     school 2400120 3   Baltimore County 240012000248 175 Western School of Technology & Env. Science   Career and Technical School No High 09 12 2020   pk_12_total 120 515 47   * 183     *   25                             892 120 515 47     183         25                       892
1244514 1244514 MD     school 2400510 16   Prince George's 240051001160 2113 Springhill Lake Elementary   Regular School No Elementary KG 05 2020   pk_12_total 13 384 478   * *     *   *                             891 13 384 478                                       891
1244227 1244227 MD     school 2400510 16   Prince George's 240051001087 1719 Langley Park/McCormick Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 34 837   * *     *   *                             890   34 837                                       890
1317570 1317570 MD     school 2400660 21   Washington 240066001263 304 E. Russell Hicks Middle   Regular School No Middle 06 08 2021   pk_12_total 395 215 157   * 31         91                             890 395 215 157     31         91                       890
1314345 1314345 MD     school 2400480 15   Montgomery 240048001417 107 Martin Luther King Jr. Middle   Regular School No Middle 06 08 2021   pk_12_total 115 319 283   * 120         50                             888 115 319 283     120         50                       888
1243049 1243049 MD     school 2400480 15   Montgomery 240048001741 835 Silver Creek Middle   Regular School No Middle 06 08 2020   pk_12_total 423 190 173     56         45                             887 423 190 173     56         45                       887
1240190 1240190 MD     school 2400270 8   Charles 240027001647 625 Theodore G. Davis Middle School   Regular School No Middle 06 08 2020   pk_12_total 71 618 83   * 32     *   72                             885 71 618 83     32         72                       885
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
1246802 1246802 MD     school 2400090 30   Baltimore City 240009000168 454 Carver Vocational-Technical High   Career and Technical School No High 09 12 2020   pk_12_total * 859 13   * *         *                             885   859 13                                       885
1312137 1312137 MD     school 2400210 6   Carroll 240021000533 202 Francis Scott Key High   Regular School No High 09 12 2021   pk_12_total 767 25 48   * *     *   35                             885 767 25 48               35                       885
1312738 1312738 MD     school 2400270 8   Charles 240027001647 625 Theodore G. Davis Middle School   Regular School No Middle 06 08 2021   pk_12_total 70 601 98   * 30     *   79                             885 70 601 98     30         79                       885
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
1242719 1242719 MD     school 2400480 15   Montgomery 240048000660 707 Rocky Hill Middle   Regular School No Middle 06 08 2020   pk_12_total 186 220 154   * 261     *   57                             883 186 220 154     261         57                       883
1246269 1246269 MD     school 2400090 30   Baltimore City 240009000244 237 Highlandtown Elementary/Middle #237   Regular School No Elementary PK 08 2020   pk_12_total 18 122 732   * *         *                             882 18 122 732                                       882
1240230 1240230 MD     school 2400270 8   Charles 240027001395 708 Robert D. Stethem Educational Center   Alternative School No High 06 12 2020   pk_12_total 25 53 *   *       *   *                             88 25 53                                         88
1316188 1316188 MD     school 2400510 16   Prince George's 240051001763 918 James Ryder Randall Early Childhood Center   Special Education School No Prekindergarten PK PK 2021   pk_12_total * 57 17     *         *                             88   57 17                                       88
1311270 1311270 MD     school 2400120 3   Baltimore County 240012000366 853 Cockeysville Middle   Regular School No Middle 06 08 2021   pk_12_total 373 217 159   * 86         42                             878 373 217 159     86         42                       878
1313741 1313741 MD     school 2400390 12   Harford 240039000709 583 North Harford Middle   Regular School No Middle 06 08 2021   pk_12_total 788 * 29   * *     *   37                             878 788   29               37                       878
1242513 1242513 MD     school 2400480 15   Montgomery 240048000837 554 Gaithersburg Middle   Regular School No Middle 06 08 2020   pk_12_total 131 180 453   * 62         50                             877 131 180 453     62         50                       877
1240757 1240757 MD     school 2400330 10   Frederick 240033000656 2606 Walkersville Middle   Regular School No Middle 06 08 2020   pk_12_total 570 108 117     24     *   56                             876 570 108 117     24         56                       876
1319221 1319221 MD     school 2400090 30   Baltimore City 240009001691 377 Green Street Academy   Regular School Yes High 06 12 2021   pk_12_total 15 843 17     *                                       876 15 843 17                                       876
1245249 1245249 MD     school 2400690 22   Wicomico 240069001319 510 Wicomico Middle   Regular School No Middle 06 08 2020   pk_12_total 198 419 156   * 16     *   77                             875 198 419 156     16         77                       875
1309917 1309917 MD     school 2400060 2   Anne Arundel 240006000050 1023 Brooklyn Park Middle   Regular School No Middle 06 08 2021   pk_12_total 370 221 190   * 18     *   69                             875 370 221 190     18         69                       875
1316469 1316469 MD     school 2400510 16   Prince George's 240051001472 1326 Kettering Middle   Regular School No Middle 06 08 2021   pk_12_total * 714 130     *     *   11                             875   714 130               11                       875
1238859 1238859 MD     school 2400120 3   Baltimore County 240012000420 973 Loch Raven High   Regular School No High 09 12 2020   pk_12_total 347 379 64   * 39     *   41                             874 347 379 64     39         41                       874
1242093 1242093 MD     school 2400480 15   Montgomery 240048000788 304 JoAnn Leleck at Broad Acres Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 101 739   * 21         *                             874   101 739     21                                 874
1242217 1242217 MD     school 2400480 15   Montgomery 240048001739 345 Hallie Wells Middle School   Regular School No Middle 06 08 2020   pk_12_total 212 178 116   * 307         59                             873 212 178 116     307         59                       873
1317624 1317624 MD     school 2400660 21   Washington 240066001256 601 Boonsboro High   Regular School No High 09 12 2021   pk_12_total 761 15 40   * 18         37                             873 761 15 40     18         37                       873
1240579 1240579 MD     school 2400330 10   Frederick 240033001163 918 Oakdale Middle   Regular School No Middle 06 08 2020   pk_12_total 624 54 83   * 56     *   50                             872 624 54 83     56         50                       872
1241365 1241365 MD     school 2400420 13   Howard 240042000856 217 Hollifield Station Elementary   Regular School No Elementary KG 05 2020   pk_12_total 212 117 108   * 401     *   28                             872 212 117 108     401         28                       872
1243865 1243865 MD     school 2400510 16   Prince George's 240051001089 1314 Largo High   Regular School No High 09 12 2020   pk_12_total * 779 70   * *     *   11                             872   779 70               11                       872
1318131 1318131 MD     school 2400090 30   Baltimore City 240009000180 27 Commodore John Rodgers Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 54 496 303   * *         *                             871 54 496 303                                       871
1244081 1244081 MD     school 2400510 16   Prince George's 240051001475 1510 James Madison Middle   Regular School No Middle 06 08 2020   pk_12_total 17 721 106   * *     *   13                             870 17 721 106               13                       870
1309952 1309952 MD     school 2400060 2   Anne Arundel 240006000066 1102 Ferndale Early Education Center   Regular School No Prekindergarten PK PK 2021   pk_12_total 30 19 21     12         *                             87 30 19 21     12                                 87
1244900 1244900 MD     school 2400630 20   Talbot 240063001243 106 Easton Middle   Regular School No Middle 06 08 2020   pk_12_total 444 149 209     24     *   42                             869 444 149 209     24         42                       869
1241844 1241844 MD     school 2400480 15   Montgomery 240048000181 155 Rosa M. Parks Middle   Regular School No Middle 06 08 2020   pk_12_total 484 121 116     91         56                             868 484 121 116     91         56                       868
1243445 1243445 MD     school 2400510 16   Prince George's 240051001034 660 Drew Freeman Middle   Regular School No Middle 06 08 2020   pk_12_total 11 693 150   * *     *   *                             868 11 693 150                                       868
1246736 1246736 MD     school 2400090 30   Baltimore City 240009000298 414 Paul Laurence Dunbar High   Regular School No High 09 12 2020   pk_12_total 15 788 52   * *         *                             868 15 788 52                                       868
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
1244809 1244809 MD     school 2400600 18   Saint Mary's 240060001220 807 Esperanza Middle   Regular School No Middle 06 08 2020   pk_12_total 461 200 81     31     *   92                             867 461 200 81     31         92                       867
1319246 1319246 MD     school 2400090 30   Baltimore City 240009000194 400 Edmondson-Westside High   Career and Technical School No High 09 12 2021   pk_12_total 11 826 24   * *     *   *                             867 11 826 24                                       867
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
1244965 1244965 MD     school 2400660 21   Washington 240066001290 201 Springfield Middle   Regular School No Middle 06 08 2020   pk_12_total 623 77 104   * 13         48                             866 623 77 104     13         48                       866
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
1242509 1242509 MD     school 2400480 15   Montgomery 240048000836 553 Gaithersburg Elementary   Regular School No Elementary PK 05 2020   pk_12_total 25 127 684   * 16         12                             865 25 127 684     16         12                       865
1243823 1243823 MD     school 2400510 16   Prince George's 240051001471 1234 Oxon Hill Middle   Regular School No Middle 06 08 2020   pk_12_total 24 355 434   * 39     *   *                             865 24 355 434     39                                 865
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
1313673 1313673 MD     school 2400390 12   Harford 240039090475 386 Fallston Middle School   Regular School No Middle 06 08 2021   pk_12_total 743 29 30   * 20         38                             864 743 29 30     20         38                       864
1314402 1314402 MD     school 2400480 15   Montgomery 240048000181 155 Rosa M. Parks Middle   Regular School No Middle 06 08 2021   pk_12_total 465 135 121     85         58                             864 465 135 121     85         58                       864
1314731 1314731 MD     school 2400480 15   Montgomery 240048000783 333 Benjamin Banneker Middle   Regular School No Middle 06 08 2021   pk_12_total 22 565 175   * 80         21                             864 22 565 175     80         21                       864
1244995 1244995 MD     school 2400660 21   Washington 240066001263 304 E. Russell Hicks Middle   Regular School No Middle 06 08 2020   pk_12_total 392 206 137     24         102                             861 392 206 137     24         102                       861
1315584 1315584 MD     school 2400480 15   Montgomery 240048000954 811 White Oak Middle   Regular School No Middle 06 08 2021   pk_12_total 40 255 462   * 83     *   18                             860 40 255 462     83         18                       860
1318831 1318831 MD     school 2400090 30   Baltimore City 240009000244 237 Highlandtown Elementary/Middle #237   Regular School No Elementary PK 08 2021   pk_12_total 15 115 720     *     *   *                             860 15 115 720                                       860
1317515 1317515 MD     school 2400630 20   Talbot 240063001250 501 Tilghman Elementary   Regular School No Elementary PK 05 2021   pk_12_total 81   *               *                             86 81                                           86
1317849 1317849 MD     school 2400690 22   Wicomico 240069001088 520 Wicomico County Evening High   Alternative School No High 09 12 2021   pk_12_total 24 46 11               *                             86 24 46 11                                       86
1316715 1316715 MD     school 2400510 16   Prince George's 240051001065 1602 Hyattsville Middle   Regular School No Middle 06 08 2021   pk_12_total 63 216 557   * 12     *   *                             859 63 216 557     12                                 859
1317540 1317540 MD     school 2400660 21   Washington 240066001290 201 Springfield Middle   Regular School No Middle 06 08 2021   pk_12_total 581 90 104   * 14     *   68                             859 581 90 104     14         68                       859
1317387 1317387 MD     school 2400600 18   Saint Mary's 240060001220 807 Esperanza Middle   Regular School No Middle 06 08 2021   pk_12_total 459 193 80     38     *   85                             858 459 193 80     38         85                       858
1241948 1241948 MD     school 2400480 15   Montgomery 240048000828 219 Farmland Elementary   Regular School No Elementary KG 05 2020   pk_12_total 404 66 94     260         32                             856 404 66 94     260         32                       856
1318215 1318215 MD     school 2400090 30   Baltimore City 240009000234 47 Hampstead Hill Academy   Regular School Yes Elementary PK 08 2021   pk_12_total 331 142 325   * 12     *   39                             855 331 142 325     12         39                       855
1317475 1317475 MD     school 2400630 20   Talbot 240063001243 106 Easton Middle   Regular School No Middle 06 08 2021   pk_12_total 424 160 207     19         44                             854 424 160 207     19         44                       854
1318746 1318746 MD     school 2400090 30   Baltimore City 240009000257 228 John Ruhrah Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 68 42 730   * *         *                             854 68 42 730                                       854
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
1241392 1241392 MD     school 2400420 13   Howard 240042000403 304 Mount View Middle   Regular School No Middle 06 08 2020   pk_12_total 390 44 35   * 331         51                             853 390 44 35     331         51                       853
1243105 1243105 MD     school 2400510 16   Prince George's 240051000995 105 Calverton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 14 264 529   * 37     *   *                             853 14 264 529     37                                 853
1246701 1246701 MD     school 2400090 30   Baltimore City 240009000194 400 Edmondson-Westside High   Career and Technical School No High 09 12 2020   pk_12_total 10 826 13   * *     *                                 853 10 826 13                                       853
1246678 1246678 MD     school 2400090 30   Baltimore City 240009001691 377 Green Street Academy   Regular School Yes High 06 12 2020   pk_12_total 20 815 16     *                                       852 20 815 16                                       852
1246186 1246186 MD     school 2400090 30   Baltimore City 240009000257 228 John Ruhrah Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 62 35 741   * *         *                             851 62 35 741                                       851
1311708 1311708 MD     school 2400120 3   Baltimore County 240012001439 1451 Golden Ring Middle   Regular School No Middle 06 08 2021   pk_12_total 136 523 112   * 42         33                             851 136 523 112     42         33                       851
1238332 1238332 MD     school 2400120 3   Baltimore County 240012000354 151 Catonsville Middle   Regular School No Middle 06 08 2020   pk_12_total 508 174 61   * 73     *   30                             850 508 174 61     73         30                       850
1241702 1241702 MD     school 2400420 13   Howard 240042001032 625 Gorman Crossing Elementary   Regular School No Elementary PK 05 2020   pk_12_total 171 288 91   * 235     *   61                             849 171 288 91     235         61                       849
1312644 1312644 MD     school 2400270 8   Charles 240027000595 608 John Hanson Middle School   Regular School No Middle 06 08 2021   pk_12_total 135 488 129   * 17     *   72                             849 135 488 129     17         72                       849
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
1243004 1243004 MD     school 2400480 15   Montgomery 240048000954 811 White Oak Middle   Regular School No Middle 06 08 2020   pk_12_total 38 264 455     68     *   18                             845 38 264 455     68         18                       845
1313913 1313913 MD     school 2400420 13   Howard 240042000173 216 Burleigh Manor Middle School   Regular School No Middle 06 08 2021   pk_12_total 267 93 45   * 391         44                             844 267 93 45     391         44                       844
1317881 1317881 MD     school 2400690 22   Wicomico 240069001300 1103 Delmar Elementary   Regular School No Elementary PK 04 2021   pk_12_total 505 158 68   * 33         78                             843 505 158 68     33         78                       843
1314381 1314381 MD     school 2400480 15   Montgomery 240048000759 115 Neelsville Middle   Regular School No Middle 06 08 2021   pk_12_total 54 235 420   * 98         32                             842 54 235 420     98         32                       842
1245639 1245639 MD     school 2400090 30   Baltimore City 240009000234 47 Hampstead Hill Academy   Regular School Yes Elementary PK 08 2020   pk_12_total 320 138 332   * 13     *   31                             840 320 138 332     13         31                       840
1315637 1315637 MD     school 2400480 15   Montgomery 240048001460 916 Rock Terrace School   Special Education School No High 06 12 2021   pk_12_total 23 24 22     11         *                             84 23 24 22     11                                 84

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