enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 1,398 ✖

grade ✖

  • pk_12_total · 1,398 ✖
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
1238185 1238185 MD     school 2400120 3   Baltimore County 240012001756 51 Northwest EDLP at Milford Mill Academy   Alternative School No High 11 12 2020   pk_12_total   * *                                             *                                              
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 * *                                               *                                              
1238203 1238203 MD     school 2400120 3   Baltimore County 240012000925 57 Home Assignments-Elementary   Alternative School No Middle 04 06 2020   pk_12_total   *                                               *                                              
1239512 1239512 MD     school 2400150 4   Calvert 240015001344 500 Calvert County Alternative School   Alternative School No High 09 12 2020   pk_12_total * * *                                             *                                              
1239771 1239771 MD     school 2400210 6   Carroll 240021001349 718 PRIDE School   Alternative School No Elementary 01 05 2020   pk_12_total * *                                               *                                              
1239774 1239774 MD     school 2400210 6   Carroll 240021001694 726 Crossroads Middle School   Alternative School No Middle 06 08 2020   pk_12_total *   *               *                             *                                              
1244872 1244872 MD     school 2400570 19   Somerset 240057001203 1003 Ewell School   Regular School No Elementary PK 07 2020   pk_12_total *                                                 *                                              
1244572 1244572 MD     school   16   Prince George's   2217 Incarcerated Youth Center (JACS)             2020   pk_12_total   * *                                             10                                             10
1242617 1242617 MD     school 2400480 15   Montgomery 240048001635 587 PEP - Itinerant   Special Education School No Prekindergarten PK PK 2020   pk_12_total 43 18 16   * 16         *                             100 43 18 16     16                                 100
1245177 1245177 MD     school 2400660 21   Washington 240066001293 2501 Western Heights Middle   Regular School No Middle 06 08 2020   pk_12_total 481 235 160     19         106                             1001 481 235 160     19         106                       1001
1243134 1243134 MD     school 2400510 16   Prince George's 240051001101 110 Martin Luther King Jr. Middle   Regular School No Middle 06 08 2020   pk_12_total 44 490 367   * 70     *   26                             1003 44 490 367     70         26                       1003
1242134 1242134 MD     school 2400480 15   Montgomery 240048090453 311 Francis Scott Key Middle   Regular School No Middle 06 08 2020   pk_12_total 27 437 420   * 90     *   26                             1004 27 437 420     90         26                       1004
1239866 1239866 MD     school 2400240 7   Cecil 240024000568 302 Elkton High   Regular School No High 09 12 2020   pk_12_total 480 288 128   * 13     *   91                             1005 480 288 128     13         91                       1005
1244940 1244940 MD     school 2400630 20   Talbot 240063001250 501 Tilghman Elementary   Regular School No Elementary PK 05 2020   pk_12_total 89   *               *                             101 89                                           101
1242833 1242833 MD     school 2400480 15   Montgomery 240048001457 775 Eastern Middle School   Regular School No Middle 06 08 2020   pk_12_total 195 189 509   * 77     *   37                             1010 195 189 509     77         37                       1010
1239836 1239836 MD     school 2400210 6   Carroll 240021000546 1401 South Carroll High   Regular School No High 09 12 2020   pk_12_total 881 18 68   * 22     *   17                             1011 881 18 68     22         17                       1011
1239955 1239955 MD     school 2400240 7   Cecil 240024000575 514 North East High   Regular School No High 09 12 2020   pk_12_total 840 62 55   * 12         42                             1016 840 62 55     12         42                       1016
1239162 1239162 MD     school 2400120 3   Baltimore County 240012000438 1473 Overlea High   Regular School No High 09 12 2020   pk_12_total 173 665 105   * 28     *   45                             1020 173 665 105     28         45                       1020
1240521 1240521 MD     school 2400330 10   Frederick 240033001536 716 Urbana Middle   Regular School No Middle 06 08 2020   pk_12_total 548 73 123   * 203     *   67                             1021 548 73 123     203         67                       1021
1241542 1241542 MD     school 2400420 13   Howard 240042000859 525 Fulton Elementary   Regular School No Elementary KG 05 2020   pk_12_total 423 164 47   * 296     *   89                             1021 423 164 47     296         89                       1021
1246326 1246326 MD     school 2400090 30   Baltimore City 240009000268 245 Leith Walk Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 945 60     *     *   *                             1023   945 60                                       1023
1243045 1243045 MD     school 2400480 15   Montgomery 240048000409 823 Argyle Middle   Regular School No Middle 06 08 2020   pk_12_total 72 256 582   * 88         25                             1024 72 256 582     88         25                       1024
1244698 1244698 MD     school 2400600 18   Saint Mary's 240060001229 305 Leonardtown Middle   Regular School No Middle 06 08 2020   pk_12_total 782 89 52   * 25     *   72                             1024 782 89 52     25         72                       1024
1240165 1240165 MD     school 2400270 8   Charles 240027000615 621 Mattawoman Middle School   Regular School No Middle 06 08 2020   pk_12_total 52 748 107   * 52     *   62                             1026 52 748 107     52         62                       1026
1242015 1242015 MD     school 2400480 15   Montgomery 240048001447 237 Robert Frost Middle School   Regular School No Middle 06 08 2020   pk_12_total 387 116 77   * 399         45                             1028 387 116 77     399         45                       1028
1243498 1243498 MD     school 2400510 16   Prince George's 240051000982 714 Benjamin Tasker Middle School   Regular School No Middle 06 08 2020   pk_12_total 124 708 118   * 48     *   21                             1031 124 708 118     48         21                       1031
1244070 1244070 MD     school 2400510 16   Prince George's 240051001036 1502 Frederick Douglass High   Regular School No High 09 12 2020   pk_12_total 16 905 68   * *     *   36                             1033 16 905 68               36                       1033
1241069 1241069 MD     school 2400390 12   Harford 240039000701 335 Homestead/Wakefield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 753 59 75   * 69     *   75                             1034 753 59 75     69         75                       1034
1239328 1239328 MD     school 2400120 3   Baltimore County 240012001440 1556 Middle River Middle   Regular School No Middle 06 08 2020   pk_12_total 343 466 115   * 36     *   70                             1035 343 466 115     36         70                       1035
1244896 1244896 MD     school 2400630 20   Talbot 240063001244 104 Easton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 309 219 423     26         62                             1039 309 219 423     26         62                       1039
1241161 1241161 MD     school 2400390 12   Harford 240039000685 518 Darlington Elementary   Regular School No Elementary KG 05 2020   pk_12_total 91 * *     *         *                             104 91                                           104
1242647 1242647 MD     school 2400480 15   Montgomery 240048001526 606 Cabin John Middle School   Regular School No Middle 06 08 2020   pk_12_total 408 120 84   * 365         62                             1040 408 120 84     365         62                       1040
1244715 1244715 MD     school 2400600 18   Saint Mary's 240060001231 404 Margaret Brent Middle   Regular School No Middle 06 08 2020   pk_12_total 848 81 42   * *     *   60                             1043 848 81 42               60                       1043
1237966 1237966 MD     school 2400060 2   Anne Arundel 240006000036 4033 Annapolis Middle   Regular School No Middle 06 08 2020   pk_12_total 208 297 498   * 13     *   26                             1044 208 297 498     13         26                       1044
1239651 1239651 MD     school 2400210 6   Carroll 240021001394 507 Liberty High   Regular School No High 09 12 2020   pk_12_total 861 44 54   * 43     *   33                             1044 861 44 54     43         33                       1044
1241974 1241974 MD     school 2400480 15   Montgomery 240048000849 228 Herbert Hoover Middle   Regular School No Middle 06 08 2020   pk_12_total 430 74 89     392     *   59                             1045 430 74 89     392         59                       1045
1238476 1238476 MD     school 2400120 3   Baltimore County 240012000458 272 Randallstown High   Regular School No High 09 12 2020   pk_12_total 14 951 44   * 23         15                             1048 14 951 44     23         15                       1048
1243632 1243632 MD     school 2400510 16   Prince George's 240051001024 1010 Dwight D. Eisenhower Middle   Regular School No Middle 06 08 2020   pk_12_total 46 524 437   * 17     *   21                             1052 46 524 437     17         21                       1052
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
1241083 1241083 MD     school 2400390 12   Harford 240039000717 348 Youths Benefit Elementary   Regular School No Elementary KG 05 2020   pk_12_total 939 14 40   * 24     *   34                             1057 939 14 40     24         34                       1057
1239381 1239381 MD     school 2400150 4   Calvert 240015000611 113 Patuxent High   Regular School No High 09 12 2020   pk_12_total 698 186 65   * 24     *   85                             1063 698 186 65     24         85                       1063
1239346 1239346 MD     school 2400120 3   Baltimore County 240012000477 1573 Sparrows Point High   Regular School No High 09 12 2020   pk_12_total 881 79 52   * 10     *   41                             1067 881 79 52     10         41                       1067
1244657 1244657 MD     school 2400600 18   Saint Mary's 240060001237 101 Spring Ridge Middle   Regular School No Middle 06 08 2020   pk_12_total 402 377 125   * 32     *   122                             1067 402 377 125     32         122                       1067
1237722 1237722 MD     school 2400060 2   Anne Arundel 240006000039 3023 Arundel Middle   Regular School No Middle 06 08 2020   pk_12_total 480 283 118   * 57     *   122                             1068 480 283 118     57         122                       1068
1245273 1245273 MD     school 2400690 22   Wicomico 240069001088 520 Wicomico County Evening High   Alternative School No High 09 12 2020   pk_12_total 38 55 10     *         *                             107 38 55 10                                       107
1239702 1239702 MD     school 2400210 6   Carroll 240021001185 704 Winters Mill High   Regular School No High 09 12 2020   pk_12_total 792 75 126   * 34     *   48                             1079 792 75 126     34         48                       1079
1245258 1245258 MD     school 2400690 22   Wicomico 240069001320 513 Wicomico High   Regular School No High 09 12 2020   pk_12_total 323 535 112   * 31         74                             1079 323 535 112     31         74                       1079
1237893 1237893 MD     school 2400060 2   Anne Arundel 240006000107 3333 Old Mill Middle North   Regular School No Middle 06 08 2020   pk_12_total 345 475 144   * 48     *   66                             1081 345 475 144     48         66                       1081
1245335 1245335 MD     school 2400690 22   Wicomico 240069001309 1309 Parkside High   Regular School No High 09 12 2020   pk_12_total 590 351 52   * 35         54                             1083 590 351 52     35         54                       1083
1240025 1240025 MD     school 2400270 8   Charles 240027000601 104 Milton M. Somers Middle School   Regular School No Middle 06 08 2020   pk_12_total 444 428 86   * 45     *   79                             1086 444 428 86     45         79                       1086
1244244 1244244 MD     school 2400510 16   Prince George's 240051001257 1730 Mary Harris   Regular School No Elementary PK 05 2020   pk_12_total 32 43 1000   * *         *                             1091 32 43 1000                                       1091
1240021 1240021 MD     school 2400240 7   Cecil 240024090469 905 Rising Sun High   Regular School No High 09 12 2020   pk_12_total 990 * 59   * 11         28                             1100 990   59     11         28                       1100
1238711 1238711 MD     school 2400120 3   Baltimore County 240012001434 852 Ridgely Middle   Regular School No Middle 06 08 2020   pk_12_total 689 109 64   * 196     *   49                             1113 689 109 64     196         49                       1113
1243081 1243081 MD     school 2400480 15   Montgomery 240048001398 965 John L Gildner Regional Inst for Children & Adol   Special Education School No Other 04 12 2020   pk_12_total 35 41 25     *         *                             112 35 41 25                                       112
1237369 1237369 MD     school 2400060 2   Anne Arundel 240006000087 1053 Lindale Middle   Regular School No Middle 06 08 2020   pk_12_total 480 302 202   * 64     *   71                             1126 480 302 202     64         71                       1126
1239157 1239157 MD     school 2400120 3   Baltimore County 240012000442 1452 Parkville Middle & Center of Technology   Regular School No Middle 06 08 2020   pk_12_total 478 431 82   * 68     *   64                             1126 478 431 82     68         64                       1126
1240084 1240084 MD     school 2400270 8   Charles 240027000607 605 Thomas Stone High School   Regular School No High 09 12 2020   pk_12_total 161 703 189   * 15     *   54                             1128 161 703 189     15         54                       1128
1240473 1240473 MD     school 2400330 10   Frederick 240033000641 313 Middletown High   Regular School No High 09 12 2020   pk_12_total 970 19 70   * 26         42                             1129 970 19 70     26         42                       1129
1244218 1244218 MD     school 2400510 16   Prince George's 240051001112 1718 Nicholas Orem Middle   Regular School No Middle 06 08 2020   pk_12_total 12 193 912   * *     *   *                             1129 12 193 912                                       1129
1243214 1243214 MD     school 2400510 16   Prince George's 240051001368 217 Port Towns Elementary   Regular School No Elementary PK 06 2020   pk_12_total 16 351 751   * *     *   *                             1132 16 351 751                                       1132
1239561 1239561 MD     school 2400180 5   Caroline 240018000523 703 North Caroline High School   Regular School No High 09 12 2020   pk_12_total 728 111 210   * 11     *   72                             1138 728 111 210     11         72                       1138
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
1240153 1240153 MD     school 2400270 8   Charles 240027000144 619 Westlake High School   Regular School No High 09 12 2020   pk_12_total 74 866 91   * 45     *   59                             1140 74 866 91     45         59                       1140
1243008 1243008 MD     school 2400480 15   Montgomery 240048000891 812 Parkland Middle   Regular School No Middle 06 08 2020   pk_12_total 97 247 599   * 164         30                             1141 97 247 599     164         30                       1141
1246721 1246721 MD     school 2400090 30   Baltimore City 240009000330 407 Western High   Regular School No High 09 12 2020   pk_12_total 57 1016 48   * 10     *   *                             1142 57 1016 48     10                                 1142
1243527 1243527 MD     school 2400510 16   Prince George's 240051001384 723 C. Elizabeth Rieg Regional Center   Special Education School No Other KG 12 2020   pk_12_total 13 88 12     *                                       115 13 88 12                                       115
1242659 1242659 MD     school 2400480 15   Montgomery 240048001128 647 Silver Spring International Middle   Regular School No Middle 06 08 2020   pk_12_total 294 250 492   * 62         52                             1153 294 250 492     62         52                       1153
1240038 1240038 MD     school 2400270 8   Charles 240027000596 106 La Plata High School   Regular School No High 09 12 2020   pk_12_total 750 225 57   * 33     *   88                             1159 750 225 57     33         88                       1159
1240948 1240948 MD     school 2400390 12   Harford 240039000689 177 Edgewood Middle   Regular School No Middle 06 08 2020   pk_12_total 350 518 148   * 26     *   107                             1160 350 518 148     26         107                       1160
1239446 1239446 MD     school 2400150 4   Calvert 240015000508 213 Calvert High   Regular School No High 09 12 2020   pk_12_total 737 224 81   * 21     *   93                             1161 737 224 81     21         93                       1161
1242744 1242744 MD     school 2400480 15   Montgomery 240048000933 755 Takoma Park Middle School   Regular School No Middle 06 08 2020   pk_12_total 341 395 197   * 169         58                             1162 341 395 197     169         58                       1162
1243097 1243097 MD     school 2400510 16   Prince George's 240051000978 104 Beltsville Academy   Regular School No Elementary PK 08 2020   pk_12_total 72 190 823   * 54     *   18                             1162 72 190 823     54         18                       1162
1246746 1246746 MD     school 2400090 30   Baltimore City 240009001313 416 Digital Harbor High School   Career and Technical School No High 09 12 2020   pk_12_total 80 715 346   * 13     *   *                             1162 80 715 346     13                                 1162
1238612 1238612 MD     school 2400120 3   Baltimore County 240012001547 473 New Town High   Regular School No High 09 12 2020   pk_12_total 22 1067 31     11         37                             1168 22 1067 31     11         37                       1168
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
1239356 1239356 MD     school 2400120 3   Baltimore County 240012000379 1575 Eastern Technical High School   Career and Technical School No High 09 12 2020   pk_12_total 562 235 57   * 257     *   55                             1172 562 235 57     257         55                       1172
1246711 1246711 MD     school 2400090 30   Baltimore City 240009000297 405 Patterson High   Career and Technical School No High 09 12 2020   pk_12_total 76 549 524   * *         10                             1174 76 549 524               10                       1174
1240770 1240770 MD     school 2400330 10   Frederick 240033000655 2610 Walkersville High   Regular School No High 09 12 2020   pk_12_total 747 161 145   * 39     *   86                             1185 747 161 145     39         86                       1185
1244602 1244602 MD     school 2400540 17   Queen Anne's 240054001195 301 Queen Anne's County High School   Regular School No High 09 12 2020   pk_12_total 933 84 109   * *         50                             1187 933 84 109               50                       1187
1238602 1238602 MD     school 2400120 3   Baltimore County 240012001347 452 Owings Mills High   Regular School No High 09 12 2020   pk_12_total 77 642 385   * 54     *   25                             1189 77 642 385     54         25                       1189
1243783 1243783 MD     school 2400510 16   Prince George's 240051001133 1220 Potomac High   Regular School No High 09 12 2020   pk_12_total * 820 338   * 14         14                             1196   820 338     14         14                       1196
1241420 1241420 MD     school 2400420 13   Howard 240042000731 404 Glenelg High   Regular School No High 09 12 2020   pk_12_total 879 46 59   * 156     *   54                             1197 879 46 59     156         54                       1197
1243205 1243205 MD     school 2400510 16   Prince George's 240051000865 216 Annapolis Road Academy   Alternative School No Secondary 09 10 2020   pk_12_total   66 51               *                             120   66 51                                       120
1242457 1242457 MD     school 2400480 15   Montgomery 240048001441 522 Lakelands Park Middle   Regular School No Middle 06 08 2020   pk_12_total 443 199 298   * 181         78                             1200 443 199 298     181         78                       1200
1240994 1240994 MD     school 2400390 12   Harford 240039000678 265 Aberdeen Middle   Regular School No Middle 06 08 2020   pk_12_total 411 488 131   * 26     *   139                             1203 411 488 131     26         139                       1203
1241832 1241832 MD     school 2400480 15   Montgomery 240048000897 152 Poolesville High   Regular School No High 09 12 2020   pk_12_total 581 68 94   * 397     *   61                             1205 581 68 94     397         61                       1205
1241226 1241226 MD     school 2400420 13   Howard 240042001189 80 Homewood School   Alternative School No High 06 12 2020   pk_12_total 30 70 14   * *         *                             122 30 70 14                                       122
1244633 1244633 MD     school 2400540 17   Queen Anne's 240054001076 405 Kent Island High School   Regular School No High 09 12 2020   pk_12_total 985 66 76   * 27     *   60                             1221 985 66 76     27         60                       1221
1244376 1244376 MD     school 2400510 16   Prince George's 240051001186 1908 William Wirt Middle   Regular School No Middle 06 08 2020   pk_12_total 23 215 940   * 40     *   *                             1224 23 215 940     40                                 1224
1244888 1244888 MD     school 2400630 20   Talbot 240063001242 101 Easton High   Regular School No High 09 12 2020   pk_12_total 682 189 267   * 24     *   60                             1224 682 189 267     24         60                       1224
1238836 1238836 MD     school 2400120 3   Baltimore County 240012000374 953 Dumbarton Middle   Regular School No Middle 06 08 2020   pk_12_total 717 155 179     101     *   70                             1225 717 155 179     101         70                       1225
1241770 1241770 MD     school 2400480 15   Montgomery 240048000918 104 Seneca Valley High   Regular School No High 09 12 2020   pk_12_total 175 445 433   * 122         49                             1226 175 445 433     122         49                       1226
1238817 1238817 MD     school 2400120 3   Baltimore County 240012000483 922 Ridge Ruxton   Special Education School No Other PK 12 2020   pk_12_total 38 42 15   * 19         *                             123 38 42 15     19                                 123
1241132 1241132 MD     school 2400390 12   Harford 240039000703 391 John Archer School   Special Education School No Other PK 12 2020   pk_12_total 64 36 11     *         *                             123 64 36 11                                       123
1242291 1242291 MD     school 2400480 15   Montgomery 240048001118 413 North Bethesda Middle   Regular School No Middle 06 08 2020   pk_12_total 695 120 161   * 151     *   99                             1233 695 120 161     151         99                       1233
1238597 1238597 MD     school 2400120 3   Baltimore County 240012000389 451 Franklin Middle   Regular School No Middle 06 08 2020   pk_12_total 279 600 205   * 79     *   77                             1242 279 600 205     79         77                       1242
1241626 1241626 MD     school 2400420 13   Howard 240042000745 611 Oakland Mills High   Regular School No High 09 12 2020   pk_12_total 253 545 263     86     *   97                             1246 253 545 263     86         97                       1246
1238471 1238471 MD     school 2400120 3   Baltimore County 240012000432 271 Milford Mill Academy   Regular School No High 09 12 2020   pk_12_total 15 1118 68   * 17     *   28                             1251 15 1118 68     17         28                       1251
1241181 1241181 MD     school 2400390 12   Harford 240039000710 580 North Harford High   Regular School No High 09 12 2020   pk_12_total 1138 29 32   * 15         37                             1254 1138 29 32     15         37                       1254
1242029 1242029 MD     school 2400480 15   Montgomery 240048001451 239 Alternative Programs   Alternative School No High 07 12 2020   pk_12_total 10 63 43     *         *                             126 10 63 43                                       126

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