CT School Learning Model Indicators By County (14-day Metrics) - ARCHIVE by US Government | Healthcare

About this Dataset

CT School Learning Model Indicators By County (14-day Metrics) - ARCHIVE

NOTE: This dataset pertains only to the 2020-2021 school year and is no longer being updated. For additional data on COVID-19, visit data.ct.gov/coronavirus.

This dataset includes the leading and secondary metrics identified by the Connecticut Department of Health (DPH) and the Department of Education (CSDE) to support local district decision-making on the level of in-person, hybrid (blended), and remote learning model for Pre K-12 education.

Data represent daily averages for two-week periods by date of specimen collection (cases and positivity), date of hospital admission, or date of ED visit. Hospitalization data come from the Connecticut Hospital Association and are based on hospital location, not county of patient residence. COVID-19-like illness includes fever and cough or shortness of breath or difficulty breathing or the presence of coronavirus diagnosis code and excludes patients with influenza-like illness. All data are preliminary.

These data are updated weekly and reflect the previous two full Sunday-Saturday (MMWR) weeks (https://wwwn.cdc.gov/nndss/document/MMWR_week_overview.pdf).

These metrics were adapted from recommendations by the Harvard Global Institute and supplemented by existing DPH measures.

For national data on COVID-19, see COVID View, the national weekly surveillance summary of U.S. COVID-19 activity, at https://www.cdc.gov/coronavirus/2019-ncov/covid-data/covidview/index.html

DPH note about change from 7-day to 14-day metrics:
Prior to 10/15/2020, these metrics were calculated using a 7-day average rather than a 14-day average. The 7-day metrics are no longer being updated as of 10/15/2020 but the archived dataset can be accessed here: https://data.ct.gov/Health-and-Human-Services/CT-School-Learning-Model-Indicators-by-County/rpph-4ysy

As you know, we are learning more about COVID-19 all the time, including the best ways to measure COVID-19 activity in our communities. CT DPH has decided to shift to 14-day rates because these are more stable, particularly at the town level, as compared to 7-day rates. In addition, since the school indicators were initially published by DPH last summer, CDC has recommended 14-day rates and other states (e.g., Massachusetts) have started to implement 14-day metrics for monitoring COVID transmission as well.

With respect to geography, we also have learned that many people are looking at the town-level data to inform decision making, despite emphasis on the county-level metrics in the published addenda. This is understandable as there has been variation within counties in COVID-19 activity (for example, rates that are higher in one town than in most other towns in the county).
Organization: State of Connecticut
Last updated: 2020-11-12T14:55:45.055144
Tags: covid-archive

Tables

Table 1

@usgov.state_of_connecticut_ct_school_learning_model_indicato_14d39fe2.table_1

13.56 KB
666 rows
7 columns


CREATE TABLE table_1 (
  "county" VARCHAR,
  "new_covid_19_cases_per_100k_population_over_14_day_period" DOUBLE,
  "percent_test_positivity" DOUBLE,
  "new_hospitalizations_per_100k_population_per_day" DOUBLE,
  "percent_covid_19_like_illness_hospital_ed_visits" DOUBLE,
  "reporting_period" VARCHAR,
  "data_update_date" TIMESTAMP
);