enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 1,398 ✖

grade ✖

  • pk_12_total · 1,398 ✖
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
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
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
1246807 1246807 MD     school 2400090 30   Baltimore City 240009000150 480 Baltimore City College   Regular School No High 09 12 2020   pk_12_total 254 970 126   * 24     *   21                             1402 254 970 126     24         21                       1402
1246802 1246802 MD     school 2400090 30   Baltimore City 240009000168 454 Carver Vocational-Technical High   Career and Technical School No High 09 12 2020   pk_12_total * 859 13   * *         *                             885   859 13                                       885
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
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
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
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
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
1246772 1246772 MD     school 2400090 30   Baltimore City 240009001381 427 Academy for College and Career Exploration   Regular School No High 06 12 2020   pk_12_total 29 500 74   * *     *   *                             616 29 500 74                                       616
1246764 1246764 MD     school 2400090 30   Baltimore City 240009001559 422 New Era Academy   Regular School No High 09 12 2020   pk_12_total * 193 124     *         *                             328   193 124                                       328
1246759 1246759 MD     school 2400090 30   Baltimore City 240009001339 421 National Academy Foundation   Regular School No High 06 12 2020   pk_12_total 19 511 298     *                                       830 19 511 298                                       830
1246751 1246751 MD     school 2400090 30   Baltimore City 240009001331 419 Reginald F. Lewis High   Regular School No High 09 12 2020   pk_12_total 11 446 81   * *     *   *                             546 11 446 81                                       546
1246746 1246746 MD     school 2400090 30   Baltimore City 240009001313 416 Digital Harbor High School   Career and Technical School No High 09 12 2020   pk_12_total 80 715 346   * 13     *   *                             1162 80 715 346     13                                 1162
1246741 1246741 MD     school 2400090 30   Baltimore City 240009001391 415 Baltimore School for the Arts   Regular School No High 09 12 2020   pk_12_total 176 218 23   * 10     *   *                             438 176 218 23     10                                 438
1246736 1246736 MD     school 2400090 30   Baltimore City 240009000298 414 Paul Laurence Dunbar High   Regular School No High 09 12 2020   pk_12_total 15 788 52   * *         *                             868 15 788 52                                       868
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
1246726 1246726 MD     school 2400090 30   Baltimore City 240009000280 410 Mergenthaler Vocational-Technical High   Career and Technical School No High 09 12 2020   pk_12_total 44 1555 108   * *         *                             1719 44 1555 108                                       1719
1246721 1246721 MD     school 2400090 30   Baltimore City 240009000330 407 Western High   Regular School No High 09 12 2020   pk_12_total 57 1016 48   * 10     *   *                             1142 57 1016 48     10                                 1142
1246716 1246716 MD     school 2400090 30   Baltimore City 240009000203 406 Forest Park High   Regular School No High 09 12 2020   pk_12_total * 542 119   * *     *   *                             676   542 119                                       676
1246711 1246711 MD     school 2400090 30   Baltimore City 240009000297 405 Patterson High   Career and Technical School No High 09 12 2020   pk_12_total 76 549 524   * *         10                             1174 76 549 524               10                       1174
1246706 1246706 MD     school 2400090 30   Baltimore City 240009000151 403 Baltimore Polytechnic Institute   Regular School No High 09 12 2020   pk_12_total 258 1030 162   * 104     *   21                             1584 258 1030 162     104         21                       1584
1246701 1246701 MD     school 2400090 30   Baltimore City 240009000194 400 Edmondson-Westside High   Career and Technical School No High 09 12 2020   pk_12_total 10 826 13   * *     *                                 853 10 826 13                                       853
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
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
1246686 1246686 MD     school 2400090 30   Baltimore City 240009001703 382 Baltimore Design School   Regular School No High 06 12 2020   pk_12_total 18 477 12   * *         *                             511 18 477 12                                       511
1246678 1246678 MD     school 2400090 30   Baltimore City 240009001691 377 Green Street Academy   Regular School Yes High 06 12 2020   pk_12_total 20 815 16     *                                       852 20 815 16                                       852
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
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
1246659 1246659 MD     school 2400090 30   Baltimore City 240009001693 374 Vanguard Collegiate Middle   Regular School No Middle 06 08 2020   pk_12_total * 331 19     *     11   *                             378   331 19           11                           378
1246655 1246655 MD     school 2400090 30   Baltimore City 240009001689 373 Tunbridge Public Charter School   Regular School Yes Elementary PK 08 2020   pk_12_total 65 378 10   * *     *   11                             471 65 378 10               11                       471
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
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
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
1246621 1246621 MD     school 2400090 30   Baltimore City 240009001735 362 Bard High School Early College   Regular School No High 09 12 2020   pk_12_total 43 384 14     *     *   *                             446 43 384 14                                       446
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
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
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
1246590 1246590 MD     school 2400090 30   Baltimore City 240009001680 346 City Neighbors Hamilton   Regular School Yes Elementary KG 08 2020   pk_12_total 77 126 11   * *         16                             234 77 126 11               16                       234
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
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
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
1246564 1246564 MD     school 2400090 30   Baltimore City 240009001657 336 Baltimore Montessori Public Charter School   Regular School Yes Elementary PK 08 2020   pk_12_total 123 306 10   * *         13                             456 123 306 10               13                       456
1246553 1246553 MD     school 2400090 30   Baltimore City 240009001631 335 Baltimore International Academy   Regular School Yes Elementary KG 08 2020   pk_12_total 27 641 40     *     *   24                             736 27 641 40               24                       736
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
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
1246531 1246531 MD     school 2400090 30   Baltimore City 240009001527 328 Southwest Baltimore Charter School   Regular School Yes Elementary PK 08 2020   pk_12_total 29 363 22   * *         11                             432 29 363 22               11                       432
1246520 1246520 MD     school 2400090 30   Baltimore City 240009001480 327 Patterson Park Public Charter School   Regular School Yes Elementary PK 08 2020   pk_12_total 111 319 282   * *     *   17                             733 111 319 282               17                       733
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
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
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
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
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
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
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
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
1246444 1246444 MD     school 2400090 30   Baltimore City 240009000336 301 William S. Baer School   Special Education School No Other PK 12 2020   pk_12_total 15 126 21     *                                       167 15 126 21                                       167
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
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
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
1246402 1246402 MD     school 2400090 30   Baltimore City 240009001390 256 Calvin M. Rodwell Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 681 35   * *         *                             729   681 35                                       729
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
1246380 1246380 MD     school 2400090 30   Baltimore City 240009000163 251 Callaway Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 282 14     *         *                             303   282 14                                       303
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
1246364 1246364 MD     school 2400090 30   Baltimore City 240009000279 249 Medfield Heights Elementary   Regular School No Elementary PK 05 2020   pk_12_total 127 143 21   * 37     *   22                             352 127 143 21     37         22                       352
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
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
1246337 1246337 MD     school 2400090 30   Baltimore City 240009000155 246 Beechfield Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 17 581 29   * *     *   *                             635 17 581 29                                       635
1246326 1246326 MD     school 2400090 30   Baltimore City 240009000268 245 Leith Walk Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 945 60     *     *   *                             1023   945 60                                       1023
1246315 1246315 MD     school 2400090 30   Baltimore City 240009000147 243 Armistead Gardens Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 182 80 513   * 10         21                             809 182 80 513     10         21                       809
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
1246296 1246296 MD     school 2400090 30   Baltimore City 240009000199 241 Fallstaff Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 242 266   * *     *   *                             526   242 266                                       526
1246285 1246285 MD     school 2400090 30   Baltimore City 240009000224 240 Graceland Park/O'Donnel Heights Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 33 111 439     *         *                             587 33 111 439                                       587
1246274 1246274 MD     school 2400090 30   Baltimore City 240009000157 239 Benjamin Franklin High School at Masonville Cove   Regular School No High 09 12 2020   pk_12_total 130 212 194   * *     *   *                             547 130 212 194                                       547
1246269 1246269 MD     school 2400090 30   Baltimore City 240009000244 237 Highlandtown Elementary/Middle #237   Regular School No Elementary PK 08 2020   pk_12_total 18 122 732   * *         *                             882 18 122 732                                       882
1246258 1246258 MD     school 2400090 30   Baltimore City 240009000231 236 Hamilton Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 93 679 58     11     *   22                             864 93 679 58     11         22                       864
1246247 1246247 MD     school 2400090 30   Baltimore City 240009000222 235 Glenmount Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 14 634 35   * *     *   *                             697 14 634 35                                       697
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
1246228 1246228 MD     school 2400090 30   Baltimore City 240009000306 233 Roland Park Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 576 599 69   * 136     *   62                             1453 576 599 69     136         62                       1453
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
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
1246197 1246197 MD     school 2400090 30   Baltimore City 240009000247 229 Holabird Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 45 204 239   * *     *   11                             504 45 204 239               11                       504
1246186 1246186 MD     school 2400090 30   Baltimore City 240009000257 228 John Ruhrah Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 62 35 741   * *         *                             851 62 35 741                                       851
1246175 1246175 MD     school 2400090 30   Baltimore City 240009000326 226 Violetville Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 103 187 62   * 13     *   18                             386 103 187 62     13         18                       386
1246164 1246164 MD     school 2400090 30   Baltimore City 240009000331 225 Westport Academy   Regular School No Elementary PK 08 2020   pk_12_total * 253 13     *         *                             281   253 13                                       281
1246153 1246153 MD     school 2400090 30   Baltimore City 240009000299 223 Pimlico Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 579 29     *     *   *                             621   579 29                                       621
1246142 1246142 MD     school 2400090 30   Baltimore City 240009000286 221 The Mount Washington School   Regular School No Elementary KG 08 2020   pk_12_total 150 373 24     14     *   24                             587 150 373 24     14         24                       587
1246132 1246132 MD     school 2400090 30   Baltimore City 240009000284 220 Morrell Park Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 181 156 90   * 20     *   20                             471 181 156 90     20         20                       471
1246121 1246121 MD     school 2400090 30   Baltimore City 240009000340 219 Yorkwood Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 392 13   * *         *                             412   392 13                                       412
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
1246105 1246105 MD     school 2400090 30   Baltimore City 240009000243 215 Highlandtown Elementary/Middle #215   Regular School No Elementary PK 08 2020   pk_12_total * 73 387     *     *   *                             476   73 387                                       476
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
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
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
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
1246056 1246056 MD     school 2400090 30   Baltimore City 240009000241 210 Hazelwood Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 437 29     *         *                             477   437 29                                       477
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
1246034 1246034 MD     school 2400090 30   Baltimore City 240009000210 206 Furley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 21 437 26   * *     *                                 495 21 437 26                                       495
1246026 1246026 MD     school 2400090 30   Baltimore City 240009000339 205 Woodhome Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 36 314 51     *     *   *                             415 36 314 51                                       415
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

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