enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pk_12_total · 2,691 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school ▼ school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1319229 1319229 MD     school 2400090 30   Baltimore City 240009001703 382 Baltimore Design School   Regular School No High 06 12 2021   pk_12_total 19 491 13   * *         *                             529 19 491 13                                       529
1239064 1239064 MD     school 2400120 3   Baltimore County 240012000344 1307 Baltimore Highlands Elementary   Regular School No Elementary PK 05 2020   pk_12_total 122 120 249   * 10         42                             551 122 120 249     10         42                       551
1311619 1311619 MD     school 2400120 3   Baltimore County 240012000344 1307 Baltimore Highlands Elementary   Regular School No Elementary PK 05 2021   pk_12_total 96 105 223   * *         33                             469 96 105 223               33                       469
1246553 1246553 MD     school 2400090 30   Baltimore City 240009001631 335 Baltimore International Academy   Regular School Yes Elementary KG 08 2020   pk_12_total 27 641 40     *     *   24                             736 27 641 40               24                       736
1319104 1319104 MD     school 2400090 30   Baltimore City 240009001631 335 Baltimore International Academy   Regular School Yes Elementary KG 08 2021   pk_12_total 36 645 43   * *     *   25                             752 36 645 43               25                       752
1246696 1246696 MD     school 2400090 30   Baltimore City 240009001752 385 Baltimore International Academy West   Regular School Yes Elementary 06 06 2020   pk_12_total   67 *               *                             69   67                                         69
1319241 1319241 MD     school 2400090 30   Baltimore City 240009001752 385 Baltimore International Academy West   Regular School Yes Elementary KG 07 2021   pk_12_total * 143 *               *                             150   143                                         150
1246608 1246608 MD     school 2400090 30   Baltimore City 240009001682 348 Baltimore Leadership School for Young Women   Regular School Yes High 06 12 2020   pk_12_total * 523 *   *           *                             539   523                                         539
1319158 1319158 MD     school 2400090 30   Baltimore City 240009001682 348 Baltimore Leadership School for Young Women   Regular School Yes High 06 12 2021   pk_12_total * 514 *   *           *                             531   514                                         531
1246564 1246564 MD     school 2400090 30   Baltimore City 240009001657 336 Baltimore Montessori Public Charter School   Regular School Yes Elementary PK 08 2020   pk_12_total 123 306 10   * *         13                             456 123 306 10               13                       456
1319115 1319115 MD     school 2400090 30   Baltimore City 240009001657 336 Baltimore Montessori Public Charter School   Regular School Yes Elementary PK 08 2021   pk_12_total 119 323 16   *           19                             479 119 323 16               19                       479
1246706 1246706 MD     school 2400090 30   Baltimore City 240009000151 403 Baltimore Polytechnic Institute   Regular School No High 09 12 2020   pk_12_total 258 1030 162   * 104     *   21                             1584 258 1030 162     104         21                       1584
1319251 1319251 MD     school 2400090 30   Baltimore City 240009000151 403 Baltimore Polytechnic Institute   Regular School No High 09 12 2021   pk_12_total 279 993 200   * 109     *   30                             1619 279 993 200     109         30                       1619
1246741 1246741 MD     school 2400090 30   Baltimore City 240009001391 415 Baltimore School for the Arts   Regular School No High 09 12 2020   pk_12_total 176 218 23   * 10     *   *                             438 176 218 23     10                                 438
1319286 1319286 MD     school 2400090 30   Baltimore City 240009001391 415 Baltimore School for the Arts   Regular School No High 09 12 2021   pk_12_total 161 229 27   * *     *   *                             433 161 229 27                                       433
1242317 1242317 MD     school 2400480 15   Montgomery 240048000779 420 Bannockburn Elementary   Regular School No Elementary KG 05 2020   pk_12_total 307 22 50     52         30                             461 307 22 50     52         30                       461
1314885 1314885 MD     school 2400480 15   Montgomery 240048000779 420 Bannockburn Elementary   Regular School No Elementary PK 05 2021   pk_12_total 257 20 40     50         34                             401 257 20 40     50         34                       401
1244097 1244097 MD     school 2400510 16   Prince George's 240051001697 1518 Barack Obama Elementary   Regular School No Elementary PK 05 2020   pk_12_total 14 680 40     *     *   12                             753 14 680 40               12                       753
1316678 1316678 MD     school 2400510 16   Prince George's 240051001697 1518 Barack Obama Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 675 41     *     *   13                             743   675 41               13                       743
1244945 1244945 MD     school 2400660 21   Washington 240066001674 40 Barbara Ingram School for the Arts   Regular School No High 09 12 2020   pk_12_total 224 24 30     *         17                             303 224 24 30               17                       303
1317520 1317520 MD     school 2400660 21   Washington 240066001674 40 Barbara Ingram School for the Arts   Regular School No High 09 12 2021   pk_12_total 240 35 24     14         20                             333 240 35 24     14         20                       333
1245680 1245680 MD     school 2400090 30   Baltimore City 240009000152 54 Barclay Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 392 64   * *     *   *                             477   392 64                                       477
1318256 1318256 MD     school 2400090 30   Baltimore City 240009000152 54 Barclay Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 345 64   * *     *   *                             425   345 64                                       425
1246621 1246621 MD     school 2400090 30   Baltimore City 240009001735 362 Bard High School Early College   Regular School No High 09 12 2020   pk_12_total 43 384 14     *     *   *                             446 43 384 14                                       446
1319163 1319163 MD     school 2400090 30   Baltimore City 240009001735 362 Bard High School Early College   Regular School No High 09 12 2021   pk_12_total 43 352 20     *     *   *                             421 43 352 20                                       421
1243778 1243778 MD     school 2400510 16   Prince George's 240051000974 1219 Barnaby Manor Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 326 157   * *         *                             501   326 157                                       501
1316360 1316360 MD     school 2400510 16   Prince George's 240051000974 1219 Barnaby Manor Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 301 138   * *         *                             459   301 138                                       459
1239433 1239433 MD     school 2400150 4   Calvert 240015001655 208 Barstow Elementary   Regular School No Elementary PK 05 2020   pk_12_total 432 103 39   * *     *   73                             658 432 103 39               73                       658
1311988 1311988 MD     school 2400150 4   Calvert 240015001655 208 Barstow Elementary   Regular School No Elementary PK 05 2021   pk_12_total 389 108 37     *     *   65                             605 389 108 37               65                       605
1239257 1239257 MD     school 2400120 3   Baltimore County 240012000345 1517 Battle Grove Elementary   Regular School No Elementary PK 05 2020   pk_12_total 177 71 53   * *     *   41                             346 177 71 53               41                       346
1311813 1311813 MD     school 2400120 3   Baltimore County 240012000345 1517 Battle Grove Elementary   Regular School No Elementary PK 05 2021   pk_12_total 155 74 58   * *     *   42                             334 155 74 58               42                       334
1239008 1239008 MD     school 2400120 3   Baltimore County 240012000346 1215 Battle Monument School   Special Education School No Other PK 12 2020   pk_12_total 30 19 *     *         *                             63 30 19                                         63
1311563 1311563 MD     school 2400120 3   Baltimore County 240012000346 1215 Battle Monument School   Special Education School No Other PK 12 2021   pk_12_total 31 19 *     *         *                             63 31 19                                         63
1239942 1239942 MD     school 2400240 7   Cecil 240024000557 510 Bay View Elementary   Regular School No Elementary PK 05 2020   pk_12_total 346 33 33     10     *   41                             464 346 33 33     10         41                       464
1312490 1312490 MD     school 2400240 7   Cecil 240024000557 510 Bay View Elementary   Regular School No Elementary PK 05 2021   pk_12_total 300 36 38     *         33                             414 300 36 38               33                       414
1245907 1245907 MD     school 2400090 30   Baltimore City 240009000154 124 Bay-Brook Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 17 265 143               *                             427 17 265 143                                       427
1318472 1318472 MD     school 2400090 30   Baltimore City 240009000154 124 Bay-Brook Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 71 335 204     *     *   10                             622 71 335 204               10                       622
1242225 1242225 MD     school 2400480 15   Montgomery 240048001747 346 Bayard Rustin Elementary   Regular School No Elementary PK 05 2020   pk_12_total 183 70 209   * 190         64                             719 183 70 209     190         64                       719
1314786 1314786 MD     school 2400480 15   Montgomery 240048001747 346 Bayard Rustin Elementary   Regular School No Elementary PK 05 2021   pk_12_total 182 64 200   * 175         61                             686 182 64 200     175         61                       686
1244624 1244624 MD     school 2400540 17   Queen Anne's 240054000202 403 Bayside Elementary School   Regular School No Elementary 03 05 2020   pk_12_total 326 18 32   * *         35                             420 326 18 32               35                       420
1317202 1317202 MD     school 2400540 17   Queen Anne's 240054000202 403 Bayside Elementary School   Regular School No Elementary 03 05 2021   pk_12_total 290 20 42     *         33                             393 290 20 42               33                       393
1239471 1239471 MD     school 2400150 4   Calvert 240015000505 302 Beach Elementary   Regular School No Elementary PK 05 2020   pk_12_total 343 55 42     *         75                             518 343 55 42               75                       518
1312026 1312026 MD     school 2400150 4   Calvert 240015000505 302 Beach Elementary   Regular School No Elementary PK 05 2021   pk_12_total 313 51 42   * *     *   73                             483 313 51 42               73                       483
1244372 1244372 MD     school 2400510 16   Prince George's 240051000975 1907 Beacon Heights Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 94 352   * *         *                             461   94 352                                       461
1316953 1316953 MD     school 2400510 16   Prince George's 240051000975 1907 Beacon Heights Elementary   Regular School No Elementary PK 06 2021   pk_12_total * 83 317   * *                                       412   83 317                                       412
1237336 1237336 MD     school 2400030 1   Allegany 240003000003 2801 Beall Elementary   Regular School No Elementary PK 05 2020   pk_12_total 386 * *   * *         30                             441 386                   30                       441
1241901 1241901 MD     school 2400480 15   Montgomery 240048000947 207 Beall Elementary   Regular School No Elementary PK 05 2020   pk_12_total 203 81 133     71     *   41                             531 203 81 133     71         41                       531
1309897 1309897 MD     school 2400030 1   Allegany 240003000003 2801 Beall Elementary   Regular School No Elementary PK 05 2021   pk_12_total 384 * *   * *         41                             445 384                   41                       445
1314459 1314459 MD     school 2400480 15   Montgomery 240048000947 207 Beall Elementary   Regular School No Elementary PK 05 2021   pk_12_total 204 82 114     74     *   41                             516 204 82 114     74         41                       516
1238972 1238972 MD     school 2400120 3   Baltimore County 240012000347 1206 Bear Creek Elementary   Regular School No Elementary PK 05 2020   pk_12_total 296 62 56   * 10         65                             495 296 62 56     10         65                       495
1311527 1311527 MD     school 2400120 3   Baltimore County 240012000347 1206 Bear Creek Elementary   Regular School No Elementary PK 05 2021   pk_12_total 264 71 62   * *         45                             457 264 71 62               45                       457
1245263 1245263 MD     school 2400690 22   Wicomico 240069001298 514 Beaver Run School   Regular School No Elementary PK 02 2020   pk_12_total 134 291 118   * *         53                             605 134 291 118               53                       605
1317839 1317839 MD     school 2400690 22   Wicomico 240069001298 514 Beaver Run School   Regular School No Elementary PK 02 2021   pk_12_total 125 263 97     *         56                             546 125 263 97               56                       546
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
1311037 1311037 MD     school 2400120 3   Baltimore County 240012000348 303 Bedford Elementary   Regular School No Elementary 01 05 2021   pk_12_total * 234 49   * *     *   18                             319   234 49               18                       319
1246337 1246337 MD     school 2400090 30   Baltimore City 240009000155 246 Beechfield Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 17 581 29   * *     *   *                             635 17 581 29                                       635
1318899 1318899 MD     school 2400090 30   Baltimore City 240009000155 246 Beechfield Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 26 578 30   * *     *   *                             643 26 578 30                                       643
1237283 1237283 MD     school 2400030 1   Allegany 240003000005 702 Bel Air Elementary   Regular School No Elementary PK 05 2020   pk_12_total 204 * *     *         11                             225 204                   11                       225
1241018 1241018 MD     school 2400390 12   Harford 240039000681 314 Bel Air Elementary   Regular School No Elementary PK 05 2020   pk_12_total 378 37 68   * 24         22                             531 378 37 68     24         22                       531
1309844 1309844 MD     school 2400030 1   Allegany 240003000005 702 Bel Air Elementary   Regular School No Elementary PK 05 2021   pk_12_total 202   *     *         *                             216 202                                           216
1313573 1313573 MD     school 2400390 12   Harford 240039000681 314 Bel Air Elementary   Regular School No Elementary PK 05 2021   pk_12_total 366 34 69   * 25         27                             522 366 34 69     25         27                       522
1241099 1241099 MD     school 2400390 12   Harford 240039000683 373 Bel Air High   Regular School No High 09 12 2020   pk_12_total 1163 123 102   * 113     *   56                             1560 1163 123 102     113         56                       1560
1313655 1313655 MD     school 2400390 12   Harford 240039000683 373 Bel Air High   Regular School No High 09 12 2021   pk_12_total 1146 121 102   * 119     *   63                             1557 1146 121 102     119         63                       1557
1241094 1241094 MD     school 2400390 12   Harford 240039001397 372 Bel Air Middle   Regular School No Middle 06 08 2020   pk_12_total 1062 107 89   * 101     *   69                             1435 1062 107 89     101         69                       1435
1313650 1313650 MD     school 2400390 12   Harford 240039001397 372 Bel Air Middle   Regular School No Middle 06 08 2021   pk_12_total 1067 113 90   * 106     *   61                             1441 1067 113 90     106         61                       1441
1242863 1242863 MD     school 2400480 15   Montgomery 240048000780 780 Bel Pre Elementary   Regular School No Elementary PK 02 2020   pk_12_total 35 185 335   * 32     *   19                             612 35 185 335     32         19                       612
1315443 1315443 MD     school 2400480 15   Montgomery 240048000780 780 Bel Pre Elementary   Regular School No Elementary PK 02 2021   pk_12_total 39 167 290   * 31     *   16                             549 39 167 290     31         16                       549
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
1309942 1309942 MD     school 2400060 2   Anne Arundel 240006000043 1082 Belle Grove Elementary   Regular School No Elementary PK 05 2021   pk_12_total 108 62 73   * 11         32                             287 108 62 73     11         32                       287
1241373 1241373 MD     school 2400420 13   Howard 240042001551 218 Bellows Spring Elementary   Regular School No Elementary PK 05 2020   pk_12_total 202 198 90   * 231         51                             776 202 198 90     231         51                       776
1313928 1313928 MD     school 2400420 13   Howard 240042001551 218 Bellows Spring Elementary   Regular School No Elementary PK 05 2021   pk_12_total 154 187 65   * 221     *   42                             676 154 187 65     221         42                       676
1242655 1242655 MD     school 2400480 15   Montgomery 240048000781 607 Bells Mill Elementary   Regular School No Elementary PK 05 2020   pk_12_total 276 80 58   * 181     *   45                             642 276 80 58     181         45                       642
1315233 1315233 MD     school 2400480 15   Montgomery 240048000781 607 Bells Mill Elementary   Regular School No Elementary PK 05 2021   pk_12_total 233 74 56   * 171     *   43                             579 233 74 56     171         43                       579
1242426 1242426 MD     school 2400480 15   Montgomery 240048000782 513 Belmont Elementary   Regular School No Elementary KG 05 2020   pk_12_total 231 32 39     24         22                             348 231 32 39     24         22                       348
1246113 1246113 MD     school 2400090 30   Baltimore City 240009000156 217 Belmont Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 254 *   *           *                             262   254                                         262
1315001 1315001 MD     school 2400480 15   Montgomery 240048000782 513 Belmont Elementary   Regular School No Elementary PK 05 2021   pk_12_total 211 36 45     26         22                             340 211 36 45     26         22                       340
1318673 1318673 MD     school 2400090 30   Baltimore City 240009000156 217 Belmont Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 231 *   *           *                             241   231                                         241
1243097 1243097 MD     school 2400510 16   Prince George's 240051000978 104 Beltsville Academy   Regular School No Elementary PK 08 2020   pk_12_total 72 190 823   * 54     *   18                             1162 72 190 823     54         18                       1162
1315677 1315677 MD     school 2400510 16   Prince George's 240051000978 104 Beltsville Academy   Regular School No Elementary PK 08 2021   pk_12_total 65 187 820   * 51         15                             1143 65 187 820     51         15                       1143
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
1310114 1310114 MD     school 2400060 2   Anne Arundel 240006000044 2062 Belvedere Elementary   Regular School No Elementary PK 05 2021   pk_12_total 354 30 45     15         39                             483 354 30 45     15         39                       483
1237560 1237560 MD     school 2400060 2   Anne Arundel 240006000045 2072 Benfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 350 * 21   * *         28                             410 350   21               28                       410
1310122 1310122 MD     school 2400060 2   Anne Arundel 240006000045 2072 Benfield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 334 * 23   * *         23                             392 334   23               23                       392
1244689 1244689 MD     school 2400600 18   Saint Mary's 240060001216 302 Benjamin Banneker Elementary   Regular School No Elementary PK 05 2020   pk_12_total 481 68 28     *         39                             625 481 68 28               39                       625
1317267 1317267 MD     school 2400600 18   Saint Mary's 240060001216 302 Benjamin Banneker Elementary   Regular School No Elementary PK 05 2021   pk_12_total 413 68 18     *         32                             536 413 68 18               32                       536
1242171 1242171 MD     school 2400480 15   Montgomery 240048000783 333 Benjamin Banneker Middle   Regular School No Middle 06 08 2020   pk_12_total 26 583 177   * 88         24                             900 26 583 177     88         24                       900
1314731 1314731 MD     school 2400480 15   Montgomery 240048000783 333 Benjamin Banneker Middle   Regular School No Middle 06 08 2021   pk_12_total 22 565 175   * 80         21                             864 22 565 175     80         21                       864
1243383 1243383 MD     school 2400510 16   Prince George's 240051001684 638 Benjamin D. Foulois Academy   Regular School No Elementary KG 08 2020   pk_12_total * 502 14   * *     *   12                             538   502 14               12                       538
1315963 1315963 MD     school 2400510 16   Prince George's 240051001684 638 Benjamin D. Foulois Academy   Regular School No Elementary KG 08 2021   pk_12_total * 500 16   * *     *   15                             540   500 16               15                       540
1246274 1246274 MD     school 2400090 30   Baltimore City 240009000157 239 Benjamin Franklin High School at Masonville Cove   Regular School No High 09 12 2020   pk_12_total 130 212 194   * *     *   *                             547 130 212 194                                       547
1318836 1318836 MD     school 2400090 30   Baltimore City 240009000157 239 Benjamin Franklin High School at Masonville Cove   Regular School No High 09 12 2021   pk_12_total 149 243 232   * *     *   *                             638 149 243 232                                       638
1243319 1243319 MD     school 2400510 16   Prince George's 240051001464 615 Benjamin Stoddert Middle   Regular School No Middle 06 08 2020   pk_12_total * 565 121     *     *                                 696   565 121                                       696
1315900 1315900 MD     school 2400510 16   Prince George's 240051001464 615 Benjamin Stoddert Middle   Regular School No Middle 06 08 2021   pk_12_total * 485 116     *     *   *                             614   485 116                                       614
1240124 1240124 MD     school 2400270 8   Charles 240027000583 613 Benjamin Stoddert Middle School   Regular School No Middle 06 08 2020   pk_12_total 52 574 93   * 25     *   64                             814 52 574 93     25         64                       814
1312672 1312672 MD     school 2400270 8   Charles 240027000583 613 Benjamin Stoddert Middle School   Regular School No Middle 06 08 2021   pk_12_total 52 590 110   * 25     *   56                             838 52 590 110     25         56                       838
1243498 1243498 MD     school 2400510 16   Prince George's 240051000982 714 Benjamin Tasker Middle School   Regular School No Middle 06 08 2020   pk_12_total 124 708 118   * 48     *   21                             1031 124 708 118     48         21                       1031
1316078 1316078 MD     school 2400510 16   Prince George's 240051000982 714 Benjamin Tasker Middle School   Regular School No Middle 06 08 2021   pk_12_total 129 718 127   * 53     *   28                             1068 129 718 127     53         28                       1068
1245330 1245330 MD     school 2400690 22   Wicomico 240069001299 1308 Bennett Middle   Regular School No Middle 06 08 2020   pk_12_total 389 337 122   * 35     *   71                             965 389 337 122     35         71                       965
1317906 1317906 MD     school 2400690 22   Wicomico 240069001299 1308 Bennett Middle   Regular School No Middle 06 08 2021   pk_12_total 380 351 137   * 34     *   68                             980 380 351 137     34         68                       980
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

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