enrollments

Data source: Big Local News · About: Big Local

19,213 rows where state = "MD" sorted by native_hawaiian_pacific_islander descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
1239715 1239715 MD     school 2400210 6   Carroll 240021000552 707 Westminster High   Regular School No High 09 12 2020   pk_12_total 1289 60 69     48     *   55                             1522 1289 60 69     48         55                       1522
1239723 1239723 MD     school 2400210 6   Carroll 240021000551 710 Westminster Elementary   Regular School No Elementary PK 05 2020   pk_12_total 382 24 65     29     *   36                             538 382 24 65     29         36                       538
1239731 1239731 MD     school 2400210 6   Carroll 240021000544 711 Robert Moton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 267 53 79   * *     *   30                             434 267 53 79               30                       434
1239751 1239751 MD     school 2400210 6   Carroll 240021000052 714 Friendship Valley Elementary   Regular School No Elementary KG 05 2020   pk_12_total 381 22 53     *     *   22                             488 381 22 53               22                       488
1239778 1239778 MD     school 2400210 6   Carroll 240021000542 801 North Carroll Middle   Regular School No Middle 06 08 2020   pk_12_total 554 12 34   * 14     *   11                             628 554 12 34     14         11                       628
1239798 1239798 MD     school 2400210 6   Carroll 240021002947 807 Shiloh Middle   Regular School No Middle 06 08 2020   pk_12_total 553 34 38     15     *   17                             658 553 34 38     15         17                       658
1239810 1239810 MD     school 2400210 6   Carroll 240021000555 906 Winfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 550 14 24   * *     *   11                             608 550 14 24               11                       608
1239823 1239823 MD     school 2400210 6   Carroll 240021001414 1304 Parr's Ridge Elementary   Regular School No Elementary PK 02 2020   pk_12_total 367 * 63     *     *   15                             459 367   63               15                       459
1239827 1239827 MD     school 2400210 6   Carroll 240021000538 1305 Mount Airy Elementary   Regular School No Elementary 03 05 2020   pk_12_total 352 14 70   * *     *   12                             460 352 14 70               12                       460
1239836 1239836 MD     school 2400210 6   Carroll 240021000546 1401 South Carroll High   Regular School No High 09 12 2020   pk_12_total 881 18 68   * 22     *   17                             1011 881 18 68     22         17                       1011
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
1239866 1239866 MD     school 2400240 7   Cecil 240024000568 302 Elkton High   Regular School No High 09 12 2020   pk_12_total 480 288 128   * 13     *   91                             1005 480 288 128     13         91                       1005
1239870 1239870 MD     school 2400240 7   Cecil 240024000567 303 Elkton Middle   Regular School No Middle 06 08 2020   pk_12_total 234 157 93   * *     *   73                             571 234 157 93               73                       571
1239890 1239890 MD     school 2400240 7   Cecil 240024000564 313 Cherry Hill Middle   Regular School No Middle 06 08 2020   pk_12_total 301 55 50           *   24                             431 301 55 50               24                       431
1239906 1239906 MD     school 2400240 7   Cecil 240024000581 316 Thomson Estates Elementary   Regular School No Elementary PK 05 2020   pk_12_total 214 116 88   * 13     *   59                             493 214 116 88     13         59                       493
1239926 1239926 MD     school 2400240 7   Cecil 240024000574 504 North East Middle   Regular School No Middle 06 08 2020   pk_12_total 634 57 52   * *     *   33                             786 634 57 52               33                       786
1239934 1239934 MD     school 2400240 7   Cecil 240024000573 506 North East Elementary   Regular School No Elementary PK 05 2020   pk_12_total 399 54 39   * *     *   45                             542 399 54 39               45                       542
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
1239950 1239950 MD     school 2400240 7   Cecil 240024000563 513 Charlestown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 196 35 *           *   15                             257 196 35                 15                       257
1239979 1239979 MD     school 2400240 7   Cecil 240024000578 701 Perryville Middle   Regular School No Middle 06 08 2020   pk_12_total 477 42 22   * *     *   44                             590 477 42 22               44                       590
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
1240000 1240000 MD     school 2400240 7   Cecil 240024000577 705 Perryville High   Regular School No High 09 12 2020   pk_12_total 661 39 41   * *     *   50                             801 661 39 41               50                       801
1240025 1240025 MD     school 2400270 8   Charles 240027000601 104 Milton M. Somers Middle School   Regular School No Middle 06 08 2020   pk_12_total 444 428 86   * 45     *   79                             1086 444 428 86     45         79                       1086
1240033 1240033 MD     school 2400270 8   Charles 240027000609 105 Walter J. Mitchell Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 387 103 63   * 14     *   55                             626 387 103 63     14         55                       626
1240038 1240038 MD     school 2400270 8   Charles 240027000596 106 La Plata High School   Regular School No High 09 12 2020   pk_12_total 750 225 57   * 33     *   88                             1159 750 225 57     33         88                       1159
1240043 1240043 MD     school 2400270 8   Charles 240027000600 108 Maurice J. McDonough High School   Regular School No High 09 12 2020   pk_12_total 287 438 95   * 20     *   60                             902 287 438 95     20         60                       902
1240071 1240071 MD     school 2400270 8   Charles 240027000604 503 Piccowaxen Middle School   Regular School No Middle 06 08 2020   pk_12_total 332 49 23   * *     *   34                             450 332 49 23               34                       450
1240084 1240084 MD     school 2400270 8   Charles 240027000607 605 Thomas Stone High School   Regular School No High 09 12 2020   pk_12_total 161 703 189   * 15     *   54                             1128 161 703 189     15         54                       1128
1240092 1240092 MD     school 2400270 8   Charles 240027000593 606 J. P. Ryon Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 66 411 112   * 11     *   56                             659 66 411 112     11         56                       659
1240096 1240096 MD     school 2400270 8   Charles 240027000595 608 John Hanson Middle School   Regular School No Middle 06 08 2020   pk_12_total 147 517 128   * 20     *   75                             893 147 517 128     20         75                       893
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
1240153 1240153 MD     school 2400270 8   Charles 240027000144 619 Westlake High School   Regular School No High 09 12 2020   pk_12_total 74 866 91   * 45     *   59                             1140 74 866 91     45         59                       1140
1240165 1240165 MD     school 2400270 8   Charles 240027000615 621 Mattawoman Middle School   Regular School No Middle 06 08 2020   pk_12_total 52 748 107   * 52     *   62                             1026 52 748 107     52         62                       1026
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
1240178 1240178 MD     school 2400270 8   Charles 240027001416 623 North Point High School   Regular School No High 09 12 2020   pk_12_total 295 1112 135   * 114     *   146                             1814 295 1112 135     114         146                       1814
1240186 1240186 MD     school 2400270 8   Charles 240027001565 624 William A. Diggs Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 94 523 58     30     *   66                             775 94 523 58     30         66                       775
1240190 1240190 MD     school 2400270 8   Charles 240027001647 625 Theodore G. Davis Middle School   Regular School No Middle 06 08 2020   pk_12_total 71 618 83   * 32     *   72                             885 71 618 83     32         72                       885
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
1240210 1240210 MD     school 2400270 8   Charles 240027000599 701 Matthew Henson Middle School   Regular School No Middle 06 08 2020   pk_12_total 92 552 80   * 19     *   64                             811 92 552 80     19         64                       811
1240218 1240218 MD     school 2400270 8   Charles 240027000592 703 J. C. Parks Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 70 368 84   * 20     *   61                             609 70 368 84     20         61                       609
1240222 1240222 MD     school 2400270 8   Charles 240027000589 705 General Smallwood Middle School   Regular School No Middle 06 08 2020   pk_12_total 201 247 23   * *     *   45                             527 201 247 23               45                       527
1240230 1240230 MD     school 2400270 8   Charles 240027001395 708 Robert D. Stethem Educational Center   Alternative School No High 06 12 2020   pk_12_total 25 53 *   *       *   *                             88 25 53                                         88
1240246 1240246 MD     school 2400270 8   Charles 240027000606 801 T. C. Martin Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 302 125 33   * *     *   55                             522 302 125 33               55                       522
1240251 1240251 MD     school 2400270 8   Charles 240027001727 802 St. Charles High School   Regular School No High 09 12 2020   pk_12_total 175 1005 90   11 29     *   97                             1410 175 1005 90   11 29         97                       1410
1240259 1240259 MD     school 2400270 8   Charles 240027000598 902 Malcolm Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 158 156 59     *     *   55                             436 158 156 59               55                       436
1240272 1240272 MD     school 2400270 8   Charles 240027000597 1002 Henry E. Lackey High School   Regular School No High 09 12 2020   pk_12_total 283 563 47   12 20     *   64                             990 283 563 47   12 20         64                       990
1240308 1240308 MD     school 2400300 9   Dorchester 240030000622 508 South Dorchester School   Regular School No Elementary PK 08 2020   pk_12_total 196 * 15     *     *   12                             231 196   15               12                       231
1240312 1240312 MD     school 2400300 9   Dorchester 240030001423 707 Mace's Lane Middle School   Regular School No Middle 06 08 2020   pk_12_total 72 400 55     *     *   41                             576 72 400 55               41                       576
1240349 1240349 MD     school 2400300 9   Dorchester 240030000614 1503 Hurlock Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 163 133 38     *     *   32                             374 163 133 38               32                       374
1240357 1240357 MD     school 2400330 10   Frederick 240033000628 108 Carroll Manor Elementary   Regular School No Elementary PK 05 2020   pk_12_total 411 55 70   * 16     *   21                             577 411 55 70     16         21                       577
1240365 1240365 MD     school 2400330 10   Frederick 240033001355 109 Tuscarora Elementary   Regular School No Elementary PK 05 2020   pk_12_total 211 177 206   * 54     *   60                             713 211 177 206     54         60                       713
1240393 1240393 MD     school 2400330 10   Frederick 240033000632 209 Frederick High   Regular School No High 09 12 2020   pk_12_total 384 375 561   * 116     *   65                             1508 384 375 561     116         65                       1508
1240401 1240401 MD     school 2400330 10   Frederick 240033000645 210 North Frederick Elementary   Regular School No Elementary PK 05 2020   pk_12_total 250 122 182     31     *   83                             669 250 122 182     31         83                       669
1240405 1240405 MD     school 2400330 10   Frederick 240033000658 211 West Frederick Middle   Regular School No Middle 06 08 2020   pk_12_total 242 229 374     47     *   52                             947 242 229 374     47         52                       947
1240410 1240410 MD     school 2400330 10   Frederick 240033000634 213 Gov. Thomas Johnson High   Regular School No High 09 12 2020   pk_12_total 615 390 542   * 83     *   92                             1730 615 390 542     83         92                       1730
1240414 1240414 MD     school 2400330 10   Frederick 240033001413 219 Monocacy Middle   Regular School No Middle 06 08 2020   pk_12_total 268 224 380   * 40     *   49                             969 268 224 380     40         49                       969
1240422 1240422 MD     school 2400330 10   Frederick 240033001521 222 Monocacy Elementary   Regular School No Elementary PK 05 2020   pk_12_total 167 177 190   * 17     *   53                             611 167 177 190     17         53                       611
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
1240434 1240434 MD     school 2400330 10   Frederick 240033001549 225 Gov. Thomas Johnson Middle   Regular School No Middle 06 08 2020   pk_12_total 258 104 124   * 31     *   31                             553 258 104 124     31         31                       553
1240445 1240445 MD     school 2400330 10   Frederick 240033001187 226 Monocacy Valley Montessori   Regular School Yes Elementary PK 08 2020   pk_12_total 193 32 30   * 25     *   18                             300 193 32 30     25         18                       300
1240449 1240449 MD     school 2400330 10   Frederick 240033001357 227 Crestwood Middle   Regular School No Middle 06 08 2020   pk_12_total 202 199 197   * 48     *   40                             691 202 199 197     48         40                       691
1240468 1240468 MD     school 2400330 10   Frederick 240033000640 311 Middletown Middle   Regular School No Middle 06 08 2020   pk_12_total 652 24 55   * 15     *   33                             784 652 24 55     15         33                       784
1240506 1240506 MD     school 2400330 10   Frederick 240033000616 713 Urbana High   Regular School No High 09 12 2020   pk_12_total 1082 164 221   * 276     *   99                             1851 1082 164 221     276         99                       1851
1240510 1240510 MD     school 2400330 10   Frederick 240033000392 714 Windsor Knolls Middle   Regular School No Middle 06 08 2020   pk_12_total 588 32 82     35     *   26                             764 588 32 82     35         26                       764
1240517 1240517 MD     school 2400330 10   Frederick 240033001429 715 Centerville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 452 99 139   * 206     *   73                             972 452 99 139     206         73                       972
1240521 1240521 MD     school 2400330 10   Frederick 240033001536 716 Urbana Middle   Regular School No Middle 06 08 2020   pk_12_total 548 73 123   * 203     *   67                             1021 548 73 123     203         67                       1021
1240536 1240536 MD     school 2400330 10   Frederick 240033000643 903 New Market Elementary   Regular School No Elementary PK 05 2020   pk_12_total 569 14 43   * 25     *   28                             684 569 14 43     25         28                       684
1240541 1240541 MD     school 2400330 10   Frederick 240033000638 912 Linganore High   Regular School No High 09 12 2020   pk_12_total 1131 22 97   * 12     *   46                             1311 1131 22 97     12         46                       1311
1240548 1240548 MD     school 2400330 10   Frederick 240033000635 913 Green Valley Elementary   Regular School No Elementary KG 05 2020   pk_12_total 412 38 79   * 58     *   38                             627 412 38 79     58         38                       627
1240552 1240552 MD     school 2400330 10   Frederick 240033001379 914 New Market Middle   Regular School No Middle 06 08 2020   pk_12_total 484 * 33   * 11     *   24                             563 484   33     11         24                       563
1240567 1240567 MD     school 2400330 10   Frederick 240033090472 916 Spring Ridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 242 107 55   * 21     *   53                             482 242 107 55     21         53                       482
1240575 1240575 MD     school 2400330 10   Frederick 240033000847 917 Deer Crossing Elementary   Regular School No Elementary PK 05 2020   pk_12_total 674 27 55     21     *   28                             806 674 27 55     21         28                       806
1240579 1240579 MD     school 2400330 10   Frederick 240033001163 918 Oakdale Middle   Regular School No Middle 06 08 2020   pk_12_total 624 54 83   * 56     *   50                             872 624 54 83     56         50                       872
1240586 1240586 MD     school 2400330 10   Frederick 240033001165 919 Oakdale Elementary   Regular School No Elementary KG 05 2020   pk_12_total 503 89 73   * 95     *   25                             792 503 89 73     95         25                       792
1240616 1240616 MD     school 2400330 10   Frederick 240033001715 1301 Frederick Classical Charter   Regular School Yes Elementary KG 08 2020   pk_12_total 158 124 37   * 32     *   22                             376 158 124 37     32         22                       376
1240624 1240624 MD     school 2400330 10   Frederick 240033000653 1406 Valley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 395 14 65   * *     *   23                             508 395 14 65               23                       508
1240633 1240633 MD     school 2400330 10   Frederick 240033000629 1509 Catoctin High   Regular School No High 09 12 2020   pk_12_total 672 * 38   * *     *   22                             749 672   38               22                       749
1240637 1240637 MD     school 2400330 10   Frederick 240033000651 1510 Thurmont Middle   Regular School No Middle 06 08 2020   pk_12_total 494 * 24   * *     *   15                             545 494   24               15                       545
1240642 1240642 MD     school 2400330 10   Frederick 240033001166 1511 Thurmont Primary   Regular School No Elementary PK 02 2020   pk_12_total 301   17     *     *   16                             336 301   17               16                       336
1240672 1240672 MD     school 2400330 10   Frederick 240033000661 2103 Yellow Springs Elementary   Regular School No Elementary KG 05 2020   pk_12_total 275 97 41   * 19     *   32                             470 275 97 41     19         32                       470
1240680 1240680 MD     school 2400330 10   Frederick 240033001015 2107 Whittier Elementary   Regular School No Elementary PK 05 2020   pk_12_total 322 193 116   * 44     *   35                             718 322 193 116     44         35                       718
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
1240700 1240700 MD     school 2400330 10   Frederick 240033000807 2306 Orchard Grove Elementary   Regular School No Elementary PK 05 2020   pk_12_total 173 207 150   * 54     *   47                             635 173 207 150     54         47                       635
1240705 1240705 MD     school 2400330 10   Frederick 240033001550 2307 Tuscarora High   Regular School No High 09 12 2020   pk_12_total 701 340 338   * 112     *   92                             1590 701 340 338     112         92                       1590
1240713 1240713 MD     school 2400330 10   Frederick 240033001748 2308 Butterfly Ridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 147 201 274     22     *   30                             675 147 201 274     22         30                       675
1240749 1240749 MD     school 2400330 10   Frederick 240033000626 2504 Brunswick Elementary   Regular School No Elementary PK 05 2020   pk_12_total 535 68 93   * 17     *   45                             762 535 68 93     17         45                       762
1240753 1240753 MD     school 2400330 10   Frederick 240033001409 2525 Brunswick Middle   Regular School No Middle 06 08 2020   pk_12_total 403 44 74   * 10     *   40                             573 403 44 74     10         40                       573
1240757 1240757 MD     school 2400330 10   Frederick 240033000656 2606 Walkersville Middle   Regular School No Middle 06 08 2020   pk_12_total 570 108 117     24     *   56                             876 570 108 117     24         56                       876
1240765 1240765 MD     school 2400330 10   Frederick 240033000654 2607 Walkersville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 330 143 107   * 24     *   70                             678 330 143 107     24         70                       678
1240770 1240770 MD     school 2400330 10   Frederick 240033000655 2610 Walkersville High   Regular School No High 09 12 2020   pk_12_total 747 161 145   * 39     *   86                             1185 747 161 145     39         86                       1185
1240876 1240876 MD     school 2400390 12   Harford 240039000688 115 Edgewood Elementary   Regular School No Elementary PK 05 2020   pk_12_total 103 228 54   * *     *   16                             405 103 228 54               16                       405
1240884 1240884 MD     school 2400390 12   Harford 240039000686 120 Deerfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 194 370 83   * 17     *   84                             752 194 370 83     17         84                       752
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
1240907 1240907 MD     school 2400390 12   Harford 240039000468 125 Church Creek Elementary   Regular School No Elementary PK 05 2020   pk_12_total 273 263 58     24     *   77                             697 273 263 58     24         77                       697
1240923 1240923 MD     school 2400390 12   Harford 240039000704 137 Joppatowne Elementary   Regular School No Elementary PK 05 2020   pk_12_total 353 152 52   * 11     *   46                             617 353 152 52     11         46                       617
1240939 1240939 MD     school 2400390 12   Harford 240039000713 143 Riverside Elementary   Regular School No Elementary PK 05 2020   pk_12_total 182 169 54   * 11     *   41                             462 182 169 54     11         41                       462
1240944 1240944 MD     school 2400390 12   Harford 240039000690 176 Edgewood High   Regular School No High 09 12 2020   pk_12_total 466 675 168   * 47     *   95                             1458 466 675 168     47         95                       1458
1240948 1240948 MD     school 2400390 12   Harford 240039000689 177 Edgewood Middle   Regular School No Middle 06 08 2020   pk_12_total 350 518 148   * 26     *   107                             1160 350 518 148     26         107                       1160
1240953 1240953 MD     school 2400390 12   Harford 240039000705 181 Joppatowne High   Regular School No High 09 12 2020   pk_12_total 197 383 88   * *     *   60                             745 197 383 88               60                       745
1240962 1240962 MD     school 2400390 12   Harford 240039001638 187 Patterson Mill High School   Regular School No High 09 12 2020   pk_12_total 600 73 59     54     *   37                             825 600 73 59     54         37                       825

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