SELECT stStateName,stCityName,stUrlSlug,stStateAbbr FROM tbl_states WHERE stStateName LIKE 'Colorado' AND stCityName LIKE 'Denver'