enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
1315025 1315025 MD     school 2400480 15   Montgomery 240048090451 518 Brooke Grove Elementary   Regular School No Elementary PK 05 2021   pk_12_total 162 127 66   * 63         31                             450 162 127 66     63         31                       450
1315055 1315055 MD     school 2400480 15   Montgomery 240048001511 546 Goshen Elementary   Regular School No Elementary PK 05 2021   pk_12_total 77 123 236     63         23                             522 77 123 236     63         23                       522
1315136 1315136 MD     school 2400480 15   Montgomery 240048000901 562 Redland Middle   Regular School No Middle 06 08 2021   pk_12_total 126 142 281   * 63         32                             646 126 142 281     63         32                       646
1313970 1313970 MD     school 2400420 13   Howard 240042001437 308 Marriotts Ridge High   Regular School No High 09 12 2021   pk_12_total 675 159 58   * 626     *   73                             1597 675 159 58     626         73                       1597
1239100 1239100 MD     school 2400120 3   Baltimore County 240012000417 1351 Lansdowne Middle   Regular School No Middle 06 08 2020   pk_12_total 201 246 292   16 62     *   48                             866 201 246 292   16 62         48                       866
1242513 1242513 MD     school 2400480 15   Montgomery 240048000837 554 Gaithersburg Middle   Regular School No Middle 06 08 2020   pk_12_total 131 180 453   * 62         50                             877 131 180 453     62         50                       877
1242541 1242541 MD     school 2400480 15   Montgomery 240048000953 558 Whetstone Elementary   Regular School No Elementary PK 05 2020   pk_12_total 48 191 416   * 62         22                             742 48 191 416     62         22                       742
1242659 1242659 MD     school 2400480 15   Montgomery 240048001128 647 Silver Spring International Middle   Regular School No Middle 06 08 2020   pk_12_total 294 250 492   * 62         52                             1153 294 250 492     62         52                       1153
1311696 1311696 MD     school 2400120 3   Baltimore County 240012000459 1406 Red House Run Elementary   Regular School No Elementary PK 05 2021   pk_12_total 197 173 116   * 62         24                             575 197 173 116     62         24                       575
1313444 1313444 MD     school 2400390 12   Harford 240039000485 121 Emmorton Elementary   Regular School No Elementary KG 05 2021   pk_12_total 352 49 49     62         52                             564 352 49 49     62         52                       564
1315116 1315116 MD     school 2400480 15   Montgomery 240048000953 558 Whetstone Elementary   Regular School No Elementary PK 05 2021   pk_12_total 46 173 387   * 62         21                             693 46 173 387     62         21                       693
1315310 1315310 MD     school 2400480 15   Montgomery 240048090480 747 Dr. Charles R. Drew Elementary   Regular School No Elementary PK 05 2021   pk_12_total 62 211 108   * 62     *   22                             468 62 211 108     62         22                       468
1241877 1241877 MD     school 2400480 15   Montgomery 240048000902 201 Richard Montgomery High   Regular School No High 09 12 2020   pk_12_total 729 430 591   * 615     *   135                             2505 729 430 591     615         135                       2505
1313901 1313901 MD     school 2400420 13   Howard 240042000722 214 Centennial High   Regular School No High 09 12 2021   pk_12_total 566 131 82     611     *   75                             1467 566 131 82     611         75                       1467
1239141 1239141 MD     school 2400120 3   Baltimore County 240012000459 1406 Red House Run Elementary   Regular School No Elementary PK 05 2020   pk_12_total 207 172 124   * 61     *   21                             588 207 172 124     61         21                       588
1240430 1240430 MD     school 2400330 10   Frederick 240033090471 223 Ballenger Creek Elementary   Regular School No Elementary PK 05 2020   pk_12_total 218 113 124   * 61     *   64                             586 218 113 124     61         64                       586
1241278 1241278 MD     school 2400420 13   Howard 240042001717 109 Ducketts Lane   Regular School No Elementary PK 05 2020   pk_12_total 116 227 138   * 61     *   26                             570 116 227 138     61         26                       570
1242876 1242876 MD     school 2400480 15   Montgomery 240048000892 783 Kensington Parkwood Elementary   Regular School No Elementary PK 05 2020   pk_12_total 396 40 81     61         64                             642 396 40 81     61         64                       642
1244381 1244381 MD     school 2400510 16   Prince George's 240051001126 1909 Parkdale High   Regular School No High 09 12 2020   pk_12_total 73 718 1473   * 61     *   18                             2354 73 718 1473     61         18                       2354
1314623 1314623 MD     school 2400480 15   Montgomery 240048000644 248 Forest Oak Middle   Regular School No Middle 06 08 2021   pk_12_total 85 212 534     61     *   26                             920 85 212 534     61         26                       920
1237691 1237691 MD     school 2400060 2   Anne Arundel 240006001402 2363 Broadneck High   Regular School No High 09 12 2020   pk_12_total 1635 170 212   10 60     *   130                             2221 1635 170 212   10 60         130                       2221
1240692 1240692 MD     school 2400330 10   Frederick 240033090446 2305 Ballenger Creek Middle   Regular School No Middle 06 08 2020   pk_12_total 362 172 168   * 60     *   47                             817 362 172 168     60         47                       817
1242287 1242287 MD     school 2400480 15   Montgomery 240048000949 412 Westland Middle   Regular School No Middle 06 08 2020   pk_12_total 477 66 147   * 60     *   56                             808 477 66 147     60         56                       808
1242643 1242643 MD     school 2400480 15   Montgomery 240048000798 604 Carderock Springs Elementary   Regular School No Elementary KG 05 2020   pk_12_total 222 12 41   * 60     *   29                             366 222 12 41     60         29                       366
1244703 1244703 MD     school 2400600 18   Saint Mary's 240060001356 306 Leonardtown High   Regular School No High 09 12 2020   pk_12_total 1426 163 103   * 60     *   128                             1889 1426 163 103     60         128                       1889
1310314 1310314 MD     school 2400060 2   Anne Arundel 240006000061 3082 Crofton Woods Elementary   Regular School No Elementary KG 05 2021   pk_12_total 458 58 65   * 60     *   65                             715 458 58 65     60         65                       715
1314532 1314532 MD     school 2400480 15   Montgomery 240048000904 227 Ritchie Park Elementary   Regular School No Elementary KG 05 2021   pk_12_total 187 56 53   * 60     *   26                             384 187 56 53     60         26                       384
1316543 1316543 MD     school 2400510 16   Prince George's 240051001023 1409 Duval High   Regular School No High 09 12 2021   pk_12_total 53 1187 872   * 60     *   20                             2206 53 1187 872     60         20                       2206
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
1242449 1242449 MD     school 2400480 15   Montgomery 240048090451 518 Brooke Grove Elementary   Regular School No Elementary PK 05 2020   pk_12_total 175 134 65   * 59         30                             464 175 134 65     59         30                       464
1242521 1242521 MD     school 2400480 15   Montgomery 240048000916 555 Rosemont Elementary   Regular School No Elementary PK 05 2020   pk_12_total 53 194 301     59     *   37                             645 53 194 301     59         37                       645
1310284 1310284 MD     school 2400060 2   Anne Arundel 240006000039 3023 Arundel Middle   Regular School No Middle 06 08 2021   pk_12_total 501 307 130   * 59     *   116                             1119 501 307 130     59         116                       1119
1313659 1313659 MD     school 2400390 12   Harford 240039000682 374 Southampton Middle   Regular School No Middle 06 08 2021   pk_12_total 923 74 59   * 59         56                             1173 923 74 59     59         56                       1173
1314435 1314435 MD     school 2400480 15   Montgomery 240048000902 201 Richard Montgomery High   Regular School No High 09 12 2021   pk_12_total 699 399 577   * 586     *   143                             2410 699 399 577     586         143                       2410
1240548 1240548 MD     school 2400330 10   Frederick 240033000635 913 Green Valley Elementary   Regular School No Elementary KG 05 2020   pk_12_total 412 38 79   * 58     *   38                             627 412 38 79     58         38                       627
1242101 1242101 MD     school 2400480 15   Montgomery 240048000854 305 Jackson Road Elementary   Regular School No Elementary PK 05 2020   pk_12_total 26 378 255   * 58         14                             732 26 378 255     58         14                       732
1242179 1242179 MD     school 2400480 15   Montgomery 240048001510 334 Greencastle Elementary   Regular School No Elementary PK 05 2020   pk_12_total 17 496 139   * 58         10                             721 17 496 139     58         10                       721
1242533 1242533 MD     school 2400480 15   Montgomery 240048000879 557 Montgomery Village Middle School   Regular School No Middle 06 08 2020   pk_12_total 46 210 449   * 58         25                             790 46 210 449     58         25                       790
1243025 1243025 MD     school 2400480 15   Montgomery 240048000806 818 Col. E. Brooke Lee Middle   Regular School No Middle 06 08 2020   pk_12_total 35 178 483   * 58     *   14                             771 35 178 483     58         14                       771
1310420 1310420 MD     school 2400060 2   Anne Arundel 240006000138 3222 Waugh Chapel Elementary   Regular School No Elementary PK 05 2021   pk_12_total 300 135 90   * 58     *   44                             631 300 135 90     58         44                       631
1311655 1311655 MD     school 2400120 3   Baltimore County 240012000417 1351 Lansdowne Middle   Regular School No Middle 06 08 2021   pk_12_total 211 252 316   17 58     *   55                             910 211 252 316   17 58         55                       910
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
1314602 1314602 MD     school 2400480 15   Montgomery 240048000191 242 Dr. Sally K. Ride Elementary   Regular School No Elementary PK 05 2021   pk_12_total 41 168 180     58     *   27                             475 41 168 180     58         27                       475
1315519 1315519 MD     school 2400480 15   Montgomery 240048000908 795 Rock View Elementary   Regular School No Elementary PK 05 2021   pk_12_total 133 85 307   * 58     *   37                             625 133 85 307     58         37                       625
1317281 1317281 MD     school 2400600 18   Saint Mary's 240060001356 306 Leonardtown High   Regular School No High 09 12 2021   pk_12_total 1366 162 117   * 58     *   138                             1846 1366 162 117     58         138                       1846
1237722 1237722 MD     school 2400060 2   Anne Arundel 240006000039 3023 Arundel Middle   Regular School No Middle 06 08 2020   pk_12_total 480 283 118   * 57     *   122                             1068 480 283 118     57         122                       1068
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
1309998 1309998 MD     school 2400060 2   Anne Arundel 240006000093 1162 Marley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 202 267 192   * 57     *   52                             778 202 267 192     57         52                       778
1311194 1311194 MD     school 2400120 3   Baltimore County 240012001432 772 Hereford High   Regular School No High 09 12 2021   pk_12_total 1093 33 57     57         45                             1285 1093 33 57     57         45                       1285
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
1315088 1315088 MD     school 2400480 15   Montgomery 240048000837 554 Gaithersburg Middle   Regular School No Middle 06 08 2021   pk_12_total 114 175 463   * 57         58                             868 114 175 463     57         58                       868
1238731 1238731 MD     school 2400120 3   Baltimore County 240012000479 905 Stoneleigh Elementary   Regular School No Elementary KG 05 2020   pk_12_total 526 65 60     56         41                             748 526 65 60     56         41                       748
1238770 1238770 MD     school 2400120 3   Baltimore County 240012000399 911 Hampton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 369 114 35     56         28                             602 369 114 35     56         28                       602
1238924 1238924 MD     school 2400120 3   Baltimore County 240012000021 1110 Seven Oaks Elementary   Regular School No Elementary PK 05 2020   pk_12_total 222 136 22   * 56         34                             471 222 136 22     56         34                       471
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
1242821 1242821 MD     school 2400480 15   Montgomery 240048000907 773 Rock Creek Forest Elementary   Regular School No Elementary PK 05 2020   pk_12_total 270 143 247   * 56         41                             760 270 143 247     56         41                       760
1243049 1243049 MD     school 2400480 15   Montgomery 240048001741 835 Silver Creek Middle   Regular School No Middle 06 08 2020   pk_12_total 423 190 173     56         45                             887 423 190 173     56         45                       887
1312265 1312265 MD     school 2400210 6   Carroll 240021000552 707 Westminster High   Regular School No High 09 12 2021   pk_12_total 1242 70 84   * 56     *   59                             1515 1242 70 84     56         59                       1515
1314474 1314474 MD     school 2400480 15   Montgomery 240048000872 210 Maryvale Elementary   Regular School No Elementary PK 05 2021   pk_12_total 132 150 186     56         47                             571 132 150 186     56         47                       571
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
1315108 1315108 MD     school 2400480 15   Montgomery 240048000879 557 Montgomery Village Middle School   Regular School No Middle 06 08 2021   pk_12_total 40 220 438   * 56         20                             776 40 220 438     56         20                       776
1315456 1315456 MD     school 2400480 15   Montgomery 240048000892 783 Kensington Parkwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 346 52 83     56         59                             596 346 52 83     56         59                       596
1316512 1316512 MD     school 2400510 16   Prince George's 240051001704 1350 Academy of Health Sciences at PGCC   Regular School No High 09 12 2021   pk_12_total 22 388 57   * 56         *                             534 22 388 57     56                                 534
1242057 1242057 MD     school 2400480 15   Montgomery 240048001040 246 Northwest High   Regular School No High 09 12 2020   pk_12_total 684 645 605   * 559     *   126                             2623 684 645 605     559         126                       2623
1314628 1314628 MD     school 2400480 15   Montgomery 240048001541 249 Clarksburg High   Regular School No High 09 12 2021   pk_12_total 403 702 585   * 559         111                             2365 403 702 585     559         111                       2365
1313866 1313866 MD     school 2400420 13   Howard 240042000743 207 Mount Hebron High   Regular School No High 09 12 2021   pk_12_total 660 205 152   * 555     *   58                             1635 660 205 152     555         58                       1635
1314615 1314615 MD     school 2400480 15   Montgomery 240048001040 246 Northwest High   Regular School No High 09 12 2021   pk_12_total 655 674 588   * 551         129                             2598 655 674 588     551         129                       2598
1238901 1238901 MD     school 2400120 3   Baltimore County 240012000351 1106 Carney Elementary   Regular School No Elementary PK 05 2020   pk_12_total 200 318 26   * 55     *   36                             638 200 318 26     55         36                       638
1242264 1242264 MD     school 2400480 15   Montgomery 240048000923 405 Somerset Elementary   Regular School No Elementary PK 05 2020   pk_12_total 358 41 78     55     *   49                             582 358 41 78     55         49                       582
1312721 1312721 MD     school 2400270 8   Charles 240027000805 622 Berry Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 59 404 84   * 55     *   68                             675 59 404 84     55         68                       675
1314451 1314451 MD     school 2400480 15   Montgomery 240048000939 206 Twinbrook Elementary   Regular School No Elementary PK 05 2021   pk_12_total 61 47 324   * 55         20                             508 61 47 324     55         20                       508
1315063 1315063 MD     school 2400480 15   Montgomery 240048001454 549 Flower Hill Elementary   Regular School No Elementary PK 05 2021   pk_12_total 31 107 222     55         26                             441 31 107 222     55         26                       441
1241415 1241415 MD     school 2400420 13   Howard 240042001437 308 Marriotts Ridge High   Regular School No High 09 12 2020   pk_12_total 676 136 46   * 548         63                             1472 676 136 46     548         63                       1472
1237485 1237485 MD     school 2400060 2   Anne Arundel 240006000117 1232 Quarterfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 165 120 78   * 54     *   48                             468 165 120 78     54         48                       468
1237749 1237749 MD     school 2400060 2   Anne Arundel 240006000061 3082 Crofton Woods Elementary   Regular School No Elementary KG 05 2020   pk_12_total 525 48 69   * 54     *   63                             763 525 48 69     54         63                       763
1238489 1238489 MD     school 2400120 3   Baltimore County 240012000492 304 Wellwood International Elementary   Regular School No Elementary KG 05 2020   pk_12_total 74 309 30   * 54         18                             489 74 309 30     54         18                       489
1238530 1238530 MD     school 2400120 3   Baltimore County 240012000449 371 Pikesville High   Regular School No High 09 12 2020   pk_12_total 301 464 76   * 54     *   21                             922 301 464 76     54         21                       922
1238602 1238602 MD     school 2400120 3   Baltimore County 240012001347 452 Owings Mills High   Regular School No High 09 12 2020   pk_12_total 77 642 385   * 54     *   25                             1189 77 642 385     54         25                       1189
1238668 1238668 MD     school 2400120 3   Baltimore County 240012000454 808 Pot Spring Elementary   Regular School No Elementary PK 05 2020   pk_12_total 170 127 105   * 54         20                             477 170 127 105     54         20                       477
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
1240700 1240700 MD     school 2400330 10   Frederick 240033000807 2306 Orchard Grove Elementary   Regular School No Elementary PK 05 2020   pk_12_total 173 207 150   * 54     *   47                             635 173 207 150     54         47                       635
1240962 1240962 MD     school 2400390 12   Harford 240039001638 187 Patterson Mill High School   Regular School No High 09 12 2020   pk_12_total 600 73 59     54     *   37                             825 600 73 59     54         37                       825
1242850 1242850 MD     school 2400480 15   Montgomery 240048001458 778 Sligo Middle   Regular School No Middle 06 08 2020   pk_12_total 198 134 308   * 54         27                             722 198 134 308     54         27                       722
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
1311080 1311080 MD     school 2400120 3   Baltimore County 240012000441 353 Sudbrook Magnet Middle   Regular School No Middle 06 08 2021   pk_12_total 105 574 213   * 54     *   22                             972 105 574 213     54         22                       972
1312713 1312713 MD     school 2400270 8   Charles 240027000615 621 Mattawoman Middle School   Regular School No Middle 06 08 2021   pk_12_total 37 756 116   * 54     *   56                             1024 37 756 116     54         56                       1024
1317744 1317744 MD     school 2400660 21   Washington 240066001275 2101 North Hagerstown High   Regular School No High 09 12 2021   pk_12_total 653 278 205   * 54     *   150                             1343 653 278 205     54         150                       1343
1242070 1242070 MD     school 2400480 15   Montgomery 240048001541 249 Clarksburg High   Regular School No High 09 12 2020   pk_12_total 424 743 653   * 539     *   108                             2472 424 743 653     539         108                       2472
1237726 1237726 MD     school 2400060 2   Anne Arundel 240006000090 3033 MacArthur Middle   Regular School No Middle 06 08 2020   pk_12_total 191 505 127   * 53     *   67                             959 191 505 127     53         67                       959
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
1310835 1310835 MD     school 2400120 3   Baltimore County 240012000410 105 Johnnycake Elementary   Regular School No Elementary PK 05 2021   pk_12_total 39 270 140   * 53     *   22                             531 39 270 140     53         22                       531
1313253 1313253 MD     school 2400330 10   Frederick 240033000807 2306 Orchard Grove Elementary   Regular School No Elementary PK 05 2021   pk_12_total 150 205 144   * 53     *   46                             603 150 205 144     53         46                       603
1313515 1313515 MD     school 2400390 12   Harford 240039001638 187 Patterson Mill High School   Regular School No High 09 12 2021   pk_12_total 599 69 58     53     *   54                             836 599 69 58     53         54                       836
1315096 1315096 MD     school 2400480 15   Montgomery 240048000916 555 Rosemont Elementary   Regular School No Elementary PK 05 2021   pk_12_total 45 186 278   * 53     *   34                             602 45 186 278     53         34                       602
1315401 1315401 MD     school 2400480 15   Montgomery 240048000907 773 Rock Creek Forest Elementary   Regular School No Elementary PK 05 2021   pk_12_total 237 139 258   * 53         45                             734 237 139 258     53         45                       734
1315506 1315506 MD     school 2400480 15   Montgomery 240048001207 792 Newport Mill Middle   Regular School No Middle 06 08 2021   pk_12_total 95 89 401   * 53         28                             670 95 89 401     53         28                       670
1315629 1315629 MD     school 2400480 15   Montgomery 240048001741 835 Silver Creek Middle   Regular School No Middle 06 08 2021   pk_12_total 395 191 154     53         45                             838 395 191 154     53         45                       838
1316078 1316078 MD     school 2400510 16   Prince George's 240051000982 714 Benjamin Tasker Middle School   Regular School No Middle 06 08 2021   pk_12_total 129 718 127   * 53     *   28                             1068 129 718 127     53         28                       1068
1241311 1241311 MD     school 2400420 13   Howard 240042000743 207 Mount Hebron High   Regular School No High 09 12 2020   pk_12_total 717 217 163   * 525     *   67                             1695 717 217 163     525         67                       1695
1240165 1240165 MD     school 2400270 8   Charles 240027000615 621 Mattawoman Middle School   Regular School No Middle 06 08 2020   pk_12_total 52 748 107   * 52     *   62                             1026 52 748 107     52         62                       1026

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