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_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 1,393 ✖

grade ✖

  • pk_12_total · 1,393 ✖
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1317520 1317520 MD     school 2400660 21   Washington 240066001674 40 Barbara Ingram School for the Arts   Regular School No High 09 12 2021   pk_12_total 240 35 24     14         20                             333 240 35 24     14         20                       333
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
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
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
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
1310749 1310749 MD     school 2400120 3   Baltimore County 240012001756 51 Northwest EDLP at Milford Mill Academy   Alternative School No High 10 12 2021   pk_12_total   *                                               *                                              
1314300 1314300 MD     school 2400480 15   Montgomery 240048000864 51 Laytonsville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 138 67 106     29     *   27                             369 138 67 106     29         27                       369
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
1310752 1310752 MD     school 2400120 3   Baltimore County 240012001751 52 Southwest EDLP at Woodlawn High School   Alternative School No High 11 12 2021   pk_12_total * * *                                             *                                              
1310755 1310755 MD     school 2400120 3   Baltimore County 240012001754 53 Northeast EDLP at Parkville High School   Alternative School No High 11 12 2021   pk_12_total * * *                                             15                                             15
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
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
1310758 1310758 MD     school 2400120 3   Baltimore County 240012001759 55 Southeast EDLP at Dundalk High School   Alternative School No High 10 12 2021   pk_12_total * * *                                             *                                              
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
1310760 1310760 MD     school 2400120 3   Baltimore County 240012001760 56 Central EDLP at Loch Raven High School   Alternative School No High 12 12 2021   pk_12_total *                                                 *                                              
1310765 1310765 MD     school 2400120 3   Baltimore County 240012000935 58 Home Assignments-Secondary   Alternative School No High 08 12 2021   pk_12_total * *                                               12                                             12
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
1318286 1318286 MD     school 2400090 30   Baltimore City 240009000229 60 Gwynns Falls Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 284 *                                             286   284                                         286
1318294 1318294 MD     school 2400090 30   Baltimore City 240009000256 61 Dorothy I. Height Elementary   Regular School No Elementary PK 05 2021   pk_12_total * 324 *   *                                         339   324                                         339
1310768 1310768 MD     school 2400120 3   Baltimore County 240012000012 62 Campfield Early Childhood Center   Regular School No Elementary PK KG 2021   pk_12_total 24 235 36   * 22         15                             333 24 235 36     22         15                       333
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
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
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
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
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
1310773 1310773 MD     school 2400120 3   Baltimore County 240012000436 69 Catonsville Center for Alternative Studies   Alternative School No High 09 12 2021   pk_12_total * 41 *     *         *                             51   41                                         51
1310776 1310776 MD     school 2400120 3   Baltimore County 240012000777 70 Meadowood Education Center   Alternative School No Middle 07 08 2021   pk_12_total * 12 *               *                             15   12                                         15
1310783 1310783 MD     school 2400120 3   Baltimore County 240012000831 72 Rosedale Center   Alternative School No High 07 12 2021   pk_12_total * 17                 *                             25   17                                         25
1310790 1310790 MD     school 2400120 3   Baltimore County 240012001649 75 Crossroads Center   Alternative School No High 07 12 2021   pk_12_total 63 84 *   * *         12                             169 63 84                 12                       169
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
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
1310795 1310795 MD     school 2400120 3   Baltimore County 240012001711 77 BCDC Educational Center   Alternative School No High 09 12 2021   pk_12_total * 19 *                                             31   19                                         31
1313781 1313781 MD     school 2400420 13   Howard 240042001189 80 Homewood School   Alternative School No High 07 12 2021   pk_12_total 36 64 12     *         *                             120 36 64 12                                       120
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
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
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
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
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
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
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
1318434 1318434 MD     school 2400090 30   Baltimore City 240009000208 95 Franklin Square Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 316 *   * *         *                             336   316                                         336
1318445 1318445 MD     school 2400090 30   Baltimore City 240009000179 97 Collington Square Elementary/Middle   Regular School No Elementary PK 08 2021   pk_12_total * 308 *   * *     *   *                             326   308                                         326
1314308 1314308 MD     school 2400480 15   Montgomery 240048001494 100 Clopper Mill Elementary   Regular School No Elementary PK 05 2021   pk_12_total 35 161 215   * 44         21                             478 35 161 215     44         21                       478
1310803 1310803 MD     school 2400120 3   Baltimore County 240012000353 101 Catonsville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 301 94 50     140     *   52                             638 301 94 50     140         52                       638
1311920 1311920 MD     school 2400150 4   Calvert 240015000504 101 Patuxent Appeal Elementary Campus   Regular School No Elementary PK 05 2021   pk_12_total 394 118 52     *     *   99                             667 394 118 52               99                       667
1313789 1313789 MD     school 2400420 13   Howard 240042000728 101 Elkridge Elementary   Regular School No Elementary PK 05 2021   pk_12_total 295 244 56   * 167     *   55                             819 295 244 56     167         55                       819
1314316 1314316 MD     school 2400480 15   Montgomery 240048000804 101 Clarksburg Elementary   Regular School No Elementary PK 05 2021   pk_12_total 90 190 115   * 242     *   51                             690 90 190 115     242         51                       690
1317161 1317161 MD     school 2400540 17   Queen Anne's 240054001198 101 Sudlersville Middle School   Regular School No Middle 05 08 2021   pk_12_total 303 30 77   * *         27                             443 303 30 77               27                       443
1317235 1317235 MD     school 2400600 18   Saint Mary's 240060001237 101 Spring Ridge Middle   Regular School No Middle 06 08 2021   pk_12_total 417 366 128   * 33     *   118                             1067 417 366 128     33         118                       1067
1317463 1317463 MD     school 2400630 20   Talbot 240063001242 101 Easton High   Regular School No High 09 12 2021   pk_12_total 655 160 263   * 29     *   61                             1170 655 160 263     29         61                       1170
1317528 1317528 MD     school 2400660 21   Washington 240066001284 101 Sharpsburg Elementary   Regular School No Elementary PK 05 2021   pk_12_total 296 * *               *                             308 296                                           308
1310811 1310811 MD     school 2400120 3   Baltimore County 240012000936 102 Westchester Elementary   Regular School No Elementary PK 05 2021   pk_12_total 415 71 55   * 93         31                             668 415 71 55     93         31                       668
1314324 1314324 MD     school 2400480 15   Montgomery 240048000843 102 Germantown Elementary   Regular School No Elementary PK 05 2021   pk_12_total 47 110 75   * 50     *   16                             301 47 110 75     50         16                       301
1315666 1315666 MD     school 2400510 16   Prince George's 240051001059 102 High Point High   Regular School No High 09 12 2021   pk_12_total 50 449 2042   * 71     *   12                             2634 50 449 2042     71         12                       2634
1317419 1317419 MD     school 2400570 19   Somerset 240057001213 102 Washington Academy and High School   Regular School No High 08 12 2021   pk_12_total 191 308 43     *     *   37                             589 191 308 43               37                       589
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
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
1310819 1310819 MD     school 2400120 3   Baltimore County 240012000495 103 Westowne Elementary   Regular School No Elementary PK 05 2021   pk_12_total 226 241 50   * 87     *   50                             659 226 241 50     87         50                       659
1312128 1312128 MD     school 2400210 6   Carroll 240021000548 103 Taneytown Elementary   Regular School No Elementary PK 05 2021   pk_12_total 298 20 34   * *     *   14                             374 298 20 34               14                       374
1313797 1313797 MD     school 2400420 13   Howard 240042090448 103 Deep Run Elementary   Regular School No Elementary PK 05 2021   pk_12_total 137 100 320   * 87         31                             680 137 100 320     87         31                       680
1310827 1310827 MD     school 2400120 3   Baltimore County 240012000382 104 Edmondson Heights Elementary   Regular School No Elementary PK 05 2021   pk_12_total 40 336 71   * 28     *   16                             499 40 336 71     28         16                       499
1312392 1312392 MD     school 2400240 7   Cecil 240024000562 104 Cecilton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 207 16 43   *           15                             282 207 16 43               15                       282
1312573 1312573 MD     school 2400270 8   Charles 240027000601 104 Milton M. Somers Middle School   Regular School No Middle 06 08 2021   pk_12_total 386 437 103   * 37     *   83                             1049 386 437 103     37         83                       1049
1313801 1313801 MD     school 2400420 13   Howard 240042090477 104 Mayfield Woods Middle   Regular School No Middle 06 08 2021   pk_12_total 191 218 226   * 117     *   37                             795 191 218 226     117         37                       795
1314329 1314329 MD     school 2400480 15   Montgomery 240048000918 104 Seneca Valley High   Regular School No High 09 12 2021   pk_12_total 213 616 569   * 168     *   83                             1652 213 616 569     168         83                       1652
1315677 1315677 MD     school 2400510 16   Prince George's 240051000978 104 Beltsville Academy   Regular School No Elementary PK 08 2021   pk_12_total 65 187 820   * 51         15                             1143 65 187 820     51         15                       1143
1317243 1317243 MD     school 2400600 18   Saint Mary's 240060001236 104 Ridge Elementary   Regular School No Elementary PK 05 2021   pk_12_total 154 27 14   *           31                             227 154 27 14               31                       227
1317471 1317471 MD     school 2400630 20   Talbot 240063001244 104 Easton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 304 217 424     33         70                             1048 304 217 424     33         70                       1048
1310835 1310835 MD     school 2400120 3   Baltimore County 240012000410 105 Johnnycake Elementary   Regular School No Elementary PK 05 2021   pk_12_total 39 270 140   * 53     *   22                             531 39 270 140     53         22                       531
1312132 1312132 MD     school 2400210 6   Carroll 240021000543 105 Northwest Middle   Regular School No Middle 06 08 2021   pk_12_total 534 26 30   * *         46                             645 534 26 30               46                       645
1312581 1312581 MD     school 2400270 8   Charles 240027000609 105 Walter J. Mitchell Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 377 105 55   * 13     *   59                             613 377 105 55     13         59                       613
1313809 1313809 MD     school 2400420 13   Howard 240042000396 105 Rockburn Elementary   Regular School No Elementary PK 05 2021   pk_12_total 277 91 36   * 168         35                             611 277 91 36     168         35                       611
1314267 1314267 MD     school 2400450 14   Kent 240045001695 105 Galena Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 187 30 61               18                             296 187 30 61               18                       296
1314333 1314333 MD     school 2400480 15   Montgomery 240048000903 105 Ridgeview Middle   Regular School No Middle 06 08 2021   pk_12_total 288 116 261   * 89         34                             792 288 116 261     89         34                       792
1315685 1315685 MD     school 2400510 16   Prince George's 240051000995 105 Calverton Elementary   Regular School No Elementary PK 05 2021   pk_12_total 15 241 507   * 38     *   *                             811 15 241 507     38                                 811
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
1312586 1312586 MD     school 2400270 8   Charles 240027000596 106 La Plata High School   Regular School No High 09 12 2021   pk_12_total 703 247 73   * 38     *   107                             1174 703 247 73     38         107                       1174
1313813 1313813 MD     school 2400420 13   Howard 240042000633 106 Elkridge Landing Middle   Regular School No Middle 06 08 2021   pk_12_total 287 196 49   * 121     *   54                             710 287 196 49     121         54                       710
1314341 1314341 MD     school 2400480 15   Montgomery 240048000834 106 Fox Chapel Elementary   Regular School No Elementary PK 05 2021   pk_12_total 63 137 266   * 92     *   27                             589 63 137 266     92         27                       589
1317168 1317168 MD     school 2400540 17   Queen Anne's 240054001197 106 Sudlersville Elementary School   Regular School No Elementary PK 04 2021   pk_12_total 150 14 116               17                             297 150 14 116               17                       297
1317475 1317475 MD     school 2400630 20   Talbot 240063001243 106 Easton Middle   Regular School No Middle 06 08 2021   pk_12_total 424 160 207     19         44                             854 424 160 207     19         44                       854

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