enrollments

Data source: Big Local News · About: Big Local

19,213 rows where state = "MD" sorted by asian_int

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

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
1239520 1239520 MD     school 2400180 5   Caroline 240018000522 201 Greensboro Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 386 31 356     *         50                             825 386 31 356               50                       825
1239532 1239532 MD     school 2400180 5   Caroline 240018000526 302 Lockerman Middle School   Regular School No Middle 06 08 2020   pk_12_total 591 97 179     *         73                             949 591 97 179               73                       949
1239540 1239540 MD     school 2400180 5   Caroline 240018000524 401 Preston Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 299 36 27   * *         38                             403 299 36 27               38                       403
1239556 1239556 MD     school 2400180 5   Caroline 240018000525 701 Ridgely Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 341 40 39   * *         46                             469 341 40 39               46                       469
1239570 1239570 MD     school 2400180 5   Caroline 240018000519 802 Colonel Richardson Middle School   Regular School No Middle 06 08 2020   pk_12_total 260 96 31   * *         35                             432 260 96 31               35                       432
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
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
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
1239731 1239731 MD     school 2400210 6   Carroll 240021000544 711 Robert Moton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 267 53 79   * *     *   30                             434 267 53 79               30                       434
1239744 1239744 MD     school 2400210 6   Carroll 240021000527 712 Carroll Springs School   Special Education School No Other PK 12 2020   pk_12_total 26 * *     *                                       33 26                                           33
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
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
1239764 1239764 MD     school 2400210 6   Carroll 240021001548 716 Gateway School   Alternative School No High 09 12 2020   pk_12_total 54 * *   * *         *                             66 54                                           66
1239786 1239786 MD     school 2400210 6   Carroll 240021000535 804 Hampstead Elementary   Regular School No Elementary PK 05 2020   pk_12_total 345 11 19     *         16                             393 345 11 19               16                       393
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
1239802 1239802 MD     school 2400210 6   Carroll 240021001350 903 Flexible Student Support   Alternative School No High 09 12 2020   pk_12_total 19         *         *                             22 19                                           22
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
1239818 1239818 MD     school 2400210 6   Carroll 240021000532 1201 Elmer A. Wolfe Elementary   Regular School No Elementary PK 05 2020   pk_12_total 400 * 11   * *         18                             437 400   11               18                       437
1239823 1239823 MD     school 2400210 6   Carroll 240021001414 1304 Parr's Ridge Elementary   Regular School No Elementary PK 02 2020   pk_12_total 367 * 63     *     *   15                             459 367   63               15                       459
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
1239849 1239849 MD     school 2400240 7   Cecil 240024000558 204 Bohemia Manor High   Regular School No High 09 12 2020   pk_12_total 539 39 42   * *         25                             647 539 39 42               25                       647
1239861 1239861 MD     school 2400240 7   Cecil 240024000791 206 Bohemia Manor Middle   Regular School No Middle 06 08 2020   pk_12_total 385 34 43   * *     *   28                             495 385 34 43               28                       495
1239870 1239870 MD     school 2400240 7   Cecil 240024000567 303 Elkton Middle   Regular School No Middle 06 08 2020   pk_12_total 234 157 93   * *     *   73                             571 234 157 93               73                       571
1239878 1239878 MD     school 2400240 7   Cecil 240024000569 310 Gilpin Manor Elementary   Regular School No Elementary PK 05 2020   pk_12_total 175 139 53     *         52                             425 175 139 53               52                       425
1239886 1239886 MD     school 2400240 7   Cecil 240024000570 311 Holly Hall Elementary   Regular School No Elementary PK 05 2020   pk_12_total 246 77 59   * *         43                             430 246 77 59               43                       430
1239922 1239922 MD     school 2400240 7   Cecil 240024000560 401 Cecil Manor Elementary   Regular School No Elementary PK 05 2020   pk_12_total 191 108 61     *         47                             408 191 108 61               47                       408
1239926 1239926 MD     school 2400240 7   Cecil 240024000574 504 North East Middle   Regular School No Middle 06 08 2020   pk_12_total 634 57 52   * *     *   33                             786 634 57 52               33                       786
1239934 1239934 MD     school 2400240 7   Cecil 240024000573 506 North East Elementary   Regular School No Elementary PK 05 2020   pk_12_total 399 54 39   * *     *   45                             542 399 54 39               45                       542
1239963 1239963 MD     school 2400240 7   Cecil 240024090468 515 Elk Neck Elementary   Regular School No Elementary PK 05 2020   pk_12_total 399 * 12     *         25                             443 399   12               25                       443
1239967 1239967 MD     school 2400240 7   Cecil 240024000580 606 Rising Sun Middle School   Regular School No Middle 06 08 2020   pk_12_total 640 * 34   * *         21                             702 640   34               21                       702
1239975 1239975 MD     school 2400240 7   Cecil 240024000579 607 Rising Sun Elementary   Regular School No Elementary PK 05 2020   pk_12_total 602 * 46     *         26                             681 602   46               26                       681
1239979 1239979 MD     school 2400240 7   Cecil 240024000578 701 Perryville Middle   Regular School No Middle 06 08 2020   pk_12_total 477 42 22   * *     *   44                             590 477 42 22               44                       590
1239987 1239987 MD     school 2400240 7   Cecil 240024000576 703 Perryville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 295 36 24     *         35                             393 295 36 24               35                       393
1240000 1240000 MD     school 2400240 7   Cecil 240024000577 705 Perryville High   Regular School No High 09 12 2020   pk_12_total 661 39 41   * *     *   50                             801 661 39 41               50                       801
1240067 1240067 MD     school 2400270 8   Charles 240027000610 501 Dr. Thomas L. Higdon Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 313 60 14     *         33                             426 313 60 14               33                       426
1240071 1240071 MD     school 2400270 8   Charles 240027000604 503 Piccowaxen Middle School   Regular School No Middle 06 08 2020   pk_12_total 332 49 23   * *     *   34                             450 332 49 23               34                       450
1240112 1240112 MD     school 2400270 8   Charles 240027000584 611 Dr. Gustavus Brown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 39 270 76   * *         36                             426 39 270 76               36                       426
1240132 1240132 MD     school 2400270 8   Charles 240027000586 616 Eva Turner Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 26 334 53   * *         26                             443 26 334 53               26                       443
1240222 1240222 MD     school 2400270 8   Charles 240027000589 705 General Smallwood Middle School   Regular School No Middle 06 08 2020   pk_12_total 201 247 23   * *     *   45                             527 201 247 23               45                       527
1240238 1240238 MD     school 2400270 8   Charles 240027000591 710 Indian Head Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 117 251 39     *         59                             473 117 251 39               59                       473
1240246 1240246 MD     school 2400270 8   Charles 240027000606 801 T. C. Martin Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 302 125 33   * *     *   55                             522 302 125 33               55                       522
1240259 1240259 MD     school 2400270 8   Charles 240027000598 902 Malcolm Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 158 156 59     *     *   55                             436 158 156 59               55                       436
1240267 1240267 MD     school 2400270 8   Charles 240027000588 1001 Gale-Bailey Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 192 132 29     *         39                             395 192 132 29               39                       395
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
1240285 1240285 MD     school 2400300 9   Dorchester 240030000618 207 North Dorchester High School   Regular School No High 09 12 2020   pk_12_total 349 112 39     *         28                             533 349 112 39               28                       533
1240289 1240289 MD     school 2400300 9   Dorchester 240030000619 208 North Dorchester Middle School   Regular School No Middle 06 08 2020   pk_12_total 277 117 34     *         40                             477 277 117 34               40                       477
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
1240308 1240308 MD     school 2400300 9   Dorchester 240030000622 508 South Dorchester School   Regular School No Elementary PK 08 2020   pk_12_total 196 * 15     *     *   12                             231 196   15               12                       231
1240312 1240312 MD     school 2400300 9   Dorchester 240030001423 707 Mace's Lane Middle School   Regular School No Middle 06 08 2020   pk_12_total 72 400 55     *     *   41                             576 72 400 55               41                       576
1240320 1240320 MD     school 2400300 9   Dorchester 240030000621 710 Sandy Hill Elementary   Regular School No Elementary PK 05 2020   pk_12_total 77 241 35     *         34                             395 77 241 35               34                       395
1240349 1240349 MD     school 2400300 9   Dorchester 240030000614 1503 Hurlock Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 163 133 38     *     *   32                             374 163 133 38               32                       374
1240372 1240372 MD     school 2400330 10   Frederick 240033000646 201 Parkway Elementary   Regular School No Elementary KG 05 2020   pk_12_total 144 32 41   * *         15                             242 144 32 41               15                       242
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
1240486 1240486 MD     school 2400330 10   Frederick 240033000631 503 Emmitsburg Elementary   Regular School No Elementary PK 05 2020   pk_12_total 193 * *     *         12                             220 193                   12                       220
1240528 1240528 MD     school 2400330 10   Frederick 240033000637 801 Liberty Elementary   Regular School No Elementary KG 05 2020   pk_12_total 216 * 22   * *         17                             262 216   22               17                       262
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
1240633 1240633 MD     school 2400330 10   Frederick 240033000629 1509 Catoctin High   Regular School No High 09 12 2020   pk_12_total 672 * 38   * *     *   22                             749 672   38               22                       749
1240637 1240637 MD     school 2400330 10   Frederick 240033000651 1510 Thurmont Middle   Regular School No Middle 06 08 2020   pk_12_total 494 * 24   * *     *   15                             545 494   24               15                       545
1240642 1240642 MD     school 2400330 10   Frederick 240033001166 1511 Thurmont Primary   Regular School No Elementary PK 02 2020   pk_12_total 301   17     *     *   16                             336 301   17               16                       336
1240649 1240649 MD     school 2400330 10   Frederick 240033000642 1604 Myersville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 362 11 23   * *         18                             418 362 11 23               18                       418
1240657 1240657 MD     school 2400330 10   Frederick 240033000159 1801 Twin Ridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 396 * 46   * *         17                             473 396   46               17                       473
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
1240851 1240851 MD     school 2400360 11   Garrett 240036000675 2708 Southern Middle School   Regular School No Middle 06 08 2020   pk_12_total 487 * *     *         12                             507 487                   12                       507
1240856 1240856 MD     school 2400360 11   Garrett 240036000671 3512 Northern Garrett High School   Regular School No High 09 12 2020   pk_12_total 426   *     *         *                             441 426                                           441
1240861 1240861 MD     school 2400360 11   Garrett 240036000674 3709 Southern Garrett High School   Regular School No High 09 12 2020   pk_12_total 670 * 12     *         15                             701 670   12               15                       701
1240876 1240876 MD     school 2400390 12   Harford 240039000688 115 Edgewood Elementary   Regular School No Elementary PK 05 2020   pk_12_total 103 228 54   * *     *   16                             405 103 228 54               16                       405
1240915 1240915 MD     school 2400390 12   Harford 240039000706 131 Magnolia Elementary   Regular School No Elementary PK 05 2020   pk_12_total 54 356 61   * *         72                             550 54 356 61               72                       550
1240953 1240953 MD     school 2400390 12   Harford 240039000705 181 Joppatowne High   Regular School No High 09 12 2020   pk_12_total 197 383 88   * *     *   60                             745 197 383 88               60                       745
1240974 1240974 MD     school 2400390 12   Harford 240039000700 211 G. Lisby Elementary at Hillsdale   Regular School No Elementary PK 05 2020   pk_12_total 145 168 34     *     *   57                             413 145 168 34               57                       413
1240990 1240990 MD     school 2400390 12   Harford 240039000693 230 Halls Cross Roads Elementary   Regular School No Elementary PK 05 2020   pk_12_total 106 239 46   * *     *   56                             454 106 239 46               56                       454
1241005 1241005 MD     school 2400390 12   Harford 240039000480 292 Center for Educational Opportunity   Alternative School No High 08 12 2020   pk_12_total 26 37 *     *         *                             74 26 37                                         74
1241046 1241046 MD     school 2400390 12   Harford 240039000692 328 Forest Lakes Elementary   Regular School No Elementary KG 05 2020   pk_12_total 383 * 25     *         22                             445 383   25               22                       445
1241132 1241132 MD     school 2400390 12   Harford 240039000703 391 John Archer School   Special Education School No Other PK 12 2020   pk_12_total 64 36 11     *         *                             123 64 36 11                                       123
1241139 1241139 MD     school 2400390 12   Harford 240039000702 436 Jarrettsville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 408 * 14     *     *   18                             450 408   14               18                       450
1241146 1241146 MD     school 2400390 12   Harford 240039000708 441 Norrisville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 203   *     *     *   *                             218 203                                           218
1241154 1241154 MD     school 2400390 12   Harford 240039090476 447 North Bend Elementary   Regular School No Elementary PK 05 2020   pk_12_total 365 * 14     *         17                             402 365   14               17                       402
1241161 1241161 MD     school 2400390 12   Harford 240039000685 518 Darlington Elementary   Regular School No Elementary KG 05 2020   pk_12_total 91 * *     *         *                             104 91                                           104
1241176 1241176 MD     school 2400390 12   Harford 240039001443 544 North Harford Elementary   Regular School No Elementary KG 05 2020   pk_12_total 353 * *     *         12                             373 353                   12                       373
1241201 1241201 MD     school 2400390 12   Harford 240039000707 638 Meadowvale Elementary   Regular School No Elementary PK 05 2020   pk_12_total 341 71 47   * *         54                             518 341 71 47               54                       518
1241214 1241214 MD     school 2400390 12   Harford 240039000697 678 Havre de Grace High   Regular School No High 09 12 2020   pk_12_total 380 161 50   * *     *   62                             662 380 161 50               62                       662
1241218 1241218 MD     school 2400390 12   Harford 240039000696 679 Havre de Grace Middle   Regular School No Middle 06 08 2020   pk_12_total 359 115 49   * *     *   67                             601 359 115 49               67                       601
1241226 1241226 MD     school 2400420 13   Howard 240042001189 80 Homewood School   Alternative School No High 06 12 2020   pk_12_total 30 70 14   * *         *                             122 30 70 14                                       122
1241719 1241719 MD     school 2400450 14   Kent 240045000766 402 Kent County Middle School   Regular School No Middle 06 08 2020   pk_12_total 251 98 41   * *         27                             421 251 98 41               27                       421
1241727 1241727 MD     school 2400450 14   Kent 240045000765 403 H. H. Garnett Elementary   Regular School No Elementary PK 05 2020   pk_12_total 141 156 35     *         38                             372 141 156 35               38                       372
1242029 1242029 MD     school 2400480 15   Montgomery 240048001451 239 Alternative Programs   Alternative School No High 07 12 2020   pk_12_total 10 63 43     *         *                             126 10 63 43                                       126
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
1242666 1242666 MD     school 2400480 15   Montgomery 240048000876 652 Monocacy Elementary   Regular School No Elementary KG 05 2020   pk_12_total 106 * 21     *         14                             151 106   21               14                       151
1242884 1242884 MD     school 2400480 15   Montgomery 240048000851 784 Highland View Elementary   Regular School No Elementary PK 05 2020   pk_12_total 143 140 128   * *         13                             434 143 140 128               13                       434
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
1242988 1242988 MD     school 2400480 15   Montgomery 240048000858 805 Kemp Mill Elementary   Regular School No Elementary PK 05 2020   pk_12_total 21 58 396     *         *                             486 21 58 396                                       486
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
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
1243121 1243121 MD     school 2400510 16   Prince George's 240051001354 108 James E. Duckworth Regional Center   Special Education School No Other KG 12 2020   pk_12_total * 33 52     *         *                             93   33 52                                       93
1243162 1243162 MD     school 2400510 16   Prince George's 240051000985 205 Bladensburg Elementary   Regular School No Elementary PK 06 2020   pk_12_total 17 209 557   * *     *   *                             795 17 209 557                                       795
1243214 1243214 MD     school 2400510 16   Prince George's 240051001368 217 Port Towns Elementary   Regular School No Elementary PK 06 2020   pk_12_total 16 351 751   * *     *   *                             1132 16 351 751                                       1132
1243224 1243224 MD     school 2400510 16   Prince George's 240051000866 304 Perrywood Elementary   Regular School No Elementary KG 05 2020   pk_12_total * 540 31   * *         *                             593   540 31                                       593
1243232 1243232 MD     school 2400510 16   Prince George's 240051001129 305 Patuxent Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 264 20   * *         *                             293   264 20                                       293
1243248 1243248 MD     school 2400510 16   Prince George's 240051001148 507 Rose Valley Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 190 139   * *     *   *                             354   190 139                                       354
1243276 1243276 MD     school 2400510 16   Prince George's 240051001164 603 Suitland High   Regular School No High 09 12 2020   pk_12_total 16 1684 170   * *     *   19                             1903 16 1684 170               19                       1903

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