Restaurant Inspection Scores

**Overview**
This accelerator provides restaurant inspection scores, violations, grades and adjudication information for restaurants in New York City, Austin Texas, King county, San Fransisco in US and Oxford City Council in UK.

**Description**
Datasets in this accelerator contain data from both US and UK. The Department of Health and Mental Hygiene (DOHMH) inspects about 24,000 restaurants a year to monitor compliance with city and state food safety regulations in US. The Health Department conducts unannounced inspections of restaurants at least once a year. Inspectors check for compliance in food handling, food temperature, personal hygiene and vermin control. Each violation of a regulation gets a certain number of points. At the end of the inspection, the inspector totals the points, and this number is the restaurant's inspection score—the lower the score, the better the Grade. Restaurants with a score between 0 and 13 points earn an A, those with 14 to 27 points receive a B and those with 28 or more a C. A restaurant has two chances to earn an A in every inspection cycle. If it doesn’t earn an A on the first inspection, it’s scored but ungraded. An inspector goes back to the restaurant unannounced, typically within a month, to inspect it again and the re-inspection is graded. If the grade is a B or C, the restaurant will receive a grade card and a grade pending card. It can post either card until it has an opportunity to be heard at the Office of Administrative Trials and Hearings Health Tribunal. The datasets in this data package contain

**Benefits**
- before visiting a new restaurant, the diners can check the restaurant's score in order to decide if it's worth spending money.
- useful for new restauranteurs to check the scores of existing restaurants
- score are available for many cities across us

**License Information**
The use of John Snow Labs datasets is free for personal and research purposes. For commercial use please subscribe to the [Data Library](https://www.johnsnowlabs.com/marketplace/) on John Snow Labs website. The subscription will allow you to use all John Snow Labs datasets and data packages for commercial purposes.

**Included Datasets**
- [Approved Food Establishments in UK](https://www.johnsnowlabs.com/marketplace/approved-food-establishments-in-uk)
- This dataset contains a list of establishments in United Kingdom which are approved to handle, prepare or produce products of animal origin for which requirements are laid down in Regulation (EC) No 853/2004.
- [Food Hygiene Rating Data in Oxford City Council](https://www.johnsnowlabs.com/marketplace/food-hygiene-rating-data-in-oxford-city-council)
- This dataset provides the food hygiene rating or inspection result given to a business and reflects the standards of food hygiene found on the date of inspection or visit by the local authority. Businesses include restaurants, pubs, cafés, takeaways, hotels and other places consumers eat, as well as supermarkets. The data is held on behalf of local authorities participating in the Food Standards Agency's National Food Hygiene Rating Scheme (FHRS) in England, Northern Ireland and Wales.
- [Restaurant Inspection Scores in Austin Texas](https://www.johnsnowlabs.com/marketplace/restaurant-inspection-scores-in-austin-texas)
- This dataset provides restaurant scores for inspections performed within the last three years. It also provides the name of the restaurant as well as the location and address of the restaurants.
- [Restaurant Inspection Scores in King County](https://www.johnsnowlabs.com/marketplace/restaurant-inspection-scores-in-king-county)
- This dataset provides restaurant scores for inspections performed by the Health Department in King County, from 2006 to the present. It includes the name, location and address of the restaurants. This dataset is organized by business / inspection date / violation. Each row in this dataset is an inspection, and if an inspection at a particular business results in multiple violations there will be multiple rows for that business with the same inspection serial number.
- [Restaurant Inspection Scores in New York City](https://www.johnsnowlabs.com/marketplace/restaurant-inspection-scores-in-new-york-city)
- This dataset provides restaurant inspection scores, violations, grades and adjudication information for restaurants in New York City. It also provides the name as well as the location and address of the restaurants.
- [Restaurant Inspection Scores in San Francisco](https://www.johnsnowlabs.com/marketplace/restaurant-inspection-scores-in-san-francisco)
- This dataset provides restaurant scores for inspections performed by LIVES (Local Inspector Value-Entry Specification). It also provides the name of the restaurant as well as the location and address of the restaurants.

**Data Engineering Overview**
**We deliver high-quality data**
- Each dataset goes through 3 levels of quality review
- 2 Manual reviews are done by domain experts
- Then, an automated set of 60+ validations enforces every datum matches metadata & defined constraints
- Data is normalized into one unified type system
- All dates, unites, codes, currencies look the same
- All null values are normalized to the same value
- All dataset and field names are SQL and Hive compliant
- Data and Metadata
- Data is available in both CSV and Apache Parquet format, optimized for high read performance on distributed Hadoop, Spark & MPP clusters
- Metadata is provided in the open Frictionless Data standard, and its every field is normalized & validated
- Data Updates
- Data updates support replace-on-update: outdated foreign keys are deprecated, not deleted

**Our data is curated and enriched by domain experts**

Each dataset is manually curated by our team of doctors, pharmacists, public health & medical billing experts:
- Field names, descriptions, and normalized values are chosen by people who actually understand their meaning
- Healthcare & life science experts add categories, search keywords, descriptions and more to each dataset
- Both manual and automated data enrichment supported for clinical codes, providers, drugs, and geo-locations
- The data is always kept up to date – even when the source requires manual effort to get updates
- Support for data subscribers is provided directly by the domain experts who curated the data sets
- Every data source’s license is manually verified to allow for royalty-free commercial use and redistribution.

**Need Help?**
If you have questions about our products, contact us at [[e-mail]](mailto:[e-mail]).