enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
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
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
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
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
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
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
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
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
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
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
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
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
1237560 1237560 MD     school 2400060 2   Anne Arundel 240006000045 2072 Benfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 350 * 21   * *         28                             410 350   21               28                       410
1237589 1237589 MD     school 2400060 2   Anne Arundel 240006000068 2112 Fort Smallwood Elementary   Regular School No Elementary PK 05 2020   pk_12_total 416 18 15     *         14                             468 416 18 15               14                       468
1237597 1237597 MD     school 2400060 2   Anne Arundel 240006000079 2132 High Point Elementary   Regular School No Elementary PK 05 2020   pk_12_total 463 46 100   * 14         53                             680 463 46 100     14         53                       680
1237605 1237605 MD     school 2400060 2   Anne Arundel 240006000082 2142 Jacobsville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 447 39 48   * 10         33                             578 447 39 48     10         33                       578
1237627 1237627 MD     school 2400060 2   Anne Arundel 240006000104 2172 Oak Hill Elementary   Regular School No Elementary PK 05 2020   pk_12_total 575 27 26   * 43     *   43                             716 575 27 26     43         43                       716
1237642 1237642 MD     school 2400060 2   Anne Arundel 240006000121 2192 Riviera Beach Elementary   Regular School No Elementary PK 05 2020   pk_12_total 252 12 16   * *         22                             312 252 12 16               22                       312
1237657 1237657 MD     school 2400060 2   Anne Arundel 240006000129 2212 Solley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 498 100 94   * 32     *   70                             798 498 100 94     32         70                       798
1237665 1237665 MD     school 2400060 2   Anne Arundel 240006000134 2222 Sunset Elementary   Regular School No Elementary PK 05 2020   pk_12_total 342 30 29   * 10     *   33                             446 342 30 29     10         33                       446
1237734 1237734 MD     school 2400060 2   Anne Arundel 240006000048 3062 Brock Bridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 44 245 251   * 40     *   16                             600 44 245 251     40         16                       600
1237742 1237742 MD     school 2400060 2   Anne Arundel 240006000060 3072 Crofton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 502 157 81   * 36         49                             828 502 157 81     36         49                       828
1237757 1237757 MD     school 2400060 2   Anne Arundel 240006001645 3092 Seven Oaks Elementary   Regular School No Elementary PK 05 2020   pk_12_total 61 357 59     15     *   46                             539 61 357 59     15         46                       539
1237765 1237765 MD     school 2400060 2   Anne Arundel 240006000078 3102 Hebron - Harman Elementary   Regular School No Elementary PK 05 2020   pk_12_total 117 323 161   * 78         76                             759 117 323 161     78         76                       759
1237773 1237773 MD     school 2400060 2   Anne Arundel 240006000083 3112 Jessup Elementary   Regular School No Elementary PK 05 2020   pk_12_total 186 169 142   * 35         63                             596 186 169 142     35         63                       596
1237787 1237787 MD     school 2400060 2   Anne Arundel 240006000096 3132 Maryland City Elementary   Regular School No Elementary PK 05 2020   pk_12_total 17 150 196   * *         11                             384 17 150 196               11                       384
1237795 1237795 MD     school 2400060 2   Anne Arundel 240006000098 3142 Meade Heights Elementary   Regular School No Elementary PK 05 2020   pk_12_total 71 258 62   * *         30                             429 71 258 62               30                       429
1237803 1237803 MD     school 2400060 2   Anne Arundel 240006000137 3152 Van Bokkelen Elementary   Regular School No Elementary PK 05 2020   pk_12_total 17 304 118   * *     *   20                             465 17 304 118               20                       465
1237818 1237818 MD     school 2400060 2   Anne Arundel 240006000106 3172 Odenton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 186 146 96     27     *   71                             527 186 146 96     27         71                       527
1237840 1237840 MD     school 2400060 2   Anne Arundel 240006000123 3202 Severn Elementary   Regular School No Elementary PK 05 2020   pk_12_total 125 285 65   * 30     *   43                             553 125 285 65     30         43                       553
1237855 1237855 MD     school 2400060 2   Anne Arundel 240006000138 3222 Waugh Chapel Elementary   Regular School No Elementary PK 05 2020   pk_12_total 326 128 80   * 48     *   49                             633 326 128 80     48         49                       633
1237858 1237858 MD     school 2400060 2   Anne Arundel 240006000140 3232 West Meade Early Education Center   Regular School No Elementary PK KG 2020   pk_12_total 123 33 64   * 14         21                             256 123 33 64     14         21                       256
1237877 1237877 MD     school 2400060 2   Anne Arundel 240006000069 3272 Four Seasons Elementary   Regular School No Elementary PK 05 2020   pk_12_total 364 134 63   * 49     *   71                             684 364 134 63     49         71                       684
1237917 1237917 MD     school 2400060 2   Anne Arundel 240006000076 3372 Glen Burnie Park Elementary   Regular School No Elementary PK 05 2020   pk_12_total 145 212 134   * 25     *   24                             543 145 212 134     25         24                       543
1237925 1237925 MD     school 2400060 2   Anne Arundel 240006000133 3382 Southgate Elementary   Regular School No Elementary PK 05 2020   pk_12_total 275 316 116   * 21     *   54                             784 275 316 116     21         54                       784
1237933 1237933 MD     school 2400060 2   Anne Arundel 240006000120 3392 Rippling Woods Elementary   Regular School No Elementary PK 05 2020   pk_12_total 211 234 115     16         35                             611 211 234 115     16         35                       611
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
1238000 1238000 MD     school 2400060 2   Anne Arundel 240006000035 4092 Annapolis Elementary   Regular School No Elementary PK 05 2020   pk_12_total 37 133 41     *         *                             214 37 133 41                                       214
1238002 1238002 MD     school 2400060 2   Anne Arundel 240006001746 4102 Carrie Weedon Early Education Center   Regular School No Prekindergarten PK PK 2020   pk_12_total 36 * 17     *                                       61 36   17                                       61
1238031 1238031 MD     school 2400060 2   Anne Arundel 240006000064 4142 Eastport Elementary   Regular School No Elementary PK 05 2020   pk_12_total 38 104 144   * *         10                             300 38 104 144               10                       300
1238046 1238046 MD     school 2400060 2   Anne Arundel 240006000073 4162 Georgetown East Elementary   Regular School No Elementary PK 05 2020   pk_12_total 11 160 130     *     *   *                             315 11 160 130                                       315
1238054 1238054 MD     school 2400060 2   Anne Arundel 240006000074 4182 Germantown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 93 119 287   * *         *                             512 93 119 287                                       512
1238062 1238062 MD     school 2400060 2   Anne Arundel 240006000080 4192 Hillsmere Elementary   Regular School No Elementary PK 05 2020   pk_12_total 272 72 59   * *         15                             424 272 72 59               15                       424
1238070 1238070 MD     school 2400060 2   Anne Arundel 240006000089 4202 Lothian Elementary   Regular School No Elementary PK 05 2020   pk_12_total 247 37 164   * *     *   40                             495 247 37 164               40                       495
1238085 1238085 MD     school 2400060 2   Anne Arundel 240006000112 4222 Walter S. Mills - Parole Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 233 355   * *         12                             615   233 355               12                       615
1238093 1238093 MD     school 2400060 2   Anne Arundel 240006000122 4232 Rolling Knolls Elementary   Regular School No Elementary PK 05 2020   pk_12_total 208 47 119   * 20         29                             424 208 47 119     20         29                       424
1238101 1238101 MD     school 2400060 2   Anne Arundel 240006000128 4242 Shady Side Elementary   Regular School No Elementary PK 05 2020   pk_12_total 384 38 19     *         20                             466 384 38 19               20                       466
1238116 1238116 MD     school 2400060 2   Anne Arundel 240006000136 4262 Tyler Heights Elementary   Regular School No Elementary PK 05 2020   pk_12_total   14 466     *         *                             488   14 466                                       488
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
1238213 1238213 MD     school 2400120 3   Baltimore County 240012000012 62 Campfield Early Childhood Center   Regular School No Elementary PK KG 2020   pk_12_total 27 273 64   * 25         19                             410 27 273 64     25         19                       410
1238249 1238249 MD     school 2400120 3   Baltimore County 240012000353 101 Catonsville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 329 114 51   * 118     *   53                             668 329 114 51     118         53                       668
1238257 1238257 MD     school 2400120 3   Baltimore County 240012000936 102 Westchester Elementary   Regular School No Elementary PK 05 2020   pk_12_total 457 68 59   * 102         30                             719 457 68 59     102         30                       719
1238265 1238265 MD     school 2400120 3   Baltimore County 240012000495 103 Westowne Elementary   Regular School No Elementary PK 05 2020   pk_12_total 250 256 45   * 93     *   45                             698 250 256 45     93         45                       698
1238273 1238273 MD     school 2400120 3   Baltimore County 240012000382 104 Edmondson Heights Elementary   Regular School No Elementary PK 05 2020   pk_12_total 37 375 61   * 19     *   25                             524 37 375 61     19         25                       524
1238281 1238281 MD     school 2400120 3   Baltimore County 240012000410 105 Johnnycake Elementary   Regular School No Elementary PK 05 2020   pk_12_total 52 368 163   * 77     *   23                             690 52 368 163     77         23                       690
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
1238304 1238304 MD     school 2400120 3   Baltimore County 240012002945 112 Dogwood Elementary   Regular School No Elementary PK 05 2020   pk_12_total 20 555 30   17 40     *   19                             682 20 555 30   17 40         19                       682
1238312 1238312 MD     school 2400120 3   Baltimore County 240012000357 113 Chadwick Elementary   Regular School No Elementary PK 05 2020   pk_12_total 32 279 78   * 234     *   *                             637 32 279 78     234                                 637
1238320 1238320 MD     school 2400120 3   Baltimore County 240012000406 115 Hillcrest Elementary   Regular School No Elementary PK 05 2020   pk_12_total 409 75 81   * 98     *   32                             698 409 75 81     98         32                       698
1238328 1238328 MD     school 2400120 3   Baltimore County 240012000499 116 Woodbridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 39 142 68   * 183     *   14                             448 39 142 68     183         14                       448
1238366 1238366 MD     school 2400120 3   Baltimore County 240012000385 204 Featherbed Lane Elementary   Regular School No Elementary PK 05 2020   pk_12_total 12 452 78   * *     *   19                             572 12 452 78               19                       572
1238374 1238374 MD     school 2400120 3   Baltimore County 240012000503 205 Woodmoor Elementary   Regular School No Elementary PK 05 2020   pk_12_total 12 536 46   * *     *   *                             614 12 536 46                                       614
1238389 1238389 MD     school 2400120 3   Baltimore County 240012000364 207 Church Lane Elementary Technology   Regular School No Elementary PK 05 2020   pk_12_total * 319 24   * *         10                             367   319 24               10                       367
1238397 1238397 MD     school 2400120 3   Baltimore County 240012000402 209 Hebbville Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 423 72   * *         17                             527   423 72               17                       527
1238405 1238405 MD     school 2400120 3   Baltimore County 240012000455 210 Powhatan Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 206 27   *           11                             251   206 27               11                       251
1238413 1238413 MD     school 2400120 3   Baltimore County 240012000498 211 Winfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 14 425 32   * *         15                             493 14 425 32               15                       493
1238421 1238421 MD     school 2400120 3   Baltimore County 240012000497 213 Winand Elementary   Regular School No Elementary PK 05 2020   pk_12_total 16 410 17   * *     *   10                             465 16 410 17               10                       465
1238429 1238429 MD     school 2400120 3   Baltimore County 240012000405 214 Hernwood Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 339 18   * *         15                             383   339 18               15                       383
1238437 1238437 MD     school 2400120 3   Baltimore County 240012000371 216 Deer Park Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 385 *     *         *                             404   385                                         404
1238445 1238445 MD     school 2400120 3   Baltimore County 240012001159 217 New Town Elementary   Regular School No Elementary PK 05 2020   pk_12_total 50 656 36   * 40     *   41                             830 50 656 36     40         41                       830
1238503 1238503 MD     school 2400120 3   Baltimore County 240012000387 308 Fort Garrison Elementary   Regular School No Elementary PK 05 2020   pk_12_total 232 62 *   * 11     *   *                             319 232 62       11                                 319
1238538 1238538 MD     school 2400120 3   Baltimore County 240012000439 402 Owings Mills Elementary   Regular School No Elementary PK 05 2020   pk_12_total 39 431 272   * 18         32                             793 39 431 272     18         32                       793
1238546 1238546 MD     school 2400120 3   Baltimore County 240012000388 403 Franklin Elementary   Regular School No Elementary PK 05 2020   pk_12_total 228 97 47     28         19                             419 228 97 47     28         19                       419
1238554 1238554 MD     school 2400120 3   Baltimore County 240012000361 404 Chatsworth School   Regular School No Elementary PK 05 2020   pk_12_total 119 178 23   * 22     *   22                             366 119 178 23     22         22                       366
1238562 1238562 MD     school 2400120 3   Baltimore County 240012000484 405 Timber Grove Elementary   Regular School No Elementary PK 05 2020   pk_12_total 68 309 117   * 31         33                             561 68 309 117     31         33                       561
1238570 1238570 MD     school 2400120 3   Baltimore County 240012000460 406 Reisterstown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 93 242 161   * 36         31                             564 93 242 161     36         31                       564
1238578 1238578 MD     school 2400120 3   Baltimore County 240012001346 407 Glyndon Elementary   Regular School No Elementary PK 05 2020   pk_12_total 90 313 81   * 28     *   42                             559 90 313 81     28         42                       559
1238586 1238586 MD     school 2400120 3   Baltimore County 240012000356 408 Cedarmere Elementary   Regular School No Elementary PK 05 2020   pk_12_total 98 209 165   * 45     *   19                             539 98 209 165     45         19                       539
1238634 1238634 MD     school 2400120 3   Baltimore County 240012000473 701 Seventh District Elementary   Regular School No Elementary PK 05 2020   pk_12_total 364 * 13   * *         13                             404 364   13               13                       404
1238668 1238668 MD     school 2400120 3   Baltimore County 240012000454 808 Pot Spring Elementary   Regular School No Elementary PK 05 2020   pk_12_total 170 127 105   * 54         20                             477 170 127 105     54         20                       477
1238683 1238683 MD     school 2400120 3   Baltimore County 240012090440 810 Padonia International Elementary   Regular School No Elementary PK 05 2020   pk_12_total 53 92 259   * 98         21                             524 53 92 259     98         21                       524
1238691 1238691 MD     school 2400120 3   Baltimore County 240012000452 811 Pinewood Elementary   Regular School No Elementary PK 05 2020   pk_12_total 373 33 30     133         27                             596 373 33 30     133         27                       596

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