enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 9,515 ✖
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
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
1241970 1241970 MD     school 2400480 15   Montgomery 240048000904 227 Ritchie Park Elementary   Regular School No Elementary KG 05 2020   pk_12_total 206 51 49     63     *   31                             401 206 51 49     63         31                       401
1242434 1242434 MD     school 2400480 15   Montgomery 240048090479 514 Judith A. Resnik Elementary   Regular School No Elementary PK 05 2020   pk_12_total 84 175 251   * 63         28                             602 84 175 251     63         28                       602
1242731 1242731 MD     school 2400480 15   Montgomery 240048090480 747 Dr. Charles R. Drew Elementary   Regular School No Elementary PK 05 2020   pk_12_total 57 236 120   * 63     *   20                             498 57 236 120     63         20                       498
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
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
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
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
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
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
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
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
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
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
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
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
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
1242065 1242065 MD     school 2400480 15   Montgomery 240048000644 248 Forest Oak Middle   Regular School No Middle 06 08 2020   pk_12_total 95 228 547   * 52     *   26                             950 95 228 547     52         26                       950
1242317 1242317 MD     school 2400480 15   Montgomery 240048000779 420 Bannockburn Elementary   Regular School No Elementary KG 05 2020   pk_12_total 307 22 50     52         30                             461 307 22 50     52         30                       461
1242488 1242488 MD     school 2400480 15   Montgomery 240048001454 549 Flower Hill Elementary   Regular School No Elementary PK 05 2020   pk_12_total 31 126 221     52         28                             458 31 126 221     52         28                       458
1242557 1242557 MD     school 2400480 15   Montgomery 240048000944 561 Watkins Mill Elementary   Regular School No Elementary PK 05 2020   pk_12_total 23 181 443   * 52         28                             731 23 181 443     52         28                       731
1243858 1243858 MD     school 2400510 16   Prince George's 240051001208 1310 Dodge Park Elementary   Regular School No Elementary PK 06 2020   pk_12_total 17 330 193   * 52     *   *                             597 17 330 193     52                                 597
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
1242813 1242813 MD     school 2400480 15   Montgomery 240048000940 772 Viers Mill Elementary   Regular School No Elementary PK 05 2020   pk_12_total 60 54 399   * 51         14                             579 60 54 399     51         14                       579
1242926 1242926 MD     school 2400480 15   Montgomery 240048001207 792 Newport Mill Middle   Regular School No Middle 06 08 2020   pk_12_total 108 106 388   * 51         42                             702 108 106 388     51         42                       702
1237957 1237957 MD     school 2400060 2   Anne Arundel 240006000037 4013 Annapolis High   Regular School No High 09 12 2020   pk_12_total 635 560 790   * 50     *   62                             2103 635 560 790     50         62                       2103
1238653 1238653 MD     school 2400120 3   Baltimore County 240012000350 803 Lutherville Laboratory   Regular School No Elementary KG 05 2020   pk_12_total 186 68 35     50     *   28                             368 186 68 35     50         28                       368
1239125 1239125 MD     school 2400120 3   Baltimore County 240012000391 1404 Fullerton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 247 227 53   * 50     *   36                             617 247 227 53     50         36                       617
1242707 1242707 MD     school 2400480 15   Montgomery 240048001456 705 John T. Baker Middle School   Regular School No Middle 06 08 2020   pk_12_total 397 99 239     50     *   43                             830 397 99 239     50         43                       830
1244983 1244983 MD     school 2400660 21   Washington 240066001288 301 South Hagerstown High   Regular School No High 09 12 2020   pk_12_total 586 358 167   * 50     *   179                             1345 586 358 167     50         179                       1345
1245169 1245169 MD     school 2400660 21   Washington 240066001275 2101 North Hagerstown High   Regular School No High 09 12 2020   pk_12_total 687 259 183   * 50     *   129                             1311 687 259 183     50         129                       1311
1241381 1241381 MD     school 2400420 13   Howard 240042001646 219 Veterans Elementary   Regular School No Elementary PK 05 2020   pk_12_total 217 130 75   * 499     *   33                             962 217 130 75     499         33                       962
1237877 1237877 MD     school 2400060 2   Anne Arundel 240006000069 3272 Four Seasons Elementary   Regular School No Elementary PK 05 2020   pk_12_total 364 134 63   * 49     *   71                             684 364 134 63     49         71                       684
1238639 1238639 MD     school 2400120 3   Baltimore County 240012001432 772 Hereford High   Regular School No High 09 12 2020   pk_12_total 1120 31 56     49         39                             1295 1120 31 56     49         39                       1295
1241653 1241653 MD     school 2400420 13   Howard 240042001700 617 Lake Elkhorn Middle   Regular School No Middle 06 08 2020   pk_12_total 71 293 106     49         45                             564 71 293 106     49         45                       564
1242577 1242577 MD     school 2400480 15   Montgomery 240048000924 564 South Lake Elementary   Regular School No Elementary PK 05 2020   pk_12_total 10 176 632   * 49     *   23                             893 10 176 632     49         23                       893
1241354 1241354 MD     school 2400420 13   Howard 240042090449 215 Waverly Elementary   Regular School No Elementary PK 05 2020   pk_12_total 328 59 30   * 481         48                             951 328 59 30     481         48                       951
1237855 1237855 MD     school 2400060 2   Anne Arundel 240006000138 3222 Waugh Chapel Elementary   Regular School No Elementary PK 05 2020   pk_12_total 326 128 80   * 48     *   49                             633 326 128 80     48         49                       633
1237893 1237893 MD     school 2400060 2   Anne Arundel 240006000107 3333 Old Mill Middle North   Regular School No Middle 06 08 2020   pk_12_total 345 475 144   * 48     *   66                             1081 345 475 144     48         66                       1081
1239715 1239715 MD     school 2400210 6   Carroll 240021000552 707 Westminster High   Regular School No High 09 12 2020   pk_12_total 1289 60 69     48     *   55                             1522 1289 60 69     48         55                       1522
1240449 1240449 MD     school 2400330 10   Frederick 240033001357 227 Crestwood Middle   Regular School No Middle 06 08 2020   pk_12_total 202 199 197   * 48     *   40                             691 202 199 197     48         40                       691
1243498 1243498 MD     school 2400510 16   Prince George's 240051000982 714 Benjamin Tasker Middle School   Regular School No Middle 06 08 2020   pk_12_total 124 708 118   * 48     *   21                             1031 124 708 118     48         21                       1031
1243898 1243898 MD     school 2400510 16   Prince George's 240051001473 1330 Kenmoor Middle   Regular School No Middle 06 08 2020   pk_12_total 41 620 245   * 48     *   *                             964 41 620 245     48                                 964
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
1240405 1240405 MD     school 2400330 10   Frederick 240033000658 211 West Frederick Middle   Regular School No Middle 06 08 2020   pk_12_total 242 229 374     47     *   52                             947 242 229 374     47         52                       947
1240944 1240944 MD     school 2400390 12   Harford 240039000690 176 Edgewood High   Regular School No High 09 12 2020   pk_12_total 466 675 168   * 47     *   95                             1458 466 675 168     47         95                       1458
1241765 1241765 MD     school 2400480 15   Montgomery 240048000843 102 Germantown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 59 117 77   * 47     *   22                             324 59 117 77     47         22                       324
1242106 1242106 MD     school 2400480 15   Montgomery 240048001572 307 Roscoe R Nix Elementary   Regular School No Elementary PK 02 2020   pk_12_total 20 164 240   * 47     *   *                             482 20 164 240     47                                 482
1240688 1240688 MD     school 2400330 10   Frederick 240033090473 2302 Hillcrest Elementary   Regular School No Elementary PK 05 2020   pk_12_total 41 70 561     46         31                             749 41 70 561     46         31                       749
1240966 1240966 MD     school 2400390 12   Harford 240039001642 188 Patterson Mill Middle School   Regular School No Middle 06 08 2020   pk_12_total 537 63 59   * 46     *   53                             764 537 63 59     46         53                       764
1241852 1241852 MD     school 2400480 15   Montgomery 240048000185 156 Lois P. Rockwell Elementary   Regular School No Elementary PK 05 2020   pk_12_total 200 55 112   * 46     *   36                             452 200 55 112     46         36                       452
1242757 1242757 MD     school 2400480 15   Montgomery 240048000877 757 Montgomery Blair High   Regular School No High 09 12 2020   pk_12_total 770 779 1085   * 450     *   134                             3223 770 779 1085     450         134                       3223
1238586 1238586 MD     school 2400120 3   Baltimore County 240012000356 408 Cedarmere Elementary   Regular School No Elementary PK 05 2020   pk_12_total 98 209 165   * 45     *   19                             539 98 209 165     45         19                       539
1238832 1238832 MD     school 2400120 3   Baltimore County 240012001696 925 West Towson Elementary   Regular School No Elementary KG 05 2020   pk_12_total 329 41 21   * 45         49                             486 329 41 21     45         49                       486
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
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
1241750 1241750 MD     school 2400480 15   Montgomery 240048001494 100 Clopper Mill Elementary   Regular School No Elementary PK 05 2020   pk_12_total 32 190 254   * 45     *   15                             539 32 190 254     45         15                       539
1242374 1242374 MD     school 2400480 15   Montgomery 240048000950 504 Westover Elementary   Regular School No Elementary PK 05 2020   pk_12_total 59 117 71   * 45     *   22                             316 59 117 71     45         22                       316
1242797 1242797 MD     school 2400480 15   Montgomery 240048000873 770 Flora M. Singer Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 230 98 255   * 45         53                             683 230 98 255     45         53                       683
1239646 1239646 MD     school 2400210 6   Carroll 240021000529 506 Carrolltowne Elementary   Regular School No Elementary PK 05 2020   pk_12_total 472 13 30   * 44     *   29                             591 472 13 30     44         29                       591
1240680 1240680 MD     school 2400330 10   Frederick 240033001015 2107 Whittier Elementary   Regular School No Elementary PK 05 2020   pk_12_total 322 193 116   * 44     *   35                             718 322 193 116     44         35                       718
1241054 1241054 MD     school 2400390 12   Harford 240039000712 329 Prospect Mill Elementary   Regular School No Elementary PK 05 2020   pk_12_total 399 62 43     44         43                             591 399 62 43     44         43                       591

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