Data source: Big Local News · About: Big Local

469 rows where grade = "pre_kindergarten", state = "IN" and year = 2020 sorted by total

View and edit SQL

year

  • 2020 · 469

grade

  • pre_kindergarten · 469
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
1909902 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001560 2471 Hoosier Road Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                         1.0 0.0                       1.0                         1 0                 1
1913598 IN     school 1812810 5375   M S D Wayne Township 181281002035 5257 McClelland Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         1.0 0.0                       1.0                         1 0                 1
1913616 IN     school 1812810 5375   M S D Wayne Township 181281002037 5265 Robey Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         1.0 0.0                       1.0                         1 0                 1
1915042 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001787 6605 Gosport Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         0.0 1.0                       1.0                         0 1                 1
1916707 IN     school 1811220 7775   Switzerland County School Corp 181122001808 7985 Jefferson-Craig Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         0.0 1.0                       1.0                         0 1                 1
1917338 IN     school 1812090 8030   Vigo County School Corp 181209001899 8497 Sugar Creek Consolidated Elem Sch   Regular School No Elementary PK 05 2020   pre_kindergarten                         1.0 0.0                       1.0                         1 0                 1
1917416 IN     school 1812090 8030   Vigo County School Corp 181209002173 8543 Hoosier Prairie Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         1.0 0.0                       1.0                         1 0                 1
1908559 IN     school 1802610 1655   Decatur County Community Schools 180261000310 1265 South Decatur Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         9.0 1.0                       10.0                         9 1                 10
1913755 IN     school 1804770 5385   Indianapolis Public Schools 180477000896 5515 Thomas D Gregg School 15   Regular School No Elementary PK 06 2020   pre_kindergarten                         8.0 2.0                       10.0                         8 2                 10
1914992 IN     school 1808490 6145   Orleans Community Schools 180849001436 6577 Orleans Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         9.0 1.0                       10.0                         9 1                 10
1917972 IN     school 1803810 8525   Frontier School Corporation 180381000604 9113 Frontier Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten                         6.0 4.0                       10.0                         6 4                 10
1907412 IN     school 1803630 235   Fort Wayne Community Schools 180363001541 241 Whitney M Young Early Childhood   Regular School No Elementary PK KG 2020   pre_kindergarten                         54.0 46.0                       100.0                         54 46                 100
1911012 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471002598 3078 Huntington Schools Preschool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                         64.0 36.0                       100.0                         64 36                 100
1914349 IN     school 1806090 5615   Maconaquah School Corp 180609002318 6012 Pipe Creek Elementary School   Regular School No Elementary PK 01 2020   pre_kindergarten                         45.0 57.0                       102.0                         45 57                 102
1915056 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001794 6617 Spencer Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         64.0 40.0                       104.0                         64 40                 104
1907587 IN     school 1800360 365   Bartholomew Con School Corp 180036002506 354 Richard L Johnson Early Educ Cntr   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                         63.0 43.0                       106.0                         63 43                 106
1916046 IN     school 1806840 7200   School City of Mishawaka 180684001175 7473 Beiger Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         64.0 45.0                       109.0                         64 45                 109
1907391 IN     school 1803630 235   Fort Wayne Community Schools 180363000524 221 Francis M Price Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         10.0 1.0                       11.0                         10 1                 11
1910057 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten                         5.0 6.0                       11.0                         5 6                 11
1911995 IN     school 1805450 4615   Lake Central School Corporation 180545002143 4349 Homan Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                         9.0 2.0                       11.0                         9 2                 11
1913839 IN     school 1804770 5385   Indianapolis Public Schools 180477000904 5549 William Penn School 49   Regular School No Elementary PK 08 2020   pre_kindergarten                         8.0 3.0                       11.0                         8 3                 11
1914549 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000127 6197 Fairview Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         5.0 6.0                       11.0                         5 6                 11
1914899 IN     school 1802970 6060   East Noble School Corporation 180297000387 6457 Avilla Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         9.0 2.0                       11.0                         9 2                 11
1915499 IN     school 1807290 6590   M S D Mount Vernon 180729001223 6965 Farmersville Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         5.0 6.0                       11.0                         5 6                 11
1917717 IN     school 1809810 8205   Salem Community Schools 180981000357 8864 Bradie Shrum Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                         7.0 4.0                       11.0                         7 4                 11
1918043 IN     school 1810230 8625   Smith-Green Community Schools 181023001637 9197 Churubusco Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         6.0 5.0                       11.0                         6 5                 11
1912992 IN     school 1803300 5280   Elwood Community School Corp 180330000448 5157 Elwood Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten                         54.0 56.0                       110.0                         54 56                 110
1910260 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001760 2564 New Palestine Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                         61.0 50.0                       111.0                         61 50                 111
1916222 IN     school 1810290 7205   South Bend Community School Corp 181029001672 7577 Marquette Montessori Academy   Regular School No Elementary PK 06 2020   pre_kindergarten                         54.0 59.0                       113.0                         54 59                 113
1910332 IN     school 1807260 3135   Mt Vernon Community School Corp 180726002634 2568 Mt Vernon Early Learning Academy   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                         55.0 59.0                       114.0                         55 59                 114
1911379 IN     school 1801440 4205   Center Grove Community School Corp 180144000662 3434 Sugar Grove Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         78.0 37.0                       115.0                         78 37                 115
1911977 IN     school 1805450 4615   Lake Central School Corporation 180545000981 3840 James H Watson Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                         70.0 45.0                       115.0                         70 45                 115
1909693 IN     school 1803030 2815   Eastbrook Community Sch Corp 180303002505 2291 Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                         3.0 9.0                       12.0                         3 9                 12
1911823 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         10.0 2.0                       12.0                         10 2                 12
1912240 IN     school 1804170 4700   Griffith Public Schools 180417000717 4171 Beiriger Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         9.0 3.0                       12.0                         9 3                 12
1914166 IN     school 1804770 5385   Indianapolis Public Schools 180477002395 5674 Frederick Douglass School 19   Regular School No Elementary PK 08 2020   pre_kindergarten                         7.0 5.0                       12.0                         7 5                 12
1914455 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000136 6123 Unionville Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         5.0 7.0                       12.0                         5 7                 12
1914770 IN     school 1806510 5925   M S D Martinsville Schools 180651001138 6357 Paragon Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                         7.0 5.0                       12.0                         7 5                 12
1915179 IN     school 1808900 6445   Pike County School Corp 180890001483 6808 Winslow Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         11.0 1.0                       12.0                         11 1                 12
1916625 IN     school 1811100 7615   M S D Steuben County 181110001799 7897 Carlin Park Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         8.0 4.0                       12.0                         8 4                 12
1914426 IN     school 1808850 5635   Peru Community Schools 180885001472 6097 Elmwood Primary Learning Center   Regular School No Elementary PK 02 2020   pre_kindergarten                         67.0 55.0                       122.0                         67 55                 122
1909263 IN     school 1803270 2305   Elkhart Community Schools 180327000447 1817 Woodland Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         80.0 44.0                       124.0                         80 44                 124
1912203 IN     school 1803870 4690   Gary Community School Corp 180387000620 4086 Frankie Woods McCullough Academy   Regular School No Elementary PK 05 2020   pre_kindergarten                         66.0 60.0                       126.0                         66 60                 126
1910014 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                         12.0 1.0                       13.0                         12 1                 13
1913281 IN     school 1808820 5340   Perry Township Schools 180882001457 5338 Douglas MacArthur Elementary Sch   Regular School No Elementary PK 05 2020   pre_kindergarten                         8.0 5.0                       13.0                         8 5                 13
1914192 IN     school 1810920 5400   School Town of Speedway 181092001781 5897 Carl G Fisher Elementary School 1   Regular School No Elementary PK 06 2020   pre_kindergarten                         8.0 5.0                       13.0                         8 5                 13
1914596 IN     school 1800630 5740   Monroe County Community Sch Corp 180063002663 6312 Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                         7.0 6.0                       13.0                         7 6                 13
1914662 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001715 6269 New Market Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         5.0 8.0                       13.0                         5 8                 13
1914756 IN     school 1806510 5925   M S D Martinsville Schools 180651002355 6344 South Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         4.0 9.0                       13.0                         4 9                 13
1914917 IN     school 1802970 6060   East Noble School Corporation 180297000393 6465 Rome City Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         6.0 7.0                       13.0                         6 7                 13
1915989 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876000526 7383 Horizon Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         9.0 4.0                       13.0                         9 4                 13
1916942 IN     school 1811400 7945   Tipton Community School Corp 181140001844 8163 Tipton Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         8.0 5.0                       13.0                         8 5                 13
1917392 IN     school 1812090 8030   Vigo County School Corp 181209001914 8525 Rio Grande Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         9.0 4.0                       13.0                         9 4                 13
1914042 IN     school 1804770 5385   Indianapolis Public Schools 180477000833 5602 Francis Bellamy Pre-School Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                         76.0 56.0                       132.0                         76 56                 132
1910489 IN     school 1801020 3305   Brownsburg Community School Corp 180102002562 2707 Brownsburg Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                         83.0 53.0                       136.0                         83 53                 136
1909205 IN     school 1803270 2305   Elkhart Community Schools 180327000434 1769 Mary Beck Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         66.0 72.0                       138.0                         66 72                 138
1914683 IN     school 1802460 5855   Crawfordsville Community Schools 180246000285 6305 Anna Willson School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                         70.0 68.0                       138.0                         70 68                 138
1910447 IN     school 1810360 3190   South Harrison Com Schools 181036002284 2667 South Central Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten                         5.0 9.0                       14.0                         5 9                 14
1911042 IN     school 1801230 3640   Medora Community School Corp 180123002268 3095 Medora Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         5.0 9.0                       14.0                         5 9                 14
1911621 IN     school 1812120 4335   Vincennes Community School Corp 181212001927 3581 Francis Vigo Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         7.0 7.0                       14.0                         7 7                 14
1914700 IN     school 1804140 5900   Monroe-Gregg School District 180414000715 6323 Monrovia Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         10.0 4.0                       14.0                         10 4                 14
1914777 IN     school 1806510 5925   M S D Martinsville Schools 180651001139 6361 Poston Road Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                         12.0 2.0                       14.0                         12 2                 14
1915818 IN     school 1804800 6900   Jac-Cen-Del Community Sch Corp 180480002353 7203 Jac-Cen-Del Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         8.0 6.0                       14.0                         8 6                 14
1916411 IN     school 1810830 7360   Southwestern Con Sch Shelby Co 181083001768 7703 Southwestern Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         8.0 6.0                       14.0                         8 6                 14
1909376 IN     school 1803510 2395   Fayette County School Corporation 180351000505 1917 Maplewood Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         80.0 67.0                       147.0                         80 67                 147
1912701 IN     school 1805580 4945   LaPorte Community School Corp 180558001015 4741 LaPorte High School   Regular School No High 09 12 2020   pre_kindergarten                         87.0 60.0                       147.0                         87 60                 147
1908456 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119001803 1189 North Dearborn Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         9.0 6.0                       15.0                         9 6                 15
1909510 IN     school 1810620 2455   Southeast Fountain School Corp 181062001743 2021 Southeast Fountain Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten                         9.0 6.0                       15.0                         9 6                 15
1911104 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000182 3129 Brownstown Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         11.0 4.0                       15.0                         11 4                 15
1911707 IN     school 1812420 4415   Warsaw Community Schools 181242001992 3661 Jefferson Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         10.0 5.0                       15.0                         10 5                 15
1913257 IN     school 1808820 5340   Perry Township Schools 180882001456 5325 Clinton Young Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         11.0 4.0                       15.0                         11 4                 15
1913896 IN     school 1804770 5385   Indianapolis Public Schools 180477000883 5558 Ralph Waldo Emerson School 58   Regular School No Elementary PK 06 2020   pre_kindergarten                         4.0 11.0                       15.0                         4 11                 15
1914522 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000117 6181 Arlington Heights Elementary Sch   Regular School No Elementary PK 06 2020   pre_kindergarten                         9.0 6.0                       15.0                         9 6                 15
1915146 IN     school 1800118 6375   North Central Parke Comm Schl Corp 180011801578 6645 Rockville Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         12.0 3.0                       15.0                         12 3                 15
1917724 IN     school 1803000 8215   East Washington School Corp 180300002195 8904 East Washington Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                         10.0 5.0                       15.0                         10 5                 15
1917766 IN     school 1807380 8305   Nettle Creek School Corporation 180738001260 8989 Hagerstown Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         10.0 5.0                       15.0                         10 5                 15
1907265 IN     school 1803630 235   Fort Wayne Community Schools 180363000519 151 Bunche Elementary School   Regular School No Elementary PK KG 2020   pre_kindergarten                         73.0 81.0                       154.0                         73 81                 154
1907703 IN     school 1800480 395   Benton Community School Corp 180048000098 433 Boswell Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         8.0 8.0                       16.0                         8 8                 16
1909639 IN     school 1807770 2735   North Gibson School Corporation 180777001325 2257 Princeton Comm Primary School   Regular School No Elementary PK 02 2020   pre_kindergarten                         13.0 3.0                       16.0                         13 3                 16
1910362 IN     school 1803120 3145   Eastern Hancock Co Com Sch Corp 180312000409 2586 Eastern Hancock Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         12.0 4.0                       16.0                         12 4                 16
1910385 IN     school 1800690 3180   North Harrison Com School Corp 180069000142 2621 Morgan Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         9.0 7.0                       16.0                         9 7                 16
1910434 IN     school 1810360 3190   South Harrison Com Schools 181036001696 2653 Heth-Washington Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         8.0 8.0                       16.0                         8 8                 16
1913866 IN     school 1804770 5385   Indianapolis Public Schools 180477000822 5555 IPS/Butler Lab at Eliza Blaker 55   Regular School No Elementary PK 07 2020   pre_kindergarten                         11.0 5.0                       16.0                         11 5                 16
1914941 IN     school 1802970 6060   East Noble School Corporation 180297000394 6485 Wayne Center Elem School   Regular School No Elementary PK 05 2020   pre_kindergarten                         7.0 9.0                       16.0                         7 9                 16
1917270 IN     school 1810590 8020   South Vermillion Com Sch Corp 181059001736 8431 Ernie Pyle Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         8.0 8.0                       16.0                         8 8                 16
1908342 IN     school 1809720 1180   Rossville Con School District 180972001589 1033 Rossville Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         12.0 5.0                       17.0                         12 5                 17
1909543 IN     school 1803700 2475   Franklin County Community Sch Corp 180370000587 2125 Brookville Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         12.0 5.0                       17.0                         12 5                 17
1909618 IN     school 1802940 2725   East Gibson School Corporation 180294000384 2237 Oakland City Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         10.0 7.0                       17.0                         10 7                 17
1914020 IN     school 1804770 5385   Indianapolis Public Schools 180477002277 5591 Rousseau McClellan School 91   Regular School No Elementary PK 08 2020   pre_kindergarten                         5.0 12.0                       17.0                         5 12                 17
1914513 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000118 6173 Binford Elementary School   Regular School No Elementary 03 06 2020   pre_kindergarten                         14.0 3.0                       17.0                         14 3                 17
1914540 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000124 6189 Clear Creek Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         11.0 6.0                       17.0                         11 6                 17
1915138 IN     school 1811260 6350   Tell City-Troy Twp School Corp 181126001282 6745 William Tell Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         11.0 6.0                       17.0                         11 6                 17
1916012 IN     school 1806840 7200   School City of Mishawaka 180684001178 7459 Fred J Hums Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         8.0 9.0                       17.0                         8 9                 17
1916724 IN     school 1811220 7775   Switzerland County School Corp 181122002170 7994 Switzerland Co Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         9.0 8.0                       17.0                         9 8                 17
1917021 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002627 8242 McCutchanville Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         9.0 8.0                       17.0                         9 8                 17
1917099 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000463 8289 Dexter Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         9.0 8.0                       17.0                         9 8                 17
1917137 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000470 8317 Hebron Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         12.0 5.0                       17.0                         12 5                 17
1917448 IN     school 1812090 8030   Vigo County School Corp 181209001913 8593 Riley Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         15.0 2.0                       17.0                         15 2                 17
1909739 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No Elementary PK 01 2020   pre_kindergarten                         106.0 71.0                       177.0                         106 71                 177
1909447 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001269 1961 Green Valley Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                         6.0 12.0                       18.0                         6 12                 18

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