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,383 ✖

grade ✖

  • pk_12_total · 1,383 ✖
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
1243358 1243358 MD     school 2400510 16   Prince George's 240051000966 632 Allenwood Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 254 168   * *         *                             435   254 168                                       435
1242029 1242029 MD     school 2400480 15   Montgomery 240048001451 239 Alternative Programs   Alternative School No High 07 12 2020   pk_12_total 10 63 43     *         *                             126 10 63 43                                       126
1243412 1243412 MD     school 2400510 16   Prince George's 240051001683 645 Andrew Jackson Academy   Regular School No Elementary PK 08 2020   pk_12_total * 423 60     *     *   *                             504   423 60                                       504
1238000 1238000 MD     school 2400060 2   Anne Arundel 240006000035 4092 Annapolis Elementary   Regular School No Elementary PK 05 2020   pk_12_total 37 133 41     *         *                             214 37 133 41                                       214
1237957 1237957 MD     school 2400060 2   Anne Arundel 240006000037 4013 Annapolis High   Regular School No High 09 12 2020   pk_12_total 635 560 790   * 50     *   62                             2103 635 560 790     50         62                       2103
1237966 1237966 MD     school 2400060 2   Anne Arundel 240006000036 4033 Annapolis Middle   Regular School No Middle 06 08 2020   pk_12_total 208 297 498   * 13     *   26                             1044 208 297 498     13         26                       1044
1243205 1243205 MD     school 2400510 16   Prince George's 240051000865 216 Annapolis Road Academy   Alternative School No Secondary 09 10 2020   pk_12_total   66 51               *                             120   66 51                                       120
1237670 1237670 MD     school 2400060 2   Anne Arundel 240006000899 2233 Anne Arundel Evening High   Alternative School No High 09 12 2020   pk_12_total 150 66 55   * *         22                             296 150 66 55               22                       296
1243801 1243801 MD     school 2400510 16   Prince George's 240051000969 1229 Apple Grove Elementary   Regular School No Elementary PK 06 2020   pk_12_total 11 261 224     12     *                                 512 11 261 224     12                                 512
1239056 1239056 MD     school 2400120 3   Baltimore County 240012000341 1302 Arbutus Elementary   Regular School No Elementary PK 05 2020   pk_12_total 201 24 13   * 138     *   25                             404 201 24 13     138         25                       404
1239104 1239104 MD     school 2400120 3   Baltimore County 240012000342 1356 Arbutus Middle   Regular School No Middle 06 08 2020   pk_12_total 489 214 40   * 136     *   67                             951 489 214 40     136         67                       951
1242917 1242917 MD     school 2400480 15   Montgomery 240048001643 790 Arcola Elementary   Regular School No Elementary PK 05 2020   pk_12_total 27 148 518   * 42     *   *                             748 27 148 518     42                                 748
1244423 1244423 MD     school 2400510 16   Prince George's 240051000970 2008 Ardmore Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 340 82     *     *   *                             435   340 82                                       435
1243045 1243045 MD     school 2400480 15   Montgomery 240048000409 823 Argyle Middle   Regular School No Middle 06 08 2020   pk_12_total 72 256 582   * 88         25                             1024 72 256 582     88         25                       1024
1246236 1246236 MD     school 2400090 30   Baltimore City 240009000146 234 Arlington Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 307 81               *                             392   307 81                                       392
1246315 1246315 MD     school 2400090 30   Baltimore City 240009000147 243 Armistead Gardens Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 182 80 513   * 10         21                             809 182 80 513     10         21                       809
1237544 1237544 MD     school 2400060 2   Anne Arundel 240006000038 2052 Arnold Elementary   Regular School No Elementary KG 05 2020   pk_12_total 427 33 30   * 21     *   29                             543 427 33 30     21         29                       543
1243401 1243401 MD     school 2400510 16   Prince George's 240051000971 640 Arrowhead Elementary   Regular School No Elementary PK 05 2020   pk_12_total 16 266 119   * *         *                             406 16 266 119                                       406
1240120 1240120 MD     school 2400270 8   Charles 240027000582 612 Arthur Middleton Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 57 313 107     19         55                             551 57 313 107     19         55                       551
1245974 1245974 MD     school 2400090 30   Baltimore City 240009000148 164 Arundel Elementary   Regular School No Elementary PK 02 2020   pk_12_total * 502 12               *                             523   502 12                                       523
1237718 1237718 MD     school 2400060 2   Anne Arundel 240006000040 3013 Arundel High   Regular School No High 09 12 2020   pk_12_total 1089 595 177   * 127     12   198                             2200 1089 595 177     127     12   198                       2200
1237722 1237722 MD     school 2400060 2   Anne Arundel 240006000039 3023 Arundel Middle   Regular School No Middle 06 08 2020   pk_12_total 480 283 118   * 57     *   122                             1068 480 283 118     57         122                       1068
1242337 1242337 MD     school 2400480 15   Montgomery 240048000776 425 Ashburton Elementary   Regular School No Elementary KG 05 2020   pk_12_total 362 153 160   * 160     *   81                             922 362 153 160     160         81                       922
1241575 1241575 MD     school 2400420 13   Howard 240042000718 603 Atholton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 255 121 46     40     *   41                             504 255 121 46     40         41                       504
1241451 1241451 MD     school 2400420 13   Howard 240042000719 509 Atholton High   Regular School No High 09 12 2020   pk_12_total 580 369 137   * 287         85                             1460 580 369 137     287         85                       1460
1246782 1246782 MD     school 2400090 30   Baltimore City 240009001387 430 Augusta Fells Savage Institute of Visual Arts   Regular School No High 09 12 2020   pk_12_total * 421 *     *         *                             434   421                                         434
1243792 1243792 MD     school 2400510 16   Prince George's 240051000972 1221 Avalon Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 232 125   * *     *   *                             374   232 125                                       374
1238241 1238241 MD     school 2400120 3   Baltimore County 240012001711 77 BCDC Educational Center   Alternative School No High 09 12 2020   pk_12_total * 24 *                                             33   24                                         33
1243544 1243544 MD     school 2400510 16   Prince George's 240051000973 802 Baden Elementary   Regular School No Elementary PK 06 2020   pk_12_total 51 92 48   *           16                             209 51 92 48               16                       209
1239995 1239995 MD     school 2400240 7   Cecil 240024000556 704 Bainbridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 240 11 *   *       *   23                             284 240 11                 23                       284
1240982 1240982 MD     school 2400390 12   Harford 240039000680 212 Bakerfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 143 141 82     15         45                             426 143 141 82     15         45                       426
1240430 1240430 MD     school 2400330 10   Frederick 240033090471 223 Ballenger Creek Elementary   Regular School No Elementary PK 05 2020   pk_12_total 218 113 124   * 61     *   64                             586 218 113 124     61         64                       586
1240692 1240692 MD     school 2400330 10   Frederick 240033090446 2305 Ballenger Creek Middle   Regular School No Middle 06 08 2020   pk_12_total 362 172 168   * 60     *   47                             817 362 172 168     60         47                       817
1246807 1246807 MD     school 2400090 30   Baltimore City 240009000150 480 Baltimore City College   Regular School No High 09 12 2020   pk_12_total 254 970 126   * 24     *   21                             1402 254 970 126     24         21                       1402
1246665 1246665 MD     school 2400090 30   Baltimore City 240009001736 375 Baltimore Collegiate School for Boys   Regular School Yes Middle 04 08 2020   pk_12_total * 421 *   *           *                             432   421                                         432
1246686 1246686 MD     school 2400090 30   Baltimore City 240009001703 382 Baltimore Design School   Regular School No High 06 12 2020   pk_12_total 18 477 12   * *         *                             511 18 477 12                                       511
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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