post: cbf8b5b0adf5fe157b69dce113af5a1170eaa8f6
Data source: Myles' Garden Posts
This data as json
| _id | _path | text | html | type | name | summary | emoji | publishedAt | updatedAt | author | tags | location | syndication | inReplyTo | bookmarkOf | rsvp | likeOf | repostOf | visibility | cover | media | book | film | tvShowSeason | vinylRecord | listenOnUrls | playlist | leftHand | rightHand | readStatus | currentPage | event | watchStatus |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| cbf8b5b0adf5fe157b69dce113af5a1170eaa8f6 | src/content/posts/2024/03/16/toronto-dinesafe/index.md | As a lover of good food, I've always been curious about restaurant health inspections. So, I decided to take matters into my own hands and create a tool that makes it easy to explore Toronto's DineSafe data. [](https://dinesafe-toronto.slothful-myles.com "DineSafe Toronto — slothful-myles") I built a scraper using Python and the [sqlite-utils](https://sqlite-utils.datasette.io/en/stable/) library. It gathers data on restaurant inspections and stores it in a SQLite database. But I didn't stop there – I added some automation magic to make the process even more fun! Now, thanks to a [Github Actions workflow](https://github.com/myles/dinesafe-toronto/blob/main/.github/workflows/deploy.yml), the scraper runs every day at 9 am and deploys the database to an instance of [Datasette](https://datasette.io/) running on [Vercel](https://vercel.com/). Datasette is a super cool tool that lets you explore and visualize data in a fun and interactive way. So, whether you're a foodie, data enthusiast, or just curious about what's happening behind the scenes in your favorite restaurant, this project is for you. Check out the [Github repository](https://github.com/myles/dinesafe-toronto) to see the code and learn how to set up your own instance of the scraper. You can also explore the data and play around with visualizations on the [DineSafe Toronto website](https://dinesafe-toronto.slothful-myles.com/). | <p>As a lover of good food, I've always been curious about restaurant health inspections. So, I decided to take matters into my own hands and create a tool that makes it easy to explore Toronto's DineSafe data.</p> <p><a href="https://dinesafe-toronto.slothful-myles.com" title="DineSafe Toronto — slothful-myles"><img alt="Screenshot of the Datasette for DineSafe Toronto — slothful-myles" src="./dinesafe-toronto-datasette-screenshot.png" title="DineSafe Toronto — slothful-myles" /></a></p> <p>I built a scraper using Python and the <a href="https://sqlite-utils.datasette.io/en/stable/">sqlite-utils</a> library. It gathers data on restaurant inspections and stores it in a SQLite database. But I didn't stop there – I added some automation magic to make the process even more fun!</p> <p>Now, thanks to a <a href="https://github.com/myles/dinesafe-toronto/blob/main/.github/workflows/deploy.yml">Github Actions workflow</a>, the scraper runs every day at 9 am and deploys the database to an instance of <a href="https://datasette.io/">Datasette</a> running on <a href="https://vercel.com/">Vercel</a>.</p> <p>Datasette is a super cool tool that lets you explore and visualize data in a fun and interactive way. So, whether you're a foodie, data enthusiast, or just curious about what's happening behind the scenes in your favorite restaurant, this project is for you.</p> <p>Check out the <a href="https://github.com/myles/dinesafe-toronto">Github repository</a> to see the code and learn how to set up your own instance of the scraper. You can also explore the data and play around with visualizations on the <a href="https://dinesafe-toronto.slothful-myles.com/">DineSafe Toronto website</a>.</p> | article | Exploring Toronto's Restaurant Inspection Data with DineSafe | 2024-03-16T00:00:00-05:00 | ["software-engineering", "toronto", "projects"] | {"image": "./dinesafe-toronto-datasette-screenshot.png", "alt": "Screenshot of Datasette for DineSafe Toronto."} |