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,244 ✖
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
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
1241299 1241299 MD     school 2400420 13   Howard 240042000738 203 Howard High   Regular School No High 09 12 2020   pk_12_total 898 423 133   * 323     *   126                             1910 898 423 133     323         126                       1910
1241306 1241306 MD     school 2400420 13   Howard 240042000753 204 St. Johns Lane Elementary   Regular School No Elementary KG 05 2020   pk_12_total 329 99 43   * 260     *   31                             764 329 99 43     260         31                       764
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
1241318 1241318 MD     school 2400420 13   Howard 240042000744 208 Northfield Elementary   Regular School No Elementary KG 05 2020   pk_12_total 338 70 57   * 177         57                             702 338 70 57     177         57                       702
1241322 1241322 MD     school 2400420 13   Howard 240042000748 209 Patapsco Middle   Regular School No Middle 06 08 2020   pk_12_total 306 96 77     247     *   17                             746 306 96 77     247         17                       746
1241329 1241329 MD     school 2400420 13   Howard 240042000723 210 Centennial Lane Elementary   Regular School No Elementary KG 05 2020   pk_12_total 223 39 29   12 360         56                             719 223 39 29   12 360         56                       719
1241333 1241333 MD     school 2400420 13   Howard 240042000727 211 Dunloggin Middle   Regular School No Middle 06 08 2020   pk_12_total 237 105 40     217     *   27                             628 237 105 40     217         27                       628
1241341 1241341 MD     school 2400420 13   Howard 240042000764 213 Worthington Elementary   Regular School No Elementary PK 05 2020   pk_12_total 199 34 38   * 202         33                             508 199 34 38     202         33                       508
1241346 1241346 MD     school 2400420 13   Howard 240042000722 214 Centennial High   Regular School No High 09 12 2020   pk_12_total 630 146 73   * 651     *   90                             1597 630 146 73     651         90                       1597
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
1241358 1241358 MD     school 2400420 13   Howard 240042000173 216 Burleigh Manor Middle School   Regular School No Middle 06 08 2020   pk_12_total 242 85 34   * 404         41                             811 242 85 34     404         41                       811
1241365 1241365 MD     school 2400420 13   Howard 240042000856 217 Hollifield Station Elementary   Regular School No Elementary KG 05 2020   pk_12_total 212 117 108   * 401     *   28                             872 212 117 108     401         28                       872
1241373 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
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
1241388 1241388 MD     school 2400420 13   Howard 240042000760 302 West Friendship Elementary   Regular School No Elementary KG 05 2020   pk_12_total 251 21 16     79     *   25                             393 251 21 16     79         25                       393
1241392 1241392 MD     school 2400420 13   Howard 240042000403 304 Mount View Middle   Regular School No Middle 06 08 2020   pk_12_total 390 44 35   * 331         51                             853 390 44 35     331         51                       853
1241399 1241399 MD     school 2400420 13   Howard 240042000488 305 Manor Woods Elementary   Regular School No Elementary KG 05 2020   pk_12_total 215 44 33     314         21                             627 215 44 33     314         21                       627
1241406 1241406 MD     school 2400420 13   Howard 240042001026 306 Triadelphia Ridge Elementary   Regular School No Elementary KG 05 2020   pk_12_total 257 42 36   * 170     *   45                             555 257 42 36     170         45                       555
1241410 1241410 MD     school 2400420 13   Howard 240042001552 307 Folly Quarter Middle   Regular School No Middle 06 08 2020   pk_12_total 388 45 27   * 189     *   49                             700 388 45 27     189         49                       700
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
1241420 1241420 MD     school 2400420 13   Howard 240042000731 404 Glenelg High   Regular School No High 09 12 2020   pk_12_total 879 46 59   * 156     *   54                             1197 879 46 59     156         54                       1197
1241424 1241424 MD     school 2400420 13   Howard 240042000732 405 Glenwood Middle   Regular School No Middle 06 08 2020   pk_12_total 372 27 47   * 41         27                             515 372 27 47     41         27                       515
1241432 1241432 MD     school 2400420 13   Howard 240042000721 406 Bushy Park Elementary   Regular School No Elementary PK 05 2020   pk_12_total 455 32 26   * 90     *   31                             638 455 32 26     90         31                       638
1241439 1241439 MD     school 2400420 13   Howard 240042000741 407 Lisbon Elementary   Regular School No Elementary KG 05 2020   pk_12_total 353 * 40     16         29                             443 353   40     16         29                       443
1241446 1241446 MD     school 2400420 13   Howard 240042000724 505 Clarksville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 129 47 19     224         17                             436 129 47 19     224         17                       436
1241451 1241451 MD     school 2400420 13   Howard 240042000719 509 Atholton High   Regular School No High 09 12 2020   pk_12_total 580 369 137   * 287         85                             1460 580 369 137     287         85                       1460
1241459 1241459 MD     school 2400420 13   Howard 240042000720 510 Bryant Woods Elementary   Regular School No Elementary PK 05 2020   pk_12_total 94 244 56   * 15     *   37                             448 94 244 56     15         37                       448
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
1241471 1241471 MD     school 2400420 13   Howard 240042000742 514 Longfellow Elementary   Regular School No Elementary PK 05 2020   pk_12_total 110 149 102   * 34     *   49                             447 110 149 102     34         49                       447
1241479 1241479 MD     school 2400420 13   Howard 240042000751 515 Running Brook Elementary   Regular School No Elementary PK 05 2020   pk_12_total 102 256 52     27     *   46                             484 102 256 52     27         46                       484
1241484 1241484 MD     school 2400420 13   Howard 240042000762 516 Wilde Lake High   Regular School No High 09 12 2020   pk_12_total 337 630 175   * 110     *   94                             1351 337 630 175     110         94                       1351
1241492 1241492 MD     school 2400420 13   Howard 240042000755 517 Swansfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 70 311 108     39         34                             562 70 311 108     39         34                       562

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