SELECT DISTINCT ON (location) location, time, report FROM weather_reports ORDER BY location, time DESC;