enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 1,393 ✖

grade ✖

  • pk_12_total · 1,393 ✖
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
1317149 1317149 MD     school   16   Prince George's   2217 Incarcerated Youth Center (JACS)             2021   pk_12_total   * *               *                             11                                             11
1317987 1317987 MD     school 2400720 23   Worcester 240072001498 312 Showell Elementary   Regular School No Elementary PK 04 2021   pk_12_total 530 19 43   * 16         40                             649 530 19 43     16         40                       649
1317977 1317977 MD     school 2400720 23   Worcester 240072001335 310 Stephen Decatur High   Regular School No High 09 12 2021   pk_12_total 1046 121 105   * 25     *   70                             1369 1046 121 105     25         70                       1369
1317963 1317963 MD     school 2400720 23   Worcester 240072001334 207 Snow Hill High   Regular School No High 09 12 2021   pk_12_total 229 76 11   * *         18                             337 229 76 11               18                       337
1317969 1317969 MD     school 2400720 23   Worcester 240072001333 208 Snow Hill Middle   Regular School No Middle 04 08 2021   pk_12_total 232 116 18   * *         35                             407 232 116 18               35                       407
1317958 1317958 MD     school 2400720 23   Worcester 240072001332 205 Snow Hill Elementary   Regular School No Elementary PK 03 2021   pk_12_total 194 84 22   * *         28                             332 194 84 22               28                       332
1317946 1317946 MD     school 2400720 23   Worcester 240072001330 107 Pocomoke High   Regular School No High 09 12 2021   pk_12_total 151 152 25     *         17                             349 151 152 25               17                       349
1317952 1317952 MD     school 2400720 23   Worcester 240072001329 108 Pocomoke Middle   Regular School No Middle 04 08 2021   pk_12_total 160 217 20     10         23                             430 160 217 20     10         23                       430
1317941 1317941 MD     school 2400720 23   Worcester 240072001328 102 Pocomoke Elementary   Regular School No Elementary PK 03 2021   pk_12_total 173 178 41   * *         21                             416 173 178 41               21                       416
1318016 1318016 MD     school 2400720 23   Worcester 240072001327 1001 Ocean City Elementary   Regular School No Elementary PK 04 2021   pk_12_total 400 17 72     12         28                             529 400 17 72     12         28                       529
1318002 1318002 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2021   pk_12_total 27 16 *     *         *                             50 27 16                                         50
1318009 1318009 MD     school 2400720 23   Worcester 240072001325 901 Buckingham Elementary   Regular School No Elementary PK 04 2021   pk_12_total 254 130 57     *         47                             494 254 130 57               47                       494
1317980 1317980 MD     school 2400720 23   Worcester 240072001323 311 Berlin Intermediate   Regular School No Middle 05 06 2021   pk_12_total 458 59 69     17         55                             658 458 59 69     17         55                       658
1317972 1317972 MD     school 2400720 23   Worcester 240072000880 308 Stephen Decatur Middle   Regular School No Middle 07 08 2021   pk_12_total 484 59 75   * 13         58                             691 484 59 75     13         58                       691
1317917 1317917 MD     school 2400690 22   Wicomico 240069001322 1404 Willards Elementary   Regular School No Elementary PK 03 2021   pk_12_total 209 * 23   * *     *   22                             260 209   23               22                       260
1317834 1317834 MD     school 2400690 22   Wicomico 240069001320 513 Wicomico High   Regular School No High 09 12 2021   pk_12_total 306 592 178   * 32     *   77                             1190 306 592 178     32         77                       1190
1317825 1317825 MD     school 2400690 22   Wicomico 240069001319 510 Wicomico Middle   Regular School No Middle 06 08 2021   pk_12_total 189 372 155   * 17     *   86                             829 189 372 155     17         86                       829
1317921 1317921 MD     school 2400690 22   Wicomico 240069001318 1501 Westside Primary   Regular School No Elementary PK 01 2021   pk_12_total 109 24 22   * *         19                             181 109 24 22               19                       181
1317870 1317870 MD     school 2400690 22   Wicomico 240069001317 909 West Salisbury   Regular School No Elementary PK 02 2021   pk_12_total 50 169 50   * 12         23                             307 50 169 50     12         23                       307
1317865 1317865 MD     school 2400690 22   Wicomico 240069001315 907 Charles H. Chipman Elementary   Regular School No Elementary PK 01 2021   pk_12_total 33 142 17     *         23                             217 33 142 17               23                       217
1317897 1317897 MD     school 2400690 22   Wicomico 240069001314 1306 Prince Street School   Regular School No Elementary PK 05 2021   pk_12_total 107 396 151   * 16         55                             731 107 396 151     16         55                       731
1317821 1317821 MD     school 2400690 22   Wicomico 240069001312 406 Pittsville Elementary & Middle   Regular School No Middle 04 08 2021   pk_12_total 322 * 23   * *         29                             387 322   23               29                       387
1317889 1317889 MD     school 2400690 22   Wicomico 240069001311 1305 Pinehurst Elementary   Regular School No Elementary PK 05 2021   pk_12_total 114 249 60   * 10     *   52                             489 114 249 60     10         52                       489
1317861 1317861 MD     school 2400690 22   Wicomico 240069001310 906 Pemberton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 104 297 34   * 23     *   56                             517 104 297 34     23         56                       517
1317911 1317911 MD     school 2400690 22   Wicomico 240069001309 1309 Parkside High   Regular School No High 09 12 2021   pk_12_total 577 368 67   * 33         64                             1113 577 368 67     33         64                       1113
1317815 1317815 MD     school 2400690 22   Wicomico 240069001308 106 Northwestern Elementary   Regular School No Elementary PK 05 2021   pk_12_total 239 25 10   * *     *   27                             308 239 25 10               27                       308
1317853 1317853 MD     school 2400690 22   Wicomico 240069001307 905 North Salisbury Elementary   Regular School No Elementary 03 05 2021   pk_12_total 153 172 68   * 43     *   31                             471 153 172 68     43         31                       471
1317807 1317807 MD     school 2400690 22   Wicomico 240069001306 102 Mardela Middle & High   Regular School No High 06 12 2021   pk_12_total 515 74 26   * *         53                             674 515 74 26               53                       674
1317902 1317902 MD     school 2400690 22   Wicomico 240069001305 1307 James M. Bennett High   Regular School No High 09 12 2021   pk_12_total 575 475 155   * 68     *   77                             1362 575 475 155     68         77                       1362
1317844 1317844 MD     school 2400690 22   Wicomico 240069001304 515 Glen Avenue School   Regular School No Elementary 02 05 2021   pk_12_total 75 241 52   * *     *   30                             409 75 241 52               30                       409
1317935 1317935 MD     school 2400690 22   Wicomico 240069001303 1602 Fruitland Intermediate   Regular School No Elementary 03 05 2021   pk_12_total 196 108 55   * 23         34                             417 196 108 55     23         34                       417
1317829 1317829 MD     school 2400690 22   Wicomico 240069001301 512 East Salisbury Elementary   Regular School No Elementary 03 05 2021   pk_12_total 66 203 81   * *         46                             399 66 203 81               46                       399
1317881 1317881 MD     school 2400690 22   Wicomico 240069001300 1103 Delmar Elementary   Regular School No Elementary PK 04 2021   pk_12_total 505 158 68   * 33         78                             843 505 158 68     33         78                       843
1317906 1317906 MD     school 2400690 22   Wicomico 240069001299 1308 Bennett Middle   Regular School No Middle 06 08 2021   pk_12_total 380 351 137   * 34     *   68                             980 380 351 137     34         68                       980
1317839 1317839 MD     school 2400690 22   Wicomico 240069001298 514 Beaver Run School   Regular School No Elementary PK 02 2021   pk_12_total 125 263 97     *         56                             546 125 263 97               56                       546
1317931 1317931 MD     school 2400690 22   Wicomico 240069001151 1601 Fruitland Primary   Regular School No Elementary PK 02 2021   pk_12_total 181 102 31   * 13     *   48                             378 181 102 31     13         48                       378
1317926 1317926 MD     school 2400690 22   Wicomico 240069001149 1502 Westside Intermediate   Regular School No Elementary 02 05 2021   pk_12_total 229 67 27   * *         34                             363 229 67 27               34                       363
1317874 1317874 MD     school 2400690 22   Wicomico 240069001145 910 Salisbury Middle   Regular School No Middle 06 08 2021   pk_12_total 222 475 83   * 41     *   69                             897 222 475 83     41         69                       897
1317849 1317849 MD     school 2400690 22   Wicomico 240069001088 520 Wicomico County Evening High   Alternative School No High 09 12 2021   pk_12_total 24 46 11               *                             86 24 46 11                                       86
1317536 1317536 MD     school 2400660 21   Washington 240066001740 190 Jonathan Hager Elementary   Regular School No Elementary PK 05 2021   pk_12_total 129 114 56   * *     *   57                             372 129 114 56               57                       372
1317586 1317586 MD     school 2400660 21   Washington 240066001707 328 Ruth Ann Monroe Primary   Regular School No Elementary PK 02 2021   pk_12_total 176 178 99   * 22         79                             556 176 178 99     22         79                       556
1317520 1317520 MD     school 2400660 21   Washington 240066001674 40 Barbara Ingram School for the Arts   Regular School No High 09 12 2021   pk_12_total 240 35 24     14         20                             333 240 35 24     14         20                       333
1317581 1317581 MD     school 2400660 21   Washington 240066001667 325 Rockland Woods Elementary   Regular School No Elementary PK 05 2021   pk_12_total 323 112 91   * 19     *   55                             604 323 112 91     19         55                       604
1317655 1317655 MD     school 2400660 21   Washington 240066001484 705 Washington County Job Development Center   Special Education School No High 12 12 2021   pk_12_total 18 11 *               *                             34 18 11                                         34
1317553 1317553 MD     school 2400660 21   Washington 240066001295 204 Williamsport High   Regular School No High 09 12 2021   pk_12_total 660 74 104   * 10         52                             901 660 74 104     10         52                       901
1317548 1317548 MD     school 2400660 21   Washington 240066001294 202 Williamsport Elementary   Regular School No Elementary PK 05 2021   pk_12_total 371 37 41   * 11     *   53                             515 371 37 41     11         53                       515
1317752 1317752 MD     school 2400660 21   Washington 240066001293 2501 Western Heights Middle   Regular School No Middle 06 08 2021   pk_12_total 440 234 149     17     *   109                             950 440 234 149     17         109                       950
1317540 1317540 MD     school 2400660 21   Washington 240066001290 201 Springfield Middle   Regular School No Middle 06 08 2021   pk_12_total 581 90 104   * 14     *   68                             859 581 90 104     14         68                       859
1317775 1317775 MD     school 2400660 21   Washington 240066001289 2505 Marshall Street School   Special Education School No Other PK 12 2021   pk_12_total 24 * *     *         *                             41 24                                           41
1317558 1317558 MD     school 2400660 21   Washington 240066001288 301 South Hagerstown High   Regular School No High 09 12 2021   pk_12_total 582 351 212   * 47     *   187                             1381 582 351 212     47         187                       1381
1317653 1317653 MD     school 2400660 21   Washington 240066001287 704 Smithsburg Middle   Regular School No Middle 06 08 2021   pk_12_total 422 42 50   * 10         40                             565 422 42 50     10         40                       565
1317649 1317649 MD     school 2400660 21   Washington 240066001286 702 Smithsburg Elementary   Regular School No Elementary PK 05 2021   pk_12_total 270 10 17   *           22                             320 270 10 17               22                       320
1317641 1317641 MD     school 2400660 21   Washington 240066001285 701 Smithsburg High   Regular School No High 09 12 2021   pk_12_total 591 48 44     10     *   39                             734 591 48 44     10         39                       734
1317528 1317528 MD     school 2400660 21   Washington 240066001284 101 Sharpsburg Elementary   Regular School No Elementary PK 05 2021   pk_12_total 296 * *               *                             308 296                                           308
1317760 1317760 MD     school 2400660 21   Washington 240066001283 2503 Salem Avenue Elementary   Regular School No Elementary PK 05 2021   pk_12_total 261 166 125   * *     *   130                             687 261 166 125               130                       687
1317731 1317731 MD     school 2400660 21   Washington 240066001281 1805 Potomac Heights Elementary   Regular School No Elementary PK 05 2021   pk_12_total 159 57 52   * *         51                             323 159 57 52               51                       323
1317683 1317683 MD     school 2400660 21   Washington 240066001280 1101 Pleasant Valley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 183 * *   * *         *                             204 183                                           204
1317723 1317723 MD     school 2400660 21   Washington 240066001278 1802 Pangborn Elementary   Regular School No Elementary PK 05 2021   pk_12_total 243 177 158     16         96                             690 243 177 158     16         96                       690
1317671 1317671 MD     school 2400660 21   Washington 240066001277 903 Old Forge Elementary   Regular School No Elementary PK 05 2021   pk_12_total 265 * 17               11                             298 265   17               11                       298
1317748 1317748 MD     school 2400660 21   Washington 240066001276 2102 Northern Middle   Regular School No Middle 06 08 2021   pk_12_total 391 171 113   * 21     *   109                             809 391 171 113     21         109                       809
1317744 1317744 MD     school 2400660 21   Washington 240066001275 2101 North Hagerstown High   Regular School No High 09 12 2021   pk_12_total 653 278 205   * 54     *   150                             1343 653 278 205     54         150                       1343
1317691 1317691 MD     school 2400660 21   Washington 240066001274 1301 Maugansville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 394 97 115     22         56                             684 394 97 115     22         56                       684
1317783 1317783 MD     school 2400660 21   Washington 240066001273 2601 Lincolnshire Elementary   Regular School No Elementary PK 05 2021   pk_12_total 293 60 57     *         51                             466 293 60 57               51                       466
1317791 1317791 MD     school 2400660 21   Washington 240066001271 2602 Hickory Elementary   Regular School No Elementary PK 05 2021   pk_12_total 124 39 110     *         23                             297 124 39 110               23                       297
1317611 1317611 MD     school 2400660 21   Washington 240066001270 501 Hancock Middle Senior High   Regular School No High 06 12 2021   pk_12_total 226   *     *         *                             235 226                                           235
1317619 1317619 MD     school 2400660 21   Washington 240066001269 502 Hancock Elementary   Regular School No Elementary PK 05 2021   pk_12_total 205 * *     *         *                             213 205                                           213
1317707 1317707 MD     school 2400660 21   Washington 240066001268 1602 Greenbrier Elementary   Regular School No Elementary PK 05 2021   pk_12_total 170 11 11     18         10                             220 170 11 11     18         10                       220
1317799 1317799 MD     school 2400660 21   Washington 240066001266 2701 Fountaindale Elementary   Regular School No Elementary PK 05 2021   pk_12_total 194 67 39     22         37                             359 194 67 39     22         37                       359
1317739 1317739 MD     school 2400660 21   Washington 240066001265 2002 Fountain Rock Elementary   Regular School No Elementary PK 05 2021   pk_12_total 219 * 21     *         *                             258 219   21                                       258
1317566 1317566 MD     school 2400660 21   Washington 240066001264 302 Emma K. Doub Elementary   Regular School No Elementary PK 05 2021   pk_12_total 208 45 42   * *         43                             350 208 45 42               43                       350
1317570 1317570 MD     school 2400660 21   Washington 240066001263 304 E. Russell Hicks Middle   Regular School No Middle 06 08 2021   pk_12_total 395 215 157   * 31         91                             890 395 215 157     31         91                       890
1317590 1317590 MD     school 2400660 21   Washington 240066001261 401 Clear Spring Middle   Regular School No Middle 06 08 2021   pk_12_total 307 * 12     *         13                             340 307   12               13                       340
1317603 1317603 MD     school 2400660 21   Washington 240066001260 403 Clear Spring High   Regular School No High 09 12 2021   pk_12_total 424 * 22     *         14                             470 424   22               14                       470
1317598 1317598 MD     school 2400660 21   Washington 240066001259 402 Clear Spring Elementary   Regular School No Elementary PK 05 2021   pk_12_total 335 * *               *                             348 335                                           348
1317699 1317699 MD     school 2400660 21   Washington 240066001258 1401 Cascade Elementary   Regular School No Elementary PK 05 2021   pk_12_total 121 * *   * *         *                             130 121                                           130
1317624 1317624 MD     school 2400660 21   Washington 240066001256 601 Boonsboro High   Regular School No High 09 12 2021   pk_12_total 761 15 40   * 18         37                             873 761 15 40     18         37                       873
1317628 1317628 MD     school 2400660 21   Washington 240066001255 602 Boonsboro Middle   Regular School No Middle 06 08 2021   pk_12_total 541 24 28   * 14         23                             631 541 24 28     14         23                       631
1317636 1317636 MD     school 2400660 21   Washington 240066001254 603 Boonsboro Elementary   Regular School No Elementary PK 05 2021   pk_12_total 438 17 22     *     *   10                             491 438 17 22               10                       491
1317715 1317715 MD     school 2400660 21   Washington 240066001253 1701 Bester Elementary   Regular School No Elementary PK 05 2021   pk_12_total 176 131 85   * *         94                             491 176 131 85               94                       491
1317663 1317663 MD     school 2400660 21   Washington 240066000752 902 Paramount Elementary   Regular School No Elementary PK 05 2021   pk_12_total 221 60 54     27         32                             394 221 60 54     27         32                       394
1317675 1317675 MD     school 2400660 21   Washington 240066000418 1002 Eastern Elementary   Regular School No Elementary 03 05 2021   pk_12_total 141 118 81   * *         68                             418 141 118 81               68                       418
1317573 1317573 MD     school 2400660 21   Washington 240066000308 305 Washington County Technical High   Career and Technical School No High 11 12 2021   pk_12_total 409 33 73   * *     *   28                             554 409 33 73               28                       554
1317499 1317499 MD     school 2400630 20   Talbot 240063001252 302 White Marsh Elementary   Regular School No Elementary PK 05 2021   pk_12_total 184 39 28   * *         28                             286 184 39 28               28                       286
1317515 1317515 MD     school 2400630 20   Talbot 240063001250 501 Tilghman Elementary   Regular School No Elementary PK 05 2021   pk_12_total 81   *               *                             86 81                                           86
1317483 1317483 MD     school 2400630 20   Talbot 240063001248 202 St. Michaels Middle/High School   Regular School No High 06 12 2021   pk_12_total 320 44 32     *         19                             418 320 44 32               19                       418
1317491 1317491 MD     school 2400630 20   Talbot 240063001247 204 St. Michaels Elementary   Regular School No Elementary PK 05 2021   pk_12_total 217 54 32     *         20                             327 217 54 32               20                       327
1317471 1317471 MD     school 2400630 20   Talbot 240063001244 104 Easton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 304 217 424     33         70                             1048 304 217 424     33         70                       1048
1317475 1317475 MD     school 2400630 20   Talbot 240063001243 106 Easton Middle   Regular School No Middle 06 08 2021   pk_12_total 424 160 207     19         44                             854 424 160 207     19         44                       854
1317463 1317463 MD     school 2400630 20   Talbot 240063001242 101 Easton High   Regular School No High 09 12 2021   pk_12_total 655 160 263   * 29     *   61                             1170 655 160 263     29         61                       1170
1317507 1317507 MD     school 2400630 20   Talbot 240063001241 401 Chapel District Elementary   Regular School No Elementary PK 05 2021   pk_12_total 278 * 25     *         20                             335 278   25               20                       335
1317289 1317289 MD     school 2400600 18   Saint Mary's 240060001732 308 Captain Walter Francis Duke Elementary   Regular School No Elementary PK 05 2021   pk_12_total 408 39 22     12     *   45                             527 408 39 22     12         45                       527
1317339 1317339 MD     school 2400600 18   Saint Mary's 240060001685 606 Evergreen Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 483 81 78   * 39     *   58                             741 483 81 78     39         58                       741
1317413 1317413 MD     school 2400600 18   Saint Mary's 240060001639 813 Chesapeake Charter School   Regular School Yes Elementary KG 08 2021   pk_12_total 346 40 18     18         55                             477 346 40 18     18         55                       477
1317376 1317376 MD     school 2400600 18   Saint Mary's 240060001483 805 George Washington Carver Elementary   Regular School No Elementary PK 05 2021   pk_12_total 76 279 109     *     *   48                             519 76 279 109               48                       519
1317301 1317301 MD     school 2400600 18   Saint Mary's 240060001399 501 Lettie Marshall Dent Elem   Regular School No Elementary PK 05 2021   pk_12_total 468 22 19   * *         25                             541 468 22 19               25                       541
1317281 1317281 MD     school 2400600 18   Saint Mary's 240060001356 306 Leonardtown High   Regular School No High 09 12 2021   pk_12_total 1366 162 117   * 58     *   138                             1846 1366 162 117     58         138                       1846
1317308 1317308 MD     school 2400600 18   Saint Mary's 240060001240 503 White Marsh Elementary   Regular School No Elementary KG 05 2021   pk_12_total 170 20 12     *         15                             219 170 20 12               15                       219
1317383 1317383 MD     school 2400600 18   Saint Mary's 240060001239 806 Town Creek Elementary   Regular School No Elementary KG 05 2021   pk_12_total 128 26 17     *         24                             200 128 26 17               24                       200
1317235 1317235 MD     school 2400600 18   Saint Mary's 240060001237 101 Spring Ridge Middle   Regular School No Middle 06 08 2021   pk_12_total 417 366 128   * 33     *   118                             1067 417 366 128     33         118                       1067
1317243 1317243 MD     school 2400600 18   Saint Mary's 240060001236 104 Ridge Elementary   Regular School No Elementary PK 05 2021   pk_12_total 154 27 14   *           31                             227 154 27 14               31                       227

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