Monthly Restaurant Inspection Report

[mgottholsen]

From @mgottholsen on June 28, 2017 17:48

See this article.
www.bizjournals.com/louisville/news/2017/04/12/these-louisville-restaurants-had-critical-food.html

Now, automate it.

Copied from original issue: mgottholsen#13

[mgottholsen]

@jorgefelico You up for tackling this one?

[mgottholsen]

From @jorgefelico on July 4, 2017 2:59

Sure am!

[mgottholsen]

See also https://github.com/LouisvilleMetro/IFTTT-Smart-Louisville/issues/11

[mgottholsen]

New Feature Description:

As an IFTTT user, I want to receive a time-based (daily, weekly, monthly, quarterly) digest of critical food code violations of all restaurants that have been inspected.

Template:

Restaurant Name, Address
Grade
Inspection Result (bulleted list)

[mgottholsen]

From @jorgefelico on November 22, 2017 14:20

@mgottholsen I'm working on this issue and noticed that our open data for the inspections does not have the inspection result as a list. We only have the score and grade. Here's a sample of one entry:

EstablishmentID: "27867",
InspectionID: "1320961",
EstablishmentName: "FUNNEL CAKE #5",
PlaceName: " ",
Address: "MOBILE UNIT",
Address2: null,
City: "LOUISVILLE",
State: "KY",
Zip: "40202",
TypeDescription: "SELF-CONTAINED MOBILE FOOD UNITS",
Latitude: "38.2527",
Longitude	: "-85.7585",
InspectionDate: "2017-09-03 00:00:00",
Score: "93",
Grade: "C",
NameSearch: "FUNNELCAKE",
Intersection: null

So, my proposal

Template

Restaurant Name, Address
Grade
Score

[mgottholsen]

There are a couple of different datasets that contain this information, but would require additional leg work.

We could pull just from Restaurant Inspection Scores. Or we could pull a query from the open data site that joins the following:

https://data.louisvilleky.gov/dataset/inspections
https://data.louisvilleky.gov/dataset/establishments

Or even:

https://data.louisvilleky.gov/dataset/yelp-data (the preview on this one does not automatically update, but the file download does. Or we could pull the files from S3)

Thoughts?

[mgottholsen]

Also, check out some of the other datasets https://data.louisvilleky.gov/group/health-wellness