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,691 ✖
Link rowid ▲ state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
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
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
1318539 1318539 MD     school 2400090 30   Baltimore City 240009000148 164 Arundel Elementary   Regular School No Elementary PK 02 2021   pk_12_total * 425 11               *                             445   425 11                                       445
1318534 1318534 MD     school 2400090 30   Baltimore City 240009000171 159 The Historic Cherry Hill Elementary/Middle   Regular School No Middle 03 08 2021   pk_12_total * 629 31   *           *                             674   629 31                                       674
1318527 1318527 MD     school 2400090 30   Baltimore City 240009000158 150 Mary Ann Winterling Elementary at Bentalou   Regular School No Elementary PK 05 2021   pk_12_total   179                 *                             185   179                                         185
1318519 1318519 MD     school 2400090 30   Baltimore City 240009000145 145 Alexander Hamilton Elementary   Regular School No Elementary PK 05 2021   pk_12_total   154                 *                             156   154                                         156
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
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
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
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
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
1318472 1318472 MD     school 2400090 30   Baltimore City 240009000154 124 Bay-Brook Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 71 335 204     *     *   10                             622 71 335 204               10                       622
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
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
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
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
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
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
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
1318398 1318398 MD     school 2400090 30   Baltimore City 240009000204 85 Fort Worthington Elementary/Middle   Regular School No Elementary KG 08 2021   pk_12_total 10 656 55   * *         *                             736 10 656 55                                       736
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
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
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
1318358 1318358 MD     school 2400090 30   Baltimore City 240009000205 76 Francis Scott Key Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 229 237 74   * *     *   22                             575 229 237 74               22                       575
1318347 1318347 MD     school 2400090 30   Baltimore City 240009000164 75 Calverton Elementary/Middle   Regular School No Middle 03 08 2021   pk_12_total * 326 17     *         *                             359   326 17                                       359
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
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
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
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
1318302 1318302 MD     school 2400090 30   Baltimore City 240009000192 62 Edgecombe Circle Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 278 11     *     *   *                             300   278 11                                       300
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
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
1318278 1318278 MD     school 2400090 30   Baltimore City 240009000149 58 Dr. Nathan A. Pitts-Ashburton Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 323 17   * *         *                             349   323 17                                       349
1318267 1318267 MD     school 2400090 30   Baltimore City 240009000233 55 Hampden Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 204 193 20   * 12     *   26                             459 204 193 20     12         26                       459
1318256 1318256 MD     school 2400090 30   Baltimore City 240009000152 54 Barclay Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 345 64   * *     *   *                             425   345 64                                       425
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
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
1318223 1318223 MD     school 2400090 30   Baltimore City 240009000143 50 Abbottston Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 334 18               *                             365   334 18                                       365
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
1318204 1318204 MD     school 2400090 30   Baltimore City 240009000201 45 Federal Hill Preparatory Academy   Regular School No Elementary PK 05 2021   pk_12_total 102 192 26     *     *   16                             345 102 192 26               16                       345
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
1318185 1318185 MD     school 2400090 30   Baltimore City 240009000184 39 Dallas F. Nicholas, Sr., Elementary   Regular School No Elementary PK 05 2021   pk_12_total   190 16   * *     *   *                             217   190 16                                       217
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
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
1318158 1318158 MD     school 2400090 30   Baltimore City 240009000153 34 Charles Carroll Barrister Elementary   Regular School No Elementary PK 05 2021   pk_12_total 52 131 143   * *                                       336 52 131 143                                       336
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
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
1318131 1318131 MD     school 2400090 30   Baltimore City 240009000180 27 Commodore John Rodgers Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total 54 496 303   * *         *                             871 54 496 303                                       871
1318120 1318120 MD     school 2400090 30   Baltimore City 240009000215 23 Wolfe Street Academy   Regular School Yes Elementary PK 05 2021   pk_12_total 16 30 214   * *                                       265 16 30 214                                       265
1318112 1318112 MD     school 2400090 30   Baltimore City 240009000220 22 George Washington Elementary   Regular School No Elementary PK 05 2021   pk_12_total 10 153 13           *   *                             184 10 153 13                                       184
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
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
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
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
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
1318062 1318062 MD     school 2400090 30   Baltimore City 240009000196 11 Eutaw-Marshburn Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 243 *   *                                         248   243                                         248
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
1318043 1318043 MD     school 2400090 30   Baltimore City 240009000175 8 City Springs Elementary/Middle   Regular School Yes Elementary PK 08 2021   pk_12_total 10 594 24   *           *                             633 10 594 24                                       633
1318032 1318032 MD     school 2400090 30   Baltimore City 240009000169 7 Cecil Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 341 *           *   *                             354   341                                         354
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
1318016 1318016 MD     school 2400720 23   Worcester 240072001327 1001 Ocean City Elementary   Regular School No Elementary PK 04 2021   pk_12_total 400 17 72     12         28                             529 400 17 72     12         28                       529
1318009 1318009 MD     school 2400720 23   Worcester 240072001325 901 Buckingham Elementary   Regular School No Elementary PK 04 2021   pk_12_total 254 130 57     *         47                             494 254 130 57               47                       494
1318002 1318002 MD     school 2400720 23   Worcester 240072001326 401 Cedar Chapel Special School   Special Education School No Other PK 12 2021   pk_12_total 27 16 *     *         *                             50 27 16                                         50
1317987 1317987 MD     school 2400720 23   Worcester 240072001498 312 Showell Elementary   Regular School No Elementary PK 04 2021   pk_12_total 530 19 43   * 16         40                             649 530 19 43     16         40                       649
1317980 1317980 MD     school 2400720 23   Worcester 240072001323 311 Berlin Intermediate   Regular School No Middle 05 06 2021   pk_12_total 458 59 69     17         55                             658 458 59 69     17         55                       658
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
1317972 1317972 MD     school 2400720 23   Worcester 240072000880 308 Stephen Decatur Middle   Regular School No Middle 07 08 2021   pk_12_total 484 59 75   * 13         58                             691 484 59 75     13         58                       691
1317969 1317969 MD     school 2400720 23   Worcester 240072001333 208 Snow Hill Middle   Regular School No Middle 04 08 2021   pk_12_total 232 116 18   * *         35                             407 232 116 18               35                       407
1317963 1317963 MD     school 2400720 23   Worcester 240072001334 207 Snow Hill High   Regular School No High 09 12 2021   pk_12_total 229 76 11   * *         18                             337 229 76 11               18                       337
1317958 1317958 MD     school 2400720 23   Worcester 240072001332 205 Snow Hill Elementary   Regular School No Elementary PK 03 2021   pk_12_total 194 84 22   * *         28                             332 194 84 22               28                       332
1317952 1317952 MD     school 2400720 23   Worcester 240072001329 108 Pocomoke Middle   Regular School No Middle 04 08 2021   pk_12_total 160 217 20     10         23                             430 160 217 20     10         23                       430
1317946 1317946 MD     school 2400720 23   Worcester 240072001330 107 Pocomoke High   Regular School No High 09 12 2021   pk_12_total 151 152 25     *         17                             349 151 152 25               17                       349
1317941 1317941 MD     school 2400720 23   Worcester 240072001328 102 Pocomoke Elementary   Regular School No Elementary PK 03 2021   pk_12_total 173 178 41   * *         21                             416 173 178 41               21                       416
1317935 1317935 MD     school 2400690 22   Wicomico 240069001303 1602 Fruitland Intermediate   Regular School No Elementary 03 05 2021   pk_12_total 196 108 55   * 23         34                             417 196 108 55     23         34                       417
1317931 1317931 MD     school 2400690 22   Wicomico 240069001151 1601 Fruitland Primary   Regular School No Elementary PK 02 2021   pk_12_total 181 102 31   * 13     *   48                             378 181 102 31     13         48                       378
1317926 1317926 MD     school 2400690 22   Wicomico 240069001149 1502 Westside Intermediate   Regular School No Elementary 02 05 2021   pk_12_total 229 67 27   * *         34                             363 229 67 27               34                       363
1317921 1317921 MD     school 2400690 22   Wicomico 240069001318 1501 Westside Primary   Regular School No Elementary PK 01 2021   pk_12_total 109 24 22   * *         19                             181 109 24 22               19                       181
1317917 1317917 MD     school 2400690 22   Wicomico 240069001322 1404 Willards Elementary   Regular School No Elementary PK 03 2021   pk_12_total 209 * 23   * *     *   22                             260 209   23               22                       260
1317911 1317911 MD     school 2400690 22   Wicomico 240069001309 1309 Parkside High   Regular School No High 09 12 2021   pk_12_total 577 368 67   * 33         64                             1113 577 368 67     33         64                       1113
1317906 1317906 MD     school 2400690 22   Wicomico 240069001299 1308 Bennett Middle   Regular School No Middle 06 08 2021   pk_12_total 380 351 137   * 34     *   68                             980 380 351 137     34         68                       980
1317902 1317902 MD     school 2400690 22   Wicomico 240069001305 1307 James M. Bennett High   Regular School No High 09 12 2021   pk_12_total 575 475 155   * 68     *   77                             1362 575 475 155     68         77                       1362
1317897 1317897 MD     school 2400690 22   Wicomico 240069001314 1306 Prince Street School   Regular School No Elementary PK 05 2021   pk_12_total 107 396 151   * 16         55                             731 107 396 151     16         55                       731
1317889 1317889 MD     school 2400690 22   Wicomico 240069001311 1305 Pinehurst Elementary   Regular School No Elementary PK 05 2021   pk_12_total 114 249 60   * 10     *   52                             489 114 249 60     10         52                       489
1317881 1317881 MD     school 2400690 22   Wicomico 240069001300 1103 Delmar Elementary   Regular School No Elementary PK 04 2021   pk_12_total 505 158 68   * 33         78                             843 505 158 68     33         78                       843
1317874 1317874 MD     school 2400690 22   Wicomico 240069001145 910 Salisbury Middle   Regular School No Middle 06 08 2021   pk_12_total 222 475 83   * 41     *   69                             897 222 475 83     41         69                       897
1317870 1317870 MD     school 2400690 22   Wicomico 240069001317 909 West Salisbury   Regular School No Elementary PK 02 2021   pk_12_total 50 169 50   * 12         23                             307 50 169 50     12         23                       307
1317865 1317865 MD     school 2400690 22   Wicomico 240069001315 907 Charles H. Chipman Elementary   Regular School No Elementary PK 01 2021   pk_12_total 33 142 17     *         23                             217 33 142 17               23                       217
1317861 1317861 MD     school 2400690 22   Wicomico 240069001310 906 Pemberton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 104 297 34   * 23     *   56                             517 104 297 34     23         56                       517
1317853 1317853 MD     school 2400690 22   Wicomico 240069001307 905 North Salisbury Elementary   Regular School No Elementary 03 05 2021   pk_12_total 153 172 68   * 43     *   31                             471 153 172 68     43         31                       471
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
1317844 1317844 MD     school 2400690 22   Wicomico 240069001304 515 Glen Avenue School   Regular School No Elementary 02 05 2021   pk_12_total 75 241 52   * *     *   30                             409 75 241 52               30                       409
1317839 1317839 MD     school 2400690 22   Wicomico 240069001298 514 Beaver Run School   Regular School No Elementary PK 02 2021   pk_12_total 125 263 97     *         56                             546 125 263 97               56                       546
1317834 1317834 MD     school 2400690 22   Wicomico 240069001320 513 Wicomico High   Regular School No High 09 12 2021   pk_12_total 306 592 178   * 32     *   77                             1190 306 592 178     32         77                       1190
1317829 1317829 MD     school 2400690 22   Wicomico 240069001301 512 East Salisbury Elementary   Regular School No Elementary 03 05 2021   pk_12_total 66 203 81   * *         46                             399 66 203 81               46                       399
1317825 1317825 MD     school 2400690 22   Wicomico 240069001319 510 Wicomico Middle   Regular School No Middle 06 08 2021   pk_12_total 189 372 155   * 17     *   86                             829 189 372 155     17         86                       829
1317821 1317821 MD     school 2400690 22   Wicomico 240069001312 406 Pittsville Elementary & Middle   Regular School No Middle 04 08 2021   pk_12_total 322 * 23   * *         29                             387 322   23               29                       387
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
1317807 1317807 MD     school 2400690 22   Wicomico 240069001306 102 Mardela Middle & High   Regular School No High 06 12 2021   pk_12_total 515 74 26   * *         53                             674 515 74 26               53                       674
1317799 1317799 MD     school 2400660 21   Washington 240066001266 2701 Fountaindale Elementary   Regular School No Elementary PK 05 2021   pk_12_total 194 67 39     22         37                             359 194 67 39     22         37                       359
1317791 1317791 MD     school 2400660 21   Washington 240066001271 2602 Hickory Elementary   Regular School No Elementary PK 05 2021   pk_12_total 124 39 110     *         23                             297 124 39 110               23                       297

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