Data source: Big Local News · About: Big Local

9,615 rows where state = "MD" and year = 2020 sorted by hispanic_int

View and edit SQL

year

  • 2020 · 9,415
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
1244723 MD     school 2400600 18   Saint Mary's 240060001399 501 Lettie Marshall Dent Elem   Regular School No Elementary PK 05 2020   pk_12_total 511 21 14   * *         27                             583 511 21 14               27                       583
1244805 MD     school 2400600 18   Saint Mary's 240060001239 806 Town Creek Elementary   Regular School No Elementary KG 05 2020   pk_12_total 142 29 14   * *         23                             216 142 29 14               23                       216
1245478 MD     school 2400090 30   Baltimore City 240009000253 10 James McHenry Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 20 577 14     *     *   *                             625 20 577 14                                       625
1246380 MD     school 2400090 30   Baltimore City 240009000163 251 Callaway Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 282 14     *         *                             303   282 14                                       303
1246621 MD     school 2400090 30   Baltimore City 240009001735 362 Bard High School Early College   Regular School No High 09 12 2020   pk_12_total 43 384 14     *     *   *                             446 43 384 14                                       446
1237251 MD     school 2400030 1   Allegany 240003000006 504 Braddock Middle   Regular School No Middle 06 08 2020   pk_12_total 510 26 15     10     *   57                             620 510 26 15     10         57                       620
1237267 MD     school 2400030 1   Allegany 240003000001 606 Allegany High   Regular School No High 09 12 2020   pk_12_total 631 21 15   * 11         41                             721 631 21 15     11         41                       721
1237514 MD     school 2400060 2   Anne Arundel 240006000094 1274 Marley Glen School   Special Education School No Other PK 11 2020   pk_12_total 91 32 15   * 11     *   *                             160 91 32 15     11                                 160
1237589 MD     school 2400060 2   Anne Arundel 240006000068 2112 Fort Smallwood Elementary   Regular School No Elementary PK 05 2020   pk_12_total 416 18 15     *         14                             468 416 18 15               14                       468
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
1238593 MD     school 2400120 3   Baltimore County 240012001730 410 Lyons Mill Elementary   Regular School No Elementary KG 05 2020   pk_12_total 34 609 15   * 67         30                             759 34 609 15     67         30                       759
1238794 MD     school 2400120 3   Baltimore County 240012000463 916 Cromwell Valley Elementary Technology   Regular School No Elementary PK 05 2020   pk_12_total 142 158 15   * 31         28                             375 142 158 15     31         28                       375
1238817 MD     school 2400120 3   Baltimore County 240012000483 922 Ridge Ruxton   Special Education School No Other PK 12 2020   pk_12_total 38 42 15   * 19         *                             123 38 42 15     19                                 123
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
1242467 MD     school 2400480 15   Montgomery 240048001365 525 MCPS Transitions School   Special Education School No High 12 12 2020   pk_12_total 13 21 15     *         *                             55 13 21 15                                       55
1244089 MD     school 2400510 16   Prince George's 240051001100 1511 Marlton Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 271 15   * *         *                             299   271 15                                       299
1244665 MD     school 2400600 18   Saint Mary's 240060001236 104 Ridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 186 29 15   *           35                             266 186 29 15               35                       266
1245782 MD     school 2400090 30   Baltimore City 240009000164 75 Calverton Elementary/Middle   Regular School No Elementary KG 08 2020   pk_12_total * 332 15     *         *                             358   332 15                                       358
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
1241388 MD     school 2400420 13   Howard 240042000760 302 West Friendship Elementary   Regular School No Elementary KG 05 2020   pk_12_total 251 21 16     79     *   25                             393 251 21 16     79         25                       393
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
1243676 MD     school 2400510 16   Prince George's 240051001103 1102 Mattaponi Elementary   Regular School No Elementary KG 05 2020   pk_12_total 20 299 16   * *     *   20                             360 20 299 16               20                       360
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
1245512 MD     school 2400090 30   Baltimore City 240009000571 15 Stadium School   Regular School No Middle 06 08 2020   pk_12_total * 390 16           *   *                             415   390 16                                       415
1246410 MD     school 2400090 30   Baltimore City 240009001430 260 Frederick Elementary   Regular School Yes Elementary PK 05 2020   pk_12_total 28 340 16   *           *                             394 28 340 16                                       394
1246670 MD     school 2400090 30   Baltimore City 240009001690 376 City Neighbors High   Regular School Yes High 09 12 2020   pk_12_total 27 370 16   *           *                             418 27 370 16                                       418
1246678 MD     school 2400090 30   Baltimore City 240009001691 377 Green Street Academy   Regular School Yes High 06 12 2020   pk_12_total 20 815 16     *                                       852 20 815 16                                       852
1246777 MD     school 2400090 30   Baltimore City 240009001385 429 Vivien T. Thomas Medical Arts Academy   Career and Technical School No High 09 12 2020   pk_12_total 11 357 16   *           *                             387 11 357 16                                       387
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 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
1238421 MD     school 2400120 3   Baltimore County 240012000497 213 Winand Elementary   Regular School No Elementary PK 05 2020   pk_12_total 16 410 17   * *     *   10                             465 16 410 17               10                       465
1239689 MD     school 2400210 6   Carroll 240021001652 603 Ebb Valley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 489 13 17   * 10     *   13                             548 489 13 17     10         13                       548
1240016 MD     school 2400240 7   Cecil 240024000559 904 Calvert Elementary   Regular School No Elementary PK 05 2020   pk_12_total 406   17   *           *                             432 406   17                                       432
1240642 MD     school 2400330 10   Frederick 240033001166 1511 Thurmont Primary   Regular School No Elementary PK 02 2020   pk_12_total 301   17     *     *   16                             336 301   17               16                       336
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
1245289 MD     school 2400690 22   Wicomico 240069001315 907 Charles H. Chipman Elementary   Regular School No Elementary PK 01 2020   pk_12_total 47 206 17   * *         24                             301 47 206 17               24                       301
1245387 MD     school 2400720 23   Worcester 240072001334 207 Snow Hill High   Regular School No High 09 12 2020   pk_12_total 199 74 17     *         20                             315 199 74 17               20                       315
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
1238429 MD     school 2400120 3   Baltimore County 240012000405 214 Hernwood Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 339 18   * *         15                             383   339 18               15                       383
1239372 MD     school 2400150 4   Calvert 240015000514 110 Mutual Elementary   Regular School No Elementary PK 05 2020   pk_12_total 318 42 18               43                             421 318 42 18               43                       421
1239548 MD     school 2400180 5   Caroline 240018000521 501 Federalsburg Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 188 187 18   * 10         61                             465 188 187 18     10         61                       465
1240280 MD     school 2400300 9   Dorchester 240030000625 205 Warwick Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 294 27 18     *         19                             361 294 27 18               19                       361
1245370 MD     school 2400720 23   Worcester 240072001330 107 Pocomoke High   Regular School No High 09 12 2020   pk_12_total 161 144 18     *         24                             353 161 144 18               24                       353
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
1237948 MD     school 2400060 2   Anne Arundel 240006001425 3414 Ruth Parker Eason School   Special Education School No Other PK 12 2020   pk_12_total 51 63 19     *         *                             143 51 63 19                                       143
1238101 MD     school 2400060 2   Anne Arundel 240006000128 4242 Shady Side Elementary   Regular School No Elementary PK 05 2020   pk_12_total 384 38 19     *         20                             466 384 38 19               20                       466
1239595 MD     school 2400210 6   Carroll 240021000368 204 Runnymede Elementary   Regular School No Elementary PK 05 2020   pk_12_total 540 19 19   * *     *   27                             612 540 19 19               27                       612
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
1241446 MD     school 2400420 13   Howard 240042000724 505 Clarksville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 129 47 19     224         17                             436 129 47 19     224         17                       436
1244769 MD     school 2400600 18   Saint Mary's 240060001219 702 Dynard Elementary   Regular School No Elementary PK 05 2020   pk_12_total 352 29 19     *         37                             438 352 29 19               37                       438
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
1245345 MD     school 2400690 22   Wicomico 240069001318 1501 Westside Primary   Regular School No Elementary PK 01 2020   pk_12_total 148 31 19   * *         25                             229 148 31 19               25                       229
1245382 MD     school 2400720 23   Worcester 240072001332 205 Snow Hill Elementary   Regular School No Elementary PK 03 2020   pk_12_total 239 91 19   * *         30                             383 239 91 19               30                       383
1245393 MD     school 2400720 23   Worcester 240072001333 208 Snow Hill Middle   Regular School No Middle 04 08 2020   pk_12_total 250 112 19   * *         32                             420 250 112 19               32                       420
1245467 MD     school 2400090 30   Baltimore City 240009000175 8 City Springs Elementary/Middle   Regular School Yes Elementary PK 08 2020   pk_12_total 19 662 19   * *         *                             703 19 662 19                                       703
1245647 MD     school 2400090 30   Baltimore City 240009000143 50 Abbottston Elementary   Regular School No Elementary PK 05 2020   pk_12_total 10 373 19     *     *   *                             409 10 373 19                                       409
1246659 MD     school 2400090 30   Baltimore City 240009001693 374 Vanguard Collegiate Middle   Regular School No Middle 06 08 2020   pk_12_total * 331 19     *     11   *                             378   331 19           11                           378
1238510 MD     school 2400120 3   Baltimore County 240012000481 310 Summit Park Elementary   Regular School No Elementary KG 05 2020   pk_12_total 346 56 20   * 32     *   14                             470 346 56 20     32         14                       470
1238675 MD     school 2400120 3   Baltimore County 240012000462 809 Riderwood Elementary   Regular School No Elementary KG 05 2020   pk_12_total 360 16 20     32         25                             453 360 16 20     32         25                       453
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
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
1240628 MD     school 2400330 10   Frederick 240033000650 1503 Thurmont Elementary   Regular School No Elementary 03 05 2020   pk_12_total 272   20   *           18                             312 272   20               18                       312
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
1243232 MD     school 2400510 16   Prince George's 240051001129 305 Patuxent Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 264 20   * *         *                             293   264 20                                       293
1243720 MD     school 2400510 16   Prince George's 240051000870 1206 John Hanson Montessori   Regular School No Elementary PK 08 2020   pk_12_total * 462 20   * 13     *   *                             511   462 20     13                                 511
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
1245231 MD     school 2400690 22   Wicomico 240069001306 102 Mardela Middle & High   Regular School No High 06 12 2020   pk_12_total 519 84 20   * *         47                             675 519 84 20               47                       675
1245609 MD     school 2400090 30   Baltimore City 240009000184 39 Dallas F. Nicholas, Sr., Elementary   Regular School No Elementary PK 05 2020   pk_12_total   189 20   * *     *                                 224   189 20                                       224
1245858 MD     school 2400090 30   Baltimore City 240009000273 88 Wildwood Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 771 20           *   *                             800   771 20                                       800
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
1238832 MD     school 2400120 3   Baltimore County 240012001696 925 West Towson Elementary   Regular School No Elementary KG 05 2020   pk_12_total 329 41 21   * 45         49                             486 329 41 21     45         49                       486
1239170 MD     school 2400120 3   Baltimore County 240012000381 1502 Edgemere Elementary   Regular School No Elementary PK 05 2020   pk_12_total 396 17 21   * *         34                             475 396 17 21               34                       475
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
1243071 MD     school 2400480 15   Montgomery 240048000867 951 Longview School   Special Education School No Other KG 12 2020   pk_12_total 17 16 21     *                                       61 17 16 21                                       61
1243494 MD     school 2400510 16   Prince George's 240051001056 712 Heather Hills Elementary   Regular School No Elementary 02 05 2020   pk_12_total 35 245 21     38     *   12                             353 35 245 21     38         12                       353
1244673 MD     school 2400600 18   Saint Mary's 240060001235 201 Piney Point Elementary   Regular School No Elementary PK 05 2020   pk_12_total 341 43 21     *         49                             455 341 43 21               49                       455
1244681 MD     school 2400600 18   Saint Mary's 240060001228 301 Leonardtown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 358 73 21     *         34                             494 358 73 21               34                       494
1245061 MD     school 2400660 21   Washington 240066001254 603 Boonsboro Elementary   Regular School No Elementary PK 05 2020   pk_12_total 564 16 21     *     *   17                             622 564 16 21               17                       622
1245074 MD     school 2400660 21   Washington 240066001286 702 Smithsburg Elementary   Regular School No Elementary PK 05 2020   pk_12_total 318 14 21     *         25                             379 318 14 21               25                       379
1245245 MD     school 2400690 22   Wicomico 240069001312 406 Pittsville Elementary & Middle   Regular School No Middle 04 08 2020   pk_12_total 340 14 21   * *         27                             406 340 14 21               27                       406
1246364 MD     school 2400090 30   Baltimore City 240009000279 249 Medfield Heights Elementary   Regular School No Elementary PK 05 2020   pk_12_total 127 143 21   * 37     *   22                             352 127 143 21     37         22                       352
1246444 MD     school 2400090 30   Baltimore City 240009000336 301 William S. Baer School   Special Education School No Other PK 12 2020   pk_12_total 15 126 21     *                                       167 15 126 21                                       167
1238924 MD     school 2400120 3   Baltimore County 240012000021 1110 Seven Oaks Elementary   Regular School No Elementary PK 05 2020   pk_12_total 222 136 22   * 56         34                             471 222 136 22     56         34                       471
1239117 MD     school 2400120 3   Baltimore County 240012000426 1403 McCormick Elementary   Regular School No Elementary PK 05 2020   pk_12_total 16 282 22     *     *   12                             338 16 282 22               12                       338
1239441 MD     school 2400150 4   Calvert 240015000511 209 Huntingtown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 392 31 22               55                             500 392 31 22               55                       500
1239979 MD     school 2400240 7   Cecil 240024000578 701 Perryville Middle   Regular School No Middle 06 08 2020   pk_12_total 477 42 22   * *     *   44                             590 477 42 22               44                       590
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
1241507 MD     school 2400420 13   Howard 240042000725 521 Clarksville Middle   Regular School No Middle 06 08 2020   pk_12_total 294 54 22   * 306     *   31                             710 294 54 22     306         31                       710
1245376 MD     school 2400720 23   Worcester 240072001329 108 Pocomoke Middle   Regular School No Middle 04 08 2020   pk_12_total 166 186 22     *         21                             402 166 186 22               21                       402
1246531 MD     school 2400090 30   Baltimore City 240009001527 328 Southwest Baltimore Charter School   Regular School Yes Elementary PK 08 2020   pk_12_total 29 363 22   * *         11                             432 29 363 22               11                       432
1238147 MD     school 2400060 2   Anne Arundel 240006000056 4304 Central Special School   Special Education School No Other PK 12 2020   pk_12_total 80 32 23     *         *                             148 80 32 23                                       148
1238554 MD     school 2400120 3   Baltimore County 240012000361 404 Chatsworth School   Regular School No Elementary PK 05 2020   pk_12_total 119 178 23   * 22     *   22                             366 119 178 23     22         22                       366
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
1240071 MD     school 2400270 8   Charles 240027000604 503 Piccowaxen Middle School   Regular School No Middle 06 08 2020   pk_12_total 332 49 23   * *     *   34                             450 332 49 23               34                       450
1240222 MD     school 2400270 8   Charles 240027000589 705 General Smallwood Middle School   Regular School No Middle 06 08 2020   pk_12_total 201 247 23   * *     *   45                             527 201 247 23               45                       527
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
1244576 MD     school 2400510 16   Prince George's 240051001067 2220 Community Based Classrooms   Alternative School No High 12 12 2020   pk_12_total * 49 23           *   *                             75   49 23                                       75
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
1244711 MD     school 2400600 18   Saint Mary's 240060001732 308 Captain Walter Francis Duke Elementary   Regular School No Elementary PK 05 2020   pk_12_total 438 41 23   * 16         43                             562 438 41 23     16         43                       562
1244835 MD     school 2400600 18   Saint Mary's 240060001639 813 Chesapeake Charter School   Regular School Yes Elementary KG 08 2020   pk_12_total 329 34 23     17         54                             457 329 34 23     17         54                       457

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