enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pk_12_total · 2,691 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black ▼ hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
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
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

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