enrollments

Data source: Big Local News · About: Big Local

9,598 rows where state = "MD" and year = 2021 sorted by black_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 9,498 ✖
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
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
1312333 1312333 MD     school 2400210 6   Carroll 240021000535 804 Hampstead Elementary   Regular School No Elementary PK 05 2021   pk_12_total 329 12 20     *     *   18                             385 329 12 20               18                       385
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
1313010 1313010 MD     school 2400330 10   Frederick 240033000639 303 Middletown Elementary   Regular School No Elementary 03 05 2021   pk_12_total 331 12 36   * *         30                             417 331 12 36               30                       417
1313089 1313089 MD     school 2400330 10   Frederick 240033000643 903 New Market Elementary   Regular School No Elementary PK 05 2021   pk_12_total 522 12 44   * 19     *   30                             632 522 12 44     19         30                       632
1313177 1313177 MD     school 2400330 10   Frederick 240033000653 1406 Valley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 342 12 70     *         28                             459 342 12 70               28                       459
1313202 1313202 MD     school 2400330 10   Frederick 240033000642 1604 Myersville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 316 12 28     *         19                             379 316 12 28               19                       379
1313210 1313210 MD     school 2400330 10   Frederick 240033000159 1801 Twin Ridge Elementary   Regular School No Elementary PK 05 2021   pk_12_total 466 12 62     12     *   24                             577 466 12 62     12         24                       577
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
1312375 1312375 MD     school 2400210 6   Carroll 240021000538 1305 Mount Airy Elementary   Regular School No Elementary 03 05 2021   pk_12_total 340 13 57   * *     *   16                             436 340 13 57               16                       436
1314850 1314850 MD     school 2400480 15   Montgomery 240048000787 410 Bradley Hills Elementary   Regular School No Elementary PK 05 2021   pk_12_total 309 13 44     82         49                             497 309 13 44     82         49                       497
1315221 1315221 MD     school 2400480 15   Montgomery 240048000798 604 Carderock Springs Elementary   Regular School No Elementary KG 05 2021   pk_12_total 175 13 46   * 50     *   33                             319 175 13 46     50         33                       319
1309808 1309808 MD     school 2400030 1   Allegany 240003000024 502 Northeast Elementary   Regular School No Elementary PK 05 2021   pk_12_total 228 14 *               24                             269 228 14                 24                       269
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
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
1312358 1312358 MD     school 2400210 6   Carroll 240021000555 906 Winfield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 537 14 16   * *     *   *                             583 537 14 16                                       583
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
1313105 1313105 MD     school 2400330 10   Frederick 240033001379 914 New Market Middle   Regular School No Middle 06 08 2021   pk_12_total 536 14 50   * 10     *   34                             647 536 14 50     10         34                       647
1313112 1313112 MD     school 2400330 10   Frederick 240033001412 915 Kemptown Elementary   Regular School No Elementary KG 05 2021   pk_12_total 261 14 37     14         30                             356 261 14 37     14         30                       356
1316839 1316839 MD     school 2400510 16   Prince George's 240051001738 1732 International High School @ Langley Park   Regular School No High 09 12 2021   pk_12_total * 14 282     16                                       317   14 282     16                                 317
1317168 1317168 MD     school 2400540 17   Queen Anne's 240054001197 106 Sudlersville Elementary School   Regular School No Elementary PK 04 2021   pk_12_total 150 14 116               17                             297 150 14 116               17                       297
1317223 1317223 MD     school 2400540 17   Queen Anne's 240054001644 407 Matapeake Middle School   Regular School No Middle 06 08 2021   pk_12_total 309 14 24   * *         29                             381 309 14 24               29                       381
1310196 1310196 MD     school 2400060 2   Anne Arundel 240006000113 2182 Pasadena Elementary   Regular School No Elementary KG 05 2021   pk_12_total 288 15 26     *         15                             347 288 15 26               15                       347
1312325 1312325 MD     school 2400210 6   Carroll 240021000542 801 North Carroll Middle   Regular School No Middle 06 08 2021   pk_12_total 551 15 28   * 13     *   17                             628 551 15 28     13         17                       628
1312384 1312384 MD     school 2400210 6   Carroll 240021000546 1401 South Carroll High   Regular School No High 09 12 2021   pk_12_total 842 15 78   * 23     *   22                             984 842 15 78     23         22                       984
1313587 1313587 MD     school 2400390 12   Harford 240039002948 326 Forest Hill Elementary   Regular School No Elementary KG 05 2021   pk_12_total 391 15 30     11     *   24                             472 391 15 30     11         24                       472
1313601 1313601 MD     school 2400390 12   Harford 240039000692 328 Forest Lakes Elementary   Regular School No Elementary KG 05 2021   pk_12_total 360 15 24     *         25                             429 360 15 24               25                       429
1317624 1317624 MD     school 2400660 21   Washington 240066001256 601 Boonsboro High   Regular School No High 09 12 2021   pk_12_total 761 15 40   * 18         37                             873 761 15 40     18         37                       873
1309913 1309913 MD     school 2400030 1   Allegany 240003000026 2902 Parkside Elementary   Regular School No Elementary PK 05 2021   pk_12_total 134 16 *     *         15                             178 134 16                 15                       178
1312299 1312299 MD     school 2400210 6   Carroll 240021000052 714 Friendship Valley Elementary   Regular School No Elementary KG 05 2021   pk_12_total 333 16 39     *     *   17                             414 333 16 39               17                       414
1312341 1312341 MD     school 2400210 6   Carroll 240021090467 806 Spring Garden Elementary   Regular School No Elementary PK 05 2021   pk_12_total 364 16 28     *         14                             429 364 16 28               14                       429
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
1313024 1313024 MD     school 2400330 10   Frederick 240033001566 314 Middletown Primary   Regular School No Elementary PK 02 2021   pk_12_total 346 16 37     *     *   20                             428 346 16 37               20                       428
1313289 1313289 MD     school 2400330 10   Frederick 240033000647 2404 Rock Creek   Special Education School No Other PK 12 2021   pk_12_total 39 16 11               *                             71 39 16 11                                       71
1314870 1314870 MD     school 2400480 15   Montgomery 240048000958 417 Wood Acres Elementary   Regular School No Elementary PK 05 2021   pk_12_total 397 16 72     56     *   41                             583 397 16 72     56         41                       583
1315651 1315651 MD     school 2400480 15   Montgomery 240048000867 951 Longview School   Special Education School No Other KG 12 2021   pk_12_total 18 16 25     *                                       65 18 16 25                                       65
1318002 1318002 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2021   pk_12_total 27 16 *     *         *                             50 27 16                                         50
1309889 1309889 MD     school 2400030 1   Allegany 240003001636 2404 Mountain Ridge High School   Regular School No High 09 12 2021   pk_12_total 712 17 12   * *         23                             771 712 17 12               23                       771
1310143 1310143 MD     school 2400060 2   Anne Arundel 240006000067 2102 Folger Mckinsey Elementary   Regular School No Elementary KG 05 2021   pk_12_total 482 17 31     18         28                             576 482 17 31     18         28                       576
1310151 1310151 MD     school 2400060 2   Anne Arundel 240006000068 2112 Fort Smallwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 404 17 18     *         19                             464 404 17 18               19                       464
1310680 1310680 MD     school 2400060 2   Anne Arundel 240006000136 4262 Tyler Heights Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 17 445     *         *                             467   17 445                                       467
1310783 1310783 MD     school 2400120 3   Baltimore County 240012000831 72 Rosedale Center   Alternative School No High 07 12 2021   pk_12_total * 17                 *                             25   17                                         25
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
1315552 1315552 MD     school 2400480 15   Montgomery 240048000496 799 Stephen Knolls School   Special Education School No Other PK 12 2021   pk_12_total 13 17 19     *         *                             52 13 17 19                                       52
1317636 1317636 MD     school 2400660 21   Washington 240066001254 603 Boonsboro Elementary   Regular School No Elementary PK 05 2021   pk_12_total 438 17 22     *     *   10                             491 438 17 22               10                       491
1318016 1318016 MD     school 2400720 23   Worcester 240072001327 1001 Ocean City Elementary   Regular School No Elementary PK 04 2021   pk_12_total 400 17 72     12         28                             529 400 17 72     12         28                       529
1310573 1310573 MD     school 2400060 2   Anne Arundel 240006000053 4112 Central Elementary   Regular School No Elementary KG 05 2021   pk_12_total 448 18 62   * 18         18                             565 448 18 62     18         18                       565
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
1312379 1312379 MD     school 2400210 6   Carroll 240021000539 1306 Mount Airy Middle   Regular School No Middle 06 08 2021   pk_12_total 567 18 74   * 14     *   13                             690 567 18 74     14         13                       690
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
1317175 1317175 MD     school 2400540 17   Queen Anne's 240054001192 202 Church Hill Elementary School   Regular School No Elementary PK 04 2021   pk_12_total 177 18 35               22                             252 177 18 35               22                       252
1309905 1309905 MD     school 2400030 1   Allegany 240003001338 2901 Cash Valley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 226 19 *     *         16                             273 226 19                 16                       273
1309952 1309952 MD     school 2400060 2   Anne Arundel 240006000066 1102 Ferndale Early Education Center   Regular School No Prekindergarten PK PK 2021   pk_12_total 30 19 21     12         *                             87 30 19 21     12                                 87
1310543 1310543 MD     school 2400060 2   Anne Arundel 240006001729 4064 Mary Moss at Adams Academy   Alternative School No Middle 07 09 2021   pk_12_total 10 19 *               *                             42 10 19                                         42
1310687 1310687 MD     school 2400060 2   Anne Arundel 240006000139 4272 West Annapolis Elementary   Regular School No Elementary KG 05 2021   pk_12_total 132 19 39     *         23                             215 132 19 39               23                       215
1310795 1310795 MD     school 2400120 3   Baltimore County 240012001711 77 BCDC Educational Center   Alternative School No High 09 12 2021   pk_12_total * 19 *                                             31   19                                         31
1311563 1311563 MD     school 2400120 3   Baltimore County 240012000346 1215 Battle Monument School   Special Education School No Other PK 12 2021   pk_12_total 31 19 *     *         *                             63 31 19                                         63
1317987 1317987 MD     school 2400720 23   Worcester 240072001498 312 Showell Elementary   Regular School No Elementary PK 04 2021   pk_12_total 530 19 43   * 16         40                             649 530 19 43     16         40                       649
1311230 1311230 MD     school 2400120 3   Baltimore County 240012000462 809 Riderwood Elementary   Regular School No Elementary KG 05 2021   pk_12_total 317 20 19     28         21                             405 317 20 19     28         21                       405
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
1314885 1314885 MD     school 2400480 15   Montgomery 240048000779 420 Bannockburn Elementary   Regular School No Elementary PK 05 2021   pk_12_total 257 20 40     50         34                             401 257 20 40     50         34                       401
1317202 1317202 MD     school 2400540 17   Queen Anne's 240054000202 403 Bayside Elementary School   Regular School No Elementary 03 05 2021   pk_12_total 290 20 42     *         33                             393 290 20 42               33                       393
1317308 1317308 MD     school 2400600 18   Saint Mary's 240060001240 503 White Marsh Elementary   Regular School No Elementary KG 05 2021   pk_12_total 170 20 12     *         15                             219 170 20 12               15                       219
1309791 1309791 MD     school 2400030 1   Allegany 240003000019 402 John Humbird Elementary   Regular School No Elementary PK 05 2021   pk_12_total 176 21 *               33                             233 176 21                 33                       233
1310189 1310189 MD     school 2400060 2   Anne Arundel 240006000104 2172 Oak Hill Elementary   Regular School No Elementary KG 05 2021   pk_12_total 519 21 26   * 28     *   43                             639 519 21 26     28         43                       639
1310375 1310375 MD     school 2400060 2   Anne Arundel 240006000100 3162 Millersville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 259 21 28     *     *   32                             349 259 21 28               32                       349
1311201 1311201 MD     school 2400120 3   Baltimore County 240012000476 801 Sparks Elementary   Regular School No Elementary KG 05 2021   pk_12_total 399 21 14   * 34     *   14                             485 399 21 14     34         14                       485
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
1314619 1314619 MD     school 2400480 15   Montgomery 240048000861 247 John H. Poole Middle   Regular School No Middle 06 08 2021   pk_12_total 254 21 52     20         34                             381 254 21 52     20         34                       381
1309823 1309823 MD     school 2400030 1   Allegany 240003000032 603 West Side Elementary   Regular School No Elementary PK 05 2021   pk_12_total 240 22 *   * *         47                             319 240 22                 47                       319
1311215 1311215 MD     school 2400120 3   Baltimore County 240012001433 805 Timonium Elementary   Regular School No Elementary KG 05 2021   pk_12_total 286 22 36     75     *   24                             444 286 22 36     75         24                       444
1313019 1313019 MD     school 2400330 10   Frederick 240033000641 313 Middletown High   Regular School No High 09 12 2021   pk_12_total 992 22 74   * 17     *   40                             1149 992 22 74     17         40                       1149
1313639 1313639 MD     school 2400390 12   Harford 240039000717 348 Youths Benefit Elementary   Regular School No Elementary PK 05 2021   pk_12_total 942 22 44   * 27     *   37                             1082 942 22 44     27         37                       1082
1313943 1313943 MD     school 2400420 13   Howard 240042000760 302 West Friendship Elementary   Regular School No Elementary KG 05 2021   pk_12_total 225 22 20     83     *   25                             376 225 22 20     83         25                       376
1317301 1317301 MD     school 2400600 18   Saint Mary's 240060001399 501 Lettie Marshall Dent Elem   Regular School No Elementary PK 05 2021   pk_12_total 468 22 19   * *         25                             541 468 22 19               25                       541
1310672 1310672 MD     school 2400060 2   Anne Arundel 240006000135 4252 Traceys Elementary   Regular School No Elementary KG 05 2021   pk_12_total 216 23 144     *         14                             398 216 23 144               14                       398
1312307 1312307 MD     school 2400210 6   Carroll 240021001105 715 Cranberry Station Elementary   Regular School No Elementary PK 05 2021   pk_12_total 415 23 59   * *         38                             544 415 23 59               38                       544
1316531 1316531 MD     school 2400510 16   Prince George's 240051001737 1352 International High school @ Largo   Regular School No High 09 12 2021   pk_12_total * 23 323     25                                       373   23 323     25                                 373
1316817 1316817 MD     school 2400510 16   Prince George's 240051000510 1725 Cool Spring Elementary   Regular School No Elementary PK 06 2021   pk_12_total 10 23 784   *           *                             834 10 23 784                                       834
1319017 1319017 MD     school 2400090 30   Baltimore City 240009001369 314 Sharp-Leadenhall Elementary   Special Education School No Elementary 01 05 2021   pk_12_total * 23                 *                             27   23                                         27
1309828 1309828 MD     school 2400030 1   Allegany 240003000001 606 Allegany High   Regular School No High 09 12 2021   pk_12_total 628 24 20   * 11     *   50                             736 628 24 20     11         50                       736
1310227 1310227 MD     school 2400060 2   Anne Arundel 240006000134 2222 Sunset Elementary   Regular School No Elementary PK 05 2021   pk_12_total 328 24 29   * *     *   25                             418 328 24 29               25                       418
1310580 1310580 MD     school 2400060 2   Anne Arundel 240006000062 4122 Davidsonville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 491 24 51   * 17     *   38                             624 491 24 51     17         38                       624
1311274 1311274 MD     school 2400120 3   Baltimore County 240012001422 855 Hereford Middle   Regular School No Middle 06 08 2021   pk_12_total 787 24 36   * 38         34                             920 787 24 36     38         34                       920
1311611 1311611 MD     school 2400120 3   Baltimore County 240012000341 1302 Arbutus Elementary   Regular School No Elementary PK 05 2021   pk_12_total 186 24 16   * 136         26                             390 186 24 16     136         26                       390
1315637 1315637 MD     school 2400480 15   Montgomery 240048001460 916 Rock Terrace School   Special Education School No High 06 12 2021   pk_12_total 23 24 22     11         *                             84 23 24 22     11                                 84
1317323 1317323 MD     school 2400600 18   Saint Mary's 240060001233 602 Oakville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 216 24 *   *           22                             269 216 24                 22                       269
1317628 1317628 MD     school 2400660 21   Washington 240066001255 602 Boonsboro Middle   Regular School No Middle 06 08 2021   pk_12_total 541 24 28   * 14         23                             631 541 24 28     14         23                       631
1317921 1317921 MD     school 2400690 22   Wicomico 240069001318 1501 Westside Primary   Regular School No Elementary PK 01 2021   pk_12_total 109 24 22   * *         19                             181 109 24 22               19                       181
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
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
1313014 1313014 MD     school 2400330 10   Frederick 240033000640 311 Middletown Middle   Regular School No Middle 06 08 2021   pk_12_total 647 25 63   * 15         40                             794 647 25 63     15         40                       794
1313331 1313331 MD     school 2400330 10   Frederick 240033000620 2611 Glade Elementary   Regular School No Elementary PK 05 2021   pk_12_total 407 25 55   * 13         41                             543 407 25 55     13         41                       543
1315266 1315266 MD     school 2400480 15   Montgomery 240048000815 702 Damascus Elementary   Regular School No Elementary PK 05 2021   pk_12_total 143 25 143   * 20     *   21                             354 143 25 143     20         21                       354
1317815 1317815 MD     school 2400690 22   Wicomico 240069001308 106 Northwestern Elementary   Regular School No Elementary PK 05 2021   pk_12_total 239 25 10   * *     *   27                             308 239 25 10               27                       308
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
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
1312273 1312273 MD     school 2400210 6   Carroll 240021000551 710 Westminster Elementary   Regular School No Elementary PK 05 2021   pk_12_total 379 26 61     29     *   38                             535 379 26 61     29         38                       535
1313737 1313737 MD     school 2400390 12   Harford 240039000710 580 North Harford High   Regular School No High 09 12 2021   pk_12_total 1118 26 29   * 14         36                             1226 1118 26 29     14         36                       1226
1314801 1314801 MD     school 2400480 15   Montgomery 240048000817 351 Darnestown Elementary   Regular School No Elementary KG 05 2021   pk_12_total 195 26 21     38         21                             301 195 26 21     38         21                       301

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