enrollments

Data source: Big Local News · About: Big Local

9,615 rows where state = "MD" and year = 2020 sorted by native_hawaiian_pacific_islander_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 9,615 ✖
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
1237239 1237239 MD     school 2400030 1   Allegany 240003000031 406 Washington Middle   Regular School No Middle 06 08 2020   pk_12_total 522 35 *     *     *   46                             612 522 35                 46                       612
1237251 1237251 MD     school 2400030 1   Allegany 240003000006 504 Braddock Middle   Regular School No Middle 06 08 2020   pk_12_total 510 26 15     10     *   57                             620 510 26 15     10         57                       620
1237275 1237275 MD     school 2400030 1   Allegany 240003000010 701 Cresaptown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 284 * 12     *     *   16                             320 284   12               16                       320
1237291 1237291 MD     school 2400030 1   Allegany 240003000033 801 Westernport Elementary   Regular School No Elementary PK 05 2020   pk_12_total 242 * *           *   11                             260 242                   11                       260
1237315 1237315 MD     school 2400030 1   Allegany 240003000023 1301 Mount Savage Middle   Regular School No Middle 06 08 2020   pk_12_total 369 * *   * *     *   12                             394 369                   12                       394
1237356 1237356 MD     school 2400060 2   Anne Arundel 240006000050 1023 Brooklyn Park Middle   Regular School No Middle 06 08 2020   pk_12_total 350 217 185   * 16     *   64                             837 350 217 185     16         64                       837
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
1237365 1237365 MD     school 2400060 2   Anne Arundel 240006000059 1043 Corkran Middle School   Regular School No Middle 06 08 2020   pk_12_total 237 176 167   * 25     *   46                             657 237 176 167     25         46                       657
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
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
1237381 1237381 MD     school 2400060 2   Anne Arundel 240006000043 1082 Belle Grove Elementary   Regular School No Elementary PK 05 2020   pk_12_total 120 64 75   * 13     *   35                             309 120 64 75     13         35                       309
1237398 1237398 MD     school 2400060 2   Anne Arundel 240006000071 1112 George T. Cromwell Elementary   Regular School No Elementary 01 05 2020   pk_12_total 160 35 77   * 10     *   17                             301 160 35 77     10         17                       301
1237406 1237406 MD     school 2400060 2   Anne Arundel 240006001515 1122 Freetown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 146 184 90   * 15     *   34                             471 146 184 90     15         34                       471
1237414 1237414 MD     school 2400060 2   Anne Arundel 240006000077 1132 Glendale Elementary   Regular School No Elementary PK 05 2020   pk_12_total 192 41 134   * *     *   34                             412 192 41 134               34                       412
1237422 1237422 MD     school 2400060 2   Anne Arundel 240006000081 1142 Hilltop Elementary   Regular School No Elementary PK 05 2020   pk_12_total 176 235 186   * 23     *   56                             679 176 235 186     23         56                       679
1237429 1237429 MD     school 2400060 2   Anne Arundel 240006000088 1152 Linthicum Elementary   Regular School No Elementary KG 05 2020   pk_12_total 348 31 51     25     *   18                             475 348 31 51     25         18                       475
1237437 1237437 MD     school 2400060 2   Anne Arundel 240006000093 1162 Marley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 228 257 213   * 63     *   61                             831 228 257 213     63         61                       831
1237453 1237453 MD     school 2400060 2   Anne Arundel 240006000105 1182 Oakwood Elementary   Regular School No Elementary PK 05 2020   pk_12_total 137 66 79   * 28     *   21                             334 137 66 79     28         21                       334
1237461 1237461 MD     school 2400060 2   Anne Arundel 240006000110 1192 Overlook Elementary   Regular School No Elementary PK 05 2020   pk_12_total 191 78 72     13     *   21                             376 191 78 72     13         21                       376
1237469 1237469 MD     school 2400060 2   Anne Arundel 240006000111 1202 Park Elementary   Regular School No Elementary PK 05 2020   pk_12_total 176 127 160   * 16     *   38                             519 176 127 160     16         38                       519
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
1237500 1237500 MD     school 2400060 2   Anne Arundel 240006000142 1262 Woodside Elementary   Regular School No Elementary PK 05 2020   pk_12_total 128 63 153   * 10     *   12                             368 128 63 153     10         12                       368
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
1237519 1237519 MD     school 2400060 2   Anne Arundel 240006090441 1323 North County High   Regular School No High 09 12 2020   pk_12_total 1017 593 414   * 119     *   133                             2286 1017 593 414     119         133                       2286
1237524 1237524 MD     school 2400060 2   Anne Arundel 240006000127 2013 Severna Park High   Regular School No High 09 12 2020   pk_12_total 1589 77 97   * 81     *   84                             1932 1589 77 97     81         84                       1932
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
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
1237537 1237537 MD     school 2400060 2   Anne Arundel 240006000126 2043 Severna Park Middle   Regular School No Middle 06 08 2020   pk_12_total 1162 52 87   * 66     *   77                             1453 1162 52 87     66         77                       1453
1237544 1237544 MD     school 2400060 2   Anne Arundel 240006000038 2052 Arnold Elementary   Regular School No Elementary KG 05 2020   pk_12_total 427 33 30   * 21     *   29                             543 427 33 30     21         29                       543
1237552 1237552 MD     school 2400060 2   Anne Arundel 240006000044 2062 Belvedere Elementary   Regular School No Elementary PK 05 2020   pk_12_total 381 30 56   * 21     *   42                             532 381 30 56     21         42                       532
1237574 1237574 MD     school 2400060 2   Anne Arundel 240006000051 2092 Cape St. Claire Elementary   Regular School No Elementary KG 05 2020   pk_12_total 473 17 70   * 14     *   48                             625 473 17 70     14         48                       625
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
1237657 1237657 MD     school 2400060 2   Anne Arundel 240006000129 2212 Solley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 498 100 94   * 32     *   70                             798 498 100 94     32         70                       798
1237665 1237665 MD     school 2400060 2   Anne Arundel 240006000134 2222 Sunset Elementary   Regular School No Elementary PK 05 2020   pk_12_total 342 30 29   * 10     *   33                             446 342 30 29     10         33                       446
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
1237679 1237679 MD     school 2400060 2   Anne Arundel 240006000058 2273 Chesapeake High   Regular School No High 09 12 2020   pk_12_total 1161 57 82   * 26     *   54                             1388 1161 57 82     26         54                       1388
1237686 1237686 MD     school 2400060 2   Anne Arundel 240006000047 2322 Broadneck Elementary   Regular School No Elementary KG 05 2020   pk_12_total 586 41 71   * 25     *   49                             774 586 41 71     25         49                       774
1237691 1237691 MD     school 2400060 2   Anne Arundel 240006001402 2363 Broadneck High   Regular School No High 09 12 2020   pk_12_total 1635 170 212   10 60     *   130                             2221 1635 170 212   10 60         130                       2221
1237722 1237722 MD     school 2400060 2   Anne Arundel 240006000039 3023 Arundel Middle   Regular School No Middle 06 08 2020   pk_12_total 480 283 118   * 57     *   122                             1068 480 283 118     57         122                       1068
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
1237734 1237734 MD     school 2400060 2   Anne Arundel 240006000048 3062 Brock Bridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 44 245 251   * 40     *   16                             600 44 245 251     40         16                       600
1237749 1237749 MD     school 2400060 2   Anne Arundel 240006000061 3082 Crofton Woods Elementary   Regular School No Elementary KG 05 2020   pk_12_total 525 48 69   * 54     *   63                             763 525 48 69     54         63                       763
1237757 1237757 MD     school 2400060 2   Anne Arundel 240006001645 3092 Seven Oaks Elementary   Regular School No Elementary PK 05 2020   pk_12_total 61 357 59     15     *   46                             539 61 357 59     15         46                       539
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
1237803 1237803 MD     school 2400060 2   Anne Arundel 240006000137 3152 Van Bokkelen Elementary   Regular School No Elementary PK 05 2020   pk_12_total 17 304 118   * *     *   20                             465 17 304 118               20                       465
1237810 1237810 MD     school 2400060 2   Anne Arundel 240006000100 3162 Millersville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 249 23 30     *     *   33                             344 249 23 30               33                       344
1237818 1237818 MD     school 2400060 2   Anne Arundel 240006000106 3172 Odenton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 186 146 96     27     *   71                             527 186 146 96     27         71                       527
1237825 1237825 MD     school 2400060 2   Anne Arundel 240006000114 3182 Pershing Hill Elementary   Regular School No Elementary KG 05 2020   pk_12_total 255 117 113   * 12     *   67                             568 255 117 113     12         67                       568
1237832 1237832 MD     school 2400060 2   Anne Arundel 240006000119 3192 Ridgeway Elementary   Regular School No Elementary KG 05 2020   pk_12_total 333 145 99     25     *   80                             686 333 145 99     25         80                       686
1237840 1237840 MD     school 2400060 2   Anne Arundel 240006000123 3202 Severn Elementary   Regular School No Elementary PK 05 2020   pk_12_total 125 285 65   * 30     *   43                             553 125 285 65     30         43                       553
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
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
1237877 1237877 MD     school 2400060 2   Anne Arundel 240006000069 3272 Four Seasons Elementary   Regular School No Elementary PK 05 2020   pk_12_total 364 134 63   * 49     *   71                             684 364 134 63     49         71                       684
1237884 1237884 MD     school 2400060 2   Anne Arundel 240006001658 3282 Nantucket Elementary   Regular School No Elementary KG 05 2020   pk_12_total 361 219 57   * 95     *   44                             779 361 219 57     95         44                       779
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
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
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
1237917 1237917 MD     school 2400060 2   Anne Arundel 240006000076 3372 Glen Burnie Park Elementary   Regular School No Elementary PK 05 2020   pk_12_total 145 212 134   * 25     *   24                             543 145 212 134     25         24                       543
1237925 1237925 MD     school 2400060 2   Anne Arundel 240006000133 3382 Southgate Elementary   Regular School No Elementary PK 05 2020   pk_12_total 275 316 116   * 21     *   54                             784 275 316 116     21         54                       784
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
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
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
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
1238038 1238038 MD     school 2400060 2   Anne Arundel 240006000065 4152 Edgewater Elementary   Regular School No Elementary KG 05 2020   pk_12_total 390 * 135   * 14     *   23                             573 390   135     14         23                       573
1238046 1238046 MD     school 2400060 2   Anne Arundel 240006000073 4162 Georgetown East Elementary   Regular School No Elementary PK 05 2020   pk_12_total 11 160 130     *     *   *                             315 11 160 130                                       315
1238070 1238070 MD     school 2400060 2   Anne Arundel 240006000089 4202 Lothian Elementary   Regular School No Elementary PK 05 2020   pk_12_total 247 37 164   * *     *   40                             495 247 37 164               40                       495
1238077 1238077 MD     school 2400060 2   Anne Arundel 240006000097 4212 Mayo Elementary   Regular School No Elementary KG 05 2020   pk_12_total 279 11 34     *     *   19                             347 279 11 34               19                       347
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
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
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
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
1238249 1238249 MD     school 2400120 3   Baltimore County 240012000353 101 Catonsville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 329 114 51   * 118     *   53                             668 329 114 51     118         53                       668
1238265 1238265 MD     school 2400120 3   Baltimore County 240012000495 103 Westowne Elementary   Regular School No Elementary PK 05 2020   pk_12_total 250 256 45   * 93     *   45                             698 250 256 45     93         45                       698
1238273 1238273 MD     school 2400120 3   Baltimore County 240012000382 104 Edmondson Heights Elementary   Regular School No Elementary PK 05 2020   pk_12_total 37 375 61   * 19     *   25                             524 37 375 61     19         25                       524
1238281 1238281 MD     school 2400120 3   Baltimore County 240012000410 105 Johnnycake Elementary   Regular School No Elementary PK 05 2020   pk_12_total 52 368 163   * 77     *   23                             690 52 368 163     77         23                       690
1238304 1238304 MD     school 2400120 3   Baltimore County 240012002945 112 Dogwood Elementary   Regular School No Elementary PK 05 2020   pk_12_total 20 555 30   17 40     *   19                             682 20 555 30   17 40         19                       682
1238312 1238312 MD     school 2400120 3   Baltimore County 240012000357 113 Chadwick Elementary   Regular School No Elementary PK 05 2020   pk_12_total 32 279 78   * 234     *   *                             637 32 279 78     234                                 637
1238320 1238320 MD     school 2400120 3   Baltimore County 240012000406 115 Hillcrest Elementary   Regular School No Elementary PK 05 2020   pk_12_total 409 75 81   * 98     *   32                             698 409 75 81     98         32                       698
1238328 1238328 MD     school 2400120 3   Baltimore County 240012000499 116 Woodbridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 39 142 68   * 183     *   14                             448 39 142 68     183         14                       448
1238332 1238332 MD     school 2400120 3   Baltimore County 240012000354 151 Catonsville Middle   Regular School No Middle 06 08 2020   pk_12_total 508 174 61   * 73     *   30                             850 508 174 61     73         30                       850
1238341 1238341 MD     school 2400120 3   Baltimore County 240012000502 172 Woodlawn High Center for Pre-Eng. Res.   Regular School No High 09 12 2020   pk_12_total 41 1277 229   * 82     *   21                             1656 41 1277 229     82         21                       1656
1238346 1238346 MD     school 2400120 3   Baltimore County 240012000355 174 Catonsville High   Regular School No High 09 12 2020   pk_12_total 929 462 110   * 223     *   95                             1826 929 462 110     223         95                       1826
1238351 1238351 MD     school 2400120 3   Baltimore County 240012000248 175 Western School of Technology & Env. Science   Career and Technical School No High 09 12 2020   pk_12_total 120 515 47   * 183     *   25                             892 120 515 47     183         25                       892
1238358 1238358 MD     school 2400120 3   Baltimore County 240012000457 202 Randallstown Elementary   Regular School No Elementary KG 05 2020   pk_12_total * 345 29     *     *   11                             400   345 29               11                       400
1238366 1238366 MD     school 2400120 3   Baltimore County 240012000385 204 Featherbed Lane Elementary   Regular School No Elementary PK 05 2020   pk_12_total 12 452 78   * *     *   19                             572 12 452 78               19                       572
1238374 1238374 MD     school 2400120 3   Baltimore County 240012000503 205 Woodmoor Elementary   Regular School No Elementary PK 05 2020   pk_12_total 12 536 46   * *     *   *                             614 12 536 46                                       614
1238381 1238381 MD     school 2400120 3   Baltimore County 240012000471 206 Scotts Branch Elementary   Regular School No Elementary KG 05 2020   pk_12_total 10 487 33     *     *   *                             543 10 487 33                                       543
1238421 1238421 MD     school 2400120 3   Baltimore County 240012000497 213 Winand Elementary   Regular School No Elementary PK 05 2020   pk_12_total 16 410 17   * *     *   10                             465 16 410 17               10                       465
1238445 1238445 MD     school 2400120 3   Baltimore County 240012001159 217 New Town Elementary   Regular School No Elementary PK 05 2020   pk_12_total 50 656 36   * 40     *   41                             830 50 656 36     40         41                       830
1238454 1238454 MD     school 2400120 3   Baltimore County 240012001431 252 Northwest Academy of Health Sciences   Regular School No Middle 06 08 2020   pk_12_total 22 687 42   * 17     *   15                             785 22 687 42     17         15                       785
1238458 1238458 MD     school 2400120 3   Baltimore County 240012000501 253 Woodlawn Middle   Regular School No Middle 06 08 2020   pk_12_total 12 550 39     *     *   13                             622 12 550 39               13                       622
1238462 1238462 MD     school 2400120 3   Baltimore County 240012000372 254 Deer Park Middle Magnet School   Regular School No Middle 06 08 2020   pk_12_total 37 1183 74   * 29     *   36                             1365 37 1183 74     29         36                       1365
1238471 1238471 MD     school 2400120 3   Baltimore County 240012000432 271 Milford Mill Academy   Regular School No High 09 12 2020   pk_12_total 15 1118 68   * 17     *   28                             1251 15 1118 68     17         28                       1251
1238482 1238482 MD     school 2400120 3   Baltimore County 240012000348 303 Bedford Elementary   Regular School No Elementary 01 05 2020   pk_12_total 10 250 46     *     *   16                             331 10 250 46               16                       331
1238503 1238503 MD     school 2400120 3   Baltimore County 240012000387 308 Fort Garrison Elementary   Regular School No Elementary PK 05 2020   pk_12_total 232 62 *   * 11     *   *                             319 232 62       11                                 319
1238510 1238510 MD     school 2400120 3   Baltimore County 240012000481 310 Summit Park Elementary   Regular School No Elementary KG 05 2020   pk_12_total 346 56 20   * 32     *   14                             470 346 56 20     32         14                       470
1238517 1238517 MD     school 2400120 3   Baltimore County 240012001405 311 Woodholme Elementary   Regular School No Elementary KG 05 2020   pk_12_total 46 470 145   * 24     *   25                             714 46 470 145     24         25                       714
1238521 1238521 MD     school 2400120 3   Baltimore County 240012000448 352 Pikesville Middle   Regular School No Middle 06 08 2020   pk_12_total 162 642 86   * 39     *   34                             972 162 642 86     39         34                       972
1238530 1238530 MD     school 2400120 3   Baltimore County 240012000449 371 Pikesville High   Regular School No High 09 12 2020   pk_12_total 301 464 76   * 54     *   21                             922 301 464 76     54         21                       922
1238554 1238554 MD     school 2400120 3   Baltimore County 240012000361 404 Chatsworth School   Regular School No Elementary PK 05 2020   pk_12_total 119 178 23   * 22     *   22                             366 119 178 23     22         22                       366

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