enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 9,498 ✖
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
1311080 1311080 MD     school 2400120 3   Baltimore County 240012000441 353 Sudbrook Magnet Middle   Regular School No Middle 06 08 2021   pk_12_total 105 574 213   * 54     *   22                             972 105 574 213     54         22                       972
1311085 1311085 MD     school 2400120 3   Baltimore County 240012000449 371 Pikesville High   Regular School No High 09 12 2021   pk_12_total 312 431 82   * 48     *   29                             905 312 431 82     48         29                       905
1311109 1311109 MD     school 2400120 3   Baltimore County 240012000361 404 Chatsworth School   Regular School No Elementary PK 05 2021   pk_12_total 102 171 17     24     *   20                             335 102 171 17     24         20                       335
1311133 1311133 MD     school 2400120 3   Baltimore County 240012001346 407 Glyndon Elementary   Regular School No Elementary PK 05 2021   pk_12_total 80 281 86   * 21     *   38                             512 80 281 86     21         38                       512
1311152 1311152 MD     school 2400120 3   Baltimore County 240012000389 451 Franklin Middle   Regular School No Middle 06 08 2021   pk_12_total 271 625 197   * 88     *   73                             1258 271 625 197     88         73                       1258
1311157 1311157 MD     school 2400120 3   Baltimore County 240012001347 452 Owings Mills High   Regular School No High 09 12 2021   pk_12_total 59 619 363   * 48     *   26                             1120 59 619 363     48         26                       1120
1311162 1311162 MD     school 2400120 3   Baltimore County 240012000390 472 Franklin High   Regular School No High 09 12 2021   pk_12_total 429 647 190   * 109     *   76                             1457 429 647 190     109         76                       1457
1311201 1311201 MD     school 2400120 3   Baltimore County 240012000476 801 Sparks Elementary   Regular School No Elementary KG 05 2021   pk_12_total 399 21 14   * 34     *   14                             485 399 21 14     34         14                       485
1311208 1311208 MD     school 2400120 3   Baltimore County 240012000350 803 Lutherville Laboratory   Regular School No Elementary KG 05 2021   pk_12_total 164 68 30     46     *   29                             338 164 68 30     46         29                       338
1311215 1311215 MD     school 2400120 3   Baltimore County 240012001433 805 Timonium Elementary   Regular School No Elementary KG 05 2021   pk_12_total 286 22 36     75     *   24                             444 286 22 36     75         24                       444
1311266 1311266 MD     school 2400120 3   Baltimore County 240012001434 852 Ridgely Middle   Regular School No Middle 06 08 2021   pk_12_total 676 105 61   * 207     *   45                             1100 676 105 61     207         45                       1100
1311279 1311279 MD     school 2400120 3   Baltimore County 240012000373 872 Dulaney High   Regular School No High 09 12 2021   pk_12_total 930 438 221   * 248     *   87                             1930 930 438 221     248         87                       1930
1311293 1311293 MD     school 2400120 3   Baltimore County 240012000465 907 Rodgers Forge Elementary   Regular School No Elementary KG 05 2021   pk_12_total 298 * 26     33     *   25                             392 298   26     33         25                       392
1311301 1311301 MD     school 2400120 3   Baltimore County 240012000490 908 Villa Cresta Elementary   Regular School No Elementary PK 05 2021   pk_12_total 337 160 76   * 22     *   46                             649 337 160 76     22         46                       649
1311309 1311309 MD     school 2400120 3   Baltimore County 240012000453 909 Pleasant Plains Elementary   Regular School No Elementary PK 05 2021   pk_12_total 88 283 115   * 11     *   25                             525 88 283 115     11         25                       525
1311341 1311341 MD     school 2400120 3   Baltimore County 240012000400 915 Harford Hills Elementary   Regular School No Elementary PK 05 2021   pk_12_total 162 134 32     21     *   20                             370 162 134 32     21         20                       370
1311391 1311391 MD     school 2400120 3   Baltimore County 240012000374 953 Dumbarton Middle   Regular School No Middle 06 08 2021   pk_12_total 656 151 167     103     *   71                             1152 656 151 167     103         71                       1152
1311395 1311395 MD     school 2400120 3   Baltimore County 240012000419 954 Loch Raven Technical Academy   Regular School No Middle 06 08 2021   pk_12_total 156 539 63   * 22     *   31                             817 156 539 63     22         31                       817
1311399 1311399 MD     school 2400120 3   Baltimore County 240012000451 957 Pine Grove Middle   Regular School No Middle 06 08 2021   pk_12_total 366 385 45   * 75     *   49                             926 366 385 45     75         49                       926
1311404 1311404 MD     school 2400120 3   Baltimore County 240012000487 971 Towson High   Regular School No High 09 12 2021   pk_12_total 1036 303 99   * 133     *   102                             1677 1036 303 99     133         102                       1677
1311409 1311409 MD     school 2400120 3   Baltimore County 240012000443 972 Parkville High   Regular School No High 09 12 2021   pk_12_total 423 925 485   * 161     *   71                             2075 423 925 485     161         71                       2075
1311414 1311414 MD     school 2400120 3   Baltimore County 240012000420 973 Loch Raven High   Regular School No High 09 12 2021   pk_12_total 316 376 66   * 35     *   40                             836 316 376 66     35         40                       836
1311419 1311419 MD     school 2400120 3   Baltimore County 240012000230 975 George W. Carver Center for Arts & Technology   Career and Technical School No High 09 12 2021   pk_12_total 458 354 63   * 66     *   50                             997 458 354 63     66         50                       997
1311440 1311440 MD     school 2400120 3   Baltimore County 240012000413 1104 Kingsville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 242 * *     *     *   *                             272 242                                           272
1311448 1311448 MD     school 2400120 3   Baltimore County 240012000445 1105 Perry Hall Elementary   Regular School No Elementary PK 05 2021   pk_12_total 245 136 29   * 144     *   34                             592 245 136 29     144         34                       592
1311463 1311463 MD     school 2400120 3   Baltimore County 240012000358 1107 Chapel Hill Elementary   Regular School No Elementary KG 05 2021   pk_12_total 327 102 17     116     *   30                             593 327 102 17     116         30                       593
1311471 1311471 MD     school 2400120 3   Baltimore County 240012090444 1109 Joppa View Elementary   Regular School No Elementary PK 05 2021   pk_12_total 268 211 32   * 128     *   42                             685 268 211 32     128         42                       685
1311494 1311494 MD     school 2400120 3   Baltimore County 240012001750 1113 Honeygo Elementary   Regular School No Elementary PK 05 2021   pk_12_total 347 105 28   * 130     *   47                             661 347 105 28     130         47                       661
1311498 1311498 MD     school 2400120 3   Baltimore County 240012000447 1151 Perry Hall Middle   Regular School No Middle 06 08 2021   pk_12_total 885 502 86   * 312     *   86                             1878 885 502 86     312         86                       1878
1311503 1311503 MD     school 2400120 3   Baltimore County 240012000446 1171 Perry Hall High   Regular School No High 09 12 2021   pk_12_total 904 659 107   * 256     *   85                             2018 904 659 107     256         85                       2018
1311511 1311511 MD     school 2400120 3   Baltimore County 240012000375 1202 Dundalk Elementary   Regular School No Elementary PK 05 2021   pk_12_total 233 221 176   * *     *   86                             732 233 221 176               86                       732
1311519 1311519 MD     school 2400120 3   Baltimore County 240012000349 1205 Berkshire Elementary   Regular School No Elementary PK 05 2021   pk_12_total 196 77 110   * *     *   29                             423 196 77 110               29                       423
1311533 1311533 MD     school 2400120 3   Baltimore County 240012000434 1207 Norwood Elementary   Regular School No Elementary PK 03 2021   pk_12_total 190 40 176     30     *   33                             470 190 40 176     30         33                       470
1311541 1311541 MD     school 2400120 3   Baltimore County 240012000395 1210 Grange Elementary   Regular School No Elementary PK 05 2021   pk_12_total 265 64 54   * 12     *   46                             446 265 64 54     12         46                       446
1311549 1311549 MD     school 2400120 3   Baltimore County 240012000359 1212 Charlesmont Elementary   Regular School No Elementary PK 05 2021   pk_12_total 209 48 51   * *     *   33                             349 209 48 51               33                       349
1311579 1311579 MD     school 2400120 3   Baltimore County 240012000421 1217 Logan Elementary   Regular School No Elementary PK 05 2021   pk_12_total 203 151 79   * 13     *   53                             501 203 151 79     13         53                       501
1311583 1311583 MD     school 2400120 3   Baltimore County 240012000376 1251 Dundalk Middle   Regular School No Middle 06 08 2021   pk_12_total 223 213 312   * 19     *   51                             827 223 213 312     19         51                       827
1311589 1311589 MD     school 2400120 3   Baltimore County 240012000408 1253 Holabird Middle   Regular School No Middle 04 08 2021   pk_12_total 433 123 291   10 31     *   56                             945 433 123 291   10 31         56                       945
1311598 1311598 MD     school 2400120 3   Baltimore County 240012000444 1272 Patapsco High and Center for Arts   Regular School No High 09 12 2021   pk_12_total 799 327 134   15 14     *   112                             1402 799 327 134   15 14         112                       1402
1311603 1311603 MD     school 2400120 3   Baltimore County 240012000377 1273 Dundalk High   Regular School No High 09 12 2021   pk_12_total 691 335 661   16 37     *   99                             1842 691 335 661   16 37         99                       1842
1311655 1311655 MD     school 2400120 3   Baltimore County 240012000417 1351 Lansdowne Middle   Regular School No Middle 06 08 2021   pk_12_total 211 252 316   17 58     *   55                             910 211 252 316   17 58         55                       910
1311659 1311659 MD     school 2400120 3   Baltimore County 240012000342 1356 Arbutus Middle   Regular School No Middle 06 08 2021   pk_12_total 522 205 46   * 140     *   83                             1004 522 205 46     140         83                       1004
1311672 1311672 MD     school 2400120 3   Baltimore County 240012000426 1403 McCormick Elementary   Regular School No Elementary PK 05 2021   pk_12_total 13 263 18           *   12                             308 13 263 18               12                       308
1311680 1311680 MD     school 2400120 3   Baltimore County 240012000391 1404 Fullerton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 204 222 58   * 49     *   37                             574 204 222 58     49         37                       574
1311712 1311712 MD     school 2400120 3   Baltimore County 240012000442 1452 Parkville Middle   Regular School No Middle 06 08 2021   pk_12_total 435 429 78   * 71     *   61                             1076 435 429 78     71         61                       1076
1311717 1311717 MD     school 2400120 3   Baltimore County 240012000438 1473 Overlea High   Regular School No High 09 12 2021   pk_12_total 181 751 119   * 39     *   52                             1148 181 751 119     39         52                       1148
1311741 1311741 MD     school 2400120 3   Baltimore County 240012000489 1505 Victory Villa Elementary   Regular School No Elementary PK 05 2021   pk_12_total 123 333 123     14     *   45                             640 123 333 123     14         45                       640
1311757 1311757 MD     school 2400120 3   Baltimore County 240012000360 1507 Chase Elementary   Regular School No Elementary PK 05 2021   pk_12_total 180 89 54     *     *   29                             355 180 89 54               29                       355
1311765 1311765 MD     school 2400120 3   Baltimore County 240012000384 1508 Essex Elementary   Regular School No Elementary PK 05 2021   pk_12_total 253 63 69   * 12     *   29                             435 253 63 69     12         29                       435
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
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
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
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
1311920 1311920 MD     school 2400150 4   Calvert 240015000504 101 Patuxent Appeal Elementary Campus   Regular School No Elementary PK 05 2021   pk_12_total 394 118 52     *     *   99                             667 394 118 52               99                       667
1311988 1311988 MD     school 2400150 4   Calvert 240015001655 208 Barstow Elementary   Regular School No Elementary PK 05 2021   pk_12_total 389 108 37     *     *   65                             605 389 108 37               65                       605
1311996 1311996 MD     school 2400150 4   Calvert 240015000511 209 Huntingtown Elementary   Regular School No Elementary PK 05 2021   pk_12_total 367 35 23     *     *   53                             480 367 35 23               53                       480
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
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
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
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
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
1312153 1312153 MD     school 2400210 6   Carroll 240021000545 404 Sandymount Elementary   Regular School No Elementary PK 05 2021   pk_12_total 391 29 38     11     *   *                             478 391 29 38     11                                 478
1312161 1312161 MD     school 2400210 6   Carroll 240021000537 406 Mechanicsville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 366 14 15     *     *   21                             426 366 14 15               21                       426
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
1312188 1312188 MD     school 2400210 6   Carroll 240021000534 505 Freedom District Elementary   Regular School No Elementary KG 05 2021   pk_12_total 452 12 27     27     *   25                             544 452 12 27     27         25                       544
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
1312201 1312201 MD     school 2400210 6   Carroll 240021001394 507 Liberty High   Regular School No High 09 12 2021   pk_12_total 815 55 44     38     *   34                             993 815 55 44     38         34                       993
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
1312226 1312226 MD     school 2400210 6   Carroll 240021000536 601 Manchester Elementary   Regular School No Elementary PK 05 2021   pk_12_total 525 10 37     *     *   17                             599 525 10 37               17                       599
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
1312243 1312243 MD     school 2400210 6   Carroll 240021000550 701 Westminster East Middle   Regular School No Middle 06 08 2021   pk_12_total 538 59 83     16     *   33                             730 538 59 83     16         33                       730
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
1312273 1312273 MD     school 2400210 6   Carroll 240021000551 710 Westminster Elementary   Regular School No Elementary PK 05 2021   pk_12_total 379 26 61     29     *   38                             535 379 26 61     29         38                       535
1312281 1312281 MD     school 2400210 6   Carroll 240021000544 711 Robert Moton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 227 45 81     *     *   27                             387 227 45 81               27                       387
1312299 1312299 MD     school 2400210 6   Carroll 240021000052 714 Friendship Valley Elementary   Regular School No Elementary KG 05 2021   pk_12_total 333 16 39     *     *   17                             414 333 16 39               17                       414
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
1312333 1312333 MD     school 2400210 6   Carroll 240021000535 804 Hampstead Elementary   Regular School No Elementary PK 05 2021   pk_12_total 329 12 20     *     *   18                             385 329 12 20               18                       385
1312345 1312345 MD     school 2400210 6   Carroll 240021002947 807 Shiloh Middle   Regular School No Middle 06 08 2021   pk_12_total 516 30 49     12     *   15                             623 516 30 49     12         15                       623
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
1312371 1312371 MD     school 2400210 6   Carroll 240021001414 1304 Parr's Ridge Elementary   Regular School No Elementary PK 02 2021   pk_12_total 292 11 57     *     *   17                             384 292 11 57               17                       384
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

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