Loading pubs…
| Pub | Postcode | Area | Type | Status | Managed by | Ownership | CAMRA | Data quality | Actions |
|---|
No pubs match the current filters.
1
Paste JSON2
Review matches3
Resolve conflicts4
ApplyPaste a JSON array of pub objects. Each object should follow the clockapub extended schema. A single object is also accepted.
| Incoming name | Match | Matched pub | Confidence | Fields to update | Action |
|---|
Review field-level conflicts below. Green = incoming wins (higher confidence or new data). Amber = conflict — choose which value to keep. New pubs have no conflicts.
Open backlog
filtered
click a cell to filter the table below
| Theme | High | Medium | Low | Total |
|---|
Loading portal feedback…
| Date | Category | Message | From | Priority | Component | Status | Pub | Actions |
|---|
Page
No feedback matches current filters.
Loading user suggestions…
| Date | Type | Summary | Submitted By | Priority | Component | Status | Pub | Actions |
|---|
Page
No suggestions match current filters.
Status:
Loading claims…
No claims match the filter.
| Pub | Claimant email | Requested | Status | Decided | Actions |
|---|
Status:
● live
Loading invitations…
No invitations match the filter.
| Pub | Kind | Invitee | Inviter | Sent | Expires | Status | Actions |
|---|
Sport:
Country:
Querying TheSportsDB…
No leagues match. Try a different sport / country combination.
| League | Country | Season | Sport (clockapub) | Status | Action |
|---|
Adding a league here writes a row to
competitions with the TheSportsDB id in external_codes. The next time the importer Worker runs (cron Sunday 03:00 UTC, or on demand via /run), fixtures for the new league populate automatically.
Recent imports
Loading…
No
import_runs rows yet.| Started (UTC) | Duration | Status | Fetched | +Add | ~Upd | Skip | Errors | Trigger |
|---|
Scans existing pub data for evidence of amenities not yet tagged on
pubs.amenities. Tier 1 (free) reads menu data only. Each proposal lists the evidence — you review and apply per-row or in bulk.
Scanning menus…
No proposals — all eligible pubs already tagged, or no menu evidence found.
| Pub | Source | Evidence | Status |
|---|
Bio + amenity synthesis
Reads each pub's website with Haiku 4.5 and proposes a punter-facing bio plus structured amenity / policy claims with evidence quotes. Only suggests positive claims — never denies. Review per-row, then Apply to write to
pubs.bio and pubs.amenities. Pubs without a website URL or with thin homepages are flagged for manual.
Click Synthesize gaps to start. Each pub takes ~3 seconds.
| Pub | Quality | Bio preview | Amenities | Policies | Actions |
|---|
Pick a pub to synthesise
Broadcasts
One-off operator nudges to all active pubs. Shows on every landlord's dashboard as a banner + inbox card until they ack or snooze.
New broadcast
Title
Body
Priority
Starts
Ends
Audience
All active pubs (only option for now)
CTA label (optional)
CTA destination (optional)
Active
Loading…
No active broadcasts.
Past (last 20)
Loading…
No past broadcasts.
System Health
Live probe of every clockapub service — the Workers, Supabase (read + write), the Anthropic AI dependency, and TheSportsDB. Re-runs each time you open this tab.
Loading contacts…
| Name | Role(s) | Pub(s) | Last interaction | Source |
|---|
No contacts match the current filters.
Funnel — all pubs (click a stage to filter)
What each stage means
Loading pipeline…
No pubs match the current filters.
🏆 Add competition to clockapub
Auto-derived from TheSportsDB. Tweak before adding if needed.
TheSportsDB id
Name
Short name
Sport key
Country (2-letter)
Season