enrollments

Data source: Big Local News · About: Big Local

1,393 rows where grade = "pk_12_total", state = "MD" and year = 2021 sorted by district_state_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 1,393 ✖

grade ✖

  • pk_12_total · 1,393 ✖
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
1312827 1312827 MD     school 2400300 9   Dorchester 240030000625 205 Warwick Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 273 18 15     *         11                             321 273 18 15               11                       321
1312832 1312832 MD     school 2400300 9   Dorchester 240030000618 207 North Dorchester High School   Regular School No High 09 12 2021   pk_12_total 386 122 42     *         31                             590 386 122 42               31                       590
1312836 1312836 MD     school 2400300 9   Dorchester 240030000619 208 North Dorchester Middle School   Regular School No Middle 06 08 2021   pk_12_total 258 119 41     *         37                             461 258 119 41               37                       461
1312844 1312844 MD     school 2400300 9   Dorchester 240030000624 302 Vienna Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 121 25 12     *         14                             173 121 25 12               14                       173
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
1312859 1312859 MD     school 2400300 9   Dorchester 240030001423 707 Mace's Lane Middle School   Regular School No Middle 06 08 2021   pk_12_total 92 405 63     *     *   36                             603 92 405 63               36                       603
1312867 1312867 MD     school 2400300 9   Dorchester 240030000621 710 Sandy Hill Elementary   Regular School No Elementary PK 05 2021   pk_12_total 73 249 33     *         32                             393 73 249 33               32                       393
1312875 1312875 MD     school 2400300 9   Dorchester 240030000617 711 Maple Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 85 248 75     10         36                             454 85 248 75     10         36                       454
1312880 1312880 MD     school 2400300 9   Dorchester 240030000612 713 Cambridge-South Dorchester High School   Regular School No High 09 12 2021   pk_12_total 246 403 67   * 10         54                             782 246 403 67     10         54                       782
1312888 1312888 MD     school 2400300 9   Dorchester 240030000841 716 Choptank Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 33 205 52               15                             305 33 205 52               15                       305
1312896 1312896 MD     school 2400300 9   Dorchester 240030000614 1503 Hurlock Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 136 144 37     *     *   37                             361 136 144 37               37                       361
1312573 1312573 MD     school 2400270 8   Charles 240027000601 104 Milton M. Somers Middle School   Regular School No Middle 06 08 2021   pk_12_total 386 437 103   * 37     *   83                             1049 386 437 103     37         83                       1049
1312581 1312581 MD     school 2400270 8   Charles 240027000609 105 Walter J. Mitchell Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 377 105 55   * 13     *   59                             613 377 105 55     13         59                       613
1312586 1312586 MD     school 2400270 8   Charles 240027000596 106 La Plata High School   Regular School No High 09 12 2021   pk_12_total 703 247 73   * 38     *   107                             1174 703 247 73     38         107                       1174
1312591 1312591 MD     school 2400270 8   Charles 240027000600 108 Maurice J. McDonough High School   Regular School No High 09 12 2021   pk_12_total 310 479 116   * 27     *   64                             999 310 479 116     27         64                       999
1312599 1312599 MD     school 2400270 8   Charles 240027000141 109 Mary H. Matula Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 227 190 42   * 28     *   42                             531 227 190 42     28         42                       531
1312607 1312607 MD     school 2400270 8   Charles 240027001492 302 Mt Hope/Nanjemoy Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 145 56 *   *           22                             230 145 56                 22                       230
1312615 1312615 MD     school 2400270 8   Charles 240027000610 501 Dr. Thomas L. Higdon Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 257 58 13     *     *   27                             362 257 58 13               27                       362
1312619 1312619 MD     school 2400270 8   Charles 240027000604 503 Piccowaxen Middle School   Regular School No Middle 06 08 2021   pk_12_total 327 53 27   * *     *   27                             443 327 53 27               27                       443
1312627 1312627 MD     school 2400270 8   Charles 240027000585 604 Dr. Samuel A. Mudd Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 33 402 91   * *         29                             566 33 402 91               29                       566
1312632 1312632 MD     school 2400270 8   Charles 240027000607 605 Thomas Stone High School   Regular School No High 09 12 2021   pk_12_total 138 708 186   * 19     *   59                             1115 138 708 186     19         59                       1115
1312640 1312640 MD     school 2400270 8   Charles 240027000593 606 J. P. Ryon Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 50 398 121   * *         51                             630 50 398 121               51                       630
1312644 1312644 MD     school 2400270 8   Charles 240027000595 608 John Hanson Middle School   Regular School No Middle 06 08 2021   pk_12_total 135 488 129   * 17     *   72                             849 135 488 129     17         72                       849
1312652 1312652 MD     school 2400270 8   Charles 240027000594 609 Dr. James Craik Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 215 179 45   * *         49                             499 215 179 45               49                       499
1312660 1312660 MD     school 2400270 8   Charles 240027000584 611 Dr. Gustavus Brown Elementary   Regular School No Elementary PK 05 2021   pk_12_total 32 266 74   * *         31                             407 32 266 74               31                       407
1312668 1312668 MD     school 2400270 8   Charles 240027000582 612 Arthur Middleton Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 51 301 114     18     *   59                             545 51 301 114     18         59                       545
1312672 1312672 MD     school 2400270 8   Charles 240027000583 613 Benjamin Stoddert Middle School   Regular School No Middle 06 08 2021   pk_12_total 52 590 110   * 25     *   56                             838 52 590 110     25         56                       838
1312680 1312680 MD     school 2400270 8   Charles 240027000586 616 Eva Turner Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 29 320 53     *         17                             421 29 320 53               17                       421
1312688 1312688 MD     school 2400270 8   Charles 240027010501 617 Daniel of St. Thomas Jenifer Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 27 411 96   * 17         42                             595 27 411 96     17         42                       595
1312696 1312696 MD     school 2400270 8   Charles 240027001519 618 William B. Wade Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 72 385 50   * 39         71                             619 72 385 50     39         71                       619
1312701 1312701 MD     school 2400270 8   Charles 240027000144 619 Westlake High School   Regular School No High 09 12 2021   pk_12_total 68 877 89   * 42     *   57                             1139 68 877 89     42         57                       1139
1312709 1312709 MD     school 2400270 8   Charles 240027000380 620 C. Paul Barnhart Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 13 439 84     24         49                             609 13 439 84     24         49                       609
1312713 1312713 MD     school 2400270 8   Charles 240027000615 621 Mattawoman Middle School   Regular School No Middle 06 08 2021   pk_12_total 37 756 116   * 54     *   56                             1024 37 756 116     54         56                       1024
1312721 1312721 MD     school 2400270 8   Charles 240027000805 622 Berry Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 59 404 84   * 55     *   68                             675 59 404 84     55         68                       675
1312726 1312726 MD     school 2400270 8   Charles 240027001416 623 North Point High School   Regular School No High 09 12 2021   pk_12_total 286 1130 141   * 108     *   139                             1813 286 1130 141     108         139                       1813
1312734 1312734 MD     school 2400270 8   Charles 240027001565 624 William A. Diggs Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 84 525 60     30     *   59                             762 84 525 60     30         59                       762
1312738 1312738 MD     school 2400270 8   Charles 240027001647 625 Theodore G. Davis Middle School   Regular School No Middle 06 08 2021   pk_12_total 70 601 98   * 30     *   79                             885 70 601 98     30         79                       885
1312746 1312746 MD     school 2400270 8   Charles 240027001656 626 Mary B. Neal Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 26 512 57   * 35         47                             678 26 512 57     35         47                       678
1312754 1312754 MD     school 2400270 8   Charles 240027001757 627 Billingsley Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 70 462 65   * 31     *   58                             688 70 462 65     31         58                       688
1312758 1312758 MD     school 2400270 8   Charles 240027000599 701 Matthew Henson Middle School   Regular School No Middle 06 08 2021   pk_12_total 73 529 95   * 17     *   65                             784 73 529 95     17         65                       784
1312766 1312766 MD     school 2400270 8   Charles 240027000592 703 J. C. Parks Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 52 364 83   * 20     *   67                             592 52 364 83     20         67                       592
1312770 1312770 MD     school 2400270 8   Charles 240027000589 705 General Smallwood Middle School   Regular School No Middle 06 08 2021   pk_12_total 168 241 35     *         49                             500 168 241 35               49                       500
1312777 1312777 MD     school 2400270 8   Charles 240027001395 708 Robert D. Stethem Educational Center   Alternative School No High 07 12 2021   pk_12_total 22 34 *               *                             65 22 34                                         65
1312785 1312785 MD     school 2400270 8   Charles 240027000591 710 Indian Head Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 82 246 37     *         46                             416 82 246 37               46                       416
1312793 1312793 MD     school 2400270 8   Charles 240027000606 801 T. C. Martin Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 248 126 36   * *     *   53                             470 248 126 36               53                       470
1312798 1312798 MD     school 2400270 8   Charles 240027001727 802 St. Charles High School   Regular School No High 09 12 2021   pk_12_total 154 997 101   11 30     *   96                             1392 154 997 101   11 30         96                       1392
1312806 1312806 MD     school 2400270 8   Charles 240027000598 902 Malcolm Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 129 166 56   * *     *   59                             419 129 166 56               59                       419
1312814 1312814 MD     school 2400270 8   Charles 240027000588 1001 Gale-Bailey Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 156 125 29     *         37                             348 156 125 29               37                       348
1312819 1312819 MD     school 2400270 8   Charles 240027000597 1002 Henry E. Lackey High School   Regular School No High 09 12 2021   pk_12_total 276 578 72   * 22     *   66                             1024 276 578 72     22         66                       1024
1312392 1312392 MD     school 2400240 7   Cecil 240024000562 104 Cecilton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 207 16 43   *           15                             282 207 16 43               15                       282
1312397 1312397 MD     school 2400240 7   Cecil 240024000558 204 Bohemia Manor High   Regular School No High 09 12 2021   pk_12_total 513 37 54   * *     *   23                             632 513 37 54               23                       632
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
1312409 1312409 MD     school 2400240 7   Cecil 240024000791 206 Bohemia Manor Middle   Regular School No Middle 06 08 2021   pk_12_total 367 38 39     *     *   24                             470 367 38 39               24                       470
1312414 1312414 MD     school 2400240 7   Cecil 240024000568 302 Elkton High   Regular School No High 09 12 2021   pk_12_total 493 290 151   * 13     *   107                             1061 493 290 151     13         107                       1061
1312418 1312418 MD     school 2400240 7   Cecil 240024000567 303 Elkton Middle   Regular School No Middle 06 08 2021   pk_12_total 216 178 95   * *     *   76                             574 216 178 95               76                       574
1312426 1312426 MD     school 2400240 7   Cecil 240024000569 310 Gilpin Manor Elementary   Regular School No Elementary PK 05 2021   pk_12_total 156 128 51     *         49                             392 156 128 51               49                       392
1312434 1312434 MD     school 2400240 7   Cecil 240024000570 311 Holly Hall Elementary   Regular School No Elementary PK 05 2021   pk_12_total 217 66 59   * *         42                             390 217 66 59               42                       390
1312438 1312438 MD     school 2400240 7   Cecil 240024000564 313 Cherry Hill Middle   Regular School No Middle 06 08 2021   pk_12_total 277 56 52               29                             414 277 56 52               29                       414
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
1312454 1312454 MD     school 2400240 7   Cecil 240024000581 316 Thomson Estates Elementary   Regular School No Elementary PK 05 2021   pk_12_total 209 102 69   * 11     *   60                             453 209 102 69     11         60                       453
1312462 1312462 MD     school 2400240 7   Cecil 240024001491 317 Kenmore Elementary   Regular School No Elementary PK 05 2021   pk_12_total 237 17 33               16                             303 237 17 33               16                       303
1312470 1312470 MD     school 2400240 7   Cecil 240024000560 401 Cecil Manor Elementary   Regular School No Elementary PK 05 2021   pk_12_total 148 117 58     *         49                             374 148 117 58               49                       374
1312474 1312474 MD     school 2400240 7   Cecil 240024000574 504 North East Middle   Regular School No Middle 06 08 2021   pk_12_total 637 63 47   * *     *   42                             798 637 63 47               42                       798
1312482 1312482 MD     school 2400240 7   Cecil 240024000573 506 North East Elementary   Regular School No Elementary PK 05 2021   pk_12_total 374 59 35   * *     *   46                             522 374 59 35               46                       522
1312490 1312490 MD     school 2400240 7   Cecil 240024000557 510 Bay View Elementary   Regular School No Elementary PK 05 2021   pk_12_total 300 36 38     *         33                             414 300 36 38               33                       414
1312498 1312498 MD     school 2400240 7   Cecil 240024000563 513 Charlestown Elementary   Regular School No Elementary PK 05 2021   pk_12_total 197 21 11           *   19                             253 197 21 11               19                       253
1312503 1312503 MD     school 2400240 7   Cecil 240024000575 514 North East High   Regular School No High 09 12 2021   pk_12_total 843 62 58   * 10         43                             1020 843 62 58     10         43                       1020
1312511 1312511 MD     school 2400240 7   Cecil 240024090468 515 Elk Neck Elementary   Regular School No Elementary PK 05 2021   pk_12_total 375 14 15   * *     *   21                             430 375 14 15               21                       430
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
1312527 1312527 MD     school 2400240 7   Cecil 240024000578 701 Perryville Middle   Regular School No Middle 06 08 2021   pk_12_total 460 48 27   * *     *   47                             585 460 48 27               47                       585
1312535 1312535 MD     school 2400240 7   Cecil 240024000576 703 Perryville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 283 28 27     *         29                             371 283 28 27               29                       371
1312543 1312543 MD     school 2400240 7   Cecil 240024000556 704 Bainbridge Elementary   Regular School No Elementary PK 05 2021   pk_12_total 221 12 *   *           23                             265 221 12                 23                       265
1312548 1312548 MD     school 2400240 7   Cecil 240024000577 705 Perryville High   Regular School No High 09 12 2021   pk_12_total 677 36 36   * 10     *   46                             810 677 36 36     10         46                       810
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
1312564 1312564 MD     school 2400240 7   Cecil 240024000559 904 Calvert Elementary   Regular School No Elementary PK 05 2021   pk_12_total 375   19   *           *                             404 375   19                                       404
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
1312128 1312128 MD     school 2400210 6   Carroll 240021000548 103 Taneytown Elementary   Regular School No Elementary PK 05 2021   pk_12_total 298 20 34   * *     *   14                             374 298 20 34               14                       374
1312132 1312132 MD     school 2400210 6   Carroll 240021000543 105 Northwest Middle   Regular School No Middle 06 08 2021   pk_12_total 534 26 30   * *         46                             645 534 26 30               46                       645
1312137 1312137 MD     school 2400210 6   Carroll 240021000533 202 Francis Scott Key High   Regular School No High 09 12 2021   pk_12_total 767 25 48   * *     *   35                             885 767 25 48               35                       885
1312145 1312145 MD     school 2400210 6   Carroll 240021000368 204 Runnymede Elementary   Regular School No Elementary PK 05 2021   pk_12_total 492 18 21   * *         24                             562 492 18 21               24                       562
1312153 1312153 MD     school 2400210 6   Carroll 240021000545 404 Sandymount Elementary   Regular School No Elementary PK 05 2021   pk_12_total 391 29 38     11     *   *                             478 391 29 38     11                                 478
1312161 1312161 MD     school 2400210 6   Carroll 240021000537 406 Mechanicsville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 366 14 15     *     *   21                             426 366 14 15               21                       426
1312169 1312169 MD     school 2400210 6   Carroll 240021000531 501 Eldersburg Elementary   Regular School No Elementary PK 05 2021   pk_12_total 345 26 28     39         21                             459 345 26 28     39         21                       459
1312177 1312177 MD     school 2400210 6   Carroll 240021000977 503 Linton Springs Elementary   Regular School No Elementary PK 05 2021   pk_12_total 577 13 38   * 19     *   20                             674 577 13 38     19         20                       674
1312181 1312181 MD     school 2400210 6   Carroll 240021000547 504 Sykesville Middle   Regular School No Middle 06 08 2021   pk_12_total 614 37 34   * 44     *   30                             762 614 37 34     44         30                       762
1312188 1312188 MD     school 2400210 6   Carroll 240021000534 505 Freedom District Elementary   Regular School No Elementary KG 05 2021   pk_12_total 452 12 27     27     *   25                             544 452 12 27     27         25                       544
1312196 1312196 MD     school 2400210 6   Carroll 240021000529 506 Carrolltowne Elementary   Regular School No Elementary PK 05 2021   pk_12_total 474 14 37   * 41     *   30                             599 474 14 37     41         30                       599
1312201 1312201 MD     school 2400210 6   Carroll 240021001394 507 Liberty High   Regular School No High 09 12 2021   pk_12_total 815 55 44     38     *   34                             993 815 55 44     38         34                       993
1312205 1312205 MD     school 2400210 6   Carroll 240021000835 508 Oklahoma Road Middle   Regular School No Middle 06 08 2021   pk_12_total 571 43 31   * 47     *   26                             721 571 43 31     47         26                       721
1312213 1312213 MD     school 2400210 6   Carroll 240021090466 509 Piney Ridge Elementary   Regular School No Elementary PK 05 2021   pk_12_total 371 37 33   * 40     *   55                             538 371 37 33     40         55                       538
1312218 1312218 MD     school 2400210 6   Carroll 240021001161 510 Century High   Regular School No High 09 12 2021   pk_12_total 919 53 79   * 52     *   27                             1135 919 53 79     52         27                       1135
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
1312231 1312231 MD     school 2400210 6   Carroll 240021001672 602 Manchester Valley High   Regular School No High 09 12 2021   pk_12_total 1154 34 73   * 31     *   25                             1321 1154 34 73     31         25                       1321
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
1312243 1312243 MD     school 2400210 6   Carroll 240021000550 701 Westminster East Middle   Regular School No Middle 06 08 2021   pk_12_total 538 59 83     16     *   33                             730 538 59 83     16         33                       730
1312247 1312247 MD     school 2400210 6   Carroll 240021000553 703 Westminster West Middle   Regular School No Middle 06 08 2021   pk_12_total 671 59 108   * 28     *   33                             904 671 59 108     28         33                       904
1312252 1312252 MD     school 2400210 6   Carroll 240021001185 704 Winters Mill High   Regular School No High 09 12 2021   pk_12_total 780 79 125   * 38     *   55                             1080 780 79 125     38         55                       1080
1312260 1312260 MD     school 2400210 6   Carroll 240021000554 705 William Winchester Elementary   Regular School No Elementary PK 05 2021   pk_12_total 314 41 92     10         26                             483 314 41 92     10         26                       483
1312265 1312265 MD     school 2400210 6   Carroll 240021000552 707 Westminster High   Regular School No High 09 12 2021   pk_12_total 1242 70 84   * 56     *   59                             1515 1242 70 84     56         59                       1515

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