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

✎ 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
1315476 1315476 MD     school 2400480 15   Montgomery 240048001446 787 A. Mario Loiederman Middle   Regular School No Middle 06 08 2021   pk_12_total 149 150 622   * 42         30                             996 149 150 622     42         30                       996
1318223 1318223 MD     school 2400090 30   Baltimore City 240009000143 50 Abbottston Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 334 18               *                             365   334 18                                       365
1313552 1313552 MD     school 2400390 12   Harford 240039000679 270 Aberdeen High   Regular School No High 09 12 2021   pk_12_total 498 576 140   10 85     *   125                             1441 498 576 140   10 85         125                       1441
1313547 1313547 MD     school 2400390 12   Harford 240039000678 265 Aberdeen Middle   Regular School No Middle 06 08 2021   pk_12_total 407 495 135   * 26     *   131                             1204 407 495 135     26         131                       1204
1313452 1313452 MD     school 2400390 12   Harford 240039000162 123 Abingdon Elementary   Regular School No Elementary PK 05 2021   pk_12_total 357 150 44   * 19     *   73                             649 357 150 44     19         73                       649
1319317 1319317 MD     school 2400090 30   Baltimore City 240009001381 427 Academy for College and Career Exploration   Regular School No High 06 12 2021   pk_12_total 44 556 99   * *     *   *                             715 44 556 99                                       715
1316512 1316512 MD     school 2400510 16   Prince George's 240051001704 1350 Academy of Health Sciences at PGCC   Regular School No High 09 12 2021   pk_12_total 22 388 57   * 56         *                             534 22 388 57     56                                 534
1313362 1313362 MD     school 2400360 11   Garrett 240036000662 1501 Accident Elementary   Regular School No Elementary PK 05 2021   pk_12_total 221   12               *                             242 221   12                                       242
1315839 1315839 MD     school 2400510 16   Prince George's 240051001686 509 Accokeek Academy   Regular School No Elementary KG 08 2021   pk_12_total 57 1150 216   * 66     12   38                             1543 57 1150 216     66     12   38                       1543
1319276 1319276 MD     school 2400090 30   Baltimore City 240009000236 413 Achievement Academy at Harbor City High   Alternative School No High 09 12 2021   pk_12_total * 350 20   *                                         372   350 20                                       372
1316795 1316795 MD     school 2400510 16   Prince George's 240051000965 1714 Adelphi Elementary   Regular School No Elementary PK 06 2021   pk_12_total 14 114 554   * 14         *                             702 14 114 554     14                                 702
1319117 1319117 MD     school 2400090 30   Baltimore City 240009001661 337 Afya Public Charter School   Regular School Yes Middle 08 08 2021   pk_12_total   105 *                                             112   105                                         112
1315489 1315489 MD     school 2400480 15   Montgomery 240048000773 789 Albert Einstein High   Regular School No High 09 12 2021   pk_12_total 462 336 916   * 117         83                             1921 462 336 916     117         83                       1921
1318519 1318519 MD     school 2400090 30   Baltimore City 240009000145 145 Alexander Hamilton Elementary   Regular School No Elementary PK 05 2021   pk_12_total   154                 *                             156   154                                         156
1309828 1309828 MD     school 2400030 1   Allegany 240003000001 606 Allegany High   Regular School No High 09 12 2021   pk_12_total 628 24 20   * 11     *   50                             736 628 24 20     11         50                       736
1315937 1315937 MD     school 2400510 16   Prince George's 240051000966 632 Allenwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 177 133   * *         *                             322   177 133                                       322
1315992 1315992 MD     school 2400510 16   Prince George's 240051001683 645 Andrew Jackson Academy   Regular School No Elementary PK 08 2021   pk_12_total * 427 50     *     *   *                             499   427 50                                       499
1310564 1310564 MD     school 2400060 2   Anne Arundel 240006000035 4092 Annapolis Elementary   Regular School No Elementary PK 05 2021   pk_12_total 26 120 38     *         *                             194 26 120 38                                       194
1310522 1310522 MD     school 2400060 2   Anne Arundel 240006000037 4013 Annapolis High   Regular School No High 09 12 2021   pk_12_total 638 547 835   * 51     *   60                             2134 638 547 835     51         60                       2134
1310531 1310531 MD     school 2400060 2   Anne Arundel 240006000036 4033 Annapolis Middle   Regular School No Middle 06 08 2021   pk_12_total 157 309 549   * 19     *   25                             1061 157 309 549     19         25                       1061
1315785 1315785 MD     school 2400510 16   Prince George's 240051000865 216 Annapolis Road Academy   Alternative School No Secondary 09 10 2021   pk_12_total   33 48     *         *                             83   33 48                                       83
1310232 1310232 MD     school 2400060 2   Anne Arundel 240006000899 2233 Anne Arundel Evening High   Alternative School No High 09 12 2021   pk_12_total 106 55 54     *         *                             227 106 55 54                                       227
1316382 1316382 MD     school 2400510 16   Prince George's 240051000969 1229 Apple Grove Elementary   Regular School No Elementary PK 06 2021   pk_12_total * 231 208   * 10     *                                 460   231 208     10                                 460
1311611 1311611 MD     school 2400120 3   Baltimore County 240012000341 1302 Arbutus Elementary   Regular School No Elementary PK 05 2021   pk_12_total 186 24 16   * 136         26                             390 186 24 16     136         26                       390
1311659 1311659 MD     school 2400120 3   Baltimore County 240012000342 1356 Arbutus Middle   Regular School No Middle 06 08 2021   pk_12_total 522 205 46   * 140     *   83                             1004 522 205 46     140         83                       1004
1315497 1315497 MD     school 2400480 15   Montgomery 240048001643 790 Arcola Elementary   Regular School No Elementary PK 05 2021   pk_12_total 26 134 485   * 38     *   16                             703 26 134 485     38         16                       703
1317004 1317004 MD     school 2400510 16   Prince George's 240051000970 2008 Ardmore Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 334 91     *     *   *                             434   334 91                                       434
1315625 1315625 MD     school 2400480 15   Montgomery 240048000409 823 Argyle Middle   Regular School No Middle 06 08 2021   pk_12_total 79 249 599   * 78         36                             1043 79 249 599     78         36                       1043
1318798 1318798 MD     school 2400090 30   Baltimore City 240009000146 234 Arlington Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 313 84               *                             405   313 84                                       405
1318877 1318877 MD     school 2400090 30   Baltimore City 240009000147 243 Armistead Gardens Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 154 75 518   * *         26                             780 154 75 518               26                       780
1310106 1310106 MD     school 2400060 2   Anne Arundel 240006000038 2052 Arnold Elementary   Regular School No Elementary KG 05 2021   pk_12_total 357 38 26   * 19         38                             481 357 38 26     19         38                       481
1315981 1315981 MD     school 2400510 16   Prince George's 240051000971 640 Arrowhead Elementary   Regular School No Elementary PK 05 2021   pk_12_total 13 241 117   * *         *                             376 13 241 117                                       376
1312668 1312668 MD     school 2400270 8   Charles 240027000582 612 Arthur Middleton Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 51 301 114     18     *   59                             545 51 301 114     18         59                       545
1318539 1318539 MD     school 2400090 30   Baltimore City 240009000148 164 Arundel Elementary   Regular School No Elementary PK 02 2021   pk_12_total * 425 11               *                             445   425 11                                       445
1310280 1310280 MD     school 2400060 2   Anne Arundel 240006000040 3013 Arundel High   Regular School No High 09 12 2021   pk_12_total 873 545 149   * 97     12   197                             1876 873 545 149     97     12   197                       1876
1310284 1310284 MD     school 2400060 2   Anne Arundel 240006000039 3023 Arundel Middle   Regular School No Middle 06 08 2021   pk_12_total 501 307 130   * 59     *   116                             1119 501 307 130     59         116                       1119
1314906 1314906 MD     school 2400480 15   Montgomery 240048000776 425 Ashburton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 343 143 162   * 159     *   87                             900 343 143 162     159         87                       900
1314131 1314131 MD     school 2400420 13   Howard 240042000718 603 Atholton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 206 112 52     35         46                             451 206 112 52     35         46                       451
1314006 1314006 MD     school 2400420 13   Howard 240042000719 509 Atholton High   Regular School No High 09 12 2021   pk_12_total 516 436 160   * 268         91                             1472 516 436 160     268         91                       1472
1319327 1319327 MD     school 2400090 30   Baltimore City 240009001387 430 Augusta Fells Savage Institute of Visual Arts   Regular School No High 09 12 2021   pk_12_total * 463 *   * *         *                             481   463                                         481
1316373 1316373 MD     school 2400510 16   Prince George's 240051000972 1221 Avalon Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 174 97   * *     *   *                             285   174 97                                       285
1310795 1310795 MD     school 2400120 3   Baltimore County 240012001711 77 BCDC Educational Center   Alternative School No High 09 12 2021   pk_12_total * 19 *                                             31   19                                         31
1316124 1316124 MD     school 2400510 16   Prince George's 240051000973 802 Baden Elementary   Regular School No Elementary PK 06 2021   pk_12_total 37 98 46   *           16                             198 37 98 46               16                       198
1312543 1312543 MD     school 2400240 7   Cecil 240024000556 704 Bainbridge Elementary   Regular School No Elementary PK 05 2021   pk_12_total 221 12 *   *           23                             265 221 12                 23                       265
1313535 1313535 MD     school 2400390 12   Harford 240039000680 212 Bakerfield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 137 126 69     *         42                             383 137 126 69               42                       383
1312976 1312976 MD     school 2400330 10   Frederick 240033090471 223 Ballenger Creek Elementary   Regular School No Elementary PK 05 2021   pk_12_total 197 138 128   * 66     *   67                             602 197 138 128     66         67                       602
1313245 1313245 MD     school 2400330 10   Frederick 240033090446 2305 Ballenger Creek Middle   Regular School No Middle 06 08 2021   pk_12_total 338 161 180   * 51     *   62                             800 338 161 180     51         62                       800
1319352 1319352 MD     school 2400090 30   Baltimore City 240009000150 480 Baltimore City College   Regular School No High 09 12 2021   pk_12_total 256 972 146   * 25     *   32                             1439 256 972 146     25         32                       1439
1319208 1319208 MD     school 2400090 30   Baltimore City 240009001736 375 Baltimore Collegiate School for Boys   Regular School Yes Middle 04 08 2021   pk_12_total   455 *   *       *   *                             466   455                                         466
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1311519 1311519 MD     school 2400120 3   Baltimore County 240012000349 1205 Berkshire Elementary   Regular School No Elementary PK 05 2021   pk_12_total 196 77 110   * *     *   29                             423 196 77 110               29                       423

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