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

grade ✖

  • pk_12_total · 1,398 ✖
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
1242896 1242896 MD     school 2400480 15   Montgomery 240048001446 787 A. Mario Loiederman Middle   Regular School No Middle 06 08 2020   pk_12_total 142 154 626   * 43         30                             999 142 154 626     43         30                       999
1245647 1245647 MD     school 2400090 30   Baltimore City 240009000143 50 Abbottston Elementary   Regular School No Elementary PK 05 2020   pk_12_total 10 373 19     *     *   *                             409 10 373 19                                       409
1240999 1240999 MD     school 2400390 12   Harford 240039000679 270 Aberdeen High   Regular School No High 09 12 2020   pk_12_total 517 543 145   * 91     *   119                             1431 517 543 145     91         119                       1431
1240994 1240994 MD     school 2400390 12   Harford 240039000678 265 Aberdeen Middle   Regular School No Middle 06 08 2020   pk_12_total 411 488 131   * 26     *   139                             1203 411 488 131     26         139                       1203
1240899 1240899 MD     school 2400390 12   Harford 240039000162 123 Abingdon Elementary   Regular School No Elementary PK 05 2020   pk_12_total 416 161 55   * 24     *   66                             724 416 161 55     24         66                       724
1246772 1246772 MD     school 2400090 30   Baltimore City 240009001381 427 Academy for College and Career Exploration   Regular School No High 06 12 2020   pk_12_total 29 500 74   * *     *   *                             616 29 500 74                                       616
1243932 1243932 MD     school 2400510 16   Prince George's 240051001704 1350 Academy of Health Sciences at PGCC   Regular School No High 09 12 2020   pk_12_total 22 394 70   * 66     *   *                             563 22 394 70     66                                 563
1240809 1240809 MD     school 2400360 11   Garrett 240036000662 1501 Accident Elementary   Regular School No Elementary PK 05 2020   pk_12_total 266   *               *                             281 266                                           281
1243258 1243258 MD     school 2400510 16   Prince George's 240051001686 509 Accokeek Academy   Regular School No Elementary KG 08 2020   pk_12_total 63 1236 209   * 68     12   44                             1637 63 1236 209     68     12   44                       1637
1246731 1246731 MD     school 2400090 30   Baltimore City 240009000236 413 Achievement Academy at Harbor City High   Alternative School No High 09 12 2020   pk_12_total * 404 26   *                                         433   404 26                                       433
1244214 1244214 MD     school 2400510 16   Prince George's 240051000965 1714 Adelphi Elementary   Regular School No Elementary PK 06 2020   pk_12_total 17 128 615   * 11         *                             775 17 128 615     11                                 775
1246567 1246567 MD     school 2400090 30   Baltimore City 240009001661 337 Afya Public Charter School   Regular School Yes Middle 07 08 2020   pk_12_total   215 12               *                             228   215 12                                       228
1242909 1242909 MD     school 2400480 15   Montgomery 240048000773 789 Albert Einstein High   Regular School No High 09 12 2020   pk_12_total 407 321 882   * 139         65                             1818 407 321 882     139         65                       1818
1245954 1245954 MD     school 2400090 30   Baltimore City 240009000145 145 Alexander Hamilton Elementary   Regular School No Elementary PK 05 2020   pk_12_total   157 *               *                             160   157                                         160
1237267 1237267 MD     school 2400030 1   Allegany 240003000001 606 Allegany High   Regular School No High 09 12 2020   pk_12_total 631 21 15   * 11         41                             721 631 21 15     11         41                       721
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

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