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
1310749 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 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 * * *                                             *                                              
1310755 1310755 MD     school 2400120 3   Baltimore County 240012001754 53 Northeast EDLP at Parkville High School   Alternative School No High 11 12 2021   pk_12_total * * *                                             15                                             15
1310758 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 * * *                                             *                                              
1310765 1310765 MD     school 2400120 3   Baltimore County 240012000935 58 Home Assignments-Secondary   Alternative School No High 08 12 2021   pk_12_total * *                                               12                                             12
1311174 1311174 MD     school 2400120 3   Baltimore County 240012000386 501 Fifth District Elementary   Regular School No Elementary KG 05 2021   pk_12_total 247 * 19   * *         12                             281 247   19               12                       281
1311181 1311181 MD     school 2400120 3   Baltimore County 240012000456 601 Prettyboy Elementary   Regular School No Elementary KG 05 2021   pk_12_total 360 * *     *         *                             385 360                                           385
1311189 1311189 MD     school 2400120 3   Baltimore County 240012000473 701 Seventh District Elementary   Regular School No Elementary PK 05 2021   pk_12_total 295 * 14   * *         18                             337 295   14               18                       337
1311293 1311293 MD     school 2400120 3   Baltimore County 240012000465 907 Rodgers Forge Elementary   Regular School No Elementary KG 05 2021   pk_12_total 298 * 26     33     *   25                             392 298   26     33         25                       392
1311426 1311426 MD     school 2400120 3   Baltimore County 240012000352 1001 Carroll Manor Elementary   Regular School No Elementary KG 05 2021   pk_12_total 309 * 14     *         15                             351 309   14               15                       351
1311433 1311433 MD     school 2400120 3   Baltimore County 240012000467 1002 Jacksonville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 411 * 20     22         20                             480 411   20     22         20                       480
1311440 1311440 MD     school 2400120 3   Baltimore County 240012000413 1104 Kingsville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 242 * *     *     *   *                             272 242                                           272
1311773 1311773 MD     school 2400120 3   Baltimore County 240012000363 1511 Chesapeake Terrace Elementary   Regular School No Elementary PK 05 2021   pk_12_total 253 * *   * *         *                             273 253                                           273
1311876 1311876 MD     school 2400120 3   Baltimore County 240012001406 1534 Oliver Beach Elementary   Regular School No Elementary PK 05 2021   pk_12_total 147 * *     *         14                             168 147                   14                       168
1311972 1311972 MD     school 2400150 4   Calvert 240015000509 206 Calvert Country School   Special Education School No Other 03 12 2021   pk_12_total 23 *     * *         *                             38 23                                           38
1312292 1312292 MD     school 2400210 6   Carroll 240021000527 712 Carroll Springs School   Special Education School No Other 01 12 2021   pk_12_total 25 * *                                             28 25                                           28
1312312 1312312 MD     school 2400210 6   Carroll 240021001548 716 Gateway School   Alternative School No High 09 12 2021   pk_12_total 42 * *   * *         *                             51 42                                           51
1312314 1312314 MD     school 2400210 6   Carroll 240021001348 717 Post Secondary Program   Alternative School No High 12 12 2021   pk_12_total 40 * *     *         *                             50 40                                           50
1312318 1312318 MD     school 2400210 6   Carroll 240021001349 718 PRIDE School   Alternative School No Elementary 01 05 2021   pk_12_total * * *                                             *                                              
1312350 1312350 MD     school 2400210 6   Carroll 240021001350 903 Flexible Student Support   Alternative School No High 09 12 2021   pk_12_total 28 *                                               32 28                                           32
1312366 1312366 MD     school 2400210 6   Carroll 240021000532 1201 Elmer A. Wolfe Elementary   Regular School No Elementary PK 05 2021   pk_12_total 379 * 11   * *         18                             416 379   11               18                       416
1312405 1312405 MD     school 2400240 7   Cecil 240024000565 205 Chesapeake City Elementary   Regular School No Elementary PK 05 2021   pk_12_total 309 * 21               15                             349 309   21               15                       349
1312446 1312446 MD     school 2400240 7   Cecil 240024000572 315 Leeds Elementary   Regular School No Elementary PK 05 2021   pk_12_total 300 * 19               25                             350 300   19               25                       350
1312515 1312515 MD     school 2400240 7   Cecil 240024000580 606 Rising Sun Middle School   Regular School No Middle 06 08 2021   pk_12_total 618 * 42   * *         20                             685 618   42               20                       685
1312523 1312523 MD     school 2400240 7   Cecil 240024000579 607 Rising Sun Elementary   Regular School No Elementary PK 05 2021   pk_12_total 562 * 41   * *         23                             634 562   41               23                       634
1312556 1312556 MD     school 2400240 7   Cecil 240024000566 801 Conowingo Elementary   Regular School No Elementary PK 05 2021   pk_12_total 373 * 14   *           10                             407 373   14               10                       407
1312569 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
1312855 1312855 MD     school 2400300 9   Dorchester 240030000622 508 South Dorchester School   Regular School No Elementary PK 08 2021   pk_12_total 189 * 10     *     *   11                             219 189   10               11                       219
1313032 1313032 MD     school 2400330 10   Frederick 240033000631 503 Emmitsburg Elementary   Regular School No Elementary PK 05 2021   pk_12_total 177 * *     *         12                             201 177                   12                       201
1313039 1313039 MD     school 2400330 10   Frederick 240033000659 603 Wolfsville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 105 * *               *                             123 105                                           123
1313081 1313081 MD     school 2400330 10   Frederick 240033000637 801 Liberty Elementary   Regular School No Elementary KG 05 2021   pk_12_total 172 * 16   * *         17                             215 172   16               17                       215
1313151 1313151 MD     school 2400330 10   Frederick 240033000648 1001 Sabillasville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 60 * *               *                             70 60                                           70
1313159 1313159 MD     school 2400330 10   Frederick 240033001442 1105 New Midway/Woodsboro Elementary   Regular School No Elementary PK 05 2021   pk_12_total 245 * 16               20                             287 245   16               20                       287
1313186 1313186 MD     school 2400330 10   Frederick 240033000629 1509 Catoctin High   Regular School No High 09 12 2021   pk_12_total 642 * 41   * *     *   19                             719 642   41               19                       719
1313190 1313190 MD     school 2400330 10   Frederick 240033000651 1510 Thurmont Middle   Regular School No Middle 06 08 2021   pk_12_total 514 * 30     *         20                             573 514   30               20                       573
1313218 1313218 MD     school 2400330 10   Frederick 240033000636 2001 Lewistown Elementary   Regular School No Elementary PK 05 2021   pk_12_total 120 * 26               *                             161 120   26                                       161
1313370 1313370 MD     school 2400360 11   Garrett 240036000664 1707 Broad Ford Elementary   Regular School No Elementary PK 05 2021   pk_12_total 539 * *     *         *                             561 539                                           561
1313404 1313404 MD     school 2400360 11   Garrett 240036000675 2708 Southern Middle School   Regular School No Middle 06 08 2021   pk_12_total 447 * *     *         11                             468 447                   11                       468
1313414 1313414 MD     school 2400360 11   Garrett 240036000674 3709 Southern Garrett High School   Regular School No High 09 12 2021   pk_12_total 653 * *     *         16                             678 653                   16                       678
1313695 1313695 MD     school 2400390 12   Harford 240039000702 436 Jarrettsville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 383 * 17           *   18                             426 383   17               18                       426
1313710 1313710 MD     school 2400390 12   Harford 240039090476 447 North Bend Elementary   Regular School No Elementary PK 05 2021   pk_12_total 338 * 12     *         19                             378 338   12               19                       378
1313717 1313717 MD     school 2400390 12   Harford 240039000685 518 Darlington Elementary   Regular School No Elementary KG 05 2021   pk_12_total 80 * *     *         *                             98 80                                           98
1313725 1313725 MD     school 2400390 12   Harford 240039000687 522 Dublin Elementary   Regular School No Elementary PK 05 2021   pk_12_total 192 * *               12                             215 192                   12                       215
1313732 1313732 MD     school 2400390 12   Harford 240039001443 544 North Harford Elementary   Regular School No Elementary KG 05 2021   pk_12_total 310 * *     *         12                             331 310                   12                       331
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
1313994 1313994 MD     school 2400420 13   Howard 240042000741 407 Lisbon Elementary   Regular School No Elementary KG 05 2021   pk_12_total 301 * 40     14         19                             377 301   40     14         19                       377
1314842 1314842 MD     school 2400480 15   Montgomery 240048000948 408 Westbrook Elementary   Regular School No Elementary PK 05 2021   pk_12_total 234 * 48   * 18         20                             331 234   48     18         20                       331
1315194 1315194 MD     school 2400480 15   Montgomery 240048001635 587 PEP - Itinerant   Special Education School No Prekindergarten PK PK 2021   pk_12_total 14 * *     *         *                             40 14                                           40
1315245 1315245 MD     school 2400480 15   Montgomery 240048000876 652 Monocacy Elementary   Regular School No Elementary PK 05 2021   pk_12_total 95 * 21     *         *                             136 95   21                                       136
1317149 1317149 MD     school   16   Prince George's   2217 Incarcerated Youth Center (JACS)             2021   pk_12_total   * *               *                             11                                             11
1317152 1317152 MD     school 2400510 16   Prince George's 240051001755 2218 Career and Technical Education Evening High   Career and Technical School No High 11 12 2021   pk_12_total   * 21   *           *                             27     21                                       27
1317156 1317156 MD     school 2400510 16   Prince George's 240051001476 2300 Prekindergarten Offsites   Regular School No Prekindergarten PK PK 2021   pk_12_total * * *                                             *                                              
1317198 1317198 MD     school 2400540 17   Queen Anne's 240054001194 402 Kent Island Elementary School   Regular School No Elementary PK 02 2021   pk_12_total 302 * 30   * *         22                             370 302   30               22                       370
1317219 1317219 MD     school 2400540 17   Queen Anne's 240054001557 406 Matapeake Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 358 * 22     *         24                             415 358   22               24                       415
1317458 1317458 MD     school 2400570 19   Somerset 240057001202 1401 Deal Island School   Regular School No Elementary PK 05 2021   pk_12_total 98 * *     *         *                             121 98                                           121
1317507 1317507 MD     school 2400630 20   Talbot 240063001241 401 Chapel District Elementary   Regular School No Elementary PK 05 2021   pk_12_total 278 * 25     *         20                             335 278   25               20                       335
1317528 1317528 MD     school 2400660 21   Washington 240066001284 101 Sharpsburg Elementary   Regular School No Elementary PK 05 2021   pk_12_total 296 * *               *                             308 296                                           308
1317590 1317590 MD     school 2400660 21   Washington 240066001261 401 Clear Spring Middle   Regular School No Middle 06 08 2021   pk_12_total 307 * 12     *         13                             340 307   12               13                       340
1317598 1317598 MD     school 2400660 21   Washington 240066001259 402 Clear Spring Elementary   Regular School No Elementary PK 05 2021   pk_12_total 335 * *               *                             348 335                                           348
1317603 1317603 MD     school 2400660 21   Washington 240066001260 403 Clear Spring High   Regular School No High 09 12 2021   pk_12_total 424 * 22     *         14                             470 424   22               14                       470
1317619 1317619 MD     school 2400660 21   Washington 240066001269 502 Hancock Elementary   Regular School No Elementary PK 05 2021   pk_12_total 205 * *     *         *                             213 205                                           213
1317671 1317671 MD     school 2400660 21   Washington 240066001277 903 Old Forge Elementary   Regular School No Elementary PK 05 2021   pk_12_total 265 * 17               11                             298 265   17               11                       298
1317683 1317683 MD     school 2400660 21   Washington 240066001280 1101 Pleasant Valley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 183 * *   * *         *                             204 183                                           204
1317699 1317699 MD     school 2400660 21   Washington 240066001258 1401 Cascade Elementary   Regular School No Elementary PK 05 2021   pk_12_total 121 * *   * *         *                             130 121                                           130
1317739 1317739 MD     school 2400660 21   Washington 240066001265 2002 Fountain Rock Elementary   Regular School No Elementary PK 05 2021   pk_12_total 219 * 21     *         *                             258 219   21                                       258
1317775 1317775 MD     school 2400660 21   Washington 240066001289 2505 Marshall Street School   Special Education School No Other PK 12 2021   pk_12_total 24 * *     *         *                             41 24                                           41
1317821 1317821 MD     school 2400690 22   Wicomico 240069001312 406 Pittsville Elementary & Middle   Regular School No Middle 04 08 2021   pk_12_total 322 * 23   * *         29                             387 322   23               29                       387
1317917 1317917 MD     school 2400690 22   Wicomico 240069001322 1404 Willards Elementary   Regular School No Elementary PK 03 2021   pk_12_total 209 * 23   * *     *   22                             260 209   23               22                       260
1237567 1237567 MD     school 2400060 2   Anne Arundel 240006000046 2082 Bodkin Elementary   Regular School No Elementary KG 05 2020   pk_12_total 485 10 35     *         25                             557 485 10 35               25                       557
1238197 1238197 MD     school 2400120 3   Baltimore County 240012001759 55 Southeast EDLP at Dundalk High School   Alternative School No High 10 12 2020   pk_12_total * 10 *               *                             18   10                                         18
1238878 1238878 MD     school 2400120 3   Baltimore County 240012000467 1002 Jacksonville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 469 10 24     25     *   21                             550 469 10 24     25         21                       550
1240008 1240008 MD     school 2400240 7   Cecil 240024000566 801 Conowingo Elementary   Regular School No Elementary PK 05 2020   pk_12_total 427 10 14   *           11                             464 427 10 14               11                       464
1244737 1244737 MD     school 2400600 18   Saint Mary's 240060001232 504 Mechanicsville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 238 10 16   * *         19                             287 238 10 16               19                       287
1245096 1245096 MD     school 2400660 21   Washington 240066001277 903 Old Forge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 299 10 13     *         12                             335 299 10 13               12                       335
1312226 1312226 MD     school 2400210 6   Carroll 240021000536 601 Manchester Elementary   Regular School No Elementary PK 05 2021   pk_12_total 525 10 37     *     *   17                             599 525 10 37               17                       599
1313580 1313580 MD     school 2400390 12   Harford 240039000684 316 Churchville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 284 10 15   * *         25                             338 284 10 15               25                       338
1317315 1317315 MD     school 2400600 18   Saint Mary's 240060001232 504 Mechanicsville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 232 10 13   * *     *   20                             280 232 10 13               20                       280
1317649 1317649 MD     school 2400660 21   Washington 240066001286 702 Smithsburg Elementary   Regular School No Elementary PK 05 2021   pk_12_total 270 10 17   *           22                             320 270 10 17               22                       320
1237612 1237612 MD     school 2400060 2   Anne Arundel 240006000084 2152 Jones Elementary   Regular School No Elementary KG 05 2020   pk_12_total 242 11 19     21         17                             310 242 11 19     21         17                       310
1238077 1238077 MD     school 2400060 2   Anne Arundel 240006000097 4212 Mayo Elementary   Regular School No Elementary KG 05 2020   pk_12_total 279 11 34     *     *   19                             347 279 11 34               19                       347
1239786 1239786 MD     school 2400210 6   Carroll 240021000535 804 Hampstead Elementary   Regular School No Elementary PK 05 2020   pk_12_total 345 11 19     *         16                             393 345 11 19               16                       393
1239995 1239995 MD     school 2400240 7   Cecil 240024000556 704 Bainbridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 240 11 *   *       *   23                             284 240 11                 23                       284
1240649 1240649 MD     school 2400330 10   Frederick 240033000642 1604 Myersville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 362 11 23   * *         18                             418 362 11 23               18                       418
1241025 1241025 MD     school 2400390 12   Harford 240039000684 316 Churchville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 326 11 10   *           22                             370 326 11 10               22                       370
1310136 1310136 MD     school 2400060 2   Anne Arundel 240006000051 2092 Cape St. Claire Elementary   Regular School No Elementary KG 05 2021   pk_12_total 427 11 68   * 16     *   41                             566 427 11 68     16         41                       566
1310412 1310412 MD     school 2400060 2   Anne Arundel 240006000130 3212 South Shore Elementary   Regular School No Elementary KG 05 2021   pk_12_total 175 11 52   * *         22                             268 175 11 52               22                       268
1312239 1312239 MD     school 2400210 6   Carroll 240021001652 603 Ebb Valley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 474 11 14   * 10     *   13                             527 474 11 14     10         13                       527
1312371 1312371 MD     school 2400210 6   Carroll 240021001414 1304 Parr's Ridge Elementary   Regular School No Elementary PK 02 2021   pk_12_total 292 11 57     *     *   17                             384 292 11 57               17                       384
1312934 1312934 MD     school 2400330 10   Frederick 240033001410 208 Heather Ridge   Alternative School No High 07 12 2021   pk_12_total 22 11 *   *           *                             44 22 11                                         44
1314586 1314586 MD     school 2400480 15   Montgomery 240048000809 238 Cold Spring Elementary   Regular School No Elementary PK 05 2021   pk_12_total 139 11 14     128         25                             317 139 11 14     128         25                       317
1317655 1317655 MD     school 2400660 21   Washington 240066001484 705 Washington County Job Development Center   Special Education School No High 12 12 2021   pk_12_total 18 11 *               *                             34 18 11                                         34
1317707 1317707 MD     school 2400660 21   Washington 240066001268 1602 Greenbrier Elementary   Regular School No Elementary PK 05 2021   pk_12_total 170 11 11     18         10                             220 170 11 11     18         10                       220
1237642 1237642 MD     school 2400060 2   Anne Arundel 240006000121 2192 Riviera Beach Elementary   Regular School No Elementary PK 05 2020   pk_12_total 252 12 16   * *         22                             312 252 12 16               22                       312
1239778 1239778 MD     school 2400210 6   Carroll 240021000542 801 North Carroll Middle   Regular School No Middle 06 08 2020   pk_12_total 554 12 34   * 14     *   11                             628 554 12 34     14         11                       628
1242022 1242022 MD     school 2400480 15   Montgomery 240048000809 238 Cold Spring Elementary   Regular School No Elementary KG 05 2020   pk_12_total 137 12 17     137         29                             332 137 12 17     137         29                       332
1242643 1242643 MD     school 2400480 15   Montgomery 240048000798 604 Carderock Springs Elementary   Regular School No Elementary KG 05 2020   pk_12_total 222 12 41   * 60     *   29                             366 222 12 41     60         29                       366
1244578 1244578 MD     school 2400510 16   Prince George's 240051001476 2300 Prekindergarten Offsites   Regular School No Prekindergarten PK PK 2020   pk_12_total * 12 *               *                             16   12                                         16
1244883 1244883 MD     school 2400570 19   Somerset 240057001202 1401 Deal Island School   Regular School No Elementary PK 05 2020   pk_12_total 115 12 *     *         *                             139 115 12                                         139
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
1245440 1245440 MD     school 2400720 23   Worcester 240072001327 1001 Ocean City Elementary   Regular School No Elementary PK 04 2020   pk_12_total 455 12 76     12         37                             592 455 12 76     12         37                       592

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