enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1245528 1245528 MD     school 2400090 30   Baltimore City 240009000246 21 Hilton Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 349 *                                             365   349                                         365
1245566 1245566 MD     school 2400090 30   Baltimore City 240009000335 28 Sandtown-Winchester Achievement Academy   Regular School No Elementary PK 08 2020   pk_12_total * 390 *               *                             400   390                                         400
1245574 1245574 MD     school 2400090 30   Baltimore City 240009000278 29 Matthew A. Henson Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 299 *   * *         *                             312   299                                         312
1245593 1245593 MD     school 2400090 30   Baltimore City 240009000239 35 Harlem Park Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total   286 *   *           *                             293   286                                         293
1245620 1245620 MD     school 2400090 30   Baltimore City 240009000281 44 Montebello Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 534 *   * *         *                             553   534                                         553
1245726 1245726 MD     school 2400090 30   Baltimore City 240009000192 62 Edgecombe Circle Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 204 *               *                             215   204                                         215
1245737 1245737 MD     school 2400090 30   Baltimore City 240009000307 63 Rosemont Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total   350 *     *         *                             359   350                                         359
1245764 1245764 MD     school 2400090 30   Baltimore City 240009000193 67 Edgewood Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 179 *           *                                 188   179                                         188
1245772 1245772 MD     school 2400090 30   Baltimore City 240009000312 73 Sarah M. Roach Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 174 *                                             185   174                                         185
1245836 1245836 MD     school 2400090 30   Baltimore City 240009000265 86 Lakewood Elementary   Regular School No Elementary PK KG 2020   pk_12_total   73 *               *                             83   73                                         83
1245847 1245847 MD     school 2400090 30   Baltimore City 240009000337 87 Windsor Hills Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 241 *     *     *                                 259   241                                         259
1245869 1245869 MD     school 2400090 30   Baltimore City 240009000208 95 Franklin Square Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 347 *   *           *                             367   347                                         367
1245880 1245880 MD     school 2400090 30   Baltimore City 240009000179 97 Collington Square Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 336 *               *                             347   336                                         347
1245896 1245896 MD     school 2400090 30   Baltimore City 240009000309 122 The Historic Samuel Coleridge-Taylor Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 244 *                                             247   244                                         247
1245915 1245915 MD     school 2400090 30   Baltimore City 240009000211 125 Furman Templeton Preparatory Academy   Regular School Yes Elementary PK 05 2020   pk_12_total * 454 *   *       *                                 461   454                                         461
1245919 1245919 MD     school 2400090 30   Baltimore City 240009000160 130 Booker T. Washington Middle   Regular School No Middle 06 08 2020   pk_12_total * 234 *                                             242   234                                         242
1245938 1245938 MD     school 2400090 30   Baltimore City 240009000303 142 Robert W. Coleman Elementary   Regular School No Elementary PK 05 2020   pk_12_total   297 *               *                             304   297                                         304
1245946 1245946 MD     school 2400090 30   Baltimore City 240009000255 144 James Mosher Elementary   Regular School No Elementary PK 05 2020   pk_12_total   201 *           *   *                             211   201                                         211
1245954 1245954 MD     school 2400090 30   Baltimore City 240009000145 145 Alexander Hamilton Elementary   Regular School No Elementary PK 05 2020   pk_12_total   157 *               *                             160   157                                         160
1245962 1245962 MD     school 2400090 30   Baltimore City 240009000158 150 Mary Ann Winterling Elementary at Bentalou   Regular School No Elementary PK 05 2020   pk_12_total * 221 *               *                             226   221                                         226
1245979 1245979 MD     school 2400090 30   Baltimore City 240009000219 177 George W. F. McMechen High   Special Education School No High 09 12 2020   pk_12_total * 44 *               *                             50   44                                         50
1245996 1245996 MD     school 2400090 30   Baltimore City 240009000186 201 Dickey Hill Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total   353 *     *         *                             363   353                                         363
1246015 1246015 MD     school 2400090 30   Baltimore City 240009000277 204 Mary E. Rodman Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 276 *     *         *                             285   276                                         285
1246064 1246064 MD     school 2400090 30   Baltimore City 240009000212 211 Gardenville Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 274 *   * *         *                             295   274                                         295
1246075 1246075 MD     school 2400090 30   Baltimore City 240009000213 212 Garrett Heights Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 31 243 *           *   *                             289 31 243                                         289
1246083 1246083 MD     school 2400090 30   Baltimore City 240009000223 213 Govans Elementary   Regular School Yes Elementary PK 05 2020   pk_12_total * 368 *                                             381   368                                         381
1246094 1246094 MD     school 2400090 30   Baltimore City 240009001428 214 Guilford Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 293 *     *         *                             305   293                                         305
1246113 1246113 MD     school 2400090 30   Baltimore City 240009000156 217 Belmont Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 254 *   *           *                             262   254                                         262
1246304 1246304 MD     school 2400090 30   Baltimore City 240009000293 242 Northwood Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 573 *           *   *                             590   573                                         590
1246356 1246356 MD     school 2400090 30   Baltimore City 240009000313 248 Sinclair Lane Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 331 *     *                                       339   331                                         339
1246372 1246372 MD     school 2400090 30   Baltimore City 240009000187 250 Dr. Bernard Harris, Sr., Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 301 *   *           *                             310   301                                         310
1246391 1246391 MD     school 2400090 30   Baltimore City 240009000188 254 Dr. Martin Luther King, Jr., Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 233 *           *   *                             244   233                                         244
1246418 1246418 MD     school 2400090 30   Baltimore City 240009000260 261 Lockerman Bundy Elementary   Regular School No Elementary PK 05 2020   pk_12_total   217 *     *         *                             221   217                                         221
1246429 1246429 MD     school 2400090 30   Baltimore City 240009001558 262 Empowerment Academy   Regular School Yes Elementary PK 08 2020   pk_12_total   260 *                                             263   260                                         263
1246450 1246450 MD     school 2400090 30   Baltimore City 240009000176 307 Claremont School   Special Education School No High 08 12 2020   pk_12_total * 44 *                                             48   44                                         48
1246461 1246461 MD     school 2400090 30   Baltimore City 240009001364 313 Lois T. Murray Elementary/Middle   Special Education School No Elementary PK 08 2020   pk_12_total * 33 *                                             44   33                                         44
1246476 1246476 MD     school 2400090 30   Baltimore City 240009000883 321 Midtown Academy   Regular School Yes Elementary KG 08 2020   pk_12_total 16 166 *   * *         *                             198 16 166                                         198
1246487 1246487 MD     school 2400090 30   Baltimore City 240009000884 322 New Song Academy   Regular School No Elementary PK 08 2020   pk_12_total   183 *                                             185   183                                         185
1246499 1246499 MD     school 2400090 30   Baltimore City 240009001302 325 ConneXions: A Community Based Arts School   Regular School Yes High 06 12 2020   pk_12_total * 490 *     *                                       505   490                                         505
1246509 1246509 MD     school 2400090 30   Baltimore City 240009001478 326 City Neighbors Charter School   Regular School Yes Elementary KG 08 2020   pk_12_total 78 144 *               *                             231 78 144                                         231
1246543 1246543 MD     school 2400090 30   Baltimore City 240009001632 333 Independence School Local I   Regular School Yes High 09 12 2020   pk_12_total * 127 *     *         *                             140   127                                         140
1246572 1246572 MD     school 2400090 30   Baltimore City 240009001663 341 The Reach! Partnership School   Regular School No High 09 12 2020   pk_12_total * 576 *   *           *                             587   576                                         587
1246608 1246608 MD     school 2400090 30   Baltimore City 240009001682 348 Baltimore Leadership School for Young Women   Regular School Yes High 06 12 2020   pk_12_total * 523 *   *           *                             539   523                                         539
1246616 1246616 MD     school 2400090 30   Baltimore City 240009001678 349 N.A.C.A. Freedom and Democracy Academy II   Regular School No High 06 12 2020   pk_12_total * 283 *     *     *                                 297   283                                         297
1246629 1246629 MD     school 2400090 30   Baltimore City 240009001675 364 Bluford Drew Jemison STEM Academy West   Regular School No High 06 12 2020   pk_12_total * 219 *   *                                         227   219                                         227
1246639 1246639 MD     school 2400090 30   Baltimore City 240009001670 368 Elmer A. Henderson: A Johns Hopkins Partnership   Regular School No Elementary KG 08 2020   pk_12_total * 545 *   * *         *                             561   545                                         561
1246644 1246644 MD     school 2400090 30   Baltimore City 240009001734 371 Lillie May Carroll Jackson School   Regular School Yes Middle 05 08 2020   pk_12_total * 300 *                                             308   300                                         308
1246665 1246665 MD     school 2400090 30   Baltimore City 240009001736 375 Baltimore Collegiate School for Boys   Regular School Yes Middle 04 08 2020   pk_12_total * 421 *   *           *                             432   421                                         432
1246693 1246693 MD     school 2400090 30   Baltimore City 240009001716 384 Creative City Public Charter School   Regular School Yes Elementary KG 05 2020   pk_12_total 28 298 *     *         14                             346 28 298                 14                       346
1246696 1246696 MD     school 2400090 30   Baltimore City 240009001752 385 Baltimore International Academy West   Regular School Yes Elementary 06 06 2020   pk_12_total   67 *               *                             69   67                                         69
1246782 1246782 MD     school 2400090 30   Baltimore City 240009001387 430 Augusta Fells Savage Institute of Visual Arts   Regular School No High 09 12 2020   pk_12_total * 421 *     *         *                             434   421                                         434
1246787 1246787 MD     school 2400090 30   Baltimore City 240009001530 432 Coppin Academy   Regular School Yes High 09 12 2020   pk_12_total * 348 *           *   *                             355   348                                         355
1246792 1246792 MD     school 2400090 30   Baltimore City 240009001531 433 Renaissance Academy   Regular School No High 09 12 2020   pk_12_total   236 *                                             239   236                                         239
1246813 1246813 MD     school 2400090 30   Baltimore City 240009000885 884 Eager Street Academy   Alternative School No High 08 12 2020   pk_12_total   43 *     *                                       46   43                                         46
1237235 1237235 MD     school 2400030 1   Allegany 240003000015 405 Fort Hill High   Regular School No High 09 12 2020   pk_12_total 578 38 10     *         44                             672 578 38 10               44                       672
1241025 1241025 MD     school 2400390 12   Harford 240039000684 316 Churchville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 326 11 10   *           22                             370 326 11 10               22                       370
1244122 1244122 MD     school 2400510 16   Prince George's 240051001706 1522 Imagine Foundations at Morningside PCS   Regular School Yes Elementary KG 08 2020   pk_12_total * 407 10   * *         *                             427   407 10                                       427
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
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
1245273 1245273 MD     school 2400690 22   Wicomico 240069001088 520 Wicomico County Evening High   Alternative School No High 09 12 2020   pk_12_total 38 55 10     *         *                             107 38 55 10                                       107
1245536 1245536 MD     school 2400090 30   Baltimore City 240009000220 22 George Washington Elementary   Regular School No Elementary PK 05 2020   pk_12_total 12 160 10   *       *   *                             192 12 160 10                                       192
1245601 1245601 MD     school 2400090 30   Baltimore City 240009001153 37 Harford Heights Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 417 10               *                             431   417 10                                       431
1245718 1245718 MD     school 2400090 30   Baltimore City 240009000256 61 Dorothy I. Height Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 352 10   * *                                       375   352 10                                       375
1245985 1245985 MD     school 2400090 30   Baltimore City 240009001343 178 Excel Academy at Francis M. Wood High   Alternative School No High 08 12 2020   pk_12_total * 620 10   *           *                             642   620 10                                       642
1246564 1246564 MD     school 2400090 30   Baltimore City 240009001657 336 Baltimore Montessori Public Charter School   Regular School Yes Elementary PK 08 2020   pk_12_total 123 306 10   * *         13                             456 123 306 10               13                       456
1246655 1246655 MD     school 2400090 30   Baltimore City 240009001689 373 Tunbridge Public Charter School   Regular School Yes Elementary PK 08 2020   pk_12_total 65 378 10   * *     *   11                             471 65 378 10               11                       471
1237597 1237597 MD     school 2400060 2   Anne Arundel 240006000079 2132 High Point Elementary   Regular School No Elementary PK 05 2020   pk_12_total 463 46 100   * 14         53                             680 463 46 100     14         53                       680
1243639 1243639 MD     school 2400510 16   Prince George's 240051000988 1011 Bond Mill Elementary   Regular School No Elementary KG 05 2020   pk_12_total 92 238 100   * 39     *   32                             507 92 238 100     39         32                       507
1244761 1244761 MD     school 2400600 18   Saint Mary's 240060001685 606 Evergreen Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 515 86 100   * 35     *   75                             813 515 86 100     35         75                       813
1244244 1244244 MD     school 2400510 16   Prince George's 240051001257 1730 Mary Harris   Regular School No Elementary PK 05 2020   pk_12_total 32 43 1000   * *         *                             1091 32 43 1000                                       1091
1239351 1239351 MD     school 2400120 3   Baltimore County 240012000362 1574 Chesapeake High   Regular School No High 09 12 2020   pk_12_total 267 525 102   * *     *   50                             961 267 525 102               50                       961
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
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
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
1241471 1241471 MD     school 2400420 13   Howard 240042000742 514 Longfellow Elementary   Regular School No Elementary PK 05 2020   pk_12_total 110 149 102   * 34     *   49                             447 110 149 102     34         49                       447
1244703 1244703 MD     school 2400600 18   Saint Mary's 240060001356 306 Leonardtown High   Regular School No High 09 12 2020   pk_12_total 1426 163 103   * 60     *   128                             1889 1426 163 103     60         128                       1889
1237389 1237389 MD     school 2400060 2   Anne Arundel 240006000049 1092 Brooklyn Park Elementary   Regular School No Elementary PK 05 2020   pk_12_total 199 108 104   * *         30                             450 199 108 104               30                       450
1242213 1242213 MD     school 2400480 15   Montgomery 240048001721 341 Wilson Wims Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 178 131 104   * 316     *   35                             767 178 131 104     316         35                       767
1243985 1243985 MD     school 2400510 16   Prince George's 240051001001 1414 Catherine T. Reed Elementary   Regular School No Elementary PK 05 2020   pk_12_total 20 358 104   * 15     *   *                             508 20 358 104     15                                 508
1244965 1244965 MD     school 2400660 21   Washington 240066001290 201 Springfield Middle   Regular School No Middle 06 08 2020   pk_12_total 623 77 104   * 13         48                             866 623 77 104     13         48                       866
1246348 1246348 MD     school 2400090 30   Baltimore City 240009000182 247 Cross Country Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 20 569 104   *       *   *                             699 20 569 104                                       699
1238668 1238668 MD     school 2400120 3   Baltimore County 240012000454 808 Pot Spring Elementary   Regular School No Elementary PK 05 2020   pk_12_total 170 127 105   * 54         20                             477 170 127 105     54         20                       477
1239162 1239162 MD     school 2400120 3   Baltimore County 240012000438 1473 Overlea High   Regular School No High 09 12 2020   pk_12_total 173 665 105   * 28     *   45                             1020 173 665 105     28         45                       1020
1243681 1243681 MD     school 2400510 16   Prince George's 240051001052 1103 Gwynn Park High   Regular School No High 09 12 2020   pk_12_total 34 778 105   * 13     *   26                             961 34 778 105     13         26                       961
1244978 1244978 MD     school 2400660 21   Washington 240066001295 204 Williamsport High   Regular School No High 09 12 2020   pk_12_total 663 79 105   * *         47                             903 663 79 105               47                       903
1238336 1238336 MD     school 2400120 3   Baltimore County 240012000411 155 Southwest Academy   Regular School No Middle 06 08 2020   pk_12_total 30 564 106   * 93         26                             823 30 564 106     93         26                       823
1241653 1241653 MD     school 2400420 13   Howard 240042001700 617 Lake Elkhorn Middle   Regular School No Middle 06 08 2020   pk_12_total 71 293 106     49         45                             564 71 293 106     49         45                       564
1243373 1243373 MD     school 2400510 16   Prince George's 240051001184 636 William Beanes Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 363 106     *     *   *                             481   363 106                                       481
1244081 1244081 MD     school 2400510 16   Prince George's 240051001475 1510 James Madison Middle   Regular School No Middle 06 08 2020   pk_12_total 17 721 106   * *     *   13                             870 17 721 106               13                       870
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
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
1240765 1240765 MD     school 2400330 10   Frederick 240033000654 2607 Walkersville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 330 143 107   * 24     *   70                             678 330 143 107     24         70                       678
1242735 1242735 MD     school 2400480 15   Montgomery 240048000894 749 Piney Branch Elementary   Regular School No Elementary 03 05 2020   pk_12_total 268 209 107   * 20     *   44                             650 268 209 107     20         44                       650
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
1241270 1241270 MD     school 2400420 13   Howard 240042001172 108 Bonnie Branch Middle   Regular School No Middle 06 08 2020   pk_12_total 257 168 108   * 128         41                             703 257 168 108     128         41                       703
1241365 1241365 MD     school 2400420 13   Howard 240042000856 217 Hollifield Station Elementary   Regular School No Elementary KG 05 2020   pk_12_total 212 117 108   * 401     *   28                             872 212 117 108     401         28                       872
1241492 1241492 MD     school 2400420 13   Howard 240042000755 517 Swansfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 70 311 108     39         34                             562 70 311 108     39         34                       562
1244294 1244294 MD     school 2400510 16   Prince George's 240051000998 1811 Carmody Hills Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 308 108               *                             423   308 108                                       423
1246726 1246726 MD     school 2400090 30   Baltimore City 240009000280 410 Mergenthaler Vocational-Technical High   Career and Technical School No High 09 12 2020   pk_12_total 44 1555 108   * *         *                             1719 44 1555 108                                       1719
1242757 1242757 MD     school 2400480 15   Montgomery 240048000877 757 Montgomery Blair High   Regular School No High 09 12 2020   pk_12_total 770 779 1085   * 450     *   134                             3223 770 779 1085     450         134                       3223

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