AndreaBozzo/ceres-open-data-index huggingface dataset:
Charitable Contributions at the Request of an Elected Official - Behested Payment Reports (FPPC Form 803)

This dataset includes information disclosed by elected officials when they fundraise or otherwise solicit payments from third parties for a legislative, governmental or charitable purpose. California law requires Oakland elected officials to file an FPPC Form 803 report with the Public Ethics Commission any time they fundraise or otherwise solicit payments for a legislative, governmental or charitable purpose that total $5,000 or more in a calendar year from a single source (one individual or organization) to be given to another individual or organization. The data is current as of the last modified date on this dataset.
Curb Ramps

This Indicator measures the percent of curbs with curb ramps that are not modern, indicating that they are non-compliant. Modern curb ramps should have all the proper elements: low slope and cross-slope, adequate width, level top and bottom landings, a detectable warning surface, and they should be directional and clear of obstructions in the curb ramp area. This is a citywide Indicator that measures conditions for individuals with physical disabilities and limited mobility.
Candidate Contributions (Show Me the Money)

This dataset includes itemized contributions (contributions of $100 or more) to campaign committees filed on FPPC Form 460. The transaction data includes both monetary and non-monetary (in-kind) contributions. The Election Year, Election Date, Candidate Name and Office have been added for each transaction based on the committee's Statement of Organization (FPPC Form 410) and FPPC ID (Filer ID). The data is current as of the last modified date on this dataset.
Campaign Finance - FPPC Form 497 - Late Contribution Report - Late Contributions Made

This dataset includes all itemized late contributions (cumulative $1,000 or more) e-filed on Fair Political Practices Commission (FPPC) Form 497 Late Contribution Report from 2011 to the present. The data is current as of the last modified date on this dataset. See the data key for column definitions: https://data.sfgov.org/Ethics/Campaign-Finance-Data-Key/wygs-cc76
Campaign Finance - FPPC Form 496 - Late Independent Expenditure Report - Part 3 - Contributions of $100 or More Received

This dataset includes all itemized contributions of $100 or more e-filed on Fair Political Practices Commission (FPPC) Form 496 "Part 3" Contributions of $100 or More Received from 2011 to the present. The data is current as of the last modified date on this dataset. See the data key for column definitions: https://data.sfgov.org/Ethics/Campaign-Finance-Data-Key/wygs-cc76
Campaign Finance - FPPC Form 496 - Late Independent Expenditure Report - Independent Expenditures Made

This dataset includes all itemized late independent expenditures ($1000 or more) e-filed on Fair Political Practices Commission (FPPC) Form 496 Late Independent Expenditures Report from 2011 to the present. The data is current as of the last modified date on this dataset. See the data key for column definitions: https://data.sfgov.org/Ethics/Campaign-Finance-Data-Key/wygs-cc76
Campaign Finance - FPPC Form 465 - Supplemental Independent Expenditure Report - Part 3 - Independent Expenditures Made

This dataset includes all itemized independent expenditures ($100 or more) e-filed on Fair Political Practices Commission (FPPC) Form 465 Part 3 Independent Expenditures Made from 2011 to the present. The data is current as of the last modified date on this dataset. See the data key for column definitions: https://data.sfgov.org/Ethics/Campaign-Finance-Data-Key/wygs-cc76
Campaign Finance - FPPC Form 461 - Major Donor and Independent Expenditure Committee Statement - Part 5 - Contributions (Including Loans, Forgiveness of Loans, and Loan Guarantees) and Expenditures Made

This dataset includes all itemized Contributions (Including Loans, Forgiveness of Loans, and Loan Guarantees) and Expenditures Made ($100 or more) e-filed on Fair Political Practices Commission (FPPC) Form 461 "Part 5" Contributions (Including Loans, Forgiveness of Loans, and Loan Guarantees) and Expenditures Made from 2011 to the present. The data is current as of the last modified date on this dataset. See the data key for column definitions: https://data.sfgov.org/Ethics/Campaign-Finance-Data-Key/wygs-cc76
Campaign Finance - FPPC Form 460 - Schedule D - Summary of Expenditures Supporting/Opposing Other Candidates, Measures and Committees

This dataset includes all itemized expenditures supporting/opposing other candidates, measures and committees ($100 or more) e-filed on Fair Political Practices Commission (FPPC) Form 460 Schedule "D" Expenditures Supporting/Opposing Other Candidates, Measures and Committees from 2011 to the present. The data is current as of the last modified date on this dataset. See the data key for column definitions: https://data.sfgov.org/Ethics/Campaign-Finance-Data-Key/wygs-cc76
Campaign Finance - FPPC Form 460 - Schedule C - Non-Monetary Contributions

This dataset includes all itemized non-monetary contributions ($100 or more) e-filed on Fair Political Practices Commission (FPPC) Form 460 Schedule "C" Non-Monetary Contributions from 2011 to the present. The data is current as of the last modified date on this dataset. See the data key for column definitions: https://data.sfgov.org/Ethics/Campaign-Finance-Data-Key/wygs-cc76
Campaign Finance - FPPC Form 460 - Schedule B2 - Loan Guarantors

This dataset includes all itemized guarantors of loans ($100 or more) e-filed on Fair Political Practices Commission (FPPC) Form 460 Schedule "B2" Loan Guarantors from 2011 to the present. The data is current as of the last modified date on this dataset. See the data key for column definitions: https://data.sfgov.org/Ethics/Campaign-Finance-Data-Key/wygs-cc76
Campaign Finance - FPPC Form 460 - Schedule B1 - Loans Received

This dataset includes all itemized loans received ($100 or more) e-filed on Fair Political Practices Commission (FPPC) Form 460 Schedule "B1" Loans Received from 2011 to the present. The data is current as of the last modified date on this dataset. See the data key for column definitions: https://data.sfgov.org/Ethics/Campaign-Finance-Data-Key/wygs-cc76
Campaign Finance - FPPC Form 460 - Schedule A - Monetary Contributions

This dataset includes all itemized monetary contributions ($100 or more) e-filed on Fair Political Practices Commission (FPPC) Form 460 Schedule "A" Monetary Contributions from 2011 to the present. The data is current as of the last modified date on this dataset. See the data key for column definitions: https://data.sfgov.org/Ethics/Campaign-Finance-Data-Key/wygs-cc76
Campaign Finance - Filers with Delinquent Campaign Filings 2014

According to the records of the City Clerk (the City's local filing officer), the Oakland Public Ethics Commission has identified the campaign finance disclosure filers in this table as non-responsive (NR) filers. NR filers are those that have not responded to two or more written notices and one or more verbal notices regarding past-due campaign finance reporting. Please note that Public Ethics Commission records are subject to change and the table below may not include all NR filers or reflect recent activity. The NR filers are encouraged to contact the Commission because continued failure to file may result in an enforcement action. Posted NR filers are removed from the list after filing their past-due campaign statement(s) or five years have elapsed since the applicable filing deadline.
Campaign Finance - Filers with Delinquent Campaign Filings

This dataset summarizes Oakland campaign committees with deliquent campaign filings. Under the Oakland Campaign Reform Act, any person required by State or local law to file a campaign statement or report with the local filing officer, must file the statement or report in an electronic format with the Public Ethics Commission. The Commission publishes the names of campaign committees and officers with filings that are more than 45 days overdue. Please note that this list is subject to change and the dataset below may not include all delinquent filers or reflect the most recent activity. Posted filers are removed from the list after filing their past-due campaign statement(s) or two years have elapsed since the applicable filing deadline.
Campaign Finance - FPPC Form 460 - Schedule H - Loans Made to Others

This dataset includes all itemized loans made to others ($100 or more) e-filed on Fair Political Practices Commission (FPPC) Form 460 Schedule "H" Loans Made to Others from 2011 to the present. The data is current as of the last modified date on this dataset. See the data key for column definitions: https://data.sfgov.org/Ethics/Campaign-Finance-Data-Key/wygs-cc76
Campaign Finance - FPPC Form 460 - Schedule G - Payments Made by an Agent or Independent Contractor

This dataset includes all itemized payments made by an agent or independent contractor ($500 or more) e-filed on Fair Political Practices Commission (FPPC) Form 460 Schedule "G" Payments Made by an Agent or Independent Contractor from 2011 to the present. The data is current as of the last modified date on this dataset. See the data key for column definitions: https://data.sfgov.org/Ethics/Campaign-Finance-Data-Key/wygs-cc76
Attrition from Field Training

This Indicator measures the attrition rate by race/ethnicity of police officers from the Oakland Police Department’s Field Training Program over the past 3 years (since the start of 2015). This includes the last five OPD academies (172nd-176th) as well as lateral academies and SFPD- managed academies. Officers are released from the program for different reasons ranging from termination, resignation, and/or failing to meet the performance dimensions required by the Field Training Program and the POST approved guidelines.
Adult Felony Arrests

This Indicator measures the rate of adult felony arrests by race/ethnicity adjusted for population. Rate is calculated as the number of adult felony arrests per 100,000 people of each race/ethnicity that are 18 years of age and older. To determine the number of adults of each race/ethnicity in Oakland, we took the population by race/ethnicity for all ages and multiplied by the percent of Oakland’s population that is 18 and over (80.33%). This approach was necessary due to the lack of exact data available on the 18 and over population in Oakland by race/ethnicity.
Acute Preventable Hospitalizations

This Indicator measures the age adjusted rate of acute preventable hospitalizations. “‘Preventable hospitalizations’ are inpatient hospital stays that could have been avoided with improved access to and quality of outpatient care. They are measured by prevention quality indicators (PQIs). PQI #91, the acute composite, is a summary measure which includes bacterial pneumonia, urinary tract infection, and dehydration preventable hospitalizations for adults. ”(Source:http://www.healthyalamedacounty.org/indicators/index/view?indicatorId=2480&localeId=2 38) This Indicator compares zip codes in which more than 60% of the population is non-White to those in which more than 60% of the population is White. The third category of zip codes is those in which the population is racially and ethnically mixed. Data is from 2013 through the third quarter of 2015.
Campaign Finance - FPPC Form 460 - Schedule F - Accrued Expenses (Unpaid Bills)

This dataset includes all itemized accrued expenses ($100 or more) e-filed on Fair Political Practices Commission (FPPC) Form 460 Schedule "F" Accrued Expenses (Unpaid Bills) from 2011 to the present. The data is current as of the last modified date on this dataset. See the data key for column definitions: https://data.sfgov.org/Ethics/Campaign-Finance-Data-Key/wygs-cc76
Access to Healthy Financial Institutions

This Indicator measures access to different types of financial institutions by zip code. “Good” institutions include banks, credit unions, and savings institutions. “Bad” institutions include check cashing services, money transfer services, and payday loan institutions. The ratio between the number of bad institutions and the number of good institutions is calculated for each zip code. A higher ratio of bad-to-good institutions means that there are disproportionately more bad institutions in a given zip code. The Indicator then measures the ratio of these ratios, comparing zip codes in which more than 60% of the population is non- White to those in which more than 60% of the population is White. The third category of zip codes is those in which the population is racially and ethnically mixed.
A-G Completion (Readiness for UC System)

The measurement is percent of students by race/ethnicity who have met the California A-G requirements by the end of high school. There are two components to the requirement: 1) Students must enroll in the right sequence of A-G courses, and 2) They must obtain a grade of “C” or better in each required course. Data includes only OUSD students (not charter or private schools) who have graduated.
Campaign Finance - FPPC Form 460 - Schedule E - Payments Made

This dataset includes all itemized payments made ($100 or more) e-filed on Fair Political Practices Commission (FPPC) Form 460 Schedule "E" Payments Made from 2011 to the present. The data is current as of the last modified date on this dataset. See the data key for column definitions: https://data.sfgov.org/Ethics/Campaign-Finance-Data-Key/wygs-cc76
Campaign Finance - FPPC Form 460 - Schedule I - Miscellaneous Increases to Cash

This dataset includes all itemized Miscellaneous Increases to Cash ($100 or more) e-filed on Fair Political Practices Commission (FPPC) Form 460 Schedule "I" Miscellaneous Increases to Cash from 2011 to the present. The data is current as of the last modified date on this dataset. See the data key for column definitions: https://data.sfgov.org/Ethics/Campaign-Finance-Data-Key/wygs-cc76
Weekend Parking Occupancy - April 2021

This dataset includes weekend on-street parking occupancy data collected in select commercial districts on April 10-11, 2021 and April 17-18, 2021. Data is available for Fruitvale, Grand Lake, Montclair, Rockridge, and Temescal. This data supports the suite of parking proposals presented to City Council on June 1, 2021. For more information on the suite of parking proposals, please visit: https://oakland.legistar.com/LegislationDetail.aspx?ID=4953657&GUID=ED90721C-CB1C-440C-97F9-17C84F13786D&Options=&Search=
Use of Force

This Indicator measures the rate of use of force on subjects per 100,000 people in Oakland by race/ethnicity. Note: There were 10 incidents of use of force that were on a crowd. For these incidents, the number and race/ethnicity of subjects were not available. Therefore, each was counted as one incident in the Citywide total. This will somewhat undercount the true total of people subjected to use of force and will potentially misrepresent the true racial and ethnic breakdown as well.
Stops

This Indicator measures the rate of discretionary stops per 1,000 people in Oakland by race/ethnicity. “In 2016 through 2017, officers were required to complete stop data forms after every discretionary detention or arrest, and discretionary encounters in which a search or request to search occurred. Discretionary stops and searches exclude detentions and arrests that occurred as the result of a dispatched call for service, a citizen request, or for stops occurring pursuant to search warrants.” (Source: Oakland Police Department’s 2016- 2017 Stop Data Report)
Soft Story Buildings

This Indicator measures the residential parcels that required a Level 1 or Level 2 evaluation of the group floor for a soft-story retrofit. Potential soft story buildings were identified through a 2008 screening of buildings permitted for construction before January 1, 1991, with parking or commercial on the ground floor, with five or more residential units, without previous soft story retrofits, and at least two stories. Some of these buildings were marked exempt or had incomplete evaluations, so this Indicator only measures those that were officially identified as soft story in 2014. In future years, we hope to measure the percent of identified soft story buildings that have been retrofitted.
Severe Mental Illness Emergency Department Visits

This Indicator measures severe mental illness related emergency department visits per 100,000 by race/ethnicity, from 2013 through the third quarter of 2015. Severe mental illness is often defined by its length of duration and the disability it produces. These illnesses include disorders that produce psychotic symptoms, such as schizophrenia and schizoaffective disorder, and severe forms of other disorders, such as major depression and bipolar disorder.
Service requests received by the Oakland Call Center (OAK 311)

REQUESTID = The service request number. This should be shown as an integer without decimals. 5-digit REQUESTIDs were imported from the Recycling Hotline’s prior tracking system when they switched to the same system as the Oakland Call Center in August 2012. All others are 6 digits. DATETIMEINIT = The Date that the request was initiated. SOURCE = Indicates if the request was received via SeeClickFix or the OAK 311 mobile app, via the legacy Report A Problem website, or via (Phone or Email). DESCRIPTION = Type of issue. Most of these are self-explanatory. Notes: “test template” and “This is a test subject. Ignore this ticket.” were for testing/training purposes only. Descriptions starting with “Business” “City Services” “CityBldg” (no space) “Events” “Misc” are/were used by the Recycling Hotline “TE” means “Traffic Engineering” REQCATEGORY = Request Category REQADDRESS = Request Address An address of ZZ indicates that the address was not recorded, usually this is for general inquiries to the Recycling Hotline. STATUS = The status as of date of upload. PENDING: Request received for review OPEN: Request assigned to work unit WOCREATE: Work Order created for work to be done (not all work units use this status, so Open service requests may also have work orders created for work to be done) CLOSED: Request is resolved REFERRED: Oakland Call Center received the request and forwarded it to another entity (see REFERREDTO) UNFUNDED: Request is for an service that the City is not funded to provide CANCEL: Request was canceled, generally because it was created erroneously, it was used for testing/training, or it is a request that was received that duplicated an existing unresolved request WAITING ON CUSTOMER: Request involves a process where customer needs to provide information requested by staff EVALUATED - NO FURTHER ACTION: Staff has evaluated the service request and no further action will be taken (e.g., limited resources, temporary issue, staff alerted to ongoing issue, professional judgement says to leave situation as-is, unable to provide requested action) GONE ON ARRIVAL: Staff went to location and was unable to verify the issue DATETIMECLOSED = The Date that the request was closed SRX, SRY= Coordinates of the issue. Note that this is in NAD_1983_StatePlane_California_III_FIPS_0403_Feet, not latitude/longitude. REFERREDTO = If the status is Referred, this shows who it was referred to. COUNCILDISTRICT = City Council District of the REQADDRESS. BEAT = Police Beat of the REQADDRESS (see http://mapgis.oaklandnet.com/PoliceDistricts/ for a map of police beats)
Service requests received by Public Works

REQUESTID = The service request number. This should be shown as an integer without decimals. 5-digit REQUESTIDs were imported from the Recycling Hotline’s prior tracking system when they switched to the same system as the rest of Public Works in August 2012. All others are 6 digits. DATETIMEINIT = The Date/Time that the request was initiated. DESCRIPTION = Type of issue. Most of these are self-explanatory. Notes: “test template” and “This is a test subject. Ignore this ticket.” were for testing/training purposes only. Descriptions starting with “Business” “City Services” “CityBldg” (no space) “Events” “Misc” are/were used by the Recycling Hotline “TE” means “Traffic Engineering” REQCATEGORY = Request Category REQADDRESS = Request Address An address of ZZ indicates that the address was not recorded, usually this is for general inquiries to the Recycling Hotline. STATUS = The status as of 1/30/13. Pending: Request received for review OPEN: Request assigned to work unit WOCREATE: Work Order created for work to be done (not all work units use this status, so Open service requests may also have work orders created for work to be done) CLOSED: Request is resolved REFERRED: Public Works received the request and forwarded it to another entity (see REFERREDTO) UNFUNDED: Request is for an service that Public Works is not funded to provide CANCEL: Request was canceled, generally because it was created erroneously, it was used for testing/training, or it is a request that was received that duplicated an existing unresolved request DATETIMECLOSED = The Date/Time that the request was closed SRX, SRY= Coordinates of the issue. Note that this is in NAD_1983_StatePlane_California_III_FIPS_0403_Feet, not latitude/longitude. REFERREDTO = If the status is Referred, this shows who it was referred to.
Political Contributions Solicited by Oakland Officials

Any Oakland public servant required to file a Statement of Economic Interests (Form 700) who successfully solicits a political contribution of $5,000 or more from any person or entity that contracts or proposes to contract with the official’s department must disclose the solicitation to the Public Ethics Commission within 30 days. This dataset summarizes data from Solicited Contribution Reports (OCRA Form 303) submitted to the Public Ethics Commission.
Police Response Times

This Indicator measures the median response times of calls for service that were routed to patrol. The measurement is broken down between Priority 1 and Priority 2 calls as well as by police area. Priority 1 Calls are defined as those that include potential danger for serious injury to persons, prevention of violent crimes, serious public hazards, felonies in progress with possible suspect on scene. Priority 2 Calls are defined as urgent but not an emergency situation, hazardous / sensitive matters, in-progress misdemeanors and crimes where quick response may facilitate apprehension of suspect(s). There are 5 police areas in Oakland each of which consist of a defined set of police beats and therefore cover a specific geographic part of Oakland. For more information and maps of areas, see here: http://www2.oaklandnet.com/government/o/OPD/o/BFO/index.htm
Physical Fitness

Physical fitness is measured by whether OUSD students are in the “Healthy Fitness Zone” in all six fitness areas captured by the Physical Fitness Test. The test is administered to students in grades 5, 7, and 9, and it measures abdominal strength, aerobic capacity, body composition, flexibility, trunk extensor strength, and upper body strength. Students are assessed based on whether they meet standards in each of these areas and are categorized as “Healthy Fitness Zone,” “Needs Improvement,” or “Needs Improvement - Health Risk”.
Teacher Turnover

The measurement is percent of teachers who turned over between the 2016-17 and 2017-18 school years at OUSD schools (data from charters and private schools were not available). Turnover percents are calculated at a school level out of the total number of teachers at that school. Schools are placed into groups based on the racial and ethnic breakdown of their student population (see note below data table for full explanation of grouping). Average teacher turnover percent is then calculated for each group of schools.