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_charter_school 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
1310736 1310736 MD     school 2400060 2   Anne Arundel 240006001401 6223 Chesapeake Science Point   Regular School Yes High 06 12 2021   pk_12_total 138 203 42   * 79     *   36                             500 138 203 42     79         36                       500
1310746 1310746 MD     school 2400060 2   Anne Arundel 240006001687 6233 Monarch Academy   Regular School Yes Elementary KG 08 2021   pk_12_total 273 246 68   * 25     *   65                             681 273 246 68     25         65                       681
1311005 1311005 MD     school 2400120 3   Baltimore County 240012001753 219 Watershed Public Charter   Regular School Yes Elementary KG 04 2021   pk_12_total 53 128 15   * *         31                             231 53 128 15               31                       231
1312991 1312991 MD     school 2400330 10   Frederick 240033001187 226 Monocacy Valley Montessori   Regular School Yes Elementary PK 08 2021   pk_12_total 181 37 36   * 25         23                             303 181 37 36     25         23                       303
1313006 1313006 MD     school 2400330 10   Frederick 240033001712 228 Carroll Creek Montessori Public Charter   Regular School Yes Elementary PK 08 2021   pk_12_total 196 44 53   * 13         11                             318 196 44 53     13         11                       318
1313169 1313169 MD     school 2400330 10   Frederick 240033001715 1301 Frederick Classical Charter   Regular School Yes Elementary KG 08 2021   pk_12_total 155 117 47   * 30     *   23                             376 155 117 47     30         23                       376
1316044 1316044 MD     school 2400510 16   Prince George's 240051001648 662 Imagine Lincoln Public Charter   Regular School Yes Elementary KG 08 2021   pk_12_total * 376 10     *         *                             393   376 10                                       393
1316186 1316186 MD     school 2400510 16   Prince George's 240051001701 917 Imagine Andrews Public Charter   Regular School Yes Elementary KG 08 2021   pk_12_total 60 297 33     17     *   22                             433 60 297 33     17         22                       433
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
1316646 1316646 MD     school 2400510 16   Prince George's 240051001540 1442 Excel Academy Public Charter   Regular School Yes Elementary KG 08 2021   pk_12_total * 391 30   * *     *   *                             430   391 30                                       430
1316693 1316693 MD     school 2400510 16   Prince George's 240051001637 1521 Imagine Foundations at Leeland PCS   Regular School Yes Elementary KG 08 2021   pk_12_total * 443 *   * *         *                             467   443                                         467
1316703 1316703 MD     school 2400510 16   Prince George's 240051001706 1522 Imagine Foundations at Morningside PCS   Regular School Yes Elementary KG 08 2021   pk_12_total * 385 11   *           *                             405   385 11                                       405
1317066 1317066 MD     school 2400510 16   Prince George's 240051001764 2023 Legend Public Charter School   Regular School Yes Elementary KG 05 2021   pk_12_total * 547 21   * *         11                             592   547 21               11                       592
1317144 1317144 MD     school 2400510 16   Prince George's 240051001718 2142 College Park Academy   Regular School Yes High 06 12 2021   pk_12_total 55 364 206   * 16         35                             677 55 364 206     16         35                       677
1317413 1317413 MD     school 2400600 18   Saint Mary's 240060001639 813 Chesapeake Charter School   Regular School Yes Elementary KG 08 2021   pk_12_total 346 40 18     18         55                             477 346 40 18     18         55                       477
1318043 1318043 MD     school 2400090 30   Baltimore City 240009000175 8 City Springs Elementary/Middle   Regular School Yes Elementary PK 08 2021   pk_12_total 10 594 24   *           *                             633 10 594 24                                       633
1318120 1318120 MD     school 2400090 30   Baltimore City 240009000215 23 Wolfe Street Academy   Regular School Yes Elementary PK 05 2021   pk_12_total 16 30 214   * *                                       265 16 30 214                                       265
1318215 1318215 MD     school 2400090 30   Baltimore City 240009000234 47 Hampstead Hill Academy   Regular School Yes Elementary PK 08 2021   pk_12_total 331 142 325   * 12     *   39                             855 331 142 325     12         39                       855
1318480 1318480 MD     school 2400090 30   Baltimore City 240009000211 125 Furman Templeton Preparatory Academy   Regular School Yes Elementary PK 05 2021   pk_12_total * 443 *   *       *   *                             450   443                                         450
1318643 1318643 MD     school 2400090 30   Baltimore City 240009000223 213 Govans Elementary   Regular School Yes Elementary PK 05 2021   pk_12_total * 338 14               *                             357   338 14                                       357
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
1318961 1318961 MD     school 2400090 30   Baltimore City 240009001430 260 Frederick Elementary   Regular School Yes Elementary PK 05 2021   pk_12_total 22 294 18   * *         12                             349 22 294 18               12                       349
1318980 1318980 MD     school 2400090 30   Baltimore City 240009001558 262 Empowerment Academy   Regular School Yes Elementary PK 08 2021   pk_12_total   284 *                                             287   284                                         287
1319027 1319027 MD     school 2400090 30   Baltimore City 240009000883 321 Midtown Academy   Regular School Yes Elementary KG 08 2021   pk_12_total 12 170 *   * *         *                             198 12 170                                         198
1319038 1319038 MD     school 2400090 30   Baltimore City 240009000884 322 New Song Academy   Regular School Yes Elementary PK 08 2021   pk_12_total   172 *                                             174   172                                         174
1319042 1319042 MD     school 2400090 30   Baltimore City 240009001291 323 The Crossroads School   Regular School Yes Middle 06 08 2021   pk_12_total * 119 40               *                             163   119 40                                       163
1319050 1319050 MD     school 2400090 30   Baltimore City 240009001302 325 ConneXions: A Community Based Arts School   Regular School Yes High 06 12 2021   pk_12_total * 506 13               *                             526   506 13                                       526
1319060 1319060 MD     school 2400090 30   Baltimore City 240009001478 326 City Neighbors Charter School   Regular School Yes Elementary KG 08 2021   pk_12_total 75 148 *               *                             233 75 148                                         233
1319071 1319071 MD     school 2400090 30   Baltimore City 240009001480 327 Patterson Park Public Charter School   Regular School Yes Elementary PK 08 2021   pk_12_total 116 302 301   * *     *   19                             742 116 302 301               19                       742
1319082 1319082 MD     school 2400090 30   Baltimore City 240009001527 328 Southwest Baltimore Charter School   Regular School Yes Elementary PK 08 2021   pk_12_total 27 372 13   * *         13                             431 27 372 13               13                       431
1319089 1319089 MD     school 2400090 30   Baltimore City 240009001571 332 The Green School of Baltimore   Regular School Yes Elementary KG 05 2021   pk_12_total 61 68 *               24                             162 61 68                 24                       162
1319094 1319094 MD     school 2400090 30   Baltimore City 240009001632 333 Independence School Local I   Regular School Yes High 09 12 2021   pk_12_total 15 138 *                                             155 15 138                                         155
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
1319115 1319115 MD     school 2400090 30   Baltimore City 240009001657 336 Baltimore Montessori Public Charter School   Regular School Yes Elementary PK 08 2021   pk_12_total 119 323 16   *           19                             479 119 323 16               19                       479
1319117 1319117 MD     school 2400090 30   Baltimore City 240009001661 337 Afya Public Charter School   Regular School Yes Middle 08 08 2021   pk_12_total   105 *                                             112   105                                         112
1319140 1319140 MD     school 2400090 30   Baltimore City 240009001680 346 City Neighbors Hamilton   Regular School Yes Elementary KG 08 2021   pk_12_total 77 127 11   * *         14                             234 77 127 11               14                       234
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
1319158 1319158 MD     school 2400090 30   Baltimore City 240009001682 348 Baltimore Leadership School for Young Women   Regular School Yes High 06 12 2021   pk_12_total * 514 *   *           *                             531   514                                         531
1319187 1319187 MD     school 2400090 30   Baltimore City 240009001734 371 Lillie May Carroll Jackson School   Regular School Yes Middle 05 08 2021   pk_12_total   306 *                                             309   306                                         309
1319198 1319198 MD     school 2400090 30   Baltimore City 240009001689 373 Tunbridge Public Charter School   Regular School Yes Elementary PK 08 2021   pk_12_total 65 372 16   * *     *   15                             475 65 372 16               15                       475
1319208 1319208 MD     school 2400090 30   Baltimore City 240009001736 375 Baltimore Collegiate School for Boys   Regular School Yes Middle 04 08 2021   pk_12_total   455 *   *       *   *                             466   455                                         466
1319213 1319213 MD     school 2400090 30   Baltimore City 240009001690 376 City Neighbors High   Regular School Yes High 09 12 2021   pk_12_total 30 365 23   * *         *                             424 30 365 23                                       424
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
1319236 1319236 MD     school 2400090 30   Baltimore City 240009001716 384 Creative City Public Charter School   Regular School Yes Elementary KG 05 2021   pk_12_total 27 309 *   * *         17                             358 27 309                 17                       358
1319241 1319241 MD     school 2400090 30   Baltimore City 240009001752 385 Baltimore International Academy West   Regular School Yes Elementary KG 07 2021   pk_12_total * 143 *               *                             150   143                                         150
1319332 1319332 MD     school 2400090 30   Baltimore City 240009001530 432 Coppin Academy   Regular School Yes High 09 12 2021   pk_12_total * 351 *                                             359   351                                         359
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
1309815 1309815 MD     school 2400030 1   Allegany 240003000030 601 Center for Career & Technical Education   Career and Technical School No High 11 12 2021   pk_12_total 245 * *   *           *                             258 245                                           258
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
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
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

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