AndreaBozzo/ceres-open-data-index huggingface dataset:
SFEC Campaign Consultant Report - City Officeholders & Employees

<strong>A. SUMMARY</strong>
This dataset contains information about the Employment of Local Officeholders and City Employees section of the Campaign Consultant Report.

For more information, visit the Ethics Commission’s webpage on <a href="https://sfethics.org/guidance/campaign-consultants">Campaign Consultants</a>.

<strong>B. HOW THE DATASET IS CREATED</strong>
Data for this dataset is created when campaign consultants electronically file the following reports with employment information: 

Form 3 – Quarterly Disclosure Report for Campaign Consultants
Form 6 – Campaign Consultant Termination Statement

This dataset contains reports filings starting from December 9, 2024, when electronic filing of campaign consultant reports will be required.

<strong>C. UPDATE PROCESS</strong>
The dataset is updated via the Socrata Publisher API as needed when form filings are submitted and signed by campaign consultants.

<strong>D. HOW TO USE THIS DATASET</strong>
The unique row identifier for an employment entry is “Entry Id”. This dataset should be joined with the SFEC Campaign Consultant Report dataset by “Envelope Id”.

<strong>E. RELATED DATASETS</strong>
For detail reporting on campaign consultant activities, visit <a href="https://data.sfgov.org/City-Management-and-Ethics/SFEC-Campaign-Consultant-Report/iv34-5p9x/about_data">SFEC Campaign Consultant Report</a>.

Organization: City of San Francisco
SFEC Form 3610b - City Officer Behested Payment - Communications

San Francisco Campaign and Governmental Conduct Code section 3.610 requires City elective officers and members of certain boards and commissions to file behested payment reports (Form SFEC-3610(b)) with the Ethics Commission.

Effective September 24, 2020, Mayoral Executive Directive 20-02 requires Department Heads to file behested payment Form SFEC-3610(b) and to comply with the City’s behested payment requirements that apply to City elected officials and members of boards and commissions that are contained in Article III, Chapter 6 of the Campaign and Governmental Conduct Code.

An officer must file Form SFEC-3610(b) any time a behested payment of $1,000 or more is made at his or her behest by an interested party. An “interested party” is a person who is a party, participant or agent of a party or participant to certain types of proceedings before the official in question. Those proceedings are limited to administrative enforcement proceedings and proceedings regarding permits, licenses, or other entitlements for use. A party to such a proceeding is someone who files an application for a license, permit, or entitlement for use or is the subject of the administrative enforcement. A participant in such a proceeding is someone who is not a party to the proceeding but who actively supports or opposes a particular decision in the proceeding and has a financial interest in the decision. An agent is someone who represents a party or a participant in such a proceeding.

The filing deadline for Form SFEC-3610(b) depends on the circumstances under which the behested payment was made.

If the behested payment was made while the proceeding involving the interested party is pending before the official, then the form must be filed within thirty days of the payment being made. If there is a series of behested payments, the form is due within 30 days of the payment that makes the total $1,000 or more.

If the behested payment was made within six months following the date on which a final decision was made in the proceeding involving the interested party, then the form must be filed within thirty days of the payment. If there is a series of behested payments, the form is due within 30 days of the payment that makes the total $1,000 or more.

Finally, if the behested payment was made in the 12 months prior to the commencement of the proceeding involving the interested party, the form is due within 30 days of the date the official knew or should have known that the source of the behested payment became an interested party.

Each row in this dataset represents information about communications reported in the "Communications Featuring Officer" sub-table of a Form 3610b filed with the Ethics Commission. The parent filing and form data is available in a separate dataset: "SFEC Form 3610b - City Officer Behested Payment - Filings" at https://data.sfgov.org/City-Management-and-Ethics/SFEC-Form-3610b-City-Officer-Behested-Payment-Fili/7vmk-cq9e. Join this dataset with the sub-table using the DocuSignID.

Organization: City of San Francisco
SFEC Campaign Consultant Report - Vendors

<strong>A. SUMMARY</strong>
This dataset contains information about the Vendors and Subvendors section of the Campaign Consultant Report.

For more information, visit the Ethics Commission’s webpage on <a href="https://sfethics.org/guidance/campaign-consultants">Campaign Consultants</a>.

<strong>B. HOW THE DATASET IS CREATED</strong>
Data for this dataset is created when campaign consultants electronically file the following reports with vendors information: 

Form 3 – Quarterly Disclosure Report for Campaign Consultants
Form 6 – Campaign Consultant Termination Statement

This dataset contains reports filings starting from December 9, 2024, when electronic filing of campaign consultant reports will be required.

<strong>C. UPDATE PROCESS</strong>
The dataset is updated via the Socrata Publisher API as needed when form filings are submitted and signed by campaign consultants.

<strong>D. HOW TO USE THIS DATASET</strong>
The unique row identifier for a vendor entry is “Entry Id”. This dataset should be joined with the SFEC Campaign Consultant Report dataset by “Envelope Id”.

<strong>E. RELATED DATASETS</strong>
For detail reporting on campaign consultant activities, visit <a href="https://data.sfgov.org/City-Management-and-Ethics/SFEC-Campaign-Consultant-Report/iv34-5p9x/about_data">SFEC Campaign Consultant Report</a>.

Organization: City of San Francisco
SFEC Campaign Consultant Report - City Contracts

<strong>A. SUMMARY</strong>
This dataset contains information about the City Contracts section of the Campaign Consultant Report.

For more information, visit the Ethics Commission’s webpage on <a href="https://sfethics.org/guidance/campaign-consultants">Campaign Consultants</a>.

<strong>B. HOW THE DATASET IS CREATED</strong>
Data for this dataset is created when campaign consultants electronically file the following reports with city contract information: 

Form 3 – Quarterly Disclosure Report for Campaign Consultants
Form 6 – Campaign Consultant Termination Statement

This dataset contains reports filings starting from December 9, 2024, when electronic filing of campaign consultant reports will be required.

<strong>C. UPDATE PROCESS</strong>
The dataset is updated via the Socrata Publisher API as needed when form filings are submitted and signed by campaign consultants.

<strong>D. HOW TO USE THIS DATASET</strong>
The unique row identifier for a city contract entry is “Entry Id”. This dataset should be joined with the SFEC Campaign Consultant Report dataset by “Envelope Id”.

<strong>E. RELATED DATASETS</strong>
For detail reporting on campaign consultant activities, visit <a href="https://data.sfgov.org/City-Management-and-Ethics/SFEC-Campaign-Consultant-Report/iv34-5p9x/about_data">SFEC Campaign Consultant Report</a>.

Organization: City of San Francisco
Citywide Nonprofit Monitoring and Capacity Building Program FY24 Annual Report

The Controllers’ Office coordinates the Citywide Nonprofit Monitoring and Capacity Building Program, where City departments conduct annual fiscal and compliance monitoring of nonprofits doing business with the City. Departments submit the results of fiscal and compliance monitoring into the Nonprofit Monitoring Salesforce database. Each year, the Controller’s Office generates this dataset of fiscal monitoring activities and results, then summarizes highlights in the annual Nonprofit Monitoring Annual Report. To read the full Annual Report, please see the Annual Reports section on the <u><a href="https://www.sf.gov/resource/2022/citywide-nonprofit-monitoring-and-capacity-building-program">Citywide Nonprofit Monitoring and Capacity Building Program website</a></u>

This dataset includes a list of all nonprofits in the FY24 joint fiscal and compliance monitoring pool, the type of monitoring they received, and their monitoring results including any findings.  

Attachment 1 “FY24 Contractor Summary” lists the contractors in the FY24 joint monitoring pool, the type of fiscal monitoring assigned, lead monitoring department for FY24 and participating funding departments for each contractor. Attachment 2 “FY24 Department Key” lists the full name of departments along with their acronym.

Tags: nonprofit
Organization: City of San Francisco
Performance Metrics - Buildings - Time To Issue Green Permits

As part of the City’s sustainability program, the Department of Buildings (DOB) offers expedited permitting for residential, commercial and industrial building projects that meet certain criteria. In addition to fast-tracking, projects achieving exceptional sustainability may be eligible for a fee waiver up to $25,000.  Projects that include green technologies (green roofs, rainwater harvesting, solar panels, solar thermal panels, wind turbine and geothermal systems) are required to be submitted through the Green Permit Program.  This metric tracks the average number of days DOB takes to process individual Green Permits, grouped by the week the permit was processed. The target average process time is within 71 days.

Tags: buildings, performance-metrics, permits, service-delivery, sustainability
Organization: City of Chicago
Chicago Public Schools - School Admissions Information SY2122

School admissions information for all Chicago Public Schools for the academic year 2021-2022. Each row is a program, and a program can appear multiple times if it belongs to more than one program_group. This allows for a program to be associated with multiple groups.

* Data set is no longer being updated when data set for next year is created

Tags: 2021, 2022, cps, metrics, report-cards, schools
Organization: City of Chicago
Chicago Public Schools - School Admissions Information SY2021

School admissions information for all Chicago Public Schools for the academic year 2020-2021. Each row is a program, and a program can appear multiple times if it belongs to more than one program_group. This allows for a program to be associated with multiple groups.

* Data set is no longer being updated when data set for next year is created

Tags: 2020, 2021, cps, metrics, report-cards, schools
Organization: City of Chicago
Performance Metrics - Buildings - Time to Issue Developer Services Permits

The Developer Services Review Program is designed to meet the special needs of owners, developers, architects and contractors working on moderately- to highly-complex construction or renovation projects. Eligible projects include high-rise buildings, mercantile buildings with more than 150,000 square feet, other occupancies with more than 80,000 square feet, buildings with foundations deeper than 12 feet, and residential projects that contain more than 25 units. This metric tracks the average number of days DOB takes to process individual Developer Services Permits, grouped by the week the permit was processed. The target average process time is within 89 days. Click here for more information about DOB’s Developer Services Program.

Tags: buildings, performance-metrics, permits, service-delivery
Organization: City of Chicago
Vendor Payments - New Arrivals

The expenditures reported here reflect payments that have been made for Migrant-related response costs as of the upload date.  The City has implemented a coordinated response to track expenditures related to Migrants.  Additional expenditures may have been incurred that are in the process of being paid and/or reconciled.  These expenditures may be reported at a later date and will be captured in future iterations of this dataset.

Tags: asylum, migrants, new-arrivals, payments, vendors
Organization: City of Chicago
Performance Metrics - Transportation

This dataset contains performance metrics tracked by the Chicago Department of Transportation (CDOT). Thirty-five different performance metrics are tracked in this dataset, which reports the performance target, actual performance, and number of requests completed for a given metric. These metrics are based on data calculated from the city's 311 system. Individual breakout of each performance metric are also available under the "More Views" button.

Tags: pavement, performance-metrics, pothole, service-requests, streets
Organization: City of Chicago
Chicago Public Schools - School Admissions Information SY2223

School admissions information for all Chicago Public Schools for the academic year 2022-2023. Each row is a program, and a program can appear multiple times if it belongs to more than one program_group. This allows for a program to be associated with multiple groups.

* Data set is no longer being updated when data set for next year is created

Tags: 2022, 2023, cps, metrics, report-cards, schools
Organization: City of Chicago
Performance Metrics - Buildings - Time to Issue Easy Permits

The Easy Permit Process allows home and building owners to obtain a permit to repair or replace the same or existing elements of a building, without making any changes to the structure of the building. Eligible projects include repairing or replacing drywall, flooring, fences, sheds or garages. This metric tracks the average number of days DOB takes to process individual Easy Permits, grouped by the week the permit was processed. The target process time is within 1.3 days. For more information about the Easy Permitting process, go to http://www.cityofchicago.org/city/en/depts/bldgs/provdrs/permit_proc.html.

Tags: buildings, performance-metrics, permits
Organization: City of Chicago
Performance Metrics - Buildings - Time to Issue Standard Plan Review Program Permits

The Department of Building (DOB) issues building permits to give individuals, insurance companies, neighbors and the City assurance that specific minimum standards are met in constructing, repairing or altering buildings by complying with the Chicago Building Code.  This metric tracks the average number of days DOB takes to process Standard Plan Review Program building permits, grouped by the week the permit was processed. The target process time is within 53 days. The Standard Plan Review Program is designed for small to mid-sized construction or renovation projects requiring drawings. Eligible projects include buildings up to 80 feet high, institutional or mercantile properties under 100,000 square feet, residential properties of up to 12 units, and foundations no deeper than 12 feet. For more information, go to http://www.cityofchicago.org/city/en/depts/bldgs/supp_info/overview_of_the_standardplanreviewpermitprogram.html.

Tags: buildings, performance-metrics, permits, service-delivery
Organization: City of Chicago
Police Sentiment Scores

This dataset was used by Chicago Police Department analysts to create the publicly available “Chicago Police Sentiment Dashboard” (https://home.chicagopolice.org/statistics-data/data-dashboards/sentiment-dashboard/). This online dashboard displays information related to how safe Chicago residents feel and how much trust they have in the police.

The dashboard and this dataset are updated monthly and users are able to view data citywide, as well as within the five detective areas and in each of the 22 districts. Users can sort this data based on year, month and location. Information is also available based on demographics, including age, sex, race, education and income level. The dashboard is meant to improve transparency as well as work toward compliance with the consent decree.

The first five columns indicate the type of organizational unit described by the records and which particular unit. Subsequent columns show either a safety or trust score for a demographic group. Scores are derived from responses to survey questions, with each response being a value that ranges from 0-10. Please note that Elucd trust and safety scores are NOT a percentage. A score of 65 means that average response to the questions is 6.5 out of 10. The final two columns show the time period in which the data were collected.

The dataset was created by our partner, Elucd (https://elucd.com), through delivering short surveys to Chicago residents through digital ads. See [https://home.chicagopolice.org/wp-content/uploads/2020/12/Dashboard_FAQ_11_25_20.pdf] for more information on the project.

This effort is one element of a Chicago Police Department reform process, governed by a consent decree executed between the Office of the Attorney General of the State of Illinois (OAG) and the City of Chicago. For more information on the consent decree, see https://www.chicago.gov/city/en/sites/police-reform/home/consent-decree.html.

Tags: consent-decree, police, public-safety
Organization: City of Chicago
Department for the Aging (NYC Aging) - Bottom Line Budget

The Department for the Aging (NYC Aging) provides a wide array of services to older adults (age 60 and older) in the five boroughs of New York City. To accomplish this, NYC Aging contracts out to external organizations (mainly non-profits) to provide the services.

This dataset contains the approved bottom line budgets for the contracted providers for the current Fiscal Year.

Tags: department-for-the-aging, dfta, nyc-aging, nycaging, older-adults, program-name, provider-name, provider-type
Organization: City of New York
Department for the Aging (NYC Aging) - Reported Expenditures

The Department for the Aging (NYC Aging) provides a wide array of services to older adults (age 60 and older) in the five boroughs of New York City. To accomplish this, NYC Aging contracts out to external organizations (mainly non-profits) to provide the services.

 This dataset contains approved line item expenditures reported by the contracted providers during the current Fiscal Year.

Tags: department-for-the-aging, dfta, nyc-aging, nycaging, older-adults, program-name, provider-name, provider-type
Organization: City of New York
Local Law 14 Health Data (Middle School)

This report provides information about the provision of health education instruction for the 6-8 grades.

For the Local Law 14 Health Data High School and HIV/AIDS Lessons data, please refer to: https://data.cityofnewyork.us/d/msnn-ey3g and https://data.cityofnewyork.us/d/hi2h-7vr7

Tags: health, health-education, local-law-14
Organization: City of New York
Community Development Block Grant (CDBG) Eligibility by Census Tract - CSV

The U.S. Department of Housing and Urban Development (HUD) requires local municipalities that receive Community Development Block Grant (CDBG or CD) formula Entitlement funds to use the 5-year 2016-2020 American Community Survey (ACS) Low and Moderate Income Summary Data (LMISD) data file to determine where CDBG funds may be used for activities that are available to all the residents in a particular area ("CD area benefit" or "CD-eligible area"). A CD-eligible census tract refers to 2020 census tracts where the area is primarily residential in nature and at least 51.00% of the residents are low- and moderate-income persons as per the LMISD data file. For New York City, a primarily residential area is defined as one where at least 50.00% of the total built floor area is residential. Low- and moderate-income persons are defined as persons living in households with incomes below 80 percent of the area median household income (AMI).
In addition, floor area percentages have been updated with the most recent floor area data (PLUTO 24v4).
Persons who are interested in determining their individual household eligibility for CD-funded programs should refer to <a href='https://www.huduser.gov/portal/datasets/il.html'>HUD's household low- and moderate-income limits for the given year.</a>
For more information about how geographic datasets are used for compliance purposes, please refer to the following <a href='https://www.hud.gov/sites/dfiles/OA/documents/CPD-24-04.pdf'>HUD Office of Community Planning and Development (CPD) Notice CPD-24-04</a>.

Tags: block-grant-eligibility, cdbg, census-tracts, community-development, low-income, moderate-income, residential
Organization: City of New York
Department for the Aging (NYC Aging) - Budgeted Services

The Department for the Aging (NYC Aging) provides a wide array of services to older adults (age 60 and older) in the five boroughs of New York City. To accomplish this, NYC Aging contracts out to external organizations (mainly non-profits) to provide the services.

This dataset contains the approved service units budgeted/proposed by the contracted providers for the current Fiscal Year.

Tags: department-for-the-aging, dfta, nyc-aging, nycaging, older-adults, program-name, provider-name, provider-type, service-name
Organization: City of New York
Local Law 14 Health Data (High School)

This report provides information about the provision of health education instruction for the 9-12 grades.

For the Local Law 14 Health Data Middle School and HIV/AIDS Lessons data, please refer to: https://data.cityofnewyork.us/d/qq3t-y24y and https://data.cityofnewyork.us/d/hi2h-7vr7

Tags: health, health-education, local-law-14
Organization: City of New York
Expense Budget-Debt Service Agency OTPS Detail

The Debt Service Agency OTPS detail lays out the various expense and funding line items for Agency 099. It further compares the Adopted Budget, Current Modified Budget for the Current Year, and the Executive or Adopted Budget for the next fiscal year. All amounts are in dollars and information is updated twice per year at the Executive and Adopted budgets.

Tags: contact-budget, expense, expense-budget, nyc-debt-service, nyc-debt-service-budget, nyc-omb, revenue
Organization: City of New York
Local Law 14 Health Data (HlV/AIDS Lessons)

This report provides information on the HIV/AIDS education for the 6-12 grades.			

For the Local Law 14 Health Data High School and Middle School and HIV/AIDS Lessons data, please refer to: https://data.cityofnewyork.us/d/msnn-ey3g and https://data.cityofnewyork.us/d/qq3t-y24y

Tags: health, health-education, local-law-14
Organization: City of New York
Firefighter Probationary School Results Admissions and Graduation Statistics

This dataset contain cumulative counts of applicants from the current active firefighter exam listings, which include Exam 7001 (open-competitive) and Exam 7501 (promotional).  This dataset dissects the career path stages of becoming a firefighter from application, examinations, to graduation. Visit https://www.joinfdny.com/careers/firefighter/ for more information on the firefighter career path.

Tags: demographics, firefighter, probationary-firefighter, proby-school
Organization: City of New York