Data source: Big Local News · About: Big Local

11,966 rows where state = "IN" and year = 2020 sorted by school_nces_id

View and edit SQL

grade

year

  • 2020 · 11,866
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
1918545 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 2020   grade_11                         2.0 5.0                       7.0                         2 5                 7
1918546 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 2020   grade_12                         8.0 6.0                       14.0                         8 6                 14
1918547 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 2020   grade_2                         5.0 3.0                       8.0                         5 3                 8
1918548 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 2020   grade_3                         5.0 0.0                       5.0                         5 0                 5
1918549 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 2020   grade_4                         4.0 2.0                       6.0                         4 2                 6
1918550 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 2020   grade_5                         3.0 3.0                       6.0                         3 3                 6
1918551 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 2020   grade_6                         6.0 3.0                       9.0                         6 3                 9
1918552 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 2020   grade_7                         3.0 0.0                       3.0                         3 0                 3
1918553 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 2020   grade_8                         5.0 5.0                       10.0                         5 5                 10
1918554 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 2020   grade_9                         11.0 4.0                       15.0                         11 4                 15
1918555 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 2020   kindergarten                         0.0 1.0                       1.0                         0 1                 1
1918556 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 2020   pk_12_total 70.0 25.0 17.0     2.0         8.0   73.0 49.0     6.0         105.0   108.0   122.0 70 25 17     2         8   73 49     6     105 108   122
1918557 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 2020   pre_kindergarten                         3.0 5.0                       8.0                         3 5                 8
1918558 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2020   grade_1                         10.0 10.0                       20.0                         10 10                 20
1918559 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2020   grade_10                         7.0 16.0                       23.0                         7 16                 23
1918560 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2020   grade_11                         16.0 18.0                       34.0                         16 18                 34
1918561 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2020   grade_12                         15.0 18.0                       33.0                         15 18                 33
1918562 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2020   grade_2                         7.0 20.0                       27.0                         7 20                 27
1918563 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2020   grade_3                         14.0 5.0                       19.0                         14 5                 19
1918564 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2020   grade_4                         9.0 10.0                       19.0                         9 10                 19
1918565 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2020   grade_5                         8.0 7.0                       15.0                         8 7                 15
1918566 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2020   grade_6                         11.0 10.0                       21.0                         11 10                 21
1918567 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2020   grade_7                         4.0 6.0                       10.0                         4 6                 10
1918568 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2020   grade_8                         11.0 15.0                       26.0                         11 15                 26
1918569 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2020   grade_9                         12.0 14.0                       26.0                         12 14                 26
1918570 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2020   kindergarten                         8.0 8.0                       16.0                         8 8                 16
1918571 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2020   pk_12_total 202.0 38.0 37.0     15.0         23.0   147.0 168.0     31.0         299.0   296.0   315.0 202 38 37     15         23   147 168     31     299 296   315
1918572 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2020   pre_kindergarten                         15.0 11.0                       26.0                         15 11                 26
1918430 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2020   grade_1                         29.0 40.0                       69.0                         29 40                 69
1918431 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2020   grade_10                         42.0 42.0                       84.0                         42 42                 84
1918432 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2020   grade_11                         48.0 37.0                       85.0                         48 37                 85
1918433 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2020   grade_12                         49.0 45.0                       94.0                         49 45                 94
1918434 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2020   grade_2                         46.0 35.0                       81.0                         46 35                 81
1918435 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2020   grade_3                         38.0 37.0                       75.0                         38 37                 75
1918436 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2020   grade_4                         50.0 41.0                       91.0                         50 41                 91
1918437 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2020   grade_5                         33.0 35.0                       68.0                         33 35                 68
1918438 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2020   grade_6                         41.0 41.0                       82.0                         41 41                 82
1918439 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2020   grade_7                         46.0 49.0                       95.0                         46 49                 95
1918440 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2020   grade_8                         45.0 47.0                       92.0                         45 47                 92
1918441 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2020   grade_9                         58.0 47.0                       105.0                         58 47                 105
1918442 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2020   kindergarten                         23.0 42.0                       65.0                         23 42                 65
1918443 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2020   pk_12_total 2.0 1033.0 39.0               12.0   548.0 538.0     3.0         1086.0   115.0   1086.0 2 1033 39               12   548 538     3     1086 115   1086
1918290 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2020   grade_1                         34.0 42.0                       76.0                         34 42                 76
1918291 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2020   grade_2                         29.0 40.0                       69.0                         29 40                 69
1918292 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2020   grade_3                         34.0 44.0                       78.0                         34 44                 78
1918293 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2020   grade_4                         35.0 40.0                       75.0                         35 40                 75
1918294 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2020   grade_5                         31.0 46.0                       77.0                         31 46                 77
1918295 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2020   grade_6                         37.0 39.0                       76.0                         37 39                 76
1918296 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2020   grade_7                         29.0 41.0                       70.0                         29 41                 70
1918297 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2020   grade_8                         27.0 36.0                       63.0                         27 36                 63
1918298 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2020   kindergarten                         41.0 33.0                       74.0                         41 33                 74
1918299 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2020   pk_12_total 17.0 574.0 35.0 2.0   1.0         29.0   297.0 361.0     6.0         626.0   89.0   658.0 17 574 35 2   1         29   297 361     6     626 89   658
1918396 IN     school 1800028 9400   KIPP Indy College Prep Middle 180002802136 5860 KIPP Indy College Prep Middle   Regular School Yes Middle 06 08 2020   grade_6                         27.0 34.0                       61.0                         27 34                 61
1918397 IN     school 1800028 9400   KIPP Indy College Prep Middle 180002802136 5860 KIPP Indy College Prep Middle   Regular School Yes Middle 06 08 2020   grade_7                         55.0 59.0                       114.0                         55 59                 114
1918398 IN     school 1800028 9400   KIPP Indy College Prep Middle 180002802136 5860 KIPP Indy College Prep Middle   Regular School Yes Middle 06 08 2020   grade_8                         56.0 63.0                       119.0                         56 63                 119
1918399 IN     school 1800028 9400   KIPP Indy College Prep Middle 180002802136 5860 KIPP Indy College Prep Middle   Regular School Yes Middle 06 08 2020   pk_12_total 9.0 246.0 27.0               12.0   138.0 156.0     19.0         264.0   50.0   294.0 9 246 27               12   138 156     19     264 50   294
1907040 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2020   grade_1                         36.0 22.0                       58.0                         36 22                 58
1907041 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2020   grade_2                         44.0 33.0                       77.0                         44 33                 77
1907042 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2020   grade_3                         48.0 42.0                       90.0                         48 42                 90
1907043 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2020   grade_4                         56.0 44.0                       100.0                         56 44                 100
1907044 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2020   grade_5                         50.0 46.0                       96.0                         50 46                 96
1907045 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2020   kindergarten                         22.0 26.0                       48.0                         22 26                 48
1907046 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 393.0 6.0 18.0 2.0   24.0         26.0   256.0 213.0     2.0         62.0   21.0   469.0 393 6 18 2   24         26   256 213     2     62 21   469
1907055 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2020   grade_10                         339.0 334.0                       673.0                         339 334                 673
1907056 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2020   grade_11                         299.0 287.0                       586.0                         299 287                 586
1907057 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2020   grade_12                         301.0 301.0                       602.0                         301 301                 602
1907058 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2020   grade_9                         317.0 302.0                       619.0                         317 302                 619
1907059 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2020   pk_12_total 1965.0 124.0 167.0 8.0   111.0     2.0   103.0   1256.0 1224.0     19.0         377.0   195.0   2480.0 1965 124 167 8   111     2   103   1256 1224     19     377 195   2480
1907071 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2020   grade_6                         156.0 163.0                       319.0                         156 163                 319
1907072 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2020   grade_7                         169.0 174.0                       343.0                         169 174                 343
1907073 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2020   grade_8                         182.0 175.0                       357.0                         182 175                 357
1907074 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2020   pk_12_total 736.0 88.0 73.0 1.0   60.0     3.0   58.0   507.0 512.0     12.0         201.0   70.0   1019.0 736 88 73 1   60     3   58   507 512     12     201 70   1019
1907047 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2020   grade_1                         37.0 46.0                       83.0                         37 46                 83
1907048 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2020   grade_2                         48.0 41.0                       89.0                         48 41                 89
1907049 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2020   grade_3                         44.0 46.0                       90.0                         44 46                 90
1907050 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2020   grade_4                         50.0 40.0                       90.0                         50 40                 90
1907051 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2020   grade_5                         51.0 41.0                       92.0                         51 41                 92
1907052 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2020   kindergarten                         59.0 36.0                       95.0                         59 36                 95
1907053 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2020   pk_12_total 386.0 74.0 32.0 3.0   40.0         37.0   312.0 260.0     30.0         152.0   72.0   572.0 386 74 32 3   40         37   312 260     30     152 72   572
1907054 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2020   pre_kindergarten                         23.0 10.0                       33.0                         23 10                 33
1907060 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2020   grade_6                         140.0 136.0                       276.0                         140 136                 276
1907061 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2020   grade_7                         151.0 128.0                       279.0                         151 128                 279
1907062 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2020   grade_8                         114.0 127.0                       241.0                         114 127                 241
1907063 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2020   pk_12_total 679.0 25.0 40.0 1.0   20.0         31.0   405.0 391.0     7.0         155.0   75.0   796.0 679 25 40 1   20         31   405 391     7     155 75   796
1907089 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2020   grade_1                         78.0 55.0                       133.0                         78 55                 133
1907090 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2020   grade_2                         88.0 60.0                       148.0                         88 60                 148
1907091 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2020   grade_3                         56.0 66.0                       122.0                         56 66                 122
1907092 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2020   grade_4                         64.0 59.0                       123.0                         64 59                 123
1907093 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2020   grade_5                         76.0 66.0                       142.0                         76 66                 142
1907094 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2020   kindergarten                         80.0 79.0                       159.0                         80 79                 159
1907095 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 589.0 110.0 46.0     31.0     1.0   50.0   442.0 385.0     9.0         194.0   75.0   827.0 589 110 46     31     1   50   442 385     9     194 75   827
1907064 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2020   grade_1                         51.0 48.0                       99.0                         51 48                 99
1907065 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2020   grade_2                         66.0 62.0                       128.0                         66 62                 128
1907066 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2020   grade_3                         51.0 62.0                       113.0                         51 62                 113
1907067 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2020   grade_4                         71.0 53.0                       124.0                         71 53                 124
1907068 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2020   grade_5                         57.0 60.0                       117.0                         57 60                 117
1907069 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2020   kindergarten                         59.0 42.0                       101.0                         59 42                 101
1907070 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2020   pk_12_total 597.0 20.0 32.0     10.0     1.0   22.0   355.0 327.0     0.0         100.0   65.0   682.0 597 20 32     10     1   22   355 327     0     100 65   682
1907075 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2020   grade_1                         31.0 38.0                       69.0                         31 38                 69
1907076 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2020   grade_2                         37.0 39.0                       76.0                         37 39                 76

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