Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

  • 2021 · 12,002
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade ▼ year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1919512 IN     school   255   East Allen County Schools   318 EACS Early Childhood Preschool             2021   pk_12_total 28.0 8.0 4.0     4.0         4.0   36.0 12.0     0.0         24.0   40.0   48.0 28 8 4     4         4   36 12     0     24 40   48
1919513 IN     school   255   East Allen County Schools   318 EACS Early Childhood Preschool             2021   pre_kindergarten                         36.0 12.0                       48.0                         36 12                 48
1925542 IN     school   5375   MSD Wayne Township   5271 Sanders School             2021   grade_10                         0.0 3.0                       3.0                         0 3                 3
1925543 IN     school   5375   MSD Wayne Township   5271 Sanders School             2021   grade_11                         4.0 3.0                       7.0                         4 3                 7
1925544 IN     school   5375   MSD Wayne Township   5271 Sanders School             2021   grade_12                         4.0 0.0                       4.0                         4 0                 4
1925545 IN     school   5375   MSD Wayne Township   5271 Sanders School             2021   grade_2                         6.0 0.0                       6.0                         6 0                 6
1925546 IN     school   5375   MSD Wayne Township   5271 Sanders School             2021   grade_3                         8.0 1.0                       9.0                         8 1                 9
1925547 IN     school   5375   MSD Wayne Township   5271 Sanders School             2021   grade_4                         5.0 1.0                       6.0                         5 1                 6
1925548 IN     school   5375   MSD Wayne Township   5271 Sanders School             2021   grade_5                         4.0 1.0                       5.0                         4 1                 5
1925549 IN     school   5375   MSD Wayne Township   5271 Sanders School             2021   grade_6                         4.0 0.0                       4.0                         4 0                 4
1925550 IN     school   5375   MSD Wayne Township   5271 Sanders School             2021   grade_7                         7.0 1.0                       8.0                         7 1                 8
1925551 IN     school   5375   MSD Wayne Township   5271 Sanders School             2021   grade_8                         6.0 1.0                       7.0                         6 1                 7
1925552 IN     school   5375   MSD Wayne Township   5271 Sanders School             2021   grade_9                         3.0 2.0                       5.0                         3 2                 5
1925553 IN     school   5375   MSD Wayne Township   5271 Sanders School             2021   pk_12_total 30.0 23.0 4.0               7.0   51.0 13.0     5.0         38.0   63.0   64.0 30 23 4               7   51 13     5     38 63   64
1927083 IN     school   6470   Duneland School Corporation   6811 Porter County Education Services             2021   adult                         1.0 0.0                       1.0                         1 0                 1
1927084 IN     school   6470   Duneland School Corporation   6811 Porter County Education Services             2021   grade_2                         2.0 0.0                       2.0                         2 0                 2
1927085 IN     school   6470   Duneland School Corporation   6811 Porter County Education Services             2021   grade_3                         2.0 2.0                       4.0                         2 2                 4
1927086 IN     school   6470   Duneland School Corporation   6811 Porter County Education Services             2021   grade_4                         3.0 1.0                       4.0                         3 1                 4
1927087 IN     school   6470   Duneland School Corporation   6811 Porter County Education Services             2021   grade_5                         1.0 0.0                       1.0                         1 0                 1
1927088 IN     school   6470   Duneland School Corporation   6811 Porter County Education Services             2021   grade_7                         1.0 1.0                       2.0                         1 1                 2
1927089 IN     school   6470   Duneland School Corporation   6811 Porter County Education Services             2021   grade_9                         1.0 0.0                       1.0                         1 0                 1
1927090 IN     school   6470   Duneland School Corporation   6811 Porter County Education Services             2021   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1927091 IN     school   6470   Duneland School Corporation   6811 Porter County Education Services             2021   pk_12_total 11.0 1.0 3.0     1.0             12.0 4.0     1.0         7.0   16.0   16.0 11 1 3     1             12 4     1     7 16   16
1927137 IN     school   6510   East Porter County School Corp   6811 Porter County Education Services             2021   grade_2                         0.0 1.0                       1.0                         0 1                 1
1927138 IN     school   6510   East Porter County School Corp   6811 Porter County Education Services             2021   grade_4                         0.0 1.0                       1.0                         0 1                 1
1927139 IN     school   6510   East Porter County School Corp   6811 Porter County Education Services             2021   grade_5                         1.0 0.0                       1.0                         1 0                 1
1927140 IN     school   6510   East Porter County School Corp   6811 Porter County Education Services             2021   grade_6                         2.0 0.0                       2.0                         2 0                 2
1927141 IN     school   6510   East Porter County School Corp   6811 Porter County Education Services             2021   grade_8                         1.0 0.0                       1.0                         1 0                 1
1927142 IN     school   6510   East Porter County School Corp   6811 Porter County Education Services             2021   pk_12_total 5.0   1.0                   4.0 2.0     0.0         3.0   6.0   6.0 5   1                   4 2     0     3 6   6
1927188 IN     school   6520   Porter Township School Corp   6811 Porter County Education Services             2021   grade_1                         0.0 1.0                       1.0                         0 1                 1
1927189 IN     school   6520   Porter Township School Corp   6811 Porter County Education Services             2021   grade_12                         1.0 0.0                       1.0                         1 0                 1
1927190 IN     school   6520   Porter Township School Corp   6811 Porter County Education Services             2021   kindergarten                         0.0 1.0                       1.0                         0 1                 1
1927191 IN     school   6520   Porter Township School Corp   6811 Porter County Education Services             2021   pk_12_total 3.0                       1.0 2.0     0.0             3.0   3.0 3                       1 2     0       3   3
1927211 IN     school   6530   Union Township School Corp   6811 Porter County Education Services             2021   grade_2                         0.0 1.0                       1.0                         0 1                 1
1927212 IN     school   6530   Union Township School Corp   6811 Porter County Education Services             2021   grade_6                         0.0 1.0                       1.0                         0 1                 1
1927213 IN     school   6530   Union Township School Corp   6811 Porter County Education Services             2021   grade_9                         0.0 1.0                       1.0                         0 1                 1
1927214 IN     school   6530   Union Township School Corp   6811 Porter County Education Services             2021   pk_12_total 3.0                       0.0 3.0     0.0         3.0   3.0   3.0 3                       0 3     0     3 3   3
1927238 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   adult                         2.0 1.0                       3.0                         2 1                 3
1927239 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   grade_1                         0.0 1.0                       1.0                         0 1                 1
1927240 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   grade_10                         3.0 0.0                       3.0                         3 0                 3
1927241 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   grade_11                         0.0 1.0                       1.0                         0 1                 1
1927242 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   grade_12                         0.0 1.0                       1.0                         0 1                 1
1927243 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   grade_2                         6.0 1.0                       7.0                         6 1                 7
1927244 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   grade_3                         3.0 0.0                       3.0                         3 0                 3
1927245 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   grade_4                         4.0 0.0                       4.0                         4 0                 4
1927246 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   grade_5                         1.0 0.0                       1.0                         1 0                 1
1927247 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   grade_6                         3.0 0.0                       3.0                         3 0                 3
1927248 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   grade_7                         2.0 0.0                       2.0                         2 0                 2
1927249 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   grade_8                         4.0 2.0                       6.0                         4 2                 6
1927250 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   kindergarten                         1.0 1.0                       2.0                         1 1                 2
1927251 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   pk_12_total 24.0 5.0 3.0     1.0         4.0   29.0 8.0     0.0         19.0   37.0   37.0 24 5 3     1         4   29 8     0     19 37   37
1927322 IN     school   6560   Valparaiso Community Schools   6811 Porter County Education Services             2021   adult                         0.0 1.0                       1.0                         0 1                 1
1927323 IN     school   6560   Valparaiso Community Schools   6811 Porter County Education Services             2021   grade_1                         2.0 2.0                       4.0                         2 2                 4
1927324 IN     school   6560   Valparaiso Community Schools   6811 Porter County Education Services             2021   grade_10                         1.0 0.0                       1.0                         1 0                 1
1927325 IN     school   6560   Valparaiso Community Schools   6811 Porter County Education Services             2021   grade_12                         2.0 0.0                       2.0                         2 0                 2
1927326 IN     school   6560   Valparaiso Community Schools   6811 Porter County Education Services             2021   grade_2                         4.0 0.0                       4.0                         4 0                 4
1927327 IN     school   6560   Valparaiso Community Schools   6811 Porter County Education Services             2021   grade_3                         2.0 1.0                       3.0                         2 1                 3
1927328 IN     school   6560   Valparaiso Community Schools   6811 Porter County Education Services             2021   grade_4                         2.0 1.0                       3.0                         2 1                 3
1927329 IN     school   6560   Valparaiso Community Schools   6811 Porter County Education Services             2021   grade_5                         2.0 3.0                       5.0                         2 3                 5
1927330 IN     school   6560   Valparaiso Community Schools   6811 Porter County Education Services             2021   grade_6                         6.0 0.0                       6.0                         6 0                 6
1927331 IN     school   6560   Valparaiso Community Schools   6811 Porter County Education Services             2021   grade_9                         1.0 0.0                       1.0                         1 0                 1
1927332 IN     school   6560   Valparaiso Community Schools   6811 Porter County Education Services             2021   pk_12_total 20.0 3.0 6.0               1.0   22.0 8.0     2.0         15.0   30.0   30.0 20 3 6               1   22 8     2     15 30   30
1928191 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2021   pk_12_total 80.0 50.0 35.0               36.0   130.0 71.0     0.0         2.0   105.0   201.0 80 50 35               36   130 71     0     2 105   201
1928192 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2021   pre_kindergarten                         130.0 71.0                       201.0                         130 71                 201
1920021 IN     school 1800213 945   Silver Creek School Corporation 180021302469 818 Silver Creek Primary School   Regular School No Elementary PK 01 2021   grade_1                         88.0 103.0                       191.0                         88 103                 191
1920022 IN     school 1800213 945   Silver Creek School Corporation 180021302469 818 Silver Creek Primary School   Regular School No Elementary PK 01 2021   kindergarten                         112.0 105.0                       217.0                         112 105                 217
1920023 IN     school 1800213 945   Silver Creek School Corporation 180021302469 818 Silver Creek Primary School   Regular School No Elementary PK 01 2021   pk_12_total 365.0 8.0 37.0 1.0   3.0         21.0   218.0 217.0     26.0         106.0   86.0   435.0 365 8 37 1   3         21   218 217     26     106 86   435
1920024 IN     school 1800213 945   Silver Creek School Corporation 180021302469 818 Silver Creek Primary School   Regular School No Elementary PK 01 2021   pre_kindergarten                         18.0 9.0                       27.0                         18 9                 27
1921692 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No Elementary PK 01 2021   grade_1                         113.0 85.0                       198.0                         113 85                 198
1921693 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No Elementary PK 01 2021   kindergarten                         80.0 62.0                       142.0                         80 62                 142
1921694 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No Elementary PK 01 2021   pk_12_total 395.0 7.0 33.0 1.0   3.0         49.0   275.0 213.0     2.0         321.0   67.0   488.0 395 7 33 1   3         49   275 213     2     321 67   488
1921695 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No Elementary PK 01 2021   pre_kindergarten                         82.0 66.0                       148.0                         82 66                 148
1925603 IN     school 1800450 5380   Beech Grove City Schools 180045000881 5463 Hornet Park Elementary School   Regular School No Elementary PK 01 2021   grade_1                         109.0 103.0                       212.0                         109 103                 212
1925604 IN     school 1800450 5380   Beech Grove City Schools 180045000881 5463 Hornet Park Elementary School   Regular School No Elementary PK 01 2021   kindergarten                         96.0 101.0                       197.0                         96 101                 197
1925605 IN     school 1800450 5380   Beech Grove City Schools 180045000881 5463 Hornet Park Elementary School   Regular School No Elementary PK 01 2021   pk_12_total 276.0 52.0 47.0     5.0         52.0   219.0 213.0     25.0         220.0   56.0   432.0 276 52 47     5         52   219 213     25     220 56   432
1925606 IN     school 1800450 5380   Beech Grove City Schools 180045000881 5463 Hornet Park Elementary School   Regular School No Elementary PK 01 2021   pre_kindergarten                         14.0 9.0                       23.0                         14 9                 23
1926228 IN     school 1806090 5615   Maconaquah School Corp 180609002318 6012 Pipe Creek Elementary School   Regular School No Elementary PK 01 2021   grade_1                         82.0 71.0                       153.0                         82 71                 153
1926229 IN     school 1806090 5615   Maconaquah School Corp 180609002318 6012 Pipe Creek Elementary School   Regular School No Elementary PK 01 2021   kindergarten                         76.0 67.0                       143.0                         76 67                 143
1926230 IN     school 1806090 5615   Maconaquah School Corp 180609002318 6012 Pipe Creek Elementary School   Regular School No Elementary PK 01 2021   pk_12_total 306.0 6.0 30.0     2.0         23.0   193.0 174.0     8.0         223.0   54.0   367.0 306 6 30     2         23   193 174     8     223 54   367
1926231 IN     school 1806090 5615   Maconaquah School Corp 180609002318 6012 Pipe Creek Elementary School   Regular School No Elementary PK 01 2021   pre_kindergarten                         35.0 36.0                       71.0                         35 36                 71
1926555 IN     school 1802460 5855   Crawfordsville Community Schools 180246000290 6293 Laura Hose Elementary School   Regular School No Elementary KG 01 2021   grade_1                         111.0 109.0                       220.0                         111 109                 220
1926556 IN     school 1802460 5855   Crawfordsville Community Schools 180246000290 6293 Laura Hose Elementary School   Regular School No Elementary KG 01 2021   kindergarten                         94.0 85.0                       179.0                         94 85                 179
1926557 IN     school 1802460 5855   Crawfordsville Community Schools 180246000290 6293 Laura Hose Elementary School   Regular School No Elementary KG 01 2021   pk_12_total 283.0 14.0 86.0 2.0         1.0   13.0   205.0 194.0     57.0         278.0   86.0   399.0 283 14 86 2         1   13   205 194     57     278 86   399
1926825 IN     school 1812900 6065   West Noble School Corporation 181290002055 6491 West Noble Primary School   Regular School No Elementary PK 01 2021   grade_1                         84.0 85.0                       169.0                         84 85                 169
1926826 IN     school 1812900 6065   West Noble School Corporation 181290002055 6491 West Noble Primary School   Regular School No Elementary PK 01 2021   kindergarten                         106.0 69.0                       175.0                         106 69                 175
1926827 IN     school 1812900 6065   West Noble School Corporation 181290002055 6491 West Noble Primary School   Regular School No Elementary PK 01 2021   pk_12_total 152.0   204.0 1.0   1.0         1.0   201.0 158.0     156.0         204.0   64.0   359.0 152   204 1   1         1   201 158     156     204 64   359
1926828 IN     school 1812900 6065   West Noble School Corporation 181290002055 6491 West Noble Primary School   Regular School No Elementary PK 01 2021   pre_kindergarten                         11.0 4.0                       15.0                         11 4                 15
1919465 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2021   grade_1                         70.0 74.0                       144.0                         70 74                 144
1919466 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2021   grade_2                         79.0 69.0                       148.0                         79 69                 148
1919467 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2021   kindergarten                         71.0 66.0                       137.0                         71 66                 137
1919468 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2021   pk_12_total 346.0 40.0 36.0     4.0         36.0   235.0 227.0     6.0         267.0   57.0   462.0 346 40 36     4         36   235 227     6     267 57   462
1919469 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2021   pre_kindergarten                         15.0 18.0                       33.0                         15 18                 33
1919507 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No Elementary PK 02 2021   grade_1                         101.0 101.0                       202.0                         101 101                 202
1919508 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No Elementary PK 02 2021   grade_2                         104.0 81.0                       185.0                         104 81                 185
1919509 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No Elementary PK 02 2021   kindergarten                         79.0 87.0                       166.0                         79 87                 166
1919510 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No Elementary PK 02 2021   pk_12_total 57.0 167.0 79.0     274.0         20.0   309.0 288.0     295.0         503.0   46.0   597.0 57 167 79     274         20   309 288     295     503 46   597
1919511 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No Elementary PK 02 2021   pre_kindergarten                         25.0 19.0                       44.0                         25 19                 44
1919706 IN     school 1800570 515   Blackford County Schools 180057000126 501 North Side Elementary School   Regular School No Elementary KG 02 2021   grade_1                         38.0 29.0                       67.0                         38 29                 67
1919707 IN     school 1800570 515   Blackford County Schools 180057000126 501 North Side Elementary School   Regular School No Elementary KG 02 2021   grade_2                         56.0 43.0                       99.0                         56 43                 99
1919708 IN     school 1800570 515   Blackford County Schools 180057000126 501 North Side Elementary School   Regular School No Elementary KG 02 2021   kindergarten                         53.0 48.0                       101.0                         53 48                 101

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