Collection

The Data source continued to be the 311 Complaints file sourced from WPRDC:

https://data.wprdc.org/dataset/311-data

What changed however was the the way in which the analysis was conducted. For instance, I found that while SQL increased the possibilities of use of data in analysis on Carto, I am not well versed enough (yet!) to be able to use it effectively. Hence I found data cleaning to be easier in Microsoft Excel. For instance, to better understand the time of day when 311 requests were made, it seemed easier to apply the 'IF' constraint on Excel than SQL.