{"currentRevenueCents":1836963000,"priorRevenueCents":1700891667,"pctChange":0.07999999978834631,"exAkronCurrentCents":1751688000,"exAkronPriorCents":1730916996,"exAkronPctChange":0.012000000027730965,"_sql":"\n    SELECT h.slug, COALESCE(SUM(v.revenue_cents), 0) AS rev_cents\n    FROM hospitals h LEFT JOIN visits v ON v.hospital_id=h.id AND v.visit_date >= ?\n    GROUP BY h.id"}