enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pk_12_total · 2,791 ✖
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
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
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
1319352 1319352 MD     school 2400090 30   Baltimore City 240009000150 480 Baltimore City College   Regular School No High 09 12 2021   pk_12_total 256 972 146   * 25     *   32                             1439 256 972 146     25         32                       1439
1319347 1319347 MD     school 2400090 30   Baltimore City 240009000168 454 Carver Vocational-Technical High   Career and Technical School No High 09 12 2021   pk_12_total 15 942 24   * *         *                             985 15 942 24                                       985
1319342 1319342 MD     school 2400090 30   Baltimore City 240009000209 450 Frederick Douglass High   Regular School No High 09 12 2021   pk_12_total 13 687 55     *         *                             759 13 687 55                                       759
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1319261 1319261 MD     school 2400090 30   Baltimore City 240009000203 406 Forest Park High   Regular School No High 09 12 2021   pk_12_total 11 577 133     *     *   *                             726 11 577 133                                       726
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
1319251 1319251 MD     school 2400090 30   Baltimore City 240009000151 403 Baltimore Polytechnic Institute   Regular School No High 09 12 2021   pk_12_total 279 993 200   * 109     *   30                             1619 279 993 200     109         30                       1619
1319246 1319246 MD     school 2400090 30   Baltimore City 240009000194 400 Edmondson-Westside High   Career and Technical School No High 09 12 2021   pk_12_total 11 826 24   * *     *   *                             867 11 826 24                                       867
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
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
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
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
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
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
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
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
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
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
1319163 1319163 MD     school 2400090 30   Baltimore City 240009001735 362 Bard High School Early College   Regular School No High 09 12 2021   pk_12_total 43 352 20     *     *   *                             421 43 352 20                                       421
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1318942 1318942 MD     school 2400090 30   Baltimore City 240009000163 251 Callaway Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 276 14   * *         *                             300   276 14                                       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
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
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
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
1318899 1318899 MD     school 2400090 30   Baltimore City 240009000155 246 Beechfield Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 26 578 30   * *     *   *                             643 26 578 30                                       643
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
1318877 1318877 MD     school 2400090 30   Baltimore City 240009000147 243 Armistead Gardens Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 154 75 518   * *         26                             780 154 75 518               26                       780
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
1318858 1318858 MD     school 2400090 30   Baltimore City 240009000199 241 Fallstaff Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 10 234 259     *     *   *                             510 10 234 259                                       510
1318847 1318847 MD     school 2400090 30   Baltimore City 240009000224 240 Graceland Park/O'Donnell Heights Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 35 109 459     *         *                             608 35 109 459                                       608
1318836 1318836 MD     school 2400090 30   Baltimore City 240009000157 239 Benjamin Franklin High School at Masonville Cove   Regular School No High 09 12 2021   pk_12_total 149 243 232   * *     *   *                             638 149 243 232                                       638
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
1318820 1318820 MD     school 2400090 30   Baltimore City 240009000231 236 Hamilton Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 93 673 50   * 10     *   26                             854 93 673 50     10         26                       854
1318809 1318809 MD     school 2400090 30   Baltimore City 240009000222 235 Glenmount Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 13 592 35     *         *                             652 13 592 35                                       652
1318798 1318798 MD     school 2400090 30   Baltimore City 240009000146 234 Arlington Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 313 84               *                             405   313 84                                       405
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
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
1318768 1318768 MD     school 2400090 30   Baltimore City 240009000161 231 The Belair-Edison School   Regular School Yes Elementary PK 08 2021   pk_12_total 12 881 12   *           20                             927 12 881 12               20                       927
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
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
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
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
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
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
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
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
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
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
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
1318643 1318643 MD     school 2400090 30   Baltimore City 240009000223 213 Govans Elementary   Regular School Yes Elementary PK 05 2021   pk_12_total * 338 14               *                             357   338 14                                       357
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
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
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
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
1318597 1318597 MD     school 2400090 30   Baltimore City 240009000210 206 Furley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 13 411 25   * *                                       457 13 411 25                                       457
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
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
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
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

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