Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

  • 2020 · 11,966
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
1907546 IN     school   255   East Allen County Schools   318 EACS Early Childhood Preschool             2020   pk_12_total 36.0 6.0 6.0     4.0         2.0   40.0 14.0     0.0         22.0   46.0   54.0 36 6 6     4         2   40 14     0     22 46   54
1907547 IN     school   255   East Allen County Schools   318 EACS Early Childhood Preschool             2020   pre_kindergarten                         40.0 14.0                       54.0                         40 14                 54
1908007 IN     school   940   West Clark Community Schools   765 Henryville Jr & Sr High School             2020   adult                         1.0 0.0                       1.0                         1 0                 1
1908008 IN     school   940   West Clark Community Schools   765 Henryville Jr & Sr High School             2020   grade_10                         39.0 37.0                       76.0                         39 37                 76
1908009 IN     school   940   West Clark Community Schools   765 Henryville Jr & Sr High School             2020   grade_11                         39.0 48.0                       87.0                         39 48                 87
1908010 IN     school   940   West Clark Community Schools   765 Henryville Jr & Sr High School             2020   grade_12                         38.0 42.0                       80.0                         38 42                 80
1908011 IN     school   940   West Clark Community Schools   765 Henryville Jr & Sr High School             2020   grade_7                         33.0 44.0                       77.0                         33 44                 77
1908012 IN     school   940   West Clark Community Schools   765 Henryville Jr & Sr High School             2020   grade_8                         49.0 41.0                       90.0                         49 41                 90
1908013 IN     school   940   West Clark Community Schools   765 Henryville Jr & Sr High School             2020   grade_9                         55.0 35.0                       90.0                         55 35                 90
1908014 IN     school   940   West Clark Community Schools   765 Henryville Jr & Sr High School             2020   pk_12_total 465.0 4.0 13.0     2.0         17.0   254.0 247.0     3.0         157.0   77.0   501.0 465 4 13     2         17   254 247     3     157 77   501
1908015 IN     school   940   West Clark Community Schools   767 Henryville Elementary School             2020   grade_1                         50.0 43.0                       93.0                         50 43                 93
1908016 IN     school   940   West Clark Community Schools   767 Henryville Elementary School             2020   grade_2                         53.0 40.0                       93.0                         53 40                 93
1908017 IN     school   940   West Clark Community Schools   767 Henryville Elementary School             2020   grade_3                         53.0 58.0                       111.0                         53 58                 111
1908018 IN     school   940   West Clark Community Schools   767 Henryville Elementary School             2020   grade_4                         48.0 47.0                       95.0                         48 47                 95
1908019 IN     school   940   West Clark Community Schools   767 Henryville Elementary School             2020   grade_5                         50.0 48.0                       98.0                         50 48                 98
1908020 IN     school   940   West Clark Community Schools   767 Henryville Elementary School             2020   grade_6                         39.0 44.0                       83.0                         39 44                 83
1908021 IN     school   940   West Clark Community Schools   767 Henryville Elementary School             2020   kindergarten                         44.0 53.0                       97.0                         44 53                 97
1908022 IN     school   940   West Clark Community Schools   767 Henryville Elementary School             2020   pk_12_total 641.0 3.0 15.0     2.0         31.0   351.0 341.0     3.0         286.0   142.0   692.0 641 3 15     2         31   351 341     3     286 142   692
1908023 IN     school   940   West Clark Community Schools   767 Henryville Elementary School             2020   pre_kindergarten                         14.0 8.0                       22.0                         14 8                 22
1908024 IN     school   940   West Clark Community Schools   777 Silver Creek High School             2020   adult                         1.0 0.0                       1.0                         1 0                 1
1908025 IN     school   940   West Clark Community Schools   777 Silver Creek High School             2020   grade_10                         103.0 105.0                       208.0                         103 105                 208
1908026 IN     school   940   West Clark Community Schools   777 Silver Creek High School             2020   grade_11                         113.0 119.0                       232.0                         113 119                 232
1908027 IN     school   940   West Clark Community Schools   777 Silver Creek High School             2020   grade_12                         113.0 93.0                       206.0                         113 93                 206
1908028 IN     school   940   West Clark Community Schools   777 Silver Creek High School             2020   grade_9                         108.0 103.0                       211.0                         108 103                 211
1908029 IN     school   940   West Clark Community Schools   777 Silver Creek High School             2020   pk_12_total 727.0 15.0 72.0 1.0   8.0     4.0   31.0   438.0 420.0     37.0         207.0   83.0   858.0 727 15 72 1   8     4   31   438 420     37     207 83   858
1908030 IN     school   940   West Clark Community Schools   781 Silver Creek Middle School             2020   grade_6                         114.0 95.0                       209.0                         114 95                 209
1908031 IN     school   940   West Clark Community Schools   781 Silver Creek Middle School             2020   grade_7                         110.0 117.0                       227.0                         110 117                 227
1908032 IN     school   940   West Clark Community Schools   781 Silver Creek Middle School             2020   grade_8                         125.0 126.0                       251.0                         125 126                 251
1908033 IN     school   940   West Clark Community Schools   781 Silver Creek Middle School             2020   pk_12_total 572.0 17.0 63.0     5.0         30.0   349.0 338.0     23.0         231.0   110.0   687.0 572 17 63     5         30   349 338     23     231 110   687
1908034 IN     school   940   West Clark Community Schools   789 Silver Creek Elementary School             2020   grade_2                         97.0 101.0                       198.0                         97 101                 198
1908035 IN     school   940   West Clark Community Schools   789 Silver Creek Elementary School             2020   grade_3                         121.0 92.0                       213.0                         121 92                 213
1908036 IN     school   940   West Clark Community Schools   789 Silver Creek Elementary School             2020   grade_4                         96.0 104.0                       200.0                         96 104                 200
1908037 IN     school   940   West Clark Community Schools   789 Silver Creek Elementary School             2020   grade_5                         133.0 93.0                       226.0                         133 93                 226
1908038 IN     school   940   West Clark Community Schools   789 Silver Creek Elementary School             2020   pk_12_total 674.0 10.0 89.0 1.0   15.0         48.0   447.0 390.0     62.0         281.0   122.0   837.0 674 10 89 1   15         48   447 390     62     281 122   837
1908039 IN     school   940   West Clark Community Schools   813 William W Borden High School             2020   adult                         3.0 1.0                       4.0                         3 1                 4
1908040 IN     school   940   West Clark Community Schools   813 William W Borden High School             2020   grade_10                         40.0 13.0                       53.0                         40 13                 53
1908041 IN     school   940   West Clark Community Schools   813 William W Borden High School             2020   grade_11                         35.0 20.0                       55.0                         35 20                 55
1908042 IN     school   940   West Clark Community Schools   813 William W Borden High School             2020   grade_12                         29.0 23.0                       52.0                         29 23                 52
1908043 IN     school   940   West Clark Community Schools   813 William W Borden High School             2020   grade_7                         23.0 34.0                       57.0                         23 34                 57
1908044 IN     school   940   West Clark Community Schools   813 William W Borden High School             2020   grade_8                         31.0 27.0                       58.0                         31 27                 58
1908045 IN     school   940   West Clark Community Schools   813 William W Borden High School             2020   grade_9                         33.0 24.0                       57.0                         33 24                 57
1908046 IN     school   940   West Clark Community Schools   813 William W Borden High School             2020   pk_12_total 317.0 1.0 10.0     2.0         6.0   194.0 142.0     2.0         95.0   77.0   336.0 317 1 10     2         6   194 142     2     95 77   336
1908047 IN     school   940   West Clark Community Schools   815 William W Borden Elementary School             2020   grade_1                         25.0 17.0                       42.0                         25 17                 42
1908048 IN     school   940   West Clark Community Schools   815 William W Borden Elementary School             2020   grade_2                         24.0 17.0                       41.0                         24 17                 41
1908049 IN     school   940   West Clark Community Schools   815 William W Borden Elementary School             2020   grade_3                         12.0 14.0                       26.0                         12 14                 26
1908050 IN     school   940   West Clark Community Schools   815 William W Borden Elementary School             2020   grade_4                         25.0 17.0                       42.0                         25 17                 42
1908051 IN     school   940   West Clark Community Schools   815 William W Borden Elementary School             2020   grade_5                         28.0 27.0                       55.0                         28 27                 55
1908052 IN     school   940   West Clark Community Schools   815 William W Borden Elementary School             2020   grade_6                         25.0 33.0                       58.0                         25 33                 58
1908053 IN     school   940   West Clark Community Schools   815 William W Borden Elementary School             2020   kindergarten                         25.0 17.0                       42.0                         25 17                 42
1908054 IN     school   940   West Clark Community Schools   815 William W Borden Elementary School             2020   pk_12_total 289.0 3.0 8.0     1.0         5.0   164.0 142.0     4.0         106.0   81.0   306.0 289 3 8     1         5   164 142     4     106 81   306
1908055 IN     school   940   West Clark Community Schools   818 Silver Creek Primary School             2020   grade_1                         90.0 92.0                       182.0                         90 92                 182
1908056 IN     school   940   West Clark Community Schools   818 Silver Creek Primary School             2020   kindergarten                         91.0 97.0                       188.0                         91 97                 188
1908057 IN     school   940   West Clark Community Schools   818 Silver Creek Primary School             2020   pk_12_total 350.0 6.0 40.0 2.0   3.0         20.0   206.0 215.0     24.0         135.0   98.0   421.0 350 6 40 2   3         20   206 215     24     135 98   421
1908058 IN     school   940   West Clark Community Schools   818 Silver Creek Primary School             2020   pre_kindergarten                         25.0 26.0                       51.0                         25 26                 51
1909787 IN     school   2865   Marion Community Schools   2416 Grant County Comm Justice Center             2020   grade_10                         1.0 0.0                       1.0                         1 0                 1
1909788 IN     school   2865   Marion Community Schools   2416 Grant County Comm Justice Center             2020   grade_8                         1.0 0.0                       1.0                         1 0                 1
1909789 IN     school   2865   Marion Community Schools   2416 Grant County Comm Justice Center             2020   pk_12_total 2.0                       2.0 0.0     0.0             2.0   2.0 2                       2 0     0       2   2
1913635 IN     school   5375   M S D Wayne Township   5271 Sanders School             2020   grade_1                         4.0 0.0                       4.0                         4 0                 4
1913636 IN     school   5375   M S D Wayne Township   5271 Sanders School             2020   grade_10                         4.0 1.0                       5.0                         4 1                 5
1913637 IN     school   5375   M S D Wayne Township   5271 Sanders School             2020   grade_11                         4.0 0.0                       4.0                         4 0                 4
1913638 IN     school   5375   M S D Wayne Township   5271 Sanders School             2020   grade_12                         4.0 2.0                       6.0                         4 2                 6
1913639 IN     school   5375   M S D Wayne Township   5271 Sanders School             2020   grade_2                         7.0 1.0                       8.0                         7 1                 8
1913640 IN     school   5375   M S D Wayne Township   5271 Sanders School             2020   grade_3                         6.0 0.0                       6.0                         6 0                 6
1913641 IN     school   5375   M S D Wayne Township   5271 Sanders School             2020   grade_4                         4.0 1.0                       5.0                         4 1                 5
1913642 IN     school   5375   M S D Wayne Township   5271 Sanders School             2020   grade_5                         3.0 0.0                       3.0                         3 0                 3
1913643 IN     school   5375   M S D Wayne Township   5271 Sanders School             2020   grade_6                         8.0 1.0                       9.0                         8 1                 9
1913644 IN     school   5375   M S D Wayne Township   5271 Sanders School             2020   grade_7                         7.0 1.0                       8.0                         7 1                 8
1913645 IN     school   5375   M S D Wayne Township   5271 Sanders School             2020   grade_8                         2.0 2.0                       4.0                         2 2                 4
1913646 IN     school   5375   M S D Wayne Township   5271 Sanders School             2020   grade_9                         3.0 3.0                       6.0                         3 3                 6
1913647 IN     school   5375   M S D Wayne Township   5271 Sanders School             2020   pk_12_total 37.0 23.0 4.0               4.0   56.0 12.0     4.0         42.0   68.0   68.0 37 23 4               4   56 12     4     42 68   68
1916255 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2020   pk_12_total 80.0 49.0 42.0     1.0         29.0   142.0 59.0     0.0         3.0   95.0   201.0 80 49 42     1         29   142 59     0     3 95   201
1916256 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2020   pre_kindergarten                         142.0 59.0                       201.0                         142 59                 201
1907184 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2020   grade_1                         37.0 34.0                       71.0                         37 34                 71
1907185 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2020   grade_2                         42.0 33.0                       75.0                         42 33                 75
1907186 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2020   grade_3                         32.0 39.0                       71.0                         32 39                 71
1907187 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2020   grade_4                         40.0 33.0                       73.0                         40 33                 73
1907188 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2020   grade_5                         41.0 34.0                       75.0                         41 34                 75
1907189 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2020   grade_6                         35.0 42.0                       77.0                         35 42                 77
1907190 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2020   grade_7                         38.0 40.0                       78.0                         38 40                 78
1907191 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2020   grade_8                         42.0 43.0                       85.0                         42 43                 85
1907192 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2020   pk_12_total 242.0 149.0 130.0 5.0   17.0     2.0   60.0   307.0 298.0     71.0         327.0   100.0   605.0 242 149 130 5   17     2   60   307 298     71     327 100   605
1907225 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2020   grade_1                         63.0 54.0                       117.0                         63 54                 117
1907226 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2020   grade_2                         60.0 64.0                       124.0                         60 64                 124
1907227 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2020   grade_3                         65.0 60.0                       125.0                         65 60                 125
1907228 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2020   grade_4                         64.0 61.0                       125.0                         64 61                 125
1907229 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2020   grade_5                         55.0 69.0                       124.0                         55 69                 124
1907230 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2020   pk_12_total 242.0 202.0 110.0 2.0   9.0         50.0   307.0 308.0     66.0         356.0   81.0   615.0 242 202 110 2   9         50   307 308     66     356 81   615
1911151 IN     school 1809420 3815   Rensselaer Central School Corp 180942001545 3205 Van Rensselaer Elementary School   Regular School No Elementary 01 06 2020   grade_1                         1.0 0.0                       1.0                         1 0                 1
1911152 IN     school 1809420 3815   Rensselaer Central School Corp 180942001545 3205 Van Rensselaer Elementary School   Regular School No Elementary 01 06 2020   grade_3                         58.0 55.0                       113.0                         58 55                 113
1911153 IN     school 1809420 3815   Rensselaer Central School Corp 180942001545 3205 Van Rensselaer Elementary School   Regular School No Elementary 01 06 2020   grade_4                         51.0 43.0                       94.0                         51 43                 94
1911154 IN     school 1809420 3815   Rensselaer Central School Corp 180942001545 3205 Van Rensselaer Elementary School   Regular School No Elementary 01 06 2020   grade_5                         60.0 59.0                       119.0                         60 59                 119
1911155 IN     school 1809420 3815   Rensselaer Central School Corp 180942001545 3205 Van Rensselaer Elementary School   Regular School No Elementary 01 06 2020   grade_6                         1.0 0.0                       1.0                         1 0                 1
1911156 IN     school 1809420 3815   Rensselaer Central School Corp 180942001545 3205 Van Rensselaer Elementary School   Regular School No Elementary 01 06 2020   pk_12_total 268.0 2.0 46.0     1.0         11.0   171.0 157.0     22.0         176.0   54.0   328.0 268 2 46     1         11   171 157     22     176 54   328
1912449 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 05 2020   grade_1                         61.0 60.0                       121.0                         61 60                 121
1912450 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 05 2020   grade_2                         48.0 57.0                       105.0                         48 57                 105
1912451 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 05 2020   grade_3                         39.0 48.0                       87.0                         39 48                 87
1912452 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 05 2020   grade_4                         57.0 33.0                       90.0                         57 33                 90
1912453 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 05 2020   grade_5                         48.0 43.0                       91.0                         48 43                 91
1912454 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 05 2020   pk_12_total 302.0 50.0 123.0 1.0   8.0         10.0   253.0 241.0     9.0         264.0   86.0   494.0 302 50 123 1   8         10   253 241     9     264 86   494
1912455 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No Elementary 01 05 2020   grade_1                         42.0 41.0                       83.0                         42 41                 83

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