enrollments

Data source: Big Local News · About: Big Local

9,615 rows where state = "MD" and year = 2020 sorted by white descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 9,515 ✖
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
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
1237869 1237869 MD     school 2400060 2   Anne Arundel 240006001403 3263 Crofton Middle   Regular School No Middle 06 08 2020   pk_12_total 746 271 136   * 105     *   76                             1345 746 271 136     105         76                       1345
1237952 1237952 MD     school 2400060 2   Anne Arundel 240006000823 3423 Meade Middle   Regular School No Middle 06 08 2020   pk_12_total 74 381 304   * 31         40                             832 74 381 304     31         40                       832
1238489 1238489 MD     school 2400120 3   Baltimore County 240012000492 304 Wellwood International Elementary   Regular School No Elementary KG 05 2020   pk_12_total 74 309 30   * 54         18                             489 74 309 30     54         18                       489
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
1241927 1241927 MD     school 2400480 15   Montgomery 240048000874 212 Meadow Hall Elementary   Regular School No Elementary KG 05 2020   pk_12_total 74 40 239   * 34         18                             407 74 40 239     34         18                       407
1242142 1242142 MD     school 2400480 15   Montgomery 240048000955 312 William Tyler Page Elementary   Regular School No Elementary PK 05 2020   pk_12_total 74 279 160   * 73         27                             615 74 279 160     73         27                       615
1239446 1239446 MD     school 2400150 4   Calvert 240015000508 213 Calvert High   Regular School No High 09 12 2020   pk_12_total 737 224 81   * 21     *   93                             1161 737 224 81     21         93                       1161
1244381 1244381 MD     school 2400510 16   Prince George's 240051001126 1909 Parkdale High   Regular School No High 09 12 2020   pk_12_total 73 718 1473   * 61     *   18                             2354 73 718 1473     61         18                       2354
1237328 1237328 MD     school 2400030 1   Allegany 240003001636 2404 Mountain Ridge High School   Regular School No High 09 12 2020   pk_12_total 729 17 *   * *         24                             784 729 17                 24                       784
1237962 1237962 MD     school 2400060 2   Anne Arundel 240006000132 4023 Southern High   Regular School No High 09 12 2020   pk_12_total 729 75 132   * *     *   51                             996 729 75 132               51                       996
1241877 1241877 MD     school 2400480 15   Montgomery 240048000902 201 Richard Montgomery High   Regular School No High 09 12 2020   pk_12_total 729 430 591   * 615     *   135                             2505 729 430 591     615         135                       2505
1239561 1239561 MD     school 2400180 5   Caroline 240018000523 703 North Caroline High School   Regular School No High 09 12 2020   pk_12_total 728 111 210   * 11     *   72                             1138 728 111 210     11         72                       1138
1239697 1239697 MD     school 2400210 6   Carroll 240021000553 703 Westminster West Middle   Regular School No Middle 06 08 2020   pk_12_total 725 44 94   * 29     *   36                             935 725 44 94     29         36                       935
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
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
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
1238836 1238836 MD     school 2400120 3   Baltimore County 240012000374 953 Dumbarton Middle   Regular School No Middle 06 08 2020   pk_12_total 717 155 179     101     *   70                             1225 717 155 179     101         70                       1225
1241311 1241311 MD     school 2400420 13   Howard 240042000743 207 Mount Hebron High   Regular School No High 09 12 2020   pk_12_total 717 217 163   * 525     *   67                             1695 717 217 163     525         67                       1695
1237795 1237795 MD     school 2400060 2   Anne Arundel 240006000098 3142 Meade Heights Elementary   Regular School No Elementary PK 05 2020   pk_12_total 71 258 62   * *         30                             429 71 258 62               30                       429
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
1241653 1241653 MD     school 2400420 13   Howard 240042001700 617 Lake Elkhorn Middle   Regular School No Middle 06 08 2020   pk_12_total 71 293 106     49         45                             564 71 293 106     49         45                       564
1243021 1243021 MD     school 2400480 15   Montgomery 240048000845 817 Glenallan Elementary   Regular School No Elementary PK 05 2020   pk_12_total 71 228 336   * 86         22                             744 71 228 336     86         22                       744
1243620 1243620 MD     school 2400510 16   Prince George's 240051001092 1008 Laurel High   Regular School No High 09 12 2020   pk_12_total 71 1023 728   * 77     *   35                             1943 71 1023 728     77         35                       1943
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
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
1241492 1241492 MD     school 2400420 13   Howard 240042000755 517 Swansfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 70 311 108     39         34                             562 70 311 108     39         34                       562
1242838 1242838 MD     school 2400480 15   Montgomery 240048000878 776 Montgomery Knolls Elementary   Regular School No Elementary PK 02 2020   pk_12_total 70 137 223     21         18                             469 70 137 223     21         18                       469
1239381 1239381 MD     school 2400150 4   Calvert 240015000611 113 Patuxent High   Regular School No High 09 12 2020   pk_12_total 698 186 65   * 24     *   85                             1063 698 186 65     24         85                       1063
1241010 1241010 MD     school 2400390 12   Harford 240039000694 304 Harford Technical High   Career and Technical School No High 09 12 2020   pk_12_total 698 145 81   * 34     *   38                             999 698 145 81     34         38                       999
1242291 1242291 MD     school 2400480 15   Montgomery 240048001118 413 North Bethesda Middle   Regular School No Middle 06 08 2020   pk_12_total 695 120 161   * 151     *   99                             1233 695 120 161     151         99                       1233
1239048 1239048 MD     school 2400120 3   Baltimore County 240012000377 1273 Dundalk High   Regular School No High 09 12 2020   pk_12_total 690 349 593   14 43     *   89                             1782 690 349 593   14 43         89                       1782
1238711 1238711 MD     school 2400120 3   Baltimore County 240012001434 852 Ridgely Middle   Regular School No Middle 06 08 2020   pk_12_total 689 109 64   * 196     *   49                             1113 689 109 64     196         49                       1113
1245169 1245169 MD     school 2400660 21   Washington 240066001275 2101 North Hagerstown High   Regular School No High 09 12 2020   pk_12_total 687 259 183   * 50     *   129                             1311 687 259 183     50         129                       1311
1242057 1242057 MD     school 2400480 15   Montgomery 240048001040 246 Northwest High   Regular School No High 09 12 2020   pk_12_total 684 645 605   * 559     *   126                             2623 684 645 605     559         126                       2623
1244888 1244888 MD     school 2400630 20   Talbot 240063001242 101 Easton High   Regular School No High 09 12 2020   pk_12_total 682 189 267   * 24     *   60                             1224 682 189 267     24         60                       1224
1238562 1238562 MD     school 2400120 3   Baltimore County 240012000484 405 Timber Grove Elementary   Regular School No Elementary PK 05 2020   pk_12_total 68 309 117   * 31         33                             561 68 309 117     31         33                       561
1244026 1244026 MD     school 2400510 16   Prince George's 240051000200 1427 Yorktown Elementary   Regular School No Elementary KG 05 2020   pk_12_total 68 246 48     21     *   19                             403 68 246 48     21         19                       403
1241415 1241415 MD     school 2400420 13   Howard 240042001437 308 Marriotts Ridge High   Regular School No High 09 12 2020   pk_12_total 676 136 46   * 548         63                             1472 676 136 46     548         63                       1472
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
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
1240861 1240861 MD     school 2400360 11   Garrett 240036000674 3709 Southern Garrett High School   Regular School No High 09 12 2020   pk_12_total 670 * 12     *         15                             701 670   12               15                       701
1239225 1239225 MD     school 2400120 3   Baltimore County 240012000424 1512 Mars Estates Elementary   Regular School No Elementary PK 05 2020   pk_12_total 67 222 54   * 10     *   30                             386 67 222 54     10         30                       386
1244978 1244978 MD     school 2400660 21   Washington 240066001295 204 Williamsport High   Regular School No High 09 12 2020   pk_12_total 663 79 105   * *         47                             903 663 79 105               47                       903
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
1241090 1241090 MD     school 2400390 12   Harford 240039001698 349 Red Pump Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 660 25 35     12         40                             772 660 25 35     12         40                       772
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
1245756 1245756 MD     school 2400090 30   Baltimore City 240009000285 66 Mount Royal Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 66 671 23   * *     *   *                             775 66 671 23                                       775
1244774 1244774 MD     school 2400600 18   Saint Mary's 240060001224 801 Great Mills High   Regular School No High 09 12 2020   pk_12_total 653 592 225   * 79     *   122                             1678 653 592 225     79         122                       1678
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
1244850 1244850 MD     school 2400570 19   Somerset 240057001742 108 Princess Anne Elementary School   Regular School No Elementary PK 01 2020   pk_12_total 65 234 38   * *         21                             363 65 234 38               21                       363
1246655 1246655 MD     school 2400090 30   Baltimore City 240009001689 373 Tunbridge Public Charter School   Regular School Yes Elementary PK 08 2020   pk_12_total 65 378 10   * *     *   11                             471 65 378 10               11                       471
1239341 1239341 MD     school 2400120 3   Baltimore County 240012000412 1572 Kenwood High IB and Sports Science   Regular School No High 09 12 2020   pk_12_total 648 677 172   10 40     *   100                             1649 648 677 172   10 40         100                       1649
1242679 1242679 MD     school 2400480 15   Montgomery 240048001455 701 Damascus High   Regular School No High 09 12 2020   pk_12_total 648 177 315   * 140     *   69                             1353 648 177 315     140         69                       1353
1239967 1239967 MD     school 2400240 7   Cecil 240024000580 606 Rising Sun Middle School   Regular School No Middle 06 08 2020   pk_12_total 640 * 34   * *         21                             702 640   34               21                       702
1241132 1241132 MD     school 2400390 12   Harford 240039000703 391 John Archer School   Special Education School No Other PK 12 2020   pk_12_total 64 36 11     *         *                             123 64 36 11                                       123
1242183 1242183 MD     school 2400480 15   Montgomery 240048090450 335 Briggs Chaney Middle   Regular School No Middle 06 08 2020   pk_12_total 64 504 236     98     *   33                             936 64 504 236     98         33                       936
1239631 1239631 MD     school 2400210 6   Carroll 240021000547 504 Sykesville Middle   Regular School No Middle 06 08 2020   pk_12_total 639 37 37   * 42     *   26                             784 639 37 37     42         26                       784
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
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
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
1241346 1241346 MD     school 2400420 13   Howard 240042000722 214 Centennial High   Regular School No High 09 12 2020   pk_12_total 630 146 73   * 651     *   90                             1597 630 146 73     651         90                       1597
1241609 1241609 MD     school 2400420 13   Howard 240042000754 608 Stevens Forest Elementary   Regular School No Elementary PK 05 2020   pk_12_total 63 159 138   * 24     *   40                             426 63 159 138     24         40                       426
1241893 1241893 MD     school 2400480 15   Montgomery 240048000939 206 Twinbrook Elementary   Regular School No Elementary PK 05 2020   pk_12_total 63 54 362   * 59         18                             558 63 54 362     59         18                       558
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
1237533 1237533 MD     school 2400060 2   Anne Arundel 240006000072 2033 George Fox Middle   Regular School No Middle 06 08 2020   pk_12_total 626 91 85   * 18     *   55                             884 626 91 85     18         55                       884
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
1244965 1244965 MD     school 2400660 21   Washington 240066001290 201 Springfield Middle   Regular School No Middle 06 08 2020   pk_12_total 623 77 104   * 13         48                             866 623 77 104     13         48                       866
1246186 1246186 MD     school 2400090 30   Baltimore City 240009000257 228 John Ruhrah Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 62 35 741   * *         *                             851 62 35 741                                       851
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
1237757 1237757 MD     school 2400060 2   Anne Arundel 240006001645 3092 Seven Oaks Elementary   Regular School No Elementary PK 05 2020   pk_12_total 61 357 59     15     *   46                             539 61 357 59     15         46                       539
1241782 1241782 MD     school 2400480 15   Montgomery 240048000834 106 Fox Chapel Elementary   Regular School No Elementary PK 05 2020   pk_12_total 61 155 278   * 88     *   25                             611 61 155 278     88         25                       611
1245066 1245066 MD     school 2400660 21   Washington 240066001285 701 Smithsburg High   Regular School No High 09 12 2020   pk_12_total 607 42 53   * 15     *   33                             753 607 42 53     15         33                       753
1245326 1245326 MD     school 2400690 22   Wicomico 240069001305 1307 James M. Bennett High   Regular School No High 09 12 2020   pk_12_total 606 565 235   15 65     *   77                             1567 606 565 235   15 65         77                       1567
1240741 1240741 MD     school 2400330 10   Frederick 240033000627 2503 Brunswick High   Regular School No High 09 12 2020   pk_12_total 604 50 74   * 13         50                             792 604 50 74     13         50                       792
1239975 1239975 MD     school 2400240 7   Cecil 240024000579 607 Rising Sun Elementary   Regular School No Elementary PK 05 2020   pk_12_total 602 * 46     *         26                             681 602   46               26                       681
1245053 1245053 MD     school 2400660 21   Washington 240066001255 602 Boonsboro Middle   Regular School No Middle 06 08 2020   pk_12_total 602 29 26   * 18         26                             702 602 29 26     18         26                       702
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
1242813 1242813 MD     school 2400480 15   Montgomery 240048000940 772 Viers Mill Elementary   Regular School No Elementary PK 05 2020   pk_12_total 60 54 399   * 51         14                             579 60 54 399     51         14                       579
1243662 1243662 MD     school 2400510 16   Prince George's 240051001708 1015 Chesapeake Math and IT Public Charter   Regular School Yes Other KG 12 2020   pk_12_total 60 1343 150   * 74     *   27                             1664 60 1343 150     74         27                       1664
1241535 1241535 MD     school 2400420 13   Howard 240042000816 524 River Hill High   Regular School No High 09 12 2020   pk_12_total 599 136 84     470         89                             1378 599 136 84     470         89                       1378
1237702 1237702 MD     school 2400060 2   Anne Arundel 240006000124 2413 Severn River Middle   Regular School No Middle 06 08 2020   pk_12_total 597 60 93   * 19         39                             809 597 60 93     19         39                       809
1239676 1239676 MD     school 2400210 6   Carroll 240021000536 601 Manchester Elementary   Regular School No Elementary PK 05 2020   pk_12_total 595 * 39     10     *   10                             663 595   39     10         10                       663
1239831 1239831 MD     school 2400210 6   Carroll 240021000539 1306 Mount Airy Middle   Regular School No Middle 06 08 2020   pk_12_total 594 15 64   * 20         18                             714 594 15 64     20         18                       714
1239532 1239532 MD     school 2400180 5   Caroline 240018000526 302 Lockerman Middle School   Regular School No Middle 06 08 2020   pk_12_total 591 97 179     *         73                             949 591 97 179               73                       949
1245335 1245335 MD     school 2400690 22   Wicomico 240069001309 1309 Parkside High   Regular School No High 09 12 2020   pk_12_total 590 351 52   * 35         54                             1083 590 351 52     35         54                       1083
1241765 1241765 MD     school 2400480 15   Montgomery 240048000843 102 Germantown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 59 117 77   * 47     *   22                             324 59 117 77     47         22                       324
1241794 1241794 MD     school 2400480 15   Montgomery 240048001448 108 Lake Seneca Elementary   Regular School No Elementary PK 05 2020   pk_12_total 59 177 219     25     *   28                             510 59 177 219     25         28                       510
1242374 1242374 MD     school 2400480 15   Montgomery 240048000950 504 Westover Elementary   Regular School No Elementary PK 05 2020   pk_12_total 59 117 71   * 45     *   22                             316 59 117 71     45         22                       316
1243202 1243202 MD     school 2400510 16   Prince George's 240051001171 214 Templeton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 59 183 527   * 164     *   *                             943 59 183 527     164                                 943
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
1245305 1245305 MD     school 2400690 22   Wicomico 240069001300 1103 Delmar Elementary   Regular School No Elementary PK 04 2020   pk_12_total 587 146 75   * 24     *   98                             932 587 146 75     24         98                       932
1237686 1237686 MD     school 2400060 2   Anne Arundel 240006000047 2322 Broadneck Elementary   Regular School No Elementary KG 05 2020   pk_12_total 586 41 71   * 25     *   49                             774 586 41 71     25         49                       774
1244983 1244983 MD     school 2400660 21   Washington 240066001288 301 South Hagerstown High   Regular School No High 09 12 2020   pk_12_total 586 358 167   * 50     *   179                             1345 586 358 167     50         179                       1345
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
1239582 1239582 MD     school 2400210 6   Carroll 240021000543 105 Northwest Middle   Regular School No Middle 06 08 2020   pk_12_total 583 16 32   * *         39                             682 583 16 32               39                       682
1241832 1241832 MD     school 2400480 15   Montgomery 240048000897 152 Poolesville High   Regular School No High 09 12 2020   pk_12_total 581 68 94   * 397     *   61                             1205 581 68 94     397         61                       1205
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
1238236 1238236 MD     school 2400120 3   Baltimore County 240012001649 75 Crossroads Center   Alternative School No High 07 12 2020   pk_12_total 58 97 *   * *         16                             183 58 97                 16                       183
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

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