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 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
1241083 1241083 MD     school 2400390 12   Harford 240039000717 348 Youths Benefit Elementary   Regular School No Elementary KG 05 2020   pk_12_total 939 14 40   * 24     *   34                             1057 939 14 40     24         34                       1057
1240825 1240825 MD     school 2400360 11   Garrett 240036000852 1710 Yough Glades Elementary   Regular School No Elementary PK 05 2020   pk_12_total 295 * *               *                             308 295                                           308
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
1244026 1244026 MD     school 2400510 16   Prince George's 240051000200 1427 Yorktown Elementary   Regular School No Elementary KG 05 2020   pk_12_total 68 246 48     21     *   19                             403 68 246 48     21         19                       403
1240672 1240672 MD     school 2400330 10   Frederick 240033000661 2103 Yellow Springs Elementary   Regular School No Elementary KG 05 2020   pk_12_total 275 97 41   * 19     *   32                             470 275 97 41     19         32                       470
1242325 1242325 MD     school 2400480 15   Montgomery 240048000963 422 Wyngate Elementary   Regular School No Elementary PK 05 2020   pk_12_total 448 33 90     99     *   70                             741 448 33 90     99         70                       741
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
1237500 1237500 MD     school 2400060 2   Anne Arundel 240006000142 1262 Woodside Elementary   Regular School No Elementary PK 05 2020   pk_12_total 128 63 153   * 10     *   12                             368 128 63 153     10         12                       368
1244415 1244415 MD     school 2400510 16   Prince George's 240051001386 2007 Woodridge Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 39 274     *     *                                 324   39 274                                       324
1243475 1243475 MD     school 2400510 16   Prince George's 240051001188 706 Woodmore Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 406 33     20     *   *                             473   406 33     20                                 473
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
1242769 1242769 MD     school 2400480 15   Montgomery 240048000961 764 Woodlin Elementary   Regular School No Elementary PK 05 2020   pk_12_total 214 140 118     33     *   47                             553 214 140 118     33         47                       553
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
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
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
1238517 1238517 MD     school 2400120 3   Baltimore County 240012001405 311 Woodholme Elementary   Regular School No Elementary KG 05 2020   pk_12_total 46 470 145   * 24     *   25                             714 46 470 145     24         25                       714
1242703 1242703 MD     school 2400480 15   Montgomery 240048000959 704 Woodfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 182 31 87     31         24                             355 182 31 87     31         24                       355
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
1242303 1242303 MD     school 2400480 15   Montgomery 240048000958 417 Wood Acres Elementary   Regular School No Elementary PK 05 2020   pk_12_total 428 22 87     67         45                             649 428 22 87     67         45                       649
1240493 1240493 MD     school 2400330 10   Frederick 240033000659 603 Wolfsville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 130 * *   *           *                             149 130                                           149
1245544 1245544 MD     school 2400090 30   Baltimore City 240009000215 23 Wolfe Street Academy   Regular School Yes Elementary PK 05 2020   pk_12_total 12 28 215   * *                                       260 12 28 215                                       260
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
1242629 1242629 MD     school 2400480 15   Montgomery 240048000956 602 Winston Churchill High   Regular School No High 09 12 2020   pk_12_total 1063 212 178   * 687     *   128                             2274 1063 212 178     687         128                       2274
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
1239810 1239810 MD     school 2400210 6   Carroll 240021000555 906 Winfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 550 14 24   * *     *   11                             608 550 14 24               11                       608
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
1239503 1239503 MD     school 2400150 4   Calvert 240015000790 317 Windy Hill Elementary   Regular School No Elementary PK 05 2020   pk_12_total 488 50 52   * *         69                             668 488 50 52               69                       668
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
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
1245847 1245847 MD     school 2400090 30   Baltimore City 240009000337 87 Windsor Hills Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 241 *     *     *                                 259   241                                         259
1237698 1237698 MD     school 2400060 2   Anne Arundel 240006001516 2372 Windsor Farm Elementary   Regular School No Elementary KG 05 2020   pk_12_total 388 41 87   * *         37                             564 388 41 87               37                       564
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
1242213 1242213 MD     school 2400480 15   Montgomery 240048001721 341 Wilson Wims Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 178 131 104   * 316     *   35                             767 178 131 104     316         35                       767
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
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
1244376 1244376 MD     school 2400510 16   Prince George's 240051001186 1908 William Wirt Middle   Regular School No Middle 06 08 2020   pk_12_total 23 215 940   * 40     *   *                             1224 23 215 940     40                                 1224
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
1244346 1244346 MD     school 2400510 16   Prince George's 240051001462 1830 William W. Hall Academy   Regular School No Elementary PK 08 2020   pk_12_total 12 360 193   *                                         566 12 360 193                                       566
1242142 1242142 MD     school 2400480 15   Montgomery 240048000955 312 William Tyler Page Elementary   Regular School No Elementary PK 05 2020   pk_12_total 74 279 160   * 73         27                             615 74 279 160     73         27                       615
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
1246444 1246444 MD     school 2400090 30   Baltimore City 240009000336 301 William S. Baer School   Special Education School No Other PK 12 2020   pk_12_total 15 126 21     *                                       167 15 126 21                                       167
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
1243849 1243849 MD     school 2400510 16   Prince George's 240051000729 1309 William Paca Elementary   Regular School No Elementary PK 05 2020   pk_12_total 27 355 189   * 44     *   *                             619 27 355 189     44                                 619
1245812 1245812 MD     school 2400090 30   Baltimore City 240009000334 83 William Paca Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 267 227   * *     *   *                             509   267 227                                       509
1242392 1242392 MD     school 2400480 15   Montgomery 240048000957 507 William H. Farquhar Middle   Regular School No Middle 06 08 2020   pk_12_total 254 177 121   * 110         31                             694 254 177 121     110         31                       694
1243373 1243373 MD     school 2400510 16   Prince George's 240051001184 636 William Beanes Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 363 106     *     *   *                             481   363 106                                       481
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
1242198 1242198 MD     school 2400480 15   Montgomery 240048001673 337 William B. Gibbs, Jr. Elementary   Regular School No Elementary PK 05 2020   pk_12_total 109 184 129   * 157         40                             621 109 184 129     157         40                       621
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
1245341 1245341 MD     school 2400690 22   Wicomico 240069001322 1404 Willards Elementary   Regular School No Elementary PK 03 2020   pk_12_total 259 * 27   * *     *   27                             323 259   27               27                       323
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
1245858 1245858 MD     school 2400090 30   Baltimore City 240009000273 88 Wildwood Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 771 20           *   *                             800   771 20                                       800
1241463 1241463 MD     school 2400420 13   Howard 240042000763 512 Wilde Lake Middle   Regular School No Middle 06 08 2020   pk_12_total 164 317 91   * 51         62                             687 164 317 91     51         62                       687
1241484 1241484 MD     school 2400420 13   Howard 240042000762 516 Wilde Lake High   Regular School No High 09 12 2020   pk_12_total 337 630 175   * 110     *   94                             1351 337 630 175     110         94                       1351
1245249 1245249 MD     school 2400690 22   Wicomico 240069001319 510 Wicomico Middle   Regular School No Middle 06 08 2020   pk_12_total 198 419 156   * 16     *   77                             875 198 419 156     16         77                       875
1245258 1245258 MD     school 2400690 22   Wicomico 240069001320 513 Wicomico High   Regular School No High 09 12 2020   pk_12_total 323 535 112   * 31         74                             1079 323 535 112     31         74                       1079
1245273 1245273 MD     school 2400690 22   Wicomico 240069001088 520 Wicomico County Evening High   Alternative School No High 09 12 2020   pk_12_total 38 55 10     *         *                             107 38 55 10                                       107
1240680 1240680 MD     school 2400330 10   Frederick 240033001015 2107 Whittier Elementary   Regular School No Elementary PK 05 2020   pk_12_total 322 193 116   * 44     *   35                             718 322 193 116     44         35                       718
1244055 1244055 MD     school 2400510 16   Prince George's 240051001461 1438 Whitehall Elementary   Regular School No Elementary KG 05 2020   pk_12_total 183 346 71   * 39     *   11                             653 183 346 71     39         11                       653
1238825 1238825 MD     school 2400120 3   Baltimore County 240012001435 923 White Oak School   Special Education School No Elementary PK 05 2020   pk_12_total 39 36 *     *         *                             93 39 36                                         93
1243004 1243004 MD     school 2400480 15   Montgomery 240048000954 811 White Oak Middle   Regular School No Middle 06 08 2020   pk_12_total 38 264 455     68     *   18                             845 38 264 455     68         18                       845
1244730 1244730 MD     school 2400600 18   Saint Mary's 240060001240 503 White Marsh Elementary   Regular School No Elementary KG 05 2020   pk_12_total 195 19 *     *         18                             242 195 19                 18                       242
1244924 1244924 MD     school 2400630 20   Talbot 240063001252 302 White Marsh Elementary   Regular School No Elementary PK 05 2020   pk_12_total 217 56 44   * *         40                             367 217 56 44               40                       367
1242541 1242541 MD     school 2400480 15   Montgomery 240048000953 558 Whetstone Elementary   Regular School No Elementary PK 05 2020   pk_12_total 48 191 416   * 62         22                             742 48 191 416     62         22                       742
1242904 1242904 MD     school 2400480 15   Montgomery 240048000952 788 Wheaton Woods Elementary   Regular School No Elementary PK 05 2020   pk_12_total 18 123 320   * 32         *                             503 18 123 320     32                                 503
1242868 1242868 MD     school 2400480 15   Montgomery 240048000951 782 Wheaton High   Regular School No High 09 12 2020   pk_12_total 202 433 1248     244     *   51                             2179 202 433 1248     244         51                       2179
1245345 1245345 MD     school 2400690 22   Wicomico 240069001318 1501 Westside Primary   Regular School No Elementary PK 01 2020   pk_12_total 148 31 19   * *         25                             229 148 31 19               25                       229
1245350 1245350 MD     school 2400690 22   Wicomico 240069001149 1502 Westside Intermediate   Regular School No Elementary 02 05 2020   pk_12_total 267 64 23   *           33                             390 267 64 23               33                       390
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
1238265 1238265 MD     school 2400120 3   Baltimore County 240012000495 103 Westowne Elementary   Regular School No Elementary PK 05 2020   pk_12_total 250 256 45   * 93     *   45                             698 250 256 45     93         45                       698
1242374 1242374 MD     school 2400480 15   Montgomery 240048000950 504 Westover Elementary   Regular School No Elementary PK 05 2020   pk_12_total 59 117 71   * 45     *   22                             316 59 117 71     45         22                       316
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
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
1239723 1239723 MD     school 2400210 6   Carroll 240021000551 710 Westminster Elementary   Regular School No Elementary PK 05 2020   pk_12_total 382 24 65     29     *   36                             538 382 24 65     29         36                       538
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
1237295 1237295 MD     school 2400030 1   Allegany 240003000007 802 Westmar Middle   Regular School No Middle 06 08 2020   pk_12_total 258   *     *         *                             268 258                                           268
1242287 1242287 MD     school 2400480 15   Montgomery 240048000949 412 Westland Middle   Regular School No Middle 06 08 2020   pk_12_total 477 66 147   * 60     *   56                             808 477 66 147     60         56                       808
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
1237291 1237291 MD     school 2400030 1   Allegany 240003000033 801 Westernport Elementary   Regular School No Elementary PK 05 2020   pk_12_total 242 * *           *   11                             260 242                   11                       260
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
1246721 1246721 MD     school 2400090 30   Baltimore City 240009000330 407 Western High   Regular School No High 09 12 2020   pk_12_total 57 1016 48   * 10     *   *                             1142 57 1016 48     10                                 1142
1245177 1245177 MD     school 2400660 21   Washington 240066001293 2501 Western Heights Middle   Regular School No Middle 06 08 2020   pk_12_total 481 235 160     19         106                             1001 481 235 160     19         106                       1001
1238257 1238257 MD     school 2400120 3   Baltimore County 240012000936 102 Westchester Elementary   Regular School No Elementary PK 05 2020   pk_12_total 457 68 59   * 102         30                             719 457 68 59     102         30                       719
1242276 1242276 MD     school 2400480 15   Montgomery 240048000948 408 Westbrook Elementary   Regular School No Elementary KG 05 2020   pk_12_total 238 * 51   * 18         24                             341 238   51     18         24                       341
1238832 1238832 MD     school 2400120 3   Baltimore County 240012001696 925 West Towson Elementary   Regular School No Elementary KG 05 2020   pk_12_total 329 41 21   * 45         49                             486 329 41 21     45         49                       486
1237262 1237262 MD     school 2400030 1   Allegany 240003000032 603 West Side Elementary   Regular School No Elementary PK 05 2020   pk_12_total 288 17 *   * *         52                             367 288 17                 52                       367
1245294 1245294 MD     school 2400690 22   Wicomico 240069001317 909 West Salisbury   Regular School No Elementary PK 02 2020   pk_12_total 52 189 65   * 15         25                             350 52 189 65     15         25                       350
1237858 1237858 MD     school 2400060 2   Anne Arundel 240006000140 3232 West Meade Early Education Center   Regular School No Elementary PK KG 2020   pk_12_total 123 33 64   * 14         21                             256 123 33 64     14         21                       256
1241388 1241388 MD     school 2400420 13   Howard 240042000760 302 West Friendship Elementary   Regular School No Elementary KG 05 2020   pk_12_total 251 21 16     79     *   25                             393 251 21 16     79         25                       393
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
1238123 1238123 MD     school 2400060 2   Anne Arundel 240006000139 4272 West Annapolis Elementary   Regular School No Elementary KG 05 2020   pk_12_total 162 24 40   * *         20                             251 162 24 40               20                       251
1238489 1238489 MD     school 2400120 3   Baltimore County 240012000492 304 Wellwood International Elementary   Regular School No Elementary KG 05 2020   pk_12_total 74 309 30   * 54         18                             489 74 309 30     54         18                       489
1242846 1242846 MD     school 2400480 15   Montgomery 240048000946 777 Weller Road Elementary   Regular School No Elementary PK 05 2020   pk_12_total 25 49 619   * 39         14                             747 25 49 619     39         14                       747
1242011 1242011 MD     school 2400480 15   Montgomery 240048000945 235 Wayside Elementary   Regular School No Elementary PK 05 2020   pk_12_total 169 36 31     231         33                             500 169 36 31     231         33                       500
1245658 1245658 MD     school 2400090 30   Baltimore City 240009000329 51 Waverly Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 12 588 24     *         *                             635 12 588 24                                       635
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
1240721 1240721 MD     school 2400330 10   Frederick 240033000657 2403 Waverley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 43 66 394   * 31         10                             548 43 66 394     31         10                       548
1237855 1237855 MD     school 2400060 2   Anne Arundel 240006000138 3222 Waugh Chapel Elementary   Regular School No Elementary PK 05 2020   pk_12_total 326 128 80   * 48     *   49                             633 326 128 80     48         49                       633
1242472 1242472 MD     school 2400480 15   Montgomery 240048001525 545 Watkins Mill High   Regular School No High 09 12 2020   pk_12_total 107 424 870     137     *   51                             1590 107 424 870     137         51                       1590
1242557 1242557 MD     school 2400480 15   Montgomery 240048000944 561 Watkins Mill Elementary   Regular School No Elementary PK 05 2020   pk_12_total 23 181 443   * 52         28                             731 23 181 443     52         28                       731

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