enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
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
1245907 1245907 MD     school 2400090 30   Baltimore City 240009000154 124 Bay-Brook Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 17 265 143               *                             427 17 265 143                                       427
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
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
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
1246045 1246045 MD     school 2400090 30   Baltimore City 240009000183 207 Curtis Bay Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 171 280 166   *       *   39                             659 171 280 166               39                       659
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
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
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
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
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
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
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
1246410 1246410 MD     school 2400090 30   Baltimore City 240009001430 260 Frederick Elementary   Regular School Yes Elementary PK 05 2020   pk_12_total 28 340 16   *           *                             394 28 340 16                                       394
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
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
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
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
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
1246538 1246538 MD     school 2400090 30   Baltimore City 240009001571 332 The Green School of Baltimore   Regular School Yes Elementary KG 05 2020   pk_12_total 57 74 11           *   18                             161 57 74 11               18                       161
1246567 1246567 MD     school 2400090 30   Baltimore City 240009001661 337 Afya Public Charter School   Regular School Yes Middle 07 08 2020   pk_12_total   215 12               *                             228   215 12                                       228
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
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
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
1246670 1246670 MD     school 2400090 30   Baltimore City 240009001690 376 City Neighbors High   Regular School Yes High 09 12 2020   pk_12_total 27 370 16   *           *                             418 27 370 16                                       418
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
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
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
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
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
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
1237222 1237222 MD     school 2400030 1   Allegany 240003001359 401 South Penn Elementary   Regular School No Elementary PK 05 2020   pk_12_total 421 51 *     *         88                             571 421 51                 88                       571
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
1237239 1237239 MD     school 2400030 1   Allegany 240003000031 406 Washington Middle   Regular School No Middle 06 08 2020   pk_12_total 522 35 *     *     *   46                             612 522 35                 46                       612
1237247 1237247 MD     school 2400030 1   Allegany 240003000024 502 Northeast Elementary   Regular School No Elementary PK 05 2020   pk_12_total 268 16 *   * *         30                             319 268 16                 30                       319
1237262 1237262 MD     school 2400030 1   Allegany 240003000032 603 West Side Elementary   Regular School No Elementary PK 05 2020   pk_12_total 288 17 *   * *         52                             367 288 17                 52                       367
1237275 1237275 MD     school 2400030 1   Allegany 240003000010 701 Cresaptown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 284 * 12     *     *   16                             320 284   12               16                       320
1237283 1237283 MD     school 2400030 1   Allegany 240003000005 702 Bel Air Elementary   Regular School No Elementary PK 05 2020   pk_12_total 204 * *     *         11                             225 204                   11                       225
1237295 1237295 MD     school 2400030 1   Allegany 240003000007 802 Westmar Middle   Regular School No Middle 06 08 2020   pk_12_total 258   *     *         *                             268 258                                           268
1237311 1237311 MD     school 2400030 1   Allegany 240003000016 1101 Frost Elementary   Regular School No Elementary PK 05 2020   pk_12_total 183   *     *         *                             195 183                                           195
1237315 1237315 MD     school 2400030 1   Allegany 240003000023 1301 Mount Savage Middle   Regular School No Middle 06 08 2020   pk_12_total 369 * *   * *     *   12                             394 369                   12                       394
1237328 1237328 MD     school 2400030 1   Allegany 240003001636 2404 Mountain Ridge High School   Regular School No High 09 12 2020   pk_12_total 729 17 *   * *         24                             784 729 17                 24                       784
1237336 1237336 MD     school 2400030 1   Allegany 240003000003 2801 Beall Elementary   Regular School No Elementary PK 05 2020   pk_12_total 386 * *   * *         30                             441 386                   30                       441
1237344 1237344 MD     school 2400030 1   Allegany 240003001338 2901 Cash Valley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 242 13 *   * *         12                             279 242 13                 12                       279
1237352 1237352 MD     school 2400030 1   Allegany 240003000026 2902 Parkside Elementary   Regular School No Elementary PK 05 2020   pk_12_total 164 15 *     *         18                             210 164 15                 18                       210
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
1237392 1237392 MD     school 2400060 2   Anne Arundel 240006000066 1102 Ferndale Early Education Center   Regular School No Elementary PK KG 2020   pk_12_total 76 33 28   * *         *                             151 76 33 28                                       151
1237414 1237414 MD     school 2400060 2   Anne Arundel 240006000077 1132 Glendale Elementary   Regular School No Elementary PK 05 2020   pk_12_total 192 41 134   * *     *   34                             412 192 41 134               34                       412
1237560 1237560 MD     school 2400060 2   Anne Arundel 240006000045 2072 Benfield Elementary   Regular School No Elementary PK 05 2020   pk_12_total 350 * 21   * *         28                             410 350   21               28                       410
1237567 1237567 MD     school 2400060 2   Anne Arundel 240006000046 2082 Bodkin Elementary   Regular School No Elementary KG 05 2020   pk_12_total 485 10 35     *         25                             557 485 10 35               25                       557
1237589 1237589 MD     school 2400060 2   Anne Arundel 240006000068 2112 Fort Smallwood Elementary   Regular School No Elementary PK 05 2020   pk_12_total 416 18 15     *         14                             468 416 18 15               14                       468
1237619 1237619 MD     school 2400060 2   Anne Arundel 240006000085 2162 Lake Shore Elementary   Regular School No Elementary KG 05 2020   pk_12_total 288 * 18     *         19                             327 288   18               19                       327
1237634 1237634 MD     school 2400060 2   Anne Arundel 240006000113 2182 Pasadena Elementary   Regular School No Elementary KG 05 2020   pk_12_total 297 17 26     *         19                             364 297 17 26               19                       364
1237642 1237642 MD     school 2400060 2   Anne Arundel 240006000121 2192 Riviera Beach Elementary   Regular School No Elementary PK 05 2020   pk_12_total 252 12 16   * *         22                             312 252 12 16               22                       312
1237670 1237670 MD     school 2400060 2   Anne Arundel 240006000899 2233 Anne Arundel Evening High   Alternative School No High 09 12 2020   pk_12_total 150 66 55   * *         22                             296 150 66 55               22                       296
1237698 1237698 MD     school 2400060 2   Anne Arundel 240006001516 2372 Windsor Farm Elementary   Regular School No Elementary KG 05 2020   pk_12_total 388 41 87   * *         37                             564 388 41 87               37                       564
1237779 1237779 MD     school 2400060 2   Anne Arundel 240006000092 3122 Manor View Elementary   Regular School No Elementary 01 05 2020   pk_12_total 114 69 65     *     *   42                             301 114 69 65               42                       301
1237787 1237787 MD     school 2400060 2   Anne Arundel 240006000096 3132 Maryland City Elementary   Regular School No Elementary PK 05 2020   pk_12_total 17 150 196   * *         11                             384 17 150 196               11                       384
1237795 1237795 MD     school 2400060 2   Anne Arundel 240006000098 3142 Meade Heights Elementary   Regular School No Elementary PK 05 2020   pk_12_total 71 258 62   * *         30                             429 71 258 62               30                       429
1237803 1237803 MD     school 2400060 2   Anne Arundel 240006000137 3152 Van Bokkelen Elementary   Regular School No Elementary PK 05 2020   pk_12_total 17 304 118   * *     *   20                             465 17 304 118               20                       465
1237810 1237810 MD     school 2400060 2   Anne Arundel 240006000100 3162 Millersville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 249 23 30     *     *   33                             344 249 23 30               33                       344
1237847 1237847 MD     school 2400060 2   Anne Arundel 240006000130 3212 South Shore Elementary   Regular School No Elementary KG 05 2020   pk_12_total 230 * 57   * *         36                             340 230   57               36                       340
1237948 1237948 MD     school 2400060 2   Anne Arundel 240006001425 3414 Ruth Parker Eason School   Special Education School No Other PK 12 2020   pk_12_total 51 63 19     *         *                             143 51 63 19                                       143
1237962 1237962 MD     school 2400060 2   Anne Arundel 240006000132 4023 Southern High   Regular School No High 09 12 2020   pk_12_total 729 75 132   * *     *   51                             996 729 75 132               51                       996
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
1238000 1238000 MD     school 2400060 2   Anne Arundel 240006000035 4092 Annapolis Elementary   Regular School No Elementary PK 05 2020   pk_12_total 37 133 41     *         *                             214 37 133 41                                       214
1238002 1238002 MD     school 2400060 2   Anne Arundel 240006001746 4102 Carrie Weedon Early Education Center   Regular School No Prekindergarten PK PK 2020   pk_12_total 36 * 17     *                                       61 36   17                                       61
1238031 1238031 MD     school 2400060 2   Anne Arundel 240006000064 4142 Eastport Elementary   Regular School No Elementary PK 05 2020   pk_12_total 38 104 144   * *         10                             300 38 104 144               10                       300
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
1238054 1238054 MD     school 2400060 2   Anne Arundel 240006000074 4182 Germantown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 93 119 287   * *         *                             512 93 119 287                                       512
1238062 1238062 MD     school 2400060 2   Anne Arundel 240006000080 4192 Hillsmere Elementary   Regular School No Elementary PK 05 2020   pk_12_total 272 72 59   * *         15                             424 272 72 59               15                       424
1238070 1238070 MD     school 2400060 2   Anne Arundel 240006000089 4202 Lothian Elementary   Regular School No Elementary PK 05 2020   pk_12_total 247 37 164   * *     *   40                             495 247 37 164               40                       495
1238077 1238077 MD     school 2400060 2   Anne Arundel 240006000097 4212 Mayo Elementary   Regular School No Elementary KG 05 2020   pk_12_total 279 11 34     *     *   19                             347 279 11 34               19                       347
1238085 1238085 MD     school 2400060 2   Anne Arundel 240006000112 4222 Walter S. Mills - Parole Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 233 355   * *         12                             615   233 355               12                       615
1238101 1238101 MD     school 2400060 2   Anne Arundel 240006000128 4242 Shady Side Elementary   Regular School No Elementary PK 05 2020   pk_12_total 384 38 19     *         20                             466 384 38 19               20                       466
1238116 1238116 MD     school 2400060 2   Anne Arundel 240006000136 4262 Tyler Heights Elementary   Regular School No Elementary PK 05 2020   pk_12_total   14 466     *         *                             488   14 466                                       488
1238123 1238123 MD     school 2400060 2   Anne Arundel 240006000139 4272 West Annapolis Elementary   Regular School No Elementary KG 05 2020   pk_12_total 162 24 40   * *         20                             251 162 24 40               20                       251
1238147 1238147 MD     school 2400060 2   Anne Arundel 240006000056 4304 Central Special School   Special Education School No Other PK 12 2020   pk_12_total 80 32 23     *         *                             148 80 32 23                                       148
1238189 1238189 MD     school 2400120 3   Baltimore County 240012001751 52 Southwest EDLP at Woodlawn High School   Alternative School No High 09 12 2020   pk_12_total * * *     *         *                             14                                             14
1238218 1238218 MD     school 2400120 3   Baltimore County 240012000436 69 Catonsville Center for Alternative Studies   Alternative School No High 09 12 2020   pk_12_total * 45 *     *         *                             55   45                                         55
1238221 1238221 MD     school 2400120 3   Baltimore County 240012000777 70 Meadowood Education Center   Alternative School No Middle 07 08 2020   pk_12_total * 25 *   * *         *                             33   25                                         33

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