enrollments

Data source: Big Local News · About: Big Local

1,393 rows where grade = "pk_12_total", state = "MD" and year = 2021 sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 1,393 ✖

grade ✖

  • pk_12_total · 1,393 ✖
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
1317149 1317149 MD     school   16   Prince George's   2217 Incarcerated Youth Center (JACS)             2021   pk_12_total   * *               *                             11                                             11
1310344 1310344 MD     school 2400060 2   Anne Arundel 240006000092 3122 Manor View Elementary   Regular School No Elementary 01 05 2021   pk_12_total 89 47 51   * *     *   37                             235 89 47 51               37                       235
1310556 1310556 MD     school 2400060 2   Anne Arundel 240006001714 4074 Phoenix Academy   Special Education School No Other 01 12 2021   pk_12_total 121 172 30   *           24                             349 121 172 30               24                       349
1311037 1311037 MD     school 2400120 3   Baltimore County 240012000348 303 Bedford Elementary   Regular School No Elementary 01 05 2021   pk_12_total * 234 49   * *     *   18                             319   234 49               18                       319
1311050 1311050 MD     school 2400120 3   Baltimore County 240012000431 307 Milbrook Elementary   Regular School No Elementary 01 05 2021   pk_12_total 26 212 72   * 18         13                             344 26 212 72     18         13                       344
1312292 1312292 MD     school 2400210 6   Carroll 240021000527 712 Carroll Springs School   Special Education School No Other 01 12 2021   pk_12_total 25 * *                                             28 25                                           28
1312318 1312318 MD     school 2400210 6   Carroll 240021001349 718 PRIDE School   Alternative School No Elementary 01 05 2021   pk_12_total * * *                                             *                                              
1317059 1317059 MD     school 2400510 16   Prince George's 240051001544 2022 Middleton Valley Academy   Regular School No Elementary 01 08 2021   pk_12_total * 263 16   * *     *                                 287   263 16                                       287
1317447 1317447 MD     school 2400570 19   Somerset 240057001203 1003 Ewell School   Regular School No Middle 01 07 2021   pk_12_total *                                                 *                                              
1319017 1319017 MD     school 2400090 30   Baltimore City 240009001369 314 Sharp-Leadenhall Elementary   Special Education School No Elementary 01 05 2021   pk_12_total * 23                 *                             27   23                                         27
1316074 1316074 MD     school 2400510 16   Prince George's 240051001056 712 Heather Hills Elementary   Regular School No Elementary 02 05 2021   pk_12_total 30 251 22     31     *   14                             349 30 251 22     31         14                       349
1317013 1317013 MD     school 2400510 16   Prince George's 240051001043 2010 Glenarden Woods Elementary   Regular School No Elementary 02 05 2021   pk_12_total 47 285 70   * 43     *   *                             455 47 285 70     43                                 455
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
1317844 1317844 MD     school 2400690 22   Wicomico 240069001304 515 Glen Avenue School   Regular School No Elementary 02 05 2021   pk_12_total 75 241 52   * *     *   30                             409 75 241 52               30                       409
1317926 1317926 MD     school 2400690 22   Wicomico 240069001149 1502 Westside Intermediate   Regular School No Elementary 02 05 2021   pk_12_total 229 67 27   * *         34                             363 229 67 27               34                       363
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
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
1313010 1313010 MD     school 2400330 10   Frederick 240033000639 303 Middletown Elementary   Regular School No Elementary 03 05 2021   pk_12_total 331 12 36   * *         30                             417 331 12 36               30                       417
1313181 1313181 MD     school 2400330 10   Frederick 240033000650 1503 Thurmont Elementary   Regular School No Elementary 03 05 2021   pk_12_total 256   22   *           12                             292 256   22               12                       292
1314821 1314821 MD     school 2400480 15   Montgomery 240048000803 403 Chevy Chase Elementary   Regular School No Elementary 03 05 2021   pk_12_total 243 84 42     40         32                             441 243 84 42     40         32                       441
1314862 1314862 MD     school 2400480 15   Montgomery 240048001452 415 North Chevy Chase Elementary   Regular School No Elementary 03 05 2021   pk_12_total 113 45 31     19         17                             225 113 45 31     19         17                       225
1315315 1315315 MD     school 2400480 15   Montgomery 240048000894 749 Piney Branch Elementary   Regular School No Elementary 03 05 2021   pk_12_total 250 197 112   * 22     *   42                             626 250 197 112     22         42                       626
1315341 1315341 MD     school 2400480 15   Montgomery 240048000893 761 Pine Crest Elementary   Regular School No Elementary 03 05 2021   pk_12_total 112 105 170     32         27                             446 112 105 170     32         27                       446
1315353 1315353 MD     school 2400480 15   Montgomery 240048000887 766 Oak View Elementary   Regular School No Elementary 03 05 2021   pk_12_total 67 53 270     17         12                             419 67 53 270     17         12                       419
1315580 1315580 MD     school 2400480 15   Montgomery 240048000814 808 Cresthaven Elementary   Regular School No Elementary 03 05 2021   pk_12_total 11 185 252     37     *   *                             491 11 185 252     37                                 491
1315621 1315621 MD     school 2400480 15   Montgomery 240048000930 822 Strathmore Elementary   Regular School No Elementary 03 05 2021   pk_12_total 38 174 242     25         12                             491 38 174 242     25         12                       491
1317184 1317184 MD     school 2400540 17   Queen Anne's 240054001070 302 Kennard Elementary School   Regular School No Elementary 03 05 2021   pk_12_total 352 33 28     *         31                             446 352 33 28               31                       446
1317202 1317202 MD     school 2400540 17   Queen Anne's 240054000202 403 Bayside Elementary School   Regular School No Elementary 03 05 2021   pk_12_total 290 20 42     *         33                             393 290 20 42               33                       393
1317675 1317675 MD     school 2400660 21   Washington 240066000418 1002 Eastern Elementary   Regular School No Elementary 03 05 2021   pk_12_total 141 118 81   * *         68                             418 141 118 81               68                       418
1317829 1317829 MD     school 2400690 22   Wicomico 240069001301 512 East Salisbury Elementary   Regular School No Elementary 03 05 2021   pk_12_total 66 203 81   * *         46                             399 66 203 81               46                       399
1317853 1317853 MD     school 2400690 22   Wicomico 240069001307 905 North Salisbury Elementary   Regular School No Elementary 03 05 2021   pk_12_total 153 172 68   * 43     *   31                             471 153 172 68     43         31                       471
1317935 1317935 MD     school 2400690 22   Wicomico 240069001303 1602 Fruitland Intermediate   Regular School No Elementary 03 05 2021   pk_12_total 196 108 55   * 23         34                             417 196 108 55     23         34                       417
1318347 1318347 MD     school 2400090 30   Baltimore City 240009000164 75 Calverton Elementary/Middle   Regular School No Middle 03 08 2021   pk_12_total * 326 17     *         *                             359   326 17                                       359
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
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
1315661 1315661 MD     school 2400480 15   Montgomery 240048001398 965 John L Gildner Regional Inst for Children & Adol   Special Education School No Other 04 12 2021   pk_12_total 33 37 25     *         10                             108 33 37 25               10                       108
1317821 1317821 MD     school 2400690 22   Wicomico 240069001312 406 Pittsville Elementary & Middle   Regular School No Middle 04 08 2021   pk_12_total 322 * 23   * *         29                             387 322   23               29                       387
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
1317969 1317969 MD     school 2400720 23   Worcester 240072001333 208 Snow Hill Middle   Regular School No Middle 04 08 2021   pk_12_total 232 116 18   * *         35                             407 232 116 18               35                       407
1319208 1319208 MD     school 2400090 30   Baltimore City 240009001736 375 Baltimore Collegiate School for Boys   Regular School Yes Middle 04 08 2021   pk_12_total   455 *   *       *   *                             466   455                                         466
1317161 1317161 MD     school 2400540 17   Queen Anne's 240054001198 101 Sudlersville Middle School   Regular School No Middle 05 08 2021   pk_12_total 303 30 77   * *         27                             443 303 30 77               27                       443
1317980 1317980 MD     school 2400720 23   Worcester 240072001323 311 Berlin Intermediate   Regular School No Middle 05 06 2021   pk_12_total 458 59 69     17         55                             658 458 59 69     17         55                       658
1319187 1319187 MD     school 2400090 30   Baltimore City 240009001734 371 Lillie May Carroll Jackson School   Regular School Yes Middle 05 08 2021   pk_12_total   306 *                                             309   306                                         309
1309800 1309800 MD     school 2400030 1   Allegany 240003000031 406 Washington Middle   Regular School No Middle 06 08 2021   pk_12_total 516 27 *   * *     *   53                             609 516 27                 53                       609
1309812 1309812 MD     school 2400030 1   Allegany 240003000006 504 Braddock Middle   Regular School No Middle 06 08 2021   pk_12_total 502 28 14   * *     *   52                             605 502 28 14               52                       605
1309856 1309856 MD     school 2400030 1   Allegany 240003000007 802 Westmar Middle   Regular School No Middle 06 08 2021   pk_12_total 241   *               *                             256 241                                           256
1309876 1309876 MD     school 2400030 1   Allegany 240003000023 1301 Mount Savage Middle   Regular School No Middle 06 08 2021   pk_12_total 355 * *   * *     *   13                             383 355                   13                       383
1309917 1309917 MD     school 2400060 2   Anne Arundel 240006000050 1023 Brooklyn Park Middle   Regular School No Middle 06 08 2021   pk_12_total 370 221 190   * 18     *   69                             875 370 221 190     18         69                       875
1309926 1309926 MD     school 2400060 2   Anne Arundel 240006000059 1043 Corkran Middle School   Regular School No Middle 06 08 2021   pk_12_total 235 156 161   * 29     *   49                             638 235 156 161     29         49                       638
1309930 1309930 MD     school 2400060 2   Anne Arundel 240006000087 1053 Lindale Middle   Regular School No Middle 06 08 2021   pk_12_total 490 347 222   * 51     *   80                             1194 490 347 222     51         80                       1194
1309934 1309934 MD     school 2400060 2   Anne Arundel 240006000095 1063 Marley Middle   Regular School No Middle 06 08 2021   pk_12_total 335 265 241   * 32     *   78                             956 335 265 241     32         78                       956
1310095 1310095 MD     school 2400060 2   Anne Arundel 240006000072 2033 George Fox Middle   Regular School No Middle 06 08 2021   pk_12_total 634 88 88   * 18     *   62                             899 634 88 88     18         62                       899
1310099 1310099 MD     school 2400060 2   Anne Arundel 240006000126 2043 Severna Park Middle   Regular School No Middle 06 08 2021   pk_12_total 1130 55 76   * 69     *   75                             1412 1130 55 76     69         75                       1412
1310236 1310236 MD     school 2400060 2   Anne Arundel 240006000091 2243 Magothy River Middle   Regular School No Middle 06 08 2021   pk_12_total 533 40 72   * 15     *   51                             714 533 40 72     15         51                       714
1310264 1310264 MD     school 2400060 2   Anne Arundel 240006000124 2413 Severn River Middle   Regular School No Middle 06 08 2021   pk_12_total 588 67 87   * 16         41                             801 588 67 87     16         41                       801
1310268 1310268 MD     school 2400060 2   Anne Arundel 240006000042 2423 Chesapeake Bay Middle   Regular School No Middle 06 08 2021   pk_12_total 908 31 60   * 15         43                             1062 908 31 60     15         43                       1062
1310284 1310284 MD     school 2400060 2   Anne Arundel 240006000039 3023 Arundel Middle   Regular School No Middle 06 08 2021   pk_12_total 501 307 130   * 59     *   116                             1119 501 307 130     59         116                       1119
1310288 1310288 MD     school 2400060 2   Anne Arundel 240006000090 3033 MacArthur Middle   Regular School No Middle 06 08 2021   pk_12_total 172 460 135   * 48     *   71                             898 172 460 135     48         71                       898
1310434 1310434 MD     school 2400060 2   Anne Arundel 240006001403 3263 Crofton Middle   Regular School No Middle 06 08 2021   pk_12_total 720 257 152   * 114     *   87                             1339 720 257 152     114         87                       1339
1310458 1310458 MD     school 2400060 2   Anne Arundel 240006000107 3333 Old Mill Middle North   Regular School No Middle 06 08 2021   pk_12_total 312 479 145   * 42     *   59                             1042 312 479 145     42         59                       1042
1310462 1310462 MD     school 2400060 2   Anne Arundel 240006000108 3343 Old Mill Middle South   Regular School No Middle 06 08 2021   pk_12_total 495 237 169   * 33     *   80                             1018 495 237 169     33         80                       1018
1310517 1310517 MD     school 2400060 2   Anne Arundel 240006000823 3423 Meade Middle   Regular School No Middle 06 08 2021   pk_12_total 67 369 317   * 24     *   44                             826 67 369 317     24         44                       826
1310531 1310531 MD     school 2400060 2   Anne Arundel 240006000036 4033 Annapolis Middle   Regular School No Middle 06 08 2021   pk_12_total 157 309 549   * 19     *   25                             1061 157 309 549     19         25                       1061
1310535 1310535 MD     school 2400060 2   Anne Arundel 240006000041 4043 Wiley H. Bates Middle   Regular School No Middle 06 08 2021   pk_12_total 265 158 215   * 15         28                             682 265 158 215     15         28                       682
1310539 1310539 MD     school 2400060 2   Anne Arundel 240006000131 4053 Southern Middle   Regular School No Middle 06 08 2021   pk_12_total 516 61 152   * *         58                             790 516 61 152               58                       790
1310691 1310691 MD     school 2400060 2   Anne Arundel 240006000054 4283 Central Middle   Regular School No Middle 06 08 2021   pk_12_total 988 61 173   * 48     *   69                             1345 988 61 173     48         69                       1345
1310736 1310736 MD     school 2400060 2   Anne Arundel 240006001401 6223 Chesapeake Science Point   Regular School Yes High 06 12 2021   pk_12_total 138 203 42   * 79     *   36                             500 138 203 42     79         36                       500
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
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
1311009 1311009 MD     school 2400120 3   Baltimore County 240012001431 252 Northwest Academy of Health Sciences   Regular School No Middle 06 08 2021   pk_12_total 17 695 46   * *     *   12                             784 17 695 46               12                       784
1311013 1311013 MD     school 2400120 3   Baltimore County 240012000501 253 Woodlawn Middle   Regular School No Middle 06 08 2021   pk_12_total 11 577 49   * *     *   13                             657 11 577 49               13                       657
1311017 1311017 MD     school 2400120 3   Baltimore County 240012000372 254 Deer Park Middle Magnet School   Regular School No Middle 06 08 2021   pk_12_total 33 1297 88   * 34         38                             1495 33 1297 88     34         38                       1495
1311021 1311021 MD     school 2400120 3   Baltimore County 240012001574 256 Windsor Mill Middle   Regular School No Middle 06 08 2021   pk_12_total * 635 29   * *     *   13                             691   635 29               13                       691
1311076 1311076 MD     school 2400120 3   Baltimore County 240012000448 352 Pikesville Middle   Regular School No Middle 06 08 2021   pk_12_total 157 624 103   * 43     *   32                             967 157 624 103     43         32                       967
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
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
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
1311270 1311270 MD     school 2400120 3   Baltimore County 240012000366 853 Cockeysville Middle   Regular School No Middle 06 08 2021   pk_12_total 373 217 159   * 86         42                             878 373 217 159     86         42                       878
1311274 1311274 MD     school 2400120 3   Baltimore County 240012001422 855 Hereford Middle   Regular School No Middle 06 08 2021   pk_12_total 787 24 36   * 38         34                             920 787 24 36     38         34                       920
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
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
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
1311593 1311593 MD     school 2400120 3   Baltimore County 240012001438 1255 General John Stricker Middle   Regular School No Middle 06 08 2021   pk_12_total 487 152 104   11 16         76                             846 487 152 104   11 16         76                       846
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
1311708 1311708 MD     school 2400120 3   Baltimore County 240012001439 1451 Golden Ring Middle   Regular School No Middle 06 08 2021   pk_12_total 136 523 112   * 42         33                             851 136 523 112     42         33                       851
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
1311880 1311880 MD     school 2400120 3   Baltimore County 240012000478 1554 Stemmers Run Middle   Regular School No Middle 06 08 2021   pk_12_total 379 249 93   11 18         56                             806 379 249 93   11 18         56                       806
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
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
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
1312013 1312013 MD     school 2400150 4   Calvert 240015000027 216 Plum Point Middle   Regular School No Middle 06 08 2021   pk_12_total 492 48 34     10         57                             641 492 48 34     10         57                       641
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
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
1312082 1312082 MD     school 2400180 5   Caroline 240018000526 302 Lockerman Middle School   Regular School No Middle 06 08 2021   pk_12_total 544 96 184     *         69                             902 544 96 184               69                       902

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