San Francisco COVID-19 Daily Test Results and Positivity Over Time

Daily counts of COVID-19 laboratory test results reported in San Francisco, including positive, negative, and indeterminate outcomes. The dataset is created by the City of San Francisco from electronic laboratory reports, with deduplication and quality assurance processes applied. It is updated automatically each day at 05:00 Pacific Time, with a redundant run scheduled for 09:00.

Use Cases

• Track daily testing volume trends over time based on the 'result_date' field.
• Calculate and visualize the positivity rate over time based on daily positive and total test counts.
• Analyze the impact of reporting delays and data corrections on historical testing metrics.
• Monitor cumulative testing outcomes using the added cumulative test count columns.

Strengths

• Includes daily counts of positive, negative, and indeterminate test results.
• Data is de-duplicated by individual and date to avoid overcounting.
• Update process includes a daily automatic refresh and a redundant run for reliability.
• A documented change log shows ongoing data corrections and improvements.

Limitations

• Column-level documentation is absent; field semantics must be inferred after download.
• Row count is unknown, which may limit suitability assessment.
• Description notes a reporting delay due to variation in test completion times across labs.

Provenance

Source

City of San Francisco

Collection Method

Based on electronic laboratory test reports from commercial, clinical, hospital, and public health labs, with deduplication and verification processes.

Freshness

Updated automatically daily at 05:00 Pacific Time.

Geography

San Francisco, California, USA