enrollments

Data source: Big Local News · About: Big Local

1,393 rows where grade = "pk_12_total", state = "MD" and year = 2021 sorted by school_state_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 1,393 ✖

grade ✖

  • pk_12_total · 1,393 ✖
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1310412 1310412 MD     school 2400060 2   Anne Arundel 240006000130 3212 South Shore Elementary   Regular School No Elementary KG 05 2021   pk_12_total 175 11 52   * *         22                             268 175 11 52               22                       268
1310405 1310405 MD     school 2400060 2   Anne Arundel 240006000123 3202 Severn Elementary   Regular School No Elementary PK 05 2021   pk_12_total 104 278 75   * 40     *   43                             544 104 278 75     40         43                       544
1310397 1310397 MD     school 2400060 2   Anne Arundel 240006000119 3192 Ridgeway Elementary   Regular School No Elementary KG 05 2021   pk_12_total 285 148 95   * 34     *   68                             632 285 148 95     34         68                       632
1310390 1310390 MD     school 2400060 2   Anne Arundel 240006000114 3182 Pershing Hill Elementary   Regular School No Elementary KG 05 2021   pk_12_total 216 99 97   * 14     *   60                             491 216 99 97     14         60                       491
1310383 1310383 MD     school 2400060 2   Anne Arundel 240006000106 3172 Odenton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 177 140 102   * 28     *   70                             519 177 140 102     28         70                       519
1310375 1310375 MD     school 2400060 2   Anne Arundel 240006000100 3162 Millersville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 259 21 28     *     *   32                             349 259 21 28               32                       349
1310368 1310368 MD     school 2400060 2   Anne Arundel 240006000137 3152 Van Bokkelen Elementary   Regular School No Elementary PK 05 2021   pk_12_total 15 242 109   * *         12                             381 15 242 109               12                       381
1310360 1310360 MD     school 2400060 2   Anne Arundel 240006000098 3142 Meade Heights Elementary   Regular School No Elementary PK 05 2021   pk_12_total 60 252 59   * *     *   33                             414 60 252 59               33                       414
1310352 1310352 MD     school 2400060 2   Anne Arundel 240006000096 3132 Maryland City Elementary   Regular School No Elementary PK 05 2021   pk_12_total 14 154 201   * *         10                             389 14 154 201               10                       389
1310344 1310344 MD     school 2400060 2   Anne Arundel 240006000092 3122 Manor View Elementary   Regular School No Elementary 01 05 2021   pk_12_total 89 47 51   * *     *   37                             235 89 47 51               37                       235
1310338 1310338 MD     school 2400060 2   Anne Arundel 240006000083 3112 Jessup Elementary   Regular School No Elementary PK 05 2021   pk_12_total 163 160 140   * 39         54                             557 163 160 140     39         54                       557
1310330 1310330 MD     school 2400060 2   Anne Arundel 240006000078 3102 Hebron - Harman Elementary   Regular School No Elementary PK 05 2021   pk_12_total 98 285 161   * 75     *   64                             687 98 285 161     75         64                       687
1310322 1310322 MD     school 2400060 2   Anne Arundel 240006001645 3092 Seven Oaks Elementary   Regular School No Elementary PK 05 2021   pk_12_total 53 354 42     18     *   33                             501 53 354 42     18         33                       501
1310314 1310314 MD     school 2400060 2   Anne Arundel 240006000061 3082 Crofton Woods Elementary   Regular School No Elementary KG 05 2021   pk_12_total 458 58 65   * 60     *   65                             715 458 58 65     60         65                       715
1310307 1310307 MD     school 2400060 2   Anne Arundel 240006000060 3072 Crofton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 413 103 55   * 36     *   41                             653 413 103 55     36         41                       653
1310299 1310299 MD     school 2400060 2   Anne Arundel 240006001761 3063 Crofton High School   Regular School No Secondary 09 10 2021   pk_12_total 458 146 75   * 51     *   47                             783 458 146 75     51         47                       783
1310296 1310296 MD     school 2400060 2   Anne Arundel 240006000048 3062 Brock Bridge Elementary   Regular School No Elementary PK 05 2021   pk_12_total 38 214 234   * 37     *   15                             543 38 214 234     37         15                       543
1310288 1310288 MD     school 2400060 2   Anne Arundel 240006000090 3033 MacArthur Middle   Regular School No Middle 06 08 2021   pk_12_total 172 460 135   * 48     *   71                             898 172 460 135     48         71                       898
1310284 1310284 MD     school 2400060 2   Anne Arundel 240006000039 3023 Arundel Middle   Regular School No Middle 06 08 2021   pk_12_total 501 307 130   * 59     *   116                             1119 501 307 130     59         116                       1119
1310280 1310280 MD     school 2400060 2   Anne Arundel 240006000040 3013 Arundel High   Regular School No High 09 12 2021   pk_12_total 873 545 149   * 97     12   197                             1876 873 545 149     97     12   197                       1876
1309913 1309913 MD     school 2400030 1   Allegany 240003000026 2902 Parkside Elementary   Regular School No Elementary PK 05 2021   pk_12_total 134 16 *     *         15                             178 134 16                 15                       178
1309905 1309905 MD     school 2400030 1   Allegany 240003001338 2901 Cash Valley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 226 19 *     *         16                             273 226 19                 16                       273
1309897 1309897 MD     school 2400030 1   Allegany 240003000003 2801 Beall Elementary   Regular School No Elementary PK 05 2021   pk_12_total 384 * *   * *         41                             445 384                   41                       445
1313404 1313404 MD     school 2400360 11   Garrett 240036000675 2708 Southern Middle School   Regular School No Middle 06 08 2021   pk_12_total 447 * *     *         11                             468 447                   11                       468
1317799 1317799 MD     school 2400660 21   Washington 240066001266 2701 Fountaindale Elementary   Regular School No Elementary PK 05 2021   pk_12_total 194 67 39     22         37                             359 194 67 39     22         37                       359
1313331 1313331 MD     school 2400330 10   Frederick 240033000620 2611 Glade Elementary   Regular School No Elementary PK 05 2021   pk_12_total 407 25 55   * 13         41                             543 407 25 55     13         41                       543
1313323 1313323 MD     school 2400330 10   Frederick 240033000655 2610 Walkersville High   Regular School No High 09 12 2021   pk_12_total 733 183 168   * 44     *   89                             1219 733 183 168     44         89                       1219
1313318 1313318 MD     school 2400330 10   Frederick 240033000654 2607 Walkersville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 291 132 116   * 18     *   69                             631 291 132 116     18         69                       631
1313310 1313310 MD     school 2400330 10   Frederick 240033000656 2606 Walkersville Middle   Regular School No Middle 06 08 2021   pk_12_total 519 108 131   * 23     *   53                             836 519 108 131     23         53                       836
1317791 1317791 MD     school 2400660 21   Washington 240066001271 2602 Hickory Elementary   Regular School No Elementary PK 05 2021   pk_12_total 124 39 110     *         23                             297 124 39 110               23                       297
1317783 1317783 MD     school 2400660 21   Washington 240066001273 2601 Lincolnshire Elementary   Regular School No Elementary PK 05 2021   pk_12_total 293 60 57     *         51                             466 293 60 57               51                       466
1313306 1313306 MD     school 2400330 10   Frederick 240033001409 2525 Brunswick Middle   Regular School No Middle 06 08 2021   pk_12_total 427 42 84   * *         49                             610 427 42 84               49                       610
1313400 1313400 MD     school 2400360 11   Garrett 240036001351 2511 Northern Middle School   Regular School No Middle 06 08 2021   pk_12_total 342   *     *         *                             355 342                                           355
1317775 1317775 MD     school 2400660 21   Washington 240066001289 2505 Marshall Street School   Special Education School No Other PK 12 2021   pk_12_total 24 * *     *         *                             41 24                                           41
1313302 1313302 MD     school 2400330 10   Frederick 240033000626 2504 Brunswick Elementary   Regular School No Elementary PK 05 2021   pk_12_total 478 63 82   * 18         51                             694 478 63 82     18         51                       694
1313294 1313294 MD     school 2400330 10   Frederick 240033000627 2503 Brunswick High   Regular School No High 09 12 2021   pk_12_total 590 66 81   * 12         47                             797 590 66 81     12         47                       797
1317760 1317760 MD     school 2400660 21   Washington 240066001283 2503 Salem Avenue Elementary   Regular School No Elementary PK 05 2021   pk_12_total 261 166 125   * *     *   130                             687 261 166 125               130                       687
1317752 1317752 MD     school 2400660 21   Washington 240066001293 2501 Western Heights Middle   Regular School No Middle 06 08 2021   pk_12_total 440 234 149     17     *   109                             950 440 234 149     17         109                       950
1310275 1310275 MD     school 2400060 2   Anne Arundel 240006001421 2432 Shipley's Choice Elementary   Regular School No Elementary KG 05 2021   pk_12_total 320 * *     13         23                             369 320         13         23                       369
1310268 1310268 MD     school 2400060 2   Anne Arundel 240006000042 2423 Chesapeake Bay Middle   Regular School No Middle 06 08 2021   pk_12_total 908 31 60   * 15         43                             1062 908 31 60     15         43                       1062
1310264 1310264 MD     school 2400060 2   Anne Arundel 240006000124 2413 Severn River Middle   Regular School No Middle 06 08 2021   pk_12_total 588 67 87   * 16         41                             801 588 67 87     16         41                       801
1309889 1309889 MD     school 2400030 1   Allegany 240003001636 2404 Mountain Ridge High School   Regular School No High 09 12 2021   pk_12_total 712 17 12   * *         23                             771 712 17 12               23                       771
1313289 1313289 MD     school 2400330 10   Frederick 240033000647 2404 Rock Creek   Special Education School No Other PK 12 2021   pk_12_total 39 16 11               *                             71 39 16 11                                       71
1313274 1313274 MD     school 2400330 10   Frederick 240033000657 2403 Waverley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 31 68 363   * 33         12                             511 31 68 363     33         12                       511
1310260 1310260 MD     school 2400060 2   Anne Arundel 240006001516 2372 Windsor Farm Elementary   Regular School No Elementary KG 05 2021   pk_12_total 338 46 81   * 13         35                             515 338 46 81     13         35                       515
1310253 1310253 MD     school 2400060 2   Anne Arundel 240006001402 2363 Broadneck High   Regular School No High 09 12 2021   pk_12_total 1634 158 234   * 63     *   130                             2233 1634 158 234     63         130                       2233
1310248 1310248 MD     school 2400060 2   Anne Arundel 240006000047 2322 Broadneck Elementary   Regular School No Elementary KG 05 2021   pk_12_total 546 51 66   * 30         55                             749 546 51 66     30         55                       749
1313266 1313266 MD     school 2400330 10   Frederick 240033001748 2308 Butterfly Ridge Elementary   Regular School No Elementary PK 05 2021   pk_12_total 142 165 276     24     *   40                             649 142 165 276     24         40                       649
1313258 1313258 MD     school 2400330 10   Frederick 240033001550 2307 Tuscarora High   Regular School No High 09 12 2021   pk_12_total 690 356 379   * 125     *   87                             1645 690 356 379     125         87                       1645
1313253 1313253 MD     school 2400330 10   Frederick 240033000807 2306 Orchard Grove Elementary   Regular School No Elementary PK 05 2021   pk_12_total 150 205 144   * 53     *   46                             603 150 205 144     53         46                       603

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