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,298 ✖

grade ✖

  • pk_12_total · 1,298 ✖
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
1244590 1244590 MD     school 2400540 17   Queen Anne's 240054001197 106 Sudlersville Elementary School   Regular School No Elementary PK 04 2020   pk_12_total 172 14 109               17                             312 172 14 109               17                       312
1244900 1244900 MD     school 2400630 20   Talbot 240063001243 106 Easton Middle   Regular School No Middle 06 08 2020   pk_12_total 444 149 209     24     *   42                             869 444 149 209     24         42                       869
1245239 1245239 MD     school 2400690 22   Wicomico 240069001308 106 Northwestern Elementary   Regular School No Elementary PK 05 2020   pk_12_total 256 26 10   * *         35                             334 256 26 10               35                       334
1241266 1241266 MD     school 2400420 13   Howard 240042000813 107 Ilchester Elementary   Regular School No Elementary PK 05 2020   pk_12_total 350 52 24   * 167     *   38                             634 350 52 24     167         38                       634
1241786 1241786 MD     school 2400480 15   Montgomery 240048001417 107 Martin Luther King Jr. Middle   Regular School No Middle 06 08 2020   pk_12_total 97 257 267   * 96         46                             764 97 257 267     96         46                       764
1243107 1243107 MD     school 2400510 16   Prince George's 240051001134 107 Frances Fuchs Early Childhood Center   Special Education School No Prekindergarten PK PK 2020   pk_12_total 18 120 167   * 14         *                             324 18 120 167     14                                 324
1244846 1244846 MD     school 2400570 19   Somerset 240057001743 107 Greenwood Elementary School   Regular School No Elementary 02 05 2020   pk_12_total 80 318 36   * *         26                             468 80 318 36               26                       468
1245370 1245370 MD     school 2400720 23   Worcester 240072001330 107 Pocomoke High   Regular School No High 09 12 2020   pk_12_total 161 144 18     *         24                             353 161 144 18               24                       353
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
1240357 1240357 MD     school 2400330 10   Frederick 240033000628 108 Carroll Manor Elementary   Regular School No Elementary PK 05 2020   pk_12_total 411 55 70   * 16     *   21                             577 411 55 70     16         21                       577
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
1241794 1241794 MD     school 2400480 15   Montgomery 240048001448 108 Lake Seneca Elementary   Regular School No Elementary PK 05 2020   pk_12_total 59 177 219     25     *   28                             510 59 177 219     25         28                       510
1243121 1243121 MD     school 2400510 16   Prince George's 240051001354 108 James E. Duckworth Regional Center   Special Education School No Other KG 12 2020   pk_12_total * 33 52     *         *                             93   33 52                                       93
1244850 1244850 MD     school 2400570 19   Somerset 240057001742 108 Princess Anne Elementary School   Regular School No Elementary PK 01 2020   pk_12_total 65 234 38   * *         21                             363 65 234 38               21                       363
1245376 1245376 MD     school 2400720 23   Worcester 240072001329 108 Pocomoke Middle   Regular School No Middle 04 08 2020   pk_12_total 166 186 22     *         21                             402 166 186 22               21                       402
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
1240365 1240365 MD     school 2400330 10   Frederick 240033001355 109 Tuscarora Elementary   Regular School No Elementary PK 05 2020   pk_12_total 211 177 206   * 54     *   60                             713 211 177 206     54         60                       713
1241278 1241278 MD     school 2400420 13   Howard 240042001717 109 Ducketts Lane   Regular School No Elementary PK 05 2020   pk_12_total 116 227 138   * 61     *   26                             570 116 227 138     61         26                       570
1241802 1241802 MD     school 2400480 15   Montgomery 240048001508 109 Waters Landing Elementary   Regular School No Elementary PK 05 2020   pk_12_total 90 265 248   * 29         25                             659 90 265 248     29         25                       659
1243130 1243130 MD     school 2400510 16   Prince George's 240051001069 109 James H. Harrison Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 136 138     26         *                             314   136 138     26                                 314
1239372 1239372 MD     school 2400150 4   Calvert 240015000514 110 Mutual Elementary   Regular School No Elementary PK 05 2020   pk_12_total 318 42 18               43                             421 318 42 18               43                       421
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
1241810 1241810 MD     school 2400480 15   Montgomery 240048010502 110 S. Christa McAuliffe Elementary   Regular School No Elementary PK 05 2020   pk_12_total 79 209 186   * 38     *   37                             554 79 209 186     38         37                       554
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
1238296 1238296 MD     school 2400120 3   Baltimore County 240012000466 111 Maiden Choice School   Special Education School No Other PK 12 2020   pk_12_total 33 72 *     20         *                             137 33 72       20                                 137
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
1241290 1241290 MD     school 2400420 13   Howard 240042001749 111 Hanover Hills   Regular School No Elementary PK 05 2020   pk_12_total 111 299 121   * 178         41                             757 111 299 121     178         41                       757
1241818 1241818 MD     school 2400480 15   Montgomery 240048001523 111 Captain James E. Daly Elementary   Regular School No Elementary PK 05 2020   pk_12_total 31 207 324     41         15                             618 31 207 324     41         15                       618
1243142 1243142 MD     school 2400510 16   Prince George's 240051001660 111 Vansville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 34 407 215   * 95     *   21                             775 34 407 215     95         21                       775
1238304 1238304 MD     school 2400120 3   Baltimore County 240012002945 112 Dogwood Elementary   Regular School No Elementary PK 05 2020   pk_12_total 20 555 30   17 40     *   19                             682 20 555 30   17 40         19                       682
1238312 1238312 MD     school 2400120 3   Baltimore County 240012000357 113 Chadwick Elementary   Regular School No Elementary PK 05 2020   pk_12_total 32 279 78   * 234     *   *                             637 32 279 78     234                                 637
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
1240868 1240868 MD     school 2400390 12   Harford 240039000715 113 William S. James Elementary   Regular School No Elementary KG 05 2020   pk_12_total 338 55 30   * 12         35                             472 338 55 30     12         35                       472
1239389 1239389 MD     school 2400150 4   Calvert 240015000778 114 St Leonard Elementary   Regular School No Elementary PK 05 2020   pk_12_total 315 81 64     *         52                             521 315 81 64               52                       521
1238320 1238320 MD     school 2400120 3   Baltimore County 240012000406 115 Hillcrest Elementary   Regular School No Elementary PK 05 2020   pk_12_total 409 75 81   * 98     *   32                             698 409 75 81     98         32                       698
1239397 1239397 MD     school 2400150 4   Calvert 240015001102 115 Dowell Elementary   Regular School No Elementary PK 05 2020   pk_12_total 414 55 44   * 14         74                             604 414 55 44     14         74                       604
1240876 1240876 MD     school 2400390 12   Harford 240039000688 115 Edgewood Elementary   Regular School No Elementary PK 05 2020   pk_12_total 103 228 54   * *     *   16                             405 103 228 54               16                       405
1241822 1241822 MD     school 2400480 15   Montgomery 240048000759 115 Neelsville Middle   Regular School No Middle 06 08 2020   pk_12_total 48 287 499   * 81     *   24                             945 48 287 499     81         24                       945
1238328 1238328 MD     school 2400120 3   Baltimore County 240012000499 116 Woodbridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 39 142 68   * 183     *   14                             448 39 142 68     183         14                       448
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
1240884 1240884 MD     school 2400390 12   Harford 240039000686 120 Deerfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 194 370 83   * 17     *   84                             752 194 370 83     17         84                       752
1240891 1240891 MD     school 2400390 12   Harford 240039000485 121 Emmorton Elementary   Regular School No Elementary KG 05 2020   pk_12_total 383 59 38     71         41                             592 383 59 38     71         41                       592
1245896 1245896 MD     school 2400090 30   Baltimore City 240009000309 122 The Historic Samuel Coleridge-Taylor Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 244 *                                             247   244                                         247
1240899 1240899 MD     school 2400390 12   Harford 240039000162 123 Abingdon Elementary   Regular School No Elementary PK 05 2020   pk_12_total 416 161 55   * 24     *   66                             724 416 161 55     24         66                       724
1245907 1245907 MD     school 2400090 30   Baltimore City 240009000154 124 Bay-Brook Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 17 265 143               *                             427 17 265 143                                       427
1240907 1240907 MD     school 2400390 12   Harford 240039000468 125 Church Creek Elementary   Regular School No Elementary PK 05 2020   pk_12_total 273 263 58     24     *   77                             697 273 263 58     24         77                       697
1241827 1241827 MD     school 2400480 15   Montgomery 240048001509 125 Quince Orchard High   Regular School No High 09 12 2020   pk_12_total 818 351 607   * 278     *   91                             2148 818 351 607     278         91                       2148
1245915 1245915 MD     school 2400090 30   Baltimore City 240009000211 125 Furman Templeton Preparatory Academy   Regular School Yes Elementary PK 05 2020   pk_12_total * 454 *   *       *                                 461   454                                         461
1245919 1245919 MD     school 2400090 30   Baltimore City 240009000160 130 Booker T. Washington Middle   Regular School No Middle 06 08 2020   pk_12_total * 234 *                                             242   234                                         242
1240915 1240915 MD     school 2400390 12   Harford 240039000706 131 Magnolia Elementary   Regular School No Elementary PK 05 2020   pk_12_total 54 356 61   * *         72                             550 54 356 61               72                       550
1245930 1245930 MD     school 2400090 30   Baltimore City 240009000328 134 Walter P. Carter Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 376 11   *           *                             395   376 11                                       395
1240923 1240923 MD     school 2400390 12   Harford 240039000704 137 Joppatowne Elementary   Regular School No Elementary PK 05 2020   pk_12_total 353 152 52   * 11     *   46                             617 353 152 52     11         46                       617
1240931 1240931 MD     school 2400390 12   Harford 240039000716 140 William Paca/Old Post Road Elementary   Regular School No Elementary PK 05 2020   pk_12_total 210 386 158   10 13         88                             865 210 386 158   10 13         88                       865
1245938 1245938 MD     school 2400090 30   Baltimore City 240009000303 142 Robert W. Coleman Elementary   Regular School No Elementary PK 05 2020   pk_12_total   297 *               *                             304   297                                         304
1240939 1240939 MD     school 2400390 12   Harford 240039000713 143 Riverside Elementary   Regular School No Elementary PK 05 2020   pk_12_total 182 169 54   * 11     *   41                             462 182 169 54     11         41                       462
1245946 1245946 MD     school 2400090 30   Baltimore City 240009000255 144 James Mosher Elementary   Regular School No Elementary PK 05 2020   pk_12_total   201 *           *   *                             211   201                                         211
1245954 1245954 MD     school 2400090 30   Baltimore City 240009000145 145 Alexander Hamilton Elementary   Regular School No Elementary PK 05 2020   pk_12_total   157 *               *                             160   157                                         160
1245962 1245962 MD     school 2400090 30   Baltimore City 240009000158 150 Mary Ann Winterling Elementary at Bentalou   Regular School No Elementary PK 05 2020   pk_12_total * 221 *               *                             226   221                                         226
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
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
1241840 1241840 MD     school 2400480 15   Montgomery 240048000896 153 Poolesville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 316 26 65     36     *   45                             489 316 26 65     36         45                       489
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
1241844 1241844 MD     school 2400480 15   Montgomery 240048000181 155 Rosa M. Parks Middle   Regular School No Middle 06 08 2020   pk_12_total 484 121 116     91         56                             868 484 121 116     91         56                       868
1241852 1241852 MD     school 2400480 15   Montgomery 240048000185 156 Lois P. Rockwell Elementary   Regular School No Elementary PK 05 2020   pk_12_total 200 55 112   * 46     *   36                             452 200 55 112     46         36                       452
1241856 1241856 MD     school 2400480 15   Montgomery 240048000493 157 Roberto W. Clemente Middle   Regular School No Middle 06 08 2020   pk_12_total 156 383 397   * 270         79                             1287 156 383 397     270         79                       1287
1241864 1241864 MD     school 2400480 15   Montgomery 240048090455 158 Ronald McNair Elementary   Regular School No Elementary PK 05 2020   pk_12_total 165 223 150   * 233     *   54                             828 165 223 150     233         54                       828
1241872 1241872 MD     school 2400480 15   Montgomery 240048090454 159 Rachel Carson Elementary   Regular School No Elementary PK 05 2020   pk_12_total 414 60 196     158         65                             893 414 60 196     158         65                       893
1245969 1245969 MD     school 2400090 30   Baltimore City 240009000171 159 The Historic Cherry Hill Elementary/Middle   Regular School No Middle 03 08 2020   pk_12_total * 641 29   *           *                             680   641 29                                       680
1245974 1245974 MD     school 2400090 30   Baltimore City 240009000148 164 Arundel Elementary   Regular School No Elementary PK 02 2020   pk_12_total * 502 12               *                             523   502 12                                       523
1238341 1238341 MD     school 2400120 3   Baltimore County 240012000502 172 Woodlawn High Center for Pre-Eng. Res.   Regular School No High 09 12 2020   pk_12_total 41 1277 229   * 82     *   21                             1656 41 1277 229     82         21                       1656
1238346 1238346 MD     school 2400120 3   Baltimore County 240012000355 174 Catonsville High   Regular School No High 09 12 2020   pk_12_total 929 462 110   * 223     *   95                             1826 929 462 110     223         95                       1826
1238351 1238351 MD     school 2400120 3   Baltimore County 240012000248 175 Western School of Technology & Env. Science   Career and Technical School No High 09 12 2020   pk_12_total 120 515 47   * 183     *   25                             892 120 515 47     183         25                       892
1240944 1240944 MD     school 2400390 12   Harford 240039000690 176 Edgewood High   Regular School No High 09 12 2020   pk_12_total 466 675 168   * 47     *   95                             1458 466 675 168     47         95                       1458
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
1245979 1245979 MD     school 2400090 30   Baltimore City 240009000219 177 George W. F. McMechen High   Special Education School No High 09 12 2020   pk_12_total * 44 *               *                             50   44                                         50
1245985 1245985 MD     school 2400090 30   Baltimore City 240009001343 178 Excel Academy at Francis M. Wood High   Alternative School No High 08 12 2020   pk_12_total * 620 10   *           *                             642   620 10                                       642
1240953 1240953 MD     school 2400390 12   Harford 240039000705 181 Joppatowne High   Regular School No High 09 12 2020   pk_12_total 197 383 88   * *     *   60                             745 197 383 88               60                       745
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
1240962 1240962 MD     school 2400390 12   Harford 240039001638 187 Patterson Mill High School   Regular School No High 09 12 2020   pk_12_total 600 73 59     54     *   37                             825 600 73 59     54         37                       825
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
1244961 1244961 MD     school 2400660 21   Washington 240066001740 190 Jonathan Hager Elementary   Regular School No Elementary PK 05 2020   pk_12_total 150 108 56   * *     *   55                             385 150 108 56               55                       385
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
1239520 1239520 MD     school 2400180 5   Caroline 240018000522 201 Greensboro Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 386 31 356     *         50                             825 386 31 356               50                       825
1240372 1240372 MD     school 2400330 10   Frederick 240033000646 201 Parkway Elementary   Regular School No Elementary KG 05 2020   pk_12_total 144 32 41   * *         15                             242 144 32 41               15                       242
1241877 1241877 MD     school 2400480 15   Montgomery 240048000902 201 Richard Montgomery High   Regular School No High 09 12 2020   pk_12_total 729 430 591   * 615     *   135                             2505 729 430 591     615         135                       2505
1244673 1244673 MD     school 2400600 18   Saint Mary's 240060001235 201 Piney Point Elementary   Regular School No Elementary PK 05 2020   pk_12_total 341 43 21     *         49                             455 341 43 21               49                       455
1244965 1244965 MD     school 2400660 21   Washington 240066001290 201 Springfield Middle   Regular School No Middle 06 08 2020   pk_12_total 623 77 104   * 13         48                             866 623 77 104     13         48                       866
1245996 1245996 MD     school 2400090 30   Baltimore City 240009000186 201 Dickey Hill Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total   353 *     *         *                             363   353                                         363
1238358 1238358 MD     school 2400120 3   Baltimore County 240012000457 202 Randallstown Elementary   Regular School No Elementary KG 05 2020   pk_12_total * 345 29     *     *   11                             400   345 29               11                       400
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
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
1244597 1244597 MD     school 2400540 17   Queen Anne's 240054001192 202 Church Hill Elementary School   Regular School No Elementary PK 04 2020   pk_12_total 196 18 26     *         22                             263 196 18 26               22                       263
1244908 1244908 MD     school 2400630 20   Talbot 240063001248 202 St. Michaels Middle/High School   Regular School No High 06 12 2020   pk_12_total 333 41 31     *         22                             430 333 41 31               22                       430
1244973 1244973 MD     school 2400660 21   Washington 240066001294 202 Williamsport Elementary   Regular School No Elementary PK 05 2020   pk_12_total 438 38 36   * *     *   49                             572 438 38 36               49                       572
1241299 1241299 MD     school 2400420 13   Howard 240042000738 203 Howard High   Regular School No High 09 12 2020   pk_12_total 898 423 133   * 323     *   126                             1910 898 423 133     323         126                       1910
1243153 1243153 MD     school 2400510 16   Prince George's 240051000414 203 Judith P. Hoyer Montessori   Regular School No Elementary PK 08 2020   pk_12_total 33 312 14   * 10     *   *                             375 33 312 14     10                                 375
1246007 1246007 MD     school 2400090 30   Baltimore City 240009001363 203 Maree Garnett Farring Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 162 214 363   * 10     *   11                             763 162 214 363     10         11                       763
1238366 1238366 MD     school 2400120 3   Baltimore County 240012000385 204 Featherbed Lane Elementary   Regular School No Elementary PK 05 2020   pk_12_total 12 452 78   * *     *   19                             572 12 452 78               19                       572
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
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

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