enrollments

Data source: Big Local News · About: Big Local

1,393 rows where grade = "pk_12_total", state = "MD" and year = 2021 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 1,293 ✖

grade ✖

  • pk_12_total · 1,293 ✖
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
1313421 1313421 MD     school 2400390 12   Harford 240039000715 113 William S. James Elementary   Regular School No Elementary KG 05 2021   pk_12_total 344 60 33     15         28                             480 344 60 33     15         28                       480
1313429 1313429 MD     school 2400390 12   Harford 240039000688 115 Edgewood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 92 190 39   * *     *   21                             349 92 190 39               21                       349
1313437 1313437 MD     school 2400390 12   Harford 240039000686 120 Deerfield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 168 352 92   * 12     *   93                             720 168 352 92     12         93                       720
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
1313452 1313452 MD     school 2400390 12   Harford 240039000162 123 Abingdon Elementary   Regular School No Elementary PK 05 2021   pk_12_total 357 150 44   * 19     *   73                             649 357 150 44     19         73                       649
1313460 1313460 MD     school 2400390 12   Harford 240039000468 125 Church Creek Elementary   Regular School No Elementary PK 05 2021   pk_12_total 231 284 59     24     *   79                             678 231 284 59     24         79                       678
1313468 1313468 MD     school 2400390 12   Harford 240039000706 131 Magnolia Elementary   Regular School No Elementary PK 05 2021   pk_12_total 47 336 52   * *         77                             517 47 336 52               77                       517
1313476 1313476 MD     school 2400390 12   Harford 240039000704 137 Joppatowne Elementary   Regular School No Elementary PK 05 2021   pk_12_total 286 146 53     *     *   45                             536 286 146 53               45                       536
1313484 1313484 MD     school 2400390 12   Harford 240039000716 140 William Paca/Old Post Road Elementary   Regular School No Elementary PK 05 2021   pk_12_total 199 378 150   * 11         89                             836 199 378 150     11         89                       836
1313492 1313492 MD     school 2400390 12   Harford 240039000713 143 Riverside Elementary   Regular School No Elementary PK 05 2021   pk_12_total 173 173 49   * *     *   38                             445 173 173 49               38                       445
1313497 1313497 MD     school 2400390 12   Harford 240039000690 176 Edgewood High   Regular School No High 09 12 2021   pk_12_total 412 678 169   * 43     *   102                             1413 412 678 169     43         102                       1413
1313501 1313501 MD     school 2400390 12   Harford 240039000689 177 Edgewood Middle   Regular School No Middle 06 08 2021   pk_12_total 353 532 157   * 24     *   113                             1186 353 532 157     24         113                       1186
1313506 1313506 MD     school 2400390 12   Harford 240039000705 181 Joppatowne High   Regular School No High 09 12 2021   pk_12_total 202 421 87   * *     *   61                             782 202 421 87               61                       782
1313510 1313510 MD     school 2400390 12   Harford 240039001352 184 Magnolia Middle   Regular School No Middle 06 08 2021   pk_12_total 209 405 109   * 14         73                             812 209 405 109     14         73                       812
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
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
1313527 1313527 MD     school 2400390 12   Harford 240039000700 211 G. Lisby Elementary at Hillsdale   Regular School No Elementary PK 05 2021   pk_12_total 131 186 40     *     *   57                             420 131 186 40               57                       420
1313535 1313535 MD     school 2400390 12   Harford 240039000680 212 Bakerfield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 137 126 69     *         42                             383 137 126 69               42                       383
1313543 1313543 MD     school 2400390 12   Harford 240039000693 230 Halls Cross Roads Elementary   Regular School No Elementary PK 05 2021   pk_12_total 102 213 37   * 10     *   63                             429 102 213 37     10         63                       429
1313547 1313547 MD     school 2400390 12   Harford 240039000678 265 Aberdeen Middle   Regular School No Middle 06 08 2021   pk_12_total 407 495 135   * 26     *   131                             1204 407 495 135     26         131                       1204
1313552 1313552 MD     school 2400390 12   Harford 240039000679 270 Aberdeen High   Regular School No High 09 12 2021   pk_12_total 498 576 140   10 85     *   125                             1441 498 576 140   10 85         125                       1441
1313560 1313560 MD     school 2400390 12   Harford 240039000480 292 Center for Educational Opportunity   Alternative School No High 06 12 2021   pk_12_total 79 48 *     *         14                             148 79 48                 14                       148
1313565 1313565 MD     school 2400390 12   Harford 240039000694 304 Harford Technical High   Career and Technical School No High 09 12 2021   pk_12_total 702 133 75   * 32     *   47                             993 702 133 75     32         47                       993
1313573 1313573 MD     school 2400390 12   Harford 240039000681 314 Bel Air Elementary   Regular School No Elementary PK 05 2021   pk_12_total 366 34 69   * 25         27                             522 366 34 69     25         27                       522
1313580 1313580 MD     school 2400390 12   Harford 240039000684 316 Churchville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 284 10 15   * *         25                             338 284 10 15               25                       338
1313587 1313587 MD     school 2400390 12   Harford 240039002948 326 Forest Hill Elementary   Regular School No Elementary KG 05 2021   pk_12_total 391 15 30     11     *   24                             472 391 15 30     11         24                       472
1313594 1313594 MD     school 2400390 12   Harford 240039000394 327 Fountain Green Elementary   Regular School No Elementary KG 05 2021   pk_12_total 349 39 26     21         23                             458 349 39 26     21         23                       458
1313601 1313601 MD     school 2400390 12   Harford 240039000692 328 Forest Lakes Elementary   Regular School No Elementary KG 05 2021   pk_12_total 360 15 24     *         25                             429 360 15 24               25                       429
1313609 1313609 MD     school 2400390 12   Harford 240039000712 329 Prospect Mill Elementary   Regular School No Elementary PK 05 2021   pk_12_total 381 53 48     39         45                             566 381 53 48     39         45                       566
1313616 1313616 MD     school 2400390 12   Harford 240039000698 333 Hickory Elementary   Regular School No Elementary KG 05 2021   pk_12_total 507 36 32     28     *   38                             643 507 36 32     28         38                       643
1313624 1313624 MD     school 2400390 12   Harford 240039000701 335 Homestead/Wakefield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 710 54 81   * 70     *   75                             996 710 54 81     70         75                       996
1313631 1313631 MD     school 2400390 12   Harford 240039090447 345 Ring Factory Elementary   Regular School No Elementary KG 05 2021   pk_12_total 411 32 19     24         34                             520 411 32 19     24         34                       520
1313639 1313639 MD     school 2400390 12   Harford 240039000717 348 Youths Benefit Elementary   Regular School No Elementary PK 05 2021   pk_12_total 942 22 44   * 27     *   37                             1082 942 22 44     27         37                       1082
1313646 1313646 MD     school 2400390 12   Harford 240039001698 349 Red Pump Elementary School   Regular School No Elementary KG 05 2021   pk_12_total 643 28 43     *         35                             758 643 28 43               35                       758
1313650 1313650 MD     school 2400390 12   Harford 240039001397 372 Bel Air Middle   Regular School No Middle 06 08 2021   pk_12_total 1067 113 90   * 106     *   61                             1441 1067 113 90     106         61                       1441
1313655 1313655 MD     school 2400390 12   Harford 240039000683 373 Bel Air High   Regular School No High 09 12 2021   pk_12_total 1146 121 102   * 119     *   63                             1557 1146 121 102     119         63                       1557
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
1313664 1313664 MD     school 2400390 12   Harford 240039000691 382 Fallston High   Regular School No High 09 12 2021   pk_12_total 838 35 41   * 25     *   35                             977 838 35 41     25         35                       977
1313669 1313669 MD     school 2400390 12   Harford 240039001380 385 C. Milton Wright High   Regular School No High 09 12 2021   pk_12_total 1026 100 68   * 72     *   61                             1330 1026 100 68     72         61                       1330
1313673 1313673 MD     school 2400390 12   Harford 240039090475 386 Fallston Middle School   Regular School No Middle 06 08 2021   pk_12_total 743 29 30   * 20         38                             864 743 29 30     20         38                       864
1313688 1313688 MD     school 2400390 12   Harford 240039000703 391 John Archer School   Special Education School No Other PK 12 2021   pk_12_total 65 41 16     *         10                             136 65 41 16               10                       136
1313695 1313695 MD     school 2400390 12   Harford 240039000702 436 Jarrettsville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 383 * 17           *   18                             426 383   17               18                       426
1313702 1313702 MD     school 2400390 12   Harford 240039000708 441 Norrisville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 192   *               *                             205 192                                           205
1313710 1313710 MD     school 2400390 12   Harford 240039090476 447 North Bend Elementary   Regular School No Elementary PK 05 2021   pk_12_total 338 * 12     *         19                             378 338   12               19                       378
1313717 1313717 MD     school 2400390 12   Harford 240039000685 518 Darlington Elementary   Regular School No Elementary KG 05 2021   pk_12_total 80 * *     *         *                             98 80                                           98
1313725 1313725 MD     school 2400390 12   Harford 240039000687 522 Dublin Elementary   Regular School No Elementary PK 05 2021   pk_12_total 192 * *               12                             215 192                   12                       215
1313732 1313732 MD     school 2400390 12   Harford 240039001443 544 North Harford Elementary   Regular School No Elementary KG 05 2021   pk_12_total 310 * *     *         12                             331 310                   12                       331
1313737 1313737 MD     school 2400390 12   Harford 240039000710 580 North Harford High   Regular School No High 09 12 2021   pk_12_total 1118 26 29   * 14         36                             1226 1118 26 29     14         36                       1226
1313741 1313741 MD     school 2400390 12   Harford 240039000709 583 North Harford Middle   Regular School No Middle 06 08 2021   pk_12_total 788 * 29   * *     *   37                             878 788   29               37                       878
1313749 1313749 MD     school 2400390 12   Harford 240039000695 632 Havre de Grace Elementary   Regular School No Elementary PK 05 2021   pk_12_total 315 122 61     10     *   66                             575 315 122 61     10         66                       575
1313757 1313757 MD     school 2400390 12   Harford 240039000707 638 Meadowvale Elementary   Regular School No Elementary PK 05 2021   pk_12_total 301 62 41   * *         44                             454 301 62 41               44                       454
1313765 1313765 MD     school 2400390 12   Harford 240039000711 639 Roye-Williams Elementary   Regular School No Elementary PK 05 2021   pk_12_total 164 110 74   * *     *   52                             410 164 110 74               52                       410
1313770 1313770 MD     school 2400390 12   Harford 240039000697 678 Havre de Grace High   Regular School No High 09 12 2021   pk_12_total 404 162 53   * 12     *   65                             699 404 162 53     12         65                       699
1313774 1313774 MD     school 2400390 12   Harford 240039000696 679 Havre de Grace Middle   Regular School No Middle 06 08 2021   pk_12_total 364 114 49   * *     *   78                             613 364 114 49               78                       613
1313781 1313781 MD     school 2400420 13   Howard 240042001189 80 Homewood School   Alternative School No High 07 12 2021   pk_12_total 36 64 12     *         *                             120 36 64 12                                       120
1313789 1313789 MD     school 2400420 13   Howard 240042000728 101 Elkridge Elementary   Regular School No Elementary PK 05 2021   pk_12_total 295 244 56   * 167     *   55                             819 295 244 56     167         55                       819
1313797 1313797 MD     school 2400420 13   Howard 240042090448 103 Deep Run Elementary   Regular School No Elementary PK 05 2021   pk_12_total 137 100 320   * 87         31                             680 137 100 320     87         31                       680
1313801 1313801 MD     school 2400420 13   Howard 240042090477 104 Mayfield Woods Middle   Regular School No Middle 06 08 2021   pk_12_total 191 218 226   * 117     *   37                             795 191 218 226     117         37                       795
1313809 1313809 MD     school 2400420 13   Howard 240042000396 105 Rockburn Elementary   Regular School No Elementary PK 05 2021   pk_12_total 277 91 36   * 168         35                             611 277 91 36     168         35                       611
1313813 1313813 MD     school 2400420 13   Howard 240042000633 106 Elkridge Landing Middle   Regular School No Middle 06 08 2021   pk_12_total 287 196 49   * 121     *   54                             710 287 196 49     121         54                       710
1313821 1313821 MD     school 2400420 13   Howard 240042000813 107 Ilchester Elementary   Regular School No Elementary PK 05 2021   pk_12_total 260 65 34   * 155     *   39                             556 260 65 34     155         39                       556
1313825 1313825 MD     school 2400420 13   Howard 240042001172 108 Bonnie Branch Middle   Regular School No Middle 06 08 2021   pk_12_total 236 166 96     142         53                             693 236 166 96     142         53                       693
1313833 1313833 MD     school 2400420 13   Howard 240042001717 109 Ducketts Lane   Regular School No Elementary PK 05 2021   pk_12_total 108 260 144   * 77     *   37                             630 108 260 144     77         37                       630
1313837 1313837 MD     school 2400420 13   Howard 240042001720 110 Thomas Viaduct   Regular School No Middle 06 08 2021   pk_12_total 123 389 159   * 120     *   41                             835 123 389 159     120         41                       835
1313845 1313845 MD     school 2400420 13   Howard 240042001749 111 Hanover Hills   Regular School No Elementary PK 05 2021   pk_12_total 90 319 117   * 198         43                             774 90 319 117     198         43                       774
1313849 1313849 MD     school 2400420 13   Howard 240042001444 202 Ellicott Mills Middle   Regular School No Middle 06 08 2021   pk_12_total 294 115 41   * 283     *   51                             789 294 115 41     283         51                       789
1313854 1313854 MD     school 2400420 13   Howard 240042000738 203 Howard High   Regular School No High 09 12 2021   pk_12_total 824 411 142   * 317     *   127                             1828 824 411 142     317         127                       1828
1313861 1313861 MD     school 2400420 13   Howard 240042000753 204 St. Johns Lane Elementary   Regular School No Elementary KG 05 2021   pk_12_total 249 87 34   * 278     *   28                             679 249 87 34     278         28                       679
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
1313873 1313873 MD     school 2400420 13   Howard 240042000744 208 Northfield Elementary   Regular School No Elementary KG 05 2021   pk_12_total 324 71 51   * 232     *   54                             736 324 71 51     232         54                       736
1313877 1313877 MD     school 2400420 13   Howard 240042000748 209 Patapsco Middle   Regular School No Middle 06 08 2021   pk_12_total 277 90 75   * 226     *   22                             693 277 90 75     226         22                       693
1313884 1313884 MD     school 2400420 13   Howard 240042000723 210 Centennial Lane Elementary   Regular School No Elementary KG 05 2021   pk_12_total 209 34 30   10 332         40                             655 209 34 30   10 332         40                       655
1313888 1313888 MD     school 2400420 13   Howard 240042000727 211 Dunloggin Middle   Regular School No Middle 06 08 2021   pk_12_total 201 127 56   * 213     *   25                             624 201 127 56     213         25                       624
1313896 1313896 MD     school 2400420 13   Howard 240042000764 213 Worthington Elementary   Regular School No Elementary PK 05 2021   pk_12_total 190 36 23   * 189         27                             467 190 36 23     189         27                       467
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
1313909 1313909 MD     school 2400420 13   Howard 240042090449 215 Waverly Elementary   Regular School No Elementary PK 05 2021   pk_12_total 276 62 33   * 475         48                             899 276 62 33     475         48                       899
1313913 1313913 MD     school 2400420 13   Howard 240042000173 216 Burleigh Manor Middle School   Regular School No Middle 06 08 2021   pk_12_total 267 93 45   * 391         44                             844 267 93 45     391         44                       844
1313920 1313920 MD     school 2400420 13   Howard 240042000856 217 Hollifield Station Elementary   Regular School No Elementary KG 05 2021   pk_12_total 172 105 100   * 359     *   26                             768 172 105 100     359         26                       768
1313928 1313928 MD     school 2400420 13   Howard 240042001551 218 Bellows Spring Elementary   Regular School No Elementary PK 05 2021   pk_12_total 154 187 65   * 221     *   42                             676 154 187 65     221         42                       676
1313936 1313936 MD     school 2400420 13   Howard 240042001646 219 Veterans Elementary   Regular School No Elementary PK 05 2021   pk_12_total 225 146 70   * 449     *   49                             951 225 146 70     449         49                       951
1313943 1313943 MD     school 2400420 13   Howard 240042000760 302 West Friendship Elementary   Regular School No Elementary KG 05 2021   pk_12_total 225 22 20     83     *   25                             376 225 22 20     83         25                       376
1313947 1313947 MD     school 2400420 13   Howard 240042000403 304 Mount View Middle   Regular School No Middle 06 08 2021   pk_12_total 356 47 32   * 348         49                             835 356 47 32     348         49                       835
1313954 1313954 MD     school 2400420 13   Howard 240042000488 305 Manor Woods Elementary   Regular School No Elementary KG 05 2021   pk_12_total 281 39 43   * 299         34                             697 281 39 43     299         34                       697
1313961 1313961 MD     school 2400420 13   Howard 240042001026 306 Triadelphia Ridge Elementary   Regular School No Elementary KG 05 2021   pk_12_total 258 47 30   * 163     *   38                             540 258 47 30     163         38                       540
1313965 1313965 MD     school 2400420 13   Howard 240042001552 307 Folly Quarter Middle   Regular School No Middle 06 08 2021   pk_12_total 326 46 34   * 211     *   41                             662 326 46 34     211         41                       662
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
1313975 1313975 MD     school 2400420 13   Howard 240042000731 404 Glenelg High   Regular School No High 09 12 2021   pk_12_total 888 52 77   * 179         65                             1263 888 52 77     179         65                       1263
1313979 1313979 MD     school 2400420 13   Howard 240042000732 405 Glenwood Middle   Regular School No Middle 06 08 2021   pk_12_total 367 29 40   * 48     *   24                             510 367 29 40     48         24                       510
1313987 1313987 MD     school 2400420 13   Howard 240042000721 406 Bushy Park Elementary   Regular School No Elementary PK 05 2021   pk_12_total 412 31 29   * 91     *   37                             602 412 31 29     91         37                       602
1313994 1313994 MD     school 2400420 13   Howard 240042000741 407 Lisbon Elementary   Regular School No Elementary KG 05 2021   pk_12_total 301 * 40     14         19                             377 301   40     14         19                       377
1314001 1314001 MD     school 2400420 13   Howard 240042000724 505 Clarksville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 143 91 44     201         22                             501 143 91 44     201         22                       501
1314006 1314006 MD     school 2400420 13   Howard 240042000719 509 Atholton High   Regular School No High 09 12 2021   pk_12_total 516 436 160   * 268         91                             1472 516 436 160     268         91                       1472
1314014 1314014 MD     school 2400420 13   Howard 240042000720 510 Bryant Woods Elementary   Regular School No Elementary PK 05 2021   pk_12_total 84 174 49   * 19     *   32                             360 84 174 49     19         32                       360
1314018 1314018 MD     school 2400420 13   Howard 240042000763 512 Wilde Lake Middle   Regular School No Middle 06 08 2021   pk_12_total 154 301 81     43         62                             641 154 301 81     43         62                       641
1314026 1314026 MD     school 2400420 13   Howard 240042000742 514 Longfellow Elementary   Regular School No Elementary PK 05 2021   pk_12_total 101 167 127   * 45     *   43                             485 101 167 127     45         43                       485
1314034 1314034 MD     school 2400420 13   Howard 240042000751 515 Running Brook Elementary   Regular School No Elementary PK 05 2021   pk_12_total 66 215 50   * 33     *   36                             402 66 215 50     33         36                       402
1314039 1314039 MD     school 2400420 13   Howard 240042000762 516 Wilde Lake High   Regular School No High 09 12 2021   pk_12_total 328 654 187   * 100     *   105                             1379 328 654 187     100         105                       1379
1314047 1314047 MD     school 2400420 13   Howard 240042000755 517 Swansfield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 115 260 57     34         35                             501 115 260 57     34         35                       501
1314051 1314051 MD     school 2400420 13   Howard 240042000737 518 Harpers Choice Middle   Regular School No Middle 06 08 2021   pk_12_total 92 241 74   * 38     *   43                             490 92 241 74     38         43                       490
1314058 1314058 MD     school 2400420 13   Howard 240042001382 520 Clemens Crossing Elementary   Regular School No Elementary KG 05 2021   pk_12_total 234 132 55   * 75     *   51                             549 234 132 55     75         51                       549

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