Network · Riverbend Veterinary Group

Headline revenue is +8.0% YoY. Same-store is +1.2%.

Akron closed 2026-03-15. Excluding it ( $619.9K in the window ), organic revenue is roughly flat. The board narrative is the difference between those two numbers.

Disclosure: current-period revenue is real query output. The prior-year baseline is a synthetic calibration constant (current ÷ 1.08; ex-Akron ÷ 1.012) because this demo seed has no prior-year rows. The drawer SQL annotates exactly which half is which.

visits (240d)

23,915

4 hospitals · all PMS sources

revenue (240d)

$17.83M +8.0%

yoy +8.0% · ex-Akron +1.2%

avg wait

29m

visit-weighted network mean

unique patients

7,075

240-day window

Per-hospital, last 240 days

Click a column header to re-sort. Currently revenue desc.

Hospital	Visits	Revenue	Avg wait	Walkout %	Unique pts
Riverbend Specialty Pittsburgh	7,267	$8.16M	28m	2.0%	2,026
Riverbend Emergency Cleveland	6,450	$4.93M	32m	7.1%	1,910
Riverbend Urgent Care Columbus	9,196	$4.13M	28m	2.0%	2,548
Riverbend Specialty Akron	1,002	$619.9K	21m	1.8%	591

Window: 240d · queried live from D1 · press Q for the queries this page ran

SQL · this page ran 3 queries Q to toggle

Per-hospital overview

SELECT
  h.id, h.slug, h.name,
  COUNT(v.id) AS visit_count,
  COALESCE(SUM(v.revenue_cents), 0) AS revenue_cents,
  COALESCE(AVG(v.wait_minutes), 0) AS avg_wait_minutes,
  CAST(SUM(CASE WHEN v.status='walkout' THEN 1 ELSE 0 END) AS REAL) / NULLIF(COUNT(v.id), 0) AS walkout_rate,
  COUNT(DISTINCT v.patient_id) AS unique_patients
FROM hospitals h
LEFT JOIN visits v ON v.hospital_id = h.id AND v.visit_date >= ?
GROUP BY h.id

YoY (current = real query; prior = synthetic baseline)

-- Current-period revenue: REAL query output (this is what runs):
SELECT h.slug, COALESCE(SUM(v.revenue_cents), 0) AS rev_cents
    FROM hospitals h LEFT JOIN visits v ON v.hospital_id=h.id AND v.visit_date >= ?
    GROUP BY h.id

-- Prior-year baseline: SYNTHETIC CALIBRATION CONSTANT, not query output.
-- The demo seed only spans 2025-09-01 -> 2026-04-30, so there are no
-- prior-year visit rows. Prior-year revenue is derived as:
--   prior_total    = current_total    / 1.08
--   prior_ex_akron = current_ex_akron / 1.012
-- To make this real, seed 2024-09 -> 2025-04 visits and run the same SELECT
-- against the prior window, then compare the two SUMs.

28-day daily revenue sparkline

SELECT hospital_id, date, revenue_cents_total AS rev FROM aggregations_daily WHERE date >= 1777916808616 ORDER BY hospital_id, date

`1` – `0`	Jump to the ten dashboards (1 = charge integrity, 0 = audit log)
`/`	Focus the page's primary filter
`Q`	Toggle SQL inspector
`S`	Sort table by next column (table-focused only)
`?`	This help
`Esc`	Close anything open
`↑` `↓`	Move row focus inside a table