Data source: Big Local News · About: Big Local

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

View and edit SQL

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
1312798 MD     school 2400270 8   Charles 240027001727 802 St. Charles High School   Regular School No High 09 12 2021   pk_12_total 154 997 101   11 30     *   96                             1392 154 997 101   11 30         96                       1392
1319251 MD     school 2400090 30   Baltimore City 240009000151 403 Baltimore Polytechnic Institute   Regular School No High 09 12 2021   pk_12_total 279 993 200   * 109     *   30                             1619 279 993 200     109         30                       1619
1316651 MD     school 2400510 16   Prince George's 240051001036 1502 Frederick Douglass High   Regular School No High 09 12 2021   pk_12_total 17 992 69   * *     *   28                             1115 17 992 69               28                       1115
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
1241306 MD     school 2400420 13   Howard 240042000753 204 St. Johns Lane Elementary   Regular School No Elementary KG 05 2020   pk_12_total 329 99 43   * 260     *   31                             764 329 99 43     260         31                       764
1242707 MD     school 2400480 15   Montgomery 240048001456 705 John T. Baker Middle School   Regular School No Middle 06 08 2020   pk_12_total 397 99 239     50     *   43                             830 397 99 239     50         43                       830
1243176 MD     school 2400510 16   Prince George's 240051001146 210 Rogers Heights Elementary   Regular School No Elementary PK 06 2020   pk_12_total 11 99 692     14     *   *                             820 11 99 692     14                                 820
1245116 MD     school 2400660 21   Washington 240066001274 1301 Maugansville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 462 99 107     22         59                             749 462 99 107     22         59                       749
1310390 MD     school 2400060 2   Anne Arundel 240006000114 3182 Pershing Hill Elementary   Regular School No Elementary KG 05 2021   pk_12_total 216 99 97   * 14     *   60                             491 216 99 97     14         60                       491
1314085 MD     school 2400420 13   Howard 240042090478 523 Pointers Run Elementary   Regular School No Elementary PK 05 2021   pk_12_total 312 99 43   * 259         65                             779 312 99 43     259         65                       779
1239495 MD     school 2400150 4   Calvert 240015001505 316 Sunderland Elementary   Regular School No Elementary PK 05 2020   pk_12_total 532 98 24     *         60                             723 532 98 24               60                       723
1241719 MD     school 2400450 14   Kent 240045000766 402 Kent County Middle School   Regular School No Middle 06 08 2020   pk_12_total 251 98 41   * *         27                             421 251 98 41               27                       421
1241885 MD     school 2400480 15   Montgomery 240048000840 204 Garrett Park Elementary   Regular School No Elementary PK 05 2020   pk_12_total 310 98 193   * 132     *   65                             802 310 98 193     132         65                       802
1242797 MD     school 2400480 15   Montgomery 240048000873 770 Flora M. Singer Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 230 98 255   * 45         53                             683 230 98 255     45         53                       683
1314923 MD     school 2400480 15   Montgomery 240048000920 501 Sherwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 184 98 86   * 51         46                             467 184 98 86     51         46                       467
1316124 MD     school 2400510 16   Prince George's 240051000973 802 Baden Elementary   Regular School No Elementary PK 06 2021   pk_12_total 37 98 46   *           16                             198 37 98 46               16                       198
1319352 MD     school 2400090 30   Baltimore City 240009000150 480 Baltimore City College   Regular School No High 09 12 2021   pk_12_total 256 972 146   * 25     *   32                             1439 256 972 146     25         32                       1439
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
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
1238546 MD     school 2400120 3   Baltimore County 240012000388 403 Franklin Elementary   Regular School No Elementary PK 05 2020   pk_12_total 228 97 47     28         19                             419 228 97 47     28         19                       419
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
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
1241113 MD     school 2400390 12   Harford 240039001380 385 C. Milton Wright High   Regular School No High 09 12 2020   pk_12_total 1059 97 68   * 82     *   51                             1363 1059 97 68     82         51                       1363
1310219 MD     school 2400060 2   Anne Arundel 240006000129 2212 Solley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 453 97 92   * 32     *   57                             735 453 97 92     32         57                       735
1317691 MD     school 2400660 21   Washington 240066001274 1301 Maugansville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 394 97 115     22         56                             684 394 97 115     22         56                       684
1239570 MD     school 2400180 5   Caroline 240018000519 802 Colonel Richardson Middle School   Regular School No Middle 06 08 2020   pk_12_total 260 96 31   * *         35                             432 260 96 31               35                       432
1241322 MD     school 2400420 13   Howard 240042000748 209 Patapsco Middle   Regular School No Middle 06 08 2020   pk_12_total 306 96 77     247     *   17                             746 306 96 77     247         17                       746
1311101 MD     school 2400120 3   Baltimore County 240012000388 403 Franklin Elementary   Regular School No Elementary PK 05 2021   pk_12_total 203 96 49     28         24                             400 203 96 49     28         24                       400
1312082 MD     school 2400180 5   Caroline 240018000526 302 Lockerman Middle School   Regular School No Middle 06 08 2021   pk_12_total 544 96 184     *         69                             902 544 96 184               69                       902
1314652 MD     school 2400480 15   Montgomery 240048000788 304 JoAnn Leleck at Broad Acres Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 96 697   * 18         *                             821   96 697     18                                 821
1238476 MD     school 2400120 3   Baltimore County 240012000458 272 Randallstown High   Regular School No High 09 12 2020   pk_12_total 14 951 44   * 23         15                             1048 14 951 44     23         15                       1048
1318888 MD     school 2400090 30   Baltimore City 240009000268 245 Leith Walk Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 950 48   * *     *   *                             1018   950 48                                       1018
1239201 MD     school 2400120 3   Baltimore County 240012000360 1507 Chase Elementary   Regular School No Elementary PK 05 2020   pk_12_total 210 95 47   * *     *   42                             398 210 95 47               42                       398
1239425 MD     school 2400150 4   Calvert 240015000517 207 Calvert Elementary   Regular School No Elementary PK 05 2020   pk_12_total 326 95 27   * *         63                             516 326 95 27               63                       516
1242501 MD     school 2400480 15   Montgomery 240048000943 552 Washington Grove Elementary   Regular School No Elementary PK 05 2020   pk_12_total 37 95 292     24     *   13                             462 37 95 292     24         13                       462
1246326 MD     school 2400090 30   Baltimore City 240009000268 245 Leith Walk Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 945 60     *     *   *                             1023   945 60                                       1023
1319347 MD     school 2400090 30   Baltimore City 240009000168 454 Carver Vocational-Technical High   Career and Technical School No High 09 12 2021   pk_12_total 15 942 24   * *         *                             985 15 942 24                                       985
1238939 MD     school 2400120 3   Baltimore County 240012001750 1113 Honeygo Elementary   Regular School No Elementary PK 05 2020   pk_12_total 366 94 33   * 138     *   45                             680 366 94 33     138         45                       680
1243749 MD     school 2400510 16   Prince George's 240051001042 1214 Glassmanor Elementary   Regular School No Elementary KG 05 2020   pk_12_total * 94 223                                             319   94 223                                       319
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
1310803 MD     school 2400120 3   Baltimore County 240012000353 101 Catonsville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 301 94 50     140     *   52                             638 301 94 50     140         52                       638
1237909 MD     school 2400060 2   Anne Arundel 240006001517 3362 Crofton Meadows Elementary   Regular School No Elementary KG 05 2020   pk_12_total 321 93 56     29         55                             554 321 93 56     29         55                       554
1241546 MD     school 2400420 13   Howard 240042001115 526 Lime Kiln Middle   Regular School No Middle 06 08 2020   pk_12_total 313 93 26   * 176         50                             660 313 93 26     176         50                       660
1242381 MD     school 2400480 15   Montgomery 240048000868 505 Lucy V. Barnsley Elementary   Regular School No Elementary KG 05 2020   pk_12_total 243 93 254   * 88         57                             737 243 93 254     88         57                       737
1313913 MD     school 2400420 13   Howard 240042000173 216 Burleigh Manor Middle School   Regular School No Middle 06 08 2021   pk_12_total 267 93 45   * 391         44                             844 267 93 45     391         44                       844
1311409 MD     school 2400120 3   Baltimore County 240012000443 972 Parkville High   Regular School No High 09 12 2021   pk_12_total 423 925 485   * 161     *   71                             2075 423 925 485     161         71                       2075
1238683 MD     school 2400120 3   Baltimore County 240012090440 810 Padonia International Elementary   Regular School No Elementary PK 05 2020   pk_12_total 53 92 259   * 98         21                             524 53 92 259     98         21                       524
1242592 MD     school 2400480 15   Montgomery 240048000829 566 Fields Road Elementary   Regular School No Elementary PK 05 2020   pk_12_total 131 92 169     65         30                             487 131 92 169     65         30                       487
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
1312050 MD     school 2400150 4   Calvert 240015001505 316 Sunderland Elementary   Regular School No Elementary PK 05 2021   pk_12_total 444 92 31     *         54                             624 444 92 31               54                       624
1314931 MD     school 2400480 15   Montgomery 240048000889 502 Olney Elementary   Regular School No Elementary PK 05 2021   pk_12_total 312 92 98   * 90     *   40                             634 312 92 98     90         40                       634
1237445 MD     school 2400060 2   Anne Arundel 240006000102 1172 North Glen Elementary   Regular School No Elementary PK 05 2020   pk_12_total 87 91 82     14         31                             305 87 91 82     14         31                       305
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
1242789 MD     school 2400480 15   Montgomery 240048000888 769 Oakland Terrace Elementary   Regular School No Elementary PK 05 2020   pk_12_total 184 91 185     24         47                             531 184 91 185     24         47                       531
1245382 MD     school 2400720 23   Worcester 240072001332 205 Snow Hill Elementary   Regular School No Elementary PK 03 2020   pk_12_total 239 91 19   * *         30                             383 239 91 19               30                       383
1311931 MD     school 2400150 4   Calvert 240015001392 111 Southern Middle   Regular School No Middle 06 08 2021   pk_12_total 289 91 44   * *         40                             469 289 91 44               40                       469
1313067 MD     school 2400330 10   Frederick 240033001536 716 Urbana Middle   Regular School No Middle 06 08 2021   pk_12_total 483 91 112   * 208     *   70                             967 483 91 112     208         70                       967
1313809 MD     school 2400420 13   Howard 240042000396 105 Rockburn Elementary   Regular School No Elementary PK 05 2021   pk_12_total 277 91 36   * 168         35                             611 277 91 36     168         35                       611
1314001 MD     school 2400420 13   Howard 240042000724 505 Clarksville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 143 91 44     201         22                             501 143 91 44     201         22                       501
1244070 MD     school 2400510 16   Prince George's 240051001036 1502 Frederick Douglass High   Regular School No High 09 12 2020   pk_12_total 16 905 68   * *     *   36                             1033 16 905 68               36                       1033
1313877 MD     school 2400420 13   Howard 240042000748 209 Patapsco Middle   Regular School No Middle 06 08 2021   pk_12_total 277 90 75   * 226     *   22                             693 277 90 75     226         22                       693
1315532 MD     school 2400480 15   Montgomery 240048000848 797 Harmony Hills Elementary   Regular School No Elementary PK 05 2021   pk_12_total 22 90 540   * 28     *   *                             690 22 90 540     28                                 690
1315756 MD     school 2400510 16   Prince George's 240051001146 210 Rogers Heights Elementary   Regular School No Elementary PK 06 2021   pk_12_total 10 90 629     *         *                             740 10 90 629                                       740
1317540 MD     school 2400660 21   Washington 240066001290 201 Springfield Middle   Regular School No Middle 06 08 2021   pk_12_total 581 90 104   * 14     *   68                             859 581 90 104     14         68                       859
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
1244151 MD     school 2400510 16   Prince George's 240051001110 1703 Mt Rainier Elementary   Regular School No Elementary PK 06 2020   pk_12_total 46 89 204     *         *                             350 46 89 204                                       350
1244698 MD     school 2400600 18   Saint Mary's 240060001229 305 Leonardtown Middle   Regular School No Middle 06 08 2020   pk_12_total 782 89 52   * 25     *   72                             1024 782 89 52     25         72                       1024
1310006 MD     school 2400060 2   Anne Arundel 240006000102 1172 North Glen Elementary   Regular School No Elementary PK 05 2021   pk_12_total 85 89 87     15         27                             303 85 89 87     15         27                       303
1310053 MD     school 2400060 2   Anne Arundel 240006000118 1242 Richard Henry Lee Elementary   Regular School No Elementary KG 05 2021   pk_12_total 178 89 138   * 20     *   45                             472 178 89 138     20         45                       472
1311757 MD     school 2400120 3   Baltimore County 240012000360 1507 Chase Elementary   Regular School No Elementary PK 05 2021   pk_12_total 180 89 54     *     *   29                             355 180 89 54               29                       355
1312062 MD     school 2400150 4   Calvert 240015000967 318 Windy Hill Middle   Regular School No Middle 06 08 2021   pk_12_total 517 89 54   * *     *   77                             746 517 89 54               77                       746
1314952 MD     school 2400480 15   Montgomery 240048000868 505 Lucy V. Barnsley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 214 89 246   * 88     *   57                             701 214 89 246     88         57                       701
1315506 MD     school 2400480 15   Montgomery 240048001207 792 Newport Mill Middle   Regular School No Middle 06 08 2021   pk_12_total 95 89 401   * 53         28                             670 95 89 401     53         28                       670
1317050 MD     school 2400510 16   Prince George's 240051001142 2016 Robert Frost Elementary   Regular School No Elementary KG 05 2021   pk_12_total 13 89 164     *         *                             275 13 89 164                                       275
1317180 MD     school 2400540 17   Queen Anne's 240054001195 301 Queen Anne's County High School   Regular School No High 09 12 2021   pk_12_total 938 89 111   * 11         59                             1210 938 89 111     11         59                       1210
1318768 MD     school 2400090 30   Baltimore City 240009000161 231 The Belair-Edison School   Regular School Yes Elementary PK 08 2021   pk_12_total 12 881 12   *           20                             927 12 881 12               20                       927
1238931 MD     school 2400120 3   Baltimore County 240012000397 1111 Gunpowder Elementary   Regular School No Elementary KG 05 2020   pk_12_total 342 88 12   * 67     *   26                             538 342 88 12     67         26                       538
1243527 MD     school 2400510 16   Prince George's 240051001384 723 C. Elizabeth Rieg Regional Center   Special Education School No Other KG 12 2020   pk_12_total 13 88 12     *                                       115 13 88 12                                       115
1310095 MD     school 2400060 2   Anne Arundel 240006000072 2033 George Fox Middle   Regular School No Middle 06 08 2021   pk_12_total 634 88 88   * 18     *   62                             899 634 88 88     18         62                       899
1311486 MD     school 2400120 3   Baltimore County 240012000397 1111 Gunpowder Elementary   Regular School No Elementary KG 05 2021   pk_12_total 297 88 15   * 74         19                             494 297 88 15     74         19                       494
1312701 MD     school 2400270 8   Charles 240027000144 619 Westlake High School   Regular School No High 09 12 2021   pk_12_total 68 877 89   * 42     *   57                             1139 68 877 89     42         57                       1139
1238854 MD     school 2400120 3   Baltimore County 240012000443 972 Parkville High & Center for Math/Science   Regular School No High 09 12 2020   pk_12_total 460 873 492   10 162     *   74                             2074 460 873 492   10 162         74                       2074
1239376 MD     school 2400150 4   Calvert 240015001392 111 Southern Middle   Regular School No Middle 06 08 2020   pk_12_total 315 87 43     *         46                             495 315 87 43               46                       495
1239507 MD     school 2400150 4   Calvert 240015000967 318 Windy Hill Middle   Regular School No Middle 06 08 2020   pk_12_total 557 87 48   * 12     *   82                             789 557 87 48     12         82                       789
1311902 MD     school 2400120 3   Baltimore County 240012000477 1573 Sparrows Point High   Regular School No High 09 12 2021   pk_12_total 877 87 70   * 14     *   43                             1097 877 87 70     14         43                       1097
1313861 MD     school 2400420 13   Howard 240042000753 204 St. Johns Lane Elementary   Regular School No Elementary KG 05 2021   pk_12_total 249 87 34   * 278     *   28                             679 249 87 34     278         28                       679
1314960 MD     school 2400480 15   Montgomery 240048000830 506 Flower Valley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 172 87 123   * 43         44                             470 172 87 123     43         44                       470
1316107 MD     school 2400510 16   Prince George's 240051001384 723 C. Elizabeth Rieg Regional Center   Special Education School No Other KG 12 2021   pk_12_total 12 87 12     *                                       114 12 87 12                                       114
1316740 MD     school 2400510 16   Prince George's 240051001176 1706 Thomas S. Stone Elementary   Regular School No Elementary PK 05 2021   pk_12_total 12 87 360   * *     *                                 466 12 87 360                                       466
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
1244205 MD     school 2400510 16   Prince George's 240051001139 1713 Cesar Chavez Elementary   Regular School No Elementary KG 05 2020   pk_12_total 41 86 219   * *     *                                 354 41 86 219                                       354
1244761 MD     school 2400600 18   Saint Mary's 240060001685 606 Evergreen Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 515 86 100   * 35     *   75                             813 515 86 100     35         75                       813
1245823 MD     school 2400090 30   Baltimore City 240009000323 84 Thomas Johnson Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 381 86 44     *     *   32                             548 381 86 44               32                       548
1310595 MD     school 2400060 2   Anne Arundel 240006000064 4142 Eastport Elementary   Regular School No Elementary PK 05 2021   pk_12_total 39 86 147   * *         *                             283 39 86 147                                       283
1315377 MD     school 2400480 15   Montgomery 240048000873 770 Flora M. Singer Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 210 86 230   * 42         43                             613 210 86 230     42         43                       613
1318388 MD     school 2400090 30   Baltimore City 240009000323 84 Thomas Johnson Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 354 86 47     *     *   25                             516 354 86 47               25                       516
1243733 MD     school 2400510 16   Prince George's 240051001123 1209 Oxon Hill High   Regular School No High 09 12 2020   pk_12_total 31 859 451   * 114     *   31                             1497 31 859 451     114         31                       1497
1246802 MD     school 2400090 30   Baltimore City 240009000168 454 Carver Vocational-Technical High   Career and Technical School No High 09 12 2020   pk_12_total * 859 13   * *         *                             885   859 13                                       885
1241358 MD     school 2400420 13   Howard 240042000173 216 Burleigh Manor Middle School   Regular School No Middle 06 08 2020   pk_12_total 242 85 34   * 404         41                             811 242 85 34     404         41                       811
1241503 MD     school 2400420 13   Howard 240042001382 520 Clemens Crossing Elementary   Regular School No Elementary KG 05 2020   pk_12_total 248 85 49   * 80     *   44                             508 248 85 49     80         44                       508

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