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:

Campaign Consultant
campaign_consultant
Employee
employee
Department
department
City Position
city_position
Appointment Date
appointment_date
Appointing Officer
appointing_officer
Quarter Start Date
quarter_start_date
Quarter End Date
quarter_end_date
Year
year
Quarter
quarter

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:

Close
Author
San Francisco Ethics Commission
Description
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.��
Category
City Management and Ethics
Tags
campaign consultant, ethics, appointments, public office
Rating
Current value: 0 out of 5
Data Provided By
San Francisco Ethics Commission
Source Link
http://www.sfethics.org
License
Public Domain Dedication and License

San Francisco Data

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