enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1237514 1237514 MD     school 2400060 2   Anne Arundel 240006000094 1274 Marley Glen School   Special Education School No Other PK 11 2020   pk_12_total 91 32 15   * 11     *   *                             160 91 32 15     11                                 160
1237948 1237948 MD     school 2400060 2   Anne Arundel 240006001425 3414 Ruth Parker Eason School   Special Education School No Other PK 12 2020   pk_12_total 51 63 19     *         *                             143 51 63 19                                       143
1237992 1237992 MD     school 2400060 2   Anne Arundel 240006001714 4074 Phoenix Academy   Special Education School No Other KG 12 2020   pk_12_total 131 164 27   *           22                             347 131 164 27               22                       347
1238147 1238147 MD     school 2400060 2   Anne Arundel 240006000056 4304 Central Special School   Special Education School No Other PK 12 2020   pk_12_total 80 32 23     *         *                             148 80 32 23                                       148
1238296 1238296 MD     school 2400120 3   Baltimore County 240012000466 111 Maiden Choice School   Special Education School No Other PK 12 2020   pk_12_total 33 72 *     20         *                             137 33 72       20                                 137
1238817 1238817 MD     school 2400120 3   Baltimore County 240012000483 922 Ridge Ruxton   Special Education School No Other PK 12 2020   pk_12_total 38 42 15   * 19         *                             123 38 42 15     19                                 123
1238825 1238825 MD     school 2400120 3   Baltimore County 240012001435 923 White Oak School   Special Education School No Elementary PK 05 2020   pk_12_total 39 36 *     *         *                             93 39 36                                         93
1239008 1239008 MD     school 2400120 3   Baltimore County 240012000346 1215 Battle Monument School   Special Education School No Other PK 12 2020   pk_12_total 30 19 *     *         *                             63 30 19                                         63
1239417 1239417 MD     school 2400150 4   Calvert 240015000509 206 Calvert Country School   Special Education School No Other 03 12 2020   pk_12_total 29 * *   * *         *                             46 29                                           46
1239744 1239744 MD     school 2400210 6   Carroll 240021000527 712 Carroll Springs School   Special Education School No Other PK 12 2020   pk_12_total 26 * *     *                                       33 26                                           33
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
1241132 1241132 MD     school 2400390 12   Harford 240039000703 391 John Archer School   Special Education School No Other PK 12 2020   pk_12_total 64 36 11     *         *                             123 64 36 11                                       123
1241522 1241522 MD     school 2400420 13   Howard 240042001415 522 Cedar Lane Special Center   Special Education School No Other PK 12 2020   pk_12_total 33 47 14   * 18         *                             117 33 47 14     18                                 117
1241934 1241934 MD     school 2400480 15   Montgomery 240048000799 215 Carl Sandburg Center   Special Education School No Elementary KG 05 2020   pk_12_total 17 36 33     10         *                             97 17 36 33     10                                 97
1242467 1242467 MD     school 2400480 15   Montgomery 240048001365 525 MCPS Transitions School   Special Education School No High 12 12 2020   pk_12_total 13 21 15     *         *                             55 13 21 15                                       55
1242617 1242617 MD     school 2400480 15   Montgomery 240048001635 587 PEP - Itinerant   Special Education School No Prekindergarten PK PK 2020   pk_12_total 43 18 16   * 16         *                             100 43 18 16     16                                 100
1242972 1242972 MD     school 2400480 15   Montgomery 240048000496 799 Stephen Knolls School   Special Education School No Other PK 12 2020   pk_12_total 15 23 33     *         *                             76 15 23 33                                       76
1243057 1243057 MD     school 2400480 15   Montgomery 240048001460 916 Rock Terrace School   Special Education School No High 06 12 2020   pk_12_total 27 26 24     11         *                             92 27 26 24     11                                 92
1243071 1243071 MD     school 2400480 15   Montgomery 240048000867 951 Longview School   Special Education School No Other KG 12 2020   pk_12_total 17 16 21     *                                       61 17 16 21                                       61
1243081 1243081 MD     school 2400480 15   Montgomery 240048001398 965 John L Gildner Regional Inst for Children & Adol   Special Education School No Other 04 12 2020   pk_12_total 35 41 25     *         *                             112 35 41 25                                       112
1243107 1243107 MD     school 2400510 16   Prince George's 240051001134 107 Frances Fuchs Early Childhood Center   Special Education School No Prekindergarten PK PK 2020   pk_12_total 18 120 167   * 14         *                             324 18 120 167     14                                 324
1243121 1243121 MD     school 2400510 16   Prince George's 240051001354 108 James E. Duckworth Regional Center   Special Education School No Other KG 12 2020   pk_12_total * 33 52     *         *                             93   33 52                                       93
1243527 1243527 MD     school 2400510 16   Prince George's 240051001384 723 C. Elizabeth Rieg Regional Center   Special Education School No Other KG 12 2020   pk_12_total 13 88 12     *                                       115 13 88 12                                       115
1243860 1243860 MD     school 2400510 16   Prince George's 240051001731 1313 Kenmoor Early Childhood Center   Special Education School No Prekindergarten PK PK 2020   pk_12_total 12 127 141   * *                                       288 12 127 141                                       288
1244040 1244040 MD     school 2400510 16   Prince George's 240051001003 1433 Chapel Forge Early Childhood Center   Special Education School No Prekindergarten PK PK 2020   pk_12_total 14 178 43   * 12         *                             254 14 178 43     12                                 254
1244326 1244326 MD     school 2400510 16   Prince George's 240051001053 1822 H. W. Wheatley Early Childhood Center   Special Education School No Prekindergarten PK PK 2020   pk_12_total * 244 39     10         *                             301   244 39     10                                 301
1244446 1244446 MD     school 2400510 16   Prince George's 240051001419 2012 Margaret Brent Regional Center   Special Education School No Elementary KG 08 2020   pk_12_total * 42 27                                             72   42 27                                       72
1245080 1245080 MD     school 2400660 21   Washington 240066001484 705 Washington County Job Development Center   Special Education School No High 12 12 2020   pk_12_total 23 * *               *                             33 23                                           33
1245199 1245199 MD     school 2400660 21   Washington 240066001289 2505 Marshall Street School   Special Education School No Other KG 12 2020   pk_12_total 25 * *     *         *                             43 25                                           43
1245426 1245426 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2020   pk_12_total 28 19 *     *         *                             55 28 19                                         55
1245979 1245979 MD     school 2400090 30   Baltimore City 240009000219 177 George W. F. McMechen High   Special Education School No High 09 12 2020   pk_12_total * 44 *               *                             50   44                                         50
1246444 1246444 MD     school 2400090 30   Baltimore City 240009000336 301 William S. Baer School   Special Education School No Other PK 12 2020   pk_12_total 15 126 21     *                                       167 15 126 21                                       167
1246450 1246450 MD     school 2400090 30   Baltimore City 240009000176 307 Claremont School   Special Education School No High 08 12 2020   pk_12_total * 44 *                                             48   44                                         48
1246461 1246461 MD     school 2400090 30   Baltimore City 240009001364 313 Lois T. Murray Elementary/Middle   Special Education School No Elementary PK 08 2020   pk_12_total * 33 *                                             44   33                                         44
1246466 1246466 MD     school 2400090 30   Baltimore City 240009001369 314 Sharp-Leadenhall Elementary   Special Education School No Elementary 01 05 2020   pk_12_total * 15                 *                             18   15                                         18
1246580 1246580 MD     school 2400090 30   Baltimore City 240009001662 345 Joseph C. Briscoe Academy   Special Education School No High 06 12 2020   pk_12_total * 50                                               57   50                                         57
1310076 1310076 MD     school 2400060 2   Anne Arundel 240006000094 1274 Marley Glen School   Special Education School No Other PK 12 2021   pk_12_total 61 29 22   * *         *                             126 61 29 22                                       126
1310513 1310513 MD     school 2400060 2   Anne Arundel 240006001425 3414 Ruth Parker Eason School   Special Education School No Other PK 12 2021   pk_12_total 46 68 19     *     *   *                             149 46 68 19                                       149
1310556 1310556 MD     school 2400060 2   Anne Arundel 240006001714 4074 Phoenix Academy   Special Education School No Other 01 12 2021   pk_12_total 121 172 30   *           24                             349 121 172 30               24                       349
1310711 1310711 MD     school 2400060 2   Anne Arundel 240006000056 4304 Central Special School   Special Education School No Other PK 12 2021   pk_12_total 67 27 26     *         *                             129 67 27 26                                       129
1310850 1310850 MD     school 2400120 3   Baltimore County 240012000466 111 Maiden Choice School   Special Education School No Other PK 12 2021   pk_12_total 29 71 *     16         *                             130 29 71       16                                 130
1311372 1311372 MD     school 2400120 3   Baltimore County 240012000483 922 Ridge/Ruxton School   Special Education School No Other PK 12 2021   pk_12_total 35 42 14   * 20         *                             119 35 42 14     20                                 119
1311380 1311380 MD     school 2400120 3   Baltimore County 240012001435 923 White Oak School   Special Education School No Elementary PK 05 2021   pk_12_total 30 33 *     *         *                             75 30 33                                         75
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
1311972 1311972 MD     school 2400150 4   Calvert 240015000509 206 Calvert Country School   Special Education School No Other 03 12 2021   pk_12_total 23 *     * *         *                             38 23                                           38
1312292 1312292 MD     school 2400210 6   Carroll 240021000527 712 Carroll Springs School   Special Education School No Other 01 12 2021   pk_12_total 25 * *                                             28 25                                           28
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
1313688 1313688 MD     school 2400390 12   Harford 240039000703 391 John Archer School   Special Education School No Other PK 12 2021   pk_12_total 65 41 16     *         10                             136 65 41 16               10                       136
1314077 1314077 MD     school 2400420 13   Howard 240042001415 522 Cedar Lane Special Center   Special Education School No Other PK 12 2021   pk_12_total 30 47 13     22         *                             116 30 47 13     22                                 116
1314493 1314493 MD     school 2400480 15   Montgomery 240048000799 215 Carl Sandburg Center   Special Education School No Elementary KG 05 2021   pk_12_total 11 39 31     10         *                             94 11 39 31     10                                 94
1315194 1315194 MD     school 2400480 15   Montgomery 240048001635 587 PEP - Itinerant   Special Education School No Prekindergarten PK PK 2021   pk_12_total 14 * *     *         *                             40 14                                           40
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
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
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
1315661 1315661 MD     school 2400480 15   Montgomery 240048001398 965 John L Gildner Regional Inst for Children & Adol   Special Education School No Other 04 12 2021   pk_12_total 33 37 25     *         10                             108 33 37 25               10                       108
1315687 1315687 MD     school 2400510 16   Prince George's 240051001134 107 Frances Fuchs Early Childhood Center   Special Education School No Prekindergarten PK PK 2021   pk_12_total 11 100 117   * 14     *   *                             249 11 100 117     14                                 249
1315701 1315701 MD     school 2400510 16   Prince George's 240051001354 108 James E. Duckworth Regional Center   Special Education School No Other KG 12 2021   pk_12_total * 34 57     *         *                             103   34 57                                       103
1316107 1316107 MD     school 2400510 16   Prince George's 240051001384 723 C. Elizabeth Rieg Regional Center   Special Education School No Other KG 12 2021   pk_12_total 12 87 12     *                                       114 12 87 12                                       114
1316188 1316188 MD     school 2400510 16   Prince George's 240051001763 918 James Ryder Randall Early Childhood Center   Special Education School No Prekindergarten PK PK 2021   pk_12_total * 57 17     *         *                             88   57 17                                       88
1316441 1316441 MD     school 2400510 16   Prince George's 240051001731 1313 Kenmoor Early Childhood Center   Special Education School No Prekindergarten PK PK 2021   pk_12_total * 53 60   * *         *                             122   53 60                                       122
1316621 1316621 MD     school 2400510 16   Prince George's 240051001003 1433 Chapel Forge Early Childhood Center   Special Education School No Prekindergarten PK PK 2021   pk_12_total 17 162 31     10         *                             228 17 162 31     10                                 228
1316907 1316907 MD     school 2400510 16   Prince George's 240051001053 1822 H. W. Wheatley Early Childhood Center   Special Education School No Prekindergarten PK PK 2021   pk_12_total * 212 30     *         *                             261   212 30                                       261
1317027 1317027 MD     school 2400510 16   Prince George's 240051001419 2012 Margaret Brent Regional Center   Special Education School No Elementary KG 08 2021   pk_12_total * 40 28     *         *                             72   40 28                                       72
1317655 1317655 MD     school 2400660 21   Washington 240066001484 705 Washington County Job Development Center   Special Education School No High 12 12 2021   pk_12_total 18 11 *               *                             34 18 11                                         34
1317775 1317775 MD     school 2400660 21   Washington 240066001289 2505 Marshall Street School   Special Education School No Other PK 12 2021   pk_12_total 24 * *     *         *                             41 24                                           41
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
1318543 1318543 MD     school 2400090 30   Baltimore City 240009000219 177 George W. F. McMechen High   Special Education School No High 10 12 2021   pk_12_total * 39 *               *                             44   39                                         44
1318995 1318995 MD     school 2400090 30   Baltimore City 240009000336 301 William S. Baer School   Special Education School No Other PK 12 2021   pk_12_total 14 112 20     *                                       148 14 112 20                                       148
1319001 1319001 MD     school 2400090 30   Baltimore City 240009000176 307 Claremont School   Special Education School No High 07 12 2021   pk_12_total * 47 *                                             51   47                                         51
1319011 1319011 MD     school 2400090 30   Baltimore City 240009001364 313 Lois T. Murray Elementary/Middle   Special Education School No Elementary KG 08 2021   pk_12_total * 34 *                                             44   34                                         44
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
1319130 1319130 MD     school 2400090 30   Baltimore City 240009001662 345 Joseph C. Briscoe Academy   Special Education School No High 06 12 2021   pk_12_total * 50 *               *                             58   50                                         58
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
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
1237356 1237356 MD     school 2400060 2   Anne Arundel 240006000050 1023 Brooklyn Park Middle   Regular School No Middle 06 08 2020   pk_12_total 350 217 185   * 16     *   64                             837 350 217 185     16         64                       837
1237361 1237361 MD     school 2400060 2   Anne Arundel 240006000075 1033 Glen Burnie High   Regular School No High 09 12 2020   pk_12_total 812 624 420   * 86     *   120                             2076 812 624 420     86         120                       2076
1237365 1237365 MD     school 2400060 2   Anne Arundel 240006000059 1043 Corkran Middle School   Regular School No Middle 06 08 2020   pk_12_total 237 176 167   * 25     *   46                             657 237 176 167     25         46                       657
1237369 1237369 MD     school 2400060 2   Anne Arundel 240006000087 1053 Lindale Middle   Regular School No Middle 06 08 2020   pk_12_total 480 302 202   * 64     *   71                             1126 480 302 202     64         71                       1126
1237373 1237373 MD     school 2400060 2   Anne Arundel 240006000095 1063 Marley Middle   Regular School No Middle 06 08 2020   pk_12_total 359 255 213   * 28     *   79                             938 359 255 213     28         79                       938
1237381 1237381 MD     school 2400060 2   Anne Arundel 240006000043 1082 Belle Grove Elementary   Regular School No Elementary PK 05 2020   pk_12_total 120 64 75   * 13     *   35                             309 120 64 75     13         35                       309
1237389 1237389 MD     school 2400060 2   Anne Arundel 240006000049 1092 Brooklyn Park Elementary   Regular School No Elementary PK 05 2020   pk_12_total 199 108 104   * *         30                             450 199 108 104               30                       450

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