About this Dataset

COVID-19 Cases In CT Schools (Statewide), 2022-2023 School Year - Archive

This dataset provides the number of weekly COVID-19 cases for staff and students in CT public and private PK-12 schools during the 2022-2023 school year. The following metrics are included:

Number of student cases - total
Number of student cases - vaccination status up-to-date
Number of student cases - vaccination status not up-to-date
Number of student cases - vaccination status unknown

Number of staff cases - total
Number of staff cases - vaccination status up-to-date
Number of staff cases -vaccination status not up-to-date
Number of staff cases - vaccination status unknown
Organization: State of Connecticut
Last updated: 2022-09-09T04:56:01.988549
Tags: covid-19, covid-school-data, ct-dph

Tables

Table 1

@usgov.state_of_connecticut_covid_19_cases_in_ct_schools_stat_ce1563e3.table_1

14.06 kB
48 rows
12 columns

CREATE TABLE table_1 (
  "reporting_period_start_date" TIMESTAMP,
  "reporting_period_end_date" TIMESTAMP,
  "staff_cases_total" BIGINT  -- Staff Cases - Total,
  "staff_cases_vaccination_status_up_to_date" BIGINT  -- Staff Cases - Vaccination Status Up-to-date,
  "staff_cases_vaccination_status_not_up_to_date" BIGINT  -- Staff Cases - Vaccination Status Not Up-to-date,
  "staff_cases_vaccination_status_unknown" BIGINT  -- Staff Cases - Vaccination Status Unknown,
  "student_cases_total" BIGINT  -- Student Cases - Total,
  "student_cases_vaccination_status_up_to_date" BIGINT  -- Student Cases - Vaccination Status Up-to-date,
  "student_cases_vaccination_status_not_up_to_date" BIGINT  -- Student Cases - Vaccination Status Not Up-to-date,
  "student_cases_vaccination_status_unknown" BIGINT  -- Student Cases - Vaccination Status Unknown,
  "academicyear" VARCHAR,
  "date_updated" TIMESTAMP
);