Data source: Big Local News · About: Big Local

462 rows where grade = "pre_kindergarten", state = "IN" and year = 2019 sorted by total

View and edit SQL

year

  • 2019 · 462

grade

  • pre_kindergarten · 462
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
1753806 IN     school 1803270 2305   Elkhart Community Schools 180327000437 1789 Monger Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         0.0 1.0                       1.0                         0 1                 1
1757481 IN     school 1810440 5255   South Madison Com Sch Corp 181044001676 5064 Maple Ridge Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         1.0 0.0                       1.0                         1 0                 1
1759220 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001714 6233 Ladoga Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         1.0 0.0                       1.0                         1 0                 1
1759307 IN     school 1806510 5925   M S D Martinsville Schools 180651001132 6309 Green Township Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         1.0 0.0                       1.0                         1 0                 1
1759334 IN     school 1806510 5925   M S D Martinsville Schools 180651001129 6341 Centerton Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         1.0 0.0                       1.0                         1 0                 1
1759743 IN     school 1800118 6375   North Central Parke Comm Schl Corp 180011801857 6647 Turkey Run Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         0.0 1.0                       1.0                         0 1                 1
1761732 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000470 8317 Hebron Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         1.0 0.0                       1.0                         1 0                 1
1762494 IN     school 1808220 8435   Northern Wells Community Schools 180822001411 9081 Ossian Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                         1.0 0.0                       1.0                         1 0                 1
1751871 IN     school 1803630 235   Fort Wayne Community Schools 180363000533 164 J Wilbur Haley Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         8.0 2.0                       10.0                         8 2                 10
1753722 IN     school 1803270 2305   Elkhart Community Schools 180327000424 1693 Bristol Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         3.0 7.0                       10.0                         3 7                 10
1754214 IN     school 1807770 2735   North Gibson School Corporation 180777001325 2257 Princeton Comm Primary School   Regular School No Elementary PK 02 2019   pre_kindergarten                         6.0 4.0                       10.0                         6 4                 10
1754629 IN     school 1806480 3055   Sheridan Community Schools 180648001125 2465 Sheridan Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         6.0 4.0                       10.0                         6 4                 10
1755418 IN     school 1803150 3480   Eastern Howard School Corporation 180315000412 2909 Eastern Elementary School   Regular School No Elementary PK 07 2019   pre_kindergarten                         10.0 0.0                       10.0                         10 0                 10
1755596 IN     school 1801230 3640   Medora Community School Corp 180123002268 3095 Medora Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         5.0 5.0                       10.0                         5 5                 10
1758675 IN     school 1804770 5385   Indianapolis Public Schools 180477000882 5614 Paul I Miller School 114   Regular School No Elementary PK 06 2019   pre_kindergarten                         9.0 1.0                       10.0                         9 1                 10
1759582 IN     school 1808490 6145   Orleans Community Schools 180849001436 6577 Orleans Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         8.0 2.0                       10.0                         8 2                 10
1761606 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000459 8241 Central High School   Regular School No High 09 12 2019   pre_kindergarten                         2.0 8.0                       10.0                         2 8                 10
1751972 IN     school 1803630 235   Fort Wayne Community Schools 180363001541 241 Whitney M Young Early Childhood   Regular School No Elementary PK KG 2019   pre_kindergarten                         42.0 58.0                       100.0                         42 58                 100
1758102 IN     school 1812720 5370   M S D Washington Township 181272002444 5434 Hilltop School   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                         70.0 30.0                       100.0                         70 30                 100
1759011 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948000261 6144 Edgewood Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                         61.0 42.0                       103.0                         61 42                 103
1756528 IN     school 1805450 4615   Lake Central School Corporation 180545000981 3840 James H Watson Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         73.0 31.0                       104.0                         73 31                 104
1759646 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001794 6617 Spencer Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         61.0 48.0                       109.0                         61 48                 109
1754084 IN     school 1810620 2455   Southeast Fountain School Corp 181062001743 2021 Southeast Fountain Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten                         9.0 2.0                       11.0                         9 2                 11
1758979 IN     school 1808340 5625   Oak Hill United School Corp 180834001428 6073 Converse Elementary School   Regular School No Elementary PK 02 2019   pre_kindergarten                         5.0 6.0                       11.0                         5 6                 11
1759531 IN     school 1802970 6060   East Noble School Corporation 180297000394 6485 Wayne Center Elem School   Regular School No Elementary PK 05 2019   pre_kindergarten                         3.0 8.0                       11.0                         3 8                 11
1760090 IN     school 1807290 6590   M S D Mount Vernon 180729001223 6965 Farmersville Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         8.0 3.0                       11.0                         8 3                 11
1762304 IN     school 1803000 8215   East Washington School Corp 180300002195 8904 East Washington Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         8.0 3.0                       11.0                         8 3                 11
1754888 IN     school 1807260 3135   Mt Vernon Community School Corp 180726002634 2568 Mt Vernon Early Learning Academy   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                         60.0 50.0                       110.0                         60 50                 110
1754817 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001760 2564 New Palestine Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         56.0 55.0                       111.0                         56 55                 111
1757270 IN     school 1805580 4945   LaPorte Community School Corp 180558001015 4741 LaPorte High School   Regular School No High 09 12 2019   pre_kindergarten                         65.0 54.0                       119.0                         65 54                 119
1754940 IN     school 1800690 3180   North Harrison Com School Corp 180069000142 2621 Morgan Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         6.0 6.0                       12.0                         6 6                 12
1756546 IN     school 1805450 4615   Lake Central School Corporation 180545002143 4349 Homan Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         9.0 3.0                       12.0                         9 3                 12
1759343 IN     school 1806510 5925   M S D Martinsville Schools 180651002355 6344 South Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         6.0 6.0                       12.0                         6 6                 12
1759357 IN     school 1806510 5925   M S D Martinsville Schools 180651001138 6357 Paragon Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         6.0 6.0                       12.0                         6 6                 12
1759009 IN     school 1808850 5635   Peru Community Schools 180885001472 6097 Elmwood Primary Learning Center   Regular School No Elementary PK 02 2019   pre_kindergarten                         67.0 53.0                       120.0                         67 53                 120
1753831 IN     school 1803270 2305   Elkhart Community Schools 180327000447 1817 Woodland Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         79.0 42.0                       121.0                         79 42                 121
1760814 IN     school 1810290 7205   South Bend Community School Corp 181029001672 7577 Marquette Montessori Academy   Regular School No Elementary PK 06 2019   pre_kindergarten                         62.0 59.0                       121.0                         62 59                 121
1755566 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471002598 3078 Huntington Schools Preschool   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                         72.0 51.0                       123.0                         72 51                 123
1754988 IN     school 1810360 3190   South Harrison Com Schools 181036001696 2653 Heth-Washington Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         5.0 8.0                       13.0                         5 8                 13
1755286 IN     school 1808280 3435   Shenandoah School Corporation 180828002356 2815 Shenandoah Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         8.0 5.0                       13.0                         8 5                 13
1756165 IN     school 1812120 4335   Vincennes Community School Corp 181212001927 3581 Francis Vigo Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         7.0 6.0                       13.0                         7 6                 13
1757141 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No Elementary PK 08 2019   pre_kindergarten                         8.0 5.0                       13.0                         8 5                 13
1758573 IN     school 1804770 5385   Indianapolis Public Schools 180477000797 5588 Anna Brochhausen School 88   Regular School No Elementary PK 06 2019   pre_kindergarten                         8.0 5.0                       13.0                         8 5                 13
1758774 IN     school 1810920 5400   School Town of Speedway 181092001781 5897 Carl G Fisher Elementary School 1   Regular School No Elementary PK 06 2019   pre_kindergarten                         7.0 6.0                       13.0                         7 6                 13
1762297 IN     school 1809810 8205   Salem Community Schools 180981000357 8864 Bradie Shrum Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                         12.0 1.0                       13.0                         12 1                 13
1753772 IN     school 1803270 2305   Elkhart Community Schools 180327000434 1769 Mary Beck Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         71.0 65.0                       136.0                         71 65                 136
1758623 IN     school 1804770 5385   Indianapolis Public Schools 180477000833 5602 Francis Bellamy Pre-School Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                         70.0 66.0                       136.0                         70 66                 136
1759266 IN     school 1802460 5855   Crawfordsville Community Schools 180246000285 6305 Anna Willson School   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                         74.0 63.0                       137.0                         74 63                 137
1756892 IN     school 1804320 4710   School City of Hammond 180432000750 4453 Warren G Harding Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         80.0 58.0                       138.0                         80 58                 138
1752920 IN     school 1802440 1300   Crawford County Community Sch Corp 180244000281 1037 South Crawford Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         6.0 8.0                       14.0                         6 8                 14
1753127 IN     school 1802610 1655   Decatur County Community Schools 180261000310 1265 South Decatur Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         12.0 2.0                       14.0                         12 2                 14
1754192 IN     school 1802940 2725   East Gibson School Corporation 180294000384 2237 Oakland City Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         9.0 5.0                       14.0                         9 5                 14
1754573 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         12.0 2.0                       14.0                         12 2                 14
1754586 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         8.0 6.0                       14.0                         8 6                 14
1755659 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000182 3129 Brownstown Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         9.0 5.0                       14.0                         9 5                 14
1756366 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         10.0 4.0                       14.0                         10 4                 14
1759770 IN     school 1808900 6445   Pike County School Corp 180890001483 6808 Winslow Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         8.0 6.0                       14.0                         8 6                 14
1761702 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000465 8293 Fairlawn Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         10.0 4.0                       14.0                         10 4                 14
1761864 IN     school 1810590 8020   South Vermillion Com Sch Corp 181059001736 8431 Ernie Pyle Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         6.0 8.0                       14.0                         6 8                 14
1757575 IN     school 1803300 5280   Elwood Community School Corp 180330000448 5157 Elwood Elementary School   Regular School No Elementary PK 02 2019   pre_kindergarten                         78.0 65.0                       143.0                         78 65                 143
1760636 IN     school 1806840 7200   School City of Mishawaka 180684001175 7473 Beiger Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         77.0 67.0                       144.0                         77 67                 144
1753382 IN     school 1807320 1970   Muncie Community Schools 180732002153 1482 South View Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         7.0 8.0                       15.0                         7 8                 15
1754616 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2019   pre_kindergarten                         11.0 4.0                       15.0                         11 4                 15
1755000 IN     school 1810360 3190   South Harrison Com Schools 181036002284 2667 South Central Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                         7.0 8.0                       15.0                         7 8                 15
1755772 IN     school 1806120 3995   Madison Consolidated Schools 180612001085 3301 Deputy Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         9.0 6.0                       15.0                         9 6                 15
1757762 IN     school 1805670 5330   M S D Lawrence Township 180567000150 5294 Forest Glen Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         5.0 10.0                       15.0                         5 10                 15
1758468 IN     school 1804770 5385   Indianapolis Public Schools 180477000883 5558 Ralph Waldo Emerson School 58   Regular School No Elementary PK 06 2019   pre_kindergarten                         9.0 6.0                       15.0                         9 6                 15
1759107 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000117 6181 Arlington Heights Elementary Sch   Regular School No Elementary PK 06 2019   pre_kindergarten                         9.0 6.0                       15.0                         9 6                 15
1759364 IN     school 1806510 5925   M S D Martinsville Schools 180651001139 6361 Poston Road Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         11.0 4.0                       15.0                         11 4                 15
1759727 IN     school 1811260 6350   Tell City-Troy Twp School Corp 181126001282 6745 William Tell Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         11.0 4.0                       15.0                         11 4                 15
1760952 IN     school 1803210 7285   Shelby Eastern Schools 180321000417 7663 Morristown Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         10.0 5.0                       15.0                         10 5                 15
1761216 IN     school 1811100 7615   M S D Steuben County 181110001799 7897 Carlin Park Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         11.0 4.0                       15.0                         11 4                 15
1751825 IN     school 1803630 235   Fort Wayne Community Schools 180363000519 151 Bunche Elementary School   Regular School No Elementary PK KG 2019   pre_kindergarten                         74.0 84.0                       158.0                         74 84                 158
1751951 IN     school 1803630 235   Fort Wayne Community Schools 180363000524 221 Francis M Price Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         11.0 5.0                       16.0                         11 5                 16
1754117 IN     school 1803700 2475   Franklin County Community Sch Corp 180370000587 2125 Brookville Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         8.0 8.0                       16.0                         8 8                 16
1754801 IN     school 1807650 3070   Noblesville Schools 180765001246 2547 White River Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         13.0 3.0                       16.0                         13 3                 16
1757785 IN     school 1805670 5330   M S D Lawrence Township 180567001034 5298 Skiles Test Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         9.0 7.0                       16.0                         9 7                 16
1759134 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000127 6197 Fairview Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         9.0 7.0                       16.0                         9 7                 16
1754312 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No Elementary PK 01 2019   pre_kindergarten                         86.0 77.0                       163.0                         86 77                 163
1757626 IN     school 1802640 5300   M S D Decatur Township 180264001065 5192 Liberty Early Elementary School   Regular School No Elementary PK KG 2019   pre_kindergarten                         95.0 74.0                       169.0                         95 74                 169
1753451 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064001746 1563 Pine Ridge Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         7.0 10.0                       17.0                         7 10                 17
1754021 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001269 1961 Green Valley Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         11.0 6.0                       17.0                         11 6                 17
1754040 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001278 1981 S Ellen Jones Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         10.0 7.0                       17.0                         10 7                 17
1754917 IN     school 1803120 3145   Eastern Hancock Co Com Sch Corp 180312000409 2586 Eastern Hancock Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         13.0 4.0                       17.0                         13 4                 17
1758327 IN     school 1804770 5385   Indianapolis Public Schools 180477000896 5515 Thomas D Gregg School 15   Regular School No Elementary PK 06 2019   pre_kindergarten                         13.0 4.0                       17.0                         13 4                 17
1758438 IN     school 1804770 5385   Indianapolis Public Schools 180477000822 5555 IPS/ Butler Eliza Blaker School 55   Regular School No Elementary PK 06 2019   pre_kindergarten                         8.0 9.0                       17.0                         8 9                 17
1758692 IN     school 1804770 5385   Indianapolis Public Schools 180477001427 5623 Arlington Woods School 99   Regular School No Elementary PK 06 2019   pre_kindergarten                         9.0 8.0                       17.0                         9 8                 17
1759327 IN     school 1806510 5925   M S D Martinsville Schools 180651001128 6337 Brooklyn STEM Academy   Regular School No Elementary PK 04 2019   pre_kindergarten                         6.0 11.0                       17.0                         6 11                 17
1761269 IN     school 1810860 7715   Southwest School Corporation 181086001770 7953 Carlisle Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         8.0 9.0                       17.0                         8 9                 17
1762624 IN     school 1810230 8625   Smith-Green Community Schools 181023001637 9197 Churubusco Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         9.0 8.0                       17.0                         9 8                 17
1755209 IN     school 1808970 3330   Plainfield Community School Corp 180897002569 2753 Little Quakers Academy   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                         99.0 78.0                       177.0                         99 78                 177
1751814 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         11.0 7.0                       18.0                         11 7                 18
1753282 IN     school 1804500 1885   Wes-Del Community Schools 180450002607 1412 Wes-Del Preschool   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                         8.0 10.0                       18.0                         8 10                 18
1753789 IN     school 1803270 2305   Elkhart Community Schools 180327000431 1777 Hawthorne Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         5.0 13.0                       18.0                         5 13                 18
1754757 IN     school 1807650 3070   Noblesville Schools 180765001311 2529 North Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         10.0 8.0                       18.0                         10 8                 18
1755231 IN     school 1806660 3335   Mill Creek Community Sch Corp 180666001172 2675 Mill Creek East Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                         11.0 7.0                       18.0                         11 7                 18
1755791 IN     school 1806120 3995   Madison Consolidated Schools 180612001093 3321 Rykers' Ridge Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         8.0 10.0                       18.0                         8 10                 18
1758648 IN     school 1804770 5385   Indianapolis Public Schools 180477000887 5606 Robert Lee Frost School 106   Regular School No Elementary PK 06 2019   pre_kindergarten                         9.0 9.0                       18.0                         9 9                 18
1758885 IN     school 1811490 5495   Triton School Corporation 181149001855 5922 Triton Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         11.0 7.0                       18.0                         11 7                 18
1759116 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000123 6187 Childs Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         9.0 9.0                       18.0                         9 9                 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]);