Skip to content

Instantly share code, notes, and snippets.

View JasonThomasData's full-sized avatar
🐓
cluck cluck

Jason Thomas JasonThomasData

🐓
cluck cluck
View GitHub Profile
Data taken from Mother Jones' open database - http://www.motherjones.com/politics/2012/12/mass-shootings-mother-jones-full-data
Date,Victims,x,Trend,Trend formula
1996-01-01,6,1,16.23157895, =(b$21 * c2) + b$22
1997-01-01,14,2,19.32280702,...
1998-01-01,50,3,22.41403509,...
1999-01-01,91,4,25.50526316,...
2000-01-01,7,5,28.59649123,...
2001-01-01,9,6,31.6877193,...
2003-01-01,15,7,34.77894737,...
http://databank.worldbank.org/data/reports.aspx?source=2&country=&series=SG.GEN.PARL.ZS&period=
The latest Australian data matches with the most recent election - http://results.aec.gov.au/17496/Website/Default.htm
These are seats of parliament held by female politicians, and obviously don't inlcude Senators, which Australia has a higher proportion of.
Year,World,Australia
2004-01-01,15.9,24.7
2005-01-01,16.5,24.7
2006-01-01,17,24.7
2007-01-01,17.9,26.7
Medals
http://www.topendsports.com/world/countries/australia/events/olympics/medals.htm
http://corporate.olympics.com.au/olympian-search/aus-olympic-champions
Date,Swimming,Sailing,Cycling,Athletics,Rowing,Other
1980-01-01,2,0,0,0,0,0
1984-01-01,1,0,1,1,0,1
1988-01-01,1,0,0,1,0,1
1992-01-01,1,0,1,0,2,3
1996-01-01,2,0,0,0,2,5
CPI data calculated for each period by dividing each period by the original index price * 100
From ABS - http://www.abs.gov.au/AUSSTATS/abs@.nsf/DetailsPage/6401.0Mar%202016?OpenDocument
Period,Housing,All
Mar-1997,100,100
Jun-1997,96.74657534,99.70282318
Sep-1997,95.71917808,99.40564636
Dec-1997,94.00684932,99.70282318
Mar-1998,93.32191781,100.1485884
This data was provided to SBS by the Australian Shark Attack file in 2015, for the former 20 years.
This is not the same data as on the file, as incidents need to meet certain criteria to be included there.
2015 data - https://taronga.org.au/conservation/conservation-science-research/australian-shark-attack-file/2015
Day,Month,Year,Recovery Status,State,Location,Shark Common Name,Provoked,# of Sharks,Sex,Time of Attack,Victims Activity,Wounds Sustained,Provocative Act
1,2,1995,UNINJURED,VIC,"SEAL ROCKS, PHILLIP ISLAND",Sevengill Shark,Provoked,1,M,730,SCUBA DIVER,UNINJURED,COLECTING CRAYFISH
27,2,1995,INJURED,SA,"BOOMER BEACH, PORT ELLIOT",Wobbegong,Unprovoked,1,M,,SURFING ON BOARD,MINOR TEETH MARKS,
11,3,1995,INJURED,SA,CACTUS BEACH,White Shark,Unprovoked,1,M,730,SURFING ON BOARD,MINOR INJURY - STITCHES,
21,3,1995,UNINJURED,NSW,"CLARK ISLAND, SYDNEY HARBOUR",Bull Shark,Unprovoked,1,F,700,BOAT - SURF SKI,UNINJURED,
These details from this cocodile attack database - http://www.crocodile-attack.info/data/filter-simple?
The duplicates from this database were removed, but this is the original data.
Does not include the May 2016 Incident in QLD.
Details,Date,Location,Victim,Age,Outcome,Species,Size (m)
[view],1/01/2000,Malaysia,Male,,Non-Fatal,Saltwater Crocodile,
[view],24/01/2000,Malaysia,Female,10,Fatal,Saltwater Crocodile,
[view],1/02/2000,Mexico,Male,20,Non-Fatal,American Crocodile,
[view],8/02/2000,Australia,Female,8,Non-Fatal,Saltwater Crocodile,2.5
[view],1/03/2000,Myanmar,Female,14,Fatal,Saltwater Crocodile,
This file has been truncated, but you can view the full file.
This data from https://rsf.org/en/ranking_table
Combined with global country boundaries http://www.naturalearthdata.com/downloads/10m-cultural-vectors/10m-admin-0-countries/
{"type":"FeatureCollection","crs":{"type":"name","properties":{"name":"urn:ogc:def:crs:OGC:1.3:CRS84"}},"features":[
{"type":"Feature","geometry":null,"properties":{"ADMIN":"Aruba","rsf_pf_rank":null,"rsf_pf_abuse":null,"rsf_pf_underlying_situtation":null,"rsf_pf_global":null,"rsf_pf_color":null}},
{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[71.04980228700009,38.40866445000009],[71.08938643400012,38.409853007],[71.2176990160001,38.32582712800007],[71.3001229250001,38.29869700100011],[71.3343843990001,38.28066192700001],[71.36451176000008,38.206816305000046],[71.33453942900013,38.11167999300011],[71.27263106300012,37.997991842],[71.25578454600003,37.94988108300004],[71.25826501500012,37.92647165900007],[71.28182946800013,37.92499888100008],[71.34115401300005,37.89329539000008],[71.36099776200012,37.90202870700003],[71.
@JasonThomasData
JasonThomasData / australian-postcodes.sql
Created May 5, 2016 05:20 — forked from randomecho/australian-postcodes.sql
Australian postcodes (with states and suburb names) geocoded with latitude and longitude.
/*
Taken and cribbed from blog.datalicious.com/free-download-all-australian-postcodes-geocod
May contain errors where latitude and longitude are off. Use at own non-validated risk.
*/
SET NAMES utf8;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
DROP TABLE IF EXISTS postcodes_geo;
##This is from BOCSAR, NSW crime data people.
##Copy this and paste it into Excel.
##Split into colums with the 'Text to columns' option, and use comma as the delimeter
NSW Recorded Crime Statistics October 2010 to September 2015
Number of non-domestic violence related assault incidents recorded by the NSW Police Force as having occurred in Sydney City Local Area Command (LAC), Kings Cross Local Area Command (LAC)
Redfern Local Area Command (LAC), Newtown Local Area Command (LAC) or Greater Sydney Statistical Area by time of day and day of the week the incident occurred