Convert spacetime object to spacetime cube
Source:R/spacetime-cube-complete.R
complete_spacetime_cube.Rd
Given a spacetime object, convert it to a spacetime cube. A spacetime cube ensures that there is a regular time-series for each geometry present.
Details
If observations are missing for a time period and location combination, columns will be populated with NAs.
See is_spacetime_cube()
for more details on spacetime cubes.
Examples
df_fp <- system.file("extdata", "bos-ecometric.csv", package = "sfdep")
geo_fp <- system.file("extdata", "bos-ecometric.geojson", package = "sfdep")
# read in data
df <- read.csv(df_fp, colClasses = c("character", "character", "integer", "double", "Date"))
geo <- sf::st_read(geo_fp)
#> Reading layer `bos-ecometric' from data source
#> `/private/var/folders/zc/tg2xwck53dg9sls8x4ndzdc00000gn/T/Rtmp2RGXTr/temp_libpath2b6f5ea0db20/sfdep/extdata/bos-ecometric.geojson'
#> using driver `GeoJSON'
#> Simple feature collection with 168 features and 1 field
#> Geometry type: POLYGON
#> Dimension: XY
#> Bounding box: xmin: -71.19115 ymin: 42.22788 xmax: -70.99445 ymax: 42.3974
#> Geodetic CRS: NAD83
# Create spacetime object called `bos`
bos <- spacetime(df, geo,
.loc_col = ".region_id",
.time_col = "time_period")
# create a sample of data
set.seed(0)
sample_index <- sample(1:nrow(bos), nrow(bos) * 0.95)
incomplete_spt <- bos[sample_index,]
# check to see if is spacetime cube
is_spacetime_cube(incomplete_spt)
#> ! Number of rows does not equal `n time-periods x n locations`
#> [1] FALSE
# complete it again
complete_spacetime_cube(incomplete_spt)
#> ! Vars(s) `ecometric`, `year`, and `value` are missing 84, 84, and 84 value(s).
#> spacetime ────
#> Context:`data`
#> 168 locations `.region_id`
#> 10 time periods `time_period`
#> ── data context ────────────────────────────────────────────────────────────────
#> .region_id time_period ecometric year value
#> 1 25025000100 2010-01-01 <NA> NA NA
#> 2 25025000100 2011-01-01 Guns 2011 1.54
#> 3 25025000100 2012-01-01 Guns 2012 1.84
#> 4 25025000100 2013-01-01 Guns 2013 4.36
#> 5 25025000100 2014-01-01 Guns 2014 1.91
#> 6 25025000100 2015-01-01 Guns 2015 1.93
#> 7 25025000100 2016-01-01 Guns 2016 1.50
#> 8 25025000100 2017-01-01 Guns 2017 2.14
#> 9 25025000100 2018-01-01 Guns 2018 2.78
#> 10 25025000100 2019-01-01 Guns 2019 1.69
#> 11 25025000201 2010-01-01 Guns 2010 0.00
#> 12 25025000201 2011-01-01 Guns 2011 1.60
#> 13 25025000201 2012-01-01 Guns 2012 0.65
#> 14 25025000201 2013-01-01 Guns 2013 0.91
#> 15 25025000201 2014-01-01 Guns 2014 0.28
#> 16 25025000201 2015-01-01 Guns 2015 0.78
#> 17 25025000201 2016-01-01 Guns 2016 0.52
#> 18 25025000201 2017-01-01 Guns 2017 0.00
#> 19 25025000201 2018-01-01 Guns 2018 1.81
#> 20 25025000201 2019-01-01 Guns 2019 0.25
#> 21 25025000202 2010-01-01 Guns 2010 0.82
#> 22 25025000202 2011-01-01 Guns 2011 2.02
#> 23 25025000202 2012-01-01 Guns 2012 1.72
#> 24 25025000202 2013-01-01 Guns 2013 3.07
#> 25 25025000202 2014-01-01 Guns 2014 2.43
#> 26 25025000202 2015-01-01 <NA> NA NA
#> 27 25025000202 2016-01-01 Guns 2016 4.02
#> 28 25025000202 2017-01-01 Guns 2017 1.76
#> 29 25025000202 2018-01-01 Guns 2018 3.52
#> 30 25025000202 2019-01-01 Guns 2019 1.17
#> 31 25025000301 2010-01-01 Guns 2010 0.00
#> 32 25025000301 2011-01-01 Guns 2011 1.65
#> 33 25025000301 2012-01-01 Guns 2012 1.64
#> 34 25025000301 2013-01-01 Guns 2013 0.74
#> 35 25025000301 2014-01-01 Guns 2014 1.16
#> 36 25025000301 2015-01-01 Guns 2015 0.69
#> 37 25025000301 2016-01-01 Guns 2016 0.69
#> 38 25025000301 2017-01-01 Guns 2017 0.34
#> 39 25025000301 2018-01-01 Guns 2018 0.34
#> 40 25025000301 2019-01-01 Guns 2019 0.00
#> 41 25025000302 2010-01-01 Guns 2010 0.33
#> 42 25025000302 2011-01-01 Guns 2011 1.10
#> 43 25025000302 2012-01-01 Guns 2012 1.50
#> 44 25025000302 2013-01-01 Guns 2013 0.69
#> 45 25025000302 2014-01-01 Guns 2014 1.93
#> 46 25025000302 2015-01-01 Guns 2015 0.89
#> 47 25025000302 2016-01-01 Guns 2016 1.18
#> 48 25025000302 2017-01-01 Guns 2017 0.59
#> 49 25025000302 2018-01-01 Guns 2018 0.00
#> 50 25025000302 2019-01-01 <NA> NA NA
#> 51 25025000401 2010-01-01 Guns 2010 0.19
#> 52 25025000401 2011-01-01 Guns 2011 0.96
#> 53 25025000401 2012-01-01 Guns 2012 1.77
#> 54 25025000401 2013-01-01 Guns 2013 0.57
#> 55 25025000401 2014-01-01 Guns 2014 0.78
#> 56 25025000401 2015-01-01 Guns 2015 0.59
#> 57 25025000401 2016-01-01 Guns 2016 1.17
#> 58 25025000401 2017-01-01 Guns 2017 1.17
#> 59 25025000401 2018-01-01 Guns 2018 0.39
#> 60 25025000401 2019-01-01 Guns 2019 0.00
#> 61 25025000402 2010-01-01 Guns 2010 0.00
#> 62 25025000402 2011-01-01 Guns 2011 0.00
#> 63 25025000402 2012-01-01 Guns 2012 2.92
#> 64 25025000402 2013-01-01 Guns 2013 1.57
#> 65 25025000402 2014-01-01 Guns 2014 0.00
#> 66 25025000402 2015-01-01 Guns 2015 0.29
#> 67 25025000402 2016-01-01 Guns 2016 0.87
#> 68 25025000402 2017-01-01 Guns 2017 0.58
#> 69 25025000402 2018-01-01 Guns 2018 0.00
#> 70 25025000402 2019-01-01 Guns 2019 0.00
#> 71 25025000502 2010-01-01 Guns 2010 0.20
#> 72 25025000502 2011-01-01 Guns 2011 0.39
#> 73 25025000502 2012-01-01 Guns 2012 0.72
#> 74 25025000502 2013-01-01 Guns 2013 0.16
#> 75 25025000502 2014-01-01 Guns 2014 0.34
#> 76 25025000502 2015-01-01 Guns 2015 0.17
#> 77 25025000502 2016-01-01 Guns 2016 0.85
#> 78 25025000502 2017-01-01 Guns 2017 0.34
#> 79 25025000502 2018-01-01 Guns 2018 0.00
#> 80 25025000502 2019-01-01 Guns 2019 0.86
#> 81 25025000503 2010-01-01 Guns 2010 0.00
#> 82 25025000503 2011-01-01 Guns 2011 1.03
#> 83 25025000503 2012-01-01 Guns 2012 0.53
#> 84 25025000503 2013-01-01 Guns 2013 2.39
#> 85 25025000503 2014-01-01 Guns 2014 0.00
#> 86 25025000503 2015-01-01 Guns 2015 0.94
#> 87 25025000503 2016-01-01 Guns 2016 0.94
#> 88 25025000503 2017-01-01 Guns 2017 0.94
#> 89 25025000503 2018-01-01 Guns 2018 0.00
#> 90 25025000503 2019-01-01 Guns 2019 1.00
#> 91 25025000504 2010-01-01 Guns 2010 0.22
#> 92 25025000504 2011-01-01 Guns 2011 1.35
#> 93 25025000504 2012-01-01 Guns 2012 1.66
#> 94 25025000504 2013-01-01 Guns 2013 2.89
#> 95 25025000504 2014-01-01 Guns 2014 0.66
#> 96 25025000504 2015-01-01 Guns 2015 1.35
#> 97 25025000504 2016-01-01 Guns 2016 0.90
#> 98 25025000504 2017-01-01 Guns 2017 1.12
#> 99 25025000504 2018-01-01 Guns 2018 1.57
#> 100 25025000504 2019-01-01 Guns 2019 0.61
#> 101 25025000601 2010-01-01 Guns 2010 0.00
#> 102 25025000601 2011-01-01 Guns 2011 0.33
#> 103 25025000601 2012-01-01 Guns 2012 0.31
#> 104 25025000601 2013-01-01 Guns 2013 1.82
#> 105 25025000601 2014-01-01 Guns 2014 1.42
#> 106 25025000601 2015-01-01 Guns 2015 1.05
#> 107 25025000601 2016-01-01 Guns 2016 1.05
#> 108 25025000601 2017-01-01 Guns 2017 0.79
#> 109 25025000601 2018-01-01 Guns 2018 1.84
#> 110 25025000601 2019-01-01 Guns 2019 0.75
#> 111 25025000602 2010-01-01 Guns 2010 0.00
#> 112 25025000602 2011-01-01 Guns 2011 1.60
#> 113 25025000602 2012-01-01 Guns 2012 2.61
#> 114 25025000602 2013-01-01 Guns 2013 6.24
#> 115 25025000602 2014-01-01 Guns 2014 2.24
#> 116 25025000602 2015-01-01 Guns 2015 3.59
#> 117 25025000602 2016-01-01 Guns 2016 3.85
#> 118 25025000602 2017-01-01 Guns 2017 2.31
#> 119 25025000602 2018-01-01 Guns 2018 3.34
#> 120 25025000602 2019-01-01 Guns 2019 3.56
#> 121 25025000701 2010-01-01 Guns 2010 0.00
#> 122 25025000701 2011-01-01 Guns 2011 2.63
#> 123 25025000701 2012-01-01 Guns 2012 2.02
#> 124 25025000701 2013-01-01 Guns 2013 2.38
#> 125 25025000701 2014-01-01 Guns 2014 0.51
#> 126 25025000701 2015-01-01 Guns 2015 0.70
#> 127 25025000701 2016-01-01 Guns 2016 1.16
#> 128 25025000701 2017-01-01 Guns 2017 0.47
#> 129 25025000701 2018-01-01 Guns 2018 0.00
#> 130 25025000701 2019-01-01 Guns 2019 0.42
#> 131 25025000703 2010-01-01 Guns 2010 0.00
#> 132 25025000703 2011-01-01 Guns 2011 3.34
#> 133 25025000703 2012-01-01 Guns 2012 1.34
#> 134 25025000703 2013-01-01 Guns 2013 2.80
#> 135 25025000703 2014-01-01 Guns 2014 3.06
#> 136 25025000703 2015-01-01 Guns 2015 4.67
#> 137 25025000703 2016-01-01 Guns 2016 3.63
#> 138 25025000703 2017-01-01 Guns 2017 3.63
#> 139 25025000703 2018-01-01 Guns 2018 5.71
#> 140 25025000703 2019-01-01 Guns 2019 3.06
#> 141 25025000704 2010-01-01 Guns 2010 0.00
#> 142 25025000704 2011-01-01 Guns 2011 2.66
#> 143 25025000704 2012-01-01 Guns 2012 1.63
#> 144 25025000704 2013-01-01 Guns 2013 3.05
#> 145 25025000704 2014-01-01 Guns 2014 2.21
#> 146 25025000704 2015-01-01 Guns 2015 1.96
#> 147 25025000704 2016-01-01 Guns 2016 2.62
#> 148 25025000704 2017-01-01 Guns 2017 0.65
#> 149 25025000704 2018-01-01 Guns 2018 1.09
#> 150 25025000704 2019-01-01 Guns 2019 0.41
#> 151 25025000802 2010-01-01 Guns 2010 0.25
#> 152 25025000802 2011-01-01 Guns 2011 1.58
#> 153 25025000802 2012-01-01 Guns 2012 2.35
#> 154 25025000802 2013-01-01 Guns 2013 3.51
#> 155 25025000802 2014-01-01 Guns 2014 2.13
#> 156 25025000802 2015-01-01 Guns 2015 2.12
#> 157 25025000802 2016-01-01 Guns 2016 3.49
#> 158 25025000802 2017-01-01 Guns 2017 3.03
#> 159 25025000802 2018-01-01 Guns 2018 3.18
#> 160 25025000802 2019-01-01 Guns 2019 2.55
#> 161 25025000803 2010-01-01 Guns 2010 0.00
#> 162 25025000803 2011-01-01 Guns 2011 0.87
#> 163 25025000803 2012-01-01 Guns 2012 0.49
#> 164 25025000803 2013-01-01 Guns 2013 0.00
#> 165 25025000803 2014-01-01 Guns 2014 0.00
#> 166 25025000803 2015-01-01 Guns 2015 0.00
#> 167 25025000803 2016-01-01 Guns 2016 0.32
#> 168 25025000803 2017-01-01 Guns 2017 0.16
#> 169 25025000803 2018-01-01 Guns 2018 0.48
#> 170 25025000803 2019-01-01 Guns 2019 0.33
#> 171 25025010103 2010-01-01 Guns 2010 0.00
#> 172 25025010103 2011-01-01 Guns 2011 0.51
#> 173 25025010103 2012-01-01 Guns 2012 0.00
#> 174 25025010103 2013-01-01 Guns 2013 0.28
#> 175 25025010103 2014-01-01 Guns 2014 0.27
#> 176 25025010103 2015-01-01 Guns 2015 1.35
#> 177 25025010103 2016-01-01 Guns 2016 0.00
#> 178 25025010103 2017-01-01 Guns 2017 0.00
#> 179 25025010103 2018-01-01 Guns 2018 0.81
#> 180 25025010103 2019-01-01 Guns 2019 0.00
#> 181 25025010104 2010-01-01 Guns 2010 0.00
#> 182 25025010104 2011-01-01 Guns 2011 0.42
#> 183 25025010104 2012-01-01 Guns 2012 0.64
#> 184 25025010104 2013-01-01 Guns 2013 0.84
#> 185 25025010104 2014-01-01 Guns 2014 0.21
#> 186 25025010104 2015-01-01 Guns 2015 0.82
#> 187 25025010104 2016-01-01 Guns 2016 0.00
#> 188 25025010104 2017-01-01 Guns 2017 0.61
#> 189 25025010104 2018-01-01 Guns 2018 1.02
#> 190 25025010104 2019-01-01 <NA> NA NA
#> 191 25025010203 2010-01-01 Guns 2010 0.42
#> 192 25025010203 2011-01-01 Guns 2011 1.47
#> 193 25025010203 2012-01-01 Guns 2012 1.05
#> 194 25025010203 2013-01-01 Guns 2013 1.21
#> 195 25025010203 2014-01-01 Guns 2014 2.17
#> 196 25025010203 2015-01-01 Guns 2015 3.29
#> 197 25025010203 2016-01-01 Guns 2016 2.71
#> 198 25025010203 2017-01-01 Guns 2017 1.35
#> 199 25025010203 2018-01-01 Guns 2018 1.93
#> 200 25025010203 2019-01-01 Guns 2019 1.49
#> 201 25025010204 2010-01-01 Guns 2010 0.00
#> 202 25025010204 2011-01-01 Guns 2011 0.30
#> 203 25025010204 2012-01-01 Guns 2012 0.31
#> 204 25025010204 2013-01-01 Guns 2013 0.60
#> 205 25025010204 2014-01-01 Guns 2014 0.92
#> 206 25025010204 2015-01-01 Guns 2015 0.00
#> 207 25025010204 2016-01-01 Guns 2016 0.89
#> 208 25025010204 2017-01-01 Guns 2017 0.00
#> 209 25025010204 2018-01-01 Guns 2018 1.49
#> 210 25025010204 2019-01-01 <NA> NA NA
#> 211 25025010300 2010-01-01 Guns 2010 0.00
#> 212 25025010300 2011-01-01 Guns 2011 0.59
#> 213 25025010300 2012-01-01 Guns 2012 0.19
#> 214 25025010300 2013-01-01 <NA> NA NA
#> 215 25025010300 2014-01-01 Guns 2014 0.00
#> 216 25025010300 2015-01-01 Guns 2015 0.56
#> 217 25025010300 2016-01-01 Guns 2016 0.56
#> 218 25025010300 2017-01-01 Guns 2017 0.37
#> 219 25025010300 2018-01-01 Guns 2018 0.56
#> 220 25025010300 2019-01-01 Guns 2019 0.00
#> 221 25025010403 2010-01-01 Guns 2010 0.00
#> 222 25025010403 2011-01-01 Guns 2011 3.11
#> 223 25025010403 2012-01-01 Guns 2012 0.68
#> 224 25025010403 2013-01-01 Guns 2013 3.13
#> 225 25025010403 2014-01-01 Guns 2014 1.03
#> 226 25025010403 2015-01-01 Guns 2015 2.44
#> 227 25025010403 2016-01-01 Guns 2016 0.35
#> 228 25025010403 2017-01-01 Guns 2017 2.79
#> 229 25025010403 2018-01-01 Guns 2018 3.83
#> 230 25025010403 2019-01-01 Guns 2019 2.10
#> 231 25025010404 2010-01-01 Guns 2010 0.00
#> 232 25025010404 2011-01-01 Guns 2011 0.86
#> 233 25025010404 2012-01-01 Guns 2012 0.17
#> 234 25025010404 2013-01-01 Guns 2013 1.35
#> 235 25025010404 2014-01-01 Guns 2014 1.58
#> 236 25025010404 2015-01-01 Guns 2015 1.17
#> 237 25025010404 2016-01-01 Guns 2016 0.78
#> 238 25025010404 2017-01-01 Guns 2017 0.39
#> 239 25025010404 2018-01-01 Guns 2018 1.17
#> 240 25025010404 2019-01-01 Guns 2019 0.19
#> 241 25025010405 2010-01-01 Guns 2010 0.35
#> 242 25025010405 2011-01-01 Guns 2011 0.89
#> 243 25025010405 2012-01-01 Guns 2012 1.20
#> 244 25025010405 2013-01-01 Guns 2013 0.84
#> 245 25025010405 2014-01-01 Guns 2014 1.50
#> 246 25025010405 2015-01-01 <NA> NA NA
#> 247 25025010405 2016-01-01 Guns 2016 1.48
#> 248 25025010405 2017-01-01 Guns 2017 1.64
#> 249 25025010405 2018-01-01 Guns 2018 0.49
#> 250 25025010405 2019-01-01 Guns 2019 0.17
#> 251 25025010408 2010-01-01 Guns 2010 0.00
#> 252 25025010408 2011-01-01 Guns 2011 0.68
#> 253 25025010408 2012-01-01 Guns 2012 1.33
#> 254 25025010408 2013-01-01 Guns 2013 1.35
#> 255 25025010408 2014-01-01 Guns 2014 2.13
#> 256 25025010408 2015-01-01 Guns 2015 0.72
#> 257 25025010408 2016-01-01 Guns 2016 0.72
#> 258 25025010408 2017-01-01 Guns 2017 0.72
#> 259 25025010408 2018-01-01 Guns 2018 0.00
#> 260 25025010408 2019-01-01 Guns 2019 0.00
#> 261 25025010500 2010-01-01 Guns 2010 0.00
#> 262 25025010500 2011-01-01 Guns 2011 0.00
#> 263 25025010500 2012-01-01 Guns 2012 0.60
#> 264 25025010500 2013-01-01 Guns 2013 1.80
#> 265 25025010500 2014-01-01 <NA> NA NA
#> 266 25025010500 2015-01-01 Guns 2015 2.06
#> 267 25025010500 2016-01-01 Guns 2016 1.47
#> 268 25025010500 2017-01-01 Guns 2017 1.47
#> 269 25025010500 2018-01-01 Guns 2018 3.24
#> 270 25025010500 2019-01-01 Guns 2019 1.99
#> 271 25025010600 2010-01-01 Guns 2010 0.35
#> 272 25025010600 2011-01-01 Guns 2011 2.19
#> 273 25025010600 2012-01-01 Guns 2012 1.06
#> 274 25025010600 2013-01-01 Guns 2013 1.65
#> 275 25025010600 2014-01-01 Guns 2014 3.50
#> 276 25025010600 2015-01-01 Guns 2015 5.12
#> 277 25025010600 2016-01-01 Guns 2016 4.16
#> 278 25025010600 2017-01-01 Guns 2017 4.48
#> 279 25025010600 2018-01-01 Guns 2018 5.76
#> 280 25025010600 2019-01-01 Guns 2019 4.77
#> 281 25025010701 2010-01-01 Guns 2010 0.00
#> 282 25025010701 2011-01-01 <NA> NA NA
#> 283 25025010701 2012-01-01 Guns 2012 0.68
#> 284 25025010701 2013-01-01 <NA> NA NA
#> 285 25025010701 2014-01-01 Guns 2014 1.43
#> 286 25025010701 2015-01-01 Guns 2015 1.48
#> 287 25025010701 2016-01-01 Guns 2016 1.11
#> 288 25025010701 2017-01-01 Guns 2017 3.33
#> 289 25025010701 2018-01-01 Guns 2018 1.85
#> 290 25025010701 2019-01-01 Guns 2019 4.67
#> 291 25025010702 2010-01-01 Guns 2010 0.46
#> 292 25025010702 2011-01-01 Guns 2011 2.12
#> 293 25025010702 2012-01-01 Guns 2012 2.88
#> 294 25025010702 2013-01-01 Guns 2013 3.68
#> 295 25025010702 2014-01-01 Guns 2014 3.22
#> 296 25025010702 2015-01-01 Guns 2015 2.71
#> 297 25025010702 2016-01-01 Guns 2016 5.80
#> 298 25025010702 2017-01-01 Guns 2017 5.41
#> 299 25025010702 2018-01-01 Guns 2018 5.41
#> 300 25025010702 2019-01-01 Guns 2019 2.68
#> 301 25025010801 2010-01-01 Guns 2010 0.00
#> 302 25025010801 2011-01-01 Guns 2011 0.00
#> 303 25025010801 2012-01-01 Guns 2012 0.00
#> 304 25025010801 2013-01-01 Guns 2013 0.32
#> 305 25025010801 2014-01-01 Guns 2014 0.61
#> 306 25025010801 2015-01-01 Guns 2015 0.31
#> 307 25025010801 2016-01-01 Guns 2016 0.62
#> 308 25025010801 2017-01-01 Guns 2017 0.31
#> 309 25025010801 2018-01-01 Guns 2018 0.62
#> 310 25025010801 2019-01-01 Guns 2019 0.00
#> 311 25025010802 2010-01-01 Guns 2010 0.00
#> 312 25025010802 2011-01-01 Guns 2011 0.33
#> 313 25025010802 2012-01-01 Guns 2012 0.00
#> 314 25025010802 2013-01-01 Guns 2013 0.70
#> 315 25025010802 2014-01-01 Guns 2014 0.00
#> 316 25025010802 2015-01-01 Guns 2015 0.63
#> 317 25025010802 2016-01-01 Guns 2016 0.00
#> 318 25025010802 2017-01-01 Guns 2017 0.63
#> 319 25025010802 2018-01-01 Guns 2018 0.32
#> 320 25025010802 2019-01-01 Guns 2019 0.00
#> 321 25025020101 2010-01-01 Guns 2010 0.00
#> 322 25025020101 2011-01-01 Guns 2011 0.00
#> 323 25025020101 2012-01-01 Guns 2012 0.00
#> 324 25025020101 2013-01-01 Guns 2013 1.36
#> 325 25025020101 2014-01-01 Guns 2014 0.91
#> 326 25025020101 2015-01-01 Guns 2015 1.43
#> 327 25025020101 2016-01-01 Guns 2016 1.02
#> 328 25025020101 2017-01-01 Guns 2017 0.41
#> 329 25025020101 2018-01-01 Guns 2018 0.00
#> 330 25025020101 2019-01-01 Guns 2019 0.21
#> 331 25025020200 2010-01-01 Guns 2010 0.00
#> 332 25025020200 2011-01-01 Guns 2011 0.26
#> 333 25025020200 2012-01-01 Guns 2012 0.77
#> 334 25025020200 2013-01-01 Guns 2013 0.26
#> 335 25025020200 2014-01-01 Guns 2014 0.00
#> 336 25025020200 2015-01-01 Guns 2015 0.26
#> 337 25025020200 2016-01-01 Guns 2016 1.06
#> 338 25025020200 2017-01-01 Guns 2017 1.06
#> 339 25025020200 2018-01-01 Guns 2018 0.26
#> 340 25025020200 2019-01-01 Guns 2019 0.00
#> 341 25025020301 2010-01-01 Guns 2010 0.00
#> 342 25025020301 2011-01-01 Guns 2011 0.44
#> 343 25025020301 2012-01-01 Guns 2012 1.53
#> 344 25025020301 2013-01-01 Guns 2013 2.11
#> 345 25025020301 2014-01-01 Guns 2014 3.39
#> 346 25025020301 2015-01-01 Guns 2015 1.27
#> 347 25025020301 2016-01-01 Guns 2016 2.12
#> 348 25025020301 2017-01-01 Guns 2017 0.42
#> 349 25025020301 2018-01-01 <NA> NA NA
#> 350 25025020301 2019-01-01 Guns 2019 0.46
#> 351 25025020302 2010-01-01 <NA> NA NA
#> 352 25025020302 2011-01-01 Guns 2011 2.49
#> 353 25025020302 2012-01-01 Guns 2012 0.00
#> 354 25025020302 2013-01-01 Guns 2013 2.01
#> 355 25025020302 2014-01-01 Guns 2014 0.99
#> 356 25025020302 2015-01-01 Guns 2015 0.95
#> 357 25025020302 2016-01-01 Guns 2016 0.00
#> 358 25025020302 2017-01-01 Guns 2017 3.80
#> 359 25025020302 2018-01-01 Guns 2018 0.00
#> 360 25025020302 2019-01-01 Guns 2019 1.02
#> 361 25025020303 2010-01-01 Guns 2010 0.00
#> 362 25025020303 2011-01-01 Guns 2011 1.60
#> 363 25025020303 2012-01-01 Guns 2012 0.86
#> 364 25025020303 2013-01-01 Guns 2013 2.24
#> 365 25025020303 2014-01-01 Guns 2014 1.35
#> 366 25025020303 2015-01-01 Guns 2015 2.10
#> 367 25025020303 2016-01-01 Guns 2016 1.31
#> 368 25025020303 2017-01-01 Guns 2017 2.88
#> 369 25025020303 2018-01-01 Guns 2018 2.36
#> 370 25025020303 2019-01-01 Guns 2019 2.09
#> 371 25025030100 2010-01-01 Guns 2010 0.00
#> 372 25025030100 2011-01-01 Guns 2011 0.99
#> 373 25025030100 2012-01-01 Guns 2012 0.46
#> 374 25025030100 2013-01-01 <NA> NA NA
#> 375 25025030100 2014-01-01 Guns 2014 0.91
#> 376 25025030100 2015-01-01 Guns 2015 0.44
#> 377 25025030100 2016-01-01 Guns 2016 0.44
#> 378 25025030100 2017-01-01 Guns 2017 0.44
#> 379 25025030100 2018-01-01 Guns 2018 1.33
#> 380 25025030100 2019-01-01 Guns 2019 0.43
#> 381 25025030200 2010-01-01 Guns 2010 0.00
#> 382 25025030200 2011-01-01 Guns 2011 0.00
#> 383 25025030200 2012-01-01 Guns 2012 0.00
#> 384 25025030200 2013-01-01 Guns 2013 1.15
#> 385 25025030200 2014-01-01 Guns 2014 0.59
#> 386 25025030200 2015-01-01 Guns 2015 1.18
#> 387 25025030200 2016-01-01 Guns 2016 1.18
#> 388 25025030200 2017-01-01 Guns 2017 1.77
#> 389 25025030200 2018-01-01 Guns 2018 1.77
#> 390 25025030200 2019-01-01 Guns 2019 1.65
#> 391 25025030300 2010-01-01 Guns 2010 0.19
#> 392 25025030300 2011-01-01 Guns 2011 1.85
#> 393 25025030300 2012-01-01 Guns 2012 0.92
#> 394 25025030300 2013-01-01 Guns 2013 2.18
#> 395 25025030300 2014-01-01 Guns 2014 2.70
#> 396 25025030300 2015-01-01 Guns 2015 4.84
#> 397 25025030300 2016-01-01 Guns 2016 3.94
#> 398 25025030300 2017-01-01 Guns 2017 3.58
#> 399 25025030300 2018-01-01 Guns 2018 3.40
#> 400 25025030300 2019-01-01 Guns 2019 3.06
#> 401 25025030400 2010-01-01 Guns 2010 0.00
#> 402 25025030400 2011-01-01 Guns 2011 0.42
#> 403 25025030400 2012-01-01 Guns 2012 0.39
#> 404 25025030400 2013-01-01 Guns 2013 0.00
#> 405 25025030400 2014-01-01 Guns 2014 1.41
#> 406 25025030400 2015-01-01 Guns 2015 0.73
#> 407 25025030400 2016-01-01 Guns 2016 0.73
#> 408 25025030400 2017-01-01 Guns 2017 0.36
#> 409 25025030400 2018-01-01 Guns 2018 0.36
#> 410 25025030400 2019-01-01 Guns 2019 0.37
#> 411 25025030500 2010-01-01 Guns 2010 0.00
#> 412 25025030500 2011-01-01 Guns 2011 0.00
#> 413 25025030500 2012-01-01 Guns 2012 0.74
#> 414 25025030500 2013-01-01 Guns 2013 0.38
#> 415 25025030500 2014-01-01 Guns 2014 0.00
#> 416 25025030500 2015-01-01 Guns 2015 0.39
#> 417 25025030500 2016-01-01 <NA> NA NA
#> 418 25025030500 2017-01-01 Guns 2017 0.39
#> 419 25025030500 2018-01-01 Guns 2018 0.39
#> 420 25025030500 2019-01-01 Guns 2019 0.40
#> 421 25025040100 2010-01-01 Guns 2010 0.00
#> 422 25025040100 2011-01-01 Guns 2011 0.88
#> 423 25025040100 2012-01-01 Guns 2012 0.43
#> 424 25025040100 2013-01-01 Guns 2013 1.67
#> 425 25025040100 2014-01-01 Guns 2014 1.20
#> 426 25025040100 2015-01-01 Guns 2015 0.41
#> 427 25025040100 2016-01-01 Guns 2016 0.81
#> 428 25025040100 2017-01-01 Guns 2017 0.81
#> 429 25025040100 2018-01-01 Guns 2018 0.41
#> 430 25025040100 2019-01-01 Guns 2019 0.41
#> 431 25025040200 2010-01-01 Guns 2010 1.61
#> 432 25025040200 2011-01-01 Guns 2011 1.70
#> 433 25025040200 2012-01-01 Guns 2012 3.66
#> 434 25025040200 2013-01-01 Guns 2013 4.35
#> 435 25025040200 2014-01-01 Guns 2014 4.17
#> 436 25025040200 2015-01-01 Guns 2015 1.04
#> 437 25025040200 2016-01-01 Guns 2016 2.60
#> 438 25025040200 2017-01-01 Guns 2017 2.60
#> 439 25025040200 2018-01-01 Guns 2018 3.12
#> 440 25025040200 2019-01-01 Guns 2019 2.45
#> 441 25025040300 2010-01-01 Guns 2010 0.48
#> 442 25025040300 2011-01-01 Guns 2011 2.64
#> 443 25025040300 2012-01-01 Guns 2012 2.39
#> 444 25025040300 2013-01-01 Guns 2013 3.47
#> 445 25025040300 2014-01-01 Guns 2014 5.75
#> 446 25025040300 2015-01-01 Guns 2015 2.39
#> 447 25025040300 2016-01-01 Guns 2016 0.48
#> 448 25025040300 2017-01-01 Guns 2017 0.95
#> 449 25025040300 2018-01-01 Guns 2018 1.67
#> 450 25025040300 2019-01-01 Guns 2019 1.11
#> 451 25025040401 2010-01-01 Guns 2010 0.35
#> 452 25025040401 2011-01-01 Guns 2011 1.17
#> 453 25025040401 2012-01-01 Guns 2012 0.80
#> 454 25025040401 2013-01-01 Guns 2013 2.38
#> 455 25025040401 2014-01-01 Guns 2014 2.30
#> 456 25025040401 2015-01-01 Guns 2015 1.45
#> 457 25025040401 2016-01-01 Guns 2016 2.18
#> 458 25025040401 2017-01-01 Guns 2017 2.18
#> 459 25025040401 2018-01-01 <NA> NA NA
#> 460 25025040401 2019-01-01 Guns 2019 0.68
#> 461 25025040600 2010-01-01 Guns 2010 0.00
#> 462 25025040600 2011-01-01 Guns 2011 0.35
#> 463 25025040600 2012-01-01 Guns 2012 1.05
#> 464 25025040600 2013-01-01 Guns 2013 2.44
#> 465 25025040600 2014-01-01 Guns 2014 0.00
#> 466 25025040600 2015-01-01 Guns 2015 1.30
#> 467 25025040600 2016-01-01 Guns 2016 1.95
#> 468 25025040600 2017-01-01 Guns 2017 1.62
#> 469 25025040600 2018-01-01 Guns 2018 2.27
#> 470 25025040600 2019-01-01 Guns 2019 1.96
#> 471 25025040801 2010-01-01 Guns 2010 0.58
#> 472 25025040801 2011-01-01 Guns 2011 3.69
#> 473 25025040801 2012-01-01 Guns 2012 1.68
#> 474 25025040801 2013-01-01 Guns 2013 7.08
#> 475 25025040801 2014-01-01 Guns 2014 4.11
#> 476 25025040801 2015-01-01 Guns 2015 2.90
#> 477 25025040801 2016-01-01 Guns 2016 5.13
#> 478 25025040801 2017-01-01 Guns 2017 3.12
#> 479 25025040801 2018-01-01 Guns 2018 4.68
#> 480 25025040801 2019-01-01 Guns 2019 1.83
#> 481 25025050101 2010-01-01 Guns 2010 0.19
#> 482 25025050101 2011-01-01 Guns 2011 1.52
#> 483 25025050101 2012-01-01 <NA> NA NA
#> 484 25025050101 2013-01-01 Guns 2013 1.09
#> 485 25025050101 2014-01-01 Guns 2014 2.94
#> 486 25025050101 2015-01-01 Guns 2015 1.68
#> 487 25025050101 2016-01-01 Guns 2016 1.31
#> 488 25025050101 2017-01-01 Guns 2017 1.31
#> 489 25025050101 2018-01-01 Guns 2018 3.17
#> 490 25025050101 2019-01-01 Guns 2019 1.80
#> 491 25025050200 2010-01-01 Guns 2010 0.20
#> 492 25025050200 2011-01-01 Guns 2011 1.83
#> 493 25025050200 2012-01-01 Guns 2012 2.01
#> 494 25025050200 2013-01-01 Guns 2013 1.32
#> 495 25025050200 2014-01-01 Guns 2014 2.55
#> 496 25025050200 2015-01-01 Guns 2015 1.80
#> 497 25025050200 2016-01-01 Guns 2016 1.80
#> 498 25025050200 2017-01-01 Guns 2017 1.14
#> 499 25025050200 2018-01-01 Guns 2018 1.47
#> 500 25025050200 2019-01-01 Guns 2019 0.71
#> 501 25025050300 2010-01-01 Guns 2010 0.00
#> 502 25025050300 2011-01-01 Guns 2011 1.37
#> 503 25025050300 2012-01-01 Guns 2012 2.54
#> 504 25025050300 2013-01-01 Guns 2013 5.60
#> 505 25025050300 2014-01-01 Guns 2014 6.07
#> 506 25025050300 2015-01-01 Guns 2015 7.87
#> 507 25025050300 2016-01-01 Guns 2016 6.56
#> 508 25025050300 2017-01-01 Guns 2017 5.68
#> 509 25025050300 2018-01-01 Guns 2018 4.37
#> 510 25025050300 2019-01-01 Guns 2019 1.61
#> 511 25025050400 2010-01-01 Guns 2010 0.00
#> 512 25025050400 2011-01-01 Guns 2011 3.02
#> 513 25025050400 2012-01-01 Guns 2012 1.60
#> 514 25025050400 2013-01-01 Guns 2013 3.28
#> 515 25025050400 2014-01-01 Guns 2014 1.17
#> 516 25025050400 2015-01-01 Guns 2015 1.95
#> 517 25025050400 2016-01-01 Guns 2016 4.30
#> 518 25025050400 2017-01-01 Guns 2017 1.17
#> 519 25025050400 2018-01-01 Guns 2018 2.73
#> 520 25025050400 2019-01-01 Guns 2019 1.21
#> 521 25025050500 2010-01-01 <NA> NA NA
#> 522 25025050500 2011-01-01 <NA> NA NA
#> 523 25025050500 2012-01-01 Guns 2012 0.91
#> 524 25025050500 2013-01-01 Guns 2013 0.87
#> 525 25025050500 2014-01-01 Guns 2014 0.81
#> 526 25025050500 2015-01-01 Guns 2015 0.00
#> 527 25025050500 2016-01-01 Guns 2016 0.80
#> 528 25025050500 2017-01-01 Guns 2017 0.40
#> 529 25025050500 2018-01-01 <NA> NA NA
#> 530 25025050500 2019-01-01 Guns 2019 0.43
#> 531 25025050600 2010-01-01 <NA> NA NA
#> 532 25025050600 2011-01-01 Guns 2011 1.22
#> 533 25025050600 2012-01-01 Guns 2012 1.26
#> 534 25025050600 2013-01-01 Guns 2013 2.62
#> 535 25025050600 2014-01-01 Guns 2014 2.36
#> 536 25025050600 2015-01-01 Guns 2015 3.74
#> 537 25025050600 2016-01-01 <NA> NA NA
#> 538 25025050600 2017-01-01 Guns 2017 0.42
#> 539 25025050600 2018-01-01 Guns 2018 0.83
#> 540 25025050600 2019-01-01 Guns 2019 2.02
#> 541 25025050700 2010-01-01 Guns 2010 0.00
#> 542 25025050700 2011-01-01 Guns 2011 0.62
#> 543 25025050700 2012-01-01 Guns 2012 1.01
#> 544 25025050700 2013-01-01 Guns 2013 1.69
#> 545 25025050700 2014-01-01 Guns 2014 1.83
#> 546 25025050700 2015-01-01 Guns 2015 0.89
#> 547 25025050700 2016-01-01 Guns 2016 0.89
#> 548 25025050700 2017-01-01 Guns 2017 0.89
#> 549 25025050700 2018-01-01 Guns 2018 0.72
#> 550 25025050700 2019-01-01 Guns 2019 0.36
#> 551 25025050901 2010-01-01 <NA> NA NA
#> 552 25025050901 2011-01-01 Guns 2011 1.83
#> 553 25025050901 2012-01-01 Guns 2012 2.42
#> 554 25025050901 2013-01-01 Guns 2013 1.27
#> 555 25025050901 2014-01-01 Guns 2014 2.34
#> 556 25025050901 2015-01-01 Guns 2015 1.99
#> 557 25025050901 2016-01-01 Guns 2016 3.32
#> 558 25025050901 2017-01-01 Guns 2017 2.21
#> 559 25025050901 2018-01-01 Guns 2018 2.43
#> 560 25025050901 2019-01-01 Guns 2019 1.52
#> 561 25025051000 2010-01-01 Guns 2010 0.23
#> 562 25025051000 2011-01-01 Guns 2011 0.92
#> 563 25025051000 2012-01-01 Guns 2012 0.86
#> 564 25025051000 2013-01-01 Guns 2013 0.66
#> 565 25025051000 2014-01-01 Guns 2014 0.90
#> 566 25025051000 2015-01-01 Guns 2015 0.86
#> 567 25025051000 2016-01-01 Guns 2016 0.64
#> 568 25025051000 2017-01-01 Guns 2017 1.50
#> 569 25025051000 2018-01-01 Guns 2018 0.64
#> 570 25025051000 2019-01-01 Guns 2019 0.41
#> 571 25025051101 2010-01-01 Guns 2010 0.31
#> 572 25025051101 2011-01-01 Guns 2011 1.89
#> 573 25025051101 2012-01-01 Guns 2012 1.41
#> 574 25025051101 2013-01-01 Guns 2013 2.01
#> 575 25025051101 2014-01-01 Guns 2014 1.97
#> 576 25025051101 2015-01-01 Guns 2015 1.78
#> 577 25025051101 2016-01-01 Guns 2016 0.96
#> 578 25025051101 2017-01-01 Guns 2017 2.46
#> 579 25025051101 2018-01-01 Guns 2018 0.68
#> 580 25025051101 2019-01-01 Guns 2019 1.20
#> 581 25025051200 2010-01-01 Guns 2010 0.47
#> 582 25025051200 2011-01-01 <NA> NA NA
#> 583 25025051200 2012-01-01 Guns 2012 1.94
#> 584 25025051200 2013-01-01 Guns 2013 1.48
#> 585 25025051200 2014-01-01 Guns 2014 2.70
#> 586 25025051200 2015-01-01 Guns 2015 1.38
#> 587 25025051200 2016-01-01 Guns 2016 1.73
#> 588 25025051200 2017-01-01 Guns 2017 0.69
#> 589 25025051200 2018-01-01 <NA> NA NA
#> 590 25025051200 2019-01-01 Guns 2019 0.69
#> 591 25025060101 2010-01-01 Guns 2010 0.00
#> 592 25025060101 2011-01-01 Guns 2011 1.10
#> 593 25025060101 2012-01-01 <NA> NA NA
#> 594 25025060101 2013-01-01 Guns 2013 0.26
#> 595 25025060101 2014-01-01 Guns 2014 1.11
#> 596 25025060101 2015-01-01 Guns 2015 1.10
#> 597 25025060101 2016-01-01 Guns 2016 0.28
#> 598 25025060101 2017-01-01 Guns 2017 0.00
#> 599 25025060101 2018-01-01 Guns 2018 0.28
#> 600 25025060101 2019-01-01 Guns 2019 0.57
#> 601 25025060200 2010-01-01 Guns 2010 0.00
#> 602 25025060200 2011-01-01 Guns 2011 0.95
#> 603 25025060200 2012-01-01 Guns 2012 0.89
#> 604 25025060200 2013-01-01 Guns 2013 0.00
#> 605 25025060200 2014-01-01 Guns 2014 0.83
#> 606 25025060200 2015-01-01 Guns 2015 0.00
#> 607 25025060200 2016-01-01 Guns 2016 0.00
#> 608 25025060200 2017-01-01 Guns 2017 0.86
#> 609 25025060200 2018-01-01 <NA> NA NA
#> 610 25025060200 2019-01-01 Guns 2019 0.44
#> 611 25025060301 2010-01-01 Guns 2010 0.33
#> 612 25025060301 2011-01-01 Guns 2011 0.97
#> 613 25025060301 2012-01-01 Guns 2012 0.63
#> 614 25025060301 2013-01-01 <NA> NA NA
#> 615 25025060301 2014-01-01 Guns 2014 0.29
#> 616 25025060301 2015-01-01 Guns 2015 1.40
#> 617 25025060301 2016-01-01 Guns 2016 0.56
#> 618 25025060301 2017-01-01 Guns 2017 0.00
#> 619 25025060301 2018-01-01 Guns 2018 0.84
#> 620 25025060301 2019-01-01 Guns 2019 0.00
#> 621 25025060400 2010-01-01 Guns 2010 0.00
#> 622 25025060400 2011-01-01 Guns 2011 0.40
#> 623 25025060400 2012-01-01 Guns 2012 0.19
#> 624 25025060400 2013-01-01 Guns 2013 0.56
#> 625 25025060400 2014-01-01 Guns 2014 0.90
#> 626 25025060400 2015-01-01 Guns 2015 0.53
#> 627 25025060400 2016-01-01 Guns 2016 0.35
#> 628 25025060400 2017-01-01 Guns 2017 0.71
#> 629 25025060400 2018-01-01 Guns 2018 1.06
#> 630 25025060400 2019-01-01 Guns 2019 1.06
#> 631 25025060501 2010-01-01 Guns 2010 0.00
#> 632 25025060501 2011-01-01 Guns 2011 0.81
#> 633 25025060501 2012-01-01 Guns 2012 0.79
#> 634 25025060501 2013-01-01 Guns 2013 1.48
#> 635 25025060501 2014-01-01 Guns 2014 0.97
#> 636 25025060501 2015-01-01 Guns 2015 1.43
#> 637 25025060501 2016-01-01 Guns 2016 0.71
#> 638 25025060501 2017-01-01 Guns 2017 0.95
#> 639 25025060501 2018-01-01 Guns 2018 1.19
#> 640 25025060501 2019-01-01 Guns 2019 0.25
#> 641 25025060600 2010-01-01 Guns 2010 0.00
#> 642 25025060600 2011-01-01 Guns 2011 2.44
#> 643 25025060600 2012-01-01 Guns 2012 0.39
#> 644 25025060600 2013-01-01 Guns 2013 2.99
#> 645 25025060600 2014-01-01 <NA> NA NA
#> 646 25025060600 2015-01-01 Guns 2015 1.24
#> 647 25025060600 2016-01-01 Guns 2016 1.86
#> 648 25025060600 2017-01-01 Guns 2017 3.11
#> 649 25025060600 2018-01-01 Guns 2018 2.49
#> 650 25025060600 2019-01-01 <NA> NA NA
#> 651 25025060700 2010-01-01 Guns 2010 0.00
#> 652 25025060700 2011-01-01 Guns 2011 2.12
#> 653 25025060700 2012-01-01 Guns 2012 6.14
#> 654 25025060700 2013-01-01 Guns 2013 3.13
#> 655 25025060700 2014-01-01 Guns 2014 5.07
#> 656 25025060700 2015-01-01 Guns 2015 9.53
#> 657 25025060700 2016-01-01 Guns 2016 3.81
#> 658 25025060700 2017-01-01 Guns 2017 21.34
#> 659 25025060700 2018-01-01 Guns 2018 15.62
#> 660 25025060700 2019-01-01 Guns 2019 3.06
#> 661 25025060800 2010-01-01 Guns 2010 0.00
#> 662 25025060800 2011-01-01 Guns 2011 0.67
#> 663 25025060800 2012-01-01 Guns 2012 0.66
#> 664 25025060800 2013-01-01 Guns 2013 1.76
#> 665 25025060800 2014-01-01 Guns 2014 0.45
#> 666 25025060800 2015-01-01 Guns 2015 3.20
#> 667 25025060800 2016-01-01 Guns 2016 1.83
#> 668 25025060800 2017-01-01 Guns 2017 3.43
#> 669 25025060800 2018-01-01 Guns 2018 4.12
#> 670 25025060800 2019-01-01 Guns 2019 1.62
#> 671 25025061000 2010-01-01 Guns 2010 0.30
#> 672 25025061000 2011-01-01 Guns 2011 0.60
#> 673 25025061000 2012-01-01 Guns 2012 2.47
#> 674 25025061000 2013-01-01 Guns 2013 3.45
#> 675 25025061000 2014-01-01 Guns 2014 1.91
#> 676 25025061000 2015-01-01 Guns 2015 3.64
#> 677 25025061000 2016-01-01 Guns 2016 3.04
#> 678 25025061000 2017-01-01 Guns 2017 10.02
#> 679 25025061000 2018-01-01 Guns 2018 6.68
#> 680 25025061000 2019-01-01 Guns 2019 2.79
#> 681 25025061101 2010-01-01 Guns 2010 0.91
#> 682 25025061101 2011-01-01 Guns 2011 3.34
#> 683 25025061101 2012-01-01 Guns 2012 5.29
#> 684 25025061101 2013-01-01 Guns 2013 5.54
#> 685 25025061101 2014-01-01 Guns 2014 6.33
#> 686 25025061101 2015-01-01 Guns 2015 11.49
#> 687 25025061101 2016-01-01 Guns 2016 12.37
#> 688 25025061101 2017-01-01 Guns 2017 11.93
#> 689 25025061101 2018-01-01 Guns 2018 10.16
#> 690 25025061101 2019-01-01 Guns 2019 9.57
#> 691 25025061200 2010-01-01 Guns 2010 0.59
#> 692 25025061200 2011-01-01 Guns 2011 1.54
#> 693 25025061200 2012-01-01 Guns 2012 3.18
#> 694 25025061200 2013-01-01 Guns 2013 4.51
#> 695 25025061200 2014-01-01 Guns 2014 2.05
#> 696 25025061200 2015-01-01 Guns 2015 3.52
#> 697 25025061200 2016-01-01 Guns 2016 1.64
#> 698 25025061200 2017-01-01 Guns 2017 3.28
#> 699 25025061200 2018-01-01 Guns 2018 6.10
#> 700 25025061200 2019-01-01 Guns 2019 3.90
#> 701 25025070101 2010-01-01 Guns 2010 0.36
#> 702 25025070101 2011-01-01 Guns 2011 3.04
#> 703 25025070101 2012-01-01 Guns 2012 2.73
#> 704 25025070101 2013-01-01 Guns 2013 7.06
#> 705 25025070101 2014-01-01 Guns 2014 6.76
#> 706 25025070101 2015-01-01 Guns 2015 7.08
#> 707 25025070101 2016-01-01 Guns 2016 8.93
#> 708 25025070101 2017-01-01 Guns 2017 10.62
#> 709 25025070101 2018-01-01 Guns 2018 9.08
#> 710 25025070101 2019-01-01 Guns 2019 5.09
#> 711 25025070200 2010-01-01 Guns 2010 0.19
#> 712 25025070200 2011-01-01 Guns 2011 3.26
#> 713 25025070200 2012-01-01 Guns 2012 3.30
#> 714 25025070200 2013-01-01 Guns 2013 2.10
#> 715 25025070200 2014-01-01 Guns 2014 2.66
#> 716 25025070200 2015-01-01 Guns 2015 2.36
#> 717 25025070200 2016-01-01 Guns 2016 2.54
#> 718 25025070200 2017-01-01 Guns 2017 4.00
#> 719 25025070200 2018-01-01 Guns 2018 3.45
#> 720 25025070200 2019-01-01 Guns 2019 2.67
#> 721 25025070300 2010-01-01 Guns 2010 0.45
#> 722 25025070300 2011-01-01 Guns 2011 0.91
#> 723 25025070300 2012-01-01 Guns 2012 0.22
#> 724 25025070300 2013-01-01 Guns 2013 1.61
#> 725 25025070300 2014-01-01 Guns 2014 0.44
#> 726 25025070300 2015-01-01 Guns 2015 1.12
#> 727 25025070300 2016-01-01 Guns 2016 1.12
#> 728 25025070300 2017-01-01 Guns 2017 2.69
#> 729 25025070300 2018-01-01 Guns 2018 1.35
#> 730 25025070300 2019-01-01 Guns 2019 1.34
#> 731 25025070402 2010-01-01 Guns 2010 0.00
#> 732 25025070402 2011-01-01 Guns 2011 3.49
#> 733 25025070402 2012-01-01 Guns 2012 1.81
#> 734 25025070402 2013-01-01 Guns 2013 0.00
#> 735 25025070402 2014-01-01 Guns 2014 2.11
#> 736 25025070402 2015-01-01 Guns 2015 2.72
#> 737 25025070402 2016-01-01 Guns 2016 2.27
#> 738 25025070402 2017-01-01 Guns 2017 2.27
#> 739 25025070402 2018-01-01 Guns 2018 2.72
#> 740 25025070402 2019-01-01 Guns 2019 1.25
#> 741 25025070500 2010-01-01 Guns 2010 0.16
#> 742 25025070500 2011-01-01 Guns 2011 2.79
#> 743 25025070500 2012-01-01 Guns 2012 3.86
#> 744 25025070500 2013-01-01 Guns 2013 6.76
#> 745 25025070500 2014-01-01 Guns 2014 7.30
#> 746 25025070500 2015-01-01 Guns 2015 6.94
#> 747 25025070500 2016-01-01 Guns 2016 7.79
#> 748 25025070500 2017-01-01 Guns 2017 2.88
#> 749 25025070500 2018-01-01 Guns 2018 2.20
#> 750 25025070500 2019-01-01 Guns 2019 3.29
#> 751 25025070600 2010-01-01 Guns 2010 0.00
#> 752 25025070600 2011-01-01 Guns 2011 1.30
#> 753 25025070600 2012-01-01 Guns 2012 1.68
#> 754 25025070600 2013-01-01 Guns 2013 2.15
#> 755 25025070600 2014-01-01 Guns 2014 2.41
#> 756 25025070600 2015-01-01 Guns 2015 3.59
#> 757 25025070600 2016-01-01 Guns 2016 2.39
#> 758 25025070600 2017-01-01 Guns 2017 0.40
#> 759 25025070600 2018-01-01 Guns 2018 1.20
#> 760 25025070600 2019-01-01 Guns 2019 2.34
#> 761 25025070700 2010-01-01 Guns 2010 0.00
#> 762 25025070700 2011-01-01 Guns 2011 2.49
#> 763 25025070700 2012-01-01 Guns 2012 1.34
#> 764 25025070700 2013-01-01 Guns 2013 3.37
#> 765 25025070700 2014-01-01 Guns 2014 2.19
#> 766 25025070700 2015-01-01 Guns 2015 1.08
#> 767 25025070700 2016-01-01 Guns 2016 2.52
#> 768 25025070700 2017-01-01 Guns 2017 1.08
#> 769 25025070700 2018-01-01 Guns 2018 2.52
#> 770 25025070700 2019-01-01 Guns 2019 2.19
#> 771 25025070800 2010-01-01 Guns 2010 0.27
#> 772 25025070800 2011-01-01 Guns 2011 3.51
#> 773 25025070800 2012-01-01 Guns 2012 3.25
#> 774 25025070800 2013-01-01 Guns 2013 4.30
#> 775 25025070800 2014-01-01 Guns 2014 6.44
#> 776 25025070800 2015-01-01 Guns 2015 4.06
#> 777 25025070800 2016-01-01 Guns 2016 1.45
#> 778 25025070800 2017-01-01 Guns 2017 1.45
#> 779 25025070800 2018-01-01 Guns 2018 3.19
#> 780 25025070800 2019-01-01 Guns 2019 2.24
#> 781 25025070900 2010-01-01 Guns 2010 0.67
#> 782 25025070900 2011-01-01 <NA> NA NA
#> 783 25025070900 2012-01-01 Guns 2012 4.99
#> 784 25025070900 2013-01-01 Guns 2013 3.17
#> 785 25025070900 2014-01-01 Guns 2014 8.24
#> 786 25025070900 2015-01-01 <NA> NA NA
#> 787 25025070900 2016-01-01 Guns 2016 7.75
#> 788 25025070900 2017-01-01 Guns 2017 10.11
#> 789 25025070900 2018-01-01 Guns 2018 2.36
#> 790 25025070900 2019-01-01 Guns 2019 5.70
#> 791 25025071101 2010-01-01 Guns 2010 1.79
#> 792 25025071101 2011-01-01 Guns 2011 8.60
#> 793 25025071101 2012-01-01 Guns 2012 7.70
#> 794 25025071101 2013-01-01 <NA> NA NA
#> 795 25025071101 2014-01-01 Guns 2014 11.08
#> 796 25025071101 2015-01-01 Guns 2015 10.03
#> 797 25025071101 2016-01-01 Guns 2016 12.90
#> 798 25025071101 2017-01-01 Guns 2017 12.90
#> 799 25025071101 2018-01-01 Guns 2018 12.66
#> 800 25025071101 2019-01-01 Guns 2019 9.79
#> 801 25025071201 2010-01-01 Guns 2010 0.34
#> 802 25025071201 2011-01-01 Guns 2011 5.11
#> 803 25025071201 2012-01-01 Guns 2012 1.79
#> 804 25025071201 2013-01-01 Guns 2013 1.77
#> 805 25025071201 2014-01-01 Guns 2014 1.72
#> 806 25025071201 2015-01-01 Guns 2015 2.79
#> 807 25025071201 2016-01-01 Guns 2016 5.59
#> 808 25025071201 2017-01-01 Guns 2017 2.51
#> 809 25025071201 2018-01-01 Guns 2018 2.79
#> 810 25025071201 2019-01-01 Guns 2019 3.75
#> 811 25025080100 2010-01-01 Guns 2010 1.67
#> 812 25025080100 2011-01-01 Guns 2011 5.97
#> 813 25025080100 2012-01-01 Guns 2012 6.63
#> 814 25025080100 2013-01-01 Guns 2013 15.28
#> 815 25025080100 2014-01-01 Guns 2014 8.66
#> 816 25025080100 2015-01-01 Guns 2015 11.75
#> 817 25025080100 2016-01-01 Guns 2016 18.72
#> 818 25025080100 2017-01-01 <NA> NA NA
#> 819 25025080100 2018-01-01 <NA> NA NA
#> 820 25025080100 2019-01-01 Guns 2019 12.27
#> 821 25025080300 2010-01-01 Guns 2010 4.15
#> 822 25025080300 2011-01-01 Guns 2011 10.81
#> 823 25025080300 2012-01-01 Guns 2012 9.76
#> 824 25025080300 2013-01-01 Guns 2013 23.18
#> 825 25025080300 2014-01-01 Guns 2014 18.80
#> 826 25025080300 2015-01-01 Guns 2015 19.64
#> 827 25025080300 2016-01-01 Guns 2016 12.38
#> 828 25025080300 2017-01-01 Guns 2017 17.51
#> 829 25025080300 2018-01-01 Guns 2018 12.38
#> 830 25025080300 2019-01-01 Guns 2019 8.62
#> 831 25025080401 2010-01-01 <NA> NA NA
#> 832 25025080401 2011-01-01 Guns 2011 5.11
#> 833 25025080401 2012-01-01 <NA> NA NA
#> 834 25025080401 2013-01-01 Guns 2013 10.35
#> 835 25025080401 2014-01-01 Guns 2014 14.06
#> 836 25025080401 2015-01-01 Guns 2015 16.82
#> 837 25025080401 2016-01-01 Guns 2016 15.53
#> 838 25025080401 2017-01-01 Guns 2017 21.03
#> 839 25025080401 2018-01-01 Guns 2018 11.32
#> 840 25025080401 2019-01-01 Guns 2019 10.11
#> 841 25025080500 2010-01-01 Guns 2010 1.52
#> 842 25025080500 2011-01-01 Guns 2011 12.63
#> 843 25025080500 2012-01-01 Guns 2012 14.64
#> 844 25025080500 2013-01-01 Guns 2013 14.30
#> 845 25025080500 2014-01-01 <NA> NA NA
#> 846 25025080500 2015-01-01 Guns 2015 12.17
#> 847 25025080500 2016-01-01 Guns 2016 13.77
#> 848 25025080500 2017-01-01 Guns 2017 9.93
#> 849 25025080500 2018-01-01 Guns 2018 4.16
#> 850 25025080500 2019-01-01 Guns 2019 5.29
#> 851 25025080601 2010-01-01 Guns 2010 0.59
#> 852 25025080601 2011-01-01 Guns 2011 5.32
#> 853 25025080601 2012-01-01 Guns 2012 6.04
#> 854 25025080601 2013-01-01 Guns 2013 7.71
#> 855 25025080601 2014-01-01 Guns 2014 8.62
#> 856 25025080601 2015-01-01 Guns 2015 14.31
#> 857 25025080601 2016-01-01 <NA> NA NA
#> 858 25025080601 2017-01-01 Guns 2017 11.54
#> 859 25025080601 2018-01-01 Guns 2018 6.46
#> 860 25025080601 2019-01-01 Guns 2019 6.30
#> 861 25025080801 2010-01-01 Guns 2010 0.58
#> 862 25025080801 2011-01-01 Guns 2011 11.00
#> 863 25025080801 2012-01-01 Guns 2012 6.50
#> 864 25025080801 2013-01-01 Guns 2013 9.68
#> 865 25025080801 2014-01-01 Guns 2014 9.77
#> 866 25025080801 2015-01-01 Guns 2015 12.24
#> 867 25025080801 2016-01-01 Guns 2016 7.79
#> 868 25025080801 2017-01-01 Guns 2017 10.68
#> 869 25025080801 2018-01-01 <NA> NA NA
#> 870 25025080801 2019-01-01 Guns 2019 6.20
#> 871 25025080900 2010-01-01 Guns 2010 0.58
#> 872 25025080900 2011-01-01 Guns 2011 3.21
#> 873 25025080900 2012-01-01 Guns 2012 2.67
#> 874 25025080900 2013-01-01 Guns 2013 2.87
#> 875 25025080900 2014-01-01 Guns 2014 3.22
#> 876 25025080900 2015-01-01 Guns 2015 2.11
#> 877 25025080900 2016-01-01 Guns 2016 2.38
#> 878 25025080900 2017-01-01 Guns 2017 2.64
#> 879 25025080900 2018-01-01 Guns 2018 0.53
#> 880 25025080900 2019-01-01 <NA> NA NA
#> 881 25025081001 2010-01-01 Guns 2010 0.67
#> 882 25025081001 2011-01-01 Guns 2011 1.25
#> 883 25025081001 2012-01-01 Guns 2012 1.49
#> 884 25025081001 2013-01-01 Guns 2013 2.19
#> 885 25025081001 2014-01-01 Guns 2014 2.92
#> 886 25025081001 2015-01-01 Guns 2015 5.41
#> 887 25025081001 2016-01-01 Guns 2016 4.21
#> 888 25025081001 2017-01-01 Guns 2017 2.00
#> 889 25025081001 2018-01-01 Guns 2018 2.80
#> 890 25025081001 2019-01-01 Guns 2019 3.12
#> 891 25025081100 2010-01-01 Guns 2010 0.00
#> 892 25025081100 2011-01-01 Guns 2011 2.19
#> 893 25025081100 2012-01-01 Guns 2012 2.85
#> 894 25025081100 2013-01-01 Guns 2013 2.34
#> 895 25025081100 2014-01-01 Guns 2014 4.33
#> 896 25025081100 2015-01-01 Guns 2015 2.90
#> 897 25025081100 2016-01-01 Guns 2016 4.35
#> 898 25025081100 2017-01-01 Guns 2017 7.01
#> 899 25025081100 2018-01-01 Guns 2018 3.14
#> 900 25025081100 2019-01-01 <NA> NA NA
#> 901 25025081200 2010-01-01 Guns 2010 0.57
#> 902 25025081200 2011-01-01 <NA> NA NA
#> 903 25025081200 2012-01-01 Guns 2012 11.90
#> 904 25025081200 2013-01-01 Guns 2013 16.06
#> 905 25025081200 2014-01-01 Guns 2014 11.42
#> 906 25025081200 2015-01-01 Guns 2015 24.60
#> 907 25025081200 2016-01-01 Guns 2016 20.69
#> 908 25025081200 2017-01-01 Guns 2017 20.69
#> 909 25025081200 2018-01-01 Guns 2018 12.30
#> 910 25025081200 2019-01-01 Guns 2019 15.01
#> 911 25025081300 2010-01-01 Guns 2010 0.58
#> 912 25025081300 2011-01-01 Guns 2011 10.41
#> 913 25025081300 2012-01-01 Guns 2012 5.21
#> 914 25025081300 2013-01-01 <NA> NA NA
#> 915 25025081300 2014-01-01 Guns 2014 12.26
#> 916 25025081300 2015-01-01 Guns 2015 14.89
#> 917 25025081300 2016-01-01 Guns 2016 14.35
#> 918 25025081300 2017-01-01 Guns 2017 13.46
#> 919 25025081300 2018-01-01 Guns 2018 10.95
#> 920 25025081300 2019-01-01 Guns 2019 8.26
#> 921 25025081400 2010-01-01 Guns 2010 0.74
#> 922 25025081400 2011-01-01 Guns 2011 5.10
#> 923 25025081400 2012-01-01 Guns 2012 2.74
#> 924 25025081400 2013-01-01 Guns 2013 5.94
#> 925 25025081400 2014-01-01 Guns 2014 6.17
#> 926 25025081400 2015-01-01 Guns 2015 6.51
#> 927 25025081400 2016-01-01 Guns 2016 7.88
#> 928 25025081400 2017-01-01 Guns 2017 11.30
#> 929 25025081400 2018-01-01 <NA> NA NA
#> 930 25025081400 2019-01-01 Guns 2019 7.14
#> 931 25025081500 2010-01-01 Guns 2010 0.00
#> 932 25025081500 2011-01-01 Guns 2011 7.06
#> 933 25025081500 2012-01-01 <NA> NA NA
#> 934 25025081500 2013-01-01 Guns 2013 6.41
#> 935 25025081500 2014-01-01 Guns 2014 7.58
#> 936 25025081500 2015-01-01 Guns 2015 5.30
#> 937 25025081500 2016-01-01 <NA> NA NA
#> 938 25025081500 2017-01-01 Guns 2017 5.30
#> 939 25025081500 2018-01-01 Guns 2018 11.01
#> 940 25025081500 2019-01-01 Guns 2019 7.65
#> 941 25025081700 2010-01-01 Guns 2010 0.87
#> 942 25025081700 2011-01-01 Guns 2011 9.46
#> 943 25025081700 2012-01-01 Guns 2012 15.42
#> 944 25025081700 2013-01-01 Guns 2013 21.58
#> 945 25025081700 2014-01-01 Guns 2014 17.33
#> 946 25025081700 2015-01-01 Guns 2015 15.46
#> 947 25025081700 2016-01-01 Guns 2016 14.43
#> 948 25025081700 2017-01-01 Guns 2017 14.43
#> 949 25025081700 2018-01-01 Guns 2018 8.24
#> 950 25025081700 2019-01-01 <NA> NA NA
#> 951 25025081800 2010-01-01 Guns 2010 2.22
#> 952 25025081800 2011-01-01 Guns 2011 12.99
#> 953 25025081800 2012-01-01 Guns 2012 9.06
#> 954 25025081800 2013-01-01 <NA> NA NA
#> 955 25025081800 2014-01-01 Guns 2014 12.84
#> 956 25025081800 2015-01-01 Guns 2015 10.18
#> 957 25025081800 2016-01-01 Guns 2016 10.18
#> 958 25025081800 2017-01-01 Guns 2017 13.01
#> 959 25025081800 2018-01-01 Guns 2018 9.90
#> 960 25025081800 2019-01-01 Guns 2019 6.59
#> 961 25025081900 2010-01-01 Guns 2010 1.04
#> 962 25025081900 2011-01-01 Guns 2011 11.21
#> 963 25025081900 2012-01-01 Guns 2012 13.37
#> 964 25025081900 2013-01-01 Guns 2013 21.91
#> 965 25025081900 2014-01-01 Guns 2014 17.31
#> 966 25025081900 2015-01-01 Guns 2015 16.07
#> 967 25025081900 2016-01-01 Guns 2016 18.33
#> 968 25025081900 2017-01-01 Guns 2017 10.71
#> 969 25025081900 2018-01-01 Guns 2018 7.61
#> 970 25025081900 2019-01-01 Guns 2019 11.73
#> 971 25025082000 2010-01-01 Guns 2010 0.00
#> 972 25025082000 2011-01-01 Guns 2011 13.75
#> 973 25025082000 2012-01-01 Guns 2012 12.50
#> 974 25025082000 2013-01-01 Guns 2013 11.01
#> 975 25025082000 2014-01-01 Guns 2014 9.91
#> 976 25025082000 2015-01-01 <NA> NA NA
#> 977 25025082000 2016-01-01 Guns 2016 11.70
#> 978 25025082000 2017-01-01 Guns 2017 7.91
#> 979 25025082000 2018-01-01 Guns 2018 5.85
#> 980 25025082000 2019-01-01 Guns 2019 6.16
#> 981 25025082100 2010-01-01 Guns 2010 1.00
#> 982 25025082100 2011-01-01 Guns 2011 10.76
#> 983 25025082100 2012-01-01 Guns 2012 5.59
#> 984 25025082100 2013-01-01 Guns 2013 14.69
#> 985 25025082100 2014-01-01 <NA> NA NA
#> 986 25025082100 2015-01-01 Guns 2015 8.71
#> 987 25025082100 2016-01-01 Guns 2016 12.79
#> 988 25025082100 2017-01-01 Guns 2017 14.08
#> 989 25025082100 2018-01-01 Guns 2018 7.04
#> 990 25025082100 2019-01-01 Guns 2019 7.30
#> 991 25025090100 2010-01-01 Guns 2010 1.82
#> 992 25025090100 2011-01-01 Guns 2011 8.39
#> 993 25025090100 2012-01-01 Guns 2012 8.38
#> 994 25025090100 2013-01-01 Guns 2013 18.91
#> 995 25025090100 2014-01-01 <NA> NA NA
#> 996 25025090100 2015-01-01 Guns 2015 12.73
#> 997 25025090100 2016-01-01 Guns 2016 15.36
#> 998 25025090100 2017-01-01 Guns 2017 11.72
#> 999 25025090100 2018-01-01 Guns 2018 12.33
#> 1000 25025090100 2019-01-01 Guns 2019 10.10
#> 1001 25025090200 2010-01-01 Guns 2010 2.04
#> 1002 25025090200 2011-01-01 Guns 2011 13.87
#> 1003 25025090200 2012-01-01 Guns 2012 14.25
#> 1004 25025090200 2013-01-01 Guns 2013 18.88
#> 1005 25025090200 2014-01-01 Guns 2014 15.72
#> 1006 25025090200 2015-01-01 Guns 2015 14.26
#> 1007 25025090200 2016-01-01 Guns 2016 17.52
#> 1008 25025090200 2017-01-01 Guns 2017 11.00
#> 1009 25025090200 2018-01-01 Guns 2018 11.41
#> 1010 25025090200 2019-01-01 <NA> NA NA
#> 1011 25025090300 2010-01-01 Guns 2010 0.31
#> 1012 25025090300 2011-01-01 Guns 2011 16.33
#> 1013 25025090300 2012-01-01 Guns 2012 7.95
#> 1014 25025090300 2013-01-01 Guns 2013 11.29
#> 1015 25025090300 2014-01-01 Guns 2014 12.36
#> 1016 25025090300 2015-01-01 Guns 2015 15.34
#> 1017 25025090300 2016-01-01 Guns 2016 13.28
#> 1018 25025090300 2017-01-01 Guns 2017 12.98
#> 1019 25025090300 2018-01-01 Guns 2018 6.49
#> 1020 25025090300 2019-01-01 Guns 2019 9.22
#> 1021 25025090400 2010-01-01 Guns 2010 2.46
#> 1022 25025090400 2011-01-01 Guns 2011 10.09
#> 1023 25025090400 2012-01-01 Guns 2012 15.82
#> 1024 25025090400 2013-01-01 Guns 2013 9.84
#> 1025 25025090400 2014-01-01 Guns 2014 6.19
#> 1026 25025090400 2015-01-01 Guns 2015 7.42
#> 1027 25025090400 2016-01-01 Guns 2016 5.34
#> 1028 25025090400 2017-01-01 Guns 2017 7.42
#> 1029 25025090400 2018-01-01 Guns 2018 7.66
#> 1030 25025090400 2019-01-01 Guns 2019 6.72
#> 1031 25025090600 2010-01-01 Guns 2010 1.39
#> 1032 25025090600 2011-01-01 Guns 2011 12.66
#> 1033 25025090600 2012-01-01 Guns 2012 10.00
#> 1034 25025090600 2013-01-01 Guns 2013 15.83
#> 1035 25025090600 2014-01-01 Guns 2014 15.11
#> 1036 25025090600 2015-01-01 <NA> NA NA
#> 1037 25025090600 2016-01-01 Guns 2016 9.83
#> 1038 25025090600 2017-01-01 Guns 2017 11.06
#> 1039 25025090600 2018-01-01 Guns 2018 6.96
#> 1040 25025090600 2019-01-01 Guns 2019 11.16
#> 1041 25025090700 2010-01-01 Guns 2010 0.24
#> 1042 25025090700 2011-01-01 <NA> NA NA
#> 1043 25025090700 2012-01-01 Guns 2012 2.20
#> 1044 25025090700 2013-01-01 Guns 2013 4.34
#> 1045 25025090700 2014-01-01 <NA> NA NA
#> 1046 25025090700 2015-01-01 Guns 2015 4.55
#> 1047 25025090700 2016-01-01 Guns 2016 4.79
#> 1048 25025090700 2017-01-01 Guns 2017 4.79
#> 1049 25025090700 2018-01-01 Guns 2018 3.59
#> 1050 25025090700 2019-01-01 Guns 2019 6.44
#> 1051 25025090901 2010-01-01 Guns 2010 0.00
#> 1052 25025090901 2011-01-01 Guns 2011 2.30
#> 1053 25025090901 2012-01-01 Guns 2012 1.89
#> 1054 25025090901 2013-01-01 Guns 2013 1.04
#> 1055 25025090901 2014-01-01 Guns 2014 2.30
#> 1056 25025090901 2015-01-01 Guns 2015 1.04
#> 1057 25025090901 2016-01-01 Guns 2016 1.82
#> 1058 25025090901 2017-01-01 Guns 2017 1.56
#> 1059 25025090901 2018-01-01 Guns 2018 1.82
#> 1060 25025090901 2019-01-01 <NA> NA NA
#> 1061 25025091001 2010-01-01 Guns 2010 0.36
#> 1062 25025091001 2011-01-01 Guns 2011 5.39
#> 1063 25025091001 2012-01-01 Guns 2012 3.19
#> 1064 25025091001 2013-01-01 Guns 2013 6.53
#> 1065 25025091001 2014-01-01 Guns 2014 3.40
#> 1066 25025091001 2015-01-01 Guns 2015 3.94
#> 1067 25025091001 2016-01-01 Guns 2016 2.95
#> 1068 25025091001 2017-01-01 Guns 2017 4.60
#> 1069 25025091001 2018-01-01 <NA> NA NA
#> 1070 25025091001 2019-01-01 Guns 2019 3.03
#> 1071 25025091100 2010-01-01 Guns 2010 0.00
#> 1072 25025091100 2011-01-01 Guns 2011 2.34
#> 1073 25025091100 2012-01-01 Guns 2012 2.64
#> 1074 25025091100 2013-01-01 Guns 2013 2.92
#> 1075 25025091100 2014-01-01 Guns 2014 2.44
#> 1076 25025091100 2015-01-01 Guns 2015 1.78
#> 1077 25025091100 2016-01-01 Guns 2016 1.19
#> 1078 25025091100 2017-01-01 Guns 2017 2.78
#> 1079 25025091100 2018-01-01 Guns 2018 2.78
#> 1080 25025091100 2019-01-01 Guns 2019 1.89
#> 1081 25025091200 2010-01-01 Guns 2010 0.68
#> 1082 25025091200 2011-01-01 Guns 2011 5.18
#> 1083 25025091200 2012-01-01 Guns 2012 5.05
#> 1084 25025091200 2013-01-01 Guns 2013 7.41
#> 1085 25025091200 2014-01-01 Guns 2014 10.80
#> 1086 25025091200 2015-01-01 Guns 2015 11.58
#> 1087 25025091200 2016-01-01 Guns 2016 9.60
#> 1088 25025091200 2017-01-01 Guns 2017 15.88
#> 1089 25025091200 2018-01-01 <NA> NA NA
#> 1090 25025091200 2019-01-01 Guns 2019 3.98
#> 1091 25025091300 2010-01-01 Guns 2010 0.00
#> 1092 25025091300 2011-01-01 <NA> NA NA
#> 1093 25025091300 2012-01-01 Guns 2012 16.65
#> 1094 25025091300 2013-01-01 Guns 2013 12.33
#> 1095 25025091300 2014-01-01 <NA> NA NA
#> 1096 25025091300 2015-01-01 Guns 2015 21.10
#> 1097 25025091300 2016-01-01 Guns 2016 25.79
#> 1098 25025091300 2017-01-01 Guns 2017 14.46
#> 1099 25025091300 2018-01-01 Guns 2018 14.07
#> 1100 25025091300 2019-01-01 Guns 2019 7.81
#> 1101 25025091400 2010-01-01 Guns 2010 0.46
#> 1102 25025091400 2011-01-01 Guns 2011 7.21
#> 1103 25025091400 2012-01-01 Guns 2012 6.13
#> 1104 25025091400 2013-01-01 Guns 2013 13.23
#> 1105 25025091400 2014-01-01 Guns 2014 10.50
#> 1106 25025091400 2015-01-01 Guns 2015 8.42
#> 1107 25025091400 2016-01-01 Guns 2016 7.77
#> 1108 25025091400 2017-01-01 Guns 2017 7.45
#> 1109 25025091400 2018-01-01 Guns 2018 9.71
#> 1110 25025091400 2019-01-01 Guns 2019 8.85
#> 1111 25025091500 2010-01-01 Guns 2010 1.20
#> 1112 25025091500 2011-01-01 Guns 2011 6.91
#> 1113 25025091500 2012-01-01 Guns 2012 7.15
#> 1114 25025091500 2013-01-01 Guns 2013 9.16
#> 1115 25025091500 2014-01-01 Guns 2014 10.47
#> 1116 25025091500 2015-01-01 Guns 2015 9.22
#> 1117 25025091500 2016-01-01 Guns 2016 12.10
#> 1118 25025091500 2017-01-01 Guns 2017 12.49
#> 1119 25025091500 2018-01-01 <NA> NA NA
#> 1120 25025091500 2019-01-01 Guns 2019 3.96
#> 1121 25025091600 2010-01-01 Guns 2010 1.58
#> 1122 25025091600 2011-01-01 Guns 2011 6.25
#> 1123 25025091600 2012-01-01 Guns 2012 4.18
#> 1124 25025091600 2013-01-01 Guns 2013 14.78
#> 1125 25025091600 2014-01-01 Guns 2014 5.59
#> 1126 25025091600 2015-01-01 Guns 2015 4.39
#> 1127 25025091600 2016-01-01 Guns 2016 7.44
#> 1128 25025091600 2017-01-01 Guns 2017 11.49
#> 1129 25025091600 2018-01-01 Guns 2018 9.80
#> 1130 25025091600 2019-01-01 Guns 2019 7.08
#> 1131 25025091700 2010-01-01 Guns 2010 0.60
#> 1132 25025091700 2011-01-01 Guns 2011 5.26
#> 1133 25025091700 2012-01-01 Guns 2012 10.53
#> 1134 25025091700 2013-01-01 Guns 2013 16.95
#> 1135 25025091700 2014-01-01 Guns 2014 10.86
#> 1136 25025091700 2015-01-01 Guns 2015 11.40
#> 1137 25025091700 2016-01-01 Guns 2016 11.71
#> 1138 25025091700 2017-01-01 Guns 2017 16.02
#> 1139 25025091700 2018-01-01 Guns 2018 5.55
#> 1140 25025091700 2019-01-01 Guns 2019 8.71
#> 1141 25025091800 2010-01-01 Guns 2010 0.87
#> 1142 25025091800 2011-01-01 Guns 2011 13.29
#> 1143 25025091800 2012-01-01 Guns 2012 7.60
#> 1144 25025091800 2013-01-01 Guns 2013 8.92
#> 1145 25025091800 2014-01-01 Guns 2014 9.15
#> 1146 25025091800 2015-01-01 Guns 2015 16.80
#> 1147 25025091800 2016-01-01 Guns 2016 13.22
#> 1148 25025091800 2017-01-01 Guns 2017 12.67
#> 1149 25025091800 2018-01-01 Guns 2018 9.09
#> 1150 25025091800 2019-01-01 Guns 2019 7.37
#> 1151 25025091900 2010-01-01 Guns 2010 0.98
#> 1152 25025091900 2011-01-01 Guns 2011 7.49
#> 1153 25025091900 2012-01-01 Guns 2012 5.65
#> 1154 25025091900 2013-01-01 Guns 2013 14.19
#> 1155 25025091900 2014-01-01 Guns 2014 8.96
#> 1156 25025091900 2015-01-01 Guns 2015 12.47
#> 1157 25025091900 2016-01-01 Guns 2016 9.48
#> 1158 25025091900 2017-01-01 Guns 2017 9.73
#> 1159 25025091900 2018-01-01 Guns 2018 6.73
#> 1160 25025091900 2019-01-01 Guns 2019 8.11
#> 1161 25025092000 2010-01-01 Guns 2010 1.32
#> 1162 25025092000 2011-01-01 Guns 2011 7.85
#> 1163 25025092000 2012-01-01 Guns 2012 9.27
#> 1164 25025092000 2013-01-01 Guns 2013 14.19
#> 1165 25025092000 2014-01-01 Guns 2014 9.26
#> 1166 25025092000 2015-01-01 Guns 2015 8.48
#> 1167 25025092000 2016-01-01 <NA> NA NA
#> 1168 25025092000 2017-01-01 Guns 2017 9.40
#> 1169 25025092000 2018-01-01 Guns 2018 6.08
#> 1170 25025092000 2019-01-01 Guns 2019 6.92
#> 1171 25025092101 2010-01-01 Guns 2010 1.33
#> 1172 25025092101 2011-01-01 Guns 2011 5.76
#> 1173 25025092101 2012-01-01 Guns 2012 3.42
#> 1174 25025092101 2013-01-01 Guns 2013 5.35
#> 1175 25025092101 2014-01-01 Guns 2014 7.70
#> 1176 25025092101 2015-01-01 <NA> NA NA
#> 1177 25025092101 2016-01-01 Guns 2016 4.90
#> 1178 25025092101 2017-01-01 Guns 2017 5.74
#> 1179 25025092101 2018-01-01 Guns 2018 4.06
#> 1180 25025092101 2019-01-01 Guns 2019 3.76
#> 1181 25025092200 2010-01-01 Guns 2010 1.38
#> 1182 25025092200 2011-01-01 Guns 2011 13.37
#> 1183 25025092200 2012-01-01 Guns 2012 10.47
#> 1184 25025092200 2013-01-01 Guns 2013 10.42
#> 1185 25025092200 2014-01-01 Guns 2014 14.61
#> 1186 25025092200 2015-01-01 Guns 2015 12.86
#> 1187 25025092200 2016-01-01 Guns 2016 19.30
#> 1188 25025092200 2017-01-01 Guns 2017 15.01
#> 1189 25025092200 2018-01-01 Guns 2018 17.46
#> 1190 25025092200 2019-01-01 Guns 2019 15.13
#> 1191 25025092300 2010-01-01 Guns 2010 0.32
#> 1192 25025092300 2011-01-01 Guns 2011 10.53
#> 1193 25025092300 2012-01-01 Guns 2012 9.48
#> 1194 25025092300 2013-01-01 Guns 2013 7.24
#> 1195 25025092300 2014-01-01 Guns 2014 5.91
#> 1196 25025092300 2015-01-01 Guns 2015 12.79
#> 1197 25025092300 2016-01-01 Guns 2016 10.80
#> 1198 25025092300 2017-01-01 Guns 2017 13.07
#> 1199 25025092300 2018-01-01 Guns 2018 7.10
#> 1200 25025092300 2019-01-01 Guns 2019 8.25
#> 1201 25025092400 2010-01-01 Guns 2010 1.19
#> 1202 25025092400 2011-01-01 Guns 2011 9.42
#> 1203 25025092400 2012-01-01 Guns 2012 8.22
#> 1204 25025092400 2013-01-01 Guns 2013 10.47
#> 1205 25025092400 2014-01-01 Guns 2014 13.41
#> 1206 25025092400 2015-01-01 Guns 2015 10.19
#> 1207 25025092400 2016-01-01 Guns 2016 11.20
#> 1208 25025092400 2017-01-01 Guns 2017 10.70
#> 1209 25025092400 2018-01-01 Guns 2018 6.68
#> 1210 25025092400 2019-01-01 Guns 2019 9.31
#> 1211 25025100100 2010-01-01 Guns 2010 0.16
#> 1212 25025100100 2011-01-01 Guns 2011 8.90
#> 1213 25025100100 2012-01-01 Guns 2012 8.79
#> 1214 25025100100 2013-01-01 Guns 2013 10.90
#> 1215 25025100100 2014-01-01 Guns 2014 11.03
#> 1216 25025100100 2015-01-01 Guns 2015 11.12
#> 1217 25025100100 2016-01-01 Guns 2016 9.64
#> 1218 25025100100 2017-01-01 Guns 2017 8.90
#> 1219 25025100100 2018-01-01 Guns 2018 7.42
#> 1220 25025100100 2019-01-01 Guns 2019 8.12
#> 1221 25025100200 2010-01-01 Guns 2010 1.49
#> 1222 25025100200 2011-01-01 Guns 2011 10.07
#> 1223 25025100200 2012-01-01 Guns 2012 13.21
#> 1224 25025100200 2013-01-01 Guns 2013 14.98
#> 1225 25025100200 2014-01-01 Guns 2014 11.99
#> 1226 25025100200 2015-01-01 <NA> NA NA
#> 1227 25025100200 2016-01-01 Guns 2016 6.62
#> 1228 25025100200 2017-01-01 Guns 2017 9.14
#> 1229 25025100200 2018-01-01 Guns 2018 8.51
#> 1230 25025100200 2019-01-01 Guns 2019 9.59
#> 1231 25025100300 2010-01-01 Guns 2010 0.55
#> 1232 25025100300 2011-01-01 Guns 2011 4.69
#> 1233 25025100300 2012-01-01 Guns 2012 7.91
#> 1234 25025100300 2013-01-01 Guns 2013 9.34
#> 1235 25025100300 2014-01-01 Guns 2014 9.11
#> 1236 25025100300 2015-01-01 Guns 2015 8.86
#> 1237 25025100300 2016-01-01 Guns 2016 3.20
#> 1238 25025100300 2017-01-01 Guns 2017 10.83
#> 1239 25025100300 2018-01-01 Guns 2018 7.14
#> 1240 25025100300 2019-01-01 Guns 2019 3.65
#> 1241 25025100400 2010-01-01 Guns 2010 0.65
#> 1242 25025100400 2011-01-01 Guns 2011 4.95
#> 1243 25025100400 2012-01-01 Guns 2012 8.12
#> 1244 25025100400 2013-01-01 Guns 2013 6.91
#> 1245 25025100400 2014-01-01 Guns 2014 6.25
#> 1246 25025100400 2015-01-01 Guns 2015 5.65
#> 1247 25025100400 2016-01-01 Guns 2016 10.76
#> 1248 25025100400 2017-01-01 Guns 2017 6.00
#> 1249 25025100400 2018-01-01 Guns 2018 3.71
#> 1250 25025100400 2019-01-01 Guns 2019 3.51
#> 1251 25025100500 2010-01-01 Guns 2010 1.23
#> 1252 25025100500 2011-01-01 Guns 2011 6.43
#> 1253 25025100500 2012-01-01 Guns 2012 7.90
#> 1254 25025100500 2013-01-01 Guns 2013 10.24
#> 1255 25025100500 2014-01-01 Guns 2014 8.30
#> 1256 25025100500 2015-01-01 Guns 2015 9.54
#> 1257 25025100500 2016-01-01 Guns 2016 10.63
#> 1258 25025100500 2017-01-01 Guns 2017 6.00
#> 1259 25025100500 2018-01-01 Guns 2018 5.18
#> 1260 25025100500 2019-01-01 <NA> NA NA
#> 1261 25025100601 2010-01-01 Guns 2010 0.20
#> 1262 25025100601 2011-01-01 Guns 2011 3.09
#> 1263 25025100601 2012-01-01 Guns 2012 4.44
#> 1264 25025100601 2013-01-01 Guns 2013 5.01
#> 1265 25025100601 2014-01-01 Guns 2014 2.67
#> 1266 25025100601 2015-01-01 Guns 2015 2.20
#> 1267 25025100601 2016-01-01 Guns 2016 2.37
#> 1268 25025100601 2017-01-01 Guns 2017 1.36
#> 1269 25025100601 2018-01-01 Guns 2018 0.85
#> 1270 25025100601 2019-01-01 Guns 2019 0.67
#> 1271 25025100603 2010-01-01 Guns 2010 0.00
#> 1272 25025100603 2011-01-01 Guns 2011 4.19
#> 1273 25025100603 2012-01-01 Guns 2012 1.96
#> 1274 25025100603 2013-01-01 Guns 2013 0.98
#> 1275 25025100603 2014-01-01 Guns 2014 1.93
#> 1276 25025100603 2015-01-01 Guns 2015 4.30
#> 1277 25025100603 2016-01-01 Guns 2016 0.48
#> 1278 25025100603 2017-01-01 Guns 2017 4.30
#> 1279 25025100603 2018-01-01 Guns 2018 1.91
#> 1280 25025100603 2019-01-01 Guns 2019 3.04
#> 1281 25025100700 2010-01-01 <NA> NA NA
#> 1282 25025100700 2011-01-01 Guns 2011 2.05
#> 1283 25025100700 2012-01-01 Guns 2012 0.67
#> 1284 25025100700 2013-01-01 Guns 2013 1.14
#> 1285 25025100700 2014-01-01 Guns 2014 1.34
#> 1286 25025100700 2015-01-01 Guns 2015 0.45
#> 1287 25025100700 2016-01-01 Guns 2016 0.91
#> 1288 25025100700 2017-01-01 Guns 2017 1.81
#> 1289 25025100700 2018-01-01 Guns 2018 1.13
#> 1290 25025100700 2019-01-01 Guns 2019 0.46
#> 1291 25025100800 2010-01-01 Guns 2010 0.76
#> 1292 25025100800 2011-01-01 Guns 2011 2.51
#> 1293 25025100800 2012-01-01 Guns 2012 4.86
#> 1294 25025100800 2013-01-01 Guns 2013 4.17
#> 1295 25025100800 2014-01-01 Guns 2014 4.52
#> 1296 25025100800 2015-01-01 Guns 2015 1.97
#> 1297 25025100800 2016-01-01 Guns 2016 2.73
#> 1298 25025100800 2017-01-01 Guns 2017 2.89
#> 1299 25025100800 2018-01-01 Guns 2018 1.82
#> 1300 25025100800 2019-01-01 Guns 2019 2.89
#> 1301 25025100900 2010-01-01 Guns 2010 0.00
#> 1302 25025100900 2011-01-01 Guns 2011 4.63
#> 1303 25025100900 2012-01-01 Guns 2012 1.68
#> 1304 25025100900 2013-01-01 Guns 2013 3.77
#> 1305 25025100900 2014-01-01 Guns 2014 5.64
#> 1306 25025100900 2015-01-01 Guns 2015 6.20
#> 1307 25025100900 2016-01-01 Guns 2016 7.15
#> 1308 25025100900 2017-01-01 Guns 2017 7.39
#> 1309 25025100900 2018-01-01 Guns 2018 5.72
#> 1310 25025100900 2019-01-01 Guns 2019 3.07
#> 1311 25025101001 2010-01-01 Guns 2010 0.84
#> 1312 25025101001 2011-01-01 Guns 2011 5.43
#> 1313 25025101001 2012-01-01 Guns 2012 7.15
#> 1314 25025101001 2013-01-01 Guns 2013 8.08
#> 1315 25025101001 2014-01-01 Guns 2014 7.00
#> 1316 25025101001 2015-01-01 Guns 2015 6.15
#> 1317 25025101001 2016-01-01 Guns 2016 8.98
#> 1318 25025101001 2017-01-01 Guns 2017 8.83
#> 1319 25025101001 2018-01-01 Guns 2018 7.25
#> 1320 25025101001 2019-01-01 Guns 2019 4.85
#> 1321 25025101002 2010-01-01 Guns 2010 1.05
#> 1322 25025101002 2011-01-01 <NA> NA NA
#> 1323 25025101002 2012-01-01 Guns 2012 6.46
#> 1324 25025101002 2013-01-01 Guns 2013 6.70
#> 1325 25025101002 2014-01-01 Guns 2014 7.73
#> 1326 25025101002 2015-01-01 Guns 2015 8.48
#> 1327 25025101002 2016-01-01 Guns 2016 5.88
#> 1328 25025101002 2017-01-01 Guns 2017 5.88
#> 1329 25025101002 2018-01-01 Guns 2018 6.92
#> 1330 25025101002 2019-01-01 Guns 2019 4.53
#> 1331 25025101101 2010-01-01 Guns 2010 0.59
#> 1332 25025101101 2011-01-01 Guns 2011 6.31
#> 1333 25025101101 2012-01-01 Guns 2012 3.49
#> 1334 25025101101 2013-01-01 Guns 2013 4.46
#> 1335 25025101101 2014-01-01 Guns 2014 4.84
#> 1336 25025101101 2015-01-01 Guns 2015 4.49
#> 1337 25025101101 2016-01-01 Guns 2016 3.96
#> 1338 25025101101 2017-01-01 Guns 2017 4.75
#> 1339 25025101101 2018-01-01 Guns 2018 2.64
#> 1340 25025101101 2019-01-01 Guns 2019 7.27
#> 1341 25025101102 2010-01-01 Guns 2010 1.66
#> 1342 25025101102 2011-01-01 Guns 2011 8.40
#> 1343 25025101102 2012-01-01 Guns 2012 7.78
#> 1344 25025101102 2013-01-01 Guns 2013 13.99
#> 1345 25025101102 2014-01-01 Guns 2014 9.02
#> 1346 25025101102 2015-01-01 Guns 2015 10.06
#> 1347 25025101102 2016-01-01 Guns 2016 8.29
#> 1348 25025101102 2017-01-01 Guns 2017 7.89
#> 1349 25025101102 2018-01-01 Guns 2018 7.70
#> 1350 25025101102 2019-01-01 Guns 2019 8.57
#> 1351 25025110103 2010-01-01 Guns 2010 0.68
#> 1352 25025110103 2011-01-01 Guns 2011 3.59
#> 1353 25025110103 2012-01-01 Guns 2012 3.69
#> 1354 25025110103 2013-01-01 Guns 2013 3.20
#> 1355 25025110103 2014-01-01 Guns 2014 2.14
#> 1356 25025110103 2015-01-01 Guns 2015 4.76
#> 1357 25025110103 2016-01-01 Guns 2016 2.54
#> 1358 25025110103 2017-01-01 Guns 2017 2.54
#> 1359 25025110103 2018-01-01 Guns 2018 1.59
#> 1360 25025110103 2019-01-01 Guns 2019 2.10
#> 1361 25025110201 2010-01-01 Guns 2010 0.00
#> 1362 25025110201 2011-01-01 Guns 2011 0.90
#> 1363 25025110201 2012-01-01 Guns 2012 2.23
#> 1364 25025110201 2013-01-01 Guns 2013 5.46
#> 1365 25025110201 2014-01-01 Guns 2014 3.23
#> 1366 25025110201 2015-01-01 Guns 2015 5.18
#> 1367 25025110201 2016-01-01 Guns 2016 2.39
#> 1368 25025110201 2017-01-01 Guns 2017 3.58
#> 1369 25025110201 2018-01-01 Guns 2018 3.18
#> 1370 25025110201 2019-01-01 Guns 2019 3.56
#> 1371 25025110301 2010-01-01 Guns 2010 0.39
#> 1372 25025110301 2011-01-01 Guns 2011 2.42
#> 1373 25025110301 2012-01-01 Guns 2012 2.76
#> 1374 25025110301 2013-01-01 Guns 2013 2.25
#> 1375 25025110301 2014-01-01 Guns 2014 1.84
#> 1376 25025110301 2015-01-01 Guns 2015 2.60
#> 1377 25025110301 2016-01-01 Guns 2016 2.23
#> 1378 25025110301 2017-01-01 Guns 2017 4.46
#> 1379 25025110301 2018-01-01 Guns 2018 2.60
#> 1380 25025110301 2019-01-01 Guns 2019 2.94
#> 1381 25025110401 2010-01-01 Guns 2010 0.54
#> 1382 25025110401 2011-01-01 Guns 2011 2.48
#> 1383 25025110401 2012-01-01 Guns 2012 2.49
#> 1384 25025110401 2013-01-01 Guns 2013 2.09
#> 1385 25025110401 2014-01-01 Guns 2014 2.07
#> 1386 25025110401 2015-01-01 Guns 2015 3.45
#> 1387 25025110401 2016-01-01 Guns 2016 1.59
#> 1388 25025110401 2017-01-01 Guns 2017 2.39
#> 1389 25025110401 2018-01-01 Guns 2018 3.18
#> 1390 25025110401 2019-01-01 Guns 2019 3.10
#> 1391 25025110403 2010-01-01 Guns 2010 0.00
#> 1392 25025110403 2011-01-01 Guns 2011 1.00
#> 1393 25025110403 2012-01-01 Guns 2012 1.01
#> 1394 25025110403 2013-01-01 Guns 2013 1.91
#> 1395 25025110403 2014-01-01 Guns 2014 1.53
#> 1396 25025110403 2015-01-01 Guns 2015 0.67
#> 1397 25025110403 2016-01-01 Guns 2016 1.33
#> 1398 25025110403 2017-01-01 Guns 2017 2.89
#> 1399 25025110403 2018-01-01 Guns 2018 0.44
#> 1400 25025110403 2019-01-01 Guns 2019 1.77
#> 1401 25025110501 2010-01-01 Guns 2010 0.00
#> 1402 25025110501 2011-01-01 Guns 2011 0.83
#> 1403 25025110501 2012-01-01 Guns 2012 0.83
#> 1404 25025110501 2013-01-01 Guns 2013 1.11
#> 1405 25025110501 2014-01-01 Guns 2014 0.28
#> 1406 25025110501 2015-01-01 Guns 2015 0.00
#> 1407 25025110501 2016-01-01 Guns 2016 1.13
#> 1408 25025110501 2017-01-01 Guns 2017 1.41
#> 1409 25025110501 2018-01-01 Guns 2018 1.13
#> 1410 25025110501 2019-01-01 Guns 2019 0.80
#> 1411 25025110502 2010-01-01 Guns 2010 0.00
#> 1412 25025110502 2011-01-01 Guns 2011 2.64
#> 1413 25025110502 2012-01-01 Guns 2012 3.08
#> 1414 25025110502 2013-01-01 Guns 2013 2.25
#> 1415 25025110502 2014-01-01 Guns 2014 1.93
#> 1416 25025110502 2015-01-01 Guns 2015 1.72
#> 1417 25025110502 2016-01-01 <NA> NA NA
#> 1418 25025110502 2017-01-01 Guns 2017 3.01
#> 1419 25025110502 2018-01-01 <NA> NA NA
#> 1420 25025110502 2019-01-01 Guns 2019 1.63
#> 1421 25025110601 2010-01-01 Guns 2010 0.00
#> 1422 25025110601 2011-01-01 Guns 2011 0.75
#> 1423 25025110601 2012-01-01 Guns 2012 0.00
#> 1424 25025110601 2013-01-01 Guns 2013 2.04
#> 1425 25025110601 2014-01-01 Guns 2014 1.06
#> 1426 25025110601 2015-01-01 Guns 2015 0.00
#> 1427 25025110601 2016-01-01 <NA> NA NA
#> 1428 25025110601 2017-01-01 Guns 2017 0.00
#> 1429 25025110601 2018-01-01 Guns 2018 0.33
#> 1430 25025110601 2019-01-01 <NA> NA NA
#> 1431 25025110607 2010-01-01 Guns 2010 0.00
#> 1432 25025110607 2011-01-01 Guns 2011 1.32
#> 1433 25025110607 2012-01-01 Guns 2012 1.89
#> 1434 25025110607 2013-01-01 Guns 2013 1.37
#> 1435 25025110607 2014-01-01 Guns 2014 2.08
#> 1436 25025110607 2015-01-01 Guns 2015 0.37
#> 1437 25025110607 2016-01-01 Guns 2016 1.31
#> 1438 25025110607 2017-01-01 Guns 2017 0.75
#> 1439 25025110607 2018-01-01 Guns 2018 0.93
#> 1440 25025110607 2019-01-01 Guns 2019 0.55
#> 1441 25025120103 2010-01-01 Guns 2010 0.00
#> 1442 25025120103 2011-01-01 Guns 2011 0.63
#> 1443 25025120103 2012-01-01 Guns 2012 0.00
#> 1444 25025120103 2013-01-01 Guns 2013 0.62
#> 1445 25025120103 2014-01-01 Guns 2014 1.81
#> 1446 25025120103 2015-01-01 Guns 2015 5.29
#> 1447 25025120103 2016-01-01 Guns 2016 0.59
#> 1448 25025120103 2017-01-01 Guns 2017 0.00
#> 1449 25025120103 2018-01-01 Guns 2018 5.29
#> 1450 25025120103 2019-01-01 Guns 2019 1.80
#> 1451 25025120104 2010-01-01 Guns 2010 0.00
#> 1452 25025120104 2011-01-01 Guns 2011 4.65
#> 1453 25025120104 2012-01-01 Guns 2012 3.22
#> 1454 25025120104 2013-01-01 Guns 2013 4.40
#> 1455 25025120104 2014-01-01 Guns 2014 3.92
#> 1456 25025120104 2015-01-01 Guns 2015 1.74
#> 1457 25025120104 2016-01-01 Guns 2016 1.74
#> 1458 25025120104 2017-01-01 Guns 2017 1.30
#> 1459 25025120104 2018-01-01 Guns 2018 2.61
#> 1460 25025120104 2019-01-01 Guns 2019 0.45
#> 1461 25025120105 2010-01-01 Guns 2010 0.87
#> 1462 25025120105 2011-01-01 Guns 2011 0.85
#> 1463 25025120105 2012-01-01 Guns 2012 0.41
#> 1464 25025120105 2013-01-01 Guns 2013 0.38
#> 1465 25025120105 2014-01-01 Guns 2014 1.10
#> 1466 25025120105 2015-01-01 Guns 2015 1.81
#> 1467 25025120105 2016-01-01 Guns 2016 0.73
#> 1468 25025120105 2017-01-01 Guns 2017 2.18
#> 1469 25025120105 2018-01-01 Guns 2018 0.73
#> 1470 25025120105 2019-01-01 Guns 2019 1.83
#> 1471 25025120201 2010-01-01 Guns 2010 0.52
#> 1472 25025120201 2011-01-01 Guns 2011 2.10
#> 1473 25025120201 2012-01-01 Guns 2012 3.19
#> 1474 25025120201 2013-01-01 Guns 2013 4.35
#> 1475 25025120201 2014-01-01 Guns 2014 2.20
#> 1476 25025120201 2015-01-01 Guns 2015 3.97
#> 1477 25025120201 2016-01-01 Guns 2016 2.38
#> 1478 25025120201 2017-01-01 Guns 2017 0.79
#> 1479 25025120201 2018-01-01 Guns 2018 1.59
#> 1480 25025120201 2019-01-01 Guns 2019 2.30
#> 1481 25025120301 2010-01-01 Guns 2010 0.80
#> 1482 25025120301 2011-01-01 Guns 2011 6.53
#> 1483 25025120301 2012-01-01 Guns 2012 2.95
#> 1484 25025120301 2013-01-01 Guns 2013 4.61
#> 1485 25025120301 2014-01-01 Guns 2014 7.69
#> 1486 25025120301 2015-01-01 Guns 2015 4.94
#> 1487 25025120301 2016-01-01 Guns 2016 4.75
#> 1488 25025120301 2017-01-01 <NA> NA NA
#> 1489 25025120301 2018-01-01 <NA> NA NA
#> 1490 25025120301 2019-01-01 Guns 2019 2.33
#> 1491 25025120400 2010-01-01 Guns 2010 1.51
#> 1492 25025120400 2011-01-01 Guns 2011 0.93
#> 1493 25025120400 2012-01-01 Guns 2012 1.25
#> 1494 25025120400 2013-01-01 Guns 2013 2.12
#> 1495 25025120400 2014-01-01 <NA> NA NA
#> 1496 25025120400 2015-01-01 Guns 2015 1.42
#> 1497 25025120400 2016-01-01 Guns 2016 2.06
#> 1498 25025120400 2017-01-01 Guns 2017 3.00
#> 1499 25025120400 2018-01-01 Guns 2018 2.06
#> 1500 25025120400 2019-01-01 Guns 2019 0.46
#> 1501 25025120500 2010-01-01 Guns 2010 0.00
#> 1502 25025120500 2011-01-01 Guns 2011 2.50
#> 1503 25025120500 2012-01-01 Guns 2012 2.11
#> 1504 25025120500 2013-01-01 Guns 2013 4.03
#> 1505 25025120500 2014-01-01 Guns 2014 4.88
#> 1506 25025120500 2015-01-01 Guns 2015 2.98
#> 1507 25025120500 2016-01-01 Guns 2016 5.21
#> 1508 25025120500 2017-01-01 Guns 2017 2.23
#> 1509 25025120500 2018-01-01 Guns 2018 4.10
#> 1510 25025120500 2019-01-01 Guns 2019 4.61
#> 1511 25025120600 2010-01-01 Guns 2010 0.00
#> 1512 25025120600 2011-01-01 Guns 2011 3.05
#> 1513 25025120600 2012-01-01 Guns 2012 0.00
#> 1514 25025120600 2013-01-01 Guns 2013 3.10
#> 1515 25025120600 2014-01-01 Guns 2014 2.91
#> 1516 25025120600 2015-01-01 Guns 2015 2.16
#> 1517 25025120600 2016-01-01 Guns 2016 1.73
#> 1518 25025120600 2017-01-01 Guns 2017 0.43
#> 1519 25025120600 2018-01-01 <NA> NA NA
#> 1520 25025120600 2019-01-01 Guns 2019 2.04
#> 1521 25025120700 2010-01-01 Guns 2010 0.47
#> 1522 25025120700 2011-01-01 Guns 2011 1.56
#> 1523 25025120700 2012-01-01 Guns 2012 3.43
#> 1524 25025120700 2013-01-01 Guns 2013 2.32
#> 1525 25025120700 2014-01-01 Guns 2014 2.27
#> 1526 25025120700 2015-01-01 Guns 2015 3.49
#> 1527 25025120700 2016-01-01 Guns 2016 1.31
#> 1528 25025120700 2017-01-01 Guns 2017 2.18
#> 1529 25025120700 2018-01-01 Guns 2018 2.62
#> 1530 25025120700 2019-01-01 Guns 2019 1.29
#> 1531 25025130100 2010-01-01 Guns 2010 0.17
#> 1532 25025130100 2011-01-01 Guns 2011 0.50
#> 1533 25025130100 2012-01-01 Guns 2012 1.32
#> 1534 25025130100 2013-01-01 Guns 2013 0.46
#> 1535 25025130100 2014-01-01 Guns 2014 0.00
#> 1536 25025130100 2015-01-01 Guns 2015 0.90
#> 1537 25025130100 2016-01-01 <NA> NA NA
#> 1538 25025130100 2017-01-01 Guns 2017 0.30
#> 1539 25025130100 2018-01-01 <NA> NA NA
#> 1540 25025130100 2019-01-01 Guns 2019 0.30
#> 1541 25025130200 2010-01-01 Guns 2010 0.00
#> 1542 25025130200 2011-01-01 Guns 2011 0.60
#> 1543 25025130200 2012-01-01 Guns 2012 0.40
#> 1544 25025130200 2013-01-01 Guns 2013 0.60
#> 1545 25025130200 2014-01-01 Guns 2014 0.80
#> 1546 25025130200 2015-01-01 Guns 2015 0.57
#> 1547 25025130200 2016-01-01 Guns 2016 0.38
#> 1548 25025130200 2017-01-01 Guns 2017 0.38
#> 1549 25025130200 2018-01-01 Guns 2018 1.14
#> 1550 25025130200 2019-01-01 Guns 2019 0.57
#> 1551 25025130300 2010-01-01 Guns 2010 0.23
#> 1552 25025130300 2011-01-01 Guns 2011 0.43
#> 1553 25025130300 2012-01-01 Guns 2012 0.00
#> 1554 25025130300 2013-01-01 Guns 2013 0.43
#> 1555 25025130300 2014-01-01 Guns 2014 0.44
#> 1556 25025130300 2015-01-01 Guns 2015 1.07
#> 1557 25025130300 2016-01-01 Guns 2016 0.00
#> 1558 25025130300 2017-01-01 Guns 2017 0.64
#> 1559 25025130300 2018-01-01 Guns 2018 0.43
#> 1560 25025130300 2019-01-01 Guns 2019 0.44
#> 1561 25025130402 2010-01-01 <NA> NA NA
#> 1562 25025130402 2011-01-01 Guns 2011 0.00
#> 1563 25025130402 2012-01-01 Guns 2012 0.39
#> 1564 25025130402 2013-01-01 Guns 2013 0.61
#> 1565 25025130402 2014-01-01 Guns 2014 1.39
#> 1566 25025130402 2015-01-01 Guns 2015 1.38
#> 1567 25025130402 2016-01-01 Guns 2016 1.18
#> 1568 25025130402 2017-01-01 Guns 2017 0.79
#> 1569 25025130402 2018-01-01 Guns 2018 0.98
#> 1570 25025130402 2019-01-01 Guns 2019 0.61
#> 1571 25025130404 2010-01-01 Guns 2010 0.34
#> 1572 25025130404 2011-01-01 Guns 2011 0.98
#> 1573 25025130404 2012-01-01 Guns 2012 0.30
#> 1574 25025130404 2013-01-01 Guns 2013 3.60
#> 1575 25025130404 2014-01-01 Guns 2014 1.87
#> 1576 25025130404 2015-01-01 Guns 2015 1.53
#> 1577 25025130404 2016-01-01 Guns 2016 1.53
#> 1578 25025130404 2017-01-01 Guns 2017 1.53
#> 1579 25025130404 2018-01-01 Guns 2018 0.00
#> 1580 25025130404 2019-01-01 Guns 2019 0.87
#> 1581 25025130406 2010-01-01 Guns 2010 0.00
#> 1582 25025130406 2011-01-01 Guns 2011 2.61
#> 1583 25025130406 2012-01-01 Guns 2012 1.13
#> 1584 25025130406 2013-01-01 Guns 2013 1.85
#> 1585 25025130406 2014-01-01 Guns 2014 1.77
#> 1586 25025130406 2015-01-01 <NA> NA NA
#> 1587 25025130406 2016-01-01 Guns 2016 1.66
#> 1588 25025130406 2017-01-01 Guns 2017 1.16
#> 1589 25025130406 2018-01-01 Guns 2018 0.50
#> 1590 25025130406 2019-01-01 Guns 2019 0.79
#> 1591 25025140102 2010-01-01 Guns 2010 0.45
#> 1592 25025140102 2011-01-01 Guns 2011 1.34
#> 1593 25025140102 2012-01-01 Guns 2012 0.63
#> 1594 25025140102 2013-01-01 Guns 2013 1.49
#> 1595 25025140102 2014-01-01 Guns 2014 0.99
#> 1596 25025140102 2015-01-01 Guns 2015 2.09
#> 1597 25025140102 2016-01-01 Guns 2016 2.28
#> 1598 25025140102 2017-01-01 Guns 2017 2.28
#> 1599 25025140102 2018-01-01 Guns 2018 3.23
#> 1600 25025140102 2019-01-01 Guns 2019 1.98
#> 1601 25025140105 2010-01-01 Guns 2010 0.00
#> 1602 25025140105 2011-01-01 Guns 2011 2.36
#> 1603 25025140105 2012-01-01 Guns 2012 1.22
#> 1604 25025140105 2013-01-01 Guns 2013 0.50
#> 1605 25025140105 2014-01-01 Guns 2014 1.78
#> 1606 25025140105 2015-01-01 Guns 2015 2.89
#> 1607 25025140105 2016-01-01 Guns 2016 1.45
#> 1608 25025140105 2017-01-01 Guns 2017 0.96
#> 1609 25025140105 2018-01-01 Guns 2018 1.21
#> 1610 25025140105 2019-01-01 Guns 2019 2.46
#> 1611 25025140106 2010-01-01 Guns 2010 0.00
#> 1612 25025140106 2011-01-01 Guns 2011 0.00
#> 1613 25025140106 2012-01-01 <NA> NA NA
#> 1614 25025140106 2013-01-01 Guns 2013 1.60
#> 1615 25025140106 2014-01-01 Guns 2014 1.05
#> 1616 25025140106 2015-01-01 Guns 2015 3.21
#> 1617 25025140106 2016-01-01 Guns 2016 2.75
#> 1618 25025140106 2017-01-01 Guns 2017 2.29
#> 1619 25025140106 2018-01-01 Guns 2018 0.92
#> 1620 25025140106 2019-01-01 Guns 2019 1.37
#> 1621 25025140107 2010-01-01 Guns 2010 0.00
#> 1622 25025140107 2011-01-01 Guns 2011 3.08
#> 1623 25025140107 2012-01-01 Guns 2012 1.04
#> 1624 25025140107 2013-01-01 Guns 2013 1.72
#> 1625 25025140107 2014-01-01 Guns 2014 1.97
#> 1626 25025140107 2015-01-01 Guns 2015 0.74
#> 1627 25025140107 2016-01-01 Guns 2016 1.12
#> 1628 25025140107 2017-01-01 Guns 2017 3.72
#> 1629 25025140107 2018-01-01 Guns 2018 1.49
#> 1630 25025140107 2019-01-01 Guns 2019 4.36
#> 1631 25025140201 2010-01-01 Guns 2010 0.00
#> 1632 25025140201 2011-01-01 Guns 2011 1.67
#> 1633 25025140201 2012-01-01 Guns 2012 0.83
#> 1634 25025140201 2013-01-01 Guns 2013 0.00
#> 1635 25025140201 2014-01-01 <NA> NA NA
#> 1636 25025140201 2015-01-01 Guns 2015 2.56
#> 1637 25025140201 2016-01-01 Guns 2016 1.28
#> 1638 25025140201 2017-01-01 Guns 2017 2.13
#> 1639 25025140201 2018-01-01 Guns 2018 2.13
#> 1640 25025140201 2019-01-01 <NA> NA NA
#> 1641 25025140202 2010-01-01 Guns 2010 0.33
#> 1642 25025140202 2011-01-01 Guns 2011 1.15
#> 1643 25025140202 2012-01-01 Guns 2012 2.13
#> 1644 25025140202 2013-01-01 Guns 2013 4.53
#> 1645 25025140202 2014-01-01 Guns 2014 2.55
#> 1646 25025140202 2015-01-01 Guns 2015 3.37
#> 1647 25025140202 2016-01-01 Guns 2016 3.22
#> 1648 25025140202 2017-01-01 Guns 2017 2.91
#> 1649 25025140202 2018-01-01 Guns 2018 2.76
#> 1650 25025140202 2019-01-01 Guns 2019 2.06
#> 1651 25025140300 2010-01-01 Guns 2010 0.32
#> 1652 25025140300 2011-01-01 Guns 2011 3.18
#> 1653 25025140300 2012-01-01 Guns 2012 4.26
#> 1654 25025140300 2013-01-01 Guns 2013 4.25
#> 1655 25025140300 2014-01-01 Guns 2014 1.58
#> 1656 25025140300 2015-01-01 Guns 2015 3.67
#> 1657 25025140300 2016-01-01 Guns 2016 2.58
#> 1658 25025140300 2017-01-01 <NA> NA NA
#> 1659 25025140300 2018-01-01 <NA> NA NA
#> 1660 25025140300 2019-01-01 Guns 2019 5.32
#> 1661 25025140400 2010-01-01 Guns 2010 0.24
#> 1662 25025140400 2011-01-01 Guns 2011 3.20
#> 1663 25025140400 2012-01-01 Guns 2012 2.40
#> 1664 25025140400 2013-01-01 Guns 2013 3.23
#> 1665 25025140400 2014-01-01 Guns 2014 3.12
#> 1666 25025140400 2015-01-01 Guns 2015 4.23
#> 1667 25025140400 2016-01-01 Guns 2016 2.29
#> 1668 25025140400 2017-01-01 Guns 2017 2.29
#> 1669 25025140400 2018-01-01 Guns 2018 2.29
#> 1670 25025140400 2019-01-01 Guns 2019 3.91
#> 1671 25025981100 2010-01-01 Guns 2010 0.00
#> 1672 25025981100 2011-01-01 Guns 2011 0.00
#> 1673 25025981100 2012-01-01 Guns 2012 0.00
#> 1674 25025981100 2013-01-01 Guns 2013 3.36
#> 1675 25025981100 2014-01-01 Guns 2014 0.00
#> 1676 25025981100 2015-01-01 Guns 2015 0.00
#> 1677 25025981100 2016-01-01 Guns 2016 0.00
#> 1678 25025981100 2017-01-01 Guns 2017 0.00
#> 1679 25025981100 2018-01-01 Guns 2018 0.00
#> 1680 25025981100 2019-01-01 Guns 2019 0.00