Digging into the Boston public Dataset can reveal interesting and juicy facts.
Even though there is nothing juicy about Bed bugs but the data about Boston open cases for Bed bugs is quite interesting and worth looking at.
We uploaded the entire 50 mb data dump which is around 500K rows into the Data Visualizer and filtered the category for Bed Bugs. Splitting the date into its date hierarchy components we then plotted the month on the Y axis.
It seems that the City of Boston started collecting this data around 2011 and has only partial data for that year.
Interestingly, the number of Bed bug cases seem to rise during the summer months.
Now if we break the lines into Quarters (we just add the quarter hierarchy to the mix)