Skip to content

Instantly share code, notes, and snippets.

View harkanwals's full-sized avatar
🎯
Focusing

Harkanwal harkanwals

🎯
Focusing
35 followers · 164 following
  • Auckland, New Zealand
View GitHub Profile
@harkanwals
harkanwals / crashes_17.csv
Created June 1, 2018 12:40
nz_crashes
We can't make this file beautiful and searchable because it's too large.
lng,lat
175.68592181028342,-37.561026204986725
176.18711602077855,-37.656371977845744
171.9382801638338,-43.90524025424106
174.91467471257795,-41.20750652292337
174.806325454025,-41.22426372329549
172.6581434172231,-43.535448567797474
170.05768527861858,-43.44782693170241
170.50785528364457,-45.852187255150064
176.14159956649655,-37.79068833121704
@harkanwals
harkanwals / crashes.csv
Created June 1, 2018 13:19
nz_crashes
We can't make this file beautiful and searchable because it's too large.
lng,lat
174.88882728622,-36.960424173400334
173.8129554352325,-35.425810683352466
175.60004721377987,-37.94722121033722
175.85976343285049,-38.93878466112252
176.70067996622245,-38.08406335490036
174.6149648180305,-36.36824149023421
175.82701255299324,-38.48364473833039
174.76161767371602,-36.85790622492376
176.16456191529113,-37.69072186900747
@harkanwals
harkanwals / gist:f02dad98a302d0db3ad7c03eedbf3d82
Created June 14, 2018 06:09
"Month","Auckland","Bay of Plenty","Canterbury","Gisborne","Hawke's Bay","Manawatu-Wanganui","Marlborough","National Total","Nelson","Northland","Otago","Southland","Taranaki","Tasman","Waikato","Wellington","West Coast"
1993-01-01,196,138,146,122,132,142,134,157,150,124,144,95,125,137,133,172,104
1993-02-01,196,139,151,123,136,140,128,161,151,123,161,101,121,139,133,178,94
1993-03-01,193,140,152,119,136,148,132,162,148,119,173,92,139,127,133,181,104
1993-04-01,195,137,145,122,137,142,130,160,152,122,158,95,128,137,131,176,107
1993-05-01,200,139,148,121,141,131,131,161,154,121,145,101,127,159,134,183,101
1993-06-01,194,139,148,122,140,138,127,160,155,121,138,102,128,144,135,180,103
1993-07-01,203,138,149,128,136,134,131,162,150,117,144,101,125,126,131,180,105
1993-08-01,200,141,144,128,142,130,131,160,152,121,148,99,132,145,131,174,109
1993-09-01,201,140,148,126,147,131,132,162,152,121,147,104,128,145,133,177,97
@harkanwals
harkanwals / region-mean-rents.csv
Created June 14, 2018 06:11
Month Auckland Bay of Plenty Canterbury Gisborne Hawke's Bay Manawatu-Wanganui Marlborough National Total Nelson Northland Otago Southland Taranaki Tasman Waikato Wellington West Coast
1993-01-01 196 138 146 122 132 142 134 157 150 124 144 95 125 137 133 172 104
1993-02-01 196 139 151 123 136 140 128 161 151 123 161 101 121 139 133 178 94
1993-03-01 193 140 152 119 136 148 132 162 148 119 173 92 139 127 133 181 104
1993-04-01 195 137 145 122 137 142 130 160 152 122 158 95 128 137 131 176 107
1993-05-01 200 139 148 121 141 131 131 161 154 121 145 101 127 159 134 183 101
1993-06-01 194 139 148 122 140 138 127 160 155 121 138 102 128 144 135 180 103
1993-07-01 203 138 149 128 136 134 131 162 150 117 144 101 125 126 131 180 105
1993-08-01 200 141 144 128 142 130 131 160 152 121 148 99 132 145 131 174 109
1993-09-01 201 140 148 126 147 131 132 162 152 121 147 104 128 145 133 177 97
@harkanwals
harkanwals / rents.csv
Created June 14, 2018 08:28
month region rent
1993-01-01 Auckland 196
1993-02-01 Auckland 196
1993-03-01 Auckland 193
1993-04-01 Auckland 195
1993-05-01 Auckland 200
1993-06-01 Auckland 194
1993-07-01 Auckland 203
1993-08-01 Auckland 200
1993-09-01 Auckland 201
@harkanwals
harkanwals / quarter_change.csv
Created June 14, 2018 13:39
region date change
Whangarei District 1994-03-31 0.8364333915328906
Kaipara District 1994-03-31 -11.1577950013541
Thames-Coromandel District 1994-03-31 7.932823081118211
Hauraki District 1994-03-31 1.607444008584863
Waikato District 1994-03-31 4.696201176854893
Matamata-Piako District 1994-03-31 -5.987084657518273
Hamilton City 1994-03-31 5.892729190304423
Waipa District 1994-03-31 1.4683581638272996
Otorohanga District 1994-03-31 27.040061254101015
@harkanwals
harkanwals / quarter_change.csv
Created June 14, 2018 13:40
region date change
Whangarei District 1994-03-31 0
Kaipara District 1994-03-31 -0
Thames-Coromandel District 1994-03-31 0
Hauraki District 1994-03-31 0
Waikato District 1994-03-31 0
Matamata-Piako District 1994-03-31 -0
Hamilton City 1994-03-31 0
Waipa District 1994-03-31 0
Otorohanga District 1994-03-31 0
@harkanwals
harkanwals / quarterly_change.csv
Created June 14, 2018 13:42
region date change
Whangarei District 1994-03-31 0.836433
Kaipara District 1994-03-31 -11.1578
Thames-Coromandel District 1994-03-31 7.93282
Hauraki District 1994-03-31 1.60744
Waikato District 1994-03-31 4.6962
Matamata-Piako District 1994-03-31 -5.98708
Hamilton City 1994-03-31 5.89273
Waipa District 1994-03-31 1.46836
Otorohanga District 1994-03-31 27.0401
@harkanwals
harkanwals / quarterly_change.csv
Created June 14, 2018 13:48
region date change
Whangarei District 1994-03-31 0.836
Kaipara District 1994-03-31 -11.158
Thames-Coromandel District 1994-03-31 7.933
Hauraki District 1994-03-31 1.607
Waikato District 1994-03-31 4.696
Matamata-Piako District 1994-03-31 -5.987
Hamilton City 1994-03-31 5.893
Waipa District 1994-03-31 1.468
Otorohanga District 1994-03-31 27.04
@harkanwals
harkanwals / quarterly.csv
Created June 14, 2018 14:44
region date median change
Queenstown-Lakes District 2017-12-31 938139.662027833 3.957
Queenstown-Lakes District 2017-09-30 935650.924376103 6.121
Queenstown-Lakes District 2018-03-31 902500 5.021
Queenstown-Lakes District 2016-12-31 902430.524733034 27.565
Queenstown-Lakes District 2017-06-30 900548.25 5.481
Queenstown-Lakes District 2016-09-30 881685.62927262 30.755
Auckland 2016-12-31 878054.307758913 10.331
Auckland 2017-06-30 874515 1.818
Auckland 2017-12-31 874324.055666004 -0.425