enrollments

Data source: Big Local News · About: Big Local

9,598 rows where state = "MD" and year = 2021 sorted by hispanic descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 9,498 ✖
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
1315875 1315875 MD     school 2400510 16   Prince George's 240051001060 607 Hillcrest Heights Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 333 81     *         *                             420   333 81                                       420
1317675 1317675 MD     school 2400660 21   Washington 240066000418 1002 Eastern Elementary   Regular School No Elementary 03 05 2021   pk_12_total 141 118 81   * *         68                             418 141 118 81               68                       418
1317829 1317829 MD     school 2400690 22   Wicomico 240069001301 512 East Salisbury Elementary   Regular School No Elementary 03 05 2021   pk_12_total 66 203 81   * *         46                             399 66 203 81               46                       399
1310874 1310874 MD     school 2400120 3   Baltimore County 240012000406 115 Hillcrest Elementary   Regular School No Elementary PK 05 2021   pk_12_total 387 74 80   * 123     *   26                             692 387 74 80     123         26                       692
1312018 1312018 MD     school 2400150 4   Calvert 240015001342 217 Huntingtown High School   Regular School No High 09 12 2021   pk_12_total 1060 134 80   * 22         100                             1398 1060 134 80     22         100                       1398
1317387 1317387 MD     school 2400600 18   Saint Mary's 240060001220 807 Esperanza Middle   Regular School No Middle 06 08 2021   pk_12_total 459 193 80     38     *   85                             858 459 193 80     38         85                       858
1311579 1311579 MD     school 2400120 3   Baltimore County 240012000421 1217 Logan Elementary   Regular School No Elementary PK 05 2021   pk_12_total 203 151 79   * 13     *   53                             501 203 151 79     13         53                       501
1312218 1312218 MD     school 2400210 6   Carroll 240021001161 510 Century High   Regular School No High 09 12 2021   pk_12_total 919 53 79   * 52     *   27                             1135 919 53 79     52         27                       1135
1315192 1315192 MD     school 2400480 15   Montgomery 240048000818 570 Diamond Elementary   Regular School No Elementary PK 05 2021   pk_12_total 200 65 79     397     *   38                             780 200 65 79     397         38                       780
1316817 1316817 MD     school 2400510 16   Prince George's 240051000510 1725 Cool Spring Elementary   Regular School No Elementary PK 06 2021   pk_12_total 10 23 784   *           *                             834 10 23 784                                       834
1311712 1311712 MD     school 2400120 3   Baltimore County 240012000442 1452 Parkville Middle   Regular School No Middle 06 08 2021   pk_12_total 435 429 78   * 71     *   61                             1076 435 429 78     71         61                       1076
1311797 1311797 MD     school 2400120 3   Baltimore County 240012000430 1514 Middlesex Elementary   Regular School No Elementary PK 05 2021   pk_12_total 139 113 78     *         31                             370 139 113 78               31                       370
1312384 1312384 MD     school 2400210 6   Carroll 240021000546 1401 South Carroll High   Regular School No High 09 12 2021   pk_12_total 842 15 78   * 23     *   22                             984 842 15 78     23         22                       984
1313047 1313047 MD     school 2400330 10   Frederick 240033000652 702 Urbana Elementary   Regular School No Elementary PK 05 2021   pk_12_total 322 52 78   * 144         51                             651 322 52 78     144         51                       651
1313074 1313074 MD     school 2400330 10   Frederick 240033001762 717 Sugarloaf Elementary   Regular School No Elementary KG 05 2021   pk_12_total 291 78 78   * 133         39                             620 291 78 78     133         39                       620
1317211 1317211 MD     school 2400540 17   Queen Anne's 240054001076 405 Kent Island High School   Regular School No High 09 12 2021   pk_12_total 952 56 78     23     *   62                             1174 952 56 78     23         62                       1174
1317339 1317339 MD     school 2400600 18   Saint Mary's 240060001685 606 Evergreen Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 483 81 78   * 39     *   58                             741 483 81 78     39         58                       741
1313975 1313975 MD     school 2400420 13   Howard 240042000731 404 Glenelg High   Regular School No High 09 12 2021   pk_12_total 888 52 77   * 179         65                             1263 888 52 77     179         65                       1263
1314794 1314794 MD     school 2400480 15   Montgomery 240048001758 347 Snowden Farm Elementary   Regular School No Elementary PK 05 2021   pk_12_total 118 163 77   * 359         36                             757 118 163 77     359         36                       757
1317161 1317161 MD     school 2400540 17   Queen Anne's 240054001198 101 Sudlersville Middle School   Regular School No Middle 05 08 2021   pk_12_total 303 30 77   * *         27                             443 303 30 77               27                       443
1310099 1310099 MD     school 2400060 2   Anne Arundel 240006000126 2043 Severna Park Middle   Regular School No Middle 06 08 2021   pk_12_total 1130 55 76   * 69     *   75                             1412 1130 55 76     69         75                       1412
1311301 1311301 MD     school 2400120 3   Baltimore County 240012000490 908 Villa Cresta Elementary   Regular School No Elementary PK 05 2021   pk_12_total 337 160 76   * 22     *   46                             649 337 160 76     22         46                       649
1314536 1314536 MD     school 2400480 15   Montgomery 240048000849 228 Herbert Hoover Middle   Regular School No Middle 06 08 2021   pk_12_total 400 81 76   * 399     *   63                             1021 400 81 76     399         63                       1021
1310299 1310299 MD     school 2400060 2   Anne Arundel 240006001761 3063 Crofton High School   Regular School No Secondary 09 10 2021   pk_12_total 458 146 75   * 51     *   47                             783 458 146 75     51         47                       783
1310405 1310405 MD     school 2400060 2   Anne Arundel 240006000123 3202 Severn Elementary   Regular School No Elementary PK 05 2021   pk_12_total 104 278 75   * 40     *   43                             544 104 278 75     40         43                       544
1310866 1310866 MD     school 2400120 3   Baltimore County 240012000357 113 Chadwick Elementary   Regular School No Elementary PK 05 2021   pk_12_total 35 283 75   * 240         10                             647 35 283 75     240         10                       647
1311789 1311789 MD     school 2400120 3   Baltimore County 240012000482 1513 Sussex Elementary   Regular School No Elementary PK 05 2021   pk_12_total 149 142 75   * *         52                             425 149 142 75               52                       425
1312875 1312875 MD     school 2400300 9   Dorchester 240030000617 711 Maple Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 85 248 75     10         36                             454 85 248 75     10         36                       454
1313565 1313565 MD     school 2400390 12   Harford 240039000694 304 Harford Technical High   Career and Technical School No High 09 12 2021   pk_12_total 702 133 75   * 32     *   47                             993 702 133 75     32         47                       993
1313877 1313877 MD     school 2400420 13   Howard 240042000748 209 Patapsco Middle   Regular School No Middle 06 08 2021   pk_12_total 277 90 75   * 226     *   22                             693 277 90 75     226         22                       693
1314324 1314324 MD     school 2400480 15   Montgomery 240048000843 102 Germantown Elementary   Regular School No Elementary PK 05 2021   pk_12_total 47 110 75   * 50     *   16                             301 47 110 75     50         16                       301
1316636 1316636 MD     school 2400510 16   Prince George's 240051001461 1438 Whitehall Elementary   Regular School No Elementary KG 05 2021   pk_12_total 134 300 75   * 49     *   17                             577 134 300 75     49         17                       577
1317074 1317074 MD     school 2400510 16   Prince George's 240051000512 2106 Greenbelt Elementary   Regular School No Elementary PK 05 2021   pk_12_total 97 319 75   * 42         15                             550 97 319 75     42         15                       550
1317972 1317972 MD     school 2400720 23   Worcester 240072000880 308 Stephen Decatur Middle   Regular School No Middle 07 08 2021   pk_12_total 484 59 75   * 13         58                             691 484 59 75     13         58                       691
1318790 1318790 MD     school 2400090 30   Baltimore City 240009000306 233 Roland Park Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 511 617 75   * 119     *   72                             1402 511 617 75     119         72                       1402
1311852 1311852 MD     school 2400120 3   Baltimore County 240012000469 1527 Sandalwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 36 334 74   *           32                             479 36 334 74               32                       479
1312379 1312379 MD     school 2400210 6   Carroll 240021000539 1306 Mount Airy Middle   Regular School No Middle 06 08 2021   pk_12_total 567 18 74   * 14     *   13                             690 567 18 74     14         13                       690
1312660 1312660 MD     school 2400270 8   Charles 240027000584 611 Dr. Gustavus Brown Elementary   Regular School No Elementary PK 05 2021   pk_12_total 32 266 74   * *         31                             407 32 266 74               31                       407
1313019 1313019 MD     school 2400330 10   Frederick 240033000641 313 Middletown High   Regular School No High 09 12 2021   pk_12_total 992 22 74   * 17     *   40                             1149 992 22 74     17         40                       1149
1313765 1313765 MD     school 2400390 12   Harford 240039000711 639 Roye-Williams Elementary   Regular School No Elementary PK 05 2021   pk_12_total 164 110 74   * *     *   52                             410 164 110 74               52                       410
1314051 1314051 MD     school 2400420 13   Howard 240042000737 518 Harpers Choice Middle   Regular School No Middle 06 08 2021   pk_12_total 92 241 74   * 38     *   43                             490 92 241 74     38         43                       490
1317272 1317272 MD     school 2400600 18   Saint Mary's 240060001218 303 Chopticon High   Regular School No High 09 12 2021   pk_12_total 1375 134 74   * 14     *   85                             1689 1375 134 74     14         85                       1689
1318358 1318358 MD     school 2400090 30   Baltimore City 240009000205 76 Francis Scott Key Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 229 237 74   * *     *   22                             575 229 237 74               22                       575
1319296 1319296 MD     school 2400090 30   Baltimore City 240009001331 419 Reginald F. Lewis High   Regular School No High 09 12 2021   pk_12_total 14 520 74   * *     *   *                             615 14 520 74                                       615
1316808 1316808 MD     school 2400510 16   Prince George's 240051001087 1719 Langley Park/McCormick Elementary   Regular School No Elementary PK 06 2021   pk_12_total * 33 737   * *         *                             783   33 737                                       783
1318746 1318746 MD     school 2400090 30   Baltimore City 240009000257 228 John Ruhrah Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 68 42 730   * *         *                             854 68 42 730                                       854
1309942 1309942 MD     school 2400060 2   Anne Arundel 240006000043 1082 Belle Grove Elementary   Regular School No Elementary PK 05 2021   pk_12_total 108 62 73   * 11         32                             287 108 62 73     11         32                       287
1312231 1312231 MD     school 2400210 6   Carroll 240021001672 602 Manchester Valley High   Regular School No High 09 12 2021   pk_12_total 1154 34 73   * 31     *   25                             1321 1154 34 73     31         25                       1321
1312586 1312586 MD     school 2400270 8   Charles 240027000596 106 La Plata High School   Regular School No High 09 12 2021   pk_12_total 703 247 73   * 38     *   107                             1174 703 247 73     38         107                       1174
1312904 1312904 MD     school 2400330 10   Frederick 240033000628 108 Carroll Manor Elementary   Regular School No Elementary PK 05 2021   pk_12_total 368 57 73   * 16         23                             538 368 57 73     16         23                       538
1317573 1317573 MD     school 2400660 21   Washington 240066000308 305 Washington County Technical High   Career and Technical School No High 11 12 2021   pk_12_total 409 33 73   * *     *   28                             554 409 33 73               28                       554
1316201 1316201 MD     school 2400510 16   Prince George's 240051001092 1008 Laurel High   Regular School No High 09 12 2021   pk_12_total 71 1069 728   * 75     *   35                             1986 71 1069 728     75         35                       1986
1318831 1318831 MD     school 2400090 30   Baltimore City 240009000244 237 Highlandtown Elementary/Middle #237   Regular School No Elementary PK 08 2021   pk_12_total 15 115 720     *     *   *                             860 15 115 720                                       860
1310236 1310236 MD     school 2400060 2   Anne Arundel 240006000091 2243 Magothy River Middle   Regular School No Middle 06 08 2021   pk_12_total 533 40 72   * 15     *   51                             714 533 40 72     15         51                       714
1310882 1310882 MD     school 2400120 3   Baltimore County 240012000499 116 Woodbridge Elementary   Regular School No Elementary PK 05 2021   pk_12_total 35 128 72   * 184     *   *                             430 35 128 72     184                                 430
1311050 1311050 MD     school 2400120 3   Baltimore County 240012000431 307 Milbrook Elementary   Regular School No Elementary 01 05 2021   pk_12_total 26 212 72   * 18         13                             344 26 212 72     18         13                       344
1312819 1312819 MD     school 2400270 8   Charles 240027000597 1002 Henry E. Lackey High School   Regular School No High 09 12 2021   pk_12_total 276 578 72   * 22     *   66                             1024 276 578 72     22         66                       1024
1314157 1314157 MD     school 2400420 13   Howard 240042000736 607 Hammond Middle School   Regular School No Middle 06 08 2021   pk_12_total 250 153 72   * 83     *   51                             612 250 153 72     83         51                       612
1314870 1314870 MD     school 2400480 15   Montgomery 240048000958 417 Wood Acres Elementary   Regular School No Elementary PK 05 2021   pk_12_total 397 16 72     56     *   41                             583 397 16 72     56         41                       583
1318016 1318016 MD     school 2400720 23   Worcester 240072001327 1001 Ocean City Elementary   Regular School No Elementary PK 04 2021   pk_12_total 400 17 72     12         28                             529 400 17 72     12         28                       529
1310827 1310827 MD     school 2400120 3   Baltimore County 240012000382 104 Edmondson Heights Elementary   Regular School No Elementary PK 05 2021   pk_12_total 40 336 71   * 28     *   16                             499 40 336 71     28         16                       499
1310920 1310920 MD     school 2400120 3   Baltimore County 240012000385 204 Featherbed Lane Elementary   Regular School No Elementary PK 05 2021   pk_12_total 11 359 71   * *     *   21                             473 11 359 71               21                       473
1314398 1314398 MD     school 2400480 15   Montgomery 240048000896 153 Poolesville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 280 37 71     45     *   40                             474 280 37 71     45         40                       474
1316619 1316619 MD     school 2400510 16   Prince George's 240051001144 1432 Rockledge Elementary   Regular School No Elementary PK 05 2021   pk_12_total 54 189 71   * 11     *   16                             345 54 189 71     11         16                       345
1310951 1310951 MD     school 2400120 3   Baltimore County 240012000402 209 Hebbville Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 377 70   * 13         11                             479   377 70     13         11                       479
1311902 1311902 MD     school 2400120 3   Baltimore County 240012000477 1573 Sparrows Point High   Regular School No High 09 12 2021   pk_12_total 877 87 70   * 14     *   43                             1097 877 87 70     14         43                       1097
1313177 1313177 MD     school 2400330 10   Frederick 240033000653 1406 Valley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 342 12 70     *         28                             459 342 12 70               28                       459
1313936 1313936 MD     school 2400420 13   Howard 240042001646 219 Veterans Elementary   Regular School No Elementary PK 05 2021   pk_12_total 225 146 70   * 449     *   49                             951 225 146 70     449         49                       951
1314123 1314123 MD     school 2400420 13   Howard 240042000733 602 Guilford Elementary   Regular School No Elementary PK 05 2021   pk_12_total 69 261 70     68         32                             500 69 261 70     68         32                       500
1314993 1314993 MD     school 2400480 15   Montgomery 240048000846 512 Greenwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 301 54 70     37     *   38                             501 301 54 70     37         38                       501
1317013 1317013 MD     school 2400510 16   Prince George's 240051001043 2010 Glenarden Woods Elementary   Regular School No Elementary 02 05 2021   pk_12_total 47 285 70   * 43     *   *                             455 47 285 70     43                                 455
1314652 1314652 MD     school 2400480 15   Montgomery 240048000788 304 JoAnn Leleck at Broad Acres Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 96 697   * 18         *                             821   96 697     18                                 821
1310014 1310014 MD     school 2400060 2   Anne Arundel 240006000105 1182 Oakwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 137 74 69   * 26         30                             339 137 74 69     26         30                       339
1311765 1311765 MD     school 2400120 3   Baltimore County 240012000384 1508 Essex Elementary   Regular School No Elementary PK 05 2021   pk_12_total 253 63 69   * 12     *   29                             435 253 63 69     12         29                       435
1312454 1312454 MD     school 2400240 7   Cecil 240024000581 316 Thomson Estates Elementary   Regular School No Elementary PK 05 2021   pk_12_total 209 102 69   * 11     *   60                             453 209 102 69     11         60                       453
1313535 1313535 MD     school 2400390 12   Harford 240039000680 212 Bakerfield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 137 126 69     *         42                             383 137 126 69               42                       383
1313573 1313573 MD     school 2400390 12   Harford 240039000681 314 Bel Air Elementary   Regular School No Elementary PK 05 2021   pk_12_total 366 34 69   * 25         27                             522 366 34 69     25         27                       522
1314829 1314829 MD     school 2400480 15   Montgomery 240048000923 405 Somerset Elementary   Regular School No Elementary PK 05 2021   pk_12_total 290 43 69     57     *   40                             500 290 43 69     57         40                       500
1314944 1314944 MD     school 2400480 15   Montgomery 240048000950 504 Westover Elementary   Regular School No Elementary PK 05 2021   pk_12_total 57 105 69     28     *   21                             281 57 105 69     28         21                       281
1314972 1314972 MD     school 2400480 15   Montgomery 240048000796 508 Candlewood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 165 60 69     72     *   30                             398 165 60 69     72         30                       398
1314985 1314985 MD     school 2400480 15   Montgomery 240048000800 511 Cashell Elementary   Regular School No Elementary PK 05 2021   pk_12_total 128 51 69     22         43                             313 128 51 69     22         43                       313
1316651 1316651 MD     school 2400510 16   Prince George's 240051001036 1502 Frederick Douglass High   Regular School No High 09 12 2021   pk_12_total 17 992 69   * *     *   28                             1115 17 992 69               28                       1115
1316893 1316893 MD     school 2400510 16   Prince George's 240051001174 1814 Thomas G. Pullen School   Regular School No Elementary KG 08 2021   pk_12_total 21 616 69   * *     *   22                             743 21 616 69               22                       743
1317980 1317980 MD     school 2400720 23   Worcester 240072001323 311 Berlin Intermediate   Regular School No Middle 05 06 2021   pk_12_total 458 59 69     17         55                             658 458 59 69     17         55                       658
1310136 1310136 MD     school 2400060 2   Anne Arundel 240006000051 2092 Cape St. Claire Elementary   Regular School No Elementary KG 05 2021   pk_12_total 427 11 68   * 16     *   41                             566 427 11 68     16         41                       566
1310746 1310746 MD     school 2400060 2   Anne Arundel 240006001687 6233 Monarch Academy   Regular School Yes Elementary KG 08 2021   pk_12_total 273 246 68   * 25     *   65                             681 273 246 68     25         65                       681
1310886 1310886 MD     school 2400120 3   Baltimore County 240012000354 151 Catonsville Middle   Regular School No Middle 06 08 2021   pk_12_total 455 171 68   * 85     *   36                             821 455 171 68     85         36                       821
1311936 1311936 MD     school 2400150 4   Calvert 240015000611 113 Patuxent High   Regular School No High 09 12 2021   pk_12_total 716 190 68   * 20         88                             1085 716 190 68     20         88                       1085
1313669 1313669 MD     school 2400390 12   Harford 240039001380 385 C. Milton Wright High   Regular School No High 09 12 2021   pk_12_total 1026 100 68   * 72     *   61                             1330 1026 100 68     72         61                       1330
1315017 1315017 MD     school 2400480 15   Montgomery 240048001122 517 Sligo Creek Elementary   Regular School No Elementary PK 05 2021   pk_12_total 345 169 68   * 23     *   48                             658 345 169 68     23         48                       658
1317853 1317853 MD     school 2400690 22   Wicomico 240069001307 905 North Salisbury Elementary   Regular School No Elementary 03 05 2021   pk_12_total 153 172 68   * 43     *   31                             471 153 172 68     43         31                       471
1317881 1317881 MD     school 2400690 22   Wicomico 240069001300 1103 Delmar Elementary   Regular School No Elementary PK 04 2021   pk_12_total 505 158 68   * 33         78                             843 505 158 68     33         78                       843
1319266 1319266 MD     school 2400090 30   Baltimore City 240009000330 407 Western High   Regular School No High 09 12 2021   pk_12_total 56 1090 68   * 11     *   *                             1236 56 1090 68     11                                 1236
1312880 1312880 MD     school 2400300 9   Dorchester 240030000612 713 Cambridge-South Dorchester High School   Regular School No High 09 12 2021   pk_12_total 246 403 67   * 10         54                             782 246 403 67     10         54                       782
1313063 1313063 MD     school 2400330 10   Frederick 240033001429 715 Centerville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 177 58 67     87         50                             439 177 58 67     87         50                       439
1313519 1313519 MD     school 2400390 12   Harford 240039001642 188 Patterson Mill Middle School   Regular School No Middle 06 08 2021   pk_12_total 500 57 67   * 58     *   52                             742 500 57 67     58         52                       742
1316250 1316250 MD     school 2400510 16   Prince George's 240051000992 1101 Brandywine Elementary   Regular School No Elementary KG 05 2021   pk_12_total 11 331 67   * *         18                             434 11 331 67               18                       434
1316446 1316446 MD     school 2400510 16   Prince George's 240051001089 1314 Largo High   Regular School No High 09 12 2021   pk_12_total * 817 67   * *     *   10                             909   817 67               10                       909
1316507 1316507 MD     school 2400510 16   Prince George's 240051001223 1348 Ernest Everett Just Middle   Regular School No Middle 06 08 2021   pk_12_total * 705 67   * *     *   *                             802   705 67                                       802
1316558 1316558 MD     school 2400510 16   Prince George's 240051001058 1412 High Bridge Elementary   Regular School No Elementary KG 05 2021   pk_12_total 22 246 67   * *         *                             351 22 246 67                                       351

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