AndreaBozzo/ceres-open-data-index huggingface dataset:
COVID-19 Alternative Housing Sites

<b> A. SUMMARY</b> 
This dataset includes aggregate data on the type, status, population served, and individuals placed at each alternative housing site under contract with HSA.

<b>B. HOW THE DATASET IS CREATED</b>
Site Type, Status, and Population
The HSA DOC leadership inform the data tracker owner when the legal status, site type, or intended population to serve changes. 

Daily Census and Units Available
The site monitors at each site inform the data tracker owner at the HSA DOC at least once daily with the updates to the daily census. 

<b>C. UPDATE PROCESS</b>
Updated several times daily, whenever new information is shared with the data tracker owner. The data tracker owner inputs the data directly into the underlying SharePoint spreadsheet.

<b> D. HOW TO USE THIS DATASET</b>
Use the data for aggregate data on the site type, status, and daily census of individuals placed in the sites. Do not use this spreadsheet for individual-level information. There is no personally identifying or medical information in this dataset.

Organization: City of San Francisco
Annual Statement of Economic Interests (SEI) Form 700 - Non-Filers

Historic data only. The Ethics Commission now posts the Non-Filers list annually on the website with a category tag of "SEI" https://sfethics.org/ethics/category/sei

San Francisco Campaign and Governmental Conduct Code Section 3.1-104(b) requires the Ethics Commission to publish a report by April 10 and May 10 each year to list the names of individuals who did not file their annual Statement of Economic Interests by the April 1 deadline and by May 1, respectively. This table provides the list of non-filers as of the non-filer report date. To view the current list of non-filers visit SEI disclosures database: http://public.netfile.com/pub/?aid=SFO

Tags: conflict-of-interest, ethics, form-700, non-filer, sei, statement-of-economic-interests
Organization: City of San Francisco
Post- Employment Restriction Waivers

Under section 3.234(a)(1) of the San Francisco Campaign and Governmental Conduct Code, no former officer or employee of the City and County of San Francisco may make communications before any court or public agency in connection with any particular matter in which the City is a party or has a direct and substantial interest, in which the former officer or employee participated personally and substantially, and which involved specific parties at the time of such participation.  Under section 3.234(a)(2), no current or former officer or employee may, for one year after termination of service or employment, communicate with his or her former department to influence a government decision on behalf of any other person.  Under section 3.234(a)(3), no current or former officer or employee may be employed by or otherwise receive compensation from a person or entity that entered into a contract with the city within the past 12 months where the officer or employee personally and substantially participated in the award of the contract. Under section 3.234(c)(1), the Ethics Commission may waive the restrictions in subsections (a)(1) and (a)(2) if the Commission determines that granting a waiver would not create the potential for undue influence or unfair advantage.  Under section 3.234(c)(2), the Commission may grant a waiver from the restrictions in subsections (a)(1) and (a)(2) for members of City boards and commissions who, by law, must be appointed to represent any profession, trade, business union or association.  Under section 3.234(c)(3), the Commission may waive the ban in subsection (a)(3) if the Commission determines that imposing the restriction would cause extreme hardship for the City officer or employee. This is a table of the waivers that have been granted under section 3.234(c).

Tags: conflict-of-interest, ethics, post-employment-restriction-waivers
Organization: City of San Francisco
Library Usage

The Integrated Library System (ILS) is composed of bibliographic records including inventoried items, and patron records including circulation data. 
The data is used in the daily operation of the library, including circulation, online public catalog, cataloging, acquisitions, collection development, processing, and serials control.
This dataset represents the usage of inventoried items by active patrons. Per the California State Library definition, San Francisco Public Library defines active patrons as a) patrons with unexpired library cards and b) patrons who had circulation activity within the last three years.

Tags: circulation, library, patron
Organization: City of San Francisco
Civic Center Cultural Landscape Inventory

The Civic Center Cultural Landscape Inventory provides information about the historic landscape features that contribute to the Civic Center Historic District.  For more information please see the Civic Center Cultural Landscape Inventory website: http://sf-planning.org/civic-center-cultural-landscape-inventory

The dataset is a zipped ArcGIS map package.

Tags: gis, historic, planning, preservation, shapefile
Organization: City of San Francisco
SFEC Form 134b - Candidate's Notice of Exceeding 100 Percent of the Voluntary Expenditure Ceiling - Filings

SFEC Form 134b is for use by a candidate for Assessor, Public Defender, City Attorney, District Attorney, Treasurer, Sheriff, the Board of Education or the Community College Board who has received contributions, made qualified campaign expenditures, incurred expenses or have funds in his or her Campaign Contribution Trust Account that exceed 100 percent of the applicable ceiling.  This form must be filed by the candidate and received by the San Francisco Ethics Commission within 24 hours of reaching the 100 percent threshold. See S.F. Campaign & Governmental Conduct Code 
§ 1.134(b).  This form must be filed only if at least one candidate for the City elective office has accepted the applicable voluntary expenditure ceiling, and the Ethics Commission has not lifted that voluntary expenditure ceiling.  This dataset includes filings received starting March 2, 2020.

Organization: City of San Francisco
Civic Art Collection

<strong>A. SUMMARY</strong>
This data set includes all of the publicly-sited works in the Civic Art Collection, which includes historic monuments, murals, and artworks commissioned through the City's Public Art Program. The data set includes the following categories: artist name, title of work, medium, dimensions and location. The location also includes the Cultural Districts and Supervisor District that an artwork resides in. 

<strong>B. HOW THE DATASET IS CREATED</strong>
Dataset is exported manually by staff from internal collections database and re-formatted manually by staff.

<strong>C. UPDATE PROCESS</strong>
Dataset is updated as needed manually by staff.

<strong>D. HOW TO USE THIS DATASET</strong>
Artworks may be located at a specific addresses (traditional building number, street name format) or other locations (City Parks, Piers, SFO, etc.) that don't meet the traditional address format; in these cases, the closest intersection or building address has been used. Please look at the "Location Description" field for the location of the artwork (floor 2, International terminal, Northwest corner, etc.). An individual artwork can consist of a single piece or multiple pieces, this will be reflected in the last part of it's accession number with either a letter or number (i.e. 1904.2.a-b or 1999.22.1-2). A single artwork may have multiple entries, one for each part, or may have a single group entry. Therefore, the number of entries is not equivalent to the number of artworks. Generally, if an artworks' pieces are spread out over a distance, each piece will have an entry and if they are grouped at one location, there will be one group entry. When an artwork spans multiple blocks one end point was chosen for the address/map point. The data column "number_of_districts" refers to how many Cultural Districts a mural is in. If a mural is in more than Cultural Districts, the districts will be listed in the "Cultural_District" column and separated by a semicolon. This is because cultural districts can overlap.

Tags: art, artist, artworks, civic-art, san-francisco-arts-commission, sfarts, sfo
Organization: City of San Francisco
San Francisco Seismic Hazard Zones

This is a digital Seismic Hazard Zone Map presenting areas where liquefaction and landslides may occur during a strong earthquake. Three types of geological hazards, referred to as seismic hazard zones, may be featured on the map: 1) liquefaction, 2) earthquake-induced landslides, and 3) overlapping liquefaction and earthquake-induced landslides. Developers of properties falling within any of the three zones may be required to investigate the potential hazard and mitigate its threat during the local permitting process.

Organization: City of San Francisco
Campaign Consultants - Political Contributions

This dataset will no longer be updated as of March 2024, and is scheduled to be replaced with a new dataset in January of 2025. New filings are available in scanned paper format through the Ethics Commission's <a href="https://public.netfile.com/pub2/?aid=sfo">public disclosure portal</a>.

Filers must report each political contribution of $100 or more to a candidate for local office, a committee controlled by a local officeholder or a candidate for local office, or a ballot measure committee whether or not the committee is controlled by a local officeholder or a candidate for local office.  Filers must report contributions of $100 or more made or delivered by the filer, or made by the filer�۪s client at the filer�۪s behest, or for which the filer acted as an agent or intermediary during the reporting period. This chart indicates the political contributions made by campaign consultants during the reporting period.

Tags: campaign-consultant, contributions, ethics, political
Organization: City of San Francisco
ARCHIVED: COVID-19 Hospital Capacity

<i><b>Note: As of July 21, 2021, this dataset no longer updates.</i></b>

<strong>A. SUMMARY</strong>
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.
<strong>B. HOW THE DATASET IS CREATED</strong>
This hospital capacity information is based on data that all SF acute care hospitals report to the San Francisco Department of Public Health.
<strong>C. UPDATE PROCESS</strong>
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. 
<strong>D. HOW TO USE THIS DATASET</strong>
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.

Tags: acute, covid, covid-19, hospital, hospital-beds, hospital-capacity, icu, surge
Organization: City of San Francisco
Analysis Neighborhoods - 2020 census tracts assigned to neighborhoods

<strong>A. SUMMARY</strong>
This dataset maps 2020 census tracts to Analysis Neighborhoods. 

The Department of Public Health and the Mayor’s Office of Housing and Community Development, with support from the Planning Department originally created the 41 <u><a href="https://data.sfgov.org/d/p5b7-5n3h">Analysis Neighborhoods</a></u>  by grouping 2010 Census tracts, using common real estate and residents’ definitions for the purpose of providing consistency in the analysis and reporting of socio-economic, demographic, and environmental data, and data on City-funded programs and services. They are not codified in Planning Code nor Administrative Code. 

<strong>B. HOW THE DATASET IS CREATED</strong>
This dataset is produced by mapping the 2020 Census tracts to Analysis neighborhoods.  

<strong>C. UPDATE PROCESS</strong>
This dataset is static. Changes to the census tract boundaries are tracked in multiple datasets. See here for the  <u><a href="https://data.sfgov.org/d/bwbp-wk3r">2010 census tracts assigned to neighborhoods</a></u>


<strong>D. HOW TO USE THIS DATASET</strong>
This boundary file can be joined to other census datasets on GEOID, which is the primary key for census tracts in the dataset 

<strong>E. RELATED DATASET</strong>
2020 census tract boundaries for San Francisco can be found <u><a href="https://data.sfgov.org/d/tmph-tgz9">here</a></u>

Organization: City of San Francisco
Campaign Finance Database

The campaign finance database is the San Francisco Ethics Commission's repository for campaign finance filings. It can answer questions about who is contributing money, who is receiving money, and how it is being spent. Use the campaign finance database to research campaign contributions and expenditures reported on forms provided by the Fair Political Practices Commission. The database provides live access to the Ethics Commission's records. Filings are accessible once processed/posted by the Ethics Commission.Forms filed with the Ethics Commission can be downloaded in PDF format.  Forms filed electronically can be searched and exported in Microsoft Excel format.  The following Excel exports are available:- Excel file based on a search of itemized transactions up to 2,000 rows (Updated immediately, with the exception of FPPC filing deadlines -- within 48 hours);- Excel file by year or for entire life of a single committee (Updated immediately upon filing submission); and- Excel file by year for all committees in a single calendar year (Updated every 24 hours).

Tags: 460, 461, 465, 496, 497, campaign, candidate, committee, contribution, expenditure, finance, fppc
Organization: City of San Francisco
Campaign Finance - Status of Voluntary Expenditure Ceiling VECs in November 3, 2015 Election

Under S.F. Campaign and Governmental Conduct Code 1.128, a candidate who wishes to accept the voluntary expenditure ceiling must file Form SFEC-128 no later than the August 7, 2015 deadline for filing nomination papers.In a race where at least one candidate has accepted the VEC, all candidates running for office in the same race must file Form SFEC 134(b) within 24 hours of receiving contributions, making expenditures, or having funds that exceed 100 percent of the applicable VEC.

Organization: City of San Francisco
2016 SFO Customer Survey

SFO conducts a yearly comprehensive survey of our guests to gauge satisfaction with our facilities, services, and amenities. SFO compares results to previous surveys to look for areas of improvement and discover elements of the guest experience that are not satisfactory.

** The 2017 survey and Data Dictionary will be published late Summer, 2017.**

Tags: airport, customer, sfo, survey
Organization: City of San Francisco
Green Connections Network

Green Connections aims to increase access to parks, open spaces, and the waterfront by envisioning a network of green connectors -- city streets that will be upgraded incrementally over the next 20 years to make it safer and more pleasant to travel to parks by walking, biking, and other forms of active transportation. The dataset is a zipped GIS shapefile of the Green Connections Network which is shown in this map: http://www.sf-planning.org/ftp/files/Citywide/green_connections/GC_Final_Network_Map_03-2014.pdf. Further information can be found on the Green Connections website: http://greenconnections.sfplanning.org

Organization: City of San Francisco
Campaign Consultants - Client Payments

This dataset will no longer be updated as of March 2024, and is scheduled to be replaced with a new dataset in January of 2025. New filings are available in scanned paper format through the Ethics Commission's <a href="https://public.netfile.com/pub2/?aid=sfo">public disclosure portal</a>.

Campaign Consultants are required to report economic consideration promised by or received from clients in exchange for campaign consulting services during the applicable reporting period.  Economic consideration includes payments, fees, commissions, and reimbursements for expenses, gifts or anything else of value.

Tags: campaign-consultant, ethics, payments, promised, received
Organization: City of San Francisco
Campaign Consultants - Appointment to Public Office

This dataset will no longer be updated as of March 2024, and is scheduled to be replaced with a new dataset in January of 2025. New filings are available in scanned paper format through the Ethics Commission's <a href="https://public.netfile.com/pub2/?aid=sfo">public disclosure portal</a>.

If the campaign consultant is appointed to public office during the reporting period and the appointment is made by a local officeholder who is the campaign consultant's client, the campaign consultant must report the public office to which the filer was appointed, the date of the appointment, and the name of the officeholder who appointed the campaign consultant.��

Tags: appointments, campaign-consultant, ethics, public-office
Organization: City of San Francisco
Census 2020: Tracts for San Francisco

<strong>A. SUMMARY</strong>
Census tracts boundaries in San Francisco county. Census tracts are small, relatively permanent statistical subdivisions of a county. They are uniquely numbered in each county with a numeric code. Census tracts average about 4,000 inhabitants ranging from 1,200 – 8,000. More information on the census tracts can be found <u><a href="https://www2.census.gov/geo/pdfs/education/CensusTracts.pdf">here</a></u>.

<strong>B. HOW THE DATASET IS CREATED</strong>
The boundaries are uploaded from TIGER/Line shapefiles provided by the <u><a href="https://www.census.gov/cgi-bin/geo/shapefiles/index.php?year=2021&layergroup=Census+Tracts">U.S. Census Bureau</a></u>.
 
<strong>C. UPDATE PROCESS</strong>
This dataset is static. Changes to the census tract boundaries are tracked in multiple datasets. See here for <u><a href="https://data.sfgov.org/d/xx87-44s6">2000</a></u> and <u><a href="https://data.sfgov.org/d/rarb-5ahf">2010</a></u> census tract boundaries. 

<strong>D. HOW TO USE THIS DATASET</strong>
This boundary file can be joined to other census datasets on GEOID. 

<strong>E. RELATED DATASET</strong>
 <u><a href="https://data.sfgov.org/Geographic-Locations-and-Boundaries/Analysis-Neighborhoods-2020-census-tracts-assigned/sevw-6tgi">2020 Census Tracts and Analysis Neighborhoods</a></u>

Organization: City of San Francisco
SFEC Form 3630 - Recipients of Major Behested Payments - Expenditures

Under San Francisco Campaign & Governmental Conduct Code Section 3.630(a)(1), any person who receives a behested payment, or series of behested payments in a calendar year, totaling $100,000 or more must file this form within 30 days following the date on which the payments total $100,000 or more. For example, if your behested payments received total $100,000 on June 12, 2019, you must submit this form by July 12, 2019. You must notify the Ethics Commission that the recipient has received such payment(s) and specify the date on which the payment(s) equaled or exceeded $100,000.

Additionally, under San Francisco Campaign & Governmental Conduct Code Section 3.630(a)(2), if you filed this report to notify the Ethics Commission that you received behested payments totaling $100,000 or more, you must file this form again between 12 and 13 months following the date on which the payment(s) or payments total $100,000 or more and submit Schedule A. For example, if your behested payments total $100,000 on June 12, 2019, you must submit Schedule A between June 12, 2020 and July 12, 2020. Filers must disclose all payments made that were funded in whole or in part by the behested payment(s) made at the behest of the City officer and if the person was an interested party in any City decision(s) involving the officer in the 12 months following the date on which the payment(s) were made.

This dataset is a subtable of the parent dataset "SFEC Form 3630 - Recipients of Major Behested Payments - Filings", linked from the dataset Primer.  It must be joined using the DocuSign ID to connect to the parent table.

If 12 months have elapsed since the filer last filed Form 3630 to report receipt of behested payments of $100,000 or more, the filer must complete the expenditures report to disclose expenditures made with the behested funds.  For each expenditure, the filer must provide each payee's name, payment date, and payment details.

Organization: City of San Francisco
Nonprofit Wage and Equity Survey - Organization-Level Survey Data - FY23

<strong>A. SUMMARY</strong>
This dataset is a cleaned and anonymized version of survey data gathered in FY23 from nonprofits who contract with the City and County of San Francisco. Each row is one organization and data includes general information about the nonprofit's services, finances, and operations, and summary demographic data about each nonprofit's workforce. 

<strong>B. HOW THE DATASET IS CREATED</strong>
This dataset was generated through conducting a two-tiered survey gathering data on organizational characteristics and position-level data from nonprofits who contract with the City and County of San Francisco in FY23. The survey was fielded in October and November of 2022. 152 nonprofits provided organizational-level data and summary data about their workforce. 29 of those organizations (referred to as "Cohort Organizations") provided additional position-level data. This dataset includes organization-level data for the 152 respondent organizations. For further details on survey methodology, please review page 39 of the Nonprofit Wage and Equity Survey report, linked below in "Related Reports."

<strong>C. UPDATE PROCESS</strong>
Data is a one-time survey and will not update.

<strong>D. HOW TO USE THIS DATASET</strong>
Review code book, attached in the "About this Dataset" section. 

<strong>E. RELATED REPORTS</strong>
This dataset informs the Nonprofit Wage and Equity Survey Report, released by the Controller's Office in April 2023. 
<u><a href="https://sf.gov/sites/default/files/2023-04/Nonprofit%20Wage%20and%20Equity%20Survey%20Report%204.25.23.pdf">Nonprofit Wage and Equity Survey</a></u>

<strong>F. RELATED DATASETS</strong>
This dataset is one of two datasets of survey data from the Nonprofit Wage and Equity Survey (FY23). Position-level data can be viewed on the Open Data Portal. <u><a href="https://data.sfgov.org/City-Management-and-Ethics/Nonprofit-Wage-and-Equity-Survey-Position-Level-Co/jsip-bbxj">Nonprofit Wage and Equity Survey - Position-Level Cohort Data - FY23</a></u>

Tags: nonprofit
Organization: City of San Francisco