enrollments

Data source: Big Local News · About: Big Local

1,398 rows where grade = "pk_12_total", state = "MD" and year = 2020 sorted by ccd_school_type

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 1,398 ✖

grade ✖

  • pk_12_total · 1,398 ✖
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
1244572 1244572 MD     school   16   Prince George's   2217 Incarcerated Youth Center (JACS)             2020   pk_12_total   * *                                             10                                             10
1237670 1237670 MD     school 2400060 2   Anne Arundel 240006000899 2233 Anne Arundel Evening High   Alternative School No High 09 12 2020   pk_12_total 150 66 55   * *         22                             296 150 66 55               22                       296
1237978 1237978 MD     school 2400060 2   Anne Arundel 240006001729 4064 Mary Moss at Adams Academy   Alternative School No Middle 07 09 2020   pk_12_total 11 21 *               *                             44 11 21                                         44
1238185 1238185 MD     school 2400120 3   Baltimore County 240012001756 51 Northwest EDLP at Milford Mill Academy   Alternative School No High 11 12 2020   pk_12_total   * *                                             *                                              
1238189 1238189 MD     school 2400120 3   Baltimore County 240012001751 52 Southwest EDLP at Woodlawn High School   Alternative School No High 09 12 2020   pk_12_total * * *     *         *                             14                                             14
1238193 1238193 MD     school 2400120 3   Baltimore County 240012001754 53 Northeast EDLP at Parkville High School   Alternative School No High 10 12 2020   pk_12_total * * *                                             18                                             18
1238197 1238197 MD     school 2400120 3   Baltimore County 240012001759 55 Southeast EDLP at Dundalk High School   Alternative School No High 10 12 2020   pk_12_total * 10 *               *                             18   10                                         18
1238199 1238199 MD     school 2400120 3   Baltimore County 240012001760 56 Central EDLP at Loch Raven High School   Alternative School No High 12 12 2020   pk_12_total * *                                               *                                              
1238203 1238203 MD     school 2400120 3   Baltimore County 240012000925 57 Home Assignments-Elementary   Alternative School No Middle 04 06 2020   pk_12_total   *                                               *                                              
1238210 1238210 MD     school 2400120 3   Baltimore County 240012000935 58 Home Assignments-Secondary   Alternative School No High 07 12 2020   pk_12_total * 17                 *                             26   17                                         26
1238218 1238218 MD     school 2400120 3   Baltimore County 240012000436 69 Catonsville Center for Alternative Studies   Alternative School No High 09 12 2020   pk_12_total * 45 *     *         *                             55   45                                         55
1238221 1238221 MD     school 2400120 3   Baltimore County 240012000777 70 Meadowood Education Center   Alternative School No Middle 07 08 2020   pk_12_total * 25 *   * *         *                             33   25                                         33
1238229 1238229 MD     school 2400120 3   Baltimore County 240012000831 72 Rosedale Center   Alternative School No High 06 12 2020   pk_12_total 21 36 *               *                             65 21 36                                         65
1238236 1238236 MD     school 2400120 3   Baltimore County 240012001649 75 Crossroads Center   Alternative School No High 07 12 2020   pk_12_total 58 97 *   * *         16                             183 58 97                 16                       183
1238241 1238241 MD     school 2400120 3   Baltimore County 240012001711 77 BCDC Educational Center   Alternative School No High 09 12 2020   pk_12_total * 24 *                                             33   24                                         33
1239512 1239512 MD     school 2400150 4   Calvert 240015001344 500 Calvert County Alternative School   Alternative School No High 09 12 2020   pk_12_total * * *                                             *                                              
1239764 1239764 MD     school 2400210 6   Carroll 240021001548 716 Gateway School   Alternative School No High 09 12 2020   pk_12_total 54 * *   * *         *                             66 54                                           66
1239766 1239766 MD     school 2400210 6   Carroll 240021001348 717 Post Secondary Program   Alternative School No High 12 12 2020   pk_12_total 41 * *                                             44 41                                           44
1239771 1239771 MD     school 2400210 6   Carroll 240021001349 718 PRIDE School   Alternative School No Elementary 01 05 2020   pk_12_total * *                                               *                                              
1239774 1239774 MD     school 2400210 6   Carroll 240021001694 726 Crossroads Middle School   Alternative School No Middle 06 08 2020   pk_12_total *   *               *                             *                                              
1239802 1239802 MD     school 2400210 6   Carroll 240021001350 903 Flexible Student Support   Alternative School No High 09 12 2020   pk_12_total 19         *         *                             22 19                                           22
1240230 1240230 MD     school 2400270 8   Charles 240027001395 708 Robert D. Stethem Educational Center   Alternative School No High 06 12 2020   pk_12_total 25 53 *   *       *   *                             88 25 53                                         88
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
1241005 1241005 MD     school 2400390 12   Harford 240039000480 292 Center for Educational Opportunity   Alternative School No High 08 12 2020   pk_12_total 26 37 *     *         *                             74 26 37                                         74
1241226 1241226 MD     school 2400420 13   Howard 240042001189 80 Homewood School   Alternative School No High 06 12 2020   pk_12_total 30 70 14   * *         *                             122 30 70 14                                       122
1242029 1242029 MD     school 2400480 15   Montgomery 240048001451 239 Alternative Programs   Alternative School No High 07 12 2020   pk_12_total 10 63 43     *         *                             126 10 63 43                                       126
1243205 1243205 MD     school 2400510 16   Prince George's 240051000865 216 Annapolis Road Academy   Alternative School No Secondary 09 10 2020   pk_12_total   66 51               *                             120   66 51                                       120
1243217 1243217 MD     school 2400510 16   Prince George's 240051001463 303 Croom High   Alternative School No High 11 12 2020   pk_12_total   62 *               *                             65   62                                         65
1243298 1243298 MD     school 2400510 16   Prince George's 240051001047 608 Green Valley Academy at Edgar Allan Poe   Alternative School No Secondary 07 10 2020   pk_12_total * 41 *   *           *                             50   41                                         50
1243467 1243467 MD     school 2400510 16   Prince George's 240051001424 705 Tall Oaks High   Alternative School No High 11 12 2020   pk_12_total * 63 25   * *                                       95   63 25                                       95
1244562 1244562 MD     school 2400510 16   Prince George's 240051001054 2211 Northwestern Evening/Saturday High   Alternative School No High 09 12 2020   pk_12_total * 64 401   * *         *                             481   64 401                                       481
1244567 1244567 MD     school 2400510 16   Prince George's 240051001062 2213 Crossland Evening/Saturday High   Alternative School No High 09 12 2020   pk_12_total * 185 33   *           *                             228   185 33                                       228
1244576 1244576 MD     school 2400510 16   Prince George's 240051001067 2220 Community Based Classrooms   Alternative School No High 12 12 2020   pk_12_total * 49 23           *   *                             75   49 23                                       75
1245273 1245273 MD     school 2400690 22   Wicomico 240069001088 520 Wicomico County Evening High   Alternative School No High 09 12 2020   pk_12_total 38 55 10     *         *                             107 38 55 10                                       107
1245985 1245985 MD     school 2400090 30   Baltimore City 240009001343 178 Excel Academy at Francis M. Wood High   Alternative School No High 08 12 2020   pk_12_total * 620 10   *           *                             642   620 10                                       642
1246731 1246731 MD     school 2400090 30   Baltimore City 240009000236 413 Achievement Academy at Harbor City High   Alternative School No High 09 12 2020   pk_12_total * 404 26   *                                         433   404 26                                       433
1246813 1246813 MD     school 2400090 30   Baltimore City 240009000885 884 Eager Street Academy   Alternative School No High 08 12 2020   pk_12_total   43 *     *                                       46   43                                         46
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
1238351 1238351 MD     school 2400120 3   Baltimore County 240012000248 175 Western School of Technology & Env. Science   Career and Technical School No High 09 12 2020   pk_12_total 120 515 47   * 183     *   25                             892 120 515 47     183         25                       892
1238864 1238864 MD     school 2400120 3   Baltimore County 240012000230 975 George W. Carver Center for Arts & Technology   Career and Technical School No High 09 12 2020   pk_12_total 439 349 58   * 63     *   44                             961 439 349 58     63         44                       961
1239356 1239356 MD     school 2400120 3   Baltimore County 240012000379 1575 Eastern Technical High School   Career and Technical School No High 09 12 2020   pk_12_total 562 235 57   * 257     *   55                             1172 562 235 57     257         55                       1172
1241010 1241010 MD     school 2400390 12   Harford 240039000694 304 Harford Technical High   Career and Technical School No High 09 12 2020   pk_12_total 698 145 81   * 34     *   38                             999 698 145 81     34         38                       999
1244574 1244574 MD     school 2400510 16   Prince George's 240051001755 2218 Career and Technical Education Evening High   Career and Technical School No Secondary 11 11 2020   pk_12_total   * 12   *           *                             15     12                                       15
1244998 1244998 MD     school 2400660 21   Washington 240066000308 305 Washington County Technical High   Career and Technical School No High 11 12 2020   pk_12_total 435 53 74   * 16     *   33                             613 435 53 74     16         33                       613
1246701 1246701 MD     school 2400090 30   Baltimore City 240009000194 400 Edmondson-Westside High   Career and Technical School No High 09 12 2020   pk_12_total 10 826 13   * *     *                                 853 10 826 13                                       853
1246711 1246711 MD     school 2400090 30   Baltimore City 240009000297 405 Patterson High   Career and Technical School No High 09 12 2020   pk_12_total 76 549 524   * *         10                             1174 76 549 524               10                       1174
1246726 1246726 MD     school 2400090 30   Baltimore City 240009000280 410 Mergenthaler Vocational-Technical High   Career and Technical School No High 09 12 2020   pk_12_total 44 1555 108   * *         *                             1719 44 1555 108                                       1719
1246746 1246746 MD     school 2400090 30   Baltimore City 240009001313 416 Digital Harbor High School   Career and Technical School No High 09 12 2020   pk_12_total 80 715 346   * 13     *   *                             1162 80 715 346     13                                 1162
1246777 1246777 MD     school 2400090 30   Baltimore City 240009001385 429 Vivien T. Thomas Medical Arts Academy   Career and Technical School No High 09 12 2020   pk_12_total 11 357 16   *           *                             387 11 357 16                                       387
1246802 1246802 MD     school 2400090 30   Baltimore City 240009000168 454 Carver Vocational-Technical High   Career and Technical School No High 09 12 2020   pk_12_total * 859 13   * *         *                             885   859 13                                       885
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
1237392 1237392 MD     school 2400060 2   Anne Arundel 240006000066 1102 Ferndale Early Education Center   Regular School No Elementary PK KG 2020   pk_12_total 76 33 28   * *         *                             151 76 33 28                                       151
1237398 1237398 MD     school 2400060 2   Anne Arundel 240006000071 1112 George T. Cromwell Elementary   Regular School No Elementary 01 05 2020   pk_12_total 160 35 77   * 10     *   17                             301 160 35 77     10         17                       301
1237406 1237406 MD     school 2400060 2   Anne Arundel 240006001515 1122 Freetown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 146 184 90   * 15     *   34                             471 146 184 90     15         34                       471
1237414 1237414 MD     school 2400060 2   Anne Arundel 240006000077 1132 Glendale Elementary   Regular School No Elementary PK 05 2020   pk_12_total 192 41 134   * *     *   34                             412 192 41 134               34                       412
1237422 1237422 MD     school 2400060 2   Anne Arundel 240006000081 1142 Hilltop Elementary   Regular School No Elementary PK 05 2020   pk_12_total 176 235 186   * 23     *   56                             679 176 235 186     23         56                       679
1237429 1237429 MD     school 2400060 2   Anne Arundel 240006000088 1152 Linthicum Elementary   Regular School No Elementary KG 05 2020   pk_12_total 348 31 51     25     *   18                             475 348 31 51     25         18                       475
1237437 1237437 MD     school 2400060 2   Anne Arundel 240006000093 1162 Marley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 228 257 213   * 63     *   61                             831 228 257 213     63         61                       831
1237445 1237445 MD     school 2400060 2   Anne Arundel 240006000102 1172 North Glen Elementary   Regular School No Elementary PK 05 2020   pk_12_total 87 91 82     14         31                             305 87 91 82     14         31                       305
1237453 1237453 MD     school 2400060 2   Anne Arundel 240006000105 1182 Oakwood Elementary   Regular School No Elementary PK 05 2020   pk_12_total 137 66 79   * 28     *   21                             334 137 66 79     28         21                       334
1237461 1237461 MD     school 2400060 2   Anne Arundel 240006000110 1192 Overlook Elementary   Regular School No Elementary PK 05 2020   pk_12_total 191 78 72     13     *   21                             376 191 78 72     13         21                       376
1237469 1237469 MD     school 2400060 2   Anne Arundel 240006000111 1202 Park Elementary   Regular School No Elementary PK 05 2020   pk_12_total 176 127 160   * 16     *   38                             519 176 127 160     16         38                       519
1237477 1237477 MD     school 2400060 2   Anne Arundel 240006000116 1212 Point Pleasant Elementary   Regular School No Elementary PK 05 2020   pk_12_total 325 77 84     10         49                             545 325 77 84     10         49                       545
1237485 1237485 MD     school 2400060 2   Anne Arundel 240006000117 1232 Quarterfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 165 120 78   * 54     *   48                             468 165 120 78     54         48                       468
1237492 1237492 MD     school 2400060 2   Anne Arundel 240006000118 1242 Richard Henry Lee Elementary   Regular School No Elementary KG 05 2020   pk_12_total 212 104 127   * 20         40                             506 212 104 127     20         40                       506
1237500 1237500 MD     school 2400060 2   Anne Arundel 240006000142 1262 Woodside Elementary   Regular School No Elementary PK 05 2020   pk_12_total 128 63 153   * 10     *   12                             368 128 63 153     10         12                       368
1237519 1237519 MD     school 2400060 2   Anne Arundel 240006090441 1323 North County High   Regular School No High 09 12 2020   pk_12_total 1017 593 414   * 119     *   133                             2286 1017 593 414     119         133                       2286
1237524 1237524 MD     school 2400060 2   Anne Arundel 240006000127 2013 Severna Park High   Regular School No High 09 12 2020   pk_12_total 1589 77 97   * 81     *   84                             1932 1589 77 97     81         84                       1932
1237529 1237529 MD     school 2400060 2   Anne Arundel 240006000103 2023 Northeast High   Regular School No High 09 12 2020   pk_12_total 996 123 133   * 34     *   72                             1367 996 123 133     34         72                       1367
1237533 1237533 MD     school 2400060 2   Anne Arundel 240006000072 2033 George Fox Middle   Regular School No Middle 06 08 2020   pk_12_total 626 91 85   * 18     *   55                             884 626 91 85     18         55                       884
1237537 1237537 MD     school 2400060 2   Anne Arundel 240006000126 2043 Severna Park Middle   Regular School No Middle 06 08 2020   pk_12_total 1162 52 87   * 66     *   77                             1453 1162 52 87     66         77                       1453
1237544 1237544 MD     school 2400060 2   Anne Arundel 240006000038 2052 Arnold Elementary   Regular School No Elementary KG 05 2020   pk_12_total 427 33 30   * 21     *   29                             543 427 33 30     21         29                       543
1237552 1237552 MD     school 2400060 2   Anne Arundel 240006000044 2062 Belvedere Elementary   Regular School No Elementary PK 05 2020   pk_12_total 381 30 56   * 21     *   42                             532 381 30 56     21         42                       532

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