Data source: Big Local News · About: Big Local

12,002 rows where state = "IN" and year = 2021 sorted by male descending

View and edit SQL

grade

year

  • 2021 · 12,002
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
1919844 IN     school 1800960 670   Brown County School Corporation 180096000170 581 Helmsburg Elementary School   Regular School No Elementary PK 04 2021   pk_12_total 176.0 2.0 7.0           1.0   4.0   99.0 91.0     0.0         84.0   45.0   190.0 176 2 7           1   4   99 91     0     84 45   190
1920019 IN     school 1800213 945   Silver Creek School Corporation 180021301538 789 Silver Creek Elementary School   Regular School No Elementary 02 05 2021   grade_5                         99.0 110.0                       209.0                         99 110                 209
1920730 IN     school 1807230 1910   Yorktown Community Schools 180723001217 1389 Yorktown High School   Regular School No High 09 12 2021   grade_10                         99.0 101.0                       200.0                         99 101                 200
1920741 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No Elementary KG 02 2021   kindergarten                         99.0 95.0                       194.0                         99 95                 194
1920768 IN     school 1807320 1970   Muncie Community Schools 180732001252 1437 Southside Middle School   Regular School No Middle 06 08 2021   grade_7                         99.0 86.0                       185.0                         99 86                 185
1922564 IN     school 1802550 3325   Danville Community School Corp 180255000306 2721 North Elementary School   Regular School No Elementary KG 04 2021   kindergarten                         99.0 106.0                       205.0                         99 106                 205
1922576 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No Other 04 09 2021   grade_8                         99.0 95.0                       194.0                         99 95                 194
1923177 IN     school 1806120 3995   Madison Consolidated Schools 180612001090 3309 Madison Consolidated High School   Regular School No High 09 12 2021   grade_11                         99.0 99.0                       198.0                         99 99                 198
1923553 IN     school 1812120 4335   Vincennes Community School Corp 181212001931 3553 Lincoln High School   Regular School No High 09 12 2021   grade_9                         99.0 78.0                       177.0                         99 78                 177
1923910 IN     school 1805450 4615   Lake Central School Corporation 180545000985 3831 Michael Grimmer Middle School   Regular School No Middle 05 08 2021   grade_6                         99.0 85.0                       184.0                         99 85                 184
1926443 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000131 6213 Marlin Elementary School   Regular School No Elementary KG 06 2021   pk_12_total 179.0 2.0 3.0     1.0     1.0   5.0   99.0 92.0     1.0         44.0   24.0   191.0 179 2 3     1     1   5   99 92     1     44 24   191
1926548 IN     school 1802460 5855   Crawfordsville Community Schools 180246000289 6281 Crawfordsville Middle School   Regular School No Middle 06 08 2021   grade_6                         99.0 110.0                       209.0                         99 110                 209
1926920 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001791 6613 Owen Valley Community High School   Regular School No High 09 12 2021   grade_10                         99.0 91.0                       190.0                         99 91                 190
1928066 IN     school 1810290 7205   South Bend Community School Corp 181029001645 7510 Jackson Middle School   Regular School No Middle 06 08 2021   grade_8                         99.0 92.0                       191.0                         99 92                 191
1928077 IN     school 1810290 7205   South Bend Community School Corp 181029001684 7517 Washington High School   Regular School No High 09 12 2021   grade_10                         99.0 113.0                       212.0                         99 113                 212
1928263 IN     school 1810020 7255   Scott County School District 2 181002001611 7645 Scottsburg Middle School   Regular School No Middle 06 08 2021   grade_8                         99.0 121.0                       220.0                         99 121                 220
1929009 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002649 8271 Harwood Career Prep High School   Regular School No Other KG 12 2021   grade_2                         99.0 91.0                       190.0                         99 91                 190
1929322 IN     school 1812090 8030   Vigo County School Corp 181209001905 8521 Fayette Elementary School   Regular School No Elementary KG 05 2021   pk_12_total 191.0   2.0               7.0   99.0 101.0     0.0         87.0   27.0   200.0 191   2               7   99 101     0     87 27   200
1929937 IN     school 1811580 8565   Twin Lakes School Corp 181158001862 9153 Roosevelt Middle School   Regular School No Middle 06 08 2021   grade_6                         99.0 84.0                       183.0                         99 84                 183
1930186 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 08 12 2021   pk_12_total 55.0 29.0 12.0               3.0   99.0 0.0     4.0         99.0   37.0   99.0 55 29 12               3   99 0     4     99 37   99
1930252 IN     school 1800208 9165   Paramount Englewood 180020802655 7861 Paramount Englewood   Regular School Yes Middle 05 08 2021   pk_12_total 33.0 97.0 41.0     1.0     1.0   14.0   99.0 88.0     15.0         139.0   28.0   187.0 33 97 41     1     1   14   99 88     15     139 28   187
1920129 IN     school 1803940 1010   Greater Clark County Schools 180394002128 863 Charlestown Middle School   Regular School No Middle 06 08 2021   grade_8                         98.0 83.0                       181.0                         98 83                 181
1920470 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000054 1165 Manchester Elementary School   Regular School No Elementary KG 06 2021   pk_12_total 184.0 1.0 5.0               2.0   98.0 94.0     0.0         70.0   43.0   192.0 184 1 5               2   98 94     0     70 43   192
1921942 IN     school 1804260 3025   Hamilton Heights School Corp 180426000728 2477 Hamilton Heights High School   Regular School No High 09 12 2021   grade_11                         98.0 91.0                       189.0                         98 91                 189
1921949 IN     school 1804260 3025   Hamilton Heights School Corp 180426002134 2478 Hamilton Heights Elementary School   Regular School No Elementary PK 04 2021   grade_4                         98.0 86.0                       184.0                         98 86                 184
1922570 IN     school 1802550 3325   Danville Community School Corp 180255000304 2741 Danville Community High School   Regular School No High 09 12 2021   grade_9                         98.0 97.0                       195.0                         98 97                 195
1922852 IN     school 1804470 3490   Western School Corporation 180447000755 2935 Western Primary School   Regular School No Elementary KG 03 2021   grade_2                         98.0 97.0                       195.0                         98 97                 195
1923182 IN     school 1806120 3995   Madison Consolidated Schools 180612001091 3313 Madison Consolidated Jr High Sch   Regular School No Middle 04 08 2021   grade_5                         98.0 92.0                       190.0                         98 92                 190
1923837 IN     school 1804350 4580   Hanover Community School Corp 180435000753 3785 Hanover Central High School   Regular School No High 09 12 2021   grade_10                         98.0 99.0                       197.0                         98 99                 197
1924215 IN     school 1804320 4710   School City of Hammond 180432000735 4411 George Rogers Clark Md/HS   Regular School No High 06 12 2021   grade_11                         98.0 94.0                       192.0                         98 94                 192
1924219 IN     school 1804320 4710   School City of Hammond 180432000735 4411 George Rogers Clark Md/HS   Regular School No High 06 12 2021   grade_8                         98.0 87.0                       185.0                         98 87                 185
1925618 IN     school 1804770 5385   Indianapolis Public Schools 180477002651 108 Impact Academy   Regular School No Other 03 12 2021   pk_12_total 87.0 49.0 13.0     1.0         17.0   98.0 69.0     4.0         8.0   76.0   167.0 87 49 13     1         17   98 69     4     8 76   167
1926307 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001546 6146 Edgewood High School   Regular School No High 09 12 2021   grade_10                         98.0 101.0                       199.0                         98 101                 199
1926558 IN     school 1802460 5855   Crawfordsville Community Schools 180246000291 6301 Meredith Nicholson Elementary Sch   Regular School No Elementary 02 03 2021   grade_2                         98.0 84.0                       182.0                         98 84                 182
1926559 IN     school 1802460 5855   Crawfordsville Community Schools 180246000291 6301 Meredith Nicholson Elementary Sch   Regular School No Elementary 02 03 2021   grade_3                         98.0 97.0                       195.0                         98 97                 195
1928424 IN     school 1808010 7385   North Spencer County Sch Corp 180801001898 7761 Heritage Hills Middle School   Regular School No Middle 07 08 2021   grade_8                         98.0 86.0                       184.0                         98 86                 184
1928608 IN     school 1810860 7715   Southwest School Corporation 181086001770 7953 Carlisle Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 165.0   8.0     1.0         3.0   98.0 79.0     4.0         114.0   31.0   177.0 165   8     1         3   98 79     4     114 31   177
1928797 IN     school 1811340 7865   Tippecanoe School Corp 181134001825 8033 East Tipp Middle School   Regular School No Middle 06 08 2021   grade_7                         98.0 98.0                       196.0                         98 98                 196
1929011 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002649 8271 Harwood Career Prep High School   Regular School No Other KG 12 2021   grade_4                         98.0 110.0                       208.0                         98 110                 208
1929121 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000481 8349 Plaza Park International Prep Acad   Regular School No Middle 06 08 2021   grade_7                         98.0 84.0                       182.0                         98 84                 182
1929703 IN     school 1813050 8355   Western Wayne Schools 181305000561 8965 Lincoln Middle School   Regular School No Middle 06 08 2021   pk_12_total 181.0 1.0 6.0               4.0   98.0 94.0     2.0         114.0   37.0   192.0 181 1 6               4   98 94     2     114 37   192
1919183 IN     school 1803630 235   Fort Wayne Community Schools 180363000553 129 Northwood Middle School   Regular School No Middle 06 08 2021   grade_6                         97.0 84.0                       181.0                         97 84                 181
1919371 IN     school 1803630 235   Fort Wayne Community Schools 180363000560 240 Shawnee Middle School   Regular School No Middle 06 08 2021   grade_6                         97.0 115.0                       212.0                         97 115                 212
1919455 IN     school 1802850 255   East Allen County Schools 180285000348 53 Leo Elementary School   Regular School No Middle 04 06 2021   grade_6                         97.0 100.0                       197.0                         97 100                 197
1920110 IN     school 1803940 1010   Greater Clark County Schools 180394000667 825 Jonathan Jennings Elementary Sch   Regular School No Elementary 03 05 2021   grade_4                         97.0 85.0                       182.0                         97 85                 182
1920480 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000958 1172 South Dearborn Middle School   Regular School No Middle 07 08 2021   grade_8                         97.0 85.0                       182.0                         97 85                 182
1920740 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No Elementary KG 02 2021   grade_2                         97.0 117.0                       214.0                         97 117                 214
1921413 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741000852 1966 Floyds Knobs Elementary School   Regular School No Elementary KG 04 2021   grade_4                         97.0 76.0                       173.0                         97 76                 173
1921492 IN     school 1803700 2475   Franklin County Community Sch Corp 180370002336 2083 Franklin County High   Regular School No High 09 12 2021   grade_9                         97.0 84.0                       181.0                         97 84                 181
1921615 IN     school 1810350 2765   South Gibson School Corporation 181035001688 2211 Gibson Southern High School   Regular School No High 09 12 2021   grade_11                         97.0 92.0                       189.0                         97 92                 189
1921685 IN     school 1806870 2855   Mississinewa Community School Corp 180687001189 2333 Mississinewa High School   Regular School No High 09 12 2021   grade_12                         97.0 88.0                       185.0                         97 88                 185
1922567 IN     school 1802550 3325   Danville Community School Corp 180255000304 2741 Danville Community High School   Regular School No High 09 12 2021   grade_10                         97.0 76.0                       173.0                         97 76                 173
1922574 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No Other 04 09 2021   grade_6                         97.0 96.0                       193.0                         97 96                 193
1923176 IN     school 1806120 3995   Madison Consolidated Schools 180612001090 3309 Madison Consolidated High School   Regular School No High 09 12 2021   grade_10                         97.0 113.0                       210.0                         97 113                 210
1924234 IN     school 1804320 4710   School City of Hammond 180432000736 4415 Hammond High School   Regular School No High 09 12 2021   grade_12                         97.0 96.0                       193.0                         97 96                 193
1927694 IN     school 1810530 6865   South Ripley Com Sch Corp 181053002482 7174 South Ripley Junior High School   Regular School No Middle 07 08 2021   pk_12_total 187.0   3.0               3.0   97.0 96.0     1.0         114.0   41.0   193.0 187   3               3   97 96     1     114 41   193
1927798 IN     school 1809750 6995   Rush County Schools 180975001596 7285 Rushville Consolidated High School   Regular School No High 09 12 2021   grade_9                         97.0 85.0                       182.0                         97 85                 182
1928113 IN     school 1810290 7205   South Bend Community School Corp 181029001682 7549 Jefferson Traditional School   Regular School No Middle 06 08 2021   grade_7                         97.0 89.0                       186.0                         97 89                 186
1928540 IN     school 1811100 7615   MSD Steuben County 181110001797 7893 Angola High School   Regular School No High 09 12 2021   grade_10                         97.0 113.0                       210.0                         97 113                 210
1928545 IN     school 1811100 7615   MSD Steuben County 181110001798 7895 Angola Middle School   Regular School No Middle 06 08 2021   grade_6                         97.0 100.0                       197.0                         97 100                 197
1928834 IN     school 1812870 7875   West Lafayette Com School Corp 181287002048 8129 West Lafayette Jr/Sr High School   Regular School No High 07 12 2021   grade_10                         97.0 85.0                       182.0                         97 85                 182
1929591 IN     school 1812390 8130   Warrick County School Corp 181239001976 8793 Boonville Middle School   Regular School No Middle 06 08 2021   grade_7                         97.0 109.0                       206.0                         97 109                 206
1929754 IN     school 1809510 8385   Richmond Community Schools 180951001561 8997 Test Intermediate School   Regular School No Middle 05 08 2021   grade_5                         97.0 83.0                       180.0                         97 83                 180
1929974 IN     school 1800211 8635   Purdue Polytechnic High Sch North 180021102685 7782 Purdue Polytechnic High Sch North   Regular School Yes Secondary 09 11 2021   pk_12_total 69.0 49.0 8.0     1.0         8.0   97.0 38.0     1.0         57.0   30.0   135.0 69 49 8     1         8   97 38     1     57 30   135
1930104 IN     school 1800183 9015   Purdue Polytechnic High School Ind 180018302632 4271 Purdue Polytechnic High School Ind   Regular School Yes High 09 12 2021   grade_11                         97.0 32.0                       129.0                         97 32                 129
1920333 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000284 1045 West Crawford Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 179.0   3.0               8.0   96.0 94.0     0.0         137.0   38.0   190.0 179   3               8   96 94     0     137 38   190
1920556 IN     school 1804080 1730   Greensburg Community Schools 180408002056 1270 Greensburg Elementary   Regular School No Elementary PK 05 2021   grade_1                         96.0 74.0                       170.0                         96 74                 170
1921617 IN     school 1810350 2765   South Gibson School Corporation 181035001688 2211 Gibson Southern High School   Regular School No High 09 12 2021   grade_9                         96.0 101.0                       197.0                         96 101                 197
1921688 IN     school 1806870 2855   Mississinewa Community School Corp 180687001190 2335 R J Baskett Middle School   Regular School No Middle 06 08 2021   grade_6                         96.0 79.0                       175.0                         96 79                 175
1923130 IN     school 1804980 3945   Jay School Corporation 180498000914 3239 Jay County Jr/Sr High School   Regular School No High 07 12 2021   grade_12                         96.0 105.0                       201.0                         96 105                 201
1923192 IN     school 1806120 3995   Madison Consolidated Schools 180612001093 3321 Rykers' Ridge Elementary School   Regular School No Elementary PK 04 2021   pk_12_total 184.0 2.0 5.0 2.0   1.0         10.0   96.0 108.0     0.0         120.0   16.0   204.0 184 2 5 2   1         10   96 108     0     120 16   204
1923832 IN     school 1804350 4580   Hanover Community School Corp 180435001908 3784 Hanover Central Middle School   Regular School No Middle 05 08 2021   grade_5                         96.0 96.0                       192.0                         96 96                 192
1923839 IN     school 1804350 4580   Hanover Community School Corp 180435000753 3785 Hanover Central High School   Regular School No High 09 12 2021   grade_12                         96.0 98.0                       194.0                         96 98                 194
1924163 IN     school 1803870 4690   Gary Community School Corp 180387002460 4105 Bailly Middle School   Regular School No Middle 06 08 2021   grade_6                         96.0 82.0                       178.0                         96 82                 178
1924225 IN     school 1804320 4710   School City of Hammond 180432000734 4413 Donald E Gavit Middle/High School   Regular School No High 06 12 2021   grade_12                         96.0 78.0                       174.0                         96 78                 174
1924226 IN     school 1804320 4710   School City of Hammond 180432000734 4413 Donald E Gavit Middle/High School   Regular School No High 06 12 2021   grade_6                         96.0 120.0                       216.0                         96 120                 216
1924548 IN     school 1806570 4925   Michigan City Area Schools 180657001140 4789 Barker Middle School   Regular School No Middle 07 08 2021   grade_7                         96.0 107.0                       203.0                         96 107                 203
1925604 IN     school 1800450 5380   Beech Grove City Schools 180045000881 5463 Hornet Park Elementary School   Regular School No Elementary PK 01 2021   kindergarten                         96.0 101.0                       197.0                         96 101                 197
1926831 IN     school 1812900 6065   West Noble School Corporation 181290002059 6509 West Noble Middle School   Regular School No Middle 05 08 2021   grade_7                         96.0 78.0                       174.0                         96 78                 174
1927194 IN     school 1809180 6520   Porter Township School Corp 180918001520 6837 Boone Grove Elementary School   Regular School No Elementary 04 05 2021   pk_12_total 162.0 2.0 29.0     1.0         4.0   96.0 102.0     2.0         59.0   35.0   198.0 162 2 29     1         4   96 102     2     59 35   198
1928070 IN     school 1810290 7205   South Bend Community School Corp 181029001709 7512 LaSalle Academy   Regular School No Middle 06 08 2021   grade_8                         96.0 104.0                       200.0                         96 104                 200
1928600 IN     school 1808160 7645   Northeast School Corp 180816001401 7941 Northeast East Elementary School   Regular School No Elementary PK 06 2021   pk_12_total 166.0   1.0               4.0   96.0 75.0     0.0         100.0   52.0   171.0 166   1               4   96 75     0     100 52   171
1928812 IN     school 1811340 7865   Tippecanoe School Corp 181134001827 8042 Klondike Elementary School   Regular School No Elementary KG 05 2021   grade_2                         96.0 69.0                       165.0                         96 69                 165
1929062 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000490 8311 William Henry Harrison High School   Regular School No High 09 12 2021   grade_12                         96.0 109.0                       205.0                         96 109                 205
1929850 IN     school 1808220 8435   Northern Wells Community Schools 180822001410 9087 Norwell High School   Regular School No High 09 12 2021   grade_11                         96.0 95.0                       191.0                         96 95                 191
1919441 IN     school 1802850 255   East Allen County Schools 180285002519 43 Prince Chapman Academy   Regular School No Elementary 03 06 2021   grade_4                         95.0 96.0                       191.0                         95 96                 191
1919488 IN     school 1802850 255   East Allen County Schools 180285000954 291 Cedarville Elementary School   Regular School No Elementary KG 03 2021   grade_3                         95.0 94.0                       189.0                         95 94                 189
1920017 IN     school 1800213 945   Silver Creek School Corporation 180021301538 789 Silver Creek Elementary School   Regular School No Elementary 02 05 2021   grade_3                         95.0 103.0                       198.0                         95 103                 198
1920107 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No High 09 12 2021   grade_9                         95.0 109.0                       204.0                         95 109                 204
1920725 IN     school 1807230 1910   Yorktown Community Schools 180723001218 1387 Yorktown Middle School   Regular School No Middle 06 08 2021   grade_6                         95.0 96.0                       191.0                         95 96                 191
1921955 IN     school 1804260 3025   Hamilton Heights School Corp 180426000727 2501 Hamilton Heights Middle School   Regular School No Middle 05 08 2021   grade_7                         95.0 81.0                       176.0                         95 81                 176
1922407 IN     school 1808100 3295   North West Hendricks Schools 180810001670 2682 Tri-West Middle School   Regular School No Middle 06 08 2021   grade_8                         95.0 87.0                       182.0                         95 87                 182
1922606 IN     school 1808970 3330   Plainfield Community School Corp 180897002569 2753 Little Quakers Academy   Regular School No Prekindergarten PK PK 2021   pk_12_total 139.0 2.0 7.0     3.0         12.0   95.0 68.0     0.0         30.0   65.0   163.0 139 2 7     3         12   95 68     0     30 65   163
1922607 IN     school 1808970 3330   Plainfield Community School Corp 180897002569 2753 Little Quakers Academy   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                         95.0 68.0                       163.0                         95 68                 163
1923771 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No High 06 12 2021   grade_8                         95.0 87.0                       182.0                         95 87                 182
1923834 IN     school 1804350 4580   Hanover Community School Corp 180435001908 3784 Hanover Central Middle School   Regular School No Middle 05 08 2021   grade_7                         95.0 106.0                       201.0                         95 106                 201
1925172 IN     school 1808820 5340   Perry Township Schools 180882001459 5333 Glenns Valley Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         95.0 96.0                       191.0                         95 96                 191
1925636 IN     school 1804770 5385   Indianapolis Public Schools 180477000815 5474 Crispus Attucks High School   Regular School No High 09 12 2021   grade_12                         95.0 150.0                       245.0                         95 150                 245
1925640 IN     school 1804770 5385   Indianapolis Public Schools 180477000825 5481 Emmerich Manual High School   Regular School No High 10 12 2021   grade_11                         95.0 68.0                       163.0                         95 68                 163
1925668 IN     school 1804770 5385   Indianapolis Public Schools 180477002528 5516 Northwest Community Middle School   Regular School No Middle 07 08 2021   grade_8                         95.0 100.0                       195.0                         95 100                 195

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