Data source: Big Local News · About: Big Local

7,228 rows where grade = "kindergarten" and state = "IN" sorted by district_state_id descending

View and edit SQL

year

grade

  • kindergarten · 7,228
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
1304968 IN     school 1800178 9990   Heritage Institute of Arts & Tech 180017802602 1116 Heritage Institute of Arts & Tech   Regular School Yes Elementary KG 05 2017   kindergarten                         26.0 29.0                       55.0                         26 29                 55
1763532 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 07 2019   kindergarten                         15.0 5.0                       20.0                         15 5                 20
1799300 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 06 2018   kindergarten                         33.0 33.0                       66.0                         33 33                 66
1918948 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 08 2020   kindergarten                         13.0 17.0                       30.0                         13 17                 30
1930949 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 08 2021   kindergarten                         7.0 10.0                       17.0                         7 10                 17
1304961 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Elementary KG 08 2017   kindergarten                         16.0 15.0                       31.0                         16 15                 31
1763523 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   kindergarten                         30.0 21.0                       51.0                         30 21                 51
1799292 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 09 2018   kindergarten                         27.0 21.0                       48.0                         27 21                 48
1918938 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 11 2020   kindergarten                         23.0 19.0                       42.0                         23 19                 42
1930939 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 12 2021   kindergarten                         30.0 24.0                       54.0                         30 24                 54
1763511 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 11 2019   kindergarten                         14.0 13.0                       27.0                         14 13                 27
1918925 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 12 2020   kindergarten                         27.0 15.0                       42.0                         27 15                 42
1930925 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 12 2021   kindergarten                         20.0 14.0                       34.0                         20 14                 34
1304948 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 02 2017   kindergarten                         50.0 66.0                       116.0                         50 66                 116
1763503 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 04 2019   kindergarten                         57.0 53.0                       110.0                         57 53                 110
1799276 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 03 2018   kindergarten                         37.0 37.0                       74.0                         37 37                 74
1918915 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 06 2020   kindergarten                         56.0 51.0                       107.0                         56 51                 107
1930914 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 06 2021   kindergarten                         45.0 48.0                       93.0                         45 48                 93
1304944 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 01 2017   kindergarten                         11.0 15.0                       26.0                         11 15                 26
1763497 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 03 2019   kindergarten                         16.0 8.0                       24.0                         16 8                 24
1799271 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 02 2018   kindergarten                         19.0 24.0                       43.0                         19 24                 43
1918907 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 04 2020   kindergarten                         33.0 26.0                       59.0                         33 26                 59
1930906 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 05 2021   kindergarten                         18.0 10.0                       28.0                         18 10                 28
1292907 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes 1.0 KG 04 2016   kindergarten                         55.0 28.0                       83.0                         55 28                 83
1304936 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 04 2017   kindergarten                         51.0 46.0                       97.0                         51 46                 97
1763488 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 05 2019   kindergarten                         62.0 46.0                       108.0                         62 46                 108
1799263 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 05 2018   kindergarten                         44.0 68.0                       112.0                         44 68                 112
1918897 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 05 2020   kindergarten                         64.0 61.0                       125.0                         64 61                 125
1930895 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 05 2021   kindergarten                         68.0 49.0                       117.0                         68 49                 117
1292901 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes 1.0 KG 06 2016   kindergarten                         6.0 7.0                       13.0                         6 7                 13
1304930 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 06 2017   kindergarten                         22.0 17.0                       39.0                         22 17                 39
1763481 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 07 2019   kindergarten                         12.0 12.0                       24.0                         12 12                 24
1799256 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 06 2018   kindergarten                         13.0 15.0                       28.0                         13 15                 28
1918890 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 08 2020   kindergarten                         21.0 11.0                       32.0                         21 11                 32
1930888 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 08 2021   kindergarten                         17.0 12.0                       29.0                         17 12                 29
1930878 IN     school 1800225 9954   Phalen Leadership Academy at Louis 180022500867 5548 Louis B Russell Jr School 48   Regular School Yes Elementary KG 06 2021   kindergarten                         11.0 9.0                       20.0                         11 9                 20
1292893 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes 4.0 KG 12 2016   kindergarten                         7.0 6.0                       13.0                         7 6                 13
1304922 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2017   kindergarten                         17.0 7.0                       24.0                         17 7                 24
1763472 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2019   kindergarten                         12.0 11.0                       23.0                         12 11                 23
1799248 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2018   kindergarten                         11.0 7.0                       18.0                         11 7                 18
1918880 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2020   kindergarten                         13.0 22.0                       35.0                         13 22                 35
1930870 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2021   kindergarten                         19.0 18.0                       37.0                         19 18                 37
1171504 IN     school 1800141 9945   Tindley Renaissance Academy 180014102558 5926 Tindley Renaissance Academy   Regular School Yes 1.0 KG 04 2015   kindergarten                         39.0 50.0                       89.0                         39 50                 89
1292879 IN     school 1800141 9945   Tindley Renaissance Academy 180014102558 5926 Tindley Renaissance Academy   Regular School Yes 1.0 KG 04 2016   kindergarten                         36.0 37.0                       73.0                         36 37                 73
1304908 IN     school 1800141 9945   Tindley Renaissance Academy 180014102558 5926 Tindley Renaissance Academy   Regular School Yes Elementary KG 05 2017   kindergarten                         56.0 55.0                       111.0                         56 55                 111
1763458 IN     school 1800141 9945   Tindley Renaissance Academy 180014102558 5926 Tindley Renaissance Academy   Regular School Yes Elementary KG 05 2019   kindergarten                         33.0 42.0                       75.0                         33 42                 75
1799234 IN     school 1800141 9945   Tindley Renaissance Academy 180014102558 5926 Tindley Renaissance Academy   Regular School Yes Elementary KG 05 2018   kindergarten                         31.0 45.0                       76.0                         31 45                 76
1171493 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes 1.0 KG 06 2015   kindergarten                         30.0 23.0                       53.0                         30 23                 53
1292868 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes 1.0 KG 07 2016   kindergarten                         29.0 21.0                       50.0                         29 21                 50
1304897 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes Elementary KG 08 2017   kindergarten                         27.0 22.0                       49.0                         27 22                 49
1763447 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes Elementary KG 08 2019   kindergarten                         19.0 26.0                       45.0                         19 26                 45
1799223 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes Elementary KG 08 2018   kindergarten                         24.0 29.0                       53.0                         24 29                 53
1918866 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes Elementary KG 08 2020   kindergarten                         22.0 30.0                       52.0                         22 30                 52
1930856 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes Elementary KG 08 2021   kindergarten                         30.0 24.0                       54.0                         30 24                 54
1171480 IN     school 1800124 9925   Phalen Ldrshp Acad - IN Inc 180012402550 5496 Phalen Ldrshp Acad - IN Inc   Regular School Yes 1.0 KG 03 2015   kindergarten                         46.0 64.0                       110.0                         46 64                 110
1292854 IN     school 1800124 9925   Phalen Leadership Academy - IN Inc 180012402550 5496 Phalen Leadership Academy - IN Inc   Regular School Yes 1.0 KG 04 2016   kindergarten                         49.0 42.0                       91.0                         49 42                 91
1304882 IN     school 1800124 9925   Phalen Leadership Academy - IN Inc 180012402550 5496 Phalen Leadership Academy - IN Inc   Regular School Yes Elementary KG 05 2017   kindergarten                         36.0 29.0                       65.0                         36 29                 65
1763437 IN     school 1800124 9925   Phalen Leadership Academy - IN Inc 180012402550 5496 Phalen Leadership Academy - IN Inc   Regular School Yes Elementary KG 06 2019   kindergarten                         24.0 17.0                       41.0                         24 17                 41
1799208 IN     school 1800124 9925   Phalen Leadership Academy - IN Inc 180012402550 5496 Phalen Leadership Academy - IN Inc   Regular School Yes Elementary KG 06 2018   kindergarten                         33.0 23.0                       56.0                         33 23                 56
1918856 IN     school 1800124 9925   Phalen Leadership Academy - IN Inc 180012402550 5496 Phalen Leadership Academy - IN Inc   Regular School Yes Elementary KG 07 2020   kindergarten                         36.0 25.0                       61.0                         36 25                 61
1930846 IN     school 1800124 9925   Phalen Leadership Academy - IN Inc 180012402550 5496 Phalen Leadership Academy - IN Inc   Regular School Yes Elementary KG 08 2021   kindergarten                         24.0 18.0                       42.0                         24 18                 42
1171475 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2015   kindergarten                         0.0 1.0                       1.0                         0 1                 1
1292848 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2016   kindergarten                         2.0 0.0                       2.0                         2 0                 2
1304875 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2017   kindergarten                         3.0 0.0                       3.0                         3 0                 3
1763429 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2019   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1799200 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2018   kindergarten                         2.0 1.0                       3.0                         2 1                 3
1930836 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2021   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1171455 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes 4.0 KG 12 2015   kindergarten                         42.0 42.0                       84.0                         42 42                 84
1292821 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes 4.0 KG 12 2016   kindergarten                         35.0 44.0                       79.0                         35 44                 79
1304849 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2017   kindergarten                         40.0 34.0                       74.0                         40 34                 74
1763403 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2019   kindergarten                         63.0 69.0                       132.0                         63 69                 132
1799174 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2018   kindergarten                         68.0 61.0                       129.0                         68 61                 129
1918829 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2020   kindergarten                         57.0 59.0                       116.0                         57 59                 116
1930818 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2021   kindergarten                         140.0 132.0                       272.0                         140 132                 272
1171441 IN     school 1800094 9895   Indiana Math Science Academy North 180009402487 5444 IN Math & Science Acad North   Regular School Yes 4.0 KG 12 2015   kindergarten                         30.0 46.0                       76.0                         30 46                 76
1292805 IN     school 1800094 9895   Indiana Math Science Academy North 180009402487 5444 IN Math & Science Acad North   Regular School Yes 4.0 KG 12 2016   kindergarten                         26.0 22.0                       48.0                         26 22                 48
1304831 IN     school 1800094 9895   IN Math & Science Academy - North 180009402487 5444 IN Math & Science Academy - North   Regular School Yes Other KG 12 2017   kindergarten                         12.0 14.0                       26.0                         12 14                 26
1763386 IN     school 1800094 9895   IN Math & Science Academy - North 180009402487 5444 IN Math & Science Academy - North   Regular School Yes Other KG 12 2019   kindergarten                         21.0 23.0                       44.0                         21 23                 44
1799157 IN     school 1800094 9895   IN Math & Science Academy - North 180009402487 5444 IN Math & Science Academy - North   Regular School Yes Other KG 12 2018   kindergarten                         16.0 25.0                       41.0                         16 25                 41
1918812 IN     school 1800094 9895   IN Math & Science Academy - North 180009402487 5444 IN Math & Science Academy - North   Regular School Yes Other KG 12 2020   kindergarten                         31.0 17.0                       48.0                         31 17                 48
1930801 IN     school 1800094 9895   IN Math & Science Academy - North 180009402487 5444 IN Math & Science Academy - North   Regular School Yes Other KG 12 2021   kindergarten                         20.0 25.0                       45.0                         20 25                 45
1171405 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes 4.0 KG 12 2015   kindergarten                         19.0 22.0                       41.0                         19 22                 41
1292772 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes 4.0 KG 12 2016   kindergarten                         20.0 22.0                       42.0                         20 22                 42
1304798 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes Other KG 12 2017   kindergarten                         19.0 21.0                       40.0                         19 21                 40
1763353 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes Other KG 12 2019   kindergarten                         18.0 25.0                       43.0                         18 25                 43
1799125 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes Other KG 12 2018   kindergarten                         15.0 21.0                       36.0                         15 21                 36
1918789 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes Other KG 12 2020   kindergarten                         19.0 21.0                       40.0                         19 21                 40
1930777 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes Other KG 12 2021   kindergarten                         33.0 33.0                       66.0                         33 33                 66
1171391 IN     school 1800088 9870   Discovery Charter School 180008802495 6824 Discovery Charter School   Regular School Yes 1.0 KG 08 2015   kindergarten                         36.0 30.0                       66.0                         36 30                 66
1292758 IN     school 1800088 9870   Discovery Charter School 180008802495 6824 Discovery Charter School   Regular School Yes 1.0 KG 08 2016   kindergarten                         39.0 27.0                       66.0                         39 27                 66
1304784 IN     school 1800088 9870   Discovery Charter School 180008802495 6824 Discovery Charter School   Regular School Yes Elementary KG 08 2017   kindergarten                         37.0 28.0                       65.0                         37 28                 65
1763339 IN     school 1800088 9870   Discovery Charter School 180008802495 6824 Discovery Charter School   Regular School Yes Elementary KG 08 2019   kindergarten                         34.0 32.0                       66.0                         34 32                 66
1799111 IN     school 1800088 9870   Discovery Charter School 180008802495 6824 Discovery Charter School   Regular School Yes Elementary KG 08 2018   kindergarten                         30.0 35.0                       65.0                         30 35                 65
1918775 IN     school 1800088 9870   Discovery Charter School 180008802495 6824 Discovery Charter School   Regular School Yes Elementary KG 08 2020   kindergarten                         36.0 30.0                       66.0                         36 30                 66
1930763 IN     school 1800088 9870   Discovery Charter School 180008802495 6824 Discovery Charter School   Regular School Yes Elementary KG 08 2021   kindergarten                         36.0 30.0                       66.0                         36 30                 66
1171381 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes 4.0 KG 12 2015   kindergarten                         75.0 76.0                       151.0                         75 76                 151
1292748 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes 4.0 KG 12 2016   kindergarten                         77.0 59.0                       136.0                         77 59                 136
1304774 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes Other KG 12 2017   kindergarten                         82.0 88.0                       170.0                         82 88                 170
1799101 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes Other KG 12 2018   kindergarten                         20.0 24.0                       44.0                         20 24                 44
1171367 IN     school 1800084 9850   Imagine Life Sciences Acad - West 180008402447 5484 Imagine Ind Life Science West   Regular School Yes 1.0 KG 08 2015   kindergarten                         35.0 33.0                       68.0                         35 33                 68

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