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)

grade ✖

  • pk_12_total · 2,591 ✖
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
1317783 1317783 MD     school 2400660 21   Washington 240066001273 2601 Lincolnshire Elementary   Regular School No Elementary PK 05 2021   pk_12_total 293 60 57     *         51                             466 293 60 57               51                       466
1317775 1317775 MD     school 2400660 21   Washington 240066001289 2505 Marshall Street School   Special Education School No Other PK 12 2021   pk_12_total 24 * *     *         *                             41 24                                           41
1317760 1317760 MD     school 2400660 21   Washington 240066001283 2503 Salem Avenue Elementary   Regular School No Elementary PK 05 2021   pk_12_total 261 166 125   * *     *   130                             687 261 166 125               130                       687
1317752 1317752 MD     school 2400660 21   Washington 240066001293 2501 Western Heights Middle   Regular School No Middle 06 08 2021   pk_12_total 440 234 149     17     *   109                             950 440 234 149     17         109                       950
1317748 1317748 MD     school 2400660 21   Washington 240066001276 2102 Northern Middle   Regular School No Middle 06 08 2021   pk_12_total 391 171 113   * 21     *   109                             809 391 171 113     21         109                       809
1317744 1317744 MD     school 2400660 21   Washington 240066001275 2101 North Hagerstown High   Regular School No High 09 12 2021   pk_12_total 653 278 205   * 54     *   150                             1343 653 278 205     54         150                       1343
1317739 1317739 MD     school 2400660 21   Washington 240066001265 2002 Fountain Rock Elementary   Regular School No Elementary PK 05 2021   pk_12_total 219 * 21     *         *                             258 219   21                                       258
1317731 1317731 MD     school 2400660 21   Washington 240066001281 1805 Potomac Heights Elementary   Regular School No Elementary PK 05 2021   pk_12_total 159 57 52   * *         51                             323 159 57 52               51                       323
1317723 1317723 MD     school 2400660 21   Washington 240066001278 1802 Pangborn Elementary   Regular School No Elementary PK 05 2021   pk_12_total 243 177 158     16         96                             690 243 177 158     16         96                       690
1317715 1317715 MD     school 2400660 21   Washington 240066001253 1701 Bester Elementary   Regular School No Elementary PK 05 2021   pk_12_total 176 131 85   * *         94                             491 176 131 85               94                       491
1317707 1317707 MD     school 2400660 21   Washington 240066001268 1602 Greenbrier Elementary   Regular School No Elementary PK 05 2021   pk_12_total 170 11 11     18         10                             220 170 11 11     18         10                       220
1317699 1317699 MD     school 2400660 21   Washington 240066001258 1401 Cascade Elementary   Regular School No Elementary PK 05 2021   pk_12_total 121 * *   * *         *                             130 121                                           130
1317691 1317691 MD     school 2400660 21   Washington 240066001274 1301 Maugansville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 394 97 115     22         56                             684 394 97 115     22         56                       684
1317683 1317683 MD     school 2400660 21   Washington 240066001280 1101 Pleasant Valley Elementary   Regular School No Elementary PK 05 2021   pk_12_total 183 * *   * *         *                             204 183                                           204
1317675 1317675 MD     school 2400660 21   Washington 240066000418 1002 Eastern Elementary   Regular School No Elementary 03 05 2021   pk_12_total 141 118 81   * *         68                             418 141 118 81               68                       418
1317671 1317671 MD     school 2400660 21   Washington 240066001277 903 Old Forge Elementary   Regular School No Elementary PK 05 2021   pk_12_total 265 * 17               11                             298 265   17               11                       298
1317663 1317663 MD     school 2400660 21   Washington 240066000752 902 Paramount Elementary   Regular School No Elementary PK 05 2021   pk_12_total 221 60 54     27         32                             394 221 60 54     27         32                       394
1317655 1317655 MD     school 2400660 21   Washington 240066001484 705 Washington County Job Development Center   Special Education School No High 12 12 2021   pk_12_total 18 11 *               *                             34 18 11                                         34
1317653 1317653 MD     school 2400660 21   Washington 240066001287 704 Smithsburg Middle   Regular School No Middle 06 08 2021   pk_12_total 422 42 50   * 10         40                             565 422 42 50     10         40                       565
1317649 1317649 MD     school 2400660 21   Washington 240066001286 702 Smithsburg Elementary   Regular School No Elementary PK 05 2021   pk_12_total 270 10 17   *           22                             320 270 10 17               22                       320
1317641 1317641 MD     school 2400660 21   Washington 240066001285 701 Smithsburg High   Regular School No High 09 12 2021   pk_12_total 591 48 44     10     *   39                             734 591 48 44     10         39                       734
1317636 1317636 MD     school 2400660 21   Washington 240066001254 603 Boonsboro Elementary   Regular School No Elementary PK 05 2021   pk_12_total 438 17 22     *     *   10                             491 438 17 22               10                       491
1317628 1317628 MD     school 2400660 21   Washington 240066001255 602 Boonsboro Middle   Regular School No Middle 06 08 2021   pk_12_total 541 24 28   * 14         23                             631 541 24 28     14         23                       631
1317624 1317624 MD     school 2400660 21   Washington 240066001256 601 Boonsboro High   Regular School No High 09 12 2021   pk_12_total 761 15 40   * 18         37                             873 761 15 40     18         37                       873
1317619 1317619 MD     school 2400660 21   Washington 240066001269 502 Hancock Elementary   Regular School No Elementary PK 05 2021   pk_12_total 205 * *     *         *                             213 205                                           213
1317611 1317611 MD     school 2400660 21   Washington 240066001270 501 Hancock Middle Senior High   Regular School No High 06 12 2021   pk_12_total 226   *     *         *                             235 226                                           235
1317603 1317603 MD     school 2400660 21   Washington 240066001260 403 Clear Spring High   Regular School No High 09 12 2021   pk_12_total 424 * 22     *         14                             470 424   22               14                       470
1317598 1317598 MD     school 2400660 21   Washington 240066001259 402 Clear Spring Elementary   Regular School No Elementary PK 05 2021   pk_12_total 335 * *               *                             348 335                                           348
1317590 1317590 MD     school 2400660 21   Washington 240066001261 401 Clear Spring Middle   Regular School No Middle 06 08 2021   pk_12_total 307 * 12     *         13                             340 307   12               13                       340
1317586 1317586 MD     school 2400660 21   Washington 240066001707 328 Ruth Ann Monroe Primary   Regular School No Elementary PK 02 2021   pk_12_total 176 178 99   * 22         79                             556 176 178 99     22         79                       556
1317581 1317581 MD     school 2400660 21   Washington 240066001667 325 Rockland Woods Elementary   Regular School No Elementary PK 05 2021   pk_12_total 323 112 91   * 19     *   55                             604 323 112 91     19         55                       604
1317573 1317573 MD     school 2400660 21   Washington 240066000308 305 Washington County Technical High   Career and Technical School No High 11 12 2021   pk_12_total 409 33 73   * *     *   28                             554 409 33 73               28                       554
1317570 1317570 MD     school 2400660 21   Washington 240066001263 304 E. Russell Hicks Middle   Regular School No Middle 06 08 2021   pk_12_total 395 215 157   * 31         91                             890 395 215 157     31         91                       890
1317566 1317566 MD     school 2400660 21   Washington 240066001264 302 Emma K. Doub Elementary   Regular School No Elementary PK 05 2021   pk_12_total 208 45 42   * *         43                             350 208 45 42               43                       350
1317558 1317558 MD     school 2400660 21   Washington 240066001288 301 South Hagerstown High   Regular School No High 09 12 2021   pk_12_total 582 351 212   * 47     *   187                             1381 582 351 212     47         187                       1381
1317553 1317553 MD     school 2400660 21   Washington 240066001295 204 Williamsport High   Regular School No High 09 12 2021   pk_12_total 660 74 104   * 10         52                             901 660 74 104     10         52                       901
1317548 1317548 MD     school 2400660 21   Washington 240066001294 202 Williamsport Elementary   Regular School No Elementary PK 05 2021   pk_12_total 371 37 41   * 11     *   53                             515 371 37 41     11         53                       515
1317540 1317540 MD     school 2400660 21   Washington 240066001290 201 Springfield Middle   Regular School No Middle 06 08 2021   pk_12_total 581 90 104   * 14     *   68                             859 581 90 104     14         68                       859
1317536 1317536 MD     school 2400660 21   Washington 240066001740 190 Jonathan Hager Elementary   Regular School No Elementary PK 05 2021   pk_12_total 129 114 56   * *     *   57                             372 129 114 56               57                       372
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
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
1317515 1317515 MD     school 2400630 20   Talbot 240063001250 501 Tilghman Elementary   Regular School No Elementary PK 05 2021   pk_12_total 81   *               *                             86 81                                           86
1317507 1317507 MD     school 2400630 20   Talbot 240063001241 401 Chapel District Elementary   Regular School No Elementary PK 05 2021   pk_12_total 278 * 25     *         20                             335 278   25               20                       335
1317499 1317499 MD     school 2400630 20   Talbot 240063001252 302 White Marsh Elementary   Regular School No Elementary PK 05 2021   pk_12_total 184 39 28   * *         28                             286 184 39 28               28                       286
1317491 1317491 MD     school 2400630 20   Talbot 240063001247 204 St. Michaels Elementary   Regular School No Elementary PK 05 2021   pk_12_total 217 54 32     *         20                             327 217 54 32               20                       327
1317483 1317483 MD     school 2400630 20   Talbot 240063001248 202 St. Michaels Middle/High School   Regular School No High 06 12 2021   pk_12_total 320 44 32     *         19                             418 320 44 32               19                       418
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
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
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
1317458 1317458 MD     school 2400570 19   Somerset 240057001202 1401 Deal Island School   Regular School No Elementary PK 05 2021   pk_12_total 98 * *     *         *                             121 98                                           121
1317450 1317450 MD     school 2400570 19   Somerset 240057001377 1303 Somerset 6/7 Intermediate School   Regular School No Middle 06 07 2021   pk_12_total 147 193 48   * *         29                             424 147 193 48               29                       424
1317447 1317447 MD     school 2400570 19   Somerset 240057001203 1003 Ewell School   Regular School No Middle 01 07 2021   pk_12_total *                                                 *                                              
1317442 1317442 MD     school 2400570 19   Somerset 240057001535 705 Carter G Woodson Elementary   Regular School No Elementary PK 05 2021   pk_12_total 246 156 62     *         33                             499 246 156 62               33                       499
1317434 1317434 MD     school 2400570 19   Somerset 240057001201 702 Crisfield Academy and High School   Regular School No High 08 12 2021   pk_12_total 229 109 45     *         17                             401 229 109 45               17                       401
1317428 1317428 MD     school 2400570 19   Somerset 240057001742 108 Princess Anne Elementary School   Regular School No Elementary PK 01 2021   pk_12_total 62 207 34   * *         20                             325 62 207 34               20                       325
1317424 1317424 MD     school 2400570 19   Somerset 240057001743 107 Greenwood Elementary School   Regular School No Elementary 02 05 2021   pk_12_total 80 307 41     *         19                             454 80 307 41               19                       454
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
1317413 1317413 MD     school 2400600 18   Saint Mary's 240060001639 813 Chesapeake Charter School   Regular School Yes Elementary KG 08 2021   pk_12_total 346 40 18     18         55                             477 346 40 18     18         55                       477
1317403 1317403 MD     school 2400600 18   Saint Mary's 240060001226 810 Greenview Knolls Elementary   Regular School No Elementary PK 05 2021   pk_12_total 132 171 45   * 12         58                             419 132 171 45     12         58                       419
1317395 1317395 MD     school 2400600 18   Saint Mary's 240060001234 808 Park Hall Elementary   Regular School No Elementary PK 05 2021   pk_12_total 187 216 50   * 13     *   77                             547 187 216 50     13         77                       547
1317387 1317387 MD     school 2400600 18   Saint Mary's 240060001220 807 Esperanza Middle   Regular School No Middle 06 08 2021   pk_12_total 459 193 80     38     *   85                             858 459 193 80     38         85                       858
1317383 1317383 MD     school 2400600 18   Saint Mary's 240060001239 806 Town Creek Elementary   Regular School No Elementary KG 05 2021   pk_12_total 128 26 17     *         24                             200 128 26 17               24                       200
1317376 1317376 MD     school 2400600 18   Saint Mary's 240060001483 805 George Washington Carver Elementary   Regular School No Elementary PK 05 2021   pk_12_total 76 279 109     *     *   48                             519 76 279 109               48                       519
1317368 1317368 MD     school 2400600 18   Saint Mary's 240060001230 804 Lexington Park Elementary   Regular School No Elementary PK 05 2021   pk_12_total 130 189 61   * 15     *   47                             445 130 189 61     15         47                       445
1317360 1317360 MD     school 2400600 18   Saint Mary's 240060001221 803 Green Holly Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 163 140 32   * 16     *   40                             393 163 140 32     16         40                       393
1317352 1317352 MD     school 2400600 18   Saint Mary's 240060001224 801 Great Mills High   Regular School No High 09 12 2021   pk_12_total 634 622 219   * 81     *   147                             1713 634 622 219     81         147                       1713
1317347 1317347 MD     school 2400600 18   Saint Mary's 240060001219 702 Dynard Elementary   Regular School No Elementary PK 05 2021   pk_12_total 338 31 13     *         38                             421 338 31 13               38                       421
1317339 1317339 MD     school 2400600 18   Saint Mary's 240060001685 606 Evergreen Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 483 81 78   * 39     *   58                             741 483 81 78     39         58                       741
1317331 1317331 MD     school 2400600 18   Saint Mary's 240060001227 604 Hollywood Elementary   Regular School No Elementary PK 05 2021   pk_12_total 299 47 27   * 14         50                             439 299 47 27     14         50                       439
1317323 1317323 MD     school 2400600 18   Saint Mary's 240060001233 602 Oakville Elementary   Regular School No Elementary PK 05 2021   pk_12_total 216 24 *   *           22                             269 216 24                 22                       269
1317315 1317315 MD     school 2400600 18   Saint Mary's 240060001232 504 Mechanicsville Elementary   Regular School No Elementary KG 05 2021   pk_12_total 232 10 13   * *     *   20                             280 232 10 13               20                       280
1317308 1317308 MD     school 2400600 18   Saint Mary's 240060001240 503 White Marsh Elementary   Regular School No Elementary KG 05 2021   pk_12_total 170 20 12     *         15                             219 170 20 12               15                       219
1317301 1317301 MD     school 2400600 18   Saint Mary's 240060001399 501 Lettie Marshall Dent Elem   Regular School No Elementary PK 05 2021   pk_12_total 468 22 19   * *         25                             541 468 22 19               25                       541
1317293 1317293 MD     school 2400600 18   Saint Mary's 240060001231 404 Margaret Brent Middle   Regular School No Middle 06 08 2021   pk_12_total 807 72 48   * *     *   65                             1002 807 72 48               65                       1002
1317289 1317289 MD     school 2400600 18   Saint Mary's 240060001732 308 Captain Walter Francis Duke Elementary   Regular School No Elementary PK 05 2021   pk_12_total 408 39 22     12     *   45                             527 408 39 22     12         45                       527
1317281 1317281 MD     school 2400600 18   Saint Mary's 240060001356 306 Leonardtown High   Regular School No High 09 12 2021   pk_12_total 1366 162 117   * 58     *   138                             1846 1366 162 117     58         138                       1846
1317276 1317276 MD     school 2400600 18   Saint Mary's 240060001229 305 Leonardtown Middle   Regular School No Middle 06 08 2021   pk_12_total 802 84 53   * 20     *   67                             1029 802 84 53     20         67                       1029
1317272 1317272 MD     school 2400600 18   Saint Mary's 240060001218 303 Chopticon High   Regular School No High 09 12 2021   pk_12_total 1375 134 74   * 14     *   85                             1689 1375 134 74     14         85                       1689
1317267 1317267 MD     school 2400600 18   Saint Mary's 240060001216 302 Benjamin Banneker Elementary   Regular School No Elementary PK 05 2021   pk_12_total 413 68 18     *         32                             536 413 68 18               32                       536
1317259 1317259 MD     school 2400600 18   Saint Mary's 240060001228 301 Leonardtown Elementary   Regular School No Elementary PK 05 2021   pk_12_total 310 63 24     12         27                             436 310 63 24     12         27                       436
1317251 1317251 MD     school 2400600 18   Saint Mary's 240060001235 201 Piney Point Elementary   Regular School No Elementary PK 05 2021   pk_12_total 300 36 14   * *         51                             406 300 36 14               51                       406
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
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
1317231 1317231 MD     school 2400540 17   Queen Anne's 240054001193 503 Grasonville Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 295 41 55     *         30                             426 295 41 55               30                       426
1317223 1317223 MD     school 2400540 17   Queen Anne's 240054001644 407 Matapeake Middle School   Regular School No Middle 06 08 2021   pk_12_total 309 14 24   * *         29                             381 309 14 24               29                       381
1317219 1317219 MD     school 2400540 17   Queen Anne's 240054001557 406 Matapeake Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 358 * 22     *         24                             415 358   22               24                       415
1317211 1317211 MD     school 2400540 17   Queen Anne's 240054001076 405 Kent Island High School   Regular School No High 09 12 2021   pk_12_total 952 56 78     23     *   62                             1174 952 56 78     23         62                       1174
1317206 1317206 MD     school 2400540 17   Queen Anne's 240054001196 404 Stevensville Middle School   Regular School No Middle 06 08 2021   pk_12_total 411 34 43   * *         25                             522 411 34 43               25                       522
1317202 1317202 MD     school 2400540 17   Queen Anne's 240054000202 403 Bayside Elementary School   Regular School No Elementary 03 05 2021   pk_12_total 290 20 42     *         33                             393 290 20 42               33                       393
1317198 1317198 MD     school 2400540 17   Queen Anne's 240054001194 402 Kent Island Elementary School   Regular School No Elementary PK 02 2021   pk_12_total 302 * 30   * *         22                             370 302   30               22                       370
1317193 1317193 MD     school 2400540 17   Queen Anne's 240054001191 308 Centreville Elementary School   Regular School No Elementary PK 02 2021   pk_12_total 389 40 54   * *         30                             517 389 40 54               30                       517
1317188 1317188 MD     school 2400540 17   Queen Anne's 240054001190 303 Centreville Middle School   Regular School No Middle 06 08 2021   pk_12_total 443 31 45   * *         26                             549 443 31 45               26                       549
1317184 1317184 MD     school 2400540 17   Queen Anne's 240054001070 302 Kennard Elementary School   Regular School No Elementary 03 05 2021   pk_12_total 352 33 28     *         31                             446 352 33 28               31                       446
1317180 1317180 MD     school 2400540 17   Queen Anne's 240054001195 301 Queen Anne's County High School   Regular School No High 09 12 2021   pk_12_total 938 89 111   * 11         59                             1210 938 89 111     11         59                       1210
1317175 1317175 MD     school 2400540 17   Queen Anne's 240054001192 202 Church Hill Elementary School   Regular School No Elementary PK 04 2021   pk_12_total 177 18 35               22                             252 177 18 35               22                       252
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
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
1317156 1317156 MD     school 2400510 16   Prince George's 240051001476 2300 Prekindergarten Offsites   Regular School No Prekindergarten PK PK 2021   pk_12_total * * *                                             *                                              
1317154 1317154 MD     school 2400510 16   Prince George's 240051001067 2220 Community Based Classrooms   Alternative School No High 12 12 2021   pk_12_total   37 27     *         *                             68   37 27                                       68
1317152 1317152 MD     school 2400510 16   Prince George's 240051001755 2218 Career and Technical Education Evening High   Career and Technical School No High 11 12 2021   pk_12_total   * 21   *           *                             27     21                                       27

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