enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 1,193 ✖

grade ✖

  • pk_12_total · 1,193 ✖
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
1318215 1318215 MD     school 2400090 30   Baltimore City 240009000234 47 Hampstead Hill Academy   Regular School Yes Elementary PK 08 2021   pk_12_total 331 142 325   * 12     *   39                             855 331 142 325     12         39                       855
1319276 1319276 MD     school 2400090 30   Baltimore City 240009000236 413 Achievement Academy at Harbor City High   Alternative School No High 09 12 2021   pk_12_total * 350 20   *                                         372   350 20                                       372
1318169 1318169 MD     school 2400090 30   Baltimore City 240009000239 35 Harlem Park Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total   275 *   *           *                             282   275                                         282
1318616 1318616 MD     school 2400090 30   Baltimore City 240009000241 210 Hazelwood Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 416 30   *           *                             460   416 30                                       460
1318665 1318665 MD     school 2400090 30   Baltimore City 240009000243 215 Highlandtown Elementary/Middle #215   Regular School No Elementary PK 08 2021   pk_12_total 11 68 377     *     *   *                             463 11 68 377                                       463
1318831 1318831 MD     school 2400090 30   Baltimore City 240009000244 237 Highlandtown Elementary/Middle #237   Regular School No Elementary PK 08 2021   pk_12_total 15 115 720     *     *   *                             860 15 115 720                                       860
1318104 1318104 MD     school 2400090 30   Baltimore City 240009000246 21 Hilton Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 313 *                                             328   313                                         328
1318757 1318757 MD     school 2400090 30   Baltimore City 240009000247 229 Holabird Academy   Regular School No Elementary PK 08 2021   pk_12_total 34 187 241   * *         *                             475 34 187 241                                       475
1318054 1318054 MD     school 2400090 30   Baltimore City 240009000253 10 James McHenry Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 24 601 31     *         11                             670 24 601 31               11                       670
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
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
1318746 1318746 MD     school 2400090 30   Baltimore City 240009000257 228 John Ruhrah Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 68 42 730   * *         *                             854 68 42 730                                       854
1318096 1318096 MD     school 2400090 30   Baltimore City 240009000258 16 Johnston Square Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 263 *               *                             273   263                                         273
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
1318073 1318073 MD     school 2400090 30   Baltimore City 240009000264 12 Lakeland Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 37 288 642   * *         10                             984 37 288 642               10                       984
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
1318888 1318888 MD     school 2400090 30   Baltimore City 240009000268 245 Leith Walk Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 950 48   * *     *   *                             1018   950 48                                       1018
1318321 1318321 MD     school 2400090 30   Baltimore City 240009000270 64 Liberty Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 406 16           *   *                             428   406 16                                       428
1318423 1318423 MD     school 2400090 30   Baltimore City 240009000273 88 Wildwood Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 713 15           *   *                             734   713 15                                       734
1318245 1318245 MD     school 2400090 30   Baltimore City 240009000276 53 Margaret Brent Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 27 161 93   *       *   *                             294 27 161 93                                       294
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
1318150 1318150 MD     school 2400090 30   Baltimore City 240009000278 29 Matthew A. Henson Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 257 *   * *         *                             268   257                                         268
1318926 1318926 MD     school 2400090 30   Baltimore City 240009000279 249 Medfield Heights Elementary   Regular School No Elementary PK 05 2021   pk_12_total 132 137 27   * 34     *   31                             363 132 137 27     34         31                       363
1319271 1319271 MD     school 2400090 30   Baltimore City 240009000280 410 Mergenthaler Vocational-Technical High   Career and Technical School No High 09 12 2021   pk_12_total 51 1577 145     *     *   *                             1785 51 1577 145                                       1785
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
1318453 1318453 MD     school 2400090 30   Baltimore City 240009000282 105 Moravia Park Elementary   Regular School No Elementary PK 05 2021   pk_12_total 17 646 26   * 11     *   *                             714 17 646 26     11                                 714
1318692 1318692 MD     school 2400090 30   Baltimore City 240009000284 220 Morrell Park Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 166 146 91   * 14     *   22                             443 166 146 91     14         22                       443
1318332 1318332 MD     school 2400090 30   Baltimore City 240009000285 66 Mount Royal Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 77 660 26   * *     *   *                             781 77 660 26                                       781
1318702 1318702 MD     school 2400090 30   Baltimore City 240009000286 221 The Mount Washington School   Regular School No Elementary KG 08 2021   pk_12_total 142 352 29     12     *   16                             552 142 352 29     12         16                       552
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
1319256 1319256 MD     school 2400090 30   Baltimore City 240009000297 405 Patterson High   Career and Technical School No High 09 12 2021   pk_12_total 80 581 535   * *         *                             1213 80 581 535                                       1213
1319281 1319281 MD     school 2400090 30   Baltimore City 240009000298 414 Paul Laurence Dunbar High   Regular School No High 09 12 2021   pk_12_total 22 826 66   * *     *   *                             928 22 826 66                                       928
1318713 1318713 MD     school 2400090 30   Baltimore City 240009000299 223 Pimlico Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 618 39     *     *   *                             667   618 39                                       667
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
1318790 1318790 MD     school 2400090 30   Baltimore City 240009000306 233 Roland Park Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 511 617 75   * 119     *   72                             1402 511 617 75     119         72                       1402
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
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
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
1318024 1318024 MD     school 2400090 30   Baltimore City 240009000319 4 Steuart Hill Academic Academy   Regular School No Elementary PK 05 2021   pk_12_total 13 163 *     *         *                             187 13 163                                         187
1318084 1318084 MD     school 2400090 30   Baltimore City 240009000320 13 Tench Tilghman Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 319 48               *                             371   319 48                                       371
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
1318388 1318388 MD     school 2400090 30   Baltimore City 240009000323 84 Thomas Johnson Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 354 86 47     *     *   25                             516 354 86 47               25                       516
1318735 1318735 MD     school 2400090 30   Baltimore City 240009000326 226 Violetville Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 90 171 57   * 13     *   23                             358 90 171 57     13         23                       358
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
1318234 1318234 MD     school 2400090 30   Baltimore City 240009000329 51 Waverly Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 544 22   * *     *   *                             589   544 22                                       589
1319266 1319266 MD     school 2400090 30   Baltimore City 240009000330 407 Western High   Regular School No High 09 12 2021   pk_12_total 56 1090 68   * 11     *   *                             1236 56 1090 68     11                                 1236
1318724 1318724 MD     school 2400090 30   Baltimore City 240009000331 225 Westport Academy   Regular School No Elementary PK 08 2021   pk_12_total 11 251 14     *         *                             284 11 251 14                                       284
1318377 1318377 MD     school 2400090 30   Baltimore City 240009000334 83 William Paca Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 213 215   * *     *   *                             445   213 215                                       445
1318142 1318142 MD     school 2400090 30   Baltimore City 240009000335 28 Sandtown-Winchester Achievement Academy   Regular School No Elementary PK 08 2021   pk_12_total * 386 *     *         *                             400   386                                         400
1318995 1318995 MD     school 2400090 30   Baltimore City 240009000336 301 William S. Baer School   Special Education School No Other PK 12 2021   pk_12_total 14 112 20     *                                       148 14 112 20                                       148
1318412 1318412 MD     school 2400090 30   Baltimore City 240009000337 87 Windsor Hills Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 215 13     *     *                                 237   215 13                                       237
1318589 1318589 MD     school 2400090 30   Baltimore City 240009000339 205 Woodhome Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 36 334 55     *     *   *                             443 36 334 55                                       443
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
1318088 1318088 MD     school 2400090 30   Baltimore City 240009000571 15 Stadium School   Regular School No Middle 06 08 2021   pk_12_total * 471 20           *   *                             500   471 20                                       500
1318369 1318369 MD     school 2400090 30   Baltimore City 240009000602 81 North Bend Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 10 446 28   *       *   *                             491 10 446 28                                       491
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
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
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
1319042 1319042 MD     school 2400090 30   Baltimore City 240009001291 323 The Crossroads School   Regular School Yes Middle 06 08 2021   pk_12_total * 119 40               *                             163   119 40                                       163
1319050 1319050 MD     school 2400090 30   Baltimore City 240009001302 325 ConneXions: A Community Based Arts School   Regular School Yes High 06 12 2021   pk_12_total * 506 13               *                             526   506 13                                       526
1319291 1319291 MD     school 2400090 30   Baltimore City 240009001313 416 Digital Harbor High School   Career and Technical School No High 09 12 2021   pk_12_total 77 846 373   * *     *   *                             1315 77 846 373                                       1315
1319296 1319296 MD     school 2400090 30   Baltimore City 240009001331 419 Reginald F. Lewis High   Regular School No High 09 12 2021   pk_12_total 14 520 74   * *     *   *                             615 14 520 74                                       615
1319304 1319304 MD     school 2400090 30   Baltimore City 240009001339 421 National Academy Foundation   Regular School No High 06 12 2021   pk_12_total 21 470 311   * *         *                             805 21 470 311                                       805
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
1318570 1318570 MD     school 2400090 30   Baltimore City 240009001363 203 Maree Garnett Farring Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 139 192 349   * 10     *   13                             706 139 192 349     10         13                       706
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
1319017 1319017 MD     school 2400090 30   Baltimore City 240009001369 314 Sharp-Leadenhall Elementary   Special Education School No Elementary 01 05 2021   pk_12_total * 23                 *                             27   23                                         27
1319317 1319317 MD     school 2400090 30   Baltimore City 240009001381 427 Academy for College and Career Exploration   Regular School No High 06 12 2021   pk_12_total 44 556 99   * *     *   *                             715 44 556 99                                       715
1319322 1319322 MD     school 2400090 30   Baltimore City 240009001385 429 Vivien T. Thomas Medical Arts Academy   Career and Technical School No High 09 12 2021   pk_12_total 15 371 24   *           *                             413 15 371 24                                       413
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
1318953 1318953 MD     school 2400090 30   Baltimore City 240009001390 256 Calvin M. Rodwell Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 753 46   * *         *                             817   753 46                                       817
1319286 1319286 MD     school 2400090 30   Baltimore City 240009001391 415 Baltimore School for the Arts   Regular School No High 09 12 2021   pk_12_total 161 229 27   * *     *   *                             433 161 229 27                                       433
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
1318961 1318961 MD     school 2400090 30   Baltimore City 240009001430 260 Frederick Elementary   Regular School Yes Elementary PK 05 2021   pk_12_total 22 294 18   * *         12                             349 22 294 18               12                       349
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
1319071 1319071 MD     school 2400090 30   Baltimore City 240009001480 327 Patterson Park Public Charter School   Regular School Yes Elementary PK 08 2021   pk_12_total 116 302 301   * *     *   19                             742 116 302 301               19                       742
1319082 1319082 MD     school 2400090 30   Baltimore City 240009001527 328 Southwest Baltimore Charter School   Regular School Yes Elementary PK 08 2021   pk_12_total 27 372 13   * *         13                             431 27 372 13               13                       431
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
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
1319309 1319309 MD     school 2400090 30   Baltimore City 240009001559 422 New Era Academy   Regular School No High 09 12 2021   pk_12_total 14 232 141     *                                       388 14 232 141                                       388
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
1319104 1319104 MD     school 2400090 30   Baltimore City 240009001631 335 Baltimore International Academy   Regular School Yes Elementary KG 08 2021   pk_12_total 36 645 43   * *     *   25                             752 36 645 43               25                       752
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
1319115 1319115 MD     school 2400090 30   Baltimore City 240009001657 336 Baltimore Montessori Public Charter School   Regular School Yes Elementary PK 08 2021   pk_12_total 119 323 16   *           19                             479 119 323 16               19                       479
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
1319122 1319122 MD     school 2400090 30   Baltimore City 240009001663 341 The Reach! Partnership School   Regular School No High 09 12 2021   pk_12_total * 672 14               *                             695   672 14                                       695
1319182 1319182 MD     school 2400090 30   Baltimore City 240009001670 368 Elmer A. Henderson: A Johns Hopkins Partnership   Regular School No Elementary PK 08 2021   pk_12_total * 573 11   * *         *                             592   573 11                                       592
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
1319140 1319140 MD     school 2400090 30   Baltimore City 240009001680 346 City Neighbors Hamilton   Regular School Yes Elementary KG 08 2021   pk_12_total 77 127 11   * *         14                             234 77 127 11               14                       234
1319150 1319150 MD     school 2400090 30   Baltimore City 240009001681 347 KIPP Harmony Academy   Regular School Yes Elementary KG 08 2021   pk_12_total * 1542 21   * *     *   *                             1575   1542 21                                       1575
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
1319198 1319198 MD     school 2400090 30   Baltimore City 240009001689 373 Tunbridge Public Charter School   Regular School Yes Elementary PK 08 2021   pk_12_total 65 372 16   * *     *   15                             475 65 372 16               15                       475
1319213 1319213 MD     school 2400090 30   Baltimore City 240009001690 376 City Neighbors High   Regular School Yes High 09 12 2021   pk_12_total 30 365 23   * *         *                             424 30 365 23                                       424
1319221 1319221 MD     school 2400090 30   Baltimore City 240009001691 377 Green Street Academy   Regular School Yes High 06 12 2021   pk_12_total 15 843 17     *                                       876 15 843 17                                       876
1319202 1319202 MD     school 2400090 30   Baltimore City 240009001693 374 Vanguard Collegiate Middle   Regular School No Middle 06 08 2021   pk_12_total 11 366 18     *     *   *                             408 11 366 18                                       408
1319229 1319229 MD     school 2400090 30   Baltimore City 240009001703 382 Baltimore Design School   Regular School No High 06 12 2021   pk_12_total 19 491 13   * *         *                             529 19 491 13                                       529
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

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