Average Health Score by Year and Month

Query Details

The chart above was generated by querying the LIVES Restaurat Inspection dataset. To see the raw JSON resonse for the SQL query below, click here.

SELECT substring("date" from 1 for 4) as Year, 
      substring("date" from 5 for 2) as Month, 
      avg(CAST(coalesce("score", '0') AS integer)) as averageScore 
    FROM "19426f05-1814-4447-b63b-23c33b3706a7" 
    GROUP BY 
      Year, Month 
    ORDER BY 
      Year, Month