enrollments

Data source: Big Local News · About: Big Local

1,398 rows where grade = "pk_12_total", state = "MD" and year = 2020 sorted by total descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 1,398 ✖

grade ✖

  • pk_12_total · 1,398 ✖
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
1241010 1241010 MD     school 2400390 12   Harford 240039000694 304 Harford Technical High   Career and Technical School No High 09 12 2020   pk_12_total 698 145 81   * 34     *   38                             999 698 145 81     34         38                       999
1242896 1242896 MD     school 2400480 15   Montgomery 240048001446 787 A. Mario Loiederman Middle   Regular School No Middle 06 08 2020   pk_12_total 142 154 626   * 43         30                             999 142 154 626     43         30                       999
1238525 1238525 MD     school 2400120 3   Baltimore County 240012000441 353 Sudbrook Magnet Middle   Regular School No Middle 06 08 2020   pk_12_total 115 608 178   * 64         29                             998 115 608 178     64         29                       998
1245497 1245497 MD     school 2400090 30   Baltimore City 240009000264 12 Lakeland Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 39 324 621   * *         *                             998 39 324 621                                       998
1237962 1237962 MD     school 2400060 2   Anne Arundel 240006000132 4023 Southern High   Regular School No High 09 12 2020   pk_12_total 729 75 132   * *     *   51                             996 729 75 132               51                       996
1243037 1243037 MD     school 2400480 15   Montgomery 240048000820 820 Earle B. Wood Middle   Regular School No Middle 06 08 2020   pk_12_total 249 126 456     111     *   51                             994 249 126 456     111         51                       994
1237897 1237897 MD     school 2400060 2   Anne Arundel 240006000108 3343 Old Mill Middle South   Regular School No Middle 06 08 2020   pk_12_total 477 225 174     38     *   72                             990 477 225 174     38         72                       990
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
1241991 1241991 MD     school 2400480 15   Montgomery 240048001450 232 Tilden Middle School   Regular School No Middle 06 08 2020   pk_12_total 434 125 213   * 166     *   48                             989 434 125 213     166         48                       989
1242723 1242723 MD     school 2400480 15   Montgomery 240048000863 708 Kingsview Middle   Regular School No Middle 06 08 2020   pk_12_total 232 265 149     277     *   57                             983 232 265 149     277         57                       983
1243762 1243762 MD     school 2400510 16   Prince George's 240051001017 1217 Crossland High   Regular School No High 09 12 2020   pk_12_total 13 626 320   * 11         *                             975 13 626 320     11                                 975
1241108 1241108 MD     school 2400390 12   Harford 240039000691 382 Fallston High   Regular School No High 09 12 2020   pk_12_total 839 39 36   * 21     *   35                             973 839 39 36     21         35                       973
1238521 1238521 MD     school 2400120 3   Baltimore County 240012000448 352 Pikesville Middle   Regular School No Middle 06 08 2020   pk_12_total 162 642 86   * 39     *   34                             972 162 642 86     39         34                       972
1238719 1238719 MD     school 2400120 3   Baltimore County 240012001422 855 Hereford Middle   Regular School No Middle 06 08 2020   pk_12_total 839 21 38     40         34                             972 839 21 38     40         34                       972
1240517 1240517 MD     school 2400330 10   Frederick 240033001429 715 Centerville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 452 99 139   * 206     *   73                             972 452 99 139     206         73                       972
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
1241934 1241934 MD     school 2400480 15   Montgomery 240048000799 215 Carl Sandburg Center   Special Education School No Elementary KG 05 2020   pk_12_total 17 36 33     10         *                             97 17 36 33     10                                 97
1240414 1240414 MD     school 2400330 10   Frederick 240033001413 219 Monocacy Middle   Regular School No Middle 06 08 2020   pk_12_total 268 224 380   * 40     *   49                             969 268 224 380     40         49                       969
1245330 1245330 MD     school 2400690 22   Wicomico 240069001299 1308 Bennett Middle   Regular School No Middle 06 08 2020   pk_12_total 389 337 122   * 35     *   71                             965 389 337 122     35         71                       965
1243898 1243898 MD     school 2400510 16   Prince George's 240051001473 1330 Kenmoor Middle   Regular School No Middle 06 08 2020   pk_12_total 41 620 245   * 48     *   *                             964 41 620 245     48                                 964
1241381 1241381 MD     school 2400420 13   Howard 240042001646 219 Veterans Elementary   Regular School No Elementary PK 05 2020   pk_12_total 217 130 75   * 499     *   33                             962 217 130 75     499         33                       962
1238864 1238864 MD     school 2400120 3   Baltimore County 240012000230 975 George W. Carver Center for Arts & Technology   Career and Technical School No High 09 12 2020   pk_12_total 439 349 58   * 63     *   44                             961 439 349 58     63         44                       961
1239351 1239351 MD     school 2400120 3   Baltimore County 240012000362 1574 Chesapeake High   Regular School No High 09 12 2020   pk_12_total 267 525 102   * *     *   50                             961 267 525 102               50                       961
1243681 1243681 MD     school 2400510 16   Prince George's 240051001052 1103 Gwynn Park High   Regular School No High 09 12 2020   pk_12_total 34 778 105   * 13     *   26                             961 34 778 105     13         26                       961
1238844 1238844 MD     school 2400120 3   Baltimore County 240012000451 957 Pine Grove Middle   Regular School No Middle 06 08 2020   pk_12_total 410 375 50   * 69     *   49                             960 410 375 50     69         49                       960
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
1239104 1239104 MD     school 2400120 3   Baltimore County 240012000342 1356 Arbutus Middle   Regular School No Middle 06 08 2020   pk_12_total 489 214 40   * 136     *   67                             951 489 214 40     136         67                       951
1241354 1241354 MD     school 2400420 13   Howard 240042090449 215 Waverly Elementary   Regular School No Elementary PK 05 2020   pk_12_total 328 59 30   * 481         48                             951 328 59 30     481         48                       951
1242065 1242065 MD     school 2400480 15   Montgomery 240048000644 248 Forest Oak Middle   Regular School No Middle 06 08 2020   pk_12_total 95 228 547   * 52     *   26                             950 95 228 547     52         26                       950
1243467 1243467 MD     school 2400510 16   Prince George's 240051001424 705 Tall Oaks High   Alternative School No High 11 12 2020   pk_12_total * 63 25   * *                                       95   63 25                                       95
1239532 1239532 MD     school 2400180 5   Caroline 240018000526 302 Lockerman Middle School   Regular School No Middle 06 08 2020   pk_12_total 591 97 179     *         73                             949 591 97 179               73                       949
1240405 1240405 MD     school 2400330 10   Frederick 240033000658 211 West Frederick Middle   Regular School No Middle 06 08 2020   pk_12_total 242 229 374     47     *   52                             947 242 229 374     47         52                       947
1241822 1241822 MD     school 2400480 15   Montgomery 240048000759 115 Neelsville Middle   Regular School No Middle 06 08 2020   pk_12_total 48 287 499   * 81     *   24                             945 48 287 499     81         24                       945
1243202 1243202 MD     school 2400510 16   Prince George's 240051001171 214 Templeton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 59 183 527   * 164     *   *                             943 59 183 527     164                                 943
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
1242183 1242183 MD     school 2400480 15   Montgomery 240048090450 335 Briggs Chaney Middle   Regular School No Middle 06 08 2020   pk_12_total 64 504 236     98     *   33                             936 64 504 236     98         33                       936
1239697 1239697 MD     school 2400210 6   Carroll 240021000553 703 Westminster West Middle   Regular School No Middle 06 08 2020   pk_12_total 725 44 94   * 29     *   36                             935 725 44 94     29         36                       935
1241117 1241117 MD     school 2400390 12   Harford 240039090475 386 Fallston Middle School   Regular School No Middle 06 08 2020   pk_12_total 808 29 30   * 25         38                             934 808 29 30     25         38                       934
1245305 1245305 MD     school 2400690 22   Wicomico 240069001300 1103 Delmar Elementary   Regular School No Elementary PK 04 2020   pk_12_total 587 146 75   * 24     *   98                             932 587 146 75     24         98                       932
1238825 1238825 MD     school 2400120 3   Baltimore County 240012001435 923 White Oak School   Special Education School No Elementary PK 05 2020   pk_12_total 39 36 *     *         *                             93 39 36                                         93
1243121 1243121 MD     school 2400510 16   Prince George's 240051001354 108 James E. Duckworth Regional Center   Special Education School No Other KG 12 2020   pk_12_total * 33 52     *         *                             93   33 52                                       93
1241185 1241185 MD     school 2400390 12   Harford 240039000709 583 North Harford Middle   Regular School No Middle 06 08 2020   pk_12_total 851 * 20   * 11     *   33                             929 851   20     11         33                       929
1241234 1241234 MD     school 2400420 13   Howard 240042000728 101 Elkridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 342 244 76   * 186     *   71                             923 342 244 76     186         71                       923
1238530 1238530 MD     school 2400120 3   Baltimore County 240012000449 371 Pikesville High   Regular School No High 09 12 2020   pk_12_total 301 464 76   * 54     *   21                             922 301 464 76     54         21                       922
1239587 1239587 MD     school 2400210 6   Carroll 240021000533 202 Francis Scott Key High   Regular School No High 09 12 2020   pk_12_total 811 31 39   * *     *   28                             922 811 31 39               28                       922
1242337 1242337 MD     school 2400480 15   Montgomery 240048000776 425 Ashburton Elementary   Regular School No Elementary KG 05 2020   pk_12_total 362 153 160   * 160     *   81                             922 362 153 160     160         81                       922
1243057 1243057 MD     school 2400480 15   Montgomery 240048001460 916 Rock Terrace School   Special Education School No High 06 12 2020   pk_12_total 27 26 24     11         *                             92 27 26 24     11                                 92
1244236 1244236 MD     school 2400510 16   Prince George's 240051000510 1725 Cool Spring Elementary   Regular School No Elementary PK 06 2020   pk_12_total 12 26 867   * *         *                             915 12 26 867                                       915
1241530 1241530 MD     school 2400420 13   Howard 240042090478 523 Pointers Run Elementary   Regular School No Elementary PK 05 2020   pk_12_total 414 105 33   * 291     *   67                             912 414 105 33     291         67                       912
1238715 1238715 MD     school 2400120 3   Baltimore County 240012000366 853 Cockeysville Middle   Regular School No Middle 06 08 2020   pk_12_total 391 251 154   * 71     *   41                             910 391 251 154     71         41                       910
1241294 1241294 MD     school 2400420 13   Howard 240042001444 202 Ellicott Mills Middle   Regular School No Middle 06 08 2020   pk_12_total 361 153 43   * 296     *   52                             909 361 153 43     296         52                       909
1244134 1244134 MD     school 2400510 16   Prince George's 240051001065 1602 Hyattsville Middle   Regular School No Middle 06 08 2020   pk_12_total 82 237 567   * 11     *   *                             909 82 237 567     11                                 909
1245555 1245555 MD     school 2400090 30   Baltimore City 240009000180 27 Commodore John Rogers Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 48 530 308   * 11         *                             907 48 530 308     11                                 907
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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