Data source: Big Local News · About: Big Local

12,058 rows where state = "IN" and year = 2017 sorted by district

View and edit SQL

grade

year

  • 2017 · 12,058
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
1304414 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   grade_1                         27.0 43.0                       70.0                         27 43                 70
1304415 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   grade_10                         31.0 43.0                       74.0                         31 43                 74
1304416 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   grade_11                         36.0 35.0                       71.0                         36 35                 71
1304417 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   grade_12                         19.0 27.0                       46.0                         19 27                 46
1304418 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   grade_2                         42.0 31.0                       73.0                         42 31                 73
1304419 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   grade_3                         34.0 45.0                       79.0                         34 45                 79
1304420 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   grade_4                         24.0 36.0                       60.0                         24 36                 60
1304421 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   grade_5                         38.0 23.0                       61.0                         38 23                 61
1304422 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   grade_6                         31.0 28.0                       59.0                         31 28                 59
1304423 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   grade_7                         29.0 43.0                       72.0                         29 43                 72
1304424 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   grade_8                         45.0 30.0                       75.0                         45 30                 75
1304425 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   grade_9                         51.0 24.0                       75.0                         51 24                 75
1304426 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   kindergarten                         37.0 36.0                       73.0                         37 36                 73
1304427 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   pk_12_total 3.0 860.0 11.0 1.0             13.0   444.0 444.0     0.0             105.0   888.0 3 860 11 1             13   444 444     0       105   888
1304943 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 01 2017   grade_1                         3.0 7.0                       10.0                         3 7                 10
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
1304945 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 01 2017   pk_12_total 6.0 23.0 4.0               3.0   14.0 22.0     1.0             2.0   36.0 6 23 4               3   14 22     1       2   36
1292914 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2017   grade_6                         50.0 36.0                       86.0                         50 36                 86
1292915 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2017   grade_7                         38.0 42.0                       80.0                         38 42                 80
1292916 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2017   grade_8                         48.0 55.0                       103.0                         48 55                 103
1292917 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2017   pk_12_total 253.0 3.0 6.0 1.0   3.0         3.0   136.0 133.0     5.0             16.0   269.0 253 3 6 1   3         3   136 133     5       16   269
1292918 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_1                         54.0 40.0                       94.0                         54 40                 94
1292919 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_2                         53.0 52.0                       105.0                         53 52                 105
1292920 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_3                         63.0 38.0                       101.0                         63 38                 101
1292921 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_4                         51.0 52.0                       103.0                         51 52                 103
1292922 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_5                         50.0 51.0                       101.0                         50 51                 101
1292923 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         62.0 42.0                       104.0                         62 42                 104
1292924 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 566.0 8.0 25.0     4.0         9.0   335.0 277.0     22.0             88.0   612.0 566 8 25     4         9   335 277     22       88   612
1292925 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         2.0 2.0                       4.0                         2 2                 4
1292926 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2017   adult                         2.0 1.0                       3.0                         2 1                 3
1292927 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2017   grade_10                         46.0 55.0                       101.0                         46 55                 101
1292928 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2017   grade_11                         48.0 33.0                       81.0                         48 33                 81
1292929 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2017   grade_12                         45.0 57.0                       102.0                         45 57                 102
1292930 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2017   grade_9                         42.0 49.0                       91.0                         42 49                 91
1292931 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2017   pk_12_total 358.0   9.0 2.0   8.0         1.0   183.0 195.0     8.0             28.0   378.0 358   9 2   8         1   183 195     8       28   378
1298951 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2017   grade_10                         61.0 63.0                       124.0                         61 63                 124
1298952 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2017   grade_11                         73.0 61.0                       134.0                         73 61                 134
1298953 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2017   grade_12                         60.0 62.0                       122.0                         60 62                 122
1298954 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2017   grade_7                         49.0 63.0                       112.0                         49 63                 112
1298955 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2017   grade_8                         58.0 69.0                       127.0                         58 69                 127
1298956 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2017   grade_9                         69.0 57.0                       126.0                         69 57                 126
1298957 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2017   pk_12_total 671.0 1.0 56.0 1.0   3.0         13.0   370.0 375.0     8.0             94.0   745.0 671 1 56 1   3         13   370 375     8       94   745
1298958 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2017   grade_3                         67.0 50.0                       117.0                         67 50                 117
1298959 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2017   grade_4                         54.0 51.0                       105.0                         54 51                 105
1298960 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2017   grade_5                         71.0 54.0                       125.0                         71 54                 125
1298961 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2017   grade_6                         55.0 57.0                       112.0                         55 57                 112
1298962 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2017   pk_12_total 399.0 2.0 43.0               15.0   247.0 212.0     2.0             91.0   459.0 399 2 43               15   247 212     2       91   459
1298963 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2017   grade_1                         53.0 43.0                       96.0                         53 43                 96
1298964 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2017   grade_2                         63.0 64.0                       127.0                         63 64                 127
1298965 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2017   kindergarten                         56.0 47.0                       103.0                         56 47                 103
1298966 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2017   pk_12_total 303.0 1.0 38.0               15.0   192.0 165.0     8.0             75.0   357.0 303 1 38               15   192 165     8       75   357
1298967 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2017   pre_kindergarten                         20.0 11.0                       31.0                         20 11                 31
1298968 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No High 09 12 2017   grade_10                         272.0 221.0                       493.0                         272 221                 493
1298969 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No High 09 12 2017   grade_11                         278.0 207.0                       485.0                         278 207                 485
1298970 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No High 09 12 2017   grade_12                         203.0 237.0                       440.0                         203 237                 440
1298971 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No High 09 12 2017   grade_9                         268.0 247.0                       515.0                         268 247                 515
1298972 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No High 09 12 2017   pk_12_total 1109.0 485.0 202.0 3.0   9.0         125.0   1021.0 912.0     34.0             385.0   1933.0 1109 485 202 3   9         125   1021 912     34       385   1933
1298973 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2017   grade_1                         28.0 27.0                       55.0                         28 27                 55
1298974 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2017   grade_2                         25.0 23.0                       48.0                         25 23                 48
1298975 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2017   grade_3                         32.0 30.0                       62.0                         32 30                 62
1298976 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2017   grade_4                         17.0 23.0                       40.0                         17 23                 40
1298977 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2017   grade_5                         18.0 21.0                       39.0                         18 21                 39
1298978 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         14.0 25.0                       39.0                         14 25                 39
1298979 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 118.0 95.0 19.0               51.0   134.0 149.0     4.0             60.0   283.0 118 95 19               51   134 149     4       60   283
1298980 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2017   grade_1                         77.0 42.0                       119.0                         77 42                 119
1298981 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2017   grade_2                         75.0 45.0                       120.0                         75 45                 120
1298982 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2017   grade_3                         68.0 53.0                       121.0                         68 53                 121
1298983 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2017   grade_4                         58.0 45.0                       103.0                         58 45                 103
1298984 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2017   grade_5                         46.0 47.0                       93.0                         46 47                 93
1298985 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         53.0 52.0                       105.0                         53 52                 105
1298986 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 403.0 126.0 51.0 2.0   2.0         77.0   377.0 284.0     6.0             157.0   661.0 403 126 51 2   2         77   377 284     6       157   661
1298987 IN     school 1800150 5275   Anderson Community School Corp 180015002557 5023 Southview Preschool Center   Regular School No Elementary PK PK 2017   pk_12_total 216.0 41.0 44.0               24.0   199.0 126.0     0.0             154.0   325.0 216 41 44               24   199 126     0       154   325
1298988 IN     school 1800150 5275   Anderson Community School Corp 180015002557 5023 Southview Preschool Center   Regular School No Elementary PK PK 2017   pre_kindergarten                         199.0 126.0                       325.0                         199 126                 325
1298989 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2017   grade_1                         58.0 44.0                       102.0                         58 44                 102
1298990 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2017   grade_2                         62.0 43.0                       105.0                         62 43                 105
1298991 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2017   grade_3                         59.0 49.0                       108.0                         59 49                 108
1298992 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2017   grade_4                         49.0 48.0                       97.0                         49 48                 97
1298993 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2017   grade_5                         52.0 40.0                       92.0                         52 40                 92
1298994 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         53.0 56.0                       109.0                         53 56                 109
1298995 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 376.0 108.0 64.0 1.0   3.0         61.0   333.0 280.0     12.0             133.0   613.0 376 108 64 1   3         61   333 280     12       133   613
1298996 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No Middle 06 08 2017   grade_6                         268.0 227.0                       495.0                         268 227                 495
1298997 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No Middle 06 08 2017   grade_7                         244.0 212.0                       456.0                         244 212                 456
1298998 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No Middle 06 08 2017   grade_8                         245.0 207.0                       452.0                         245 207                 452
1298999 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No Middle 06 08 2017   pk_12_total 796.0 319.0 167.0 2.0   5.0         114.0   757.0 646.0     41.0             320.0   1403.0 796 319 167 2   5         114   757 646     41       320   1403
1299000 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 05 2017   grade_1                         50.0 45.0                       95.0                         50 45                 95
1299001 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 05 2017   grade_2                         45.0 49.0                       94.0                         45 49                 94
1299002 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 05 2017   grade_3                         58.0 59.0                       117.0                         58 59                 117
1299003 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 05 2017   grade_4                         72.0 53.0                       125.0                         72 53                 125
1299004 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 05 2017   grade_5                         54.0 52.0                       106.0                         54 52                 106
1299005 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         48.0 38.0                       86.0                         48 38                 86
1299006 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 415.0 83.0 59.0 2.0             64.0   327.0 296.0     7.0             126.0   623.0 415 83 59 2             64   327 296     7       126   623
1299007 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 05 2017   grade_1                         56.0 41.0                       97.0                         56 41                 97
1299008 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 05 2017   grade_2                         45.0 58.0                       103.0                         45 58                 103
1299009 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 05 2017   grade_3                         62.0 50.0                       112.0                         62 50                 112
1299010 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 05 2017   grade_4                         49.0 57.0                       106.0                         49 57                 106
1299011 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 05 2017   grade_5                         46.0 57.0                       103.0                         46 57                 103
1299012 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         48.0 52.0                       100.0                         48 52                 100
1299013 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 155.0 163.0 249.0 1.0   2.0         51.0   306.0 315.0     153.0             117.0   621.0 155 163 249 1   2         51   306 315     153       117   621
1299014 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No Elementary KG 05 2017   grade_1                         65.0 59.0                       124.0                         65 59                 124
1299015 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No Elementary KG 05 2017   grade_2                         60.0 40.0                       100.0                         60 40                 100

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