Kirix Strata: Access and Manipulate Data from the Web

Kirix Strata: Access and Manipulate Data from the Web - this is quite cool, and it’s great to see a lot of data/stats/visualization stuff coming to the web these days. For their specific app though, it seems like it would have made more sense to act as a browser add-on for extracting the data, and not trying to add a browser and spreadsheet/database software at the same time. I know if I used this, I would generally copy everything over to Excel or other software rather than edit it within their app.

Canadian Election Analysis: Urban vs Rural

Talking about the urban-vs-rural divide in Canada and the US with my roommate yesterday; today I realized I could actually demonstrate it.

I scraped data from two websites: CBC and Elections Canada, since the latter doesn’t yet have election results. So here’s what I found:

population density vs vote scatterplots

What are you seeing here? Each point is a single riding. The x-axis shows population density. The y-axis shows the votes for that party as a percentage of the votes to the four major national parties (Liberal, Conservative, NDP, Green), and the scale is different for each. The Bloc Quebecois are not considered here, since they only participate in Quebec.

As you can see, this data seems to show that the Liberals weakly correlate with high population density, and the Conservatives correlate strongly with low population density. I tried making similar graphs using the logarithm of population density, but that didn’t reveal anything differently.

There’s quite a lot more that can be done with the data I used, you can find it all in this Excel file.

Google Code: Web Authoring Statistics

Google Code: Web Authoring Statistics - excellent stats from Google on HTML usage. There are so many times that I have wanted this. I have, however, made use somewhat more basic stats on RSS from Syndic8.