enrollments

Data source: Big Local News · About: Big Local

1,393 rows where grade = "pk_12_total", state = "MD" and year = 2021

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 1,293 ✖

grade ✖

  • pk_12_total · 1,293 ✖
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
1310442 1310442 MD     school 2400060 2   Anne Arundel 240006000069 3272 Four Seasons Elementary   Regular School No Elementary PK 05 2021   pk_12_total 338 139 57   * 49     *   79                             665 338 139 57     49         79                       665
1310449 1310449 MD     school 2400060 2   Anne Arundel 240006001658 3282 Nantucket Elementary   Regular School No Elementary KG 05 2021   pk_12_total 317 192 64   * 89     *   38                             705 317 192 64     89         38                       705
1310454 1310454 MD     school 2400060 2   Anne Arundel 240006000099 3323 Meade High   Regular School No High 09 12 2021   pk_12_total 245 1030 549   * 113     10   136                             2087 245 1030 549     113     10   136                       2087
1310458 1310458 MD     school 2400060 2   Anne Arundel 240006000107 3333 Old Mill Middle North   Regular School No Middle 06 08 2021   pk_12_total 312 479 145   * 42     *   59                             1042 312 479 145     42         59                       1042
1310462 1310462 MD     school 2400060 2   Anne Arundel 240006000108 3343 Old Mill Middle South   Regular School No Middle 06 08 2021   pk_12_total 495 237 169   * 33     *   80                             1018 495 237 169     33         80                       1018
1310467 1310467 MD     school 2400060 2   Anne Arundel 240006000109 3353 Old Mill High   Regular School No High 09 12 2021   pk_12_total 906 829 344   * 117     10   153                             2364 906 829 344     117     10   153                       2364
1310474 1310474 MD     school 2400060 2   Anne Arundel 240006001517 3362 Crofton Meadows Elementary   Regular School No Elementary KG 05 2021   pk_12_total 284 101 49     32         61                             527 284 101 49     32         61                       527
1310482 1310482 MD     school 2400060 2   Anne Arundel 240006000076 3372 Glen Burnie Park Elementary   Regular School No Elementary PK 05 2021   pk_12_total 134 199 124   * 34     *   20                             518 134 199 124     34         20                       518
1310490 1310490 MD     school 2400060 2   Anne Arundel 240006000133 3382 Southgate Elementary   Regular School No Elementary PK 05 2021   pk_12_total 247 301 105   * 25     *   53                             734 247 301 105     25         53                       734
1310498 1310498 MD     school 2400060 2   Anne Arundel 240006000120 3392 Rippling Woods Elementary   Regular School No Elementary PK 05 2021   pk_12_total 180 240 98     19         40                             577 180 240 98     19         40                       577
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
1310517 1310517 MD     school 2400060 2   Anne Arundel 240006000823 3423 Meade Middle   Regular School No Middle 06 08 2021   pk_12_total 67 369 317   * 24     *   44                             826 67 369 317     24         44                       826
1310522 1310522 MD     school 2400060 2   Anne Arundel 240006000037 4013 Annapolis High   Regular School No High 09 12 2021   pk_12_total 638 547 835   * 51     *   60                             2134 638 547 835     51         60                       2134
1310527 1310527 MD     school 2400060 2   Anne Arundel 240006000132 4023 Southern High   Regular School No High 09 12 2021   pk_12_total 719 73 176     10     *   53                             1032 719 73 176     10         53                       1032
1310531 1310531 MD     school 2400060 2   Anne Arundel 240006000036 4033 Annapolis Middle   Regular School No Middle 06 08 2021   pk_12_total 157 309 549   * 19     *   25                             1061 157 309 549     19         25                       1061
1310535 1310535 MD     school 2400060 2   Anne Arundel 240006000041 4043 Wiley H. Bates Middle   Regular School No Middle 06 08 2021   pk_12_total 265 158 215   * 15         28                             682 265 158 215     15         28                       682
1310539 1310539 MD     school 2400060 2   Anne Arundel 240006000131 4053 Southern Middle   Regular School No Middle 06 08 2021   pk_12_total 516 61 152   * *         58                             790 516 61 152               58                       790
1310543 1310543 MD     school 2400060 2   Anne Arundel 240006001729 4064 Mary Moss at Adams Academy   Alternative School No Middle 07 09 2021   pk_12_total 10 19 *               *                             42 10 19                                         42
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
1310564 1310564 MD     school 2400060 2   Anne Arundel 240006000035 4092 Annapolis Elementary   Regular School No Elementary PK 05 2021   pk_12_total 26 120 38     *         *                             194 26 120 38                                       194
1310566 1310566 MD     school 2400060 2   Anne Arundel 240006001746 4102 Carrie Weedon Early Education Center   Regular School No Prekindergarten PK PK 2021   pk_12_total 33 * 21               *                             62 33   21                                       62
1310573 1310573 MD     school 2400060 2   Anne Arundel 240006000053 4112 Central Elementary   Regular School No Elementary KG 05 2021   pk_12_total 448 18 62   * 18         18                             565 448 18 62     18         18                       565
1310580 1310580 MD     school 2400060 2   Anne Arundel 240006000062 4122 Davidsonville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 491 24 51   * 17     *   38                             624 491 24 51     17         38                       624
1310587 1310587 MD     school 2400060 2   Anne Arundel 240006000063 4132 Deale Elementary   Regular School No Elementary KG 05 2021   pk_12_total 172 * 18     *         *                             209 172   18                                       209
1310595 1310595 MD     school 2400060 2   Anne Arundel 240006000064 4142 Eastport Elementary   Regular School No Elementary PK 05 2021   pk_12_total 39 86 147   * *         *                             283 39 86 147                                       283
1310602 1310602 MD     school 2400060 2   Anne Arundel 240006000065 4152 Edgewater Elementary   Regular School No Elementary KG 05 2021   pk_12_total 374 12 138   * 10     *   27                             563 374 12 138     10         27                       563
1310610 1310610 MD     school 2400060 2   Anne Arundel 240006000073 4162 Georgetown East Elementary   Regular School No Elementary PK 05 2021   pk_12_total 11 142 138     *     *   *                             308 11 142 138                                       308
1310618 1310618 MD     school 2400060 2   Anne Arundel 240006000074 4182 Germantown Elementary   Regular School No Elementary PK 05 2021   pk_12_total 96 107 271   * *         *                             485 96 107 271                                       485
1310626 1310626 MD     school 2400060 2   Anne Arundel 240006000080 4192 Hillsmere Elementary   Regular School No Elementary PK 05 2021   pk_12_total 249 73 55     *         15                             398 249 73 55               15                       398
1310634 1310634 MD     school 2400060 2   Anne Arundel 240006000089 4202 Lothian Elementary   Regular School No Elementary PK 05 2021   pk_12_total 229 41 167   * *         27                             472 229 41 167               27                       472
1310641 1310641 MD     school 2400060 2   Anne Arundel 240006000097 4212 Mayo Elementary   Regular School No Elementary KG 05 2021   pk_12_total 286 * 39     *         18                             353 286   39               18                       353
1310649 1310649 MD     school 2400060 2   Anne Arundel 240006000112 4222 Walter S. Mills - Parole Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 201 329     *         *                             555   201 329                                       555
1310657 1310657 MD     school 2400060 2   Anne Arundel 240006000122 4232 Rolling Knolls Elementary   Regular School No Elementary PK 05 2021   pk_12_total 169 43 116   * 23         22                             374 169 43 116     23         22                       374
1310665 1310665 MD     school 2400060 2   Anne Arundel 240006000128 4242 Shady Side Elementary   Regular School No Elementary PK 05 2021   pk_12_total 352 33 20     *         21                             430 352 33 20               21                       430
1310672 1310672 MD     school 2400060 2   Anne Arundel 240006000135 4252 Traceys Elementary   Regular School No Elementary KG 05 2021   pk_12_total 216 23 144     *         14                             398 216 23 144               14                       398
1310680 1310680 MD     school 2400060 2   Anne Arundel 240006000136 4262 Tyler Heights Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 17 445     *         *                             467   17 445                                       467
1310687 1310687 MD     school 2400060 2   Anne Arundel 240006000139 4272 West Annapolis Elementary   Regular School No Elementary KG 05 2021   pk_12_total 132 19 39     *         23                             215 132 19 39               23                       215
1310691 1310691 MD     school 2400060 2   Anne Arundel 240006000054 4283 Central Middle   Regular School No Middle 06 08 2021   pk_12_total 988 61 173   * 48     *   69                             1345 988 61 173     48         69                       1345
1310696 1310696 MD     school 2400060 2   Anne Arundel 240006000055 4293 South River High   Regular School No High 09 12 2021   pk_12_total 1415 100 228   * 86     *   83                             1916 1415 100 228     86         83                       1916
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
1310721 1310721 MD     school 2400060 2   Anne Arundel 240006001724 6113 Monarch Global Academy PCS Laurel Campus   Regular School No Elementary KG 08 2021   pk_12_total 96 454 193   * 43     *   38                             828 96 454 193     43         38                       828
1310728 1310728 MD     school 2400060 2   Anne Arundel 240006001744 6123 Monarch Academy Annapolis ES   Regular School No Elementary KG 05 2021   pk_12_total 144 403 157   * 12         41                             759 144 403 157     12         41                       759
1310736 1310736 MD     school 2400060 2   Anne Arundel 240006001401 6223 Chesapeake Science Point   Regular School Yes High 06 12 2021   pk_12_total 138 203 42   * 79     *   36                             500 138 203 42     79         36                       500
1310746 1310746 MD     school 2400060 2   Anne Arundel 240006001687 6233 Monarch Academy   Regular School Yes Elementary KG 08 2021   pk_12_total 273 246 68   * 25     *   65                             681 273 246 68     25         65                       681
1310749 1310749 MD     school 2400120 3   Baltimore County 240012001756 51 Northwest EDLP at Milford Mill Academy   Alternative School No High 10 12 2021   pk_12_total   *                                               *                                              
1310752 1310752 MD     school 2400120 3   Baltimore County 240012001751 52 Southwest EDLP at Woodlawn High School   Alternative School No High 11 12 2021   pk_12_total * * *                                             *                                              
1310755 1310755 MD     school 2400120 3   Baltimore County 240012001754 53 Northeast EDLP at Parkville High School   Alternative School No High 11 12 2021   pk_12_total * * *                                             15                                             15
1310758 1310758 MD     school 2400120 3   Baltimore County 240012001759 55 Southeast EDLP at Dundalk High School   Alternative School No High 10 12 2021   pk_12_total * * *                                             *                                              
1310760 1310760 MD     school 2400120 3   Baltimore County 240012001760 56 Central EDLP at Loch Raven High School   Alternative School No High 12 12 2021   pk_12_total *                                                 *                                              
1310765 1310765 MD     school 2400120 3   Baltimore County 240012000935 58 Home Assignments-Secondary   Alternative School No High 08 12 2021   pk_12_total * *                                               12                                             12
1310768 1310768 MD     school 2400120 3   Baltimore County 240012000012 62 Campfield Early Childhood Center   Regular School No Elementary PK KG 2021   pk_12_total 24 235 36   * 22         15                             333 24 235 36     22         15                       333
1310773 1310773 MD     school 2400120 3   Baltimore County 240012000436 69 Catonsville Center for Alternative Studies   Alternative School No High 09 12 2021   pk_12_total * 41 *     *         *                             51   41                                         51
1310776 1310776 MD     school 2400120 3   Baltimore County 240012000777 70 Meadowood Education Center   Alternative School No Middle 07 08 2021   pk_12_total * 12 *               *                             15   12                                         15
1310783 1310783 MD     school 2400120 3   Baltimore County 240012000831 72 Rosedale Center   Alternative School No High 07 12 2021   pk_12_total * 17                 *                             25   17                                         25
1310790 1310790 MD     school 2400120 3   Baltimore County 240012001649 75 Crossroads Center   Alternative School No High 07 12 2021   pk_12_total 63 84 *   * *         12                             169 63 84                 12                       169
1310795 1310795 MD     school 2400120 3   Baltimore County 240012001711 77 BCDC Educational Center   Alternative School No High 09 12 2021   pk_12_total * 19 *                                             31   19                                         31
1310803 1310803 MD     school 2400120 3   Baltimore County 240012000353 101 Catonsville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 301 94 50     140     *   52                             638 301 94 50     140         52                       638
1310811 1310811 MD     school 2400120 3   Baltimore County 240012000936 102 Westchester Elementary   Regular School No Elementary PK 05 2021   pk_12_total 415 71 55   * 93         31                             668 415 71 55     93         31                       668
1310819 1310819 MD     school 2400120 3   Baltimore County 240012000495 103 Westowne Elementary   Regular School No Elementary PK 05 2021   pk_12_total 226 241 50   * 87     *   50                             659 226 241 50     87         50                       659
1310827 1310827 MD     school 2400120 3   Baltimore County 240012000382 104 Edmondson Heights Elementary   Regular School No Elementary PK 05 2021   pk_12_total 40 336 71   * 28     *   16                             499 40 336 71     28         16                       499
1310835 1310835 MD     school 2400120 3   Baltimore County 240012000410 105 Johnnycake Elementary   Regular School No Elementary PK 05 2021   pk_12_total 39 270 140   * 53     *   22                             531 39 270 140     53         22                       531
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
1310858 1310858 MD     school 2400120 3   Baltimore County 240012002945 112 Dogwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 15 467 27   13 37     *   18                             578 15 467 27   13 37         18                       578
1310866 1310866 MD     school 2400120 3   Baltimore County 240012000357 113 Chadwick Elementary   Regular School No Elementary PK 05 2021   pk_12_total 35 283 75   * 240         10                             647 35 283 75     240         10                       647
1310874 1310874 MD     school 2400120 3   Baltimore County 240012000406 115 Hillcrest Elementary   Regular School No Elementary PK 05 2021   pk_12_total 387 74 80   * 123     *   26                             692 387 74 80     123         26                       692
1310882 1310882 MD     school 2400120 3   Baltimore County 240012000499 116 Woodbridge Elementary   Regular School No Elementary PK 05 2021   pk_12_total 35 128 72   * 184     *   *                             430 35 128 72     184                                 430
1310886 1310886 MD     school 2400120 3   Baltimore County 240012000354 151 Catonsville Middle   Regular School No Middle 06 08 2021   pk_12_total 455 171 68   * 85     *   36                             821 455 171 68     85         36                       821
1310890 1310890 MD     school 2400120 3   Baltimore County 240012000411 155 Southwest Academy   Regular School No Middle 06 08 2021   pk_12_total 31 513 109   * 111     *   28                             794 31 513 109     111         28                       794
1310895 1310895 MD     school 2400120 3   Baltimore County 240012000502 172 Woodlawn High   Regular School No High 09 12 2021   pk_12_total 48 1265 247   * 86     *   22                             1680 48 1265 247     86         22                       1680
1310900 1310900 MD     school 2400120 3   Baltimore County 240012000355 174 Catonsville High   Regular School No High 09 12 2021   pk_12_total 929 443 100   * 233     *   94                             1809 929 443 100     233         94                       1809
1310905 1310905 MD     school 2400120 3   Baltimore County 240012000248 175 Western School of Technology   Career and Technical School No High 09 12 2021   pk_12_total 136 514 48   * 190     *   28                             920 136 514 48     190         28                       920
1310912 1310912 MD     school 2400120 3   Baltimore County 240012000457 202 Randallstown Elementary   Regular School No Elementary KG 05 2021   pk_12_total * 334 28     *     *   12                             384   334 28               12                       384
1310920 1310920 MD     school 2400120 3   Baltimore County 240012000385 204 Featherbed Lane Elementary   Regular School No Elementary PK 05 2021   pk_12_total 11 359 71   * *     *   21                             473 11 359 71               21                       473
1310928 1310928 MD     school 2400120 3   Baltimore County 240012000503 205 Woodmoor Elementary   Regular School No Elementary PK 05 2021   pk_12_total 14 498 41   * *     *   *                             565 14 498 41                                       565
1310935 1310935 MD     school 2400120 3   Baltimore County 240012000471 206 Scotts Branch Elementary   Regular School No Elementary KG 05 2021   pk_12_total * 458 39     *     *   *                             520   458 39                                       520
1310943 1310943 MD     school 2400120 3   Baltimore County 240012000364 207 Church Lane Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 292 20   * *         11                             331   292 20               11                       331
1310951 1310951 MD     school 2400120 3   Baltimore County 240012000402 209 Hebbville Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 377 70   * 13         11                             479   377 70     13         11                       479
1310959 1310959 MD     school 2400120 3   Baltimore County 240012000455 210 Powhatan Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 180 20   *       *   10                             216   180 20               10                       216
1310967 1310967 MD     school 2400120 3   Baltimore County 240012000498 211 Winfield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 13 381 26   * *     *   14                             447 13 381 26               14                       447
1310975 1310975 MD     school 2400120 3   Baltimore County 240012000497 213 Winand Elementary   Regular School No Elementary PK 05 2021   pk_12_total 13 409 14   * *     *   10                             455 13 409 14               10                       455
1310983 1310983 MD     school 2400120 3   Baltimore County 240012000405 214 Hernwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 307 14   * *         10                             339   307 14               10                       339
1310991 1310991 MD     school 2400120 3   Baltimore County 240012000371 216 Deer Park Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 368 *     *         10                             396   368                 10                       396
1310999 1310999 MD     school 2400120 3   Baltimore County 240012001159 217 New Town Elementary   Regular School No Elementary PK 05 2021   pk_12_total 40 667 35   * 34     *   34                             818 40 667 35     34         34                       818
1311005 1311005 MD     school 2400120 3   Baltimore County 240012001753 219 Watershed Public Charter   Regular School Yes Elementary KG 04 2021   pk_12_total 53 128 15   * *         31                             231 53 128 15               31                       231
1311009 1311009 MD     school 2400120 3   Baltimore County 240012001431 252 Northwest Academy of Health Sciences   Regular School No Middle 06 08 2021   pk_12_total 17 695 46   * *     *   12                             784 17 695 46               12                       784
1311013 1311013 MD     school 2400120 3   Baltimore County 240012000501 253 Woodlawn Middle   Regular School No Middle 06 08 2021   pk_12_total 11 577 49   * *     *   13                             657 11 577 49               13                       657
1311017 1311017 MD     school 2400120 3   Baltimore County 240012000372 254 Deer Park Middle Magnet School   Regular School No Middle 06 08 2021   pk_12_total 33 1297 88   * 34         38                             1495 33 1297 88     34         38                       1495
1311021 1311021 MD     school 2400120 3   Baltimore County 240012001574 256 Windsor Mill Middle   Regular School No Middle 06 08 2021   pk_12_total * 635 29   * *     *   13                             691   635 29               13                       691
1311026 1311026 MD     school 2400120 3   Baltimore County 240012000432 271 Milford Mill Academy   Regular School No High 09 12 2021   pk_12_total 22 1155 84   * 15         33                             1312 22 1155 84     15         33                       1312
1311031 1311031 MD     school 2400120 3   Baltimore County 240012000458 272 Randallstown High   Regular School No High 09 12 2021   pk_12_total 16 1001 44     22         14                             1097 16 1001 44     22         14                       1097
1311037 1311037 MD     school 2400120 3   Baltimore County 240012000348 303 Bedford Elementary   Regular School No Elementary 01 05 2021   pk_12_total * 234 49   * *     *   18                             319   234 49               18                       319
1311044 1311044 MD     school 2400120 3   Baltimore County 240012000492 304 Wellwood International School   Regular School No Elementary KG 05 2021   pk_12_total 81 308 42   * 46         16                             496 81 308 42     46         16                       496
1311050 1311050 MD     school 2400120 3   Baltimore County 240012000431 307 Milbrook Elementary   Regular School No Elementary 01 05 2021   pk_12_total 26 212 72   * 18         13                             344 26 212 72     18         13                       344
1311058 1311058 MD     school 2400120 3   Baltimore County 240012000387 308 Fort Garrison Elementary   Regular School No Elementary PK 05 2021   pk_12_total 203 59 *   * *         *                             283 203 59                                         283
1311065 1311065 MD     school 2400120 3   Baltimore County 240012000481 310 Summit Park Elementary   Regular School No Elementary KG 05 2021   pk_12_total 278 44 14   * 28         14                             379 278 44 14     28         14                       379
1311072 1311072 MD     school 2400120 3   Baltimore County 240012001405 311 Woodholme Elementary   Regular School No Elementary KG 05 2021   pk_12_total 46 440 137   * 27     *   25                             679 46 440 137     27         25                       679
1311076 1311076 MD     school 2400120 3   Baltimore County 240012000448 352 Pikesville Middle   Regular School No Middle 06 08 2021   pk_12_total 157 624 103   * 43     *   32                             967 157 624 103     43         32                       967
1311080 1311080 MD     school 2400120 3   Baltimore County 240012000441 353 Sudbrook Magnet Middle   Regular School No Middle 06 08 2021   pk_12_total 105 574 213   * 54     *   22                             972 105 574 213     54         22                       972
1311085 1311085 MD     school 2400120 3   Baltimore County 240012000449 371 Pikesville High   Regular School No High 09 12 2021   pk_12_total 312 431 82   * 48     *   29                             905 312 431 82     48         29                       905
1311093 1311093 MD     school 2400120 3   Baltimore County 240012000439 402 Owings Mills Elementary   Regular School No Elementary PK 05 2021   pk_12_total 28 436 232   * 14         34                             746 28 436 232     14         34                       746

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