enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
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
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
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
1245680 1245680 MD     school 2400090 30   Baltimore City 240009000152 54 Barclay Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 392 64   * *     *   *                             477   392 64                                       477
1245710 1245710 MD     school 2400090 30   Baltimore City 240009000229 60 Gwynns Falls Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 313                                               316   313                                         316
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
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
1245745 1245745 MD     school 2400090 30   Baltimore City 240009000270 64 Liberty Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 470 12           *   *                             488   470 12                                       488
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
1245782 1245782 MD     school 2400090 30   Baltimore City 240009000164 75 Calverton Elementary/Middle   Regular School No Elementary KG 08 2020   pk_12_total * 332 15     *         *                             358   332 15                                       358
1245804 1245804 MD     school 2400090 30   Baltimore City 240009000602 81 North Bend Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 457 24   *       *   *                             493   457 24                                       493
1245812 1245812 MD     school 2400090 30   Baltimore City 240009000334 83 William Paca Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 267 227   * *     *   *                             509   267 227                                       509
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
1245858 1245858 MD     school 2400090 30   Baltimore City 240009000273 88 Wildwood Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 771 20           *   *                             800   771 20                                       800
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
1245888 1245888 MD     school 2400090 30   Baltimore City 240009000282 105 Moravia Park Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 698 26   * 10     14   *                             763   698 26     10     14                           763
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
1245930 1245930 MD     school 2400090 30   Baltimore City 240009000328 134 Walter P. Carter Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 376 11   *           *                             395   376 11                                       395
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
1245969 1245969 MD     school 2400090 30   Baltimore City 240009000171 159 The Historic Cherry Hill Elementary/Middle   Regular School No Middle 03 08 2020   pk_12_total * 641 29   *           *                             680   641 29                                       680
1245974 1245974 MD     school 2400090 30   Baltimore City 240009000148 164 Arundel Elementary   Regular School No Elementary PK 02 2020   pk_12_total * 502 12               *                             523   502 12                                       523
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
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
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
1246056 1246056 MD     school 2400090 30   Baltimore City 240009000241 210 Hazelwood Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 437 29     *         *                             477   437 29                                       477
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
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
1246105 1246105 MD     school 2400090 30   Baltimore City 240009000243 215 Highlandtown Elementary/Middle #215   Regular School No Elementary PK 08 2020   pk_12_total * 73 387     *     *   *                             476   73 387                                       476
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
1246121 1246121 MD     school 2400090 30   Baltimore City 240009000340 219 Yorkwood Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 392 13   * *         *                             412   392 13                                       412
1246153 1246153 MD     school 2400090 30   Baltimore City 240009000299 223 Pimlico Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 579 29     *     *   *                             621   579 29                                       621
1246164 1246164 MD     school 2400090 30   Baltimore City 240009000331 225 Westport Academy   Regular School No Elementary PK 08 2020   pk_12_total * 253 13     *         *                             281   253 13                                       281
1246217 1246217 MD     school 2400090 30   Baltimore City 240009000322 232 Thomas Jefferson Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 436 12   *                                         457   436 12                                       457
1246236 1246236 MD     school 2400090 30   Baltimore City 240009000146 234 Arlington Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 307 81               *                             392   307 81                                       392
1246296 1246296 MD     school 2400090 30   Baltimore City 240009000199 241 Fallstaff Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 242 266   * *     *   *                             526   242 266                                       526
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
1246326 1246326 MD     school 2400090 30   Baltimore City 240009000268 245 Leith Walk Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 945 60     *     *   *                             1023   945 60                                       1023
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
1246380 1246380 MD     school 2400090 30   Baltimore City 240009000163 251 Callaway Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 282 14     *         *                             303   282 14                                       303
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
1246402 1246402 MD     school 2400090 30   Baltimore City 240009001390 256 Calvin M. Rodwell Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 681 35   * *         *                             729   681 35                                       729
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
1246466 1246466 MD     school 2400090 30   Baltimore City 240009001369 314 Sharp-Leadenhall Elementary   Special Education School No Elementary 01 05 2020   pk_12_total * 15                 *                             18   15                                         18
1246491 1246491 MD     school 2400090 30   Baltimore City 240009001291 323 The Crossroads School   Regular School Yes Middle 06 08 2020   pk_12_total * 114 37   *           *                             162   114 37                                       162
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
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
1246580 1246580 MD     school 2400090 30   Baltimore City 240009001662 345 Joseph C. Briscoe Academy   Special Education School No High 06 12 2020   pk_12_total * 50                                               57   50                                         57
1246600 1246600 MD     school 2400090 30   Baltimore City 240009001681 347 KIPP Harmony Academy   Regular School Yes Elementary KG 08 2020   pk_12_total * 1490 23               *                             1520   1490 23                                       1520
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
1246659 1246659 MD     school 2400090 30   Baltimore City 240009001693 374 Vanguard Collegiate Middle   Regular School No Middle 06 08 2020   pk_12_total * 331 19     *     11   *                             378   331 19           11                           378
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
1246716 1246716 MD     school 2400090 30   Baltimore City 240009000203 406 Forest Park High   Regular School No High 09 12 2020   pk_12_total * 542 119   * *     *   *                             676   542 119                                       676
1246731 1246731 MD     school 2400090 30   Baltimore City 240009000236 413 Achievement Academy at Harbor City High   Alternative School No High 09 12 2020   pk_12_total * 404 26   *                                         433   404 26                                       433
1246764 1246764 MD     school 2400090 30   Baltimore City 240009001559 422 New Era Academy   Regular School No High 09 12 2020   pk_12_total * 193 124     *         *                             328   193 124                                       328
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
1246797 1246797 MD     school 2400090 30   Baltimore City 240009000209 450 Frederick Douglass High   Regular School No High 09 12 2020   pk_12_total * 721 39               *                             769   721 39                                       769
1246802 1246802 MD     school 2400090 30   Baltimore City 240009000168 454 Carver Vocational-Technical High   Career and Technical School No High 09 12 2020   pk_12_total * 859 13   * *         *                             885   859 13                                       885
1246821 1246821 MD     school 2400027 32   SEED 240002701669 1000 The Seed School of Maryland   Regular School No High 06 12 2020   pk_12_total * 383 11               *                             401   383 11                                       401
1238381 1238381 MD     school 2400120 3   Baltimore County 240012000471 206 Scotts Branch Elementary   Regular School No Elementary KG 05 2020   pk_12_total 10 487 33     *     *   *                             543 10 487 33                                       543
1238482 1238482 MD     school 2400120 3   Baltimore County 240012000348 303 Bedford Elementary   Regular School No Elementary 01 05 2020   pk_12_total 10 250 46     *     *   16                             331 10 250 46               16                       331
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
1242577 1242577 MD     school 2400480 15   Montgomery 240048000924 564 South Lake Elementary   Regular School No Elementary PK 05 2020   pk_12_total 10 176 632   * 49     *   23                             893 10 176 632     49         23                       893
1243628 1243628 MD     school 2400510 16   Prince George's 240051001117 1009 Oaklands Elementary   Regular School No Elementary PK 05 2020   pk_12_total 10 172 213     13         *                             409 10 172 213     13                                 409
1243728 1243728 MD     school 2400510 16   Prince George's 240051001030 1208 Flintstone Elementary   Regular School No Elementary PK 05 2020   pk_12_total 10 133 292   * *         *                             449 10 133 292                                       449
1243970 1243970 MD     school 2400510 16   Prince George's 240051001041 1411 Gaywood Elementary   Regular School No Elementary PK 05 2020   pk_12_total 10 131 360   * 10         *                             519 10 131 360     10                                 519
1244267 1244267 MD     school 2400510 16   Prince George's 240051001155 1802 Seat Pleasant Elementary   Regular School No Elementary PK 06 2020   pk_12_total 10 297 79   * *         *                             395 10 297 79                                       395
1244286 1244286 MD     school 2400510 16   Prince George's 240051001002 1810 Central High   Regular School No High 09 12 2020   pk_12_total 10 505 262   * 10     *   *                             798 10 505 262     10                                 798
1244397 1244397 MD     school 2400510 16   Prince George's 240051001000 2005 Carrollton Elementary   Regular School No Elementary PK 05 2020   pk_12_total 10 208 392     12     *                                 623 10 208 392     12                                 623
1245647 1245647 MD     school 2400090 30   Baltimore City 240009000143 50 Abbottston Elementary   Regular School No Elementary PK 05 2020   pk_12_total 10 373 19     *     *   *                             409 10 373 19                                       409
1246206 1246206 MD     school 2400090 30   Baltimore City 240009000161 231 The Belair-Edison School   Regular School Yes Elementary PK 06 2020   pk_12_total 10 795 12   *           11                             831 10 795 12               11                       831
1246701 1246701 MD     school 2400090 30   Baltimore City 240009000194 400 Edmondson-Westside High   Career and Technical School No High 09 12 2020   pk_12_total 10 826 13   * *     *                                 853 10 826 13                                       853
1237978 1237978 MD     school 2400060 2   Anne Arundel 240006001729 4064 Mary Moss at Adams Academy   Alternative School No Middle 07 09 2020   pk_12_total 11 21 *               *                             44 11 21                                         44
1238046 1238046 MD     school 2400060 2   Anne Arundel 240006000073 4162 Georgetown East Elementary   Regular School No Elementary PK 05 2020   pk_12_total 11 160 130     *     *   *                             315 11 160 130                                       315
1243176 1243176 MD     school 2400510 16   Prince George's 240051001146 210 Rogers Heights Elementary   Regular School No Elementary PK 06 2020   pk_12_total 11 99 692     14     *   *                             820 11 99 692     14                                 820
1243266 1243266 MD     school 2400510 16   Prince George's 240051001132 510 Potomac Landing Elementary   Regular School No Elementary PK 05 2020   pk_12_total 11 256 85   * 21     *   *                             382 11 256 85     21                                 382
1243445 1243445 MD     school 2400510 16   Prince George's 240051001034 660 Drew Freeman Middle   Regular School No Middle 06 08 2020   pk_12_total 11 693 150   * *     *   *                             868 11 693 150                                       868
1243742 1243742 MD     school 2400510 16   Prince George's 240051001033 1213 Fort Foote Elementary   Regular School No Elementary PK 06 2020   pk_12_total 11 133 130     26         *                             305 11 133 130     26                                 305
1243801 1243801 MD     school 2400510 16   Prince George's 240051000969 1229 Apple Grove Elementary   Regular School No Elementary PK 06 2020   pk_12_total 11 261 224     12     *                                 512 11 261 224     12                                 512
1243819 1243819 MD     school 2400510 16   Prince George's 240051001066 1233 Indian Queen Elementary   Regular School No Elementary PK 06 2020   pk_12_total 11 135 125   * 32     *   *                             311 11 135 125     32                                 311
1243889 1243889 MD     school 2400510 16   Prince George's 240051001472 1326 Kettering Middle   Regular School No Middle 06 08 2020   pk_12_total 11 697 97     *     *   *                             825 11 697 97                                       825
1246751 1246751 MD     school 2400090 30   Baltimore City 240009001331 419 Reginald F. Lewis High   Regular School No High 09 12 2020   pk_12_total 11 446 81   * *     *   *                             546 11 446 81                                       546
1246777 1246777 MD     school 2400090 30   Baltimore City 240009001385 429 Vivien T. Thomas Medical Arts Academy   Career and Technical School No High 09 12 2020   pk_12_total 11 357 16   *           *                             387 11 357 16                                       387
1238366 1238366 MD     school 2400120 3   Baltimore County 240012000385 204 Featherbed Lane Elementary   Regular School No Elementary PK 05 2020   pk_12_total 12 452 78   * *     *   19                             572 12 452 78               19                       572
1238374 1238374 MD     school 2400120 3   Baltimore County 240012000503 205 Woodmoor Elementary   Regular School No Elementary PK 05 2020   pk_12_total 12 536 46   * *     *   *                             614 12 536 46                                       614
1238458 1238458 MD     school 2400120 3   Baltimore County 240012000501 253 Woodlawn Middle   Regular School No Middle 06 08 2020   pk_12_total 12 550 39     *     *   13                             622 12 550 39               13                       622
1243565 1243565 MD     school 2400510 16   Prince George's 240051001167 908 Surrattsville High   Regular School No High 09 12 2020   pk_12_total 12 562 109     *     *   15                             705 12 562 109               15                       705
1243669 1243669 MD     school 2400510 16   Prince George's 240051000992 1101 Brandywine Elementary   Regular School No Elementary KG 05 2020   pk_12_total 12 323 53   * *         16                             412 12 323 53               16                       412

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