Brush Collection Tuesday South

data.kcmo.org | Last Updated 23 Jan 2019

This data set contains call record data from the 311 call center in Kansas City, MO. This dataset used to be published under the name "KCMOPS311". This name was changed to make the dataset name more reflective of it's contents.

Tags: 311, service requests, bdkc, high value, kcmops311

This dataset has the following 30 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
CASE IDcase_idnumber
SOURCEsourcetext
DEPARTMENTdepartmenttext
WORK GROUPwork_grouptext
REQUEST TYPErequest_typetext
CATEGORYcategorytext
TYPEtypetext
DETAILdetailtext
CREATION DATEcreation_datecalendar_dateDate the case was created
CREATION TIMEcreation_timetext
CREATION MONTHcreation_monthnumber
CREATION YEARcreation_yearnumber
STATUSstatustext
EXCEEDED EST TIMEFRAMEexceeded_est_timeframetext
CLOSED DATEclosed_datecalendar_date
CLOSED MONTHclosed_monthnumber
CLOSED YEARclosed_yearnumber
DAYS TO CLOSEdays_to_closenumber
STREET ADDRESSstreet_addresstext
ADDRESS WITH GEOCODEaddress_with_geocodelocation
ZIP CODEzip_codetext
NEIGHBORHOODneighborhoodtext
COUNTYcountytext
COUNCIL DISTRICTcouncil_districtnumber
POLICE DISTRICTpolice_districttext
PARCEL ID NOparcel_id_nonumber
LATITUDEycoordinatenumber
LONGITUDExcoordinatenumber
CASE URLcase_urlurlHyperlink to actual case information
30-60-90 Days Open Windowdays_opennumberIf the column is blank the case is closed, 0 - case open less than 30 days, 30 - case open 31 to 60 days, 60 - case open 61 to 90 days, 90 - case open 91 days or more.