enrollments

Data source: Big Local News · About: Big Local

9,615 rows where state = "MD" and year = 2020 sorted by hispanic_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 9,471 ✖
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
1237235 1237235 MD     school 2400030 1   Allegany 240003000015 405 Fort Hill High   Regular School No High 09 12 2020   pk_12_total 578 38 10     *         44                             672 578 38 10               44                       672
1241025 1241025 MD     school 2400390 12   Harford 240039000684 316 Churchville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 326 11 10   *           22                             370 326 11 10               22                       370
1244122 1244122 MD     school 2400510 16   Prince George's 240051001706 1522 Imagine Foundations at Morningside PCS   Regular School Yes Elementary KG 08 2020   pk_12_total * 407 10   * *         *                             427   407 10                                       427
1244745 1244745 MD     school 2400600 18   Saint Mary's 240060001233 602 Oakville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 240 24 10     *         23                             299 240 24 10               23                       299
1245239 1245239 MD     school 2400690 22   Wicomico 240069001308 106 Northwestern Elementary   Regular School No Elementary PK 05 2020   pk_12_total 256 26 10   * *         35                             334 256 26 10               35                       334
1245273 1245273 MD     school 2400690 22   Wicomico 240069001088 520 Wicomico County Evening High   Alternative School No High 09 12 2020   pk_12_total 38 55 10     *         *                             107 38 55 10                                       107
1245536 1245536 MD     school 2400090 30   Baltimore City 240009000220 22 George Washington Elementary   Regular School No Elementary PK 05 2020   pk_12_total 12 160 10   *       *   *                             192 12 160 10                                       192
1245601 1245601 MD     school 2400090 30   Baltimore City 240009001153 37 Harford Heights Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 417 10               *                             431   417 10                                       431
1245718 1245718 MD     school 2400090 30   Baltimore City 240009000256 61 Dorothy I. Height Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 352 10   * *                                       375   352 10                                       375
1245985 1245985 MD     school 2400090 30   Baltimore City 240009001343 178 Excel Academy at Francis M. Wood High   Alternative School No High 08 12 2020   pk_12_total * 620 10   *           *                             642   620 10                                       642
1246564 1246564 MD     school 2400090 30   Baltimore City 240009001657 336 Baltimore Montessori Public Charter School   Regular School Yes Elementary PK 08 2020   pk_12_total 123 306 10   * *         13                             456 123 306 10               13                       456
1246655 1246655 MD     school 2400090 30   Baltimore City 240009001689 373 Tunbridge Public Charter School   Regular School Yes Elementary PK 08 2020   pk_12_total 65 378 10   * *     *   11                             471 65 378 10               11                       471
1238885 1238885 MD     school 2400120 3   Baltimore County 240012000413 1104 Kingsville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 287 * 11     10     *   11                             326 287   11     10         11                       326
1239281 1239281 MD     school 2400120 3   Baltimore County 240012000429 1520 Middleborough Elementary   Regular School No Elementary PK 05 2020   pk_12_total 226 84 11   * *         22                             349 226 84 11               22                       349
1239818 1239818 MD     school 2400210 6   Carroll 240021000532 1201 Elmer A. Wolfe Elementary   Regular School No Elementary PK 05 2020   pk_12_total 400 * 11   * *         18                             437 400   11               18                       437
1241132 1241132 MD     school 2400390 12   Harford 240039000703 391 John Archer School   Special Education School No Other PK 12 2020   pk_12_total 64 36 11     *         *                             123 64 36 11                                       123
1245702 1245702 MD     school 2400090 30   Baltimore City 240009000149 58 Dr. Nathan A. Pitts-Ashburton Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total   343 11     *         *                             359   343 11                                       359
1245930 1245930 MD     school 2400090 30   Baltimore City 240009000328 134 Walter P. Carter Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 376 11   *           *                             395   376 11                                       395
1246538 1246538 MD     school 2400090 30   Baltimore City 240009001571 332 The Green School of Baltimore   Regular School Yes Elementary KG 05 2020   pk_12_total 57 74 11           *   18                             161 57 74 11               18                       161
1246590 1246590 MD     school 2400090 30   Baltimore City 240009001680 346 City Neighbors Hamilton   Regular School Yes Elementary KG 08 2020   pk_12_total 77 126 11   * *         16                             234 77 126 11               16                       234
1246821 1246821 MD     school 2400027 32   SEED 240002701669 1000 The Seed School of Maryland   Regular School No High 06 12 2020   pk_12_total * 383 11               *                             401   383 11                                       401
1237275 1237275 MD     school 2400030 1   Allegany 240003000010 701 Cresaptown Elementary   Regular School No Elementary PK 05 2020   pk_12_total 284 * 12     *     *   16                             320 284   12               16                       320
1238931 1238931 MD     school 2400120 3   Baltimore County 240012000397 1111 Gunpowder Elementary   Regular School No Elementary KG 05 2020   pk_12_total 342 88 12   * 67     *   26                             538 342 88 12     67         26                       538
1239963 1239963 MD     school 2400240 7   Cecil 240024090468 515 Elk Neck Elementary   Regular School No Elementary PK 05 2020   pk_12_total 399 * 12     *         25                             443 399   12               25                       443
1240736 1240736 MD     school 2400330 10   Frederick 240033000647 2404 Rock Creek   Special Education School No Other PK 12 2020   pk_12_total 43 13 12     *         *                             74 43 13 12                                       74
1240861 1240861 MD     school 2400360 11   Garrett 240036000674 3709 Southern Garrett High School   Regular School No High 09 12 2020   pk_12_total 670 * 12     *         15                             701 670   12               15                       701
1241169 1241169 MD     school 2400390 12   Harford 240039000687 522 Dublin Elementary   Regular School No Elementary PK 05 2020   pk_12_total 199 * 12               16                             230 199   12               16                       230
1243527 1243527 MD     school 2400510 16   Prince George's 240051001384 723 C. Elizabeth Rieg Regional Center   Special Education School No Other KG 12 2020   pk_12_total 13 88 12     *                                       115 13 88 12                                       115
1243915 1243915 MD     school 2400510 16   Prince George's 240051001217 1346 Lake Arbor Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 526 12   * *         15                             559   526 12               15                       559
1244574 1244574 MD     school 2400510 16   Prince George's 240051001755 2218 Career and Technical Education Evening High   Career and Technical School No Secondary 11 11 2020   pk_12_total   * 12   *           *                             15     12                                       15
1245745 1245745 MD     school 2400090 30   Baltimore City 240009000270 64 Liberty Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 470 12           *   *                             488   470 12                                       488
1245974 1245974 MD     school 2400090 30   Baltimore City 240009000148 164 Arundel Elementary   Regular School No Elementary PK 02 2020   pk_12_total * 502 12               *                             523   502 12                                       523
1246206 1246206 MD     school 2400090 30   Baltimore City 240009000161 231 The Belair-Edison School   Regular School Yes Elementary PK 06 2020   pk_12_total 10 795 12   *           11                             831 10 795 12               11                       831
1246217 1246217 MD     school 2400090 30   Baltimore City 240009000322 232 Thomas Jefferson Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total * 436 12   *                                         457   436 12                                       457
1246567 1246567 MD     school 2400090 30   Baltimore City 240009001661 337 Afya Public Charter School   Regular School Yes Middle 07 08 2020   pk_12_total   215 12               *                             228   215 12                                       228
1246686 1246686 MD     school 2400090 30   Baltimore City 240009001703 382 Baltimore Design School   Regular School No High 06 12 2020   pk_12_total 18 477 12   * *         *                             511 18 477 12                                       511
1238634 1238634 MD     school 2400120 3   Baltimore County 240012000473 701 Seventh District Elementary   Regular School No Elementary PK 05 2020   pk_12_total 364 * 13   * *         13                             404 364   13               13                       404
1238871 1238871 MD     school 2400120 3   Baltimore County 240012000352 1001 Carroll Manor Elementary   Regular School No Elementary KG 05 2020   pk_12_total 346 * 13     *         18                             389 346   13               18                       389
1239056 1239056 MD     school 2400120 3   Baltimore County 240012000341 1302 Arbutus Elementary   Regular School No Elementary PK 05 2020   pk_12_total 201 24 13   * 138     *   25                             404 201 24 13     138         25                       404
1245096 1245096 MD     school 2400660 21   Washington 240066001277 903 Old Forge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 299 10 13     *         12                             335 299 10 13               12                       335
1245448 1245448 MD     school 2400090 30   Baltimore City 240009000319 4 Steuart Hill Academic Academy   Regular School No Elementary PK 05 2020   pk_12_total 16 219 13     *         *                             250 16 219 13                                       250
1246121 1246121 MD     school 2400090 30   Baltimore City 240009000340 219 Yorkwood Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 392 13   * *         *                             412   392 13                                       412
1246164 1246164 MD     school 2400090 30   Baltimore City 240009000331 225 Westport Academy   Regular School No Elementary PK 08 2020   pk_12_total * 253 13     *         *                             281   253 13                                       281
1246701 1246701 MD     school 2400090 30   Baltimore City 240009000194 400 Edmondson-Westside High   Career and Technical School No High 09 12 2020   pk_12_total 10 826 13   * *     *                                 853 10 826 13                                       853
1246802 1246802 MD     school 2400090 30   Baltimore City 240009000168 454 Carver Vocational-Technical High   Career and Technical School No High 09 12 2020   pk_12_total * 859 13   * *         *                             885   859 13                                       885
1238646 1238646 MD     school 2400120 3   Baltimore County 240012000476 801 Sparks Elementary   Regular School No Elementary KG 05 2020   pk_12_total 424 16 14   * 37     *   15                             509 424 16 14     37         15                       509
1239611 1239611 MD     school 2400210 6   Carroll 240021000537 406 Mechanicsville Elementary   Regular School No Elementary PK 05 2020   pk_12_total 412 17 14     10     *   27                             483 412 17 14     10         27                       483
1240008 1240008 MD     school 2400240 7   Cecil 240024000566 801 Conowingo Elementary   Regular School No Elementary PK 05 2020   pk_12_total 427 10 14   *           11                             464 427 10 14               11                       464
1240067 1240067 MD     school 2400270 8   Charles 240027000610 501 Dr. Thomas L. Higdon Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 313 60 14     *         33                             426 313 60 14               33                       426
1241139 1241139 MD     school 2400390 12   Harford 240039000702 436 Jarrettsville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 408 * 14     *     *   18                             450 408   14               18                       450
1241154 1241154 MD     school 2400390 12   Harford 240039090476 447 North Bend Elementary   Regular School No Elementary PK 05 2020   pk_12_total 365 * 14     *         17                             402 365   14               17                       402
1241226 1241226 MD     school 2400420 13   Howard 240042001189 80 Homewood School   Alternative School No High 06 12 2020   pk_12_total 30 70 14   * *         *                             122 30 70 14                                       122
1241522 1241522 MD     school 2400420 13   Howard 240042001415 522 Cedar Lane Special Center   Special Education School No Other PK 12 2020   pk_12_total 33 47 14   * 18         *                             117 33 47 14     18                                 117
1243153 1243153 MD     school 2400510 16   Prince George's 240051000414 203 Judith P. Hoyer Montessori   Regular School No Elementary PK 08 2020   pk_12_total 33 312 14   * 10     *   *                             375 33 312 14     10                                 375
1243383 1243383 MD     school 2400510 16   Prince George's 240051001684 638 Benjamin D. Foulois Academy   Regular School No Elementary KG 08 2020   pk_12_total * 502 14   * *     *   12                             538   502 14               12                       538
1243393 1243393 MD     school 2400510 16   Prince George's 240051001554 639 Maya Angelou French Immersion   Regular School No Elementary KG 08 2020   pk_12_total * 436 14     10         *                             476   436 14     10                                 476
1244723 1244723 MD     school 2400600 18   Saint Mary's 240060001399 501 Lettie Marshall Dent Elem   Regular School No Elementary PK 05 2020   pk_12_total 511 21 14   * *         27                             583 511 21 14               27                       583
1244805 1244805 MD     school 2400600 18   Saint Mary's 240060001239 806 Town Creek Elementary   Regular School No Elementary KG 05 2020   pk_12_total 142 29 14   * *         23                             216 142 29 14               23                       216
1245478 1245478 MD     school 2400090 30   Baltimore City 240009000253 10 James McHenry Elementary/Middle   Regular School No Elementary PK 08 2020   pk_12_total 20 577 14     *     *   *                             625 20 577 14                                       625
1246380 1246380 MD     school 2400090 30   Baltimore City 240009000163 251 Callaway Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 282 14     *         *                             303   282 14                                       303
1246621 1246621 MD     school 2400090 30   Baltimore City 240009001735 362 Bard High School Early College   Regular School No High 09 12 2020   pk_12_total 43 384 14     *     *   *                             446 43 384 14                                       446
1237251 1237251 MD     school 2400030 1   Allegany 240003000006 504 Braddock Middle   Regular School No Middle 06 08 2020   pk_12_total 510 26 15     10     *   57                             620 510 26 15     10         57                       620
1237267 1237267 MD     school 2400030 1   Allegany 240003000001 606 Allegany High   Regular School No High 09 12 2020   pk_12_total 631 21 15   * 11         41                             721 631 21 15     11         41                       721
1237514 1237514 MD     school 2400060 2   Anne Arundel 240006000094 1274 Marley Glen School   Special Education School No Other PK 11 2020   pk_12_total 91 32 15   * 11     *   *                             160 91 32 15     11                                 160
1237589 1237589 MD     school 2400060 2   Anne Arundel 240006000068 2112 Fort Smallwood Elementary   Regular School No Elementary PK 05 2020   pk_12_total 416 18 15     *         14                             468 416 18 15               14                       468
1237649 1237649 MD     school 2400060 2   Anne Arundel 240006000125 2202 Severna Park Elementary   Regular School No Elementary KG 05 2020   pk_12_total 381 * 15   * 22         16                             442 381   15     22         16                       442
1238593 1238593 MD     school 2400120 3   Baltimore County 240012001730 410 Lyons Mill Elementary   Regular School No Elementary KG 05 2020   pk_12_total 34 609 15   * 67         30                             759 34 609 15     67         30                       759
1238794 1238794 MD     school 2400120 3   Baltimore County 240012000463 916 Cromwell Valley Elementary Technology   Regular School No Elementary PK 05 2020   pk_12_total 142 158 15   * 31         28                             375 142 158 15     31         28                       375
1238817 1238817 MD     school 2400120 3   Baltimore County 240012000483 922 Ridge Ruxton   Special Education School No Other PK 12 2020   pk_12_total 38 42 15   * 19         *                             123 38 42 15     19                                 123
1240308 1240308 MD     school 2400300 9   Dorchester 240030000622 508 South Dorchester School   Regular School No Elementary PK 08 2020   pk_12_total 196 * 15     *     *   12                             231 196   15               12                       231
1242467 1242467 MD     school 2400480 15   Montgomery 240048001365 525 MCPS Transitions School   Special Education School No High 12 12 2020   pk_12_total 13 21 15     *         *                             55 13 21 15                                       55
1244089 1244089 MD     school 2400510 16   Prince George's 240051001100 1511 Marlton Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 271 15   * *         *                             299   271 15                                       299
1244665 1244665 MD     school 2400600 18   Saint Mary's 240060001236 104 Ridge Elementary   Regular School No Elementary PK 05 2020   pk_12_total 186 29 15   *           35                             266 186 29 15               35                       266
1245782 1245782 MD     school 2400090 30   Baltimore City 240009000164 75 Calverton Elementary/Middle   Regular School No Elementary KG 08 2020   pk_12_total * 332 15     *         *                             358   332 15                                       358
1237642 1237642 MD     school 2400060 2   Anne Arundel 240006000121 2192 Riviera Beach Elementary   Regular School No Elementary PK 05 2020   pk_12_total 252 12 16   * *         22                             312 252 12 16               22                       312
1241388 1241388 MD     school 2400420 13   Howard 240042000760 302 West Friendship Elementary   Regular School No Elementary KG 05 2020   pk_12_total 251 21 16     79     *   25                             393 251 21 16     79         25                       393
1242617 1242617 MD     school 2400480 15   Montgomery 240048001635 587 PEP - Itinerant   Special Education School No Prekindergarten PK PK 2020   pk_12_total 43 18 16   * 16         *                             100 43 18 16     16                                 100
1243676 1243676 MD     school 2400510 16   Prince George's 240051001103 1102 Mattaponi Elementary   Regular School No Elementary KG 05 2020   pk_12_total 20 299 16   * *     *   20                             360 20 299 16               20                       360
1244737 1244737 MD     school 2400600 18   Saint Mary's 240060001232 504 Mechanicsville Elementary   Regular School No Elementary KG 05 2020   pk_12_total 238 10 16   * *         19                             287 238 10 16               19                       287
1245512 1245512 MD     school 2400090 30   Baltimore City 240009000571 15 Stadium School   Regular School No Middle 06 08 2020   pk_12_total * 390 16           *   *                             415   390 16                                       415
1246410 1246410 MD     school 2400090 30   Baltimore City 240009001430 260 Frederick Elementary   Regular School Yes Elementary PK 05 2020   pk_12_total 28 340 16   *           *                             394 28 340 16                                       394
1246670 1246670 MD     school 2400090 30   Baltimore City 240009001690 376 City Neighbors High   Regular School Yes High 09 12 2020   pk_12_total 27 370 16   *           *                             418 27 370 16                                       418
1246678 1246678 MD     school 2400090 30   Baltimore City 240009001691 377 Green Street Academy   Regular School Yes High 06 12 2020   pk_12_total 20 815 16     *                                       852 20 815 16                                       852
1246777 1246777 MD     school 2400090 30   Baltimore City 240009001385 429 Vivien T. Thomas Medical Arts Academy   Career and Technical School No High 09 12 2020   pk_12_total 11 357 16   *           *                             387 11 357 16                                       387
1238002 1238002 MD     school 2400060 2   Anne Arundel 240006001746 4102 Carrie Weedon Early Education Center   Regular School No Prekindergarten PK PK 2020   pk_12_total 36 * 17     *                                       61 36   17                                       61
1238023 1238023 MD     school 2400060 2   Anne Arundel 240006000063 4132 Deale Elementary   Regular School No Elementary KG 05 2020   pk_12_total 189 * 17               *                             219 189   17                                       219
1238421 1238421 MD     school 2400120 3   Baltimore County 240012000497 213 Winand Elementary   Regular School No Elementary PK 05 2020   pk_12_total 16 410 17   * *     *   10                             465 16 410 17               10                       465
1239689 1239689 MD     school 2400210 6   Carroll 240021001652 603 Ebb Valley Elementary   Regular School No Elementary PK 05 2020   pk_12_total 489 13 17   * 10     *   13                             548 489 13 17     10         13                       548
1240016 1240016 MD     school 2400240 7   Cecil 240024000559 904 Calvert Elementary   Regular School No Elementary PK 05 2020   pk_12_total 406   17   *           *                             432 406   17                                       432
1240642 1240642 MD     school 2400330 10   Frederick 240033001166 1511 Thurmont Primary   Regular School No Elementary PK 02 2020   pk_12_total 301   17     *     *   16                             336 301   17               16                       336
1242022 1242022 MD     school 2400480 15   Montgomery 240048000809 238 Cold Spring Elementary   Regular School No Elementary KG 05 2020   pk_12_total 137 12 17     137         29                             332 137 12 17     137         29                       332
1245289 1245289 MD     school 2400690 22   Wicomico 240069001315 907 Charles H. Chipman Elementary   Regular School No Elementary PK 01 2020   pk_12_total 47 206 17   * *         24                             301 47 206 17               24                       301
1245387 1245387 MD     school 2400720 23   Worcester 240072001334 207 Snow Hill High   Regular School No High 09 12 2020   pk_12_total 199 74 17     *         20                             315 199 74 17               20                       315
1237619 1237619 MD     school 2400060 2   Anne Arundel 240006000085 2162 Lake Shore Elementary   Regular School No Elementary KG 05 2020   pk_12_total 288 * 18     *         19                             327 288   18               19                       327
1238429 1238429 MD     school 2400120 3   Baltimore County 240012000405 214 Hernwood Elementary   Regular School No Elementary PK 05 2020   pk_12_total * 339 18   * *         15                             383   339 18               15                       383
1239372 1239372 MD     school 2400150 4   Calvert 240015000514 110 Mutual Elementary   Regular School No Elementary PK 05 2020   pk_12_total 318 42 18               43                             421 318 42 18               43                       421
1239548 1239548 MD     school 2400180 5   Caroline 240018000521 501 Federalsburg Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 188 187 18   * 10         61                             465 188 187 18     10         61                       465
1240280 1240280 MD     school 2400300 9   Dorchester 240030000625 205 Warwick Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 294 27 18     *         19                             361 294 27 18               19                       361
1245370 1245370 MD     school 2400720 23   Worcester 240072001330 107 Pocomoke High   Regular School No High 09 12 2020   pk_12_total 161 144 18     *         24                             353 161 144 18               24                       353
1237612 1237612 MD     school 2400060 2   Anne Arundel 240006000084 2152 Jones Elementary   Regular School No Elementary KG 05 2020   pk_12_total 242 11 19     21         17                             310 242 11 19     21         17                       310

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