Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

  • 2017 · 11,958
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
1304275 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes Elementary KG 08 2017   pk_12_total 10.0 55.0 4.0 1.0             20.0   56.0 34.0     2.0             12.0   90.0 10 55 4 1             20   56 34     2       12   90
1304217 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 09 12 2017   grade_10                         4.0 2.0                       6.0                         4 2                 6
1304218 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 09 12 2017   grade_11                         10.0 11.0                       21.0                         10 11                 21
1304219 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 09 12 2017   grade_12                         72.0 72.0                       144.0                         72 72                 144
1304220 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 09 12 2017   grade_9                         3.0 2.0                       5.0                         3 2                 5
1304221 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 09 12 2017   pk_12_total 124.0 24.0 8.0 1.0   2.0         17.0   89.0 87.0     2.0             39.0   176.0 124 24 8 1   2         17   89 87     2       39   176
1304294 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2017   grade_1                         27.0 26.0                       53.0                         27 26                 53
1304295 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2017   grade_10                         38.0 15.0                       53.0                         38 15                 53
1304296 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2017   grade_11                         33.0 26.0                       59.0                         33 26                 59
1304297 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2017   grade_12                         24.0 22.0                       46.0                         24 22                 46
1304298 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2017   grade_2                         28.0 26.0                       54.0                         28 26                 54
1304299 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2017   grade_3                         31.0 23.0                       54.0                         31 23                 54
1304300 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2017   grade_4                         18.0 36.0                       54.0                         18 36                 54
1304301 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2017   grade_5                         25.0 29.0                       54.0                         25 29                 54
1304302 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2017   grade_6                         25.0 28.0                       53.0                         25 28                 53
1304303 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2017   grade_7                         25.0 29.0                       54.0                         25 29                 54
1304304 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2017   grade_8                         26.0 29.0                       55.0                         26 29                 55
1304305 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2017   grade_9                         31.0 43.0                       74.0                         31 43                 74
1304306 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2017   kindergarten                         28.0 27.0                       55.0                         28 27                 55
1304307 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2017   pk_12_total 205.0 112.0 336.0 2.0   6.0         57.0   359.0 359.0     166.0             92.0   718.0 205 112 336 2   6         57   359 359     166       92   718
1304198 IN     school 1800021 9315   Signature School Inc 180002100319 8295 Signature School Inc   Regular School Yes High 09 12 2017   grade_10                         34.0 58.0                       92.0                         34 58                 92
1304199 IN     school 1800021 9315   Signature School Inc 180002100319 8295 Signature School Inc   Regular School Yes High 09 12 2017   grade_11                         34.0 40.0                       74.0                         34 40                 74
1304200 IN     school 1800021 9315   Signature School Inc 180002100319 8295 Signature School Inc   Regular School Yes High 09 12 2017   grade_12                         36.0 50.0                       86.0                         36 50                 86
1304201 IN     school 1800021 9315   Signature School Inc 180002100319 8295 Signature School Inc   Regular School Yes High 09 12 2017   grade_9                         56.0 53.0                       109.0                         56 53                 109
1304202 IN     school 1800021 9315   Signature School Inc 180002100319 8295 Signature School Inc   Regular School Yes High 09 12 2017   pk_12_total 248.0 10.0 17.0 2.0   56.0         28.0   160.0 201.0     2.0             3.0   361.0 248 10 17 2   56         28   160 201     2       3   361
1304461 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   adult                         18.0 6.0                       24.0                         18 6                 24
1304462 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   grade_1                         3.0 1.0                       4.0                         3 1                 4
1304463 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   grade_10                         7.0 2.0                       9.0                         7 2                 9
1304464 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   grade_11                         10.0 5.0                       15.0                         10 5                 15
1304465 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   grade_12                         5.0 9.0                       14.0                         5 9                 14
1304466 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   grade_2                         4.0 3.0                       7.0                         4 3                 7
1304467 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   grade_3                         2.0 2.0                       4.0                         2 2                 4
1304468 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   grade_4                         3.0 2.0                       5.0                         3 2                 5
1304469 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   grade_5                         3.0 3.0                       6.0                         3 3                 6
1304470 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   grade_6                         7.0 2.0                       9.0                         7 2                 9
1304471 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   grade_7                         3.0 3.0                       6.0                         3 3                 6
1304472 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   grade_8                         2.0 5.0                       7.0                         2 5                 7
1304473 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   grade_9                         11.0 8.0                       19.0                         11 8                 19
1304474 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   kindergarten                         2.0 1.0                       3.0                         2 1                 3
1304475 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   pk_12_total 86.0 29.0 12.0     2.0         9.0   84.0 54.0     1.0             137.0   138.0 86 29 12     2         9   84 54     1       137   138
1304476 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   pre_kindergarten                         4.0 2.0                       6.0                         4 2                 6
1304477 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_1                         5.0 4.0                       9.0                         5 4                 9
1304478 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_10                         19.0 9.0                       28.0                         19 9                 28
1304479 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_11                         14.0 8.0                       22.0                         14 8                 22
1304480 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_12                         23.0 10.0                       33.0                         23 10                 33
1304481 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_2                         6.0 4.0                       10.0                         6 4                 10
1304482 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_3                         5.0 10.0                       15.0                         5 10                 15
1304483 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_4                         5.0 7.0                       12.0                         5 7                 12
1304484 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_5                         9.0 14.0                       23.0                         9 14                 23
1304485 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_6                         8.0 7.0                       15.0                         8 7                 15
1304486 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_7                         4.0 10.0                       14.0                         4 10                 14
1304487 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_8                         8.0 13.0                       21.0                         8 13                 21
1304488 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_9                         16.0 16.0                       32.0                         16 16                 32
1304489 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   kindergarten                         12.0 13.0                       25.0                         12 13                 25
1304490 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   pk_12_total 175.0 36.0 39.0 1.0   10.0         14.0   137.0 138.0     30.0             270.0   275.0 175 36 39 1   10         14   137 138     30       270   275
1304491 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   pre_kindergarten                         3.0 13.0                       16.0                         3 13                 16
1304348 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2017   grade_1                         46.0 43.0                       89.0                         46 43                 89
1304349 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2017   grade_10                         55.0 62.0                       117.0                         55 62                 117
1304350 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2017   grade_11                         63.0 50.0                       113.0                         63 50                 113
1304351 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2017   grade_12                         46.0 53.0                       99.0                         46 53                 99
1304352 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2017   grade_2                         47.0 36.0                       83.0                         47 36                 83
1304353 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2017   grade_3                         54.0 43.0                       97.0                         54 43                 97
1304354 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2017   grade_4                         49.0 47.0                       96.0                         49 47                 96
1304355 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2017   grade_5                         44.0 47.0                       91.0                         44 47                 91
1304356 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2017   grade_6                         29.0 41.0                       70.0                         29 41                 70
1304357 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2017   grade_7                         38.0 40.0                       78.0                         38 40                 78
1304358 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2017   grade_8                         46.0 35.0                       81.0                         46 35                 81
1304359 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2017   grade_9                         63.0 55.0                       118.0                         63 55                 118
1304360 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2017   kindergarten                         39.0 28.0                       67.0                         39 28                 67
1304361 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2017   pk_12_total   1161.0 23.0               15.0   619.0 580.0     2.0             119.0   1199.0   1161 23               15   619 580     2       119   1199
1304188 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2017   grade_1                         33.0 28.0                       61.0                         33 28                 61
1304189 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2017   grade_2                         30.0 26.0                       56.0                         30 26                 56
1304190 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2017   grade_3                         34.0 17.0                       51.0                         34 17                 51
1304191 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2017   grade_4                         20.0 25.0                       45.0                         20 25                 45
1304192 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2017   grade_5                         21.0 25.0                       46.0                         21 25                 46
1304193 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2017   grade_6                         29.0 24.0                       53.0                         29 24                 53
1304194 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2017   grade_7                         22.0 30.0                       52.0                         22 30                 52
1304195 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2017   grade_8                         23.0 21.0                       44.0                         23 21                 44
1304196 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2017   kindergarten                         22.0 33.0                       55.0                         22 33                 55
1304197 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2017   pk_12_total 19.0 392.0 24.0 1.0   1.0         26.0   234.0 229.0     1.0             58.0   463.0 19 392 24 1   1         26   234 229     1       58   463
1304319 IN     school 1800028 9400   KIPP Indy College Prep Middle 180002802136 5860 KIPP Indy College Prep Middle   Regular School Yes Middle 06 08 2017   grade_6                         44.0 30.0                       74.0                         44 30                 74
1304320 IN     school 1800028 9400   KIPP Indy College Prep Middle 180002802136 5860 KIPP Indy College Prep Middle   Regular School Yes Middle 06 08 2017   grade_7                         77.0 53.0                       130.0                         77 53                 130
1304321 IN     school 1800028 9400   KIPP Indy College Prep Middle 180002802136 5860 KIPP Indy College Prep Middle   Regular School Yes Middle 06 08 2017   grade_8                         53.0 47.0                       100.0                         53 47                 100
1304322 IN     school 1800028 9400   KIPP Indy College Prep Middle 180002802136 5860 KIPP Indy College Prep Middle   Regular School Yes Middle 06 08 2017   pk_12_total 7.0 275.0 12.0               10.0   174.0 130.0     2.0             61.0   304.0 7 275 12               10   174 130     2       61   304
1292967 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   grade_1                         33.0 22.0                       55.0                         33 22                 55
1292968 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   grade_2                         47.0 38.0                       85.0                         47 38                 85
1292969 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   grade_3                         39.0 50.0                       89.0                         39 50                 89
1292970 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   grade_4                         60.0 47.0                       107.0                         60 47                 107
1292971 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   grade_5                         53.0 45.0                       98.0                         53 45                 98
1292972 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         13.0 21.0                       34.0                         13 21                 34
1292973 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 376.0 8.0 20.0 1.0   38.0         25.0   245.0 223.0     1.0             16.0   468.0 376 8 20 1   38         25   245 223     1       16   468
1292982 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2017   grade_10                         298.0 300.0                       598.0                         298 300                 598
1292983 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2017   grade_11                         292.0 279.0                       571.0                         292 279                 571
1292984 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2017   grade_12                         305.0 282.0                       587.0                         305 282                 587
1292985 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2017   grade_9                         301.0 291.0                       592.0                         301 291                 592
1292986 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2017   pk_12_total 1911.0 134.0 117.0 5.0   94.0     2.0   85.0   1196.0 1152.0     5.0             201.0   2348.0 1911 134 117 5   94     2   85   1196 1152     5       201   2348
1292998 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2017   grade_6                         172.0 152.0                       324.0                         172 152                 324
1292999 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2017   grade_7                         183.0 186.0                       369.0                         183 186                 369
1293000 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2017   grade_8                         171.0 169.0                       340.0                         171 169                 340
1293001 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2017   pk_12_total 813.0 55.0 51.0 3.0   60.0     3.0   48.0   526.0 507.0     5.0             73.0   1033.0 813 55 51 3   60     3   48   526 507     5       73   1033

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