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 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1318423 1318423 MD     school 2400090 30   Baltimore City 240009000273 88 Wildwood Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 713 15           *   *                             734   713 15                                       734
1314018 1314018 MD     school 2400420 13   Howard 240042000763 512 Wilde Lake Middle   Regular School No Middle 06 08 2021   pk_12_total 154 301 81     43         62                             641 154 301 81     43         62                       641
1314039 1314039 MD     school 2400420 13   Howard 240042000762 516 Wilde Lake High   Regular School No High 09 12 2021   pk_12_total 328 654 187   * 100     *   105                             1379 328 654 187     100         105                       1379
1317825 1317825 MD     school 2400690 22   Wicomico 240069001319 510 Wicomico Middle   Regular School No Middle 06 08 2021   pk_12_total 189 372 155   * 17     *   86                             829 189 372 155     17         86                       829
1317834 1317834 MD     school 2400690 22   Wicomico 240069001320 513 Wicomico High   Regular School No High 09 12 2021   pk_12_total 306 592 178   * 32     *   77                             1190 306 592 178     32         77                       1190
1317849 1317849 MD     school 2400690 22   Wicomico 240069001088 520 Wicomico County Evening High   Alternative School No High 09 12 2021   pk_12_total 24 46 11               *                             86 24 46 11                                       86
1313233 1313233 MD     school 2400330 10   Frederick 240033001015 2107 Whittier Elementary   Regular School No Elementary PK 05 2021   pk_12_total 300 182 121   * 43     *   36                             686 300 182 121     43         36                       686
1316636 1316636 MD     school 2400510 16   Prince George's 240051001461 1438 Whitehall Elementary   Regular School No Elementary KG 05 2021   pk_12_total 134 300 75   * 49     *   17                             577 134 300 75     49         17                       577
1311380 1311380 MD     school 2400120 3   Baltimore County 240012001435 923 White Oak School   Special Education School No Elementary PK 05 2021   pk_12_total 30 33 *     *         *                             75 30 33                                         75
1315584 1315584 MD     school 2400480 15   Montgomery 240048000954 811 White Oak Middle   Regular School No Middle 06 08 2021   pk_12_total 40 255 462   * 83     *   18                             860 40 255 462     83         18                       860
1317308 1317308 MD     school 2400600 18   Saint Mary's 240060001240 503 White Marsh Elementary   Regular School No Elementary KG 05 2021   pk_12_total 170 20 12     *         15                             219 170 20 12               15                       219
1317499 1317499 MD     school 2400630 20   Talbot 240063001252 302 White Marsh Elementary   Regular School No Elementary PK 05 2021   pk_12_total 184 39 28   * *         28                             286 184 39 28               28                       286
1315116 1315116 MD     school 2400480 15   Montgomery 240048000953 558 Whetstone Elementary   Regular School No Elementary PK 05 2021   pk_12_total 46 173 387   * 62         21                             693 46 173 387     62         21                       693
1315484 1315484 MD     school 2400480 15   Montgomery 240048000952 788 Wheaton Woods Elementary   Regular School No Elementary PK 05 2021   pk_12_total 15 127 302   * 35         14                             494 15 127 302     35         14                       494
1315448 1315448 MD     school 2400480 15   Montgomery 240048000951 782 Wheaton High   Regular School No High 09 12 2021   pk_12_total 216 461 1274   * 268     *   57                             2280 216 461 1274     268         57                       2280
1317921 1317921 MD     school 2400690 22   Wicomico 240069001318 1501 Westside Primary   Regular School No Elementary PK 01 2021   pk_12_total 109 24 22   * *         19                             181 109 24 22               19                       181
1317926 1317926 MD     school 2400690 22   Wicomico 240069001149 1502 Westside Intermediate   Regular School No Elementary 02 05 2021   pk_12_total 229 67 27   * *         34                             363 229 67 27               34                       363
1318724 1318724 MD     school 2400090 30   Baltimore City 240009000331 225 Westport Academy   Regular School No Elementary PK 08 2021   pk_12_total 11 251 14     *         *                             284 11 251 14                                       284
1310819 1310819 MD     school 2400120 3   Baltimore County 240012000495 103 Westowne Elementary   Regular School No Elementary PK 05 2021   pk_12_total 226 241 50   * 87     *   50                             659 226 241 50     87         50                       659
1314944 1314944 MD     school 2400480 15   Montgomery 240048000950 504 Westover Elementary   Regular School No Elementary PK 05 2021   pk_12_total 57 105 69     28     *   21                             281 57 105 69     28         21                       281
1312247 1312247 MD     school 2400210 6   Carroll 240021000553 703 Westminster West Middle   Regular School No Middle 06 08 2021   pk_12_total 671 59 108   * 28     *   33                             904 671 59 108     28         33                       904
1312265 1312265 MD     school 2400210 6   Carroll 240021000552 707 Westminster High   Regular School No High 09 12 2021   pk_12_total 1242 70 84   * 56     *   59                             1515 1242 70 84     56         59                       1515
1312273 1312273 MD     school 2400210 6   Carroll 240021000551 710 Westminster Elementary   Regular School No Elementary PK 05 2021   pk_12_total 379 26 61     29     *   38                             535 379 26 61     29         38                       535
1312243 1312243 MD     school 2400210 6   Carroll 240021000550 701 Westminster East Middle   Regular School No Middle 06 08 2021   pk_12_total 538 59 83     16     *   33                             730 538 59 83     16         33                       730
1309856 1309856 MD     school 2400030 1   Allegany 240003000007 802 Westmar Middle   Regular School No Middle 06 08 2021   pk_12_total 241   *               *                             256 241                                           256
1314854 1314854 MD     school 2400480 15   Montgomery 240048000949 412 Westland Middle   Regular School No Middle 06 08 2021   pk_12_total 434 60 140   * 63         62                             764 434 60 140     63         62                       764
1312701 1312701 MD     school 2400270 8   Charles 240027000144 619 Westlake High School   Regular School No High 09 12 2021   pk_12_total 68 877 89   * 42     *   57                             1139 68 877 89     42         57                       1139
1309852 1309852 MD     school 2400030 1   Allegany 240003000033 801 Westernport Elementary   Regular School No Elementary PK 05 2021   pk_12_total 239 * *           *   10                             256 239                   10                       256
1310905 1310905 MD     school 2400120 3   Baltimore County 240012000248 175 Western School of Technology   Career and Technical School No High 09 12 2021   pk_12_total 136 514 48   * 190     *   28                             920 136 514 48     190         28                       920
1319266 1319266 MD     school 2400090 30   Baltimore City 240009000330 407 Western High   Regular School No High 09 12 2021   pk_12_total 56 1090 68   * 11     *   *                             1236 56 1090 68     11                                 1236
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
1310811 1310811 MD     school 2400120 3   Baltimore County 240012000936 102 Westchester Elementary   Regular School No Elementary PK 05 2021   pk_12_total 415 71 55   * 93         31                             668 415 71 55     93         31                       668
1314842 1314842 MD     school 2400480 15   Montgomery 240048000948 408 Westbrook Elementary   Regular School No Elementary PK 05 2021   pk_12_total 234 * 48   * 18         20                             331 234   48     18         20                       331
1311387 1311387 MD     school 2400120 3   Baltimore County 240012001696 925 West Towson Elementary   Regular School No Elementary KG 05 2021   pk_12_total 288 43 22   * 38         43                             435 288 43 22     38         43                       435
1309823 1309823 MD     school 2400030 1   Allegany 240003000032 603 West Side Elementary   Regular School No Elementary PK 05 2021   pk_12_total 240 22 *   * *         47                             319 240 22                 47                       319
1317870 1317870 MD     school 2400690 22   Wicomico 240069001317 909 West Salisbury   Regular School No Elementary PK 02 2021   pk_12_total 50 169 50   * 12         23                             307 50 169 50     12         23                       307
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
1313943 1313943 MD     school 2400420 13   Howard 240042000760 302 West Friendship Elementary   Regular School No Elementary KG 05 2021   pk_12_total 225 22 20     83     *   25                             376 225 22 20     83         25                       376
1312951 1312951 MD     school 2400330 10   Frederick 240033000658 211 West Frederick Middle   Regular School No Middle 06 08 2021   pk_12_total 227 204 382   * 46     *   62                             925 227 204 382     46         62                       925
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
1311044 1311044 MD     school 2400120 3   Baltimore County 240012000492 304 Wellwood International School   Regular School No Elementary KG 05 2021   pk_12_total 81 308 42   * 46         16                             496 81 308 42     46         16                       496
1315426 1315426 MD     school 2400480 15   Montgomery 240048000946 777 Weller Road Elementary   Regular School No Elementary PK 05 2021   pk_12_total 21 40 567     33         16                             677 21 40 567     33         16                       677
1314574 1314574 MD     school 2400480 15   Montgomery 240048000945 235 Wayside Elementary   Regular School No Elementary PK 05 2021   pk_12_total 160 32 26     215         26                             459 160 32 26     215         26                       459
1318234 1318234 MD     school 2400090 30   Baltimore City 240009000329 51 Waverly Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 544 22   * *     *   *                             589   544 22                                       589
1313909 1313909 MD     school 2400420 13   Howard 240042090449 215 Waverly Elementary   Regular School No Elementary PK 05 2021   pk_12_total 276 62 33   * 475         48                             899 276 62 33     475         48                       899
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
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
1315047 1315047 MD     school 2400480 15   Montgomery 240048001525 545 Watkins Mill High   Regular School No High 09 12 2021   pk_12_total 103 418 876   * 153     *   44                             1597 103 418 876     153         44                       1597
1315132 1315132 MD     school 2400480 15   Montgomery 240048000944 561 Watkins Mill Elementary   Regular School No Elementary PK 05 2021   pk_12_total 25 182 463   * 48     *   26                             749 25 182 463     48         26                       749

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