enrollments

Data source: Big Local News · About: Big Local

1,393 rows where grade = "pk_12_total", state = "MD" and year = 2021 sorted by black_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 1,393 ✖

grade ✖

  • pk_12_total · 1,393 ✖
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
1309844 1309844 MD     school 2400030 1   Allegany 240003000005 702 Bel Air Elementary   Regular School No Elementary PK 05 2021   pk_12_total 202   *     *         *                             216 202                                           216
1309856 1309856 MD     school 2400030 1   Allegany 240003000007 802 Westmar Middle   Regular School No Middle 06 08 2021   pk_12_total 241   *               *                             256 241                                           256
1309864 1309864 MD     school 2400030 1   Allegany 240003000017 1001 George's Creek Elementary   Regular School No Elementary PK 05 2021   pk_12_total 241         *         *                             244 241                                           244
1309872 1309872 MD     school 2400030 1   Allegany 240003000016 1101 Frost Elementary   Regular School No Elementary PK 05 2021   pk_12_total 179   *     *         *                             192 179                                           192
1310760 1310760 MD     school 2400120 3   Baltimore County 240012001760 56 Central EDLP at Loch Raven High School   Alternative School No High 12 12 2021   pk_12_total *                                                 *                                              
1312321 1312321 MD     school 2400210 6   Carroll 240021001694 726 Crossroads Middle School   Alternative School No Middle 07 08 2021   pk_12_total *   *                                             *                                              
1312564 1312564 MD     school 2400240 7   Cecil 240024000559 904 Calvert Elementary   Regular School No Elementary PK 05 2021   pk_12_total 375   19   *           *                             404 375   19                                       404
1313181 1313181 MD     school 2400330 10   Frederick 240033000650 1503 Thurmont Elementary   Regular School No Elementary 03 05 2021   pk_12_total 256   22   *           12                             292 256   22               12                       292
1313195 1313195 MD     school 2400330 10   Frederick 240033001166 1511 Thurmont Primary   Regular School No Elementary PK 02 2021   pk_12_total 258   12     *         13                             284 258   12               13                       284
1313339 1313339 MD     school 2400360 11   Garrett 240036000667 1202 Friendsville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 131   *               *                             140 131                                           140
1313347 1313347 MD     school 2400360 11   Garrett 240036000668 1301 Grantsville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 171                   *                             172 171                                           172
1313354 1313354 MD     school 2400360 11   Garrett 240036000665 1408 Crellin Elementary   Regular School No Elementary KG 05 2021   pk_12_total 118   *               *                             123 118                                           123
1313362 1313362 MD     school 2400360 11   Garrett 240036000662 1501 Accident Elementary   Regular School No Elementary PK 05 2021   pk_12_total 221   12               *                             242 221   12                                       242
1313378 1313378 MD     school 2400360 11   Garrett 240036000852 1710 Yough Glades Elementary   Regular School No Elementary PK 05 2021   pk_12_total 271   *               *                             284 271                                           284
1313388 1313388 MD     school 2400360 11   Garrett 240036000676 1812 Swan Meadow School   Regular School No Elementary KG 08 2021   pk_12_total 44   *                                             45 44                                           45
1313396 1313396 MD     school 2400360 11   Garrett 240036000673 1904 Route 40 Elementary   Regular School No Elementary PK 05 2021   pk_12_total 117   *               *                             119 117                                           119
1313400 1313400 MD     school 2400360 11   Garrett 240036001351 2511 Northern Middle School   Regular School No Middle 06 08 2021   pk_12_total 342   *     *         *                             355 342                                           355
1313409 1313409 MD     school 2400360 11   Garrett 240036000671 3512 Northern Garrett High School   Regular School No High 09 12 2021   pk_12_total 440   11     *         *                             461 440   11                                       461
1313702 1313702 MD     school 2400390 12   Harford 240039000708 441 Norrisville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 192   *               *                             205 192                                           205
1317447 1317447 MD     school 2400570 19   Somerset 240057001203 1003 Ewell School   Regular School No Middle 01 07 2021   pk_12_total *                                                 *                                              
1317515 1317515 MD     school 2400630 20   Talbot 240063001250 501 Tilghman Elementary   Regular School No Elementary PK 05 2021   pk_12_total 81   *               *                             86 81                                           86
1317611 1317611 MD     school 2400660 21   Washington 240066001270 501 Hancock Middle Senior High   Regular School No High 06 12 2021   pk_12_total 226   *     *         *                             235 226                                           235
1316474 1316474 MD     school 2400510 16   Prince George's 240051002951 1327 Charles Herbert Flowers High   Regular School No High 09 12 2021   pk_12_total 15 2057 204   * 32     *   28                             2342 15 2057 204     32         28                       2342
1316683 1316683 MD     school 2400510 16   Prince George's 240051001542 1519 Dr. Henry A. Wise, Jr. High   Regular School No High 09 12 2021   pk_12_total 44 1881 318   * 12     *   28                             2294 44 1881 318     12         28                       2294
1315858 1315858 MD     school 2400510 16   Prince George's 240051001164 603 Suitland High   Regular School No High 09 12 2021   pk_12_total 28 1806 185   * *     *   15                             2047 28 1806 185               15                       2047
1316592 1316592 MD     school 2400510 16   Prince George's 240051000990 1423 Bowie High   Regular School No High 09 12 2021   pk_12_total 237 1608 381   * 94     *   76                             2406 237 1608 381     94         76                       2406
1319271 1319271 MD     school 2400090 30   Baltimore City 240009000280 410 Mergenthaler Vocational-Technical High   Career and Technical School No High 09 12 2021   pk_12_total 51 1577 145     *     *   *                             1785 51 1577 145                                       1785
1319150 1319150 MD     school 2400090 30   Baltimore City 240009001681 347 KIPP Harmony Academy   Regular School Yes Elementary KG 08 2021   pk_12_total * 1542 21   * *     *   *                             1575   1542 21                                       1575
1317106 1317106 MD     school 2400510 16   Prince George's 240051001027 2114 Eleanor Roosevelt High   Regular School No High 09 12 2021   pk_12_total 252 1426 569   * 225     *   59                             2546 252 1426 569     225         59                       2546
1316243 1316243 MD     school 2400510 16   Prince George's 240051001708 1015 Chesapeake Math and IT Public Charter   Regular School Yes Other KG 12 2021   pk_12_total 56 1363 165   * 69     *   23                             1683 56 1363 165     69         23                       1683
1316526 1316526 MD     school 2400510 16   Prince George's 240051001726 1351 Chesapeake Math and IT South Public Charter   Regular School Yes Other KG 12 2021   pk_12_total 13 1322 24   * 17     *   10                             1393 13 1322 24     17         10                       1393
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
1310895 1310895 MD     school 2400120 3   Baltimore County 240012000502 172 Woodlawn High   Regular School No High 09 12 2021   pk_12_total 48 1265 247   * 86     *   22                             1680 48 1265 247     86         22                       1680
1314714 1314714 MD     school 2400480 15   Montgomery 240048000890 315 Paint Branch High   Regular School No High 09 12 2021   pk_12_total 86 1218 451   * 257         49                             2064 86 1218 451     257         49                       2064
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
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
1315839 1315839 MD     school 2400510 16   Prince George's 240051001686 509 Accokeek Academy   Regular School No Elementary KG 08 2021   pk_12_total 57 1150 216   * 66     12   38                             1543 57 1150 216     66     12   38                       1543
1312726 1312726 MD     school 2400270 8   Charles 240027001416 623 North Point High School   Regular School No High 09 12 2021   pk_12_total 286 1130 141   * 108     *   139                             1813 286 1130 141     108         139                       1813
1311167 1311167 MD     school 2400120 3   Baltimore County 240012001547 473 New Town High   Regular School No High 09 12 2021   pk_12_total 16 1117 27   * 13         40                             1214 16 1117 27     13         40                       1214
1319266 1319266 MD     school 2400090 30   Baltimore City 240009000330 407 Western High   Regular School No High 09 12 2021   pk_12_total 56 1090 68   * 11     *   *                             1236 56 1090 68     11                                 1236
1316201 1316201 MD     school 2400510 16   Prince George's 240051001092 1008 Laurel High   Regular School No High 09 12 2021   pk_12_total 71 1069 728   * 75     *   35                             1986 71 1069 728     75         35                       1986
1310454 1310454 MD     school 2400060 2   Anne Arundel 240006000099 3323 Meade High   Regular School No High 09 12 2021   pk_12_total 245 1030 549   * 113     10   136                             2087 245 1030 549     113     10   136                       2087
1311031 1311031 MD     school 2400120 3   Baltimore County 240012000458 272 Randallstown High   Regular School No High 09 12 2021   pk_12_total 16 1001 44     22         14                             1097 16 1001 44     22         14                       1097
1312798 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 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 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
1319352 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
1318888 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
1319347 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
1311409 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
1318768 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
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
1319291 1319291 MD     school 2400090 30   Baltimore City 240009001313 416 Digital Harbor High School   Career and Technical School No High 09 12 2021   pk_12_total 77 846 373   * *     *   *                             1315 77 846 373                                       1315
1319221 1319221 MD     school 2400090 30   Baltimore City 240009001691 377 Green Street Academy   Regular School Yes High 06 12 2021   pk_12_total 15 843 17     *                                       876 15 843 17                                       876
1316365 1316365 MD     school 2400510 16   Prince George's 240051001133 1220 Potomac High   Regular School No High 09 12 2021   pk_12_total 10 835 312   * 10     *   12                             1187 10 835 312     10         12                       1187
1310467 1310467 MD     school 2400060 2   Anne Arundel 240006000109 3353 Old Mill High   Regular School No High 09 12 2021   pk_12_total 906 829 344   * 117     10   153                             2364 906 829 344     117     10   153                       2364
1316315 1316315 MD     school 2400510 16   Prince George's 240051001123 1209 Oxon Hill High   Regular School No High 09 12 2021   pk_12_total 36 827 451   * 107     10   30                             1467 36 827 451     107     10   30                       1467
1319246 1319246 MD     school 2400090 30   Baltimore City 240009000194 400 Edmondson-Westside High   Career and Technical School No High 09 12 2021   pk_12_total 11 826 24   * *     *   *                             867 11 826 24                                       867
1319281 1319281 MD     school 2400090 30   Baltimore City 240009000298 414 Paul Laurence Dunbar High   Regular School No High 09 12 2021   pk_12_total 22 826 66   * *     *   *                             928 22 826 66                                       928
1316262 1316262 MD     school 2400510 16   Prince George's 240051001052 1103 Gwynn Park High   Regular School No High 09 12 2021   pk_12_total 31 825 117   * 16     *   28                             1025 31 825 117     16         28                       1025
1316446 1316446 MD     school 2400510 16   Prince George's 240051001089 1314 Largo High   Regular School No High 09 12 2021   pk_12_total * 817 67   * *     *   10                             909   817 67               10                       909
1315337 1315337 MD     school 2400480 15   Montgomery 240048000877 757 Montgomery Blair High   Regular School No High 09 12 2021   pk_12_total 780 773 1106   * 414     *   139                             3220 780 773 1106     414         139                       3220
1312713 1312713 MD     school 2400270 8   Charles 240027000615 621 Mattawoman Middle School   Regular School No Middle 06 08 2021   pk_12_total 37 756 116   * 54     *   56                             1024 37 756 116     54         56                       1024
1318953 1318953 MD     school 2400090 30   Baltimore City 240009001390 256 Calvin M. Rodwell Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 753 46   * *         *                             817   753 46                                       817
1311717 1311717 MD     school 2400120 3   Baltimore County 240012000438 1473 Overlea High   Regular School No High 09 12 2021   pk_12_total 181 751 119   * 39     *   52                             1148 181 751 119     39         52                       1148
1314727 1314727 MD     school 2400480 15   Montgomery 240048001044 321 James Hubert Blake High   Regular School No High 09 12 2021   pk_12_total 277 751 540   * 179         64                             1815 277 751 540     179         64                       1815
1316662 1316662 MD     school 2400510 16   Prince George's 240051001475 1510 James Madison Middle   Regular School No Middle 06 08 2021   pk_12_total 19 743 110   * *     *   *                             895 19 743 110                                       895
1316078 1316078 MD     school 2400510 16   Prince George's 240051000982 714 Benjamin Tasker Middle School   Regular School No Middle 06 08 2021   pk_12_total 129 718 127   * 53     *   28                             1068 129 718 127     53         28                       1068
1316962 1316962 MD     school 2400510 16   Prince George's 240051001126 1909 Parkdale High   Regular School No High 09 12 2021   pk_12_total 80 717 1560   * 74     *   15                             2453 80 717 1560     74         15                       2453
1316469 1316469 MD     school 2400510 16   Prince George's 240051001472 1326 Kettering Middle   Regular School No Middle 06 08 2021   pk_12_total * 714 130     *     *   11                             875   714 130               11                       875
1318423 1318423 MD     school 2400090 30   Baltimore City 240009000273 88 Wildwood Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 713 15           *   *                             734   713 15                                       734
1312632 1312632 MD     school 2400270 8   Charles 240027000607 605 Thomas Stone High School   Regular School No High 09 12 2021   pk_12_total 138 708 186   * 19     *   59                             1115 138 708 186     19         59                       1115
1311897 1311897 MD     school 2400120 3   Baltimore County 240012000412 1572 Kenwood High   Regular School No High 09 12 2021   pk_12_total 623 705 194   * 44     *   103                             1679 623 705 194     44         103                       1679
1316507 1316507 MD     school 2400510 16   Prince George's 240051001223 1348 Ernest Everett Just Middle   Regular School No Middle 06 08 2021   pk_12_total * 705 67   * *     *   *                             802   705 67                                       802
1314628 1314628 MD     school 2400480 15   Montgomery 240048001541 249 Clarksburg High   Regular School No High 09 12 2021   pk_12_total 403 702 585   * 559         111                             2365 403 702 585     559         111                       2365
1311009 1311009 MD     school 2400120 3   Baltimore County 240012001431 252 Northwest Academy of Health Sciences   Regular School No Middle 06 08 2021   pk_12_total 17 695 46   * *     *   12                             784 17 695 46               12                       784
1319342 1319342 MD     school 2400090 30   Baltimore City 240009000209 450 Frederick Douglass High   Regular School No High 09 12 2021   pk_12_total 13 687 55     *         *                             759 13 687 55                                       759
1313497 1313497 MD     school 2400390 12   Harford 240039000690 176 Edgewood High   Regular School No High 09 12 2021   pk_12_total 412 678 169   * 43     *   102                             1413 412 678 169     43         102                       1413
1316450 1316450 MD     school 2400510 16   Prince George's 240051001211 1320 G. James Gholson Middle   Regular School No Middle 06 08 2021   pk_12_total * 676 254   * *         *                             949   676 254                                       949
1316678 1316678 MD     school 2400510 16   Prince George's 240051001697 1518 Barack Obama Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 675 41     *     *   13                             743   675 41               13                       743
1314615 1314615 MD     school 2400480 15   Montgomery 240048001040 246 Northwest High   Regular School No High 09 12 2021   pk_12_total 655 674 588   * 551         129                             2598 655 674 588     551         129                       2598
1318820 1318820 MD     school 2400090 30   Baltimore City 240009000231 236 Hamilton Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 93 673 50   * 10     *   26                             854 93 673 50     10         26                       854
1319122 1319122 MD     school 2400090 30   Baltimore City 240009001663 341 The Reach! Partnership School   Regular School No High 09 12 2021   pk_12_total * 672 14               *                             695   672 14                                       695
1317136 1317136 MD     school 2400510 16   Prince George's 240051001049 2141 Greenbelt Middle   Regular School No Middle 06 08 2021   pk_12_total 102 671 562   * 91     *   35                             1471 102 671 562     91         35                       1471
1310999 1310999 MD     school 2400120 3   Baltimore County 240012001159 217 New Town Elementary   Regular School No Elementary PK 05 2021   pk_12_total 40 667 35   * 34     *   34                             818 40 667 35     34         34                       818
1316025 1316025 MD     school 2400510 16   Prince George's 240051001034 660 Drew Freeman Middle   Regular School No Middle 06 08 2021   pk_12_total * 662 157   * *     *   *                             838   662 157                                       838
1315537 1315537 MD     school 2400480 15   Montgomery 240048000926 798 Springbrook High   Regular School No High 09 12 2021   pk_12_total 104 660 665   * 218     *   45                             1694 104 660 665     218         45                       1694
1318332 1318332 MD     school 2400090 30   Baltimore City 240009000285 66 Mount Royal Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 77 660 26   * *     *   *                             781 77 660 26                                       781
1311503 1311503 MD     school 2400120 3   Baltimore County 240012000446 1171 Perry Hall High   Regular School No High 09 12 2021   pk_12_total 904 659 107   * 256     *   85                             2018 904 659 107     256         85                       2018
1316344 1316344 MD     school 2400510 16   Prince George's 240051001017 1217 Crossland High   Regular School No High 09 12 2021   pk_12_total 10 656 274   * 10     *   *                             957 10 656 274     10                                 957
1318398 1318398 MD     school 2400090 30   Baltimore City 240009000204 85 Fort Worthington Elementary/Middle   Regular School No Elementary KG 08 2021   pk_12_total 10 656 55   * *         *                             736 10 656 55                                       736
1314039 1314039 MD     school 2400420 13   Howard 240042000762 516 Wilde Lake High   Regular School No High 09 12 2021   pk_12_total 328 654 187   * 100     *   105                             1379 328 654 187     100         105                       1379
1311162 1311162 MD     school 2400120 3   Baltimore County 240012000390 472 Franklin High   Regular School No High 09 12 2021   pk_12_total 429 647 190   * 109     *   76                             1457 429 647 190     109         76                       1457
1318453 1318453 MD     school 2400090 30   Baltimore City 240009000282 105 Moravia Park Elementary   Regular School No Elementary PK 05 2021   pk_12_total 17 646 26   * 11     *   *                             714 17 646 26     11                                 714
1319104 1319104 MD     school 2400090 30   Baltimore City 240009001631 335 Baltimore International Academy   Regular School Yes Elementary KG 08 2021   pk_12_total 36 645 43   * *     *   25                             752 36 645 43               25                       752
1311021 1311021 MD     school 2400120 3   Baltimore County 240012001574 256 Windsor Mill Middle   Regular School No Middle 06 08 2021   pk_12_total * 635 29   * *     *   13                             691   635 29               13                       691
1310081 1310081 MD     school 2400060 2   Anne Arundel 240006090441 1323 North County High   Regular School No High 09 12 2021   pk_12_total 963 634 463   * 118     *   138                             2327 963 634 463     118         138                       2327
1316853 1316853 MD     school 2400510 16   Prince George's 240051001029 1806 Fairmont Heights High   Regular School No High 09 12 2021   pk_12_total 20 630 239   * *     *   *                             910 20 630 239                                       910
1318534 1318534 MD     school 2400090 30   Baltimore City 240009000171 159 The Historic Cherry Hill Elementary/Middle   Regular School No Middle 03 08 2021   pk_12_total * 629 31   *           *                             674   629 31                                       674
1309922 1309922 MD     school 2400060 2   Anne Arundel 240006000075 1033 Glen Burnie High   Regular School No High 09 12 2021   pk_12_total 798 625 472   * 101     *   121                             2132 798 625 472     101         121                       2132

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