Data source: Big Local News · About: Big Local

12,019 rows where state = "IN" and year = 2018 sorted by district

View and edit SQL

grade

year

  • 2018 · 12,019
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
1798755 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2018   grade_1                         35.0 35.0                       70.0                         35 35                 70
1798756 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2018   grade_10                         43.0 25.0                       68.0                         43 25                 68
1798757 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2018   grade_11                         24.0 48.0                       72.0                         24 48                 72
1798758 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2018   grade_12                         31.0 29.0                       60.0                         31 29                 60
1798759 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2018   grade_2                         28.0 47.0                       75.0                         28 47                 75
1798760 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2018   grade_3                         45.0 31.0                       76.0                         45 31                 76
1798761 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2018   grade_4                         34.0 38.0                       72.0                         34 38                 72
1798762 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2018   grade_5                         28.0 34.0                       62.0                         28 34                 62
1798763 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2018   grade_6                         34.0 25.0                       59.0                         34 25                 59
1798764 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2018   grade_7                         43.0 32.0                       75.0                         43 32                 75
1798765 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2018   grade_8                         35.0 42.0                       77.0                         35 42                 77
1798766 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2018   grade_9                         58.0 34.0                       92.0                         58 34                 92
1798767 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2018   kindergarten                         43.0 33.0                       76.0                         43 33                 76
1798768 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2018   pk_12_total 3.0 884.0 20.0               27.0   481.0 453.0     0.0         876.0   134.0   934.0 3 884 20               27   481 453     0     876 134   934
1799269 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 02 2018   grade_1                         12.0 13.0                       25.0                         12 13                 25
1799270 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 02 2018   grade_2                         5.0 7.0                       12.0                         5 7                 12
1799271 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 02 2018   kindergarten                         19.0 24.0                       43.0                         19 24                 43
1799272 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 02 2018   pk_12_total 6.0 58.0 6.0           1.0   9.0   36.0 44.0     1.0         63.0   8.0   80.0 6 58 6           1   9   36 44     1     63 8   80
1787287 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2018   grade_6                         51.0 51.0                       102.0                         51 51                 102
1787288 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2018   grade_7                         49.0 33.0                       82.0                         49 33                 82
1787289 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2018   grade_8                         41.0 42.0                       83.0                         41 42                 83
1787290 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2018   pk_12_total 251.0 3.0 10.0     2.0         1.0   141.0 126.0     1.0         63.0   16.0   267.0 251 3 10     2         1   141 126     1     63 16   267
1787291 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   grade_1                         59.0 42.0                       101.0                         59 42                 101
1787292 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   grade_2                         52.0 42.0                       94.0                         52 42                 94
1787293 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   grade_3                         56.0 50.0                       106.0                         56 50                 106
1787294 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   grade_4                         63.0 38.0                       101.0                         63 38                 101
1787295 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   grade_5                         51.0 57.0                       108.0                         51 57                 108
1787296 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         59.0 63.0                       122.0                         59 63                 122
1787297 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   pk_12_total 586.0 6.0 25.0 1.0   5.0         13.0   341.0 295.0     22.0         172.0   106.0   636.0 586 6 25 1   5         13   341 295     22     172 106   636
1787298 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         1.0 3.0                       4.0                         1 3                 4
1787299 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2018   adult                         1.0 0.0                       1.0                         1 0                 1
1787300 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2018   grade_10                         41.0 53.0                       94.0                         41 53                 94
1787301 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2018   grade_11                         45.0 53.0                       98.0                         45 53                 98
1787302 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2018   grade_12                         50.0 33.0                       83.0                         50 33                 83
1787303 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2018   grade_9                         49.0 53.0                       102.0                         49 53                 102
1787304 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2018   pk_12_total 356.0 1.0 9.0 1.0   6.0         5.0   186.0 192.0     9.0         86.0   21.0   378.0 356 1 9 1   6         5   186 192     9     86 21   378
1793273 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2018   grade_10                         67.0 54.0                       121.0                         67 54                 121
1793274 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2018   grade_11                         46.0 54.0                       100.0                         46 54                 100
1793275 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2018   grade_12                         74.0 56.0                       130.0                         74 56                 130
1793276 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2018   grade_7                         53.0 62.0                       115.0                         53 62                 115
1793277 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2018   grade_8                         48.0 65.0                       113.0                         48 65                 113
1793278 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2018   grade_9                         60.0 68.0                       128.0                         60 68                 128
1793279 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No High 07 12 2018   pk_12_total 651.0 2.0 39.0     2.0         13.0   348.0 359.0     9.0         327.0   95.0   707.0 651 2 39     2         13   348 359     9     327 95   707
1793280 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2018   grade_3                         65.0 60.0                       125.0                         65 60                 125
1793281 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2018   grade_4                         63.0 42.0                       105.0                         63 42                 105
1793282 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2018   grade_5                         49.0 51.0                       100.0                         49 51                 100
1793283 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2018   grade_6                         74.0 50.0                       124.0                         74 50                 124
1793284 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2018   pk_12_total 402.0 2.0 33.0               17.0   251.0 203.0     4.0         258.0   88.0   454.0 402 2 33               17   251 203     4     258 88   454
1793285 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2018   grade_1                         57.0 54.0                       111.0                         57 54                 111
1793286 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2018   grade_2                         64.0 49.0                       113.0                         64 49                 113
1793287 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2018   kindergarten                         62.0 47.0                       109.0                         62 47                 109
1793288 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2018   pk_12_total 320.0 1.0 28.0           1.0   18.0   200.0 168.0     6.0         208.0   91.0   368.0 320 1 28           1   18   200 168     6     208 91   368
1793289 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2018   pre_kindergarten                         17.0 18.0                       35.0                         17 18                 35
1793290 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Middle 06 09 2018   grade_6                         8.0 3.0                       11.0                         8 3                 11
1793291 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Middle 06 09 2018   grade_7                         24.0 4.0                       28.0                         24 4                 28
1793292 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Middle 06 09 2018   grade_8                         14.0 7.0                       21.0                         14 7                 21
1793293 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Middle 06 09 2018   grade_9                         12.0 5.0                       17.0                         12 5                 17
1793294 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Middle 06 09 2018   pk_12_total 26.0 32.0 10.0               9.0   58.0 19.0     3.0         76.0   22.0   77.0 26 32 10               9   58 19     3     76 22   77
1793295 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No High 09 12 2018   grade_10                         266.0 234.0                       500.0                         266 234                 500
1793296 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No High 09 12 2018   grade_11                         258.0 215.0                       473.0                         258 215                 473
1793297 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No High 09 12 2018   grade_12                         263.0 203.0                       466.0                         263 203                 466
1793298 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No High 09 12 2018   grade_9                         224.0 203.0                       427.0                         224 203                 427
1793299 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No High 09 12 2018   pk_12_total 1060.0 443.0 211.0 4.0   9.0         139.0   1011.0 855.0     50.0         1430.0   379.0   1866.0 1060 443 211 4   9         139   1011 855     50     1430 379   1866
1793300 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2018   grade_1                         17.0 23.0                       40.0                         17 23                 40
1793301 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2018   grade_2                         27.0 26.0                       53.0                         27 26                 53
1793302 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2018   grade_3                         24.0 25.0                       49.0                         24 25                 49
1793303 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2018   grade_4                         29.0 28.0                       57.0                         29 28                 57
1793304 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2018   grade_5                         24.0 18.0                       42.0                         24 18                 42
1793305 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         31.0 20.0                       51.0                         31 20                 51
1793306 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2018   pk_12_total 132.0 93.0 16.0               51.0   152.0 140.0     3.0         238.0   63.0   292.0 132 93 16               51   152 140     3     238 63   292
1793307 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2018   grade_1                         71.0 55.0                       126.0                         71 55                 126
1793308 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2018   grade_2                         68.0 41.0                       109.0                         68 41                 109
1793309 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2018   grade_3                         69.0 42.0                       111.0                         69 42                 111
1793310 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2018   grade_4                         51.0 44.0                       95.0                         51 44                 95
1793311 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2018   grade_5                         59.0 49.0                       108.0                         59 49                 108
1793312 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         40.0 49.0                       89.0                         40 49                 89
1793313 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2018   pk_12_total 398.0 117.0 44.0 3.0   2.0         74.0   358.0 280.0     10.0         569.0   149.0   638.0 398 117 44 3   2         74   358 280     10     569 149   638
1793314 IN     school 1800150 5275   Anderson Community School Corp 180015002557 5023 Southview Preschool Center   Regular School No Prekindergarten PK PK 2018   pk_12_total 204.0 42.0 47.0               26.0   190.0 129.0     0.0             133.0   319.0 204 42 47               26   190 129     0       133   319
1793315 IN     school 1800150 5275   Anderson Community School Corp 180015002557 5023 Southview Preschool Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                         190.0 129.0                       319.0                         190 129                 319
1793316 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2018   grade_1                         50.0 58.0                       108.0                         50 58                 108
1793317 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2018   grade_2                         61.0 48.0                       109.0                         61 48                 109
1793318 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2018   grade_3                         51.0 36.0                       87.0                         51 36                 87
1793319 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2018   grade_4                         54.0 43.0                       97.0                         54 43                 97
1793320 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2018   grade_5                         54.0 42.0                       96.0                         54 42                 96
1793321 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         51.0 36.0                       87.0                         51 36                 87
1793322 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2018   pk_12_total 361.0 119.0 43.0     2.0         59.0   321.0 263.0     17.0         522.0   133.0   584.0 361 119 43     2         59   321 263     17     522 133   584
1793323 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No Middle 06 08 2018   grade_6                         258.0 252.0                       510.0                         258 252                 510
1793324 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No Middle 06 08 2018   grade_7                         232.0 223.0                       455.0                         232 223                 455
1793325 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No Middle 06 08 2018   grade_8                         235.0 224.0                       459.0                         235 224                 459
1793326 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No Middle 06 08 2018   pk_12_total 794.0 315.0 194.0 2.0   3.0     1.0   115.0   725.0 699.0     37.0         1194.0   300.0   1424.0 794 315 194 2   3     1   115   725 699     37     1194 300   1424
1793327 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 05 2018   grade_1                         48.0 36.0                       84.0                         48 36                 84
1793328 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 05 2018   grade_2                         46.0 35.0                       81.0                         46 35                 81
1793329 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 05 2018   grade_3                         51.0 58.0                       109.0                         51 58                 109
1793330 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 05 2018   grade_4                         62.0 51.0                       113.0                         62 51                 113
1793331 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 05 2018   grade_5                         72.0 64.0                       136.0                         72 64                 136
1793332 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         64.0 49.0                       113.0                         64 49                 113
1793333 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 05 2018   pk_12_total 425.0 93.0 52.0     2.0         64.0   343.0 293.0     10.0         505.0   136.0   636.0 425 93 52     2         64   343 293     10     505 136   636
1793334 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 05 2018   grade_1                         51.0 49.0                       100.0                         51 49                 100
1793335 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 05 2018   grade_2                         54.0 39.0                       93.0                         54 39                 93
1793336 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 05 2018   grade_3                         46.0 63.0                       109.0                         46 63                 109

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