Data source: Big Local News · About: Big Local

84,143 rows where state = "IN" sorted by rowid descending

View and edit SQL

grade

year

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
1930954 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes High 10 12 2021   pk_12_total 127.0 4.0 20.0     2.0         8.0   67.0 94.0     3.0         99.0   23.0   161.0 127 4 20     2         8   67 94     3     99 23   161
1930953 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes High 10 12 2021   grade_12                         29.0 33.0                       62.0                         29 33                 62
1930952 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes High 10 12 2021   grade_11                         37.0 61.0                       98.0                         37 61                 98
1930951 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes High 10 12 2021   grade_10                         1.0 0.0                       1.0                         1 0                 1
1930950 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 08 2021   pk_12_total 3.0 187.0 7.0               10.0   102.0 105.0     1.0         168.0   26.0   207.0 3 187 7               10   102 105     1     168 26   207
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
1930948 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 08 2021   grade_8                         11.0 10.0                       21.0                         11 10                 21
1930947 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 08 2021   grade_7                         17.0 8.0                       25.0                         17 8                 25
1930946 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 08 2021   grade_6                         14.0 10.0                       24.0                         14 10                 24
1930945 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 08 2021   grade_5                         11.0 9.0                       20.0                         11 9                 20
1930944 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 08 2021   grade_4                         10.0 14.0                       24.0                         10 14                 24
1930943 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 08 2021   grade_3                         9.0 14.0                       23.0                         9 14                 23
1930942 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 08 2021   grade_2                         14.0 12.0                       26.0                         14 12                 26
1930941 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 08 2021   grade_1                         9.0 18.0                       27.0                         9 18                 27
1930940 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 12 2021   pk_12_total 347.0 1.0 8.0 1.0   3.0         28.0   194.0 194.0     3.0         85.0   57.0   388.0 347 1 8 1   3         28   194 194     3     85 57   388
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
1930938 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 12 2021   grade_9                         6.0 10.0                       16.0                         6 10                 16
1930937 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 12 2021   grade_8                         10.0 15.0                       25.0                         10 15                 25
1930936 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 12 2021   grade_7                         12.0 18.0                       30.0                         12 18                 30
1930935 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 12 2021   grade_6                         28.0 17.0                       45.0                         28 17                 45
1930934 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 12 2021   grade_5                         9.0 13.0                       22.0                         9 13                 22
1930933 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 12 2021   grade_4                         24.0 18.0                       42.0                         24 18                 42
1930932 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 12 2021   grade_3                         18.0 19.0                       37.0                         18 19                 37
1930931 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 12 2021   grade_2                         27.0 20.0                       47.0                         27 20                 47
1930930 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 12 2021   grade_12                         6.0 3.0                       9.0                         6 3                 9
1930929 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 12 2021   grade_11                         3.0 9.0                       12.0                         3 9                 12
1930928 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 12 2021   grade_10                         3.0 9.0                       12.0                         3 9                 12
1930927 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 12 2021   grade_1                         18.0 19.0                       37.0                         18 19                 37
1930926 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 12 2021   pk_12_total 5.0 390.0 10.0               10.0   206.0 209.0     1.0         317.0   59.0   415.0 5 390 10               10   206 209     1     317 59   415
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
1930924 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 12 2021   grade_9                         24.0 45.0                       69.0                         24 45                 69
1930923 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 12 2021   grade_8                         13.0 17.0                       30.0                         13 17                 30
1930922 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 12 2021   grade_7                         7.0 11.0                       18.0                         7 11                 18
1930921 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 12 2021   grade_3                         15.0 17.0                       32.0                         15 17                 32
1930920 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 12 2021   grade_2                         22.0 14.0                       36.0                         22 14                 36
1930919 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 12 2021   grade_12                         16.0 14.0                       30.0                         16 14                 30
1930918 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 12 2021   grade_11                         32.0 30.0                       62.0                         32 30                 62
1930917 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 12 2021   grade_10                         36.0 31.0                       67.0                         36 31                 67
1930916 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 12 2021   grade_1                         21.0 16.0                       37.0                         21 16                 37
1930915 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 06 2021   pk_12_total 57.0 223.0 294.0 1.0   4.0         18.0   292.0 305.0     233.0         435.0   74.0   597.0 57 223 294 1   4         18   292 305     233     435 74   597
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
1930913 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 06 2021   grade_6                         35.0 28.0                       63.0                         35 28                 63
1930912 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 06 2021   grade_5                         37.0 29.0                       66.0                         37 29                 66
1930911 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 06 2021   grade_4                         46.0 57.0                       103.0                         46 57                 103
1930910 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 06 2021   grade_3                         39.0 51.0                       90.0                         39 51                 90
1930909 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 06 2021   grade_2                         48.0 45.0                       93.0                         48 45                 93
1930908 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 06 2021   grade_1                         42.0 47.0                       89.0                         42 47                 89
1930907 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 05 2021   pk_12_total 14.0 119.0 10.0               18.0   80.0 81.0     6.0         91.0   23.0   161.0 14 119 10               18   80 81     6     91 23   161
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
1930905 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 05 2021   grade_5                         6.0 4.0                       10.0                         6 4                 10
1930904 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 05 2021   grade_4                         8.0 9.0                       17.0                         8 9                 17
1930903 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 05 2021   grade_3                         12.0 20.0                       32.0                         12 20                 32
1930902 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 05 2021   grade_2                         15.0 15.0                       30.0                         15 15                 30
1930901 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 05 2021   grade_1                         21.0 23.0                       44.0                         21 23                 44
1930900 IN     school 1800164 9965   Career Academy Middle School 180016402593 7563 Career Academy Middle School   Regular School Yes Middle 06 08 2021   pk_12_total 166.0 141.0 37.0 1.0   2.0         20.0   214.0 153.0     17.0         225.0   99.0   367.0 166 141 37 1   2         20   214 153     17     225 99   367
1930899 IN     school 1800164 9965   Career Academy Middle School 180016402593 7563 Career Academy Middle School   Regular School Yes Middle 06 08 2021   grade_8                         67.0 56.0                       123.0                         67 56                 123
1930898 IN     school 1800164 9965   Career Academy Middle School 180016402593 7563 Career Academy Middle School   Regular School Yes Middle 06 08 2021   grade_7                         85.0 48.0                       133.0                         85 48                 133
1930897 IN     school 1800164 9965   Career Academy Middle School 180016402593 7563 Career Academy Middle School   Regular School Yes Middle 06 08 2021   grade_6                         62.0 49.0                       111.0                         62 49                 111
1930896 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 05 2021   pk_12_total 189.0 273.0 76.0 1.0             72.0   326.0 285.0     46.0         321.0   123.0   611.0 189 273 76 1             72   326 285     46     321 123   611
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
1930894 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 05 2021   grade_5                         47.0 37.0                       84.0                         47 37                 84
1930893 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 05 2021   grade_4                         53.0 52.0                       105.0                         53 52                 105
1930892 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 05 2021   grade_3                         54.0 53.0                       107.0                         54 53                 107
1930891 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 05 2021   grade_2                         51.0 40.0                       91.0                         51 40                 91
1930890 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 05 2021   grade_1                         53.0 54.0                       107.0                         53 54                 107
1930889 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 08 2021   pk_12_total 184.0   4.0               5.0   106.0 87.0     0.0         118.0   71.0   193.0 184   4               5   106 87     0     118 71   193
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
1930887 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 08 2021   grade_8                         6.0 4.0                       10.0                         6 4                 10
1930886 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 08 2021   grade_7                         8.0 6.0                       14.0                         8 6                 14
1930885 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 08 2021   grade_6                         11.0 11.0                       22.0                         11 11                 22
1930884 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 08 2021   grade_5                         9.0 14.0                       23.0                         9 14                 23
1930883 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 08 2021   grade_4                         10.0 7.0                       17.0                         10 7                 17
1930882 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 08 2021   grade_3                         15.0 7.0                       22.0                         15 7                 22
1930881 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 08 2021   grade_2                         12.0 12.0                       24.0                         12 12                 24
1930880 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 08 2021   grade_1                         18.0 14.0                       32.0                         18 14                 32
1930879 IN     school 1800225 9954   Phalen Leadership Academy at Louis 180022500867 5548 Louis B Russell Jr School 48   Regular School Yes Elementary KG 06 2021   pk_12_total 6.0 163.0 27.0               17.0   113.0 100.0     12.0         189.0   35.0   213.0 6 163 27               17   113 100     12     189 35   213
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
1930877 IN     school 1800225 9954   Phalen Leadership Academy at Louis 180022500867 5548 Louis B Russell Jr School 48   Regular School Yes Elementary KG 06 2021   grade_6                         11.0 14.0                       25.0                         11 14                 25
1930876 IN     school 1800225 9954   Phalen Leadership Academy at Louis 180022500867 5548 Louis B Russell Jr School 48   Regular School Yes Elementary KG 06 2021   grade_5                         14.0 15.0                       29.0                         14 15                 29
1930875 IN     school 1800225 9954   Phalen Leadership Academy at Louis 180022500867 5548 Louis B Russell Jr School 48   Regular School Yes Elementary KG 06 2021   grade_4                         17.0 16.0                       33.0                         17 16                 33
1930874 IN     school 1800225 9954   Phalen Leadership Academy at Louis 180022500867 5548 Louis B Russell Jr School 48   Regular School Yes Elementary KG 06 2021   grade_3                         22.0 17.0                       39.0                         22 17                 39
1930873 IN     school 1800225 9954   Phalen Leadership Academy at Louis 180022500867 5548 Louis B Russell Jr School 48   Regular School Yes Elementary KG 06 2021   grade_2                         21.0 16.0                       37.0                         21 16                 37
1930872 IN     school 1800225 9954   Phalen Leadership Academy at Louis 180022500867 5548 Louis B Russell Jr School 48   Regular School Yes Elementary KG 06 2021   grade_1                         17.0 13.0                       30.0                         17 13                 30
1930871 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2021   pk_12_total 508.0 3.0 26.0     1.0         5.0   274.0 269.0     1.0         312.0   119.0   543.0 508 3 26     1         5   274 269     1     312 119   543
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
1930869 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2021   grade_9                         32.0 31.0                       63.0                         32 31                 63
1930868 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2021   grade_8                         16.0 26.0                       42.0                         16 26                 42
1930867 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2021   grade_7                         19.0 15.0                       34.0                         19 15                 34
1930866 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2021   grade_6                         29.0 23.0                       52.0                         29 23                 52
1930865 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2021   grade_5                         13.0 25.0                       38.0                         13 25                 38
1930864 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2021   grade_4                         27.0 11.0                       38.0                         27 11                 38
1930863 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2021   grade_3                         23.0 20.0                       43.0                         23 20                 43
1930862 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2021   grade_2                         17.0 18.0                       35.0                         17 18                 35
1930861 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2021   grade_12                         20.0 16.0                       36.0                         20 16                 36
1930860 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2021   grade_11                         18.0 24.0                       42.0                         18 24                 42
1930859 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2021   grade_10                         24.0 24.0                       48.0                         24 24                 48
1930858 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2021   grade_1                         17.0 18.0                       35.0                         17 18                 35
1930857 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes Elementary KG 08 2021   pk_12_total 16.0 331.0 49.0 1.0   2.0         27.0   215.0 211.0     33.0         372.0   82.0   426.0 16 331 49 1   2         27   215 211     33     372 82   426
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
1930855 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes Elementary KG 08 2021   grade_8                         23.0 23.0                       46.0                         23 23                 46

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