Data source: Big Local News · About: Big Local

11,966 rows where state = "IN" and year = 2020 sorted by rowid descending

View and edit SQL

grade

year

  • 2020 · 11,966
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
1918952 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes High 11 12 2020   pk_12_total 122.0 9.0 19.0     1.0         4.0   60.0 95.0     0.0         86.0   11.0   155.0 122 9 19     1         4   60 95     0     86 11   155
1918951 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes High 11 12 2020   grade_12                         6.0 3.0                       9.0                         6 3                 9
1918950 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes High 11 12 2020   grade_11                         54.0 92.0                       146.0                         54 92                 146
1918949 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 08 2020   pk_12_total 6.0 212.0 11.0               6.0   123.0 112.0     0.0         111.0   26.0   235.0 6 212 11               6   123 112     0     111 26   235
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
1918947 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 08 2020   grade_8                         6.0 9.0                       15.0                         6 9                 15
1918946 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 08 2020   grade_7                         12.0 12.0                       24.0                         12 12                 24
1918945 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 08 2020   grade_6                         18.0 8.0                       26.0                         18 8                 26
1918944 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 08 2020   grade_5                         13.0 11.0                       24.0                         13 11                 24
1918943 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 08 2020   grade_4                         16.0 11.0                       27.0                         16 11                 27
1918942 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 08 2020   grade_3                         13.0 15.0                       28.0                         13 15                 28
1918941 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 08 2020   grade_2                         12.0 15.0                       27.0                         12 15                 27
1918940 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 08 2020   grade_1                         20.0 14.0                       34.0                         20 14                 34
1918939 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 11 2020   pk_12_total 309.0 6.0 14.0 2.0   8.0     1.0   18.0   182.0 176.0     4.0         97.0   62.0   358.0 309 6 14 2   8     1   18   182 176     4     97 62   358
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
1918937 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 11 2020   grade_9                         7.0 11.0                       18.0                         7 11                 18
1918936 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 11 2020   grade_8                         10.0 17.0                       27.0                         10 17                 27
1918935 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 11 2020   grade_7                         14.0 14.0                       28.0                         14 14                 28
1918934 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 11 2020   grade_6                         10.0 16.0                       26.0                         10 16                 26
1918933 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 11 2020   grade_5                         28.0 15.0                       43.0                         28 15                 43
1918932 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 11 2020   grade_4                         13.0 9.0                       22.0                         13 9                 22
1918931 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 11 2020   grade_3                         21.0 18.0                       39.0                         21 18                 39
1918930 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 11 2020   grade_2                         17.0 25.0                       42.0                         17 25                 42
1918929 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 11 2020   grade_11                         10.0 5.0                       15.0                         10 5                 15
1918928 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 11 2020   grade_10                         1.0 10.0                       11.0                         1 10                 11
1918927 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 11 2020   grade_1                         28.0 17.0                       45.0                         28 17                 45
1918926 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 12 2020   pk_12_total 9.0 440.0 11.0               15.0   232.0 243.0     1.0         358.0   62.0   475.0 9 440 11               15   232 243     1     358 62   475
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
1918924 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 12 2020   grade_9                         45.0 37.0                       82.0                         45 37                 82
1918923 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 12 2020   grade_8                         26.0 49.0                       75.0                         26 49                 75
1918922 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 12 2020   grade_7                         15.0 19.0                       34.0                         15 19                 34
1918921 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 12 2020   grade_2                         16.0 18.0                       34.0                         16 18                 34
1918920 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 12 2020   grade_12                         24.0 29.0                       53.0                         24 29                 53
1918919 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 12 2020   grade_11                         23.0 19.0                       42.0                         23 19                 42
1918918 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 12 2020   grade_10                         36.0 44.0                       80.0                         36 44                 80
1918917 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Other KG 12 2020   grade_1                         20.0 13.0                       33.0                         20 13                 33
1918916 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 06 2020   pk_12_total 61.0 280.0 264.0 1.0   5.0         17.0   313.0 315.0     226.0         457.0   71.0   628.0 61 280 264 1   5         17   313 315     226     457 71   628
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
1918914 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 06 2020   grade_6                         39.0 34.0                       73.0                         39 34                 73
1918913 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 06 2020   grade_5                         32.0 30.0                       62.0                         32 30                 62
1918912 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 06 2020   grade_4                         42.0 33.0                       75.0                         42 33                 75
1918911 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 06 2020   grade_3                         49.0 57.0                       106.0                         49 57                 106
1918910 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 06 2020   grade_2                         36.0 54.0                       90.0                         36 54                 90
1918909 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 06 2020   grade_1                         59.0 56.0                       115.0                         59 56                 115
1918908 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 04 2020   pk_12_total 11.0 123.0 8.0           1.0   21.0   86.0 78.0     7.0         123.0   15.0   164.0 11 123 8           1   21   86 78     7     123 15   164
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
1918906 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 04 2020   grade_4                         9.0 5.0                       14.0                         9 5                 14
1918905 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 04 2020   grade_3                         9.0 8.0                       17.0                         9 8                 17
1918904 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 04 2020   grade_2                         18.0 22.0                       40.0                         18 22                 40
1918903 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 04 2020   grade_1                         17.0 17.0                       34.0                         17 17                 34
1918902 IN     school 1800164 9965   Career Academy Middle School 180016402593 7563 Career Academy Middle School   Regular School Yes Middle 06 08 2020   pk_12_total 167.0 125.0 36.0 1.0   4.0         32.0   218.0 147.0     15.0         240.0   83.0   365.0 167 125 36 1   4         32   218 147     15     240 83   365
1918901 IN     school 1800164 9965   Career Academy Middle School 180016402593 7563 Career Academy Middle School   Regular School Yes Middle 06 08 2020   grade_8                         64.0 45.0                       109.0                         64 45                 109
1918900 IN     school 1800164 9965   Career Academy Middle School 180016402593 7563 Career Academy Middle School   Regular School Yes Middle 06 08 2020   grade_7                         63.0 50.0                       113.0                         63 50                 113
1918899 IN     school 1800164 9965   Career Academy Middle School 180016402593 7563 Career Academy Middle School   Regular School Yes Middle 06 08 2020   grade_6                         91.0 52.0                       143.0                         91 52                 143
1918898 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 05 2020   pk_12_total 205.0 279.0 77.0 1.0   1.0         61.0   332.0 292.0     46.0         447.0   116.0   624.0 205 279 77 1   1         61   332 292     46     447 116   624
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
1918896 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 05 2020   grade_5                         56.0 45.0                       101.0                         56 45                 101
1918895 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 05 2020   grade_4                         51.0 38.0                       89.0                         51 38                 89
1918894 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 05 2020   grade_3                         53.0 49.0                       102.0                         53 49                 102
1918893 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 05 2020   grade_2                         49.0 57.0                       106.0                         49 57                 106
1918892 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 05 2020   grade_1                         59.0 42.0                       101.0                         59 42                 101
1918891 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 08 2020   pk_12_total 207.0 1.0 4.0 1.0             5.0   113.0 105.0     0.0         132.0   87.0   218.0 207 1 4 1             5   113 105     0     132 87   218
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
1918889 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 08 2020   grade_8                         1.0 9.0                       10.0                         1 9                 10
1918888 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 08 2020   grade_7                         6.0 6.0                       12.0                         6 6                 12
1918887 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 08 2020   grade_6                         17.0 19.0                       36.0                         17 19                 36
1918886 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 08 2020   grade_5                         16.0 11.0                       27.0                         16 11                 27
1918885 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 08 2020   grade_4                         13.0 12.0                       25.0                         13 12                 25
1918884 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 08 2020   grade_3                         10.0 12.0                       22.0                         10 12                 22
1918883 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 08 2020   grade_2                         17.0 14.0                       31.0                         17 14                 31
1918882 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 08 2020   grade_1                         12.0 11.0                       23.0                         12 11                 23
1918881 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2020   pk_12_total 468.0 5.0 22.0 1.0   1.0         7.0   248.0 256.0     0.0         211.0   109.0   504.0 468 5 22 1   1         7   248 256     0     211 109   504
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
1918879 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2020   grade_9                         24.0 25.0                       49.0                         24 25                 49
1918878 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2020   grade_8                         28.0 27.0                       55.0                         28 27                 55
1918877 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2020   grade_7                         20.0 20.0                       40.0                         20 20                 40
1918876 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2020   grade_6                         12.0 14.0                       26.0                         12 14                 26
1918875 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2020   grade_5                         22.0 21.0                       43.0                         22 21                 43
1918874 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2020   grade_4                         11.0 17.0                       28.0                         11 17                 28
1918873 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2020   grade_3                         28.0 14.0                       42.0                         28 14                 42
1918872 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2020   grade_2                         18.0 16.0                       34.0                         18 16                 34
1918871 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2020   grade_12                         15.0 23.0                       38.0                         15 23                 38
1918870 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2020   grade_11                         20.0 13.0                       33.0                         20 13                 33
1918869 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2020   grade_10                         21.0 25.0                       46.0                         21 25                 46
1918868 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2020   grade_1                         16.0 19.0                       35.0                         16 19                 35
1918867 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes Elementary KG 08 2020   pk_12_total 20.0 340.0 61.0     2.0         19.0   225.0 217.0     33.0         405.0   92.0   442.0 20 340 61     2         19   225 217     33     405 92   442
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
1918865 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes Elementary KG 08 2020   grade_8                         22.0 21.0                       43.0                         22 21                 43
1918864 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes Elementary KG 08 2020   grade_7                         30.0 24.0                       54.0                         30 24                 54
1918863 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes Elementary KG 08 2020   grade_6                         28.0 21.0                       49.0                         28 21                 49
1918862 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes Elementary KG 08 2020   grade_5                         25.0 24.0                       49.0                         25 24                 49
1918861 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes Elementary KG 08 2020   grade_4                         26.0 17.0                       43.0                         26 17                 43
1918860 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes Elementary KG 08 2020   grade_3                         23.0 23.0                       46.0                         23 23                 46
1918859 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes Elementary KG 08 2020   grade_2                         28.0 25.0                       53.0                         28 25                 53
1918858 IN     school 1800146 9935   Vision Academy 180014602566 5899 Vision Academy   Regular School Yes Elementary KG 08 2020   grade_1                         21.0 32.0                       53.0                         21 32                 53
1918857 IN     school 1800124 9925   Phalen Leadership Academy - IN Inc 180012402550 5496 Phalen Leadership Academy - IN Inc   Regular School Yes Elementary KG 07 2020   pk_12_total 6.0 342.0 4.0               15.0   200.0 167.0     0.0         265.0   26.0   367.0 6 342 4               15   200 167     0     265 26   367
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
1918855 IN     school 1800124 9925   Phalen Leadership Academy - IN Inc 180012402550 5496 Phalen Leadership Academy - IN Inc   Regular School Yes Elementary KG 07 2020   grade_7                         12.0 11.0                       23.0                         12 11                 23
1918854 IN     school 1800124 9925   Phalen Leadership Academy - IN Inc 180012402550 5496 Phalen Leadership Academy - IN Inc   Regular School Yes Elementary KG 07 2020   grade_6                         21.0 19.0                       40.0                         21 19                 40
1918853 IN     school 1800124 9925   Phalen Leadership Academy - IN Inc 180012402550 5496 Phalen Leadership Academy - IN Inc   Regular School Yes Elementary KG 07 2020   grade_5                         21.0 23.0                       44.0                         21 23                 44

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