About this Dataset

COVID-19 Cases In CT Schools (State Summary), 2020-2021 School Year - Archive

This dataset provides the following measures related to COVID-19 in CT public and private PK-12 schools for the latest week-long reporting period:

Number of staff cases and change from the previous reporting period
Number of student cases and change from the previous reporting period
Number of student cases by learning model (fully in-person, hybrid, fully remote, or unknown) and change from the previous reporting period

As of 6/24/2021, COVID-19 school-based surveillance activities for the 2020 – 2021 academic year has ended. The Connecticut Department of Public Health along with the Connecticut State Department of Education are planning to resume these activities at the start of the 2021 – 2022 academic year.

Data for the 2021-2022 school year is available here: https://data.ct.gov/Health-and-Human-Services/COVID-19-Cases-in-CT-Schools-State-Summary-2021-20/r6vy-dvtz
Organization: State of Connecticut
Last updated: 2020-11-12T14:58:15.329637
Tags: covid-19, covid-archive, covid-school-data, education

Tables

Table 1

@usgov.state_of_connecticut_covid_19_cases_in_ct_public_schoo_e6fa7815.table_1

24.66 kB
37 rows
20 columns

CREATE TABLE table_1 (
  "report_period_start_date" TIMESTAMP,
  "report_period_end_date" TIMESTAMP,
  "number_of_staff_cases" BIGINT,
  "number_of_student_cases" BIGINT,
  "number_of_in_person_student_cases" BIGINT,
  "number_of_hybrid_student_cases" BIGINT,
  "number_of_remote_student_cases" BIGINT,
  "number_of_unknown_learning_model_student_cases" BIGINT,
  "percent_change_from_previous_week_staff_cases" DOUBLE  -- Percent Change From Previous Week - Staff Cases,
  "percent_change_from_previous_week_student_cases" DOUBLE  -- Percent Change From Previous Week - Student Cases,
  "percent_change_from_previous_week_in_person_student_cases" DOUBLE  -- Percent Change From Previous Week - In Person Student Cases,
  "percent_change_from_previous_week_hybrid_student_cases" DOUBLE  -- Percent Change From Previous Week - Hybrid Student Cases,
  "percent_change_from_previous_week_remote_student_cases" DOUBLE  -- Percent Change From Previous Week - Remote Student Cases,
  "percent_change_from_previous_week_unknown_learning_mod_a510394d" DOUBLE  -- Percent Change From Previous Week - Unknown Learning Model Student Cases,
  "difference_from_previous_week_staff_cases" BIGINT  -- Difference From Previous Week - Staff Cases,
  "difference_from_previous_week_student_cases" BIGINT  -- Difference From Previous Week - Student Cases,
  "difference_from_previous_week_in_person_student_cases" BIGINT  -- Difference From Previous Week - In Person Student Cases,
  "difference_from_previous_week_hybrid_student_cases" BIGINT  -- Difference From Previous Week - Hybrid Student Cases,
  "difference_from_previous_week_remote_student_cases" BIGINT  -- Difference From Previous Week - Remote Student Cases,
  "difference_from_previous_week_unknown_learning_model_s_fd98f2d5" BIGINT  -- Difference From Previous Week - Unknown Learning Model Student Cases
);