This dataset is historical as of mid-2021. For current property violations, see https://data.kcmo.org/Neighborhoods/Property-Violations-from-EnerGov/vq3e-m9ge
This dataset has the following 23 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Property Violation ID | id | number | 1040660 1031455 1084708 1003977 1023795 view top 100 | |
| Case ID | case_id | number | 0 2011128064 2010394776 2013030538 2010018892 view top 100 | |
| Status | status | text | The status of the case is contained here. Cases can either be "Open" or "Closed". "Open" indicates that the violation has not been resolved. | Closed Open view top 100 |
| Case Opened Date | case_opened | calendar_date | This variable contains the date that the property violation case was opened. | 2010-01-14T00:00:00.000 2012-08-16T00:00:00.000 2010-01-20T00:00:00.000 2010-01-13T00:00:00.000 2014-05-20T00:00:00.000 view top 100 |
| Case Closed Date | case_closed | calendar_date | This variable contains the date that the property violation case was marked as closed. If no date is present the case status is "Open". | 2021-07-19T00:00:00.000 2014-09-30T00:00:00.000 2021-07-16T00:00:00.000 2021-05-11T00:00:00.000 2014-09-25T00:00:00.000 view top 100 |
| Days Open | days_open | number | The 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. | 105 63 112 98 77 view top 100 |
| Violation Code | violation_code | text | NSWLTRASH NSWLWEED NSWLOPSTOR NSWLLIMBS NSEXTWAL06 view top 100 | |
| Violation Description | violation_description | text | A brief text description of the violation is contained in this variable. | LITTER, TRASH, REFUSE, AND RUBBISH RANK WEEDS OR UNATTENDED GROWTH UNAPPROVED STORAGE LIMBS AND BRUSH PEELING, CRACKED, BLISTERED PAINT view top 100 |
| Ordinance Number | ordinance | text | The Kansas City Ordinance outlining the legal definition of the violation. | 48-25 C.O. 48-30 C.O. 48-32 C.O. 56-132 (B) C.O. 56-133 C.O. view top 100 |
| Ordinance Chapter | chapter | number | Ordinances are cataloged according to chapter. The chapter is the first two digits of the value given in the "Ordinance Number" variable. | 48 56 64 62 27 view top 100 |
| Violation Entry Date | violation_entry_date | calendar_date | The date that a violation was logged into the case. Cases may be open for several days before a violation is logged. | 2013-01-29T00:00:00.000 2014-05-21T00:00:00.000 2011-08-30T00:00:00.000 2017-03-22T00:00:00.000 2015-09-22T00:00:00.000 view top 100 |
| Address | address | text | 717 MANHEIM RD 5800 Thompson Ave 2800 E 24th St 4900 Raytown Rd 515 Jackson Ave view top 100 | |
| County | county | text | Jackson Clay Platte CLAY JACKSON view top 100 | |
| State | state | text | MO view top 100 | |
| Zip Code | zip_code | number | 64130 64127 64132 64128 64123 view top 100 | |
| Latitude | latitude | number | 35.79752 39.06507 39.1081 39.11008 39.10974 view top 100 | |
| Longitude | longitude | number | -103.89058 -94.54985 -94.55174 -94.56572 -94.55119 view top 100 | |
| KIVA PIN | pin | number | KIVA pins are a unique identified ursed by Kansas City to identify properties. You can use these pins at http://kivaweb.kcmo.org/kivanet/2/index.cfm. | 0 49999 131938 46297 1966 view top 100 |
| Council District | council_district | number | 3 5 4 6 1 view top 100 | |
| Police Patrol Area | police_district | text | East Metro Central South Shoal Creek view top 100 | |
| Inspection Area | inspection_area | text | 20 129 18 119 30 view top 100 | |
| Neighborhood | neighborhood | text | Kansas City has defined neighborhood boundaries. This field contains the names of the neighborhood that a property violation is within. | South Indian Mound Scarritt Point Blue Hills Marlborough Heights/Marlborough Pride East Community Team South view top 100 |
| Code Violation Location | mapping_location | location | This variable contains a geocoded address with a set of coordinates (latitude and longitude) that allow for code violations to be mapped. | view top 100 |