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_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
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
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
1314345 1314345 MD     school 2400480 15   Montgomery 240048001417 107 Martin Luther King Jr. Middle   Regular School No Middle 06 08 2021   pk_12_total 115 319 283   * 120         50                             888 115 319 283     120         50                       888
1315687 1315687 MD     school 2400510 16   Prince George's 240051001134 107 Frances Fuchs Early Childhood Center   Special Education School No Prekindergarten PK PK 2021   pk_12_total 11 100 117   * 14     *   *                             249 11 100 117     14                                 249
1317424 1317424 MD     school 2400570 19   Somerset 240057001743 107 Greenwood Elementary School   Regular School No Elementary 02 05 2021   pk_12_total 80 307 41     *         19                             454 80 307 41               19                       454
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
1312591 1312591 MD     school 2400270 8   Charles 240027000600 108 Maurice J. McDonough High School   Regular School No High 09 12 2021   pk_12_total 310 479 116   * 27     *   64                             999 310 479 116     27         64                       999
1312904 1312904 MD     school 2400330 10   Frederick 240033000628 108 Carroll Manor Elementary   Regular School No Elementary PK 05 2021   pk_12_total 368 57 73   * 16         23                             538 368 57 73     16         23                       538
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
1314353 1314353 MD     school 2400480 15   Montgomery 240048001448 108 Lake Seneca Elementary   Regular School No Elementary PK 05 2021   pk_12_total 51 166 193     24     *   26                             461 51 166 193     24         26                       461
1315701 1315701 MD     school 2400510 16   Prince George's 240051001354 108 James E. Duckworth Regional Center   Special Education School No Other KG 12 2021   pk_12_total * 34 57     *         *                             103   34 57                                       103
1317428 1317428 MD     school 2400570 19   Somerset 240057001742 108 Princess Anne Elementary School   Regular School No Elementary PK 01 2021   pk_12_total 62 207 34   * *         20                             325 62 207 34               20                       325
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
1312599 1312599 MD     school 2400270 8   Charles 240027000141 109 Mary H. Matula Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 227 190 42   * 28     *   42                             531 227 190 42     28         42                       531
1312912 1312912 MD     school 2400330 10   Frederick 240033001355 109 Tuscarora Elementary   Regular School No Elementary PK 05 2021   pk_12_total 192 184 192   * 66     *   64                             701 192 184 192     66         64                       701
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
1314361 1314361 MD     school 2400480 15   Montgomery 240048001508 109 Waters Landing Elementary   Regular School No Elementary PK 05 2021   pk_12_total 72 275 265   * 36     *   23                             673 72 275 265     36         23                       673
1315710 1315710 MD     school 2400510 16   Prince George's 240051001069 109 James H. Harrison Elementary   Regular School No Elementary PK 06 2021   pk_12_total 10 126 137     26         *                             304 10 126 137     26                                 304
1311927 1311927 MD     school 2400150 4   Calvert 240015000514 110 Mutual Elementary   Regular School No Elementary KG 05 2021   pk_12_total 243 39 15   *           33                             331 243 39 15               33                       331
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
1314369 1314369 MD     school 2400480 15   Montgomery 240048010502 110 S. Christa McAuliffe Elementary   Regular School No Elementary PK 05 2021   pk_12_total 70 207 204   * 45     *   35                             565 70 207 204     45         35                       565
1315714 1315714 MD     school 2400510 16   Prince George's 240051001101 110 Martin Luther King Jr. Middle   Regular School No Middle 06 08 2021   pk_12_total 31 443 413     69     *   20                             981 31 443 413     69         20                       981
1310850 1310850 MD     school 2400120 3   Baltimore County 240012000466 111 Maiden Choice School   Special Education School No Other PK 12 2021   pk_12_total 29 71 *     16         *                             130 29 71       16                                 130
1311931 1311931 MD     school 2400150 4   Calvert 240015001392 111 Southern Middle   Regular School No Middle 06 08 2021   pk_12_total 289 91 44   * *         40                             469 289 91 44               40                       469
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
1314377 1314377 MD     school 2400480 15   Montgomery 240048001523 111 Captain James E. Daly Elementary   Regular School No Elementary PK 05 2021   pk_12_total 27 186 308   * 38         17                             578 27 186 308     38         17                       578
1315722 1315722 MD     school 2400510 16   Prince George's 240051001660 111 Vansville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 30 391 193     92     *   25                             732 30 391 193     92         25                       732
1310858 1310858 MD     school 2400120 3   Baltimore County 240012002945 112 Dogwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 15 467 27   13 37     *   18                             578 15 467 27   13 37         18                       578
1310866 1310866 MD     school 2400120 3   Baltimore County 240012000357 113 Chadwick Elementary   Regular School No Elementary PK 05 2021   pk_12_total 35 283 75   * 240         10                             647 35 283 75     240         10                       647
1311936 1311936 MD     school 2400150 4   Calvert 240015000611 113 Patuxent High   Regular School No High 09 12 2021   pk_12_total 716 190 68   * 20         88                             1085 716 190 68     20         88                       1085
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
1311944 1311944 MD     school 2400150 4   Calvert 240015000778 114 St Leonard Elementary   Regular School No Elementary PK 05 2021   pk_12_total 282 81 55     *         55                             480 282 81 55               55                       480
1310874 1310874 MD     school 2400120 3   Baltimore County 240012000406 115 Hillcrest Elementary   Regular School No Elementary PK 05 2021   pk_12_total 387 74 80   * 123     *   26                             692 387 74 80     123         26                       692
1311952 1311952 MD     school 2400150 4   Calvert 240015001102 115 Dowell Elementary   Regular School No Elementary PK 05 2021   pk_12_total 374 46 32   * 15         59                             529 374 46 32     15         59                       529
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
1314381 1314381 MD     school 2400480 15   Montgomery 240048000759 115 Neelsville Middle   Regular School No Middle 06 08 2021   pk_12_total 54 235 420   * 98         32                             842 54 235 420     98         32                       842
1310882 1310882 MD     school 2400120 3   Baltimore County 240012000499 116 Woodbridge Elementary   Regular School No Elementary PK 05 2021   pk_12_total 35 128 72   * 184     *   *                             430 35 128 72     184                                 430
1311956 1311956 MD     school 2400150 4   Calvert 240015002946 116 Mill Creek Middle   Regular School No Middle 06 08 2021   pk_12_total 330 72 36   * *         47                             488 330 72 36               47                       488
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
1318461 1318461 MD     school 2400090 30   Baltimore City 240009000309 122 The Historic Samuel Coleridge-Taylor Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 218 *                                             220   218                                         220
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
1318472 1318472 MD     school 2400090 30   Baltimore City 240009000154 124 Bay-Brook Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 71 335 204     *     *   10                             622 71 335 204               10                       622
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
1314386 1314386 MD     school 2400480 15   Montgomery 240048001509 125 Quince Orchard High   Regular School No High 09 12 2021   pk_12_total 789 351 616   * 244     *   88                             2091 789 351 616     244         88                       2091
1318480 1318480 MD     school 2400090 30   Baltimore City 240009000211 125 Furman Templeton Preparatory Academy   Regular School Yes Elementary PK 05 2021   pk_12_total * 443 *   *       *   *                             450   443                                         450
1318484 1318484 MD     school 2400090 30   Baltimore City 240009000160 130 Booker T. Washington Middle   Regular School No Middle 06 08 2021   pk_12_total * 218 *                                             225   218                                         225
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
1318495 1318495 MD     school 2400090 30   Baltimore City 240009000328 134 Walter P. Carter Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 354 *   *           *                             371   354                                         371
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
1318503 1318503 MD     school 2400090 30   Baltimore City 240009000303 142 Robert W. Coleman Elementary   Regular School No Elementary PK 05 2021   pk_12_total   227 *                                             234   227                                         234
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
1318511 1318511 MD     school 2400090 30   Baltimore City 240009000255 144 James Mosher Elementary   Regular School No Elementary PK 05 2021   pk_12_total   208 *           *   *                             221   208                                         221
1318519 1318519 MD     school 2400090 30   Baltimore City 240009000145 145 Alexander Hamilton Elementary   Regular School No Elementary PK 05 2021   pk_12_total   154                 *                             156   154                                         156
1318527 1318527 MD     school 2400090 30   Baltimore City 240009000158 150 Mary Ann Winterling Elementary at Bentalou   Regular School No Elementary PK 05 2021   pk_12_total   179                 *                             185   179                                         185
1310886 1310886 MD     school 2400120 3   Baltimore County 240012000354 151 Catonsville Middle   Regular School No Middle 06 08 2021   pk_12_total 455 171 68   * 85     *   36                             821 455 171 68     85         36                       821
1314391 1314391 MD     school 2400480 15   Montgomery 240048000897 152 Poolesville High   Regular School No High 09 12 2021   pk_12_total 551 73 113   * 431         65                             1236 551 73 113     431         65                       1236
1314398 1314398 MD     school 2400480 15   Montgomery 240048000896 153 Poolesville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 280 37 71     45     *   40                             474 280 37 71     45         40                       474
1310890 1310890 MD     school 2400120 3   Baltimore County 240012000411 155 Southwest Academy   Regular School No Middle 06 08 2021   pk_12_total 31 513 109   * 111     *   28                             794 31 513 109     111         28                       794
1314402 1314402 MD     school 2400480 15   Montgomery 240048000181 155 Rosa M. Parks Middle   Regular School No Middle 06 08 2021   pk_12_total 465 135 121     85         58                             864 465 135 121     85         58                       864
1314410 1314410 MD     school 2400480 15   Montgomery 240048000185 156 Lois P. Rockwell Elementary   Regular School No Elementary PK 05 2021   pk_12_total 189 62 122   * 51     *   33                             460 189 62 122     51         33                       460
1314414 1314414 MD     school 2400480 15   Montgomery 240048000493 157 Roberto W. Clemente Middle   Regular School No Middle 06 08 2021   pk_12_total 120 304 359   * 203     *   51                             1040 120 304 359     203         51                       1040
1314422 1314422 MD     school 2400480 15   Montgomery 240048090455 158 Ronald McNair Elementary   Regular School No Elementary PK 05 2021   pk_12_total 136 235 148     221         60                             800 136 235 148     221         60                       800
1314430 1314430 MD     school 2400480 15   Montgomery 240048090454 159 Rachel Carson Elementary   Regular School No Elementary PK 05 2021   pk_12_total 363 55 168     149         57                             792 363 55 168     149         57                       792
1318534 1318534 MD     school 2400090 30   Baltimore City 240009000171 159 The Historic Cherry Hill Elementary/Middle   Regular School No Middle 03 08 2021   pk_12_total * 629 31   *           *                             674   629 31                                       674
1318539 1318539 MD     school 2400090 30   Baltimore City 240009000148 164 Arundel Elementary   Regular School No Elementary PK 02 2021   pk_12_total * 425 11               *                             445   425 11                                       445
1310895 1310895 MD     school 2400120 3   Baltimore County 240012000502 172 Woodlawn High   Regular School No High 09 12 2021   pk_12_total 48 1265 247   * 86     *   22                             1680 48 1265 247     86         22                       1680
1310900 1310900 MD     school 2400120 3   Baltimore County 240012000355 174 Catonsville High   Regular School No High 09 12 2021   pk_12_total 929 443 100   * 233     *   94                             1809 929 443 100     233         94                       1809
1310905 1310905 MD     school 2400120 3   Baltimore County 240012000248 175 Western School of Technology   Career and Technical School No High 09 12 2021   pk_12_total 136 514 48   * 190     *   28                             920 136 514 48     190         28                       920
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
1318543 1318543 MD     school 2400090 30   Baltimore City 240009000219 177 George W. F. McMechen High   Special Education School No High 10 12 2021   pk_12_total * 39 *               *                             44   39                                         44
1318548 1318548 MD     school 2400090 30   Baltimore City 240009001343 178 Excel Academy at Francis M. Wood High   Alternative School No High 09 12 2021   pk_12_total 11 453 *   *           *                             475 11 453                                         475
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
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
1311960 1311960 MD     school 2400150 4   Calvert 240015000507 201 Calvert Middle   Regular School No Middle 06 08 2021   pk_12_total 363 136 53   * 12         44                             611 363 136 53     12         44                       611
1312070 1312070 MD     school 2400180 5   Caroline 240018000522 201 Greensboro Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 325 27 347     *         39                             739 325 27 347               39                       739
1312919 1312919 MD     school 2400330 10   Frederick 240033000646 201 Parkway Elementary   Regular School No Elementary KG 05 2021   pk_12_total 126 31 39   * *         17                             223 126 31 39               17                       223
1314435 1314435 MD     school 2400480 15   Montgomery 240048000902 201 Richard Montgomery High   Regular School No High 09 12 2021   pk_12_total 699 399 577   * 586     *   143                             2410 699 399 577     586         143                       2410
1317251 1317251 MD     school 2400600 18   Saint Mary's 240060001235 201 Piney Point Elementary   Regular School No Elementary PK 05 2021   pk_12_total 300 36 14   * *         51                             406 300 36 14               51                       406
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
1318559 1318559 MD     school 2400090 30   Baltimore City 240009000186 201 Dickey Hill Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 273 *     *         *                             286   273                                         286
1310912 1310912 MD     school 2400120 3   Baltimore County 240012000457 202 Randallstown Elementary   Regular School No Elementary KG 05 2021   pk_12_total * 334 28     *     *   12                             384   334 28               12                       384
1312137 1312137 MD     school 2400210 6   Carroll 240021000533 202 Francis Scott Key High   Regular School No High 09 12 2021   pk_12_total 767 25 48   * *     *   35                             885 767 25 48               35                       885
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
1317175 1317175 MD     school 2400540 17   Queen Anne's 240054001192 202 Church Hill Elementary School   Regular School No Elementary PK 04 2021   pk_12_total 177 18 35               22                             252 177 18 35               22                       252
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
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
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
1315733 1315733 MD     school 2400510 16   Prince George's 240051000414 203 Judith P. Hoyer Montessori   Regular School No Elementary PK 08 2021   pk_12_total 32 316 19   * *     *   *                             382 32 316 19                                       382
1318570 1318570 MD     school 2400090 30   Baltimore City 240009001363 203 Maree Garnett Farring Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 139 192 349   * 10     *   13                             706 139 192 349     10         13                       706
1310920 1310920 MD     school 2400120 3   Baltimore County 240012000385 204 Featherbed Lane Elementary   Regular School No Elementary PK 05 2021   pk_12_total 11 359 71   * *     *   21                             473 11 359 71               21                       473
1312145 1312145 MD     school 2400210 6   Carroll 240021000368 204 Runnymede Elementary   Regular School No Elementary PK 05 2021   pk_12_total 492 18 21   * *         24                             562 492 18 21               24                       562
1312397 1312397 MD     school 2400240 7   Cecil 240024000558 204 Bohemia Manor High   Regular School No High 09 12 2021   pk_12_total 513 37 54   * *     *   23                             632 513 37 54               23                       632
1312927 1312927 MD     school 2400330 10   Frederick 240033000649 204 Lincoln Elementary   Regular School No Elementary PK 05 2021   pk_12_total 95 213 213   * 22         59                             605 95 213 213     22         59                       605
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

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