Data source: Big Local News · About: Big Local

12,062 rows where state = "IN" and year = 2016 sorted by total descending

View and edit SQL

grade

year

  • 2016 · 12,062
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
1283899 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002452 2500 Riverside Intermediate School   Regular School No 2.0 05 06 2016   pk_12_total 770.0 55.0 59.0 2.0   63.0         48.0   508.0 489.0     19.0             117.0   997.0 770 55 59 2   63         48   508 489     19       117   997
1285265 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189002094 3422 Clark Pleasant Intermediate School   Regular School No 2.0 05 06 2016   pk_12_total 788.0 37.0 51.0 5.0   56.0         59.0   529.0 467.0     23.0             137.0   996.0 788 37 51 5   56         59   529 467     23       137   996
1281415 IN     school 1802850 255   East Allen County Schools 180285000353 297 New Haven High School   Regular School No 3.0 09 12 2016   pk_12_total 535.0 288.0 90.0     29.0     1.0   51.0   522.0 472.0     28.0             158.0   994.0 535 288 90     29     1   51   522 472     28       158   994
1285966 IN     school 1802490 4660   Crown Point Community Sch Corp 180249000297 3761 Robert Taft Middle School   Regular School No 2.0 06 08 2016   pk_12_total 773.0 16.0 141.0 5.0   33.0     1.0   25.0   502.0 492.0     19.0             101.0   994.0 773 16 141 5   33     1   25   502 492     19       101   994
1285278 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189000245 3427 Clark Pleasant Middle School   Regular School No 2.0 07 08 2016   pk_12_total 800.0 22.0 52.0 3.0   58.0         58.0   531.0 462.0     34.0             147.0   993.0 800 22 52 3   58         58   531 462     34       147   993
1280858 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No 1.0 KG 05 2016   grade_3                         51.0 48.0                       99.0                         51 48                 99
1280909 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         49.0 50.0                       99.0                         49 50                 99
1281012 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No 1.0 PK 05 2016   grade_4                         54.0 45.0                       99.0                         54 45                 99
1281171 IN     school 1803630 235   Fort Wayne Community Schools 180363000529 162 Glenwood Park Elementary School   Regular School No 1.0 KG 05 2016   grade_1                         49.0 50.0                       99.0                         49 50                 99
1281174 IN     school 1803630 235   Fort Wayne Community Schools 180363000529 162 Glenwood Park Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         52.0 47.0                       99.0                         52 47                 99
1281178 IN     school 1803630 235   Fort Wayne Community Schools 180363000533 164 J Wilbur Haley Elementary School   Regular School No 1.0 PK 05 2016   grade_1                         56.0 43.0                       99.0                         56 43                 99
1281472 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No 1.0 PK 06 2016   grade_2                         64.0 35.0                       99.0                         64 35                 99
1281479 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No 1.0 PK 06 2016   pre_kindergarten                         58.0 41.0                       99.0                         58 41                 99
1281686 IN     school 1802830 630   Zionsville Community Schools 180283000340 541 Union Elementary School   Regular School No 1.0 PK 04 2016   grade_1                         51.0 48.0                       99.0                         51 48                 99
1281804 IN     school 1802700 755   Delphi Community School Corp 180270000328 641 Delphi Community Elementary School   Regular School No 1.0 PK 05 2016   grade_3                         52.0 47.0                       99.0                         52 47                 99
1281898 IN     school 1809370 940   West Clark Community Schools 180937001530 767 Henryville Elementary School   Regular School No 1.0 PK 06 2016   kindergarten                         57.0 42.0                       99.0                         57 42                 99
1282095 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative Education School No 4.0 06 12 2016   pk_12_total 52.0 20.0 11.0 1.0             15.0   56.0 43.0     1.0             3.0   99.0 52 20 11 1             15   56 43     1       3   99
1282307 IN     school 1807710 1375   North Daviess Com Schools 180771001648 1090 North Daviess Elementary School   Regular School No 1.0 PK 06 2016   grade_1                         58.0 41.0                       99.0                         58 41                 99
1282636 IN     school 1805880 1895   Liberty-Perry Com School Corp 180588001046 1377 Selma Middle School   Regular School No 2.0 06 08 2016   grade_6                         49.0 50.0                       99.0                         49 50                 99
1282848 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001236 1590 Huntingburg Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         49.0 50.0                       99.0                         49 50                 99
1283013 IN     school 1812240 2285   Wa-Nee Community Schools 181224000028 1735 Wakarusa Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         49.0 50.0                       99.0                         49 50                 99
1283171 IN     school 1803270 2305   Elkhart Community Schools 180327000444 1801 Roosevelt Elementary School   Regular School No 1.0 PK 06 2016   grade_2                         52.0 47.0                       99.0                         52 47                 99
1283627 IN     school 1806240 2825   Madison-Grant United Sch Corp 180624001097 2321 Madison-Grant High School   Regular School No 3.0 09 12 2016   grade_12                         47.0 52.0                       99.0                         47 52                 99
1283737 IN     school 1803090 2940   Eastern Greene Schools 180309002419 2436 Eastern Greene Middle School   Regular School No 2.0 05 08 2016   grade_8                         56.0 43.0                       99.0                         56 43                 99
1284126 IN     school 1807650 3070   Noblesville Schools 180765002414 2537 Noble Crossing Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         55.0 44.0                       99.0                         55 44                 99
1284308 IN     school 1800690 3180   North Harrison Com School Corp 180069000143 2633 North Harrison Elementary Sch   Regular School No 1.0 KG 05 2016   grade_5                         50.0 49.0                       99.0                         50 49                 99
1284391 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102000994 2706 Brown Elementary School   Regular School No 1.0 KG 05 2016   grade_3                         44.0 55.0                       99.0                         44 55                 99
1284434 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102001671 2723 White Lick Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         52.0 47.0                       99.0                         52 47                 99
1284631 IN     school 1808280 3435   Shenandoah School Corporation 180828002356 2815 Shenandoah Elementary School   Regular School No 1.0 PK 05 2016   grade_4                         48.0 51.0                       99.0                         48 51                 99
1284636 IN     school 1808280 3435   Shenandoah School Corporation 180828001420 2817 Shenandoah High School   Regular School No 3.0 09 12 2016   grade_10                         57.0 42.0                       99.0                         57 42                 99
1284704 IN     school 1801060 3455   C A Beard Memorial School Corp 180106000189 2869 Knightstown High School   Regular School No 3.0 09 12 2016   grade_12                         50.0 49.0                       99.0                         50 49                 99
1284744 IN     school 1802040 3470   Northwestern School Corp 180204000254 2904 Northwestern Elementary Sch   Regular School No 1.0 KG 06 2016   grade_4                         62.0 37.0                       99.0                         62 37                 99
1284802 IN     school 1805370 3500   Kokomo School Corporation 180537000959 2943 Sycamore Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         49.0 50.0                       99.0                         49 50                 99
1285063 IN     school 1809420 3815   Rensselaer Central School Corp 180942001542 3213 Rensselaer Central Primary School   Regular School No 1.0 PK 05 2016   grade_2                         58.0 41.0                       99.0                         58 41                 99
1285182 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080001766 3341 Southwestern Elementary Sch   Regular School No 1.0 PK 05 2016   grade_1                         50.0 49.0                       99.0                         50 49                 99
1285331 IN     school 1801440 4205   Center Grove Com Sch Corp 180144002333 3444 Pleasant Grove Elementary School   Regular School No 1.0 KG 05 2016   grade_1                         49.0 50.0                       99.0                         49 50                 99
1285439 IN     school 1807620 4255   Nineveh-Hensley-Jackson United 180762001306 3409 Indian Creek Elementary School   Regular School No 1.0 KG 03 2016   kindergarten                         56.0 43.0                       99.0                         56 43                 99
1285902 IN     school 1805450 4615   Lake Central School Corp 180545000986 4351 Peifer Elementary School   Regular School No 1.0 PK 04 2016   grade_3                         50.0 49.0                       99.0                         50 49                 99
1285947 IN     school 1805460 4650   Lake Ridge New Tech Schools 180546000993 3885 Longfellow New Tech Elementary Sch   Regular School No 1.0 KG 05 2016   grade_3                         54.0 45.0                       99.0                         54 45                 99
1286058 IN     school 1802880 4670   School City of East Chicago 180288000375 3953 William McKinley Elementary School   Regular School No 1.0 PK 06 2016   grade_2                         46.0 53.0                       99.0                         46 53                 99
1286074 IN     school 1802880 4670   School City of East Chicago 180288000368 3961 George Washington Elementary Sch   Regular School No 1.0 PK 06 2016   pre_kindergarten                         53.0 46.0                       99.0                         53 46                 99
1286479 IN     school 1807350 4740   School Town of Munster 180735001255 4337 James B Eads Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         44.0 55.0                       99.0                         44 55                 99
1286498 IN     school 1813200 4760   School City of Whiting 181320002082 4353 Whiting High School   Regular School No 3.0 09 12 2016   grade_11                         59.0 40.0                       99.0                         59 40                 99
1286872 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002418 5012 Lapel Middle School   Regular School No 2.0 06 08 2016   grade_7                         60.0 39.0                       99.0                         60 39                 99
1286980 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         50.0 49.0                       99.0                         50 49                 99
1287015 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No 1.0 01 06 2016   grade_6                         52.0 47.0                       99.0                         52 47                 99
1287050 IN     school 1802640 5300   M S D Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No 1.0 01 06 2016   grade_4                         49.0 50.0                       99.0                         49 50                 99
1287185 IN     school 1805670 5330   M S D Lawrence Township 180567002114 5295 Winding Ridge Elementary School   Regular School No 1.0 01 06 2016   grade_2                         50.0 49.0                       99.0                         50 49                 99
1287368 IN     school 1808910 5350   M S D Pike Township 180891002250 5358 Eagle Creek Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         53.0 46.0                       99.0                         53 46                 99
1287460 IN     school 1812360 5360   M S D Warren Township 181236001971 5389 Sunny Heights Elementary School   Regular School No 1.0 KG 04 2016   kindergarten                         53.0 46.0                       99.0                         53 46                 99
1287517 IN     school 1812720 5370   M S D Washington Township 181272002020 5427 Nora Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         58.0 41.0                       99.0                         58 41                 99
1287564 IN     school 1812810 5375   M S D Wayne Township 181281002034 5223 Maplewood Elementary School   Regular School No 1.0 PK 06 2016   grade_1                         52.0 47.0                       99.0                         52 47                 99
1287602 IN     school 1812810 5375   M S D Wayne Township 181281002036 5261 Rhoades Elementary School   Regular School No 1.0 PK 06 2016   grade_5                         48.0 51.0                       99.0                         48 51                 99
1287934 IN     school 1804770 5385   Indianapolis Public Schools 180477000901 5560 William A Bell Reggio Acad Sch 60   Regular School No 1.0 PK 05 2016   grade_1                         51.0 48.0                       99.0                         51 48                 99
1288749 IN     school 1804140 5900   Monroe-Gregg School District 180414000715 6323 Monrovia Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         55.0 44.0                       99.0                         55 44                 99
1289194 IN     school 1811260 6350   Tell City-Troy Twp School Corp 181126001819 6741 Tell City Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_8                         63.0 36.0                       99.0                         63 36                 99
1289305 IN     school 1802800 6470   Duneland School Corporation 180280000335 6823 Liberty Elementary School   Regular School No 1.0 KG 04 2016   kindergarten                         58.0 41.0                       99.0                         58 41                 99
1289626 IN     school 1807110 6620   Eastern Pulaski Com Sch Corp 180711001205 6997 Winamac Community High School   Regular School No 3.0 09 12 2016   grade_9                         50.0 49.0                       99.0                         50 49                 99
1289831 IN     school 1810530 6865   South Ripley Com Sch Corp 181053002380 7178 South Ripley Elementary School   Regular School No 1.0 KG 06 2016   grade_6                         42.0 57.0                       99.0                         42 57                 99
1290001 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001442 7361 Elm Road Elementary School   Regular School No 1.0 PK 05 2016   grade_1                         53.0 46.0                       99.0                         53 46                 99
1290055 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001148 7390 Northpoint Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         64.0 35.0                       99.0                         64 35                 99
1290280 IN     school 1810290 7205   South Bend Community Sch Corp 181029001672 7577 Marquette Montessori Academy   Regular School No 1.0 PK 03 2016   pre_kindergarten                         54.0 45.0                       99.0                         54 45                 99
1290574 IN     school 1810560 7445   South Spencer County Sch Corp 181056001733 7795 South Spencer High School   Regular School No 3.0 09 12 2016   grade_10                         60.0 39.0                       99.0                         60 39                 99
1290753 IN     school 1810860 7715   Southwest School Corp 181086002359 7961 Sullivan Middle School   Regular School No 2.0 06 08 2016   grade_7                         47.0 52.0                       99.0                         47 52                 99
1290818 IN     school 1805400 7855   Lafayette School Corporation 180540000971 8103 Miami Elementary School   Regular School No 1.0 KG 04 2016   grade_1                         57.0 42.0                       99.0                         57 42                 99
1290844 IN     school 1805400 7855   Lafayette School Corporation 180540000978 8117 Vinton Elementary School   Regular School No 1.0 KG 04 2016   grade_3                         51.0 48.0                       99.0                         51 48                 99
1291189 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000483 8321 Stockwell Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         53.0 46.0                       99.0                         53 46                 99
1291448 IN     school 1812090 8030   Vigo County School Corp 181209001909 8549 Lost Creek Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         47.0 52.0                       99.0                         47 52                 99
1291690 IN     school 1812390 8130   Warrick County School Corp 181239001985 8801 Oakdale Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         52.0 47.0                       99.0                         52 47                 99
1291772 IN     school 1807380 8305   Nettle Creek School Corp 180738001261 8985 Hagerstown Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_8                         50.0 49.0                       99.0                         50 49                 99
1291833 IN     school 1808190 8375   Northeastern Wayne Schools 180819002567 8929 Northeastern Middle School   Regular School No 2.0 06 08 2016   grade_6                         51.0 48.0                       99.0                         51 48                 99
1291857 IN     school 1809510 8385   Richmond Community Schools 180951001553 9013 Charles Elementary School   Regular School No 1.0 PK 04 2016   kindergarten                         56.0 43.0                       99.0                         56 43                 99
1292327 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes 4.0 KG 12 2016   kindergarten                         46.0 53.0                       99.0                         46 53                 99
1292367 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes 4.0 KG 12 2016   grade_1                         49.0 50.0                       99.0                         49 50                 99
1283799 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001866 2466 Brooks School Elementary   Regular School No 1.0 PK 04 2016   pk_12_total 729.0 83.0 61.0 2.0   58.0         55.0   523.0 465.0     21.0             260.0   988.0 729 83 61 2   58         55   523 465     21       260   988
1285885 IN     school 1805450 4615   Lake Central School Corp 180545000982 3841 Kahler Middle School   Regular School No 2.0 05 08 2016   pk_12_total 707.0 44.0 169.0 5.0   45.0         15.0   523.0 462.0     23.0             121.0   985.0 707 44 169 5   45         15   523 462     23       121   985
1289323 IN     school 1802800 6470   Duneland School Corporation 180280001624 6930 Chesterton Middle School   Regular School No 2.0 07 08 2016   pk_12_total 831.0 21.0 99.0 2.0   8.0         24.0   512.0 473.0     4.0             172.0   985.0 831 21 99 2   8         24   512 473     4       172   985
1287550 IN     school 1812720 5370   M S D Washington Township 181272002021 5451 North Central High School   Regular School No 3.0 09 12 2016   grade_9                         478.0 505.0                       983.0                         478 505                 983
1280908 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         53.0 45.0                       98.0                         53 45                 98
1281106 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         46.0 52.0                       98.0                         46 52                 98
1281152 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         49.0 49.0                       98.0                         49 49                 98
1281257 IN     school 1803630 235   Fort Wayne Community Schools 180363000551 217 Northcrest Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         55.0 43.0                       98.0                         55 43                 98
1281626 IN     school 1800570 515   Blackford County Schools 180057000126 501 Southside Elementary School   Regular School No 1.0 KG 03 2016   grade_3                         52.0 46.0                       98.0                         52 46                 98
1281803 IN     school 1802700 755   Delphi Community School Corp 180270000328 641 Delphi Community Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         48.0 50.0                       98.0                         48 50                 98
1281837 IN     school 1810680 815   Southeastern School Corp 181068002169 695 Thompson Elementary School   Regular School No 1.0 KG 03 2016   grade_2                         50.0 48.0                       98.0                         50 48                 98
1281937 IN     school 1801920 1000   Clarksville Com School Corp 180192000249 833 Clarksville Senior High School   Regular School No 3.0 09 12 2016   grade_11                         54.0 44.0                       98.0                         54 44                 98
1282186 IN     school 1802160 1160   Clinton Prairie School Corp 180216000258 977 Clinton Prairie Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_8                         45.0 53.0                       98.0                         45 53                 98
1282217 IN     school 1803660 1170   Community Schools of Frankfort 180366000602 1020 Suncrest Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         46.0 52.0                       98.0                         46 52                 98
1282377 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119000371 1193 Bright Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         49.0 49.0                       98.0                         49 49                 98
1282508 IN     school 1803060 1805   DeKalb Co Eastern Com Sch Dist 180306000405 1317 Eastside Junior-Senior High School   Regular School No 3.0 07 12 2016   grade_11                         46.0 52.0                       98.0                         46 52                 98
1282585 IN     school 1802660 1875   Delaware Community School Corp 180266000324 1365 Royerton Elementary School   Regular School No 1.0 KG 05 2016   grade_1                         51.0 47.0                       98.0                         51 47                 98
1283147 IN     school 1803270 2305   Elkhart Community Schools 180327000441 1785 Pinewood Elementary School   Regular School No 1.0 KG 06 2016   grade_2                         47.0 51.0                       98.0                         47 51                 98
1283749 IN     school 1805910 2950   Linton-Stockton School Corp 180591001048 2441 Linton-Stockton Elementary   Regular School No 1.0 KG 05 2016   grade_2                         47.0 51.0                       98.0                         47 51                 98
1283936 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No 1.0 PK 04 2016   grade_3                         55.0 43.0                       98.0                         55 43                 98
1284024 IN     school 1801200 3060   Carmel Clay Schools 180120000196 2510 College Wood Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         52.0 46.0                       98.0                         52 46                 98
1284056 IN     school 1801200 3060   Carmel Clay Schools 180120000198 2516 Mohawk Trails Elementary School   Regular School No 1.0 KG 05 2016   grade_3                         60.0 38.0                       98.0                         60 38                 98
1284062 IN     school 1801200 3060   Carmel Clay Schools 180120002101 2518 Forest Dale Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         47.0 51.0                       98.0                         47 51                 98
1284119 IN     school 1807650 3070   Noblesville Schools 180765001312 2533 Stony Creek Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         50.0 48.0                       98.0                         50 48                 98
1284240 IN     school 1807260 3135   Mt Vernon Community Sch Corp 180726001220 2561 Mt Comfort Elementary School   Regular School No 1.0 PK 05 2016   grade_4                         52.0 46.0                       98.0                         52 46                 98
1284435 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102001671 2723 White Lick Elementary School   Regular School No 1.0 KG 05 2016   grade_3                         59.0 39.0                       98.0                         59 39                 98

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