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_state_id

✎ 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
1240380 1240380 MD     school 2400330 10   Frederick 240033000649 204 Lincoln Elementary   Regular School No Elementary PK 05 2020   pk_12_total 86 216 218   * 20         55                             598 86 216 218     20         55                       598
1241306 1241306 MD     school 2400420 13   Howard 240042000753 204 St. Johns Lane Elementary   Regular School No Elementary KG 05 2020   pk_12_total 329 99 43   * 260     *   31                             764 329 99 43     260         31                       764
1241885 1241885 MD     school 2400480 15   Montgomery 240048000840 204 Garrett Park Elementary   Regular School No Elementary PK 05 2020   pk_12_total 310 98 193   * 132     *   65                             802 310 98 193     132         65                       802
1244916 1244916 MD     school 2400630 20   Talbot 240063001247 204 St. Michaels Elementary   Regular School No Elementary PK 05 2020   pk_12_total 200 55 28     *         15                             302 200 55 28               15                       302
1244978 1244978 MD     school 2400660 21   Washington 240066001295 204 Williamsport High   Regular School No High 09 12 2020   pk_12_total 663 79 105   * *         47                             903 663 79 105               47                       903
1246015 1246015 MD     school 2400090 30   Baltimore City 240009000277 204 Mary E. Rodman Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 276 *     *         *                             285   276                                         285
1238374 1238374 MD     school 2400120 3   Baltimore County 240012000503 205 Woodmoor Elementary   Regular School No Elementary PK 05 2020   pk_12_total 12 536 46   * *     *   *                             614 12 536 46                                       614
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
1240280 1240280 MD     school 2400300 9   Dorchester 240030000625 205 Warwick Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 294 27 18     *         19                             361 294 27 18               19                       361
1243162 1243162 MD     school 2400510 16   Prince George's 240051000985 205 Bladensburg Elementary   Regular School No Elementary PK 06 2020   pk_12_total 17 209 557   * *     *   *                             795 17 209 557                                       795
1245382 1245382 MD     school 2400720 23   Worcester 240072001332 205 Snow Hill Elementary   Regular School No Elementary PK 03 2020   pk_12_total 239 91 19   * *         30                             383 239 91 19               30                       383
1246026 1246026 MD     school 2400090 30   Baltimore City 240009000339 205 Woodhome Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 36 314 51     *     *   *                             415 36 314 51                                       415
1238381 1238381 MD     school 2400120 3   Baltimore County 240012000471 206 Scotts Branch Elementary   Regular School No Elementary KG 05 2020   pk_12_total 10 487 33     *     *   *                             543 10 487 33                                       543
1239417 1239417 MD     school 2400150 4   Calvert 240015000509 206 Calvert Country School   Special Education School No Other 03 12 2020   pk_12_total 29 * *   * *         *                             46 29                                           46
1239861 1239861 MD     school 2400240 7   Cecil 240024000791 206 Bohemia Manor Middle   Regular School No Middle 06 08 2020   pk_12_total 385 34 43   * *     *   28                             495 385 34 43               28                       495
1241893 1241893 MD     school 2400480 15   Montgomery 240048000939 206 Twinbrook Elementary   Regular School No Elementary PK 05 2020   pk_12_total 63 54 362   * 59         18                             558 63 54 362     59         18                       558
1246034 1246034 MD     school 2400090 30   Baltimore City 240009000210 206 Furley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 21 437 26   * *     *                                 495 21 437 26                                       495
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
1239425 1239425 MD     school 2400150 4   Calvert 240015000517 207 Calvert Elementary   Regular School No Elementary PK 05 2020   pk_12_total 326 95 27   * *         63                             516 326 95 27               63                       516
1240285 1240285 MD     school 2400300 9   Dorchester 240030000618 207 North Dorchester High School   Regular School No High 09 12 2020   pk_12_total 349 112 39     *         28                             533 349 112 39               28                       533
1241311 1241311 MD     school 2400420 13   Howard 240042000743 207 Mount Hebron High   Regular School No High 09 12 2020   pk_12_total 717 217 163   * 525     *   67                             1695 717 217 163     525         67                       1695
1241901 1241901 MD     school 2400480 15   Montgomery 240048000947 207 Beall Elementary   Regular School No Elementary PK 05 2020   pk_12_total 203 81 133     71     *   41                             531 203 81 133     71         41                       531
1245387 1245387 MD     school 2400720 23   Worcester 240072001334 207 Snow Hill High   Regular School No High 09 12 2020   pk_12_total 199 74 17     *         20                             315 199 74 17               20                       315
1246045 1246045 MD     school 2400090 30   Baltimore City 240009000183 207 Curtis Bay Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 171 280 166   *       *   39                             659 171 280 166               39                       659
1239433 1239433 MD     school 2400150 4   Calvert 240015001655 208 Barstow Elementary   Regular School No Elementary PK 05 2020   pk_12_total 432 103 39   * *     *   73                             658 432 103 39               73                       658
1240289 1240289 MD     school 2400300 9   Dorchester 240030000619 208 North Dorchester Middle School   Regular School No Middle 06 08 2020   pk_12_total 277 117 34     *         40                             477 277 117 34               40                       477
1240388 1240388 MD     school 2400330 10   Frederick 240033001410 208 Heather Ridge   Alternative School No High 06 12 2020   pk_12_total 21 19 *   *           *                             56 21 19                                         56
1241318 1241318 MD     school 2400420 13   Howard 240042000744 208 Northfield Elementary   Regular School No Elementary KG 05 2020   pk_12_total 338 70 57   * 177         57                             702 338 70 57     177         57                       702
1243167 1243167 MD     school 2400510 16   Prince George's 240051000987 208 Bladensburg High   Regular School No High 09 12 2020   pk_12_total 25 477 1389   * 30     *   *                             1936 25 477 1389     30                                 1936
1245393 1245393 MD     school 2400720 23   Worcester 240072001333 208 Snow Hill Middle   Regular School No Middle 04 08 2020   pk_12_total 250 112 19   * *         32                             420 250 112 19               32                       420
1238397 1238397 MD     school 2400120 3   Baltimore County 240012000402 209 Hebbville Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 423 72   * *         17                             527   423 72               17                       527
1239441 1239441 MD     school 2400150 4   Calvert 240015000511 209 Huntingtown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 392 31 22               55                             500 392 31 22               55                       500
1240393 1240393 MD     school 2400330 10   Frederick 240033000632 209 Frederick High   Regular School No High 09 12 2020   pk_12_total 384 375 561   * 116     *   65                             1508 384 375 561     116         65                       1508
1241322 1241322 MD     school 2400420 13   Howard 240042000748 209 Patapsco Middle   Regular School No Middle 06 08 2020   pk_12_total 306 96 77     247     *   17                             746 306 96 77     247         17                       746
1241908 1241908 MD     school 2400480 15   Montgomery 240048000862 209 Lakewood Elementary   Regular School No Elementary KG 05 2020   pk_12_total 106 56 48   * 213     *   34                             460 106 56 48     213         34                       460
1238405 1238405 MD     school 2400120 3   Baltimore County 240012000455 210 Powhatan Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 206 27   *           11                             251   206 27               11                       251
1240401 1240401 MD     school 2400330 10   Frederick 240033000645 210 North Frederick Elementary   Regular School No Elementary PK 05 2020   pk_12_total 250 122 182     31     *   83                             669 250 122 182     31         83                       669
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
1241916 1241916 MD     school 2400480 15   Montgomery 240048000872 210 Maryvale Elementary   Regular School No Elementary PK 05 2020   pk_12_total 143 169 199   * 66         46                             625 143 169 199     66         46                       625
1243176 1243176 MD     school 2400510 16   Prince George's 240051001146 210 Rogers Heights Elementary   Regular School No Elementary PK 06 2020   pk_12_total 11 99 692     14     *   *                             820 11 99 692     14                                 820
1246056 1246056 MD     school 2400090 30   Baltimore City 240009000241 210 Hazelwood Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 437 29     *         *                             477   437 29                                       477
1238413 1238413 MD     school 2400120 3   Baltimore County 240012000498 211 Winfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 14 425 32   * *         15                             493 14 425 32               15                       493
1240405 1240405 MD     school 2400330 10   Frederick 240033000658 211 West Frederick Middle   Regular School No Middle 06 08 2020   pk_12_total 242 229 374     47     *   52                             947 242 229 374     47         52                       947
1240974 1240974 MD     school 2400390 12   Harford 240039000700 211 G. Lisby Elementary at Hillsdale   Regular School No Elementary PK 05 2020   pk_12_total 145 168 34     *     *   57                             413 145 168 34               57                       413
1241333 1241333 MD     school 2400420 13   Howard 240042000727 211 Dunloggin Middle   Regular School No Middle 06 08 2020   pk_12_total 237 105 40     217     *   27                             628 237 105 40     217         27                       628
1241920 1241920 MD     school 2400480 15   Montgomery 240048000857 211 Julius West Middle   Regular School No Middle 06 08 2020   pk_12_total 443 228 377   * 250     *   76                             1382 443 228 377     250         76                       1382
1243185 1243185 MD     school 2400510 16   Prince George's 240051090458 211 Gladys Noon Spellman Elementary   Regular School No Elementary PK 06 2020   pk_12_total 27 283 203   * 31         *                             548 27 283 203     31                                 548
1246064 1246064 MD     school 2400090 30   Baltimore City 240009000212 211 Gardenville Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 274 *   * *         *                             295   274                                         295
1240982 1240982 MD     school 2400390 12   Harford 240039000680 212 Bakerfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 143 141 82     15         45                             426 143 141 82     15         45                       426
1241927 1241927 MD     school 2400480 15   Montgomery 240048000874 212 Meadow Hall Elementary   Regular School No Elementary KG 05 2020   pk_12_total 74 40 239   * 34         18                             407 74 40 239     34         18                       407
1246075 1246075 MD     school 2400090 30   Baltimore City 240009000213 212 Garrett Heights Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 31 243 *           *   *                             289 31 243                                         289
1238421 1238421 MD     school 2400120 3   Baltimore County 240012000497 213 Winand Elementary   Regular School No Elementary PK 05 2020   pk_12_total 16 410 17   * *     *   10                             465 16 410 17               10                       465
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
1240410 1240410 MD     school 2400330 10   Frederick 240033000634 213 Gov. Thomas Johnson High   Regular School No High 09 12 2020   pk_12_total 615 390 542   * 83     *   92                             1730 615 390 542     83         92                       1730
1241341 1241341 MD     school 2400420 13   Howard 240042000764 213 Worthington Elementary   Regular School No Elementary PK 05 2020   pk_12_total 199 34 38   * 202         33                             508 199 34 38     202         33                       508
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
1246083 1246083 MD     school 2400090 30   Baltimore City 240009000223 213 Govans Elementary   Regular School Yes Elementary PK 05 2020   pk_12_total * 368 *                                             381   368                                         381
1238429 1238429 MD     school 2400120 3   Baltimore County 240012000405 214 Hernwood Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 339 18   * *         15                             383   339 18               15                       383
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
1243202 1243202 MD     school 2400510 16   Prince George's 240051001171 214 Templeton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 59 183 527   * 164     *   *                             943 59 183 527     164                                 943
1246094 1246094 MD     school 2400090 30   Baltimore City 240009001428 214 Guilford Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 293 *     *         *                             305   293                                         305
1239454 1239454 MD     school 2400150 4   Calvert 240015090465 215 Plum Point Elementary   Regular School No Elementary PK 05 2020   pk_12_total 452 50 37     15         55                             609 452 50 37     15         55                       609
1241354 1241354 MD     school 2400420 13   Howard 240042090449 215 Waverly Elementary   Regular School No Elementary PK 05 2020   pk_12_total 328 59 30   * 481         48                             951 328 59 30     481         48                       951
1241934 1241934 MD     school 2400480 15   Montgomery 240048000799 215 Carl Sandburg Center   Special Education School No Elementary KG 05 2020   pk_12_total 17 36 33     10         *                             97 17 36 33     10                                 97
1246105 1246105 MD     school 2400090 30   Baltimore City 240009000243 215 Highlandtown Elementary/Middle #215   Regular School No Elementary PK 08 2020   pk_12_total * 73 387     *     *   *                             476   73 387                                       476
1238437 1238437 MD     school 2400120 3   Baltimore County 240012000371 216 Deer Park Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 385 *     *         *                             404   385                                         404
1239458 1239458 MD     school 2400150 4   Calvert 240015000027 216 Plum Point Middle   Regular School No Middle 06 08 2020   pk_12_total 493 63 35     12     *   52                             656 493 63 35     12         52                       656
1241358 1241358 MD     school 2400420 13   Howard 240042000173 216 Burleigh Manor Middle School   Regular School No Middle 06 08 2020   pk_12_total 242 85 34   * 404         41                             811 242 85 34     404         41                       811
1241941 1241941 MD     school 2400480 15   Montgomery 240048000937 216 Travilah Elementary   Regular School No Elementary KG 05 2020   pk_12_total 109 22 35     159     *   14                             341 109 22 35     159         14                       341
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
1238445 1238445 MD     school 2400120 3   Baltimore County 240012001159 217 New Town Elementary   Regular School No Elementary PK 05 2020   pk_12_total 50 656 36   * 40     *   41                             830 50 656 36     40         41                       830
1239463 1239463 MD     school 2400150 4   Calvert 240015001342 217 Huntingtown High School   Regular School No High 09 12 2020   pk_12_total 1085 116 83   * 25         97                             1408 1085 116 83     25         97                       1408
1241365 1241365 MD     school 2400420 13   Howard 240042000856 217 Hollifield Station Elementary   Regular School No Elementary KG 05 2020   pk_12_total 212 117 108   * 401     *   28                             872 212 117 108     401         28                       872
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
1246113 1246113 MD     school 2400090 30   Baltimore City 240009000156 217 Belmont Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 254 *   *           *                             262   254                                         262
1241373 1241373 MD     school 2400420 13   Howard 240042001551 218 Bellows Spring Elementary   Regular School No Elementary PK 05 2020   pk_12_total 202 198 90   * 231         51                             776 202 198 90     231         51                       776
1238450 1238450 MD     school 2400120 3   Baltimore County 240012001753 219 Watershed Public Charter   Regular School Yes Elementary KG 03 2020   pk_12_total 50 84 *   * *         21                             170 50 84                 21                       170
1240414 1240414 MD     school 2400330 10   Frederick 240033001413 219 Monocacy Middle   Regular School No Middle 06 08 2020   pk_12_total 268 224 380   * 40     *   49                             969 268 224 380     40         49                       969
1241381 1241381 MD     school 2400420 13   Howard 240042001646 219 Veterans Elementary   Regular School No Elementary PK 05 2020   pk_12_total 217 130 75   * 499     *   33                             962 217 130 75     499         33                       962
1241948 1241948 MD     school 2400480 15   Montgomery 240048000828 219 Farmland Elementary   Regular School No Elementary KG 05 2020   pk_12_total 404 66 94     260         32                             856 404 66 94     260         32                       856
1246121 1246121 MD     school 2400090 30   Baltimore City 240009000340 219 Yorkwood Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 392 13   * *         *                             412   392 13                                       412
1241956 1241956 MD     school 2400480 15   Montgomery 240048000869 220 Luxmanor Elementary   Regular School No Elementary PK 05 2020   pk_12_total 220 102 160     157         39                             678 220 102 160     157         39                       678
1246132 1246132 MD     school 2400090 30   Baltimore City 240009000284 220 Morrell Park Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 181 156 90   * 20     *   20                             471 181 156 90     20         20                       471
1246142 1246142 MD     school 2400090 30   Baltimore City 240009000286 221 The Mount Washington School   Regular School No Elementary KG 08 2020   pk_12_total 150 373 24     14     *   24                             587 150 373 24     14         24                       587
1240422 1240422 MD     school 2400330 10   Frederick 240033001521 222 Monocacy Elementary   Regular School No Elementary PK 05 2020   pk_12_total 167 177 190   * 17     *   53                             611 167 177 190     17         53                       611
1240430 1240430 MD     school 2400330 10   Frederick 240033090471 223 Ballenger Creek Elementary   Regular School No Elementary PK 05 2020   pk_12_total 218 113 124   * 61     *   64                             586 218 113 124     61         64                       586
1246153 1246153 MD     school 2400090 30   Baltimore City 240009000299 223 Pimlico Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 579 29     *     *   *                             621   579 29                                       621
1240434 1240434 MD     school 2400330 10   Frederick 240033001549 225 Gov. Thomas Johnson Middle   Regular School No Middle 06 08 2020   pk_12_total 258 104 124   * 31     *   31                             553 258 104 124     31         31                       553
1246164 1246164 MD     school 2400090 30   Baltimore City 240009000331 225 Westport Academy   Regular School No Elementary PK 08 2020   pk_12_total * 253 13     *         *                             281   253 13                                       281
1240445 1240445 MD     school 2400330 10   Frederick 240033001187 226 Monocacy Valley Montessori   Regular School Yes Elementary PK 08 2020   pk_12_total 193 32 30   * 25     *   18                             300 193 32 30     25         18                       300
1241963 1241963 MD     school 2400480 15   Montgomery 240048000786 226 Beverly Farms Elementary   Regular School No Elementary KG 05 2020   pk_12_total 261 45 52   * 190         36                             585 261 45 52     190         36                       585
1246175 1246175 MD     school 2400090 30   Baltimore City 240009000326 226 Violetville Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 103 187 62   * 13     *   18                             386 103 187 62     13         18                       386
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
1241970 1241970 MD     school 2400480 15   Montgomery 240048000904 227 Ritchie Park Elementary   Regular School No Elementary KG 05 2020   pk_12_total 206 51 49     63     *   31                             401 206 51 49     63         31                       401
1240460 1240460 MD     school 2400330 10   Frederick 240033001712 228 Carroll Creek Montessori Public Charter   Regular School Yes Elementary PK 08 2020   pk_12_total 199 36 56   * 11         15                             318 199 36 56     11         15                       318
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
1246186 1246186 MD     school 2400090 30   Baltimore City 240009000257 228 John Ruhrah Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 62 35 741   * *         *                             851 62 35 741                                       851
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
1246197 1246197 MD     school 2400090 30   Baltimore City 240009000247 229 Holabird Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 45 204 239   * *     *   11                             504 45 204 239               11                       504
1240990 1240990 MD     school 2400390 12   Harford 240039000693 230 Halls Cross Roads Elementary   Regular School No Elementary PK 05 2020   pk_12_total 106 239 46   * *     *   56                             454 106 239 46               56                       454

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