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,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
1238450 1238450 MD     school 2400120 3   Baltimore County 240012001753 219 Watershed Public Charter   Regular School Yes Elementary KG 03 2020   pk_12_total 50 84 *   * *         21                             170 50 84                 21                       170
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
1241583 1241583 MD     school 2400420 13   Howard 240042000758 604 Waterloo Elementary   Regular School No Elementary PK 05 2020   pk_12_total 213 184 35   * 124     *   42                             602 213 184 35     124         42                       602
1237239 1237239 MD     school 2400030 1   Allegany 240003000031 406 Washington Middle   Regular School No Middle 06 08 2020   pk_12_total 522 35 *     *     *   46                             612 522 35                 46                       612
1242501 1242501 MD     school 2400480 15   Montgomery 240048000943 552 Washington Grove Elementary   Regular School No Elementary PK 05 2020   pk_12_total 37 95 292     24     *   13                             462 37 95 292     24         13                       462
1244998 1244998 MD     school 2400660 21   Washington 240066000308 305 Washington County Technical High   Career and Technical School No High 11 12 2020   pk_12_total 435 53 74   * 16     *   33                             613 435 53 74     16         33                       613
1245080 1245080 MD     school 2400660 21   Washington 240066001484 705 Washington County Job Development Center   Special Education School No High 12 12 2020   pk_12_total 23 * *               *                             33 23                                           33
1244841 1244841 MD     school 2400570 19   Somerset 240057001213 102 Washington Academy and High School   Regular School No High 08 12 2020   pk_12_total 195 301 37     *     *   36                             574 195 301 37               36                       574
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
1238699 1238699 MD     school 2400120 3   Baltimore County 240012000491 813 Warren Elementary   Regular School No Elementary PK 05 2020   pk_12_total 126 162 83   * 12         18                             405 126 162 83     12         18                       405
1238085 1238085 MD     school 2400060 2   Anne Arundel 240006000112 4222 Walter S. Mills - Parole Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 233 355   * *         12                             615   233 355               12                       615
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
1242330 1242330 MD     school 2400480 15   Montgomery 240048000942 424 Walter Johnson High   Regular School No High 09 12 2020   pk_12_total 1431 291 471   * 380         165                             2747 1431 291 471     380         165                       2747
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
1242342 1242342 MD     school 2400480 15   Montgomery 240048000941 427 Walt Whitman High   Regular School No High 09 12 2020   pk_12_total 1366 80 179   * 284     *   126                             2039 1366 80 179     284         126                       2039
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
1240770 1240770 MD     school 2400330 10   Frederick 240033000655 2610 Walkersville High   Regular School No High 09 12 2020   pk_12_total 747 161 145   * 39     *   86                             1185 747 161 145     39         86                       1185
1240765 1240765 MD     school 2400330 10   Frederick 240033000654 2607 Walkersville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 330 143 107   * 24     *   70                             678 330 143 107     24         70                       678
1244324 1244324 MD     school 2400510 16   Prince George's 240051001477 1819 Walker Mill Middle   Regular School No Middle 06 08 2020   pk_12_total 12 601 73   * *     *   *                             705 12 601 73                                       705
1243585 1243585 MD     school 2400510 16   Prince George's 240051001180 914 Waldon Woods Elementary   Regular School No Elementary PK 05 2020   pk_12_total 15 457 92     *     *   *                             577 15 457 92                                       577
1246777 1246777 MD     school 2400090 30   Baltimore City 240009001385 429 Vivien T. Thomas Medical Arts Academy   Career and Technical School No High 09 12 2020   pk_12_total 11 357 16   *           *                             387 11 357 16                                       387
1246175 1246175 MD     school 2400090 30   Baltimore City 240009000326 226 Violetville Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 103 187 62   * 13     *   18                             386 103 187 62     13         18                       386
1239312 1239312 MD     school 2400120 3   Baltimore County 240012001653 1533 Vincent Farm Elementary   Regular School No Elementary PK 05 2020   pk_12_total 287 314 50   * 69     *   39                             761 287 314 50     69         39                       761
1238746 1238746 MD     school 2400120 3   Baltimore County 240012000490 908 Villa Cresta Elementary   Regular School No Elementary PK 05 2020   pk_12_total 396 159 80   * 23     *   43                             709 396 159 80     23         43                       709
1242813 1242813 MD     school 2400480 15   Montgomery 240048000940 772 Viers Mill Elementary   Regular School No Elementary PK 05 2020   pk_12_total 60 54 399   * 51         14                             579 60 54 399     51         14                       579
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
1239185 1239185 MD     school 2400120 3   Baltimore County 240012000489 1505 Victory Villa Elementary   Regular School No Elementary PK 05 2020   pk_12_total 147 343 131   * 11     *   55                             691 147 343 131     11         55                       691
1241381 1241381 MD     school 2400420 13   Howard 240042001646 219 Veterans Elementary   Regular School No Elementary PK 05 2020   pk_12_total 217 130 75   * 499     *   33                             962 217 130 75     499         33                       962
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
1246659 1246659 MD     school 2400090 30   Baltimore City 240009001693 374 Vanguard Collegiate Middle   Regular School No Middle 06 08 2020   pk_12_total * 331 19     *     11   *                             378   331 19           11                           378
1237803 1237803 MD     school 2400060 2   Anne Arundel 240006000137 3152 Van Bokkelen Elementary   Regular School No Elementary PK 05 2020   pk_12_total 17 304 118   * *     *   20                             465 17 304 118               20                       465
1243770 1243770 MD     school 2400510 16   Prince George's 240051001179 1218 Valley View Elementary   Regular School No Elementary PK 05 2020   pk_12_total 13 210 174     16         *                             416 13 210 174     16                                 416
1240624 1240624 MD     school 2400330 10   Frederick 240033000653 1406 Valley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 395 14 65   * *     *   23                             508 395 14 65               23                       508
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
1240506 1240506 MD     school 2400330 10   Frederick 240033000616 713 Urbana High   Regular School No High 09 12 2020   pk_12_total 1082 164 221   * 276     *   99                             1851 1082 164 221     276         99                       1851
1240501 1240501 MD     school 2400330 10   Frederick 240033000652 702 Urbana Elementary   Regular School No Elementary PK 05 2020   pk_12_total 450 67 74   * 164         54                             813 450 67 74     164         54                       813
1244363 1244363 MD     school 2400510 16   Prince George's 240051001178 1902 University Park Elementary   Regular School No Elementary PK 06 2020   pk_12_total 140 131 202   * 43     *   *                             522 140 131 202     43                                 522
1238116 1238116 MD     school 2400060 2   Anne Arundel 240006000136 4262 Tyler Heights Elementary   Regular School No Elementary PK 05 2020   pk_12_total   14 466     *         *                             488   14 466                                       488
1241893 1241893 MD     school 2400480 15   Montgomery 240048000939 206 Twinbrook Elementary   Regular School No Elementary PK 05 2020   pk_12_total 63 54 362   * 59         18                             558 63 54 362     59         18                       558
1240657 1240657 MD     school 2400330 10   Frederick 240033000159 1801 Twin Ridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 396 * 46   * *         17                             473 396   46               17                       473
1240705 1240705 MD     school 2400330 10   Frederick 240033001550 2307 Tuscarora High   Regular School No High 09 12 2020   pk_12_total 701 340 338   * 112     *   92                             1590 701 340 338     112         92                       1590
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
1246655 1246655 MD     school 2400090 30   Baltimore City 240009001689 373 Tunbridge Public Charter School   Regular School Yes Elementary PK 08 2020   pk_12_total 65 378 10   * *     *   11                             471 65 378 10               11                       471
1243489 1243489 MD     school 2400510 16   Prince George's 240051001177 711 Tulip Grove Elementary   Regular School No Elementary KG 05 2020   pk_12_total 114 182 41     *         *                             349 114 182 41                                       349
1241406 1241406 MD     school 2400420 13   Howard 240042001026 306 Triadelphia Ridge Elementary   Regular School No Elementary KG 05 2020   pk_12_total 257 42 36   * 170     *   45                             555 257 42 36     170         45                       555
1241941 1241941 MD     school 2400480 15   Montgomery 240048000937 216 Travilah Elementary   Regular School No Elementary KG 05 2020   pk_12_total 109 22 35     159     *   14                             341 109 22 35     159         14                       341
1238108 1238108 MD     school 2400060 2   Anne Arundel 240006000135 4252 Traceys Elementary   Regular School No Elementary KG 05 2020   pk_12_total 258 26 127               21                             432 258 26 127               21                       432
1238849 1238849 MD     school 2400120 3   Baltimore County 240012000487 971 Towson High Law & Public Policy   Regular School No High 09 12 2020   pk_12_total 1003 292 88   * 144         89                             1619 1003 292 88     144         89                       1619
1244805 1244805 MD     school 2400600 18   Saint Mary's 240060001239 806 Town Creek Elementary   Regular School No Elementary KG 05 2020   pk_12_total 142 29 14   * *         23                             216 142 29 14               23                       216
1238660 1238660 MD     school 2400120 3   Baltimore County 240012001433 805 Timonium Elementary   Regular School No Elementary KG 05 2020   pk_12_total 331 29 32     67         25                             484 331 29 32     67         25                       484
1238562 1238562 MD     school 2400120 3   Baltimore County 240012000484 405 Timber Grove Elementary   Regular School No Elementary PK 05 2020   pk_12_total 68 309 117   * 31         33                             561 68 309 117     31         33                       561
1244940 1244940 MD     school 2400630 20   Talbot 240063001250 501 Tilghman Elementary   Regular School No Elementary PK 05 2020   pk_12_total 89   *               *                             101 89                                           101
1241991 1241991 MD     school 2400480 15   Montgomery 240048001450 232 Tilden Middle School   Regular School No Middle 06 08 2020   pk_12_total 434 125 213   * 166     *   48                             989 434 125 213     166         48                       989
1240642 1240642 MD     school 2400330 10   Frederick 240033001166 1511 Thurmont Primary   Regular School No Elementary PK 02 2020   pk_12_total 301   17     *     *   16                             336 301   17               16                       336
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
1240628 1240628 MD     school 2400330 10   Frederick 240033000650 1503 Thurmont Elementary   Regular School No Elementary 03 05 2020   pk_12_total 272   20   *           18                             312 272   20               18                       312
1243349 1243349 MD     school 2400510 16   Prince George's 240051001465 622 Thurgood Marshall Middle School   Regular School No Middle 06 08 2020   pk_12_total * 448 150   * *     *   *                             625   448 150                                       625
1242052 1242052 MD     school 2400480 15   Montgomery 240048000404 244 Thurgood Marshall Elementary   Regular School No Elementary PK 05 2020   pk_12_total 200 114 190   * 91     *   24                             621 200 114 190     91         24                       621
1241590 1241590 MD     school 2400420 13   Howard 240042000757 605 Thunder Hill Elementary   Regular School No Elementary KG 05 2020   pk_12_total 158 134 49   * 93     *   39                             475 158 134 49     93         39                       475
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
1242346 1242346 MD     school 2400480 15   Montgomery 240048009000 428 Thomas W. Pyle Middle School   Regular School No Middle 06 08 2020   pk_12_total 987 49 163   * 214     *   118                             1534 987 49 163     214         118                       1534
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
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
1242003 1242003 MD     school 2400480 15   Montgomery 240048000934 234 Thomas S. Wootton High   Regular School No High 09 12 2020   pk_12_total 881 176 169   * 787     *   101                             2116 881 176 169     787         101                       2116
1244159 1244159 MD     school 2400510 16   Prince George's 240051001176 1706 Thomas S. Stone Elementary   Regular School No Elementary PK 05 2020   pk_12_total 18 105 425   * *     *   *                             557 18 105 425                                       557
1244427 1244427 MD     school 2400510 16   Prince George's 240051001175 2009 Thomas Johnson Middle   Regular School No Middle 06 08 2020   pk_12_total 32 639 553   * 35     *   *                             1269 32 639 553     35                                 1269
1245823 1245823 MD     school 2400090 30   Baltimore City 240009000323 84 Thomas Johnson Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 381 86 44     *     *   32                             548 381 86 44               32                       548
1246217 1246217 MD     school 2400090 30   Baltimore City 240009000322 232 Thomas Jefferson Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 436 12   *                                         457   436 12                                       457
1244312 1244312 MD     school 2400510 16   Prince George's 240051001174 1814 Thomas G. Pullen School   Regular School No Elementary KG 08 2020   pk_12_total 18 615 66   * *         23                             735 18 615 66               23                       735
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
1246821 1246821 MD     school 2400027 32   SEED 240002701669 1000 The Seed School of Maryland   Regular School No High 06 12 2020   pk_12_total * 383 11               *                             401   383 11                                       401
1246572 1246572 MD     school 2400090 30   Baltimore City 240009001663 341 The Reach! Partnership School   Regular School No High 09 12 2020   pk_12_total * 576 *   *           *                             587   576                                         587
1246142 1246142 MD     school 2400090 30   Baltimore City 240009000286 221 The Mount Washington School   Regular School No Elementary KG 08 2020   pk_12_total 150 373 24     14     *   24                             587 150 373 24     14         24                       587
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
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
1246538 1246538 MD     school 2400090 30   Baltimore City 240009001571 332 The Green School of Baltimore   Regular School Yes Elementary KG 05 2020   pk_12_total 57 74 11           *   18                             161 57 74 11               18                       161
1246491 1246491 MD     school 2400090 30   Baltimore City 240009001291 323 The Crossroads School   Regular School Yes Middle 06 08 2020   pk_12_total * 114 37   *           *                             162   114 37                                       162
1246206 1246206 MD     school 2400090 30   Baltimore City 240009000161 231 The Belair-Edison School   Regular School Yes Elementary PK 06 2020   pk_12_total 10 795 12   *           11                             831 10 795 12               11                       831
1245508 1245508 MD     school 2400090 30   Baltimore City 240009000320 13 Tench Tilghman Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 340 53               *                             398   340 53                                       398
1243202 1243202 MD     school 2400510 16   Prince George's 240051001171 214 Templeton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 59 183 527   * 164     *   *                             943 59 183 527     164                                 943
1243552 1243552 MD     school 2400510 16   Prince George's 240051001170 905 Tayac Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 235 93     *     *   *                             347   235 93                                       347
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
1243467 1243467 MD     school 2400510 16   Prince George's 240051001424 705 Tall Oaks High   Alternative School No High 11 12 2020   pk_12_total * 63 25   * *                                       95   63 25                                       95
1241617 1241617 MD     school 2400420 13   Howard 240042000756 609 Talbott Springs Elementary   Regular School No Elementary PK 05 2020   pk_12_total 99 205 141   * 25         38                             509 99 205 141     25         38                       509
1242744 1242744 MD     school 2400480 15   Montgomery 240048000933 755 Takoma Park Middle School   Regular School No Middle 06 08 2020   pk_12_total 341 395 197   * 169         58                             1162 341 395 197     169         58                       1162
1242740 1242740 MD     school 2400480 15   Montgomery 240048000932 754 Takoma Park Elementary   Regular School No Elementary PK 02 2020   pk_12_total 264 185 98   * 16     *   47                             613 264 185 98     16         47                       613
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
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
1241492 1241492 MD     school 2400420 13   Howard 240042000755 517 Swansfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 70 311 108     39         34                             562 70 311 108     39         34                       562
1240835 1240835 MD     school 2400360 11   Garrett 240036000676 1812 Swan Meadow School   Regular School No Elementary KG 08 2020   pk_12_total 58   *                                             59 58                                           59
1239233 1239233 MD     school 2400120 3   Baltimore County 240012000482 1513 Sussex Elementary   Regular School No Elementary PK 05 2020   pk_12_total 180 137 73   * *     *   47                             448 180 137 73               47                       448
1243565 1243565 MD     school 2400510 16   Prince George's 240051001167 908 Surrattsville High   Regular School No High 09 12 2020   pk_12_total 12 562 109     *     *   15                             705 12 562 109               15                       705
1237665 1237665 MD     school 2400060 2   Anne Arundel 240006000134 2222 Sunset Elementary   Regular School No Elementary PK 05 2020   pk_12_total 342 30 29   * 10     *   33                             446 342 30 29     10         33                       446
1239495 1239495 MD     school 2400150 4   Calvert 240015001505 316 Sunderland Elementary   Regular School No Elementary PK 05 2020   pk_12_total 532 98 24     *         60                             723 532 98 24               60                       723
1238510 1238510 MD     school 2400120 3   Baltimore County 240012000481 310 Summit Park Elementary   Regular School No Elementary KG 05 2020   pk_12_total 346 56 20   * 32     *   14                             470 346 56 20     32         14                       470
1242569 1242569 MD     school 2400480 15   Montgomery 240048000931 563 Summit Hall Elementary   Regular School No Elementary PK 05 2020   pk_12_total 18 126 523   * 21         13                             702 18 126 523     21         13                       702
1243276 1243276 MD     school 2400510 16   Prince George's 240051001164 603 Suitland High   Regular School No High 09 12 2020   pk_12_total 16 1684 170   * *     *   19                             1903 16 1684 170               19                       1903
1243454 1243454 MD     school 2400510 16   Prince George's 240051001453 661 Suitland Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 456 115     *         *                             578   456 115                                       578
1244583 1244583 MD     school 2400540 17   Queen Anne's 240054001198 101 Sudlersville Middle School   Regular School No Middle 05 08 2020   pk_12_total 341 36 87   * *         26                             497 341 36 87               26                       497
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

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