enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1244572 1244572 MD     school   16   Prince George's   2217 Incarcerated Youth Center (JACS)             2020   pk_12_total   * *                                             10                                             10
1317149 1317149 MD     school   16   Prince George's   2217 Incarcerated Youth Center (JACS)             2021   pk_12_total   * *               *                             11                                             11
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
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
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
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
1237567 1237567 MD     school 2400060 2   Anne Arundel 240006000046 2082 Bodkin Elementary   Regular School No Elementary KG 05 2020   pk_12_total 485 10 35     *         25                             557 485 10 35               25                       557
1237574 1237574 MD     school 2400060 2   Anne Arundel 240006000051 2092 Cape St. Claire Elementary   Regular School No Elementary KG 05 2020   pk_12_total 473 17 70   * 14     *   48                             625 473 17 70     14         48                       625
1237581 1237581 MD     school 2400060 2   Anne Arundel 240006000067 2102 Folger Mckinsey Elementary   Regular School No Elementary KG 05 2020   pk_12_total 525 16 29   * 19         22                             612 525 16 29     19         22                       612
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
1237612 1237612 MD     school 2400060 2   Anne Arundel 240006000084 2152 Jones Elementary   Regular School No Elementary KG 05 2020   pk_12_total 242 11 19     21         17                             310 242 11 19     21         17                       310
1237619 1237619 MD     school 2400060 2   Anne Arundel 240006000085 2162 Lake Shore Elementary   Regular School No Elementary KG 05 2020   pk_12_total 288 * 18     *         19                             327 288   18               19                       327
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
1237634 1237634 MD     school 2400060 2   Anne Arundel 240006000113 2182 Pasadena Elementary   Regular School No Elementary KG 05 2020   pk_12_total 297 17 26     *         19                             364 297 17 26               19                       364
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
1237649 1237649 MD     school 2400060 2   Anne Arundel 240006000125 2202 Severna Park Elementary   Regular School No Elementary KG 05 2020   pk_12_total 381 * 15   * 22         16                             442 381   15     22         16                       442
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
1237686 1237686 MD     school 2400060 2   Anne Arundel 240006000047 2322 Broadneck Elementary   Regular School No Elementary KG 05 2020   pk_12_total 586 41 71   * 25     *   49                             774 586 41 71     25         49                       774
1237698 1237698 MD     school 2400060 2   Anne Arundel 240006001516 2372 Windsor Farm Elementary   Regular School No Elementary KG 05 2020   pk_12_total 388 41 87   * *         37                             564 388 41 87               37                       564
1237713 1237713 MD     school 2400060 2   Anne Arundel 240006001421 2432 Shipley's Choice Elementary   Regular School No Elementary KG 05 2020   pk_12_total 350 * *     12         17                             394 350         12         17                       394
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
1237749 1237749 MD     school 2400060 2   Anne Arundel 240006000061 3082 Crofton Woods Elementary   Regular School No Elementary KG 05 2020   pk_12_total 525 48 69   * 54     *   63                             763 525 48 69     54         63                       763
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
1237779 1237779 MD     school 2400060 2   Anne Arundel 240006000092 3122 Manor View Elementary   Regular School No Elementary 01 05 2020   pk_12_total 114 69 65     *     *   42                             301 114 69 65               42                       301
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
1237810 1237810 MD     school 2400060 2   Anne Arundel 240006000100 3162 Millersville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 249 23 30     *     *   33                             344 249 23 30               33                       344
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
1237825 1237825 MD     school 2400060 2   Anne Arundel 240006000114 3182 Pershing Hill Elementary   Regular School No Elementary KG 05 2020   pk_12_total 255 117 113   * 12     *   67                             568 255 117 113     12         67                       568
1237832 1237832 MD     school 2400060 2   Anne Arundel 240006000119 3192 Ridgeway Elementary   Regular School No Elementary KG 05 2020   pk_12_total 333 145 99     25     *   80                             686 333 145 99     25         80                       686
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
1237847 1237847 MD     school 2400060 2   Anne Arundel 240006000130 3212 South Shore Elementary   Regular School No Elementary KG 05 2020   pk_12_total 230 * 57   * *         36                             340 230   57               36                       340
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
1237865 1237865 MD     school 2400060 2   Anne Arundel 240006002944 3242 Piney Orchard Elementary   Regular School No Elementary KG 05 2020   pk_12_total 341 127 63   * 39         71                             643 341 127 63     39         71                       643
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
1237884 1237884 MD     school 2400060 2   Anne Arundel 240006001658 3282 Nantucket Elementary   Regular School No Elementary KG 05 2020   pk_12_total 361 219 57   * 95     *   44                             779 361 219 57     95         44                       779
1237909 1237909 MD     school 2400060 2   Anne Arundel 240006001517 3362 Crofton Meadows Elementary   Regular School No Elementary KG 05 2020   pk_12_total 321 93 56     29         55                             554 321 93 56     29         55                       554
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
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
1238009 1238009 MD     school 2400060 2   Anne Arundel 240006000053 4112 Central Elementary   Regular School No Elementary KG 05 2020   pk_12_total 488 17 55   * 18         22                             601 488 17 55     18         22                       601
1238016 1238016 MD     school 2400060 2   Anne Arundel 240006000062 4122 Davidsonville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 559 18 41   * 20     *   37                             678 559 18 41     20         37                       678
1238023 1238023 MD     school 2400060 2   Anne Arundel 240006000063 4132 Deale Elementary   Regular School No Elementary KG 05 2020   pk_12_total 189 * 17               *                             219 189   17                                       219
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
1238038 1238038 MD     school 2400060 2   Anne Arundel 240006000065 4152 Edgewater Elementary   Regular School No Elementary KG 05 2020   pk_12_total 390 * 135   * 14     *   23                             573 390   135     14         23                       573
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
1238077 1238077 MD     school 2400060 2   Anne Arundel 240006000097 4212 Mayo Elementary   Regular School No Elementary KG 05 2020   pk_12_total 279 11 34     *     *   19                             347 279 11 34               19                       347
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
1238108 1238108 MD     school 2400060 2   Anne Arundel 240006000135 4252 Traceys Elementary   Regular School No Elementary KG 05 2020   pk_12_total 258 26 127               21                             432 258 26 127               21                       432
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
1238123 1238123 MD     school 2400060 2   Anne Arundel 240006000139 4272 West Annapolis Elementary   Regular School No Elementary KG 05 2020   pk_12_total 162 24 40   * *         20                             251 162 24 40               20                       251
1238157 1238157 MD     school 2400060 2   Anne Arundel 240006001724 6113 Monarch Global Academy PCS Laurel Campus   Regular School No Elementary KG 08 2020   pk_12_total 104 447 187   * 43     *   42                             827 104 447 187     43         42                       827
1238164 1238164 MD     school 2400060 2   Anne Arundel 240006001744 6123 Monarch Academy Annapolis ES   Regular School No Elementary KG 05 2020   pk_12_total 111 352 182   * 11         34                             691 111 352 182     11         34                       691
1238182 1238182 MD     school 2400060 2   Anne Arundel 240006001687 6233 Monarch Academy   Regular School Yes Elementary KG 08 2020   pk_12_total 291 244 62   * 24         57                             679 291 244 62     24         57                       679
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

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