enrollments

Data source: Big Local News · About: Big Local

2,791 rows where grade = "pk_12_total" and state = "MD" sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

  • pk_12_total · 2,791 ✖
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
1244572 1244572 MD     school   16   Prince George's   2217 Incarcerated Youth Center (JACS)             2020   pk_12_total   * *                                             10                                             10
1317149 1317149 MD     school   16   Prince George's   2217 Incarcerated Youth Center (JACS)             2021   pk_12_total   * *               *                             11                                             11
1237398 1237398 MD     school 2400060 2   Anne Arundel 240006000071 1112 George T. Cromwell Elementary   Regular School No Elementary 01 05 2020   pk_12_total 160 35 77   * 10     *   17                             301 160 35 77     10         17                       301
1237779 1237779 MD     school 2400060 2   Anne Arundel 240006000092 3122 Manor View Elementary   Regular School No Elementary 01 05 2020   pk_12_total 114 69 65     *     *   42                             301 114 69 65               42                       301
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
1238495 1238495 MD     school 2400120 3   Baltimore County 240012000431 307 Milbrook Elementary   Regular School No Elementary 01 05 2020   pk_12_total 28 241 86   * 22         14                             394 28 241 86     22         14                       394
1239771 1239771 MD     school 2400210 6   Carroll 240021001349 718 PRIDE School   Alternative School No Elementary 01 05 2020   pk_12_total * *                                               *                                              
1246466 1246466 MD     school 2400090 30   Baltimore City 240009001369 314 Sharp-Leadenhall Elementary   Special Education School No Elementary 01 05 2020   pk_12_total * 15                 *                             18   15                                         18
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
1243494 1243494 MD     school 2400510 16   Prince George's 240051001056 712 Heather Hills Elementary   Regular School No Elementary 02 05 2020   pk_12_total 35 245 21     38     *   12                             353 35 245 21     38         12                       353
1244432 1244432 MD     school 2400510 16   Prince George's 240051001043 2010 Glenarden Woods Elementary   Regular School No Elementary 02 05 2020   pk_12_total 51 311 75   * 41     *   11                             491 51 311 75     41         11                       491
1244846 1244846 MD     school 2400570 19   Somerset 240057001743 107 Greenwood Elementary School   Regular School No Elementary 02 05 2020   pk_12_total 80 318 36   * *         26                             468 80 318 36               26                       468
1245268 1245268 MD     school 2400690 22   Wicomico 240069001304 515 Glen Avenue School   Regular School No Elementary 02 05 2020   pk_12_total 92 246 41   * *     *   26                             416 92 246 41               26                       416
1245350 1245350 MD     school 2400690 22   Wicomico 240069001149 1502 Westside Intermediate   Regular School No Elementary 02 05 2020   pk_12_total 267 64 23   *           33                             390 267 64 23               33                       390
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
1239417 1239417 MD     school 2400150 4   Calvert 240015000509 206 Calvert Country School   Special Education School No Other 03 12 2020   pk_12_total 29 * *   * *         *                             46 29                                           46
1239827 1239827 MD     school 2400210 6   Carroll 240021000538 1305 Mount Airy Elementary   Regular School No Elementary 03 05 2020   pk_12_total 352 14 70   * *     *   12                             460 352 14 70               12                       460
1240464 1240464 MD     school 2400330 10   Frederick 240033000639 303 Middletown Elementary   Regular School No Elementary 03 05 2020   pk_12_total 383 14 40   * *         28                             472 383 14 40               28                       472
1240628 1240628 MD     school 2400330 10   Frederick 240033000650 1503 Thurmont Elementary   Regular School No Elementary 03 05 2020   pk_12_total 272   20   *           18                             312 272   20               18                       312
1242256 1242256 MD     school 2400480 15   Montgomery 240048000803 403 Chevy Chase Elementary   Regular School No Elementary 03 05 2020   pk_12_total 259 82 47     40         38                             466 259 82 47     40         38                       466
1242295 1242295 MD     school 2400480 15   Montgomery 240048001452 415 North Chevy Chase Elementary   Regular School No Elementary 03 05 2020   pk_12_total 142 55 30     19         13                             259 142 55 30     19         13                       259
1242735 1242735 MD     school 2400480 15   Montgomery 240048000894 749 Piney Branch Elementary   Regular School No Elementary 03 05 2020   pk_12_total 268 209 107   * 20     *   44                             650 268 209 107     20         44                       650
1242761 1242761 MD     school 2400480 15   Montgomery 240048000893 761 Pine Crest Elementary   Regular School No Elementary 03 05 2020   pk_12_total 97 103 171     18         24                             413 97 103 171     18         24                       413
1242773 1242773 MD     school 2400480 15   Montgomery 240048000887 766 Oak View Elementary   Regular School No Elementary 03 05 2020   pk_12_total 75 51 277     10         10                             423 75 51 277     10         10                       423
1243000 1243000 MD     school 2400480 15   Montgomery 240048000814 808 Cresthaven Elementary   Regular School No Elementary 03 05 2020   pk_12_total 17 186 260   * 34     *   *                             505 17 186 260     34                                 505
1243041 1243041 MD     school 2400480 15   Montgomery 240048000930 822 Strathmore Elementary   Regular School No Elementary 03 05 2020   pk_12_total 45 180 221   * 22         13                             483 45 180 221     22         13                       483
1244606 1244606 MD     school 2400540 17   Queen Anne's 240054001070 302 Kennard Elementary School   Regular School No Elementary 03 05 2020   pk_12_total 420 20 30     *         28                             501 420 20 30               28                       501
1244624 1244624 MD     school 2400540 17   Queen Anne's 240054000202 403 Bayside Elementary School   Regular School No Elementary 03 05 2020   pk_12_total 326 18 32   * *         35                             420 326 18 32               35                       420
1245100 1245100 MD     school 2400660 21   Washington 240066000418 1002 Eastern Elementary   Regular School No Elementary 03 05 2020   pk_12_total 152 123 72   * 14         71                             434 152 123 72     14         71                       434
1245253 1245253 MD     school 2400690 22   Wicomico 240069001301 512 East Salisbury Elementary   Regular School No Elementary 03 05 2020   pk_12_total 102 213 81   * *         50                             451 102 213 81               50                       451
1245277 1245277 MD     school 2400690 22   Wicomico 240069001307 905 North Salisbury Elementary   Regular School No Elementary 03 05 2020   pk_12_total 166 168 54   * 40     *   35                             467 166 168 54     40         35                       467
1245359 1245359 MD     school 2400690 22   Wicomico 240069001303 1602 Fruitland Intermediate   Regular School No Elementary 03 05 2020   pk_12_total 210 100 52   * 17         35                             416 210 100 52     17         35                       416
1245969 1245969 MD     school 2400090 30   Baltimore City 240009000171 159 The Historic Cherry Hill Elementary/Middle   Regular School No Middle 03 08 2020   pk_12_total * 641 29   *           *                             680   641 29                                       680
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
1238203 1238203 MD     school 2400120 3   Baltimore County 240012000925 57 Home Assignments-Elementary   Alternative School No Middle 04 06 2020   pk_12_total   *                                               *                                              
1239034 1239034 MD     school 2400120 3   Baltimore County 240012000408 1253 Holabird Middle   Regular School No Middle 04 08 2020   pk_12_total 459 130 289   14 25         53                             970 459 130 289   14 25         53                       970
1243081 1243081 MD     school 2400480 15   Montgomery 240048001398 965 John L Gildner Regional Inst for Children & Adol   Special Education School No Other 04 12 2020   pk_12_total 35 41 25     *         *                             112 35 41 25                                       112
1245245 1245245 MD     school 2400690 22   Wicomico 240069001312 406 Pittsville Elementary & Middle   Regular School No Middle 04 08 2020   pk_12_total 340 14 21   * *         27                             406 340 14 21               27                       406
1245376 1245376 MD     school 2400720 23   Worcester 240072001329 108 Pocomoke Middle   Regular School No Middle 04 08 2020   pk_12_total 166 186 22     *         21                             402 166 186 22               21                       402
1245393 1245393 MD     school 2400720 23   Worcester 240072001333 208 Snow Hill Middle   Regular School No Middle 04 08 2020   pk_12_total 250 112 19   * *         32                             420 250 112 19               32                       420
1245405 1245405 MD     school 2400720 23   Worcester 240072001323 311 Berlin Intermediate   Regular School No Middle 04 06 2020   pk_12_total 584 63 73   * 19         59                             799 584 63 73     19         59                       799
1246665 1246665 MD     school 2400090 30   Baltimore City 240009001736 375 Baltimore Collegiate School for Boys   Regular School Yes Middle 04 08 2020   pk_12_total * 421 *   *           *                             432   421                                         432
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
1244583 1244583 MD     school 2400540 17   Queen Anne's 240054001198 101 Sudlersville Middle School   Regular School No Middle 05 08 2020   pk_12_total 341 36 87   * *         26                             497 341 36 87               26                       497
1246644 1246644 MD     school 2400090 30   Baltimore City 240009001734 371 Lillie May Carroll Jackson School   Regular School Yes Middle 05 08 2020   pk_12_total * 300 *                                             308   300                                         308
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
1237239 1237239 MD     school 2400030 1   Allegany 240003000031 406 Washington Middle   Regular School No Middle 06 08 2020   pk_12_total 522 35 *     *     *   46                             612 522 35                 46                       612
1237251 1237251 MD     school 2400030 1   Allegany 240003000006 504 Braddock Middle   Regular School No Middle 06 08 2020   pk_12_total 510 26 15     10     *   57                             620 510 26 15     10         57                       620
1237295 1237295 MD     school 2400030 1   Allegany 240003000007 802 Westmar Middle   Regular School No Middle 06 08 2020   pk_12_total 258   *     *         *                             268 258                                           268
1237315 1237315 MD     school 2400030 1   Allegany 240003000023 1301 Mount Savage Middle   Regular School No Middle 06 08 2020   pk_12_total 369 * *   * *     *   12                             394 369                   12                       394
1237356 1237356 MD     school 2400060 2   Anne Arundel 240006000050 1023 Brooklyn Park Middle   Regular School No Middle 06 08 2020   pk_12_total 350 217 185   * 16     *   64                             837 350 217 185     16         64                       837
1237365 1237365 MD     school 2400060 2   Anne Arundel 240006000059 1043 Corkran Middle School   Regular School No Middle 06 08 2020   pk_12_total 237 176 167   * 25     *   46                             657 237 176 167     25         46                       657
1237369 1237369 MD     school 2400060 2   Anne Arundel 240006000087 1053 Lindale Middle   Regular School No Middle 06 08 2020   pk_12_total 480 302 202   * 64     *   71                             1126 480 302 202     64         71                       1126
1237373 1237373 MD     school 2400060 2   Anne Arundel 240006000095 1063 Marley Middle   Regular School No Middle 06 08 2020   pk_12_total 359 255 213   * 28     *   79                             938 359 255 213     28         79                       938
1237533 1237533 MD     school 2400060 2   Anne Arundel 240006000072 2033 George Fox Middle   Regular School No Middle 06 08 2020   pk_12_total 626 91 85   * 18     *   55                             884 626 91 85     18         55                       884
1237537 1237537 MD     school 2400060 2   Anne Arundel 240006000126 2043 Severna Park Middle   Regular School No Middle 06 08 2020   pk_12_total 1162 52 87   * 66     *   77                             1453 1162 52 87     66         77                       1453
1237674 1237674 MD     school 2400060 2   Anne Arundel 240006000091 2243 Magothy River Middle   Regular School No Middle 06 08 2020   pk_12_total 555 38 65   * 16     *   45                             723 555 38 65     16         45                       723
1237702 1237702 MD     school 2400060 2   Anne Arundel 240006000124 2413 Severn River Middle   Regular School No Middle 06 08 2020   pk_12_total 597 60 93   * 19         39                             809 597 60 93     19         39                       809
1237706 1237706 MD     school 2400060 2   Anne Arundel 240006000042 2423 Chesapeake Bay Middle   Regular School No Middle 06 08 2020   pk_12_total 898 44 61   * 14         31                             1056 898 44 61     14         31                       1056
1237722 1237722 MD     school 2400060 2   Anne Arundel 240006000039 3023 Arundel Middle   Regular School No Middle 06 08 2020   pk_12_total 480 283 118   * 57     *   122                             1068 480 283 118     57         122                       1068
1237726 1237726 MD     school 2400060 2   Anne Arundel 240006000090 3033 MacArthur Middle   Regular School No Middle 06 08 2020   pk_12_total 191 505 127   * 53     *   67                             959 191 505 127     53         67                       959
1237869 1237869 MD     school 2400060 2   Anne Arundel 240006001403 3263 Crofton Middle   Regular School No Middle 06 08 2020   pk_12_total 746 271 136   * 105     *   76                             1345 746 271 136     105         76                       1345
1237893 1237893 MD     school 2400060 2   Anne Arundel 240006000107 3333 Old Mill Middle North   Regular School No Middle 06 08 2020   pk_12_total 345 475 144   * 48     *   66                             1081 345 475 144     48         66                       1081

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