About this Dataset

Lobbyist Activity Directory

A. SUMMARY This dataset shows activity reported by registered lobbyists on their monthly statements. Learn more about the lobbyist program at the SF Ethics Commission website. Activities from both Contact and Expenditure lobbyists are combined in this dataset. B. HOW THE DATASET IS CREATED Lobbyists are required to register with the Ethics Commission and file monthly statements reporting their activity. C. UPDATE PROCESS Data from the lobbyist system is synched nightly to DataSF. If any filings have been accepted since the last update, the sync reflects new activity on those filings. D. HOW TO USE THIS DATASET Activities are self reported by lobbyists on monthly statements. All types of activities are reflected on this dataset, please refer to the SF Ethics Commission website to learn more about the lobbyist program. Refer to the "related content using this data" section below for links to filtered views by activity type, which limit the visible columns and may be more useful for analysis.
Organization: City of San Francisco
Last updated: 2021-08-07T18:49:04.979952
Tags: ethics, lobbyist

Tables

Table 1

@usgov.city_of_san_francisco_lobbyist_activity_directory.table_1

5.93 MB
109,131 rows
40 columns

CREATE TABLE table_1 (
  "activity_type" VARCHAR,
  "date" TIMESTAMP,
  "lobbyist_name" VARCHAR,
  "lobbyist_type" VARCHAR,
  "firm_name" VARCHAR,
  "description" VARCHAR,
  "amount" DOUBLE,
  "client_name" VARCHAR,
  "client_city" VARCHAR,
  "client_state" VARCHAR,
  "client_zip" VARCHAR,
  "candidate_name" VARCHAR,
  "description_of_office" VARCHAR,
  "committee_name" VARCHAR,
  "fppc_id" VARCHAR,
  "source_of_funds" VARCHAR,
  "employee_first_name" VARCHAR,
  "employee_last_name" VARCHAR,
  "employee_name" VARCHAR,
  "employment_type" VARCHAR,
  "nature_of_employment" VARCHAR,
  "date_employed" VARCHAR,
  "date_appointed" VARCHAR,
  "salary_range" VARCHAR,
  "is_salary" VARCHAR,
  "job_title" VARCHAR,
  "official_name" VARCHAR,
  "department_name" VARCHAR,
  "subject_area" VARCHAR,
  "issue" VARCHAR,
  "file_number" VARCHAR,
  "outcome_sought" VARCHAR,
  "payee_name" VARCHAR,
  "payee_city" VARCHAR,
  "payee_state" VARCHAR,
  "payee_zip" DOUBLE,
  "experts_or_issues" VARCHAR,
  "intermediaries" VARCHAR,
  "activity_id" VARCHAR,
  "from_filing" VARCHAR
);