Data source: Big Local News · About: Big Local

4,354 rows where grade = "grade_2" and state = "CT" sorted by school_nces_id

View and edit SQL

year

grade

  • grade_2 · 4,354
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
2437179 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_2                                                   0                                             0
2742821 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2763085 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_2                                                   0                                             0
2437180 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201137 9001116 Bullard-Havens Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_2                                                   0                                             0
2742822 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201137 9001116 Bullard-Havens Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2763086 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201137 9001116 Bullard-Havens Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_2                                                   0                                             0
2437181 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201138 9001916 E. C. Goodwin Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_2                                                   0                                             0
2742823 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201138 9001916 E. C. Goodwin Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2763087 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201138 9001916 E. C. Goodwin Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_2                                                   0                                             0
2437183 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201139 9002716 Ella T. Grasso Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_2                                                   0                                             0
2742825 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201139 9002716 Ella T. Grasso Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2763089 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201139 9002716 Ella T. Grasso Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_2                                                   0                                             0
2437182 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201140 9001416 Eli Whitney Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_2                                                   0                                             0
2742824 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201140 9001416 Eli Whitney Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2763088 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201140 9001416 Eli Whitney Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_2                                                   0                                             0
2437184 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201141 9002516 Emmett O'Brien Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_2                                                   0                                             0
2742826 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201141 9002516 Emmett O'Brien Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2763090 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201141 9002516 Emmett O'Brien Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_2                                                   0                                             0
2437185 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201142 9001716 H. C. Wilcox Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_2                                                   0                                             0
2742827 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201142 9001716 H. C. Wilcox Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2763091 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201142 9001716 H. C. Wilcox Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_2                                                   0                                             0
2437186 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201143 9001316 H. H. Ellis Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_2                                                   0                                             0
2742828 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201143 9001316 H. H. Ellis Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2763092 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201143 9001316 H. H. Ellis Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_2                                                   0                                             0
2437187 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201144 9001216 Henry Abbott Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_2                                                   0                                             0
2742829 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201144 9001216 Henry Abbott Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2763093 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201144 9001216 Henry Abbott Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_2                                                   0                                             0
2437188 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201145 9001616 Howell Cheney Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_2                                                   0                                             0
2742830 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201145 9001616 Howell Cheney Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2763094 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201145 9001616 Howell Cheney Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_2                                                   0                                             0
2437190 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201147 9002016 Norwich Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_2                                                   0                                             0
2742832 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201147 9002016 Norwich Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2763096 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201147 9002016 Norwich Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_2                                                   0                                             0
2437191 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201148 9002216 Oliver Wolcott Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_2                                                   0                                             0
2742833 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201148 9002216 Oliver Wolcott Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2763097 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201148 9002216 Oliver Wolcott Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_2                                                   0                                             0
2437192 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201149 9002616 Platt Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_2                                                   0                                             0
2742834 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201149 9002616 Platt Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2763098 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201149 9002616 Platt Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_2                                                   0                                             0
2437193 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201150 9001816 Vinal Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_2                                                   0                                             0
2742835 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201150 9001816 Vinal Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2763099 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201150 9001816 Vinal Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_2                                                   0                                             0
2437194 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201151 9002316 W. F. Kaynor Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_2                                                   0                                             0
2742836 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201151 9002316 W. F. Kaynor Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2763100 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201151 9002316 W. F. Kaynor Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_2                                                   0                                             0
2437195 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201152 9002416 Windham Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_2                                                   0                                             0
2742837 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201152 9002416 Windham Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2763101 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201152 9002416 Windham Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_2                                                   0                                             0
2437189 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201672 9002116 J. M. Wright Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_2                                                   0                                             0
2742831 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201672 9002116 J. M. Wright Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_2                                                   0                                             0
2763095 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201672 9002116 J. M. Wright Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_2                                                   0                                             0
2742818 CT     school   3360015   Unified School District #1 90000300343 3360115 Bridgeport Correctional Center State Agency Facilities           2021   grade_2                                                   0                                             0
2763075 CT     school   3360015   Unified School District #1 90000300343 3360115 Bridgeport Correctional Center State Agency Facilities           2020   grade_2                                                   0                                             0
2437172 CT     school   3360015   Unified School District #1 90000300347 3360315 Cheshire Correctional Institution State Agency Facilities           2019   grade_2                                                   0                                             0
2742813 CT     school   3360015   Unified School District #1 90000300347 3360315 Cheshire Correctional Institution State Agency Facilities           2021   grade_2                                                   0                                             0
2763076 CT     school   3360015   Unified School District #1 90000300347 3360315 Cheshire Correctional Institution State Agency Facilities           2020   grade_2                                                   0                                             0
2437175 CT     school   3360015   Unified School District #1 90000300361 3360615 Hartford Correctional Center State Agency Facilities           2019   grade_2                                                   0                                             0
2763080 CT     school   3360015   Unified School District #1 90000300361 3360615 Hartford Correctional Center State Agency Facilities           2020   grade_2                                                   0                                             0
2742816 CT     school   3360015   Unified School District #1 90000300374 3360915 New Haven Correctional Center State Agency Facilities           2021   grade_2                                                   0                                             0
2437170 CT     school   3360015   Unified School District #1 90000300404 3361115 Manson Youth Institution State Agency Facilities           2019   grade_2                                                   0                                             0
2742810 CT     school   3360015   Unified School District #1 90000300404 3361115 Manson Youth Institution State Agency Facilities           2021   grade_2                                                   0                                             0
2763072 CT     school   3360015   Unified School District #1 90000300404 3361115 Manson Youth Institution State Agency Facilities           2020   grade_2                                                   0                                             0
2742817 CT     school   3360015   Unified School District #1 90000300408 3361215 Osborn Correctional Institution State Agency Facilities           2021   grade_2                                                   0                                             0
2763081 CT     school   3360015   Unified School District #1 90000300408 3361215 Osborn Correctional Institution State Agency Facilities           2020   grade_2                                                   0                                             0
2763083 CT     school   3360015   Unified School District #1 90000300419 3361315 Robinson Correctional Institution State Agency Facilities           2020   grade_2                                                   0                                             0
2437177 CT     school   3360015   Unified School District #1 90000300436 3361515 Willard/Cybulski Correctional Institution State Agency Facilities           2019   grade_2                                                   0                                             0
2763082 CT     school   3360015   Unified School District #1 90000300436 3361515 Willard/Cybulski Correctional Institution State Agency Facilities           2020   grade_2                                                   0                                             0
2742814 CT     school   3360015   Unified School District #1 90000300454 3361915 Garner Correctional Institution State Agency Facilities           2021   grade_2                                                   0                                             0
2763079 CT     school   3360015   Unified School District #1 90000300454 3361915 Garner Correctional Institution State Agency Facilities           2020   grade_2                                                   0                                             0
2437176 CT     school   3360015   Unified School District #1 90000300469 3362215 MacDougall/Walker Correctional Institution State Agency Facilities           2019   grade_2                                                   0                                             0
2742815 CT     school   3360015   Unified School District #1 90000300469 3362215 MacDougall/Walker Correctional Institution State Agency Facilities           2021   grade_2                                                   0                                             0
2763077 CT     school   3360015   Unified School District #1 90000300469 3362215 MacDougall/Walker Correctional Institution State Agency Facilities           2020   grade_2                                                   0                                             0
2437173 CT     school   3360015   Unified School District #1 90000300844 3362415 Corrigan/Radgowski Correctional Institution State Agency Facilities           2019   grade_2                                                   0                                             0
2742811 CT     school   3360015   Unified School District #1 90000300844 3362415 Corrigan/Radgowski Correctional Institution State Agency Facilities           2021   grade_2                                                   0                                             0
2763073 CT     school   3360015   Unified School District #1 90000300844 3362415 Corrigan/Radgowski Correctional Institution State Agency Facilities           2020   grade_2                                                   0                                             0
2437171 CT     school   3360015   Unified School District #1 90000300849 3362515 York Correctional Institution State Agency Facilities           2019   grade_2                                                   0                                             0
2742812 CT     school   3360015   Unified School District #1 90000300849 3362515 York Correctional Institution State Agency Facilities           2021   grade_2                                                   0                                             0
2763074 CT     school   3360015   Unified School District #1 90000300849 3362515 York Correctional Institution State Agency Facilities           2020   grade_2                                                   0                                             0
2437174 CT     school   3360015   Unified School District #1 90000301349 3362615 Northern Correctional Institution State Agency Facilities           2019   grade_2                                                   0                                             0
2742819 CT     school   3360015   Unified School District #1 90000301349 3362615 Northern Correctional Institution State Agency Facilities           2021   grade_2                                                   0                                             0
2763078 CT     school   3360015   Unified School District #1 90000301349 3362615 Northern Correctional Institution State Agency Facilities           2020   grade_2                                                   0                                             0
2437167 CT     school   3470015   Unified School District #2 90000400475 3470115 Children's Place School State Agency Facilities           2019   grade_2                                                   0                                             0
2742790 CT     school   3470015   Unified School District #2 90000400475 3470115 Children's Place School State Agency Facilities           2021   grade_2                                                   0                                             0
2763051 CT     school   3470015   Unified School District #2 90000400475 3470115 Children's Place School State Agency Facilities           2020   grade_2                                                   0                                             0
2437168 CT     school   3470015   Unified School District #2 90000400479 3470315 Riverview School State Agency Facilities           2019   grade_2                                                   0                                             0
2742789 CT     school   3470015   Unified School District #2 90000400479 3470315 Riverview School State Agency Facilities           2021   grade_2                                                   0                                             0
2763052 CT     school   3470015   Unified School District #2 90000400479 3470315 Riverview School State Agency Facilities           2020   grade_2                                                   0                                             0
2437201 CT     school 900005 2190012   Regional School District 19 90000501215 2196112 E. O. Smith High School Regional Schools Regular School No High 09 12 2019   grade_2                                                   0                                             0
2742844 CT     school 900005 2190012   Regional School District 19 90000501215 2196112 E. O. Smith High School Regional Schools Regular School No High 09 12 2021   grade_2                                                   0                                             0
2763107 CT     school 900005 2190012   Regional School District 19 90000501215 2196112 E. O. Smith High School Regional Schools Regular School No High 09 12 2020   grade_2                                                   0                                             0
2437202 CT     school   2190012   Regional School District 19 90000501729 2190112 E.O. Smith High School at the Depot Campus Program           2019   grade_2                                                   0                                             0
2742845 CT     school   2190012   Regional School District 19 90000501729 2190112 E.O. Smith High School at the Depot Campus Program           2021   grade_2                                                   0                                             0
2763108 CT     school   2190012   Regional School District 19 90000501729 2190112 E.O. Smith High School at the Depot Campus Program           2020   grade_2                                                   0                                             0
2436274 CT     school 900007 2610013   Jumoke Academy District 90000700747 2610113 Jumoke Academy Public Charter Schools Regular School Yes Other PK 12 2019   grade_2                                                   73                                             73
2741912 CT     school 900007 2610013   Jumoke Academy District 90000700747 2610113 Jumoke Academy Public Charter Schools Regular School Yes Other PK 12 2021   grade_2                                                   70                                             70
2762169 CT     school 900007 2610013   Jumoke Academy District 90000700747 2610113 Jumoke Academy Public Charter Schools Regular School Yes Other PK 12 2020   grade_2                                                   67                                             67
2437142 CT     school 900009 2630013   Odyssey Community School District 90000900774 2635113 Odyssey Community School Public Charter Schools Regular School Yes Elementary KG 08 2019   grade_2                                                   36                                             36
2742782 CT     school 900009 2630013   Odyssey Community School District 90000900774 2635113 Odyssey Community School Public Charter Schools Regular School Yes Elementary KG 08 2021   grade_2                                                   34                                             34
2763045 CT     school 900009 2630013   Odyssey Community School District 90000900774 2635113 Odyssey Community School Public Charter Schools Regular School Yes Elementary KG 08 2020   grade_2                                                   35                                             35
2436273 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2019   grade_2                                                   33                                             33

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