enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 1,398 ✖

grade ✖

  • pk_12_total · 1,398 ✖
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
1244572 1244572 MD     school   16   Prince George's   2217 Incarcerated Youth Center (JACS)             2020   pk_12_total   * *                                             10                                             10
1245411 1245411 MD     school 2400720 23   Worcester 240072001498 312 Showell Elementary   Regular School No Elementary PK 03 2020   pk_12_total 462 15 29   * 17         31                             555 462 15 29     17         31                       555
1245401 1245401 MD     school 2400720 23   Worcester 240072001335 310 Stephen Decatur High   Regular School No High 09 12 2020   pk_12_total 1015 137 96   * 23     *   55                             1328 1015 137 96     23         55                       1328
1245387 1245387 MD     school 2400720 23   Worcester 240072001334 207 Snow Hill High   Regular School No High 09 12 2020   pk_12_total 199 74 17     *         20                             315 199 74 17               20                       315
1245393 1245393 MD     school 2400720 23   Worcester 240072001333 208 Snow Hill Middle   Regular School No Middle 04 08 2020   pk_12_total 250 112 19   * *         32                             420 250 112 19               32                       420
1245382 1245382 MD     school 2400720 23   Worcester 240072001332 205 Snow Hill Elementary   Regular School No Elementary PK 03 2020   pk_12_total 239 91 19   * *         30                             383 239 91 19               30                       383
1245370 1245370 MD     school 2400720 23   Worcester 240072001330 107 Pocomoke High   Regular School No High 09 12 2020   pk_12_total 161 144 18     *         24                             353 161 144 18               24                       353
1245376 1245376 MD     school 2400720 23   Worcester 240072001329 108 Pocomoke Middle   Regular School No Middle 04 08 2020   pk_12_total 166 186 22     *         21                             402 166 186 22               21                       402
1245365 1245365 MD     school 2400720 23   Worcester 240072001328 102 Pocomoke Elementary   Regular School No Elementary PK 03 2020   pk_12_total 178 195 32   * *         23                             434 178 195 32               23                       434
1245440 1245440 MD     school 2400720 23   Worcester 240072001327 1001 Ocean City Elementary   Regular School No Elementary PK 04 2020   pk_12_total 455 12 76     12         37                             592 455 12 76     12         37                       592
1245426 1245426 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2020   pk_12_total 28 19 *     *         *                             55 28 19                                         55
1245433 1245433 MD     school 2400720 23   Worcester 240072001325 901 Buckingham Elementary   Regular School No Elementary PK 04 2020   pk_12_total 296 131 70     *         55                             560 296 131 70               55                       560
1245405 1245405 MD     school 2400720 23   Worcester 240072001323 311 Berlin Intermediate   Regular School No Middle 04 06 2020   pk_12_total 584 63 73   * 19         59                             799 584 63 73     19         59                       799
1245396 1245396 MD     school 2400720 23   Worcester 240072000880 308 Stephen Decatur Middle   Regular School No Middle 07 08 2020   pk_12_total 496 57 68   * 14         49                             686 496 57 68     14         49                       686
1245341 1245341 MD     school 2400690 22   Wicomico 240069001322 1404 Willards Elementary   Regular School No Elementary PK 03 2020   pk_12_total 259 * 27   * *     *   27                             323 259   27               27                       323
1245258 1245258 MD     school 2400690 22   Wicomico 240069001320 513 Wicomico High   Regular School No High 09 12 2020   pk_12_total 323 535 112   * 31         74                             1079 323 535 112     31         74                       1079
1245249 1245249 MD     school 2400690 22   Wicomico 240069001319 510 Wicomico Middle   Regular School No Middle 06 08 2020   pk_12_total 198 419 156   * 16     *   77                             875 198 419 156     16         77                       875
1245345 1245345 MD     school 2400690 22   Wicomico 240069001318 1501 Westside Primary   Regular School No Elementary PK 01 2020   pk_12_total 148 31 19   * *         25                             229 148 31 19               25                       229
1245294 1245294 MD     school 2400690 22   Wicomico 240069001317 909 West Salisbury   Regular School No Elementary PK 02 2020   pk_12_total 52 189 65   * 15         25                             350 52 189 65     15         25                       350
1245289 1245289 MD     school 2400690 22   Wicomico 240069001315 907 Charles H. Chipman Elementary   Regular School No Elementary PK 01 2020   pk_12_total 47 206 17   * *         24                             301 47 206 17               24                       301
1245321 1245321 MD     school 2400690 22   Wicomico 240069001314 1306 Prince Street School   Regular School No Elementary PK 05 2020   pk_12_total 133 420 168   * 22     *   73                             824 133 420 168     22         73                       824
1245245 1245245 MD     school 2400690 22   Wicomico 240069001312 406 Pittsville Elementary & Middle   Regular School No Middle 04 08 2020   pk_12_total 340 14 21   * *         27                             406 340 14 21               27                       406
1245313 1245313 MD     school 2400690 22   Wicomico 240069001311 1305 Pinehurst Elementary   Regular School No Elementary PK 05 2020   pk_12_total 138 247 84   * 11     *   47                             534 138 247 84     11         47                       534
1245285 1245285 MD     school 2400690 22   Wicomico 240069001310 906 Pemberton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 127 313 30   * 27     *   62                             562 127 313 30     27         62                       562
1245335 1245335 MD     school 2400690 22   Wicomico 240069001309 1309 Parkside High   Regular School No High 09 12 2020   pk_12_total 590 351 52   * 35         54                             1083 590 351 52     35         54                       1083
1245239 1245239 MD     school 2400690 22   Wicomico 240069001308 106 Northwestern Elementary   Regular School No Elementary PK 05 2020   pk_12_total 256 26 10   * *         35                             334 256 26 10               35                       334
1245277 1245277 MD     school 2400690 22   Wicomico 240069001307 905 North Salisbury Elementary   Regular School No Elementary 03 05 2020   pk_12_total 166 168 54   * 40     *   35                             467 166 168 54     40         35                       467
1245231 1245231 MD     school 2400690 22   Wicomico 240069001306 102 Mardela Middle & High   Regular School No High 06 12 2020   pk_12_total 519 84 20   * *         47                             675 519 84 20               47                       675
1245326 1245326 MD     school 2400690 22   Wicomico 240069001305 1307 James M. Bennett High   Regular School No High 09 12 2020   pk_12_total 606 565 235   15 65     *   77                             1567 606 565 235   15 65         77                       1567
1245268 1245268 MD     school 2400690 22   Wicomico 240069001304 515 Glen Avenue School   Regular School No Elementary 02 05 2020   pk_12_total 92 246 41   * *     *   26                             416 92 246 41               26                       416
1245359 1245359 MD     school 2400690 22   Wicomico 240069001303 1602 Fruitland Intermediate   Regular School No Elementary 03 05 2020   pk_12_total 210 100 52   * 17         35                             416 210 100 52     17         35                       416
1245253 1245253 MD     school 2400690 22   Wicomico 240069001301 512 East Salisbury Elementary   Regular School No Elementary 03 05 2020   pk_12_total 102 213 81   * *         50                             451 102 213 81               50                       451
1245305 1245305 MD     school 2400690 22   Wicomico 240069001300 1103 Delmar Elementary   Regular School No Elementary PK 04 2020   pk_12_total 587 146 75   * 24     *   98                             932 587 146 75     24         98                       932
1245330 1245330 MD     school 2400690 22   Wicomico 240069001299 1308 Bennett Middle   Regular School No Middle 06 08 2020   pk_12_total 389 337 122   * 35     *   71                             965 389 337 122     35         71                       965
1245263 1245263 MD     school 2400690 22   Wicomico 240069001298 514 Beaver Run School   Regular School No Elementary PK 02 2020   pk_12_total 134 291 118   * *         53                             605 134 291 118               53                       605
1245355 1245355 MD     school 2400690 22   Wicomico 240069001151 1601 Fruitland Primary   Regular School No Elementary PK 02 2020   pk_12_total 251 119 50   * 19     *   50                             492 251 119 50     19         50                       492
1245350 1245350 MD     school 2400690 22   Wicomico 240069001149 1502 Westside Intermediate   Regular School No Elementary 02 05 2020   pk_12_total 267 64 23   *           33                             390 267 64 23               33                       390
1245298 1245298 MD     school 2400690 22   Wicomico 240069001145 910 Salisbury Middle   Regular School No Middle 06 08 2020   pk_12_total 234 427 62   * 42     *   51                             820 234 427 62     42         51                       820
1245273 1245273 MD     school 2400690 22   Wicomico 240069001088 520 Wicomico County Evening High   Alternative School No High 09 12 2020   pk_12_total 38 55 10     *         *                             107 38 55 10                                       107
1244961 1244961 MD     school 2400660 21   Washington 240066001740 190 Jonathan Hager Elementary   Regular School No Elementary PK 05 2020   pk_12_total 150 108 56   * *     *   55                             385 150 108 56               55                       385
1245011 1245011 MD     school 2400660 21   Washington 240066001707 328 Ruth Ann Monroe Primary   Regular School No Elementary PK 02 2020   pk_12_total 203 181 94   * 19         97                             596 203 181 94     19         97                       596
1244945 1244945 MD     school 2400660 21   Washington 240066001674 40 Barbara Ingram School for the Arts   Regular School No High 09 12 2020   pk_12_total 224 24 30     *         17                             303 224 24 30               17                       303
1245006 1245006 MD     school 2400660 21   Washington 240066001667 325 Rockland Woods Elementary   Regular School No Elementary PK 05 2020   pk_12_total 357 104 97   * 26     *   64                             652 357 104 97     26         64                       652
1245080 1245080 MD     school 2400660 21   Washington 240066001484 705 Washington County Job Development Center   Special Education School No High 12 12 2020   pk_12_total 23 * *               *                             33 23                                           33
1244978 1244978 MD     school 2400660 21   Washington 240066001295 204 Williamsport High   Regular School No High 09 12 2020   pk_12_total 663 79 105   * *         47                             903 663 79 105               47                       903
1244973 1244973 MD     school 2400660 21   Washington 240066001294 202 Williamsport Elementary   Regular School No Elementary PK 05 2020   pk_12_total 438 38 36   * *     *   49                             572 438 38 36               49                       572
1245177 1245177 MD     school 2400660 21   Washington 240066001293 2501 Western Heights Middle   Regular School No Middle 06 08 2020   pk_12_total 481 235 160     19         106                             1001 481 235 160     19         106                       1001
1244965 1244965 MD     school 2400660 21   Washington 240066001290 201 Springfield Middle   Regular School No Middle 06 08 2020   pk_12_total 623 77 104   * 13         48                             866 623 77 104     13         48                       866
1245199 1245199 MD     school 2400660 21   Washington 240066001289 2505 Marshall Street School   Special Education School No Other KG 12 2020   pk_12_total 25 * *     *         *                             43 25                                           43
1244983 1244983 MD     school 2400660 21   Washington 240066001288 301 South Hagerstown High   Regular School No High 09 12 2020   pk_12_total 586 358 167   * 50     *   179                             1345 586 358 167     50         179                       1345
1245078 1245078 MD     school 2400660 21   Washington 240066001287 704 Smithsburg Middle   Regular School No Middle 06 08 2020   pk_12_total 452 41 42   * 10         35                             582 452 41 42     10         35                       582
1245074 1245074 MD     school 2400660 21   Washington 240066001286 702 Smithsburg Elementary   Regular School No Elementary PK 05 2020   pk_12_total 318 14 21     *         25                             379 318 14 21               25                       379
1245066 1245066 MD     school 2400660 21   Washington 240066001285 701 Smithsburg High   Regular School No High 09 12 2020   pk_12_total 607 42 53   * 15     *   33                             753 607 42 53     15         33                       753
1244953 1244953 MD     school 2400660 21   Washington 240066001284 101 Sharpsburg Elementary   Regular School No Elementary PK 05 2020   pk_12_total 238 * *   *           *                             248 238                                           248
1245185 1245185 MD     school 2400660 21   Washington 240066001283 2503 Salem Avenue Elementary   Regular School No Elementary PK 05 2020   pk_12_total 308 180 132   * *     *   147                             772 308 180 132               147                       772
1245156 1245156 MD     school 2400660 21   Washington 240066001281 1805 Potomac Heights Elementary   Regular School No Elementary PK 05 2020   pk_12_total 167 44 50     *         48                             311 167 44 50               48                       311
1245108 1245108 MD     school 2400660 21   Washington 240066001280 1101 Pleasant Valley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 238 * *   * *         *                             262 238                                           262
1245148 1245148 MD     school 2400660 21   Washington 240066001278 1802 Pangborn Elementary   Regular School No Elementary PK 05 2020   pk_12_total 289 184 158   * 22         85                             739 289 184 158     22         85                       739
1245096 1245096 MD     school 2400660 21   Washington 240066001277 903 Old Forge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 299 10 13     *         12                             335 299 10 13               12                       335
1245173 1245173 MD     school 2400660 21   Washington 240066001276 2102 Northern Middle   Regular School No Middle 06 08 2020   pk_12_total 383 184 109     23     *   97                             799 383 184 109     23         97                       799
1245169 1245169 MD     school 2400660 21   Washington 240066001275 2101 North Hagerstown High   Regular School No High 09 12 2020   pk_12_total 687 259 183   * 50     *   129                             1311 687 259 183     50         129                       1311
1245116 1245116 MD     school 2400660 21   Washington 240066001274 1301 Maugansville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 462 99 107     22         59                             749 462 99 107     22         59                       749
1245207 1245207 MD     school 2400660 21   Washington 240066001273 2601 Lincolnshire Elementary   Regular School No Elementary PK 05 2020   pk_12_total 325 82 50     *         66                             529 325 82 50               66                       529
1245215 1245215 MD     school 2400660 21   Washington 240066001271 2602 Hickory Elementary   Regular School No Elementary PK 05 2020   pk_12_total 142 32 91     *         26                             293 142 32 91               26                       293
1245036 1245036 MD     school 2400660 21   Washington 240066001270 501 Hancock Middle Senior High   Regular School No High 06 12 2020   pk_12_total 236   *     *         *                             248 236                                           248
1245044 1245044 MD     school 2400660 21   Washington 240066001269 502 Hancock Elementary   Regular School No Elementary PK 05 2020   pk_12_total 220 * *   * *         *                             229 220                                           229
1245132 1245132 MD     school 2400660 21   Washington 240066001268 1602 Greenbrier Elementary   Regular School No Elementary PK 05 2020   pk_12_total 173 * *     18         *                             215 173         18                                 215
1245223 1245223 MD     school 2400660 21   Washington 240066001266 2701 Fountaindale Elementary   Regular School No Elementary PK 05 2020   pk_12_total 216 66 44     24         44                             394 216 66 44     24         44                       394
1245164 1245164 MD     school 2400660 21   Washington 240066001265 2002 Fountain Rock Elementary   Regular School No Elementary PK 05 2020   pk_12_total 250 * 19     *         *                             286 250   19                                       286
1244991 1244991 MD     school 2400660 21   Washington 240066001264 302 Emma K. Doub Elementary   Regular School No Elementary PK 05 2020   pk_12_total 215 56 44   * *         44                             368 215 56 44               44                       368
1244995 1244995 MD     school 2400660 21   Washington 240066001263 304 E. Russell Hicks Middle   Regular School No Middle 06 08 2020   pk_12_total 392 206 137     24         102                             861 392 206 137     24         102                       861
1245015 1245015 MD     school 2400660 21   Washington 240066001261 401 Clear Spring Middle   Regular School No Middle 06 08 2020   pk_12_total 312 * 23     *         15                             356 312   23               15                       356
1245028 1245028 MD     school 2400660 21   Washington 240066001260 403 Clear Spring High   Regular School No High 09 12 2020   pk_12_total 415 * 20     *         15                             460 415   20               15                       460
1245023 1245023 MD     school 2400660 21   Washington 240066001259 402 Clear Spring Elementary   Regular School No Elementary PK 05 2020   pk_12_total 389 * *               10                             411 389                   10                       411
1245124 1245124 MD     school 2400660 21   Washington 240066001258 1401 Cascade Elementary   Regular School No Elementary PK 05 2020   pk_12_total 139 * *     *         *                             150 139                                           150
1245049 1245049 MD     school 2400660 21   Washington 240066001256 601 Boonsboro High   Regular School No High 09 12 2020   pk_12_total 807 12 30   * 21         31                             902 807 12 30     21         31                       902
1245053 1245053 MD     school 2400660 21   Washington 240066001255 602 Boonsboro Middle   Regular School No Middle 06 08 2020   pk_12_total 602 29 26   * 18         26                             702 602 29 26     18         26                       702
1245061 1245061 MD     school 2400660 21   Washington 240066001254 603 Boonsboro Elementary   Regular School No Elementary PK 05 2020   pk_12_total 564 16 21     *     *   17                             622 564 16 21               17                       622
1245140 1245140 MD     school 2400660 21   Washington 240066001253 1701 Bester Elementary   Regular School No Elementary PK 05 2020   pk_12_total 210 145 90   * *         121                             570 210 145 90               121                       570
1245088 1245088 MD     school 2400660 21   Washington 240066000752 902 Paramount Elementary   Regular School No Elementary PK 05 2020   pk_12_total 240 61 46     28         36                             411 240 61 46     28         36                       411
1245100 1245100 MD     school 2400660 21   Washington 240066000418 1002 Eastern Elementary   Regular School No Elementary 03 05 2020   pk_12_total 152 123 72   * 14         71                             434 152 123 72     14         71                       434
1244998 1244998 MD     school 2400660 21   Washington 240066000308 305 Washington County Technical High   Career and Technical School No High 11 12 2020   pk_12_total 435 53 74   * 16     *   33                             613 435 53 74     16         33                       613
1244924 1244924 MD     school 2400630 20   Talbot 240063001252 302 White Marsh Elementary   Regular School No Elementary PK 05 2020   pk_12_total 217 56 44   * *         40                             367 217 56 44               40                       367
1244940 1244940 MD     school 2400630 20   Talbot 240063001250 501 Tilghman Elementary   Regular School No Elementary PK 05 2020   pk_12_total 89   *               *                             101 89                                           101
1244908 1244908 MD     school 2400630 20   Talbot 240063001248 202 St. Michaels Middle/High School   Regular School No High 06 12 2020   pk_12_total 333 41 31     *         22                             430 333 41 31               22                       430
1244916 1244916 MD     school 2400630 20   Talbot 240063001247 204 St. Michaels Elementary   Regular School No Elementary PK 05 2020   pk_12_total 200 55 28     *         15                             302 200 55 28               15                       302
1244896 1244896 MD     school 2400630 20   Talbot 240063001244 104 Easton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 309 219 423     26         62                             1039 309 219 423     26         62                       1039
1244900 1244900 MD     school 2400630 20   Talbot 240063001243 106 Easton Middle   Regular School No Middle 06 08 2020   pk_12_total 444 149 209     24     *   42                             869 444 149 209     24         42                       869
1244888 1244888 MD     school 2400630 20   Talbot 240063001242 101 Easton High   Regular School No High 09 12 2020   pk_12_total 682 189 267   * 24     *   60                             1224 682 189 267     24         60                       1224
1244932 1244932 MD     school 2400630 20   Talbot 240063001241 401 Chapel District Elementary   Regular School No Elementary PK 05 2020   pk_12_total 305 18 27     *         17                             371 305 18 27               17                       371
1244711 1244711 MD     school 2400600 18   Saint Mary's 240060001732 308 Captain Walter Francis Duke Elementary   Regular School No Elementary PK 05 2020   pk_12_total 438 41 23   * 16         43                             562 438 41 23     16         43                       562
1244761 1244761 MD     school 2400600 18   Saint Mary's 240060001685 606 Evergreen Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 515 86 100   * 35     *   75                             813 515 86 100     35         75                       813
1244835 1244835 MD     school 2400600 18   Saint Mary's 240060001639 813 Chesapeake Charter School   Regular School Yes Elementary KG 08 2020   pk_12_total 329 34 23     17         54                             457 329 34 23     17         54                       457
1244798 1244798 MD     school 2400600 18   Saint Mary's 240060001483 805 George Washington Carver Elementary   Regular School No Elementary PK 05 2020   pk_12_total 87 317 125   * *     *   59                             598 87 317 125               59                       598
1244723 1244723 MD     school 2400600 18   Saint Mary's 240060001399 501 Lettie Marshall Dent Elem   Regular School No Elementary PK 05 2020   pk_12_total 511 21 14   * *         27                             583 511 21 14               27                       583
1244703 1244703 MD     school 2400600 18   Saint Mary's 240060001356 306 Leonardtown High   Regular School No High 09 12 2020   pk_12_total 1426 163 103   * 60     *   128                             1889 1426 163 103     60         128                       1889
1244730 1244730 MD     school 2400600 18   Saint Mary's 240060001240 503 White Marsh Elementary   Regular School No Elementary KG 05 2020   pk_12_total 195 19 *     *         18                             242 195 19                 18                       242
1244805 1244805 MD     school 2400600 18   Saint Mary's 240060001239 806 Town Creek Elementary   Regular School No Elementary KG 05 2020   pk_12_total 142 29 14   * *         23                             216 142 29 14               23                       216
1244657 1244657 MD     school 2400600 18   Saint Mary's 240060001237 101 Spring Ridge Middle   Regular School No Middle 06 08 2020   pk_12_total 402 377 125   * 32     *   122                             1067 402 377 125     32         122                       1067
1244665 1244665 MD     school 2400600 18   Saint Mary's 240060001236 104 Ridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 186 29 15   *           35                             266 186 29 15               35                       266

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