Data source: Big Local News · About: Big Local

12,002 rows where state = "IN" and year = 2021 sorted by school_state_id descending

View and edit SQL

grade

year

  • 2021 · 12,002
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
1930553 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   adult                         4.0 4.0                       8.0                         4 4                 8
1930554 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   grade_1                         5.0 8.0                       13.0                         5 8                 13
1930555 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   grade_10                         12.0 13.0                       25.0                         12 13                 25
1930556 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   grade_11                         7.0 16.0                       23.0                         7 16                 23
1930557 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   grade_12                         16.0 18.0                       34.0                         16 18                 34
1930558 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   grade_2                         9.0 10.0                       19.0                         9 10                 19
1930559 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   grade_3                         6.0 20.0                       26.0                         6 20                 26
1930560 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   grade_4                         12.0 6.0                       18.0                         12 6                 18
1930561 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   grade_5                         8.0 10.0                       18.0                         8 10                 18
1930562 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   grade_6                         8.0 8.0                       16.0                         8 8                 16
1930563 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   grade_7                         11.0 11.0                       22.0                         11 11                 22
1930564 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   grade_8                         5.0 7.0                       12.0                         5 7                 12
1930565 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   grade_9                         15.0 16.0                       31.0                         15 16                 31
1930566 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   kindergarten                         9.0 7.0                       16.0                         9 7                 16
1930567 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   pk_12_total 186.0 37.0 39.0     14.0     1.0   25.0   138.0 164.0     28.0         301.0   286.0   302.0 186 37 39     14     1   25   138 164     28     301 286   302
1930568 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   pre_kindergarten                         11.0 10.0                       21.0                         11 10                 21
1930537 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   adult                         10.0 4.0                       14.0                         10 4                 14
1930538 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   grade_1                         0.0 4.0                       4.0                         0 4                 4
1930539 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   grade_10                         10.0 5.0                       15.0                         10 5                 15
1930540 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   grade_11                         7.0 3.0                       10.0                         7 3                 10
1930541 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   grade_12                         2.0 4.0                       6.0                         2 4                 6
1930542 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   grade_2                         2.0 2.0                       4.0                         2 2                 4
1930543 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   grade_3                         4.0 5.0                       9.0                         4 5                 9
1930544 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   grade_4                         6.0 1.0                       7.0                         6 1                 7
1930545 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   grade_5                         4.0 2.0                       6.0                         4 2                 6
1930546 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   grade_6                         3.0 3.0                       6.0                         3 3                 6
1930547 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   grade_7                         4.0 4.0                       8.0                         4 4                 8
1930548 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   grade_8                         2.0 1.0                       3.0                         2 1                 3
1930549 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   grade_9                         6.0 5.0                       11.0                         6 5                 11
1930550 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   kindergarten                         3.0 3.0                       6.0                         3 3                 6
1930551 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   pk_12_total 65.0 23.0 17.0     2.0         7.0   66.0 48.0     4.0         112.0   105.0   114.0 65 23 17     2         7   66 48     4     112 105   114
1930552 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   pre_kindergarten                         3.0 2.0                       5.0                         3 2                 5
1930253 IN     school 1800224 9170   Rooted School Indianapolis 180022402709 9997 Rooted School Indianapolis   Regular School Yes Secondary 09 09 2021   grade_9                         26.0 32.0                       58.0                         26 32                 58
1930254 IN     school 1800224 9170   Rooted School Indianapolis 180022402709 9997 Rooted School Indianapolis   Regular School Yes Secondary 09 09 2021   pk_12_total 1.0 54.0                 3.0   26.0 32.0     0.0         49.0   8.0   58.0 1 54                 3   26 32     0     49 8   58
1930230 IN     school 1800223 9140   BELIEVE Circle City High School 180022302708 9994 BELIEVE Circle City High School   Regular School Yes Secondary 09 10 2021   grade_10                         3.0 2.0                       5.0                         3 2                 5
1930231 IN     school 1800223 9140   BELIEVE Circle City High School 180022302708 9994 BELIEVE Circle City High School   Regular School Yes Secondary 09 10 2021   grade_9                         20.0 29.0                       49.0                         20 29                 49
1930232 IN     school 1800223 9140   BELIEVE Circle City High School 180022302708 9994 BELIEVE Circle City High School   Regular School Yes Secondary 09 10 2021   pk_12_total 1.0 34.0 16.0               3.0   23.0 31.0     13.0         51.0   9.0   54.0 1 34 16               3   23 31     13     51 9   54
1930217 IN     school 1800216 9130   Adelante Schools 180021602702 9993 Emma Donnan Elementary and Middle   Regular School Yes Elementary KG 08 2021   grade_1                         12.0 16.0                       28.0                         12 16                 28
1930218 IN     school 1800216 9130   Adelante Schools 180021602702 9993 Emma Donnan Elementary and Middle   Regular School Yes Elementary KG 08 2021   grade_2                         13.0 12.0                       25.0                         13 12                 25
1930219 IN     school 1800216 9130   Adelante Schools 180021602702 9993 Emma Donnan Elementary and Middle   Regular School Yes Elementary KG 08 2021   grade_3                         13.0 15.0                       28.0                         13 15                 28
1930220 IN     school 1800216 9130   Adelante Schools 180021602702 9993 Emma Donnan Elementary and Middle   Regular School Yes Elementary KG 08 2021   grade_4                         20.0 15.0                       35.0                         20 15                 35
1930221 IN     school 1800216 9130   Adelante Schools 180021602702 9993 Emma Donnan Elementary and Middle   Regular School Yes Elementary KG 08 2021   grade_5                         15.0 22.0                       37.0                         15 22                 37
1930222 IN     school 1800216 9130   Adelante Schools 180021602702 9993 Emma Donnan Elementary and Middle   Regular School Yes Elementary KG 08 2021   grade_6                         19.0 17.0                       36.0                         19 17                 36
1930223 IN     school 1800216 9130   Adelante Schools 180021602702 9993 Emma Donnan Elementary and Middle   Regular School Yes Elementary KG 08 2021   grade_7                         38.0 32.0                       70.0                         38 32                 70
1930224 IN     school 1800216 9130   Adelante Schools 180021602702 9993 Emma Donnan Elementary and Middle   Regular School Yes Elementary KG 08 2021   grade_8                         35.0 34.0                       69.0                         35 34                 69
1930225 IN     school 1800216 9130   Adelante Schools 180021602702 9993 Emma Donnan Elementary and Middle   Regular School Yes Elementary KG 08 2021   kindergarten                         6.0 13.0                       19.0                         6 13                 19
1930226 IN     school 1800216 9130   Adelante Schools 180021602702 9993 Emma Donnan Elementary and Middle   Regular School Yes Elementary KG 08 2021   pk_12_total 100.0 132.0 87.0 2.0   4.0         22.0   171.0 176.0     46.0         298.0   48.0   347.0 100 132 87 2   4         22   171 176     46     298 48   347
1930082 IN     school 1800222 9000   Phalen Virtual Leadership Academy 180022202707 9992 Phalen Virtual Leadership Academy   Regular School Yes Other 02 12 2021   grade_10                         1.0 0.0                       1.0                         1 0                 1
1930083 IN     school 1800222 9000   Phalen Virtual Leadership Academy 180022202707 9992 Phalen Virtual Leadership Academy   Regular School Yes Other 02 12 2021   grade_11                         3.0 1.0                       4.0                         3 1                 4
1930084 IN     school 1800222 9000   Phalen Virtual Leadership Academy 180022202707 9992 Phalen Virtual Leadership Academy   Regular School Yes Other 02 12 2021   grade_12                         1.0 0.0                       1.0                         1 0                 1
1930085 IN     school 1800222 9000   Phalen Virtual Leadership Academy 180022202707 9992 Phalen Virtual Leadership Academy   Regular School Yes Other 02 12 2021   grade_2                         3.0 0.0                       3.0                         3 0                 3
1930086 IN     school 1800222 9000   Phalen Virtual Leadership Academy 180022202707 9992 Phalen Virtual Leadership Academy   Regular School Yes Other 02 12 2021   grade_3                         1.0 2.0                       3.0                         1 2                 3
1930087 IN     school 1800222 9000   Phalen Virtual Leadership Academy 180022202707 9992 Phalen Virtual Leadership Academy   Regular School Yes Other 02 12 2021   grade_4                         1.0 0.0                       1.0                         1 0                 1
1930088 IN     school 1800222 9000   Phalen Virtual Leadership Academy 180022202707 9992 Phalen Virtual Leadership Academy   Regular School Yes Other 02 12 2021   grade_5                         4.0 2.0                       6.0                         4 2                 6
1930089 IN     school 1800222 9000   Phalen Virtual Leadership Academy 180022202707 9992 Phalen Virtual Leadership Academy   Regular School Yes Other 02 12 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1930090 IN     school 1800222 9000   Phalen Virtual Leadership Academy 180022202707 9992 Phalen Virtual Leadership Academy   Regular School Yes Other 02 12 2021   grade_7                         3.0 2.0                       5.0                         3 2                 5
1930091 IN     school 1800222 9000   Phalen Virtual Leadership Academy 180022202707 9992 Phalen Virtual Leadership Academy   Regular School Yes Other 02 12 2021   grade_8                         2.0 1.0                       3.0                         2 1                 3
1930092 IN     school 1800222 9000   Phalen Virtual Leadership Academy 180022202707 9992 Phalen Virtual Leadership Academy   Regular School Yes Other 02 12 2021   grade_9                         1.0 2.0                       3.0                         1 2                 3
1930093 IN     school 1800222 9000   Phalen Virtual Leadership Academy 180022202707 9992 Phalen Virtual Leadership Academy   Regular School Yes Other 02 12 2021   kindergarten                         2.0 1.0                       3.0                         2 1                 3
1930094 IN     school 1800222 9000   Phalen Virtual Leadership Academy 180022202707 9992 Phalen Virtual Leadership Academy   Regular School Yes Other 02 12 2021   pk_12_total 12.0 17.0 4.0               1.0   23.0 11.0     1.0         15.0   8.0   34.0 12 17 4               1   23 11     1     15 8   34
1930078 IN     school 1800221 8990   HIM By HER Collegiate School for t 180022102706 9991 HIM By HER Collegiate School for t   Regular School Yes Elementary KG 02 2021   grade_1                         11.0 10.0                       21.0                         11 10                 21
1930079 IN     school 1800221 8990   HIM By HER Collegiate School for t 180022102706 9991 HIM By HER Collegiate School for t   Regular School Yes Elementary KG 02 2021   grade_2                         5.0 3.0                       8.0                         5 3                 8
1930080 IN     school 1800221 8990   HIM By HER Collegiate School for t 180022102706 9991 HIM By HER Collegiate School for t   Regular School Yes Elementary KG 02 2021   kindergarten                         20.0 14.0                       34.0                         20 14                 34
1930081 IN     school 1800221 8990   HIM By HER Collegiate School for t 180022102706 9991 HIM By HER Collegiate School for t   Regular School Yes Elementary KG 02 2021   pk_12_total   60.0 1.0     1.0         1.0   36.0 27.0     0.0         55.0   1.0   63.0   60 1     1         1   36 27     0     55 1   63
1930068 IN     school 1800220 8980   The PATH School 180022002705 9971 The PATH School   Regular School Yes Elementary KG 08 2021   grade_1                         38.0 27.0                       65.0                         38 27                 65
1930069 IN     school 1800220 8980   The PATH School 180022002705 9971 The PATH School   Regular School Yes Elementary KG 08 2021   grade_2                         18.0 25.0                       43.0                         18 25                 43
1930070 IN     school 1800220 8980   The PATH School 180022002705 9971 The PATH School   Regular School Yes Elementary KG 08 2021   grade_3                         30.0 24.0                       54.0                         30 24                 54
1930071 IN     school 1800220 8980   The PATH School 180022002705 9971 The PATH School   Regular School Yes Elementary KG 08 2021   grade_4                         27.0 26.0                       53.0                         27 26                 53
1930072 IN     school 1800220 8980   The PATH School 180022002705 9971 The PATH School   Regular School Yes Elementary KG 08 2021   grade_5                         29.0 24.0                       53.0                         29 24                 53
1930073 IN     school 1800220 8980   The PATH School 180022002705 9971 The PATH School   Regular School Yes Elementary KG 08 2021   grade_6                         32.0 30.0                       62.0                         32 30                 62
1930074 IN     school 1800220 8980   The PATH School 180022002705 9971 The PATH School   Regular School Yes Elementary KG 08 2021   grade_7                         31.0 45.0                       76.0                         31 45                 76
1930075 IN     school 1800220 8980   The PATH School 180022002705 9971 The PATH School   Regular School Yes Elementary KG 08 2021   grade_8                         24.0 25.0                       49.0                         24 25                 49
1930076 IN     school 1800220 8980   The PATH School 180022002705 9971 The PATH School   Regular School Yes Elementary KG 08 2021   kindergarten                         23.0 34.0                       57.0                         23 34                 57
1930077 IN     school 1800220 8980   The PATH School 180022002705 9971 The PATH School   Regular School Yes Elementary KG 08 2021   pk_12_total 64.0 121.0 307.0               20.0   252.0 260.0     267.0         413.0   58.0   512.0 64 121 307               20   252 260     267     413 58   512
1930064 IN     school 1800219 8970   GEO Next Generation Academy 180021902704 9966 GEO Next Generation Academy   Regular School Yes Secondary 09 11 2021   grade_10                         10.0 7.0                       17.0                         10 7                 17
1930065 IN     school 1800219 8970   GEO Next Generation Academy 180021902704 9966 GEO Next Generation Academy   Regular School Yes Secondary 09 11 2021   grade_11                         9.0 11.0                       20.0                         9 11                 20
1930066 IN     school 1800219 8970   GEO Next Generation Academy 180021902704 9966 GEO Next Generation Academy   Regular School Yes Secondary 09 11 2021   grade_9                         28.0 33.0                       61.0                         28 33                 61
1930067 IN     school 1800219 8970   GEO Next Generation Academy 180021902704 9966 GEO Next Generation Academy   Regular School Yes Secondary 09 11 2021   pk_12_total 3.0 67.0 22.0               6.0   47.0 51.0     12.0         77.0   14.0   98.0 3 67 22               6   47 51     12     77 14   98
1930061 IN     school 1800214 8960   Purdue Polytechnic High School Sou 180021402689 9963 Purdue Polytechnic High School Sou   Regular School Yes Secondary 09 11 2021   grade_10                         5.0 0.0                       5.0                         5 0                 5
1930062 IN     school 1800214 8960   Purdue Polytechnic High School Sou 180021402689 9963 Purdue Polytechnic High School Sou   Regular School Yes Secondary 09 11 2021   grade_9                         15.0 7.0                       22.0                         15 7                 22
1930063 IN     school 1800214 8960   Purdue Polytechnic High School Sou 180021402689 9963 Purdue Polytechnic High School Sou   Regular School Yes Secondary 09 11 2021   pk_12_total 13.0 3.0 5.0 2.0   1.0         3.0   20.0 7.0     2.0         11.0   7.0   27.0 13 3 5 2   1         3   20 7     2     11 7   27
1930049 IN     school 1800215 8940   James and Rosemary Phalen Leadersh 180021502701 9961 James and Rosemary Phalen Leadersh   Regular School Yes Secondary 09 11 2021   grade_10                         62.0 58.0                       120.0                         62 58                 120
1930050 IN     school 1800215 8940   James and Rosemary Phalen Leadersh 180021502701 9961 James and Rosemary Phalen Leadersh   Regular School Yes Secondary 09 11 2021   grade_11                         41.0 25.0                       66.0                         41 25                 66
1930051 IN     school 1800215 8940   James and Rosemary Phalen Leadersh 180021502701 9961 James and Rosemary Phalen Leadersh   Regular School Yes Secondary 09 11 2021   grade_9                         78.0 67.0                       145.0                         78 67                 145
1930052 IN     school 1800215 8940   James and Rosemary Phalen Leadersh 180021502701 9961 James and Rosemary Phalen Leadersh   Regular School Yes Secondary 09 11 2021   pk_12_total 11.0 238.0 74.0               8.0   181.0 150.0     47.0         245.0   65.0   331.0 11 238 74               8   181 150     47     245 65   331
1930018 IN     school 1800207 8675   Invent Learning Hub 180020702683 9532 Invent Learning Hub   Regular School Yes Elementary KG 07 2021   grade_1                         15.0 11.0                       26.0                         15 11                 26
1930019 IN     school 1800207 8675   Invent Learning Hub 180020702683 9532 Invent Learning Hub   Regular School Yes Elementary KG 07 2021   grade_2                         9.0 10.0                       19.0                         9 10                 19
1930020 IN     school 1800207 8675   Invent Learning Hub 180020702683 9532 Invent Learning Hub   Regular School Yes Elementary KG 07 2021   grade_3                         5.0 12.0                       17.0                         5 12                 17
1930021 IN     school 1800207 8675   Invent Learning Hub 180020702683 9532 Invent Learning Hub   Regular School Yes Elementary KG 07 2021   grade_4                         10.0 15.0                       25.0                         10 15                 25
1930022 IN     school 1800207 8675   Invent Learning Hub 180020702683 9532 Invent Learning Hub   Regular School Yes Elementary KG 07 2021   grade_5                         11.0 6.0                       17.0                         11 6                 17
1930023 IN     school 1800207 8675   Invent Learning Hub 180020702683 9532 Invent Learning Hub   Regular School Yes Elementary KG 07 2021   grade_6                         11.0 8.0                       19.0                         11 8                 19
1930024 IN     school 1800207 8675   Invent Learning Hub 180020702683 9532 Invent Learning Hub   Regular School Yes Elementary KG 07 2021   grade_7                         3.0 5.0                       8.0                         3 5                 8
1930025 IN     school 1800207 8675   Invent Learning Hub 180020702683 9532 Invent Learning Hub   Regular School Yes Elementary KG 07 2021   kindergarten                         16.0 8.0                       24.0                         16 8                 24
1930026 IN     school 1800207 8675   Invent Learning Hub 180020702683 9532 Invent Learning Hub   Regular School Yes Elementary KG 07 2021   pk_12_total 53.0 67.0 26.0               9.0   80.0 75.0     19.0         142.0   24.0   155.0 53 67 26               9   80 75     19     142 24   155
1930312 IN     school 1800016 9325   Options Charter Schools 180001602700 9329 Options Indiana   Regular School Yes High 06 12 2021   grade_10                         14.0 13.0                       27.0                         14 13                 27
1930313 IN     school 1800016 9325   Options Charter Schools 180001602700 9329 Options Indiana   Regular School Yes High 06 12 2021   grade_11                         25.0 33.0                       58.0                         25 33                 58
1930314 IN     school 1800016 9325   Options Charter Schools 180001602700 9329 Options Indiana   Regular School Yes High 06 12 2021   grade_12                         79.0 105.0                       184.0                         79 105                 184
1930315 IN     school 1800016 9325   Options Charter Schools 180001602700 9329 Options Indiana   Regular School Yes High 06 12 2021   grade_6                         4.0 1.0                       5.0                         4 1                 5
1930316 IN     school 1800016 9325   Options Charter Schools 180001602700 9329 Options Indiana   Regular School Yes High 06 12 2021   grade_7                         3.0 1.0                       4.0                         3 1                 4
1930317 IN     school 1800016 9325   Options Charter Schools 180001602700 9329 Options Indiana   Regular School Yes High 06 12 2021   grade_8                         5.0 5.0                       10.0                         5 5                 10

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