This project is a parser that scrapes inspection reports from the Napa Valley health department website and then prints the collected information from reports to the console in a tabular format as well as generating a json file with the data.
This website has a list of establishments and for each establishment a list of inspections that have been performed. For each inspection, there is a full report with details of the outcome.
Here is a sample search result for keyword: shop
This is an example of the report:
This project uses BeautifulSoup library to read information from the inspection reports for establishments. It loads all establishments, then parses information for each establishment, and finally parses inspection reports for each establishment.
Here is an example of the output:
Permit ID: 11367
Name: 1313 MAIN STREET
Address: 1313 MAIN ST
City: NAPA
State: CA
Zip code: 94559
Inspections:
Inspection ID: 409588
Inspection Type: Routine
Grade: A
Date: 11/02/2016
Violations:
Number: 35
Description: Equipment/Utensils - approved; installed; clean; good repair; capacity
Number: 44
Description: Premises; personal/cleaning items; vermin-proofing
Number: 48
Description: Plan Review
Inspection ID: 313513
Inspection Type: Routine
Grade: A
Date: 01/13/2016
Violations:
Number: 30
Description: Food storage; food storage containers identified
Inspection ID: 221606
Inspection Type: Routine
Grade: A
Date: 05/05/2015
Violations:
Number: 6
Description: Adequate handwashing facilities supplied & accessible
Number: 44
Description: Premises; personal/cleaning items; vermin-proofing
Inspection ID: 221340
Inspection Type: Routine
Grade: A
Date: 10/22/2014
Violations:
Number: 48
Description: Plan Review
Inspection ID: 221091
Inspection Type: Routine
Grade: A
Date: 04/15/2014
Violations:
Number: 35
Description: Equipment/Utensils - approved; installed; clean; good repair; capacity
Inspection ID: 150968
Inspection Type: Routine
Grade: A
Date: 09/24/2013
Violations:
Number: 18
Description: Compliance with variance, specialized process, & HACCP Plan
Inspection ID: 108409
Inspection Type: Routine
Grade: A
Date: 12/06/2012
Violations:
Inspection ID: 107912
Inspection Type: Routine
Grade: A
Date: 03/07/2012
Violations:
Number: 36
Description: Equipment, utensils and linens: storage and use
Inspection ID: 107199
Inspection Type: Routine
Grade: A
Date: 02/23/2011
Violations:
Permit ID: 249940
Name: 641 MAIN STREET
Address: 641 MAIN ST
City: SAINT HELENA
State: CA
Zip code: 94574
Inspections:
Inspection ID: 628555
Inspection Type: Routine
Grade: A
Date: 02/01/2018
Violations:
Inspection ID: 439495
Inspection Type: Routine
Grade: A
Date: 11/22/2016
Violations:
Number: 6
Description: Adequate handwashing facilities supplied & accessible
Number: 35
Description: Equipment/Utensils - approved; installed; clean; good repair; capacity
Inspection ID: 266543
Inspection Type: Routine
Grade: A
Date: 11/10/2015
Violations:
Number: 23
Description: No rodents, insects, birds, or animals
Number: 29
Description: Toxic substances properly identified, stored, used
Number: 34
Description: Warewashing facilities: installed, maintained, used; test strips
Inspection ID: 209267
Inspection Type: Routine
Grade: A
Date: 03/03/2015
Violations:
Number: 36
Description: Equipment, utensils and linens: storage and use
Inspection ID: 209147
Inspection Type: Routine
Grade: A
Date: 09/04/2014
Violations:
Number: 1
Description: Demonstration of knowledge; food safety certification; employee training