Data source: Big Local News · About: Big Local

152 rows where grade = "adult", state = "IN" and year = 2021

View and edit SQL

year

  • 2021 · 52

grade

  • adult · 52
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
1926542 IN     school 1802460 5855   Crawfordsville Community Schools 180246000287 6277 Crawfordsville Sr High School   Regular School No High 09 12 2021   adult                         0.0 1.0                       1.0                         0 1                 1
1926602 IN     school 1806510 5925   MSD Martinsville Schools 180651001135 6329 Martinsville High School   Regular School No High 09 12 2021   adult                         2.0 2.0                       4.0                         2 2                 4
1926731 IN     school 1807920 5945   North Newton School Corp 180792001363 6411 North Newton Jr-Sr High School   Regular School No High 07 12 2021   adult                         5.0 0.0                       5.0                         5 0                 5
1926760 IN     school 1801710 6055   Central Noble Com School Corp 180171000230 6453 Central Noble Junior Senior HS   Regular School No High 06 12 2021   adult                         0.0 1.0                       1.0                         0 1                 1
1926781 IN     school 1802970 6060   East Noble School Corporation 180297000389 6458 East Noble High School   Regular School No High 09 12 2021   adult                         1.0 3.0                       4.0                         1 3                 4
1926819 IN     school 1812900 6065   West Noble School Corporation 181290002058 6489 West Noble High School   Regular School No High 09 12 2021   adult                         8.0 2.0                       10.0                         8 2                 10
1926976 IN     school 1801740 6325   Perry Central Com Schools Corp 180174000234 6708 Perry Central Jr-Sr High School   Regular School No High 07 12 2021   adult                         0.0 2.0                       2.0                         0 2                 2
1926999 IN     school 1811260 6350   Tell City-Troy Twp School Corp 181126001819 6741 Tell City Jr-Sr High School   Regular School No High 07 12 2021   adult                         2.0 0.0                       2.0                         2 0                 2
1927036 IN     school 1800118 6375   North Central Parke Comm Schl Corp 180011802644 6654 Parke Heritage High School   Regular School No High 09 12 2021   adult                         1.0 0.0                       1.0                         1 0                 1
1927083 IN     school   6470   Duneland School Corporation   6811 Porter County Education Services             2021   adult                         1.0 0.0                       1.0                         1 0                 1
1927113 IN     school 1802800 6470   Duneland School Corporation 180280000333 6925 Chesterton Senior High School   Regular School No High 09 12 2021   adult                         3.0 0.0                       3.0                         3 0                 3
1927195 IN     school 1809180 6520   Porter Township School Corp 180918001521 6838 Boone Grove High School   Regular School No High 09 12 2021   adult                         2.0 4.0                       6.0                         2 4                 6
1927238 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   adult                         2.0 1.0                       3.0                         2 1                 3
1927252 IN     school 1809150 6550   Portage Township Schools 180915001514 6853 Portage High School   Regular School No High 09 12 2021   adult                         10.0 3.0                       13.0                         10 3                 13
1927322 IN     school   6560   Valparaiso Community Schools   6811 Porter County Education Services             2021   adult                         0.0 1.0                       1.0                         0 1                 1
1927333 IN     school 1811970 6560   Valparaiso Community Schools 181197001891 6881 Valparaiso High School   Regular School No High 09 12 2021   adult                         8.0 4.0                       12.0                         8 4                 12
1927403 IN     school 1807290 6590   MSD Mount Vernon 180729001226 6949 Mount Vernon High School   Regular School No High 09 12 2021   adult                         2.0 1.0                       3.0                         2 1                 3
1927478 IN     school 1809360 6630   West Central School Corp 180936001529 7025 West Central Senior High School   Regular School No High 09 12 2021   adult                         2.0 2.0                       4.0                         2 2                 4
1927543 IN     school 1802220 6750   Cloverdale Community Schools 180222000265 7077 Cloverdale High School   Regular School No High 09 12 2021   adult                         1.0 0.0                       1.0                         1 0                 1
1927606 IN     school 1811730 6795   Union School Corporation 181173002666 7131 Indiana Digital JR and High School   Regular School No High 07 12 2021   adult                         1.0 0.0                       1.0                         1 0                 1
1927703 IN     school 1810530 6865   South Ripley Com Sch Corp 181053001729 7182 South Ripley High School   Regular School No High 09 12 2021   adult                         2.0 0.0                       2.0                         2 0                 2
1927709 IN     school 1800390 6895   Batesville Community School Corp 180039000084 7217 Batesville High School   Regular School No High 09 12 2021   adult                         1.0 1.0                       2.0                         1 1                 2
1927794 IN     school 1809750 6995   Rush County Schools 180975001596 7285 Rushville Consolidated High School   Regular School No High 09 12 2021   adult                         1.0 4.0                       5.0                         1 4                 5
1927806 IN     school 1809120 7150   John Glenn School Corporation 180912001505 7453 John Glenn High School   Regular School No High 09 12 2021   adult                         2.0 0.0                       2.0                         2 0                 2
1927866 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001451 7353 Penn High School   Regular School No High 09 12 2021   adult                         159.0 288.0                       447.0                         159 288                 447
1927937 IN     school 1806840 7200   School City of Mishawaka 180684001183 7461 Mishawaka High School   Regular School No High 09 12 2021   adult                         12.0 7.0                       19.0                         12 7                 19
1927946 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Oaklawn Campus Program   Special Education School No High 07 12 2021   adult                         1.0 0.0                       1.0                         1 0                 1
1928193 IN     school 1810290 7205   South Bend Community School Corp 181029002574 7617 Studebaker Center   Regular School No Prekindergarten PK PK 2021   adult                         27.0 28.0                       55.0                         27 28                 55
1928255 IN     school 1810020 7255   Scott County School District 2 181002001612 7641 Scottsburg Senior High School   Regular School No High 09 12 2021   adult                         13.0 4.0                       17.0                         13 4                 17
1928417 IN     school 1808010 7385   North Spencer County Sch Corp 180801001376 7759 Heritage Hills High School   Regular School No High 09 12 2021   adult                         1.0 0.0                       1.0                         1 0                 1
1928489 IN     school 1805340 7525   Knox Community School Corp 180534000938 7833 Knox Community High School   Regular School No High 09 12 2021   adult                         3.0 3.0                       6.0                         3 3                 6
1928523 IN     school 1804230 7610   Hamilton Community Schools 180423000724 7885 Hamilton Community High School   Regular School No High 06 12 2021   adult                         0.0 1.0                       1.0                         0 1                 1
1928539 IN     school 1811100 7615   MSD Steuben County 181110001797 7893 Angola High School   Regular School No High 09 12 2021   adult                         5.0 3.0                       8.0                         5 3                 8
1928641 IN     school 1811220 7775   Switzerland County School Corp 181122001811 7993 Switzerland Co Senior High School   Regular School No High 09 12 2021   adult                         1.0 1.0                       2.0                         1 1                 2
1928833 IN     school 1812870 7875   West Lafayette Com School Corp 181287002048 8129 West Lafayette Jr/Sr High School   Regular School No High 07 12 2021   adult                         2.0 1.0                       3.0                         2 1                 3
1929221 IN     school 1812090 8030   Vigo County School Corp 181209001917 8441 Terre Haute North Vigo High School   Regular School No High 09 12 2021   adult                         1.0 0.0                       1.0                         1 0                 1
1929433 IN     school 1812180 8050   MSD Wabash County Schools 181218001945 8651 Northfield Jr-Sr High School   Regular School No High 07 12 2021   adult                         0.0 1.0                       1.0                         0 1                 1
1929461 IN     school 1812180 8050   MSD Wabash County Schools 181218001951 8673 White's Jr-Sr High School   Regular School No High 07 12 2021   adult                         2.0 0.0                       2.0                         2 0                 2
1929584 IN     school 1812390 8130   Warrick County School Corp 181239001975 8789 Boonville High School   Regular School No High 09 12 2021   adult                         1.0 1.0                       2.0                         1 1                 2
1929601 IN     school 1812390 8130   Warrick County School Corp 181239001977 8809 Castle High School   Regular School No High 09 12 2021   adult                         8.0 2.0                       10.0                         8 2                 10
1929628 IN     school 1809810 8205   Salem Community Schools 180981001600 8857 Salem High School   Regular School No High 09 12 2021   adult                         0.0 1.0                       1.0                         0 1                 1
1929730 IN     school 1808190 8375   Northeastern Wayne Schools 180819001406 8927 Northeastern High School   Regular School No High 09 12 2021   adult                         0.0 1.0                       1.0                         0 1                 1
1929748 IN     school 1809510 8385   Richmond Community Schools 180951001566 8993 Richmond High School   Regular School No High 09 12 2021   adult                         6.0 4.0                       10.0                         6 4                 10
1929931 IN     school 1811580 8565   Twin Lakes School Corp 181158001863 9149 Twin Lakes Senior High School   Regular School No High 09 12 2021   adult                         2.0 1.0                       3.0                         2 1                 3
1929954 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No High 06 12 2021   adult                         4.0 0.0                       4.0                         4 0                 4
1930004 IN     school 1802280 8665   Whitley County Con Schools 180228000267 9187 Columbia City High School   Regular School No High 09 12 2021   adult                         2.0 8.0                       10.0                         2 8                 10
1930180 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 08 12 2021   adult                         2.0 0.0                       2.0                         2 0                 2
1930187 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2021   adult                         43.0 0.0                       43.0                         43 0                 43
1930200 IN     school 1800006 9100   Indiana Department of Correction 180000602453 5616 Dept of Correction Adult Schools   Special Education School No High 07 12 2021   adult                         70.0 3.0                       73.0                         70 3                 73
1930537 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 2021   adult                         10.0 4.0                       14.0                         10 4                 14
1930553 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   adult                         4.0 4.0                       8.0                         4 4                 8
1930674 IN     school 1800113 9730   Neighbors' New Vistas High School 180011302544 6864 Neighbors' New Vistas High School   Regular School Yes High 09 12 2021   adult                         38.0 32.0                       70.0                         38 32                 70

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