enrollments

Data source: Big Local News · About: Big Local

12,019 rows where state = "IN" and year = 2018 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2018 · 11,919 ✖
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
1797897 1797897 IN     school 1812180 8050   M S D Wabash County Schools 181218002178 8657 Sharp Creek Elementary School   Regular School No Middle 03 07 2018   grade_7                         1.0 0.0                       1.0                         1 0                 1
1797910 1797910 IN     school 1812180 8050   M S D Wabash County Schools 181218001944 8677 Metro North Elementary School   Regular School No Elementary KG 04 2018   grade_4                         1.0 0.0                       1.0                         1 0                 1
1798336 1798336 IN     school 1803810 8525   Frontier School Corporation 180381000603 9137 Frontier Jr-Sr High School   Regular School No High 07 12 2018   adult                         0.0 1.0                       1.0                         0 1                 1
1798497 1798497 IN     school 1800185 9055   Excel Center - Hammond 180018502624 2018 Excel Center - Hammond   Regular School Yes Secondary 10 11 2018   grade_10                         1.0 0.0                       1.0                         1 0                 1
1798617 1798617 IN     school 1800135 9355   Excel Center - Kokomo 180013502553 2976 Excel Center - Kokomo   Regular School Yes High 10 12 2018   grade_10                         0.0 1.0                       1.0                         0 1                 1
1799072 1799072 IN     school 1800159 9840   Excel Center - University Heights 180015902592 5749 Excel Center - University Heights   Regular School Yes High 09 12 2018   grade_9                         0.0 1.0                       1.0                         0 1                 1
1799213 1799213 IN     school 1800136 9930   Nexus Academy of Indianapolis 180013602552 5302 Nexus Academy of Indianapolis   Regular School Yes High 09 12 2018   grade_9                         1.0 0.0                       1.0                         1 0                 1
1799302 1799302 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes High 10 12 2018   grade_10                         1.0 0.0                       1.0                         1 0                 1
1789907 1789907 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No Elementary KG 06 2018   grade_2                         3.0 7.0                       10.0                         3 7                 10
1790661 1790661 IN     school 1803120 3145   Eastern Hancock Co Com Sch Corp 180312000409 2586 Eastern Hancock Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         9.0 1.0                       10.0                         9 1                 10
1791410 1791410 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000182 3129 Brownstown Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         9.0 1.0                       10.0                         9 1                 10
1794973 1794973 IN     school 1800630 5740   Monroe County Community Sch Corp 180063002498 6220 Bloomington Graduation School   Regular School No High 09 12 2018   grade_11                         2.0 8.0                       10.0                         2 8                 10
1795356 1795356 IN     school 1802970 6060   East Noble School Corporation 180297000394 6485 Wayne Center Elem School   Regular School No Elementary PK 06 2018   pre_kindergarten                         6.0 4.0                       10.0                         6 4                 10
1795598 1795598 IN     school 1808900 6445   Pike County School Corp 180890001483 6808 Winslow Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         5.0 5.0                       10.0                         5 5                 10
1796191 1796191 IN     school 1800390 6895   Batesville Community School Corp 180039002381 7218 Batesville Primary School   Regular School No Elementary PK 02 2018   pre_kindergarten                         8.0 2.0                       10.0                         8 2                 10
1797468 1797468 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2018   grade_6                         8.0 2.0                       10.0                         8 2                 10
1798039 1798039 IN     school 1812390 8130   Warrick County School Corp 181239001977 8809 Castle High School   Regular School No High 09 12 2018   adult                         9.0 1.0                       10.0                         9 1                 10
1799040 1799040 IN     school 1800074 9795   Dr Robert H Faulkner Academy 180007402426 2411 Dr Robert H Faulkner Academy   Regular School Yes Elementary KG 06 2018   grade_3                         7.0 3.0                       10.0                         7 3                 10
1799051 1799051 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes Other KG 12 2018   grade_3                         8.0 2.0                       10.0                         8 2                 10
1799184 1799184 IN     school 1800160 9915   Marion Academy 180016002588 5903 Marion Academy   Regular School Yes High 06 12 2018   grade_7                         7.0 3.0                       10.0                         7 3                 10
1787311 1787311 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 05 08 2018   grade_6                         49.0 51.0                       100.0                         49 51                 100
1788124 1788124 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No Elementary PK 04 2018   grade_2                         53.0 47.0                       100.0                         53 47                 100
1788880 1788880 IN     school 1802610 1655   Decatur County Community Schools 180261000309 1267 North Decatur Jr-Sr High School   Regular School No High 07 12 2018   grade_9                         50.0 50.0                       100.0                         50 50                 100
1788958 1788958 IN     school 1801590 1835   DeKalb Co Ctl United Sch Dist 180159000222 1351 James R Watson Elementary School   Regular School No Elementary PK 05 2018   grade_1                         50.0 50.0                       100.0                         50 50                 100
1788983 1788983 IN     school 1802660 1875   Delaware Community School Corp 180266000324 1365 Royerton Elementary School   Regular School No Elementary KG 05 2018   grade_2                         43.0 57.0                       100.0                         43 57                 100
1789203 1789203 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064001745 1583 Forest Park Jr-Sr High School   Regular School No High 07 12 2018   grade_7                         51.0 49.0                       100.0                         51 49                 100
1789325 1789325 IN     school 1802400 2270   Concord Community Schools 180240000270 1721 Concord East Side Elementary Sch   Regular School No Elementary KG 04 2018   grade_2                         50.0 50.0                       100.0                         50 50                 100
1789581 1789581 IN     school 1803930 2315   Goshen Community Schools 180393000656 1633 Model Elementary School   Regular School No Elementary KG 05 2018   grade_4                         53.0 47.0                       100.0                         53 47                 100
1789703 1789703 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001267 1929 Georgetown Elementary School   Regular School No Elementary KG 04 2018   grade_3                         51.0 49.0                       100.0                         51 49                 100
1790110 1790110 IN     school 1803090 2940   Eastern Greene Schools 180309000407 2433 Eastern Greene Elementary School   Regular School No Elementary PK 04 2018   grade_2                         54.0 46.0                       100.0                         54 46                 100
1790211 1790211 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001750 2473 Fall Creek Elementary School   Regular School No Elementary KG 04 2018   kindergarten                         48.0 52.0                       100.0                         48 52                 100
1790441 1790441 IN     school 1801200 3060   Carmel Clay Schools 180120000198 2516 Mohawk Trails Elementary School   Regular School No Elementary KG 05 2018   grade_3                         51.0 49.0                       100.0                         51 49                 100
1790446 1790446 IN     school 1801200 3060   Carmel Clay Schools 180120002101 2518 Forest Dale Elementary School   Regular School No Elementary PK 05 2018   grade_1                         50.0 50.0                       100.0                         50 50                 100
1790555 1790555 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001760 2564 New Palestine Elementary School   Regular School No Elementary PK 06 2018   grade_6                         55.0 45.0                       100.0                         55 45                 100
1790871 1790871 IN     school 1800270 3315   Avon Community School Corp 180027000390 2735 Sycamore Elementary School   Regular School No Elementary KG 04 2018   grade_4                         53.0 47.0                       100.0                         53 47                 100
1791115 1791115 IN     school 1811250 3460   Taylor Community School Corp 181125001812 2895 Taylor Elementary School   Regular School No Elementary PK 05 2018   grade_2                         54.0 46.0                       100.0                         54 46                 100
1791116 1791116 IN     school 1811250 3460   Taylor Community School Corp 181125001812 2895 Taylor Elementary School   Regular School No Elementary PK 05 2018   grade_3                         46.0 54.0                       100.0                         46 54                 100
1791738 1791738 IN     school 1801440 4205   Center Grove Community School Corp 180144002333 3444 Pleasant Grove Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         53.0 47.0                       100.0                         53 47                 100
1791861 1791861 IN     school 1807830 4315   North Knox School Corp 180783001334 3537 North Knox Jr-Sr High School   Regular School No High 07 12 2018   grade_10                         49.0 51.0                       100.0                         49 51                 100
1791871 1791871 IN     school 1807830 4315   North Knox School Corp 180783001335 3545 North Knox Intermediate   Regular School No Elementary 03 06 2018   grade_6                         52.0 48.0                       100.0                         52 48                 100
1792093 1792093 IN     school 1809300 4515   Prairie Heights Community Sch Corp 180930001525 3688 Prairie Heights Middle School   Regular School No Middle 05 08 2018   grade_7                         65.0 35.0                       100.0                         65 35                 100
1792476 1792476 IN     school 1802910 4680   Lake Station Community Schools 180291000380 3965 Thomas A Edison Jr-Sr HS   Regular School No High 06 12 2018   grade_10                         59.0 41.0                       100.0                         59 41                 100
1792516 1792516 IN     school 1803870 4690   Gary Community School Corp 180387000615 4061 Beveridge Elementary School   Regular School No Elementary KG 06 2018   kindergarten                         62.0 38.0                       100.0                         62 38                 100
1792640 1792640 IN     school 1804320 4710   School City of Hammond 180432002413 4422 Joseph Hess Elementary School   Regular School No Elementary PK 05 2018   grade_2                         59.0 41.0                       100.0                         59 41                 100
1792719 1792719 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2018   grade_4                         58.0 42.0                       100.0                         58 42                 100
1793078 1793078 IN     school 1805580 4945   LaPorte Community School Corp 180558001009 4753 F Willard Crichfield Elementary   Regular School No Elementary PK 05 2018   grade_4                         54.0 46.0                       100.0                         54 46                 100
1793274 1793274 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2018   grade_11                         46.0 54.0                       100.0                         46 54                 100
1793282 1793282 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2018   grade_5                         49.0 51.0                       100.0                         49 51                 100
1793334 1793334 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 05 2018   grade_1                         51.0 49.0                       100.0                         51 49                 100
1793354 1793354 IN     school 1803300 5280   Elwood Community School Corp 180330000449 5149 Elwood Jr-Sr High School   Regular School No High 07 12 2018   grade_9                         51.0 49.0                       100.0                         51 49                 100
1793451 1793451 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002349 5200 Mary Adams Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         54.0 46.0                       100.0                         54 46                 100
1793563 1793563 IN     school 1805670 5330   M S D Lawrence Township 180567001033 5296 Oaklandon Elementary School   Regular School No Elementary 01 06 2018   grade_5                         47.0 53.0                       100.0                         47 53                 100
1793737 1793737 IN     school 1808910 5350   M S D Pike Township 180891001485 5359 Eastbrook Elementary School   Regular School No Elementary KG 05 2018   grade_1                         51.0 49.0                       100.0                         51 49                 100
1793806 1793806 IN     school 1812360 5360   M S D Warren Township 181236001966 5375 Lakeside Elementary School   Regular School No Elementary KG 04 2018   kindergarten                         49.0 51.0                       100.0                         49 51                 100
1793860 1793860 IN     school 1812720 5370   M S D Washington Township 181272002255 5406 Crooked Creek Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         51.0 49.0                       100.0                         51 49                 100
1793877 1793877 IN     school 1812720 5370   M S D Washington Township 181272002020 5427 Nora Elementary School   Regular School No Elementary KG 05 2018   grade_2                         50.0 50.0                       100.0                         50 50                 100
1793973 1793973 IN     school 1812810 5375   M S D Wayne Township 181281002037 5265 Robey Elementary School   Regular School No Elementary KG 06 2018   grade_2                         49.0 51.0                       100.0                         49 51                 100
1794343 1794343 IN     school 1804770 5385   Indianapolis Public Schools 180477000808 5579 Carl Wilde School 79   Regular School No Elementary PK 06 2018   grade_3                         49.0 51.0                       100.0                         49 51                 100
1794993 1794993 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000138 6226 University Elementary School   Regular School No Elementary PK 06 2018   grade_5                         52.0 48.0                       100.0                         52 48                 100
1795261 1795261 IN     school 1807920 5945   North Newton School Corp 180792001363 6411 North Newton Jr-Sr High School   Regular School No High 07 12 2018   grade_9                         50.0 50.0                       100.0                         50 50                 100
1795416 1795416 IN     school 1808640 6155   Paoli Community School Corp 180864001439 6587 Throop Elementary School   Regular School No Elementary KG 06 2018   grade_2                         51.0 49.0                       100.0                         51 49                 100
1795737 1795737 IN     school 1811700 6530   Union Township School Corp 181170000793 6843 Union Township Middle School   Regular School No Middle 06 08 2018   grade_6                         54.0 46.0                       100.0                         54 46                 100
1796008 1796008 IN     school 1810500 6705   South Putnam Community Schools 181050001726 7071 South Putnam High School   Regular School No High 09 12 2018   grade_9                         57.0 43.0                       100.0                         57 43                 100
1796107 1796107 IN     school 1807080 6820   Monroe Central School Corp 180708001202 7151 Monroe Central Jr-Sr High School   Regular School No High 07 12 2018   grade_11                         57.0 43.0                       100.0                         57 43                 100
1796129 1796129 IN     school 1801770 6825   Randolph Central School Corp 180177000235 7129 Lee L Driver Middle School   Regular School No Middle 06 08 2018   grade_8                         51.0 49.0                       100.0                         51 49                 100
1796176 1796176 IN     school 1810530 6865   South Ripley Com Sch Corp 181053001729 7182 South Ripley High School   Regular School No High 09 12 2018   grade_10                         51.0 49.0                       100.0                         51 49                 100
1796348 1796348 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001442 7361 Elm Road Elementary School   Regular School No Elementary PK 05 2018   grade_5                         57.0 43.0                       100.0                         57 43                 100
1796526 1796526 IN     school 1810290 7205   South Bend Community School Corp 181029001645 7510 Jackson Middle School   Regular School No Middle 05 08 2018   grade_8                         62.0 38.0                       100.0                         62 38                 100
1796568 1796568 IN     school 1810290 7205   South Bend Community School Corp 181029001646 7545 Harrison Elementary School   Regular School No Elementary PK 04 2018   kindergarten                         51.0 49.0                       100.0                         51 49                 100
1796588 1796588 IN     school 1810290 7205   South Bend Community School Corp 181029001667 7557 Lafayette Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pk_12_total 11.0 45.0 32.0     1.0         11.0   66.0 34.0     0.0         82.0   27.0   100.0 11 45 32     1         11   66 34     0     82 27   100
1796589 1796589 IN     school 1810290 7205   South Bend Community School Corp 181029001667 7557 Lafayette Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                         66.0 34.0                       100.0                         66 34                 100
1796796 1796796 IN     school 1808310 7350   Northwestern Con School Corp 180831001425 7697 Triton Central Middle School   Regular School No Middle 05 08 2018   grade_6                         55.0 45.0                       100.0                         55 45                 100
1796856 1796856 IN     school 1810140 7365   Shelbyville Central Schools 181014001633 7733 William F Loper Elementary School   Regular School No Elementary PK 05 2018   grade_2                         54.0 46.0                       100.0                         54 46                 100
1796949 1796949 IN     school 1807800 7515   North Judson-San Pierre Sch Corp 180780001330 7849 N Judson-San Pierre Jr Sr High Sch   Regular School No High 07 12 2018   grade_10                         43.0 57.0                       100.0                         43 57                 100
1797121 1797121 IN     school 1811220 7775   Switzerland County School Corp 181122001811 7993 Switzerland Co Senior High School   Regular School No High 09 12 2018   grade_11                         55.0 45.0                       100.0                         55 45                 100
1797208 1797208 IN     school 1811340 7865   Tippecanoe School Corp 181134001829 8005 Mayflower Mill Elementary School   Regular School No Elementary KG 05 2018   grade_4                         45.0 55.0                       100.0                         45 55                 100
1797344 1797344 IN     school 1811400 7945   Tipton Community School Corp 181140001844 8163 Tipton Elementary School   Regular School No Elementary PK 05 2018   grade_1                         54.0 46.0                       100.0                         54 46                 100
1797388 1797388 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000460 8225 Cynthia Heights Elementary School   Regular School No Elementary KG 05 2018   grade_5                         55.0 45.0                       100.0                         55 45                 100
1797829 1797829 IN     school 1812090 8030   Vigo County School Corp 181209001919 8607 Terre Town Elementary School   Regular School No Elementary KG 05 2018   grade_5                         52.0 48.0                       100.0                         52 48                 100
1797915 1797915 IN     school 1812150 8060   Wabash City Schools 181215001940 8693 Wabash High School   Regular School No High 09 12 2018   grade_12                         48.0 52.0                       100.0                         48 52                 100
1798168 1798168 IN     school 1808190 8375   Northeastern Wayne Schools 180819001406 8927 Northeastern High School   Regular School No High 09 12 2018   grade_11                         54.0 46.0                       100.0                         54 46                 100
1798172 1798172 IN     school 1808190 8375   Northeastern Wayne Schools 180819002228 8928 Northeastern Elementary School   Regular School No Elementary PK 05 2018   grade_1                         57.0 43.0                       100.0                         57 43                 100
1798499 1798499 IN     school 1800185 9055   Excel Center - Hammond 180018502624 2018 Excel Center - Hammond   Regular School Yes Secondary 10 11 2018   pk_12_total 25.0 36.0 35.0               4.0   34.0 66.0     2.0         74.0   2.0   100.0 25 36 35               4   34 66     2     74 2   100
1798661 1798661 IN     school 1800147 9410   KIPP Indy Unite Elementary 180014702571 5741 KIPP Indy Unite Elementary   Regular School Yes Elementary KG 03 2018   grade_2                         55.0 45.0                       100.0                         55 45                 100
1798746 1798746 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes Other KG 12 2018   grade_3                         42.0 58.0                       100.0                         42 58                 100
1799259 1799259 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 05 2018   grade_2                         56.0 44.0                       100.0                         56 44                 100
1799266 1799266 IN     school 1800164 9965   Career Academy Middle School 180016402593 7563 Career Academy Middle School   Regular School Yes Middle 06 08 2018   grade_7                         53.0 47.0                       100.0                         53 47                 100
1792298 1792298 IN     school 1805450 4615   Lake Central School Corporation 180545000982 3841 Kahler Middle School   Regular School No Middle 05 08 2018   pk_12_total 683.0 51.0 201.0 2.0   43.0         21.0   525.0 476.0     14.0         225.0   113.0   1001.0 683 51 201 2   43         21   525 476     14     225 113   1001
1791364 1791364 IN     school 1810080 3675   Seymour Community Schools 181008002214 3138 Seymour Middle School   Regular School No Middle 06 08 2018   pk_12_total 658.0 8.0 281.0 2.0   22.0     1.0   32.0   532.0 472.0     128.0         598.0   173.0   1004.0 658 8 281 2   22     1   32   532 472     128     598 173   1004
1793919 1793919 IN     school 1812810 5375   M S D Wayne Township 181281002028 5213 Ben Davis High School   Regular School No High 10 12 2018   grade_12                         498.0 506.0                       1004.0                         498 506                 1004
1788142 1788142 IN     school 1805790 665   Lebanon Community School Corp 180579001041 553 Lebanon Senior High School   Regular School No High 09 12 2018   pk_12_total 887.0 24.0 60.0 1.0   12.0         25.0   544.0 465.0     2.0         359.0   178.0   1009.0 887 24 60 1   12         25   544 465     2     359 178   1009
1787291 1787291 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   grade_1                         59.0 42.0                       101.0                         59 42                 101
1787294 1787294 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   grade_4                         63.0 38.0                       101.0                         63 38                 101
1787332 1787332 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2018   grade_1                         60.0 41.0                       101.0                         60 41                 101
1787336 1787336 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2018   grade_5                         53.0 48.0                       101.0                         53 48                 101
1787456 1787456 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2018   grade_4                         48.0 53.0                       101.0                         48 53                 101
1787582 1787582 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No Elementary KG 05 2018   grade_5                         51.0 50.0                       101.0                         51 50                 101
1788117 1788117 IN     school 1802830 630   Zionsville Community Schools 180283001854 542 Stonegate Elementary   Regular School No Elementary PK 04 2018   grade_2                         50.0 51.0                       101.0                         50 51                 101
1788228 1788228 IN     school 1802700 755   Delphi Community School Corp 180270000328 641 Delphi Community Elementary School   Regular School No Elementary PK 05 2018   grade_2                         50.0 51.0                       101.0                         50 51                 101
1788776 1788776 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119000371 1193 Bright Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         52.0 49.0                       101.0                         52 49                 101

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