enrollments

Data source: Big Local News · About: Big Local

686 rows where grade = "grade_6", state = "IN" and year = 2021 sorted by male

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 686 ✖

grade ✖

  • grade_6 · 686 ✖
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
1919931 1919931 IN     school 1806030 875   Logansport Community Sch Corp 180603001058 702 Logansport Junior High School   Regular School No Middle 06 08 2021   grade_6                         0.0 1.0                       1.0                         0 1                 1
1923769 1923769 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No High 06 12 2021   grade_6                         0.0 1.0                       1.0                         0 1                 1
1926152 1926152 IN     school 1809060 5485   Plymouth Community School Corp 180906001499 5949 Lincoln Junior High School   Regular School No Middle 06 08 2021   grade_6                         0.0 2.0                       2.0                         0 2                 2
1926608 1926608 IN     school 1806510 5925   MSD Martinsville Schools 180651002600 6332 John R. Wooden Middle School   Regular School No Middle 06 08 2021   grade_6                         0.0 1.0                       1.0                         0 1                 1
1926633 1926633 IN     school 1806510 5925   MSD Martinsville Schools 180651002355 6344 South Elementary School of Communi   Regular School No Elementary PK 06 2021   grade_6                         0.0 1.0                       1.0                         0 1                 1
1927212 1927212 IN     school   6530   Union Township School Corp   6811 Porter County Education Services             2021   grade_6                         0.0 1.0                       1.0                         0 1                 1
1928351 1928351 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other 02 12 2021   grade_6                         0.0 3.0                       3.0                         0 3                 3
1919128 1919128 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 06 11 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1920823 1920823 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No High 05 12 2021   grade_6                         1.0 1.0                       2.0                         1 1                 2
1921081 1921081 IN     school 1812240 2285   Wa-Nee Community Schools 181224001954 1743 Nappanee Elementary School   Regular School No Elementary KG 06 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1921959 1921959 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No Middle 05 08 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1922509 1922509 IN     school 1800270 3315   Avon Community School Corp 180027002450 2730 Avon Middle School North   Regular School No Middle 06 08 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1922625 1922625 IN     school 1808970 3330   Plainfield Community School Corp 180897002694 3331 Pride Academy   Regular School No Secondary 05 11 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1922847 1922847 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1925614 1925614 IN     school 1804770 5385   Indianapolis Public Schools 180477002651 108 Impact Academy   Regular School No Other 03 12 2021   grade_6                         1.0 1.0                       2.0                         1 1                 2
1929425 1929425 IN     school 1806270 8045   Manchester Community Schools 180627001101 8633 Manchester Elementary School   Regular School No Elementary PK 06 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1930089 1930089 IN     school 1800222 9000   Phalen Virtual Leadership Academy 180022202707 9992 Phalen Virtual Leadership Academy   Regular School Yes Other 02 12 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1930299 1930299 IN     school 1800016 9325   Options Charter Schools 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 06 12 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1919691 1919691 IN     school 1800570 515   Blackford County Schools 180057000107 485 Montpelier School   Regular School No Elementary KG 06 2021   grade_6                         10.0 13.0                       23.0                         10 13                 23
1923148 1923148 IN     school 1804980 3945   Jay School Corporation 180498000917 3247 Redkey Elementary School   Regular School No Elementary KG 06 2021   grade_6                         10.0 15.0                       25.0                         10 15                 25
1925789 1925789 IN     school 1804770 5385   Indianapolis Public Schools 180477000841 5557 George W Julian School 57   Regular School No Elementary PK 08 2021   grade_6                         10.0 7.0                       17.0                         10 7                 17
1926720 1926720 IN     school 1807920 5945   North Newton School Corp 180792001359 6405 Lake Village Elementary School   Regular School No Elementary KG 06 2021   grade_6                         10.0 13.0                       23.0                         10 13                 23
1926908 1926908 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001792 6601 Patricksburg Elementary School   Regular School No Elementary KG 06 2021   grade_6                         10.0 10.0                       20.0                         10 10                 20
1928464 1928464 IN     school 1808460 7495   Oregon-Davis School Corp 180846002209 7818 Oregon-Davis Elementary School   Regular School No Elementary KG 06 2021   grade_6                         10.0 18.0                       28.0                         10 18                 28
1929505 1929505 IN     school 1806080 8115   MSD Warren County 180608001072 8733 Pine Village Elementary School   Regular School No Elementary KG 06 2021   grade_6                         10.0 8.0                       18.0                         10 8                 18
1929814 1929814 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other 01 12 2021   grade_6                         10.0 1.0                       11.0                         10 1                 11
1919179 1919179 IN     school 1803630 235   Fort Wayne Community Schools 180363000548 128 Miami Middle School   Regular School No Middle 06 08 2021   grade_6                         100.0 88.0                       188.0                         100 88                 188
1922884 1922884 IN     school 1805370 3500   Kokomo School Corporation 180537000998 2955 Central Middle School   Regular School No Middle 06 08 2021   grade_6                         101.0 84.0                       185.0                         101 84                 185
1923086 1923086 IN     school 1805280 3785   Kankakee Valley School Corp 180528000934 3183 Kankakee Valley Middle School   Regular School No Middle 06 08 2021   grade_6                         101.0 118.0                       219.0                         101 118                 219
1927265 1927265 IN     school 1809150 6550   Portage Township Schools 180915001519 6859 William Fegely Middle School   Regular School No Middle 06 08 2021   grade_6                         101.0 118.0                       219.0                         101 118                 219
1922387 1922387 IN     school 1810360 3190   South Harrison Com Schools 181036000385 2663 Corydon Intermediate School   Regular School No Middle 04 06 2021   grade_6                         102.0 57.0                       159.0                         102 57                 159
1922840 1922840 IN     school 1804470 3490   Western School Corporation 180447002225 2922 Western Middle School   Regular School No Middle 06 08 2021   grade_6                         103.0 90.0                       193.0                         103 90                 193
1923781 1923781 IN     school 1813110 4525   Westview School Corporation 181311002365 3702 Westview Elementary School   Regular School No Middle 05 06 2021   grade_6                         103.0 92.0                       195.0                         103 92                 195
1919443 1919443 IN     school 1802850 255   East Allen County Schools 180285002519 43 Prince Chapman Academy   Regular School No Elementary 03 06 2021   grade_6                         104.0 101.0                       205.0                         104 101                 205
1920127 1920127 IN     school 1803940 1010   Greater Clark County Schools 180394002128 863 Charlestown Middle School   Regular School No Middle 06 08 2021   grade_6                         104.0 89.0                       193.0                         104 89                 193
1923183 1923183 IN     school 1806120 3995   Madison Consolidated Schools 180612001091 3313 Madison Consolidated Jr High Sch   Regular School No Middle 04 08 2021   grade_6                         106.0 87.0                       193.0                         106 87                 193
1919163 1919163 IN     school 1803630 235   Fort Wayne Community Schools 180363000537 121 Kekionga Middle School   Regular School No Middle 06 08 2021   grade_6                         107.0 108.0                       215.0                         107 108                 215
1922936 1922936 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000790 3025 Riverview School   Regular School No Middle 06 08 2021   grade_6                         107.0 83.0                       190.0                         107 83                 190
1929227 1929227 IN     school 1812090 8030   Vigo County School Corp 181209001907 8445 Honey Creek Middle School   Regular School No Middle 06 08 2021   grade_6                         107.0 127.0                       234.0                         107 127                 234
1924352 1924352 IN     school 1804560 4720   School Town of Highland 180456000764 4283 Highland Middle School   Regular School No Middle 06 08 2021   grade_6                         108.0 125.0                       233.0                         108 125                 233
1926830 1926830 IN     school 1812900 6065   West Noble School Corporation 181290002059 6509 West Noble Middle School   Regular School No Middle 05 08 2021   grade_6                         108.0 91.0                       199.0                         108 91                 199
1920211 1920211 IN     school 1800840 1125   Clay Community Schools 180084000165 925 North Clay Middle School   Regular School No Middle 06 08 2021   grade_6                         109.0 105.0                       214.0                         109 105                 214
1919667 1919667 IN     school 1800480 395   Benton Community School Corp 180048000098 433 Boswell Elementary School   Regular School No Elementary PK 06 2021   grade_6                         11.0 9.0                       20.0                         11 9                 20
1923243 1923243 IN     school 1805190 4015   Jennings County School Corporation 180519001417 3349 Sand Creek Elementary School   Regular School No Elementary PK 06 2021   grade_6                         11.0 24.0                       35.0                         11 24                 35
1927588 1927588 IN     school 1811730 6795   Union School Corporation 181173001874 7117 Union Elementary School   Regular School No Elementary KG 06 2021   grade_6                         11.0 14.0                       25.0                         11 14                 25
1930023 1930023 IN     school 1800207 8675   Invent Learning Hub 180020702683 9532 Invent Learning Hub   Regular School Yes Elementary KG 07 2021   grade_6                         11.0 8.0                       19.0                         11 8                 19
1930653 1930653 IN     school 1800065 9690   Renaissance Academy Charter School 180006502415 4711 Renaissance Academy Charter School   Regular School Yes Elementary KG 08 2021   grade_6                         11.0 13.0                       24.0                         11 13                 24
1930877 1930877 IN     school 1800225 9954   Phalen Leadership Academy at Louis 180022500867 5548 Louis B Russell Jr School 48   Regular School Yes Elementary KG 06 2021   grade_6                         11.0 14.0                       25.0                         11 14                 25
1930885 1930885 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 08 2021   grade_6                         11.0 11.0                       22.0                         11 11                 22
1925601 1925601 IN     school 1800450 5380   Beech Grove City Schools 180045000095 5461 South Grove Intermediate School   Regular School No Middle 04 06 2021   grade_6                         111.0 122.0                       233.0                         111 122                 233
1928125 1928125 IN     school 1810290 7205   South Bend Community School Corp 181029001661 7559 Dickinson Fine Arts Academy   Regular School No Middle 06 08 2021   grade_6                         111.0 101.0                       212.0                         111 101                 212
1920904 1920904 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000686 1575 Jasper Middle School   Regular School No Middle 06 08 2021   grade_6                         112.0 110.0                       222.0                         112 110                 222
1923927 1923927 IN     school 1805450 4615   Lake Central School Corporation 180545002420 3838 Hal E Clark Middle School   Regular School No Middle 05 08 2021   grade_6                         113.0 109.0                       222.0                         113 109                 222
1923991 1923991 IN     school 1811460 4645   Tri-Creek School Corporation 181146001851 3851 Lowell Middle School   Regular School No Middle 05 08 2021   grade_6                         113.0 105.0                       218.0                         113 105                 218
1919171 1919171 IN     school 1803630 235   Fort Wayne Community Schools 180363000539 126 Lane Middle School   Regular School No Middle 06 08 2021   grade_6                         115.0 116.0                       231.0                         115 116                 231
1923833 1923833 IN     school 1804350 4580   Hanover Community School Corp 180435001908 3784 Hanover Central Middle School   Regular School No Middle 05 08 2021   grade_6                         115.0 101.0                       216.0                         115 101                 216
1928822 1928822 IN     school 1811340 7865   Tippecanoe School Corp 181134001920 8049 Wea Ridge Middle School   Regular School No Middle 06 08 2021   grade_6                         115.0 110.0                       225.0                         115 110                 225
1923946 1923946 IN     school 1805450 4615   Lake Central School Corporation 180545000982 3841 Kahler Middle School   Regular School No Middle 05 08 2021   grade_6                         117.0 112.0                       229.0                         117 112                 229
1924486 1924486 IN     school 1807560 4805   New Prairie United School Corp 180756001299 7345 New Prairie Middle School   Regular School No Middle 06 08 2021   grade_6                         117.0 108.0                       225.0                         117 108                 225
1920653 1920653 IN     school 1802660 1875   Delaware Community School Corp 180266000323 1367 Delta Middle School   Regular School No Middle 06 08 2021   grade_6                         119.0 99.0                       218.0                         119 99                 218
1921058 1921058 IN     school 1812240 2285   Wa-Nee Community Schools 181224001958 1669 North Wood Middle School   Regular School No Middle 06 09 2021   grade_6                         119.0 105.0                       224.0                         119 105                 224
1927855 1927855 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001453 7336 Virgil I Grissom Middle School   Regular School No Middle 06 08 2021   grade_6                         119.0 121.0                       240.0                         119 121                 240
1921174 1921174 IN     school 1803270 2305   Elkhart Community Schools 180327000434 1769 Mary Beck Elementary School   Regular School No Elementary PK 06 2021   grade_6                         12.0 9.0                       21.0                         12 9                 21
1923584 1923584 IN     school 1812120 4335   Vincennes Community School Corp 181212002696 4319 Washington Learning Academy   Regular School No High 06 12 2021   grade_6                         12.0 7.0                       19.0                         12 7                 19
1925839 1925839 IN     school 1804770 5385   Indianapolis Public Schools 180477000893 5574 Theodore Potter School 74   Regular School No Elementary KG 06 2021   grade_6                         12.0 15.0                       27.0                         12 15                 27
1925945 1925945 IN     school 1804770 5385   Indianapolis Public Schools 180477000887 5606 Robert Lee Frost School 106   Regular School No Elementary PK 06 2021   grade_6                         12.0 22.0                       34.0                         12 22                 34
1930843 1930843 IN     school 1800124 9925   Phalen Leadership Academy - IN Inc 180012402550 5496 Phalen Leadership Academy - IN Inc   Regular School Yes Elementary KG 08 2021   grade_6                         12.0 21.0                       33.0                         12 21                 33
1919798 1919798 IN     school 1805790 665   Lebanon Community School Corp 180579001040 557 Lebanon Middle School   Regular School No Middle 06 08 2021   grade_6                         121.0 144.0                       265.0                         121 144                 265
1929755 1929755 IN     school 1809510 8385   Richmond Community Schools 180951001561 8997 Test Intermediate School   Regular School No Middle 05 08 2021   grade_6                         121.0 88.0                       209.0                         121 88                 209
1919159 1919159 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No Middle 06 08 2021   grade_6                         125.0 98.0                       223.0                         125 98                 223
1921375 1921375 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001276 1937 Nathaniel Scribner Middle School   Regular School No Middle 05 08 2021   grade_6                         126.0 128.0                       254.0                         126 128                 254
1929523 1929523 IN     school 1812390 8130   Warrick County School Corp 181239002454 8760 Castle South Middle School   Regular School No Middle 06 08 2021   grade_6                         126.0 119.0                       245.0                         126 119                 245
1929013 1929013 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002649 8271 Harwood Career Prep High School   Regular School No Other KG 12 2021   grade_6                         127.0 126.0                       253.0                         127 126                 253
1920618 1920618 IN     school 1801590 1835   DeKalb Co Ctl United Sch Dist 180159000221 1346 DeKalb Middle School   Regular School No Middle 06 08 2021   grade_6                         128.0 131.0                       259.0                         128 131                 259
1919146 1919146 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2021   grade_6                         129.0 136.0                       265.0                         129 136                 265
1922373 1922373 IN     school 1810360 3190   South Harrison Com Schools 181036001698 2649 New Middletown Elementary School   Regular School No Elementary KG 06 2021   grade_6                         13.0 3.0                       16.0                         13 3                 16
1922381 1922381 IN     school 1810360 3190   South Harrison Com Schools 181036001696 2653 Heth-Washington Elementary School   Regular School No Elementary PK 06 2021   grade_6                         13.0 3.0                       16.0                         13 3                 16
1922989 1922989 IN     school 1801230 3640   Medora Community School Corp 180123000201 3093 Medora Jr & Sr High School   Regular School No High 06 12 2021   grade_6                         13.0 2.0                       15.0                         13 2                 15
1926712 1926712 IN     school 1807920 5945   North Newton School Corp 180792001361 6397 Morocco Elementary School   Regular School No Elementary KG 06 2021   grade_6                         13.0 10.0                       23.0                         13 10                 23
1927624 1927624 IN     school 1810740 6805   Randolph Southern School Corp 181074001762 7113 Randolph Southern Elementary Sch   Regular School No Elementary KG 06 2021   grade_6                         13.0 21.0                       34.0                         13 21                 34
1929048 1929048 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000467 8301 Glenwood Leadership Academy   Regular School No Elementary KG 08 2021   grade_6                         13.0 24.0                       37.0                         13 24                 37
1930743 1930743 IN     school 1800083 9835   The Bloomington Project School 180008302446 6215 The Bloomington Project School   Regular School Yes Elementary KG 08 2021   grade_6                         13.0 14.0                       27.0                         13 14                 27
1925256 1925256 IN     school 1808910 5350   MSD Pike Township 180891001488 5355 Lincoln Middle School   Regular School No Middle 06 08 2021   grade_6                         130.0 133.0                       263.0                         130 133                 263
1920012 1920012 IN     school 1800213 945   Silver Creek School Corporation 180021301537 781 Silver Creek Middle School   Regular School No Middle 06 08 2021   grade_6                         131.0 97.0                       228.0                         131 97                 228
1920281 1920281 IN     school 1803660 1170   Community Schools of Frankfort 180366000573 999 Frankfort Middle School   Regular School No Middle 06 08 2021   grade_6                         131.0 123.0                       254.0                         131 123                 254
1928783 1928783 IN     school 1811340 7865   Tippecanoe School Corp 181134001822 8025 Battle Ground Middle School   Regular School No Middle 06 08 2021   grade_6                         131.0 123.0                       254.0                         131 123                 254
1921370 1921370 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001271 1933 Hazelwood Middle School   Regular School No Middle 05 08 2021   grade_6                         132.0 96.0                       228.0                         132 96                 228
1925453 1925453 IN     school 1812720 5370   MSD Washington Township 181272002024 5448 Westlane Middle School   Regular School No Middle 06 08 2021   grade_6                         132.0 143.0                       275.0                         132 143                 275
1927339 1927339 IN     school 1811970 6560   Valparaiso Community Schools 181197001881 6885 Benjamin Franklin Middle School   Regular School No Middle 06 08 2021   grade_6                         132.0 142.0                       274.0                         132 142                 274
1929267 1929267 IN     school 1812090 8030   Vigo County School Corp 181209001925 8485 Woodrow Wilson Middle School   Regular School No Middle 06 08 2021   grade_6                         133.0 125.0                       258.0                         133 125                 258
1924255 1924255 IN     school 1804320 4710   School City of Hammond 180432000732 4433 Charles N Scott Middle School   Regular School No Middle 06 08 2021   grade_6                         134.0 123.0                       257.0                         134 123                 257
1924424 1924424 IN     school 1807350 4740   School Town of Munster 180735001259 4333 Wilbur Wright Middle School   Regular School No Middle 06 08 2021   grade_6                         136.0 119.0                       255.0                         136 119                 255
1927120 1927120 IN     school 1802800 6470   Duneland School Corporation 180280000338 6927 Westchester Intermediate School   Regular School No Middle 05 06 2021   grade_6                         136.0 141.0                       277.0                         136 141                 277
1929590 1929590 IN     school 1812390 8130   Warrick County School Corp 181239001976 8793 Boonville Middle School   Regular School No Middle 06 08 2021   grade_6                         136.0 106.0                       242.0                         136 106                 242
1922198 1922198 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071002659 2543 New Palestine Intermediate School   Regular School No Middle 05 06 2021   grade_6                         137.0 135.0                       272.0                         137 135                 272
1925307 1925307 IN     school 1808910 5350   MSD Pike Township 180891000513 5380 New Augusta Public Academy - North   Regular School No Middle 06 08 2021   grade_6                         137.0 142.0                       279.0                         137 142                 279
1927888 1927888 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876000794 7372 Discovery Middle School   Regular School No Middle 06 08 2021   grade_6                         137.0 159.0                       296.0                         137 159                 296
1921918 1921918 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000133 2489 Hamilton SE Int and Jr High Sch   Regular School No Middle 05 08 2021   grade_6                         138.0 168.0                       306.0                         138 168                 306
1926787 1926787 IN     school 1802970 6060   East Noble School Corporation 180297002335 6461 East Noble Middle School   Regular School No Middle 06 08 2021   grade_6                         138.0 112.0                       250.0                         138 112                 250
1920395 1920395 IN     school 1812450 1405   Washington Community Schools 181245002005 1105 Veale Elementary School   Regular School No Elementary KG 06 2021   grade_6                         14.0 10.0                       24.0                         14 10                 24

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