opendata-fcgov/access-fort-collins-data-ckbp-tcy4
 
Readme
Updated 12 days ago
Indexed 3 hours ago

Access Fort Collins Data

Raw data from each Access Fort Collins case, submitted either by the public or via City Council.

Some questions are for informational purposes only and don't affect the rating or response; see column metadata for more details.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Date of Last Activity by Topic Changedate_of_last_activity_by_topicdate_of_last_activity_by_topicCalendar date
TopictopictopicTextSelected topic area
meta_row_idmeta_row_idmeta_row_idTextMetadata field for record hash. This field is a SHA-1 hash of all other fields in the record, used for validation of record uniqueness.
meta_row_indexmeta_row_indexmeta_row_indexNumberMetadata field for a suggested sort order. Sort this column in ascending order to order the dataset the way it was intended from the source system.
Outcome Areaoutcome_areaoutcome_areaTextAffected outcome area. This is only included on cases submitted via City Council.
Details of Last Activity by Topic Changedetails_of_last_activity_by_topicdetails_of_last_activity_by_topicText
ZoningzoningzoningTextThis value doesn't exist if the case location is not provided or is listed inaccurately
SubtopicsubtopicsubtopicTextWithin the topic, the selected subtopic area
Open Dateopen_dateopen_dateCalendar dateDate of case open
Close Dateclose_dateclose_dateCalendar dateDate of case closed
DepartmentdepartmentdepartmentTextAssigned department
Date of Last Activity by Status Changedate_of_last_activity_by_statusdate_of_last_activity_by_statusCalendar date
NeighborhoodneighborhoodneighborhoodTextThis value doesn't exist if the case location is not provided or is listed inaccurately
Request Submitted on Behalf of a Businessrequest_submitted_on_behalfrequest_submitted_on_behalfCheckboxSpecifies if this case was submitted on behalf of a business. This data is informational purposes only - an indication here doesn't affect the case's priority rating or response.
Case Numbercase_numbercase_numberNumberCase number in the Access Fort Collins system
Case Statuscase_statuscase_statusTextStatus of the case as of the Updated Date of this dataset. Records are updated for the prior 3 months (e.g. an update in June will update data for March-May).
Details of Last Activity by Status Changedetails_of_last_activity_by_statusdetails_of_last_activity_by_statusText
Service Areaservice_areaservice_areaTextAssigned service area. This is only included on cases submitted via City Council.
Council Districtcouncil_districtcouncil_districtNumberThis value doesn't exist if the case location is not provided or is listed inaccurately
Channel Reportchannel_reportchannel_reportTextInternal or public (online) origination of the case request
Upstream Metadata