enrollments

Data source: Big Local News · About: Big Local

9,598 rows where state = "MD" and year = 2021 sorted by native_american_alaskan_native_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 9,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
1311773 1311773 MD     school 2400120 3   Baltimore County 240012000363 1511 Chesapeake Terrace Elementary   Regular School No Elementary PK 05 2021   pk_12_total 253 * *   * *         *                             273 253                                           273
1311781 1311781 MD     school 2400120 3   Baltimore County 240012000424 1512 Mars Estates Elementary   Regular School No Elementary PK 05 2021   pk_12_total 67 195 51   * *     *   24                             346 67 195 51               24                       346
1311789 1311789 MD     school 2400120 3   Baltimore County 240012000482 1513 Sussex Elementary   Regular School No Elementary PK 05 2021   pk_12_total 149 142 75   * *         52                             425 149 142 75               52                       425
1311805 1311805 MD     school 2400120 3   Baltimore County 240012000401 1515 Hawthorne Elementary   Regular School No Elementary PK 05 2021   pk_12_total 99 249 42   * *         43                             442 99 249 42               43                       442
1311813 1311813 MD     school 2400120 3   Baltimore County 240012000345 1517 Battle Grove Elementary   Regular School No Elementary PK 05 2021   pk_12_total 155 74 58   * *     *   42                             334 155 74 58               42                       334
1311821 1311821 MD     school 2400120 3   Baltimore County 240012001372 1518 Glenmar Elementary   Regular School No Elementary PK 05 2021   pk_12_total 28 180 36   * 27         *                             282 28 180 36     27                                 282
1311829 1311829 MD     school 2400120 3   Baltimore County 240012000437 1519 Orems Elementary   Regular School No Elementary PK 05 2021   pk_12_total 179 73 56   * 24         26                             363 179 73 56     24         26                       363
1311837 1311837 MD     school 2400120 3   Baltimore County 240012000429 1520 Middleborough Elementary   Regular School No Elementary PK 05 2021   pk_12_total 200 66 14   * *         22                             306 200 66 14               22                       306
1311844 1311844 MD     school 2400120 3   Baltimore County 240012000369 1525 Deep Creek Elementary   Regular School No Elementary KG 05 2021   pk_12_total 48 301 32   * *     *   39                             426 48 301 32               39                       426
1311852 1311852 MD     school 2400120 3   Baltimore County 240012000469 1527 Sandalwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 36 334 74   *           32                             479 36 334 74               32                       479
1311860 1311860 MD     school 2400120 3   Baltimore County 240012000472 1531 Seneca Elementary   Regular School No Elementary PK 05 2021   pk_12_total 169 157 16   * *     *   36                             389 169 157 16               36                       389
1311868 1311868 MD     school 2400120 3   Baltimore County 240012001653 1533 Vincent Farm Elementary   Regular School No Elementary PK 05 2021   pk_12_total 253 330 50   * 66     *   41                             742 253 330 50     66         41                       742
1311884 1311884 MD     school 2400120 3   Baltimore County 240012001440 1556 Middle River Middle   Regular School No Middle 06 08 2021   pk_12_total 355 540 124   * 32     *   77                             1132 355 540 124     32         77                       1132
1311888 1311888 MD     school 2400120 3   Baltimore County 240012000370 1557 Deep Creek Middle   Regular School No Middle 06 08 2021   pk_12_total 182 546 106   * *     *   60                             907 182 546 106               60                       907
1311892 1311892 MD     school 2400120 3   Baltimore County 240012010500 1559 Sparrows Point Middle   Regular School No Middle 06 08 2021   pk_12_total 506 46 33   * *     *   31                             630 506 46 33               31                       630
1311897 1311897 MD     school 2400120 3   Baltimore County 240012000412 1572 Kenwood High   Regular School No High 09 12 2021   pk_12_total 623 705 194   * 44     *   103                             1679 623 705 194     44         103                       1679
1311902 1311902 MD     school 2400120 3   Baltimore County 240012000477 1573 Sparrows Point High   Regular School No High 09 12 2021   pk_12_total 877 87 70   * 14     *   43                             1097 877 87 70     14         43                       1097
1311907 1311907 MD     school 2400120 3   Baltimore County 240012000362 1574 Chesapeake High   Regular School No High 09 12 2021   pk_12_total 251 553 116   * 12     *   51                             988 251 553 116     12         51                       988
1311912 1311912 MD     school 2400120 3   Baltimore County 240012000379 1575 Eastern Technical High School   Career and Technical School No High 09 12 2021   pk_12_total 577 243 56   * 272     *   53                             1207 577 243 56     272         53                       1207
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
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
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
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
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
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
1311972 1311972 MD     school 2400150 4   Calvert 240015000509 206 Calvert Country School   Special Education School No Other 03 12 2021   pk_12_total 23 *     * *         *                             38 23                                           38
1311980 1311980 MD     school 2400150 4   Calvert 240015000517 207 Calvert Elementary   Regular School No Elementary PK 05 2021   pk_12_total 307 100 25   *           61                             496 307 100 25               61                       496
1312001 1312001 MD     school 2400150 4   Calvert 240015000508 213 Calvert High   Regular School No High 09 12 2021   pk_12_total 696 222 89   * 24     *   96                             1132 696 222 89     24         96                       1132
1312018 1312018 MD     school 2400150 4   Calvert 240015001342 217 Huntingtown High School   Regular School No High 09 12 2021   pk_12_total 1060 134 80   * 22         100                             1398 1060 134 80     22         100                       1398
1312026 1312026 MD     school 2400150 4   Calvert 240015000505 302 Beach Elementary   Regular School No Elementary PK 05 2021   pk_12_total 313 51 42   * *     *   73                             483 313 51 42               73                       483
1312033 1312033 MD     school 2400150 4   Calvert 240015000513 312 Mount Harmony Elementary   Regular School No Elementary KG 05 2021   pk_12_total 407 59 56   * 20         51                             595 407 59 56     20         51                       595
1312038 1312038 MD     school 2400150 4   Calvert 240015000516 314 Northern High   Regular School No High 09 12 2021   pk_12_total 1096 166 87   * 33     *   94                             1483 1096 166 87     33         94                       1483
1312042 1312042 MD     school 2400150 4   Calvert 240015000515 315 Northern Middle   Regular School No Middle 06 08 2021   pk_12_total 510 62 26   * 15     *   56                             672 510 62 26     15         56                       672
1312058 1312058 MD     school 2400150 4   Calvert 240015000790 317 Windy Hill Elementary   Regular School No Elementary PK 05 2021   pk_12_total 447 50 50   * 12     *   76                             637 447 50 50     12         76                       637
1312062 1312062 MD     school 2400150 4   Calvert 240015000967 318 Windy Hill Middle   Regular School No Middle 06 08 2021   pk_12_total 517 89 54   * *     *   77                             746 517 89 54               77                       746
1312090 1312090 MD     school 2400180 5   Caroline 240018000524 401 Preston Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 265 39 28   * *         32                             368 265 39 28               32                       368
1312098 1312098 MD     school 2400180 5   Caroline 240018000521 501 Federalsburg Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 166 163 18   * *         45                             399 166 163 18               45                       399
1312106 1312106 MD     school 2400180 5   Caroline 240018000525 701 Ridgely Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 301 43 35   * *         40                             421 301 43 35               40                       421
1312111 1312111 MD     school 2400180 5   Caroline 240018000523 703 North Caroline High School   Regular School No High 09 12 2021   pk_12_total 743 113 213   * 10     *   81                             1164 743 113 213     10         81                       1164
1312120 1312120 MD     school 2400180 5   Caroline 240018000519 802 Colonel Richardson Middle School   Regular School No Middle 06 08 2021   pk_12_total 226 101 28   * *     *   38                             404 226 101 28               38                       404
1312128 1312128 MD     school 2400210 6   Carroll 240021000548 103 Taneytown Elementary   Regular School No Elementary PK 05 2021   pk_12_total 298 20 34   * *     *   14                             374 298 20 34               14                       374
1312132 1312132 MD     school 2400210 6   Carroll 240021000543 105 Northwest Middle   Regular School No Middle 06 08 2021   pk_12_total 534 26 30   * *         46                             645 534 26 30               46                       645
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
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
1312177 1312177 MD     school 2400210 6   Carroll 240021000977 503 Linton Springs Elementary   Regular School No Elementary PK 05 2021   pk_12_total 577 13 38   * 19     *   20                             674 577 13 38     19         20                       674
1312181 1312181 MD     school 2400210 6   Carroll 240021000547 504 Sykesville Middle   Regular School No Middle 06 08 2021   pk_12_total 614 37 34   * 44     *   30                             762 614 37 34     44         30                       762
1312196 1312196 MD     school 2400210 6   Carroll 240021000529 506 Carrolltowne Elementary   Regular School No Elementary PK 05 2021   pk_12_total 474 14 37   * 41     *   30                             599 474 14 37     41         30                       599
1312205 1312205 MD     school 2400210 6   Carroll 240021000835 508 Oklahoma Road Middle   Regular School No Middle 06 08 2021   pk_12_total 571 43 31   * 47     *   26                             721 571 43 31     47         26                       721
1312213 1312213 MD     school 2400210 6   Carroll 240021090466 509 Piney Ridge Elementary   Regular School No Elementary PK 05 2021   pk_12_total 371 37 33   * 40     *   55                             538 371 37 33     40         55                       538
1312218 1312218 MD     school 2400210 6   Carroll 240021001161 510 Century High   Regular School No High 09 12 2021   pk_12_total 919 53 79   * 52     *   27                             1135 919 53 79     52         27                       1135
1312231 1312231 MD     school 2400210 6   Carroll 240021001672 602 Manchester Valley High   Regular School No High 09 12 2021   pk_12_total 1154 34 73   * 31     *   25                             1321 1154 34 73     31         25                       1321
1312239 1312239 MD     school 2400210 6   Carroll 240021001652 603 Ebb Valley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 474 11 14   * 10     *   13                             527 474 11 14     10         13                       527
1312247 1312247 MD     school 2400210 6   Carroll 240021000553 703 Westminster West Middle   Regular School No Middle 06 08 2021   pk_12_total 671 59 108   * 28     *   33                             904 671 59 108     28         33                       904
1312252 1312252 MD     school 2400210 6   Carroll 240021001185 704 Winters Mill High   Regular School No High 09 12 2021   pk_12_total 780 79 125   * 38     *   55                             1080 780 79 125     38         55                       1080
1312265 1312265 MD     school 2400210 6   Carroll 240021000552 707 Westminster High   Regular School No High 09 12 2021   pk_12_total 1242 70 84   * 56     *   59                             1515 1242 70 84     56         59                       1515
1312307 1312307 MD     school 2400210 6   Carroll 240021001105 715 Cranberry Station Elementary   Regular School No Elementary PK 05 2021   pk_12_total 415 23 59   * *         38                             544 415 23 59               38                       544
1312312 1312312 MD     school 2400210 6   Carroll 240021001548 716 Gateway School   Alternative School No High 09 12 2021   pk_12_total 42 * *   * *         *                             51 42                                           51
1312325 1312325 MD     school 2400210 6   Carroll 240021000542 801 North Carroll Middle   Regular School No Middle 06 08 2021   pk_12_total 551 15 28   * 13     *   17                             628 551 15 28     13         17                       628
1312358 1312358 MD     school 2400210 6   Carroll 240021000555 906 Winfield Elementary   Regular School No Elementary PK 05 2021   pk_12_total 537 14 16   * *     *   *                             583 537 14 16                                       583
1312366 1312366 MD     school 2400210 6   Carroll 240021000532 1201 Elmer A. Wolfe Elementary   Regular School No Elementary PK 05 2021   pk_12_total 379 * 11   * *         18                             416 379   11               18                       416
1312375 1312375 MD     school 2400210 6   Carroll 240021000538 1305 Mount Airy Elementary   Regular School No Elementary 03 05 2021   pk_12_total 340 13 57   * *     *   16                             436 340 13 57               16                       436
1312379 1312379 MD     school 2400210 6   Carroll 240021000539 1306 Mount Airy Middle   Regular School No Middle 06 08 2021   pk_12_total 567 18 74   * 14     *   13                             690 567 18 74     14         13                       690
1312384 1312384 MD     school 2400210 6   Carroll 240021000546 1401 South Carroll High   Regular School No High 09 12 2021   pk_12_total 842 15 78   * 23     *   22                             984 842 15 78     23         22                       984
1312392 1312392 MD     school 2400240 7   Cecil 240024000562 104 Cecilton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 207 16 43   *           15                             282 207 16 43               15                       282
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
1312414 1312414 MD     school 2400240 7   Cecil 240024000568 302 Elkton High   Regular School No High 09 12 2021   pk_12_total 493 290 151   * 13     *   107                             1061 493 290 151     13         107                       1061
1312418 1312418 MD     school 2400240 7   Cecil 240024000567 303 Elkton Middle   Regular School No Middle 06 08 2021   pk_12_total 216 178 95   * *     *   76                             574 216 178 95               76                       574
1312434 1312434 MD     school 2400240 7   Cecil 240024000570 311 Holly Hall Elementary   Regular School No Elementary PK 05 2021   pk_12_total 217 66 59   * *         42                             390 217 66 59               42                       390
1312454 1312454 MD     school 2400240 7   Cecil 240024000581 316 Thomson Estates Elementary   Regular School No Elementary PK 05 2021   pk_12_total 209 102 69   * 11     *   60                             453 209 102 69     11         60                       453
1312474 1312474 MD     school 2400240 7   Cecil 240024000574 504 North East Middle   Regular School No Middle 06 08 2021   pk_12_total 637 63 47   * *     *   42                             798 637 63 47               42                       798
1312482 1312482 MD     school 2400240 7   Cecil 240024000573 506 North East Elementary   Regular School No Elementary PK 05 2021   pk_12_total 374 59 35   * *     *   46                             522 374 59 35               46                       522
1312503 1312503 MD     school 2400240 7   Cecil 240024000575 514 North East High   Regular School No High 09 12 2021   pk_12_total 843 62 58   * 10         43                             1020 843 62 58     10         43                       1020
1312511 1312511 MD     school 2400240 7   Cecil 240024090468 515 Elk Neck Elementary   Regular School No Elementary PK 05 2021   pk_12_total 375 14 15   * *     *   21                             430 375 14 15               21                       430
1312515 1312515 MD     school 2400240 7   Cecil 240024000580 606 Rising Sun Middle School   Regular School No Middle 06 08 2021   pk_12_total 618 * 42   * *         20                             685 618   42               20                       685
1312523 1312523 MD     school 2400240 7   Cecil 240024000579 607 Rising Sun Elementary   Regular School No Elementary PK 05 2021   pk_12_total 562 * 41   * *         23                             634 562   41               23                       634
1312527 1312527 MD     school 2400240 7   Cecil 240024000578 701 Perryville Middle   Regular School No Middle 06 08 2021   pk_12_total 460 48 27   * *     *   47                             585 460 48 27               47                       585
1312543 1312543 MD     school 2400240 7   Cecil 240024000556 704 Bainbridge Elementary   Regular School No Elementary PK 05 2021   pk_12_total 221 12 *   *           23                             265 221 12                 23                       265
1312548 1312548 MD     school 2400240 7   Cecil 240024000577 705 Perryville High   Regular School No High 09 12 2021   pk_12_total 677 36 36   * 10     *   46                             810 677 36 36     10         46                       810
1312556 1312556 MD     school 2400240 7   Cecil 240024000566 801 Conowingo Elementary   Regular School No Elementary PK 05 2021   pk_12_total 373 * 14   *           10                             407 373   14               10                       407
1312564 1312564 MD     school 2400240 7   Cecil 240024000559 904 Calvert Elementary   Regular School No Elementary PK 05 2021   pk_12_total 375   19   *           *                             404 375   19                                       404
1312569 1312569 MD     school 2400240 7   Cecil 240024090469 905 Rising Sun High   Regular School No High 09 12 2021   pk_12_total 972 * 58   * *         27                             1076 972   58               27                       1076
1312573 1312573 MD     school 2400270 8   Charles 240027000601 104 Milton M. Somers Middle School   Regular School No Middle 06 08 2021   pk_12_total 386 437 103   * 37     *   83                             1049 386 437 103     37         83                       1049
1312581 1312581 MD     school 2400270 8   Charles 240027000609 105 Walter J. Mitchell Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 377 105 55   * 13     *   59                             613 377 105 55     13         59                       613
1312586 1312586 MD     school 2400270 8   Charles 240027000596 106 La Plata High School   Regular School No High 09 12 2021   pk_12_total 703 247 73   * 38     *   107                             1174 703 247 73     38         107                       1174
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
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
1312607 1312607 MD     school 2400270 8   Charles 240027001492 302 Mt Hope/Nanjemoy Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 145 56 *   *           22                             230 145 56                 22                       230
1312619 1312619 MD     school 2400270 8   Charles 240027000604 503 Piccowaxen Middle School   Regular School No Middle 06 08 2021   pk_12_total 327 53 27   * *     *   27                             443 327 53 27               27                       443
1312627 1312627 MD     school 2400270 8   Charles 240027000585 604 Dr. Samuel A. Mudd Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 33 402 91   * *         29                             566 33 402 91               29                       566
1312632 1312632 MD     school 2400270 8   Charles 240027000607 605 Thomas Stone High School   Regular School No High 09 12 2021   pk_12_total 138 708 186   * 19     *   59                             1115 138 708 186     19         59                       1115
1312640 1312640 MD     school 2400270 8   Charles 240027000593 606 J. P. Ryon Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 50 398 121   * *         51                             630 50 398 121               51                       630
1312644 1312644 MD     school 2400270 8   Charles 240027000595 608 John Hanson Middle School   Regular School No Middle 06 08 2021   pk_12_total 135 488 129   * 17     *   72                             849 135 488 129     17         72                       849
1312652 1312652 MD     school 2400270 8   Charles 240027000594 609 Dr. James Craik Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 215 179 45   * *         49                             499 215 179 45               49                       499
1312660 1312660 MD     school 2400270 8   Charles 240027000584 611 Dr. Gustavus Brown Elementary   Regular School No Elementary PK 05 2021   pk_12_total 32 266 74   * *         31                             407 32 266 74               31                       407
1312672 1312672 MD     school 2400270 8   Charles 240027000583 613 Benjamin Stoddert Middle School   Regular School No Middle 06 08 2021   pk_12_total 52 590 110   * 25     *   56                             838 52 590 110     25         56                       838
1312688 1312688 MD     school 2400270 8   Charles 240027010501 617 Daniel of St. Thomas Jenifer Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 27 411 96   * 17         42                             595 27 411 96     17         42                       595
1312696 1312696 MD     school 2400270 8   Charles 240027001519 618 William B. Wade Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 72 385 50   * 39         71                             619 72 385 50     39         71                       619
1312701 1312701 MD     school 2400270 8   Charles 240027000144 619 Westlake High School   Regular School No High 09 12 2021   pk_12_total 68 877 89   * 42     *   57                             1139 68 877 89     42         57                       1139
1312713 1312713 MD     school 2400270 8   Charles 240027000615 621 Mattawoman Middle School   Regular School No Middle 06 08 2021   pk_12_total 37 756 116   * 54     *   56                             1024 37 756 116     54         56                       1024
1312721 1312721 MD     school 2400270 8   Charles 240027000805 622 Berry Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 59 404 84   * 55     *   68                             675 59 404 84     55         68                       675

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