Data source: Big Local News · About: Big Local

12,058 rows where state = "IN" and year = 2017 sorted by male descending

View and edit SQL

grade

year

  • 2017 · 12,058
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
1293726 IN     school 1802830 630   Zionsville Community Schools 180283000341 512 Zionsville Community High School   Regular School No High 09 12 2017   pk_12_total 1671.0 36.0 75.0 5.0   84.0         64.0   992.0 943.0     6.0             224.0   1935.0 1671 36 75 5   84         64   992 943     6       224   1935
1293141 IN     school 1803630 235   Fort Wayne Community Schools 180363000539 126 Lane Middle School   Regular School No Middle 06 08 2017   grade_7                         99.0 114.0                       213.0                         99 114                 213
1293457 IN     school 1802850 255   East Allen County Schools 180285000954 291 Cedarville Elementary School   Regular School No Elementary KG 03 2017   grade_1                         99.0 97.0                       196.0                         99 97                 196
1294537 IN     school 1804080 1730   Greensburg Community Schools 180408002056 1270 Greensburg Elementary   Regular School No Elementary PK 05 2017   grade_4                         99.0 84.0                       183.0                         99 84                 183
1294700 IN     school 1807230 1910   Yorktown Community Schools 180723001218 1387 Yorktown Middle School   Regular School No Middle 06 08 2017   grade_8                         99.0 111.0                       210.0                         99 111                 210
1294778 IN     school 1807320 1970   Muncie Community Schools 180732001239 1494 Mitchell Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 146.0 26.0 10.0 1.0   5.0         31.0   99.0 120.0     11.0             22.0   219.0 146 26 10 1   5         31   99 120     11       22   219
1295496 IN     school 1803700 2475   Franklin County Community Sch Corp 180370002336 2083 Franklin County High   Regular School No High 09 12 2017   grade_11                         99.0 117.0                       216.0                         99 117                 216
1295601 IN     school 1807770 2735   North Gibson School Corp 180777001326 2249 Princeton Community High School   Regular School No High 09 12 2017   grade_9                         99.0 72.0                       171.0                         99 72                 171
1295937 IN     school 1804260 3025   Hamilton Heights School Corp 180426000728 2477 Hamilton Heights High School   Regular School No High 09 12 2017   grade_11                         99.0 87.0                       186.0                         99 87                 186
1295939 IN     school 1804260 3025   Hamilton Heights School Corp 180426000728 2477 Hamilton Heights High School   Regular School No High 09 12 2017   grade_9                         99.0 100.0                       199.0                         99 100                 199
1296331 IN     school 1800690 3180   North Harrison Com School Corp 180069000145 2625 North Harrison Middle School   Regular School No Middle 06 08 2017   grade_6                         99.0 81.0                       180.0                         99 81                 180
1296349 IN     school 1810360 3190   South Harrison Com Schools 181036002282 2640 Corydon Central High School   Regular School No High 09 12 2017   grade_10                         99.0 71.0                       170.0                         99 71                 170
1296350 IN     school 1810360 3190   South Harrison Com Schools 181036002282 2640 Corydon Central High School   Regular School No High 09 12 2017   grade_11                         99.0 85.0                       184.0                         99 85                 184
1296816 IN     school 1804470 3490   Western School Corporation 180447000756 2921 Western High School   Regular School No High 07 12 2017   grade_9                         99.0 113.0                       212.0                         99 113                 212
1296929 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000792 3035 Salamonie School   Regular School No Elementary KG 05 2017   pk_12_total 176.0 1.0 4.0               16.0   99.0 98.0     0.0             48.0   197.0 176 1 4               16   99 98     0       48   197
1297825 IN     school 1804350 4580   Hanover Community School Corp 180435000753 3785 Hanover Central High School   Regular School No High 09 12 2017   grade_11                         99.0 76.0                       175.0                         99 76                 175
1298267 IN     school 1804170 4700   Griffith Public Schools 180417000722 4173 Griffith Senior High School   Regular School No High 09 12 2017   grade_9                         99.0 95.0                       194.0                         99 95                 194
1298294 IN     school 1804320 4710   School City of Hammond 180432000735 4411 George Rogers Clark Md/HS   Regular School No Other 06 12 2017   grade_7                         99.0 101.0                       200.0                         99 101                 200
1298301 IN     school 1804320 4710   School City of Hammond 180432000734 4413 Donald E Gavit Middle/High School   Regular School No Other 06 12 2017   grade_12                         99.0 81.0                       180.0                         99 81                 180
1298836 IN     school 1807860 5075   North Lawrence Com Schools 180786001336 4905 Bedford Middle School   Regular School No Middle 06 08 2017   grade_7                         99.0 86.0                       185.0                         99 86                 185
1299142 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002499 5203 Lillie Idella Kitley Elementary   Regular School No Elementary PK 05 2017   grade_4                         99.0 81.0                       180.0                         99 81                 180
1300515 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001546 6146 Edgewood High School   Regular School No High 09 12 2017   grade_11                         99.0 106.0                       205.0                         99 106                 205
1301319 IN     school 1802800 6470   Duneland School Corporation 180280000336 6821 Liberty Intermediate School   Regular School No Middle 05 06 2017   grade_6                         99.0 66.0                       165.0                         99 66                 165
1301583 IN     school 1807290 6590   M S D Mount Vernon 180729001227 6953 Mount Vernon Jr High School   Regular School No Middle 06 08 2017   grade_7                         99.0 66.0                       165.0                         99 66                 165
1301752 IN     school 1803990 6755   Greencastle Community School Corp 180399000691 7105 Martha J Ridpath Elementary School   Regular School No Elementary KG 02 2017   pk_12_total 172.0 2.0 2.0     1.0         13.0   99.0 91.0     1.0             20.0   190.0 172 2 2     1         13   99 91     1       20   190
1302701 IN     school 1811100 7615   M S D Steuben County 181110001797 7893 Angola High School   Regular School No High 09 12 2017   grade_11                         99.0 114.0                       213.0                         99 114                 213
1302703 IN     school 1811100 7615   M S D Steuben County 181110001797 7893 Angola High School   Regular School No High 09 12 2017   grade_9                         99.0 138.0                       237.0                         99 138                 237
1303098 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000456 8237 Benjamin Bosse High School   Regular School No High 09 12 2017   grade_9                         99.0 88.0                       187.0                         99 88                 187
1303259 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000481 8349 Plaza Park International Prep Acad   Regular School No Middle 06 08 2017   grade_8                         99.0 101.0                       200.0                         99 101                 200
1304535 IN     school 1800056 9640   Options Charter School Noblesville 180005602313 2551 Options Charter School Noblesville   Regular School Yes Other 06 12 2017   pk_12_total 152.0 17.0 11.0 1.0   3.0     1.0   19.0   99.0 105.0     4.0             68.0   204.0 152 17 11 1   3     1   19   99 105     4       68   204
1304769 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes Other KG 12 2017   grade_5                         99.0 94.0                       193.0                         99 94                 193
1304770 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes Other KG 12 2017   grade_6                         99.0 107.0                       206.0                         99 107                 206
1297299 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000246 3421 Whiteland Community High School   Regular School No High 09 12 2017   pk_12_total 1540.0 47.0 90.0 4.0   107.0         60.0   986.0 862.0     31.0             258.0   1848.0 1540 47 90 4   107         60   986 862     31       258   1848
1302957 IN     school 1811340 7865   Tippecanoe School Corp 181134001835 8029 William Henry Harrison High School   Regular School No High 09 12 2017   pk_12_total 1515.0 63.0 200.0 5.0   56.0         66.0   982.0 923.0     55.0             248.0   1905.0 1515 63 200 5   56         66   982 923     55       248   1905
1293648 IN     school 1800480 395   Benton Community School Corp 180048000097 445 Benton Central Jr-Sr High School   Regular School No High 07 12 2017   grade_7                         98.0 80.0                       178.0                         98 80                 178
1294528 IN     school 1804080 1730   Greensburg Community Schools 180408000704 1268 Greensburg Community High School   Regular School No High 09 12 2017   grade_9                         98.0 94.0                       192.0                         98 94                 192
1295704 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No Elementary PK 01 2017   kindergarten                         98.0 90.0                       188.0                         98 90                 188
1296938 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000784 3061 Crestview Middle School   Regular School No Middle 06 08 2017   grade_7                         98.0 78.0                       176.0                         98 78                 176
1297496 IN     school 1807620 4255   Nineveh-Hensley-Jackson United 180762001303 3419 Indian Creek Sr High School   Regular School No High 09 12 2017   grade_10                         98.0 72.0                       170.0                         98 72                 170
1297542 IN     school 1812120 4335   Vincennes Community School Corp 181212001931 3553 Lincoln High School   Regular School No High 09 12 2017   grade_9                         98.0 78.0                       176.0                         98 78                 176
1298270 IN     school 1804170 4700   Griffith Public Schools 180417000721 4177 Griffith Middle School   Regular School No Middle 07 08 2017   grade_8                         98.0 77.0                       175.0                         98 77                 175
1300203 IN     school 1804770 5385   Indianapolis Public Schools 180477001446 5643 George Washington Community HS   Regular School No High 09 12 2017   grade_9                         98.0 71.0                       169.0                         98 71                 169
1303010 IN     school 1812870 7875   West Lafayette Com School Corp 181287002043 8138 Cumberland Elementary School   Regular School No Elementary KG 03 2017   kindergarten                         98.0 75.0                       173.0                         98 75                 173
1303212 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000471 8318 Helfrich Park STEM Academy   Regular School No Middle 06 08 2017   grade_8                         98.0 92.0                       190.0                         98 92                 190
1303870 IN     school 1809510 8385   Richmond Community Schools 180951001561 8997 Test Intermediate School   Regular School No Middle 05 08 2017   grade_7                         98.0 76.0                       174.0                         98 76                 174
1303874 IN     school 1809510 8385   Richmond Community Schools 180951001555 9001 Dennis Intermediate School   Regular School No Middle 05 08 2017   grade_6                         98.0 84.0                       182.0                         98 84                 182
1304044 IN     school 1811580 8565   Twin Lakes School Corp 181158001863 9149 Twin Lakes Senior High School   Regular School No High 09 12 2017   grade_10                         98.0 105.0                       203.0                         98 105                 203
1304046 IN     school 1811580 8565   Twin Lakes School Corp 181158001863 9149 Twin Lakes Senior High School   Regular School No High 09 12 2017   grade_12                         98.0 84.0                       182.0                         98 84                 182
1303722 IN     school 1812390 8130   Warrick County School Corp 181239001977 8809 Castle High School   Regular School No High 09 12 2017   pk_12_total 1714.0 36.0 54.0 3.0   58.0         83.0   976.0 972.0     9.0             231.0   1948.0 1714 36 54 3   58         83   976 972     9       231   1948
1293473 IN     school 1802850 255   East Allen County Schools 180285000354 301 New Haven Middle School   Regular School No Middle 06 08 2017   grade_8                         97.0 90.0                       187.0                         97 90                 187
1294376 IN     school 1812450 1405   Washington Community Schools 181245002007 1123 Washington Junior High School   Regular School No Middle 07 08 2017   grade_7                         97.0 89.0                       186.0                         97 89                 186
1296352 IN     school 1810360 3190   South Harrison Com Schools 181036002282 2640 Corydon Central High School   Regular School No High 09 12 2017   grade_9                         97.0 97.0                       194.0                         97 97                 194
1296566 IN     school 1802550 3325   Danville Community School Corp 180255000307 2745 South Elementary School   Regular School No Elementary 03 04 2017   grade_3                         97.0 93.0                       190.0                         97 93                 190
1296830 IN     school 1804470 3490   Western School Corporation 180447000755 2935 Western Primary School   Regular School No Elementary KG 03 2017   grade_2                         97.0 95.0                       192.0                         97 95                 192
1296832 IN     school 1804470 3490   Western School Corporation 180447000755 2935 Western Primary School   Regular School No Elementary KG 03 2017   kindergarten                         97.0 75.0                       172.0                         97 75                 172
1299776 IN     school 1804770 5385   Indianapolis Public Schools 180477000856 5494 John Marshall Community High Sch   Regular School No High 09 12 2017   grade_9                         97.0 77.0                       174.0                         97 77                 174
1299845 IN     school 1804770 5385   Indianapolis Public Schools 180477002605 5538 Center for Inquiry School 70   Regular School No Elementary KG 05 2017   pk_12_total 104.0 79.0 18.0     5.0         11.0   97.0 120.0     9.0             26.0   217.0 104 79 18     5         11   97 120     9       26   217
1300438 IN     school 1806090 5615   Maconaquah School Corp 180609001077 6035 Maconaquah Elementary School   Regular School No Elementary 02 05 2017   grade_5                         97.0 108.0                       205.0                         97 108                 205
1300756 IN     school 1802460 5855   Crawfordsville Community Schools 180246000290 6293 Laura Hose Elementary School   Regular School No Elementary KG 01 2017   grade_1                         97.0 98.0                       195.0                         97 98                 195
1301865 IN     school 1800390 6895   Batesville Community School Corp 180039000084 7217 Batesville High School   Regular School No High 09 12 2017   grade_11                         97.0 85.0                       182.0                         97 85                 182
1301875 IN     school 1800390 6895   Batesville Community School Corp 180039000085 7219 Batesville Middle School   Regular School No Middle 06 08 2017   grade_7                         97.0 67.0                       164.0                         97 67                 164
1303971 IN     school 1808220 8435   Northern Wells Community Schools 180822002159 9088 Norwell Middle School   Regular School No Middle 06 08 2017   grade_8                         97.0 97.0                       194.0                         97 97                 194
1304293 IN     school 1800143 9375   IN Math & Science Academy - South 180014302561 5671 IN Math & Science Academy - South   Regular School Yes Elementary KG 08 2017   pk_12_total 44.0 99.0 24.0               24.0   97.0 94.0     6.0             36.0   191.0 44 99 24               24   97 94     6       36   191
1304332 IN     school 1800145 9425   Tindley Genesis Academy 180014502595 5621 Tindley Genesis Academy   Regular School Yes Elementary KG 04 2017   pk_12_total 3.0 187.0 12.0               14.0   97.0 119.0     6.0             31.0   216.0 3 187 12               14   97 119     6       31   216
1295254 IN     school 1803930 2315   Goshen Community Schools 180393000654 1821 Goshen High School   Regular School No High 09 12 2017   pk_12_total 822.0 38.0 914.0 5.0   26.0     1.0   61.0   969.0 898.0     228.0             236.0   1867.0 822 38 914 5   26     1   61   969 898     228       236   1867
1293459 IN     school 1802850 255   East Allen County Schools 180285000954 291 Cedarville Elementary School   Regular School No Elementary KG 03 2017   grade_3                         96.0 77.0                       173.0                         96 77                 173
1294060 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No High 09 12 2017   grade_11                         96.0 85.0                       181.0                         96 85                 181
1294749 IN     school 1807320 1970   Muncie Community Schools 180732001252 1437 Southside Middle School   Regular School No Middle 06 08 2017   grade_8                         96.0 88.0                       184.0                         96 88                 184
1295821 IN     school 1800008 2980   White River Valley School District 180000802304 2457 White River Valley Middle School   Regular School No Middle 05 07 2017   pk_12_total 150.0 5.0 8.0 1.0   2.0     1.0   6.0   96.0 77.0     0.0             24.0   173.0 150 5 8 1   2     1   6   96 77     0       24   173
1296226 IN     school 1804050 3125   Greenfield-Central Com Schools 180405000699 2577 Maxwell Intermediate School   Regular School No Elementary 04 06 2017   grade_6                         96.0 84.0                       180.0                         96 84                 180
1296422 IN     school 1808100 3295   North West Hendricks Schools 180810001387 2731 Tri-West Senior High School   Regular School No High 09 12 2017   grade_10                         96.0 71.0                       167.0                         96 71                 167
1300437 IN     school 1806090 5615   Maconaquah School Corp 180609001077 6035 Maconaquah Elementary School   Regular School No Elementary 02 05 2017   grade_4                         96.0 85.0                       181.0                         96 85                 181
1301045 IN     school 1812900 6065   West Noble School Corporation 181290002058 6489 West Noble High School   Regular School No High 09 12 2017   grade_9                         96.0 88.0                       184.0                         96 88                 184
1302413 IN     school 1810020 7255   Scott County School District 2 181002001610 7637 Lexington Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 202.0   4.0               4.0   96.0 114.0     0.0             30.0   210.0 202   4               4   96 114     0       30   210
1302415 IN     school 1810020 7255   Scott County School District 2 181002001612 7641 Scottsburg Senior High School   Regular School No High 09 12 2017   grade_10                         96.0 93.0                       189.0                         96 93                 189
1302420 IN     school 1810020 7255   Scott County School District 2 181002001611 7645 Scottsburg Middle School   Regular School No Middle 06 08 2017   grade_6                         96.0 102.0                       198.0                         96 102                 198
1303004 IN     school 1812870 7875   West Lafayette Com School Corp 181287002045 8135 Happy Hollow Elementary   Regular School No Elementary 04 06 2017   grade_5                         96.0 92.0                       188.0                         96 92                 188
1304768 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes Other KG 12 2017   grade_4                         96.0 101.0                       197.0                         96 101                 197
1292932 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2017   grade_10                         95.0 85.0                       180.0                         95 85                 180
1293144 IN     school 1803630 235   Fort Wayne Community Schools 180363000546 127 Memorial Park Middle School   Regular School No Middle 06 08 2017   grade_6                         95.0 123.0                       218.0                         95 123                 218
1293149 IN     school 1803630 235   Fort Wayne Community Schools 180363000548 128 Miami Middle School   Regular School No Middle 06 08 2017   grade_7                         95.0 87.0                       182.0                         95 87                 182
1293480 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No Elementary PK 02 2017   grade_2                         95.0 96.0                       191.0                         95 96                 191
1294699 IN     school 1807230 1910   Yorktown Community Schools 180723001218 1387 Yorktown Middle School   Regular School No Middle 06 08 2017   grade_7                         95.0 102.0                       197.0                         95 102                 197
1295595 IN     school 1807770 2735   North Gibson School Corp 180777001327 2225 Princeton Community Middle   Regular School No Middle 06 08 2017   grade_7                         95.0 80.0                       175.0                         95 80                 175
1295710 IN     school 1806870 2855   Mississinewa Community School Corp 180687001191 2346 Northview Elementary School   Regular School No Elementary 02 05 2017   grade_5                         95.0 86.0                       181.0                         95 86                 181
1296721 IN     school 1807440 3445   New Castle Community School Corp 180744001289 2853 Sunnyside Elementary School   Regular School No Elementary KG 07 2017   pk_12_total 140.0 2.0 9.0               13.0   95.0 69.0     1.0             27.0   164.0 140 2 9               13   95 69     1       27   164
1300426 IN     school 1806090 5615   Maconaquah School Corp 180609001078 6032 Maconaquah High School   Regular School No High 09 12 2017   grade_10                         95.0 78.0                       173.0                         95 78                 173
1301058 IN     school 1812900 6065   West Noble School Corporation 181290002231 6510 West Noble Elementary School   Regular School No Elementary 02 04 2017   grade_4                         95.0 92.0                       187.0                         95 92                 187
1301071 IN     school 1809600 6080   Rising Sun-Ohio Co Com 180960002591 6512 Ohio County Middle School   Regular School No Middle 06 08 2017   pk_12_total 178.0 1.0 5.0     3.0         1.0   95.0 93.0     0.0             46.0   188.0 178 1 5     3         1   95 93     0       46   188
1302768 IN     school 1810860 7715   Southwest School Corporation 181086001770 7953 Carlisle Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 166.0 1.0 4.0               3.0   95.0 79.0     1.0             27.0   174.0 166 1 4               3   95 79     1       27   174
1304050 IN     school 1811580 8565   Twin Lakes School Corp 181158001862 9153 Roosevelt Middle School   Regular School No Middle 06 08 2017   grade_7                         95.0 76.0                       171.0                         95 76                 171
1304546 IN     school 1800058 9650   Herron Charter 180005802315 5724 Herron High School   Regular School Yes High 09 12 2017   grade_9                         95.0 137.0                       232.0                         95 137                 232
1304771 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes Other KG 12 2017   grade_7                         95.0 129.0                       224.0                         95 129                 224
1304931 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 06 2017   pk_12_total 172.0   2.0               6.0   95.0 85.0     1.0             39.0   180.0 172   2               6   95 85     1       39   180
1303363 IN     school 1812090 8030   Vigo County School Corp 181209001917 8441 Terre Haute North Vigo High School   Regular School No High 09 12 2017   pk_12_total 1522.0 109.0 68.0 4.0   13.0     2.0   136.0   945.0 909.0     10.0             337.0   1854.0 1522 109 68 4   13     2   136   945 909     10       337   1854
1303377 IN     school 1812090 8030   Vigo County School Corp 181209001918 8457 Terre Haute South Vigo High School   Regular School No High 09 12 2017   pk_12_total 1405.0 117.0 53.0 1.0   61.0     1.0   140.0   941.0 837.0     20.0             336.0   1778.0 1405 117 53 1   61     1   140   941 837     20       336   1778
1292934 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2017   grade_12                         94.0 88.0                       182.0                         94 88                 182
1293425 IN     school 1802850 255   East Allen County Schools 180285000348 53 Leo Elementary School   Regular School No Elementary 03 06 2017   grade_5                         94.0 109.0                       203.0                         94 109                 203
1294708 IN     school 1807230 1910   Yorktown Community Schools 180723001216 1393 Yorktown Elementary School   Regular School No Elementary 03 05 2017   grade_4                         94.0 92.0                       186.0                         94 92                 186
1294709 IN     school 1807230 1910   Yorktown Community Schools 180723001216 1393 Yorktown Elementary School   Regular School No Elementary 03 05 2017   grade_5                         94.0 98.0                       192.0                         94 98                 192

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