About this Dataset

Connecticut Reportable Disease Case List With The County Of Residence

Table published by the Connecticut Department of Public Health that contains reportable disease data. Each row of data represents a case of disease in a person with the reported county of residence.

Each case is assigned to a report period based on the date of symptom onset or first positive test. The report period is identified by the Report Period Start Date and Report Period End Date. The actual date the case occurred is not included to protect confidentially.

All data are preliminary; data for previous weeks are routinely updated as new reports are received, duplicate records are removed, and data errors are corrected.

The following disease(s) are included in this table:

MPOX (previously called Monkeypox), Influenza
Organization: State of Connecticut
Last updated: 2022-09-09T04:52:59.579160
Tags: ct-dph, flu, influenza, monkeypox, mpox, reportable-disease

Tables

Table 1

@usgov.state_of_connecticut_ct_casereportabledisease_county.table_1

813.89 KB
244717 rows
17 columns


CREATE TABLE table_1 (
  "state" VARCHAR,
  "fips" BIGINT,
  "disease" VARCHAR,
  "descriptor_type" VARCHAR,
  "descriptor_value" VARCHAR,
  "temporality_type" VARCHAR,
  "temporality_descriptor" VARCHAR,
  "temporality_value" VARCHAR,
  "county" VARCHAR,
  "countyfips" DOUBLE,
  "county_equivalent_planning_region" VARCHAR,
  "county_equivalent_planning_region_code" DOUBLE,
  "incits" DOUBLE,
  "nscc" DOUBLE,
  "reportperiodstart" TIMESTAMP,
  "reportperiodend" TIMESTAMP,
  "dateupdated" TIMESTAMP
);