San Francisco Data

Close
Author
Freya Channing
Description
<strong>A. SUMMARY</strong> The San Francisco Public Library is thrilled to share our dataset from the San Francisco Ballot Propositions Database on DataSF. This dataset contains full text of San Francisco ballot propositions dating back to 1907 and links to digitized PDF versions of the pamphlets for each election. Visit SFPL's <a href="https://sfpl.org/locations/main-library/government-information-center/san-francisco-government/san-francisco-1/san-1" target="_blank" rel="noopener">San Francisco Ballot Propositions Database</a> for a keyword searchable interface and links to Voter Information pamphlets. <strong>B. HOW THE DATASET IS CREATED</strong> San Francisco Public Library received a Library Services and Technology grant to finance the digital scanning and microfilming of the Library's print collection of voter information pamphlets and handbooks for San Francisco municipal elections. Although not complete, the collection dates back to 1907. Approximately 59,000 voter pamphlet pages, including 1,500 propositions, were digitized into PDF files. For some elections, separate pamphlets were created for each voting district or a combination of each voting district and political party, and there is no singular representative pamphlet which includes all of the candidates for that election. As a result, the hard copies of the various pamphlets were bound together to represent that particular election, and this resulted in extra-large digitized versions. Because the PDF files of the voter pamphlets are images instead of text, they cannot be searched electronically. San Francisco Public Library staff developed the San Francisco Ballot Propositions Database to provide keyword access to San Francisco propositions, pass/fail outcomes and other information, and links to the full-text PDF Voter Information Pamphlet. <strong>C. UPDATE PROCESS</strong> This dataset is updated when the final election results from the <a href="https://sfelections.sfgov.org/results">San Francisco Department of Elections</a> are available. <strong>D. HOW TO USE THIS DATASET</strong> This dataset contains the number and percentage of ballots cast, percentage required to pass, as well as pass/fail outcomes, the full text of each proposition, and a link to a PDF version of the Voter Information Pamphlet for that election, if available.
Category
City Management and Ethics
Tags
ballot measure, elections, propositions
Rating
Current value: 0 out of 5
Data Provided By
Strategic Data Analyst
License
Public Domain Dedication and License
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

PROPLetter
propletter
PROPTitle
proptitle
Month
month
Day
day
Year
year
Date
date
Description
description
PASS_FAIL
pass_fail
Voted_Yes
vote_counts_yes
Voted_No
vote_counts_no
Percent_Vote_Yes
percent_vote_yes
Percent_Vote_No
percent_vote_no
Percent_Required_To_Pass
percent_required_to_pass
Kind
kind
HowPlaced
howplaced
Voter_Information_Pamphlet
voter_information_pamphlet

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.