enrollments

Data source: Big Local News · About: Big Local

1,393 rows where grade = "pk_12_total", state = "MD" and year = 2021 sorted by hispanic

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 1,293 ✖

grade ✖

  • pk_12_total · 1,293 ✖
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
1318177 1318177 MD     school 2400090 30   Baltimore City 240009001153 37 Harford Heights Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 385 *               *                             397   385                                         397
1318196 1318196 MD     school 2400090 30   Baltimore City 240009000281 44 Montebello Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 475 *     *         *                             486   475                                         486
1318286 1318286 MD     school 2400090 30   Baltimore City 240009000229 60 Gwynns Falls Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 284 *                                             286   284                                         286
1318294 1318294 MD     school 2400090 30   Baltimore City 240009000256 61 Dorothy I. Height Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 324 *   *                                         339   324                                         339
1318313 1318313 MD     school 2400090 30   Baltimore City 240009000307 63 Rosemont Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total   341 *     *         *                             351   341                                         351
1318340 1318340 MD     school 2400090 30   Baltimore City 240009000193 67 Edgewood Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 169 *               *                             178   169                                         178
1318401 1318401 MD     school 2400090 30   Baltimore City 240009000265 86 Lakewood Elementary   Regular School No Elementary PK KG 2021   pk_12_total * 51 *     *         *                             63   51                                         63
1318434 1318434 MD     school 2400090 30   Baltimore City 240009000208 95 Franklin Square Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 316 *   * *         *                             336   316                                         336
1318445 1318445 MD     school 2400090 30   Baltimore City 240009000179 97 Collington Square Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 308 *   * *     *   *                             326   308                                         326
1318461 1318461 MD     school 2400090 30   Baltimore City 240009000309 122 The Historic Samuel Coleridge-Taylor Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 218 *                                             220   218                                         220
1318480 1318480 MD     school 2400090 30   Baltimore City 240009000211 125 Furman Templeton Preparatory Academy   Regular School Yes Elementary PK 05 2021   pk_12_total * 443 *   *       *   *                             450   443                                         450
1318484 1318484 MD     school 2400090 30   Baltimore City 240009000160 130 Booker T. Washington Middle   Regular School No Middle 06 08 2021   pk_12_total * 218 *                                             225   218                                         225
1318495 1318495 MD     school 2400090 30   Baltimore City 240009000328 134 Walter P. Carter Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 354 *   *           *                             371   354                                         371
1318503 1318503 MD     school 2400090 30   Baltimore City 240009000303 142 Robert W. Coleman Elementary   Regular School No Elementary PK 05 2021   pk_12_total   227 *                                             234   227                                         234
1318511 1318511 MD     school 2400090 30   Baltimore City 240009000255 144 James Mosher Elementary   Regular School No Elementary PK 05 2021   pk_12_total   208 *           *   *                             221   208                                         221
1318543 1318543 MD     school 2400090 30   Baltimore City 240009000219 177 George W. F. McMechen High   Special Education School No High 10 12 2021   pk_12_total * 39 *               *                             44   39                                         44
1318548 1318548 MD     school 2400090 30   Baltimore City 240009001343 178 Excel Academy at Francis M. Wood High   Alternative School No High 09 12 2021   pk_12_total 11 453 *   *           *                             475 11 453                                         475
1318559 1318559 MD     school 2400090 30   Baltimore City 240009000186 201 Dickey Hill Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 273 *     *         *                             286   273                                         286
1318578 1318578 MD     school 2400090 30   Baltimore City 240009000277 204 Mary E. Rodman Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 396 *   * *         *                             412   396                                         412
1318624 1318624 MD     school 2400090 30   Baltimore City 240009000212 211 Gardenville Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 233 *   * *         *                             254   233                                         254
1318635 1318635 MD     school 2400090 30   Baltimore City 240009000213 212 Garrett Heights Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 24 274 *           *   10                             318 24 274                 10                       318
1318654 1318654 MD     school 2400090 30   Baltimore City 240009001428 214 Guilford Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total   254 *     *         *                             262   254                                         262
1318673 1318673 MD     school 2400090 30   Baltimore City 240009000156 217 Belmont Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 231 *   *           *                             241   231                                         241
1318681 1318681 MD     school 2400090 30   Baltimore City 240009000340 219 Yorkwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 348 *   * *     *                                 363   348                                         363
1318779 1318779 MD     school 2400090 30   Baltimore City 240009000322 232 Thomas Jefferson Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 378 *   *           *                             396   378                                         396
1318918 1318918 MD     school 2400090 30   Baltimore City 240009000313 248 Sinclair Lane Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 288 *     *         *                             300   288                                         300
1318934 1318934 MD     school 2400090 30   Baltimore City 240009000187 250 Dr. Bernard Harris, Sr., Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 279 *   *           *                             289   279                                         289
1318969 1318969 MD     school 2400090 30   Baltimore City 240009000260 261 Lockerman Bundy Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 207 *   * *                                       215   207                                         215
1318980 1318980 MD     school 2400090 30   Baltimore City 240009001558 262 Empowerment Academy   Regular School Yes Elementary PK 08 2021   pk_12_total   284 *                                             287   284                                         287
1319001 1319001 MD     school 2400090 30   Baltimore City 240009000176 307 Claremont School   Special Education School No High 07 12 2021   pk_12_total * 47 *                                             51   47                                         51
1319011 1319011 MD     school 2400090 30   Baltimore City 240009001364 313 Lois T. Murray Elementary/Middle   Special Education School No Elementary KG 08 2021   pk_12_total * 34 *                                             44   34                                         44
1319027 1319027 MD     school 2400090 30   Baltimore City 240009000883 321 Midtown Academy   Regular School Yes Elementary KG 08 2021   pk_12_total 12 170 *   * *         *                             198 12 170                                         198
1319038 1319038 MD     school 2400090 30   Baltimore City 240009000884 322 New Song Academy   Regular School Yes Elementary PK 08 2021   pk_12_total   172 *                                             174   172                                         174
1319060 1319060 MD     school 2400090 30   Baltimore City 240009001478 326 City Neighbors Charter School   Regular School Yes Elementary KG 08 2021   pk_12_total 75 148 *               *                             233 75 148                                         233
1319089 1319089 MD     school 2400090 30   Baltimore City 240009001571 332 The Green School of Baltimore   Regular School Yes Elementary KG 05 2021   pk_12_total 61 68 *               24                             162 61 68                 24                       162
1319094 1319094 MD     school 2400090 30   Baltimore City 240009001632 333 Independence School Local I   Regular School Yes High 09 12 2021   pk_12_total 15 138 *                                             155 15 138                                         155
1319117 1319117 MD     school 2400090 30   Baltimore City 240009001661 337 Afya Public Charter School   Regular School Yes Middle 08 08 2021   pk_12_total   105 *                                             112   105                                         112
1319130 1319130 MD     school 2400090 30   Baltimore City 240009001662 345 Joseph C. Briscoe Academy   Special Education School No High 06 12 2021   pk_12_total * 50 *               *                             58   50                                         58
1319158 1319158 MD     school 2400090 30   Baltimore City 240009001682 348 Baltimore Leadership School for Young Women   Regular School Yes High 06 12 2021   pk_12_total * 514 *   *           *                             531   514                                         531
1319171 1319171 MD     school 2400090 30   Baltimore City 240009001675 364 Bluford Drew Jemison STEM Academy West   Regular School No High 06 12 2021   pk_12_total * 220 *                                             226   220                                         226
1319187 1319187 MD     school 2400090 30   Baltimore City 240009001734 371 Lillie May Carroll Jackson School   Regular School Yes Middle 05 08 2021   pk_12_total   306 *                                             309   306                                         309
1319208 1319208 MD     school 2400090 30   Baltimore City 240009001736 375 Baltimore Collegiate School for Boys   Regular School Yes Middle 04 08 2021   pk_12_total   455 *   *       *   *                             466   455                                         466
1319236 1319236 MD     school 2400090 30   Baltimore City 240009001716 384 Creative City Public Charter School   Regular School Yes Elementary KG 05 2021   pk_12_total 27 309 *   * *         17                             358 27 309                 17                       358
1319241 1319241 MD     school 2400090 30   Baltimore City 240009001752 385 Baltimore International Academy West   Regular School Yes Elementary KG 07 2021   pk_12_total * 143 *               *                             150   143                                         150
1319327 1319327 MD     school 2400090 30   Baltimore City 240009001387 430 Augusta Fells Savage Institute of Visual Arts   Regular School No High 09 12 2021   pk_12_total * 463 *   * *         *                             481   463                                         481
1319332 1319332 MD     school 2400090 30   Baltimore City 240009001530 432 Coppin Academy   Regular School Yes High 09 12 2021   pk_12_total * 351 *                                             359   351                                         359
1319337 1319337 MD     school 2400090 30   Baltimore City 240009001531 433 Renaissance Academy   Regular School No High 09 12 2021   pk_12_total * 222 *     *     *   *                             243   222                                         243
1319357 1319357 MD     school 2400090 30   Baltimore City 240009000885 884 Eager Street Academy   Alternative School No High 09 12 2021   pk_12_total * 35 *           *                                 39   35                                         39
1319365 1319365 MD     school 2400027 32   SEED 240002701669 1000 The Seed School of Maryland   Regular School No High 06 12 2021   pk_12_total * 391 *               *                             403   391                                         403
1312855 1312855 MD     school 2400300 9   Dorchester 240030000622 508 South Dorchester School   Regular School No Elementary PK 08 2021   pk_12_total 189 * 10     *     *   11                             219 189   10               11                       219
1316044 1316044 MD     school 2400510 16   Prince George's 240051001648 662 Imagine Lincoln Public Charter   Regular School Yes Elementary KG 08 2021   pk_12_total * 376 10     *         *                             393   376 10                                       393
1317815 1317815 MD     school 2400690 22   Wicomico 240069001308 106 Northwestern Elementary   Regular School No Elementary PK 05 2021   pk_12_total 239 25 10   * *     *   27                             308 239 25 10               27                       308
1318866 1318866 MD     school 2400090 30   Baltimore City 240009000293 242 Northwood Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 514 10   *       *   *                             537   514 10                                       537
1310900 1310900 MD     school 2400120 3   Baltimore County 240012000355 174 Catonsville High   Regular School No High 09 12 2021   pk_12_total 929 443 100   * 233     *   94                             1809 929 443 100     233         94                       1809
1313920 1313920 MD     school 2400420 13   Howard 240042000856 217 Hollifield Station Elementary   Regular School No Elementary KG 05 2021   pk_12_total 172 105 100   * 359     *   26                             768 172 105 100     359         26                       768
1316566 1316566 MD     school 2400510 16   Prince George's 240051001001 1414 Catherine T. Reed Elementary   Regular School No Elementary PK 05 2021   pk_12_total 16 326 100   * 13     *   *                             466 16 326 100     13                                 466
1312798 1312798 MD     school 2400270 8   Charles 240027001727 802 St. Charles High School   Regular School No High 09 12 2021   pk_12_total 154 997 101   11 30     *   96                             1392 154 997 101   11 30         96                       1392
1313132 1313132 MD     school 2400330 10   Frederick 240033001163 918 Oakdale Middle   Regular School No Middle 06 08 2021   pk_12_total 601 72 101   * 70     *   50                             899 601 72 101     70         50                       899
1315320 1315320 MD     school 2400480 15   Montgomery 240048000932 754 Takoma Park Elementary   Regular School No Elementary PK 02 2021   pk_12_total 255 190 101   * 20     *   49                             617 255 190 101     20         49                       617
1316220 1316220 MD     school 2400510 16   Prince George's 240051000988 1011 Bond Mill Elementary   Regular School No Elementary KG 05 2021   pk_12_total 89 224 101   * 39     *   29                             488 89 224 101     39         29                       488
1310383 1310383 MD     school 2400060 2   Anne Arundel 240006000106 3172 Odenton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 177 140 102   * 28     *   70                             519 177 140 102     28         70                       519
1313139 1313139 MD     school 2400330 10   Frederick 240033001165 919 Oakdale Elementary   Regular School No Elementary KG 05 2021   pk_12_total 527 117 102   * 135     *   40                             926 527 117 102     135         40                       926
1313655 1313655 MD     school 2400390 12   Harford 240039000683 373 Bel Air High   Regular School No High 09 12 2021   pk_12_total 1146 121 102   * 119     *   63                             1557 1146 121 102     119         63                       1557
1315349 1315349 MD     school 2400480 15   Montgomery 240048000961 764 Woodlin Elementary   Regular School No Elementary PK 05 2021   pk_12_total 198 130 102     43         38                             511 198 130 102     43         38                       511
1310159 1310159 MD     school 2400060 2   Anne Arundel 240006000079 2132 High Point Elementary   Regular School No Elementary PK 05 2021   pk_12_total 443 55 103   * 13     *   51                             669 443 55 103     13         51                       669
1311076 1311076 MD     school 2400120 3   Baltimore County 240012000448 352 Pikesville Middle   Regular School No Middle 06 08 2021   pk_12_total 157 624 103   * 43     *   32                             967 157 624 103     43         32                       967
1311223 1311223 MD     school 2400120 3   Baltimore County 240012000454 808 Pot Spring Elementary   Regular School No Elementary PK 05 2021   pk_12_total 160 125 103   * 40         17                             446 160 125 103     40         17                       446
1312573 1312573 MD     school 2400270 8   Charles 240027000601 104 Milton M. Somers Middle School   Regular School No Middle 06 08 2021   pk_12_total 386 437 103   * 37     *   83                             1049 386 437 103     37         83                       1049
1315332 1315332 MD     school 2400480 15   Montgomery 240048000821 756 East Silver Spring Elementary   Regular School No Elementary PK 05 2021   pk_12_total 86 252 103     14     *   24                             481 86 252 103     14         24                       481
1318910 1318910 MD     school 2400090 30   Baltimore City 240009000182 247 Cross Country Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 24 563 103   * *     *   *                             700 24 563 103                                       700
1311593 1311593 MD     school 2400120 3   Baltimore County 240012001438 1255 General John Stricker Middle   Regular School No Middle 06 08 2021   pk_12_total 487 152 104   11 16         76                             846 487 152 104   11 16         76                       846
1315042 1315042 MD     school 2400480 15   Montgomery 240048001181 523 Spark M. Matsunaga Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 108 140 104   * 271         37                             663 108 140 104     271         37                       663
1315225 1315225 MD     school 2400480 15   Montgomery 240048001526 606 Cabin John Middle School   Regular School No Middle 06 08 2021   pk_12_total 414 137 104   * 357         64                             1077 414 137 104     357         64                       1077
1316164 1316164 MD     school 2400510 16   Prince George's 240051001180 914 Waldon Woods Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 433 104     *         *                             559   433 104                                       559
1317540 1317540 MD     school 2400660 21   Washington 240066001290 201 Springfield Middle   Regular School No Middle 06 08 2021   pk_12_total 581 90 104   * 14     *   68                             859 581 90 104     14         68                       859
1317553 1317553 MD     school 2400660 21   Washington 240066001295 204 Williamsport High   Regular School No High 09 12 2021   pk_12_total 660 74 104   * 10         52                             901 660 74 104     10         52                       901
1310490 1310490 MD     school 2400060 2   Anne Arundel 240006000133 3382 Southgate Elementary   Regular School No Elementary PK 05 2021   pk_12_total 247 301 105   * 25     *   53                             734 247 301 105     25         53                       734
1314817 1314817 MD     school 2400480 15   Montgomery 240048000785 401 Bethesda Elementary   Regular School No Elementary PK 05 2021   pk_12_total 296 57 105     108         53                             619 296 57 105     108         53                       619
1317977 1317977 MD     school 2400720 23   Worcester 240072001335 310 Stephen Decatur High   Regular School No High 09 12 2021   pk_12_total 1046 121 105   * 25     *   70                             1369 1046 121 105     25         70                       1369
1311888 1311888 MD     school 2400120 3   Baltimore County 240012000370 1557 Deep Creek Middle   Regular School No Middle 06 08 2021   pk_12_total 182 546 106   * *     *   60                             907 182 546 106               60                       907
1314300 1314300 MD     school 2400480 15   Montgomery 240048000864 51 Laytonsville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 138 67 106     29     *   27                             369 138 67 106     29         27                       369
1316034 1316034 MD     school 2400510 16   Prince George's 240051001453 661 Suitland Elementary   Regular School No Elementary PK 06 2021   pk_12_total * 388 106     *     *   *                             503   388 106                                       503
1317123 1317123 MD     school 2400510 16   Prince George's 240051001097 2122 Magnolia Elementary   Regular School No Elementary PK 06 2021   pk_12_total 16 342 106   * 41     *   *                             513 16 342 106     41                                 513
1311503 1311503 MD     school 2400120 3   Baltimore County 240012000446 1171 Perry Hall High   Regular School No High 09 12 2021   pk_12_total 904 659 107   * 256     *   85                             2018 904 659 107     256         85                       2018
1312247 1312247 MD     school 2400210 6   Carroll 240021000553 703 Westminster West Middle   Regular School No Middle 06 08 2021   pk_12_total 671 59 108   * 28     *   33                             904 671 59 108     28         33                       904
1315310 1315310 MD     school 2400480 15   Montgomery 240048090480 747 Dr. Charles R. Drew Elementary   Regular School No Elementary PK 05 2021   pk_12_total 62 211 108   * 62     *   22                             468 62 211 108     62         22                       468
1318605 1318605 MD     school 2400090 30   Baltimore City 240009000183 207 Curtis Bay Elementary   Regular School No Elementary PK 05 2021   pk_12_total 106 187 108               39                             440 106 187 108               39                       440
1310086 1310086 MD     school 2400060 2   Anne Arundel 240006000127 2013 Severna Park High   Regular School No High 09 12 2021   pk_12_total 1525 68 109   * 78     *   95                             1880 1525 68 109     78         95                       1880
1310368 1310368 MD     school 2400060 2   Anne Arundel 240006000137 3152 Van Bokkelen Elementary   Regular School No Elementary PK 05 2021   pk_12_total 15 242 109   * *         12                             381 15 242 109               12                       381
1310890 1310890 MD     school 2400120 3   Baltimore County 240012000411 155 Southwest Academy   Regular School No Middle 06 08 2021   pk_12_total 31 513 109   * 111     *   28                             794 31 513 109     111         28                       794
1313510 1313510 MD     school 2400390 12   Harford 240039001352 184 Magnolia Middle   Regular School No Middle 06 08 2021   pk_12_total 209 405 109   * 14         73                             812 209 405 109     14         73                       812
1316132 1316132 MD     school 2400510 16   Prince George's 240051001170 905 Tayac Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 210 109   * *         *                             336   210 109                                       336
1317376 1317376 MD     school 2400600 18   Saint Mary's 240060001483 805 George Washington Carver Elementary   Regular School No Elementary PK 05 2021   pk_12_total 76 279 109     *     *   48                             519 76 279 109               48                       519
1312366 1312366 MD     school 2400210 6   Carroll 240021000532 1201 Elmer A. Wolfe Elementary   Regular School No Elementary PK 05 2021   pk_12_total 379 * 11   * *         18                             416 379   11               18                       416
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
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
1313409 1313409 MD     school 2400360 11   Garrett 240036000671 3512 Northern Garrett High School   Regular School No High 09 12 2021   pk_12_total 440   11     *         *                             461 440   11                                       461
1316703 1316703 MD     school 2400510 16   Prince George's 240051001706 1522 Imagine Foundations at Morningside PCS   Regular School Yes Elementary KG 08 2021   pk_12_total * 385 11   *           *                             405   385 11                                       405
1317707 1317707 MD     school 2400660 21   Washington 240066001268 1602 Greenbrier Elementary   Regular School No Elementary PK 05 2021   pk_12_total 170 11 11     18         10                             220 170 11 11     18         10                       220
1317849 1317849 MD     school 2400690 22   Wicomico 240069001088 520 Wicomico County Evening High   Alternative School No High 09 12 2021   pk_12_total 24 46 11               *                             86 24 46 11                                       86

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