Restaurant Radar

Daily FEHD licence changes, classified into practical JuicySuite sales signals.

Syncing
LATEST SUCCESSFUL SNAPSHOT · CONNECTING

Reading the database from Google Sheets…

Restaurant Radar is loading the latest successful daily snapshot and lead queue.

✓
Connecting to live recordsPlease wait a moment
ONE PULSE · ONE OUTCOME

0 active signals

Syncing
0sales
leads

Each animated pulse represents one outcome. Its number and size show how many restaurant records it contains.

CURRENT RECORDS—

latest FEHD restaurant licences

NEW LICENCES—

new since the previous snapshot

CHANGED RECORDS—

including renewal and rebrand checks

FRESH LEADS—

stored in Tab 3 · new_leads

Daily archive and processed comparisons

Choose a month, then select a processed day to inspect its outcomes.

0 days · 0 processed

Four outcomes for the selected day.

Choose an outcome, then select any shop to inspect the evidence and full record details.

0sales candidates0renewals suppressed
Likely new restaurant

0 shops on this day

Sales review
No shops in this outcome

A new licence appears at a restaurant address that has never appeared in our snapshots. No matching changes were recorded for this day.

TAB 3 · NEW_LEADS

Sales candidates with contact readiness.

Every candidate includes the official licence address. Phone, email and website appear when public-contact enrichment has been completed.

Open live database ↗
0snapshots stored
—current rows
0latest leads loaded
—latest comparison
Tab 1current_restaurantsLatest full register
Tab 2change_logDetected differences
Tab 3new_leadsSales candidates
Tab 4contact_activityOutreach tracking
Tab 5snapshot_runsDaily run summaries
▦
new_leadsLoading latest snapshot
● Live data
DetectedLicence no.Restaurant and official addressDistrictSignalPublic contactContact status
Showing 0 of 0 latest lead rowsRefreshes from Google Sheets on demand and page load
WHY DAILY SNAPSHOTS MATTER

The comparison creates the classification.

The government feed tells us what exists today. Our ledger combines four fields to decide what sales should see.

01
ID

Compare licence

Identify licence numbers that are new, unchanged or missing.

Primary record identity
02
AD

Compare address

Separate a new venue from a possible operator change.

Location history
03
NM

Compare shop sign

Flag possible rebrands at an existing restaurant address.

Identity change
04
EX

Compare expiry

Suppress administrative renewals from the sales queue.

Renewal only
SNAPSHOT HISTORY

0 successful days.
The evidence stays small.

Every successful morning run stores a summary in the Sheet and preserves the compressed government source in Drive.

218 MBestimated restaurant-licence archive
Based on the latest compressed restaurant snapshot of approximately 612 KB per day.
↻
Next automatic snapshotScheduled daily around 09:30 HKT
Daily
Latest useful output0 candidates in new_leads

These rows are candidates, not confirmed openings. Verify the venue and enrich public contact details before outreach.