Data source: Big Local News · About: Big Local

84,143 rows where state = "IN" sorted by district_state_id 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
1304970 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes Other 11 11 2017   grade_11                         31.0 53.0                       84.0                         31 53                 84
1304971 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes Other 11 11 2017   pk_12_total 75.0 3.0 4.0               2.0   31.0 53.0     1.0             3.0   84.0 75 3 4               2   31 53     1       3   84
1799302 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes High 10 12 2018   grade_10                         1.0 0.0                       1.0                         1 0                 1
1799303 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes High 10 12 2018   grade_11                         28.0 50.0                       78.0                         28 50                 78
1799304 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes High 10 12 2018   grade_12                         12.0 31.0                       43.0                         12 31                 43
1799305 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes High 10 12 2018   pk_12_total 102.0 6.0 8.0 1.0             5.0   41.0 81.0     5.0         89.0   7.0   122.0 102 6 8 1             5   41 81     5     89 7   122
1763534 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes High 10 12 2019   grade_10                         0.0 1.0                       1.0                         0 1                 1
1763535 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes High 10 12 2019   grade_11                         39.0 57.0                       96.0                         39 57                 96
1763536 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes High 10 12 2019   grade_12                         25.0 37.0                       62.0                         25 37                 62
1763537 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes High 10 12 2019   pk_12_total 119.0 5.0 29.0     1.0     1.0   4.0   64.0 95.0     15.0         93.0   17.0   159.0 119 5 29     1     1   4   64 95     15     93 17   159
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
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
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
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
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
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
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
1304963 IN     school 1800178 9990   Heritage Institute of Arts & Tech 180017802602 1116 Heritage Institute of Arts & Tech   Regular School Yes Elementary KG 05 2017   grade_1                         16.0 8.0                       24.0                         16 8                 24
1304964 IN     school 1800178 9990   Heritage Institute of Arts & Tech 180017802602 1116 Heritage Institute of Arts & Tech   Regular School Yes Elementary KG 05 2017   grade_2                         14.0 8.0                       22.0                         14 8                 22
1304965 IN     school 1800178 9990   Heritage Institute of Arts & Tech 180017802602 1116 Heritage Institute of Arts & Tech   Regular School Yes Elementary KG 05 2017   grade_3                         8.0 15.0                       23.0                         8 15                 23
1304966 IN     school 1800178 9990   Heritage Institute of Arts & Tech 180017802602 1116 Heritage Institute of Arts & Tech   Regular School Yes Elementary KG 05 2017   grade_4                         9.0 3.0                       12.0                         9 3                 12
1304967 IN     school 1800178 9990   Heritage Institute of Arts & Tech 180017802602 1116 Heritage Institute of Arts & Tech   Regular School Yes Elementary KG 05 2017   grade_5                         4.0 13.0                       17.0                         4 13                 17
1304968 IN     school 1800178 9990   Heritage Institute of Arts & Tech 180017802602 1116 Heritage Institute of Arts & Tech   Regular School Yes Elementary KG 05 2017   kindergarten                         26.0 29.0                       55.0                         26 29                 55
1304969 IN     school 1800178 9990   Heritage Institute of Arts & Tech 180017802602 1116 Heritage Institute of Arts & Tech   Regular School Yes Elementary KG 05 2017   pk_12_total 7.0 124.0 14.0 1.0             7.0   77.0 76.0     0.0             18.0   153.0 7 124 14 1             7   77 76     0       18   153
1799294 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 06 2018   grade_1                         24.0 19.0                       43.0                         24 19                 43
1799295 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 06 2018   grade_2                         17.0 9.0                       26.0                         17 9                 26
1799296 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 06 2018   grade_3                         11.0 13.0                       24.0                         11 13                 24
1799297 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 06 2018   grade_4                         18.0 7.0                       25.0                         18 7                 25
1799298 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 06 2018   grade_5                         8.0 14.0                       22.0                         8 14                 22
1799299 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 06 2018   grade_6                         8.0 11.0                       19.0                         8 11                 19
1799300 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 06 2018   kindergarten                         33.0 33.0                       66.0                         33 33                 66
1799301 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 06 2018   pk_12_total 4.0 208.0 5.0               8.0   119.0 106.0     0.0         189.0   13.0   225.0 4 208 5               8   119 106     0     189 13   225
1763525 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 07 2019   grade_1                         13.0 12.0                       25.0                         13 12                 25
1763526 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 07 2019   grade_2                         12.0 17.0                       29.0                         12 17                 29
1763527 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 07 2019   grade_3                         14.0 11.0                       25.0                         14 11                 25
1763528 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 07 2019   grade_4                         9.0 4.0                       13.0                         9 4                 13
1763529 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 07 2019   grade_5                         13.0 7.0                       20.0                         13 7                 20
1763530 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 07 2019   grade_6                         8.0 16.0                       24.0                         8 16                 24
1763531 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 07 2019   grade_7                         5.0 5.0                       10.0                         5 5                 10
1763532 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 07 2019   kindergarten                         15.0 5.0                       20.0                         15 5                 20
1763533 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 07 2019   pk_12_total 5.0 152.0 5.0               4.0   89.0 77.0     0.0         136.0   14.0   166.0 5 152 5               4   89 77     0     136 14   166
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1304953 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Elementary KG 08 2017   grade_1                         8.0 6.0                       14.0                         8 6                 14
1304954 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Elementary KG 08 2017   grade_2                         12.0 8.0                       20.0                         12 8                 20
1304955 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Elementary KG 08 2017   grade_3                         12.0 10.0                       22.0                         12 10                 22
1304956 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Elementary KG 08 2017   grade_4                         6.0 6.0                       12.0                         6 6                 12
1304957 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Elementary KG 08 2017   grade_5                         10.0 8.0                       18.0                         10 8                 18
1304958 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Elementary KG 08 2017   grade_6                         10.0 12.0                       22.0                         10 12                 22
1304959 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Elementary KG 08 2017   grade_7                         4.0 7.0                       11.0                         4 7                 11
1304960 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Elementary KG 08 2017   grade_8                         5.0 6.0                       11.0                         5 6                 11
1304961 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Elementary KG 08 2017   kindergarten                         16.0 15.0                       31.0                         16 15                 31
1304962 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Elementary KG 08 2017   pk_12_total 138.0 2.0 4.0 3.0   2.0         12.0   83.0 78.0     2.0             20.0   161.0 138 2 4 3   2         12   83 78     2       20   161
1799283 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 09 2018   grade_1                         16.0 11.0                       27.0                         16 11                 27
1799284 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 09 2018   grade_2                         10.0 8.0                       18.0                         10 8                 18
1799285 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 09 2018   grade_3                         18.0 9.0                       27.0                         18 9                 27
1799286 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 09 2018   grade_4                         14.0 10.0                       24.0                         14 10                 24
1799287 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 09 2018   grade_5                         12.0 11.0                       23.0                         12 11                 23
1799288 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 09 2018   grade_6                         11.0 8.0                       19.0                         11 8                 19
1799289 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 09 2018   grade_7                         6.0 11.0                       17.0                         6 11                 17
1799290 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 09 2018   grade_8                         4.0 11.0                       15.0                         4 11                 15
1799291 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 09 2018   grade_9                         6.0 2.0                       8.0                         6 2                 8
1799292 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 09 2018   kindergarten                         27.0 21.0                       48.0                         27 21                 48
1799293 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 09 2018   pk_12_total 203.0 2.0 4.0 2.0   2.0         13.0   124.0 102.0     0.0         49.0   52.0   226.0 203 2 4 2   2         13   124 102     0     49 52   226
1763513 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   grade_1                         24.0 27.0                       51.0                         24 27                 51
1763514 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   grade_10                         11.0 1.0                       12.0                         11 1                 12
1763515 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   grade_2                         18.0 21.0                       39.0                         18 21                 39
1763516 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   grade_3                         15.0 7.0                       22.0                         15 7                 22
1763517 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   grade_4                         27.0 16.0                       43.0                         27 16                 43
1763518 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   grade_5                         14.0 16.0                       30.0                         14 16                 30
1763519 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   grade_6                         13.0 16.0                       29.0                         13 16                 29
1763520 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   grade_7                         11.0 14.0                       25.0                         11 14                 25
1763521 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   grade_8                         5.0 10.0                       15.0                         5 10                 15
1763522 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   grade_9                         3.0 13.0                       16.0                         3 13                 16
1763523 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   kindergarten                         30.0 21.0                       51.0                         30 21                 51
1763524 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   pk_12_total 290.0 7.0 11.0 2.0   5.0         18.0   171.0 162.0     1.0         113.0   74.0   333.0 290 7 11 2   5         18   171 162     1     113 74   333
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
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
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
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
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
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

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