enrollments

Data source: Big Local News · About: Big Local

1,398 rows where grade = "pk_12_total", state = "MD" and year = 2020 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 1,298 ✖

grade ✖

  • pk_12_total · 1,298 ✖
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
1238964 1238964 MD     school 2400120 3   Baltimore County 240012000349 1205 Berkshire Elementary   Regular School No Elementary PK 05 2020   pk_12_total 218 74 147   * *     *   31                             484 218 74 147               31                       484
1245405 1245405 MD     school 2400720 23   Worcester 240072001323 311 Berlin Intermediate   Regular School No Middle 04 06 2020   pk_12_total 584 63 73   * 19         59                             799 584 63 73     19         59                       799
1240173 1240173 MD     school 2400270 8   Charles 240027000805 622 Berry Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 58 443 83   * 63     *   60                             717 58 443 83     63         60                       717
1244507 1244507 MD     school 2400510 16   Prince George's 240051001272 2109 Berwyn Heights Elementary   Regular School No Elementary KG 06 2020   pk_12_total 53 81 302     30         *                             473 53 81 302     30                                 473
1245140 1245140 MD     school 2400660 21   Washington 240066001253 1701 Bester Elementary   Regular School No Elementary PK 05 2020   pk_12_total 210 145 90   * *         121                             570 210 145 90               121                       570
1242252 1242252 MD     school 2400480 15   Montgomery 240048000785 401 Bethesda Elementary   Regular School No Elementary KG 05 2020   pk_12_total 339 51 99     123         53                             665 339 51 99     123         53                       665
1242269 1242269 MD     school 2400480 15   Montgomery 240048000784 406 Bethesda-Chevy Chase High   Regular School No High 09 12 2020   pk_12_total 1300 322 388   * 121     *   120                             2257 1300 322 388     121         120                       2257
1241963 1241963 MD     school 2400480 15   Montgomery 240048000786 226 Beverly Farms Elementary   Regular School No Elementary KG 05 2020   pk_12_total 261 45 52   * 190         36                             585 261 45 52     190         36                       585
1240206 1240206 MD     school 2400270 8   Charles 240027001757 627 Billingsley Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 95 480 61   * 26     *   61                             725 95 480 61     26         61                       725
1243162 1243162 MD     school 2400510 16   Prince George's 240051000985 205 Bladensburg Elementary   Regular School No Elementary PK 06 2020   pk_12_total 17 209 557   * *     *   *                             795 17 209 557                                       795
1243167 1243167 MD     school 2400510 16   Prince George's 240051000987 208 Bladensburg High   Regular School No High 09 12 2020   pk_12_total 25 477 1389   * 30     *   *                             1936 25 477 1389     30                                 1936
1246629 1246629 MD     school 2400090 30   Baltimore City 240009001675 364 Bluford Drew Jemison STEM Academy West   Regular School No High 06 12 2020   pk_12_total * 219 *   *                                         227   219                                         227
1237567 1237567 MD     school 2400060 2   Anne Arundel 240006000046 2082 Bodkin Elementary   Regular School No Elementary KG 05 2020   pk_12_total 485 10 35     *         25                             557 485 10 35               25                       557
1239849 1239849 MD     school 2400240 7   Cecil 240024000558 204 Bohemia Manor High   Regular School No High 09 12 2020   pk_12_total 539 39 42   * *         25                             647 539 39 42               25                       647
1239861 1239861 MD     school 2400240 7   Cecil 240024000791 206 Bohemia Manor Middle   Regular School No Middle 06 08 2020   pk_12_total 385 34 43   * *     *   28                             495 385 34 43               28                       495
1241674 1241674 MD     school 2400420 13   Howard 240042001507 620 Bollman Bridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 161 295 189     67     *   51                             765 161 295 189     67         51                       765
1243639 1243639 MD     school 2400510 16   Prince George's 240051000988 1011 Bond Mill Elementary   Regular School No Elementary KG 05 2020   pk_12_total 92 238 100   * 39     *   32                             507 92 238 100     39         32                       507
1241270 1241270 MD     school 2400420 13   Howard 240042001172 108 Bonnie Branch Middle   Regular School No Middle 06 08 2020   pk_12_total 257 168 108   * 128         41                             703 257 168 108     128         41                       703
1245919 1245919 MD     school 2400090 30   Baltimore City 240009000160 130 Booker T. Washington Middle   Regular School No Middle 06 08 2020   pk_12_total * 234 *                                             242   234                                         242
1245061 1245061 MD     school 2400660 21   Washington 240066001254 603 Boonsboro Elementary   Regular School No Elementary PK 05 2020   pk_12_total 564 16 21     *     *   17                             622 564 16 21               17                       622
1245049 1245049 MD     school 2400660 21   Washington 240066001256 601 Boonsboro High   Regular School No High 09 12 2020   pk_12_total 807 12 30   * 21         31                             902 807 12 30     21         31                       902
1245053 1245053 MD     school 2400660 21   Washington 240066001255 602 Boonsboro Middle   Regular School No Middle 06 08 2020   pk_12_total 602 29 26   * 18         26                             702 602 29 26     18         26                       702
1244011 1244011 MD     school 2400510 16   Prince George's 240051000990 1423 Bowie High   Regular School No High 09 12 2020   pk_12_total 240 1645 359   * 84     *   90                             2428 240 1645 359     84         90                       2428
1243285 1243285 MD     school 2400510 16   Prince George's 240051000991 606 Bradbury Heights Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 395 90     *     *   *                             496   395 90                                       496
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
1242283 1242283 MD     school 2400480 15   Montgomery 240048000787 410 Bradley Hills Elementary   Regular School No Elementary KG 05 2020   pk_12_total 372 13 37     86         58                             566 372 13 37     86         58                       566
1243669 1243669 MD     school 2400510 16   Prince George's 240051000992 1101 Brandywine Elementary   Regular School No Elementary KG 05 2020   pk_12_total 12 323 53   * *         16                             412 12 323 53               16                       412
1242183 1242183 MD     school 2400480 15   Montgomery 240048090450 335 Briggs Chaney Middle   Regular School No Middle 06 08 2020   pk_12_total 64 504 236     98     *   33                             936 64 504 236     98         33                       936
1240817 1240817 MD     school 2400360 11   Garrett 240036000664 1707 Broad Ford Elementary   Regular School No Elementary PK 05 2020   pk_12_total 561 * *               *                             582 561                                           582
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
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
1242449 1242449 MD     school 2400480 15   Montgomery 240048090451 518 Brooke Grove Elementary   Regular School No Elementary PK 05 2020   pk_12_total 175 134 65   * 59         30                             464 175 134 65     59         30                       464
1242996 1242996 MD     school 2400480 15   Montgomery 240048000789 807 Brookhaven Elementary   Regular School No Elementary PK 05 2020   pk_12_total 37 132 243     41     *   12                             467 37 132 243     41         12                       467
1237389 1237389 MD     school 2400060 2   Anne Arundel 240006000049 1092 Brooklyn Park Elementary   Regular School No Elementary PK 05 2020   pk_12_total 199 108 104   * *         30                             450 199 108 104               30                       450
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
1242549 1242549 MD     school 2400480 15   Montgomery 240048000792 559 Brown Station Elementary   Regular School No Elementary PK 05 2020   pk_12_total 53 172 310   * 77         19                             636 53 172 310     77         19                       636
1240749 1240749 MD     school 2400330 10   Frederick 240033000626 2504 Brunswick Elementary   Regular School No Elementary PK 05 2020   pk_12_total 535 68 93   * 17     *   45                             762 535 68 93     17         45                       762
1240741 1240741 MD     school 2400330 10   Frederick 240033000627 2503 Brunswick High   Regular School No High 09 12 2020   pk_12_total 604 50 74   * 13         50                             792 604 50 74     13         50                       792
1240753 1240753 MD     school 2400330 10   Frederick 240033001409 2525 Brunswick Middle   Regular School No Middle 06 08 2020   pk_12_total 403 44 74   * 10     *   40                             573 403 44 74     10         40                       573
1241459 1241459 MD     school 2400420 13   Howard 240042000720 510 Bryant Woods Elementary   Regular School No Elementary PK 05 2020   pk_12_total 94 244 56   * 15     *   37                             448 94 244 56     15         37                       448
1244499 1244499 MD     school 2400510 16   Prince George's 240051000993 2108 Buck Lodge Middle   Regular School No Middle 06 08 2020   pk_12_total 14 106 1159   * 13     *   *                             1302 14 106 1159     13                                 1302
1245433 1245433 MD     school 2400720 23   Worcester 240072001325 901 Buckingham Elementary   Regular School No Elementary PK 04 2020   pk_12_total 296 131 70     *         55                             560 296 131 70               55                       560
1241358 1241358 MD     school 2400420 13   Howard 240042000173 216 Burleigh Manor Middle School   Regular School No Middle 06 08 2020   pk_12_total 242 85 34   * 404         41                             811 242 85 34     404         41                       811
1242310 1242310 MD     school 2400480 15   Montgomery 240048000793 419 Burning Tree Elementary   Regular School No Elementary KG 05 2020   pk_12_total 263 36 46     97     *   26                             469 263 36 46     97         26                       469
1242122 1242122 MD     school 2400480 15   Montgomery 240048090452 309 Burnt Mills Elementary   Regular School No Elementary PK 05 2020   pk_12_total 38 336 149   * 29         24                             578 38 336 149     29         24                       578
1242077 1242077 MD     school 2400480 15   Montgomery 240048000794 302 Burtonsville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 40 358 110   * 70     *   23                             604 40 358 110     70         23                       604
1241432 1241432 MD     school 2400420 13   Howard 240042000721 406 Bushy Park Elementary   Regular School No Elementary PK 05 2020   pk_12_total 455 32 26   * 90     *   31                             638 455 32 26     90         31                       638
1240713 1240713 MD     school 2400330 10   Frederick 240033001748 2308 Butterfly Ridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 147 201 274     22     *   30                             675 147 201 274     22         30                       675
1243527 1243527 MD     school 2400510 16   Prince George's 240051001384 723 C. Elizabeth Rieg Regional Center   Special Education School No Other KG 12 2020   pk_12_total 13 88 12     *                                       115 13 88 12                                       115
1241113 1241113 MD     school 2400390 12   Harford 240039001380 385 C. Milton Wright High   Regular School No High 09 12 2020   pk_12_total 1059 97 68   * 82     *   51                             1363 1059 97 68     82         51                       1363
1240161 1240161 MD     school 2400270 8   Charles 240027000380 620 C. Paul Barnhart Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 21 447 98   * 31         50                             648 21 447 98     31         50                       648
1242647 1242647 MD     school 2400480 15   Montgomery 240048001526 606 Cabin John Middle School   Regular School No Middle 06 08 2020   pk_12_total 408 120 84   * 365         62                             1040 408 120 84     365         62                       1040
1246380 1246380 MD     school 2400090 30   Baltimore City 240009000163 251 Callaway Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 282 14     *         *                             303   282 14                                       303
1239417 1239417 MD     school 2400150 4   Calvert 240015000509 206 Calvert Country School   Special Education School No Other 03 12 2020   pk_12_total 29 * *   * *         *                             46 29                                           46
1239512 1239512 MD     school 2400150 4   Calvert 240015001344 500 Calvert County Alternative School   Alternative School No High 09 12 2020   pk_12_total * * *                                             *                                              
1239425 1239425 MD     school 2400150 4   Calvert 240015000517 207 Calvert Elementary   Regular School No Elementary PK 05 2020   pk_12_total 326 95 27   * *         63                             516 326 95 27               63                       516
1240016 1240016 MD     school 2400240 7   Cecil 240024000559 904 Calvert Elementary   Regular School No Elementary PK 05 2020   pk_12_total 406   17   *           *                             432 406   17                                       432
1239446 1239446 MD     school 2400150 4   Calvert 240015000508 213 Calvert High   Regular School No High 09 12 2020   pk_12_total 737 224 81   * 21     *   93                             1161 737 224 81     21         93                       1161
1239405 1239405 MD     school 2400150 4   Calvert 240015000507 201 Calvert Middle   Regular School No Middle 06 08 2020   pk_12_total 359 138 48   * 10         43                             601 359 138 48     10         43                       601
1243105 1243105 MD     school 2400510 16   Prince George's 240051000995 105 Calverton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 14 264 529   * 37     *   *                             853 14 264 529     37                                 853
1245782 1245782 MD     school 2400090 30   Baltimore City 240009000164 75 Calverton Elementary/Middle   Regular School No Elementary KG 08 2020   pk_12_total * 332 15     *         *                             358   332 15                                       358
1246402 1246402 MD     school 2400090 30   Baltimore City 240009001390 256 Calvin M. Rodwell Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 681 35   * *         *                             729   681 35                                       729
1240333 1240333 MD     school 2400300 9   Dorchester 240030000612 713 Cambridge-South Dorchester High School   Regular School No High 09 12 2020   pk_12_total 279 344 62   * 13         45                             745 279 344 62     13         45                       745
1238213 1238213 MD     school 2400120 3   Baltimore County 240012000012 62 Campfield Early Childhood Center   Regular School No Elementary PK KG 2020   pk_12_total 27 273 64   * 25         19                             410 27 273 64     25         19                       410
1242399 1242399 MD     school 2400480 15   Montgomery 240048000796 508 Candlewood Elementary   Regular School No Elementary KG 05 2020   pk_12_total 178 59 60     67     *   22                             387 178 59 60     67         22                       387
1242130 1242130 MD     school 2400480 15   Montgomery 240048000797 310 Cannon Road Elementary   Regular School No Elementary PK 05 2020   pk_12_total 21 141 195   * 38         14                             412 21 141 195     38         14                       412
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
1244302 1244302 MD     school 2400510 16   Prince George's 240051000997 1812 Capitol Heights Elementary   Regular School No Elementary PK 05 2020   pk_12_total 27 254 45   * *     *   *                             336 27 254 45                                       336
1241818 1241818 MD     school 2400480 15   Montgomery 240048001523 111 Captain James E. Daly Elementary   Regular School No Elementary PK 05 2020   pk_12_total 31 207 324     41         15                             618 31 207 324     41         15                       618
1244711 1244711 MD     school 2400600 18   Saint Mary's 240060001732 308 Captain Walter Francis Duke Elementary   Regular School No Elementary PK 05 2020   pk_12_total 438 41 23   * 16         43                             562 438 41 23     16         43                       562
1242643 1242643 MD     school 2400480 15   Montgomery 240048000798 604 Carderock Springs Elementary   Regular School No Elementary KG 05 2020   pk_12_total 222 12 41   * 60     *   29                             366 222 12 41     60         29                       366
1244574 1244574 MD     school 2400510 16   Prince George's 240051001755 2218 Career and Technical Education Evening High   Career and Technical School No Secondary 11 11 2020   pk_12_total   * 12   *           *                             15     12                                       15
1241934 1241934 MD     school 2400480 15   Montgomery 240048000799 215 Carl Sandburg Center   Special Education School No Elementary KG 05 2020   pk_12_total 17 36 33     10         *                             97 17 36 33     10                                 97
1244294 1244294 MD     school 2400510 16   Prince George's 240051000998 1811 Carmody Hills Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 308 108               *                             423   308 108                                       423
1238901 1238901 MD     school 2400120 3   Baltimore County 240012000351 1106 Carney Elementary   Regular School No Elementary PK 05 2020   pk_12_total 200 318 26   * 55     *   36                             638 200 318 26     55         36                       638
1244190 1244190 MD     school 2400510 16   Prince George's 240051000999 1711 Carole Highlands Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 71 425     10         *                             515   71 425     10                                 515
1238002 1238002 MD     school 2400060 2   Anne Arundel 240006001746 4102 Carrie Weedon Early Education Center   Regular School No Prekindergarten PK PK 2020   pk_12_total 36 * 17     *                                       61 36   17                                       61
1240460 1240460 MD     school 2400330 10   Frederick 240033001712 228 Carroll Creek Montessori Public Charter   Regular School Yes Elementary PK 08 2020   pk_12_total 199 36 56   * 11         15                             318 199 36 56     11         15                       318
1238871 1238871 MD     school 2400120 3   Baltimore County 240012000352 1001 Carroll Manor Elementary   Regular School No Elementary KG 05 2020   pk_12_total 346 * 13     *         18                             389 346   13               18                       389
1240357 1240357 MD     school 2400330 10   Frederick 240033000628 108 Carroll Manor Elementary   Regular School No Elementary PK 05 2020   pk_12_total 411 55 70   * 16     *   21                             577 411 55 70     16         21                       577
1239744 1239744 MD     school 2400210 6   Carroll 240021000527 712 Carroll Springs School   Special Education School No Other PK 12 2020   pk_12_total 26 * *     *                                       33 26                                           33
1244397 1244397 MD     school 2400510 16   Prince George's 240051001000 2005 Carrollton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 10 208 392     12     *                                 623 10 208 392     12                                 623
1239646 1239646 MD     school 2400210 6   Carroll 240021000529 506 Carrolltowne Elementary   Regular School No Elementary PK 05 2020   pk_12_total 472 13 30   * 44     *   29                             591 472 13 30     44         29                       591
1244864 1244864 MD     school 2400570 19   Somerset 240057001535 705 Carter G Woodson Elementary   Regular School No Elementary PK 05 2020   pk_12_total 287 150 57     *         38                             536 287 150 57               38                       536
1246802 1246802 MD     school 2400090 30   Baltimore City 240009000168 454 Carver Vocational-Technical High   Career and Technical School No High 09 12 2020   pk_12_total * 859 13   * *         *                             885   859 13                                       885
1245124 1245124 MD     school 2400660 21   Washington 240066001258 1401 Cascade Elementary   Regular School No Elementary PK 05 2020   pk_12_total 139 * *     *         *                             150 139                                           150
1237344 1237344 MD     school 2400030 1   Allegany 240003001338 2901 Cash Valley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 242 13 *   * *         12                             279 242 13                 12                       279
1242412 1242412 MD     school 2400480 15   Montgomery 240048000800 511 Cashell Elementary   Regular School No Elementary PK 05 2020   pk_12_total 137 60 79     22         42                             340 137 60 79     22         42                       340
1243985 1243985 MD     school 2400510 16   Prince George's 240051001001 1414 Catherine T. Reed Elementary   Regular School No Elementary PK 05 2020   pk_12_total 20 358 104   * 15     *   *                             508 20 358 104     15                                 508
1240633 1240633 MD     school 2400330 10   Frederick 240033000629 1509 Catoctin High   Regular School No High 09 12 2020   pk_12_total 672 * 38   * *     *   22                             749 672   38               22                       749
1238218 1238218 MD     school 2400120 3   Baltimore County 240012000436 69 Catonsville Center for Alternative Studies   Alternative School No High 09 12 2020   pk_12_total * 45 *     *         *                             55   45                                         55
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
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
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
1245456 1245456 MD     school 2400090 30   Baltimore City 240009000169 7 Cecil Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 384 *           *   *                             391   384                                         391
1239922 1239922 MD     school 2400240 7   Cecil 240024000560 401 Cecil Manor Elementary   Regular School No Elementary PK 05 2020   pk_12_total 191 108 61     *         47                             408 191 108 61               47                       408
1239844 1239844 MD     school 2400240 7   Cecil 240024000562 104 Cecilton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 244 16 46   *           12                             319 244 16 46               12                       319
1245426 1245426 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2020   pk_12_total 28 19 *     *         *                             55 28 19                                         55
1242695 1242695 MD     school 2400480 15   Montgomery 240048000801 703 Cedar Grove Elementary   Regular School No Elementary PK 05 2020   pk_12_total 105 65 47   * 179         21                             418 105 65 47     179         21                       418

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