enrollments

Data source: Big Local News · About: Big Local

1,398 rows where grade = "pk_12_total", state = "MD" and year = 2020 sorted by black_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 1,298 ✖

grade ✖

  • pk_12_total · 1,298 ✖
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
1244578 1244578 MD     school 2400510 16   Prince George's 240051001476 2300 Prekindergarten Offsites   Regular School No Prekindergarten PK PK 2020   pk_12_total * 12 *               *                             16   12                                         16
1244883 1244883 MD     school 2400570 19   Somerset 240057001202 1401 Deal Island School   Regular School No Elementary PK 05 2020   pk_12_total 115 12 *     *         *                             139 115 12                                         139
1245049 1245049 MD     school 2400660 21   Washington 240066001256 601 Boonsboro High   Regular School No High 09 12 2020   pk_12_total 807 12 30   * 21         31                             902 807 12 30     21         31                       902
1245440 1245440 MD     school 2400720 23   Worcester 240072001327 1001 Ocean City Elementary   Regular School No Elementary PK 04 2020   pk_12_total 455 12 76     12         37                             592 455 12 76     12         37                       592
1237344 1237344 MD     school 2400030 1   Allegany 240003001338 2901 Cash Valley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 242 13 *   * *         12                             279 242 13                 12                       279
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
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
1239914 1239914 MD     school 2400240 7   Cecil 240024001491 317 Kenmore Elementary   Regular School No Elementary PK 05 2020   pk_12_total 240 13 33               19                             305 240 13 33               19                       305
1240736 1240736 MD     school 2400330 10   Frederick 240033000647 2404 Rock Creek   Special Education School No Other PK 12 2020   pk_12_total 43 13 12     *         *                             74 43 13 12                                       74
1241032 1241032 MD     school 2400390 12   Harford 240039002948 326 Forest Hill Elementary   Regular School No Elementary KG 05 2020   pk_12_total 429 13 28     13         24                             507 429 13 28     13         24                       507
1242283 1242283 MD     school 2400480 15   Montgomery 240048000787 410 Bradley Hills Elementary   Regular School No Elementary KG 05 2020   pk_12_total 372 13 37     86         58                             566 372 13 37     86         58                       566
1238116 1238116 MD     school 2400060 2   Anne Arundel 240006000136 4262 Tyler Heights Elementary   Regular School No Elementary PK 05 2020   pk_12_total   14 466     *         *                             488   14 466                                       488
1239810 1239810 MD     school 2400210 6   Carroll 240021000555 906 Winfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 550 14 24   * *     *   11                             608 550 14 24               11                       608
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
1240536 1240536 MD     school 2400330 10   Frederick 240033000643 903 New Market Elementary   Regular School No Elementary PK 05 2020   pk_12_total 569 14 43   * 25     *   28                             684 569 14 43     25         28                       684
1240559 1240559 MD     school 2400330 10   Frederick 240033001412 915 Kemptown Elementary   Regular School No Elementary KG 05 2020   pk_12_total 301 14 42   * 14         31                             403 301 14 42     14         31                       403
1240624 1240624 MD     school 2400330 10   Frederick 240033000653 1406 Valley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 395 14 65   * *     *   23                             508 395 14 65               23                       508
1241083 1241083 MD     school 2400390 12   Harford 240039000717 348 Youths Benefit Elementary   Regular School No Elementary KG 05 2020   pk_12_total 939 14 40   * 24     *   34                             1057 939 14 40     24         34                       1057
1244590 1244590 MD     school 2400540 17   Queen Anne's 240054001197 106 Sudlersville Elementary School   Regular School No Elementary PK 04 2020   pk_12_total 172 14 109               17                             312 172 14 109               17                       312
1244620 1244620 MD     school 2400540 17   Queen Anne's 240054001194 402 Kent Island Elementary School   Regular School No Elementary PK 02 2020   pk_12_total 360 14 39   * *         28                             448 360 14 39               28                       448
1245074 1245074 MD     school 2400660 21   Washington 240066001286 702 Smithsburg Elementary   Regular School No Elementary PK 05 2020   pk_12_total 318 14 21     *         25                             379 318 14 21               25                       379
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
1237352 1237352 MD     school 2400030 1   Allegany 240003000026 2902 Parkside Elementary   Regular School No Elementary PK 05 2020   pk_12_total 164 15 *     *         18                             210 164 15                 18                       210
1239794 1239794 MD     school 2400210 6   Carroll 240021090467 806 Spring Garden Elementary   Regular School No Elementary PK 05 2020   pk_12_total 351 15 29     *         16                             416 351 15 29               16                       416
1239831 1239831 MD     school 2400210 6   Carroll 240021000539 1306 Mount Airy Middle   Regular School No Middle 06 08 2020   pk_12_total 594 15 64   * 20         18                             714 594 15 64     20         18                       714
1245411 1245411 MD     school 2400720 23   Worcester 240072001498 312 Showell Elementary   Regular School No Elementary PK 03 2020   pk_12_total 462 15 29   * 17         31                             555 462 15 29     17         31                       555
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
1237247 1237247 MD     school 2400030 1   Allegany 240003000024 502 Northeast Elementary   Regular School No Elementary PK 05 2020   pk_12_total 268 16 *   * *         30                             319 268 16                 30                       319
1237581 1237581 MD     school 2400060 2   Anne Arundel 240006000067 2102 Folger Mckinsey Elementary   Regular School No Elementary KG 05 2020   pk_12_total 525 16 29   * 19         22                             612 525 16 29     19         22                       612
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
1238675 1238675 MD     school 2400120 3   Baltimore County 240012000462 809 Riderwood Elementary   Regular School No Elementary KG 05 2020   pk_12_total 360 16 20     32         25                             453 360 16 20     32         25                       453
1239582 1239582 MD     school 2400210 6   Carroll 240021000543 105 Northwest Middle   Regular School No Middle 06 08 2020   pk_12_total 583 16 32   * *         39                             682 583 16 32               39                       682
1239844 1239844 MD     school 2400240 7   Cecil 240024000562 104 Cecilton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 244 16 46   *           12                             319 244 16 46               12                       319
1240478 1240478 MD     school 2400330 10   Frederick 240033001566 314 Middletown Primary   Regular School No Elementary PK 02 2020   pk_12_total 377 16 40     14         30                             477 377 16 40     14         30                       477
1243071 1243071 MD     school 2400480 15   Montgomery 240048000867 951 Longview School   Special Education School No Other KG 12 2020   pk_12_total 17 16 21     *                                       61 17 16 21                                       61
1244258 1244258 MD     school 2400510 16   Prince George's 240051001738 1732 International High School @ Langley Park   Regular School No High 09 12 2020   pk_12_total 12 16 300     12                                       340 12 16 300     12                                 340
1245061 1245061 MD     school 2400660 21   Washington 240066001254 603 Boonsboro Elementary   Regular School No Elementary PK 05 2020   pk_12_total 564 16 21     *     *   17                             622 564 16 21               17                       622
1237262 1237262 MD     school 2400030 1   Allegany 240003000032 603 West Side Elementary   Regular School No Elementary PK 05 2020   pk_12_total 288 17 *   * *         52                             367 288 17                 52                       367
1237328 1237328 MD     school 2400030 1   Allegany 240003001636 2404 Mountain Ridge High School   Regular School No High 09 12 2020   pk_12_total 729 17 *   * *         24                             784 729 17                 24                       784
1237574 1237574 MD     school 2400060 2   Anne Arundel 240006000051 2092 Cape St. Claire Elementary   Regular School No Elementary KG 05 2020   pk_12_total 473 17 70   * 14     *   48                             625 473 17 70     14         48                       625
1237634 1237634 MD     school 2400060 2   Anne Arundel 240006000113 2182 Pasadena Elementary   Regular School No Elementary KG 05 2020   pk_12_total 297 17 26     *         19                             364 297 17 26               19                       364
1238009 1238009 MD     school 2400060 2   Anne Arundel 240006000053 4112 Central Elementary   Regular School No Elementary KG 05 2020   pk_12_total 488 17 55   * 18         22                             601 488 17 55     18         22                       601
1238210 1238210 MD     school 2400120 3   Baltimore County 240012000935 58 Home Assignments-Secondary   Alternative School No High 07 12 2020   pk_12_total * 17                 *                             26   17                                         26
1239170 1239170 MD     school 2400120 3   Baltimore County 240012000381 1502 Edgemere Elementary   Regular School No Elementary PK 05 2020   pk_12_total 396 17 21   * *         34                             475 396 17 21               34                       475
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
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
1237589 1237589 MD     school 2400060 2   Anne Arundel 240006000068 2112 Fort Smallwood Elementary   Regular School No Elementary PK 05 2020   pk_12_total 416 18 15     *         14                             468 416 18 15               14                       468
1238016 1238016 MD     school 2400060 2   Anne Arundel 240006000062 4122 Davidsonville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 559 18 41   * 20     *   37                             678 559 18 41     20         37                       678
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
1239836 1239836 MD     school 2400210 6   Carroll 240021000546 1401 South Carroll High   Regular School No High 09 12 2020   pk_12_total 881 18 68   * 22     *   17                             1011 881 18 68     22         17                       1011
1242617 1242617 MD     school 2400480 15   Montgomery 240048001635 587 PEP - Itinerant   Special Education School No Prekindergarten PK PK 2020   pk_12_total 43 18 16   * 16         *                             100 43 18 16     16                                 100
1244597 1244597 MD     school 2400540 17   Queen Anne's 240054001192 202 Church Hill Elementary School   Regular School No Elementary PK 04 2020   pk_12_total 196 18 26     *         22                             263 196 18 26               22                       263
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
1244932 1244932 MD     school 2400630 20   Talbot 240063001241 401 Chapel District Elementary   Regular School No Elementary PK 05 2020   pk_12_total 305 18 27     *         17                             371 305 18 27               17                       371
1239008 1239008 MD     school 2400120 3   Baltimore County 240012000346 1215 Battle Monument School   Special Education School No Other PK 12 2020   pk_12_total 30 19 *     *         *                             63 30 19                                         63
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
1240388 1240388 MD     school 2400330 10   Frederick 240033001410 208 Heather Ridge   Alternative School No High 06 12 2020   pk_12_total 21 19 *   *           *                             56 21 19                                         56
1240473 1240473 MD     school 2400330 10   Frederick 240033000641 313 Middletown High   Regular School No High 09 12 2020   pk_12_total 970 19 70   * 26         42                             1129 970 19 70     26         42                       1129
1244730 1244730 MD     school 2400600 18   Saint Mary's 240060001240 503 White Marsh Elementary   Regular School No Elementary KG 05 2020   pk_12_total 195 19 *     *         18                             242 195 19                 18                       242
1245426 1245426 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2020   pk_12_total 28 19 *     *         *                             55 28 19                                         55
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
1237267 1237267 MD     school 2400030 1   Allegany 240003000001 606 Allegany High   Regular School No High 09 12 2020   pk_12_total 631 21 15   * 11         41                             721 631 21 15     11         41                       721
1237978 1237978 MD     school 2400060 2   Anne Arundel 240006001729 4064 Mary Moss at Adams Academy   Alternative School No Middle 07 09 2020   pk_12_total 11 21 *               *                             44 11 21                                         44
1238719 1238719 MD     school 2400120 3   Baltimore County 240012001422 855 Hereford Middle   Regular School No Middle 06 08 2020   pk_12_total 839 21 38     40         34                             972 839 21 38     40         34                       972
1241388 1241388 MD     school 2400420 13   Howard 240042000760 302 West Friendship Elementary   Regular School No Elementary KG 05 2020   pk_12_total 251 21 16     79     *   25                             393 251 21 16     79         25                       393
1242467 1242467 MD     school 2400480 15   Montgomery 240048001365 525 MCPS Transitions School   Special Education School No High 12 12 2020   pk_12_total 13 21 15     *         *                             55 13 21 15                                       55
1243950 1243950 MD     school 2400510 16   Prince George's 240051001737 1352 International High school @ Largo   Regular School No High 09 12 2020   pk_12_total * 21 342     19                                       385   21 342     19                                 385
1244723 1244723 MD     school 2400600 18   Saint Mary's 240060001399 501 Lettie Marshall Dent Elem   Regular School No Elementary PK 05 2020   pk_12_total 511 21 14   * *         27                             583 511 21 14               27                       583
1237230 1237230 MD     school 2400030 1   Allegany 240003000019 402 John Humbird Elementary   Regular School No Elementary PK 05 2020   pk_12_total 216 22 *               35                             279 216 22                 35                       279
1239751 1239751 MD     school 2400210 6   Carroll 240021000052 714 Friendship Valley Elementary   Regular School No Elementary KG 05 2020   pk_12_total 381 22 53     *     *   22                             488 381 22 53               22                       488
1240541 1240541 MD     school 2400330 10   Frederick 240033000638 912 Linganore High   Regular School No High 09 12 2020   pk_12_total 1131 22 97   * 12     *   46                             1311 1131 22 97     12         46                       1311
1241941 1241941 MD     school 2400480 15   Montgomery 240048000937 216 Travilah Elementary   Regular School No Elementary KG 05 2020   pk_12_total 109 22 35     159     *   14                             341 109 22 35     159         14                       341
1242303 1242303 MD     school 2400480 15   Montgomery 240048000958 417 Wood Acres Elementary   Regular School No Elementary PK 05 2020   pk_12_total 428 22 87     67         45                             649 428 22 87     67         45                       649
1242317 1242317 MD     school 2400480 15   Montgomery 240048000779 420 Bannockburn Elementary   Regular School No Elementary KG 05 2020   pk_12_total 307 22 50     52         30                             461 307 22 50     52         30                       461
1237810 1237810 MD     school 2400060 2   Anne Arundel 240006000100 3162 Millersville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 249 23 30     *     *   33                             344 249 23 30               33                       344
1242972 1242972 MD     school 2400480 15   Montgomery 240048000496 799 Stephen Knolls School   Special Education School No Other PK 12 2020   pk_12_total 15 23 33     *         *                             76 15 23 33                                       76
1238123 1238123 MD     school 2400060 2   Anne Arundel 240006000139 4272 West Annapolis Elementary   Regular School No Elementary KG 05 2020   pk_12_total 162 24 40   * *         20                             251 162 24 40               20                       251
1238241 1238241 MD     school 2400120 3   Baltimore County 240012001711 77 BCDC Educational Center   Alternative School No High 09 12 2020   pk_12_total * 24 *                                             33   24                                         33
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
1239723 1239723 MD     school 2400210 6   Carroll 240021000551 710 Westminster Elementary   Regular School No Elementary PK 05 2020   pk_12_total 382 24 65     29     *   36                             538 382 24 65     29         36                       538
1240468 1240468 MD     school 2400330 10   Frederick 240033000640 311 Middletown Middle   Regular School No Middle 06 08 2020   pk_12_total 652 24 55   * 15     *   33                             784 652 24 55     15         33                       784
1242061 1242061 MD     school 2400480 15   Montgomery 240048000861 247 John H. Poole Middle   Regular School No Middle 06 08 2020   pk_12_total 268 24 51   * 26         20                             390 268 24 51     26         20                       390
1244745 1244745 MD     school 2400600 18   Saint Mary's 240060001233 602 Oakville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 240 24 10     *         23                             299 240 24 10               23                       299
1244945 1244945 MD     school 2400660 21   Washington 240066001674 40 Barbara Ingram School for the Arts   Regular School No High 09 12 2020   pk_12_total 224 24 30     *         17                             303 224 24 30               17                       303
1238221 1238221 MD     school 2400120 3   Baltimore County 240012000777 70 Meadowood Education Center   Alternative School No Middle 07 08 2020   pk_12_total * 25 *   * *         *                             33   25                                         33
1239759 1239759 MD     school 2400210 6   Carroll 240021001105 715 Cranberry Station Elementary   Regular School No Elementary PK 05 2020   pk_12_total 421 25 51   * *         25                             528 421 25 51               25                       528
1241090 1241090 MD     school 2400390 12   Harford 240039001698 349 Red Pump Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 660 25 35     12         40                             772 660 25 35     12         40                       772
1242238 1242238 MD     school 2400480 15   Montgomery 240048000817 351 Darnestown Elementary   Regular School No Elementary KG 05 2020   pk_12_total 216 25 25     41         16                             323 216 25 25     41         16                       323
1242687 1242687 MD     school 2400480 15   Montgomery 240048000815 702 Damascus Elementary   Regular School No Elementary PK 05 2020   pk_12_total 169 25 129   * 17         21                             362 169 25 129     17         21                       362
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
1238108 1238108 MD     school 2400060 2   Anne Arundel 240006000135 4252 Traceys Elementary   Regular School No Elementary KG 05 2020   pk_12_total 258 26 127               21                             432 258 26 127               21                       432
1240297 1240297 MD     school 2400300 9   Dorchester 240030000624 302 Vienna Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 131 26 *     *         18                             183 131 26                 18                       183
1241840 1241840 MD     school 2400480 15   Montgomery 240048000896 153 Poolesville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 316 26 65     36     *   45                             489 316 26 65     36         45                       489
1243057 1243057 MD     school 2400480 15   Montgomery 240048001460 916 Rock Terrace School   Special Education School No High 06 12 2020   pk_12_total 27 26 24     11         *                             92 27 26 24     11                                 92
1244236 1244236 MD     school 2400510 16   Prince George's 240051000510 1725 Cool Spring Elementary   Regular School No Elementary PK 06 2020   pk_12_total 12 26 867   * *         *                             915 12 26 867                                       915
1245239 1245239 MD     school 2400690 22   Wicomico 240069001308 106 Northwestern Elementary   Regular School No Elementary PK 05 2020   pk_12_total 256 26 10   * *         35                             334 256 26 10               35                       334
1237627 1237627 MD     school 2400060 2   Anne Arundel 240006000104 2172 Oak Hill Elementary   Regular School No Elementary PK 05 2020   pk_12_total 575 27 26   * 43     *   43                             716 575 27 26     43         43                       716
1240280 1240280 MD     school 2400300 9   Dorchester 240030000625 205 Warwick Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 294 27 18     *         19                             361 294 27 18               19                       361

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