Spreadsheet: 795531d1662737880-return-count-value-referencing-2-sets-of-data-open-closed-by-year
Sheet: Cumulative

 | Last Name | First Name |  | Violation |  | Year |  |  | Resolution
 |  |  |  |  |  | 2013 |  |  | Closed
 |  |  |  |  |  | 2014 |  |  | Open
 |  |  |  |  |  | 2015 |  |  | Blank
 |  |  |  |  |  | 2016
 |  |  |  |  |  | 2017
 |  |  |  |  |  | 2018
 |  |  |  |  |  | 2019
 |  |  |  |  |  | 2020
 |  |  |  |  |  | 2021
 |  |  |  |  |  | 2022
A
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2021 |  |  | Open
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2021 |  |  | Open
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | Closed
 |  |  | 1 |  |  | 2017 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | Open
 |  |  | 1 |  |  | 2020 |  |  | Open
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | Open
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | Closed
 |  |  | 1 |  |  | 2014 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2014 |  |  | Closed
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | Open
 |  |  | 1 |  |  | 2021 |  |  | Open
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | Open
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | closed
 |  |  | 1 |  |  | 2014 |  |  | Closed
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | closed
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2021 |  |  | Open
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2016 |  |  | Closed
B
 |  |  | 1 |  |  | 2021 |  |  | closed
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2014 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | Open
 |  |  | 1 |  |  | 2014 |  |  | Closed
 |  |  | 1 |  |  | 2021 |  |  | Open
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2017 |  |  | Closed
 |  |  | 1 |  |  | 2016 |  |  | Open
 |  |  | 1 |  |  | 2017 |  |  | Closed
 |  |  | 1 |  |  | 2021 |  |  | closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | Open
 |  |  | 1 |  |  | 2014 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2019 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | Open
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | closed
 |  |  | 1 |  |  | 2013 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | Closed
 |  |  | 1 |  |  | 2019 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | open
 |  |  | 1 |  |  | 2014 |  |  | Closed
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2014 |  |  | Closed
 |  |  | 1 |  |  | 2021 |  |  | closed
 |  |  | 1 |  |  | 2022 |  |  | open
 |  |  | 1 |  |  | 2016 |  |  | Open
 |  |  | 1 |  |  | 2017 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2017 |  |  | Closed
 |  |  | 1 |  |  | 2017 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2014 |  |  | Closed
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | open
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2014 |  |  | Closed
 |  |  | 1 |  |  | 2013 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | Open
 |  |  | 1 |  |  | 2014 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | Open
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | Open
 |  |  | 1 |  |  | 2022 |  |  | open
 |  |  | 1 |  |  | 2017 |  |  | Closed
 |  |  | 1 |  |  | 2021 |  |  | closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | closed
 |  |  | 1 |  |  | 2019 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | Open
 |  |  | 1 |  |  | 2014 |  |  | Closed
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2017 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | Open
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2021 |  |  | open
 |  |  | 1 |  |  | 2020 |  |  | Open
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | Open
 |  |  | 1 |  |  | 2021 |  |  | Open
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | Open
 |  |  | 1 |  |  | 2020 |  |  | Open
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2019 |  |  | Closed
 |  |  | 1 |  |  | 2016 |  |  | Closed
C
 |  |  | 1 |  |  | 2020 |  |  | Open
 |  |  | 1 |  |  | 2017 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | Open
 |  |  | 1 |  |  | 2021 |  |  | Open
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | Open
 |  |  | 1 |  |  | 2020 |  |  | Open
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2014 |  |  | Closed
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2014 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2017 |  |  | Closed
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2017 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2019 |  |  | Closed
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | Open
 |  |  | 1 |  |  | 2019 |  |  | Closed
 |  |  | 1 |  |  | 2020 |  |  | Open
 |  |  | 1 |  |  | 2020 |  |  | Open
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2019 |  |  | Open
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2021 |  |  | Open
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2016 |  |  | Closed
 |  |  | 1 |  |  | 2018 |  |  | Closed
 |  |  | 1 |  |  | 2014 |  |  | Closed