enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pk_12_total · 2,691 ✖
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
1309775 1309775 MD     school 2400030 1   Allegany 240003000014 301 Flintstone Elementary   Regular School No Elementary PK 05 2021   pk_12_total 193 * *               *                             205 193                                           205
1309791 1309791 MD     school 2400030 1   Allegany 240003000019 402 John Humbird Elementary   Regular School No Elementary PK 05 2021   pk_12_total 176 21 *               33                             233 176 21                 33                       233
1309808 1309808 MD     school 2400030 1   Allegany 240003000024 502 Northeast Elementary   Regular School No Elementary PK 05 2021   pk_12_total 228 14 *               24                             269 228 14                 24                       269
1309815 1309815 MD     school 2400030 1   Allegany 240003000030 601 Center for Career & Technical Education   Career and Technical School No High 11 12 2021   pk_12_total 245 * *   *           *                             258 245                                           258
1309852 1309852 MD     school 2400030 1   Allegany 240003000033 801 Westernport Elementary   Regular School No Elementary PK 05 2021   pk_12_total 239 * *           *   10                             256 239                   10                       256
1309856 1309856 MD     school 2400030 1   Allegany 240003000007 802 Westmar Middle   Regular School No Middle 06 08 2021   pk_12_total 241   *               *                             256 241                                           256
1309884 1309884 MD     school 2400030 1   Allegany 240003001546 1302 Mt. Savage Elementary   Regular School No Elementary PK 05 2021   pk_12_total 181 * *   *           *                             186 181                                           186
1310182 1310182 MD     school 2400060 2   Anne Arundel 240006000085 2162 Lake Shore Elementary   Regular School No Elementary PK 05 2021   pk_12_total 275 * 19               21                             317 275   19               21                       317
1310543 1310543 MD     school 2400060 2   Anne Arundel 240006001729 4064 Mary Moss at Adams Academy   Alternative School No Middle 07 09 2021   pk_12_total 10 19 *               *                             42 10 19                                         42
1310556 1310556 MD     school 2400060 2   Anne Arundel 240006001714 4074 Phoenix Academy   Special Education School No Other 01 12 2021   pk_12_total 121 172 30   *           24                             349 121 172 30               24                       349
1310566 1310566 MD     school 2400060 2   Anne Arundel 240006001746 4102 Carrie Weedon Early Education Center   Regular School No Prekindergarten PK PK 2021   pk_12_total 33 * 21               *                             62 33   21                                       62
1310749 1310749 MD     school 2400120 3   Baltimore County 240012001756 51 Northwest EDLP at Milford Mill Academy   Alternative School No High 10 12 2021   pk_12_total   *                                               *                                              
1310752 1310752 MD     school 2400120 3   Baltimore County 240012001751 52 Southwest EDLP at Woodlawn High School   Alternative School No High 11 12 2021   pk_12_total * * *                                             *                                              
1310755 1310755 MD     school 2400120 3   Baltimore County 240012001754 53 Northeast EDLP at Parkville High School   Alternative School No High 11 12 2021   pk_12_total * * *                                             15                                             15
1310758 1310758 MD     school 2400120 3   Baltimore County 240012001759 55 Southeast EDLP at Dundalk High School   Alternative School No High 10 12 2021   pk_12_total * * *                                             *                                              
1310760 1310760 MD     school 2400120 3   Baltimore County 240012001760 56 Central EDLP at Loch Raven High School   Alternative School No High 12 12 2021   pk_12_total *                                                 *                                              
1310765 1310765 MD     school 2400120 3   Baltimore County 240012000935 58 Home Assignments-Secondary   Alternative School No High 08 12 2021   pk_12_total * *                                               12                                             12
1310776 1310776 MD     school 2400120 3   Baltimore County 240012000777 70 Meadowood Education Center   Alternative School No Middle 07 08 2021   pk_12_total * 12 *               *                             15   12                                         15
1310783 1310783 MD     school 2400120 3   Baltimore County 240012000831 72 Rosedale Center   Alternative School No High 07 12 2021   pk_12_total * 17                 *                             25   17                                         25
1310795 1310795 MD     school 2400120 3   Baltimore County 240012001711 77 BCDC Educational Center   Alternative School No High 09 12 2021   pk_12_total * 19 *                                             31   19                                         31
1310959 1310959 MD     school 2400120 3   Baltimore County 240012000455 210 Powhatan Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 180 20   *       *   10                             216   180 20               10                       216
1311672 1311672 MD     school 2400120 3   Baltimore County 240012000426 1403 McCormick Elementary   Regular School No Elementary PK 05 2021   pk_12_total 13 263 18           *   12                             308 13 263 18               12                       308
1311852 1311852 MD     school 2400120 3   Baltimore County 240012000469 1527 Sandalwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 36 334 74   *           32                             479 36 334 74               32                       479
1311927 1311927 MD     school 2400150 4   Calvert 240015000514 110 Mutual Elementary   Regular School No Elementary KG 05 2021   pk_12_total 243 39 15   *           33                             331 243 39 15               33                       331
1311980 1311980 MD     school 2400150 4   Calvert 240015000517 207 Calvert Elementary   Regular School No Elementary PK 05 2021   pk_12_total 307 100 25   *           61                             496 307 100 25               61                       496
1312292 1312292 MD     school 2400210 6   Carroll 240021000527 712 Carroll Springs School   Special Education School No Other 01 12 2021   pk_12_total 25 * *                                             28 25                                           28
1312318 1312318 MD     school 2400210 6   Carroll 240021001349 718 PRIDE School   Alternative School No Elementary 01 05 2021   pk_12_total * * *                                             *                                              
1312321 1312321 MD     school 2400210 6   Carroll 240021001694 726 Crossroads Middle School   Alternative School No Middle 07 08 2021   pk_12_total *   *                                             *                                              
1312350 1312350 MD     school 2400210 6   Carroll 240021001350 903 Flexible Student Support   Alternative School No High 09 12 2021   pk_12_total 28 *                                               32 28                                           32
1312392 1312392 MD     school 2400240 7   Cecil 240024000562 104 Cecilton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 207 16 43   *           15                             282 207 16 43               15                       282
1312405 1312405 MD     school 2400240 7   Cecil 240024000565 205 Chesapeake City Elementary   Regular School No Elementary PK 05 2021   pk_12_total 309 * 21               15                             349 309   21               15                       349
1312438 1312438 MD     school 2400240 7   Cecil 240024000564 313 Cherry Hill Middle   Regular School No Middle 06 08 2021   pk_12_total 277 56 52               29                             414 277 56 52               29                       414
1312446 1312446 MD     school 2400240 7   Cecil 240024000572 315 Leeds Elementary   Regular School No Elementary PK 05 2021   pk_12_total 300 * 19               25                             350 300   19               25                       350
1312462 1312462 MD     school 2400240 7   Cecil 240024001491 317 Kenmore Elementary   Regular School No Elementary PK 05 2021   pk_12_total 237 17 33               16                             303 237 17 33               16                       303
1312498 1312498 MD     school 2400240 7   Cecil 240024000563 513 Charlestown Elementary   Regular School No Elementary PK 05 2021   pk_12_total 197 21 11           *   19                             253 197 21 11               19                       253
1312543 1312543 MD     school 2400240 7   Cecil 240024000556 704 Bainbridge Elementary   Regular School No Elementary PK 05 2021   pk_12_total 221 12 *   *           23                             265 221 12                 23                       265
1312556 1312556 MD     school 2400240 7   Cecil 240024000566 801 Conowingo Elementary   Regular School No Elementary PK 05 2021   pk_12_total 373 * 14   *           10                             407 373   14               10                       407
1312564 1312564 MD     school 2400240 7   Cecil 240024000559 904 Calvert Elementary   Regular School No Elementary PK 05 2021   pk_12_total 375   19   *           *                             404 375   19                                       404
1312607 1312607 MD     school 2400270 8   Charles 240027001492 302 Mt Hope/Nanjemoy Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 145 56 *   *           22                             230 145 56                 22                       230
1312777 1312777 MD     school 2400270 8   Charles 240027001395 708 Robert D. Stethem Educational Center   Alternative School No High 07 12 2021   pk_12_total 22 34 *               *                             65 22 34                                         65
1312888 1312888 MD     school 2400300 9   Dorchester 240030000841 716 Choptank Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 33 205 52               15                             305 33 205 52               15                       305
1312934 1312934 MD     school 2400330 10   Frederick 240033001410 208 Heather Ridge   Alternative School No High 07 12 2021   pk_12_total 22 11 *   *           *                             44 22 11                                         44
1313039 1313039 MD     school 2400330 10   Frederick 240033000659 603 Wolfsville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 105 * *               *                             123 105                                           123
1313151 1313151 MD     school 2400330 10   Frederick 240033000648 1001 Sabillasville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 60 * *               *                             70 60                                           70
1313159 1313159 MD     school 2400330 10   Frederick 240033001442 1105 New Midway/Woodsboro Elementary   Regular School No Elementary PK 05 2021   pk_12_total 245 * 16               20                             287 245   16               20                       287
1313181 1313181 MD     school 2400330 10   Frederick 240033000650 1503 Thurmont Elementary   Regular School No Elementary 03 05 2021   pk_12_total 256   22   *           12                             292 256   22               12                       292
1313218 1313218 MD     school 2400330 10   Frederick 240033000636 2001 Lewistown Elementary   Regular School No Elementary PK 05 2021   pk_12_total 120 * 26               *                             161 120   26                                       161
1313289 1313289 MD     school 2400330 10   Frederick 240033000647 2404 Rock Creek   Special Education School No Other PK 12 2021   pk_12_total 39 16 11               *                             71 39 16 11                                       71
1313339 1313339 MD     school 2400360 11   Garrett 240036000667 1202 Friendsville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 131   *               *                             140 131                                           140
1313347 1313347 MD     school 2400360 11   Garrett 240036000668 1301 Grantsville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 171                   *                             172 171                                           172

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