enrollments

Data source: Big Local News · About: Big Local

1,398 rows where grade = "pk_12_total", state = "MD" and year = 2020 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 1,198 ✖

grade ✖

  • pk_12_total · 1,198 ✖
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
1241522 1241522 MD     school 2400420 13   Howard 240042001415 522 Cedar Lane Special Center   Special Education School No Other PK 12 2020   pk_12_total 33 47 14   * 18         *                             117 33 47 14     18                                 117
1238586 1238586 MD     school 2400120 3   Baltimore County 240012000356 408 Cedarmere Elementary   Regular School No Elementary PK 05 2020   pk_12_total 98 209 165   * 45     *   19                             539 98 209 165     45         19                       539
1241346 1241346 MD     school 2400420 13   Howard 240042000722 214 Centennial High   Regular School No High 09 12 2020   pk_12_total 630 146 73   * 651     *   90                             1597 630 146 73     651         90                       1597
1241329 1241329 MD     school 2400420 13   Howard 240042000723 210 Centennial Lane Elementary   Regular School No Elementary KG 05 2020   pk_12_total 223 39 29   12 360         56                             719 223 39 29   12 360         56                       719
1237254 1237254 MD     school 2400030 1   Allegany 240003000030 601 Center for Career & Technical Education   Career and Technical School No High 11 12 2020   pk_12_total 193   *               *                             203 193                                           203
1241005 1241005 MD     school 2400390 12   Harford 240039000480 292 Center for Educational Opportunity   Alternative School No High 08 12 2020   pk_12_total 26 37 *     *         *                             74 26 37                                         74
1240517 1240517 MD     school 2400330 10   Frederick 240033001429 715 Centerville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 452 99 139   * 206     *   73                             972 452 99 139     206         73                       972
1238199 1238199 MD     school 2400120 3   Baltimore County 240012001760 56 Central EDLP at Loch Raven High School   Alternative School No High 12 12 2020   pk_12_total * *                                               *                                              
1238009 1238009 MD     school 2400060 2   Anne Arundel 240006000053 4112 Central Elementary   Regular School No Elementary KG 05 2020   pk_12_total 488 17 55   * 18         22                             601 488 17 55     18         22                       601
1244286 1244286 MD     school 2400510 16   Prince George's 240051001002 1810 Central High   Regular School No High 09 12 2020   pk_12_total 10 505 262   * 10     *   *                             798 10 505 262     10                                 798
1238127 1238127 MD     school 2400060 2   Anne Arundel 240006000054 4283 Central Middle   Regular School No Middle 06 08 2020   pk_12_total 962 57 162   * 43     *   55                             1284 962 57 162     43         55                       1284
1238147 1238147 MD     school 2400060 2   Anne Arundel 240006000056 4304 Central Special School   Special Education School No Other PK 12 2020   pk_12_total 80 32 23     *         *                             148 80 32 23                                       148
1244615 1244615 MD     school 2400540 17   Queen Anne's 240054001191 308 Centreville Elementary School   Regular School No Elementary PK 02 2020   pk_12_total 423 28 42   * *         31                             527 423 28 42               31                       527
1244610 1244610 MD     school 2400540 17   Queen Anne's 240054001190 303 Centreville Middle School   Regular School No Middle 06 08 2020   pk_12_total 454 35 39   * *         28                             562 454 35 39               28                       562
1239668 1239668 MD     school 2400210 6   Carroll 240021001161 510 Century High   Regular School No High 09 12 2020   pk_12_total 945 50 73   * 40     *   27                             1139 945 50 73     40         27                       1139
1244205 1244205 MD     school 2400510 16   Prince George's 240051001139 1713 Cesar Chavez Elementary   Regular School No Elementary KG 05 2020   pk_12_total 41 86 219   * *     *                                 354 41 86 219                                       354
1238312 1238312 MD     school 2400120 3   Baltimore County 240012000357 113 Chadwick Elementary   Regular School No Elementary PK 05 2020   pk_12_total 32 279 78   * 234     *   *                             637 32 279 78     234                                 637
1244932 1244932 MD     school 2400630 20   Talbot 240063001241 401 Chapel District Elementary   Regular School No Elementary PK 05 2020   pk_12_total 305 18 27     *         17                             371 305 18 27               17                       371
1244040 1244040 MD     school 2400510 16   Prince George's 240051001003 1433 Chapel Forge Early Childhood Center   Special Education School No Prekindergarten PK PK 2020   pk_12_total 14 178 43   * 12         *                             254 14 178 43     12                                 254
1238908 1238908 MD     school 2400120 3   Baltimore County 240012000358 1107 Chapel Hill Elementary   Regular School No Elementary KG 05 2020   pk_12_total 355 103 25     132         31                             646 355 103 25     132         31                       646
1245582 1245582 MD     school 2400090 30   Baltimore City 240009000153 34 Charles Carroll Barrister Elementary   Regular School No Elementary PK 05 2020   pk_12_total 58 136 143   * 12                                       350 58 136 143     12                                 350
1244436 1244436 MD     school 2400510 16   Prince George's 240051001004 2011 Charles Carroll Middle   Regular School No Middle 06 08 2020   pk_12_total 23 378 903   * 19     *   *                             1329 23 378 903     19                                 1329
1245289 1245289 MD     school 2400690 22   Wicomico 240069001315 907 Charles H. Chipman Elementary   Regular School No Elementary PK 01 2020   pk_12_total 47 206 17   * *         24                             301 47 206 17               24                       301
1243894 1243894 MD     school 2400510 16   Prince George's 240051002951 1327 Charles Herbert Flowers High   Regular School No High 09 12 2020   pk_12_total 14 1980 186   * 35     *   38                             2262 14 1980 186     35         38                       2262
1238994 1238994 MD     school 2400120 3   Baltimore County 240012000359 1212 Charlesmont Elementary   Regular School No Elementary PK 05 2020   pk_12_total 237 46 57   * *     *   36                             384 237 46 57               36                       384
1239950 1239950 MD     school 2400240 7   Cecil 240024000563 513 Charlestown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 196 35 *           *   15                             257 196 35                 15                       257
1239201 1239201 MD     school 2400120 3   Baltimore County 240012000360 1507 Chase Elementary   Regular School No Elementary PK 05 2020   pk_12_total 210 95 47   * *     *   42                             398 210 95 47               42                       398
1238554 1238554 MD     school 2400120 3   Baltimore County 240012000361 404 Chatsworth School   Regular School No Elementary PK 05 2020   pk_12_total 119 178 23   * 22     *   22                             366 119 178 23     22         22                       366
1244527 1244527 MD     school 2400510 16   Prince George's 240051001006 2121 Cherokee Lane Elementary   Regular School No Elementary KG 06 2020   pk_12_total 13 79 460   * 18         *                             580 13 79 460     18                                 580
1239890 1239890 MD     school 2400240 7   Cecil 240024000564 313 Cherry Hill Middle   Regular School No Middle 06 08 2020   pk_12_total 301 55 50           *   24                             431 301 55 50               24                       431
1237706 1237706 MD     school 2400060 2   Anne Arundel 240006000042 2423 Chesapeake Bay Middle   Regular School No Middle 06 08 2020   pk_12_total 898 44 61   * 14         31                             1056 898 44 61     14         31                       1056
1244835 1244835 MD     school 2400600 18   Saint Mary's 240060001639 813 Chesapeake Charter School   Regular School Yes Elementary KG 08 2020   pk_12_total 329 34 23     17         54                             457 329 34 23     17         54                       457
1239857 1239857 MD     school 2400240 7   Cecil 240024000565 205 Chesapeake City Elementary   Regular School No Elementary PK 05 2020   pk_12_total 306 * 20               18                             349 306   20               18                       349
1237679 1237679 MD     school 2400060 2   Anne Arundel 240006000058 2273 Chesapeake High   Regular School No High 09 12 2020   pk_12_total 1161 57 82   * 26     *   54                             1388 1161 57 82     26         54                       1388
1239351 1239351 MD     school 2400120 3   Baltimore County 240012000362 1574 Chesapeake High   Regular School No High 09 12 2020   pk_12_total 267 525 102   * *     *   50                             961 267 525 102               50                       961
1243662 1243662 MD     school 2400510 16   Prince George's 240051001708 1015 Chesapeake Math and IT Public Charter   Regular School Yes Other KG 12 2020   pk_12_total 60 1343 150   * 74     *   27                             1664 60 1343 150     74         27                       1664
1243946 1243946 MD     school 2400510 16   Prince George's 240051001726 1351 Chesapeake Math and IT South Public Charter   Regular School Yes Other KG 12 2020   pk_12_total 13 1261 27   * 16     *   12                             1335 13 1261 27     16         12                       1335
1238172 1238172 MD     school 2400060 2   Anne Arundel 240006001401 6223 Chesapeake Science Point   Regular School Yes High 06 12 2020   pk_12_total 132 178 45   * 72     *   34                             464 132 178 45     72         34                       464
1239217 1239217 MD     school 2400120 3   Baltimore County 240012000363 1511 Chesapeake Terrace Elementary   Regular School No Elementary PK 05 2020   pk_12_total 266 * *   * *         *                             286 266                                           286
1242256 1242256 MD     school 2400480 15   Montgomery 240048000803 403 Chevy Chase Elementary   Regular School No Elementary 03 05 2020   pk_12_total 259 82 47     40         38                             466 259 82 47     40         38                       466
1244172 1244172 MD     school 2400510 16   Prince George's 240051001009 1709 Chillum Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 141 228   * *         *                             379   141 228                                       379
1240341 1240341 MD     school 2400300 9   Dorchester 240030000841 716 Choptank Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 35 238 62               22                             357 35 238 62               22                       357
1244694 1244694 MD     school 2400600 18   Saint Mary's 240060001218 303 Chopticon High   Regular School No High 09 12 2020   pk_12_total 1376 127 66   * 13     *   79                             1669 1376 127 66     13         79                       1669
1240907 1240907 MD     school 2400390 12   Harford 240039000468 125 Church Creek Elementary   Regular School No Elementary PK 05 2020   pk_12_total 273 263 58     24     *   77                             697 273 263 58     24         77                       697
1244597 1244597 MD     school 2400540 17   Queen Anne's 240054001192 202 Church Hill Elementary School   Regular School No Elementary PK 04 2020   pk_12_total 196 18 26     *         22                             263 196 18 26               22                       263
1238389 1238389 MD     school 2400120 3   Baltimore County 240012000364 207 Church Lane Elementary Technology   Regular School No Elementary PK 05 2020   pk_12_total * 319 24   * *         10                             367   319 24               10                       367
1241025 1241025 MD     school 2400390 12   Harford 240039000684 316 Churchville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 326 11 10   *           22                             370 326 11 10               22                       370
1246509 1246509 MD     school 2400090 30   Baltimore City 240009001478 326 City Neighbors Charter School   Regular School Yes Elementary KG 08 2020   pk_12_total 78 144 *               *                             231 78 144                                         231
1246590 1246590 MD     school 2400090 30   Baltimore City 240009001680 346 City Neighbors Hamilton   Regular School Yes Elementary KG 08 2020   pk_12_total 77 126 11   * *         16                             234 77 126 11               16                       234
1246670 1246670 MD     school 2400090 30   Baltimore City 240009001690 376 City Neighbors High   Regular School Yes High 09 12 2020   pk_12_total 27 370 16   *           *                             418 27 370 16                                       418
1245467 1245467 MD     school 2400090 30   Baltimore City 240009000175 8 City Springs Elementary/Middle   Regular School Yes Elementary PK 08 2020   pk_12_total 19 662 19   * *         *                             703 19 662 19                                       703
1246450 1246450 MD     school 2400090 30   Baltimore City 240009000176 307 Claremont School   Special Education School No High 08 12 2020   pk_12_total * 44 *                                             48   44                                         48
1241757 1241757 MD     school 2400480 15   Montgomery 240048000804 101 Clarksburg Elementary   Regular School No Elementary KG 05 2020   pk_12_total 104 154 92   * 218         54                             623 104 154 92     218         54                       623
1242070 1242070 MD     school 2400480 15   Montgomery 240048001541 249 Clarksburg High   Regular School No High 09 12 2020   pk_12_total 424 743 653   * 539     *   108                             2472 424 743 653     539         108                       2472
1241446 1241446 MD     school 2400420 13   Howard 240042000724 505 Clarksville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 129 47 19     224         17                             436 129 47 19     224         17                       436
1241507 1241507 MD     school 2400420 13   Howard 240042000725 521 Clarksville Middle   Regular School No Middle 06 08 2020   pk_12_total 294 54 22   * 306     *   31                             710 294 54 22     306         31                       710
1245023 1245023 MD     school 2400660 21   Washington 240066001259 402 Clear Spring Elementary   Regular School No Elementary PK 05 2020   pk_12_total 389 * *               10                             411 389                   10                       411
1245028 1245028 MD     school 2400660 21   Washington 240066001260 403 Clear Spring High   Regular School No High 09 12 2020   pk_12_total 415 * 20     *         15                             460 415   20               15                       460
1245015 1245015 MD     school 2400660 21   Washington 240066001261 401 Clear Spring Middle   Regular School No Middle 06 08 2020   pk_12_total 312 * 23     *         15                             356 312   23               15                       356
1242715 1242715 MD     school 2400480 15   Montgomery 240048001514 706 Clearspring Elementary   Regular School No Elementary PK 05 2020   pk_12_total 208 121 145   * 71     *   39                             588 208 121 145     71         39                       588
1241503 1241503 MD     school 2400420 13   Howard 240042001382 520 Clemens Crossing Elementary   Regular School No Elementary KG 05 2020   pk_12_total 248 85 49   * 80     *   44                             508 248 85 49     80         44                       508
1243560 1243560 MD     school 2400510 16   Prince George's 240051001010 906 Clinton Grove Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 181 69     *         *                             264   181 69                                       264
1241750 1241750 MD     school 2400480 15   Montgomery 240048001494 100 Clopper Mill Elementary   Regular School No Elementary PK 05 2020   pk_12_total 32 190 254   * 45     *   15                             539 32 190 254     45         15                       539
1242114 1242114 MD     school 2400480 15   Montgomery 240048001524 308 Cloverly Elementary   Regular School No Elementary PK 05 2020   pk_12_total 128 134 134     77     *   37                             511 128 134 134     77         37                       511
1238715 1238715 MD     school 2400120 3   Baltimore County 240012000366 853 Cockeysville Middle   Regular School No Middle 06 08 2020   pk_12_total 391 251 154   * 71     *   41                             910 391 251 154     71         41                       910
1243025 1243025 MD     school 2400480 15   Montgomery 240048000806 818 Col. E. Brooke Lee Middle   Regular School No Middle 06 08 2020   pk_12_total 35 178 483   * 58     *   14                             771 35 178 483     58         14                       771
1242404 1242404 MD     school 2400480 15   Montgomery 240048000808 510 Col. Zadok Magruder High   Regular School No High 09 12 2020   pk_12_total 436 302 671   * 210         75                             1697 436 302 671     210         75                       1697
1242022 1242022 MD     school 2400480 15   Montgomery 240048000809 238 Cold Spring Elementary   Regular School No Elementary KG 05 2020   pk_12_total 137 12 17     137         29                             332 137 12 17     137         29                       332
1239177 1239177 MD     school 2400120 3   Baltimore County 240012000367 1503 Colgate Elementary   Regular School No Elementary KG 05 2020   pk_12_total 122 37 237   * 10     *   25                             433 122 37 237     10         25                       433
1241982 1241982 MD     school 2400480 15   Montgomery 240048000810 229 College Gardens Elementary   Regular School No Elementary PK 05 2020   pk_12_total 197 137 123     123     *   53                             634 197 137 123     123         53                       634
1244557 1244557 MD     school 2400510 16   Prince George's 240051001718 2142 College Park Academy   Regular School Yes High 06 12 2020   pk_12_total 53 390 174     17         27                             661 53 390 174     17         27                       661
1245880 1245880 MD     school 2400090 30   Baltimore City 240009000179 97 Collington Square Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 336 *               *                             347   336                                         347
1239566 1239566 MD     school 2400180 5   Caroline 240018000518 801 Colonel Richardson High School   Regular School No High 09 12 2020   pk_12_total 318 125 33     11         26                             513 318 125 33     11         26                       513
1239570 1239570 MD     school 2400180 5   Caroline 240018000519 802 Colonel Richardson Middle School   Regular School No Middle 06 08 2020   pk_12_total 260 96 31   * *         35                             432 260 96 31               35                       432
1243832 1243832 MD     school 2400510 16   Prince George's 240051001012 1302 Columbia Park Elementary   Regular School No Elementary PK 06 2020   pk_12_total 23 303 212   * *     *   *                             546 23 303 212                                       546
1245555 1245555 MD     school 2400090 30   Baltimore City 240009000180 27 Commodore John Rogers Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 48 530 308   * 11         *                             907 48 530 308     11                                 907
1244576 1244576 MD     school 2400510 16   Prince George's 240051001067 2220 Community Based Classrooms   Alternative School No High 12 12 2020   pk_12_total * 49 23           *   *                             75   49 23                                       75
1243421 1243421 MD     school 2400510 16   Prince George's 240051001013 647 Concord Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 327 29   * *         *                             365   327 29                                       365
1246499 1246499 MD     school 2400090 30   Baltimore City 240009001302 325 ConneXions: A Community Based Arts School   Regular School Yes High 06 12 2020   pk_12_total * 490 *     *                                       505   490                                         505
1240008 1240008 MD     school 2400240 7   Cecil 240024000566 801 Conowingo Elementary   Regular School No Elementary PK 05 2020   pk_12_total 427 10 14   *           11                             464 427 10 14               11                       464
1244236 1244236 MD     school 2400510 16   Prince George's 240051000510 1725 Cool Spring Elementary   Regular School No Elementary PK 06 2020   pk_12_total 12 26 867   * *         *                             915 12 26 867                                       915
1243194 1243194 MD     school 2400510 16   Prince George's 240051001014 213 Cooper Lane Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 176 324   * 11         *                             527   176 324     11                                 527
1246787 1246787 MD     school 2400090 30   Baltimore City 240009001530 432 Coppin Academy   Regular School Yes High 09 12 2020   pk_12_total * 348 *           *   *                             355   348                                         355
1243923 1243923 MD     school 2400510 16   Prince George's 240051001222 1347 Cora L. Rice Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 585 40   * *         *                             636   585 40                                       636
1237365 1237365 MD     school 2400060 2   Anne Arundel 240006000059 1043 Corkran Middle School   Regular School No Middle 06 08 2020   pk_12_total 237 176 167   * 25     *   46                             657 237 176 167     25         46                       657
1241649 1241649 MD     school 2400420 13   Howard 240042001699 616 Cradlerock Elementary   Regular School No Elementary PK 05 2020   pk_12_total 97 231 88   * 36         44                             497 97 231 88     36         44                       497
1239759 1239759 MD     school 2400210 6   Carroll 240021001105 715 Cranberry Station Elementary   Regular School No Elementary PK 05 2020   pk_12_total 421 25 51   * *         25                             528 421 25 51               25                       528
1246693 1246693 MD     school 2400090 30   Baltimore City 240009001716 384 Creative City Public Charter School   Regular School Yes Elementary KG 05 2020   pk_12_total 28 298 *     *         14                             346 28 298                 14                       346
1240801 1240801 MD     school 2400360 11   Garrett 240036000665 1408 Crellin Elementary   Regular School No Elementary KG 05 2020   pk_12_total 127   *               *                             135 127                                           135
1237275 1237275 MD     school 2400030 1   Allegany 240003000010 701 Cresaptown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 284 * 12     *     *   16                             320 284   12               16                       320
1243000 1243000 MD     school 2400480 15   Montgomery 240048000814 808 Cresthaven Elementary   Regular School No Elementary 03 05 2020   pk_12_total 17 186 260   * 34     *   *                             505 17 186 260     34                                 505
1240449 1240449 MD     school 2400330 10   Frederick 240033001357 227 Crestwood Middle   Regular School No Middle 06 08 2020   pk_12_total 202 199 197   * 48     *   40                             691 202 199 197     48         40                       691
1244856 1244856 MD     school 2400570 19   Somerset 240057001201 702 Crisfield Academy and High School   Regular School No High 08 12 2020   pk_12_total 244 106 45   * *         18                             415 244 106 45               18                       415
1237742 1237742 MD     school 2400060 2   Anne Arundel 240006000060 3072 Crofton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 502 157 81   * 36         49                             828 502 157 81     36         49                       828
1237909 1237909 MD     school 2400060 2   Anne Arundel 240006001517 3362 Crofton Meadows Elementary   Regular School No Elementary KG 05 2020   pk_12_total 321 93 56     29         55                             554 321 93 56     29         55                       554
1237869 1237869 MD     school 2400060 2   Anne Arundel 240006001403 3263 Crofton Middle   Regular School No Middle 06 08 2020   pk_12_total 746 271 136   * 105     *   76                             1345 746 271 136     105         76                       1345
1237749 1237749 MD     school 2400060 2   Anne Arundel 240006000061 3082 Crofton Woods Elementary   Regular School No Elementary KG 05 2020   pk_12_total 525 48 69   * 54     *   63                             763 525 48 69     54         63                       763
1238794 1238794 MD     school 2400120 3   Baltimore County 240012000463 916 Cromwell Valley Elementary Technology   Regular School No Elementary PK 05 2020   pk_12_total 142 158 15   * 31         28                             375 142 158 15     31         28                       375
1243217 1243217 MD     school 2400510 16   Prince George's 240051001463 303 Croom High   Alternative School No High 11 12 2020   pk_12_total   62 *               *                             65   62                                         65
1246348 1246348 MD     school 2400090 30   Baltimore City 240009000182 247 Cross Country Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 20 569 104   *       *   *                             699 20 569 104                                       699

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