Property Violations [Historical] | Last Updated 3 Jul 2022

This dataset is historical as of mid-2021. For current property violations, see

Tags: property, violations, property violations, code, code violations, historical data

This dataset has the following 23 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Property Violation IDidnumber
Case IDcase_idnumber
StatusstatustextThe status of the case is contained here. Cases can either be "Open" or "Closed". "Open" indicates that the violation has not been resolved.
Case Opened Datecase_openedcalendar_dateThis variable contains the date that the property violation case was opened.
Case Closed Datecase_closedcalendar_dateThis variable contains the date that the property violation case was marked as closed. If no date is present the case status is "Open".
Days Opendays_opennumberThe number of days a case has been opened. Cases that are still open are present and are updated daily. Closed cases will be a static, unchanging number. When looking only at closed cases the number of days open can be used to measure the number of days it took to resolve a case.
Violation Codeviolation_codetext
Violation Descriptionviolation_descriptiontextA brief text description of the violation is contained in this variable.
Ordinance NumberordinancetextThe Kansas City Ordinance outlining the legal definition of the violation.
Ordinance ChapterchapternumberOrdinances are cataloged according to chapter. The chapter is the first two digits of the value given in the "Ordinance Number" variable.
Violation Entry Dateviolation_entry_datecalendar_dateThe date that a violation was logged into the case. Cases may be open for several days before a violation is logged.
Zip Codezip_codenumber
KIVA PINpinnumberKIVA pins are a unique identified ursed by Kansas City to identify properties. You can use these pins at
Council Districtcouncil_districtnumber
Police Patrol Areapolice_districttext
Inspection Areainspection_areatext
NeighborhoodneighborhoodtextKansas City has defined neighborhood boundaries. This field contains the names of the neighborhood that a property violation is within.
Code Violation Locationmapping_locationlocationThis variable contains a geocoded address with a set of coordinates (latitude and longitude) that allow for code violations to be mapped.