enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pk_12_total · 2,691 ✖
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
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
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
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
1309952 1309952 MD     school 2400060 2   Anne Arundel 240006000066 1102 Ferndale Early Education Center   Regular School No Prekindergarten PK PK 2021   pk_12_total 30 19 21     12         *                             87 30 19 21     12                                 87
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
1310143 1310143 MD     school 2400060 2   Anne Arundel 240006000067 2102 Folger Mckinsey Elementary   Regular School No Elementary KG 05 2021   pk_12_total 482 17 31     18         28                             576 482 17 31     18         28                       576
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
1310151 1310151 MD     school 2400060 2   Anne Arundel 240006000068 2112 Fort Smallwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 404 17 18     *         19                             464 404 17 18               19                       464
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
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
1309959 1309959 MD     school 2400060 2   Anne Arundel 240006000071 1112 George T. Cromwell Elementary   Regular School No Elementary KG 05 2021   pk_12_total 169 48 85   * *     *   19                             333 169 48 85               19                       333
1237533 1237533 MD     school 2400060 2   Anne Arundel 240006000072 2033 George Fox Middle   Regular School No Middle 06 08 2020   pk_12_total 626 91 85   * 18     *   55                             884 626 91 85     18         55                       884
1310095 1310095 MD     school 2400060 2   Anne Arundel 240006000072 2033 George Fox Middle   Regular School No Middle 06 08 2021   pk_12_total 634 88 88   * 18     *   62                             899 634 88 88     18         62                       899
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
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
1237361 1237361 MD     school 2400060 2   Anne Arundel 240006000075 1033 Glen Burnie High   Regular School No High 09 12 2020   pk_12_total 812 624 420   * 86     *   120                             2076 812 624 420     86         120                       2076
1309922 1309922 MD     school 2400060 2   Anne Arundel 240006000075 1033 Glen Burnie High   Regular School No High 09 12 2021   pk_12_total 798 625 472   * 101     *   121                             2132 798 625 472     101         121                       2132
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
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
1309975 1309975 MD     school 2400060 2   Anne Arundel 240006000077 1132 Glendale Elementary   Regular School No Elementary PK 05 2021   pk_12_total 178 44 141   * *     *   31                             403 178 44 141               31                       403
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
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
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
1310159 1310159 MD     school 2400060 2   Anne Arundel 240006000079 2132 High Point Elementary   Regular School No Elementary PK 05 2021   pk_12_total 443 55 103   * 13     *   51                             669 443 55 103     13         51                       669
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
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
1309982 1309982 MD     school 2400060 2   Anne Arundel 240006000081 1142 Hilltop Elementary   Regular School No Elementary KG 05 2021   pk_12_total 142 201 160   * 20     *   44                             570 142 201 160     20         44                       570
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
1310167 1310167 MD     school 2400060 2   Anne Arundel 240006000082 2142 Jacobsville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 394 38 51     11         33                             527 394 38 51     11         33                       527
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
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
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
1310174 1310174 MD     school 2400060 2   Anne Arundel 240006000084 2152 Jones Elementary   Regular School No Elementary KG 05 2021   pk_12_total 219 12 21     21         19                             292 219 12 21     21         19                       292
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
1310182 1310182 MD     school 2400060 2   Anne Arundel 240006000085 2162 Lake Shore Elementary   Regular School No Elementary PK 05 2021   pk_12_total 275 * 19               21                             317 275   19               21                       317
1237369 1237369 MD     school 2400060 2   Anne Arundel 240006000087 1053 Lindale Middle   Regular School No Middle 06 08 2020   pk_12_total 480 302 202   * 64     *   71                             1126 480 302 202     64         71                       1126
1309930 1309930 MD     school 2400060 2   Anne Arundel 240006000087 1053 Lindale Middle   Regular School No Middle 06 08 2021   pk_12_total 490 347 222   * 51     *   80                             1194 490 347 222     51         80                       1194
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
1309990 1309990 MD     school 2400060 2   Anne Arundel 240006000088 1152 Linthicum Elementary   Regular School No Elementary PK 05 2021   pk_12_total 319 37 53     20     *   18                             449 319 37 53     20         18                       449
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
1237726 1237726 MD     school 2400060 2   Anne Arundel 240006000090 3033 MacArthur Middle   Regular School No Middle 06 08 2020   pk_12_total 191 505 127   * 53     *   67                             959 191 505 127     53         67                       959
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
1237674 1237674 MD     school 2400060 2   Anne Arundel 240006000091 2243 Magothy River Middle   Regular School No Middle 06 08 2020   pk_12_total 555 38 65   * 16     *   45                             723 555 38 65     16         45                       723
1310236 1310236 MD     school 2400060 2   Anne Arundel 240006000091 2243 Magothy River Middle   Regular School No Middle 06 08 2021   pk_12_total 533 40 72   * 15     *   51                             714 533 40 72     15         51                       714
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
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
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
1309998 1309998 MD     school 2400060 2   Anne Arundel 240006000093 1162 Marley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 202 267 192   * 57     *   52                             778 202 267 192     57         52                       778
1237514 1237514 MD     school 2400060 2   Anne Arundel 240006000094 1274 Marley Glen School   Special Education School No Other PK 11 2020   pk_12_total 91 32 15   * 11     *   *                             160 91 32 15     11                                 160
1310076 1310076 MD     school 2400060 2   Anne Arundel 240006000094 1274 Marley Glen School   Special Education School No Other PK 12 2021   pk_12_total 61 29 22   * *         *                             126 61 29 22                                       126
1237373 1237373 MD     school 2400060 2   Anne Arundel 240006000095 1063 Marley Middle   Regular School No Middle 06 08 2020   pk_12_total 359 255 213   * 28     *   79                             938 359 255 213     28         79                       938
1309934 1309934 MD     school 2400060 2   Anne Arundel 240006000095 1063 Marley Middle   Regular School No Middle 06 08 2021   pk_12_total 335 265 241   * 32     *   78                             956 335 265 241     32         78                       956
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
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
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
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
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
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
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
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
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
1310006 1310006 MD     school 2400060 2   Anne Arundel 240006000102 1172 North Glen Elementary   Regular School No Elementary PK 05 2021   pk_12_total 85 89 87     15         27                             303 85 89 87     15         27                       303
1237529 1237529 MD     school 2400060 2   Anne Arundel 240006000103 2023 Northeast High   Regular School No High 09 12 2020   pk_12_total 996 123 133   * 34     *   72                             1367 996 123 133     34         72                       1367
1310091 1310091 MD     school 2400060 2   Anne Arundel 240006000103 2023 Northeast High   Regular School No High 09 12 2021   pk_12_total 979 135 141   * 28     *   73                             1364 979 135 141     28         73                       1364
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
1310189 1310189 MD     school 2400060 2   Anne Arundel 240006000104 2172 Oak Hill Elementary   Regular School No Elementary KG 05 2021   pk_12_total 519 21 26   * 28     *   43                             639 519 21 26     28         43                       639
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
1310014 1310014 MD     school 2400060 2   Anne Arundel 240006000105 1182 Oakwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 137 74 69   * 26         30                             339 137 74 69     26         30                       339
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
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
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
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
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
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
1310022 1310022 MD     school 2400060 2   Anne Arundel 240006000110 1192 Overlook Elementary   Regular School No Elementary PK 05 2021   pk_12_total 182 76 57   * 14     *   24                             355 182 76 57     14         24                       355
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
1310030 1310030 MD     school 2400060 2   Anne Arundel 240006000111 1202 Park Elementary   Regular School No Elementary PK 05 2021   pk_12_total 165 134 167   * 16     *   38                             522 165 134 167     16         38                       522
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
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
1310196 1310196 MD     school 2400060 2   Anne Arundel 240006000113 2182 Pasadena Elementary   Regular School No Elementary KG 05 2021   pk_12_total 288 15 26     *         15                             347 288 15 26               15                       347
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
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
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
1310038 1310038 MD     school 2400060 2   Anne Arundel 240006000116 1212 Point Pleasant Elementary   Regular School No Elementary PK 05 2021   pk_12_total 289 69 99     12         41                             510 289 69 99     12         41                       510
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
1310046 1310046 MD     school 2400060 2   Anne Arundel 240006000117 1232 Quarterfield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 146 116 85     47     *   49                             445 146 116 85     47         49                       445

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