enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

  • pk_12_total · 2,591 ✖
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
1239265 1239265 MD     school 2400120 3   Baltimore County 240012001372 1518 Glenmar Elementary   Regular School No Elementary PK 05 2020   pk_12_total 36 193 38   * 36         13                             317 36 193 38     36         13                       317
1239273 1239273 MD     school 2400120 3   Baltimore County 240012000437 1519 Orems Elementary   Regular School No Elementary PK 05 2020   pk_12_total 208 75 61   * 22         32                             403 208 75 61     22         32                       403
1239281 1239281 MD     school 2400120 3   Baltimore County 240012000429 1520 Middleborough Elementary   Regular School No Elementary PK 05 2020   pk_12_total 226 84 11   * *         22                             349 226 84 11               22                       349
1239288 1239288 MD     school 2400120 3   Baltimore County 240012000369 1525 Deep Creek Elementary   Regular School No Elementary KG 05 2020   pk_12_total 54 328 33   * *     *   36                             458 54 328 33               36                       458
1239296 1239296 MD     school 2400120 3   Baltimore County 240012000469 1527 Sandalwood Elementary   Regular School No Elementary PK 05 2020   pk_12_total 43 359 87   * *         46                             537 43 359 87               46                       537
1239304 1239304 MD     school 2400120 3   Baltimore County 240012000472 1531 Seneca Elementary   Regular School No Elementary PK 05 2020   pk_12_total 178 171 27   * 12     *   33                             423 178 171 27     12         33                       423
1239312 1239312 MD     school 2400120 3   Baltimore County 240012001653 1533 Vincent Farm Elementary   Regular School No Elementary PK 05 2020   pk_12_total 287 314 50   * 69     *   39                             761 287 314 50     69         39                       761
1239320 1239320 MD     school 2400120 3   Baltimore County 240012001406 1534 Oliver Beach Elementary   Regular School No Elementary PK 05 2020   pk_12_total 161 * *     *         15                             185 161                   15                       185
1239364 1239364 MD     school 2400150 4   Calvert 240015000504 101 Patuxent Appeal Elementary Campus   Regular School No Elementary PK 05 2020   pk_12_total 482 111 55   * *         115                             768 482 111 55               115                       768
1239372 1239372 MD     school 2400150 4   Calvert 240015000514 110 Mutual Elementary   Regular School No Elementary PK 05 2020   pk_12_total 318 42 18               43                             421 318 42 18               43                       421
1239389 1239389 MD     school 2400150 4   Calvert 240015000778 114 St Leonard Elementary   Regular School No Elementary PK 05 2020   pk_12_total 315 81 64     *         52                             521 315 81 64               52                       521
1239397 1239397 MD     school 2400150 4   Calvert 240015001102 115 Dowell Elementary   Regular School No Elementary PK 05 2020   pk_12_total 414 55 44   * 14         74                             604 414 55 44     14         74                       604
1239425 1239425 MD     school 2400150 4   Calvert 240015000517 207 Calvert Elementary   Regular School No Elementary PK 05 2020   pk_12_total 326 95 27   * *         63                             516 326 95 27               63                       516
1239433 1239433 MD     school 2400150 4   Calvert 240015001655 208 Barstow Elementary   Regular School No Elementary PK 05 2020   pk_12_total 432 103 39   * *     *   73                             658 432 103 39               73                       658
1239441 1239441 MD     school 2400150 4   Calvert 240015000511 209 Huntingtown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 392 31 22               55                             500 392 31 22               55                       500
1239454 1239454 MD     school 2400150 4   Calvert 240015090465 215 Plum Point Elementary   Regular School No Elementary PK 05 2020   pk_12_total 452 50 37     15         55                             609 452 50 37     15         55                       609
1239471 1239471 MD     school 2400150 4   Calvert 240015000505 302 Beach Elementary   Regular School No Elementary PK 05 2020   pk_12_total 343 55 42     *         75                             518 343 55 42               75                       518
1239478 1239478 MD     school 2400150 4   Calvert 240015000513 312 Mount Harmony Elementary   Regular School No Elementary KG 05 2020   pk_12_total 448 58 41   * 20         47                             616 448 58 41     20         47                       616
1239495 1239495 MD     school 2400150 4   Calvert 240015001505 316 Sunderland Elementary   Regular School No Elementary PK 05 2020   pk_12_total 532 98 24     *         60                             723 532 98 24               60                       723
1239503 1239503 MD     school 2400150 4   Calvert 240015000790 317 Windy Hill Elementary   Regular School No Elementary PK 05 2020   pk_12_total 488 50 52   * *         69                             668 488 50 52               69                       668
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
1239528 1239528 MD     school 2400180 5   Caroline 240018000520 301 Denton Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 440 120 39     13         68                             680 440 120 39     13         68                       680
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
1239548 1239548 MD     school 2400180 5   Caroline 240018000521 501 Federalsburg Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 188 187 18   * 10         61                             465 188 187 18     10         61                       465
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
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
1239595 1239595 MD     school 2400210 6   Carroll 240021000368 204 Runnymede Elementary   Regular School No Elementary PK 05 2020   pk_12_total 540 19 19   * *     *   27                             612 540 19 19               27                       612
1239603 1239603 MD     school 2400210 6   Carroll 240021000545 404 Sandymount Elementary   Regular School No Elementary PK 05 2020   pk_12_total 409 28 38     13     *   *                             497 409 28 38     13                                 497
1239611 1239611 MD     school 2400210 6   Carroll 240021000537 406 Mechanicsville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 412 17 14     10     *   27                             483 412 17 14     10         27                       483
1239619 1239619 MD     school 2400210 6   Carroll 240021000531 501 Eldersburg Elementary   Regular School No Elementary PK 05 2020   pk_12_total 335 28 28     35         23                             449 335 28 28     35         23                       449
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
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
1239663 1239663 MD     school 2400210 6   Carroll 240021090466 509 Piney Ridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 389 31 24   * 38     *   51                             535 389 31 24     38         51                       535
1239676 1239676 MD     school 2400210 6   Carroll 240021000536 601 Manchester Elementary   Regular School No Elementary PK 05 2020   pk_12_total 595 * 39     10     *   10                             663 595   39     10         10                       663
1239689 1239689 MD     school 2400210 6   Carroll 240021001652 603 Ebb Valley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 489 13 17   * 10     *   13                             548 489 13 17     10         13                       548
1239710 1239710 MD     school 2400210 6   Carroll 240021000554 705 William Winchester Elementary   Regular School No Elementary PK 05 2020   pk_12_total 347 34 102     10         30                             523 347 34 102     10         30                       523
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
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
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
1239771 1239771 MD     school 2400210 6   Carroll 240021001349 718 PRIDE School   Alternative School No Elementary 01 05 2020   pk_12_total * *                                               *                                              
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
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
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
1239857 1239857 MD     school 2400240 7   Cecil 240024000565 205 Chesapeake City Elementary   Regular School No Elementary PK 05 2020   pk_12_total 306 * 20               18                             349 306   20               18                       349
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
1239898 1239898 MD     school 2400240 7   Cecil 240024000572 315 Leeds Elementary   Regular School No Elementary PK 05 2020   pk_12_total 351 * 26               39                             423 351   26               39                       423
1239906 1239906 MD     school 2400240 7   Cecil 240024000581 316 Thomson Estates Elementary   Regular School No Elementary PK 05 2020   pk_12_total 214 116 88   * 13     *   59                             493 214 116 88     13         59                       493
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
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
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
1239942 1239942 MD     school 2400240 7   Cecil 240024000557 510 Bay View Elementary   Regular School No Elementary PK 05 2020   pk_12_total 346 33 33     10     *   41                             464 346 33 33     10         41                       464
1239950 1239950 MD     school 2400240 7   Cecil 240024000563 513 Charlestown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 196 35 *           *   15                             257 196 35                 15                       257
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
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
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
1239995 1239995 MD     school 2400240 7   Cecil 240024000556 704 Bainbridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 240 11 *   *       *   23                             284 240 11                 23                       284
1240008 1240008 MD     school 2400240 7   Cecil 240024000566 801 Conowingo Elementary   Regular School No Elementary PK 05 2020   pk_12_total 427 10 14   *           11                             464 427 10 14               11                       464
1240016 1240016 MD     school 2400240 7   Cecil 240024000559 904 Calvert Elementary   Regular School No Elementary PK 05 2020   pk_12_total 406   17   *           *                             432 406   17                                       432
1240033 1240033 MD     school 2400270 8   Charles 240027000609 105 Walter J. Mitchell Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 387 103 63   * 14     *   55                             626 387 103 63     14         55                       626
1240051 1240051 MD     school 2400270 8   Charles 240027000141 109 Mary H. Matula Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 254 198 49   * 30         39                             571 254 198 49     30         39                       571
1240059 1240059 MD     school 2400270 8   Charles 240027001492 302 Mt Hope/Nanjemoy Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 167 74 *   *           17                             264 167 74                 17                       264
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
1240079 1240079 MD     school 2400270 8   Charles 240027000585 604 Dr. Samuel A. Mudd Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 42 407 98   * 10         28                             586 42 407 98     10         28                       586
1240092 1240092 MD     school 2400270 8   Charles 240027000593 606 J. P. Ryon Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 66 411 112   * 11     *   56                             659 66 411 112     11         56                       659
1240104 1240104 MD     school 2400270 8   Charles 240027000594 609 Dr. James Craik Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 230 179 37   * 12         58                             518 230 179 37     12         58                       518
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
1240120 1240120 MD     school 2400270 8   Charles 240027000582 612 Arthur Middleton Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 57 313 107     19         55                             551 57 313 107     19         55                       551
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
1240140 1240140 MD     school 2400270 8   Charles 240027010501 617 Daniel of St. Thomas Jenifer Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 33 444 99   * 14         50                             643 33 444 99     14         50                       643
1240148 1240148 MD     school 2400270 8   Charles 240027001519 618 William B. Wade Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 89 407 71   * 42         74                             686 89 407 71     42         74                       686
1240161 1240161 MD     school 2400270 8   Charles 240027000380 620 C. Paul Barnhart Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 21 447 98   * 31         50                             648 21 447 98     31         50                       648
1240173 1240173 MD     school 2400270 8   Charles 240027000805 622 Berry Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 58 443 83   * 63     *   60                             717 58 443 83     63         60                       717
1240186 1240186 MD     school 2400270 8   Charles 240027001565 624 William A. Diggs Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 94 523 58     30     *   66                             775 94 523 58     30         66                       775
1240198 1240198 MD     school 2400270 8   Charles 240027001656 626 Mary B. Neal Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 41 518 58   * 36         45                             699 41 518 58     36         45                       699
1240206 1240206 MD     school 2400270 8   Charles 240027001757 627 Billingsley Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 95 480 61   * 26     *   61                             725 95 480 61     26         61                       725
1240218 1240218 MD     school 2400270 8   Charles 240027000592 703 J. C. Parks Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 70 368 84   * 20     *   61                             609 70 368 84     20         61                       609
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
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
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
1240328 1240328 MD     school 2400300 9   Dorchester 240030000617 711 Maple Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 86 265 68     13         46                             478 86 265 68     13         46                       478
1240341 1240341 MD     school 2400300 9   Dorchester 240030000841 716 Choptank Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 35 238 62               22                             357 35 238 62               22                       357
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
1240357 1240357 MD     school 2400330 10   Frederick 240033000628 108 Carroll Manor Elementary   Regular School No Elementary PK 05 2020   pk_12_total 411 55 70   * 16     *   21                             577 411 55 70     16         21                       577
1240365 1240365 MD     school 2400330 10   Frederick 240033001355 109 Tuscarora Elementary   Regular School No Elementary PK 05 2020   pk_12_total 211 177 206   * 54     *   60                             713 211 177 206     54         60                       713
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
1240380 1240380 MD     school 2400330 10   Frederick 240033000649 204 Lincoln Elementary   Regular School No Elementary PK 05 2020   pk_12_total 86 216 218   * 20         55                             598 86 216 218     20         55                       598
1240401 1240401 MD     school 2400330 10   Frederick 240033000645 210 North Frederick Elementary   Regular School No Elementary PK 05 2020   pk_12_total 250 122 182     31     *   83                             669 250 122 182     31         83                       669
1240422 1240422 MD     school 2400330 10   Frederick 240033001521 222 Monocacy Elementary   Regular School No Elementary PK 05 2020   pk_12_total 167 177 190   * 17     *   53                             611 167 177 190     17         53                       611

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