Data Description: This data set contains properties registered in the City of Cincinnati's vacant and foreclose property program. This program is designed to identify properties that are vacant and/or in foreclosure to ensure that they continue to comply with code despite being unoccupied.

Data Creation: This data is created every time a new property is registered as vacant or foreclosed.

Data Created By: This data set is stored and maintained by Cincinnati Area Geographic Information Systems (CAGIS). The content is input and updated by the Department of Buildings & Inspections.

Refresh Frequency: Daily

Data Dictionary: A data dictionary providing definitions of columns and attributes is available as an attachment to this dataset.

Processing: The City of Cincinnati is committed to providing the most granular and accurate data possible. In that pursuit the Office of Performance and Data Analytics facilitates standard processing to most raw data prior to publication. Processing includes but is not limited: address verification, geocoding, decoding attributes, and addition of administrative areas (i.e. Census, neighborhoods, police districts, etc.).

Data Usage: For directions on downloading and using open data please visit our How-to Guide: https://data.cincinnati-oh.gov/dataset/Open-Data-How-To-Guide/gdr9-g3ad

Data Description: The Private Lot Abatement Program (PLAP) is a program of cleaning and abatement of private lots through code enforcement. Properties that have received multiple citations for the same violation without response are included in PLAP for abatement and ongoing maintenance by the Neighborhood Operations Division (NOD) of the Department of Public Services (DPS)

Data Creation: Abatements and cleanings of PLAP properties are recorded by NOD

Data Created By: DPS

Refresh Frequency: Daily

CincyInsights: The City of Cincinnati maintains an interactive dashboard portal, CincyInsights in addition to our Open Data in an effort to increase access and usage of city data. This data set has an associated dashboard available here: https://insights.cincinnati-oh.gov/stories/s/Private-Lot-Abatement-Program-PLAP-/55ef-pfz7/

Data Dictionary: A data dictionary providing definitions of columns and attributes is available as an attachment to this dataset.

Processing: The City of Cincinnati is committed to providing the most granular and accurate data possible. In that pursuit the Office of Performance and Data Analytics facilitates standard processing to most raw data prior to publication. Processing includes but is not limited: address verification, geocoding, decoding attributes, and addition of administrative areas (i.e. Census, neighborhoods, police districts, etc.).

Data Usage: For directions on downloading and using open data please visit our How-to Guide: https://data.cincinnati-oh.gov/dataset/Open-Data-How-To-Guide/gdr9-g3ad

Data Description: Cincinnati Building Permits that have been applied for since January 1, 2010.

Data Creation: Data is entered by the Buildings & Inspections department.

Data Created By: City of Cincinnati

Refresh Frequency: Daily

CincyInsights: The City of Cincinnati maintains an interactive dashboard portal, CincyInsights in addition to our Open Data in an effort to increase access and usage of city data. This data set has an associated dashboard available here: https://insights.cincinnati-oh.gov/stories/s/vi3f-a2sx

Data Dictionary: A data dictionary providing definitions of columns and attributes is available as an attachment to this dataset.

Processing: The City of Cincinnati is committed to providing the most granular and accurate data possible. In that pursuit the Office of Performance and Data Analytics facilitates standard processing to most raw data prior to publication. Processing includes but is not limited: address verification, geocoding, decoding attributes, and addition of administrative areas (i.e. Census, neighborhoods, police districts, etc.).

Data Usage: For directions on downloading and using open data please visit our How-to Guide: https://data.cincinnati-oh.gov/dataset/Open-Data-How-To-Guide/gdr9-g3ad

Data Description: This data set contains all inspections issued/performed by City of Cincinnati Departments (including Buildings & Inspections; Cincinnati Fire Department; Cincinnati Health Department; Cincinnati Parks; and Trade/Development), as well as Inspections Bureau Inc (IBI) and Hamilton County departments.

Inspections range from electrical surveys, to swimming pools/spas, to elevator inspections, daycare inspections, and more. This data covers inspections since 1999 through present day.

Data Creation: All data is input by respective agencies, and maintained/stored by Cincinnati Area Geographic Information Systems (CAGIS), and is additionally available on CAGIS Property Activity Report website: http://cagismaps.hamilton-co.org/PropertyActivity/cagisreport

Data Created By: CAGIS

Refresh Frequency: Daily

Data Dictionary: A data dictionary providing definitions of columns and attributes is available as an attachment to this dataset.

Processing: The City of Cincinnati is committed to providing the most granular and accurate data possible. In that pursuit the Office of Performance and Data Analytics facilitates standard processing to most raw data prior to publication. Processing includes but is not limited: address verification, geocoding, decoding attributes, and addition of administrative areas (i.e. Census, neighborhoods, police districts, etc.).

Data Usage: For directions on downloading and using open data please visit our How-to Guide: https://data.cincinnati-oh.gov/dataset/Open-Data-How-To-Guide/gdr9-g3ad

Data Description: Emergency Communications Center Calls are records captured for each call. The call data does not contain the nature of the emergency or dispatched resources. For dispatch data reference Police Calls for Service (CAD) or Cincinnati Fire Incidents (CAD).

Data Creation: This dataset includes both emergency (911) and administrative calls to the center. To obtain just emergency (911) calls filter for Call Type ID = 911 CALLS.

Data Created By: The source of this data is the City of Cincinnati's Call System provided by West Communications.

Refresh Frequency: This dataset updates weekly on Fridays.

CincyInsights: The City of Cincinnati maintains an interactive dashboard portal, CincyInsights in addition to our Open Data in an effort to increase access and usage of city data. This data set has an associated dashboard available here: https://insights.cincinnati-oh.gov/stories/s/snnn-n6ic

Data Dictionary: A data dictionary providing definitions of columns and attributes is available as an attachment to this dataset.

Processing: The City of Cincinnati is committed to providing the most granular and accurate data possible. In that pursuit the Office of Performance and Data Analytics facilitates standard processing to most raw data prior to publication. Processing includes but is not limited: address verification, geocoding, decoding attributes, and addition of administrative areas (i.e. Census, neighborhoods, police districts, etc.).

Data Usage: For directions on downloading and using open data please visit our How-to Guide: https://data.cincinnati-oh.gov/dataset/Open-Data-How-To-Guide/gdr9-g3ad

Disclaimer: In compliance with privacy laws, all Public Safety datasets are anonymized and appropriately redacted prior to publication on the City of Cincinnati’s Open Data Portal. This means that for all public safety datasets: (1) the last two digits of all addresses have been replaced with “XX,” and in cases where there is a single digit street address, the entire address number is replaced with "X"; and (2) Latitude and Longitude have been randomly skewed to represent values within the same block area (but not the exact location) of the incident.

Data Description: In July 2018, the City of Cincinnati launched an emergency communication tool, Smart911, that provides 9-1-1 call takers and first responders with additional critical information about participating residents. This technology helps reduce response times and provide first responders with vital information that can help improve incident outcomes. Through Smart911, residents can create a secure “Safety Profile” that will automatically display to emergency call takers immediately upon placing a 9-1-1 call. When a call comes in, a call taker will see a user’s Safety Profile as well as a Facility Profile about their current location. For more information on Smart911 please visit: https://www.cincinnati-oh.gov/cityofcincinnati/news/smart911-tech-now-available-in-cincinnati/
This data set contains the total amount of enrollments in Hamilton County from July 2018 to present. This data allows users to view total enrollment by web site, application or overall. Additionally, the data can be filtered to show enrollment by zip code or by week.

Data Creation: This data is created when individuals create a “Safety Profile” through Smart911.

Data Created By: The source of this data is Rave Mobile Safety and ECC.

Refresh Frequency: This data set is updated weekly.

CincyInsights: The City of Cincinnati maintains an interactive dashboard portal, CincyInsights in addition to our Open Data in an effort to increase access and usage of city data. This data set has an associated dashboard available here: https://insights.cincinnati-oh.gov/stories/s/snnn-n6ic

Data Dictionary: A data dictionary providing definitions of columns and attributes is available as an attachment to this dataset.

Processing: The City of Cincinnati is committed to providing the most granular and accurate data possible. In that pursuit the Office of Performance and Data Analytics facilitates standard processing to most raw data prior to publication. Processing includes but is not limited: address verification, geocoding, decoding attributes, and addition of administrative areas (i.e. Census, neighborhoods, police districts, etc.).

Data Usage: For directions on downloading and using open data please visit our How-to Guide: https://data.cincinnati-oh.gov/dataset/Open-Data-How-To-Guide/gdr9-g3ad

Date Range: August 2019 - November 2022
66,717 rows dropped due to incomplete data from RFID reader (2% of total rows in data set)

This data comes from RFID readers on recycling trucks that scan recycling carts which contain a unique RFID tag on each cart. Every time an RFID tag is read by the recycling truck a row is recorded in the data set. The account number in the data set is the account number that the cart belongs to. Each account number may have a varying number of carts.

The account number used by the recycling company is also an ID used in our databases for referring to addresses. In our address database each record has an account number (aka address_guid) and an addressid. The important thing to note is that some addressid's may have multiple account numbers (aka addr_guid's). For example, some condo complexes have an account number (aka addr_guid) for every unit in the complex. This does not mean that every building with multiple units will have multiple account numbers for each addressid.

The columns that contain information on the type of residence the address is have data that was pulled in November 2022. This may have implications when looking at historical data structure types. For example, an account number was a one family dwelling in 2019 but remodeled and reclassified as a 4-family dwelling in 2022. The records where this is the case however should be small.

The dataset contains tips from all recycling accounts, so commercial and municipal account tips will also appear in the dataset. This will need to be accounted for when analyzing and filters may need to be applied to look at specific groups such as residential single family dwellings.

Column Info:
ADDR_TYPE:
ADR = Address
BLD = Building
PAR = Parcel
CON = CONDO

Category:
Specifies if the address is classified as "Residential" or "Commercial" use for example.

Description:
A more granular description of the address for example Category could be "Residential" and Description could be "Single Family Dwelling"

Data Description: This data set contains records for recycling cart ‘tips.’ RFID tag readers record when a City of Cincinnati recycling cart is ‘tipped,’ meaning it is picked up/lifted by a recycling truck. The table contains all addresses in the City of Cincinnati and identifies addresses with a City of Cincinnati recycle bin, which are tracked by an RFIDTAG. The No of Tips Per Month field indicates how many time the recycling cart was ‘tipped’ in a given month.

Data Creation: Data generated by RFID tag readers when City of Cincinnati recycling cart is picked up/lifted by a recycling truck

Data Created By: Office of Environment and Sustainability

Refresh Frequency: Monthly

CincyInsights: The City of Cincinnati maintains an interactive dashboard portal, CincyInsights in addition to our Open Data in an effort to increase access and usage of city data. This data set has an associated dashboard available here:

Data Dictionary: A data dictionary providing definitions of columns and attributes is available as an attachment to this dataset.

Processing: The City of Cincinnati is committed to providing the most granular and accurate data possible. In that pursuit the Office of Performance and Data Analytics facilitates standard processing to most raw data prior to publication. Processing includes but is not limited: address verification, geocoding, decoding attributes, and addition of administrative areas (i.e. Census, neighborhoods, police districts, etc.).

Data Usage: For directions on downloading and using open data please visit our How-to Guide: https://data.cincinnati-oh.gov/dataset/Open-Data-How-To-Guide/gdr9-g3ad

*This information will not be updated while the vendor undergoes transfer to a new data management system.*

Data Description: Recycling Tip Data includes all carts issued through the Cincinnati recycling program and information regarding when the cart was picked up.

Data Creation: A record is created each time a recycling truck picks up an approved cart with an RFID tag.

Refresh Frequency: This information will not be updated while the vendor undergoes transfer to a new data management system.

CincyInsights: The City of Cincinnati maintains an interactive dashboard portal, CincyInsights in addition to our Open Data in an effort to increase access and usage of city data. This data set has an associated dashboard available here: https://insights.cincinnati-oh.gov/stories/s/gd3w-zpnu

Data Dictionary: A data dictionary providing definitions of columns and attributes is available as an attachment to this dataset.

Processing: The City of Cincinnati is committed to providing the most granular and accurate data possible. In that pursuit the Office of Performance and Data Analytics facilitates standard processing to most raw data prior to publication. Processing includes but is not limited: address verification, geocoding, decoding attributes, and addition of administrative areas (i.e. Census, neighborhoods, police districts, etc.).

Data Usage: For directions on downloading and using open data please visit our How-to Guide: https://data.cincinnati-oh.gov/dataset/Open-Data-How-To-Guide/gdr9-g3ad

Data Description: This data set contains records for recycling cart ‘tips.’ RFID tag readers record when a City of Cincinnati recycling cart is ‘tipped,’ meaning it is picked up/lifted by a recycling truck. The table contains all addresses in the City of Cincinnati and identifies addresses with a City of Cincinnati recycle bin, which are tracked by an RFIDTAG. The Cartlift field indicates how many time the recycling cart was ‘tipped’ in a given month.

Data Creation: Data generated by RFID tag readers when City of Cincinnati recycling cart is picked up/lifted by a recycling truck

Data Created By: Office of Environment and Sustainability

Refresh Frequency: Daily

CincyInsights: The City of Cincinnati maintains an interactive dashboard portal, CincyInsights in addition to our Open Data in an effort to increase access and usage of city data. This data set has an associated dashboard available here: https://insights.cincinnati-oh.gov/stories/s/gd3w-zpnu

Data Dictionary: A data dictionary providing definitions of columns and attributes is available as an attachment to this dataset.

Processing: The City of Cincinnati is committed to providing the most granular and accurate data possible. In that pursuit the Office of Performance and Data Analytics facilitates standard processing to most raw data prior to publication. Processing includes but is not limited: address verification, geocoding, decoding attributes, and addition of administrative areas (i.e. Census, neighborhoods, police districts, etc.).

Data Usage: For directions on downloading and using open data please visit our How-to Guide: https://data.cincinnati-oh.gov/dataset/Open-Data-How-To-Guide/gdr9-g3ad