Go to an accessible version of this page

Tyler Data & Insights
Close
Author
Suzanne Doran
Description
The Public Ethics Commission (PEC) investigates violations of laws related to campaign finance, lobbyist registration, public records, open meetings, and government ethics laws. This dataset summarizes all cases closed by the PEC since 2010. For more information visit: https://www.oaklandca.gov/topics/public-ethics-commission-enforcement-program.
Category
City Government
Tags
ethics, public ethics commission, complaints, penalties, accountability
Rating
Current value: 0 out of 5
Data Provided By
Public Ethics Commission
License
1.0 Universal (Public Domain Dedication)
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:

Complaint
complaint
Respondent(s)
respondent_s
Issue Area
issue_area
Date opened
date_opened
Violation(s)
violation_s
Closure date
closure_date
Commission action
commission_action
Fine
fine
Forfeiture
forfeiture
url
url
Year opened
year_opened
Year closed
year_closed

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.