About this Dataset

Mpox Cases Over Time

A. SUMMARY This dataset represents probable or confirmed mpox cases among San Francisco residents. Cases are included by the episode date, defined as either the date when self-reported symptoms began or, if that date is not available, the date the positive test was collected (i.e., specimen collection date). Data are lagged by 5 days, meaning that the most recent date of self-reported symptom or specimen collection included is 1 day prior to today. All data update daily as more information becomes available. B. HOW THE DATASET IS CREATED Case information is based on confirmed or probable positive laboratory tests reported to the San Francisco Department of Public Health. Processes to provide quality assurance and other data verification are completed before the data are reported. This data may not be immediately available for recently reported cases because of the time needed to process tests and validate cases. Data are continually updated to maximize completeness of information and reporting on San Francisco residents with confirmed or probable mpox. C. UPDATE PROCESS Updates to the data are made through automated and manual processes once each day, Monday through Friday. D. HOW TO USE THIS DATASET This dataset shows new cases and cumulative cases (probable and confirmed) by episode date. Episode date is the date of self-reported symptom onset, or, if not available, date of specimen collection (i.e., the date the person was tested). New cases are the count of cases with a symptom onset or specimen collection date on the given episode date. Cumulative cases are the running total of all San Francisco cases through the episode date listed. D. CHANGE LOG 6/15/2023 - added "data_updated_at" column to reference the last date the data was compiled by scripts.
Organization: City of San Francisco
Last updated: 2022-09-09T08:12:50.725095
Tags: monkeypox

Tables

Table 1

@usgov.city_of_san_francisco_mpx_cases_over_time.table_1

17.66 kB
1,093 rows
7 columns

CREATE TABLE table_1 (
  "episode_date" TIMESTAMP,
  "new_cases" BIGINT,
  "cumulative_cases" BIGINT,
  "max_episode_date" TIMESTAMP,
  "data_as_of" VARCHAR,
  "data_updated_at" VARCHAR,
  "data_loaded_at" VARCHAR
);