enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1240721 1240721 MD     school 2400330 10   Frederick 240033000657 2403 Waverley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 43 66 394   * 31         10                             548 43 66 394     31         10                       548
1240736 1240736 MD     school 2400330 10   Frederick 240033000647 2404 Rock Creek   Special Education School No Other PK 12 2020   pk_12_total 43 13 12     *         *                             74 43 13 12                                       74
1240741 1240741 MD     school 2400330 10   Frederick 240033000627 2503 Brunswick High   Regular School No High 09 12 2020   pk_12_total 604 50 74   * 13         50                             792 604 50 74     13         50                       792
1240749 1240749 MD     school 2400330 10   Frederick 240033000626 2504 Brunswick Elementary   Regular School No Elementary PK 05 2020   pk_12_total 535 68 93   * 17     *   45                             762 535 68 93     17         45                       762
1240753 1240753 MD     school 2400330 10   Frederick 240033001409 2525 Brunswick Middle   Regular School No Middle 06 08 2020   pk_12_total 403 44 74   * 10     *   40                             573 403 44 74     10         40                       573
1240757 1240757 MD     school 2400330 10   Frederick 240033000656 2606 Walkersville Middle   Regular School No Middle 06 08 2020   pk_12_total 570 108 117     24     *   56                             876 570 108 117     24         56                       876
1240765 1240765 MD     school 2400330 10   Frederick 240033000654 2607 Walkersville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 330 143 107   * 24     *   70                             678 330 143 107     24         70                       678
1240770 1240770 MD     school 2400330 10   Frederick 240033000655 2610 Walkersville High   Regular School No High 09 12 2020   pk_12_total 747 161 145   * 39     *   86                             1185 747 161 145     39         86                       1185
1240778 1240778 MD     school 2400330 10   Frederick 240033000620 2611 Glade Elementary   Regular School No Elementary PK 05 2020   pk_12_total 475 30 48   * 14         43                             611 475 30 48     14         43                       611
1312904 1312904 MD     school 2400330 10   Frederick 240033000628 108 Carroll Manor Elementary   Regular School No Elementary PK 05 2021   pk_12_total 368 57 73   * 16         23                             538 368 57 73     16         23                       538
1312912 1312912 MD     school 2400330 10   Frederick 240033001355 109 Tuscarora Elementary   Regular School No Elementary PK 05 2021   pk_12_total 192 184 192   * 66     *   64                             701 192 184 192     66         64                       701
1312919 1312919 MD     school 2400330 10   Frederick 240033000646 201 Parkway Elementary   Regular School No Elementary KG 05 2021   pk_12_total 126 31 39   * *         17                             223 126 31 39               17                       223
1312927 1312927 MD     school 2400330 10   Frederick 240033000649 204 Lincoln Elementary   Regular School No Elementary PK 05 2021   pk_12_total 95 213 213   * 22         59                             605 95 213 213     22         59                       605
1312934 1312934 MD     school 2400330 10   Frederick 240033001410 208 Heather Ridge   Alternative School No High 07 12 2021   pk_12_total 22 11 *   *           *                             44 22 11                                         44
1312939 1312939 MD     school 2400330 10   Frederick 240033000632 209 Frederick High   Regular School No High 09 12 2021   pk_12_total 388 393 587   * 104     *   61                             1542 388 393 587     104         61                       1542
1312947 1312947 MD     school 2400330 10   Frederick 240033000645 210 North Frederick Elementary   Regular School No Elementary PK 05 2021   pk_12_total 232 113 160     27         67                             599 232 113 160     27         67                       599
1312951 1312951 MD     school 2400330 10   Frederick 240033000658 211 West Frederick Middle   Regular School No Middle 06 08 2021   pk_12_total 227 204 382   * 46     *   62                             925 227 204 382     46         62                       925
1312956 1312956 MD     school 2400330 10   Frederick 240033000634 213 Gov. Thomas Johnson High   Regular School No High 09 12 2021   pk_12_total 582 412 586   * 82     *   71                             1744 582 412 586     82         71                       1744
1312960 1312960 MD     school 2400330 10   Frederick 240033001413 219 Monocacy Middle   Regular School No Middle 06 08 2021   pk_12_total 246 226 388   * 42     *   64                             978 246 226 388     42         64                       978
1312968 1312968 MD     school 2400330 10   Frederick 240033001521 222 Monocacy Elementary   Regular School No Elementary PK 05 2021   pk_12_total 129 176 178     18     *   48                             551 129 176 178     18         48                       551
1312976 1312976 MD     school 2400330 10   Frederick 240033090471 223 Ballenger Creek Elementary   Regular School No Elementary PK 05 2021   pk_12_total 197 138 128   * 66     *   67                             602 197 138 128     66         67                       602
1312980 1312980 MD     school 2400330 10   Frederick 240033001549 225 Gov. Thomas Johnson Middle   Regular School No Middle 06 08 2021   pk_12_total 233 119 135   * 35     *   38                             563 233 119 135     35         38                       563
1312991 1312991 MD     school 2400330 10   Frederick 240033001187 226 Monocacy Valley Montessori   Regular School Yes Elementary PK 08 2021   pk_12_total 181 37 36   * 25         23                             303 181 37 36     25         23                       303
1312995 1312995 MD     school 2400330 10   Frederick 240033001357 227 Crestwood Middle   Regular School No Middle 06 08 2021   pk_12_total 173 206 196   * 45     *   45                             670 173 206 196     45         45                       670
1313006 1313006 MD     school 2400330 10   Frederick 240033001712 228 Carroll Creek Montessori Public Charter   Regular School Yes Elementary PK 08 2021   pk_12_total 196 44 53   * 13         11                             318 196 44 53     13         11                       318
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
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
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
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
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
1313047 1313047 MD     school 2400330 10   Frederick 240033000652 702 Urbana Elementary   Regular School No Elementary PK 05 2021   pk_12_total 322 52 78   * 144         51                             651 322 52 78     144         51                       651
1313052 1313052 MD     school 2400330 10   Frederick 240033000616 713 Urbana High   Regular School No High 09 12 2021   pk_12_total 1055 173 242   11 320     *   103                             1908 1055 173 242   11 320         103                       1908
1313056 1313056 MD     school 2400330 10   Frederick 240033000392 714 Windsor Knolls Middle   Regular School No Middle 06 08 2021   pk_12_total 487 48 93     43     *   37                             709 487 48 93     43         37                       709
1313063 1313063 MD     school 2400330 10   Frederick 240033001429 715 Centerville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 177 58 67     87         50                             439 177 58 67     87         50                       439
1313067 1313067 MD     school 2400330 10   Frederick 240033001536 716 Urbana Middle   Regular School No Middle 06 08 2021   pk_12_total 483 91 112   * 208     *   70                             967 483 91 112     208         70                       967
1313074 1313074 MD     school 2400330 10   Frederick 240033001762 717 Sugarloaf Elementary   Regular School No Elementary KG 05 2021   pk_12_total 291 78 78   * 133         39                             620 291 78 78     133         39                       620
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
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
1313094 1313094 MD     school 2400330 10   Frederick 240033000638 912 Linganore High   Regular School No High 09 12 2021   pk_12_total 1162 33 115   * 23     *   57                             1393 1162 33 115     23         57                       1393
1313101 1313101 MD     school 2400330 10   Frederick 240033000635 913 Green Valley Elementary   Regular School No Elementary KG 05 2021   pk_12_total 306 51 66     84         38                             545 306 51 66     84         38                       545
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
1313120 1313120 MD     school 2400330 10   Frederick 240033090472 916 Spring Ridge Elementary   Regular School No Elementary PK 05 2021   pk_12_total 206 104 65     16     *   45                             437 206 104 65     16         45                       437
1313128 1313128 MD     school 2400330 10   Frederick 240033000847 917 Deer Crossing Elementary   Regular School No Elementary PK 05 2021   pk_12_total 651 32 58     19     *   51                             813 651 32 58     19         51                       813
1313132 1313132 MD     school 2400330 10   Frederick 240033001163 918 Oakdale Middle   Regular School No Middle 06 08 2021   pk_12_total 601 72 101   * 70     *   50                             899 601 72 101     70         50                       899
1313139 1313139 MD     school 2400330 10   Frederick 240033001165 919 Oakdale Elementary   Regular School No Elementary KG 05 2021   pk_12_total 527 117 102   * 135     *   40                             926 527 117 102     135         40                       926
1313144 1313144 MD     school 2400330 10   Frederick 240033001688 920 Oakdale High   Regular School No High 09 12 2021   pk_12_total 983 84 135   * 90     *   62                             1362 983 84 135     90         62                       1362
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
1313169 1313169 MD     school 2400330 10   Frederick 240033001715 1301 Frederick Classical Charter   Regular School Yes Elementary KG 08 2021   pk_12_total 155 117 47   * 30     *   23                             376 155 117 47     30         23                       376
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
1313181 1313181 MD     school 2400330 10   Frederick 240033000650 1503 Thurmont Elementary   Regular School No Elementary 03 05 2021   pk_12_total 256   22   *           12                             292 256   22               12                       292
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
1313195 1313195 MD     school 2400330 10   Frederick 240033001166 1511 Thurmont Primary   Regular School No Elementary PK 02 2021   pk_12_total 258   12     *         13                             284 258   12               13                       284
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
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
1313225 1313225 MD     school 2400330 10   Frederick 240033000661 2103 Yellow Springs Elementary   Regular School No Elementary KG 05 2021   pk_12_total 266 112 65   * 22     *   31                             498 266 112 65     22         31                       498
1313233 1313233 MD     school 2400330 10   Frederick 240033001015 2107 Whittier Elementary   Regular School No Elementary PK 05 2021   pk_12_total 300 182 121   * 43     *   36                             686 300 182 121     43         36                       686
1313241 1313241 MD     school 2400330 10   Frederick 240033090473 2302 Hillcrest Elementary   Regular School No Elementary PK 05 2021   pk_12_total 40 51 550     43         30                             714 40 51 550     43         30                       714
1313245 1313245 MD     school 2400330 10   Frederick 240033090446 2305 Ballenger Creek Middle   Regular School No Middle 06 08 2021   pk_12_total 338 161 180   * 51     *   62                             800 338 161 180     51         62                       800
1313253 1313253 MD     school 2400330 10   Frederick 240033000807 2306 Orchard Grove Elementary   Regular School No Elementary PK 05 2021   pk_12_total 150 205 144   * 53     *   46                             603 150 205 144     53         46                       603
1313258 1313258 MD     school 2400330 10   Frederick 240033001550 2307 Tuscarora High   Regular School No High 09 12 2021   pk_12_total 690 356 379   * 125     *   87                             1645 690 356 379     125         87                       1645
1313266 1313266 MD     school 2400330 10   Frederick 240033001748 2308 Butterfly Ridge Elementary   Regular School No Elementary PK 05 2021   pk_12_total 142 165 276     24     *   40                             649 142 165 276     24         40                       649
1313274 1313274 MD     school 2400330 10   Frederick 240033000657 2403 Waverley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 31 68 363   * 33         12                             511 31 68 363     33         12                       511
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
1313294 1313294 MD     school 2400330 10   Frederick 240033000627 2503 Brunswick High   Regular School No High 09 12 2021   pk_12_total 590 66 81   * 12         47                             797 590 66 81     12         47                       797
1313302 1313302 MD     school 2400330 10   Frederick 240033000626 2504 Brunswick Elementary   Regular School No Elementary PK 05 2021   pk_12_total 478 63 82   * 18         51                             694 478 63 82     18         51                       694
1313306 1313306 MD     school 2400330 10   Frederick 240033001409 2525 Brunswick Middle   Regular School No Middle 06 08 2021   pk_12_total 427 42 84   * *         49                             610 427 42 84               49                       610
1313310 1313310 MD     school 2400330 10   Frederick 240033000656 2606 Walkersville Middle   Regular School No Middle 06 08 2021   pk_12_total 519 108 131   * 23     *   53                             836 519 108 131     23         53                       836
1313318 1313318 MD     school 2400330 10   Frederick 240033000654 2607 Walkersville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 291 132 116   * 18     *   69                             631 291 132 116     18         69                       631
1313323 1313323 MD     school 2400330 10   Frederick 240033000655 2610 Walkersville High   Regular School No High 09 12 2021   pk_12_total 733 183 168   * 44     *   89                             1219 733 183 168     44         89                       1219
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
1240786 1240786 MD     school 2400360 11   Garrett 240036000667 1202 Friendsville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 133 * *               *                             142 133                                           142
1240794 1240794 MD     school 2400360 11   Garrett 240036000668 1301 Grantsville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 187   *                                             188 187                                           188
1240801 1240801 MD     school 2400360 11   Garrett 240036000665 1408 Crellin Elementary   Regular School No Elementary KG 05 2020   pk_12_total 127   *               *                             135 127                                           135
1240809 1240809 MD     school 2400360 11   Garrett 240036000662 1501 Accident Elementary   Regular School No Elementary PK 05 2020   pk_12_total 266   *               *                             281 266                                           281
1240817 1240817 MD     school 2400360 11   Garrett 240036000664 1707 Broad Ford Elementary   Regular School No Elementary PK 05 2020   pk_12_total 561 * *               *                             582 561                                           582
1240825 1240825 MD     school 2400360 11   Garrett 240036000852 1710 Yough Glades Elementary   Regular School No Elementary PK 05 2020   pk_12_total 295 * *               *                             308 295                                           308
1240835 1240835 MD     school 2400360 11   Garrett 240036000676 1812 Swan Meadow School   Regular School No Elementary KG 08 2020   pk_12_total 58   *                                             59 58                                           59
1240843 1240843 MD     school 2400360 11   Garrett 240036000673 1904 Route 40 Elementary   Regular School No Elementary PK 05 2020   pk_12_total 130   *               *                             133 130                                           133
1240847 1240847 MD     school 2400360 11   Garrett 240036001351 2511 Northern Middle School   Regular School No Middle 06 08 2020   pk_12_total 340   *               *                             357 340                                           357
1240851 1240851 MD     school 2400360 11   Garrett 240036000675 2708 Southern Middle School   Regular School No Middle 06 08 2020   pk_12_total 487 * *     *         12                             507 487                   12                       507
1240856 1240856 MD     school 2400360 11   Garrett 240036000671 3512 Northern Garrett High School   Regular School No High 09 12 2020   pk_12_total 426   *     *         *                             441 426                                           441
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
1313339 1313339 MD     school 2400360 11   Garrett 240036000667 1202 Friendsville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 131   *               *                             140 131                                           140
1313347 1313347 MD     school 2400360 11   Garrett 240036000668 1301 Grantsville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 171                   *                             172 171                                           172
1313354 1313354 MD     school 2400360 11   Garrett 240036000665 1408 Crellin Elementary   Regular School No Elementary KG 05 2021   pk_12_total 118   *               *                             123 118                                           123
1313362 1313362 MD     school 2400360 11   Garrett 240036000662 1501 Accident Elementary   Regular School No Elementary PK 05 2021   pk_12_total 221   12               *                             242 221   12                                       242
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
1313378 1313378 MD     school 2400360 11   Garrett 240036000852 1710 Yough Glades Elementary   Regular School No Elementary PK 05 2021   pk_12_total 271   *               *                             284 271                                           284
1313388 1313388 MD     school 2400360 11   Garrett 240036000676 1812 Swan Meadow School   Regular School No Elementary KG 08 2021   pk_12_total 44   *                                             45 44                                           45
1313396 1313396 MD     school 2400360 11   Garrett 240036000673 1904 Route 40 Elementary   Regular School No Elementary PK 05 2021   pk_12_total 117   *               *                             119 117                                           119
1313400 1313400 MD     school 2400360 11   Garrett 240036001351 2511 Northern Middle School   Regular School No Middle 06 08 2021   pk_12_total 342   *     *         *                             355 342                                           355
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
1313409 1313409 MD     school 2400360 11   Garrett 240036000671 3512 Northern Garrett High School   Regular School No High 09 12 2021   pk_12_total 440   11     *         *                             461 440   11                                       461
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
1240868 1240868 MD     school 2400390 12   Harford 240039000715 113 William S. James Elementary   Regular School No Elementary KG 05 2020   pk_12_total 338 55 30   * 12         35                             472 338 55 30     12         35                       472

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