enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
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
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
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
1240297 1240297 MD     school 2400300 9   Dorchester 240030000624 302 Vienna Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 131 26 *     *         18                             183 131 26                 18                       183
1240308 1240308 MD     school 2400300 9   Dorchester 240030000622 508 South Dorchester School   Regular School No Elementary PK 08 2020   pk_12_total 196 * 15     *     *   12                             231 196   15               12                       231
1240312 1240312 MD     school 2400300 9   Dorchester 240030001423 707 Mace's Lane Middle School   Regular School No Middle 06 08 2020   pk_12_total 72 400 55     *     *   41                             576 72 400 55               41                       576
1240320 1240320 MD     school 2400300 9   Dorchester 240030000621 710 Sandy Hill Elementary   Regular School No Elementary PK 05 2020   pk_12_total 77 241 35     *         34                             395 77 241 35               34                       395
1240328 1240328 MD     school 2400300 9   Dorchester 240030000617 711 Maple Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 86 265 68     13         46                             478 86 265 68     13         46                       478
1240333 1240333 MD     school 2400300 9   Dorchester 240030000612 713 Cambridge-South Dorchester High School   Regular School No High 09 12 2020   pk_12_total 279 344 62   * 13         45                             745 279 344 62     13         45                       745
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
1240349 1240349 MD     school 2400300 9   Dorchester 240030000614 1503 Hurlock Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 163 133 38     *     *   32                             374 163 133 38               32                       374
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
1240033 1240033 MD     school 2400270 8   Charles 240027000609 105 Walter J. Mitchell Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 387 103 63   * 14     *   55                             626 387 103 63     14         55                       626
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
1240043 1240043 MD     school 2400270 8   Charles 240027000600 108 Maurice J. McDonough High School   Regular School No High 09 12 2020   pk_12_total 287 438 95   * 20     *   60                             902 287 438 95     20         60                       902
1240051 1240051 MD     school 2400270 8   Charles 240027000141 109 Mary H. Matula Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 254 198 49   * 30         39                             571 254 198 49     30         39                       571
1240059 1240059 MD     school 2400270 8   Charles 240027001492 302 Mt Hope/Nanjemoy Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 167 74 *   *           17                             264 167 74                 17                       264
1240067 1240067 MD     school 2400270 8   Charles 240027000610 501 Dr. Thomas L. Higdon Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 313 60 14     *         33                             426 313 60 14               33                       426
1240071 1240071 MD     school 2400270 8   Charles 240027000604 503 Piccowaxen Middle School   Regular School No Middle 06 08 2020   pk_12_total 332 49 23   * *     *   34                             450 332 49 23               34                       450
1240079 1240079 MD     school 2400270 8   Charles 240027000585 604 Dr. Samuel A. Mudd Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 42 407 98   * 10         28                             586 42 407 98     10         28                       586
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
1240092 1240092 MD     school 2400270 8   Charles 240027000593 606 J. P. Ryon Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 66 411 112   * 11     *   56                             659 66 411 112     11         56                       659
1240096 1240096 MD     school 2400270 8   Charles 240027000595 608 John Hanson Middle School   Regular School No Middle 06 08 2020   pk_12_total 147 517 128   * 20     *   75                             893 147 517 128     20         75                       893
1240104 1240104 MD     school 2400270 8   Charles 240027000594 609 Dr. James Craik Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 230 179 37   * 12         58                             518 230 179 37     12         58                       518
1240112 1240112 MD     school 2400270 8   Charles 240027000584 611 Dr. Gustavus Brown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 39 270 76   * *         36                             426 39 270 76               36                       426
1240120 1240120 MD     school 2400270 8   Charles 240027000582 612 Arthur Middleton Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 57 313 107     19         55                             551 57 313 107     19         55                       551
1240124 1240124 MD     school 2400270 8   Charles 240027000583 613 Benjamin Stoddert Middle School   Regular School No Middle 06 08 2020   pk_12_total 52 574 93   * 25     *   64                             814 52 574 93     25         64                       814
1240132 1240132 MD     school 2400270 8   Charles 240027000586 616 Eva Turner Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 26 334 53   * *         26                             443 26 334 53               26                       443
1240140 1240140 MD     school 2400270 8   Charles 240027010501 617 Daniel of St. Thomas Jenifer Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 33 444 99   * 14         50                             643 33 444 99     14         50                       643
1240148 1240148 MD     school 2400270 8   Charles 240027001519 618 William B. Wade Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 89 407 71   * 42         74                             686 89 407 71     42         74                       686
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
1240161 1240161 MD     school 2400270 8   Charles 240027000380 620 C. Paul Barnhart Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 21 447 98   * 31         50                             648 21 447 98     31         50                       648
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
1240173 1240173 MD     school 2400270 8   Charles 240027000805 622 Berry Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 58 443 83   * 63     *   60                             717 58 443 83     63         60                       717
1240178 1240178 MD     school 2400270 8   Charles 240027001416 623 North Point High School   Regular School No High 09 12 2020   pk_12_total 295 1112 135   * 114     *   146                             1814 295 1112 135     114         146                       1814
1240186 1240186 MD     school 2400270 8   Charles 240027001565 624 William A. Diggs Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 94 523 58     30     *   66                             775 94 523 58     30         66                       775
1240190 1240190 MD     school 2400270 8   Charles 240027001647 625 Theodore G. Davis Middle School   Regular School No Middle 06 08 2020   pk_12_total 71 618 83   * 32     *   72                             885 71 618 83     32         72                       885
1240198 1240198 MD     school 2400270 8   Charles 240027001656 626 Mary B. Neal Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 41 518 58   * 36         45                             699 41 518 58     36         45                       699
1240206 1240206 MD     school 2400270 8   Charles 240027001757 627 Billingsley Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 95 480 61   * 26     *   61                             725 95 480 61     26         61                       725
1240210 1240210 MD     school 2400270 8   Charles 240027000599 701 Matthew Henson Middle School   Regular School No Middle 06 08 2020   pk_12_total 92 552 80   * 19     *   64                             811 92 552 80     19         64                       811
1240218 1240218 MD     school 2400270 8   Charles 240027000592 703 J. C. Parks Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 70 368 84   * 20     *   61                             609 70 368 84     20         61                       609
1240222 1240222 MD     school 2400270 8   Charles 240027000589 705 General Smallwood Middle School   Regular School No Middle 06 08 2020   pk_12_total 201 247 23   * *     *   45                             527 201 247 23               45                       527
1240230 1240230 MD     school 2400270 8   Charles 240027001395 708 Robert D. Stethem Educational Center   Alternative School No High 06 12 2020   pk_12_total 25 53 *   *       *   *                             88 25 53                                         88
1240238 1240238 MD     school 2400270 8   Charles 240027000591 710 Indian Head Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 117 251 39     *         59                             473 117 251 39               59                       473
1240246 1240246 MD     school 2400270 8   Charles 240027000606 801 T. C. Martin Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 302 125 33   * *     *   55                             522 302 125 33               55                       522
1240251 1240251 MD     school 2400270 8   Charles 240027001727 802 St. Charles High School   Regular School No High 09 12 2020   pk_12_total 175 1005 90   11 29     *   97                             1410 175 1005 90   11 29         97                       1410
1240259 1240259 MD     school 2400270 8   Charles 240027000598 902 Malcolm Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 158 156 59     *     *   55                             436 158 156 59               55                       436
1240267 1240267 MD     school 2400270 8   Charles 240027000588 1001 Gale-Bailey Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 192 132 29     *         39                             395 192 132 29               39                       395
1240272 1240272 MD     school 2400270 8   Charles 240027000597 1002 Henry E. Lackey High School   Regular School No High 09 12 2020   pk_12_total 283 563 47   12 20     *   64                             990 283 563 47   12 20         64                       990
1239844 1239844 MD     school 2400240 7   Cecil 240024000562 104 Cecilton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 244 16 46   *           12                             319 244 16 46               12                       319
1239849 1239849 MD     school 2400240 7   Cecil 240024000558 204 Bohemia Manor High   Regular School No High 09 12 2020   pk_12_total 539 39 42   * *         25                             647 539 39 42               25                       647
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
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
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
1239870 1239870 MD     school 2400240 7   Cecil 240024000567 303 Elkton Middle   Regular School No Middle 06 08 2020   pk_12_total 234 157 93   * *     *   73                             571 234 157 93               73                       571
1239878 1239878 MD     school 2400240 7   Cecil 240024000569 310 Gilpin Manor Elementary   Regular School No Elementary PK 05 2020   pk_12_total 175 139 53     *         52                             425 175 139 53               52                       425
1239886 1239886 MD     school 2400240 7   Cecil 240024000570 311 Holly Hall Elementary   Regular School No Elementary PK 05 2020   pk_12_total 246 77 59   * *         43                             430 246 77 59               43                       430
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
1239898 1239898 MD     school 2400240 7   Cecil 240024000572 315 Leeds Elementary   Regular School No Elementary PK 05 2020   pk_12_total 351 * 26               39                             423 351   26               39                       423
1239906 1239906 MD     school 2400240 7   Cecil 240024000581 316 Thomson Estates Elementary   Regular School No Elementary PK 05 2020   pk_12_total 214 116 88   * 13     *   59                             493 214 116 88     13         59                       493
1239914 1239914 MD     school 2400240 7   Cecil 240024001491 317 Kenmore Elementary   Regular School No Elementary PK 05 2020   pk_12_total 240 13 33               19                             305 240 13 33               19                       305
1239922 1239922 MD     school 2400240 7   Cecil 240024000560 401 Cecil Manor Elementary   Regular School No Elementary PK 05 2020   pk_12_total 191 108 61     *         47                             408 191 108 61               47                       408
1239926 1239926 MD     school 2400240 7   Cecil 240024000574 504 North East Middle   Regular School No Middle 06 08 2020   pk_12_total 634 57 52   * *     *   33                             786 634 57 52               33                       786
1239934 1239934 MD     school 2400240 7   Cecil 240024000573 506 North East Elementary   Regular School No Elementary PK 05 2020   pk_12_total 399 54 39   * *     *   45                             542 399 54 39               45                       542
1239942 1239942 MD     school 2400240 7   Cecil 240024000557 510 Bay View Elementary   Regular School No Elementary PK 05 2020   pk_12_total 346 33 33     10     *   41                             464 346 33 33     10         41                       464
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
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
1239963 1239963 MD     school 2400240 7   Cecil 240024090468 515 Elk Neck Elementary   Regular School No Elementary PK 05 2020   pk_12_total 399 * 12     *         25                             443 399   12               25                       443
1239967 1239967 MD     school 2400240 7   Cecil 240024000580 606 Rising Sun Middle School   Regular School No Middle 06 08 2020   pk_12_total 640 * 34   * *         21                             702 640   34               21                       702
1239975 1239975 MD     school 2400240 7   Cecil 240024000579 607 Rising Sun Elementary   Regular School No Elementary PK 05 2020   pk_12_total 602 * 46     *         26                             681 602   46               26                       681
1239979 1239979 MD     school 2400240 7   Cecil 240024000578 701 Perryville Middle   Regular School No Middle 06 08 2020   pk_12_total 477 42 22   * *     *   44                             590 477 42 22               44                       590
1239987 1239987 MD     school 2400240 7   Cecil 240024000576 703 Perryville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 295 36 24     *         35                             393 295 36 24               35                       393
1239995 1239995 MD     school 2400240 7   Cecil 240024000556 704 Bainbridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 240 11 *   *       *   23                             284 240 11                 23                       284
1240000 1240000 MD     school 2400240 7   Cecil 240024000577 705 Perryville High   Regular School No High 09 12 2020   pk_12_total 661 39 41   * *     *   50                             801 661 39 41               50                       801
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
1240016 1240016 MD     school 2400240 7   Cecil 240024000559 904 Calvert Elementary   Regular School No Elementary PK 05 2020   pk_12_total 406   17   *           *                             432 406   17                                       432
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
1239578 1239578 MD     school 2400210 6   Carroll 240021000548 103 Taneytown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 326 18 31     *     *   22                             401 326 18 31               22                       401
1239582 1239582 MD     school 2400210 6   Carroll 240021000543 105 Northwest Middle   Regular School No Middle 06 08 2020   pk_12_total 583 16 32   * *         39                             682 583 16 32               39                       682
1239587 1239587 MD     school 2400210 6   Carroll 240021000533 202 Francis Scott Key High   Regular School No High 09 12 2020   pk_12_total 811 31 39   * *     *   28                             922 811 31 39               28                       922
1239595 1239595 MD     school 2400210 6   Carroll 240021000368 204 Runnymede Elementary   Regular School No Elementary PK 05 2020   pk_12_total 540 19 19   * *     *   27                             612 540 19 19               27                       612
1239603 1239603 MD     school 2400210 6   Carroll 240021000545 404 Sandymount Elementary   Regular School No Elementary PK 05 2020   pk_12_total 409 28 38     13     *   *                             497 409 28 38     13                                 497
1239611 1239611 MD     school 2400210 6   Carroll 240021000537 406 Mechanicsville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 412 17 14     10     *   27                             483 412 17 14     10         27                       483
1239619 1239619 MD     school 2400210 6   Carroll 240021000531 501 Eldersburg Elementary   Regular School No Elementary PK 05 2020   pk_12_total 335 28 28     35         23                             449 335 28 28     35         23                       449
1239627 1239627 MD     school 2400210 6   Carroll 240021000977 503 Linton Springs Elementary   Regular School No Elementary PK 05 2020   pk_12_total 538 17 32   * 24     *   22                             638 538 17 32     24         22                       638
1239631 1239631 MD     school 2400210 6   Carroll 240021000547 504 Sykesville Middle   Regular School No Middle 06 08 2020   pk_12_total 639 37 37   * 42     *   26                             784 639 37 37     42         26                       784
1239638 1239638 MD     school 2400210 6   Carroll 240021000534 505 Freedom District Elementary   Regular School No Elementary KG 05 2020   pk_12_total 485 17 28     22     *   23                             576 485 17 28     22         23                       576
1239646 1239646 MD     school 2400210 6   Carroll 240021000529 506 Carrolltowne Elementary   Regular School No Elementary PK 05 2020   pk_12_total 472 13 30   * 44     *   29                             591 472 13 30     44         29                       591
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
1239655 1239655 MD     school 2400210 6   Carroll 240021000835 508 Oklahoma Road Middle   Regular School No Middle 06 08 2020   pk_12_total 563 33 31   * 42     *   24                             695 563 33 31     42         24                       695
1239663 1239663 MD     school 2400210 6   Carroll 240021090466 509 Piney Ridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 389 31 24   * 38     *   51                             535 389 31 24     38         51                       535
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
1239676 1239676 MD     school 2400210 6   Carroll 240021000536 601 Manchester Elementary   Regular School No Elementary PK 05 2020   pk_12_total 595 * 39     10     *   10                             663 595   39     10         10                       663
1239681 1239681 MD     school 2400210 6   Carroll 240021001672 602 Manchester Valley High   Regular School No High 09 12 2020   pk_12_total 1169 32 70   * 30         22                             1325 1169 32 70     30         22                       1325
1239689 1239689 MD     school 2400210 6   Carroll 240021001652 603 Ebb Valley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 489 13 17   * 10     *   13                             548 489 13 17     10         13                       548
1239693 1239693 MD     school 2400210 6   Carroll 240021000550 701 Westminster East Middle   Regular School No Middle 06 08 2020   pk_12_total 554 56 77     18     *   41                             748 554 56 77     18         41                       748
1239697 1239697 MD     school 2400210 6   Carroll 240021000553 703 Westminster West Middle   Regular School No Middle 06 08 2020   pk_12_total 725 44 94   * 29     *   36                             935 725 44 94     29         36                       935
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
1239710 1239710 MD     school 2400210 6   Carroll 240021000554 705 William Winchester Elementary   Regular School No Elementary PK 05 2020   pk_12_total 347 34 102     10         30                             523 347 34 102     10         30                       523
1239715 1239715 MD     school 2400210 6   Carroll 240021000552 707 Westminster High   Regular School No High 09 12 2020   pk_12_total 1289 60 69     48     *   55                             1522 1289 60 69     48         55                       1522

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