Data source: Big Local News · About: Big Local

19,213 rows where state = "MD" sorted by hispanic descending

View and edit SQL

grade

year

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 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 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 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 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
1310038 MD     school 2400060 2   Anne Arundel 240006000116 1212 Point Pleasant Elementary   Regular School No Elementary PK 05 2021   pk_12_total 289 69 99     12         41                             510 289 69 99     12         41                       510
1311404 MD     school 2400120 3   Baltimore County 240012000487 971 Towson High   Regular School No High 09 12 2021   pk_12_total 1036 303 99   * 133     *   102                             1677 1036 303 99     133         102                       1677
1317586 MD     school 2400660 21   Washington 240066001707 328 Ruth Ann Monroe Primary   Regular School No Elementary PK 02 2021   pk_12_total 176 178 99   * 22         79                             556 176 178 99     22         79                       556
1319317 MD     school 2400090 30   Baltimore City 240009001381 427 Academy for College and Career Exploration   Regular School No High 06 12 2021   pk_12_total 44 556 99   * *     *   *                             715 44 556 99                                       715
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 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 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 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 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 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
1310498 MD     school 2400060 2   Anne Arundel 240006000120 3392 Rippling Woods Elementary   Regular School No Elementary PK 05 2021   pk_12_total 180 240 98     19         40                             577 180 240 98     19         40                       577
1312738 MD     school 2400270 8   Charles 240027001647 625 Theodore G. Davis Middle School   Regular School No Middle 06 08 2021   pk_12_total 70 601 98   * 30     *   79                             885 70 601 98     30         79                       885
1314931 MD     school 2400480 15   Montgomery 240048000889 502 Olney Elementary   Regular School No Elementary PK 05 2021   pk_12_total 312 92 98   * 90     *   40                             634 312 92 98     90         40                       634
1315925 MD     school 2400510 16   Prince George's 240051001136 619 Princeton Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 177 98   * *         *                             286   177 98                                       286
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 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 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 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 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
1309967 MD     school 2400060 2   Anne Arundel 240006001515 1122 Freetown Elementary   Regular School No Elementary PK 05 2021   pk_12_total 140 215 97   * 14     *   39                             508 140 215 97     14         39                       508
1310390 MD     school 2400060 2   Anne Arundel 240006000114 3182 Pershing Hill Elementary   Regular School No Elementary KG 05 2021   pk_12_total 216 99 97   * 14     *   60                             491 216 99 97     14         60                       491
1310430 MD     school 2400060 2   Anne Arundel 240006002944 3242 Piney Orchard Elementary   Regular School No Elementary KG 05 2021   pk_12_total 386 204 97   * 51     *   64                             808 386 204 97     51         64                       808
1316373 MD     school 2400510 16   Prince George's 240051000972 1221 Avalon Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 174 97   * *     *   *                             285   174 97                                       285
1317839 MD     school 2400690 22   Wicomico 240069001298 514 Beaver Run School   Regular School No Elementary PK 02 2021   pk_12_total 125 263 97     *         56                             546 125 263 97               56                       546
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
1316957 MD     school 2400510 16   Prince George's 240051001186 1908 William Wirt Middle   Regular School No Middle 06 08 2021   pk_12_total 25 219 962   * 64     *   *                             1280 25 219 962     64                                 1280
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 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
1312688 MD     school 2400270 8   Charles 240027010501 617 Daniel of St. Thomas Jenifer Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 27 411 96   * 17         42                             595 27 411 96     17         42                       595
1313825 MD     school 2400420 13   Howard 240042001172 108 Bonnie Branch Middle   Regular School No Middle 06 08 2021   pk_12_total 236 166 96     142         53                             693 236 166 96     142         53                       693
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 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 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 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
1310397 MD     school 2400060 2   Anne Arundel 240006000119 3192 Ridgeway Elementary   Regular School No Elementary KG 05 2021   pk_12_total 285 148 95   * 34     *   68                             632 285 148 95     34         68                       632
1312418 MD     school 2400240 7   Cecil 240024000567 303 Elkton Middle   Regular School No Middle 06 08 2021   pk_12_total 216 178 95   * *     *   76                             574 216 178 95               76                       574
1312758 MD     school 2400270 8   Charles 240027000599 701 Matthew Henson Middle School   Regular School No Middle 06 08 2021   pk_12_total 73 529 95   * 17     *   65                             784 73 529 95     17         65                       784
1314259 MD     school 2400420 13   Howard 240042001032 625 Gorman Crossing Elementary   Regular School No Elementary PK 05 2021   pk_12_total 144 266 95   * 230     *   49                             786 144 266 95     230         49                       786
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 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 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 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 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 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 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
1310241 MD     school 2400060 2   Anne Arundel 240006000058 2273 Chesapeake High   Regular School No High 09 12 2021   pk_12_total 1183 57 94   * 27     *   43                             1412 1183 57 94     27         43                       1412
1315848 MD     school 2400510 16   Prince George's 240051001132 510 Potomac Landing Elementary   Regular School No Elementary PK 06 2021   pk_12_total 14 272 94   * 24     *   *                             412 14 272 94     24                                 412
1316152 MD     school 2400510 16   Prince George's 240051001072 909 James Ryder Randall Elementary   Regular School No Elementary KG 05 2021   pk_12_total * 166 94     *         *                             271   166 94                                       271
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 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 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 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 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 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 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
1311571 MD     school 2400120 3   Baltimore County 240012000470 1216 Sandy Plains Elementary   Regular School No Elementary PK 05 2021   pk_12_total 250 114 93   * 19         51                             534 250 114 93     19         51                       534
1311880 MD     school 2400120 3   Baltimore County 240012000478 1554 Stemmers Run Middle   Regular School No Middle 06 08 2021   pk_12_total 379 249 93   11 18         56                             806 379 249 93   11 18         56                       806
1313056 MD     school 2400330 10   Frederick 240033000392 714 Windsor Knolls Middle   Regular School No Middle 06 08 2021   pk_12_total 487 48 93     43     *   37                             709 487 48 93     43         37                       709
1316021 MD     school 2400510 16   Prince George's 240051001556 656 Panorama Elementary   Regular School No Elementary PK 06 2021   pk_12_total * 408 93   * *     *   *                             529   408 93                                       529
1318245 MD     school 2400090 30   Baltimore City 240009000276 53 Margaret Brent Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 27 161 93   *       *   *                             294 27 161 93                                       294
1316825 MD     school 2400510 16   Prince George's 240051001257 1730 Mary Harris   Regular School No Elementary PK 05 2021   pk_12_total * 44 927   * *     *   *                             991   44 927                                       991
1317017 MD     school 2400510 16   Prince George's 240051001004 2011 Charles Carroll Middle   Regular School No Middle 06 08 2021   pk_12_total 23 356 922   * 25         *                             1330 23 356 922     25                                 1330
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 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 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 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 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
1310219 MD     school 2400060 2   Anne Arundel 240006000129 2212 Solley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 453 97 92   * 32     *   57                             735 453 97 92     32         57                       735
1311262 MD     school 2400120 3   Baltimore County 240012001722 814 Mays Chapel Elementary   Regular School No Elementary PK 05 2021   pk_12_total 279 106 92   * 142         45                             668 279 106 92     142         45                       668
1312260 MD     school 2400210 6   Carroll 240021000554 705 William Winchester Elementary   Regular School No Elementary PK 05 2021   pk_12_total 314 41 92     10         26                             483 314 41 92     10         26                       483
1313437 MD     school 2400390 12   Harford 240039000686 120 Deerfield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 168 352 92   * 12     *   93                             720 168 352 92     12         93                       720
1316176 MD     school 2400510 16   Prince George's 240051001035 916 Francis T. Evans Elementary   Regular School No Elementary PK 05 2021   pk_12_total 33 216 92   * *     *   11                             363 33 216 92               11                       363
1315489 MD     school 2400480 15   Montgomery 240048000773 789 Albert Einstein High   Regular School No High 09 12 2021   pk_12_total 462 336 916   * 117         83                             1921 462 336 916     117         83                       1921
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 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 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 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 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
1312627 MD     school 2400270 8   Charles 240027000585 604 Dr. Samuel A. Mudd Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 33 402 91   * *         29                             566 33 402 91               29                       566
1316282 MD     school 2400510 16   Prince George's 240051001121 1201 Oxon Hill Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 112 91     14         *                             228   112 91     14                                 228
1317004 MD     school 2400510 16   Prince George's 240051000970 2008 Ardmore Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 334 91     *     *   *                             434   334 91                                       434
1317581 MD     school 2400660 21   Washington 240066001667 325 Rockland Woods Elementary   Regular School No Elementary PK 05 2021   pk_12_total 323 112 91   * 19     *   55                             604 323 112 91     19         55                       604
1318692 MD     school 2400090 30   Baltimore City 240009000284 220 Morrell Park Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 166 146 91   * 14     *   22                             443 166 146 91     14         22                       443
1316799 MD     school 2400510 16   Prince George's 240051001112 1718 Nicholas Orem Middle   Regular School No Middle 06 08 2021   pk_12_total 18 201 905   * *     *   *                             1139 18 201 905                                       1139
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 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 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 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 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 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 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 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 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 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 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 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

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