enrollments

Data source: Big Local News · About: Big Local

19,213 rows where state = "MD" sorted by native_hawaiian_pacific_islander descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
1238454 1238454 MD     school 2400120 3   Baltimore County 240012001431 252 Northwest Academy of Health Sciences   Regular School No Middle 06 08 2020   pk_12_total 22 687 42   * 17     *   15                             785 22 687 42     17         15                       785
1238458 1238458 MD     school 2400120 3   Baltimore County 240012000501 253 Woodlawn Middle   Regular School No Middle 06 08 2020   pk_12_total 12 550 39     *     *   13                             622 12 550 39               13                       622
1238462 1238462 MD     school 2400120 3   Baltimore County 240012000372 254 Deer Park Middle Magnet School   Regular School No Middle 06 08 2020   pk_12_total 37 1183 74   * 29     *   36                             1365 37 1183 74     29         36                       1365
1238471 1238471 MD     school 2400120 3   Baltimore County 240012000432 271 Milford Mill Academy   Regular School No High 09 12 2020   pk_12_total 15 1118 68   * 17     *   28                             1251 15 1118 68     17         28                       1251
1238482 1238482 MD     school 2400120 3   Baltimore County 240012000348 303 Bedford Elementary   Regular School No Elementary 01 05 2020   pk_12_total 10 250 46     *     *   16                             331 10 250 46               16                       331
1238503 1238503 MD     school 2400120 3   Baltimore County 240012000387 308 Fort Garrison Elementary   Regular School No Elementary PK 05 2020   pk_12_total 232 62 *   * 11     *   *                             319 232 62       11                                 319
1238510 1238510 MD     school 2400120 3   Baltimore County 240012000481 310 Summit Park Elementary   Regular School No Elementary KG 05 2020   pk_12_total 346 56 20   * 32     *   14                             470 346 56 20     32         14                       470
1238517 1238517 MD     school 2400120 3   Baltimore County 240012001405 311 Woodholme Elementary   Regular School No Elementary KG 05 2020   pk_12_total 46 470 145   * 24     *   25                             714 46 470 145     24         25                       714
1238521 1238521 MD     school 2400120 3   Baltimore County 240012000448 352 Pikesville Middle   Regular School No Middle 06 08 2020   pk_12_total 162 642 86   * 39     *   34                             972 162 642 86     39         34                       972
1238530 1238530 MD     school 2400120 3   Baltimore County 240012000449 371 Pikesville High   Regular School No High 09 12 2020   pk_12_total 301 464 76   * 54     *   21                             922 301 464 76     54         21                       922
1238554 1238554 MD     school 2400120 3   Baltimore County 240012000361 404 Chatsworth School   Regular School No Elementary PK 05 2020   pk_12_total 119 178 23   * 22     *   22                             366 119 178 23     22         22                       366
1238578 1238578 MD     school 2400120 3   Baltimore County 240012001346 407 Glyndon Elementary   Regular School No Elementary PK 05 2020   pk_12_total 90 313 81   * 28     *   42                             559 90 313 81     28         42                       559
1238586 1238586 MD     school 2400120 3   Baltimore County 240012000356 408 Cedarmere Elementary   Regular School No Elementary PK 05 2020   pk_12_total 98 209 165   * 45     *   19                             539 98 209 165     45         19                       539
1238597 1238597 MD     school 2400120 3   Baltimore County 240012000389 451 Franklin Middle   Regular School No Middle 06 08 2020   pk_12_total 279 600 205   * 79     *   77                             1242 279 600 205     79         77                       1242
1238602 1238602 MD     school 2400120 3   Baltimore County 240012001347 452 Owings Mills High   Regular School No High 09 12 2020   pk_12_total 77 642 385   * 54     *   25                             1189 77 642 385     54         25                       1189
1238607 1238607 MD     school 2400120 3   Baltimore County 240012000390 472 Franklin High   Regular School No High 09 12 2020   pk_12_total 481 667 165   * 109     *   82                             1511 481 667 165     109         82                       1511
1238646 1238646 MD     school 2400120 3   Baltimore County 240012000476 801 Sparks Elementary   Regular School No Elementary KG 05 2020   pk_12_total 424 16 14   * 37     *   15                             509 424 16 14     37         15                       509
1238653 1238653 MD     school 2400120 3   Baltimore County 240012000350 803 Lutherville Laboratory   Regular School No Elementary KG 05 2020   pk_12_total 186 68 35     50     *   28                             368 186 68 35     50         28                       368
1238711 1238711 MD     school 2400120 3   Baltimore County 240012001434 852 Ridgely Middle   Regular School No Middle 06 08 2020   pk_12_total 689 109 64   * 196     *   49                             1113 689 109 64     196         49                       1113
1238715 1238715 MD     school 2400120 3   Baltimore County 240012000366 853 Cockeysville Middle   Regular School No Middle 06 08 2020   pk_12_total 391 251 154   * 71     *   41                             910 391 251 154     71         41                       910
1238724 1238724 MD     school 2400120 3   Baltimore County 240012000373 872 Dulaney High   Regular School No High 09 12 2020   pk_12_total 979 393 199   * 257     *   79                             1914 979 393 199     257         79                       1914
1238738 1238738 MD     school 2400120 3   Baltimore County 240012000465 907 Rodgers Forge Elementary   Regular School No Elementary KG 05 2020   pk_12_total 359 * 26     43     *   32                             468 359   26     43         32                       468
1238746 1238746 MD     school 2400120 3   Baltimore County 240012000490 908 Villa Cresta Elementary   Regular School No Elementary PK 05 2020   pk_12_total 396 159 80   * 23     *   43                             709 396 159 80     23         43                       709
1238754 1238754 MD     school 2400120 3   Baltimore County 240012000453 909 Pleasant Plains Elementary   Regular School No Elementary PK 05 2020   pk_12_total 129 354 137   * 38     *   35                             698 129 354 137     38         35                       698
1238786 1238786 MD     school 2400120 3   Baltimore County 240012000400 915 Harford Hills Elementary   Regular School No Elementary PK 05 2020   pk_12_total 173 122 29     19     *   21                             365 173 122 29     19         21                       365
1238836 1238836 MD     school 2400120 3   Baltimore County 240012000374 953 Dumbarton Middle   Regular School No Middle 06 08 2020   pk_12_total 717 155 179     101     *   70                             1225 717 155 179     101         70                       1225
1238840 1238840 MD     school 2400120 3   Baltimore County 240012000419 954 Loch Raven Technical Academy   Regular School No Middle 06 08 2020   pk_12_total 140 554 65   * 25     *   33                             823 140 554 65     25         33                       823
1238844 1238844 MD     school 2400120 3   Baltimore County 240012000451 957 Pine Grove Middle   Regular School No Middle 06 08 2020   pk_12_total 410 375 50   * 69     *   49                             960 410 375 50     69         49                       960
1238854 1238854 MD     school 2400120 3   Baltimore County 240012000443 972 Parkville High & Center for Math/Science   Regular School No High 09 12 2020   pk_12_total 460 873 492   10 162     *   74                             2074 460 873 492   10 162         74                       2074
1238859 1238859 MD     school 2400120 3   Baltimore County 240012000420 973 Loch Raven High   Regular School No High 09 12 2020   pk_12_total 347 379 64   * 39     *   41                             874 347 379 64     39         41                       874
1238864 1238864 MD     school 2400120 3   Baltimore County 240012000230 975 George W. Carver Center for Arts & Technology   Career and Technical School No High 09 12 2020   pk_12_total 439 349 58   * 63     *   44                             961 439 349 58     63         44                       961
1238878 1238878 MD     school 2400120 3   Baltimore County 240012000467 1002 Jacksonville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 469 10 24     25     *   21                             550 469 10 24     25         21                       550
1238885 1238885 MD     school 2400120 3   Baltimore County 240012000413 1104 Kingsville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 287 * 11     10     *   11                             326 287   11     10         11                       326
1238893 1238893 MD     school 2400120 3   Baltimore County 240012000445 1105 Perry Hall Elementary   Regular School No Elementary PK 05 2020   pk_12_total 272 138 37   * 128     *   40                             621 272 138 37     128         40                       621
1238901 1238901 MD     school 2400120 3   Baltimore County 240012000351 1106 Carney Elementary   Regular School No Elementary PK 05 2020   pk_12_total 200 318 26   * 55     *   36                             638 200 318 26     55         36                       638
1238916 1238916 MD     school 2400120 3   Baltimore County 240012090444 1109 Joppa View Elementary   Regular School No Elementary PK 05 2020   pk_12_total 296 220 37   * 134     *   48                             739 296 220 37     134         48                       739
1238931 1238931 MD     school 2400120 3   Baltimore County 240012000397 1111 Gunpowder Elementary   Regular School No Elementary KG 05 2020   pk_12_total 342 88 12   * 67     *   26                             538 342 88 12     67         26                       538
1238939 1238939 MD     school 2400120 3   Baltimore County 240012001750 1113 Honeygo Elementary   Regular School No Elementary PK 05 2020   pk_12_total 366 94 33   * 138     *   45                             680 366 94 33     138         45                       680
1238943 1238943 MD     school 2400120 3   Baltimore County 240012000447 1151 Perry Hall Middle   Regular School No Middle 06 08 2020   pk_12_total 954 491 93   * 295     *   82                             1925 954 491 93     295         82                       1925
1238948 1238948 MD     school 2400120 3   Baltimore County 240012000446 1171 Perry Hall High   Regular School No High 09 12 2020   pk_12_total 939 591 93   * 255     *   85                             1969 939 591 93     255         85                       1969
1238956 1238956 MD     school 2400120 3   Baltimore County 240012000375 1202 Dundalk Elementary   Regular School No Elementary PK 05 2020   pk_12_total 265 234 174   10       *   90                             776 265 234 174   10           90                       776
1238964 1238964 MD     school 2400120 3   Baltimore County 240012000349 1205 Berkshire Elementary   Regular School No Elementary PK 05 2020   pk_12_total 218 74 147   * *     *   31                             484 218 74 147               31                       484
1238978 1238978 MD     school 2400120 3   Baltimore County 240012000434 1207 Norwood Elementary   Regular School No Elementary PK 03 2020   pk_12_total 207 42 164     43     *   34                             491 207 42 164     43         34                       491
1238986 1238986 MD     school 2400120 3   Baltimore County 240012000395 1210 Grange Elementary   Regular School No Elementary PK 05 2020   pk_12_total 297 74 55   * 14     *   44                             489 297 74 55     14         44                       489
1238994 1238994 MD     school 2400120 3   Baltimore County 240012000359 1212 Charlesmont Elementary   Regular School No Elementary PK 05 2020   pk_12_total 237 46 57   * *     *   36                             384 237 46 57               36                       384
1239028 1239028 MD     school 2400120 3   Baltimore County 240012000376 1251 Dundalk Middle   Regular School No Middle 06 08 2020   pk_12_total 245 217 248   10 17     *   53                             793 245 217 248   10 17         53                       793
1239043 1239043 MD     school 2400120 3   Baltimore County 240012000444 1272 Patapsco High & Center for Arts   Regular School No High 09 12 2020   pk_12_total 820 331 148   15 15     *   104                             1434 820 331 148   15 15         104                       1434
1239048 1239048 MD     school 2400120 3   Baltimore County 240012000377 1273 Dundalk High   Regular School No High 09 12 2020   pk_12_total 690 349 593   14 43     *   89                             1782 690 349 593   14 43         89                       1782
1239056 1239056 MD     school 2400120 3   Baltimore County 240012000341 1302 Arbutus Elementary   Regular School No Elementary PK 05 2020   pk_12_total 201 24 13   * 138     *   25                             404 201 24 13     138         25                       404
1239100 1239100 MD     school 2400120 3   Baltimore County 240012000417 1351 Lansdowne Middle   Regular School No Middle 06 08 2020   pk_12_total 201 246 292   16 62     *   48                             866 201 246 292   16 62         48                       866
1239104 1239104 MD     school 2400120 3   Baltimore County 240012000342 1356 Arbutus Middle   Regular School No Middle 06 08 2020   pk_12_total 489 214 40   * 136     *   67                             951 489 214 40     136         67                       951
1239117 1239117 MD     school 2400120 3   Baltimore County 240012000426 1403 McCormick Elementary   Regular School No Elementary PK 05 2020   pk_12_total 16 282 22     *     *   12                             338 16 282 22               12                       338
1239125 1239125 MD     school 2400120 3   Baltimore County 240012000391 1404 Fullerton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 247 227 53   * 50     *   36                             617 247 227 53     50         36                       617
1239141 1239141 MD     school 2400120 3   Baltimore County 240012000459 1406 Red House Run Elementary   Regular School No Elementary PK 05 2020   pk_12_total 207 172 124   * 61     *   21                             588 207 172 124     61         21                       588
1239153 1239153 MD     school 2400120 3   Baltimore County 240012001439 1451 Golden Ring Middle   Regular School No Middle 06 08 2020   pk_12_total 123 495 98   * 39     *   31                             793 123 495 98     39         31                       793
1239157 1239157 MD     school 2400120 3   Baltimore County 240012000442 1452 Parkville Middle & Center of Technology   Regular School No Middle 06 08 2020   pk_12_total 478 431 82   * 68     *   64                             1126 478 431 82     68         64                       1126
1239162 1239162 MD     school 2400120 3   Baltimore County 240012000438 1473 Overlea High   Regular School No High 09 12 2020   pk_12_total 173 665 105   * 28     *   45                             1020 173 665 105     28         45                       1020
1239177 1239177 MD     school 2400120 3   Baltimore County 240012000367 1503 Colgate Elementary   Regular School No Elementary KG 05 2020   pk_12_total 122 37 237   * 10     *   25                             433 122 37 237     10         25                       433
1239185 1239185 MD     school 2400120 3   Baltimore County 240012000489 1505 Victory Villa Elementary   Regular School No Elementary PK 05 2020   pk_12_total 147 343 131   * 11     *   55                             691 147 343 131     11         55                       691
1239193 1239193 MD     school 2400120 3   Baltimore County 240012000425 1506 Martin Boulevard Elementary   Regular School No Elementary PK 05 2020   pk_12_total 79 118 57   * *     *   39                             298 79 118 57               39                       298
1239201 1239201 MD     school 2400120 3   Baltimore County 240012000360 1507 Chase Elementary   Regular School No Elementary PK 05 2020   pk_12_total 210 95 47   * *     *   42                             398 210 95 47               42                       398
1239209 1239209 MD     school 2400120 3   Baltimore County 240012000384 1508 Essex Elementary   Regular School No Elementary PK 05 2020   pk_12_total 293 67 75   11 17     *   28                             493 293 67 75   11 17         28                       493
1239225 1239225 MD     school 2400120 3   Baltimore County 240012000424 1512 Mars Estates Elementary   Regular School No Elementary PK 05 2020   pk_12_total 67 222 54   * 10     *   30                             386 67 222 54     10         30                       386
1239233 1239233 MD     school 2400120 3   Baltimore County 240012000482 1513 Sussex Elementary   Regular School No Elementary PK 05 2020   pk_12_total 180 137 73   * *     *   47                             448 180 137 73               47                       448
1239257 1239257 MD     school 2400120 3   Baltimore County 240012000345 1517 Battle Grove Elementary   Regular School No Elementary PK 05 2020   pk_12_total 177 71 53   * *     *   41                             346 177 71 53               41                       346
1239288 1239288 MD     school 2400120 3   Baltimore County 240012000369 1525 Deep Creek Elementary   Regular School No Elementary KG 05 2020   pk_12_total 54 328 33   * *     *   36                             458 54 328 33               36                       458
1239304 1239304 MD     school 2400120 3   Baltimore County 240012000472 1531 Seneca Elementary   Regular School No Elementary PK 05 2020   pk_12_total 178 171 27   * 12     *   33                             423 178 171 27     12         33                       423
1239312 1239312 MD     school 2400120 3   Baltimore County 240012001653 1533 Vincent Farm Elementary   Regular School No Elementary PK 05 2020   pk_12_total 287 314 50   * 69     *   39                             761 287 314 50     69         39                       761
1239328 1239328 MD     school 2400120 3   Baltimore County 240012001440 1556 Middle River Middle   Regular School No Middle 06 08 2020   pk_12_total 343 466 115   * 36     *   70                             1035 343 466 115     36         70                       1035
1239336 1239336 MD     school 2400120 3   Baltimore County 240012010500 1559 Sparrows Point Middle   Regular School No Middle 06 08 2020   pk_12_total 499 52 39   * *     *   33                             637 499 52 39               33                       637
1239341 1239341 MD     school 2400120 3   Baltimore County 240012000412 1572 Kenwood High IB and Sports Science   Regular School No High 09 12 2020   pk_12_total 648 677 172   10 40     *   100                             1649 648 677 172   10 40         100                       1649
1239346 1239346 MD     school 2400120 3   Baltimore County 240012000477 1573 Sparrows Point High   Regular School No High 09 12 2020   pk_12_total 881 79 52   * 10     *   41                             1067 881 79 52     10         41                       1067
1239351 1239351 MD     school 2400120 3   Baltimore County 240012000362 1574 Chesapeake High   Regular School No High 09 12 2020   pk_12_total 267 525 102   * *     *   50                             961 267 525 102               50                       961
1239356 1239356 MD     school 2400120 3   Baltimore County 240012000379 1575 Eastern Technical High School   Career and Technical School No High 09 12 2020   pk_12_total 562 235 57   * 257     *   55                             1172 562 235 57     257         55                       1172
1239381 1239381 MD     school 2400150 4   Calvert 240015000611 113 Patuxent High   Regular School No High 09 12 2020   pk_12_total 698 186 65   * 24     *   85                             1063 698 186 65     24         85                       1063
1239433 1239433 MD     school 2400150 4   Calvert 240015001655 208 Barstow Elementary   Regular School No Elementary PK 05 2020   pk_12_total 432 103 39   * *     *   73                             658 432 103 39               73                       658
1239446 1239446 MD     school 2400150 4   Calvert 240015000508 213 Calvert High   Regular School No High 09 12 2020   pk_12_total 737 224 81   * 21     *   93                             1161 737 224 81     21         93                       1161
1239458 1239458 MD     school 2400150 4   Calvert 240015000027 216 Plum Point Middle   Regular School No Middle 06 08 2020   pk_12_total 493 63 35     12     *   52                             656 493 63 35     12         52                       656
1239483 1239483 MD     school 2400150 4   Calvert 240015000516 314 Northern High   Regular School No High 09 12 2020   pk_12_total 1101 163 92   * 28     *   97                             1484 1101 163 92     28         97                       1484
1239487 1239487 MD     school 2400150 4   Calvert 240015000515 315 Northern Middle   Regular School No Middle 06 08 2020   pk_12_total 518 53 26     19     *   56                             674 518 53 26     19         56                       674
1239507 1239507 MD     school 2400150 4   Calvert 240015000967 318 Windy Hill Middle   Regular School No Middle 06 08 2020   pk_12_total 557 87 48   * 12     *   82                             789 557 87 48     12         82                       789
1239561 1239561 MD     school 2400180 5   Caroline 240018000523 703 North Caroline High School   Regular School No High 09 12 2020   pk_12_total 728 111 210   * 11     *   72                             1138 728 111 210     11         72                       1138
1239578 1239578 MD     school 2400210 6   Carroll 240021000548 103 Taneytown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 326 18 31     *     *   22                             401 326 18 31               22                       401
1239587 1239587 MD     school 2400210 6   Carroll 240021000533 202 Francis Scott Key High   Regular School No High 09 12 2020   pk_12_total 811 31 39   * *     *   28                             922 811 31 39               28                       922
1239595 1239595 MD     school 2400210 6   Carroll 240021000368 204 Runnymede Elementary   Regular School No Elementary PK 05 2020   pk_12_total 540 19 19   * *     *   27                             612 540 19 19               27                       612
1239603 1239603 MD     school 2400210 6   Carroll 240021000545 404 Sandymount Elementary   Regular School No Elementary PK 05 2020   pk_12_total 409 28 38     13     *   *                             497 409 28 38     13                                 497
1239611 1239611 MD     school 2400210 6   Carroll 240021000537 406 Mechanicsville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 412 17 14     10     *   27                             483 412 17 14     10         27                       483
1239627 1239627 MD     school 2400210 6   Carroll 240021000977 503 Linton Springs Elementary   Regular School No Elementary PK 05 2020   pk_12_total 538 17 32   * 24     *   22                             638 538 17 32     24         22                       638
1239631 1239631 MD     school 2400210 6   Carroll 240021000547 504 Sykesville Middle   Regular School No Middle 06 08 2020   pk_12_total 639 37 37   * 42     *   26                             784 639 37 37     42         26                       784
1239638 1239638 MD     school 2400210 6   Carroll 240021000534 505 Freedom District Elementary   Regular School No Elementary KG 05 2020   pk_12_total 485 17 28     22     *   23                             576 485 17 28     22         23                       576
1239646 1239646 MD     school 2400210 6   Carroll 240021000529 506 Carrolltowne Elementary   Regular School No Elementary PK 05 2020   pk_12_total 472 13 30   * 44     *   29                             591 472 13 30     44         29                       591
1239651 1239651 MD     school 2400210 6   Carroll 240021001394 507 Liberty High   Regular School No High 09 12 2020   pk_12_total 861 44 54   * 43     *   33                             1044 861 44 54     43         33                       1044
1239655 1239655 MD     school 2400210 6   Carroll 240021000835 508 Oklahoma Road Middle   Regular School No Middle 06 08 2020   pk_12_total 563 33 31   * 42     *   24                             695 563 33 31     42         24                       695
1239663 1239663 MD     school 2400210 6   Carroll 240021090466 509 Piney Ridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 389 31 24   * 38     *   51                             535 389 31 24     38         51                       535
1239668 1239668 MD     school 2400210 6   Carroll 240021001161 510 Century High   Regular School No High 09 12 2020   pk_12_total 945 50 73   * 40     *   27                             1139 945 50 73     40         27                       1139
1239676 1239676 MD     school 2400210 6   Carroll 240021000536 601 Manchester Elementary   Regular School No Elementary PK 05 2020   pk_12_total 595 * 39     10     *   10                             663 595   39     10         10                       663
1239689 1239689 MD     school 2400210 6   Carroll 240021001652 603 Ebb Valley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 489 13 17   * 10     *   13                             548 489 13 17     10         13                       548
1239693 1239693 MD     school 2400210 6   Carroll 240021000550 701 Westminster East Middle   Regular School No Middle 06 08 2020   pk_12_total 554 56 77     18     *   41                             748 554 56 77     18         41                       748
1239697 1239697 MD     school 2400210 6   Carroll 240021000553 703 Westminster West Middle   Regular School No Middle 06 08 2020   pk_12_total 725 44 94   * 29     *   36                             935 725 44 94     29         36                       935
1239702 1239702 MD     school 2400210 6   Carroll 240021001185 704 Winters Mill High   Regular School No High 09 12 2020   pk_12_total 792 75 126   * 34     *   48                             1079 792 75 126     34         48                       1079

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