enrollments

Data source: Big Local News · About: Big Local

19,213 rows where state = "MD" sorted by black_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

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
1237214 1237214 MD     school 2400030 1   Allegany 240003000014 301 Flintstone Elementary   Regular School No Elementary PK 05 2020   pk_12_total 210 * *               *                             221 210                                           221
1237275 1237275 MD     school 2400030 1   Allegany 240003000010 701 Cresaptown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 284 * 12     *     *   16                             320 284   12               16                       320
1237283 1237283 MD     school 2400030 1   Allegany 240003000005 702 Bel Air Elementary   Regular School No Elementary PK 05 2020   pk_12_total 204 * *     *         11                             225 204                   11                       225
1237291 1237291 MD     school 2400030 1   Allegany 240003000033 801 Westernport Elementary   Regular School No Elementary PK 05 2020   pk_12_total 242 * *           *   11                             260 242                   11                       260
1237315 1237315 MD     school 2400030 1   Allegany 240003000023 1301 Mount Savage Middle   Regular School No Middle 06 08 2020   pk_12_total 369 * *   * *     *   12                             394 369                   12                       394
1237336 1237336 MD     school 2400030 1   Allegany 240003000003 2801 Beall Elementary   Regular School No Elementary PK 05 2020   pk_12_total 386 * *   * *         30                             441 386                   30                       441
1237560 1237560 MD     school 2400060 2   Anne Arundel 240006000045 2072 Benfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 350 * 21   * *         28                             410 350   21               28                       410
1237619 1237619 MD     school 2400060 2   Anne Arundel 240006000085 2162 Lake Shore Elementary   Regular School No Elementary KG 05 2020   pk_12_total 288 * 18     *         19                             327 288   18               19                       327
1237649 1237649 MD     school 2400060 2   Anne Arundel 240006000125 2202 Severna Park Elementary   Regular School No Elementary KG 05 2020   pk_12_total 381 * 15   * 22         16                             442 381   15     22         16                       442
1237713 1237713 MD     school 2400060 2   Anne Arundel 240006001421 2432 Shipley's Choice Elementary   Regular School No Elementary KG 05 2020   pk_12_total 350 * *     12         17                             394 350         12         17                       394
1237847 1237847 MD     school 2400060 2   Anne Arundel 240006000130 3212 South Shore Elementary   Regular School No Elementary KG 05 2020   pk_12_total 230 * 57   * *         36                             340 230   57               36                       340
1238002 1238002 MD     school 2400060 2   Anne Arundel 240006001746 4102 Carrie Weedon Early Education Center   Regular School No Prekindergarten PK PK 2020   pk_12_total 36 * 17     *                                       61 36   17                                       61
1238023 1238023 MD     school 2400060 2   Anne Arundel 240006000063 4132 Deale Elementary   Regular School No Elementary KG 05 2020   pk_12_total 189 * 17               *                             219 189   17                                       219
1238038 1238038 MD     school 2400060 2   Anne Arundel 240006000065 4152 Edgewater Elementary   Regular School No Elementary KG 05 2020   pk_12_total 390 * 135   * 14     *   23                             573 390   135     14         23                       573
1238185 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   * *                                             *                                              
1238189 1238189 MD     school 2400120 3   Baltimore County 240012001751 52 Southwest EDLP at Woodlawn High School   Alternative School No High 09 12 2020   pk_12_total * * *     *         *                             14                                             14
1238193 1238193 MD     school 2400120 3   Baltimore County 240012001754 53 Northeast EDLP at Parkville High School   Alternative School No High 10 12 2020   pk_12_total * * *                                             18                                             18
1238199 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 1238203 MD     school 2400120 3   Baltimore County 240012000925 57 Home Assignments-Elementary   Alternative School No Middle 04 06 2020   pk_12_total   *                                               *                                              
1238619 1238619 MD     school 2400120 3   Baltimore County 240012000386 501 Fifth District Elementary   Regular School No Elementary KG 05 2020   pk_12_total 280 * 23   * *         13                             322 280   23               13                       322
1238626 1238626 MD     school 2400120 3   Baltimore County 240012000456 601 Prettyboy Elementary   Regular School No Elementary KG 05 2020   pk_12_total 396 * *     *         11                             422 396                   11                       422
1238634 1238634 MD     school 2400120 3   Baltimore County 240012000473 701 Seventh District Elementary   Regular School No Elementary PK 05 2020   pk_12_total 364 * 13   * *         13                             404 364   13               13                       404
1238738 1238738 MD     school 2400120 3   Baltimore County 240012000465 907 Rodgers Forge Elementary   Regular School No Elementary KG 05 2020   pk_12_total 359 * 26     43     *   32                             468 359   26     43         32                       468
1238871 1238871 MD     school 2400120 3   Baltimore County 240012000352 1001 Carroll Manor Elementary   Regular School No Elementary KG 05 2020   pk_12_total 346 * 13     *         18                             389 346   13               18                       389
1238885 1238885 MD     school 2400120 3   Baltimore County 240012000413 1104 Kingsville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 287 * 11     10     *   11                             326 287   11     10         11                       326
1239217 1239217 MD     school 2400120 3   Baltimore County 240012000363 1511 Chesapeake Terrace Elementary   Regular School No Elementary PK 05 2020   pk_12_total 266 * *   * *         *                             286 266                                           286
1239320 1239320 MD     school 2400120 3   Baltimore County 240012001406 1534 Oliver Beach Elementary   Regular School No Elementary PK 05 2020   pk_12_total 161 * *     *         15                             185 161                   15                       185
1239417 1239417 MD     school 2400150 4   Calvert 240015000509 206 Calvert Country School   Special Education School No Other 03 12 2020   pk_12_total 29 * *   * *         *                             46 29                                           46
1239512 1239512 MD     school 2400150 4   Calvert 240015001344 500 Calvert County Alternative School   Alternative School No High 09 12 2020   pk_12_total * * *                                             *                                              
1239676 1239676 MD     school 2400210 6   Carroll 240021000536 601 Manchester Elementary   Regular School No Elementary PK 05 2020   pk_12_total 595 * 39     10     *   10                             663 595   39     10         10                       663
1239744 1239744 MD     school 2400210 6   Carroll 240021000527 712 Carroll Springs School   Special Education School No Other PK 12 2020   pk_12_total 26 * *     *                                       33 26                                           33
1239764 1239764 MD     school 2400210 6   Carroll 240021001548 716 Gateway School   Alternative School No High 09 12 2020   pk_12_total 54 * *   * *         *                             66 54                                           66
1239766 1239766 MD     school 2400210 6   Carroll 240021001348 717 Post Secondary Program   Alternative School No High 12 12 2020   pk_12_total 41 * *                                             44 41                                           44
1239771 1239771 MD     school 2400210 6   Carroll 240021001349 718 PRIDE School   Alternative School No Elementary 01 05 2020   pk_12_total * *                                               *                                              
1239818 1239818 MD     school 2400210 6   Carroll 240021000532 1201 Elmer A. Wolfe Elementary   Regular School No Elementary PK 05 2020   pk_12_total 400 * 11   * *         18                             437 400   11               18                       437
1239823 1239823 MD     school 2400210 6   Carroll 240021001414 1304 Parr's Ridge Elementary   Regular School No Elementary PK 02 2020   pk_12_total 367 * 63     *     *   15                             459 367   63               15                       459
1239857 1239857 MD     school 2400240 7   Cecil 240024000565 205 Chesapeake City Elementary   Regular School No Elementary PK 05 2020   pk_12_total 306 * 20               18                             349 306   20               18                       349
1239898 1239898 MD     school 2400240 7   Cecil 240024000572 315 Leeds Elementary   Regular School No Elementary PK 05 2020   pk_12_total 351 * 26               39                             423 351   26               39                       423
1239963 1239963 MD     school 2400240 7   Cecil 240024090468 515 Elk Neck Elementary   Regular School No Elementary PK 05 2020   pk_12_total 399 * 12     *         25                             443 399   12               25                       443
1239967 1239967 MD     school 2400240 7   Cecil 240024000580 606 Rising Sun Middle School   Regular School No Middle 06 08 2020   pk_12_total 640 * 34   * *         21                             702 640   34               21                       702
1239975 1239975 MD     school 2400240 7   Cecil 240024000579 607 Rising Sun Elementary   Regular School No Elementary PK 05 2020   pk_12_total 602 * 46     *         26                             681 602   46               26                       681
1240021 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
1240308 1240308 MD     school 2400300 9   Dorchester 240030000622 508 South Dorchester School   Regular School No Elementary PK 08 2020   pk_12_total 196 * 15     *     *   12                             231 196   15               12                       231
1240486 1240486 MD     school 2400330 10   Frederick 240033000631 503 Emmitsburg Elementary   Regular School No Elementary PK 05 2020   pk_12_total 193 * *     *         12                             220 193                   12                       220
1240493 1240493 MD     school 2400330 10   Frederick 240033000659 603 Wolfsville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 130 * *   *           *                             149 130                                           149
1240528 1240528 MD     school 2400330 10   Frederick 240033000637 801 Liberty Elementary   Regular School No Elementary KG 05 2020   pk_12_total 216 * 22   * *         17                             262 216   22               17                       262
1240552 1240552 MD     school 2400330 10   Frederick 240033001379 914 New Market Middle   Regular School No Middle 06 08 2020   pk_12_total 484 * 33   * 11     *   24                             563 484   33     11         24                       563
1240598 1240598 MD     school 2400330 10   Frederick 240033000648 1001 Sabillasville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 75 * *               *                             82 75                                           82
1240606 1240606 MD     school 2400330 10   Frederick 240033001442 1105 New Midway/Woodsboro Elementary   Regular School No Elementary PK 05 2020   pk_12_total 251 * 20               16                             292 251   20               16                       292
1240633 1240633 MD     school 2400330 10   Frederick 240033000629 1509 Catoctin High   Regular School No High 09 12 2020   pk_12_total 672 * 38   * *     *   22                             749 672   38               22                       749
1240637 1240637 MD     school 2400330 10   Frederick 240033000651 1510 Thurmont Middle   Regular School No Middle 06 08 2020   pk_12_total 494 * 24   * *     *   15                             545 494   24               15                       545
1240657 1240657 MD     school 2400330 10   Frederick 240033000159 1801 Twin Ridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 396 * 46   * *         17                             473 396   46               17                       473
1240665 1240665 MD     school 2400330 10   Frederick 240033000636 2001 Lewistown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 139 * 35               14                             195 139   35               14                       195
1240786 1240786 MD     school 2400360 11   Garrett 240036000667 1202 Friendsville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 133 * *               *                             142 133                                           142
1240817 1240817 MD     school 2400360 11   Garrett 240036000664 1707 Broad Ford Elementary   Regular School No Elementary PK 05 2020   pk_12_total 561 * *               *                             582 561                                           582
1240825 1240825 MD     school 2400360 11   Garrett 240036000852 1710 Yough Glades Elementary   Regular School No Elementary PK 05 2020   pk_12_total 295 * *               *                             308 295                                           308
1240851 1240851 MD     school 2400360 11   Garrett 240036000675 2708 Southern Middle School   Regular School No Middle 06 08 2020   pk_12_total 487 * *     *         12                             507 487                   12                       507
1240861 1240861 MD     school 2400360 11   Garrett 240036000674 3709 Southern Garrett High School   Regular School No High 09 12 2020   pk_12_total 670 * 12     *         15                             701 670   12               15                       701
1241046 1241046 MD     school 2400390 12   Harford 240039000692 328 Forest Lakes Elementary   Regular School No Elementary KG 05 2020   pk_12_total 383 * 25     *         22                             445 383   25               22                       445
1241139 1241139 MD     school 2400390 12   Harford 240039000702 436 Jarrettsville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 408 * 14     *     *   18                             450 408   14               18                       450
1241154 1241154 MD     school 2400390 12   Harford 240039090476 447 North Bend Elementary   Regular School No Elementary PK 05 2020   pk_12_total 365 * 14     *         17                             402 365   14               17                       402
1241161 1241161 MD     school 2400390 12   Harford 240039000685 518 Darlington Elementary   Regular School No Elementary KG 05 2020   pk_12_total 91 * *     *         *                             104 91                                           104
1241169 1241169 MD     school 2400390 12   Harford 240039000687 522 Dublin Elementary   Regular School No Elementary PK 05 2020   pk_12_total 199 * 12               16                             230 199   12               16                       230
1241176 1241176 MD     school 2400390 12   Harford 240039001443 544 North Harford Elementary   Regular School No Elementary KG 05 2020   pk_12_total 353 * *     *         12                             373 353                   12                       373
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
1241439 1241439 MD     school 2400420 13   Howard 240042000741 407 Lisbon Elementary   Regular School No Elementary KG 05 2020   pk_12_total 353 * 40     16         29                             443 353   40     16         29                       443
1242276 1242276 MD     school 2400480 15   Montgomery 240048000948 408 Westbrook Elementary   Regular School No Elementary KG 05 2020   pk_12_total 238 * 51   * 18         24                             341 238   51     18         24                       341
1242666 1242666 MD     school 2400480 15   Montgomery 240048000876 652 Monocacy Elementary   Regular School No Elementary KG 05 2020   pk_12_total 106 * 21     *         14                             151 106   21               14                       151
1244572 1244572 MD     school   16   Prince George's   2217 Incarcerated Youth Center (JACS)             2020   pk_12_total   * *                                             10                                             10
1244574 1244574 MD     school 2400510 16   Prince George's 240051001755 2218 Career and Technical Education Evening High   Career and Technical School No Secondary 11 11 2020   pk_12_total   * 12   *           *                             15     12                                       15
1244641 1244641 MD     school 2400540 17   Queen Anne's 240054001557 406 Matapeake Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 383 * 23   * *         25                             442 383   23               25                       442
1244645 1244645 MD     school 2400540 17   Queen Anne's 240054001644 407 Matapeake Middle School   Regular School No Middle 06 08 2020   pk_12_total 296 * 25     *         19                             352 296   25               19                       352
1244953 1244953 MD     school 2400660 21   Washington 240066001284 101 Sharpsburg Elementary   Regular School No Elementary PK 05 2020   pk_12_total 238 * *   *           *                             248 238                                           248
1245015 1245015 MD     school 2400660 21   Washington 240066001261 401 Clear Spring Middle   Regular School No Middle 06 08 2020   pk_12_total 312 * 23     *         15                             356 312   23               15                       356
1245023 1245023 MD     school 2400660 21   Washington 240066001259 402 Clear Spring Elementary   Regular School No Elementary PK 05 2020   pk_12_total 389 * *               10                             411 389                   10                       411
1245028 1245028 MD     school 2400660 21   Washington 240066001260 403 Clear Spring High   Regular School No High 09 12 2020   pk_12_total 415 * 20     *         15                             460 415   20               15                       460
1245044 1245044 MD     school 2400660 21   Washington 240066001269 502 Hancock Elementary   Regular School No Elementary PK 05 2020   pk_12_total 220 * *   * *         *                             229 220                                           229
1245080 1245080 MD     school 2400660 21   Washington 240066001484 705 Washington County Job Development Center   Special Education School No High 12 12 2020   pk_12_total 23 * *               *                             33 23                                           33
1245108 1245108 MD     school 2400660 21   Washington 240066001280 1101 Pleasant Valley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 238 * *   * *         *                             262 238                                           262
1245124 1245124 MD     school 2400660 21   Washington 240066001258 1401 Cascade Elementary   Regular School No Elementary PK 05 2020   pk_12_total 139 * *     *         *                             150 139                                           150
1245132 1245132 MD     school 2400660 21   Washington 240066001268 1602 Greenbrier Elementary   Regular School No Elementary PK 05 2020   pk_12_total 173 * *     18         *                             215 173         18                                 215
1245164 1245164 MD     school 2400660 21   Washington 240066001265 2002 Fountain Rock Elementary   Regular School No Elementary PK 05 2020   pk_12_total 250 * 19     *         *                             286 250   19                                       286
1245199 1245199 MD     school 2400660 21   Washington 240066001289 2505 Marshall Street School   Special Education School No Other KG 12 2020   pk_12_total 25 * *     *         *                             43 25                                           43
1245341 1245341 MD     school 2400690 22   Wicomico 240069001322 1404 Willards Elementary   Regular School No Elementary PK 03 2020   pk_12_total 259 * 27   * *     *   27                             323 259   27               27                       323
1309775 1309775 MD     school 2400030 1   Allegany 240003000014 301 Flintstone Elementary   Regular School No Elementary PK 05 2021   pk_12_total 193 * *               *                             205 193                                           205
1309815 1309815 MD     school 2400030 1   Allegany 240003000030 601 Center for Career & Technical Education   Career and Technical School No High 11 12 2021   pk_12_total 245 * *   *           *                             258 245                                           258
1309836 1309836 MD     school 2400030 1   Allegany 240003000010 701 Cresaptown Elementary   Regular School No Elementary PK 05 2021   pk_12_total 251 * *   * *     *   17                             287 251                   17                       287
1309852 1309852 MD     school 2400030 1   Allegany 240003000033 801 Westernport Elementary   Regular School No Elementary PK 05 2021   pk_12_total 239 * *           *   10                             256 239                   10                       256
1309876 1309876 MD     school 2400030 1   Allegany 240003000023 1301 Mount Savage Middle   Regular School No Middle 06 08 2021   pk_12_total 355 * *   * *     *   13                             383 355                   13                       383
1309884 1309884 MD     school 2400030 1   Allegany 240003001546 1302 Mt. Savage Elementary   Regular School No Elementary PK 05 2021   pk_12_total 181 * *   *           *                             186 181                                           186
1309897 1309897 MD     school 2400030 1   Allegany 240003000003 2801 Beall Elementary   Regular School No Elementary PK 05 2021   pk_12_total 384 * *   * *         41                             445 384                   41                       445
1310122 1310122 MD     school 2400060 2   Anne Arundel 240006000045 2072 Benfield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 334 * 23   * *         23                             392 334   23               23                       392
1310129 1310129 MD     school 2400060 2   Anne Arundel 240006000046 2082 Bodkin Elementary   Regular School No Elementary KG 05 2021   pk_12_total 423 * 33     *         19                             483 423   33               19                       483
1310182 1310182 MD     school 2400060 2   Anne Arundel 240006000085 2162 Lake Shore Elementary   Regular School No Elementary PK 05 2021   pk_12_total 275 * 19               21                             317 275   19               21                       317
1310204 1310204 MD     school 2400060 2   Anne Arundel 240006000121 2192 Riviera Beach Elementary   Regular School No Elementary PK 05 2021   pk_12_total 224 * 15   * 12         19                             280 224   15     12         19                       280
1310211 1310211 MD     school 2400060 2   Anne Arundel 240006000125 2202 Severna Park Elementary   Regular School No Elementary KG 05 2021   pk_12_total 333 * 17   * 22         17                             392 333   17     22         17                       392
1310275 1310275 MD     school 2400060 2   Anne Arundel 240006001421 2432 Shipley's Choice Elementary   Regular School No Elementary KG 05 2021   pk_12_total 320 * *     13         23                             369 320         13         23                       369
1310566 1310566 MD     school 2400060 2   Anne Arundel 240006001746 4102 Carrie Weedon Early Education Center   Regular School No Prekindergarten PK PK 2021   pk_12_total 33 * 21               *                             62 33   21                                       62
1310587 1310587 MD     school 2400060 2   Anne Arundel 240006000063 4132 Deale Elementary   Regular School No Elementary KG 05 2021   pk_12_total 172 * 18     *         *                             209 172   18                                       209
1310641 1310641 MD     school 2400060 2   Anne Arundel 240006000097 4212 Mayo Elementary   Regular School No Elementary KG 05 2021   pk_12_total 286 * 39     *         18                             353 286   39               18                       353

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