Final Pipeline
Steps marked ran as a script against the app database. Click one to see which.
01Reddit download
Arctic Shift
25,382 posts294,937 commentsAug 2023 – Aug 2026
02LLM extraction pipeline
- 1Extract restaurant mentions
- 2Rate each mention
- 3Find, rate, and canonicalize dish mentions
03Restaurant linking
- Fuzzy-merge raw name spellings into canonical restaurants
- LLM triage of names
- Match each restaurant to its Google Places listing
04Audit, part 1
- Pin census: every pin checked against its Reddit quotes
- Ambiguous-name sweep with full quote context (48k judgments)
- Shared-address pass for duplicates and dead predecessors
05Build the web-app database
Post-web-app passes
06Audit, part 2
Claude Code agents, run against the live DB
07Rating & presentation
- Dish tiers
- Mention glyphs (sentiment)