{"rows":[{"hospitalId":1,"hospitalSlug":"rb-spec-pgh","hospitalName":"Riverbend Specialty Pittsburgh","visitCount":8256,"revenueCents":601111500,"avgWaitMinutes":28,"walkoutRate":0.019743217054263566,"uniquePatients":1966},{"hospitalId":2,"hospitalSlug":"rb-er-cle","hospitalName":"Riverbend Emergency Cleveland","visitCount":7725,"revenueCents":514548000,"avgWaitMinutes":31,"walkoutRate":0.07313915857605179,"uniquePatients":1860},{"hospitalId":3,"hospitalSlug":"rb-uc-cmh","hospitalName":"Riverbend Urgent Care Columbus","visitCount":10948,"revenueCents":636028500,"avgWaitMinutes":28,"walkoutRate":0.017902813299232736,"uniquePatients":2495},{"hospitalId":4,"hospitalSlug":"rb-spec-akr","hospitalName":"Riverbend Specialty Akron","visitCount":1136,"revenueCents":85275000,"avgWaitMinutes":22,"walkoutRate":0.03169014084507042,"uniquePatients":593}],"network":{"visitCount":28065,"revenueCents":1836963000,"avgWaitMinutes":29,"walkoutRate":0.03561883244365463,"uniquePatients":6914},"_sql":"\n    SELECT\n      h.id, h.slug, h.name,\n      COUNT(v.id) AS visit_count,\n      COALESCE(SUM(v.revenue_cents), 0) AS revenue_cents,\n      COALESCE(AVG(v.wait_minutes), 0) AS avg_wait_minutes,\n      CAST(SUM(CASE WHEN v.status='walkout' THEN 1 ELSE 0 END) AS REAL) / NULLIF(COUNT(v.id), 0) AS walkout_rate,\n      COUNT(DISTINCT v.patient_id) AS unique_patients\n    FROM hospitals h\n    LEFT JOIN visits v ON v.hospital_id = h.id AND v.visit_date >= ?\n    GROUP BY h.id"}