enrollments

Data source: Big Local News · About: Big Local

2,791 rows where grade = "pk_12_total" and state = "MD" sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

  • pk_12_total · 2,691 ✖
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
1237897 1237897 MD     school 2400060 2   Anne Arundel 240006000108 3343 Old Mill Middle South   Regular School No Middle 06 08 2020   pk_12_total 477 225 174     38     *   72                             990 477 225 174     38         72                       990
1237952 1237952 MD     school 2400060 2   Anne Arundel 240006000823 3423 Meade Middle   Regular School No Middle 06 08 2020   pk_12_total 74 381 304   * 31         40                             832 74 381 304     31         40                       832
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
1237970 1237970 MD     school 2400060 2   Anne Arundel 240006000041 4043 Wiley H. Bates Middle   Regular School No Middle 06 08 2020   pk_12_total 258 153 202     19         27                             659 258 153 202     19         27                       659
1237974 1237974 MD     school 2400060 2   Anne Arundel 240006000131 4053 Southern Middle   Regular School No Middle 06 08 2020   pk_12_total 536 60 140   * *         61                             801 536 60 140               61                       801
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
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
1238229 1238229 MD     school 2400120 3   Baltimore County 240012000831 72 Rosedale Center   Alternative School No High 06 12 2020   pk_12_total 21 36 *               *                             65 21 36                                         65
1238332 1238332 MD     school 2400120 3   Baltimore County 240012000354 151 Catonsville Middle   Regular School No Middle 06 08 2020   pk_12_total 508 174 61   * 73     *   30                             850 508 174 61     73         30                       850
1238336 1238336 MD     school 2400120 3   Baltimore County 240012000411 155 Southwest Academy   Regular School No Middle 06 08 2020   pk_12_total 30 564 106   * 93         26                             823 30 564 106     93         26                       823
1238454 1238454 MD     school 2400120 3   Baltimore County 240012001431 252 Northwest Academy of Health Sciences   Regular School No Middle 06 08 2020   pk_12_total 22 687 42   * 17     *   15                             785 22 687 42     17         15                       785
1238458 1238458 MD     school 2400120 3   Baltimore County 240012000501 253 Woodlawn Middle   Regular School No Middle 06 08 2020   pk_12_total 12 550 39     *     *   13                             622 12 550 39               13                       622
1238462 1238462 MD     school 2400120 3   Baltimore County 240012000372 254 Deer Park Middle Magnet School   Regular School No Middle 06 08 2020   pk_12_total 37 1183 74   * 29     *   36                             1365 37 1183 74     29         36                       1365
1238466 1238466 MD     school 2400120 3   Baltimore County 240012001574 256 Windsor Mill Middle   Regular School No Middle 06 08 2020   pk_12_total * 617 32   * *         11                             674   617 32               11                       674
1238521 1238521 MD     school 2400120 3   Baltimore County 240012000448 352 Pikesville Middle   Regular School No Middle 06 08 2020   pk_12_total 162 642 86   * 39     *   34                             972 162 642 86     39         34                       972
1238525 1238525 MD     school 2400120 3   Baltimore County 240012000441 353 Sudbrook Magnet Middle   Regular School No Middle 06 08 2020   pk_12_total 115 608 178   * 64         29                             998 115 608 178     64         29                       998
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
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
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
1238719 1238719 MD     school 2400120 3   Baltimore County 240012001422 855 Hereford Middle   Regular School No Middle 06 08 2020   pk_12_total 839 21 38     40         34                             972 839 21 38     40         34                       972
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
1238840 1238840 MD     school 2400120 3   Baltimore County 240012000419 954 Loch Raven Technical Academy   Regular School No Middle 06 08 2020   pk_12_total 140 554 65   * 25     *   33                             823 140 554 65     25         33                       823
1238844 1238844 MD     school 2400120 3   Baltimore County 240012000451 957 Pine Grove Middle   Regular School No Middle 06 08 2020   pk_12_total 410 375 50   * 69     *   49                             960 410 375 50     69         49                       960
1238943 1238943 MD     school 2400120 3   Baltimore County 240012000447 1151 Perry Hall Middle   Regular School No Middle 06 08 2020   pk_12_total 954 491 93   * 295     *   82                             1925 954 491 93     295         82                       1925
1239028 1239028 MD     school 2400120 3   Baltimore County 240012000376 1251 Dundalk Middle   Regular School No Middle 06 08 2020   pk_12_total 245 217 248   10 17     *   53                             793 245 217 248   10 17         53                       793
1239038 1239038 MD     school 2400120 3   Baltimore County 240012001438 1255 General John Stricker Middle   Regular School No Middle 06 08 2020   pk_12_total 452 149 89   13 13         77                             793 452 149 89   13 13         77                       793
1239100 1239100 MD     school 2400120 3   Baltimore County 240012000417 1351 Lansdowne Middle   Regular School No Middle 06 08 2020   pk_12_total 201 246 292   16 62     *   48                             866 201 246 292   16 62         48                       866
1239104 1239104 MD     school 2400120 3   Baltimore County 240012000342 1356 Arbutus Middle   Regular School No Middle 06 08 2020   pk_12_total 489 214 40   * 136     *   67                             951 489 214 40     136         67                       951
1239153 1239153 MD     school 2400120 3   Baltimore County 240012001439 1451 Golden Ring Middle   Regular School No Middle 06 08 2020   pk_12_total 123 495 98   * 39     *   31                             793 123 495 98     39         31                       793
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
1239324 1239324 MD     school 2400120 3   Baltimore County 240012000478 1554 Stemmers Run Middle   Regular School No Middle 06 08 2020   pk_12_total 382 245 92   * 14         53                             795 382 245 92     14         53                       795
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
1239332 1239332 MD     school 2400120 3   Baltimore County 240012000370 1557 Deep Creek Middle   Regular School No Middle 06 08 2020   pk_12_total 202 539 97   * *         55                             901 202 539 97               55                       901
1239336 1239336 MD     school 2400120 3   Baltimore County 240012010500 1559 Sparrows Point Middle   Regular School No Middle 06 08 2020   pk_12_total 499 52 39   * *     *   33                             637 499 52 39               33                       637
1239376 1239376 MD     school 2400150 4   Calvert 240015001392 111 Southern Middle   Regular School No Middle 06 08 2020   pk_12_total 315 87 43     *         46                             495 315 87 43               46                       495
1239401 1239401 MD     school 2400150 4   Calvert 240015002946 116 Mill Creek Middle   Regular School No Middle 06 08 2020   pk_12_total 356 71 42   * *         42                             517 356 71 42               42                       517
1239405 1239405 MD     school 2400150 4   Calvert 240015000507 201 Calvert Middle   Regular School No Middle 06 08 2020   pk_12_total 359 138 48   * 10         43                             601 359 138 48     10         43                       601
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
1239487 1239487 MD     school 2400150 4   Calvert 240015000515 315 Northern Middle   Regular School No Middle 06 08 2020   pk_12_total 518 53 26     19     *   56                             674 518 53 26     19         56                       674
1239507 1239507 MD     school 2400150 4   Calvert 240015000967 318 Windy Hill Middle   Regular School No Middle 06 08 2020   pk_12_total 557 87 48   * 12     *   82                             789 557 87 48     12         82                       789
1239532 1239532 MD     school 2400180 5   Caroline 240018000526 302 Lockerman Middle School   Regular School No Middle 06 08 2020   pk_12_total 591 97 179     *         73                             949 591 97 179               73                       949
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
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
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
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
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
1239774 1239774 MD     school 2400210 6   Carroll 240021001694 726 Crossroads Middle School   Alternative School No Middle 06 08 2020   pk_12_total *   *               *                             *                                              
1239778 1239778 MD     school 2400210 6   Carroll 240021000542 801 North Carroll Middle   Regular School No Middle 06 08 2020   pk_12_total 554 12 34   * 14     *   11                             628 554 12 34     14         11                       628
1239798 1239798 MD     school 2400210 6   Carroll 240021002947 807 Shiloh Middle   Regular School No Middle 06 08 2020   pk_12_total 553 34 38     15     *   17                             658 553 34 38     15         17                       658
1239831 1239831 MD     school 2400210 6   Carroll 240021000539 1306 Mount Airy Middle   Regular School No Middle 06 08 2020   pk_12_total 594 15 64   * 20         18                             714 594 15 64     20         18                       714
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1240468 1240468 MD     school 2400330 10   Frederick 240033000640 311 Middletown Middle   Regular School No Middle 06 08 2020   pk_12_total 652 24 55   * 15     *   33                             784 652 24 55     15         33                       784
1240510 1240510 MD     school 2400330 10   Frederick 240033000392 714 Windsor Knolls Middle   Regular School No Middle 06 08 2020   pk_12_total 588 32 82     35     *   26                             764 588 32 82     35         26                       764
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
1240552 1240552 MD     school 2400330 10   Frederick 240033001379 914 New Market Middle   Regular School No Middle 06 08 2020   pk_12_total 484 * 33   * 11     *   24                             563 484   33     11         24                       563
1240579 1240579 MD     school 2400330 10   Frederick 240033001163 918 Oakdale Middle   Regular School No Middle 06 08 2020   pk_12_total 624 54 83   * 56     *   50                             872 624 54 83     56         50                       872
1240637 1240637 MD     school 2400330 10   Frederick 240033000651 1510 Thurmont Middle   Regular School No Middle 06 08 2020   pk_12_total 494 * 24   * *     *   15                             545 494   24               15                       545
1240692 1240692 MD     school 2400330 10   Frederick 240033090446 2305 Ballenger Creek Middle   Regular School No Middle 06 08 2020   pk_12_total 362 172 168   * 60     *   47                             817 362 172 168     60         47                       817
1240753 1240753 MD     school 2400330 10   Frederick 240033001409 2525 Brunswick Middle   Regular School No Middle 06 08 2020   pk_12_total 403 44 74   * 10     *   40                             573 403 44 74     10         40                       573
1240757 1240757 MD     school 2400330 10   Frederick 240033000656 2606 Walkersville Middle   Regular School No Middle 06 08 2020   pk_12_total 570 108 117     24     *   56                             876 570 108 117     24         56                       876
1240847 1240847 MD     school 2400360 11   Garrett 240036001351 2511 Northern Middle School   Regular School No Middle 06 08 2020   pk_12_total 340   *               *                             357 340                                           357
1240851 1240851 MD     school 2400360 11   Garrett 240036000675 2708 Southern Middle School   Regular School No Middle 06 08 2020   pk_12_total 487 * *     *         12                             507 487                   12                       507
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
1240957 1240957 MD     school 2400390 12   Harford 240039001352 184 Magnolia Middle   Regular School No Middle 06 08 2020   pk_12_total 224 419 102   * 16         67                             831 224 419 102     16         67                       831
1240966 1240966 MD     school 2400390 12   Harford 240039001642 188 Patterson Mill Middle School   Regular School No Middle 06 08 2020   pk_12_total 537 63 59   * 46     *   53                             764 537 63 59     46         53                       764
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
1241094 1241094 MD     school 2400390 12   Harford 240039001397 372 Bel Air Middle   Regular School No Middle 06 08 2020   pk_12_total 1062 107 89   * 101     *   69                             1435 1062 107 89     101         69                       1435
1241103 1241103 MD     school 2400390 12   Harford 240039000682 374 Southampton Middle   Regular School No Middle 06 08 2020   pk_12_total 1007 75 62   * 42         73                             1261 1007 75 62     42         73                       1261
1241117 1241117 MD     school 2400390 12   Harford 240039090475 386 Fallston Middle School   Regular School No Middle 06 08 2020   pk_12_total 808 29 30   * 25         38                             934 808 29 30     25         38                       934
1241185 1241185 MD     school 2400390 12   Harford 240039000709 583 North Harford Middle   Regular School No Middle 06 08 2020   pk_12_total 851 * 20   * 11     *   33                             929 851   20     11         33                       929
1241218 1241218 MD     school 2400390 12   Harford 240039000696 679 Havre de Grace Middle   Regular School No Middle 06 08 2020   pk_12_total 359 115 49   * *     *   67                             601 359 115 49               67                       601
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
1241246 1241246 MD     school 2400420 13   Howard 240042090477 104 Mayfield Woods Middle   Regular School No Middle 06 08 2020   pk_12_total 203 230 207   * 108     *   34                             787 203 230 207     108         34                       787
1241258 1241258 MD     school 2400420 13   Howard 240042000633 106 Elkridge Landing Middle   Regular School No Middle 06 08 2020   pk_12_total 334 197 62   * 121     *   46                             764 334 197 62     121         46                       764
1241270 1241270 MD     school 2400420 13   Howard 240042001172 108 Bonnie Branch Middle   Regular School No Middle 06 08 2020   pk_12_total 257 168 108   * 128         41                             703 257 168 108     128         41                       703
1241282 1241282 MD     school 2400420 13   Howard 240042001720 110 Thomas Viaduct   Regular School No Middle 06 08 2020   pk_12_total 105 342 130   * 112     *   42                             734 105 342 130     112         42                       734
1241294 1241294 MD     school 2400420 13   Howard 240042001444 202 Ellicott Mills Middle   Regular School No Middle 06 08 2020   pk_12_total 361 153 43   * 296     *   52                             909 361 153 43     296         52                       909
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

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