Spreadsheet: 721165d1614538356-calculation-of-current-year-vs-prior-year-pseudo-slicer-pearl_022-
Sheet: Data

Site | Years | Date Occurred | Month No. | Date Concat | Reports | Injuries | Damage
NewJersey | 2020 | Jan | 1 |  | 1 | 1 | 0
NewJersey | 2020 | Feb | 2 |  | 0 | 0 | 0
NewJersey | 2020 | Mar | 3 |  | 0 | 0 | 0
NewJersey | 2020 | Apr | 4 |  | 0 | 0 | 0
NewJersey | 2020 | May | 5 |  | 3 | 1 | 0
NewJersey | 2020 | Jun | 6 |  | 2 | 0 | 0
NewJersey | 2020 | Jul | 7 |  | 0 | 0 | 0
NewJersey | 2020 | Aug | 8 |  | 0 | 0 | 0
NewJersey | 2020 | Sep | 9 |  | 1 | 0 | 0
NewJersey | 2020 | Oct | 10 |  | 2 | 1 | 0
NewJersey | 2020 | Nov | 11 |  | 3 | 0 | 0
NewJersey | 2020 | Dec | 12 |  | 1 | 0 | 0
NewJersey | 2021 | Jan | 1 |  | 1 | 0 | 0
NewJersey | 2021 | Feb | 2 |  | 0 | 0 | 0
NewJersey | 2021 | Mar | 3 |  | 0 | 0 | 0
NewJersey | 2021 | Apr | 4 |  | 0 | 0 | 0
NewJersey | 2021 | May | 5 |  | 0 | 0 | 0
NewJersey | 2021 | Jun | 6 |  | 0 | 0 | 0
NewJersey | 2021 | Jul | 7 |  | 0 | 0 | 0
NewJersey | 2021 | Aug | 8 |  | 0 | 0 | 0
NewJersey | 2021 | Sep | 9 |  | 0 | 0 | 0
NewJersey | 2021 | Oct | 10 |  | 0 | 0 | 0
NewJersey | 2021 | Nov | 11 |  | 0 | 0 | 0
NewJersey | 2021 | Dec | 12 |  | 0 | 0 | 0
New York | 2020 | Jan | 1 |  | 0 | 0 | 0
New York | 2020 | Feb | 2 |  | 1 | 1 | 0
New York | 2020 | Mar | 3 |  | 2 | 2 | 0
New York | 2020 | Apr | 4 |  | 0 | 0 | 0
New York | 2020 | May | 5 |  | 0 | 0 | 0
New York | 2020 | Jun | 6 |  | 5 | 4 | 0
New York | 2020 | Jul | 7 |  | 0 | 0 | 0
New York | 2020 | Aug | 8 |  | 0 | 0 | 0
New York | 2020 | Sep | 9 |  | 2 | 2 | 0
New York | 2020 | Oct | 10 |  | 0 | 0 | 0
New York | 2020 | Nov | 11 |  | 7 | 1 | 0
New York | 2020 | Dec | 12 |  | 4 | 2 | 0
New York | 2021 | Jan | 1 |  | 9 | 1 | 0
New York | 2021 | Feb | 2 |  | 0 | 0 | 0
New York | 2021 | Mar | 3 |  | 0 | 0 | 0
New York | 2021 | Apr | 4 |  | 0 | 0 | 0
New York | 2021 | May | 5 |  | 0 | 0 | 0
New York | 2021 | Jun | 6 |  | 0 | 0 | 0
New York | 2021 | Jul | 7 |  | 0 | 0 | 0
New York | 2021 | Aug | 8 |  | 0 | 0 | 0
New York | 2021 | Sep | 9 |  | 0 | 0 | 0
New York | 2021 | Oct | 10 |  | 0 | 0 | 0
New York | 2021 | Nov | 11 |  | 0 | 0 | 0
New York | 2021 | Dec | 12 |  | 0 | 0 | 0
Denver | 2020 | Jan | 1 |  | 0 | 0 | 0
Denver | 2020 | Feb | 2 |  | 0 | 0 | 0
Denver | 2020 | Mar | 3 |  | 0 | 0 | 0
Denver | 2020 | Apr | 4 |  | 0 | 0 | 0
Denver | 2020 | May | 5 |  | 0 | 0 | 0
Denver | 2020 | Jun | 6 |  | 0 | 0 | 0
Denver | 2020 | Jul | 7 |  | 1 | 0 | 0
Denver | 2020 | Aug | 8 |  | 2 | 0 | 0
Denver | 2020 | Sep | 9 |  | 0 | 0 | 0
Denver | 2020 | Oct | 10 |  | 0 | 0 | 0
Denver | 2020 | Nov | 11 |  | 1 | 0 | 0
Denver | 2020 | Dec | 12 |  | 0 | 0 | 0
Denver | 2021 | Jan | 1 |  | 1 | 0 | 0
Denver | 2021 | Feb | 2 |  | 0 | 0 | 0
Denver | 2021 | Mar | 3 |  | 0 | 0 | 0
Denver | 2021 | Apr | 4 |  | 0 | 0 | 0
Denver | 2021 | May | 5 |  | 0 | 0 | 0
Denver | 2021 | Jun | 6 |  | 0 | 0 | 0
Denver | 2021 | Jul | 7 |  | 0 | 0 | 0
Denver | 2021 | Aug | 8 |  | 0 | 0 | 0
Denver | 2021 | Sep | 9 |  | 0 | 0 | 0
Denver | 2021 | Oct | 10 |  | 0 | 0 | 0
Denver | 2021 | Nov | 11 |  | 0 | 0 | 0
Denver | 2021 | Dec | 12 |  | 0 | 0 | 0
Boston | 2020 | Jan | 1 |  | 1 | 1 | 0
Boston | 2020 | Feb | 2 |  | 0 | 0 | 0
Boston | 2020 | Mar | 3 |  | 0 | 0 | 0
Boston | 2020 | Apr | 4 |  | 0 | 0 | 0
Boston | 2020 | May | 5 |  | 0 | 0 | 0
Boston | 2020 | Jun | 6 |  | 0 | 0 | 0
Boston | 2020 | Jul | 7 |  | 0 | 0 | 0
Boston | 2020 | Aug | 8 |  | 0 | 0 | 0
Boston | 2020 | Sep | 9 |  | 0 | 0 | 0
Boston | 2020 | Oct | 10 |  | 0 | 0 | 0
Boston | 2020 | Nov | 11 |  | 3 | 2 | 0
Boston | 2020 | Dec | 12 |  | 6 | 2 | 0
Boston | 2021 | Jan | 1 |  | 7 | 3 | 0
Boston | 2021 | Feb | 2 |  | 0 | 0 | 0
Boston | 2021 | Mar | 3 |  | 0 | 0 | 0
Boston | 2021 | Apr | 4 |  | 0 | 0 | 0
Boston | 2021 | May | 5 |  | 0 | 0 | 0
Boston | 2021 | Jun | 6 |  | 0 | 0 | 0
Boston | 2021 | Jul | 7 |  | 0 | 0 | 0
Boston | 2021 | Aug | 8 |  | 0 | 0 | 0
Boston | 2021 | Sep | 9 |  | 0 | 0 | 0
Boston | 2021 | Oct | 10 |  | 0 | 0 | 0
Boston | 2021 | Nov | 11 |  | 0 | 0 | 0
Boston | 2021 | Dec | 12 |  | 0 | 0 | 0
Chicago | 2020 | Jan | 1 |  | 0 | 0 | 0
Chicago | 2020 | Feb | 2 |  | 0 | 0 | 0
Chicago | 2020 | Mar | 3 |  | 0 | 0 | 0
Chicago | 2020 | Apr | 4 |  | 0 | 0 | 0
Chicago | 2020 | May | 5 |  | 0 | 0 | 0
Chicago | 2020 | Jun | 6 |  | 1 | 0 | 0
Chicago | 2020 | Jul | 7 |  | 0 | 0 | 0
Chicago | 2020 | Aug | 8 |  | 1 | 1 | 0
Chicago | 2020 | Sep | 9 |  | 1 | 1 | 0
Chicago | 2020 | Oct | 10 |  | 0 | 0 | 0
Chicago | 2020 | Nov | 11 |  | 0 | 0 | 0
Chicago | 2020 | Dec | 12 |  | 1 | 0 | 0
Chicago | 2021 | Jan | 1 |  | 1 | 0 | 0
Chicago | 2021 | Feb | 2 |  | 0 | 0 | 0
Chicago | 2021 | Mar | 3 |  | 0 | 0 | 0
Chicago | 2021 | Apr | 4 |  | 0 | 0 | 0
Chicago | 2021 | May | 5 |  | 0 | 0 | 0
Chicago | 2021 | Jun | 6 |  | 0 | 0 | 0
Chicago | 2021 | Jul | 7 |  | 0 | 0 | 0
Chicago | 2021 | Aug | 8 |  | 0 | 0 | 0
Chicago | 2021 | Sep | 9 |  | 0 | 0 | 0
Chicago | 2021 | Oct | 10 |  | 0 | 0 | 0
Chicago | 2021 | Nov | 11 |  | 0 | 0 | 0
Chicago | 2021 | Dec | 12 |  | 0 | 0 | 0
Philadelphia | 2020 | Jan | 1 |  | 0 | 0 | 0
Philadelphia | 2020 | Feb | 2 |  | 0 | 0 | 0
Philadelphia | 2020 | Mar | 3 |  | 0 | 0 | 0
Philadelphia | 2020 | Apr | 4 |  | 0 | 0 | 0
Philadelphia | 2020 | May | 5 |  | 0 | 0 | 0
Philadelphia | 2020 | Jun | 6 |  | 0 | 0 | 0
Philadelphia | 2020 | Jul | 7 |  | 0 | 0 | 0
Philadelphia | 2020 | Aug | 8 |  | 0 | 0 | 0
Philadelphia | 2020 | Sep | 9 |  | 0 | 0 | 0
Philadelphia | 2020 | Oct | 10 |  | 0 | 0 | 0
Philadelphia | 2020 | Nov | 11 |  | 0 | 0 | 0
Philadelphia | 2020 | Dec | 12 |  | 0 | 0 | 0
Philadelphia | 2021 | Jan | 1 |  | 1 | 0 | 0
Philadelphia | 2021 | Feb | 2 |  | 0 | 0 | 0
Philadelphia | 2021 | Mar | 3 |  | 0 | 0 | 0
Philadelphia | 2021 | Apr | 4 |  | 0 | 0 | 0
Philadelphia | 2021 | May | 5 |  | 0 | 0 | 0
Philadelphia | 2021 | Jun | 6 |  | 0 | 0 | 0
Philadelphia | 2021 | Jul | 7 |  | 0 | 0 | 0
Philadelphia | 2021 | Aug | 8 |  | 0 | 0 | 0
Philadelphia | 2021 | Sep | 9 |  | 0 | 0 | 0
Philadelphia | 2021 | Oct | 10 |  | 0 | 0 | 0
Philadelphia | 2021 | Nov | 11 |  | 0 | 0 | 0
Philadelphia | 2021 | Dec | 12 |  | 0 | 0 | 0
Connecticut | 2020 | Jan | 1 |  | 2 | 2 | 0
Connecticut | 2020 | Feb | 2 |  | 0 | 0 | 0
Connecticut | 2020 | Mar | 3 |  | 1 | 1 | 0
Connecticut | 2020 | Apr | 4 |  | 0 | 0 | 0
Connecticut | 2020 | May | 5 |  | 1 | 1 | 0
Connecticut | 2020 | Jun | 6 |  | 1 | 1 | 0
Connecticut | 2020 | Jul | 7 |  | 0 | 0 | 0
Connecticut | 2020 | Aug | 8 |  | 0 | 0 | 0
Connecticut | 2020 | Sep | 9 |  | 0 | 0 | 0
Connecticut | 2020 | Oct | 10 |  | 0 | 0 | 0
Connecticut | 2020 | Nov | 11 |  | 11 | 0 | 0
Connecticut | 2020 | Dec | 12 |  | 9 | 1 | 0
Connecticut | 2021 | Jan | 1 |  | 11 | 0 | 0
Connecticut | 2021 | Feb | 2 |  | 0 | 0 | 0
Connecticut | 2021 | Mar | 3 |  | 0 | 0 | 0
Connecticut | 2021 | Apr | 4 |  | 0 | 0 | 0
Connecticut | 2021 | May | 5 |  | 0 | 0 | 0
Connecticut | 2021 | Jun | 6 |  | 0 | 0 | 0
Connecticut | 2021 | Jul | 7 |  | 0 | 0 | 0
Connecticut | 2021 | Aug | 8 |  | 0 | 0 | 0
Connecticut | 2021 | Sep | 9 |  | 0 | 0 | 0
Connecticut | 2021 | Oct | 10 |  | 0 | 0 | 0
Connecticut | 2021 | Nov | 11 |  | 0 | 0 | 0
Connecticut | 2021 | Dec | 12 |  | 0 | 0 | 0
LA | 2020 | Jan | 1 |  | 0 | 0 | 0
LA | 2020 | Feb | 2 |  | 4 | 2 | 0
LA | 2020 | Mar | 3 |  | 1 | 1 | 0
LA | 2020 | Apr | 4 |  | 2 | 2 | 0
LA | 2020 | May | 5 |  | 2 | 2 | 0
LA | 2020 | Jun | 6 |  | 2 | 0 | 0
LA | 2020 | Jul | 7 |  | 0 | 0 | 0
LA | 2020 | Aug | 8 |  | 0 | 0 | 0
LA | 2020 | Sep | 9 |  | 2 | 1 | 0
LA | 2020 | Oct | 10 |  | 0 | 0 | 0
LA | 2020 | Nov | 11 |  | 2 | 1 | 0
LA | 2020 | Dec | 12 |  | 4 | 4 | 0
LA | 2021 | Jan | 1 |  | 4 | 2 | 0
LA | 2021 | Feb | 2 |  | 0 | 0 | 0
LA | 2021 | Mar | 3 |  | 0 | 0 | 0
LA | 2021 | Apr | 4 |  | 0 | 0 | 0
LA | 2021 | May | 5 |  | 0 | 0 | 0
LA | 2021 | Jun | 6 |  | 0 | 0 | 0
LA | 2021 | Jul | 7 |  | 0 | 0 | 0
LA | 2021 | Aug | 8 |  | 0 | 0 | 0
LA | 2021 | Sep | 9 |  | 0 | 0 | 0
LA | 2021 | Oct | 10 |  | 0 | 0 | 0
LA | 2021 | Nov | 11 |  | 0 | 0 | 0
LA | 2021 | Dec | 12 |  | 0 | 0 | 0