enrollments

Data source: Big Local News · About: Big Local

12,044 rows where state = "IN" and year = 2015 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2015 · 11,954 ✖
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
1159881 1159881 IN     school 1803630 235   Fort Wayne Community Schools 180363000524 221 Francis M Price Elem Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         5.0 5.0                       10.0                         5 5                 10
1160683 1160683 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_7                         10.0 0.0                       10.0                         10 0                 10
1162118 1162118 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No 1.0 KG 06 2015   kindergarten                         6.0 4.0                       10.0                         6 4                 10
1163362 1163362 IN     school 1803150 3480   Eastern Howard School Corp 180315000412 2909 Eastern Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         7.0 3.0                       10.0                         7 3                 10
1163668 1163668 IN     school 1804980 3945   Jay School Corp 180498000914 3239 Jay County High School   Regular School No 3.0 09 12 2015   adult                         6.0 4.0                       10.0                         6 4                 10
1164746 1164746 IN     school 1803870 4690   Gary Community School Corp 180387000617 4081 Dr Bernard C Watson Acad for Boys   Regular School No 1.0 KG 06 2015   kindergarten                         10.0 0.0                       10.0                         10 0                 10
1165822 1165822 IN     school 1808820 5340   Perry Township Schools 180882001467 5309 Southport High School   Regular School No 3.0 09 12 2015   adult                         5.0 5.0                       10.0                         5 5                 10
1166231 1166231 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_10                         8.0 2.0                       10.0                         8 2                 10
1166237 1166237 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_5                         9.0 1.0                       10.0                         9 1                 10
1166325 1166325 IN     school 1804770 5385   Indianapolis Public Schools 180477000856 5494 John Marshall Community High Sch   Regular School No 3.0 09 12 2015   adult                         6.0 4.0                       10.0                         6 4                 10
1166745 1166745 IN     school 1804770 5385   Indianapolis Public Schools 180477001434 5631 Key Learning Community High School   Regular School No 3.0 09 12 2015   grade_12                         5.0 5.0                       10.0                         5 5                 10
1166812 1166812 IN     school 1800105 5390   Southside Sp Srvs Of Marion Co 180010502502 5320 RISE Learning Center   Regular School No 4.0 KG 12 2015   grade_12                         8.0 2.0                       10.0                         8 2                 10
1166817 1166817 IN     school 1800105 5390   Southside Sp Srvs Of Marion Co 180010502502 5320 RISE Learning Center   Regular School No 4.0 KG 12 2015   grade_6                         8.0 2.0                       10.0                         8 2                 10
1169408 1169408 IN     school 1805400 7855   Lafayette School Corporation 180540002518 8015 Oakland High School   Regular School No 3.0 09 12 2015   grade_9                         2.0 8.0                       10.0                         2 8                 10
1170761 1170761 IN     school 1800006 9100   IN Department of Correction 180000601943 5452 Madison Juvenile Corr Fac   Regular School No 3.0 08 12 2015   grade_10                         0.0 10.0                       10.0                         0 10                 10
1171130 1171130 IN     school 1800059 9655   Hope Academy 180005902386 5292 Hope Academy   Regular School Yes 3.0 09 12 2015   grade_12                         6.0 4.0                       10.0                         6 4                 10
1171211 1171211 IN     school 1800129 9725   Canaan Community Academy 180012902534 3312 Canaan Community Academy   Regular School Yes 1.0 KG 06 2015   grade_5                         4.0 6.0                       10.0                         4 6                 10
1171232 1171232 IN     school 1800121 9740   Thurgood Marshall Leadership Acad 180012102540 138 Thurgood Marshall Leadership Acad   Regular School Yes 1.0 KG 08 2015   grade_4                         8.0 2.0                       10.0                         8 2                 10
1171469 1171469 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2015   grade_4                         9.0 1.0                       10.0                         9 1                 10
1159462 1159462 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No 2.0 06 08 2015   grade_6                         45.0 55.0                       100.0                         45 55                 100
1159467 1159467 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary Sch   Regular School No 1.0 KG 05 2015   grade_2                         50.0 50.0                       100.0                         50 50                 100
1159543 1159543 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No 1.0 KG 05 2015   grade_5                         58.0 42.0                       100.0                         58 42                 100
1159590 1159590 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         58.0 42.0                       100.0                         58 42                 100
1159713 1159713 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         45.0 55.0                       100.0                         45 55                 100
1160004 1160004 IN     school 1802850 255   East Allen County Schools 180285000361 285 Woodlan Jr/Sr High School   Regular School No 3.0 07 12 2015   grade_7                         56.0 44.0                       100.0                         56 44                 100
1160079 1160079 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No 1.0 PK 06 2015   grade_3                         49.0 51.0                       100.0                         49 51                 100
1160408 1160408 IN     school 1802700 755   Delphi Community School Corp 180270000328 641 Delphi Community Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         50.0 50.0                       100.0                         50 50                 100
1160430 1160430 IN     school 1810680 815   Southeastern School Corp 181068001754 673 Galveston Elementary School   Regular School No 2.0 04 06 2015   grade_4                         52.0 48.0                       100.0                         52 48                 100
1161033 1161033 IN     school 1800240 1600   South Dearborn Com School Corp 180024000051 1197 Aurora Elementary School   Regular School No 1.0 PK 06 2015   kindergarten                         54.0 46.0                       100.0                         54 46                 100
1161164 1161164 IN     school 1801590 1835   DeKalb Co Ctl United Sch Dist 180159000222 1351 James R Watson Elem School   Regular School No 1.0 PK 05 2015   grade_5                         56.0 44.0                       100.0                         56 44                 100
1161231 1161231 IN     school 1805880 1895   Liberty-Perry Com School Corp 180588001047 1375 Wapahani High School   Regular School No 3.0 09 12 2015   grade_9                         51.0 49.0                       100.0                         51 49                 100
1161453 1161453 IN     school 1803960 2120   Greater Jasper Con Schs 180396000684 1569 Ireland Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         43.0 57.0                       100.0                         43 57                 100
1161570 1161570 IN     school 1806600 2275   Middlebury Community Schools 180660001163 1656 Jefferson Elementary School   Regular School No 1.0 KG 03 2015   grade_3                         48.0 52.0                       100.0                         48 52                 100
1162328 1162328 IN     school 1805910 2950   Linton-Stockton School Corp 180591001049 2437 Linton-Stockton High School   Regular School No 3.0 09 12 2015   grade_10                         54.0 46.0                       100.0                         54 46                 100
1162618 1162618 IN     school 1801200 3060   Carmel Clay Schools 180120000036 2512 Smoky Row Elementary Sch   Regular School No 1.0 PK 05 2015   grade_3                         53.0 47.0                       100.0                         53 47                 100
1162642 1162642 IN     school 1801200 3060   Carmel Clay Schools 180120000198 2516 Mohawk Trails Elementary Sch   Regular School No 1.0 KG 05 2015   grade_4                         51.0 49.0                       100.0                         51 49                 100
1162648 1162648 IN     school 1801200 3060   Carmel Clay Schools 180120002101 2518 Forest Dale Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         53.0 47.0                       100.0                         53 47                 100
1162698 1162698 IN     school 1807650 3070   Noblesville Schools 180765001311 2529 North Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         55.0 45.0                       100.0                         55 45                 100
1162705 1162705 IN     school 1807650 3070   Noblesville Schools 180765001312 2533 Stony Creek Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         57.0 43.0                       100.0                         57 43                 100
1162723 1162723 IN     school 1807650 3070   Noblesville Schools 180765002340 2538 Hazel Dell Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         51.0 49.0                       100.0                         51 49                 100
1162794 1162794 IN     school 1804050 3125   Greenfield-Central Com Schools 180405001665 2588 J B Stephens Elementary School   Regular School No 1.0 PK 03 2015   grade_2                         48.0 52.0                       100.0                         48 52                 100
1162843 1162843 IN     school 1807260 3135   Mt Vernon Community Sch Corp 180726002192 2570 McCordsville Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         52.0 48.0                       100.0                         52 48                 100
1162844 1162844 IN     school 1807260 3135   Mt Vernon Community Sch Corp 180726002192 2570 McCordsville Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         53.0 47.0                       100.0                         53 47                 100
1162986 1162986 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102000994 2706 Brown Elementary Sch   Regular School No 1.0 KG 05 2015   grade_3                         48.0 52.0                       100.0                         48 52                 100
1162988 1162988 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102000994 2706 Brown Elementary Sch   Regular School No 1.0 KG 05 2015   grade_5                         57.0 43.0                       100.0                         57 43                 100
1163011 1163011 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102002430 2714 Reagan Elementary   Regular School No 1.0 KG 05 2015   grade_2                         56.0 44.0                       100.0                         56 44                 100
1163022 1163022 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102001567 2718 Delaware Trail Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         50.0 50.0                       100.0                         50 50                 100
1163558 1163558 IN     school 1810080 3675   Seymour Community Schools 181008001617 3135 Margaret R Brown Elem School   Regular School No 1.0 KG 05 2015   grade_2                         56.0 44.0                       100.0                         56 44                 100
1163888 1163888 IN     school 1801440 4205   Center Grove Com Sch Corp 180144000662 3434 Sugar Grove Elementary Sch   Regular School No 1.0 KG 05 2015   kindergarten                         52.0 48.0                       100.0                         52 48                 100
1163973 1163973 IN     school 1803690 4225   Franklin Community School Corp 180369000584 3461 Northwood Elementary School   Regular School No 1.0 PK 04 2015   grade_2                         55.0 45.0                       100.0                         55 45                 100
1164057 1164057 IN     school 1807830 4315   North Knox School Corp 180783001334 3537 North Knox Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_9                         48.0 52.0                       100.0                         48 52                 100
1164286 1164286 IN     school 1809300 4515   Prairie Heights Com Sch Corp 180930001526 3690 Prairie Heights Sr High Sch   Regular School No 3.0 09 12 2015   grade_10                         59.0 41.0                       100.0                         59 41                 100
1164428 1164428 IN     school 1809690 4600   Merrillville Community School 180969001582 3821 Henry P Fieler Elem Sch   Regular School No 1.0 KG 04 2015   grade_1                         60.0 40.0                       100.0                         60 40                 100
1164591 1164591 IN     school 1802490 4660   Crown Point Community Sch Corp 180249000295 3773 Dwight D Eisenhower Elem Sch   Regular School No 1.0 PK 05 2015   grade_5                         46.0 54.0                       100.0                         46 54                 100
1164778 1164778 IN     school 1803870 4690   Gary Community School Corp 180387002096 4121 Jacques Marquette Elem School   Regular School No 1.0 KG 06 2015   grade_1                         55.0 45.0                       100.0                         55 45                 100
1164978 1164978 IN     school 1804320 4710   School City of Hammond 180432002237 4469 Morton Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         60.0 40.0                       100.0                         60 40                 100
1165103 1165103 IN     school 1813200 4760   Whiting School City 181320002082 4353 Whiting High School   Regular School No 3.0 09 12 2015   grade_11                         49.0 51.0                       100.0                         49 51                 100
1165592 1165592 IN     school 1803300 5280   Elwood Community School Corp 180330000449 5149 Elwood Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_11                         57.0 43.0                       100.0                         57 43                 100
1165668 1165668 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002409 5194 South Creek Elementary   Regular School No 1.0 KG 05 2015   grade_3                         47.0 53.0                       100.0                         47 53                 100
1165669 1165669 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002409 5194 South Creek Elementary   Regular School No 1.0 KG 05 2015   grade_4                         56.0 44.0                       100.0                         56 44                 100
1165780 1165780 IN     school 1805670 5330   M S D Lawrence Township 180567000150 5294 Forest Glen Elem Sch   Regular School No 1.0 KG 06 2015   grade_1                         44.0 56.0                       100.0                         44 56                 100
1165879 1165879 IN     school 1808820 5340   Perry Township Schools 180882001457 5338 Douglas MacArthur Elem School   Regular School No 1.0 KG 05 2015   grade_4                         54.0 46.0                       100.0                         54 46                 100
1166052 1166052 IN     school 1812360 5360   M S D Warren Township 181236001969 5386 Pleasant Run Elementary Sch   Regular School No 1.0 KG 04 2015   kindergarten                         45.0 55.0                       100.0                         45 55                 100
1166200 1166200 IN     school 1812810 5375   M S D Wayne Township 181281002036 5261 Rhoades Elementary School   Regular School No 1.0 PK 06 2015   grade_5                         54.0 46.0                       100.0                         54 46                 100
1166205 1166205 IN     school 1812810 5375   M S D Wayne Township 181281002037 5265 Robey Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         54.0 46.0                       100.0                         54 46                 100
1166225 1166225 IN     school 1812810 5375   M S D Wayne Township 181281002040 5270 Stout Field Elementary School   Regular School No 1.0 PK 06 2015   grade_5                         50.0 50.0                       100.0                         50 50                 100
1166257 1166257 IN     school 1812810 5375   M S D Wayne Township 181281002031 5274 Chapelwood Elementary School   Regular School No 1.0 KG 06 2015   grade_6                         52.0 48.0                       100.0                         52 48                 100
1166774 1166774 IN     school 1804770 5385   Indianapolis Public Schools 180477002393 5662 Clarence Farrington School 61   Regular School No 1.0 KG 06 2015   grade_1                         51.0 49.0                       100.0                         51 49                 100
1167550 1167550 IN     school 1801710 6055   Central Noble Com School Corp 180171000230 6453 Central Noble Junior Senior HS   Regular School No 4.0 06 12 2015   grade_9                         53.0 47.0                       100.0                         53 47                 100
1167797 1167797 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 2015   grade_9                         50.0 50.0                       100.0                         50 50                 100
1168117 1168117 IN     school 1811970 6560   Valparaiso Community Schools 181197000163 6893 Flint Lake Elementary Sch   Regular School No 1.0 KG 05 2015   grade_3                         52.0 48.0                       100.0                         52 48                 100
1168252 1168252 IN     school 1810500 6705   South Putnam Community Schools 181050002542 7056 South Putnam Middle School   Regular School No 2.0 06 08 2015   grade_6                         57.0 43.0                       100.0                         57 43                 100
1168836 1168836 IN     school 1810290 7205   South Bend Community Sch Corp 181029001681 7537 Edison Intermediate Center   Regular School No 2.0 05 08 2015   grade_8                         60.0 40.0                       100.0                         60 40                 100
1168960 1168960 IN     school 1811910 7215   Union-North United School Corp 181191001879 7399 LaVille Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_8                         49.0 51.0                       100.0                         49 51                 100
1169238 1169238 IN     school 1807800 7515   North Judson-San Pierre Sch Corp 180780001329 7854 North Judson-San Pierre Mdl Sch   Regular School No 2.0 06 08 2015   grade_8                         56.0 44.0                       100.0                         56 44                 100
1169375 1169375 IN     school 1810860 7715   Southwest School Corp 181086001771 7965 Sullivan Elementary School   Regular School No 1.0 PK 05 2015   grade_4                         54.0 46.0                       100.0                         54 46                 100
1169388 1169388 IN     school 1811220 7775   Switzerland County School Corp 181122000806 7987 Switzerland Co Middle Sch   Regular School No 2.0 07 08 2015   grade_7                         50.0 50.0                       100.0                         50 50                 100
1169435 1169435 IN     school 1805400 7855   Lafayette School Corporation 180540000971 8103 Miami Elementary School   Regular School No 1.0 KG 04 2015   grade_3                         59.0 41.0                       100.0                         59 41                 100
1169436 1169436 IN     school 1805400 7855   Lafayette School Corporation 180540000971 8103 Miami Elementary School   Regular School No 1.0 KG 04 2015   grade_4                         49.0 51.0                       100.0                         49 51                 100
1169484 1169484 IN     school 1811340 7865   Tippecanoe School Corp 181134001826 8007 Hershey Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         46.0 54.0                       100.0                         46 54                 100
1169571 1169571 IN     school 1811340 7865   Tippecanoe School Corp 181134002441 8111 Woodland Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         52.0 48.0                       100.0                         52 48                 100
1170183 1170183 IN     school 1812150 8060   Wabash City Schools 181215001940 8693 Wabash High School   Regular School No 3.0 09 12 2015   grade_11                         64.0 36.0                       100.0                         64 36                 100
1170187 1170187 IN     school 1812150 8060   Wabash City Schools 181215002301 8694 Wabash Middle School   Regular School No 2.0 05 08 2015   grade_5                         58.0 42.0                       100.0                         58 42                 100
1170572 1170572 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000149 9098 Bluffton-Harrison Elem Sch   Regular School No 1.0 KG 04 2015   grade_2                         54.0 46.0                       100.0                         54 46                 100
1170994 1170994 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes 4.0 KG 12 2015   grade_2                         50.0 50.0                       100.0                         50 50                 100
1170999 1170999 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes 4.0 KG 12 2015   grade_7                         50.0 50.0                       100.0                         50 50                 100
1168809 1168809 IN     school 1810290 7205   South Bend Community Sch Corp 181029001684 7517 Washington High School   Regular School No 3.0 09 12 2015   pk_12_total 157.0 488.0 266.0 2.0   1.0         87.0   462.0 539.0     128.0             190.0   1001.0 157 488 266 2   1         87   462 539     128       190   1001
1163859 1163859 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189002094 3422 Clark Pleasant Intermediate Sch   Regular School No 2.0 05 06 2015   pk_12_total 817.0 24.0 49.0 3.0   56.0         54.0   523.0 480.0     36.0             144.0   1003.0 817 24 49 3   56         54   523 480     36       144   1003
1164427 1164427 IN     school 1809690 4600   Merrillville Community School 180969001581 3813 Merrillville Intermediate School   Regular School No 2.0 05 06 2015   pk_12_total 134.0 603.0 199.0 3.0   11.0         56.0   525.0 481.0     26.0             125.0   1006.0 134 603 199 3   11         56   525 481     26       125   1006
1166152 1166152 IN     school 1812810 5375   M S D Wayne Township 181281002028 5213 Ben Davis High School   Regular School No 3.0 10 12 2015   grade_12                         501.0 505.0                       1006.0                         501 505                 1006
1163744 1163744 IN     school 1806120 3995   Madison Consolidated Schools 180612001090 3309 Madison Consolidated High Sch   Regular School No 3.0 09 12 2015   pk_12_total 925.0 20.0 33.0 2.0   4.0     2.0   22.0   510.0 498.0     14.0             152.0   1008.0 925 20 33 2   4     2   22   510 498     14       152   1008
1166150 1166150 IN     school 1812810 5375   M S D Wayne Township 181281002028 5213 Ben Davis High School   Regular School No 3.0 10 12 2015   grade_10                         526.0 483.0                       1009.0                         526 483                 1009
1159510 1159510 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2015   grade_4                         50.0 51.0                       101.0                         50 51                 101
1159757 1159757 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elem Sch   Regular School No 1.0 KG 05 2015   grade_2                         48.0 53.0                       101.0                         48 53                 101
1160231 1160231 IN     school 1800570 515   Blackford County Schools 180057000126 501 Southside Elementary School   Regular School No 1.0 KG 03 2015   grade_2                         53.0 48.0                       101.0                         53 48                 101
1160550 1160550 IN     school 1801920 1000   Clarksville Com School Corp 180192000251 845 Clarksville Elementary School   Regular School No 1.0 PK 04 2015   kindergarten                         49.0 52.0                       101.0                         49 52                 101
1160906 1160906 IN     school 1807710 1375   North Daviess Com Schools 180771001648 1090 North Daviess Elementary School   Regular School No 1.0 PK 06 2015   grade_2                         58.0 43.0                       101.0                         58 43                 101
1160962 1160962 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119001803 1189 North Dearborn Elementary School   Regular School No 1.0 PK 04 2015   grade_1                         50.0 51.0                       101.0                         50 51                 101
1161077 1161077 IN     school 1802610 1655   Decatur County Com Schools 180261000308 1266 North Decatur Elementary Sch   Regular School No 1.0 KG 06 2015   grade_6                         54.0 47.0                       101.0                         54 47                 101
1161105 1161105 IN     school 1803060 1805   DeKalb Co Eastern Com Sch Dist 180306000405 1317 Eastside Junior-Senior High Sch   Regular School No 3.0 07 12 2015   grade_10                         41.0 60.0                       101.0                         41 60                 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]);