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
This dataset has the following 22 columns:
Column Name | API Column Name | Data Type | Sample Values |
---|---|---|---|
UNIQUEID | uniqueid | number | 153125 439709 149955 154047 337714 view top 100 |
WORK_TYPE | work_type | text | INSPECTION view top 100 |
DISPLAY_AGENCY | display_agency | text | Cincinnati Fire Dept Hamilton County Public Health Cincinnati Planning and Building Cincinnati Buildings and Inspections Cincinnati Trade and Development view top 100 |
NUMBER_KEY | number_key | text | P199900355 HSWI070080 HPSI100329 HSWC070119 HSWI070092 view top 100 |
COMP_TYPE | comp_type | text | CFDSPEC HHTPOOLI CBHDNS CBECERT CBESAFE view top 100 |
COMP_TYPE_DESC | comp_type_desc | text | CFD Annual Inspections and SRs Swimming Pool SPA INSP Dept. of Community Dev.- Survey Inspection Elevator Certificate Elevator Safety Test view top 100 |
SUB_TYPE | sub_type | text | ANNUAL-C P STANDARD 6MONTH FIRE_ESC view top 100 |
SUB_TYPE_DESC | sub_type_desc | text | ANNUAL COMMERCIAL-NO LICENSE Standard PASSENGER ELEV 6 MONTH ON-GOING INSPECTION Residential New Building view top 100 |
ENTERED_DATE | entered_date | calendar_date | 1999-09-28T00:00:00.000 2016-07-07T00:00:00.000 2016-07-08T00:00:00.000 2012-07-04T00:00:00.000 2011-08-12T00:00:00.000 view top 100 |
DATA_STATUS | data_status | text | CLOSE-NO ISSUED NEW ABAT-OWN CLOSED view top 100 |
STATUS_CLASS | status_class | text | CLOS OPEN view top 100 |
CITY_ID | city_id | text | CINC GREE COLE ANDE MIAM view top 100 |
X_COORD | x_coord | number | 1400868 1398240 1398710 1403536 1396180 view top 100 |
Y_COORD | y_coord | number | 418326 414664 422087 422543 429416 view top 100 |
URL | url | text | http://cagismaps.hamilton-co.org/propertyactivity/cagisreport?APD=P199900355 http://cagismaps.hamilton-co.org/propertyactivity/cagisreport?APD=HSWI070080 http://cagismaps.hamilton-co.org/propertyactivity/cagisreport?APD=HPSI100329 http://cagismaps.hamilton-co.org/propertyactivity/cagisreport?APD=HSWC070119 http://cagismaps.hamilton-co.org/propertyactivity/cagisreport?APD=HSWC070117 view top 100 |
LAST_UPDATED | last_updated | calendar_date | 2020-02-12T00:00:00.000 2022-06-17T00:00:00.000 2015-05-13T00:00:00.000 2011-08-12T00:00:00.000 2013-05-31T00:00:00.000 view top 100 |
YN_ACTIVITY_REPORT | yn_activity_report | text | N Y view top 100 |
LATITUDE | latitude | number | 39.131296244493 39.1210838667842 39.1417820921913 39.1427402485361 39.163329460162 view top 100 |
LONGITUDE | longitude | number | -84.5012259060858 -84.5102006802249 -84.4921152281107 -84.5091623276032 -84.4076834537405 view top 100 |
NEIGHBORHOOD | neighborhood | text | COUNTY DOWNTOWN WESTWOOD AVONDALE OVER-THE-RHINE view top 100 |
FULL_ADDRESS | full_address | text | 3333 BURNET AV 3400 VINE ST 375 DIXMYTH AV 2139 AUBURN AV 3418 READING RD view top 100 |
CITY_COUNTY | city_county | text | CITY CNTY view top 100 |