enrollments

Data source: Big Local News · About: Big Local

1,393 rows where grade = "pk_12_total", state = "MD" and year = 2021 sorted by ccd_school_type 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
1310076 1310076 MD     school 2400060 2   Anne Arundel 240006000094 1274 Marley Glen School   Special Education School No Other PK 12 2021   pk_12_total 61 29 22   * *         *                             126 61 29 22                                       126
1310513 1310513 MD     school 2400060 2   Anne Arundel 240006001425 3414 Ruth Parker Eason School   Special Education School No Other PK 12 2021   pk_12_total 46 68 19     *     *   *                             149 46 68 19                                       149
1310556 1310556 MD     school 2400060 2   Anne Arundel 240006001714 4074 Phoenix Academy   Special Education School No Other 01 12 2021   pk_12_total 121 172 30   *           24                             349 121 172 30               24                       349
1310711 1310711 MD     school 2400060 2   Anne Arundel 240006000056 4304 Central Special School   Special Education School No Other PK 12 2021   pk_12_total 67 27 26     *         *                             129 67 27 26                                       129
1310850 1310850 MD     school 2400120 3   Baltimore County 240012000466 111 Maiden Choice School   Special Education School No Other PK 12 2021   pk_12_total 29 71 *     16         *                             130 29 71       16                                 130
1311372 1311372 MD     school 2400120 3   Baltimore County 240012000483 922 Ridge/Ruxton School   Special Education School No Other PK 12 2021   pk_12_total 35 42 14   * 20         *                             119 35 42 14     20                                 119
1311380 1311380 MD     school 2400120 3   Baltimore County 240012001435 923 White Oak School   Special Education School No Elementary PK 05 2021   pk_12_total 30 33 *     *         *                             75 30 33                                         75
1311563 1311563 MD     school 2400120 3   Baltimore County 240012000346 1215 Battle Monument School   Special Education School No Other PK 12 2021   pk_12_total 31 19 *     *         *                             63 31 19                                         63
1311972 1311972 MD     school 2400150 4   Calvert 240015000509 206 Calvert Country School   Special Education School No Other 03 12 2021   pk_12_total 23 *     * *         *                             38 23                                           38
1312292 1312292 MD     school 2400210 6   Carroll 240021000527 712 Carroll Springs School   Special Education School No Other 01 12 2021   pk_12_total 25 * *                                             28 25                                           28
1313289 1313289 MD     school 2400330 10   Frederick 240033000647 2404 Rock Creek   Special Education School No Other PK 12 2021   pk_12_total 39 16 11               *                             71 39 16 11                                       71
1313688 1313688 MD     school 2400390 12   Harford 240039000703 391 John Archer School   Special Education School No Other PK 12 2021   pk_12_total 65 41 16     *         10                             136 65 41 16               10                       136
1314077 1314077 MD     school 2400420 13   Howard 240042001415 522 Cedar Lane Special Center   Special Education School No Other PK 12 2021   pk_12_total 30 47 13     22         *                             116 30 47 13     22                                 116
1314493 1314493 MD     school 2400480 15   Montgomery 240048000799 215 Carl Sandburg Center   Special Education School No Elementary KG 05 2021   pk_12_total 11 39 31     10         *                             94 11 39 31     10                                 94
1315194 1315194 MD     school 2400480 15   Montgomery 240048001635 587 PEP - Itinerant   Special Education School No Prekindergarten PK PK 2021   pk_12_total 14 * *     *         *                             40 14                                           40
1315552 1315552 MD     school 2400480 15   Montgomery 240048000496 799 Stephen Knolls School   Special Education School No Other PK 12 2021   pk_12_total 13 17 19     *         *                             52 13 17 19                                       52
1315637 1315637 MD     school 2400480 15   Montgomery 240048001460 916 Rock Terrace School   Special Education School No High 06 12 2021   pk_12_total 23 24 22     11         *                             84 23 24 22     11                                 84
1315651 1315651 MD     school 2400480 15   Montgomery 240048000867 951 Longview School   Special Education School No Other KG 12 2021   pk_12_total 18 16 25     *                                       65 18 16 25                                       65
1315661 1315661 MD     school 2400480 15   Montgomery 240048001398 965 John L Gildner Regional Inst for Children & Adol   Special Education School No Other 04 12 2021   pk_12_total 33 37 25     *         10                             108 33 37 25               10                       108
1315687 1315687 MD     school 2400510 16   Prince George's 240051001134 107 Frances Fuchs Early Childhood Center   Special Education School No Prekindergarten PK PK 2021   pk_12_total 11 100 117   * 14     *   *                             249 11 100 117     14                                 249
1315701 1315701 MD     school 2400510 16   Prince George's 240051001354 108 James E. Duckworth Regional Center   Special Education School No Other KG 12 2021   pk_12_total * 34 57     *         *                             103   34 57                                       103
1316107 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
1316188 1316188 MD     school 2400510 16   Prince George's 240051001763 918 James Ryder Randall Early Childhood Center   Special Education School No Prekindergarten PK PK 2021   pk_12_total * 57 17     *         *                             88   57 17                                       88
1316441 1316441 MD     school 2400510 16   Prince George's 240051001731 1313 Kenmoor Early Childhood Center   Special Education School No Prekindergarten PK PK 2021   pk_12_total * 53 60   * *         *                             122   53 60                                       122
1316621 1316621 MD     school 2400510 16   Prince George's 240051001003 1433 Chapel Forge Early Childhood Center   Special Education School No Prekindergarten PK PK 2021   pk_12_total 17 162 31     10         *                             228 17 162 31     10                                 228
1316907 1316907 MD     school 2400510 16   Prince George's 240051001053 1822 H. W. Wheatley Early Childhood Center   Special Education School No Prekindergarten PK PK 2021   pk_12_total * 212 30     *         *                             261   212 30                                       261
1317027 1317027 MD     school 2400510 16   Prince George's 240051001419 2012 Margaret Brent Regional Center   Special Education School No Elementary KG 08 2021   pk_12_total * 40 28     *         *                             72   40 28                                       72
1317655 1317655 MD     school 2400660 21   Washington 240066001484 705 Washington County Job Development Center   Special Education School No High 12 12 2021   pk_12_total 18 11 *               *                             34 18 11                                         34
1317775 1317775 MD     school 2400660 21   Washington 240066001289 2505 Marshall Street School   Special Education School No Other PK 12 2021   pk_12_total 24 * *     *         *                             41 24                                           41
1318002 1318002 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2021   pk_12_total 27 16 *     *         *                             50 27 16                                         50
1318543 1318543 MD     school 2400090 30   Baltimore City 240009000219 177 George W. F. McMechen High   Special Education School No High 10 12 2021   pk_12_total * 39 *               *                             44   39                                         44
1318995 1318995 MD     school 2400090 30   Baltimore City 240009000336 301 William S. Baer School   Special Education School No Other PK 12 2021   pk_12_total 14 112 20     *                                       148 14 112 20                                       148
1319001 1319001 MD     school 2400090 30   Baltimore City 240009000176 307 Claremont School   Special Education School No High 07 12 2021   pk_12_total * 47 *                                             51   47                                         51
1319011 1319011 MD     school 2400090 30   Baltimore City 240009001364 313 Lois T. Murray Elementary/Middle   Special Education School No Elementary KG 08 2021   pk_12_total * 34 *                                             44   34                                         44
1319017 1319017 MD     school 2400090 30   Baltimore City 240009001369 314 Sharp-Leadenhall Elementary   Special Education School No Elementary 01 05 2021   pk_12_total * 23                 *                             27   23                                         27
1319130 1319130 MD     school 2400090 30   Baltimore City 240009001662 345 Joseph C. Briscoe Academy   Special Education School No High 06 12 2021   pk_12_total * 50 *               *                             58   50                                         58
1309775 1309775 MD     school 2400030 1   Allegany 240003000014 301 Flintstone Elementary   Regular School No Elementary PK 05 2021   pk_12_total 193 * *               *                             205 193                                           205
1309783 1309783 MD     school 2400030 1   Allegany 240003001359 401 South Penn Elementary   Regular School No Elementary PK 05 2021   pk_12_total 361 40 *     *         85                             497 361 40                 85                       497
1309791 1309791 MD     school 2400030 1   Allegany 240003000019 402 John Humbird Elementary   Regular School No Elementary PK 05 2021   pk_12_total 176 21 *               33                             233 176 21                 33                       233
1309796 1309796 MD     school 2400030 1   Allegany 240003000015 405 Fort Hill High   Regular School No High 09 12 2021   pk_12_total 556 39 14     *         47                             657 556 39 14               47                       657
1309800 1309800 MD     school 2400030 1   Allegany 240003000031 406 Washington Middle   Regular School No Middle 06 08 2021   pk_12_total 516 27 *   * *     *   53                             609 516 27                 53                       609
1309808 1309808 MD     school 2400030 1   Allegany 240003000024 502 Northeast Elementary   Regular School No Elementary PK 05 2021   pk_12_total 228 14 *               24                             269 228 14                 24                       269
1309812 1309812 MD     school 2400030 1   Allegany 240003000006 504 Braddock Middle   Regular School No Middle 06 08 2021   pk_12_total 502 28 14   * *     *   52                             605 502 28 14               52                       605
1309823 1309823 MD     school 2400030 1   Allegany 240003000032 603 West Side Elementary   Regular School No Elementary PK 05 2021   pk_12_total 240 22 *   * *         47                             319 240 22                 47                       319
1309828 1309828 MD     school 2400030 1   Allegany 240003000001 606 Allegany High   Regular School No High 09 12 2021   pk_12_total 628 24 20   * 11     *   50                             736 628 24 20     11         50                       736
1309836 1309836 MD     school 2400030 1   Allegany 240003000010 701 Cresaptown Elementary   Regular School No Elementary PK 05 2021   pk_12_total 251 * *   * *     *   17                             287 251                   17                       287
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
1309852 1309852 MD     school 2400030 1   Allegany 240003000033 801 Westernport Elementary   Regular School No Elementary PK 05 2021   pk_12_total 239 * *           *   10                             256 239                   10                       256
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
1309876 1309876 MD     school 2400030 1   Allegany 240003000023 1301 Mount Savage Middle   Regular School No Middle 06 08 2021   pk_12_total 355 * *   * *     *   13                             383 355                   13                       383
1309884 1309884 MD     school 2400030 1   Allegany 240003001546 1302 Mt. Savage Elementary   Regular School No Elementary PK 05 2021   pk_12_total 181 * *   *           *                             186 181                                           186
1309889 1309889 MD     school 2400030 1   Allegany 240003001636 2404 Mountain Ridge High School   Regular School No High 09 12 2021   pk_12_total 712 17 12   * *         23                             771 712 17 12               23                       771
1309897 1309897 MD     school 2400030 1   Allegany 240003000003 2801 Beall Elementary   Regular School No Elementary PK 05 2021   pk_12_total 384 * *   * *         41                             445 384                   41                       445
1309905 1309905 MD     school 2400030 1   Allegany 240003001338 2901 Cash Valley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 226 19 *     *         16                             273 226 19                 16                       273
1309913 1309913 MD     school 2400030 1   Allegany 240003000026 2902 Parkside Elementary   Regular School No Elementary PK 05 2021   pk_12_total 134 16 *     *         15                             178 134 16                 15                       178
1309917 1309917 MD     school 2400060 2   Anne Arundel 240006000050 1023 Brooklyn Park Middle   Regular School No Middle 06 08 2021   pk_12_total 370 221 190   * 18     *   69                             875 370 221 190     18         69                       875
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
1309926 1309926 MD     school 2400060 2   Anne Arundel 240006000059 1043 Corkran Middle School   Regular School No Middle 06 08 2021   pk_12_total 235 156 161   * 29     *   49                             638 235 156 161     29         49                       638
1309930 1309930 MD     school 2400060 2   Anne Arundel 240006000087 1053 Lindale Middle   Regular School No Middle 06 08 2021   pk_12_total 490 347 222   * 51     *   80                             1194 490 347 222     51         80                       1194
1309934 1309934 MD     school 2400060 2   Anne Arundel 240006000095 1063 Marley Middle   Regular School No Middle 06 08 2021   pk_12_total 335 265 241   * 32     *   78                             956 335 265 241     32         78                       956
1309942 1309942 MD     school 2400060 2   Anne Arundel 240006000043 1082 Belle Grove Elementary   Regular School No Elementary PK 05 2021   pk_12_total 108 62 73   * 11         32                             287 108 62 73     11         32                       287
1309950 1309950 MD     school 2400060 2   Anne Arundel 240006000049 1092 Brooklyn Park Elementary   Regular School No Elementary PK 05 2021   pk_12_total 177 112 116   * *     *   24                             440 177 112 116               24                       440
1309952 1309952 MD     school 2400060 2   Anne Arundel 240006000066 1102 Ferndale Early Education Center   Regular School No Prekindergarten PK PK 2021   pk_12_total 30 19 21     12         *                             87 30 19 21     12                                 87
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
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
1309975 1309975 MD     school 2400060 2   Anne Arundel 240006000077 1132 Glendale Elementary   Regular School No Elementary PK 05 2021   pk_12_total 178 44 141   * *     *   31                             403 178 44 141               31                       403
1309982 1309982 MD     school 2400060 2   Anne Arundel 240006000081 1142 Hilltop Elementary   Regular School No Elementary KG 05 2021   pk_12_total 142 201 160   * 20     *   44                             570 142 201 160     20         44                       570
1309990 1309990 MD     school 2400060 2   Anne Arundel 240006000088 1152 Linthicum Elementary   Regular School No Elementary PK 05 2021   pk_12_total 319 37 53     20     *   18                             449 319 37 53     20         18                       449
1309998 1309998 MD     school 2400060 2   Anne Arundel 240006000093 1162 Marley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 202 267 192   * 57     *   52                             778 202 267 192     57         52                       778
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
1310014 1310014 MD     school 2400060 2   Anne Arundel 240006000105 1182 Oakwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 137 74 69   * 26         30                             339 137 74 69     26         30                       339
1310022 1310022 MD     school 2400060 2   Anne Arundel 240006000110 1192 Overlook Elementary   Regular School No Elementary PK 05 2021   pk_12_total 182 76 57   * 14     *   24                             355 182 76 57     14         24                       355
1310030 1310030 MD     school 2400060 2   Anne Arundel 240006000111 1202 Park Elementary   Regular School No Elementary PK 05 2021   pk_12_total 165 134 167   * 16     *   38                             522 165 134 167     16         38                       522
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
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
1310053 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
1310061 1310061 MD     school 2400060 2   Anne Arundel 240006000142 1262 Woodside Elementary   Regular School No Elementary PK 05 2021   pk_12_total 110 65 145     *     *   10                             340 110 65 145               10                       340
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
1310086 1310086 MD     school 2400060 2   Anne Arundel 240006000127 2013 Severna Park High   Regular School No High 09 12 2021   pk_12_total 1525 68 109   * 78     *   95                             1880 1525 68 109     78         95                       1880
1310091 1310091 MD     school 2400060 2   Anne Arundel 240006000103 2023 Northeast High   Regular School No High 09 12 2021   pk_12_total 979 135 141   * 28     *   73                             1364 979 135 141     28         73                       1364
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
1310099 1310099 MD     school 2400060 2   Anne Arundel 240006000126 2043 Severna Park Middle   Regular School No Middle 06 08 2021   pk_12_total 1130 55 76   * 69     *   75                             1412 1130 55 76     69         75                       1412
1310106 1310106 MD     school 2400060 2   Anne Arundel 240006000038 2052 Arnold Elementary   Regular School No Elementary KG 05 2021   pk_12_total 357 38 26   * 19         38                             481 357 38 26     19         38                       481
1310114 1310114 MD     school 2400060 2   Anne Arundel 240006000044 2062 Belvedere Elementary   Regular School No Elementary PK 05 2021   pk_12_total 354 30 45     15         39                             483 354 30 45     15         39                       483
1310122 1310122 MD     school 2400060 2   Anne Arundel 240006000045 2072 Benfield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 334 * 23   * *         23                             392 334   23               23                       392
1310129 1310129 MD     school 2400060 2   Anne Arundel 240006000046 2082 Bodkin Elementary   Regular School No Elementary KG 05 2021   pk_12_total 423 * 33     *         19                             483 423   33               19                       483
1310136 1310136 MD     school 2400060 2   Anne Arundel 240006000051 2092 Cape St. Claire Elementary   Regular School No Elementary KG 05 2021   pk_12_total 427 11 68   * 16     *   41                             566 427 11 68     16         41                       566
1310143 1310143 MD     school 2400060 2   Anne Arundel 240006000067 2102 Folger Mckinsey Elementary   Regular School No Elementary KG 05 2021   pk_12_total 482 17 31     18         28                             576 482 17 31     18         28                       576
1310151 1310151 MD     school 2400060 2   Anne Arundel 240006000068 2112 Fort Smallwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 404 17 18     *         19                             464 404 17 18               19                       464
1310159 1310159 MD     school 2400060 2   Anne Arundel 240006000079 2132 High Point Elementary   Regular School No Elementary PK 05 2021   pk_12_total 443 55 103   * 13     *   51                             669 443 55 103     13         51                       669
1310167 1310167 MD     school 2400060 2   Anne Arundel 240006000082 2142 Jacobsville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 394 38 51     11         33                             527 394 38 51     11         33                       527
1310174 1310174 MD     school 2400060 2   Anne Arundel 240006000084 2152 Jones Elementary   Regular School No Elementary KG 05 2021   pk_12_total 219 12 21     21         19                             292 219 12 21     21         19                       292
1310182 1310182 MD     school 2400060 2   Anne Arundel 240006000085 2162 Lake Shore Elementary   Regular School No Elementary PK 05 2021   pk_12_total 275 * 19               21                             317 275   19               21                       317
1310189 1310189 MD     school 2400060 2   Anne Arundel 240006000104 2172 Oak Hill Elementary   Regular School No Elementary KG 05 2021   pk_12_total 519 21 26   * 28     *   43                             639 519 21 26     28         43                       639
1310196 1310196 MD     school 2400060 2   Anne Arundel 240006000113 2182 Pasadena Elementary   Regular School No Elementary KG 05 2021   pk_12_total 288 15 26     *         15                             347 288 15 26               15                       347
1310204 1310204 MD     school 2400060 2   Anne Arundel 240006000121 2192 Riviera Beach Elementary   Regular School No Elementary PK 05 2021   pk_12_total 224 * 15   * 12         19                             280 224   15     12         19                       280
1310211 1310211 MD     school 2400060 2   Anne Arundel 240006000125 2202 Severna Park Elementary   Regular School No Elementary KG 05 2021   pk_12_total 333 * 17   * 22         17                             392 333   17     22         17                       392
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

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