enrollments

Data source: Big Local News · About: Big Local

11,992 rows where state = "IN" and year = 2019 sorted by male descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2019 · 11,992 ✖
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
1753860 1753860 IN     school 1803930 2315   Goshen Community Schools 180393000654 1821 Goshen High School   Regular School No High 09 12 2019   pk_12_total 773.0 34.0 1039.0 4.0   28.0         67.0   998.0 947.0     312.0         1072.0   223.0   1945.0 773 34 1039 4   28         67   998 947     312     1072 223   1945
1762259 1762259 IN     school 1812390 8130   Warrick County School Corp 181239001977 8809 Castle High School   Regular School No High 09 12 2019   pk_12_total 1709.0 45.0 57.0 2.0   70.0         93.0   991.0 985.0     25.0         388.0   210.0   1976.0 1709 45 57 2   70         93   991 985     25     388 210   1976
1751757 1751757 IN     school 1803630 235   Fort Wayne Community Schools 180363000537 121 Kekionga Middle School   Regular School No Middle 06 08 2019   grade_6                         99.0 96.0                       195.0                         99 96                 195
1752049 1752049 IN     school 1802850 255   East Allen County Schools 180285000348 53 Leo Elementary School   Regular School No Middle 04 06 2019   grade_6                         99.0 105.0                       204.0                         99 105                 204
1753079 1753079 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000056 1179 South Dearborn High School   Regular School No High 09 12 2019   grade_11                         99.0 102.0                       201.0                         99 102                 201
1753081 1753081 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000056 1179 South Dearborn High School   Regular School No High 09 12 2019   grade_9                         99.0 97.0                       196.0                         99 97                 196
1753145 1753145 IN     school 1804080 1730   Greensburg Community Schools 180408000704 1268 Greensburg Community High School   Regular School No High 09 12 2019   grade_12                         99.0 88.0                       187.0                         99 88                 187
1753329 1753329 IN     school 1807230 1910   Yorktown Community Schools 180723001217 1389 Yorktown High School   Regular School No High 09 12 2019   grade_9                         99.0 106.0                       205.0                         99 106                 205
1753365 1753365 IN     school 1807320 1970   Muncie Community Schools 180732001252 1437 Southside Middle School   Regular School No Middle 06 08 2019   grade_8                         99.0 71.0                       170.0                         99 71                 170
1754989 1754989 IN     school 1810360 3190   South Harrison Com Schools 181036000385 2663 Corydon Intermediate School   Regular School No Middle 04 06 2019   grade_4                         99.0 63.0                       162.0                         99 63                 162
1755208 1755208 IN     school 1808970 3330   Plainfield Community School Corp 180897002569 2753 Little Quakers Academy   Regular School No Prekindergarten PK PK 2019   pk_12_total 155.0 7.0 2.0     7.0         6.0   99.0 78.0     0.0         25.0   71.0   177.0 155 7 2     7         6   99 78     0     25 71   177
1755209 1755209 IN     school 1808970 3330   Plainfield Community School Corp 180897002569 2753 Little Quakers Academy   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                         99.0 78.0                       177.0                         99 78                 177
1757161 1757161 IN     school 1806570 4925   Michigan City Area Schools 180657001140 4789 Barker Middle School   Regular School No Middle 07 08 2019   grade_7                         99.0 108.0                       207.0                         99 108                 207
1760920 1760920 IN     school 1810020 7255   Scott County School District 2 181002001611 7645 Scottsburg Middle School   Regular School No Middle 06 08 2019   grade_8                         99.0 95.0                       194.0                         99 95                 194
1762408 1762408 IN     school 1809510 8385   Richmond Community Schools 180951001561 8997 Test Intermediate School   Regular School No Middle 05 08 2019   grade_7                         99.0 88.0                       187.0                         99 88                 187
1762564 1762564 IN     school 1811430 8535   Tri-County School Corporation 181143001848 3170 Tri-County Primary School   Regular School No Elementary PK 02 2019   pk_12_total 171.0 2.0 11.0           1.0   4.0   99.0 90.0     3.0         87.0   33.0   189.0 171 2 11           1   4   99 90     3     87 33   189
1762605 1762605 IN     school 1811580 8565   Twin Lakes School Corp 181158001860 9163 Meadowlawn Elementary School   Regular School No Elementary KG 05 2019   grade_5                         99.0 88.0                       187.0                         99 88                 187
1762825 1762825 IN     school 1800134 9305   Excel Center - Richmond 180013402549 9012 Excel Center - Richmond   Regular School Yes High 11 12 2019   grade_12                         99.0 109.0                       208.0                         99 109                 208
1753074 1753074 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000958 1172 South Dearborn Middle School   Regular School No Middle 07 08 2019   grade_7                         98.0 80.0                       178.0                         98 80                 178
1753256 1753256 IN     school 1802660 1875   Delaware Community School Corp 180266000320 1369 Delta High School   Regular School No High 09 12 2019   grade_12                         98.0 118.0                       216.0                         98 118                 216
1755742 1755742 IN     school 1804980 3945   Jay School Corporation 180498000917 3247 Redkey Elementary School   Regular School No Elementary KG 05 2019   pk_12_total 177.0   2.0               9.0   98.0 90.0     1.0         122.0   55.0   188.0 177   2               9   98 90     1     122 55   188
1756821 1756821 IN     school 1804320 4710   School City of Hammond 180432000735 4411 George Rogers Clark Md/HS   Regular School No High 06 12 2019   grade_6                         98.0 89.0                       187.0                         98 89                 187
1758264 1758264 IN     school 1800450 5380   Beech Grove City Schools 180045000094 5457 Central Elementary School   Regular School No Elementary 02 03 2019   grade_3                         98.0 121.0                       219.0                         98 121                 219
1759015 1759015 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001546 6146 Edgewood High School   Regular School No High 09 12 2019   grade_12                         98.0 83.0                       181.0                         98 83                 181
1759027 1759027 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001708 6153 Edgewood Intermediate School   Regular School No Elementary 03 05 2019   grade_4                         98.0 95.0                       193.0                         98 95                 193
1759306 1759306 IN     school 1806510 5925   M S D Martinsville Schools 180651001132 6309 Green Township Elementary School   Regular School No Elementary PK 04 2019   pk_12_total 172.0   3.0               1.0   98.0 78.0     0.0         46.0   25.0   176.0 172   3               1   98 78     0     46 25   176
1759548 1759548 IN     school 1812900 6065   West Noble School Corporation 181290002231 6510 West Noble Elementary School   Regular School No Elementary 02 04 2019   grade_3                         98.0 88.0                       186.0                         98 88                 186
1759636 1759636 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001791 6613 Owen Valley Community High School   Regular School No High 09 12 2019   grade_9                         98.0 90.0                       188.0                         98 90                 188
1760270 1760270 IN     school 1811730 6795   Union School Corporation 181173002666 7131 Indiana Digital JR and High School   Regular School No Secondary 07 11 2019   grade_10                         98.0 138.0                       236.0                         98 138                 236
1760465 1760465 IN     school 1809750 6995   Rush County Schools 180975002240 7290 Benjamin Rush Middle School   Regular School No Middle 07 08 2019   grade_8                         98.0 102.0                       200.0                         98 102                 200
1760919 1760919 IN     school 1810020 7255   Scott County School District 2 181002001611 7645 Scottsburg Middle School   Regular School No Middle 06 08 2019   grade_7                         98.0 99.0                       197.0                         98 99                 197
1761970 1761970 IN     school 1812090 8030   Vigo County School Corp 181209001905 8521 Fayette Elementary School   Regular School No Elementary KG 05 2019   pk_12_total 191.0                   5.0   98.0 98.0     0.0         70.0   16.0   196.0 191                   5   98 98     0     70 16   196
1762509 1762509 IN     school 1808220 8435   Northern Wells Community Schools 180822002159 9088 Norwell Middle School   Regular School No Middle 06 08 2019   grade_7                         98.0 108.0                       206.0                         98 108                 206
1762510 1762510 IN     school 1808220 8435   Northern Wells Community Schools 180822002159 9088 Norwell Middle School   Regular School No Middle 06 08 2019   grade_8                         98.0 105.0                       203.0                         98 105                 203
1762593 1762593 IN     school 1811580 8565   Twin Lakes School Corp 181158001862 9153 Roosevelt Middle School   Regular School No Middle 06 08 2019   grade_8                         98.0 80.0                       178.0                         98 80                 178
1751567 1751567 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2019   grade_9                         97.0 80.0                       177.0                         97 80                 177
1751775 1751775 IN     school 1803630 235   Fort Wayne Community Schools 180363000548 128 Miami Middle School   Regular School No Middle 06 08 2019   grade_8                         97.0 100.0                       197.0                         97 100                 197
1752043 1752043 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No High 07 12 2019   grade_7                         97.0 125.0                       222.0                         97 125                 222
1752103 1752103 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No Elementary PK 02 2019   grade_2                         97.0 91.0                       188.0                         97 91                 188
1752588 1752588 IN     school 1809370 940   West Clark Community Schools 180937001536 777 Silver Creek High School   Regular School No High 09 12 2019   grade_12                         97.0 121.0                       218.0                         97 121                 218
1752688 1752688 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No High 09 12 2019   grade_12                         97.0 83.0                       180.0                         97 83                 180
1753327 1753327 IN     school 1807230 1910   Yorktown Community Schools 180723001217 1389 Yorktown High School   Regular School No High 09 12 2019   grade_11                         97.0 93.0                       190.0                         97 93                 190
1754947 1754947 IN     school 1800690 3180   North Harrison Com School Corp 180069000144 2629 North Harrison High School   Regular School No High 09 12 2019   grade_12                         97.0 83.0                       180.0                         97 83                 180
1754960 1754960 IN     school 1810360 3190   South Harrison Com Schools 181036002282 2640 Corydon Central High School   Regular School No High 09 12 2019   grade_12                         97.0 68.0                       165.0                         97 68                 165
1755480 1755480 IN     school 1805370 3500   Kokomo School Corporation 180537000998 2955 Central Middle School   Regular School No Middle 06 08 2019   grade_7                         97.0 114.0                       211.0                         97 114                 211
1756839 1756839 IN     school 1804320 4710   School City of Hammond 180432000736 4415 Hammond High School   Regular School No High 09 12 2019   grade_9                         97.0 89.0                       186.0                         97 89                 186
1757271 1757271 IN     school 1805580 4945   LaPorte Community School Corp 180558001019 4745 Paul F Boston Middle School   Regular School No Middle 06 08 2019   grade_6                         97.0 114.0                       211.0                         97 114                 211
1758988 1758988 IN     school 1808850 5635   Peru Community Schools 180885001476 6085 Peru High School   Regular School No High 08 12 2019   grade_12                         97.0 66.0                       163.0                         97 66                 163
1759014 1759014 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001546 6146 Edgewood High School   Regular School No High 09 12 2019   grade_11                         97.0 92.0                       189.0                         97 92                 189
1759542 1759542 IN     school 1812900 6065   West Noble School Corporation 181290002059 6509 West Noble Middle School   Regular School No Middle 05 08 2019   grade_5                         97.0 87.0                       184.0                         97 87                 184
1759634 1759634 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001791 6613 Owen Valley Community High School   Regular School No High 09 12 2019   grade_11                         97.0 90.0                       187.0                         97 90                 187
1759808 1759808 IN     school 1802800 6470   Duneland School Corporation 180280000336 6821 Liberty Intermediate School   Regular School No Middle 05 06 2019   grade_6                         97.0 93.0                       190.0                         97 93                 190
1760384 1760384 IN     school 1800390 6895   Batesville Community School Corp 180039000085 7219 Batesville Middle School   Regular School No Middle 06 08 2019   grade_6                         97.0 74.0                       171.0                         97 74                 171
1760459 1760459 IN     school 1809750 6995   Rush County Schools 180975001596 7285 Rushville Consolidated High School   Regular School No High 09 12 2019   grade_10                         97.0 91.0                       188.0                         97 91                 188
1761201 1761201 IN     school 1811100 7615   M S D Steuben County 181110001797 7893 Angola High School   Regular School No High 09 12 2019   grade_11                         97.0 130.0                       227.0                         97 130                 227
1761460 1761460 IN     school 1811340 7865   Tippecanoe School Corp 181134001825 8033 East Tipp Middle School   Regular School No Middle 06 08 2019   grade_8                         97.0 79.0                       176.0                         97 79                 176
1761745 1761745 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000486 8323 Thompkins Middle School   Regular School No Middle 06 08 2019   grade_7                         97.0 146.0                       243.0                         97 146                 243
1762471 1762471 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other KG 12 2019   pk_12_total 75.0 19.0 4.0 2.0             17.0   97.0 20.0     0.0         91.0   76.0   117.0 75 19 4 2             17   97 20     0     91 76   117
1762861 1762861 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 09 12 2019   pk_12_total 157.0 22.0 9.0 2.0   3.0         14.0   97.0 110.0     2.0         72.0   51.0   207.0 157 22 9 2   3         14   97 110     2     72 51   207
1763147 1763147 IN     school 1800058 9650   Herron Charter 180005802315 5724 Herron High School   Regular School Yes High 09 12 2019   grade_11                         97.0 143.0                       240.0                         97 143                 240
1763391 1763391 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2019   grade_1                         97.0 71.0                       168.0                         97 71                 168
1757509 1757509 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No High 09 12 2019   pk_12_total 982.0 439.0 235.0 2.0   8.0         118.0   960.0 824.0     59.0         1180.0   377.0   1784.0 982 439 235 2   8         118   960 824     59     1180 377   1784
1752709 1752709 IN     school 1803940 1010   Greater Clark County Schools 180394002128 863 Charlestown Middle School   Regular School No Middle 06 08 2019   grade_6                         96.0 75.0                       171.0                         96 75                 171
1754102 1754102 IN     school 1803700 2475   Franklin County Community Sch Corp 180370002336 2083 Franklin County High   Regular School No High 09 12 2019   grade_11                         96.0 93.0                       189.0                         96 93                 189
1754474 1754474 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002060 2474 Geist Elementary School   Regular School No Elementary KG 04 2019   grade_1                         96.0 75.0                       171.0                         96 75                 171
1754481 1754481 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000373 2475 Lantern Road Elementary School   Regular School No Elementary KG 04 2019   grade_2                         96.0 77.0                       173.0                         96 77                 173
1754959 1754959 IN     school 1810360 3190   South Harrison Com Schools 181036002282 2640 Corydon Central High School   Regular School No High 09 12 2019   grade_11                         96.0 87.0                       183.0                         96 87                 183
1755178 1755178 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No Other 04 09 2019   grade_8                         96.0 81.0                       177.0                         96 81                 177
1755430 1755430 IN     school 1804470 3490   Western School Corporation 180447000756 2921 Western High School   Regular School No High 08 12 2019   grade_11                         96.0 111.0                       207.0                         96 111                 207
1756345 1756345 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No High 06 12 2019   grade_7                         96.0 96.0                       192.0                         96 96                 192
1756793 1756793 IN     school 1804170 4700   Griffith Public Schools 180417000722 4173 Griffith Senior High School   Regular School No High 09 12 2019   grade_11                         96.0 90.0                       186.0                         96 90                 186
1758990 1758990 IN     school 1808850 5635   Peru Community Schools 180885001476 6085 Peru High School   Regular School No High 08 12 2019   grade_9                         96.0 76.0                       172.0                         96 76                 172
1758994 1758994 IN     school 1808850 5635   Peru Community Schools 180885001477 6089 Peru Junior High School   Regular School No Middle 05 08 2019   grade_7                         96.0 64.0                       160.0                         96 64                 160
1759020 1759020 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001547 6147 Edgewood Junior High School   Regular School No Middle 06 08 2019   grade_8                         96.0 110.0                       206.0                         96 110                 206
1759430 1759430 IN     school 1807920 5945   North Newton School Corp 180792001359 6405 Lake Village Elementary School   Regular School No Elementary KG 06 2019   pk_12_total 190.0   6.0     1.0     2.0   3.0   96.0 106.0     0.0         100.0   36.0   202.0 190   6     1     2   3   96 106     0     100 36   202
1760837 1760837 IN     school 1810290 7205   South Bend Community School Corp 181029001679 7597 Navarre Middle School   Regular School No Middle 06 08 2019   grade_7                         96.0 81.0                       177.0                         96 81                 177
1762588 1762588 IN     school 1811580 8565   Twin Lakes School Corp 181158001863 9149 Twin Lakes Senior High School   Regular School No High 09 12 2019   grade_12                         96.0 105.0                       201.0                         96 105                 201
1753975 1753975 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001265 1930 Floyd Central High School   Regular School No High 09 12 2019   pk_12_total 1643.0 20.0 61.0 11.0   42.0     1.0   37.0   950.0 865.0     7.0         309.0   207.0   1815.0 1643 20 61 11   42     1   37   950 865     7     309 207   1815
1752596 1752596 IN     school 1809370 940   West Clark Community Schools 180937001538 789 Silver Creek Elementary School   Regular School No Elementary 02 05 2019   grade_3                         95.0 102.0                       197.0                         95 102                 197
1752686 1752686 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No High 09 12 2019   grade_10                         95.0 87.0                       182.0                         95 87                 182
1752998 1752998 IN     school 1812450 1405   Washington Community Schools 181245002006 1125 Washington High School   Regular School No High 09 12 2019   grade_11                         95.0 84.0                       179.0                         95 84                 179
1753360 1753360 IN     school 1807320 1970   Muncie Community Schools 180732002320 1431 Northside Middle School   Regular School No Middle 06 08 2019   grade_7                         95.0 82.0                       177.0                         95 82                 177
1754101 1754101 IN     school 1803700 2475   Franklin County Community Sch Corp 180370002336 2083 Franklin County High   Regular School No High 09 12 2019   grade_10                         95.0 93.0                       188.0                         95 93                 188
1754202 1754202 IN     school 1807770 2735   North Gibson School Corporation 180777001327 2225 Princeton Community Middle   Regular School No Middle 06 08 2019   grade_8                         95.0 87.0                       182.0                         95 87                 182
1754555 1754555 IN     school 1804260 3025   Hamilton Heights School Corp 180426000727 2501 Hamilton Heights Middle School   Regular School No Middle 06 08 2019   grade_8                         95.0 78.0                       173.0                         95 78                 173
1755182 1755182 IN     school 1802550 3325   Danville Community School Corp 180255000307 2745 South Elementary School   Regular School No Elementary 03 04 2019   grade_4                         95.0 95.0                       190.0                         95 95                 190
1755187 1755187 IN     school 1808970 3330   Plainfield Community School Corp 180897002438 2748 Clarks Creek Elementary   Regular School No Elementary KG 05 2019   grade_4                         95.0 75.0                       170.0                         95 75                 170
1755439 1755439 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2019   grade_3                         95.0 110.0                       205.0                         95 110                 205
1756142 1756142 IN     school 1812120 4335   Vincennes Community School Corp 181212001928 3557 George Rogers Clark School   Regular School No Middle 06 08 2019   grade_8                         95.0 96.0                       191.0                         95 96                 191
1756493 1756493 IN     school 1805450 4615   Lake Central School Corporation 180545000985 3831 Michael Grimmer Middle School   Regular School No Middle 05 08 2019   grade_5                         95.0 102.0                       197.0                         95 102                 197
1756653 1756653 IN     school 1802490 4660   Crown Point Community School Corp 180249002025 3907 Jerry Ross Elementary School   Regular School No Elementary 03 05 2019   grade_5                         95.0 89.0                       184.0                         95 89                 184
1757626 1757626 IN     school 1802640 5300   M S D Decatur Township 180264001065 5192 Liberty Early Elementary School   Regular School No Elementary PK KG 2019   pre_kindergarten                         95.0 74.0                       169.0                         95 74                 169
1757682 1757682 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002499 5203 Lillie Idella Kitley Elementary   Regular School No Elementary KG 05 2019   kindergarten                         95.0 86.0                       181.0                         95 86                 181
1757852 1757852 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         95.0 104.0                       199.0                         95 104                 199
1759249 1759249 IN     school 1802460 5855   Crawfordsville Community Schools 180246000287 6277 Crawfordsville Sr High School   Regular School No High 09 12 2019   grade_12                         95.0 72.0                       167.0                         95 72                 167
1759536 1759536 IN     school 1812900 6065   West Noble School Corporation 181290002058 6489 West Noble High School   Regular School No High 09 12 2019   grade_9                         95.0 91.0                       186.0                         95 91                 186
1760157 1760157 IN     school 1809360 6630   West Central School Corp 180936001517 7031 West Central Middle School   Regular School No Middle 06 08 2019   pk_12_total 149.0   9.0 1.0   1.0         6.0   95.0 71.0     2.0         100.0   23.0   166.0 149   9 1   1         6   95 71     2     100 23   166
1760376 1760376 IN     school 1800390 6895   Batesville Community School Corp 180039000084 7217 Batesville High School   Regular School No High 09 12 2019   grade_12                         95.0 90.0                       185.0                         95 90                 185
1760781 1760781 IN     school 1810290 7205   South Bend Community School Corp 181029001661 7559 Dickinson Fine Arts Academy   Regular School No Middle 06 08 2019   grade_6                         95.0 136.0                       231.0                         95 136                 231
1760838 1760838 IN     school 1810290 7205   South Bend Community School Corp 181029001679 7597 Navarre Middle School   Regular School No Middle 06 08 2019   grade_8                         95.0 87.0                       182.0                         95 87                 182

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