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,791 ✖
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
1237214 1237214 MD     school 2400030 1   Allegany 240003000014 301 Flintstone Elementary   Regular School No Elementary PK 05 2020   pk_12_total 210 * *               *                             221 210                                           221
1237222 1237222 MD     school 2400030 1   Allegany 240003001359 401 South Penn Elementary   Regular School No Elementary PK 05 2020   pk_12_total 421 51 *     *         88                             571 421 51                 88                       571
1237230 1237230 MD     school 2400030 1   Allegany 240003000019 402 John Humbird Elementary   Regular School No Elementary PK 05 2020   pk_12_total 216 22 *               35                             279 216 22                 35                       279
1237235 1237235 MD     school 2400030 1   Allegany 240003000015 405 Fort Hill High   Regular School No High 09 12 2020   pk_12_total 578 38 10     *         44                             672 578 38 10               44                       672
1237239 1237239 MD     school 2400030 1   Allegany 240003000031 406 Washington Middle   Regular School No Middle 06 08 2020   pk_12_total 522 35 *     *     *   46                             612 522 35                 46                       612
1237247 1237247 MD     school 2400030 1   Allegany 240003000024 502 Northeast Elementary   Regular School No Elementary PK 05 2020   pk_12_total 268 16 *   * *         30                             319 268 16                 30                       319
1237251 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
1237254 1237254 MD     school 2400030 1   Allegany 240003000030 601 Center for Career & Technical Education   Career and Technical School No High 11 12 2020   pk_12_total 193   *               *                             203 193                                           203
1237262 1237262 MD     school 2400030 1   Allegany 240003000032 603 West Side Elementary   Regular School No Elementary PK 05 2020   pk_12_total 288 17 *   * *         52                             367 288 17                 52                       367
1237267 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
1237275 1237275 MD     school 2400030 1   Allegany 240003000010 701 Cresaptown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 284 * 12     *     *   16                             320 284   12               16                       320
1237283 1237283 MD     school 2400030 1   Allegany 240003000005 702 Bel Air Elementary   Regular School No Elementary PK 05 2020   pk_12_total 204 * *     *         11                             225 204                   11                       225
1237291 1237291 MD     school 2400030 1   Allegany 240003000033 801 Westernport Elementary   Regular School No Elementary PK 05 2020   pk_12_total 242 * *           *   11                             260 242                   11                       260
1237295 1237295 MD     school 2400030 1   Allegany 240003000007 802 Westmar Middle   Regular School No Middle 06 08 2020   pk_12_total 258   *     *         *                             268 258                                           268
1237303 1237303 MD     school 2400030 1   Allegany 240003000017 1001 George's Creek Elementary   Regular School No Elementary PK 05 2020   pk_12_total 282                   *                             285 282                                           285
1237311 1237311 MD     school 2400030 1   Allegany 240003000016 1101 Frost Elementary   Regular School No Elementary PK 05 2020   pk_12_total 183   *     *         *                             195 183                                           195
1237315 1237315 MD     school 2400030 1   Allegany 240003000023 1301 Mount Savage Middle   Regular School No Middle 06 08 2020   pk_12_total 369 * *   * *     *   12                             394 369                   12                       394
1237323 1237323 MD     school 2400030 1   Allegany 240003001546 1302 Mt. Savage Elementary   Regular School No Elementary PK 05 2020   pk_12_total 185   *   *           *                             191 185                                           191
1237328 1237328 MD     school 2400030 1   Allegany 240003001636 2404 Mountain Ridge High School   Regular School No High 09 12 2020   pk_12_total 729 17 *   * *         24                             784 729 17                 24                       784
1237336 1237336 MD     school 2400030 1   Allegany 240003000003 2801 Beall Elementary   Regular School No Elementary PK 05 2020   pk_12_total 386 * *   * *         30                             441 386                   30                       441
1237344 1237344 MD     school 2400030 1   Allegany 240003001338 2901 Cash Valley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 242 13 *   * *         12                             279 242 13                 12                       279
1237352 1237352 MD     school 2400030 1   Allegany 240003000026 2902 Parkside Elementary   Regular School No Elementary PK 05 2020   pk_12_total 164 15 *     *         18                             210 164 15                 18                       210
1309775 1309775 MD     school 2400030 1   Allegany 240003000014 301 Flintstone Elementary   Regular School No Elementary PK 05 2021   pk_12_total 193 * *               *                             205 193                                           205
1309783 1309783 MD     school 2400030 1   Allegany 240003001359 401 South Penn Elementary   Regular School No Elementary PK 05 2021   pk_12_total 361 40 *     *         85                             497 361 40                 85                       497
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
1309796 1309796 MD     school 2400030 1   Allegany 240003000015 405 Fort Hill High   Regular School No High 09 12 2021   pk_12_total 556 39 14     *         47                             657 556 39 14               47                       657
1309800 1309800 MD     school 2400030 1   Allegany 240003000031 406 Washington Middle   Regular School No Middle 06 08 2021   pk_12_total 516 27 *   * *     *   53                             609 516 27                 53                       609
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
1309812 1309812 MD     school 2400030 1   Allegany 240003000006 504 Braddock Middle   Regular School No Middle 06 08 2021   pk_12_total 502 28 14   * *     *   52                             605 502 28 14               52                       605
1309815 1309815 MD     school 2400030 1   Allegany 240003000030 601 Center for Career & Technical Education   Career and Technical School No High 11 12 2021   pk_12_total 245 * *   *           *                             258 245                                           258
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
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
1309836 1309836 MD     school 2400030 1   Allegany 240003000010 701 Cresaptown Elementary   Regular School No Elementary PK 05 2021   pk_12_total 251 * *   * *     *   17                             287 251                   17                       287
1309844 1309844 MD     school 2400030 1   Allegany 240003000005 702 Bel Air Elementary   Regular School No Elementary PK 05 2021   pk_12_total 202   *     *         *                             216 202                                           216
1309852 1309852 MD     school 2400030 1   Allegany 240003000033 801 Westernport Elementary   Regular School No Elementary PK 05 2021   pk_12_total 239 * *           *   10                             256 239                   10                       256
1309856 1309856 MD     school 2400030 1   Allegany 240003000007 802 Westmar Middle   Regular School No Middle 06 08 2021   pk_12_total 241   *               *                             256 241                                           256
1309864 1309864 MD     school 2400030 1   Allegany 240003000017 1001 George's Creek Elementary   Regular School No Elementary PK 05 2021   pk_12_total 241         *         *                             244 241                                           244
1309872 1309872 MD     school 2400030 1   Allegany 240003000016 1101 Frost Elementary   Regular School No Elementary PK 05 2021   pk_12_total 179   *     *         *                             192 179                                           192
1309876 1309876 MD     school 2400030 1   Allegany 240003000023 1301 Mount Savage Middle   Regular School No Middle 06 08 2021   pk_12_total 355 * *   * *     *   13                             383 355                   13                       383
1309884 1309884 MD     school 2400030 1   Allegany 240003001546 1302 Mt. Savage Elementary   Regular School No Elementary PK 05 2021   pk_12_total 181 * *   *           *                             186 181                                           186
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
1309897 1309897 MD     school 2400030 1   Allegany 240003000003 2801 Beall Elementary   Regular School No Elementary PK 05 2021   pk_12_total 384 * *   * *         41                             445 384                   41                       445
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
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
1240357 1240357 MD     school 2400330 10   Frederick 240033000628 108 Carroll Manor Elementary   Regular School No Elementary PK 05 2020   pk_12_total 411 55 70   * 16     *   21                             577 411 55 70     16         21                       577
1240365 1240365 MD     school 2400330 10   Frederick 240033001355 109 Tuscarora Elementary   Regular School No Elementary PK 05 2020   pk_12_total 211 177 206   * 54     *   60                             713 211 177 206     54         60                       713
1240372 1240372 MD     school 2400330 10   Frederick 240033000646 201 Parkway Elementary   Regular School No Elementary KG 05 2020   pk_12_total 144 32 41   * *         15                             242 144 32 41               15                       242
1240380 1240380 MD     school 2400330 10   Frederick 240033000649 204 Lincoln Elementary   Regular School No Elementary PK 05 2020   pk_12_total 86 216 218   * 20         55                             598 86 216 218     20         55                       598
1240388 1240388 MD     school 2400330 10   Frederick 240033001410 208 Heather Ridge   Alternative School No High 06 12 2020   pk_12_total 21 19 *   *           *                             56 21 19                                         56
1240393 1240393 MD     school 2400330 10   Frederick 240033000632 209 Frederick High   Regular School No High 09 12 2020   pk_12_total 384 375 561   * 116     *   65                             1508 384 375 561     116         65                       1508
1240401 1240401 MD     school 2400330 10   Frederick 240033000645 210 North Frederick Elementary   Regular School No Elementary PK 05 2020   pk_12_total 250 122 182     31     *   83                             669 250 122 182     31         83                       669
1240405 1240405 MD     school 2400330 10   Frederick 240033000658 211 West Frederick Middle   Regular School No Middle 06 08 2020   pk_12_total 242 229 374     47     *   52                             947 242 229 374     47         52                       947
1240410 1240410 MD     school 2400330 10   Frederick 240033000634 213 Gov. Thomas Johnson High   Regular School No High 09 12 2020   pk_12_total 615 390 542   * 83     *   92                             1730 615 390 542     83         92                       1730
1240414 1240414 MD     school 2400330 10   Frederick 240033001413 219 Monocacy Middle   Regular School No Middle 06 08 2020   pk_12_total 268 224 380   * 40     *   49                             969 268 224 380     40         49                       969
1240422 1240422 MD     school 2400330 10   Frederick 240033001521 222 Monocacy Elementary   Regular School No Elementary PK 05 2020   pk_12_total 167 177 190   * 17     *   53                             611 167 177 190     17         53                       611
1240430 1240430 MD     school 2400330 10   Frederick 240033090471 223 Ballenger Creek Elementary   Regular School No Elementary PK 05 2020   pk_12_total 218 113 124   * 61     *   64                             586 218 113 124     61         64                       586
1240434 1240434 MD     school 2400330 10   Frederick 240033001549 225 Gov. Thomas Johnson Middle   Regular School No Middle 06 08 2020   pk_12_total 258 104 124   * 31     *   31                             553 258 104 124     31         31                       553
1240445 1240445 MD     school 2400330 10   Frederick 240033001187 226 Monocacy Valley Montessori   Regular School Yes Elementary PK 08 2020   pk_12_total 193 32 30   * 25     *   18                             300 193 32 30     25         18                       300
1240449 1240449 MD     school 2400330 10   Frederick 240033001357 227 Crestwood Middle   Regular School No Middle 06 08 2020   pk_12_total 202 199 197   * 48     *   40                             691 202 199 197     48         40                       691
1240460 1240460 MD     school 2400330 10   Frederick 240033001712 228 Carroll Creek Montessori Public Charter   Regular School Yes Elementary PK 08 2020   pk_12_total 199 36 56   * 11         15                             318 199 36 56     11         15                       318
1240464 1240464 MD     school 2400330 10   Frederick 240033000639 303 Middletown Elementary   Regular School No Elementary 03 05 2020   pk_12_total 383 14 40   * *         28                             472 383 14 40               28                       472
1240468 1240468 MD     school 2400330 10   Frederick 240033000640 311 Middletown Middle   Regular School No Middle 06 08 2020   pk_12_total 652 24 55   * 15     *   33                             784 652 24 55     15         33                       784
1240473 1240473 MD     school 2400330 10   Frederick 240033000641 313 Middletown High   Regular School No High 09 12 2020   pk_12_total 970 19 70   * 26         42                             1129 970 19 70     26         42                       1129
1240478 1240478 MD     school 2400330 10   Frederick 240033001566 314 Middletown Primary   Regular School No Elementary PK 02 2020   pk_12_total 377 16 40     14         30                             477 377 16 40     14         30                       477
1240486 1240486 MD     school 2400330 10   Frederick 240033000631 503 Emmitsburg Elementary   Regular School No Elementary PK 05 2020   pk_12_total 193 * *     *         12                             220 193                   12                       220
1240493 1240493 MD     school 2400330 10   Frederick 240033000659 603 Wolfsville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 130 * *   *           *                             149 130                                           149
1240501 1240501 MD     school 2400330 10   Frederick 240033000652 702 Urbana Elementary   Regular School No Elementary PK 05 2020   pk_12_total 450 67 74   * 164         54                             813 450 67 74     164         54                       813
1240506 1240506 MD     school 2400330 10   Frederick 240033000616 713 Urbana High   Regular School No High 09 12 2020   pk_12_total 1082 164 221   * 276     *   99                             1851 1082 164 221     276         99                       1851
1240510 1240510 MD     school 2400330 10   Frederick 240033000392 714 Windsor Knolls Middle   Regular School No Middle 06 08 2020   pk_12_total 588 32 82     35     *   26                             764 588 32 82     35         26                       764
1240517 1240517 MD     school 2400330 10   Frederick 240033001429 715 Centerville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 452 99 139   * 206     *   73                             972 452 99 139     206         73                       972
1240521 1240521 MD     school 2400330 10   Frederick 240033001536 716 Urbana Middle   Regular School No Middle 06 08 2020   pk_12_total 548 73 123   * 203     *   67                             1021 548 73 123     203         67                       1021
1240528 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
1240536 1240536 MD     school 2400330 10   Frederick 240033000643 903 New Market Elementary   Regular School No Elementary PK 05 2020   pk_12_total 569 14 43   * 25     *   28                             684 569 14 43     25         28                       684
1240541 1240541 MD     school 2400330 10   Frederick 240033000638 912 Linganore High   Regular School No High 09 12 2020   pk_12_total 1131 22 97   * 12     *   46                             1311 1131 22 97     12         46                       1311
1240548 1240548 MD     school 2400330 10   Frederick 240033000635 913 Green Valley Elementary   Regular School No Elementary KG 05 2020   pk_12_total 412 38 79   * 58     *   38                             627 412 38 79     58         38                       627
1240552 1240552 MD     school 2400330 10   Frederick 240033001379 914 New Market Middle   Regular School No Middle 06 08 2020   pk_12_total 484 * 33   * 11     *   24                             563 484   33     11         24                       563
1240559 1240559 MD     school 2400330 10   Frederick 240033001412 915 Kemptown Elementary   Regular School No Elementary KG 05 2020   pk_12_total 301 14 42   * 14         31                             403 301 14 42     14         31                       403
1240567 1240567 MD     school 2400330 10   Frederick 240033090472 916 Spring Ridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 242 107 55   * 21     *   53                             482 242 107 55     21         53                       482
1240575 1240575 MD     school 2400330 10   Frederick 240033000847 917 Deer Crossing Elementary   Regular School No Elementary PK 05 2020   pk_12_total 674 27 55     21     *   28                             806 674 27 55     21         28                       806
1240579 1240579 MD     school 2400330 10   Frederick 240033001163 918 Oakdale Middle   Regular School No Middle 06 08 2020   pk_12_total 624 54 83   * 56     *   50                             872 624 54 83     56         50                       872
1240586 1240586 MD     school 2400330 10   Frederick 240033001165 919 Oakdale Elementary   Regular School No Elementary KG 05 2020   pk_12_total 503 89 73   * 95     *   25                             792 503 89 73     95         25                       792
1240591 1240591 MD     school 2400330 10   Frederick 240033001688 920 Oakdale High   Regular School No High 09 12 2020   pk_12_total 961 63 116   * 68         54                             1267 961 63 116     68         54                       1267
1240598 1240598 MD     school 2400330 10   Frederick 240033000648 1001 Sabillasville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 75 * *               *                             82 75                                           82
1240606 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
1240616 1240616 MD     school 2400330 10   Frederick 240033001715 1301 Frederick Classical Charter   Regular School Yes Elementary KG 08 2020   pk_12_total 158 124 37   * 32     *   22                             376 158 124 37     32         22                       376
1240624 1240624 MD     school 2400330 10   Frederick 240033000653 1406 Valley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 395 14 65   * *     *   23                             508 395 14 65               23                       508
1240628 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
1240633 1240633 MD     school 2400330 10   Frederick 240033000629 1509 Catoctin High   Regular School No High 09 12 2020   pk_12_total 672 * 38   * *     *   22                             749 672   38               22                       749
1240637 1240637 MD     school 2400330 10   Frederick 240033000651 1510 Thurmont Middle   Regular School No Middle 06 08 2020   pk_12_total 494 * 24   * *     *   15                             545 494   24               15                       545
1240642 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
1240649 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
1240657 1240657 MD     school 2400330 10   Frederick 240033000159 1801 Twin Ridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 396 * 46   * *         17                             473 396   46               17                       473
1240665 1240665 MD     school 2400330 10   Frederick 240033000636 2001 Lewistown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 139 * 35               14                             195 139   35               14                       195
1240672 1240672 MD     school 2400330 10   Frederick 240033000661 2103 Yellow Springs Elementary   Regular School No Elementary KG 05 2020   pk_12_total 275 97 41   * 19     *   32                             470 275 97 41     19         32                       470
1240680 1240680 MD     school 2400330 10   Frederick 240033001015 2107 Whittier Elementary   Regular School No Elementary PK 05 2020   pk_12_total 322 193 116   * 44     *   35                             718 322 193 116     44         35                       718
1240688 1240688 MD     school 2400330 10   Frederick 240033090473 2302 Hillcrest Elementary   Regular School No Elementary PK 05 2020   pk_12_total 41 70 561     46         31                             749 41 70 561     46         31                       749
1240692 1240692 MD     school 2400330 10   Frederick 240033090446 2305 Ballenger Creek Middle   Regular School No Middle 06 08 2020   pk_12_total 362 172 168   * 60     *   47                             817 362 172 168     60         47                       817
1240700 1240700 MD     school 2400330 10   Frederick 240033000807 2306 Orchard Grove Elementary   Regular School No Elementary PK 05 2020   pk_12_total 173 207 150   * 54     *   47                             635 173 207 150     54         47                       635
1240705 1240705 MD     school 2400330 10   Frederick 240033001550 2307 Tuscarora High   Regular School No High 09 12 2020   pk_12_total 701 340 338   * 112     *   92                             1590 701 340 338     112         92                       1590
1240713 1240713 MD     school 2400330 10   Frederick 240033001748 2308 Butterfly Ridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 147 201 274     22     *   30                             675 147 201 274     22         30                       675

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