enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pk_12_total · 2,791 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id ▲ school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
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
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
1238172 1238172 MD     school 2400060 2   Anne Arundel 240006001401 6223 Chesapeake Science Point   Regular School Yes High 06 12 2020   pk_12_total 132 178 45   * 72     *   34                             464 132 178 45     72         34                       464
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
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
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
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
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
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
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
1238132 1238132 MD     school 2400060 2   Anne Arundel 240006000055 4293 South River High   Regular School No High 09 12 2020   pk_12_total 1673 123 216   * 96     *   111                             2224 1673 123 216     96         111                       2224
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
1238127 1238127 MD     school 2400060 2   Anne Arundel 240006000054 4283 Central Middle   Regular School No Middle 06 08 2020   pk_12_total 962 57 162   * 43     *   55                             1284 962 57 162     43         55                       1284
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1237992 1237992 MD     school 2400060 2   Anne Arundel 240006001714 4074 Phoenix Academy   Special Education School No Other KG 12 2020   pk_12_total 131 164 27   *           22                             347 131 164 27               22                       347
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
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
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
1237974 1237974 MD     school 2400060 2   Anne Arundel 240006000131 4053 Southern Middle   Regular School No Middle 06 08 2020   pk_12_total 536 60 140   * *         61                             801 536 60 140               61                       801
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
1237970 1237970 MD     school 2400060 2   Anne Arundel 240006000041 4043 Wiley H. Bates Middle   Regular School No Middle 06 08 2020   pk_12_total 258 153 202     19         27                             659 258 153 202     19         27                       659
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
1237966 1237966 MD     school 2400060 2   Anne Arundel 240006000036 4033 Annapolis Middle   Regular School No Middle 06 08 2020   pk_12_total 208 297 498   * 13     *   26                             1044 208 297 498     13         26                       1044
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
1237962 1237962 MD     school 2400060 2   Anne Arundel 240006000132 4023 Southern High   Regular School No High 09 12 2020   pk_12_total 729 75 132   * *     *   51                             996 729 75 132               51                       996
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
1237957 1237957 MD     school 2400060 2   Anne Arundel 240006000037 4013 Annapolis High   Regular School No High 09 12 2020   pk_12_total 635 560 790   * 50     *   62                             2103 635 560 790     50         62                       2103
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
1240861 1240861 MD     school 2400360 11   Garrett 240036000674 3709 Southern Garrett High School   Regular School No High 09 12 2020   pk_12_total 670 * 12     *         15                             701 670   12               15                       701
1313414 1313414 MD     school 2400360 11   Garrett 240036000674 3709 Southern Garrett High School   Regular School No High 09 12 2021   pk_12_total 653 * *     *         16                             678 653                   16                       678
1240856 1240856 MD     school 2400360 11   Garrett 240036000671 3512 Northern Garrett High School   Regular School No High 09 12 2020   pk_12_total 426   *     *         *                             441 426                                           441
1313409 1313409 MD     school 2400360 11   Garrett 240036000671 3512 Northern Garrett High School   Regular School No High 09 12 2021   pk_12_total 440   11     *         *                             461 440   11                                       461
1237952 1237952 MD     school 2400060 2   Anne Arundel 240006000823 3423 Meade Middle   Regular School No Middle 06 08 2020   pk_12_total 74 381 304   * 31         40                             832 74 381 304     31         40                       832
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
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
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
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
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
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
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
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
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
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
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
1237902 1237902 MD     school 2400060 2   Anne Arundel 240006000109 3353 Old Mill High   Regular School No High 09 12 2020   pk_12_total 892 821 311   * 104     10   139                             2281 892 821 311     104     10   139                       2281
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
1237897 1237897 MD     school 2400060 2   Anne Arundel 240006000108 3343 Old Mill Middle South   Regular School No Middle 06 08 2020   pk_12_total 477 225 174     38     *   72                             990 477 225 174     38         72                       990
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
1237893 1237893 MD     school 2400060 2   Anne Arundel 240006000107 3333 Old Mill Middle North   Regular School No Middle 06 08 2020   pk_12_total 345 475 144   * 48     *   66                             1081 345 475 144     48         66                       1081
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
1237889 1237889 MD     school 2400060 2   Anne Arundel 240006000099 3323 Meade High   Regular School No High 09 12 2020   pk_12_total 259 1021 508   * 103     *   129                             2029 259 1021 508     103         129                       2029
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
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
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
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
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
1237869 1237869 MD     school 2400060 2   Anne Arundel 240006001403 3263 Crofton Middle   Regular School No Middle 06 08 2020   pk_12_total 746 271 136   * 105     *   76                             1345 746 271 136     105         76                       1345
1310434 1310434 MD     school 2400060 2   Anne Arundel 240006001403 3263 Crofton Middle   Regular School No Middle 06 08 2021   pk_12_total 720 257 152   * 114     *   87                             1339 720 257 152     114         87                       1339
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
1310430 1310430 MD     school 2400060 2   Anne Arundel 240006002944 3242 Piney Orchard Elementary   Regular School No Elementary KG 05 2021   pk_12_total 386 204 97   * 51     *   64                             808 386 204 97     51         64                       808
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
1310423 1310423 MD     school 2400060 2   Anne Arundel 240006000140 3232 West Meade Early Education Center   Regular School No Elementary PK KG 2021   pk_12_total 119 29 42   * *     *   15                             210 119 29 42               15                       210
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
1310420 1310420 MD     school 2400060 2   Anne Arundel 240006000138 3222 Waugh Chapel Elementary   Regular School No Elementary PK 05 2021   pk_12_total 300 135 90   * 58     *   44                             631 300 135 90     58         44                       631

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