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
This dataset has the following 31 columns:
Column Name | API Column Name | Data Type | Sample Values |
---|---|---|---|
PERMITNUM | permitnum | text | 2010P01248 2019P03931 2017P05582 2017P01643 2018P01227 view top 100 |
DESCRIPTION | description | text | HVAC Plumbing Permits Alteration Fire Protection Systems Repair view top 100 |
APPLIEDDATE | applieddate | calendar_date | 2010-03-17T00:00:00.000 2021-09-23T00:00:00.000 2020-08-03T00:00:00.000 2016-05-16T00:00:00.000 2020-06-18T00:00:00.000 view top 100 |
ISSUEDDATE | issueddate | calendar_date | 2020-08-19T00:00:00.000 2010-09-21T00:00:00.000 2019-12-10T00:00:00.000 2016-09-21T00:00:00.000 2017-12-21T00:00:00.000 view top 100 |
COMPLETEDDATE | completeddate | calendar_date | 2016-10-20T00:00:00.000 2013-04-19T00:00:00.000 2014-09-26T00:00:00.000 2016-04-11T00:00:00.000 2013-03-06T00:00:00.000 view top 100 |
ORIGINALADDRESS1 | originaladdress1 | text | 3333 BURNET AV 2139 AUBURN AV 511 WALNUT ST 312 WALNUT ST 3400 VINE ST view top 100 |
ORIGINALCITY | originalcity | text | CINCINNATI view top 100 |
ORIGINALSTATE | originalstate | text | OH view top 100 |
ORIGINALZIP | originalzip | text | 45202 45208 45206 45219 45209 view top 100 |
JURISDICTION | jurisdiction | text | CINCINNATI view top 100 |
PERMITCLASS | permitclass | text | RCO OBC Non-Standard Code Book view top 100 |
STATUSCURRENT | statuscurrent | text | CLOSED ISSUED WITHDRWN ROUTE EXPIRED view top 100 |
STATUSCURRENTMAPPED | statuscurrentmapped | text | Permit Finaled Permit Issued Permit Withdrawn In Review EXPIRED view top 100 |
WORKCLASS | workclass | text | CALT RR12 RRPL RNEW RALT view top 100 |
WORKCLASSMAPPED | workclassmapped | text | Existing New view top 100 |
PERMITTYPE | permittype | text | CBPCBCP CBPCPLGW CBPCMCHR CBPCWRC CBPCPLG view top 100 |
PERMITTYPEMAPPED | permittypemapped | text | HVAC Building Plumbing Permits Fire Protection Systems Excavation/Fill view top 100 |
COMPANYNAME | companyname | text | "OWNER" "RECKER AND BOERGER" "APOLLO HEATING & A/C" "STEVEN A. BOERGER" "PEOPLE WORKING COOPERATIVELY" view top 100 |
TOTALSQFT | totalsqft | text | 0 400 1200 2000 1800 view top 100 |
ESTPROJECTCOSTDEC | estprojectcostdec | text | 0 1000 5000 10000 2000 view top 100 |
UNITS | units | text | 1 0 2 4 3 view top 100 |
PIN | pin | text | "007700020244" "010400020052" "010400020011" "021600420138" "008400020001" view top 100 |
PROPOSEDUSE | proposeduse | text | "1-2-3 FM" "B" "R-2" "R-5" "A-2 (1)" view top 100 |
EXPIRESDATE | expiresdate | calendar_date | 2011-09-21T00:00:00.000 2021-08-19T00:00:00.000 2020-12-09T00:00:00.000 2020-06-06T00:00:00.000 2020-06-11T00:00:00.000 view top 100 |
COISSUEDDATE | coissueddate | calendar_date | 2019-12-20T00:00:00.000 2020-06-11T00:00:00.000 2015-01-08T00:00:00.000 2020-11-03T00:00:00.000 2020-04-17T00:00:00.000 view top 100 |
FEE | fee | number | 73.73 40.4 99.99 295.3 0 view top 100 |
LINK | link | text | http://cagis.hamilton-co.org/opal/apd.aspx?QSPerm=2010P01248 http://cagis.hamilton-co.org/opal/apd.aspx?QSPerm=2016P01131 http://cagis.hamilton-co.org/opal/apd.aspx?QSPerm=2017P01643 http://cagis.hamilton-co.org/opal/apd.aspx?QSPerm=2019P05691 http://cagis.hamilton-co.org/opal/apd.aspx?QSPerm=2017P05582 view top 100 |
LATITUDE | latitude | number | 39.141168567639134 39.101807494355086 39.12108386701925 39.099083723793385 39.14274024879595 view top 100 |
LONGITUDE | longitude | number | -84.5023815210294 -84.5117716984538 -84.5102006805373 -84.5106293954655 -84.5091623280725 view top 100 |
NEIGHBORHOOD | neighborhood | text | DOWNTOWN HYDE PARK OAKLEY OVER-THE-RHINE WESTWOOD view top 100 |
COMMUNITY COUNCIL NEIGHBORHOOD | community_council_neighborhood | text | view top 100 |