| Title: | The Covid19 San Francisco Dataset |
|---|---|
| Description: | Provides a verity of summary tables of the Covid19 cases in San Francisco. Data source: San Francisco, Department of Public Health - Population Health Division <https://datasf.org/opendata/>. |
| Authors: | Rami Krispin [aut, cre] |
| Maintainer: | Rami Krispin <[email protected]> |
| License: | MIT + file LICENSE |
| Version: | 0.1.2 |
| Built: | 2024-10-10 06:02:16 UTC |
| Source: | https://github.com/RamiKrispin/covid19sf |
Medical provider confirmed COVID-19 cases and confirmed COVID-19 related deaths in San Francisco, CA aggregated by several different geographic areas and normalized by 2018 American Community Survey (ACS) 5-year estimates for population data to calculate rate per 10,000 residents. More information about the data available here
covid19sf_geocovid19sf_geo
An object class sf and data.frame with 8 variables.
Area type, c("ZCTA", "Analysis Neighborhood", "Census Tract", "Citywide")
area id
The count of cases in the area
The rate of cases in the area, calculated as (count/acs_population) * 10000 which is a rate per 10,000 residents
The number of cases in the area
The population from the latest 5-year estimates from the American Community Survey (2014-2018))
Last update of the data in POSIXc format)
The area polygon data)
The dataset contains a summary of covid19 cases in San Francisco by geographic area
San Francisco, Department of Public Health - Population Health Division through San Francisco Opne Data protal website.
data(covid19sf_geo) head(covid19sf_geo) library(sf) # Ploting SF Covid19 counts using base plot function plot(covid19sf_geo[which(covid19sf_geo$area_type == "Census Tract"), c("rate", "geometry")], main = "Covid19 Cases Rate per 10,000 by Census Tract")data(covid19sf_geo) head(covid19sf_geo) library(sf) # Ploting SF Covid19 counts using base plot function plot(covid19sf_geo[which(covid19sf_geo$area_type == "Census Tract"), c("rate", "geometry")], main = "Covid19 Cases Rate per 10,000 by Census Tract")
Data on daily hospital bed use and available capacity at San Francisco acute care hospitals from April 2020 onward. Long Term Care facilities (like Laguna Honda and Kentfield) are not included in this data as acute care patients cannot be admitted to these facilities. More information about the data available here
covid19sf_hospitalcovid19sf_hospital
An object class data.frame with 5 variables
The hospital name, currently a single categorical variable, c("All SF Acute Hospitals")
Date which the data was recorded in YYYY-MM-DD format
The bed type, c("Intensive Care Surge", "Acute Care", "Acute Care Surge", "Intensive Care")
The bed category status, c("Available", "COVID-19 (Confirmed & Suspected)", "Other Patients")
The bed count
The dataset contains a summary of San Francisco hospital bed status
San Francisco, Department of Public Health - Population Health Division through San Francisco Opne Data protal website.
data(covid19sf_hospital) head(covid19sf_hospital)data(covid19sf_hospital) head(covid19sf_hospital)
Count of COVID+ patients admitted to the hospital. Patients who are hospitalized and test positive for COVID-19 may be admitted to an acute care bed (a regular hospital bed), or an intensive care unit (ICU) bed. This data shows the daily total count of COVID+ patients in these two bed types, and the data reflects totals from all San Francisco Hospitals. More information about the data available here
covid19sf_hospitalizationscovid19sf_hospitalizations
An object class data.frame with 5 variables
date which case was recorded in YYYY-MM-DD format.
The hospital which patients were admitted, currently it labeled under "All SF Hospitals"
The type of hospitalization bed, either an acute care bed (a regular hospital bed), or an intensive care unit (ICU) bed
The patient diagnostic, either PUI (Patient Under Investigation) or COVID+ (positive case)
Daily cases count
Each record represents how many people were hospitalized on the date recorded in either an ICU bed or acute care bed (shown as Med/Surg under DPHCategory field)
San Francisco, Department of Public Health - Population Health Division through San Francisco Opne Data protal website.
data(covid19sf_hospitalizations) head(covid19sf_hospitalizations)data(covid19sf_hospitalizations) head(covid19sf_hospitalizations)
This dataset includes aggregate data on the type, status, population served, and individuals placed at each alternative housing site under contract with HSA. More information about the data available here
covid19sf_housingcovid19sf_housing
An object class data.frame with 8 variables
Site ID
The site status, c("Active", "In Preparation")
The facility type, c("Hotel", "Safe Sleep", "Congregate", "RV")
The site type, c(""SIP: COVID-Negative/Unknown", "I/Q", "SS: COVID-Negative/Unknown", "SIP: Post-COVID")
Number of units occupied per site
Total number of units available
The population covid status, c("COVID Negative/Unknown", "COVID Positive", "Post-COVID")
Date which data was updated in YYYY-MM-DD format)
The dataset contains a summary of covid19 housing site in San Francisco by site, facility and covid19 status
San Francisco, Department of Public Health - Population Health Division through San Francisco Opne Data protal website.
data(covid19sf_housing) head(covid19sf_housing)data(covid19sf_housing) head(covid19sf_housing)
TThis dataset shows San Francisco COVID-19 cases by population characteristics and by specimen collection date. Cases are included on the date the positive test was collected. Population characteristics are subgroups, or demographic cross-sections, like age, race, or gender. The City tracks how cases have been distributed among different subgroups. This information can reveal trends and disparities among groups. Data is lagged by five days, meaning the most recent specimen collection date included is 5 days prior to today. Tests take time to process and report, so more recent data is less reliable. More details available here
covid19sf_populationcovid19sf_population
An object class data.frame with 7 variables
Date which case was recorded in YYYY-MM-DD format.
Overall topic area for a given population characteristic. These are subgroups or demographic cross-sections, like age
Each group or category within a characteristic type or topic area. ex 0-4 yrs, 5-10 yrs
Sort order of characteristic group to aid in visualizing data
Cases are counted as confirmed on the date of specimen collection after a positive lab test result
Cumulative Cases
Population estimate for a given characteristic type and characteristic group
The dataset contains a summary of COVID-19 cases overtime by population characteristics
San Francisco, Department of Public Health - Population Health Division through San Francisco Opne Data protal website.
data(covid19sf_population) head(covid19sf_population)data(covid19sf_population) head(covid19sf_population)
The function enables to keep the package datasets with most recent data available on the package main repository. The main repository is refreshed on a daily basis.
covid19sf_refresh(force = FALSE)covid19sf_refresh(force = FALSE)
force |
A boolean, if set to TRUE will update the package if new data is available automatically |
A list of testing locations including address and coordinates for mapping. More information about the data available here
covid19sf_test_loccovid19sf_test_loc
An object class sf and data.frame with 17 variables
Location ID
Medical home
The medical name
The medical address
The medical phone number
The medical phone number formatted
The medical testing hours
The medical testing type, c("Permanent", "Pop-Up" )
The medical location type, c("Private", "Public" )
Eligibility information for accessing testing at this location
The call to action used for the web map
The call to action link for the button on the web map
The method for collecting samples at the lab
The lab name
The medical latitude point
The medical longitude point
The medical geometry details
The dataset contains the San Francisco testing location information
San Francisco, Department of Public Health - Population Health Division through San Francisco Opne Data protal website.
Case information on COVID-19 Laboratory testing. This data includes a daily count of test results reported, and how many of those were positive, negative, and indeterminate. Reported tests include tests with a positive, negative or indeterminate result. Indeterminate results, which could not conclusively determine whether COVID-19 virus was present, are not included in the calculation of percent positive. Testing for the novel coronavirus is available through commercial, clinical, and hospital laboratories, as well as the SFDPH Public Health Laboratory. More information about the data available here
covid19sf_testscovid19sf_tests
An object class data.frame with 6 variables
date which case was recorded in YYYY-MM-DD format.
Daily tests count
Number of positive cases
Percentage of positive cases
Number of negative cases
Number of indeterminate cases
A daily COVID-19 testing results report
San Francisco, Department of Public Health - Population Health Division through San Francisco Opne Data protal website.
data(covid19sf_tests) head(covid19sf_tests)data(covid19sf_tests) head(covid19sf_tests)
This dataset represents doses of COVID-19 vaccine administered in California to residents of San Francisco. The data is broken down by multiple demographic slices. The three dose types are counted separately, i.e. (1) first doses administered as a part of a two-dose vaccination, (2) second doses administered as part of a two-dose vaccination, and (3) single-dose vaccines administered. here
NOTE: This dataset is no longer supported and will be deprecated on the next release (v0.1.3). The covid19sf_population dataset is an alternative for covid19sf_vaccine_demo.
covid19sf_vaccine_democovid19sf_vaccine_demo
An object class data.frame with 15 variables
Segment (universe) of analysis. Unique combination of administering_provider_type, age_group, and demographic_group. Filter to a single option to derive meaningful totals.
Providers included in a given overall_segment. Two possible values: 'All' (including SF DPH) or 'DPH Only'
Age range included in a given overall_segment
Type of demographic group included in a given overall_segment (e.g. Age, Race/Ethnicity)
Specific demographic group counted in a given record (e.g. 16-24, Asian)
Numeric sort order for all demographic_subgroups. Convenient for maintaining consistent ordering across multiple data visualizations.
Total number of first doses administered
Total number of second doses administered
Total number of single dose vaccines administered
Total number of unique vaccine recipients
Total number of individuals fully vaccinated (those having received the second dose of a two-dose vaccine or one dose of a single-dose vaccine)
2018 5-year American Community Survey population estimates for given DEMOGRAPHIC_SUBGROUP
2018 5-year American Community Survey population estimates for overall AGE_GROUP
Timestamp for last update date in source system
Timestamp when the record (row) was most recently updated in Socrata
The dataset contains a summary of COVID-19 vaccine doses given to San Franciscans by demographics
San Francisco, Department of Public Health - Population Health Division through San Francisco Opne Data protal website.
data(covid19sf_vaccine_demo) head(covid19sf_vaccine_demo)data(covid19sf_vaccine_demo) head(covid19sf_vaccine_demo)
This dataset represents doses of COVID-19 vaccine administered in California to San Francisco residents over time. The data is broken down by multiple demographic slices. The three dose types are counted separately, i.e. (1) first doses administered as a part of a two-dose vaccination, (2) second doses administered as part of a two-dose vaccination, and (3) single-dose vaccines administered. here
covid19sf_vaccine_demo_tscovid19sf_vaccine_demo_ts
An object class data.frame with 19 variables
Date vaccination administered
Segment (universe) of analysis. Unique combination of administering_provider_type, age_group, and demographic_group. Filter to a single option to derive meaningful totals.
Providers included in a given overall_segment. Two possible values: 'All' (including SF DPH) or 'DPH Only'
Age range included in a given overall_segment
Type of demographic group included in a given overall_segment (e.g. Age, Race/Ethnicity)
Specific demographic group counted in a given record (e.g. 16-24, Asian)
Numeric sort order for all demographic_subgroup. Convenient for maintaining consistent ordering across multiple data visualizations.
Count of 1st doses administered for vaccines that take two doses to complete
Count of 2nd doses administered for vaccines that take two doses to complete
Count of doses administered for vaccines that take one dose to complete
Count of individuals newly fully vaccinated on a given day (given the 2nd dose of a two-dose vaccine or one dose of a single dose vaccine)
Count of individuals vaccinated (with any dose) for the first time according to CA's records
Cumulative total of 1st doses administered for vaccines that take two doses to complete
Cumulative total of 2nd doses administered for vaccines that take two doses to complete
Cumulative total of doses administered for vaccines that take one dose to complete
Cumulative total individuals fully vaccinated (given the 2nd dose of a two-dose vaccine or one dose of a single dose vaccine)
Cumulative total individuals vaccinated (with any dose) according to CA's records
American Community Survey population estimates for given demographic_subgroup
American Community Survey population estimates for overall age_group
The dataset contains a time series of COVID-19 vaccine doses given to San Franciscans by demographics
San Francisco, Department of Public Health - Population Health Division through San Francisco Opne Data protal website.
data(covid19sf_vaccine_demo_ts) head(covid19sf_vaccine_demo_ts)data(covid19sf_vaccine_demo_ts) head(covid19sf_vaccine_demo_ts)
This dataset represents the COVID-19 vaccinations given to SF residents summarized by the geographic region of their residential address. All vaccines given to SF residents are included, no matter where the vaccination took place (the vaccine may have been administered in San Francisco or outside of San Francisco). Data provides counts for people who have received at least one dose and people who have completed a vaccine series. A vaccine series is complete after an individual has received both doses of a two-dose vaccine or one dose of a one-dose vaccine. More information about the data available here
covid19sf_vaccine_geocovid19sf_vaccine_geo
An object class sf and data.frame with 8 variables.
area id
Area type, c("Analysis Neighborhood", "Summary")
Count of residents in the given geographic region who has received at least one dose administered by DPH
Count of residents in the given geographic region who has received at least one dose regardless of who administered the vaccine
Count of residents in the given geographic region who has completed a vaccine series
2019 5-year American Community Survey population estimate for the given geographic region (all ages)
The total count of population that has completed a vaccine series by population estimate (acs_population)
Last update of the data in POSIXc format)
The area polygon data)
The dataset contains a summary of covid19 vaccination in San Francisco by neighborhood
San Francisco, Department of Public Health - Population Health Division through San Francisco Opne Data protal website.
data(covid19sf_vaccine_geo) head(covid19sf_vaccine_geo) library(sf) library(dplyr) df <- covid19sf_vaccine_geo %>% filter(area_type == "Analysis Neighborhood") plot(df[, c("percent_pop_series_completed", "geometry")], main = "San Francisco - Percentage of Fully Vaccinated Population")data(covid19sf_vaccine_geo) head(covid19sf_vaccine_geo) library(sf) library(dplyr) df <- covid19sf_vaccine_geo %>% filter(area_type == "Analysis Neighborhood") plot(df[, c("percent_pop_series_completed", "geometry")], main = "San Francisco - Percentage of Fully Vaccinated Population")