enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1245023 1245023 MD     school 2400660 21   Washington 240066001259 402 Clear Spring Elementary   Regular School No Elementary PK 05 2020   pk_12_total 389 * *               10                             411 389                   10                       411
1245036 1245036 MD     school 2400660 21   Washington 240066001270 501 Hancock Middle Senior High   Regular School No High 06 12 2020   pk_12_total 236   *     *         *                             248 236                                           248
1245044 1245044 MD     school 2400660 21   Washington 240066001269 502 Hancock Elementary   Regular School No Elementary PK 05 2020   pk_12_total 220 * *   * *         *                             229 220                                           229
1245080 1245080 MD     school 2400660 21   Washington 240066001484 705 Washington County Job Development Center   Special Education School No High 12 12 2020   pk_12_total 23 * *               *                             33 23                                           33
1245108 1245108 MD     school 2400660 21   Washington 240066001280 1101 Pleasant Valley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 238 * *   * *         *                             262 238                                           262
1245124 1245124 MD     school 2400660 21   Washington 240066001258 1401 Cascade Elementary   Regular School No Elementary PK 05 2020   pk_12_total 139 * *     *         *                             150 139                                           150
1245132 1245132 MD     school 2400660 21   Washington 240066001268 1602 Greenbrier Elementary   Regular School No Elementary PK 05 2020   pk_12_total 173 * *     18         *                             215 173         18                                 215
1245199 1245199 MD     school 2400660 21   Washington 240066001289 2505 Marshall Street School   Special Education School No Other KG 12 2020   pk_12_total 25 * *     *         *                             43 25                                           43
1245426 1245426 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2020   pk_12_total 28 19 *     *         *                             55 28 19                                         55
1245456 1245456 MD     school 2400090 30   Baltimore City 240009000169 7 Cecil Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 384 *           *   *                             391   384                                         391
1245486 1245486 MD     school 2400090 30   Baltimore City 240009000196 11 Eutaw-Marshburn Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 262 *               *                             271   262                                         271
1245520 1245520 MD     school 2400090 30   Baltimore City 240009000258 16 Johnston Square Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 282 *               *                             291   282                                         291
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
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
1309783 1309783 MD     school 2400030 1   Allegany 240003001359 401 South Penn Elementary   Regular School No Elementary PK 05 2021   pk_12_total 361 40 *     *         85                             497 361 40                 85                       497
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
1309800 1309800 MD     school 2400030 1   Allegany 240003000031 406 Washington Middle   Regular School No Middle 06 08 2021   pk_12_total 516 27 *   * *     *   53                             609 516 27                 53                       609
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
1309823 1309823 MD     school 2400030 1   Allegany 240003000032 603 West Side Elementary   Regular School No Elementary PK 05 2021   pk_12_total 240 22 *   * *         47                             319 240 22                 47                       319
1309836 1309836 MD     school 2400030 1   Allegany 240003000010 701 Cresaptown Elementary   Regular School No Elementary PK 05 2021   pk_12_total 251 * *   * *     *   17                             287 251                   17                       287
1309844 1309844 MD     school 2400030 1   Allegany 240003000005 702 Bel Air Elementary   Regular School No Elementary PK 05 2021   pk_12_total 202   *     *         *                             216 202                                           216
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
1309872 1309872 MD     school 2400030 1   Allegany 240003000016 1101 Frost Elementary   Regular School No Elementary PK 05 2021   pk_12_total 179   *     *         *                             192 179                                           192
1309876 1309876 MD     school 2400030 1   Allegany 240003000023 1301 Mount Savage Middle   Regular School No Middle 06 08 2021   pk_12_total 355 * *   * *     *   13                             383 355                   13                       383
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
1309897 1309897 MD     school 2400030 1   Allegany 240003000003 2801 Beall Elementary   Regular School No Elementary PK 05 2021   pk_12_total 384 * *   * *         41                             445 384                   41                       445
1309905 1309905 MD     school 2400030 1   Allegany 240003001338 2901 Cash Valley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 226 19 *     *         16                             273 226 19                 16                       273
1309913 1309913 MD     school 2400030 1   Allegany 240003000026 2902 Parkside Elementary   Regular School No Elementary PK 05 2021   pk_12_total 134 16 *     *         15                             178 134 16                 15                       178
1310275 1310275 MD     school 2400060 2   Anne Arundel 240006001421 2432 Shipley's Choice Elementary   Regular School No Elementary KG 05 2021   pk_12_total 320 * *     13         23                             369 320         13         23                       369
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
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 * * *                                             *                                              
1310773 1310773 MD     school 2400120 3   Baltimore County 240012000436 69 Catonsville Center for Alternative Studies   Alternative School No High 09 12 2021   pk_12_total * 41 *     *         *                             51   41                                         51
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
1310790 1310790 MD     school 2400120 3   Baltimore County 240012001649 75 Crossroads Center   Alternative School No High 07 12 2021   pk_12_total 63 84 *   * *         12                             169 63 84                 12                       169
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
1310850 1310850 MD     school 2400120 3   Baltimore County 240012000466 111 Maiden Choice School   Special Education School No Other PK 12 2021   pk_12_total 29 71 *     16         *                             130 29 71       16                                 130
1310991 1310991 MD     school 2400120 3   Baltimore County 240012000371 216 Deer Park Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 368 *     *         10                             396   368                 10                       396
1311058 1311058 MD     school 2400120 3   Baltimore County 240012000387 308 Fort Garrison Elementary   Regular School No Elementary PK 05 2021   pk_12_total 203 59 *   * *         *                             283 203 59                                         283
1311181 1311181 MD     school 2400120 3   Baltimore County 240012000456 601 Prettyboy Elementary   Regular School No Elementary KG 05 2021   pk_12_total 360 * *     *         *                             385 360                                           385
1311380 1311380 MD     school 2400120 3   Baltimore County 240012001435 923 White Oak School   Special Education School No Elementary PK 05 2021   pk_12_total 30 33 *     *         *                             75 30 33                                         75
1311440 1311440 MD     school 2400120 3   Baltimore County 240012000413 1104 Kingsville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 242 * *     *     *   *                             272 242                                           272
1311563 1311563 MD     school 2400120 3   Baltimore County 240012000346 1215 Battle Monument School   Special Education School No Other PK 12 2021   pk_12_total 31 19 *     *         *                             63 31 19                                         63
1311773 1311773 MD     school 2400120 3   Baltimore County 240012000363 1511 Chesapeake Terrace Elementary   Regular School No Elementary PK 05 2021   pk_12_total 253 * *   * *         *                             273 253                                           273

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