enrollments

Data source: Big Local News · About: Big Local

9,615 rows where state = "MD" and year = 2020 sorted by multiracial descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 9,515 ✖
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
1239104 1239104 MD     school 2400120 3   Baltimore County 240012000342 1356 Arbutus Middle   Regular School No Middle 06 08 2020   pk_12_total 489 214 40   * 136     *   67                             951 489 214 40     136         67                       951
1240521 1240521 MD     school 2400330 10   Frederick 240033001536 716 Urbana Middle   Regular School No Middle 06 08 2020   pk_12_total 548 73 123   * 203     *   67                             1021 548 73 123     203         67                       1021
1240957 1240957 MD     school 2400390 12   Harford 240039001352 184 Magnolia Middle   Regular School No Middle 06 08 2020   pk_12_total 224 419 102   * 16         67                             831 224 419 102     16         67                       831
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
1241311 1241311 MD     school 2400420 13   Howard 240042000743 207 Mount Hebron High   Regular School No High 09 12 2020   pk_12_total 717 217 163   * 525     *   67                             1695 717 217 163     525         67                       1695
1241530 1241530 MD     school 2400420 13   Howard 240042090478 523 Pointers Run Elementary   Regular School No Elementary PK 05 2020   pk_12_total 414 105 33   * 291     *   67                             912 414 105 33     291         67                       912
1242167 1242167 MD     school 2400480 15   Montgomery 240048001044 321 James Hubert Blake High   Regular School No High 09 12 2020   pk_12_total 285 737 518   * 184         67                             1795 285 737 518     184         67                       1795
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
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
1240899 1240899 MD     school 2400390 12   Harford 240039000162 123 Abingdon Elementary   Regular School No Elementary PK 05 2020   pk_12_total 416 161 55   * 24     *   66                             724 416 161 55     24         66                       724
1245207 1245207 MD     school 2400660 21   Washington 240066001273 2601 Lincolnshire Elementary   Regular School No Elementary PK 05 2020   pk_12_total 325 82 50     *         66                             529 325 82 50               66                       529
1238972 1238972 MD     school 2400120 3   Baltimore County 240012000347 1206 Bear Creek Elementary   Regular School No Elementary PK 05 2020   pk_12_total 296 62 56   * 10         65                             495 296 62 56     10         65                       495
1240393 1240393 MD     school 2400330 10   Frederick 240033000632 209 Frederick High   Regular School No High 09 12 2020   pk_12_total 384 375 561   * 116     *   65                             1508 384 375 561     116         65                       1508
1241872 1241872 MD     school 2400480 15   Montgomery 240048090454 159 Rachel Carson Elementary   Regular School No Elementary PK 05 2020   pk_12_total 414 60 196     158         65                             893 414 60 196     158         65                       893
1241885 1241885 MD     school 2400480 15   Montgomery 240048000840 204 Garrett Park Elementary   Regular School No Elementary PK 05 2020   pk_12_total 310 98 193   * 132     *   65                             802 310 98 193     132         65                       802
1242909 1242909 MD     school 2400480 15   Montgomery 240048000773 789 Albert Einstein High   Regular School No High 09 12 2020   pk_12_total 407 321 882   * 139         65                             1818 407 321 882     139         65                       1818
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
1239157 1239157 MD     school 2400120 3   Baltimore County 240012000442 1452 Parkville Middle & Center of Technology   Regular School No Middle 06 08 2020   pk_12_total 478 431 82   * 68     *   64                             1126 478 431 82     68         64                       1126
1240124 1240124 MD     school 2400270 8   Charles 240027000583 613 Benjamin Stoddert Middle School   Regular School No Middle 06 08 2020   pk_12_total 52 574 93   * 25     *   64                             814 52 574 93     25         64                       814
1240210 1240210 MD     school 2400270 8   Charles 240027000599 701 Matthew Henson Middle School   Regular School No Middle 06 08 2020   pk_12_total 92 552 80   * 19     *   64                             811 92 552 80     19         64                       811
1240272 1240272 MD     school 2400270 8   Charles 240027000597 1002 Henry E. Lackey High School   Regular School No High 09 12 2020   pk_12_total 283 563 47   12 20     *   64                             990 283 563 47   12 20         64                       990
1240430 1240430 MD     school 2400330 10   Frederick 240033090471 223 Ballenger Creek Elementary   Regular School No Elementary PK 05 2020   pk_12_total 218 113 124   * 61     *   64                             586 218 113 124     61         64                       586
1242225 1242225 MD     school 2400480 15   Montgomery 240048001747 346 Bayard Rustin Elementary   Regular School No Elementary PK 05 2020   pk_12_total 183 70 209   * 190         64                             719 183 70 209     190         64                       719
1242876 1242876 MD     school 2400480 15   Montgomery 240048000892 783 Kensington Parkwood Elementary   Regular School No Elementary PK 05 2020   pk_12_total 396 40 81     61         64                             642 396 40 81     61         64                       642
1245006 1245006 MD     school 2400660 21   Washington 240066001667 325 Rockland Woods Elementary   Regular School No Elementary PK 05 2020   pk_12_total 357 104 97   * 26     *   64                             652 357 104 97     26         64                       652
1237749 1237749 MD     school 2400060 2   Anne Arundel 240006000061 3082 Crofton Woods Elementary   Regular School No Elementary KG 05 2020   pk_12_total 525 48 69   * 54     *   63                             763 525 48 69     54         63                       763
1237773 1237773 MD     school 2400060 2   Anne Arundel 240006000083 3112 Jessup Elementary   Regular School No Elementary PK 05 2020   pk_12_total 186 169 142   * 35         63                             596 186 169 142     35         63                       596
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
1241415 1241415 MD     school 2400420 13   Howard 240042001437 308 Marriotts Ridge High   Regular School No High 09 12 2020   pk_12_total 676 136 46   * 548         63                             1472 676 136 46     548         63                       1472
1237957 1237957 MD     school 2400060 2   Anne Arundel 240006000037 4013 Annapolis High   Regular School No High 09 12 2020   pk_12_total 635 560 790   * 50     *   62                             2103 635 560 790     50         62                       2103
1240165 1240165 MD     school 2400270 8   Charles 240027000615 621 Mattawoman Middle School   Regular School No Middle 06 08 2020   pk_12_total 52 748 107   * 52     *   62                             1026 52 748 107     52         62                       1026
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
1241463 1241463 MD     school 2400420 13   Howard 240042000763 512 Wilde Lake Middle   Regular School No Middle 06 08 2020   pk_12_total 164 317 91   * 51         62                             687 164 317 91     51         62                       687
1242647 1242647 MD     school 2400480 15   Montgomery 240048001526 606 Cabin John Middle School   Regular School No Middle 06 08 2020   pk_12_total 408 120 84   * 365         62                             1040 408 120 84     365         62                       1040
1244896 1244896 MD     school 2400630 20   Talbot 240063001244 104 Easton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 309 219 423     26         62                             1039 309 219 423     26         62                       1039
1245285 1245285 MD     school 2400690 22   Wicomico 240069001310 906 Pemberton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 127 313 30   * 27     *   62                             562 127 313 30     27         62                       562
1246228 1246228 MD     school 2400090 30   Baltimore City 240009000306 233 Roland Park Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 576 599 69   * 136     *   62                             1453 576 599 69     136         62                       1453
1237437 1237437 MD     school 2400060 2   Anne Arundel 240006000093 1162 Marley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 228 257 213   * 63     *   61                             831 228 257 213     63         61                       831
1237974 1237974 MD     school 2400060 2   Anne Arundel 240006000131 4053 Southern Middle   Regular School No Middle 06 08 2020   pk_12_total 536 60 140   * *         61                             801 536 60 140               61                       801
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
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
1241702 1241702 MD     school 2400420 13   Howard 240042001032 625 Gorman Crossing Elementary   Regular School No Elementary PK 05 2020   pk_12_total 171 288 91   * 235     *   61                             849 171 288 91     235         61                       849
1241832 1241832 MD     school 2400480 15   Montgomery 240048000897 152 Poolesville High   Regular School No High 09 12 2020   pk_12_total 581 68 94   * 397     *   61                             1205 581 68 94     397         61                       1205
1242980 1242980 MD     school 2400480 15   Montgomery 240048000832 803 Forest Knolls Elementary   Regular School No Elementary PK 05 2020   pk_12_total 247 112 292   * 39     *   61                             755 247 112 292     39         61                       755
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
1240043 1240043 MD     school 2400270 8   Charles 240027000600 108 Maurice J. McDonough High School   Regular School No High 09 12 2020   pk_12_total 287 438 95   * 20     *   60                             902 287 438 95     20         60                       902
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
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
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
1244633 1244633 MD     school 2400540 17   Queen Anne's 240054001076 405 Kent Island High School   Regular School No High 09 12 2020   pk_12_total 985 66 76   * 27     *   60                             1221 985 66 76     27         60                       1221
1244715 1244715 MD     school 2400600 18   Saint Mary's 240060001231 404 Margaret Brent Middle   Regular School No Middle 06 08 2020   pk_12_total 848 81 42   * *     *   60                             1043 848 81 42               60                       1043
1244817 1244817 MD     school 2400600 18   Saint Mary's 240060001234 808 Park Hall Elementary   Regular School No Elementary PK 05 2020   pk_12_total 189 258 50   * 14     *   60                             576 189 258 50     14         60                       576
1244888 1244888 MD     school 2400630 20   Talbot 240063001242 101 Easton High   Regular School No High 09 12 2020   pk_12_total 682 189 267   * 24     *   60                             1224 682 189 267     24         60                       1224
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
1240153 1240153 MD     school 2400270 8   Charles 240027000144 619 Westlake High School   Regular School No High 09 12 2020   pk_12_total 74 866 91   * 45     *   59                             1140 74 866 91     45         59                       1140
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
1241209 1241209 MD     school 2400390 12   Harford 240039000711 639 Roye-Williams Elementary   Regular School No Elementary PK 05 2020   pk_12_total 202 126 90   * 10     *   59                             490 202 126 90     10         59                       490
1241974 1241974 MD     school 2400480 15   Montgomery 240048000849 228 Herbert Hoover Middle   Regular School No Middle 06 08 2020   pk_12_total 430 74 89     392     *   59                             1045 430 74 89     392         59                       1045
1242217 1242217 MD     school 2400480 15   Montgomery 240048001739 345 Hallie Wells Middle School   Regular School No Middle 06 08 2020   pk_12_total 212 178 116   * 307         59                             873 212 178 116     307         59                       873
1244798 1244798 MD     school 2400600 18   Saint Mary's 240060001483 805 George Washington Carver Elementary   Regular School No Elementary PK 05 2020   pk_12_total 87 317 125   * *     *   59                             598 87 317 125               59                       598
1244825 1244825 MD     school 2400600 18   Saint Mary's 240060001226 810 Greenview Knolls Elementary   Regular School No Elementary PK 05 2020   pk_12_total 137 165 42     15         59                             418 137 165 42     15         59                       418
1245116 1245116 MD     school 2400660 21   Washington 240066001274 1301 Maugansville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 462 99 107     22         59                             749 462 99 107     22         59                       749
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
1239080 1239080 MD     school 2400120 3   Baltimore County 240012000461 1310 Relay Elementary   Regular School No Elementary PK 05 2020   pk_12_total 338 112 45   * 103         58                             659 338 112 45     103         58                       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
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
1242744 1242744 MD     school 2400480 15   Montgomery 240048000933 755 Takoma Park Middle School   Regular School No Middle 06 08 2020   pk_12_total 341 395 197   * 169         58                             1162 341 395 197     169         58                       1162
1244782 1244782 MD     school 2400600 18   Saint Mary's 240060001221 803 Green Holly Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 247 176 60   * 17     *   58                             560 247 176 60     17         58                       560
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
1238182 1238182 MD     school 2400060 2   Anne Arundel 240006001687 6233 Monarch Academy   Regular School Yes Elementary KG 08 2020   pk_12_total 291 244 62   * 24         57                             679 291 244 62     24         57                       679
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
1241318 1241318 MD     school 2400420 13   Howard 240042000744 208 Northfield Elementary   Regular School No Elementary KG 05 2020   pk_12_total 338 70 57   * 177         57                             702 338 70 57     177         57                       702
1242381 1242381 MD     school 2400480 15   Montgomery 240048000868 505 Lucy V. Barnsley Elementary   Regular School No Elementary KG 05 2020   pk_12_total 243 93 254   * 88         57                             737 243 93 254     88         57                       737
1242719 1242719 MD     school 2400480 15   Montgomery 240048000660 707 Rocky Hill Middle   Regular School No Middle 06 08 2020   pk_12_total 186 220 154   * 261     *   57                             883 186 220 154     261         57                       883
1242723 1242723 MD     school 2400480 15   Montgomery 240048000863 708 Kingsview Middle   Regular School No Middle 06 08 2020   pk_12_total 232 265 149     277     *   57                             983 232 265 149     277         57                       983
1237422 1237422 MD     school 2400060 2   Anne Arundel 240006000081 1142 Hilltop Elementary   Regular School No Elementary PK 05 2020   pk_12_total 176 235 186   * 23     *   56                             679 176 235 186     23         56                       679
1239024 1239024 MD     school 2400120 3   Baltimore County 240012000421 1217 Logan Elementary   Regular School No Elementary PK 05 2020   pk_12_total 230 165 83   * 15         56                             550 230 165 83     15         56                       550
1239487 1239487 MD     school 2400150 4   Calvert 240015000515 315 Northern Middle   Regular School No Middle 06 08 2020   pk_12_total 518 53 26     19     *   56                             674 518 53 26     19         56                       674
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
1240757 1240757 MD     school 2400330 10   Frederick 240033000656 2606 Walkersville Middle   Regular School No Middle 06 08 2020   pk_12_total 570 108 117     24     *   56                             876 570 108 117     24         56                       876
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
1241099 1241099 MD     school 2400390 12   Harford 240039000683 373 Bel Air High   Regular School No High 09 12 2020   pk_12_total 1163 123 102   * 113     *   56                             1560 1163 123 102     113         56                       1560
1241329 1241329 MD     school 2400420 13   Howard 240042000723 210 Centennial Lane Elementary   Regular School No Elementary KG 05 2020   pk_12_total 223 39 29   12 360         56                             719 223 39 29   12 360         56                       719
1241844 1241844 MD     school 2400480 15   Montgomery 240048000181 155 Rosa M. Parks Middle   Regular School No Middle 06 08 2020   pk_12_total 484 121 116     91         56                             868 484 121 116     91         56                       868
1242287 1242287 MD     school 2400480 15   Montgomery 240048000949 412 Westland Middle   Regular School No Middle 06 08 2020   pk_12_total 477 66 147   * 60     *   56                             808 477 66 147     60         56                       808
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
1237909 1237909 MD     school 2400060 2   Anne Arundel 240006001517 3362 Crofton Meadows Elementary   Regular School No Elementary KG 05 2020   pk_12_total 321 93 56     29         55                             554 321 93 56     29         55                       554
1238127 1238127 MD     school 2400060 2   Anne Arundel 240006000054 4283 Central Middle   Regular School No Middle 06 08 2020   pk_12_total 962 57 162   * 43     *   55                             1284 962 57 162     43         55                       1284
1239185 1239185 MD     school 2400120 3   Baltimore County 240012000489 1505 Victory Villa Elementary   Regular School No Elementary PK 05 2020   pk_12_total 147 343 131   * 11     *   55                             691 147 343 131     11         55                       691
1239332 1239332 MD     school 2400120 3   Baltimore County 240012000370 1557 Deep Creek Middle   Regular School No Middle 06 08 2020   pk_12_total 202 539 97   * *         55                             901 202 539 97               55                       901
1239356 1239356 MD     school 2400120 3   Baltimore County 240012000379 1575 Eastern Technical High School   Career and Technical School No High 09 12 2020   pk_12_total 562 235 57   * 257     *   55                             1172 562 235 57     257         55                       1172
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
1239715 1239715 MD     school 2400210 6   Carroll 240021000552 707 Westminster High   Regular School No High 09 12 2020   pk_12_total 1289 60 69     48     *   55                             1522 1289 60 69     48         55                       1522
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
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
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
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

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