health-data-NY

The SQL Code takes raw csv data on Health Inspections on each restaurant in the New York State and converts it into a Data Warehouse, allowing the user to access any data needed from the database. The string variables are converted into integer variables in the dataset so that it can be used for further data processing, the categories for the numerical variables are detailed in the code.

This is an example of the processed Fact file that was generated from the raw csv file, only the important columns were extracted and converted into numerical values for ease of statistical processing.

---

The raw csv can be found on the Food Service Establishment: Last Inspection page of the NY Health Data website. At the moment, the code used only works on the Food Service Establishment: Last Inspection dataset, however, code to convert other databases on the NY Health Data website is in the works.