San Francisco Ballot Propositions Database - Historical Ballot Propositions 1907-present by US Government | Demographics and Population Studies

About this Dataset

San Francisco Ballot Propositions Database - Historical Ballot Propositions 1907-present

A. SUMMARY 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 San Francisco Ballot Propositions Database for a keyword searchable interface and links to Voter Information pamphlets. B. HOW THE DATASET IS CREATED 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. C. UPDATE PROCESS This dataset is updated when the final election results from the San Francisco Department of Elections are available. D. HOW TO USE THIS DATASET 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.
Organization: City of San Francisco
Last updated: 2021-08-07T18:35:09.594239
Tags: ballot-measure, elections, propositions

Tables

Table 1

@usgov.city_of_san_francisco_san_francisco_ballot_proposition_a2f111b3.table_1

367.76 KB
1998 rows
16 columns


CREATE TABLE table_1 (
  "propletter" VARCHAR,
  "proptitle" VARCHAR,
  "month" VARCHAR,
  "day" BIGINT,
  "year" BIGINT,
  "date" VARCHAR,
  "description" VARCHAR,
  "pass_fail" VARCHAR,
  "voted_yes" VARCHAR,
  "voted_no" VARCHAR,
  "percent_vote_yes" VARCHAR,
  "percent_vote_no" VARCHAR,
  "percent_required_to_pass" VARCHAR,
  "kind" VARCHAR,
  "howplaced" VARCHAR,
  "voter_information_pamphlet" VARCHAR
);