Skip to contents

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.

Usage

complete_spacetime_cube(x, ...)

Arguments

x

a spacetime object.

...

unused

Value

A spacetime object that meets the criteria of spacetime cube.

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