Data source: Big Local News · About: Big Local

3,050 rows where grade = "pre_kindergarten" and state = "IN" sorted by district_nces_id descending

View and edit SQL

year

grade

  • pre_kindergarten · 2,950
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
1795366 IN     school 1812900 6065   West Noble School Corporation 181290002055 6491 West Noble Primary School   Regular School No Elementary PK 01 2018   pre_kindergarten                         12.0 8.0                       20.0                         12 8                 20
1914951 IN     school 1812900 6065   West Noble School Corporation 181290002055 6491 West Noble Primary School   Regular School No Elementary PK 01 2020   pre_kindergarten                         18.0 5.0                       23.0                         18 5                 23
1926828 IN     school 1812900 6065   West Noble School Corporation 181290002055 6491 West Noble Primary School   Regular School No Elementary PK 01 2021   pre_kindergarten                         11.0 4.0                       15.0                         11 4                 15
1165469 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002049 5009 Frankton Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         22.0 29.0                       51.0                         22 29                 51
1165486 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002052 5025 Lapel Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         30.0 29.0                       59.0                         30 29                 59
1286865 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002049 5009 Frankton Elementary School   Regular School No 1.0 PK 06 2016   pre_kindergarten                         33.0 31.0                       64.0                         33 31                 64
1286882 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002052 5025 Lapel Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         33.0 24.0                       57.0                         33 24                 57
1298901 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002049 5009 Frankton Elementary School   Regular School No Elementary PK 06 2017   pre_kindergarten                         33.0 31.0                       64.0                         33 31                 64
1298918 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002052 5025 Lapel Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         28.0 33.0                       61.0                         28 33                 61
1757430 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002049 5009 Frankton Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         28.0 38.0                       66.0                         28 38                 66
1757447 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002052 5025 Lapel Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         42.0 31.0                       73.0                         42 31                 73
1793222 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002049 5009 Frankton Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         40.0 32.0                       72.0                         40 32                 72
1793239 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002052 5025 Lapel Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         35.0 25.0                       60.0                         35 25                 60
1912855 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002049 5009 Frankton Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         44.0 28.0                       72.0                         44 28                 72
1912872 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002052 5025 Lapel Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         29.0 26.0                       55.0                         29 26                 55
1924776 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002049 5009 Frankton Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten                         23.0 18.0                       41.0                         23 18                 41
1924793 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002052 5025 Lapel Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         28.0 23.0                       51.0                         28 23                 51
1166170 IN     school 1812810 5375   M S D Wayne Township 181281002034 5223 Maplewood Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         9.0 11.0                       20.0                         9 11                 20
1166187 IN     school 1812810 5375   M S D Wayne Township 181281002033 5241 Garden City Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         10.0 10.0                       20.0                         10 10                 20
1166204 IN     school 1812810 5375   M S D Wayne Township 181281002036 5261 Rhoades Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         10.0 10.0                       20.0                         10 10                 20
1166229 IN     school 1812810 5375   M S D Wayne Township 181281002040 5270 Stout Field Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         14.0 6.0                       20.0                         14 6                 20
1287572 IN     school 1812810 5375   M S D Wayne Township 181281002034 5223 Maplewood Elementary School   Regular School No 1.0 PK 06 2016   pre_kindergarten                         8.0 12.0                       20.0                         8 12                 20
1287589 IN     school 1812810 5375   M S D Wayne Township 181281002033 5241 Garden City Elementary School   Regular School No 1.0 PK 06 2016   pre_kindergarten                         7.0 14.0                       21.0                         7 14                 21
1287606 IN     school 1812810 5375   M S D Wayne Township 181281002036 5261 Rhoades Elementary School   Regular School No 1.0 PK 06 2016   pre_kindergarten                         9.0 11.0                       20.0                         9 11                 20
1287631 IN     school 1812810 5375   M S D Wayne Township 181281002040 5270 Stout Field Elementary School   Regular School No 1.0 PK 06 2016   pre_kindergarten                         10.0 11.0                       21.0                         10 11                 21
1299609 IN     school 1812810 5375   M S D Wayne Township 181281002034 5223 Maplewood Elementary School   Regular School No Elementary PK 06 2017   pre_kindergarten                         10.0 10.0                       20.0                         10 10                 20
1299626 IN     school 1812810 5375   M S D Wayne Township 181281002033 5241 Garden City Elementary School   Regular School No Elementary PK 06 2017   pre_kindergarten                         12.0 8.0                       20.0                         12 8                 20
1299643 IN     school 1812810 5375   M S D Wayne Township 181281002036 5261 Rhoades Elementary School   Regular School No Elementary PK 06 2017   pre_kindergarten                         10.0 10.0                       20.0                         10 10                 20
1299668 IN     school 1812810 5375   M S D Wayne Township 181281002040 5270 Stout Field Elementary School   Regular School No Elementary PK 06 2017   pre_kindergarten                         7.0 13.0                       20.0                         7 13                 20
1758147 IN     school 1812810 5375   M S D Wayne Township 181281002034 5223 Maplewood Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         8.0 11.0                       19.0                         8 11                 19
1758164 IN     school 1812810 5375   M S D Wayne Township 181281002033 5241 Garden City Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         10.0 10.0                       20.0                         10 10                 20
1758181 IN     school 1812810 5375   M S D Wayne Township 181281002036 5261 Rhoades Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         10.0 10.0                       20.0                         10 10                 20
1758206 IN     school 1812810 5375   M S D Wayne Township 181281002040 5270 Stout Field Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         8.0 11.0                       19.0                         8 11                 19
1793937 IN     school 1812810 5375   M S D Wayne Township 181281002034 5223 Maplewood Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         8.0 12.0                       20.0                         8 12                 20
1793954 IN     school 1812810 5375   M S D Wayne Township 181281002033 5241 Garden City Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         7.0 13.0                       20.0                         7 13                 20
1793971 IN     school 1812810 5375   M S D Wayne Township 181281002036 5261 Rhoades Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         7.0 14.0                       21.0                         7 14                 21
1793996 IN     school 1812810 5375   M S D Wayne Township 181281002040 5270 Stout Field Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         11.0 9.0                       20.0                         11 9                 20
1913571 IN     school 1812810 5375   M S D Wayne Township 181281002034 5223 Maplewood Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         8.0 13.0                       21.0                         8 13                 21
1913580 IN     school 1812810 5375   M S D Wayne Township 181281002030 5227 Chapel Glen Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         2.0 3.0                       5.0                         2 3                 5
1913589 IN     school 1812810 5375   M S D Wayne Township 181281002033 5241 Garden City Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         11.0 10.0                       21.0                         11 10                 21
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
1913607 IN     school 1812810 5375   M S D Wayne Township 181281002036 5261 Rhoades Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         8.0 14.0                       22.0                         8 14                 22
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
1913625 IN     school 1812810 5375   M S D Wayne Township 181281000238 5267 North Wayne Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         2.0 0.0                       2.0                         2 0                 2
1913634 IN     school 1812810 5375   M S D Wayne Township 181281002040 5270 Stout Field Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         9.0 11.0                       20.0                         9 11                 20
1913656 IN     school 1812810 5375   M S D Wayne Township 181281002042 5273 Westlake Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         2.0 2.0                       4.0                         2 2                 4
1913678 IN     school 1812810 5375   M S D Wayne Township 181281002123 5446 Bridgeport Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         1.0 1.0                       2.0                         1 1                 2
1925482 IN     school 1812810 5375   MSD Wayne Township 181281002034 5223 Maplewood Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten                         9.0 11.0                       20.0                         9 11                 20
1925499 IN     school 1812810 5375   MSD Wayne Township 181281002033 5241 Garden City Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten                         12.0 5.0                       17.0                         12 5                 17
1925516 IN     school 1812810 5375   MSD Wayne Township 181281002036 5261 Rhoades Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten                         6.0 10.0                       16.0                         6 10                 16
1925541 IN     school 1812810 5375   MSD Wayne Township 181281002040 5270 Stout Field Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten                         11.0 9.0                       20.0                         11 9                 20
1925562 IN     school 1812810 5375   MSD Wayne Township 181281002042 5273 Westlake Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten                         1.0 0.0                       1.0                         1 0                 1
1166125 IN     school 1812720 5370   M S D Washington Township 181272002444 5434 Hilltop School   Regular School No 1.0 PK PK 2015   pre_kindergarten                         92.0 32.0                       124.0                         92 32                 124
1287527 IN     school 1812720 5370   M S D Washington Township 181272002444 5434 Hilltop School   Regular School No 1.0 PK PK 2016   pre_kindergarten                         46.0 18.0                       64.0                         46 18                 64
1299564 IN     school 1812720 5370   M S D Washington Township 181272002444 5434 Hilltop School   Regular School No Elementary PK PK 2017   pre_kindergarten                         56.0 26.0                       82.0                         56 26                 82
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
1793891 IN     school 1812720 5370   M S D Washington Township 181272002444 5434 Hilltop School   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                         59.0 32.0                       91.0                         59 32                 91
1913526 IN     school 1812720 5370   M S D Washington Township 181272002444 5434 Hilltop School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                         59.0 30.0                       89.0                         59 30                 89
1925437 IN     school 1812720 5370   MSD Washington Township 181272002444 5434 Hilltop School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                         61.0 27.0                       88.0                         61 27                 88
1164157 IN     school 1812420 4415   Warsaw Community Schools 181242002468 3589 Claypool Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         21.0 19.0                       40.0                         21 19                 40
1164185 IN     school 1812420 4415   Warsaw Community Schools 181242001993 3613 Leesburg Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         10.0 10.0                       20.0                         10 10                 20
1285564 IN     school 1812420 4415   Warsaw Community Schools 181242002468 3589 Claypool Elementary School   Regular School No 1.0 PK 06 2016   pre_kindergarten                         0.0 3.0                       3.0                         0 3                 3
1285592 IN     school 1812420 4415   Warsaw Community Schools 181242001993 3613 Leesburg Elementary School   Regular School No 1.0 PK 06 2016   pre_kindergarten                         11.0 7.0                       18.0                         11 7                 18
1297654 IN     school 1812420 4415   Warsaw Community Schools 181242001992 3661 Jefferson Elementary School   Regular School No Elementary PK 06 2017   pre_kindergarten                         6.0 8.0                       14.0                         6 8                 14
1756251 IN     school 1812420 4415   Warsaw Community Schools 181242001992 3661 Jefferson Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         14.0 8.0                       22.0                         14 8                 22
1791994 IN     school 1812420 4415   Warsaw Community Schools 181242001993 3613 Leesburg Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         1.0 2.0                       3.0                         1 2                 3
1792012 IN     school 1812420 4415   Warsaw Community Schools 181242001992 3661 Jefferson Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         11.0 7.0                       18.0                         11 7                 18
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
1923675 IN     school 1812420 4415   Warsaw Community Schools 181242001992 3661 Jefferson Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten                         9.0 4.0                       13.0                         9 4                 13
1170283 IN     school 1812390 8130   Warrick County School Corp 181239002512 8779 Warrick County Preschool   Special Education School No 1.0 PK PK 2015   pre_kindergarten                         35.0 16.0                       51.0                         35 16                 51
1303692 IN     school 1812390 8130   Warrick County School Corp 181239002512 8779 Warrick County Preschool   Special Education School No Elementary PK PK 2017   pre_kindergarten                         44.0 18.0                       62.0                         44 18                 62
1762229 IN     school 1812390 8130   Warrick County School Corp 181239002512 8779 Warrick County Preschool   Special Education School No Prekindergarten PK PK 2019   pre_kindergarten                         48.0 22.0                       70.0                         48 22                 70
1798014 IN     school 1812390 8130   Warrick County School Corp 181239002512 8779 Warrick County Preschool   Special Education School No Prekindergarten PK PK 2018   pre_kindergarten                         42.0 16.0                       58.0                         42 16                 58
1917648 IN     school 1812390 8130   Warrick County School Corp 181239002512 8779 Warrick County Preschool   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten                         47.0 28.0                       75.0                         47 28                 75
1929576 IN     school 1812390 8130   Warrick County School Corp 181239002512 8779 Warrick County Preschool   Special Education School No Prekindergarten PK PK 2021   pre_kindergarten                         56.0 37.0                       93.0                         56 37                 93
1166067 IN     school 1812360 5360   M S D Warren Township 181236000726 5395 Warren Early Childhood Ctr   Regular School No 1.0 PK PK 2015   pre_kindergarten                         149.0 112.0                       261.0                         149 112                 261
1287469 IN     school 1812360 5360   M S D Warren Township 181236000726 5395 Warren Early Childhood Center   Regular School No 1.0 PK PK 2016   pre_kindergarten                         139.0 146.0                       285.0                         139 146                 285
1299506 IN     school 1812360 5360   M S D Warren Township 181236000726 5395 Warren Early Childhood Center   Regular School No Elementary PK PK 2017   pre_kindergarten                         186.0 141.0                       327.0                         186 141                 327
1758044 IN     school 1812360 5360   M S D Warren Township 181236000726 5395 Warren Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                         191.0 127.0                       318.0                         191 127                 318
1793833 IN     school 1812360 5360   M S D Warren Township 181236000726 5395 Warren Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                         193.0 140.0                       333.0                         193 140                 333
1913469 IN     school 1812360 5360   M S D Warren Township 181236000726 5395 Warren Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                         175.0 147.0                       322.0                         175 147                 322
1925380 IN     school 1812360 5360   MSD Warren Township 181236000726 5395 Warren Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                         111.0 88.0                       199.0                         111 88                 199
1291550 IN     school 1812180 8050   M S D Wabash County Schools 181218001947 8656 Southwood Elementary School   Regular School No 1.0 PK 06 2016   pre_kindergarten                         2.0 1.0                       3.0                         2 1                 3
1762110 IN     school 1812180 8050   M S D Wabash County Schools 181218001947 8656 Southwood Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         12.0 6.0                       18.0                         12 6                 18
1762127 IN     school 1812180 8050   M S D Wabash County Schools 181218001944 8677 Metro North Elementary School   Regular School No Elementary PK 03 2019   pre_kindergarten                         15.0 23.0                       38.0                         15 23                 38
1917527 IN     school 1812180 8050   M S D Wabash County Schools 181218001947 8656 Southwood Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         9.0 10.0                       19.0                         9 10                 19
1917545 IN     school 1812180 8050   M S D Wabash County Schools 181218001944 8677 Metro North Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten                         25.0 23.0                       48.0                         25 23                 48
1929456 IN     school 1812180 8050   MSD Wabash County Schools 181218001947 8656 Southwood Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten                         11.0 7.0                       18.0                         11 7                 18
1929474 IN     school 1812180 8050   MSD Wabash County Schools 181218001944 8677 Metro North Elementary School   Regular School No Elementary PK 03 2021   pre_kindergarten                         28.0 12.0                       40.0                         28 12                 40
1170198 IN     school 1812150 8060   Wabash City Schools 181215001937 8706 O J Neighbours Elem Sch   Regular School No 1.0 PK 04 2015   pre_kindergarten                         18.0 13.0                       31.0                         18 13                 31
1291586 IN     school 1812150 8060   Wabash City Schools 181215001937 8706 O J Neighbours Elementary School   Regular School No 1.0 PK 04 2016   pre_kindergarten                         20.0 14.0                       34.0                         20 14                 34
1303607 IN     school 1812150 8060   Wabash City Schools 181215001937 8706 O J Neighbours Elementary School   Regular School No Elementary PK 04 2017   pre_kindergarten                         19.0 9.0                       28.0                         19 9                 28
1762144 IN     school 1812150 8060   Wabash City Schools 181215001937 8706 O J Neighbours Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         29.0 29.0                       58.0                         29 29                 58
1797929 IN     school 1812150 8060   Wabash City Schools 181215001937 8706 O J Neighbours Elementary School   Regular School No Elementary PK 04 2018   pre_kindergarten                         30.0 13.0                       43.0                         30 13                 43
1917563 IN     school 1812150 8060   Wabash City Schools 181215001937 8706 O J Neighbours Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                         55.0 43.0                       98.0                         55 43                 98
1929491 IN     school 1812150 8060   Wabash City Schools 181215001937 8706 O J Neighbours Elementary School   Regular School No Elementary PK 04 2021   pre_kindergarten                         43.0 47.0                       90.0                         43 47                 90
1297569 IN     school 1812120 4335   Vincennes Community School Corp 181212001927 3581 Francis Vigo Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         5.0 5.0                       10.0                         5 5                 10
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
1791925 IN     school 1812120 4335   Vincennes Community School Corp 181212001927 3581 Francis Vigo Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         7.0 7.0                       14.0                         7 7                 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

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