9 Results
filtered by...
Filter
Tags > covid
Sort
Sort by Most Relevant
Filter
Categories
- COVID-19
- City Infrastructure
- City Management and Ethics
- Culture and Recreation
- Economy and Community
- Energy and Environment
- Geographic Locations and Boundaries
- Health and Social Services
- Housing and Buildings
- Public Safety
- Transportation
Publishing Department
- 311
- Airport (SFO)
- Arts Commission
- Assessor-Recorder
- Board of Supervisors
- Building Inspection
- Citizen Complaints
- City College
- Community Investment and Infrastructure
- Controller
- Economic & Workforce Development
- Elections
- Environment
- Ethics Commission
- Film Commission
- Fire Department
- GSA - City Administrator's Office
- Health Service System
- Human Resources
- Human Rights Commission
- Human Services Agency
- Mayor
- Municipal Transportation Agency
- Other
- Planning
- Police Department
- Port
- Public Health
- Public Utilities Commission
- Public Works
- Recreation and Parks
- Rent Arbitration Board
- Technology
- Treasurer-Tax Collector
- Academy of Sciences
- Adult Probation
- Asian Art Museum
- Board of Appeals
- Child Support Services
- Children and Families Commission
- Children, Youth & Their Families
- City Attorney
- Civil Service Commission
- District Attorney
- Early Care and Education
- Emergency Management
- Fine Arts Museums
- Juvenile Probation
- Law Library
- Public Defender
- Public Library
- Retirement System
- School District (SFUSD)
- Sheriff
- Status of Women
- Superior Court
- War Memorial
Tags
- covid
- 'bicycle counts
- 100-year storm flood risk zone
- 1906
- 3d
- 461
- 465
- 496
- 497
- @sfclimatehealth
- @sfclimatehealth.org
- absent heirs
- abuse prevention
- acceptance
- accepted
- accessible parking
- acs
- activity
- actors
- acute
- air carrier
- all
- annual rent increase
- aquatics
- article 10
- artists
- arts
- arts commission
- arts funding
- arts organizations
- aviation
- award
- ballot measure
- banner
- bathroom
- bayview
- beats
- benchmark
- benchmarking
- bicycle
- bicycle corrals
- bicycle counter
- bicycle loop counter
- bicycle parking
- bicycle racks
- bicycles
- bike cages
- bike corrals
- bike counter
- bike loop
- bike parking
- bike racks
- bike volume'
- bikes
- block
- blockface
- blocks
- blue zones
- bmr
- board
- bond issuances
- build
- bureau
- bus
- bus stop
- buyouts
- c-3
- cable car
- cable car stops
- cad
- cadastral
- call center
- calls for service
- caltrans
- campaign finance dashboards 2016
- canopy
- capital assets
- capital program
- car share
- cars
- carshare
- catalog
- catch basin
- catchment basin
- cellphone
- centerlines
- certified
- chairs
- children
- chinatown
- city facilities
- citylots
- civic art
- cleaning
- clearance heights
- clients
- climate
- closures
- cnns
- coast
- code
- coi
- collisions
- color curb
- colored curb
- comet
- commission
- committee
- commodity
- community resiliency system
- communitywide
- compensation
- condo
- condominium
- condos
- congestion
- congress
- conservation
- contracts
- controller
- conversion
- corrals
- cross street
- crossing guard
- crossing guards
- cultural center
- cultural centers
- cultural recreation
- culture
- current planning
- current zoning
- data
- data dictionary
- daylighting
- design
- designated employee
- directors
- display
- districts
- downtown
- downtown plan
- drawings
- earthquake
- education
- elevation
- employee
- encampment
- enforcement
- engine runs
- equity
- equity strategy
- equity strategy neighborhoods
- estimated cost
- estoppel notices
- ethnicity
- event
- eviction
- excelsior-outer mission
- exhibit
- exhibition
- expenditure lobbyist registration
- expenditure lobbyist registration lobbying disclosure reports
- expenses
- feature
- federal
- fees
- field definitions
- file geodatabase
- filing
- film
- fines
- fire station
- flight
- flights
- flood
- flu
- food truck
- footprints
- fuel
- gallery
- garages
- geography
- ghg inventory
- gov code 6270.5
- government performance
- government permit
- grant funding
- green
- green building
- green connections
- handwashing
- hayward earthquake scenario
- hdmt
- health assessment
- health impacts
- healthy development measurement tool
- highway
- historical
- history
- homeless
- homeless count
- homelessness
- hospital
- hospital beds
- hospital capacity
- icu
- in
- inclusion
- industrial
- influenza
- inner mission
- interesection
- intersections
- jobs
- key
- lagan
- land
- land use
- landings
- landmark
- landslide hazard zone
- landuse
- lanes
- language
- language access
- lao
- large
- late
- late fees
- leed
- library
- limited no parking
- liquefaction hazard zones
- liquefaction susceptibility
- livable streets
- lives
- lobbying
- lobbying disclosure reports
- lobbyist training
- locations
- loop counter
- lottery
- low income neighborhoods
- lrv
- lrv stops
- maintenance
- manifold
- maps
- mechanical
- medical
- medical cannabis dispensaries
- member
- metadata
- meter
- metrics
- metro
- micorclimate
- miles
- mobile food facility
- moratorium
- moto
- motor vehicles
- motorcycle parking
- motorcycles
- movies
- mph
- mpx
- multimodal
- muni forward
- muni service equity strategy
- municipal
- museum
- names
- narrow
- navigation
- no overnight parking
- no parking any time
- non-responsive
- notification
- nr
- occupancy
- ocii
- off street
- office
- officials
- on street car share
- on street car share pilot
- on street parking
- on-street
- onstreet
- open
- open data program
- open space
- order
- overpass
- oversized vehicles
- painted safety zone
- painted safety zones
- park maintenance
- park scores
- parking census
- parking control office beats
- parking district
- parking management district
- parking regulations
- parking space inventory
- parking supply
- parklet
- parks
- passengers
- patron
- pavement
- payment
- pdr
- photos
- phytocenosis
- phytocoenosis
- pim
- pit stop
- pitstop
- plant community
- plants
- pmd
- police
- police station
- policing
- posting
- pot clubs
- preparedness
- presidio
- presidio trust
- prime contractor
- priority
- probability
- procurement contract
- project
- project team
- prop c
- property tax
- property value
- propositions
- psi
- psz
- public bathroom
- public complaints
- public lines
- publishing plans
- race
- race/ethnicity
- racks
- rail
- rail stops
- rec and park
- recovery
- recreation
- recreation class
- recreation program
- red carpet
- red lanes
- regression model
- rehab
- removal
- rent increase
- reservoir inundation hazard zones
- residential parking permit
- residential permits
- resilience
- resiliency
- restaurant scores
- restroom
- retail
- retirement
- revenue
- ridership
- right of way
- roads
- roofs
- roundabout
- routes
- row
- rush hour
- rush hour routes
- safe sleeping
- safety
- salaries
- salary
- san andreas scenario
- san francisco arts commission
- san francisco climate action strategy
- san francisco climate and health program
- san francisco indicator project
- san francisco's climate & health program
- sanitary scores
- sb 272
- sb272
- school
- schools
- sci
- section 415
- segment
- service
- sf plant finder
- sfac
- sfarts
- sfplanning
- shelter
- shuttles
- side of street
- sidewalk widths
- sidewalks
- sign
- signage
- sink
- slopes
- slr
- sourcing
- special events
- speed
- speed limit
- speed limits
- ssd
- statistics
- stop attributes
- stop features
- stop location
- stop signs
- stops
- storm drain
- stormwater
- street evaluation
- street intersections
- street-use
- subcontractor
- supervisor
- supervisor district
- supplier
- surge
- sustainable communities index
- sweeping
- systems
- tableau
- tables
- tails
- taxi
- technology
- telecommunication
- temp bulb
- temporary
- temporary bulbout
- temporary tow zones
- tent
- tent count
- test
- testing by neighborhood
- therapeutic recreation
- time limits
- title vi
- tl
- toilet
- topography
- traffic
- traffic calming
- traffic circle
- traffic control
- traffic island
- transit access
- transit lines
- transit network
- transit only lanes
- truck routes
- tsunami
- type
- underpass
- unit
- units
- unmetered motorcycle parking
- unmetered parking
- unpaid
- utility usage
- valuation
- vehicle restrictions
- vistacion valley
- vmt
- volume
- voucher
- vulnerability
- water
- water fountain
- water spigot
- western addition
- width
- works
- wzdx
- year built
- zip
- zones
- zoning districts
- zoning map
- 2013
- 803
- 911
- access
- ada
- addresses
- allcnnsinorder
- analytics
- annual dataset
- appointments
- artist
- artworks
- assessor
- bart
- benefits
- bicycle progression
- bicycle signal
- bicycle signal timing
- bicycle timing
- bid
- bike
- blockfaces
- boundary
- budget
- building safety
- carbon emissions
- cares act
- cash
- cell
- census block
- census block group
- census tract
- ceqa
- charitable
- child development centers
- city departments
- citywide performance measurement
- client
- code violations
- coit
- committee on information technology
- community college
- community resiliency
- compensated advocacy ban
- complaints
- condition
- consultant
- contract
- contribution
- controller's street evaluation program
- covid19 testing
- crime reports
- dataset monitoring
- dbi
- disability
- drone policy
- drones
- eas
- emergency calls
- employees
- envista
- ethics enforcement complaints sunshine
- evaluation
- eviction notices
- exceptions
- expenditures
- fsr
- gifts
- graffiti
- grants
- green waves
- grime
- growth
- incidents
- inclusionary housing
- index
- information
- inspections
- issues
- jurisdiction
- lab testing
- leaks
- litter
- local officeholders
- lots
- mapping
- mast
- mff
- monkeypox
- municipal transportation agency
- node
- noi
- november 4
- november 5
- open data
- pandemic unemployment insurance
- parcel
- park
- pci
- plant
- plantfinder
- police department
- popos
- post-employment restriction waivers
- precincts
- private schools
- procurement
- property
- pua
- public art
- public facilities
- public health
- public office
- public schools
- public works
- purchase order
- purchasing
- ramps
- re-registration
- ref:inventory
- registered
- registration
- results
- retaining
- right
- roadway
- rpp
- rsis
- runway
- runways
- score
- scorecards
- screening checkpoint
- sea level rise
- services
- sfclimatehealth.org
- sfgov
- sfpd
- signs
- smf
- spills
- stairs
- stairway
- street sweeping
- structure
- surface mounted
- surface mounted facility
- sustainability
- system
- tenderloin
- tenderloin-soma
- testing
- tow
- tower
- traffic crashes
- transportation projects
- trash
- truck
- trucks
- uas
- uav
- ui
- unemployment
- unemployment insurance
- use
- utility consumption
- verification
- violations
- vision zero
- voting
- waivers
- wall
- way
- web
- wireless
- zip code
- antenna
- art
- avl
- behested
- boundaries
- city employees
- crime
- curb
- demographics
- employment
- energy
- environment
- fire inspections
- fire safety
- five
- fte
- gps
- greenhouse gas emissions
- inspection
- inventory
- loans
- mode share
- mounted
- november 4 2014
- of
- parcels
- phes
- phone
- planning pipeline housing construction permits development residential commercial building
- protected status
- restrictions
- satisfaction survey
- schedule
- sfo ground transportation
- sfphes
- staffing
- sub-vendors
- surface
- tnc
- tree
- utility
- vaccines
- vendors
- affordable housing
- aircraft
- amount
- base
- biking
- buildings
- business
- campaign consultants
- campaign finance dashboard 2015
- department of public health
- food
- intersection
- meters
- mohcd
- monetary
- muni
- noise
- november 6
- november 6 2012
- political
- promised
- real estate
- received
- sfpark
- space
- taxis
- travel
- vendor
- 2011
- 5
- airlines
- bicycling
- campaign finance dashboard 2016
- climate change
- cnn
- district
- dph
- elections
- environmental health
- fire
- mayor
- mobile
- performance
- ref:basemap
- rent control
- sfdph
- year
- bulk
- driving
- excavation
- geologic
- height
- map
- neighborhoods
- sidewalk
- spending
- summary
- trees
- utilities
- basemap
- city reference data
- historic
- non-filer
- open book
- openbook
- plan
- preservation
- san francisco
- sfopenbook
- sud
- vaccination
- walking
- ceiling
- paving
- schedules
- voluntary
- census
- construction permits
- covid-19
- hcr
- sfmta
- transportation
- form
- payments
- streets
- transit
- 460
- contributions
- lobbyist
- dashboards
- individual expenditure ceilings
- campaign consultant
- customer
- fppc
- street
- conflict of interest
- parking
- statement of economic interests
- vec
- ceilings
- financing
- individual
- sei
- voluntary expenditure ceiling
- form 700
- survey
- airport
- 2014
- case
- customer service
- permit
- 311
- calls
- 2012
- cases
- sfo
- building
- expenditure
- iec
- candidate
- gis
- disbursed
- funds
- third-party
- zoning
- disclosure
- residential
- shapefile
- pipeline
- public financing
- november
- commercial
- housing
- construction
- public
- development
- permits
- campaign finance
- public buildings
- facility
- candidates
- finance
- campaign
- planning
- election
- ethics
9 Results
filtered by
Tags > covid
Clear All
Note: On 1/31/2023 we will be updating our data to reflect the 2020 Census Bureau American Community Survey (ACS) San Francisco Population estimates.
Note: On 1/31/2023 we will rename the column "last_updated_at" to "data_as_of".
Note: On January 22, 2022, system updates to improve the timeliness and accuracy of San Francisco COVID-19 cases and deaths data were implemented. You might see some fluctuations in historic data as a result of this change. Due to the changes, starting on January 22, 2022, the number of new cases reported daily will be higher than under the old system as cases that would have taken longer to process will be reported earlier.
Note: On September 12, 2021, a new case definition of COVID-19 was introduced that includes criteria for enumerating new infections after previous probable or confirmed infections (also known as reinfections). A reinfection is defined as a confirmed positive PCR lab test more than 90 days after a positive PCR or antigen test. The first reinfection case was identified on December 7, 2021. Some fluctuation in historic data may result when this change is implemented on July 15, 2022.
A. SUMMARY
This dataset represents San Francisco COVID-19 positive confirmed cases by vaccination status over time, starting January 1, 2021. Cases are included on the date the positive test was collected (the specimen collection date). Cases are counted in four categories: (1) all cases; (2) unvaccinated cases; (3) partially vaccinated cases; and (4) fully vaccinated cases.
This dataset represents San Francisco COVID-19 positive confirmed cases by vaccination status over time, starting January 1, 2021. Cases are included on the date the positive test was collected (the specimen collection date). Cases are counted in four categories: (1) all cases; (2) unvaccinated cases; (3) partially vaccinated cases; and (4) fully vaccinated cases.
1. All cases: Includes cases among all San Francisco residents regardless of vaccination status.
2. Unvaccinated cases: Cases are considered unvaccinated if their positive COVID-19 test was before receiving any vaccine. Cases that are not matched to a COVID-19 vaccination record are considered unvaccinated.
3. Partially vaccinated cases: Cases are considered partially vaccinated if their positive COVID-19 test was after they received at least one dose of a COVID-19 vaccine, but their positive test had been fewer than 14 days since the final dose in their vaccine series. Individuals who have only received one dose of a two-dose vaccine on the date of the positive test are also considered partially vaccinated.
4. Fully vaccinated cases: Cases are considered fully vaccinated if their positive COVID-19 test was 14 days or more after they received their 2nd dose in a 2-dose COVID-19 series or the single dose of a 1-dose vaccine. These are also called “breakthrough cases.”
Data is lagged by eight days, meaning the most recent specimen collection date included is eight days prior to today. All data updates daily as more information becomes available.
B. HOW THE DATASET IS CREATED
Case information is based on confirmed positive laboratory tests reported to the City. The City then completes quality assurance and other data verification processes. Vaccination data comes from the California Immunization Registry (CAIR2). The California Department of Public Health runs CAIR2. Individual-level case and vaccination data are matched to identify cases by vaccination status in this dataset. Case records are matched to vaccine records using first name, last name, date of birth, phone number, and email address.
Case information is based on confirmed positive laboratory tests reported to the City. The City then completes quality assurance and other data verification processes. Vaccination data comes from the California Immunization Registry (CAIR2). The California Department of Public Health runs CAIR2. Individual-level case and vaccination data are matched to identify cases by vaccination status in this dataset. Case records are matched to vaccine records using first name, last name, date of birth, phone number, and email address.
We include vaccination records from all nine Bay Area counties in order to improve matching rates. This allows us to identify breakthrough cases among people who moved to the City from other Bay Area counties after completing their vaccine series. Only cases among San Francisco residents are included.
C. UPDATE PROCESS
Updates automatically at 08:00 AM Pacific Time each day.
Updates automatically at 08:00 AM Pacific Time each day.
D. HOW TO USE THIS DATASET
The dataset includes new cases, 7-day average new cases, new case rates, 7-day average new case rates, percent of total cases, and 7-day average percent of total cases for each vaccination category.
The dataset includes new cases, 7-day average new cases, new case rates, 7-day average new case rates, percent of total cases, and 7-day average percent of total cases for each vaccination category.
New cases are the coun
Updated
January 26 2023
Views
2,560
Dataset
Note: As of July 21, 2021, this dataset no longer updates.
A. SUMMARY
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.
B. HOW THE DATASET IS CREATED
This hospital capacity information is based on data that all SF acute care hospitals report to the San Francisco Department of Public Health.
C. UPDATE PROCESS
Updates automatically at 05:00 Pacific Time each day. Redundant runs are scheduled at 07:00 and 09:00 in case of pipeline failure. This data is on a 4-day lag to account for the time needed to complete and validate data from all SF acute care hospitals.
D. HOW TO USE THIS DATASET
This data provides visibility into current occupancy levels and use of San Francisco acute care hospitals and potential ability to accommodate anticipated surges of COVID patients.
Data includes current census of COVID-19 patients (including both confirmed cases and suspected COVID patients) and other patients in acute care hospitals, shown in the “Status” column. The “Status” column also includes all available beds.
This daily census information is stratified by type of bed (acute care, intensive care, and surge) in the “Bed Type” column. Acute care beds treat patients with illnesses and injuries including recovery from surgeries. Intensive care (ICU) beds are for sicker patients in need of critical and life support services that can include the use of a ventilator. Surge beds are the additional beds that can be made available to handle an influx of COVID-19 patients; surge beds are differentiated between acute care surge beds and ICU surge beds.
Note: The current census of COVID patients shown here may not always match the hospitalizations data (https://data.sfgov.org/COVID-19/COVID-19-Hospitalizations/nxjg-bhem), as that data includes all hospitals and long term care facilities. As described above, those long term care facilities are not included here as they don’t have the capacity to take in additional acute care patients and therefore aren’t included in capacity measures.
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.
B. HOW THE DATASET IS CREATED
This hospital capacity information is based on data that all SF acute care hospitals report to the San Francisco Department of Public Health.
C. UPDATE PROCESS
Updates automatically at 05:00 Pacific Time each day. Redundant runs are scheduled at 07:00 and 09:00 in case of pipeline failure. This data is on a 4-day lag to account for the time needed to complete and validate data from all SF acute care hospitals.
D. HOW TO USE THIS DATASET
This data provides visibility into current occupancy levels and use of San Francisco acute care hospitals and potential ability to accommodate anticipated surges of COVID patients.
Data includes current census of COVID-19 patients (including both confirmed cases and suspected COVID patients) and other patients in acute care hospitals, shown in the “Status” column. The “Status” column also includes all available beds.
This daily census information is stratified by type of bed (acute care, intensive care, and surge) in the “Bed Type” column. Acute care beds treat patients with illnesses and injuries including recovery from surgeries. Intensive care (ICU) beds are for sicker patients in need of critical and life support services that can include the use of a ventilator. Surge beds are the additional beds that can be made available to handle an influx of COVID-19 patients; surge beds are differentiated between acute care surge beds and ICU surge beds.
Note: The current census of COVID patients shown here may not always match the hospitalizations data (https://data.sfgov.org/COVID-19/COVID-19-Hospitalizations/nxjg-bhem), as that data includes all hospitals and long term care facilities. As described above, those long term care facilities are not included here as they don’t have the capacity to take in additional acute care patients and therefore aren’t included in capacity measures.
Updated
July 22 2021
Views
10,655
Note: On 1/31/2023 we will be updating our data to reflect the 2020 Census Bureau American Community Survey (ACS) San Francisco Population estimates.
Note: On 1/31/2023 we will also make the following changes:
Note: On January 22, 2022, system updates to improve the timeliness and accuracy of San Francisco COVID-19 cases and deaths data were implemented. You might see some fluctuations in historic data as a result of this change. Due to the changes, starting on January 22, 2022, the number of new cases reported daily will be higher than under the old system as cases that would have taken longer to process will be reported earlier.
- Rename the column "last_updated_at" to "data_as_of"
- Remove the "multipolygon" column
Note: On January 22, 2022, system updates to improve the timeliness and accuracy of San Francisco COVID-19 cases and deaths data were implemented. You might see some fluctuations in historic data as a result of this change. Due to the changes, starting on January 22, 2022, the number of new cases reported daily will be higher than under the old system as cases that would have taken longer to process will be reported earlier.
Note: As of April 16, 2021, this dataset will update daily with a five-day data lag.
A. SUMMARY
This dataset contains COVID-19 positive confirmed cases aggregated by several different geographic areas and by day. COVID-19 cases are mapped to the residence of the individual and shown on the date the positive test was collected. In addition, 2019 American Community Survey (ACS) 5-year population estimates are included to calculate the cumulative rate per 10,000 residents.
This dataset contains COVID-19 positive confirmed cases aggregated by several different geographic areas and by day. COVID-19 cases are mapped to the residence of the individual and shown on the date the positive test was collected. In addition, 2019 American Community Survey (ACS) 5-year population estimates are included to calculate the cumulative rate per 10,000 residents.
Dataset covers cases going back to March 2nd, 2020 when testing began. This data may not be immediately available for recently reported cases and data will change to reflect as information becomes available. Data updated daily.
Geographic areas summarized are:
1. Analysis Neighborhoods
2. Census Tracts
3. Census Zip Code Tabulation Areas
1. Analysis Neighborhoods
2. Census Tracts
3. Census Zip Code Tabulation Areas
B. HOW THE DATASET IS CREATED
Addresses from the COVID-19 case data are geocoded by the San Francisco Department of Public Health (SFDPH). Those addresses are spatially joined to the geographic areas. Counts are generated based on the number of address points that match each geographic area for a given date.
Addresses from the COVID-19 case data are geocoded by the San Francisco Department of Public Health (SFDPH). Those addresses are spatially joined to the geographic areas. Counts are generated based on the number of address points that match each geographic area for a given date.
The 2019 ACS estimates for population provided by the Census are used to create a cumulative rate which is equal to ([cumulative count up to that date] / [acs_population]) * 10000) representing the number of total cases per 10,000 residents (as of the specified date).
COVID-19 case data undergo quality assurance and other data verification processes and are continually updated to maximize completeness and accuracy of information. This means data may change for previous days as information is updated.
C. UPDATE PROCESS
Geographic analysis is scripted by SFDPH staff and synced to this dataset daily at 05:00 Pacific Time.
Geographic analysis is scripted by SFDPH staff and synced to this dataset daily at 05:00 Pacific Time.
D. HOW TO USE THIS DATASET
This dataset can be used to track the spread of COVID-19 throughout the city, in a variety of geographic areas. Note that the new cases column in the data represents the number of new cases confirmed in a certain area on the specified day, while the cumulative cases column is the cumulative total of cases in a certain area as of the specified date.
This dataset can be used to track the spread of COVID-19 throughout the city, in a variety of geographic areas. Note that the new cases column in the data represents the number of new cases confirmed in a certain area on the specified day, while the cumulative cases column is the cumulative total of cases in a certain area as of the specified date.
Privacy rules in effect
To protect privacy, certain rules are in effect:
1. Any area with a cumulative case count less than 10 are dropped for all days the cumulative count was less than 10. These will be null values.
2. Once an area has a cumulative case count of 10 or greater, that area will have a new row of case data every day following.
3. Cases are dropped altogether for areas where acs_population < 1000
4. Deaths data are not included in this dataset for privacy reasons. The low COVID-19 death rate in San Francisco, along with other publicly available information on deaths, means that deaths data by geography and day is too granular and potentially risky.
To protect privacy, certain rules are in effect:
1. Any area with a cumulative case count less than 10 are dropped for all days the cumulative count was less than 10. These will be null values.
2. Once an area has a cumulative case count of 10 or greater, that area will have a new row of case data every day following.
3. Cases are dropped altogether for areas where acs_population < 1000
4. Deaths data are not included in this dataset for privacy reasons. The low COVID-19 death rate in San Francisco, along with other publicly available information on deaths, means that deaths data by geography and day is too granular and potentially risky.
Updated
January 26 2023
Views
10,669
Note: On 1/31/2023 we will be updating our data to reflect the 2020 Census Bureau American Community Survey (ACS) San Francisco Population estimates.
Note: On 1/31/2023 we will also make the following changes:
Note: As of April 16, 2021, this dataset will update daily with a five-day data lag.
- Rename the column "last_updated_at" to "data_as_of"
- Remove the "multipolygon" column
Note: As of April 16, 2021, this dataset will update daily with a five-day data lag.
A. SUMMARY
This dataset includes COVID-19 tests by resident neighborhood and specimen collection date (the day the test was collected). Specifically, this dataset includes tests of San Francisco residents who listed a San Francisco home address at the time of testing. These resident addresses were then geo-located and mapped to neighborhoods. The resident address associated with each test is hand-entered and susceptible to errors, therefore neighborhood data should be interpreted as an approximation, not a precise nor comprehensive total.
This dataset includes COVID-19 tests by resident neighborhood and specimen collection date (the day the test was collected). Specifically, this dataset includes tests of San Francisco residents who listed a San Francisco home address at the time of testing. These resident addresses were then geo-located and mapped to neighborhoods. The resident address associated with each test is hand-entered and susceptible to errors, therefore neighborhood data should be interpreted as an approximation, not a precise nor comprehensive total.
In recent months, about 5% of tests are missing addresses and therefore cannot be included in any neighborhood totals. In earlier months, more tests were missing address data. Because of this high percentage of tests missing resident address data, this neighborhood testing data for March, April, and May should be interpreted with caution (see below)
Percentage of tests missing address information, by month in 2020
Mar - 33.6%
Apr - 25.9%
May - 11.1%
Jun - 7.2%
Jul - 5.8%
Aug - 5.4%
Sep - 5.1%
Oct (Oct 1-12) - 5.1%
Mar - 33.6%
Apr - 25.9%
May - 11.1%
Jun - 7.2%
Jul - 5.8%
Aug - 5.4%
Sep - 5.1%
Oct (Oct 1-12) - 5.1%
To protect the privacy of residents, the City does not disclose the number of tests in neighborhoods with resident populations of fewer than 1,000 people. These neighborhoods are omitted from the data (they include Golden Gate Park, John McLaren Park, and Lands End).
Tests for residents that listed a Skilled Nursing Facility as their home address are not included in this neighborhood-level testing data. Skilled Nursing Facilities have required and repeated testing of residents, which would change neighborhood trends and not reflect the broader neighborhood's testing data.
This data was de-duplicated by individual and date, so if a person gets tested multiple times on different dates, all tests will be included in this dataset (on the day each test was collected).
The total number of positive test results is not equal to the total number of COVID-19 cases in San Francisco. During this investigation, some test results are found to be for persons living outside of San Francisco and some people in San Francisco may be tested multiple times (which is common). To see the number of new confirmed cases by neighborhood, reference this map: https://data.sfgov.org/stories/s/Map-of-Cumulative-Cases/adm5-wq8i#new-cases-map
B. HOW THE DATASET IS CREATED
COVID-19 laboratory test data is based on electronic laboratory test reports. Deduplication, quality assurance measures and other data verification processes maximize accuracy of laboratory test information. All testing data is then geo-coded by resident address. Then data is aggregated by analysis neighborhood and specimen collection date.
COVID-19 laboratory test data is based on electronic laboratory test reports. Deduplication, quality assurance measures and other data verification processes maximize accuracy of laboratory test information. All testing data is then geo-coded by resident address. Then data is aggregated by analysis neighborhood and specimen collection date.
Data are prepared by close of business Monday through Saturday for public display.
C. UPDATE PROCESS
Updates automatically at 05:00 Pacific Time each day. Redundant runs are scheduled at 07:00 and 09:00 in case of pipeline failure.
Updates automatically at 05:00 Pacific Time each day. Redundant runs are scheduled at 07:00 and 09:00 in case of pipeline failure.
D. HOW TO USE THIS DATASET
Due to the high degree of variation in the time needed to complete tests by different labs there is a delay in this reporting. On March 24 the Health Officer ordered all labs in the City to report complete COVID-19 testing information to the local and state health departments.
Due to the high degree of variation in the time needed to complete tests by different labs there is a delay in this reporting. On March 24 the Health Officer ordered all labs in the City to report complete COVID-19 testing information to the local and state health departments.
In order to track trends over time, a data user can analyze this data by "specimen_collection_date".
Calculating Percent Positivity: The pos
Updated
January 26 2023
Views
1,874
Note: On 1/31/2023 we will be updating our data to reflect the 2020 Census Bureau American Community Survey (ACS) San Francisco Population estimates.
Note: On 1/31/2023 we will rename the column "last_updated_at" to "data_as_of".
Note: On 1/31/2023 we will rename the column "last_updated_at" to "data_as_of".
Note: As of March 2022, the race/ethnicity label changed from Native American to American Indian or Alaska Native to align with the Census.
Note: As of February 2022, the way race/ethnicity is categorized has been changed. See Section B for additional information.
Note: As of April 16, 2021, this dataset will update daily with a five-day data lag.
A. SUMMARY
This dataset includes San Francisco COVID-19 tests by race/ethnicity and by date. This dataset represents the daily count of tests collected, and the breakdown of test results (positive, negative, or indeterminate). Tests in this dataset include all those collected from persons who listed San Francisco as their home address at the time of testing. It also includes tests that were collected by San Francisco providers for persons who were missing a locating address. This dataset does not include tests for residents listing a locating address outside of San Francisco, even if they were tested in San Francisco.
This dataset includes San Francisco COVID-19 tests by race/ethnicity and by date. This dataset represents the daily count of tests collected, and the breakdown of test results (positive, negative, or indeterminate). Tests in this dataset include all those collected from persons who listed San Francisco as their home address at the time of testing. It also includes tests that were collected by San Francisco providers for persons who were missing a locating address. This dataset does not include tests for residents listing a locating address outside of San Francisco, even if they were tested in San Francisco.
The data were de-duplicated by individual and date, so if a person gets tested multiple times on different dates, all tests will be included in this dataset (on the day each test was collected). If a person tested multiple times on the same date, only one test is included from that date. When there are multiple tests on the same date, a positive result, if one exists, will always be selected as the record for the person. If a PCR and antigen test are taken on the same day, the PCR test will supersede. If a person tests multiple times on the same day and the results are all the same (e.g. all negative or all positive) then the first test done is selected as the record for the person.
The total number of positive test results is not equal to the total number of COVID-19 cases in San Francisco. Each positive test result is investigated by the health department. While the city tries to only report on tests for San Francisco residents (or tests in San Francisco for those with no locating address listed), some test results purported to be for San Francisco residents are actually for people living outside the city. This can be discovered during a case investigation or data quality assurance. In such an instance, the test would be counted as a positive test in the SF data but would not be counted as a COVID-19 case in San Francisco. If a person tests positive for COVID-19 on different dates, they would be included each of those times in the testing data but only one case. To track the number of cases by race/ethnicity, see this dashboard:
https://sf.gov/data/covid-19-population-characteristics#race-or-ethnicity-
https://sf.gov/data/covid-19-population-characteristics#race-or-ethnicity-
When a person gets tested for COVID-19, they may be asked to report information about themselves. One piece of information that might be requested is a person's race and ethnicity. These data are often incomplete in the laboratory and provider reports of the test results sent to the health department. The data can be missing or incomplete for several possible reasons:
• The person was not asked about their race and ethnicity.
• The person was asked, but refused to answer.
• The person answered, but the testing provider did not include the person's answers in the reports.
• The testing provider reported the person's answers in a format that could not be used by the health department.
• The person was asked, but refused to answer.
• The person answered, but the testing provider did not include the person's answers in the reports.
• The testing provider reported the person's answers in a format that could not be used by the health department.
For any of these reasons, a person's race/ethnicity will be recorded in the dataset as “Unknown.”
B. NOTE ON RACE/ETHNICITY
The different values for Race/Ethnicity in this dataset are "Asian;" "Black or African American;" "Hispanic or Latino/a, all races;" "American Indian or Alaska Native;" "Native Hawaiian or Other Pacific Islander;" "White;" "Multi-racial;" "Ot
The different values for Race/Ethnicity in this dataset are "Asian;" "Black or African American;" "Hispanic or Latino/a, all races;" "American Indian or Alaska Native;" "Native Hawaiian or Other Pacific Islander;" "White;" "Multi-racial;" "Ot
Updated
January 26 2023
Views
1,622
Note: On 1/31/2023 we will be updating our data to reflect the 2020 Census Bureau American Community Survey (ACS) San Francisco Population estimates.
This new dataset, implemented on 10/27/2022, includes the following changes when compared to the previous iteration of this dataset:
- The columns "age_group" and "age_group_population" have been removed. To continue to access data by age eligibility groups, filter the dataset on "demographic_group" = ‘Age Group’. The column "overall_segment" has been altered to reflect this change.
A. SUMMARY
This dataset represents the COVID-19 vaccinations given to residents of San Francisco over time. 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). The data are broken down by multiple demographic stratifications. This dataset also includes COVID-19 vaccinations given to SF residents by the San Francisco Department of Public Health (SFDPH) over time.
This dataset represents the COVID-19 vaccinations given to residents of San Francisco over time. 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). The data are broken down by multiple demographic stratifications. This dataset also includes COVID-19 vaccinations given to SF residents by the San Francisco Department of Public Health (SFDPH) over time.
Data provides counts for residents who have received at least one dose, residents who have completed a primary vaccine series, residents who have received one or two monovalent (not bivalent) booster doses, and residents who have received a bivalent booster dose. A primary vaccine series is complete after an individual has received all intended doses of the initial series. There are one, two, and three dose primary vaccine series.
B. HOW THE DATASET IS CREATED
Information on doses administered to those who live in San Francisco is from the California Immunization Registry (CAIR2), run by the California Department of Public Health (CDPH). The information on individuals’ city of residence, age, race, and ethnicity are also recorded in CAIR and are self-reported at the time of vaccine administration.
B. HOW THE DATASET IS CREATED
Information on doses administered to those who live in San Francisco is from the California Immunization Registry (CAIR2), run by the California Department of Public Health (CDPH). The information on individuals’ city of residence, age, race, and ethnicity are also recorded in CAIR and are self-reported at the time of vaccine administration.
In order to estimate the percent of San Franciscans vaccinated, we provide the 2019 five-year American Community Survey population estimates for each demographic group.
C. UPDATE PROCESS
Updated daily via automated process
D. HOW TO USE THIS DATASET
Before analysis, you must filter the dataset to the desired stratification of data using the "overall_segment" column.
For example, filtering "overall_segment" to "All SF Residents by Age Bracket, Administered by All Providers" will filter the data to residents whose vaccinations were administered by any provider. You can then further segment the data and calculate percentages by Age Brackets.
If you filter "overall_segment" to "All SF Residents by Race/Ethnicity, Administered by DPH Only", you will see the race/ethnicity breakdown for residents who received vaccinations from the San Francisco Department of Public Health (SFDPH).
C. UPDATE PROCESS
Updated daily via automated process
D. HOW TO USE THIS DATASET
Before analysis, you must filter the dataset to the desired stratification of data using the "overall_segment" column.
For example, filtering "overall_segment" to "All SF Residents by Age Bracket, Administered by All Providers" will filter the data to residents whose vaccinations were administered by any provider. You can then further segment the data and calculate percentages by Age Brackets.
If you filter "overall_segment" to "All SF Residents by Race/Ethnicity, Administered by DPH Only", you will see the race/ethnicity breakdown for residents who received vaccinations from the San Francisco Department of Public Health (SFDPH).
If you filter "overall_segment" to "All SF Residents by Age Group, Administered by All Providers" you will see vaccination counts of various age eligibility groups that were administered by any provider.
To count the number of individuals vaccinated (with any primary series dose) for the first time on a given day, use the "new_recipients" column. To count the number of individuals who have completed their primary vaccine series on a given day, use the "new_series_completed" column. To count the number of primary series doses administered on a day (1st, 2nd, 3rd, or single doses), use the "new_primary_series_doses" column.
To count the number of individuals who r
To count the number of individuals who r
Updated
January 26 2023
Views
136
A. SUMMARY
Geographic zones of the priority areas in the Tenderloin neighborhood used in the COVID-19 assessment and Tenderloin Neighborhood Plan. See more details on the plan here:
https://sf.gov/news/san-francisco-releases-tenderloin-neighborhood-safety-assessment-and-plan-covid-19
Geographic zones of the priority areas in the Tenderloin neighborhood used in the COVID-19 assessment and Tenderloin Neighborhood Plan. See more details on the plan here:
https://sf.gov/news/san-francisco-releases-tenderloin-neighborhood-safety-assessment-and-plan-covid-19
B. HOW THE DATASET IS CREATED
A team of representative City departments from the Healthy Streets Operation Center (Department of Emergency Management, Department of Public Health, Department of Homelessness and Supportive Housing, Human Rights Commission, San Francisco Police Department, San Francisco Fire Department, and Department of Public Works), SF Ho
A team of representative City departments from the Healthy Streets Operation Center (Department of Emergency Management, Department of Public Health, Department of Homelessness and Supportive Housing, Human Rights Commission, San Francisco Police Department, San Francisco Fire Department, and Department of Public Works), SF Ho