Please note that this project is part of an ongoing project assessing impacts of COVID-19 in Toronto (https://torontoafterthefirstwave.com/). Datasets are collected from Yelp in May 2020, November 2020, and May 2021.
- View Dashboard: https://torontoafterthefirstwave.com/dashboards/restaurants/
- Spacing Toronto Magazine
- University of Toronto Magazine
- The Global and Mail
- Toronto Star Podcast
- Toronto Star News
Using SQL EXCEPT and SQL INTERSECT, operation statuses are differentiated into "Open", "New", and "Closed" by comparing datasets collected in May 2020 and November 2020:
By taking the aggregated data from previous assessment, we differentiated more cases:
where
| Case Letter | 2020 Dataset | 2021 Dataset | Description |
|---|---|---|---|
| a | New | Found | New - Newly opened between May 2020 and November 2020, and continued to be open in May 20210 |
| b | New | !Found | Closed - Newly opened between May 2020 and November 2020, and closed by May 2021 |
| c | Open | Found | Open - Open before May 2020 and continued to be open in May 2021 |
| d | Open | !Found | Closed - Open before May 2020 and continued to be open until November 2020 and closed before May 2021 |
| e | Closed | Found | Open - Open between May 2020 and November 2020, closed in November 2020, open again in May 2021 |
| f | Closed | !Found | Closed - Open in May 2020 and closed in November 2020 and still closed in May 2021 |
| g | N/A | Found | New - Newly opened between November 2020 and May 2021 |
Dataset from May 2020 is sourced from Kevin Bi