enrollments

Data source: Big Local News · About: Big Local

9,598 rows where state = "MD" and year = 2021 sorted by hispanic descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 9,598 ✖
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
1310038 1310038 MD     school 2400060 2   Anne Arundel 240006000116 1212 Point Pleasant Elementary   Regular School No Elementary PK 05 2021   pk_12_total 289 69 99     12         41                             510 289 69 99     12         41                       510
1311404 1311404 MD     school 2400120 3   Baltimore County 240012000487 971 Towson High   Regular School No High 09 12 2021   pk_12_total 1036 303 99   * 133     *   102                             1677 1036 303 99     133         102                       1677
1317586 1317586 MD     school 2400660 21   Washington 240066001707 328 Ruth Ann Monroe Primary   Regular School No Elementary PK 02 2021   pk_12_total 176 178 99   * 22         79                             556 176 178 99     22         79                       556
1319317 1319317 MD     school 2400090 30   Baltimore City 240009001381 427 Academy for College and Career Exploration   Regular School No High 06 12 2021   pk_12_total 44 556 99   * *     *   *                             715 44 556 99                                       715
1310498 1310498 MD     school 2400060 2   Anne Arundel 240006000120 3392 Rippling Woods Elementary   Regular School No Elementary PK 05 2021   pk_12_total 180 240 98     19         40                             577 180 240 98     19         40                       577
1312738 1312738 MD     school 2400270 8   Charles 240027001647 625 Theodore G. Davis Middle School   Regular School No Middle 06 08 2021   pk_12_total 70 601 98   * 30     *   79                             885 70 601 98     30         79                       885
1314931 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
1315925 1315925 MD     school 2400510 16   Prince George's 240051001136 619 Princeton Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 177 98   * *         *                             286   177 98                                       286
1309967 1309967 MD     school 2400060 2   Anne Arundel 240006001515 1122 Freetown Elementary   Regular School No Elementary PK 05 2021   pk_12_total 140 215 97   * 14     *   39                             508 140 215 97     14         39                       508
1310390 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
1310430 1310430 MD     school 2400060 2   Anne Arundel 240006002944 3242 Piney Orchard Elementary   Regular School No Elementary KG 05 2021   pk_12_total 386 204 97   * 51     *   64                             808 386 204 97     51         64                       808
1316373 1316373 MD     school 2400510 16   Prince George's 240051000972 1221 Avalon Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 174 97   * *     *   *                             285   174 97                                       285
1317839 1317839 MD     school 2400690 22   Wicomico 240069001298 514 Beaver Run School   Regular School No Elementary PK 02 2021   pk_12_total 125 263 97     *         56                             546 125 263 97               56                       546
1316957 1316957 MD     school 2400510 16   Prince George's 240051001186 1908 William Wirt Middle   Regular School No Middle 06 08 2021   pk_12_total 25 219 962   * 64     *   *                             1280 25 219 962     64                                 1280
1312688 1312688 MD     school 2400270 8   Charles 240027010501 617 Daniel of St. Thomas Jenifer Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 27 411 96   * 17         42                             595 27 411 96     17         42                       595
1313825 1313825 MD     school 2400420 13   Howard 240042001172 108 Bonnie Branch Middle   Regular School No Middle 06 08 2021   pk_12_total 236 166 96     142         53                             693 236 166 96     142         53                       693
1310397 1310397 MD     school 2400060 2   Anne Arundel 240006000119 3192 Ridgeway Elementary   Regular School No Elementary KG 05 2021   pk_12_total 285 148 95   * 34     *   68                             632 285 148 95     34         68                       632
1312418 1312418 MD     school 2400240 7   Cecil 240024000567 303 Elkton Middle   Regular School No Middle 06 08 2021   pk_12_total 216 178 95   * *     *   76                             574 216 178 95               76                       574
1312758 1312758 MD     school 2400270 8   Charles 240027000599 701 Matthew Henson Middle School   Regular School No Middle 06 08 2021   pk_12_total 73 529 95   * 17     *   65                             784 73 529 95     17         65                       784
1314259 1314259 MD     school 2400420 13   Howard 240042001032 625 Gorman Crossing Elementary   Regular School No Elementary PK 05 2021   pk_12_total 144 266 95   * 230     *   49                             786 144 266 95     230         49                       786
1310241 1310241 MD     school 2400060 2   Anne Arundel 240006000058 2273 Chesapeake High   Regular School No High 09 12 2021   pk_12_total 1183 57 94   * 27     *   43                             1412 1183 57 94     27         43                       1412
1315848 1315848 MD     school 2400510 16   Prince George's 240051001132 510 Potomac Landing Elementary   Regular School No Elementary PK 06 2021   pk_12_total 14 272 94   * 24     *   *                             412 14 272 94     24                                 412
1316152 1316152 MD     school 2400510 16   Prince George's 240051001072 909 James Ryder Randall Elementary   Regular School No Elementary KG 05 2021   pk_12_total * 166 94     *         *                             271   166 94                                       271
1311571 1311571 MD     school 2400120 3   Baltimore County 240012000470 1216 Sandy Plains Elementary   Regular School No Elementary PK 05 2021   pk_12_total 250 114 93   * 19         51                             534 250 114 93     19         51                       534
1311880 1311880 MD     school 2400120 3   Baltimore County 240012000478 1554 Stemmers Run Middle   Regular School No Middle 06 08 2021   pk_12_total 379 249 93   11 18         56                             806 379 249 93   11 18         56                       806
1313056 1313056 MD     school 2400330 10   Frederick 240033000392 714 Windsor Knolls Middle   Regular School No Middle 06 08 2021   pk_12_total 487 48 93     43     *   37                             709 487 48 93     43         37                       709
1316021 1316021 MD     school 2400510 16   Prince George's 240051001556 656 Panorama Elementary   Regular School No Elementary PK 06 2021   pk_12_total * 408 93   * *     *   *                             529   408 93                                       529
1318245 1318245 MD     school 2400090 30   Baltimore City 240009000276 53 Margaret Brent Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 27 161 93   *       *   *                             294 27 161 93                                       294
1316825 1316825 MD     school 2400510 16   Prince George's 240051001257 1730 Mary Harris   Regular School No Elementary PK 05 2021   pk_12_total * 44 927   * *     *   *                             991   44 927                                       991
1317017 1317017 MD     school 2400510 16   Prince George's 240051001004 2011 Charles Carroll Middle   Regular School No Middle 06 08 2021   pk_12_total 23 356 922   * 25         *                             1330 23 356 922     25                                 1330
1310219 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
1311262 1311262 MD     school 2400120 3   Baltimore County 240012001722 814 Mays Chapel Elementary   Regular School No Elementary PK 05 2021   pk_12_total 279 106 92   * 142         45                             668 279 106 92     142         45                       668
1312260 1312260 MD     school 2400210 6   Carroll 240021000554 705 William Winchester Elementary   Regular School No Elementary PK 05 2021   pk_12_total 314 41 92     10         26                             483 314 41 92     10         26                       483
1313437 1313437 MD     school 2400390 12   Harford 240039000686 120 Deerfield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 168 352 92   * 12     *   93                             720 168 352 92     12         93                       720
1316176 1316176 MD     school 2400510 16   Prince George's 240051001035 916 Francis T. Evans Elementary   Regular School No Elementary PK 05 2021   pk_12_total 33 216 92   * *     *   11                             363 33 216 92               11                       363
1315489 1315489 MD     school 2400480 15   Montgomery 240048000773 789 Albert Einstein High   Regular School No High 09 12 2021   pk_12_total 462 336 916   * 117         83                             1921 462 336 916     117         83                       1921
1312627 1312627 MD     school 2400270 8   Charles 240027000585 604 Dr. Samuel A. Mudd Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 33 402 91   * *         29                             566 33 402 91               29                       566
1316282 1316282 MD     school 2400510 16   Prince George's 240051001121 1201 Oxon Hill Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 112 91     14         *                             228   112 91     14                                 228
1317004 1317004 MD     school 2400510 16   Prince George's 240051000970 2008 Ardmore Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 334 91     *     *   *                             434   334 91                                       434
1317581 1317581 MD     school 2400660 21   Washington 240066001667 325 Rockland Woods Elementary   Regular School No Elementary PK 05 2021   pk_12_total 323 112 91   * 19     *   55                             604 323 112 91     19         55                       604
1318692 1318692 MD     school 2400090 30   Baltimore City 240009000284 220 Morrell Park Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 166 146 91   * 14     *   22                             443 166 146 91     14         22                       443
1316799 1316799 MD     school 2400510 16   Prince George's 240051001112 1718 Nicholas Orem Middle   Regular School No Middle 06 08 2021   pk_12_total 18 201 905   * *     *   *                             1139 18 201 905                                       1139
1310420 1310420 MD     school 2400060 2   Anne Arundel 240006000138 3222 Waugh Chapel Elementary   Regular School No Elementary PK 05 2021   pk_12_total 300 135 90   * 58     *   44                             631 300 135 90     58         44                       631
1313650 1313650 MD     school 2400390 12   Harford 240039001397 372 Bel Air Middle   Regular School No Middle 06 08 2021   pk_12_total 1067 113 90   * 106     *   61                             1441 1067 113 90     106         61                       1441
1314197 1314197 MD     school 2400420 13   Howard 240042000740 613 Jeffers Hill Elementary   Regular School No Elementary KG 05 2021   pk_12_total 77 144 90     41         21                             373 77 144 90     41         21                       373
1315524 1315524 MD     school 2400480 15   Montgomery 240048001366 796 Northwood High School   Regular School No High 09 12 2021   pk_12_total 227 438 899   * 86         57                             1708 227 438 899     86         57                       1708
1312001 1312001 MD     school 2400150 4   Calvert 240015000508 213 Calvert High   Regular School No High 09 12 2021   pk_12_total 696 222 89   * 24     *   96                             1132 696 222 89     24         96                       1132
1312701 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
1314893 1314893 MD     school 2400480 15   Montgomery 240048000963 422 Wyngate Elementary   Regular School No Elementary PK 05 2021   pk_12_total 404 28 89     95     *   56                             673 404 28 89     95         56                       673
1315953 1315953 MD     school 2400510 16   Prince George's 240051001184 636 William Beanes Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 325 89           *   *                             428   325 89                                       428
1310095 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
1311017 1311017 MD     school 2400120 3   Baltimore County 240012000372 254 Deer Park Middle Magnet School   Regular School No Middle 06 08 2021   pk_12_total 33 1297 88   * 34         38                             1495 33 1297 88     34         38                       1495
1315047 1315047 MD     school 2400480 15   Montgomery 240048001525 545 Watkins Mill High   Regular School No High 09 12 2021   pk_12_total 103 418 876   * 153     *   44                             1597 103 418 876     153         44                       1597
1316543 1316543 MD     school 2400510 16   Prince George's 240051001023 1409 Duval High   Regular School No High 09 12 2021   pk_12_total 53 1187 872   * 60     *   20                             2206 53 1187 872     60         20                       2206
1310006 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
1310264 1310264 MD     school 2400060 2   Anne Arundel 240006000124 2413 Severn River Middle   Regular School No Middle 06 08 2021   pk_12_total 588 67 87   * 16         41                             801 588 67 87     16         41                       801
1312038 1312038 MD     school 2400150 4   Calvert 240015000516 314 Northern High   Regular School No High 09 12 2021   pk_12_total 1096 166 87   * 33     *   94                             1483 1096 166 87     33         94                       1483
1313506 1313506 MD     school 2400390 12   Harford 240039000705 181 Joppatowne High   Regular School No High 09 12 2021   pk_12_total 202 421 87   * *     *   61                             782 202 421 87               61                       782
1314774 1314774 MD     school 2400480 15   Montgomery 240048001721 341 Wilson Wims Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 137 119 87   * 252     *   26                             624 137 119 87     252         26                       624
1315511 1315511 MD     school 2400480 15   Montgomery 240048000915 794 Rosemary Hills Elementary   Regular School No Elementary PK 02 2021   pk_12_total 214 150 87     28     *   36                             516 214 150 87     28         36                       516
1315867 1315867 MD     school 2400510 16   Prince George's 240051000991 606 Bradbury Heights Elementary   Regular School No Elementary PK 06 2021   pk_12_total * 382 87     *     *   *                             478   382 87                                       478
1316339 1316339 MD     school 2400510 16   Prince George's 240051001150 1216 Samuel Chase Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 200 87     *         *                             301   200 87                                       301
1316848 1316848 MD     school 2400510 16   Prince George's 240051001155 1802 Seat Pleasant Elementary   Regular School No Elementary PK 06 2021   pk_12_total * 241 87   * *         *                             345   241 87                                       345
1311133 1311133 MD     school 2400120 3   Baltimore County 240012001346 407 Glyndon Elementary   Regular School No Elementary PK 05 2021   pk_12_total 80 281 86   * 21     *   38                             512 80 281 86     21         38                       512
1311498 1311498 MD     school 2400120 3   Baltimore County 240012000447 1151 Perry Hall Middle   Regular School No Middle 06 08 2021   pk_12_total 885 502 86   * 312     *   86                             1878 885 502 86     312         86                       1878
1314165 1314165 MD     school 2400420 13   Howard 240042000754 608 Stevens Forest Elementary   Regular School No Elementary PK 05 2021   pk_12_total 62 134 86   * 25     *   38                             347 62 134 86     25         38                       347
1314205 1314205 MD     school 2400420 13   Howard 240042001699 616 Cradlerock Elementary   Regular School No Elementary PK 05 2021   pk_12_total 89 214 86   * 27         39                             456 89 214 86     27         39                       456
1314923 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
1315888 1315888 MD     school 2400510 16   Prince George's 240051001113 610 North Forestville Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 158 86   * *         *                             253   158 86                                       253
1315908 1315908 MD     school 2400510 16   Prince George's 240051001050 617 Francis Scott Key Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 348 86     *         *                             445   348 86                                       445
1309959 1309959 MD     school 2400060 2   Anne Arundel 240006000071 1112 George T. Cromwell Elementary   Regular School No Elementary KG 05 2021   pk_12_total 169 48 85   * *     *   19                             333 169 48 85               19                       333
1310046 1310046 MD     school 2400060 2   Anne Arundel 240006000117 1232 Quarterfield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 146 116 85     47     *   49                             445 146 116 85     47         49                       445
1317715 1317715 MD     school 2400660 21   Washington 240066001253 1701 Bester Elementary   Regular School No Elementary PK 05 2021   pk_12_total 176 131 85   * *         94                             491 176 131 85               94                       491
1311026 1311026 MD     school 2400120 3   Baltimore County 240012000432 271 Milford Mill Academy   Regular School No High 09 12 2021   pk_12_total 22 1155 84   * 15         33                             1312 22 1155 84     15         33                       1312
1312265 1312265 MD     school 2400210 6   Carroll 240021000552 707 Westminster High   Regular School No High 09 12 2021   pk_12_total 1242 70 84   * 56     *   59                             1515 1242 70 84     56         59                       1515
1312709 1312709 MD     school 2400270 8   Charles 240027000380 620 C. Paul Barnhart Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 13 439 84     24         49                             609 13 439 84     24         49                       609
1312721 1312721 MD     school 2400270 8   Charles 240027000805 622 Berry Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 59 404 84   * 55     *   68                             675 59 404 84     55         68                       675
1313306 1313306 MD     school 2400330 10   Frederick 240033001409 2525 Brunswick Middle   Regular School No Middle 06 08 2021   pk_12_total 427 42 84   * *         49                             610 427 42 84               49                       610
1314509 1314509 MD     school 2400480 15   Montgomery 240048000828 219 Farmland Elementary   Regular School No Elementary PK 05 2021   pk_12_total 326 76 84   * 255         32                             774 326 76 84     255         32                       774
1318798 1318798 MD     school 2400090 30   Baltimore City 240009000146 234 Arlington Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 313 84               *                             405   313 84                                       405
1310522 1310522 MD     school 2400060 2   Anne Arundel 240006000037 4013 Annapolis High   Regular School No High 09 12 2021   pk_12_total 638 547 835   * 51     *   60                             2134 638 547 835     51         60                       2134
1311254 1311254 MD     school 2400120 3   Baltimore County 240012000491 813 Warren Elementary   Regular School No Elementary PK 05 2021   pk_12_total 104 156 83   * 13         *                             367 104 156 83     13                                 367
1312243 1312243 MD     school 2400210 6   Carroll 240021000550 701 Westminster East Middle   Regular School No Middle 06 08 2021   pk_12_total 538 59 83     16     *   33                             730 538 59 83     16         33                       730
1312766 1312766 MD     school 2400270 8   Charles 240027000592 703 J. C. Parks Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 52 364 83   * 20     *   67                             592 52 364 83     20         67                       592
1314090 1314090 MD     school 2400420 13   Howard 240042000816 524 River Hill High   Regular School No High 09 12 2021   pk_12_total 643 139 83   * 515         89                             1470 643 139 83     515         89                       1470
1315456 1315456 MD     school 2400480 15   Montgomery 240048000892 783 Kensington Parkwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 346 52 83     56         59                             596 346 52 83     56         59                       596
1317874 1317874 MD     school 2400690 22   Wicomico 240069001145 910 Salisbury Middle   Regular School No Middle 06 08 2021   pk_12_total 222 475 83   * 41     *   69                             897 222 475 83     41         69                       897
1315677 1315677 MD     school 2400510 16   Prince George's 240051000978 104 Beltsville Academy   Regular School No Elementary PK 08 2021   pk_12_total 65 187 820   * 51         15                             1143 65 187 820     51         15                       1143
1311085 1311085 MD     school 2400120 3   Baltimore County 240012000449 371 Pikesville High   Regular School No High 09 12 2021   pk_12_total 312 431 82   * 48     *   29                             905 312 431 82     48         29                       905
1313302 1313302 MD     school 2400330 10   Frederick 240033000626 2504 Brunswick Elementary   Regular School No Elementary PK 05 2021   pk_12_total 478 63 82   * 18         51                             694 478 63 82     18         51                       694
1313901 1313901 MD     school 2400420 13   Howard 240042000722 214 Centennial High   Regular School No High 09 12 2021   pk_12_total 566 131 82     611     *   75                             1467 566 131 82     611         75                       1467
1316266 1316266 MD     school 2400510 16   Prince George's 240051001051 1104 Gwynn Park Middle   Regular School No Middle 06 08 2021   pk_12_total 27 526 82   * *     *   20                             662 27 526 82               20                       662
1310260 1310260 MD     school 2400060 2   Anne Arundel 240006001516 2372 Windsor Farm Elementary   Regular School No Elementary KG 05 2021   pk_12_total 338 46 81   * 13         35                             515 338 46 81     13         35                       515
1312281 1312281 MD     school 2400210 6   Carroll 240021000544 711 Robert Moton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 227 45 81     *     *   27                             387 227 45 81               27                       387
1313294 1313294 MD     school 2400330 10   Frederick 240033000627 2503 Brunswick High   Regular School No High 09 12 2021   pk_12_total 590 66 81   * 12         47                             797 590 66 81     12         47                       797
1313624 1313624 MD     school 2400390 12   Harford 240039000701 335 Homestead/Wakefield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 710 54 81   * 70     *   75                             996 710 54 81     70         75                       996
1314018 1314018 MD     school 2400420 13   Howard 240042000763 512 Wilde Lake Middle   Regular School No Middle 06 08 2021   pk_12_total 154 301 81     43         62                             641 154 301 81     43         62                       641
1314146 1314146 MD     school 2400420 13   Howard 240042000757 605 Thunder Hill Elementary   Regular School No Elementary KG 05 2021   pk_12_total 118 162 81   * 89         29                             481 118 162 81     89         29                       481
1314578 1314578 MD     school 2400480 15   Montgomery 240048001447 237 Robert Frost Middle School   Regular School No Middle 06 08 2021   pk_12_total 375 105 81   * 399     *   54                             1017 375 105 81     399         54                       1017
1315282 1315282 MD     school 2400480 15   Montgomery 240048000959 704 Woodfield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 160 34 81     22         20                             317 160 34 81     22         20                       317

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