enrollments

Data source: Big Local News · About: Big Local

9,615 rows where state = "MD" and year = 2020 sorted by hispanic descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 9,615 ✖
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
1237832 1237832 MD     school 2400060 2   Anne Arundel 240006000119 3192 Ridgeway Elementary   Regular School No Elementary KG 05 2020   pk_12_total 333 145 99     25     *   80                             686 333 145 99     25         80                       686
1240140 1240140 MD     school 2400270 8   Charles 240027010501 617 Daniel of St. Thomas Jenifer Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 33 444 99   * 14         50                             643 33 444 99     14         50                       643
1242252 1242252 MD     school 2400480 15   Montgomery 240048000785 401 Bethesda Elementary   Regular School No Elementary KG 05 2020   pk_12_total 339 51 99     123         53                             665 339 51 99     123         53                       665
1242931 1242931 MD     school 2400480 15   Montgomery 240048000915 794 Rosemary Hills Elementary   Regular School No Elementary PK 02 2020   pk_12_total 256 154 99   * 36         24                             570 256 154 99     36         24                       570
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
1240079 1240079 MD     school 2400270 8   Charles 240027000585 604 Dr. Samuel A. Mudd Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 42 407 98   * 10         28                             586 42 407 98     10         28                       586
1240161 1240161 MD     school 2400270 8   Charles 240027000380 620 C. Paul Barnhart Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 21 447 98   * 31         50                             648 21 447 98     31         50                       648
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
1243327 1243327 MD     school 2400510 16   Prince George's 240051001050 617 Francis Scott Key Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 384 98     *         *                             490   384 98                                       490
1243597 1243597 MD     school 2400510 16   Prince George's 240051001035 916 Francis T. Evans Elementary   Regular School No Elementary PK 05 2020   pk_12_total 44 212 98   * *     *   12                             375 44 212 98               12                       375
1237524 1237524 MD     school 2400060 2   Anne Arundel 240006000127 2013 Severna Park High   Regular School No High 09 12 2020   pk_12_total 1589 77 97   * 81     *   84                             1932 1589 77 97     81         84                       1932
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
1240541 1240541 MD     school 2400330 10   Frederick 240033000638 912 Linganore High   Regular School No High 09 12 2020   pk_12_total 1131 22 97   * 12     *   46                             1311 1131 22 97     12         46                       1311
1243889 1243889 MD     school 2400510 16   Prince George's 240051001472 1326 Kettering Middle   Regular School No Middle 06 08 2020   pk_12_total 11 697 97     *     *   *                             825 11 697 97                                       825
1245006 1245006 MD     school 2400660 21   Washington 240066001667 325 Rockland Woods Elementary   Regular School No Elementary PK 05 2020   pk_12_total 357 104 97   * 26     *   64                             652 357 104 97     26         64                       652
1242944 1242944 MD     school 2400480 15   Montgomery 240048001366 796 Northwood High School   Regular School No High 09 12 2020   pk_12_total 248 449 965   * 85         55                             1805 248 449 965     85         55                       1805
1237818 1237818 MD     school 2400060 2   Anne Arundel 240006000106 3172 Odenton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 186 146 96     27     *   71                             527 186 146 96     27         71                       527
1245401 1245401 MD     school 2400720 23   Worcester 240072001335 310 Stephen Decatur High   Regular School No High 09 12 2020   pk_12_total 1015 137 96   * 23     *   55                             1328 1015 137 96     23         55                       1328
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
1241742 1241742 MD     school 2400480 15   Montgomery 240048000864 51 Laytonsville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 170 64 95     30     *   32                             392 170 64 95     30         32                       392
1243441 1243441 MD     school 2400510 16   Prince George's 240051001556 656 Panorama Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 457 95   * *     *   *                             587   457 95                                       587
1245669 1245669 MD     school 2400090 30   Baltimore City 240009000276 53 Margaret Brent Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 25 187 95   *       12   *                             324 25 187 95           12                           324
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
1237657 1237657 MD     school 2400060 2   Anne Arundel 240006000129 2212 Solley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 498 100 94   * 32     *   70                             798 498 100 94     32         70                       798
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
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
1241948 1241948 MD     school 2400480 15   Montgomery 240048000828 219 Farmland Elementary   Regular School No Elementary KG 05 2020   pk_12_total 404 66 94     260         32                             856 404 66 94     260         32                       856
1242361 1242361 MD     school 2400480 15   Montgomery 240048000889 502 Olney Elementary   Regular School No Elementary KG 05 2020   pk_12_total 345 105 94   * 88     *   49                             683 345 105 94     88         49                       683
1245011 1245011 MD     school 2400660 21   Washington 240066001707 328 Ruth Ann Monroe Primary   Regular School No Elementary PK 02 2020   pk_12_total 203 181 94   * 19         97                             596 203 181 94     19         97                       596
1237702 1237702 MD     school 2400060 2   Anne Arundel 240006000124 2413 Severn River Middle   Regular School No Middle 06 08 2020   pk_12_total 597 60 93   * 19         39                             809 597 60 93     19         39                       809
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
1238948 1238948 MD     school 2400120 3   Baltimore County 240012000446 1171 Perry Hall High   Regular School No High 09 12 2020   pk_12_total 939 591 93   * 255     *   85                             1969 939 591 93     255         85                       1969
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
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
1240749 1240749 MD     school 2400330 10   Frederick 240033000626 2504 Brunswick Elementary   Regular School No Elementary PK 05 2020   pk_12_total 535 68 93   * 17     *   45                             762 535 68 93     17         45                       762
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
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
1239483 1239483 MD     school 2400150 4   Calvert 240015000516 314 Northern High   Regular School No High 09 12 2020   pk_12_total 1101 163 92   * 28     *   97                             1484 1101 163 92     28         97                       1484
1241757 1241757 MD     school 2400480 15   Montgomery 240048000804 101 Clarksburg Elementary   Regular School No Elementary KG 05 2020   pk_12_total 104 154 92   * 218         54                             623 104 154 92     218         54                       623
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
1243757 1243757 MD     school 2400510 16   Prince George's 240051001150 1216 Samuel Chase Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 222 92   * *         *                             324   222 92                                       324
1244218 1244218 MD     school 2400510 16   Prince George's 240051001112 1718 Nicholas Orem Middle   Regular School No Middle 06 08 2020   pk_12_total 12 193 912   * *     *   *                             1129 12 193 912                                       1129
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
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
1241702 1241702 MD     school 2400420 13   Howard 240042001032 625 Gorman Crossing Elementary   Regular School No Elementary PK 05 2020   pk_12_total 171 288 91   * 235     *   61                             849 171 288 91     235         61                       849
1245215 1245215 MD     school 2400660 21   Washington 240066001271 2602 Hickory Elementary   Regular School No Elementary PK 05 2020   pk_12_total 142 32 91     *         26                             293 142 32 91               26                       293
1244436 1244436 MD     school 2400510 16   Prince George's 240051001004 2011 Charles Carroll Middle   Regular School No Middle 06 08 2020   pk_12_total 23 378 903   * 19     *   *                             1329 23 378 903     19                                 1329
1237406 1237406 MD     school 2400060 2   Anne Arundel 240006001515 1122 Freetown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 146 184 90   * 15     *   34                             471 146 184 90     15         34                       471
1240251 1240251 MD     school 2400270 8   Charles 240027001727 802 St. Charles High School   Regular School No High 09 12 2020   pk_12_total 175 1005 90   11 29     *   97                             1410 175 1005 90   11 29         97                       1410
1241209 1241209 MD     school 2400390 12   Harford 240039000711 639 Roye-Williams Elementary   Regular School No Elementary PK 05 2020   pk_12_total 202 126 90   * 10     *   59                             490 202 126 90     10         59                       490
1241373 1241373 MD     school 2400420 13   Howard 240042001551 218 Bellows Spring Elementary   Regular School No Elementary PK 05 2020   pk_12_total 202 198 90   * 231         51                             776 202 198 90     231         51                       776
1241641 1241641 MD     school 2400420 13   Howard 240042000740 613 Jeffers Hill Elementary   Regular School No Elementary KG 05 2020   pk_12_total 85 163 90     40         36                             414 85 163 90     40         36                       414
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
1242354 1242354 MD     school 2400480 15   Montgomery 240048000920 501 Sherwood Elementary   Regular School No Elementary PK 05 2020   pk_12_total 218 106 90   * 53     *   53                             524 218 106 90     53         53                       524
1243285 1243285 MD     school 2400510 16   Prince George's 240051000991 606 Bradbury Heights Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 395 90     *     *   *                             496   395 90                                       496
1243700 1243700 MD     school 2400510 16   Prince George's 240051001121 1201 Oxon Hill Elementary   Regular School No Elementary KG 05 2020   pk_12_total 14 113 90     10         *                             229 14 113 90     10                                 229
1245140 1245140 MD     school 2400660 21   Washington 240066001253 1701 Bester Elementary   Regular School No Elementary PK 05 2020   pk_12_total 210 145 90   * *         121                             570 210 145 90               121                       570
1246132 1246132 MD     school 2400090 30   Baltimore City 240009000284 220 Morrell Park Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 181 156 90   * 20     *   20                             471 181 156 90     20         20                       471
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
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
1241974 1241974 MD     school 2400480 15   Montgomery 240048000849 228 Herbert Hoover Middle   Regular School No Middle 06 08 2020   pk_12_total 430 74 89     392     *   59                             1045 430 74 89     392         59                       1045
1244487 1244487 MD     school 2400510 16   Prince George's 240051000512 2106 Greenbelt Elementary   Regular School No Elementary PK 05 2020   pk_12_total 126 331 89   * 42         14                             605 126 331 89     42         14                       605
1242909 1242909 MD     school 2400480 15   Montgomery 240048000773 789 Albert Einstein High   Regular School No High 09 12 2020   pk_12_total 407 321 882   * 139         65                             1818 407 321 882     139         65                       1818
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
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
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
1241649 1241649 MD     school 2400420 13   Howard 240042001699 616 Cradlerock Elementary   Regular School No Elementary PK 05 2020   pk_12_total 97 231 88   * 36         44                             497 97 231 88     36         44                       497
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
1237537 1237537 MD     school 2400060 2   Anne Arundel 240006000126 2043 Severna Park Middle   Regular School No Middle 06 08 2020   pk_12_total 1162 52 87   * 66     *   77                             1453 1162 52 87     66         77                       1453
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
1239296 1239296 MD     school 2400120 3   Baltimore County 240012000469 1527 Sandalwood Elementary   Regular School No Elementary PK 05 2020   pk_12_total 43 359 87   * *         46                             537 43 359 87               46                       537
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
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
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
1244236 1244236 MD     school 2400510 16   Prince George's 240051000510 1725 Cool Spring Elementary   Regular School No Elementary PK 06 2020   pk_12_total 12 26 867   * *         *                             915 12 26 867                                       915
1238495 1238495 MD     school 2400120 3   Baltimore County 240012000431 307 Milbrook Elementary   Regular School No Elementary 01 05 2020   pk_12_total 28 241 86   * 22         14                             394 28 241 86     22         14                       394
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
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
1237533 1237533 MD     school 2400060 2   Anne Arundel 240006000072 2033 George Fox Middle   Regular School No Middle 06 08 2020   pk_12_total 626 91 85   * 18     *   55                             884 626 91 85     18         55                       884
1243266 1243266 MD     school 2400510 16   Prince George's 240051001132 510 Potomac Landing Elementary   Regular School No Elementary PK 05 2020   pk_12_total 11 256 85   * 21     *   *                             382 11 256 85     21                                 382
1237477 1237477 MD     school 2400060 2   Anne Arundel 240006000116 1212 Point Pleasant Elementary   Regular School No Elementary PK 05 2020   pk_12_total 325 77 84     10         49                             545 325 77 84     10         49                       545
1240218 1240218 MD     school 2400270 8   Charles 240027000592 703 J. C. Parks Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 70 368 84   * 20     *   61                             609 70 368 84     20         61                       609
1241535 1241535 MD     school 2400420 13   Howard 240042000816 524 River Hill High   Regular School No High 09 12 2020   pk_12_total 599 136 84     470         89                             1378 599 136 84     470         89                       1378
1242647 1242647 MD     school 2400480 15   Montgomery 240048001526 606 Cabin John Middle School   Regular School No Middle 06 08 2020   pk_12_total 408 120 84   * 365         62                             1040 408 120 84     365         62                       1040
1245313 1245313 MD     school 2400690 22   Wicomico 240069001311 1305 Pinehurst Elementary   Regular School No Elementary PK 05 2020   pk_12_total 138 247 84   * 11     *   47                             534 138 247 84     11         47                       534
1244227 1244227 MD     school 2400510 16   Prince George's 240051001087 1719 Langley Park/McCormick Elementary   Regular School No Elementary PK 06 2020   pk_12_total * 34 837   * *     *   *                             890   34 837                                       890
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
1239024 1239024 MD     school 2400120 3   Baltimore County 240012000421 1217 Logan Elementary   Regular School No Elementary PK 05 2020   pk_12_total 230 165 83   * 15         56                             550 230 165 83     15         56                       550
1239463 1239463 MD     school 2400150 4   Calvert 240015001342 217 Huntingtown High School   Regular School No High 09 12 2020   pk_12_total 1085 116 83   * 25         97                             1408 1085 116 83     25         97                       1408
1240173 1240173 MD     school 2400270 8   Charles 240027000805 622 Berry Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 58 443 83   * 63     *   60                             717 58 443 83     63         60                       717
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
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
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
1243962 1243962 MD     school 2400510 16   Prince George's 240051001023 1409 Duval High   Regular School No High 09 12 2020   pk_12_total 42 1154 829   * 57     *   30                             2123 42 1154 829     57         30                       2123
1243097 1243097 MD     school 2400510 16   Prince George's 240051000978 104 Beltsville Academy   Regular School No Elementary PK 08 2020   pk_12_total 72 190 823   * 54     *   18                             1162 72 190 823     54         18                       1162
1237445 1237445 MD     school 2400060 2   Anne Arundel 240006000102 1172 North Glen Elementary   Regular School No Elementary PK 05 2020   pk_12_total 87 91 82     14         31                             305 87 91 82     14         31                       305
1237679 1237679 MD     school 2400060 2   Anne Arundel 240006000058 2273 Chesapeake High   Regular School No High 09 12 2020   pk_12_total 1161 57 82   * 26     *   54                             1388 1161 57 82     26         54                       1388
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
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
1240982 1240982 MD     school 2400390 12   Harford 240039000680 212 Bakerfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 143 141 82     15         45                             426 143 141 82     15         45                       426

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