A log of dataset alerts open, monitored or resolved on the open data portal. Alerts can include issues as well as deprecation or discontinuation notices.

A. SUMMARY
The San Francisco Controller's Office maintains a database of the salary and benefits paid to City employees since fiscal year 2013.

B. HOW THE DATASET IS CREATED
This data is summarized and presented on the Employee Compensation report hosted at http://openbook.sfgov.org, and is also available in this dataset in CSV format.

C. UPDATE PROCESS
New data is added on a bi-annual basis when available for each fiscal and calendar year.

D. HOW TO USE THIS DATASET
Before using please first review the following two resources:
Data Dictionary - Can be found in 'About this dataset' section after click 'Show More'
Employee Compensation FAQ - https://support.datasf.org/help/employee-compensation-faq

Summaries of closed complaints within the Ethics Commission's jurisdiction

[Update 2019-01-08] Data continues not to load but we are now working on developing an ETL off of a new API delivered by Netfile. We are in the discovery phase and do not have an exact ETA but are aiming to have the work complete this quarter.

[Issue 2018-02-21]: We are currently experiencing issues loading updated data from the Netfile source. We are investigating alternative approaches to restoring the automation. Data is not loading after December 2017 for most of the lobbyist activity datasets. During the outage, the data can be accessed via the Ethics Commission's lobbyist web site: https://netfile.com/lobbyistpub/#sfo

+++++++++

The name of each officer of the City and County of San Francisco with whom a lobbyist made a contact. Contacts of public officials are disclosed by lobbyists registered with the Ethics Commission on a monthly basis. This dataset updates automatically every night.

Cases created since 7/1/2008 with location information

This report tracks the name and source/website of the articles referenced for each month shown. Titles with a department name at the end reflect information provided from the department website. The other articles are maintained by SF311 to supplement department data. Articles used by 311 in the course of creating service requests (such as graffiti handling processes) are not included. Metrics of knowledge use from September and October 2017 was inconsistent following the migration to a new system in September 2017. Additionally, the names of articles is different than article names prior to the upgrade. This dataset is updated monthly.

Note - The data only goes back to Jan 2019. We are working to load the full data and expect to do so in Jan 2021.
For historical data (Top Articles Referenced through Aug. 2017), go to:
https://data.sfgov.org/City-Infrastructure/311-Top-Articles-Referenced-historical-through-Aug/hrr4-hjc6/data

San Francisco Campaign and Governmental Conduct Code ("S.F. C&GC Code") sections 1.143(c), 1.152(a)(3), 1.161(b), 1.161.5, and 1.160.5 require persons who make any independent expenditure, electioneering communication, or member communication that clearly identifies a candidate for City elective office or who authorizes, administers or pays for a persuasion poll to file disclosure statements with the Ethics Commission. For detailed instructions, please see Third Party Disclosure Form Regarding Candidates.

This dataset includes all summary totals e-filed on Fair Political Practices Commission (FPPC) Form 460 Summary Page 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

Campaign Finance - Public Funds Disbursed

The San Francisco Controller's Office maintains a database of spending and revenue data sourced from it's citywide financial system. This data is presented on the Spending and Revenue report hosted at http://openbook.sfgov.org, and is also available in this dataset in CSV format. New data is added on a weekly basis, and is available from fiscal year 2000 forward.