[Deprecation warning] As of December 2018, Please visit https://sfethics.org/disclosures/city-officer-disclosure/payments-made-at-the-behest-of-an-elected-officer to view new Form 803 filings --- In accordance with the California Government Code section 82015, payments made at the behest of elected officials are presumed not to be contributions if they meet the following guidelines:(a) the payments are made principally for legislative, governmental, or charitable purposes, and(b) the payments are made principally for purposes unrelated to the official's candidacy for elected office.Although such payments are not contributions, they MUST BE REPORTED on the Report of Payments Made at the Behest of an Elected Officer form to the elected officer's agency within 30 days after the total payments made by a single source equal to or exceed $5,000 in a calendar year. The agency must forward a copy of the report to the Ethics Commission within 30 days of its receipt.After the $5,000 threshold is met for a particular calendar year, all subsequent payments made by the same source during the calendar year must be reported by the elected officer within 30 days after the date the payment is made.These reports are public records. The table includes all FPPC 803 forms filed with the Ethics Commission from April 20, 2015 to March 2018.

A. SUMMARY
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 2019 American Community Survey (ACS) 5-year estimates for population data to calculate rate per 10,000 residents.

Cases and deaths are both mapped to the residence of the individual, not to where they were infected or died. For example, if one was infected in San Francisco at work but lives in the East Bay, those are not counted as SF Cases or if one dies in Zuckerberg San Francisco General but is from another county, that is also not counted in this dataset.

Dataset is cumulative and covers cases going back to March 2nd, 2020 when testing began.

Geographic areas summarized are:
1. Analysis Neighborhoods
2. Census Tracts
3. Census Zip Code Tabulation Areas

B. HOW THE DATASET IS CREATED
Addresses from medical 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. The 2019 ACS estimates for population provided by the Census are used to create a rate which is equal to ([count] / [acs_population]) * 10000) representing the number of cases per 10,000 residents.

C. UPDATE PROCESS
Geographic analysis is scripted by SFDPH staff and synced to this dataset daily at 7:30 Pacific Time.

D. HOW TO USE THIS DATASET
Privacy rules in effect
To protect privacy, certain rules are in effect:
1. Case counts greater than 0 and less than 10 are dropped - these will be null (blank) values
2. Death counts greater than 0 and less than 10 are dropped - these will be null (blank) values
3. Cases and deaths dropped altogether for areas where acs_population < 1000

Rate suppression in effect where counts lower than 20
Rates are not calculated unless the case count is greater than or equal to 20. Rates are generally unstable at small numbers, so we avoid calculating them directly. We advise you to apply the same approach as this is best practice in epidemiology.

A note on Census ZIP Code Tabulation Areas (ZCTAs)
ZIP Code Tabulation Areas are special boundaries created by the U.S. Census based on ZIP Codes developed by the USPS. They are not, however, the same thing. ZCTAs are areal representations of routes. Read how the Census develops ZCTAs on their website.

Row included for Citywide case counts, incidence rate, and deaths
A single row is included that has the Citywide case counts and incidence rate. This can be used for comparisons. Citywide will capture all cases regardless of address quality. While some cases cannot be mapped to sub-areas like Census Tracts, ongoing data quality efforts result in improved mapping on a rolling bases.

Note: This is an archive of filings from 2016-2018. Filings submitted starting in 2019 are available via the following public access site: https://netfile.com/lobbyistpub/#/sfo-exp

An expenditure lobbyist is an individual or entity that spends $2,500 or more in a calendar month to solicit, request, or urge others to communicate directly with a City officer in order to influence local legislative or administrative action. City officers covered by this rule generally include elected City officials, members of City boards and commissions, and City department heads.

Examples of spending that counts toward the $2,500 registration threshold include public relations, media relations, advertising, public outreach, research, investigation, reports, analysis, and studies to the extent those activities are used to solicit, request or urge other persons to communicate directly with a City officer.

Examples of spending that does not count toward the $2,500 registration threshold include: payments made to a registered “contact” lobbyist who directly contacts City officers; payments made to an organization for membership dues; payments made by an organization to distribute communications to its members; payments made by a news media organization to develop and distribute its publications; and payments made by a client to a representative to appear on the client’s behalf in a legal proceeding before a City agency or department; salary paid by employer to employee for activities to solicit, request, or urge others to communicate directly with an officer of the City in order to influence a matter of local legislative or administrative action.

Each expenditure lobbyist must register by filing a registration form with the Ethics Commission no later than five business days after qualifying as such, and prior to making any additional payments to influence local legislative or administrative action.

Each registered expenditure lobbyist must file monthly reports with the Ethics Commission by the fifteenth day of the month following the calendar month covered by the report. For example, a report covering activity in the month of February must be filed by March 15. Deadlines falling on a weekend or holiday are extended to the next business day. Please note the monthly disclosures are different than the registration requirements.

Lists intersecting Supervisor Districts and ZIP Codes for City and County of San Francisco.

Cases created since 7/1/2008 with location information

Affordable rental housing developed in partnership with non-profit and private developers and financed by the Mayor’s Office of Housing and Community Development (MOHCD) and the Office of Community Investment and Infrastructure (OCII) through City Funding Agreements, Ground Leases, Disposition & Participation Agreements and Conduit Mortgage Revenue Bond Financing, as of December 31, 2019.

This dataset includes all itemized monetary contributions ($100 or more) e-filed on Fair Political Practices Commission (FPPC) Form 460 Schedule "A" Monetary Contributions from 1998 to the present.The data is current as of the last modified date on this dataset.See the data key for column definitions: https://data.sfgov.org/Ethics/Campaign-Finance-Data-Key/wygs-cc76
Note: Duplicate rows were removed on 6/16/2021.

Fire Calls-For-Service includes all fire units responses to calls. Each record includes the call number, incident number, address, unit identifier, call type, and disposition. All relevant time intervals are also included. Because this dataset is based on responses, and since most calls involved multiple units, there are multiple records for each call number. Addresses are associated with a block number, intersection or call box , not a specific address,

Mobile Food Facility Permits including name of vendor, location, type of food sold and status of permit.

This dataset includes the locations of businesses that pay taxes to the City and County of San Francisco. Each registered business may have multiple locations and each location is a single row. The Treasurer & Tax Collector’s Office collects this data through business registration applications, account update/closure forms, and taxpayer filings. The data is collected to help enforce the Business and Tax Regulations Code including, but not limited to: Article 6, Article 12, Article 12-A, and Article 12-A-1. http://sftreasurer.org/registration