enrollments

Data source: Big Local News · About: Big Local

2,791 rows where grade = "pk_12_total" and state = "MD" sorted by school 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
1241083 1241083 MD     school 2400390 12   Harford 240039000717 348 Youths Benefit Elementary   Regular School No Elementary KG 05 2020   pk_12_total 939 14 40   * 24     *   34                             1057 939 14 40     24         34                       1057
1313639 1313639 MD     school 2400390 12   Harford 240039000717 348 Youths Benefit Elementary   Regular School No Elementary PK 05 2021   pk_12_total 942 22 44   * 27     *   37                             1082 942 22 44     27         37                       1082
1240825 1240825 MD     school 2400360 11   Garrett 240036000852 1710 Yough Glades Elementary   Regular School No Elementary PK 05 2020   pk_12_total 295 * *               *                             308 295                                           308
1313378 1313378 MD     school 2400360 11   Garrett 240036000852 1710 Yough Glades Elementary   Regular School No Elementary PK 05 2021   pk_12_total 271   *               *                             284 271                                           284
1246121 1246121 MD     school 2400090 30   Baltimore City 240009000340 219 Yorkwood Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 392 13   * *         *                             412   392 13                                       412
1318681 1318681 MD     school 2400090 30   Baltimore City 240009000340 219 Yorkwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 348 *   * *     *                                 363   348                                         363
1244026 1244026 MD     school 2400510 16   Prince George's 240051000200 1427 Yorktown Elementary   Regular School No Elementary KG 05 2020   pk_12_total 68 246 48     21     *   19                             403 68 246 48     21         19                       403
1316607 1316607 MD     school 2400510 16   Prince George's 240051000200 1427 Yorktown Elementary   Regular School No Elementary KG 05 2021   pk_12_total 67 234 50   * 19     *   20                             392 67 234 50     19         20                       392
1240672 1240672 MD     school 2400330 10   Frederick 240033000661 2103 Yellow Springs Elementary   Regular School No Elementary KG 05 2020   pk_12_total 275 97 41   * 19     *   32                             470 275 97 41     19         32                       470
1313225 1313225 MD     school 2400330 10   Frederick 240033000661 2103 Yellow Springs Elementary   Regular School No Elementary KG 05 2021   pk_12_total 266 112 65   * 22     *   31                             498 266 112 65     22         31                       498
1242325 1242325 MD     school 2400480 15   Montgomery 240048000963 422 Wyngate Elementary   Regular School No Elementary PK 05 2020   pk_12_total 448 33 90     99     *   70                             741 448 33 90     99         70                       741
1314893 1314893 MD     school 2400480 15   Montgomery 240048000963 422 Wyngate Elementary   Regular School No Elementary PK 05 2021   pk_12_total 404 28 89     95     *   56                             673 404 28 89     95         56                       673
1241341 1241341 MD     school 2400420 13   Howard 240042000764 213 Worthington Elementary   Regular School No Elementary PK 05 2020   pk_12_total 199 34 38   * 202         33                             508 199 34 38     202         33                       508
1313896 1313896 MD     school 2400420 13   Howard 240042000764 213 Worthington Elementary   Regular School No Elementary PK 05 2021   pk_12_total 190 36 23   * 189         27                             467 190 36 23     189         27                       467
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
1310061 1310061 MD     school 2400060 2   Anne Arundel 240006000142 1262 Woodside Elementary   Regular School No Elementary PK 05 2021   pk_12_total 110 65 145     *     *   10                             340 110 65 145               10                       340
1244415 1244415 MD     school 2400510 16   Prince George's 240051001386 2007 Woodridge Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 39 274     *     *                                 324   39 274                                       324
1316996 1316996 MD     school 2400510 16   Prince George's 240051001386 2007 Woodridge Elementary   Regular School No Elementary PK 06 2021   pk_12_total * 39 266   * *                                       314   39 266                                       314
1243475 1243475 MD     school 2400510 16   Prince George's 240051001188 706 Woodmore Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 406 33     20     *   *                             473   406 33     20                                 473
1316055 1316055 MD     school 2400510 16   Prince George's 240051001188 706 Woodmore Elementary   Regular School No Elementary PK 05 2021   pk_12_total 10 396 27   * 18     *   *                             460 10 396 27     18                                 460
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
1310928 1310928 MD     school 2400120 3   Baltimore County 240012000503 205 Woodmoor Elementary   Regular School No Elementary PK 05 2021   pk_12_total 14 498 41   * *     *   *                             565 14 498 41                                       565
1242769 1242769 MD     school 2400480 15   Montgomery 240048000961 764 Woodlin Elementary   Regular School No Elementary PK 05 2020   pk_12_total 214 140 118     33     *   47                             553 214 140 118     33         47                       553
1315349 1315349 MD     school 2400480 15   Montgomery 240048000961 764 Woodlin Elementary   Regular School No Elementary PK 05 2021   pk_12_total 198 130 102     43         38                             511 198 130 102     43         38                       511
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
1311013 1311013 MD     school 2400120 3   Baltimore County 240012000501 253 Woodlawn Middle   Regular School No Middle 06 08 2021   pk_12_total 11 577 49   * *     *   13                             657 11 577 49               13                       657
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
1310895 1310895 MD     school 2400120 3   Baltimore County 240012000502 172 Woodlawn High   Regular School No High 09 12 2021   pk_12_total 48 1265 247   * 86     *   22                             1680 48 1265 247     86         22                       1680
1246026 1246026 MD     school 2400090 30   Baltimore City 240009000339 205 Woodhome Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 36 314 51     *     *   *                             415 36 314 51                                       415
1318589 1318589 MD     school 2400090 30   Baltimore City 240009000339 205 Woodhome Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 36 334 55     *     *   *                             443 36 334 55                                       443
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
1311072 1311072 MD     school 2400120 3   Baltimore County 240012001405 311 Woodholme Elementary   Regular School No Elementary KG 05 2021   pk_12_total 46 440 137   * 27     *   25                             679 46 440 137     27         25                       679
1242703 1242703 MD     school 2400480 15   Montgomery 240048000959 704 Woodfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 182 31 87     31         24                             355 182 31 87     31         24                       355
1315282 1315282 MD     school 2400480 15   Montgomery 240048000959 704 Woodfield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 160 34 81     22         20                             317 160 34 81     22         20                       317
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
1310882 1310882 MD     school 2400120 3   Baltimore County 240012000499 116 Woodbridge Elementary   Regular School No Elementary PK 05 2021   pk_12_total 35 128 72   * 184     *   *                             430 35 128 72     184                                 430
1242303 1242303 MD     school 2400480 15   Montgomery 240048000958 417 Wood Acres Elementary   Regular School No Elementary PK 05 2020   pk_12_total 428 22 87     67         45                             649 428 22 87     67         45                       649
1314870 1314870 MD     school 2400480 15   Montgomery 240048000958 417 Wood Acres Elementary   Regular School No Elementary PK 05 2021   pk_12_total 397 16 72     56     *   41                             583 397 16 72     56         41                       583
1240493 1240493 MD     school 2400330 10   Frederick 240033000659 603 Wolfsville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 130 * *   *           *                             149 130                                           149
1313039 1313039 MD     school 2400330 10   Frederick 240033000659 603 Wolfsville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 105 * *               *                             123 105                                           123
1245544 1245544 MD     school 2400090 30   Baltimore City 240009000215 23 Wolfe Street Academy   Regular School Yes Elementary PK 05 2020   pk_12_total 12 28 215   * *                                       260 12 28 215                                       260
1318120 1318120 MD     school 2400090 30   Baltimore City 240009000215 23 Wolfe Street Academy   Regular School Yes Elementary PK 05 2021   pk_12_total 16 30 214   * *                                       265 16 30 214                                       265
1239702 1239702 MD     school 2400210 6   Carroll 240021001185 704 Winters Mill High   Regular School No High 09 12 2020   pk_12_total 792 75 126   * 34     *   48                             1079 792 75 126     34         48                       1079
1312252 1312252 MD     school 2400210 6   Carroll 240021001185 704 Winters Mill High   Regular School No High 09 12 2021   pk_12_total 780 79 125   * 38     *   55                             1080 780 79 125     38         55                       1080
1242629 1242629 MD     school 2400480 15   Montgomery 240048000956 602 Winston Churchill High   Regular School No High 09 12 2020   pk_12_total 1063 212 178   * 687     *   128                             2274 1063 212 178     687         128                       2274
1315207 1315207 MD     school 2400480 15   Montgomery 240048000956 602 Winston Churchill High   Regular School No High 09 12 2021   pk_12_total 1016 226 178   * 688     *   132                             2245 1016 226 178     688         132                       2245
1238413 1238413 MD     school 2400120 3   Baltimore County 240012000498 211 Winfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 14 425 32   * *         15                             493 14 425 32               15                       493
1239810 1239810 MD     school 2400210 6   Carroll 240021000555 906 Winfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 550 14 24   * *     *   11                             608 550 14 24               11                       608
1310967 1310967 MD     school 2400120 3   Baltimore County 240012000498 211 Winfield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 13 381 26   * *     *   14                             447 13 381 26               14                       447
1312358 1312358 MD     school 2400210 6   Carroll 240021000555 906 Winfield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 537 14 16   * *     *   *                             583 537 14 16                                       583
1239507 1239507 MD     school 2400150 4   Calvert 240015000967 318 Windy Hill Middle   Regular School No Middle 06 08 2020   pk_12_total 557 87 48   * 12     *   82                             789 557 87 48     12         82                       789
1312062 1312062 MD     school 2400150 4   Calvert 240015000967 318 Windy Hill Middle   Regular School No Middle 06 08 2021   pk_12_total 517 89 54   * *     *   77                             746 517 89 54               77                       746
1239503 1239503 MD     school 2400150 4   Calvert 240015000790 317 Windy Hill Elementary   Regular School No Elementary PK 05 2020   pk_12_total 488 50 52   * *         69                             668 488 50 52               69                       668
1312058 1312058 MD     school 2400150 4   Calvert 240015000790 317 Windy Hill Elementary   Regular School No Elementary PK 05 2021   pk_12_total 447 50 50   * 12     *   76                             637 447 50 50     12         76                       637
1238466 1238466 MD     school 2400120 3   Baltimore County 240012001574 256 Windsor Mill Middle   Regular School No Middle 06 08 2020   pk_12_total * 617 32   * *         11                             674   617 32               11                       674
1311021 1311021 MD     school 2400120 3   Baltimore County 240012001574 256 Windsor Mill Middle   Regular School No Middle 06 08 2021   pk_12_total * 635 29   * *     *   13                             691   635 29               13                       691
1240510 1240510 MD     school 2400330 10   Frederick 240033000392 714 Windsor Knolls Middle   Regular School No Middle 06 08 2020   pk_12_total 588 32 82     35     *   26                             764 588 32 82     35         26                       764
1313056 1313056 MD     school 2400330 10   Frederick 240033000392 714 Windsor Knolls Middle   Regular School No Middle 06 08 2021   pk_12_total 487 48 93     43     *   37                             709 487 48 93     43         37                       709
1245847 1245847 MD     school 2400090 30   Baltimore City 240009000337 87 Windsor Hills Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 241 *     *     *                                 259   241                                         259
1318412 1318412 MD     school 2400090 30   Baltimore City 240009000337 87 Windsor Hills Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 215 13     *     *                                 237   215 13                                       237
1237698 1237698 MD     school 2400060 2   Anne Arundel 240006001516 2372 Windsor Farm Elementary   Regular School No Elementary KG 05 2020   pk_12_total 388 41 87   * *         37                             564 388 41 87               37                       564
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
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
1310975 1310975 MD     school 2400120 3   Baltimore County 240012000497 213 Winand Elementary   Regular School No Elementary PK 05 2021   pk_12_total 13 409 14   * *     *   10                             455 13 409 14               10                       455
1242213 1242213 MD     school 2400480 15   Montgomery 240048001721 341 Wilson Wims Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 178 131 104   * 316     *   35                             767 178 131 104     316         35                       767
1314774 1314774 MD     school 2400480 15   Montgomery 240048001721 341 Wilson Wims Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 137 119 87   * 252     *   26                             624 137 119 87     252         26                       624
1244978 1244978 MD     school 2400660 21   Washington 240066001295 204 Williamsport High   Regular School No High 09 12 2020   pk_12_total 663 79 105   * *         47                             903 663 79 105               47                       903
1317553 1317553 MD     school 2400660 21   Washington 240066001295 204 Williamsport High   Regular School No High 09 12 2021   pk_12_total 660 74 104   * 10         52                             901 660 74 104     10         52                       901
1244973 1244973 MD     school 2400660 21   Washington 240066001294 202 Williamsport Elementary   Regular School No Elementary PK 05 2020   pk_12_total 438 38 36   * *     *   49                             572 438 38 36               49                       572
1317548 1317548 MD     school 2400660 21   Washington 240066001294 202 Williamsport Elementary   Regular School No Elementary PK 05 2021   pk_12_total 371 37 41   * 11     *   53                             515 371 37 41     11         53                       515
1244376 1244376 MD     school 2400510 16   Prince George's 240051001186 1908 William Wirt Middle   Regular School No Middle 06 08 2020   pk_12_total 23 215 940   * 40     *   *                             1224 23 215 940     40                                 1224
1316957 1316957 MD     school 2400510 16   Prince George's 240051001186 1908 William Wirt Middle   Regular School No Middle 06 08 2021   pk_12_total 25 219 962   * 64     *   *                             1280 25 219 962     64                                 1280
1239710 1239710 MD     school 2400210 6   Carroll 240021000554 705 William Winchester Elementary   Regular School No Elementary PK 05 2020   pk_12_total 347 34 102     10         30                             523 347 34 102     10         30                       523
1312260 1312260 MD     school 2400210 6   Carroll 240021000554 705 William Winchester Elementary   Regular School No Elementary PK 05 2021   pk_12_total 314 41 92     10         26                             483 314 41 92     10         26                       483
1244346 1244346 MD     school 2400510 16   Prince George's 240051001462 1830 William W. Hall Academy   Regular School No Elementary PK 08 2020   pk_12_total 12 360 193   *                                         566 12 360 193                                       566
1316927 1316927 MD     school 2400510 16   Prince George's 240051001462 1830 William W. Hall Academy   Regular School No Elementary PK 08 2021   pk_12_total 11 341 205   *                                         558 11 341 205                                       558
1242142 1242142 MD     school 2400480 15   Montgomery 240048000955 312 William Tyler Page Elementary   Regular School No Elementary PK 05 2020   pk_12_total 74 279 160   * 73         27                             615 74 279 160     73         27                       615
1314701 1314701 MD     school 2400480 15   Montgomery 240048000955 312 William Tyler Page Elementary   Regular School No Elementary PK 05 2021   pk_12_total 85 281 158   * 64     *   32                             622 85 281 158     64         32                       622
1240868 1240868 MD     school 2400390 12   Harford 240039000715 113 William S. James Elementary   Regular School No Elementary KG 05 2020   pk_12_total 338 55 30   * 12         35                             472 338 55 30     12         35                       472
1313421 1313421 MD     school 2400390 12   Harford 240039000715 113 William S. James Elementary   Regular School No Elementary KG 05 2021   pk_12_total 344 60 33     15         28                             480 344 60 33     15         28                       480
1246444 1246444 MD     school 2400090 30   Baltimore City 240009000336 301 William S. Baer School   Special Education School No Other PK 12 2020   pk_12_total 15 126 21     *                                       167 15 126 21                                       167
1318995 1318995 MD     school 2400090 30   Baltimore City 240009000336 301 William S. Baer School   Special Education School No Other PK 12 2021   pk_12_total 14 112 20     *                                       148 14 112 20                                       148
1240931 1240931 MD     school 2400390 12   Harford 240039000716 140 William Paca/Old Post Road Elementary   Regular School No Elementary PK 05 2020   pk_12_total 210 386 158   10 13         88                             865 210 386 158   10 13         88                       865
1313484 1313484 MD     school 2400390 12   Harford 240039000716 140 William Paca/Old Post Road Elementary   Regular School No Elementary PK 05 2021   pk_12_total 199 378 150   * 11         89                             836 199 378 150     11         89                       836
1243849 1243849 MD     school 2400510 16   Prince George's 240051000729 1309 William Paca Elementary   Regular School No Elementary PK 05 2020   pk_12_total 27 355 189   * 44     *   *                             619 27 355 189     44                                 619
1245812 1245812 MD     school 2400090 30   Baltimore City 240009000334 83 William Paca Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 267 227   * *     *   *                             509   267 227                                       509
1316430 1316430 MD     school 2400510 16   Prince George's 240051000729 1309 William Paca Elementary   Regular School No Elementary PK 05 2021   pk_12_total 24 298 164   * 50     *   *                             544 24 298 164     50                                 544
1318377 1318377 MD     school 2400090 30   Baltimore City 240009000334 83 William Paca Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 213 215   * *     *   *                             445   213 215                                       445
1242392 1242392 MD     school 2400480 15   Montgomery 240048000957 507 William H. Farquhar Middle   Regular School No Middle 06 08 2020   pk_12_total 254 177 121   * 110         31                             694 254 177 121     110         31                       694
1314964 1314964 MD     school 2400480 15   Montgomery 240048000957 507 William H. Farquhar Middle   Regular School No Middle 06 08 2021   pk_12_total 241 171 118   * 100         40                             671 241 171 118     100         40                       671
1243373 1243373 MD     school 2400510 16   Prince George's 240051001184 636 William Beanes Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 363 106     *     *   *                             481   363 106                                       481
1315953 1315953 MD     school 2400510 16   Prince George's 240051001184 636 William Beanes Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 325 89           *   *                             428   325 89                                       428
1240148 1240148 MD     school 2400270 8   Charles 240027001519 618 William B. Wade Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 89 407 71   * 42         74                             686 89 407 71     42         74                       686
1312696 1312696 MD     school 2400270 8   Charles 240027001519 618 William B. Wade Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 72 385 50   * 39         71                             619 72 385 50     39         71                       619
1242198 1242198 MD     school 2400480 15   Montgomery 240048001673 337 William B. Gibbs, Jr. Elementary   Regular School No Elementary PK 05 2020   pk_12_total 109 184 129   * 157         40                             621 109 184 129     157         40                       621
1314758 1314758 MD     school 2400480 15   Montgomery 240048001673 337 William B. Gibbs, Jr. Elementary   Regular School No Elementary PK 05 2021   pk_12_total 96 155 113     151         36                             551 96 155 113     151         36                       551
1240186 1240186 MD     school 2400270 8   Charles 240027001565 624 William A. Diggs Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 94 523 58     30     *   66                             775 94 523 58     30         66                       775
1312734 1312734 MD     school 2400270 8   Charles 240027001565 624 William A. Diggs Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 84 525 60     30     *   59                             762 84 525 60     30         59                       762
1245341 1245341 MD     school 2400690 22   Wicomico 240069001322 1404 Willards Elementary   Regular School No Elementary PK 03 2020   pk_12_total 259 * 27   * *     *   27                             323 259   27               27                       323
1317917 1317917 MD     school 2400690 22   Wicomico 240069001322 1404 Willards Elementary   Regular School No Elementary PK 03 2021   pk_12_total 209 * 23   * *     *   22                             260 209   23               22                       260

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