Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • pk_12_total · 2,791
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
1238185 MD     school 2400120 3   Baltimore County 240012001756 51 Northwest EDLP at Milford Mill Academy   Alternative School No High 11 12 2020   pk_12_total   * *                                             *                                              
1238199 MD     school 2400120 3   Baltimore County 240012001760 56 Central EDLP at Loch Raven High School   Alternative School No High 12 12 2020   pk_12_total * *                                               *                                              
1238203 MD     school 2400120 3   Baltimore County 240012000925 57 Home Assignments-Elementary   Alternative School No Middle 04 06 2020   pk_12_total   *                                               *                                              
1239512 MD     school 2400150 4   Calvert 240015001344 500 Calvert County Alternative School   Alternative School No High 09 12 2020   pk_12_total * * *                                             *                                              
1239771 MD     school 2400210 6   Carroll 240021001349 718 PRIDE School   Alternative School No Elementary 01 05 2020   pk_12_total * *                                               *                                              
1239774 MD     school 2400210 6   Carroll 240021001694 726 Crossroads Middle School   Alternative School No Middle 06 08 2020   pk_12_total *   *               *                             *                                              
1244872 MD     school 2400570 19   Somerset 240057001203 1003 Ewell School   Regular School No Elementary PK 07 2020   pk_12_total *                                                 *                                              
1310749 MD     school 2400120 3   Baltimore County 240012001756 51 Northwest EDLP at Milford Mill Academy   Alternative School No High 10 12 2021   pk_12_total   *                                               *                                              
1310752 MD     school 2400120 3   Baltimore County 240012001751 52 Southwest EDLP at Woodlawn High School   Alternative School No High 11 12 2021   pk_12_total * * *                                             *                                              
1310758 MD     school 2400120 3   Baltimore County 240012001759 55 Southeast EDLP at Dundalk High School   Alternative School No High 10 12 2021   pk_12_total * * *                                             *                                              
1310760 MD     school 2400120 3   Baltimore County 240012001760 56 Central EDLP at Loch Raven High School   Alternative School No High 12 12 2021   pk_12_total *                                                 *                                              
1312318 MD     school 2400210 6   Carroll 240021001349 718 PRIDE School   Alternative School No Elementary 01 05 2021   pk_12_total * * *                                             *                                              
1312321 MD     school 2400210 6   Carroll 240021001694 726 Crossroads Middle School   Alternative School No Middle 07 08 2021   pk_12_total *   *                                             *                                              
1317156 MD     school 2400510 16   Prince George's 240051001476 2300 Prekindergarten Offsites   Regular School No Prekindergarten PK PK 2021   pk_12_total * * *                                             *                                              
1317447 MD     school 2400570 19   Somerset 240057001203 1003 Ewell School   Regular School No Middle 01 07 2021   pk_12_total *                                                 *                                              
1244572 MD     school   16   Prince George's   2217 Incarcerated Youth Center (JACS)             2020   pk_12_total   * *                                             10                                             10
1242617 MD     school 2400480 15   Montgomery 240048001635 587 PEP - Itinerant   Special Education School No Prekindergarten PK PK 2020   pk_12_total 43 18 16   * 16         *                             100 43 18 16     16                                 100
1245177 MD     school 2400660 21   Washington 240066001293 2501 Western Heights Middle   Regular School No Middle 06 08 2020   pk_12_total 481 235 160     19         106                             1001 481 235 160     19         106                       1001
1317293 MD     school 2400600 18   Saint Mary's 240060001231 404 Margaret Brent Middle   Regular School No Middle 06 08 2021   pk_12_total 807 72 48   * *     *   65                             1002 807 72 48               65                       1002
1243134 MD     school 2400510 16   Prince George's 240051001101 110 Martin Luther King Jr. Middle   Regular School No Middle 06 08 2020   pk_12_total 44 490 367   * 70     *   26                             1003 44 490 367     70         26                       1003
1242134 MD     school 2400480 15   Montgomery 240048090453 311 Francis Scott Key Middle   Regular School No Middle 06 08 2020   pk_12_total 27 437 420   * 90     *   26                             1004 27 437 420     90         26                       1004
1311659 MD     school 2400120 3   Baltimore County 240012000342 1356 Arbutus Middle   Regular School No Middle 06 08 2021   pk_12_total 522 205 46   * 140     *   83                             1004 522 205 46     140         83                       1004
1239866 MD     school 2400240 7   Cecil 240024000568 302 Elkton High   Regular School No High 09 12 2020   pk_12_total 480 288 128   * 13     *   91                             1005 480 288 128     13         91                       1005
1244940 MD     school 2400630 20   Talbot 240063001250 501 Tilghman Elementary   Regular School No Elementary PK 05 2020   pk_12_total 89   *               *                             101 89                                           101
1316047 MD     school 2400510 16   Prince George's 240051001424 705 Tall Oaks High   Alternative School No High 11 12 2021   pk_12_total * 56 40               *                             101   56 40                                       101
1242833 MD     school 2400480 15   Montgomery 240048001457 775 Eastern Middle School   Regular School No Middle 06 08 2020   pk_12_total 195 189 509   * 77     *   37                             1010 195 189 509     77         37                       1010
1239836 MD     school 2400210 6   Carroll 240021000546 1401 South Carroll High   Regular School No High 09 12 2020   pk_12_total 881 18 68   * 22     *   17                             1011 881 18 68     22         17                       1011
1239955 MD     school 2400240 7   Cecil 240024000575 514 North East High   Regular School No High 09 12 2020   pk_12_total 840 62 55   * 12         42                             1016 840 62 55     12         42                       1016
1314578 MD     school 2400480 15   Montgomery 240048001447 237 Robert Frost Middle School   Regular School No Middle 06 08 2021   pk_12_total 375 105 81   * 399     *   54                             1017 375 105 81     399         54                       1017
1310462 MD     school 2400060 2   Anne Arundel 240006000108 3343 Old Mill Middle South   Regular School No Middle 06 08 2021   pk_12_total 495 237 169   * 33     *   80                             1018 495 237 169     33         80                       1018
1318888 MD     school 2400090 30   Baltimore City 240009000268 245 Leith Walk Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 950 48   * *     *   *                             1018   950 48                                       1018
1239162 MD     school 2400120 3   Baltimore County 240012000438 1473 Overlea High   Regular School No High 09 12 2020   pk_12_total 173 665 105   * 28     *   45                             1020 173 665 105     28         45                       1020
1312503 MD     school 2400240 7   Cecil 240024000575 514 North East High   Regular School No High 09 12 2021   pk_12_total 843 62 58   * 10         43                             1020 843 62 58     10         43                       1020
1240521 MD     school 2400330 10   Frederick 240033001536 716 Urbana Middle   Regular School No Middle 06 08 2020   pk_12_total 548 73 123   * 203     *   67                             1021 548 73 123     203         67                       1021
1241542 MD     school 2400420 13   Howard 240042000859 525 Fulton Elementary   Regular School No Elementary KG 05 2020   pk_12_total 423 164 47   * 296     *   89                             1021 423 164 47     296         89                       1021
1314536 MD     school 2400480 15   Montgomery 240048000849 228 Herbert Hoover Middle   Regular School No Middle 06 08 2021   pk_12_total 400 81 76   * 399     *   63                             1021 400 81 76     399         63                       1021
1314553 MD     school 2400480 15   Montgomery 240048001450 232 Tilden Middle School   Regular School No Middle 06 08 2021   pk_12_total 423 141 227   * 173     *   55                             1022 423 141 227     173         55                       1022
1246326 MD     school 2400090 30   Baltimore City 240009000268 245 Leith Walk Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 945 60     *     *   *                             1023   945 60                                       1023
1243045 MD     school 2400480 15   Montgomery 240048000409 823 Argyle Middle   Regular School No Middle 06 08 2020   pk_12_total 72 256 582   * 88         25                             1024 72 256 582     88         25                       1024
1244698 MD     school 2400600 18   Saint Mary's 240060001229 305 Leonardtown Middle   Regular School No Middle 06 08 2020   pk_12_total 782 89 52   * 25     *   72                             1024 782 89 52     25         72                       1024
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
1312819 MD     school 2400270 8   Charles 240027000597 1002 Henry E. Lackey High School   Regular School No High 09 12 2021   pk_12_total 276 578 72   * 22     *   66                             1024 276 578 72     22         66                       1024
1316262 MD     school 2400510 16   Prince George's 240051001052 1103 Gwynn Park High   Regular School No High 09 12 2021   pk_12_total 31 825 117   * 16     *   28                             1025 31 825 117     16         28                       1025
1240165 MD     school 2400270 8   Charles 240027000615 621 Mattawoman Middle School   Regular School No Middle 06 08 2020   pk_12_total 52 748 107   * 52     *   62                             1026 52 748 107     52         62                       1026
1242015 MD     school 2400480 15   Montgomery 240048001447 237 Robert Frost Middle School   Regular School No Middle 06 08 2020   pk_12_total 387 116 77   * 399         45                             1028 387 116 77     399         45                       1028
1317276 MD     school 2400600 18   Saint Mary's 240060001229 305 Leonardtown Middle   Regular School No Middle 06 08 2021   pk_12_total 802 84 53   * 20     *   67                             1029 802 84 53     20         67                       1029
1315701 MD     school 2400510 16   Prince George's 240051001354 108 James E. Duckworth Regional Center   Special Education School No Other KG 12 2021   pk_12_total * 34 57     *         *                             103   34 57                                       103
1243498 MD     school 2400510 16   Prince George's 240051000982 714 Benjamin Tasker Middle School   Regular School No Middle 06 08 2020   pk_12_total 124 708 118   * 48     *   21                             1031 124 708 118     48         21                       1031
1310527 MD     school 2400060 2   Anne Arundel 240006000132 4023 Southern High   Regular School No High 09 12 2021   pk_12_total 719 73 176     10     *   53                             1032 719 73 176     10         53                       1032
1244070 MD     school 2400510 16   Prince George's 240051001036 1502 Frederick Douglass High   Regular School No High 09 12 2020   pk_12_total 16 905 68   * *     *   36                             1033 16 905 68               36                       1033
1241069 MD     school 2400390 12   Harford 240039000701 335 Homestead/Wakefield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 753 59 75   * 69     *   75                             1034 753 59 75     69         75                       1034
1239328 MD     school 2400120 3   Baltimore County 240012001440 1556 Middle River Middle   Regular School No Middle 06 08 2020   pk_12_total 343 466 115   * 36     *   70                             1035 343 466 115     36         70                       1035
1244896 MD     school 2400630 20   Talbot 240063001244 104 Easton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 309 219 423     26         62                             1039 309 219 423     26         62                       1039
1241161 MD     school 2400390 12   Harford 240039000685 518 Darlington Elementary   Regular School No Elementary KG 05 2020   pk_12_total 91 * *     *         *                             104 91                                           104
1242647 MD     school 2400480 15   Montgomery 240048001526 606 Cabin John Middle School   Regular School No Middle 06 08 2020   pk_12_total 408 120 84   * 365         62                             1040 408 120 84     365         62                       1040
1314414 MD     school 2400480 15   Montgomery 240048000493 157 Roberto W. Clemente Middle   Regular School No Middle 06 08 2021   pk_12_total 120 304 359   * 203     *   51                             1040 120 304 359     203         51                       1040
1310458 MD     school 2400060 2   Anne Arundel 240006000107 3333 Old Mill Middle North   Regular School No Middle 06 08 2021   pk_12_total 312 479 145   * 42     *   59                             1042 312 479 145     42         59                       1042
1244715 MD     school 2400600 18   Saint Mary's 240060001231 404 Margaret Brent Middle   Regular School No Middle 06 08 2020   pk_12_total 848 81 42   * *     *   60                             1043 848 81 42               60                       1043
1315625 MD     school 2400480 15   Montgomery 240048000409 823 Argyle Middle   Regular School No Middle 06 08 2021   pk_12_total 79 249 599   * 78         36                             1043 79 249 599     78         36                       1043
1237966 MD     school 2400060 2   Anne Arundel 240006000036 4033 Annapolis Middle   Regular School No Middle 06 08 2020   pk_12_total 208 297 498   * 13     *   26                             1044 208 297 498     13         26                       1044
1239651 MD     school 2400210 6   Carroll 240021001394 507 Liberty High   Regular School No High 09 12 2020   pk_12_total 861 44 54   * 43     *   33                             1044 861 44 54     43         33                       1044
1241974 MD     school 2400480 15   Montgomery 240048000849 228 Herbert Hoover Middle   Regular School No Middle 06 08 2020   pk_12_total 430 74 89     392     *   59                             1045 430 74 89     392         59                       1045
1238476 MD     school 2400120 3   Baltimore County 240012000458 272 Randallstown High   Regular School No High 09 12 2020   pk_12_total 14 951 44   * 23         15                             1048 14 951 44     23         15                       1048
1315302 MD     school 2400480 15   Montgomery 240048000863 708 Kingsview Middle   Regular School No Middle 06 08 2021   pk_12_total 232 280 187   * 276     *   67                             1048 232 280 187     276         67                       1048
1317471 MD     school 2400630 20   Talbot 240063001244 104 Easton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 304 217 424     33         70                             1048 304 217 424     33         70                       1048
1312573 MD     school 2400270 8   Charles 240027000601 104 Milton M. Somers Middle School   Regular School No Middle 06 08 2021   pk_12_total 386 437 103   * 37     *   83                             1049 386 437 103     37         83                       1049
1243632 MD     school 2400510 16   Prince George's 240051001024 1010 Dwight D. Eisenhower Middle   Regular School No Middle 06 08 2020   pk_12_total 46 524 437   * 17     *   21                             1052 46 524 437     17         21                       1052
1237706 MD     school 2400060 2   Anne Arundel 240006000042 2423 Chesapeake Bay Middle   Regular School No Middle 06 08 2020   pk_12_total 898 44 61   * 14         31                             1056 898 44 61     14         31                       1056
1241083 MD     school 2400390 12   Harford 240039000717 348 Youths Benefit Elementary   Regular School No Elementary KG 05 2020   pk_12_total 939 14 40   * 24     *   34                             1057 939 14 40     24         34                       1057
1310531 MD     school 2400060 2   Anne Arundel 240006000036 4033 Annapolis Middle   Regular School No Middle 06 08 2021   pk_12_total 157 309 549   * 19     *   25                             1061 157 309 549     19         25                       1061
1312414 MD     school 2400240 7   Cecil 240024000568 302 Elkton High   Regular School No High 09 12 2021   pk_12_total 493 290 151   * 13     *   107                             1061 493 290 151     13         107                       1061
1310268 MD     school 2400060 2   Anne Arundel 240006000042 2423 Chesapeake Bay Middle   Regular School No Middle 06 08 2021   pk_12_total 908 31 60   * 15         43                             1062 908 31 60     15         43                       1062
1239381 MD     school 2400150 4   Calvert 240015000611 113 Patuxent High   Regular School No High 09 12 2020   pk_12_total 698 186 65   * 24     *   85                             1063 698 186 65     24         85                       1063
1239346 MD     school 2400120 3   Baltimore County 240012000477 1573 Sparrows Point High   Regular School No High 09 12 2020   pk_12_total 881 79 52   * 10     *   41                             1067 881 79 52     10         41                       1067
1244657 MD     school 2400600 18   Saint Mary's 240060001237 101 Spring Ridge Middle   Regular School No Middle 06 08 2020   pk_12_total 402 377 125   * 32     *   122                             1067 402 377 125     32         122                       1067
1317235 MD     school 2400600 18   Saint Mary's 240060001237 101 Spring Ridge Middle   Regular School No Middle 06 08 2021   pk_12_total 417 366 128   * 33     *   118                             1067 417 366 128     33         118                       1067
1237722 MD     school 2400060 2   Anne Arundel 240006000039 3023 Arundel Middle   Regular School No Middle 06 08 2020   pk_12_total 480 283 118   * 57     *   122                             1068 480 283 118     57         122                       1068
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
1245273 MD     school 2400690 22   Wicomico 240069001088 520 Wicomico County Evening High   Alternative School No High 09 12 2020   pk_12_total 38 55 10     *         *                             107 38 55 10                                       107
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
1312569 MD     school 2400240 7   Cecil 240024090469 905 Rising Sun High   Regular School No High 09 12 2021   pk_12_total 972 * 58   * *         27                             1076 972   58               27                       1076
1315225 MD     school 2400480 15   Montgomery 240048001526 606 Cabin John Middle School   Regular School No Middle 06 08 2021   pk_12_total 414 137 104   * 357         64                             1077 414 137 104     357         64                       1077
1239702 MD     school 2400210 6   Carroll 240021001185 704 Winters Mill High   Regular School No High 09 12 2020   pk_12_total 792 75 126   * 34     *   48                             1079 792 75 126     34         48                       1079
1245258 MD     school 2400690 22   Wicomico 240069001320 513 Wicomico High   Regular School No High 09 12 2020   pk_12_total 323 535 112   * 31         74                             1079 323 535 112     31         74                       1079
1315661 MD     school 2400480 15   Montgomery 240048001398 965 John L Gildner Regional Inst for Children & Adol   Special Education School No Other 04 12 2021   pk_12_total 33 37 25     *         10                             108 33 37 25               10                       108
1312252 MD     school 2400210 6   Carroll 240021001185 704 Winters Mill High   Regular School No High 09 12 2021   pk_12_total 780 79 125   * 38     *   55                             1080 780 79 125     38         55                       1080
1237893 MD     school 2400060 2   Anne Arundel 240006000107 3333 Old Mill Middle North   Regular School No Middle 06 08 2020   pk_12_total 345 475 144   * 48     *   66                             1081 345 475 144     48         66                       1081
1313639 MD     school 2400390 12   Harford 240039000717 348 Youths Benefit Elementary   Regular School No Elementary PK 05 2021   pk_12_total 942 22 44   * 27     *   37                             1082 942 22 44     27         37                       1082
1245335 MD     school 2400690 22   Wicomico 240069001309 1309 Parkside High   Regular School No High 09 12 2020   pk_12_total 590 351 52   * 35         54                             1083 590 351 52     35         54                       1083
1311936 MD     school 2400150 4   Calvert 240015000611 113 Patuxent High   Regular School No High 09 12 2021   pk_12_total 716 190 68   * 20         88                             1085 716 190 68     20         88                       1085
1240025 MD     school 2400270 8   Charles 240027000601 104 Milton M. Somers Middle School   Regular School No Middle 06 08 2020   pk_12_total 444 428 86   * 45     *   79                             1086 444 428 86     45         79                       1086
1244244 MD     school 2400510 16   Prince George's 240051001257 1730 Mary Harris   Regular School No Elementary PK 05 2020   pk_12_total 32 43 1000   * *         *                             1091 32 43 1000                                       1091
1311031 MD     school 2400120 3   Baltimore County 240012000458 272 Randallstown High   Regular School No High 09 12 2021   pk_12_total 16 1001 44     22         14                             1097 16 1001 44     22         14                       1097
1311902 MD     school 2400120 3   Baltimore County 240012000477 1573 Sparrows Point High   Regular School No High 09 12 2021   pk_12_total 877 87 70   * 14     *   43                             1097 877 87 70     14         43                       1097
1317149 MD     school   16   Prince George's   2217 Incarcerated Youth Center (JACS)             2021   pk_12_total   * *               *                             11                                             11
1240021 MD     school 2400240 7   Cecil 240024090469 905 Rising Sun High   Regular School No High 09 12 2020   pk_12_total 990 * 59   * 11         28                             1100 990   59     11         28                       1100
1311266 MD     school 2400120 3   Baltimore County 240012001434 852 Ridgely Middle   Regular School No Middle 06 08 2021   pk_12_total 676 105 61   * 207     *   45                             1100 676 105 61     207         45                       1100
1316213 MD     school 2400510 16   Prince George's 240051001024 1010 Dwight D. Eisenhower Middle   Regular School No Middle 06 08 2021   pk_12_total 35 540 495   * 25     *   14                             1112 35 540 495     25         14                       1112
1238711 MD     school 2400120 3   Baltimore County 240012001434 852 Ridgely Middle   Regular School No Middle 06 08 2020   pk_12_total 689 109 64   * 196     *   49                             1113 689 109 64     196         49                       1113
1317911 MD     school 2400690 22   Wicomico 240069001309 1309 Parkside High   Regular School No High 09 12 2021   pk_12_total 577 368 67   * 33         64                             1113 577 368 67     33         64                       1113

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