Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Dataset used in "Aggregate Operations in R with data.table" blog post. Derives from nzcathist dataset found in CASdatasets package.
YEAR QUARTER TYPE LOCATION LOSS_AMT_ORIG LOSS_AMT_2014
2014 4 Power outage Auckland 18065.72 19977.66
2014 2 Flood Nelson, Tasman 18065.72 19977.66
2014 2 Weather North and South Islands 18065.72 19977.66
2014 2 Flood, Storm NA 18065.72 19977.66
2014 1 Cyclone NA 18065.72 19977.66
2014 1 Storm Canterbury 18065.72 19977.66
2014 1 Storm Canterbury and Lower North Island 18065.72 19977.66
2013 4 Storm Nationwide 18065.72 19977.66
2013 3 Storm Nationwide 18065.72 19977.66
2013 3 Earthquake Cook Strait 18065.72 19977.66
2013 3 Earthquake Cook Strait 18065.72 19977.66
2013 2 Storm Nationwide 18065.72 19977.66
2013 2 Flood North Island 18065.72 19977.66
2013 2 Flood, Storm Nelson,Bay of Plenty 18065.72 19977.66
2012 4 Tornado Auckland 18065.72 19977.66
2011 1 Earthquake Canterbury 18065.72 19977.66
2011 1 Flood, Storm Nelson,Bay of Plenty 18065.72 19977.66
2011 2 Flood Hawkes Bay 18065.72 19977.66
2011 1 Flood Mid-Upper North Island 18065.72 19977.66
2011 2 Tornado Taranaki 18065.72 19977.66
2011 4 Flood Nelson 18065.72 19977.66
2011 2 Tornado Auckland 18065.72 19977.66
2010 2 Flood North, South Islands 18065.72 19977.66
2010 3 Storm Southland 18065.72 19977.66
2010 4 Flood Gisborne 18065.72 19977.66
2010 1 Storm Wellington 18065.72 19977.66
2010 2 Flood Northland,Coromandel,Eastern BOP 18065.72 19977.66
2009 3 Tornado Taranaki 18065.72 19977.66
2009 3 Earthquake Fiordland 18065.72 19977.66
2009 3 Storm North Island 18065.72 19977.66
2009 2 Hailstorm Bay of Plenty 18065.72 19977.66
2009 3 Tornado Kaitaia 18065.72 19977.66
2008 3 Storm Nationwide 18065.72 19977.66
2008 3 Flood North Canterbury and Marlborough 18065.72 19977.66
2008 3 Storm North Island 18065.72 19977.66
2008 3 Earthquake Hastings 18065.72 19977.66
2008 4 Tornado Cambridge 18065.72 19977.66
2008 4 Hailstorm Canterbury 18065.72 19977.66
2007 1 Storm Far North 18065.72 19977.66
2007 2 Flood Nelson , New Plymouth 18065.72 19977.66
2007 4 Other Central North and Lower South Islands 18065.72 19977.66
2007 4 Earthquake Gisborne 18065.72 19977.66
2007 3 Flood Hawkes Bay 18065.72 19977.66
2007 3 Storm Far North , Auckland , Coromandel 18065.72 19977.66
2007 3 Other Otago , Canterbury 18065.72 19977.66
2007 3 Tornado Tornado events 18065.72 19977.66
2006 2 Flood Oamaru , Dunedin 18065.72 19977.66
2006 2 Storm North , South Islands 18065.72 19977.66
2006 4 Storm Mid to Upper North Island 18065.72 19977.66
2006 3 Flood, Storm Wellington, Manawatu, Wairarapa 18065.72 19977.66
2005 1 Other Haumoana H,B, 18065.72 19977.66
2005 1 Flood Lower North Island 18065.72 19977.66
2005 1 Storm Bay of Plenty 18065.72 19977.66
2005 4 Flood Gisborne,East Cape 18065.72 19977.66
2005 1 Hailstorm Christchurch 18065.72 19977.66
2005 2 Other BOP Tauranga , Matata 18065.72 19977.66
2005 1 Tornado Greymouth 18065.72 19977.66
2005 1 Storm Dunedin 18065.72 19977.66
2005 1 Flood Wellington Region 18065.72 19977.66
2004 1 Storm North Island 18065.72 19977.66
2004 4 Flood Hawkes Bay 18065.72 19977.66
2004 3 Flood Eastern Bay of Plenty Floods 18065.72 19977.66
2004 3 Storm North and South Islands 18065.72 19977.66
2004 1 Storm Lower North Island 18065.72 19977.66
2004 2 Hailstorm Wanganui 18065.72 19977.66
2003 2 Flood, Storm Lower North Island 18065.72 19977.66
2003 4 Flood, Storm North , South Islands 18065.72 19977.66
2002 2 Flood, Storm North Island 18065.72 19977.66
2002 1 Flood Dunedin 18065.72 19977.66
2002 1 Flood Canterbury 18065.72 19977.66
2002 1 Flood Wellington , Wairarapa 18065.72 19977.66
2002 1 Hailstorm Canterbury 18065.72 19977.66
2001 4 Flood Wellington , Wairarapa 18065.72 19977.66
2001 1 Hailstorm Masterton 18065.72 19977.66
2001 4 Storm North Island 18065.72 19977.66
2000 3 Weather North Island 18065.72 19977.66
2000 4 Storm Canterbury 18065.72 19977.66
2000 2 Flood Tauranga , Eastern Bay of Plenty 18065.72 19977.66
2000 3 Flood Auckland , Coromandel 18065.72 19977.66
1999 1 Flood Northland , Pukekohe 18065.72 19977.66
1999 2 Flood Dargaville 18065.72 19977.66
1999 3 Storm South Canterbury 18065.72 19977.66
1999 2 Flood Whangarei , Rotorua 18065.72 19977.66
1999 4 Flood Queenstown Lakes District 18065.72 19977.66
1998 4 Storm North , South Islands 18065.72 19977.66
1998 4 Storm Upper North Island 18065.72 19977.66
1998 4 Storm North , South Islands Storms 18065.72 19977.66
1998 2 Power outage Mercury 18065.72 19977.66
1998 3 Flood, Storm North , South Island 18065.72 19977.66
1997 2 Flood Northland 18065.72 19977.66
1997 3 Flood Auckland 18065.72 19977.66
1997 3 Flood Coromandel 18065.72 19977.66
1997 2 Flood Auckland 18065.72 19977.66
1997 1 Storm South Island 18065.72 19977.66
1997 4 Storm South Island 18065.72 19977.66
1997 4 Hailstorm Southland , Otago 18065.72 19977.66
1997 1 Cyclone NA 18065.72 19977.66
1997 2 Flood Wairoa 18065.72 19977.66
1997 4 Storm North , South Island 18065.72 19977.66
1996 4 Cyclone NA 18065.72 19977.66
1996 3 Weather NA 18065.72 19977.66
1996 4 Weather NA 18065.72 19977.66
1995 1 Flood Whangarei , District 18065.72 19977.66
1995 2 Flood New Plymouth 18065.72 19977.66
1995 3 Flood Thames , Kaiaua 18065.72 19977.66
1995 3 Flood North , South Island 18065.72 19977.66
1994 1 Hailstorm Hastings 18065.72 19977.66
1994 1 Flood South Canterbury 18065.72 19977.66
1994 4 Flood, Storm North , South 18065.72 19977.66
1993 4 Flood Kaikoura 18065.72 19977.66
1992 1 Tornado Auckland 18065.72 19977.66
1992 3 Storm Canterbury 18065.72 19977.66
1991 1 Tornado Albany 18065.72 19977.66
1991 1 Flood Otago 18065.72 19977.66
1990 3 Flood Taranaki , Wanganui 18065.72 19977.66
1988 3 Flood Manawatu 18065.72 19977.66
1988 1 Cyclone NA 18065.72 19977.66
1988 3 Flood Greymouth 18065.72 19977.66
1988 2 Flood Greymouth 18065.72 19977.66
1987 1 Earthquake Bay of Plenty 18065.72 19977.66
1986 1 Flood Auckland 18065.72 19977.66
1986 1 Flood Nelson 18065.72 19977.66
1986 1 Flood North Otago , South Canterbury 18065.72 19977.66
1985 1 Other Thames , Coromandel , Te Aroha 18065.72 19977.66
1985 1 Other Wellington , Hutt Valley 18065.72 19977.66
1985 1 Flood Auckland 18065.72 19977.66
1985 1 Other Chatham 18065.72 19977.66
1985 1 Flood Gisborne 18065.72 19977.66
1985 1 Other Hawkes Bay , Wairarapa 18065.72 19977.66
1985 2 Other South Auckland 18065.72 19977.66
1984 1 Flood Greymouth 18065.72 19977.66
1984 1 Flood Auckland 18065.72 19977.66
1984 1 Flood Invercargill , Southland 18065.72 19977.66
1983 1 Storm Christchurch 18065.72 19977.66
1983 1 Flood Marlborough , Golden Bay 18065.72 19977.66
1981 1 Flood Keri Keri 18065.72 19977.66
1981 2 Flood Thames , Coromandel , Paeroa 18065.72 19977.66
1980 1 Flood South Island 18065.72 19977.66
1980 2 Flood Taieri , Otago , New Plymouth 18065.72 19977.66
1980 3 Tornado Onehunga 18065.72 19977.66
1978 4 Flood Otago 18065.72 19977.66
1976 1 Flood Wellington , Hutt Valley 18065.72 19977.66
1975 3 Storm Canterbury 18065.72 19977.66
1968 1 Storm Wahine 18065.72 19977.66
1968 1 Other Wahine 18065.72 19977.66
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.