enrollments

Data source: Big Local News · About: Big Local

2,791 rows where grade = "pk_12_total" and state = "MD"

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pk_12_total · 2,276 ✖
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
1240633 1240633 MD     school 2400330 10   Frederick 240033000629 1509 Catoctin High   Regular School No High 09 12 2020   pk_12_total 672 * 38   * *     *   22                             749 672   38               22                       749
1240637 1240637 MD     school 2400330 10   Frederick 240033000651 1510 Thurmont Middle   Regular School No Middle 06 08 2020   pk_12_total 494 * 24   * *     *   15                             545 494   24               15                       545
1240642 1240642 MD     school 2400330 10   Frederick 240033001166 1511 Thurmont Primary   Regular School No Elementary PK 02 2020   pk_12_total 301   17     *     *   16                             336 301   17               16                       336
1240649 1240649 MD     school 2400330 10   Frederick 240033000642 1604 Myersville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 362 11 23   * *         18                             418 362 11 23               18                       418
1240657 1240657 MD     school 2400330 10   Frederick 240033000159 1801 Twin Ridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 396 * 46   * *         17                             473 396   46               17                       473
1240665 1240665 MD     school 2400330 10   Frederick 240033000636 2001 Lewistown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 139 * 35               14                             195 139   35               14                       195
1240672 1240672 MD     school 2400330 10   Frederick 240033000661 2103 Yellow Springs Elementary   Regular School No Elementary KG 05 2020   pk_12_total 275 97 41   * 19     *   32                             470 275 97 41     19         32                       470
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
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
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
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
1240705 1240705 MD     school 2400330 10   Frederick 240033001550 2307 Tuscarora High   Regular School No High 09 12 2020   pk_12_total 701 340 338   * 112     *   92                             1590 701 340 338     112         92                       1590
1240713 1240713 MD     school 2400330 10   Frederick 240033001748 2308 Butterfly Ridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 147 201 274     22     *   30                             675 147 201 274     22         30                       675
1240721 1240721 MD     school 2400330 10   Frederick 240033000657 2403 Waverley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 43 66 394   * 31         10                             548 43 66 394     31         10                       548
1240736 1240736 MD     school 2400330 10   Frederick 240033000647 2404 Rock Creek   Special Education School No Other PK 12 2020   pk_12_total 43 13 12     *         *                             74 43 13 12                                       74
1240741 1240741 MD     school 2400330 10   Frederick 240033000627 2503 Brunswick High   Regular School No High 09 12 2020   pk_12_total 604 50 74   * 13         50                             792 604 50 74     13         50                       792
1240749 1240749 MD     school 2400330 10   Frederick 240033000626 2504 Brunswick Elementary   Regular School No Elementary PK 05 2020   pk_12_total 535 68 93   * 17     *   45                             762 535 68 93     17         45                       762
1240753 1240753 MD     school 2400330 10   Frederick 240033001409 2525 Brunswick Middle   Regular School No Middle 06 08 2020   pk_12_total 403 44 74   * 10     *   40                             573 403 44 74     10         40                       573
1240757 1240757 MD     school 2400330 10   Frederick 240033000656 2606 Walkersville Middle   Regular School No Middle 06 08 2020   pk_12_total 570 108 117     24     *   56                             876 570 108 117     24         56                       876
1240765 1240765 MD     school 2400330 10   Frederick 240033000654 2607 Walkersville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 330 143 107   * 24     *   70                             678 330 143 107     24         70                       678
1240770 1240770 MD     school 2400330 10   Frederick 240033000655 2610 Walkersville High   Regular School No High 09 12 2020   pk_12_total 747 161 145   * 39     *   86                             1185 747 161 145     39         86                       1185
1240778 1240778 MD     school 2400330 10   Frederick 240033000620 2611 Glade Elementary   Regular School No Elementary PK 05 2020   pk_12_total 475 30 48   * 14         43                             611 475 30 48     14         43                       611
1240786 1240786 MD     school 2400360 11   Garrett 240036000667 1202 Friendsville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 133 * *               *                             142 133                                           142
1240794 1240794 MD     school 2400360 11   Garrett 240036000668 1301 Grantsville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 187   *                                             188 187                                           188
1240801 1240801 MD     school 2400360 11   Garrett 240036000665 1408 Crellin Elementary   Regular School No Elementary KG 05 2020   pk_12_total 127   *               *                             135 127                                           135
1240809 1240809 MD     school 2400360 11   Garrett 240036000662 1501 Accident Elementary   Regular School No Elementary PK 05 2020   pk_12_total 266   *               *                             281 266                                           281
1240817 1240817 MD     school 2400360 11   Garrett 240036000664 1707 Broad Ford Elementary   Regular School No Elementary PK 05 2020   pk_12_total 561 * *               *                             582 561                                           582
1240825 1240825 MD     school 2400360 11   Garrett 240036000852 1710 Yough Glades Elementary   Regular School No Elementary PK 05 2020   pk_12_total 295 * *               *                             308 295                                           308
1240835 1240835 MD     school 2400360 11   Garrett 240036000676 1812 Swan Meadow School   Regular School No Elementary KG 08 2020   pk_12_total 58   *                                             59 58                                           59
1240843 1240843 MD     school 2400360 11   Garrett 240036000673 1904 Route 40 Elementary   Regular School No Elementary PK 05 2020   pk_12_total 130   *               *                             133 130                                           133
1240847 1240847 MD     school 2400360 11   Garrett 240036001351 2511 Northern Middle School   Regular School No Middle 06 08 2020   pk_12_total 340   *               *                             357 340                                           357
1240851 1240851 MD     school 2400360 11   Garrett 240036000675 2708 Southern Middle School   Regular School No Middle 06 08 2020   pk_12_total 487 * *     *         12                             507 487                   12                       507
1240856 1240856 MD     school 2400360 11   Garrett 240036000671 3512 Northern Garrett High School   Regular School No High 09 12 2020   pk_12_total 426   *     *         *                             441 426                                           441
1240861 1240861 MD     school 2400360 11   Garrett 240036000674 3709 Southern Garrett High School   Regular School No High 09 12 2020   pk_12_total 670 * 12     *         15                             701 670   12               15                       701
1240868 1240868 MD     school 2400390 12   Harford 240039000715 113 William S. James Elementary   Regular School No Elementary KG 05 2020   pk_12_total 338 55 30   * 12         35                             472 338 55 30     12         35                       472
1240876 1240876 MD     school 2400390 12   Harford 240039000688 115 Edgewood Elementary   Regular School No Elementary PK 05 2020   pk_12_total 103 228 54   * *     *   16                             405 103 228 54               16                       405
1240884 1240884 MD     school 2400390 12   Harford 240039000686 120 Deerfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 194 370 83   * 17     *   84                             752 194 370 83     17         84                       752
1240891 1240891 MD     school 2400390 12   Harford 240039000485 121 Emmorton Elementary   Regular School No Elementary KG 05 2020   pk_12_total 383 59 38     71         41                             592 383 59 38     71         41                       592
1240899 1240899 MD     school 2400390 12   Harford 240039000162 123 Abingdon Elementary   Regular School No Elementary PK 05 2020   pk_12_total 416 161 55   * 24     *   66                             724 416 161 55     24         66                       724
1240907 1240907 MD     school 2400390 12   Harford 240039000468 125 Church Creek Elementary   Regular School No Elementary PK 05 2020   pk_12_total 273 263 58     24     *   77                             697 273 263 58     24         77                       697
1240915 1240915 MD     school 2400390 12   Harford 240039000706 131 Magnolia Elementary   Regular School No Elementary PK 05 2020   pk_12_total 54 356 61   * *         72                             550 54 356 61               72                       550
1240923 1240923 MD     school 2400390 12   Harford 240039000704 137 Joppatowne Elementary   Regular School No Elementary PK 05 2020   pk_12_total 353 152 52   * 11     *   46                             617 353 152 52     11         46                       617
1240931 1240931 MD     school 2400390 12   Harford 240039000716 140 William Paca/Old Post Road Elementary   Regular School No Elementary PK 05 2020   pk_12_total 210 386 158   10 13         88                             865 210 386 158   10 13         88                       865
1240939 1240939 MD     school 2400390 12   Harford 240039000713 143 Riverside Elementary   Regular School No Elementary PK 05 2020   pk_12_total 182 169 54   * 11     *   41                             462 182 169 54     11         41                       462
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
1240948 1240948 MD     school 2400390 12   Harford 240039000689 177 Edgewood Middle   Regular School No Middle 06 08 2020   pk_12_total 350 518 148   * 26     *   107                             1160 350 518 148     26         107                       1160
1240953 1240953 MD     school 2400390 12   Harford 240039000705 181 Joppatowne High   Regular School No High 09 12 2020   pk_12_total 197 383 88   * *     *   60                             745 197 383 88               60                       745
1240957 1240957 MD     school 2400390 12   Harford 240039001352 184 Magnolia Middle   Regular School No Middle 06 08 2020   pk_12_total 224 419 102   * 16         67                             831 224 419 102     16         67                       831
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
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
1240974 1240974 MD     school 2400390 12   Harford 240039000700 211 G. Lisby Elementary at Hillsdale   Regular School No Elementary PK 05 2020   pk_12_total 145 168 34     *     *   57                             413 145 168 34               57                       413
1240982 1240982 MD     school 2400390 12   Harford 240039000680 212 Bakerfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 143 141 82     15         45                             426 143 141 82     15         45                       426
1240990 1240990 MD     school 2400390 12   Harford 240039000693 230 Halls Cross Roads Elementary   Regular School No Elementary PK 05 2020   pk_12_total 106 239 46   * *     *   56                             454 106 239 46               56                       454
1240994 1240994 MD     school 2400390 12   Harford 240039000678 265 Aberdeen Middle   Regular School No Middle 06 08 2020   pk_12_total 411 488 131   * 26     *   139                             1203 411 488 131     26         139                       1203
1240999 1240999 MD     school 2400390 12   Harford 240039000679 270 Aberdeen High   Regular School No High 09 12 2020   pk_12_total 517 543 145   * 91     *   119                             1431 517 543 145     91         119                       1431
1241005 1241005 MD     school 2400390 12   Harford 240039000480 292 Center for Educational Opportunity   Alternative School No High 08 12 2020   pk_12_total 26 37 *     *         *                             74 26 37                                         74
1241010 1241010 MD     school 2400390 12   Harford 240039000694 304 Harford Technical High   Career and Technical School No High 09 12 2020   pk_12_total 698 145 81   * 34     *   38                             999 698 145 81     34         38                       999
1241018 1241018 MD     school 2400390 12   Harford 240039000681 314 Bel Air Elementary   Regular School No Elementary PK 05 2020   pk_12_total 378 37 68   * 24         22                             531 378 37 68     24         22                       531
1241025 1241025 MD     school 2400390 12   Harford 240039000684 316 Churchville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 326 11 10   *           22                             370 326 11 10               22                       370
1241032 1241032 MD     school 2400390 12   Harford 240039002948 326 Forest Hill Elementary   Regular School No Elementary KG 05 2020   pk_12_total 429 13 28     13         24                             507 429 13 28     13         24                       507
1241039 1241039 MD     school 2400390 12   Harford 240039000394 327 Fountain Green Elementary   Regular School No Elementary KG 05 2020   pk_12_total 374 32 28     29         21                             484 374 32 28     29         21                       484
1241046 1241046 MD     school 2400390 12   Harford 240039000692 328 Forest Lakes Elementary   Regular School No Elementary KG 05 2020   pk_12_total 383 * 25     *         22                             445 383   25               22                       445
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
1241061 1241061 MD     school 2400390 12   Harford 240039000698 333 Hickory Elementary   Regular School No Elementary KG 05 2020   pk_12_total 546 34 41     31     *   37                             691 546 34 41     31         37                       691
1241069 1241069 MD     school 2400390 12   Harford 240039000701 335 Homestead/Wakefield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 753 59 75   * 69     *   75                             1034 753 59 75     69         75                       1034
1241076 1241076 MD     school 2400390 12   Harford 240039090447 345 Ring Factory Elementary   Regular School No Elementary KG 05 2020   pk_12_total 426 31 24     20         38                             539 426 31 24     20         38                       539
1241083 1241083 MD     school 2400390 12   Harford 240039000717 348 Youths Benefit Elementary   Regular School No Elementary KG 05 2020   pk_12_total 939 14 40   * 24     *   34                             1057 939 14 40     24         34                       1057
1241090 1241090 MD     school 2400390 12   Harford 240039001698 349 Red Pump Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 660 25 35     12         40                             772 660 25 35     12         40                       772
1241094 1241094 MD     school 2400390 12   Harford 240039001397 372 Bel Air Middle   Regular School No Middle 06 08 2020   pk_12_total 1062 107 89   * 101     *   69                             1435 1062 107 89     101         69                       1435
1241099 1241099 MD     school 2400390 12   Harford 240039000683 373 Bel Air High   Regular School No High 09 12 2020   pk_12_total 1163 123 102   * 113     *   56                             1560 1163 123 102     113         56                       1560
1241103 1241103 MD     school 2400390 12   Harford 240039000682 374 Southampton Middle   Regular School No Middle 06 08 2020   pk_12_total 1007 75 62   * 42         73                             1261 1007 75 62     42         73                       1261
1241108 1241108 MD     school 2400390 12   Harford 240039000691 382 Fallston High   Regular School No High 09 12 2020   pk_12_total 839 39 36   * 21     *   35                             973 839 39 36     21         35                       973
1241113 1241113 MD     school 2400390 12   Harford 240039001380 385 C. Milton Wright High   Regular School No High 09 12 2020   pk_12_total 1059 97 68   * 82     *   51                             1363 1059 97 68     82         51                       1363
1241117 1241117 MD     school 2400390 12   Harford 240039090475 386 Fallston Middle School   Regular School No Middle 06 08 2020   pk_12_total 808 29 30   * 25         38                             934 808 29 30     25         38                       934
1241132 1241132 MD     school 2400390 12   Harford 240039000703 391 John Archer School   Special Education School No Other PK 12 2020   pk_12_total 64 36 11     *         *                             123 64 36 11                                       123
1241139 1241139 MD     school 2400390 12   Harford 240039000702 436 Jarrettsville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 408 * 14     *     *   18                             450 408   14               18                       450
1241146 1241146 MD     school 2400390 12   Harford 240039000708 441 Norrisville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 203   *     *     *   *                             218 203                                           218
1241154 1241154 MD     school 2400390 12   Harford 240039090476 447 North Bend Elementary   Regular School No Elementary PK 05 2020   pk_12_total 365 * 14     *         17                             402 365   14               17                       402
1241161 1241161 MD     school 2400390 12   Harford 240039000685 518 Darlington Elementary   Regular School No Elementary KG 05 2020   pk_12_total 91 * *     *         *                             104 91                                           104
1241169 1241169 MD     school 2400390 12   Harford 240039000687 522 Dublin Elementary   Regular School No Elementary PK 05 2020   pk_12_total 199 * 12               16                             230 199   12               16                       230
1241176 1241176 MD     school 2400390 12   Harford 240039001443 544 North Harford Elementary   Regular School No Elementary KG 05 2020   pk_12_total 353 * *     *         12                             373 353                   12                       373
1241181 1241181 MD     school 2400390 12   Harford 240039000710 580 North Harford High   Regular School No High 09 12 2020   pk_12_total 1138 29 32   * 15         37                             1254 1138 29 32     15         37                       1254
1241185 1241185 MD     school 2400390 12   Harford 240039000709 583 North Harford Middle   Regular School No Middle 06 08 2020   pk_12_total 851 * 20   * 11     *   33                             929 851   20     11         33                       929
1241193 1241193 MD     school 2400390 12   Harford 240039000695 632 Havre de Grace Elementary   Regular School No Elementary PK 05 2020   pk_12_total 326 130 60     14     *   78                             609 326 130 60     14         78                       609
1241201 1241201 MD     school 2400390 12   Harford 240039000707 638 Meadowvale Elementary   Regular School No Elementary PK 05 2020   pk_12_total 341 71 47   * *         54                             518 341 71 47               54                       518
1241209 1241209 MD     school 2400390 12   Harford 240039000711 639 Roye-Williams Elementary   Regular School No Elementary PK 05 2020   pk_12_total 202 126 90   * 10     *   59                             490 202 126 90     10         59                       490
1241214 1241214 MD     school 2400390 12   Harford 240039000697 678 Havre de Grace High   Regular School No High 09 12 2020   pk_12_total 380 161 50   * *     *   62                             662 380 161 50               62                       662
1241218 1241218 MD     school 2400390 12   Harford 240039000696 679 Havre de Grace Middle   Regular School No Middle 06 08 2020   pk_12_total 359 115 49   * *     *   67                             601 359 115 49               67                       601
1241226 1241226 MD     school 2400420 13   Howard 240042001189 80 Homewood School   Alternative School No High 06 12 2020   pk_12_total 30 70 14   * *         *                             122 30 70 14                                       122
1241234 1241234 MD     school 2400420 13   Howard 240042000728 101 Elkridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 342 244 76   * 186     *   71                             923 342 244 76     186         71                       923
1241242 1241242 MD     school 2400420 13   Howard 240042090448 103 Deep Run Elementary   Regular School No Elementary PK 05 2020   pk_12_total 162 110 348   * 99         42                             767 162 110 348     99         42                       767
1241246 1241246 MD     school 2400420 13   Howard 240042090477 104 Mayfield Woods Middle   Regular School No Middle 06 08 2020   pk_12_total 203 230 207   * 108     *   34                             787 203 230 207     108         34                       787
1241254 1241254 MD     school 2400420 13   Howard 240042000396 105 Rockburn Elementary   Regular School No Elementary PK 05 2020   pk_12_total 313 84 34   * 149         45                             628 313 84 34     149         45                       628
1241258 1241258 MD     school 2400420 13   Howard 240042000633 106 Elkridge Landing Middle   Regular School No Middle 06 08 2020   pk_12_total 334 197 62   * 121     *   46                             764 334 197 62     121         46                       764
1241266 1241266 MD     school 2400420 13   Howard 240042000813 107 Ilchester Elementary   Regular School No Elementary PK 05 2020   pk_12_total 350 52 24   * 167     *   38                             634 350 52 24     167         38                       634
1241270 1241270 MD     school 2400420 13   Howard 240042001172 108 Bonnie Branch Middle   Regular School No Middle 06 08 2020   pk_12_total 257 168 108   * 128         41                             703 257 168 108     128         41                       703
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
1241282 1241282 MD     school 2400420 13   Howard 240042001720 110 Thomas Viaduct   Regular School No Middle 06 08 2020   pk_12_total 105 342 130   * 112     *   42                             734 105 342 130     112         42                       734
1241290 1241290 MD     school 2400420 13   Howard 240042001749 111 Hanover Hills   Regular School No Elementary PK 05 2020   pk_12_total 111 299 121   * 178         41                             757 111 299 121     178         41                       757
1241294 1241294 MD     school 2400420 13   Howard 240042001444 202 Ellicott Mills Middle   Regular School No Middle 06 08 2020   pk_12_total 361 153 43   * 296     *   52                             909 361 153 43     296         52                       909

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