👀 Who's seen what?

\n \n

\n {status === \"loading\" ? \"Checking your Letterboxd histories… 🎞 (first run takes a few seconds)\" : info}\n

\n {status !== \"loading\" && theme.films.length > 0 && (\n

\n
\n {f.title} {f.year && `(${f.year})`}\n
\n onToggleSeen(f, \"L\")} />\n onToggleSeen(f, \"J\")} />\n

\n )}\n

\n );\n}\n",[322,222,334],"381e2574-cae0-498b-90eb-637a0d429bba",67,["D",1781268689240],9,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport { chipsFor, Film, fmtRuntime, jwFilmUrl, letterboxdUrl, plexUrl, showtimesUrl } from \"./helpers.ts\";\n\n// small \"have I seen this before?\" pill, one per person\nfunction SeenPill(\n { who, seen, onClick }: { who: \"L\" | \"J\"; seen: boolean; onClick: () => void },\n) {\n return (\n {\n e.stopPropagation();\n onClick();\n }}\n title={`${who} has ${seen ? \"\" : \"not \"}seen this before`}\n className={`px-1.5 py-0.5 rounded-full text-[10px] font-bold border ${\n seen\n ? \"bg-neutral-700 border-neutral-600 text-neutral-200\"\n : \"border-neutral-700 text-neutral-600\"\n }`}\n >\n {who}{seen ? \" ✓\" : \"\"}\n \n );\n}\n\nconst inputCls =\n \"w-full rounded bg-neutral-800 border border-neutral-700 px-2 py-1.5 text-sm text-neutral-100 placeholder-neutral-500 focus:outline-none focus:border-amber-400\";\n\nfunction EditForm(\n { film, onSave, onCancel, onDelete }: {\n film: Film;\n onSave: (fields: Partial) => void;\n onCancel: () => void;\n onDelete: () => void;\n },\n) {\n const [f, setF] = useState({ ...film });\n const set = (k: string, v: string) => setF((p) => ({ ...p, [k]: v }));\n return (\n

\n set(\"title\", e.target.value)} placeholder=\"Title\" />\n

\n set(\"year\", e.target.value)} placeholder=\"Year\" />\n set(\"runtimeMin\", e.target.value)}\n placeholder=\"Runtime (min)\"\n inputMode=\"numeric\"\n />\n

\n set(\"language\", e.target.value)}\n placeholder=\"Language\"\n />\n set(\"whereToWatch\", e.target.value)}\n placeholder=\"Where to watch (e.g. Prime, Netflix, Plex, Cinema)\"\n />\n set(\"notes\", e.target.value)} placeholder=\"Notes\" />\n {film.watched && (\n \n Watched on (for the calendar)\n set(\"watchedAt\", e.target.value)}\n />\n \n )}\n

\n \n onSave({\n title: f.title,\n year: f.year,\n runtimeMin: Number(f.runtimeMin) || null,\n language: f.language,\n whereToWatch: f.whereToWatch,\n notes: f.notes,\n watchedAt: f.watchedAt,\n })}\n className=\"px-3 py-1.5 rounded bg-amber-400 text-neutral-900 text-sm font-semibold\"\n >\n Save\n \n \n {\n if (confirm(`Delete \"${film.title}\"?`)) onDelete();\n }}\n className=\"ml-auto px-3 py-1.5 rounded text-sm text-red-400 hover:bg-red-950\"\n >\n Delete\n \n

\n );\n}\n\nexport function FilmRow(\n { film, onToggleWatched, onToggleSeen, onSave, onDelete }: {\n film: Film;\n onToggleWatched: () => void;\n onToggleSeen: (who: \"L\" | \"J\") => void;\n onSave: (fields: Partial) => void;\n onDelete: () => void;\n },\n) {\n const [expanded, setExpanded] = useState(false);\n const [editing, setEditing] = useState(false);\n const chips = chipsFor(film.whereToWatch, film.title);\n const isCinema = /cinema/i.test(film.whereToWatch);\n\n // quick action on the right: rate it once watched, otherwise the full JustWatch picture\n const quick = film.watched\n ? { href: letterboxdUrl(film.title), label: \"★ rate\", title: \"Rate it on Letterboxd\" }\n : { href: jwFilmUrl(film), label: \"JW ↗\", title: \"Full availability picture on JustWatch\" };\n\n return (\n

\n \n ✓\n \n

setExpanded((e) => !e)}>\n

\n {film.title} {film.year && ({film.year})}\n

\n {film.imdbScore != null && (\n ⭐ {film.imdbScore.toFixed(1)}\n )}\n {film.tmdbScore != null && (\n \n ❤️ {Math.round(film.tmdbScore * 10)}%\n \n )}\n {film.runtimeMin ? {fmtRuntime(film.runtimeMin)} : null}\n {film.language && · {film.language}}\n {chips.map((ch) =>\n ch.href\n ? (\n e.stopPropagation()}\n title={`Open on ${ch.label}`}\n className={`px-1.5 py-0.5 rounded-full hover:ring-1 hover:ring-amber-400 ${ch.cls}`}\n >\n {ch.label}\n \n )\n : {ch.label}\n )}\n onToggleSeen(\"L\")} />\n onToggleSeen(\"J\")} />\n

\n {film.notes && !expanded && (\n

{film.notes}

\n )}\n

\n e.stopPropagation()}\n title={quick.title}\n className=\"shrink-0 px-2 py-1 rounded bg-neutral-800 text-amber-300 text-xs font-semibold hover:bg-neutral-700\"\n >\n {quick.label}\n \n

\n\n {expanded && !editing && (\n

\n {film.people &&

{film.people}

}\n {film.genre &&

{film.genre}

}\n {film.whereToWatch && (\n

\n Where to watch: {film.whereToWatch}\n

\n )}\n {film.notes &&

{film.notes}

}\n

\n \n JustWatch ↗\n \n \n Plex ↗\n \n \n Letterboxd ↗\n \n {isCinema && (\n \n Showtimes ↗\n \n )}\n \n

\n )}\n\n {expanded && editing && (\n setEditing(false)}\n onDelete={onDelete}\n onSave={(fields) => {\n onSave(fields);\n setEditing(false);\n }}\n />\n )}\n

\n );\n}\n",[322,222,120],"4d0149d2-6f77-44a0-a19d-fdfb2d3d1b72","CalendarView.tsx","80dbc68a-665d-11f1-8596-1607ee4eb77e",70,["D",1781268733049],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport { Film, Theme } from \"./helpers.ts\";\n\nconst MONTHS = [\n \"January\",\n \"February\",\n \"March\",\n \"April\",\n \"May\",\n \"June\",\n \"July\",\n \"August\",\n \"September\",\n \"October\",\n \"November\",\n \"December\",\n];\n\nfunction parseMonthLabel(label: string): { year: number; month: number } | null {\n const m = label.trim().match(/^([a-z]+)\\s+(\\d{4})$/i);\n if (!m) return null;\n const month = MONTHS.findIndex((name) => name.toLowerCase().startsWith(m[1].toLowerCase().slice(0, 3)));\n if (month < 0) return null;\n return { year: Number(m[2]), month };\n}\n\nfunction Poster({ film, size }: { film: Film; size: string }) {\n return film.posterUrl\n ? (\n \n )\n : (\n \n {film.title.slice(0, 14)}\n \n );\n}\n\nfunction MonthCalendar(\n { themes, year, month, onBack }: { themes: Theme[]; year: number; month: number; onBack: () => void },\n) {\n const prefix = `${year}-${String(month + 1).padStart(2, \"0\")}`;\n const all = themes.flatMap((t) => t.films);\n const byDay = new Map();\n for (const f of all) {\n if (f.watched && f.watchedAt.startsWith(prefix)) {\n const day = Number(f.watchedAt.slice(8, 10));\n byDay.set(day, [...(byDay.get(day) ?? []), f]);\n }\n }\n // the month's theme(s) — for the header and for watched-but-undated films\n const monthThemes = themes.filter((t) => {\n const p = parseMonthLabel(t.monthLabel);\n return p && p.year === year && p.month === month;\n });\n const undated = monthThemes.flatMap((t) => t.films.filter((f) => f.watched && !f.watchedAt));\n\n const daysInMonth = new Date(year, month + 1, 0).getDate();\n const firstWeekday = (new Date(year, month, 1).getDay() + 6) % 7; // Monday-first\n const cells: (number | null)[] = [\n ...Array.from({ length: firstWeekday }, () => null),\n ...Array.from({ length: daysInMonth }, (_, i) => i + 1),\n ];\n\n return (\n

\n {MONTHS[month]} {year}\n {monthThemes.map((t) => {t.emoji} {t.name})}\n

\n \n

\n {[\"Mo\", \"Tu\", \"We\", \"Th\", \"Fr\", \"Sa\", \"Su\"].map((d) =>

{d}

)}\n

\n {cells.map((day, i) => (\n \n {day && (\n <>\n

{day}

\n {(byDay.get(day) ?? []).map((f) => )}\n

\n \n )}\n

\n ))}\n

\n {undated.length > 0 && (\n

\n Watched this month, date unknown — tap a film's edit to set one:\n

\n {undated.map((f) => )}\n

\n )}\n {byDay.size === 0 && undated.length === 0 && (\n

No watches logged this month 🍿

\n )}\n \n );\n}\n\nexport function CalendarView({ themes }: { themes: Theme[] }) {\n const now = new Date();\n const [year, setYear] = useState(now.getFullYear());\n const [month, setMonth] = useState(null);\n\n if (month !== null) {\n return setMonth(null)} />;\n }\n\n return (\n

\n \n

{year}

\n \n

\n {MONTHS.map((name, m) => {\n const monthThemes = themes.filter((t) => {\n const p = parseMonthLabel(t.monthLabel);\n return p && p.year === year && p.month === m;\n });\n const films = monthThemes.flatMap((t) => t.films);\n const watched = films.filter((f) => f.watched).length;\n const pct = films.length ? Math.round((watched / films.length) * 100) : 0;\n const prefix = `${year}-${String(m + 1).padStart(2, \"0\")}`;\n const datedWatches = themes.flatMap((t) => t.films).filter((f) => f.watchedAt.startsWith(prefix)).length;\n const hasContent = monthThemes.length > 0 || datedWatches > 0;\n return (\n setMonth(m)}\n className={`text-left rounded-lg p-3 border ${\n hasContent\n ? \"bg-neutral-900 border-neutral-700 hover:border-amber-400\"\n : \"bg-neutral-900/40 border-neutral-800 text-neutral-600\"\n }`}\n >\n

{name}

\n {monthThemes.length > 0\n ? (\n <>\n

{monthThemes.map((t) => t.emoji).join(\" \")}

\n {monthThemes.map((t) => t.name).join(\" · \")}\n

\n {watched}/{films.length} · {pct}%\n

\n \n )\n : (\n

\n {datedWatches > 0 ? `${datedWatches} watch${datedWatches > 1 ? \"es\" : \"\"} 🍿` : \"—\"}\n

\n )}\n \n );\n })}\n

tap a month for the poster calendar

\n );\n}\n",[322,222,347],"c381d358-da3f-4466-b7a3-8f4d1ff563ec",["D",1781268762239],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useMemo, useRef, useState } from \"https://esm.sh/react@18.2.0\";\nimport { api, Film, fmtRuntime, Theme } from \"./helpers.ts\";\nimport { FilmRow } from \"./FilmRow.tsx\";\nimport { SeenSetup } from \"./SeenSetup.tsx\";\nimport { CalendarView } from \"./CalendarView.tsx\";\n\nconst inputCls =\n \"rounded bg-neutral-800 border border-neutral-700 px-2 py-1.5 text-sm text-neutral-100 placeholder-neutral-500 focus:outline-none focus:border-amber-400\";\n\nfunction AddFilmForm({ themeId, onAdded }: { themeId: number; onAdded: () => void }) {\n const [open, setOpen] = useState(false);\n const [f, setF] = useState({ title: \"\", year: \"\", runtimeMin: \"\", whereToWatch: \"\", notes: \"\" });\n if (!open) {\n return (\n setOpen(true)}\n className=\"w-full py-2.5 rounded-lg border-2 border-dashed border-neutral-700 text-neutral-400 text-sm hover:border-amber-400 hover:text-amber-300\"\n >\n + Add a film\n \n );\n }\n const set = (k: string, v: string) => setF((p) => ({ ...p, [k]: v }));\n return (\n

\n set(\"title\", e.target.value)}\n placeholder=\"Title *\"\n />\n

\n set(\"year\", e.target.value)} placeholder=\"Year\" />\n set(\"runtimeMin\", e.target.value)}\n placeholder=\"Runtime (min)\"\n inputMode=\"numeric\"\n />\n

\n set(\"whereToWatch\", e.target.value)}\n placeholder=\"Where to watch (Prime, Netflix, Cinema…)\"\n />\n set(\"notes\", e.target.value)} placeholder=\"Notes\" />\n

\n {\n await api(\"/api/films\", \"POST\", {\n themeId,\n title: f.title.trim(),\n year: f.year,\n runtimeMin: Number(f.runtimeMin) || null,\n whereToWatch: f.whereToWatch,\n notes: f.notes,\n });\n setF({ title: \"\", year: \"\", runtimeMin: \"\", whereToWatch: \"\", notes: \"\" });\n setOpen(false);\n onAdded();\n }}\n >\n Add film\n \n \n

\n );\n}\n\nfunction KindSelect({ value, onChange }: { value: string; onChange: (v: string) => void }) {\n return (\n \n );\n}\n\nfunction ThemeSettings({ theme, onDone }: { theme: Theme; onDone: () => void }) {\n const [f, setF] = useState({\n name: theme.name,\n emoji: theme.emoji,\n monthLabel: theme.monthLabel,\n kind: theme.kind,\n });\n const set = (k: string, v: string) => setF((p) => ({ ...p, [k]: v }));\n return (\n

\n set(\"emoji\", e.target.value)} placeholder=\"🎬\" />\n set(\"name\", e.target.value)}\n placeholder=\"Theme name\"\n />\n

\n set(\"kind\", v)} />\n set(\"monthLabel\", e.target.value)}\n placeholder={f.kind === \"monthly\" ? \"Month (e.g. July 2026)\" : \"Label (optional)\"}\n />\n

\n {\n await api(`/api/themes/${theme.id}`, \"PATCH\", f);\n onDone();\n }}\n >\n Save\n \n \n {\n if (!confirm(`Delete \"${theme.name}\" and all ${theme.films.length} films in it?`)) return;\n await api(`/api/themes/${theme.id}`, \"DELETE\");\n onDone();\n }}\n >\n Delete theme\n \n

\n );\n}\n\nfunction NewThemeForm({ onDone }: { onDone: (newId?: number) => void }) {\n const [f, setF] = useState({ name: \"\", emoji: \"\", monthLabel: \"\", kind: \"monthly\" });\n const set = (k: string, v: string) => setF((p) => ({ ...p, [k]: v }));\n return (\n

\n set(\"emoji\", e.target.value)} placeholder=\"🎬\" />\n set(\"name\", e.target.value)}\n placeholder=\"Theme name *\"\n />\n

\n set(\"kind\", v)} />\n set(\"monthLabel\", e.target.value)}\n placeholder={f.kind === \"monthly\" ? \"Month (e.g. July 2026)\" : \"Label (optional)\"}\n />\n

\n {\n const r = (await api(\"/api/themes\", \"POST\", f)) as { id: number };\n onDone(r.id);\n }}\n >\n Create theme\n \n \n

\n );\n}\n\nexport function App() {\n const [themes, setThemes] = useState(null);\n const [activeId, setActiveId] = useState(null);\n const [sortBy, setSortBy] = useState<\"order\" | \"runtime\" | \"year\" | \"title\">(\"order\");\n const [hideWatched, setHideWatched] = useState(false);\n const [search, setSearch] = useState(\"\");\n const [showSettings, setShowSettings] = useState(false);\n const [showNewTheme, setShowNewTheme] = useState(false);\n const [showSeenSetup, setShowSeenSetup] = useState(false);\n const [view, setView] = useState<\"films\" | \"calendar\">(\"films\");\n const [error, setError] = useState(\"\");\n const ratingsTried = useRef(new Set());\n\n const load = async () => {\n try {\n const d = (await api(\"/api/state\")) as { themes: Theme[] };\n setThemes(d.themes);\n setActiveId((cur) => (cur !== null && d.themes.some((t) => t.id === cur)) ? cur : d.themes[0]?.id ?? null);\n setError(\"\");\n } catch {\n setError(\"Couldn't sync — check your connection and pull to refresh.\");\n }\n };\n\n useEffect(() => {\n load();\n const onVis = () => {\n if (document.visibilityState === \"visible\") load();\n };\n document.addEventListener(\"visibilitychange\", onVis);\n window.addEventListener(\"focus\", onVis);\n const iv = setInterval(onVis, 60_000);\n return () => {\n document.removeEventListener(\"visibilitychange\", onVis);\n window.removeEventListener(\"focus\", onVis);\n clearInterval(iv);\n };\n }, []);\n\n const active = themes?.find((t) => t.id === activeId) ?? null;\n\n // fetch IMDb/TMDB ratings + posters for newly added films when a theme is viewed\n useEffect(() => {\n if (!active || ratingsTried.current.has(active.id)) return;\n if (active.films.some((f) => f.ratingsAt === null)) {\n ratingsTried.current.add(active.id);\n api(`/api/themes/${active.id}/fetch-ratings`, \"POST\").then(load).catch(() => {});\n }\n }, [active]);\n\n const films = useMemo(() => {\n if (!active) return [];\n let list = [...active.films];\n if (hideWatched) list = list.filter((f) => !f.watched);\n const q = search.trim().toLowerCase();\n if (q) {\n list = list.filter((f) =>\n [f.title, f.year, f.people, f.genre, f.language, f.notes, f.whereToWatch].join(\" \").toLowerCase().includes(q)\n );\n }\n const cmp: Record number> = {\n order: (a, b) => a.id - b.id,\n runtime: (a, b) => (a.runtimeMin ?? 9999) - (b.runtimeMin ?? 9999),\n year: (a, b) => a.year.localeCompare(b.year),\n title: (a, b) => a.title.localeCompare(b.title),\n };\n return list.sort(cmp[sortBy]);\n }, [active, hideWatched, search, sortBy]);\n\n // optimistic toggles so taps feel instant on phones\n const patchFilm = async (film: Film, key: \"seenL\" | \"seenJ\" | \"watched\") => {\n const next = !film[key];\n setThemes((ts) =>\n ts?.map((t) => ({\n ...t,\n films: t.films.map((f) => f.id === film.id ? { ...f, [key]: next } : f),\n })) ?? null\n );\n try {\n await api(`/api/films/${film.id}`, \"PATCH\", { [key]: next });\n } catch {\n load(); // revert to server truth\n }\n };\n\n if (!themes) {\n return

Loading the watchlist… 🍿

;\n }\n\n const watchedCount = active ? active.films.filter((f) => f.watched).length : 0;\n const total = active?.films.length ?? 0;\n const minsLeft = active\n ? active.films.filter((f) => !f.watched).reduce((s, f) => s + (f.runtimeMin ?? 0), 0)\n : 0;\n const pct = total ? Math.round((watchedCount / total) * 100) : 0;\n const monthly = themes.filter((t) => t.kind !== \"ongoing\");\n const ongoing = themes.filter((t) => t.kind === \"ongoing\");\n\n const themeTab = (t: Theme) => {\n const done = t.films.filter((f) => f.watched).length;\n const isActive = t.id === activeId;\n return (\n {\n setActiveId(t.id);\n setShowSettings(false);\n setSearch(\"\");\n }}\n className={`shrink-0 px-3 py-1.5 rounded-full text-sm whitespace-nowrap border ${\n isActive\n ? \"bg-amber-400 text-neutral-900 border-amber-400 font-semibold\"\n : t.kind === \"ongoing\"\n ? \"bg-neutral-900 border-dashed border-neutral-600 text-neutral-300\"\n : \"bg-neutral-900 border-neutral-700 text-neutral-300\"\n }`}\n >\n {t.emoji} {t.name}{\" \"}\n \n {done}/{t.films.length}\n \n \n );\n };\n\n return (\n

🍿 Movie Months

\n setView((v) => v === \"films\" ? \"calendar\" : \"films\")}\n className=\"px-2.5 py-1 rounded-full border border-neutral-700 text-xs text-neutral-300 hover:border-amber-400\"\n >\n {view === \"films\" ? \"🗓 calendar\" : \"📋 lists\"}\n \n \n L + J\n \n

\n\n {error &&

{error}

}\n\n {view === \"calendar\" && }\n\n {view === \"films\" && (\n <>\n \n\n {showNewTheme && (\n {\n setShowNewTheme(false);\n await load();\n if (newId) {\n // new theme flow: jump straight into the \"who's seen what\" setup\n setActiveId(newId);\n setShowSeenSetup(true);\n }\n }}\n />\n )}\n\n {active && (\n <>\n

\n \n {active.kind === \"ongoing\" ? \"📌 ongoing\" : active.monthLabel}\n \n \n watched {watchedCount}/{total}\n {minsLeft > 0 && <> · {fmtRuntime(minsLeft)} to go}\n \n

\n {\n setShowSeenSetup((s) => !s);\n setShowSettings(false);\n }}\n className=\"text-neutral-500 hover:text-amber-300 text-sm\"\n title=\"Mark who's seen what (prefills from Letterboxd)\"\n >\n 👀\n \n {\n setShowSettings((s) => !s);\n setShowSeenSetup(false);\n }}\n className=\"text-neutral-500 hover:text-amber-300 text-sm\"\n title=\"Theme settings\"\n >\n ⚙︎\n \n

\n\n {showSettings && (\n {\n setShowSettings(false);\n load();\n }}\n />\n )}\n\n {showSeenSetup && (\n patchFilm(f, who === \"L\" ? \"seenL\" : \"seenJ\")}\n onRefresh={load}\n onClose={() => setShowSeenSetup(false)}\n />\n )}\n\n {!showSeenSetup && (\n <>\n

\n setSearch(e.target.value)}\n placeholder={`Search ${total} films…`}\n />\n setSortBy(e.target.value as typeof sortBy)}\n >\n \n \n \n \n \n setHideWatched((h) => !h)}\n className={`shrink-0 px-2.5 py-1.5 rounded text-sm border ${\n hideWatched ? \"bg-amber-400 text-neutral-900 border-amber-400\" : \"border-neutral-700 text-neutral-400\"\n }`}\n title=\"Hide films you've already watched together\"\n >\n {hideWatched ? \"👁 hidden\" : \"hide ✓\"}\n \n

\n\n

patchFilm(f, \"watched\")}\n onToggleSeen={(who) => patchFilm(f, who === \"L\" ? \"seenL\" : \"seenJ\")}\n onSave={async (fields) => {\n await api(`/api/films/${f.id}`, \"PATCH\", fields);\n load();\n }}\n onDelete={async () => {\n await api(`/api/films/${f.id}`, \"DELETE\");\n load();\n }}\n />\n ))}\n {!films.length && (\n

\n {search ? \"No films match.\" : \"Nothing here yet — add your first film!\"}\n

\n )}\n

\n\n \n \n )}\n \n )}\n\n \n

\n );\n}\n",[322,222,101],"pulls","branches","forks","envVars",{"_96":99,"_365":99},"connections",{"_96":99,"_364":99},"unfilledCount","emptyCount",{"_49":478,"_13":453,"_87":448,"_58":-5,"_51":52,"_316":97,"_317":24,"_53":479,"_55":99,"_90":223,"_319":-5,"_92":30,"_320":-5,"_389":480,"_17":481},{"_49":470,"_13":471,"_87":472,"_58":448,"_51":52,"_316":473,"_317":24,"_53":474,"_55":343,"_90":91,"_319":475,"_92":30,"_320":-5,"_389":476,"_17":477},{"_49":462,"_13":463,"_87":464,"_58":448,"_51":52,"_316":465,"_317":24,"_53":466,"_55":99,"_90":91,"_319":467,"_92":30,"_320":-5,"_389":468,"_17":469},{"_49":454,"_13":455,"_87":456,"_58":448,"_51":52,"_316":457,"_317":24,"_53":458,"_55":99,"_90":91,"_319":459,"_92":30,"_320":-5,"_389":460,"_17":461},{"_49":445,"_13":446,"_87":447,"_58":448,"_51":52,"_316":97,"_317":24,"_53":449,"_55":99,"_90":21,"_319":450,"_92":30,"_320":-5,"_389":451,"_17":452},{"_49":441,"_13":322,"_87":315,"_58":-5,"_51":52,"_316":26,"_317":24,"_53":442,"_55":99,"_90":223,"_319":-5,"_92":30,"_320":-5,"_389":443,"_17":444},{"_49":314,"_13":222,"_87":221,"_58":315,"_51":52,"_316":26,"_317":24,"_53":438,"_55":99,"_90":223,"_319":-5,"_92":30,"_320":-5,"_389":439,"_17":440},{"_49":353,"_13":101,"_87":100,"_58":221,"_51":52,"_316":263,"_317":24,"_53":435,"_55":160,"_90":91,"_319":355,"_92":30,"_320":-5,"_389":436,"_17":437},{"_49":346,"_13":347,"_87":348,"_58":221,"_51":52,"_316":349,"_317":24,"_53":432,"_55":97,"_90":91,"_319":351,"_92":30,"_320":-5,"_389":433,"_17":434},{"_49":340,"_13":120,"_87":119,"_58":221,"_51":52,"_316":341,"_317":24,"_53":429,"_55":343,"_90":91,"_319":344,"_92":30,"_320":-5,"_389":430,"_17":431},{"_49":333,"_13":334,"_87":335,"_58":221,"_51":52,"_316":336,"_317":24,"_53":426,"_55":97,"_90":91,"_319":338,"_92":30,"_320":-5,"_389":427,"_17":428},{"_49":328,"_13":111,"_87":110,"_58":221,"_51":52,"_316":329,"_317":24,"_53":423,"_55":114,"_90":91,"_319":331,"_92":30,"_320":-5,"_389":424,"_17":425},{"_49":415,"_13":416,"_87":417,"_58":315,"_51":52,"_316":418,"_317":24,"_53":419,"_55":26,"_90":21,"_319":420,"_92":30,"_320":-5,"_389":421,"_17":422},{"_49":408,"_13":409,"_87":410,"_58":315,"_51":52,"_316":343,"_317":24,"_53":411,"_55":26,"_90":21,"_319":412,"_92":30,"_320":-5,"_389":413,"_17":414},{"_49":401,"_13":402,"_87":403,"_58":315,"_51":52,"_316":26,"_317":24,"_53":404,"_55":99,"_90":91,"_319":405,"_92":30,"_320":-5,"_389":406,"_17":407},{"_49":392,"_13":393,"_87":394,"_58":-5,"_51":52,"_316":395,"_317":24,"_53":396,"_55":397,"_90":21,"_319":398,"_92":30,"_320":-5,"_389":399,"_17":400},{"_49":383,"_13":384,"_87":236,"_58":-5,"_51":52,"_316":385,"_317":24,"_53":386,"_55":130,"_90":387,"_319":388,"_92":30,"_320":-5,"_389":390,"_17":391},"0496cd60-9cb7-482a-b1b2-89df551e4b3d","index.ts",60,["D",1781268564744],"http","import { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { Hono } from \"npm:hono\";\nimport { ensureDb, FILM_FIELDS, getState } from \"./backend/db.ts\";\nimport { prefillSeen } from \"./backend/letterboxd.ts\";\nimport { fetchRatings } from \"./backend/ratings.ts\";\n\nfunction londonToday(): string {\n return new Date().toLocaleDateString(\"en-CA\", { timeZone: \"Europe/London\" });\n}\n\nconst app = new Hono();\n\n// Serve index.html at the root /\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\n\n// Serve all /frontend files\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\n\n// View source redirect\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\nconst ready = ensureDb();\napp.use(\"/api/*\", async (_c, next) => {\n await ready;\n await next();\n});\n\napp.get(\"/api/state\", async (c) => c.json(await getState()));\n\napp.post(\"/api/themes\", async (c) => {\n const b = await c.req.json();\n if (!b.name) return c.json({ error: \"name required\" }, 400);\n const max = await sqlite.execute(\"SELECT COALESCE(MAX(sort_order), 0) AS m FROM themes_v1\");\n const kind = b.kind === \"ongoing\" ? \"ongoing\" : \"monthly\";\n const r = await sqlite.execute({\n sql: \"INSERT INTO themes_v1 (name, emoji, month_label, sort_order, kind) VALUES (?, ?, ?, ?, ?)\",\n args: [String(b.name), String(b.emoji ?? \"\"), String(b.monthLabel ?? \"\"), Number(max.rows[0].m) + 1, kind],\n });\n return c.json({ id: Number(r.lastInsertRowid) });\n});\n\napp.patch(\"/api/themes/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const b = await c.req.json();\n const fields: Record = { name: \"name\", emoji: \"emoji\", monthLabel: \"month_label\", kind: \"kind\" };\n const sets: string[] = [];\n const args: (string | number)[] = [];\n for (const [k, col] of Object.entries(fields)) {\n if (k in b) {\n sets.push(`${col} = ?`);\n args.push(k === \"kind\" && b[k] !== \"ongoing\" ? \"monthly\" : String(b[k]));\n }\n }\n if (!sets.length) return c.json({ error: \"no fields\" }, 400);\n args.push(id);\n await sqlite.execute({ sql: `UPDATE themes_v1 SET ${sets.join(\", \")} WHERE id = ?`, args });\n return c.json({ ok: true });\n});\n\n// one-time \"who's seen what\" setup: prefill from Letterboxd histories\napp.post(\"/api/themes/:id/prefill-seen\", async (c) => {\n return c.json(await prefillSeen(Number(c.req.param(\"id\"))));\n});\n\napp.delete(\"/api/themes/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n await sqlite.batch([\n { sql: \"DELETE FROM films_v1 WHERE theme_id = ?\", args: [id] },\n { sql: \"DELETE FROM themes_v1 WHERE id = ?\", args: [id] },\n ]);\n return c.json({ ok: true });\n});\n\napp.post(\"/api/films\", async (c) => {\n const b = await c.req.json();\n if (!b.themeId || !b.title) return c.json({ error: \"themeId and title required\" }, 400);\n const r = await sqlite.execute({\n sql: `INSERT INTO films_v1\n (theme_id, title, year, runtime_min, language, genre, people, where_to_watch, notes, seen_l, seen_j)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, 0, 0)`,\n args: [\n Number(b.themeId),\n String(b.title),\n String(b.year ?? \"\"),\n b.runtimeMin ? Number(b.runtimeMin) : null,\n String(b.language ?? \"\"),\n String(b.genre ?? \"\"),\n String(b.people ?? \"\"),\n String(b.whereToWatch ?? \"\"),\n String(b.notes ?? \"\"),\n ],\n });\n return c.json({ id: Number(r.lastInsertRowid) });\n});\n\n// ratings/poster lookup via JustWatch for films not yet checked (?force=1 re-checks all)\napp.post(\"/api/themes/:id/fetch-ratings\", async (c) => {\n const force = c.req.query(\"force\") === \"1\";\n return c.json(await fetchRatings(Number(c.req.param(\"id\")), force));\n});\n\napp.patch(\"/api/films/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const b = await c.req.json();\n // ticking ✓ stamps today's date for the calendar; unticking clears it\n if (\"watched\" in b && !(\"watchedAt\" in b)) {\n b.watchedAt = b.watched ? londonToday() : \"\";\n }\n const sets: string[] = [];\n const args: (string | number | null)[] = [];\n for (const [k, col] of Object.entries(FILM_FIELDS)) {\n if (!(k in b)) continue;\n sets.push(`${col} = ?`);\n if (k === \"seenL\" || k === \"seenJ\" || k === \"watched\") args.push(b[k] ? 1 : 0);\n else if (k === \"runtimeMin\") args.push(b[k] === null || b[k] === \"\" ? null : Number(b[k]));\n else args.push(String(b[k]));\n }\n if (!sets.length) return c.json({ error: \"no fields\" }, 400);\n args.push(id);\n await sqlite.execute({ sql: `UPDATE films_v1 SET ${sets.join(\", \")} WHERE id = ?`, args });\n return c.json({ ok: true });\n});\n\napp.delete(\"/api/films/:id\", async (c) => {\n await sqlite.execute({ sql: \"DELETE FROM films_v1 WHERE id = ?\", args: [Number(c.req.param(\"id\"))] });\n return c.json({ ok: true });\n});\n\n// Unwrap and rethrow Hono errors as the original error\n// If you delete this, all errors will be \"Internal Server Error\"\napp.onError((err) => Promise.reject(err));\n\n// HTTP vals expect an exported \"fetch handler\"\n// This is how you \"run the server\" in Val Town with Hono\nexport default app.fetch;\n","children",[],[384],"55ecf12a-06b2-46c0-af0e-0335274d64bc","README.md","019ebb7e-81ba-746e-81b0-8f90d9071a20",54,["D",1781267948707],3,"# 🍿 Movie Months\n\nA shared movie tracker for L + J. Monthly themes (Scandinapril, Star Wars, Spielberg…) plus\n📌 ongoing lists (Best Picture winners, James Bond) that get worked through adhoc, in order.\n\n## The model\n\n- **Big ✓** — you watched it together (you always do). This drives progress and \"hide ✓\".\n- **L / J pills** — that person had seen the film *before* the theme started. Point-in-time:\n the **👀 seen setup** runs once per theme and prefills from Letterboxd histories\n (ltraino + freethechurro), so you only correct by exception. Creating a new theme drops\n you straight into it.\n- **Service chips are clickable** — like JustWatch's platform logos: tap Prime/Netflix/\n Disney+/MUBI/BFI/Plex/iPlayer/ITVX to open that service's page for the film. Rent/Buy\n only shows when there's no included option. **JW ↗** gives the full availability picture.\n- **★ rate** — once watched, the quick link becomes a Letterboxd search to log/rate it.\n- Tap a title for all links (JustWatch / Plex / Letterboxd / showtimes), details, edit, delete.\n- Default sort is **list order** (the order films were added — chronological for Star Wars,\n Bond and Best Picture); shortest-first, year and A–Z also available.\n\n## Data\n\nLives in the val's SQLite database (`themes_v1`, `films_v1`). Seeded from the original\nspreadsheets in June 2026. The app re-syncs whenever the tab regains focus, so two phones\nstay in step. No login — anyone with the URL can tick and edit.\n\nPlex links open a search across whatever servers the logged-in Plex account can reach.\n",[],[393],"6d2c9915-c9d9-4abe-9e7c-451dcfb71fd1","index.tsx","019ebb7e-81ba-746e-81b0-84070e687499",["D",1781262090577],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = document.getElementById(\"root\");\nif (!root) {\n throw new Error(\"No root element found\");\n}\n\ncreateRoot(root).render();",[],[322,402],"a0412686-c7be-42b8-b481-54e25ec583b6","index.html","019ebb7e-81ba-746e-81b0-8373e153fe59",["D",1781263577126],"\n\n \n \n \n Movie Months 🍿\n \n \n \n \n \n

\n \n \n \n\n",[],[322,409],"525318b0-2336-40cf-9953-5e484e7aaee6","favicon.svg","019ebb7e-81ba-746e-81b0-7c1045a402d1",11,["D",1781263582994],"\n",[],[322,416],["D",1781268666216],[],[322,222,111],["D",1781267855520],[],[322,222,334],["D",1781268689240],[],[322,222,120],["D",1781268733049],[],[322,222,347],["D",1781268762239],[],[322,222,101],["D",1781262090577],[373,374,375,376,377],[322,222],"096e60b8-9375-4d16-aa19-27531113caa7",["D",1781262090577],[372,378,379,380],[322],"67df8755-4f7e-4bca-a29b-8c96384de547","seed-data.json","f177ae52-6650-11f1-b969-1607ee4eb77e","9b86e04c-f5c2-4abc-96dc-8837f50adb7c",["D",1781263325959],"{\n \"themes\": [\n {\n \"key\": \"scandi\",\n \"name\": \"ITS SCANDINAPRIL BAYYYBEEE\",\n \"emoji\": \"🇳🇴\",\n \"monthLabel\": \"April 2026\",\n \"sort\": 1\n },\n {\n \"key\": \"spielberg\",\n \"name\": \"Spielberg Films\",\n \"emoji\": \"🦈\",\n \"monthLabel\": \"June 2026\",\n \"sort\": 2\n },\n {\n \"key\": \"bp\",\n \"name\": \"Best Picture Winners\",\n \"emoji\": \"🏆\",\n \"monthLabel\": \"Ongoing\",\n \"sort\": 3\n }\n ],\n \"films\": [\n {\n \"theme\": \"scandi\",\n \"title\": \"NAME\",\n \"year\": \"YEAR\",\n \"language\": \"Language\",\n \"whereToWatch\": \"Where To Watch\",\n \"notes\": \"NOTES\",\n \"runtimeMin\": null,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"Persona\",\n \"year\": \"1966\",\n \"language\": \"Swedish\",\n \"whereToWatch\": \"Pirate/Criterion\",\n \"notes\": \"I rated 5/5\",\n \"runtimeMin\": 83,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": true,\n \"seenJ\": true\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"Sisu\",\n \"year\": \"2023\",\n \"language\": \"Finnish\",\n \"whereToWatch\": \"Plex\",\n \"notes\": \"Action film\",\n \"runtimeMin\": 91,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"Autumn Sonata\",\n \"year\": \"1978\",\n \"language\": \"Swedish\",\n \"whereToWatch\": \"Pirate/Criterion\",\n \"notes\": \"\",\n \"runtimeMin\": 93,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"Oslo August 31st\",\n \"year\": \"2011\",\n \"language\": \"Norweigan\",\n \"whereToWatch\": \"Mubi\",\n \"notes\": \"Joachim Trier\",\n \"runtimeMin\": 95,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"Blind\",\n \"year\": \"2014\",\n \"language\": \"Norweigan\",\n \"whereToWatch\": \"Pirate/Mubi\",\n \"notes\": \"\",\n \"runtimeMin\": 96,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"Insomnia\",\n \"year\": \"1997\",\n \"language\": \"Norweigan\",\n \"whereToWatch\": \"Pirate\",\n \"notes\": \"Stellan\",\n \"runtimeMin\": 97,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"Kautokeino Rebellion\",\n \"year\": \"2008\",\n \"language\": \"Norweigan\",\n \"whereToWatch\": \"Plex\",\n \"notes\": \"Nikolaj Coster-Waldau\",\n \"runtimeMin\": 97,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"Handling the Undead\",\n \"year\": \"2024\",\n \"language\": \"Norweigan\",\n \"whereToWatch\": \"Plex\",\n \"notes\": \"Renate\",\n \"runtimeMin\": 99,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"Accused\",\n \"year\": \"2005\",\n \"language\": \"Danish\",\n \"whereToWatch\": \"Pirate\",\n \"notes\": \"\",\n \"runtimeMin\": 100,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"Before it Ends\",\n \"year\": \"2023\",\n \"language\": \"Danish\",\n \"whereToWatch\": \"Pirate\",\n \"notes\": \"\",\n \"runtimeMin\": 102,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"A Somewhat Gentle Man\",\n \"year\": \"2010\",\n \"language\": \"Norweigan\",\n \"whereToWatch\": \"Pirate\",\n \"notes\": \"Stellan\",\n \"runtimeMin\": 106,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"Lamb\",\n \"year\": \"2021\",\n \"language\": \"Icelandic\",\n \"whereToWatch\": \"Pirate\",\n \"notes\": \"Noomi Rapace\",\n \"runtimeMin\": 106,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"The Celebration\",\n \"year\": \"1998\",\n \"language\": \"Danish\",\n \"whereToWatch\": \"Pirate/Mubi\",\n \"notes\": \"\",\n \"runtimeMin\": 106,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"Women in Oversized Men's Shirts\",\n \"year\": \"2015\",\n \"language\": \"Norweigan\",\n \"whereToWatch\": \"Pirate\",\n \"notes\": \"Inga + Renate\",\n \"runtimeMin\": 106,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"Louder than Bombs\",\n \"year\": \"2015\",\n \"language\": \"English\",\n \"whereToWatch\": \"Pirate\",\n \"notes\": \"Joachim Trier\",\n \"runtimeMin\": 109,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"The Ugly Stepsister\",\n \"year\": \"2025\",\n \"language\": \"Norweigan\",\n \"whereToWatch\": \"Plex\",\n \"notes\": \"Animated, Best Picture Nominee\",\n \"runtimeMin\": 109,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": true,\n \"seenJ\": true\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"King of Devils Island\",\n \"year\": \"2010\",\n \"language\": \"Norweigan\",\n \"whereToWatch\": \"Prime\",\n \"notes\": \"Stellan\",\n \"runtimeMin\": 112,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"Black Crab\",\n \"year\": \"2022\",\n \"language\": \"Swedish\",\n \"whereToWatch\": \"Netflix\",\n \"notes\": \"Noomi Rapace\",\n \"runtimeMin\": 114,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"In Order of Disappearance\",\n \"year\": \"2014\",\n \"language\": \"Norweigan\",\n \"whereToWatch\": \"Pirate\",\n \"notes\": \"Stellan\",\n \"runtimeMin\": 116,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"Man Called Ove\",\n \"year\": \"2015\",\n \"language\": \"Swedish\",\n \"whereToWatch\": \"Netflix\",\n \"notes\": \"\",\n \"runtimeMin\": 116,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"The Hunt\",\n \"year\": \"2012\",\n \"language\": \"Danish\",\n \"whereToWatch\": \"Free Trial\",\n \"notes\": \"Mads\",\n \"runtimeMin\": 116,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"Another Round\",\n \"year\": \"2020\",\n \"language\": \"Danish\",\n \"whereToWatch\": \"Pirate\",\n \"notes\": \"Mads\",\n \"runtimeMin\": 117,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"The Idiots\",\n \"year\": \"1998\",\n \"language\": \"Danish\",\n \"whereToWatch\": \"Pirate/Mubi\",\n \"notes\": \"Part of a loose trilogy\",\n \"runtimeMin\": 117,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"The Innocents\",\n \"year\": \"2021\",\n \"language\": \"Norweigan\",\n \"whereToWatch\": \"Pirate/Shudder\",\n \"notes\": \"Writer of Sentimental Value\",\n \"runtimeMin\": 117,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"Force Majeure\",\n \"year\": \"2014\",\n \"language\": \"Swedish\",\n \"whereToWatch\": \"Prime\",\n \"notes\": \"Kristofer Hivju\",\n \"runtimeMin\": 120,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"Out Stealing Horses\",\n \"year\": \"2019\",\n \"language\": \"Norweigan\",\n \"whereToWatch\": \"Prime\",\n \"notes\": \"Stellan\",\n \"runtimeMin\": 123,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"The Promised Land\",\n \"year\": \"2023\",\n \"language\": \"Danish\",\n \"whereToWatch\": \"BBC iPlayer\",\n \"notes\": \"Mads\",\n \"runtimeMin\": 127,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"Another End\",\n \"year\": \"2024\",\n \"language\": \"English/French\",\n \"whereToWatch\": \"Pirate\",\n \"notes\": \"Renate, Gael Garcia Bernal\",\n \"runtimeMin\": 129,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"Girl Who Played with Fire\",\n \"year\": \"2009\",\n \"language\": \"Swedish\",\n \"whereToWatch\": \"Prime\",\n \"notes\": \"\",\n \"runtimeMin\": 129,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": true,\n \"seenJ\": true\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"A Royal Affair\",\n \"year\": \"2012\",\n \"language\": \"Danish\",\n \"whereToWatch\": \"Netflix\",\n \"notes\": \"Mads/Alicia Vikander\",\n \"runtimeMin\": 137,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"Call Girl\",\n \"year\": \"2012\",\n \"language\": \"Swedish\",\n \"whereToWatch\": \"Free Trial\",\n \"notes\": \"\",\n \"runtimeMin\": 140,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"Girl Who Kicked the Hornets Nests\",\n \"year\": \"2009\",\n \"language\": \"Swedish\",\n \"whereToWatch\": \"Prime\",\n \"notes\": \"\",\n \"runtimeMin\": 147,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": true,\n \"seenJ\": true\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"Girl with the Dragon Tattoo\",\n \"year\": \"2009\",\n \"language\": \"Swedish\",\n \"whereToWatch\": \"Prime\",\n \"notes\": \"\",\n \"runtimeMin\": 152,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": true,\n \"seenJ\": true\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"Fanny and Alexander\",\n \"year\": \"1982\",\n \"language\": \"Swedish\",\n \"whereToWatch\": \"Pirate/Max\",\n \"notes\": \"\",\n \"runtimeMin\": 188,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"Reprise\",\n \"year\": \"\",\n \"language\": \"\",\n \"whereToWatch\": \"\",\n \"notes\": \"\",\n \"runtimeMin\": null,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": true,\n \"seenJ\": true\n },\n {\n \"theme\": \"scandi\",\n \"title\": \"The Drama\",\n \"year\": \"\",\n \"language\": \"\",\n \"whereToWatch\": \"\",\n \"notes\": \"\",\n \"runtimeMin\": null,\n \"people\": \"\",\n \"genre\": \"\",\n \"seenL\": true,\n \"seenJ\": true\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"Duel\",\n \"year\": \"1971\",\n \"language\": \"English\",\n \"whereToWatch\": \"Prime (included)\",\n \"notes\": \"\",\n \"runtimeMin\": 90,\n \"people\": \"Dennis Weaver, Jacqueline Scott\",\n \"genre\": \"Thriller\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"Something Evil\",\n \"year\": \"1972\",\n \"language\": \"English\",\n \"whereToWatch\": \"Hard to find in UK - not on major services; occasional YouTube uploads\",\n \"notes\": \"TV Movie\",\n \"runtimeMin\": 73,\n \"people\": \"Sandy Dennis, Darren McGavin\",\n \"genre\": \"Supernatural Horror / TV Movie\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"Savage\",\n \"year\": \"1973\",\n \"language\": \"English\",\n \"whereToWatch\": \"Hard to find in UK - not on major services; occasional YouTube uploads\",\n \"notes\": \"TV Movie\",\n \"runtimeMin\": 73,\n \"people\": \"Martin Landau, Barbara Bain\",\n \"genre\": \"Thriller / Drama / TV Movie\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"The Sugarland Express\",\n \"year\": \"1974\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 110,\n \"people\": \"Goldie Hawn, William Atherton\",\n \"genre\": \"Crime / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"Jaws\",\n \"year\": \"1975\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV (rotates onto Netflix/streaming - verify)\",\n \"notes\": \"\",\n \"runtimeMin\": 124,\n \"people\": \"Roy Scheider, Richard Dreyfuss\",\n \"genre\": \"Thriller / Horror / Adventure\",\n \"seenL\": true,\n \"seenJ\": true\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"Close Encounters of the Third Kind\",\n \"year\": \"1977\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 135,\n \"people\": \"Richard Dreyfuss, Melinda Dillon\",\n \"genre\": \"Sci-Fi / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"1941\",\n \"year\": \"1979\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 118,\n \"people\": \"John Belushi, Dan Aykroyd\",\n \"genre\": \"Comedy / War\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"Raiders of the Lost Ark\",\n \"year\": \"1981\",\n \"language\": \"English\",\n \"whereToWatch\": \"Likely Disney+ (verify); else rent Prime/Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 115,\n \"people\": \"Harrison Ford, Karen Allen\",\n \"genre\": \"Action / Adventure\",\n \"seenL\": true,\n \"seenJ\": true\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"E.T. the Extra-Terrestrial\",\n \"year\": \"1982\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 115,\n \"people\": \"Henry Thomas, Drew Barrymore\",\n \"genre\": \"Sci-Fi / Family / Drama\",\n \"seenL\": true,\n \"seenJ\": true\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"Twilight Zone: The Movie\",\n \"year\": \"1983\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"4 Part Anthology\",\n \"runtimeMin\": 101,\n \"people\": \"Vic Morrow, Scatman Crothers\",\n \"genre\": \"Sci-Fi / Horror / Anthology\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"Indiana Jones and the Temple of Doom\",\n \"year\": \"1984\",\n \"language\": \"English\",\n \"whereToWatch\": \"Likely Disney+ (verify); else rent Prime/Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 118,\n \"people\": \"Harrison Ford, Kate Capshaw\",\n \"genre\": \"Action / Adventure\",\n \"seenL\": true,\n \"seenJ\": false\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"The Color Purple\",\n \"year\": \"1985\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 154,\n \"people\": \"Whoopi Goldberg, Danny Glover\",\n \"genre\": \"Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"Empire of the Sun\",\n \"year\": \"1987\",\n \"language\": \"English (some Japanese / Mandarin)\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 153,\n \"people\": \"Christian Bale, John Malkovich\",\n \"genre\": \"War / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"Indiana Jones and the Last Crusade\",\n \"year\": \"1989\",\n \"language\": \"English\",\n \"whereToWatch\": \"Likely Disney+ (verify); else rent Prime/Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 127,\n \"people\": \"Harrison Ford, Sean Connery\",\n \"genre\": \"Action / Adventure\",\n \"seenL\": true,\n \"seenJ\": false\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"Always\",\n \"year\": \"1989\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 122,\n \"people\": \"Richard Dreyfuss, Holly Hunter\",\n \"genre\": \"Romance / Fantasy / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"Hook\",\n \"year\": \"1991\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 142,\n \"people\": \"Robin Williams, Dustin Hoffman\",\n \"genre\": \"Adventure / Fantasy / Family\",\n \"seenL\": false,\n \"seenJ\": true\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"Jurassic Park\",\n \"year\": \"1993\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV (rotates onto Netflix/streaming - verify)\",\n \"notes\": \"\",\n \"runtimeMin\": 127,\n \"people\": \"Sam Neill, Laura Dern\",\n \"genre\": \"Sci-Fi / Adventure\",\n \"seenL\": true,\n \"seenJ\": false\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"Schindler's List\",\n \"year\": \"1993\",\n \"language\": \"English / German / Hebrew / Polish\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 195,\n \"people\": \"Liam Neeson, Ralph Fiennes\",\n \"genre\": \"Historical / Biography / Drama\",\n \"seenL\": true,\n \"seenJ\": true\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"The Lost World: Jurassic Park\",\n \"year\": \"1997\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 129,\n \"people\": \"Jeff Goldblum, Julianne Moore\",\n \"genre\": \"Sci-Fi / Adventure\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"Amistad\",\n \"year\": \"1997\",\n \"language\": \"English / Mende / Spanish\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 155,\n \"people\": \"Djimon Hounsou, Anthony Hopkins\",\n \"genre\": \"Historical / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"Saving Private Ryan\",\n \"year\": \"1998\",\n \"language\": \"English (some German / French)\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV (sometimes on Paramount+/Netflix - verify)\",\n \"notes\": \"\",\n \"runtimeMin\": 169,\n \"people\": \"Tom Hanks, Matt Damon\",\n \"genre\": \"War / Drama\",\n \"seenL\": true,\n \"seenJ\": true\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"A.I. Artificial Intelligence\",\n \"year\": \"2001\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 146,\n \"people\": \"Haley Joel Osment, Jude Law\",\n \"genre\": \"Sci-Fi / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"Minority Report\",\n \"year\": \"2002\",\n \"language\": \"English\",\n \"whereToWatch\": \"Likely Disney+ (Star) (verify); else rent Prime/Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 145,\n \"people\": \"Tom Cruise, Colin Farrell\",\n \"genre\": \"Sci-Fi / Thriller\",\n \"seenL\": true,\n \"seenJ\": true\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"Catch Me If You Can\",\n \"year\": \"2002\",\n \"language\": \"English (some French)\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 141,\n \"people\": \"Leonardo DiCaprio, Tom Hanks\",\n \"genre\": \"Crime / Biography / Drama\",\n \"seenL\": true,\n \"seenJ\": true\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"The Terminal\",\n \"year\": \"2004\",\n \"language\": \"English / Krakozhian (fictional)\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 128,\n \"people\": \"Tom Hanks, Catherine Zeta-Jones\",\n \"genre\": \"Comedy / Drama / Romance\",\n \"seenL\": true,\n \"seenJ\": true\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"War of the Worlds\",\n \"year\": \"2005\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 116,\n \"people\": \"Tom Cruise, Dakota Fanning\",\n \"genre\": \"Sci-Fi / Thriller\",\n \"seenL\": true,\n \"seenJ\": true\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"Munich\",\n \"year\": \"2005\",\n \"language\": \"English / French / German / Arabic / Hebrew\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 164,\n \"people\": \"Eric Bana, Daniel Craig\",\n \"genre\": \"Historical / Thriller / Drama\",\n \"seenL\": true,\n \"seenJ\": false\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"Indiana Jones and the Kingdom of the Crystal Skull\",\n \"year\": \"2008\",\n \"language\": \"English\",\n \"whereToWatch\": \"Likely Disney+ (verify); else rent Prime/Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 122,\n \"people\": \"Harrison Ford, Cate Blanchett\",\n \"genre\": \"Action / Adventure\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"The Adventures of Tintin\",\n \"year\": \"2011\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 107,\n \"people\": \"Jamie Bell, Andy Serkis\",\n \"genre\": \"Animation / Adventure\",\n \"seenL\": false,\n \"seenJ\": true\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"War Horse\",\n \"year\": \"2011\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 146,\n \"people\": \"Jeremy Irvine, Emily Watson\",\n \"genre\": \"War / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"Lincoln\",\n \"year\": \"2012\",\n \"language\": \"English\",\n \"whereToWatch\": \"Likely Disney+ (Star) (verify); else rent Prime/Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 150,\n \"people\": \"Daniel Day-Lewis, Sally Field\",\n \"genre\": \"Historical / Biography / Drama\",\n \"seenL\": true,\n \"seenJ\": false\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"Bridge of Spies\",\n \"year\": \"2015\",\n \"language\": \"English (some German / Russian)\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 142,\n \"people\": \"Tom Hanks, Mark Rylance\",\n \"genre\": \"Historical / Thriller / Drama\",\n \"seenL\": true,\n \"seenJ\": false\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"The BFG\",\n \"year\": \"2016\",\n \"language\": \"English\",\n \"whereToWatch\": \"Likely Disney+ (verify); else rent Prime/Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 117,\n \"people\": \"Mark Rylance, Ruby Barnhill\",\n \"genre\": \"Fantasy / Family / Adventure\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"The Post\",\n \"year\": \"2017\",\n \"language\": \"English\",\n \"whereToWatch\": \"Likely Disney+ (Star) (verify); else rent Prime/Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 116,\n \"people\": \"Meryl Streep, Tom Hanks\",\n \"genre\": \"Historical / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"Ready Player One\",\n \"year\": \"2018\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV (rotates onto Netflix - verify)\",\n \"notes\": \"\",\n \"runtimeMin\": 140,\n \"people\": \"Tye Sheridan, Olivia Cooke\",\n \"genre\": \"Sci-Fi / Adventure\",\n \"seenL\": true,\n \"seenJ\": true\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"West Side Story\",\n \"year\": \"2021\",\n \"language\": \"English / Spanish\",\n \"whereToWatch\": \"Likely Disney+ (verify); else rent Prime/Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 156,\n \"people\": \"Rachel Zegler, Ansel Elgort\",\n \"genre\": \"Musical / Romance / Drama\",\n \"seenL\": true,\n \"seenJ\": false\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"The Fabelmans\",\n \"year\": \"2022\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV (sometimes on Netflix - verify)\",\n \"notes\": \"\",\n \"runtimeMin\": 151,\n \"people\": \"Gabriel LaBelle, Michelle Williams\",\n \"genre\": \"Drama / Coming-of-Age\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"spielberg\",\n \"title\": \"Disclosure Day\",\n \"year\": \"2026\",\n \"language\": \"English\",\n \"whereToWatch\": \"In UK cinemas from 12 June 2026 - not yet streaming\",\n \"notes\": \"\",\n \"runtimeMin\": 145,\n \"people\": \"Emily Blunt, Josh O'Connor\",\n \"genre\": \"Sci-Fi / Thriller\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Wings\",\n \"year\": \"1927/28\",\n \"language\": \"Silent (English intertitles)\",\n \"whereToWatch\": \"Rent/buy: Apple TV, Prime\",\n \"notes\": \"\",\n \"runtimeMin\": 144,\n \"people\": \"dir. William A. Wellman · Clara Bow, Charles 'Buddy' Rogers\",\n \"genre\": \"War / Romance / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"The Broadway Melody\",\n \"year\": \"1928/29\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Apple TV, Prime\",\n \"notes\": \"\",\n \"runtimeMin\": 100,\n \"people\": \"dir. Harry Beaumont · Anita Page, Bessie Love\",\n \"genre\": \"Musical\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"All Quiet on the Western Front\",\n \"year\": \"1929/30\",\n \"language\": \"English\",\n \"whereToWatch\": \"BFI Player; rent Prime/Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 152,\n \"people\": \"dir. Lewis Milestone · Lew Ayres, Louis Wolheim\",\n \"genre\": \"War / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Cimarron\",\n \"year\": \"1930/31\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 123,\n \"people\": \"dir. Wesley Ruggles · Richard Dix, Irene Dunne\",\n \"genre\": \"Western / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Grand Hotel\",\n \"year\": \"1931/32\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Apple TV, Prime\",\n \"notes\": \"\",\n \"runtimeMin\": 112,\n \"people\": \"dir. Edmund Goulding · Greta Garbo, John Barrymore\",\n \"genre\": \"Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Cavalcade\",\n \"year\": \"1932/33\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 112,\n \"people\": \"dir. Frank Lloyd · Diana Wynyard, Clive Brook\",\n \"genre\": \"Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"It Happened One Night\",\n \"year\": \"1934\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 105,\n \"people\": \"dir. Frank Capra · Clark Gable, Claudette Colbert\",\n \"genre\": \"Romantic Comedy\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Mutiny on the Bounty\",\n \"year\": \"1935\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 132,\n \"people\": \"dir. Frank Lloyd · Charles Laughton, Clark Gable\",\n \"genre\": \"Adventure / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"The Great Ziegfeld\",\n \"year\": \"1936\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 176,\n \"people\": \"dir. Robert Z. Leonard · William Powell, Myrna Loy\",\n \"genre\": \"Musical / Biography\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"The Life of Emile Zola\",\n \"year\": \"1937\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 116,\n \"people\": \"dir. William Dieterle · Paul Muni, Gloria Holden\",\n \"genre\": \"Biography / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"You Can't Take It with You\",\n \"year\": \"1938\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Apple TV, Prime\",\n \"notes\": \"\",\n \"runtimeMin\": 126,\n \"people\": \"dir. Frank Capra · Jean Arthur, James Stewart\",\n \"genre\": \"Comedy / Romance\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Gone with the Wind\",\n \"year\": \"1939\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 238,\n \"people\": \"dir. Victor Fleming · Vivien Leigh, Clark Gable\",\n \"genre\": \"Historical / Romance / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Rebecca\",\n \"year\": \"1940\",\n \"language\": \"English\",\n \"whereToWatch\": \"BFI Player; rent Prime/Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 130,\n \"people\": \"dir. Alfred Hitchcock · Laurence Olivier, Joan Fontaine\",\n \"genre\": \"Gothic / Thriller / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"How Green Was My Valley\",\n \"year\": \"1941\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 118,\n \"people\": \"dir. John Ford · Walter Pidgeon, Maureen O'Hara\",\n \"genre\": \"Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Mrs. Miniver\",\n \"year\": \"1942\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 134,\n \"people\": \"dir. William Wyler · Greer Garson, Walter Pidgeon\",\n \"genre\": \"War / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Casablanca\",\n \"year\": \"1943\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 102,\n \"people\": \"dir. Michael Curtiz · Humphrey Bogart, Ingrid Bergman\",\n \"genre\": \"Romance / Drama / War\",\n \"seenL\": false,\n \"seenJ\": true\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Going My Way\",\n \"year\": \"1944\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 126,\n \"people\": \"dir. Leo McCarey · Bing Crosby, Barry Fitzgerald\",\n \"genre\": \"Musical / Comedy / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"The Lost Weekend\",\n \"year\": \"1945\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 101,\n \"people\": \"dir. Billy Wilder · Ray Milland, Jane Wyman\",\n \"genre\": \"Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"The Best Years of Our Lives\",\n \"year\": \"1946\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 170,\n \"people\": \"dir. William Wyler · Fredric March, Myrna Loy\",\n \"genre\": \"Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Gentleman's Agreement\",\n \"year\": \"1947\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 118,\n \"people\": \"dir. Elia Kazan · Gregory Peck, Dorothy McGuire\",\n \"genre\": \"Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Hamlet\",\n \"year\": \"1948\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 154,\n \"people\": \"dir. Laurence Olivier · Laurence Olivier, Jean Simmons\",\n \"genre\": \"Drama / Tragedy\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"All the King's Men\",\n \"year\": \"1949\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 110,\n \"people\": \"dir. Robert Rossen · Broderick Crawford, Joanne Dru\",\n \"genre\": \"Political Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"All About Eve\",\n \"year\": \"1950\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 138,\n \"people\": \"dir. Joseph L. Mankiewicz · Bette Davis, Anne Baxter\",\n \"genre\": \"Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"An American in Paris\",\n \"year\": \"1951\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 114,\n \"people\": \"dir. Vincente Minnelli · Gene Kelly, Leslie Caron\",\n \"genre\": \"Musical / Romance\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"The Greatest Show on Earth\",\n \"year\": \"1952\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 152,\n \"people\": \"dir. Cecil B. DeMille · Charlton Heston, Betty Hutton\",\n \"genre\": \"Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"From Here to Eternity\",\n \"year\": \"1953\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 118,\n \"people\": \"dir. Fred Zinnemann · Burt Lancaster, Montgomery Clift\",\n \"genre\": \"War / Romance / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"On the Waterfront\",\n \"year\": \"1954\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 108,\n \"people\": \"dir. Elia Kazan · Marlon Brando, Eva Marie Saint\",\n \"genre\": \"Crime / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Marty\",\n \"year\": \"1955\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 90,\n \"people\": \"dir. Delbert Mann · Ernest Borgnine, Betsy Blair\",\n \"genre\": \"Romance / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Around the World in 80 Days\",\n \"year\": \"1956\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 175,\n \"people\": \"dir. Michael Anderson · David Niven, Cantinflas\",\n \"genre\": \"Adventure / Comedy\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"The Bridge on the River Kwai\",\n \"year\": \"1957\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 161,\n \"people\": \"dir. David Lean · William Holden, Alec Guinness\",\n \"genre\": \"War / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Gigi\",\n \"year\": \"1958\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 115,\n \"people\": \"dir. Vincente Minnelli · Leslie Caron, Maurice Chevalier\",\n \"genre\": \"Musical / Romance\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Ben-Hur\",\n \"year\": \"1959\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 212,\n \"people\": \"dir. William Wyler · Charlton Heston, Stephen Boyd\",\n \"genre\": \"Historical Epic\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"The Apartment\",\n \"year\": \"1960\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV; sometimes BFI\",\n \"notes\": \"\",\n \"runtimeMin\": 125,\n \"people\": \"dir. Billy Wilder · Jack Lemmon, Shirley MacLaine\",\n \"genre\": \"Romantic Comedy / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"West Side Story\",\n \"year\": \"1961\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 153,\n \"people\": \"dir. Robert Wise & Jerome Robbins · Natalie Wood, Richard Beymer\",\n \"genre\": \"Musical / Romance\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Lawrence of Arabia\",\n \"year\": \"1962\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 218,\n \"people\": \"dir. David Lean · Peter O'Toole, Alec Guinness\",\n \"genre\": \"Epic / Adventure / Biography\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Tom Jones\",\n \"year\": \"1963\",\n \"language\": \"English\",\n \"whereToWatch\": \"BFI Player; rent Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 129,\n \"people\": \"dir. Tony Richardson · Albert Finney, Susannah York\",\n \"genre\": \"Comedy / Adventure\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"My Fair Lady\",\n \"year\": \"1964\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 170,\n \"people\": \"dir. George Cukor · Audrey Hepburn, Rex Harrison\",\n \"genre\": \"Musical\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"The Sound of Music\",\n \"year\": \"1965\",\n \"language\": \"English\",\n \"whereToWatch\": \"Disney+ (Fox); rent Prime/Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 172,\n \"people\": \"dir. Robert Wise · Julie Andrews, Christopher Plummer\",\n \"genre\": \"Musical\",\n \"seenL\": false,\n \"seenJ\": true\n },\n {\n \"theme\": \"bp\",\n \"title\": \"A Man for All Seasons\",\n \"year\": \"1966\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 120,\n \"people\": \"dir. Fred Zinnemann · Paul Scofield, Wendy Hiller\",\n \"genre\": \"Biography / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"In the Heat of the Night\",\n \"year\": \"1967\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 110,\n \"people\": \"dir. Norman Jewison · Sidney Poitier, Rod Steiger\",\n \"genre\": \"Crime / Mystery / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Oliver!\",\n \"year\": \"1968\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 153,\n \"people\": \"dir. Carol Reed · Ron Moody, Mark Lester\",\n \"genre\": \"Musical\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Midnight Cowboy\",\n \"year\": \"1969\",\n \"language\": \"English\",\n \"whereToWatch\": \"BFI Player; rent Prime/Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 113,\n \"people\": \"dir. John Schlesinger · Dustin Hoffman, Jon Voight\",\n \"genre\": \"Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Patton\",\n \"year\": \"1970\",\n \"language\": \"English\",\n \"whereToWatch\": \"Disney+ (Fox); rent Prime/Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 172,\n \"people\": \"dir. Franklin J. Schaffner · George C. Scott, Karl Malden\",\n \"genre\": \"War / Biography\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"The French Connection\",\n \"year\": \"1971\",\n \"language\": \"English\",\n \"whereToWatch\": \"Disney+ (Fox); rent Prime/Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 104,\n \"people\": \"dir. William Friedkin · Gene Hackman, Roy Scheider\",\n \"genre\": \"Crime / Thriller\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"The Godfather\",\n \"year\": \"1972\",\n \"language\": \"English\",\n \"whereToWatch\": \"Paramount+; rent Prime/Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 175,\n \"people\": \"dir. Francis Ford Coppola · Marlon Brando, Al Pacino\",\n \"genre\": \"Crime / Drama\",\n \"seenL\": false,\n \"seenJ\": true\n },\n {\n \"theme\": \"bp\",\n \"title\": \"The Sting\",\n \"year\": \"1973\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 129,\n \"people\": \"dir. George Roy Hill · Paul Newman, Robert Redford\",\n \"genre\": \"Crime / Comedy\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"The Godfather Part II\",\n \"year\": \"1974\",\n \"language\": \"English / Italian\",\n \"whereToWatch\": \"Paramount+; rent Prime/Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 202,\n \"people\": \"dir. Francis Ford Coppola · Al Pacino, Robert De Niro\",\n \"genre\": \"Crime / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"One Flew Over the Cuckoo's Nest\",\n \"year\": \"1975\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 133,\n \"people\": \"dir. Milos Forman · Jack Nicholson, Louise Fletcher\",\n \"genre\": \"Drama\",\n \"seenL\": false,\n \"seenJ\": true\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Rocky\",\n \"year\": \"1976\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 120,\n \"people\": \"dir. John G. Avildsen · Sylvester Stallone, Talia Shire\",\n \"genre\": \"Sports / Drama\",\n \"seenL\": false,\n \"seenJ\": true\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Annie Hall\",\n \"year\": \"1977\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 93,\n \"people\": \"dir. Woody Allen · Woody Allen, Diane Keaton\",\n \"genre\": \"Romantic Comedy\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"The Deer Hunter\",\n \"year\": \"1978\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 183,\n \"people\": \"dir. Michael Cimino · Robert De Niro, Christopher Walken\",\n \"genre\": \"War / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Kramer vs. Kramer\",\n \"year\": \"1979\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 105,\n \"people\": \"dir. Robert Benton · Dustin Hoffman, Meryl Streep\",\n \"genre\": \"Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Ordinary People\",\n \"year\": \"1980\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 124,\n \"people\": \"dir. Robert Redford · Donald Sutherland, Mary Tyler Moore\",\n \"genre\": \"Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Chariots of Fire\",\n \"year\": \"1981\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 125,\n \"people\": \"dir. Hugh Hudson · Ben Cross, Ian Charleson\",\n \"genre\": \"Sports / Biography / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Gandhi\",\n \"year\": \"1982\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 191,\n \"people\": \"dir. Richard Attenborough · Ben Kingsley, Candice Bergen\",\n \"genre\": \"Biography / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Terms of Endearment\",\n \"year\": \"1983\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 132,\n \"people\": \"dir. James L. Brooks · Shirley MacLaine, Debra Winger\",\n \"genre\": \"Comedy / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Amadeus\",\n \"year\": \"1984\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 160,\n \"people\": \"dir. Milos Forman · F. Murray Abraham, Tom Hulce\",\n \"genre\": \"Biography / Drama / Musical\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Out of Africa\",\n \"year\": \"1985\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 161,\n \"people\": \"dir. Sydney Pollack · Meryl Streep, Robert Redford\",\n \"genre\": \"Romance / Biography / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Platoon\",\n \"year\": \"1986\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 120,\n \"people\": \"dir. Oliver Stone · Charlie Sheen, Tom Berenger\",\n \"genre\": \"War / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"The Last Emperor\",\n \"year\": \"1987\",\n \"language\": \"English / Mandarin\",\n \"whereToWatch\": \"Rent/buy: Apple TV; sometimes BFI\",\n \"notes\": \"\",\n \"runtimeMin\": 163,\n \"people\": \"dir. Bernardo Bertolucci · John Lone, Joan Chen\",\n \"genre\": \"Biography / Historical / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Rain Man\",\n \"year\": \"1988\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 133,\n \"people\": \"dir. Barry Levinson · Dustin Hoffman, Tom Cruise\",\n \"genre\": \"Drama\",\n \"seenL\": false,\n \"seenJ\": true\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Driving Miss Daisy\",\n \"year\": \"1989\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 99,\n \"people\": \"dir. Bruce Beresford · Morgan Freeman, Jessica Tandy\",\n \"genre\": \"Comedy / Drama\",\n \"seenL\": false,\n \"seenJ\": true\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Dances with Wolves\",\n \"year\": \"1990\",\n \"language\": \"English / Lakota\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 181,\n \"people\": \"dir. Kevin Costner · Kevin Costner, Mary McDonnell\",\n \"genre\": \"Western / Epic / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"The Silence of the Lambs\",\n \"year\": \"1991\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 118,\n \"people\": \"dir. Jonathan Demme · Jodie Foster, Anthony Hopkins\",\n \"genre\": \"Thriller / Horror / Crime\",\n \"seenL\": false,\n \"seenJ\": true\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Unforgiven\",\n \"year\": \"1992\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 130,\n \"people\": \"dir. Clint Eastwood · Clint Eastwood, Gene Hackman\",\n \"genre\": \"Western\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Schindler's List\",\n \"year\": \"1993\",\n \"language\": \"English / German / Hebrew\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 195,\n \"people\": \"dir. Steven Spielberg · Liam Neeson, Ralph Fiennes\",\n \"genre\": \"Historical / War / Drama\",\n \"seenL\": false,\n \"seenJ\": true\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Forrest Gump\",\n \"year\": \"1994\",\n \"language\": \"English\",\n \"whereToWatch\": \"Paramount+; rent Prime/Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 142,\n \"people\": \"dir. Robert Zemeckis · Tom Hanks, Robin Wright\",\n \"genre\": \"Drama / Romance / Comedy\",\n \"seenL\": false,\n \"seenJ\": true\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Braveheart\",\n \"year\": \"1995\",\n \"language\": \"English\",\n \"whereToWatch\": \"Disney+ (Fox); rent Prime/Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 178,\n \"people\": \"dir. Mel Gibson · Mel Gibson, Sophie Marceau\",\n \"genre\": \"Historical / War / Epic\",\n \"seenL\": false,\n \"seenJ\": true\n },\n {\n \"theme\": \"bp\",\n \"title\": \"The English Patient\",\n \"year\": \"1996\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 162,\n \"people\": \"dir. Anthony Minghella · Ralph Fiennes, Juliette Binoche\",\n \"genre\": \"Romance / War / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Titanic\",\n \"year\": \"1997\",\n \"language\": \"English\",\n \"whereToWatch\": \"Disney+ / Paramount+; rent Prime\",\n \"notes\": \"\",\n \"runtimeMin\": 194,\n \"people\": \"dir. James Cameron · Leonardo DiCaprio, Kate Winslet\",\n \"genre\": \"Romance / Disaster / Drama\",\n \"seenL\": false,\n \"seenJ\": true\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Shakespeare in Love\",\n \"year\": \"1998\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 123,\n \"people\": \"dir. John Madden · Joseph Fiennes, Gwyneth Paltrow\",\n \"genre\": \"Romantic Comedy / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"American Beauty\",\n \"year\": \"1999\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 122,\n \"people\": \"dir. Sam Mendes · Kevin Spacey, Annette Bening\",\n \"genre\": \"Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Gladiator\",\n \"year\": \"2000\",\n \"language\": \"English\",\n \"whereToWatch\": \"Paramount+; rent Prime/Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 155,\n \"people\": \"dir. Ridley Scott · Russell Crowe, Joaquin Phoenix\",\n \"genre\": \"Historical / Action / Epic\",\n \"seenL\": false,\n \"seenJ\": true\n },\n {\n \"theme\": \"bp\",\n \"title\": \"A Beautiful Mind\",\n \"year\": \"2001\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 135,\n \"people\": \"dir. Ron Howard · Russell Crowe, Jennifer Connelly\",\n \"genre\": \"Biography / Drama\",\n \"seenL\": false,\n \"seenJ\": true\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Chicago\",\n \"year\": \"2002\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 113,\n \"people\": \"dir. Rob Marshall · Renee Zellweger, Catherine Zeta-Jones\",\n \"genre\": \"Musical / Crime\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"The Lord of the Rings: The Return of the King\",\n \"year\": \"2003\",\n \"language\": \"English\",\n \"whereToWatch\": \"Prime / Netflix (rotates); rent Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 201,\n \"people\": \"dir. Peter Jackson · Elijah Wood, Viggo Mortensen\",\n \"genre\": \"Fantasy / Adventure / Epic\",\n \"seenL\": false,\n \"seenJ\": true\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Million Dollar Baby\",\n \"year\": \"2004\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 132,\n \"people\": \"dir. Clint Eastwood · Clint Eastwood, Hilary Swank\",\n \"genre\": \"Sports / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Crash\",\n \"year\": \"2005\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 112,\n \"people\": \"dir. Paul Haggis · Don Cheadle, Sandra Bullock\",\n \"genre\": \"Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"The Departed\",\n \"year\": \"2006\",\n \"language\": \"English\",\n \"whereToWatch\": \"Prime / Netflix (rotates); rent Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 151,\n \"people\": \"dir. Martin Scorsese · Leonardo DiCaprio, Matt Damon\",\n \"genre\": \"Crime / Thriller\",\n \"seenL\": false,\n \"seenJ\": true\n },\n {\n \"theme\": \"bp\",\n \"title\": \"No Country for Old Men\",\n \"year\": \"2007\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 122,\n \"people\": \"dir. Joel & Ethan Coen · Tommy Lee Jones, Javier Bardem\",\n \"genre\": \"Crime / Thriller\",\n \"seenL\": false,\n \"seenJ\": true\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Slumdog Millionaire\",\n \"year\": \"2008\",\n \"language\": \"English / Hindi\",\n \"whereToWatch\": \"Disney+ (Searchlight); rent Prime/Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 120,\n \"people\": \"dir. Danny Boyle · Dev Patel, Freida Pinto\",\n \"genre\": \"Drama / Romance\",\n \"seenL\": false,\n \"seenJ\": true\n },\n {\n \"theme\": \"bp\",\n \"title\": \"The Hurt Locker\",\n \"year\": \"2009\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 131,\n \"people\": \"dir. Kathryn Bigelow · Jeremy Renner, Anthony Mackie\",\n \"genre\": \"War / Thriller\",\n \"seenL\": false,\n \"seenJ\": true\n },\n {\n \"theme\": \"bp\",\n \"title\": \"The King's Speech\",\n \"year\": \"2010\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 118,\n \"people\": \"dir. Tom Hooper · Colin Firth, Geoffrey Rush\",\n \"genre\": \"Biography / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"The Artist\",\n \"year\": \"2011\",\n \"language\": \"Silent (French production)\",\n \"whereToWatch\": \"Rent/buy: Apple TV; sometimes BFI\",\n \"notes\": \"\",\n \"runtimeMin\": 100,\n \"people\": \"dir. Michel Hazanavicius · Jean Dujardin, Berenice Bejo\",\n \"genre\": \"Romantic Comedy / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Argo\",\n \"year\": \"2012\",\n \"language\": \"English\",\n \"whereToWatch\": \"Prime; rent Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 120,\n \"people\": \"dir. Ben Affleck · Ben Affleck, Bryan Cranston\",\n \"genre\": \"Thriller / Historical / Drama\",\n \"seenL\": false,\n \"seenJ\": true\n },\n {\n \"theme\": \"bp\",\n \"title\": \"12 Years a Slave\",\n \"year\": \"2013\",\n \"language\": \"English\",\n \"whereToWatch\": \"Disney+ (Searchlight); rent Prime/Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 134,\n \"people\": \"dir. Steve McQueen · Chiwetel Ejiofor, Michael Fassbender\",\n \"genre\": \"Historical / Biography / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Birdman\",\n \"year\": \"2014\",\n \"language\": \"English\",\n \"whereToWatch\": \"Disney+ (Searchlight); rent Prime/Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 119,\n \"people\": \"dir. Alejandro G. Inarritu · Michael Keaton, Edward Norton\",\n \"genre\": \"Comedy / Drama\",\n \"seenL\": false,\n \"seenJ\": true\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Spotlight\",\n \"year\": \"2015\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 129,\n \"people\": \"dir. Tom McCarthy · Mark Ruffalo, Michael Keaton\",\n \"genre\": \"Drama (Journalism)\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Moonlight\",\n \"year\": \"2016\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV; sometimes Netflix\",\n \"notes\": \"\",\n \"runtimeMin\": 111,\n \"people\": \"dir. Barry Jenkins · Trevante Rhodes, Mahershala Ali\",\n \"genre\": \"Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"The Shape of Water\",\n \"year\": \"2017\",\n \"language\": \"English\",\n \"whereToWatch\": \"Disney+ (Searchlight); rent Prime/Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 123,\n \"people\": \"dir. Guillermo del Toro · Sally Hawkins, Michael Shannon\",\n \"genre\": \"Fantasy / Romance / Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Green Book\",\n \"year\": \"2018\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 130,\n \"people\": \"dir. Peter Farrelly · Viggo Mortensen, Mahershala Ali\",\n \"genre\": \"Comedy / Biography / Drama\",\n \"seenL\": false,\n \"seenJ\": true\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Parasite\",\n \"year\": \"2019\",\n \"language\": \"Korean\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 132,\n \"people\": \"dir. Bong Joon-ho · Song Kang-ho, Lee Sun-kyun\",\n \"genre\": \"Thriller / Dark Comedy / Drama\",\n \"seenL\": false,\n \"seenJ\": true\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Nomadland\",\n \"year\": \"2020\",\n \"language\": \"English\",\n \"whereToWatch\": \"Disney+ (Searchlight); rent Prime/Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 107,\n \"people\": \"dir. Chloe Zhao · Frances McDormand, David Strathairn\",\n \"genre\": \"Drama\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"CODA\",\n \"year\": \"2021\",\n \"language\": \"English / ASL\",\n \"whereToWatch\": \"Apple TV+ (subscription); rent Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 111,\n \"people\": \"dir. Sian Heder · Emilia Jones, Troy Kotsur\",\n \"genre\": \"Coming-of-age / Drama / Comedy\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Everything Everywhere All at Once\",\n \"year\": \"2022\",\n \"language\": \"English / Mandarin / Cantonese\",\n \"whereToWatch\": \"Prime (sometimes incl.); rent Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 139,\n \"people\": \"dir. Daniel Kwan & Daniel Scheinert · Michelle Yeoh, Ke Huy Quan\",\n \"genre\": \"Sci-Fi / Comedy / Action\",\n \"seenL\": false,\n \"seenJ\": false\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Oppenheimer\",\n \"year\": \"2023\",\n \"language\": \"English\",\n \"whereToWatch\": \"Prime; rent Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 180,\n \"people\": \"dir. Christopher Nolan · Cillian Murphy, Emily Blunt\",\n \"genre\": \"Biography / Historical / Drama\",\n \"seenL\": false,\n \"seenJ\": true\n },\n {\n \"theme\": \"bp\",\n \"title\": \"Anora\",\n \"year\": \"2024\",\n \"language\": \"English / Russian\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 139,\n \"people\": \"dir. Sean Baker · Mikey Madison, Mark Eydelshteyn\",\n \"genre\": \"Comedy / Drama\",\n \"seenL\": false,\n \"seenJ\": true\n },\n {\n \"theme\": \"bp\",\n \"title\": \"One Battle After Another\",\n \"year\": \"2025\",\n \"language\": \"English\",\n \"whereToWatch\": \"Rent/buy: Prime, Apple TV\",\n \"notes\": \"\",\n \"runtimeMin\": 162,\n \"people\": \"dir. Paul Thomas Anderson · Leonardo DiCaprio, Sean Penn\",\n \"genre\": \"Action / Comedy / Drama / Thriller\",\n \"seenL\": false,\n \"seenJ\": true\n }\n ]\n}",[],[453,446],"backend","9cff1aad-40dd-4429-938f-c8e30ee83fce","ratings.ts","1376a042-665d-11f1-9a22-1607ee4eb77e",55,["D",1781268536967],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { norm } from \"./letterboxd.ts\";\n\nconst JW_GQL = \"https://apis.justwatch.com/graphql\";\nconst QUERY = `query GetSearchTitles($country: Country!, $language: Language!, $first: Int!, $filter: TitleFilter) {\n popularTitles(country: $country, first: $first, filter: $filter) {\n edges { node { objectType content(country: $country, language: $language) {\n title originalReleaseYear fullPath posterUrl scoring { imdbScore tmdbScore }\n } } }\n }\n}`;\n\ninterface JwHit {\n imdbScore: number | null;\n tmdbScore: number | null;\n posterUrl: string;\n jwPath: string;\n}\n\nasync function lookupTitle(title: string, year: string): Promise {\n const res = await fetch(JW_GQL, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\", \"User-Agent\": \"Mozilla/5.0\" },\n body: JSON.stringify({\n operationName: \"GetSearchTitles\",\n variables: { country: \"GB\", language: \"en\", first: 5, filter: { searchQuery: title } },\n query: QUERY,\n }),\n });\n if (!res.ok) throw new Error(`JustWatch ${res.status}`);\n const data = await res.json();\n const edges: any[] = data?.data?.popularTitles?.edges ?? [];\n const wantYear = Number((year.match(/\\d{4}/) ?? [])[0]) || null;\n const wantTitle = norm(title);\n let best: any = null;\n for (const e of edges) {\n const c = e?.node?.content;\n if (!c || e.node.objectType !== \"MOVIE\") continue;\n const yearOk = !wantYear || !c.originalReleaseYear || Math.abs(c.originalReleaseYear - wantYear) <= 1;\n const titleOk = norm(String(c.title ?? \"\")) === wantTitle;\n if (titleOk && yearOk) {\n best = c;\n break;\n }\n if (!best && yearOk) best = c; // fuzzy fallback: right year, JustWatch's top hit\n }\n if (!best) return null;\n const poster = best.posterUrl\n ? `https://images.justwatch.com${String(best.posterUrl).replace(\"{profile}\", \"s332\").replace(\"{format}\", \"webp\")}`\n : \"\";\n return {\n imdbScore: best.scoring?.imdbScore ?? null,\n tmdbScore: best.scoring?.tmdbScore ?? null,\n posterUrl: poster,\n jwPath: String(best.fullPath ?? \"\"),\n };\n}\n\n/** Fills imdb/tmdb scores, poster and JustWatch path for theme films that haven't been looked up yet. */\nexport async function fetchRatings(themeId: number, force = false): Promise<{ checked: number; found: number }> {\n const where = force ? \"\" : \"AND ratings_at IS NULL\";\n const films = (await sqlite.execute({\n sql: `SELECT id, title, year FROM films_v1 WHERE theme_id = ? ${where}`,\n args: [themeId],\n })).rows;\n let found = 0;\n // small parallel batches to be polite to the API and stay within request time limits\n for (let i = 0; i < films.length; i += 6) {\n await Promise.all(films.slice(i, i + 6).map(async (f) => {\n let hit: JwHit | null = null;\n try {\n hit = await lookupTitle(String(f.title), String(f.year ?? \"\"));\n } catch {\n return; // leave ratings_at NULL so a later run retries\n }\n if (hit) {\n found++;\n await sqlite.execute({\n sql: `UPDATE films_v1 SET imdb_score = ?, tmdb_score = ?, poster_url = ?, jw_path = ?, ratings_at = ? WHERE id = ?`,\n args: [hit.imdbScore, hit.tmdbScore, hit.posterUrl, hit.jwPath, Date.now(), Number(f.id)],\n });\n } else {\n await sqlite.execute({\n sql: \"UPDATE films_v1 SET ratings_at = ? WHERE id = ?\",\n args: [Date.now(), Number(f.id)],\n });\n }\n }));\n }\n return { checked: films.length, found };\n}\n",[],[453,455],"a224e73d-1ca3-440a-b66c-25751d641f82","letterboxd.ts","467d1004-665b-11f1-8a43-1607ee4eb77e",37,["D",1781267763569],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport const LB_USERS: Record<\"L\" | \"J\", string> = {\n L: \"ltraino\",\n J: \"freethechurro\",\n};\n\nconst DAY_MS = 24 * 60 * 60 * 1000;\nconst UA =\n \"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0 Safari/537.36\";\n\nasync function ensureLbTables(): Promise {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS lb_films_v1 (\n user TEXT NOT NULL,\n slug TEXT NOT NULL,\n title TEXT NOT NULL DEFAULT '',\n year TEXT NOT NULL DEFAULT '',\n PRIMARY KEY (user, slug)\n )`,\n `CREATE TABLE IF NOT EXISTS lb_meta_v1 (\n user TEXT PRIMARY KEY,\n fetched_at INTEGER NOT NULL\n )`,\n ]);\n}\n\nfunction decodeEntities(s: string): string {\n return s\n .replace(/&/g, \"&\")\n .replace(/�?39;/g, \"'\")\n .replace(/"/g, '\"')\n .replace(/</g, \"<\")\n .replace(/>/g, \">\");\n}\n\ninterface LbFilm {\n slug: string;\n title: string;\n year: string;\n}\n\nasync function scrapePage(user: string, page: number): Promise {\n const res = await fetch(`https://letterboxd.com/${user}/films/page/${page}/`, {\n headers: { \"User-Agent\": UA, \"Accept\": \"text/html\" },\n });\n if (!res.ok) return null;\n const html = await res.text();\n const films: LbFilm[] = [];\n for (const m of html.matchAll(/]+data-item-slug=\"([^\"]+)\"[^>]*>/g)) {\n const slug = m[1];\n const nameAttr = m[0].match(/data-item-name=\"([^\"]+)\"/);\n let title = \"\";\n let year = \"\";\n if (nameAttr) {\n const parsed = decodeEntities(nameAttr[1]).match(/^(.*?)(?:\\s+\$(\\d{4})\$)?$/);\n title = parsed?.[1] ?? \"\";\n year = parsed?.[2] ?? \"\";\n }\n if (!year) year = slug.match(/-(\\d{4})$/)?.[1] ?? \"\";\n films.push({ slug, title, year });\n }\n return films;\n}\n\nasync function scrapeUser(user: string): Promise {\n const out: LbFilm[] = [];\n const seen = new Set();\n // 72 films per page; fetch in small parallel batches until a page comes back empty\n for (let start = 1; start <= 57; start += 4) {\n const pages = await Promise.all(\n Array.from({ length: 4 }, (_, i) => scrapePage(user, start + i)),\n );\n let done = false;\n for (const films of pages) {\n if (!films || films.length === 0) {\n done = true;\n continue;\n }\n for (const f of films) {\n if (!seen.has(f.slug)) {\n seen.add(f.slug);\n out.push(f);\n }\n }\n }\n if (done) break;\n }\n return out;\n}\n\nexport function norm(s: string): string {\n return s\n .toLowerCase()\n .normalize(\"NFD\")\n .replace(/[̀-ͯ]/g, \"\")\n .replace(/&/g, \" and \")\n .replace(/[^a-z0-9]+/g, \" \")\n .trim();\n}\n\nfunction stripArticle(s: string): string {\n return s.replace(/^(the|a|an) /, \"\");\n}\n\nexport function titleVariants(title: string): string[] {\n const n = norm(title);\n const out = [n];\n const stripped = stripArticle(n);\n if (stripped !== n) out.push(stripped);\n return out;\n}\n\nfunction slugNorm(slug: string): string {\n return norm(slug.replace(/-\\d{4}$/, \"\").replace(/-/g, \" \"));\n}\n\n/** Returns map of normalised title/slug → years that user has logged on Letterboxd. */\nexport async function getWatchedIndex(\n user: string,\n force = false,\n): Promise<{ index: Map; filmCount: number }> {\n await ensureLbTables();\n const meta = await sqlite.execute({ sql: \"SELECT fetched_at FROM lb_meta_v1 WHERE user = ?\", args: [user] });\n const fresh = meta.rows.length > 0 && Date.now() - Number(meta.rows[0].fetched_at) < DAY_MS;\n if (!fresh || force) {\n const films = await scrapeUser(user);\n if (films.length > 0) { // keep the stale cache rather than wiping it on a failed scrape\n await sqlite.execute({ sql: \"DELETE FROM lb_films_v1 WHERE user = ?\", args: [user] });\n for (let i = 0; i < films.length; i += 50) {\n await sqlite.batch(films.slice(i, i + 50).map((f) => ({\n sql: \"INSERT OR IGNORE INTO lb_films_v1 (user, slug, title, year) VALUES (?, ?, ?, ?)\",\n args: [user, f.slug, f.title, f.year],\n })));\n }\n await sqlite.execute({\n sql: \"INSERT OR REPLACE INTO lb_meta_v1 (user, fetched_at) VALUES (?, ?)\",\n args: [user, Date.now()],\n });\n }\n }\n const rows =\n (await sqlite.execute({ sql: \"SELECT slug, title, year FROM lb_films_v1 WHERE user = ?\", args: [user] })).rows;\n const index = new Map();\n const add = (key: string, year: string) => {\n if (!key) return;\n const years = index.get(key) ?? [];\n years.push(year);\n index.set(key, years);\n };\n for (const r of rows) {\n const year = String(r.year ?? \"\");\n add(slugNorm(String(r.slug)), year);\n for (const v of titleVariants(String(r.title ?? \"\"))) add(v, year);\n }\n return { index, filmCount: rows.length };\n}\n\nfunction yearsCompatible(filmYear: string, lbYears: string[]): boolean {\n const y = Number((filmYear.match(/\\d{4}/) ?? [])[0]);\n if (!y) return true;\n return lbYears.some((ly) => !ly || Math.abs(Number(ly) - y) <= 1);\n}\n\nexport interface PrefillResult {\n L: { user: string; filmCount: number; error: string };\n J: { user: string; filmCount: number; error: string };\n matched: Record;\n}\n\n/** Marks theme films as seen-before when they appear in each person's Letterboxd history. Only ever sets, never unsets. */\nexport async function prefillSeen(themeId: number): Promise {\n const films =\n (await sqlite.execute({ sql: \"SELECT id, title, year, seen_l, seen_j FROM films_v1 WHERE theme_id = ?\", args: [themeId] }))\n .rows;\n const result: PrefillResult = {\n L: { user: LB_USERS.L, filmCount: 0, error: \"\" },\n J: { user: LB_USERS.J, filmCount: 0, error: \"\" },\n matched: {},\n };\n const updates: { sql: string; args: number[] }[] = [];\n for (const who of [\"L\", \"J\"] as const) {\n let index: Map;\n try {\n const r = await getWatchedIndex(LB_USERS[who]);\n index = r.index;\n result[who].filmCount = r.filmCount;\n if (r.filmCount === 0) result[who].error = \"no films found (private profile?)\";\n } catch (e) {\n result[who].error = String(e);\n continue;\n }\n const col = who === \"L\" ? \"seen_l\" : \"seen_j\";\n for (const f of films) {\n const hit = titleVariants(String(f.title)).some((v) => {\n const years = index.get(v);\n return years !== undefined && yearsCompatible(String(f.year ?? \"\"), years);\n });\n if (!hit) continue;\n const id = Number(f.id);\n result.matched[id] = { L: false, J: false, ...result.matched[id], [who]: true };\n if (Number(f[col]) !== 1) {\n updates.push({ sql: `UPDATE films_v1 SET ${col} = 1 WHERE id = ?`, args: [id] });\n }\n }\n }\n for (let i = 0; i < updates.length; i += 50) {\n await sqlite.batch(updates.slice(i, i + 50));\n }\n return result;\n}\n",[],[453,463],"92b92dc2-cb6a-4688-b426-6ac5d428adf2","db.ts","1be90d52-6651-11f1-98ec-1607ee4eb77e",58,["D",1781268552184],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { readFile } from \"https://esm.town/v/std/utils/index.ts\";\n\nexport async function ensureDb(): Promise {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS themes_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n emoji TEXT NOT NULL DEFAULT '',\n month_label TEXT NOT NULL DEFAULT '',\n sort_order INTEGER NOT NULL DEFAULT 0,\n kind TEXT NOT NULL DEFAULT 'monthly'\n )`,\n `CREATE TABLE IF NOT EXISTS films_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n theme_id INTEGER NOT NULL,\n title TEXT NOT NULL,\n year TEXT NOT NULL DEFAULT '',\n runtime_min INTEGER,\n language TEXT NOT NULL DEFAULT '',\n genre TEXT NOT NULL DEFAULT '',\n people TEXT NOT NULL DEFAULT '',\n where_to_watch TEXT NOT NULL DEFAULT '',\n notes TEXT NOT NULL DEFAULT '',\n seen_l INTEGER NOT NULL DEFAULT 0,\n seen_j INTEGER NOT NULL DEFAULT 0,\n watched INTEGER NOT NULL DEFAULT 0,\n imdb_score REAL,\n tmdb_score REAL,\n poster_url TEXT NOT NULL DEFAULT '',\n jw_path TEXT NOT NULL DEFAULT '',\n ratings_at INTEGER,\n watched_at TEXT NOT NULL DEFAULT ''\n )`,\n ]);\n const { rows } = await sqlite.execute(\"SELECT COUNT(*) AS n FROM themes_v1\");\n if (Number(rows[0].n) === 0) await seed();\n}\n\nasync function seed(): Promise {\n const raw = await readFile(\"/backend/seed-data.json\", import.meta.url);\n const data = JSON.parse(raw) as {\n themes: { key: string; name: string; emoji: string; monthLabel: string; sort: number }[];\n films: {\n theme: string;\n title: string;\n year: string;\n language: string;\n whereToWatch: string;\n notes: string;\n runtimeMin: number | null;\n people: string;\n genre: string;\n seenL: boolean;\n seenJ: boolean;\n }[];\n };\n\n const idByKey: Record = {};\n for (const t of data.themes) {\n const r = await sqlite.execute({\n sql: \"INSERT INTO themes_v1 (name, emoji, month_label, sort_order, kind) VALUES (?, ?, ?, ?, ?)\",\n args: [t.name, t.emoji, t.monthLabel, t.sort, t.key === \"bp\" ? \"ongoing\" : \"monthly\"],\n });\n idByKey[t.key] = Number(r.lastInsertRowid);\n }\n\n const stmts = data.films.map((f) => ({\n sql: `INSERT INTO films_v1\n (theme_id, title, year, runtime_min, language, genre, people, where_to_watch, notes, seen_l, seen_j, watched)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n idByKey[f.theme],\n f.title,\n f.year,\n f.runtimeMin,\n f.language,\n f.genre,\n f.people,\n f.whereToWatch,\n f.notes,\n f.seenL ? 1 : 0,\n f.seenJ ? 1 : 0,\n // the scandi sheet's single SEEN column meant \"watched together that month\"\n f.theme === \"scandi\" && f.seenL ? 1 : 0,\n ],\n }));\n // insert in chunks to stay under batch limits\n for (let i = 0; i < stmts.length; i += 50) {\n await sqlite.batch(stmts.slice(i, i + 50));\n }\n}\n\nfunction mapFilm(r: Record) {\n return {\n id: Number(r.id),\n themeId: Number(r.theme_id),\n title: String(r.title),\n year: String(r.year ?? \"\"),\n runtimeMin: r.runtime_min === null ? null : Number(r.runtime_min),\n language: String(r.language ?? \"\"),\n genre: String(r.genre ?? \"\"),\n people: String(r.people ?? \"\"),\n whereToWatch: String(r.where_to_watch ?? \"\"),\n notes: String(r.notes ?? \"\"),\n seenL: Number(r.seen_l) === 1,\n seenJ: Number(r.seen_j) === 1,\n watched: Number(r.watched) === 1,\n watchedAt: String(r.watched_at ?? \"\"),\n imdbScore: r.imdb_score === null || r.imdb_score === undefined ? null : Number(r.imdb_score),\n tmdbScore: r.tmdb_score === null || r.tmdb_score === undefined ? null : Number(r.tmdb_score),\n posterUrl: String(r.poster_url ?? \"\"),\n jwPath: String(r.jw_path ?? \"\"),\n ratingsAt: r.ratings_at === null || r.ratings_at === undefined ? null : Number(r.ratings_at),\n };\n}\n\nexport async function getState() {\n const themes = (await sqlite.execute(\"SELECT * FROM themes_v1 ORDER BY sort_order, id\")).rows;\n const films = (await sqlite.execute(\"SELECT * FROM films_v1 ORDER BY id\")).rows;\n return {\n themes: themes.map((t) => ({\n id: Number(t.id),\n name: String(t.name),\n emoji: String(t.emoji ?? \"\"),\n monthLabel: String(t.month_label ?? \"\"),\n kind: String(t.kind ?? \"monthly\"),\n films: films.filter((f) => Number(f.theme_id) === Number(t.id)).map(mapFilm),\n })),\n };\n}\n\nexport const FILM_FIELDS: Record = {\n title: \"title\",\n year: \"year\",\n runtimeMin: \"runtime_min\",\n language: \"language\",\n genre: \"genre\",\n people: \"people\",\n whereToWatch: \"where_to_watch\",\n notes: \"notes\",\n seenL: \"seen_l\",\n seenJ: \"seen_j\",\n watched: \"watched\",\n watchedAt: \"watched_at\",\n posterUrl: \"poster_url\",\n};\n",[],[453,471],"d61e545b-bfba-4d13-9dc1-3c506f55af51",["D",1781263325959],[367,368,369,370],[453],["D",1781262090577],["D",1789532458193],{"_11":12,"_280":95},{"_11":12,"_275":276,"_94":95,"_31":93,"_277":278,"_279":30},{"_55":263,"_13":16,"_49":52,"_264":225,"_265":84,"_266":267,"_268":229,"_269":270,"_271":272,"_273":14,"_274":12},"ctx",{"_67":-5,"_301":520,"_521":522,"_523":524,"_525":30,"_526":30,"_527":30,"_528":24,"_529":-5,"_530":-7,"_531":-7,"_532":99,"_533":30,"_534":30,"_535":-5,"_536":30,"_537":30,"_538":30,"_539":-5},"ENV",{"_491":492,"_493":494,"_495":16,"_496":497,"_498":499,"_500":501,"_502":503,"_504":505,"_506":507,"_508":509,"_510":511,"_512":513,"_514":515,"_516":517,"_518":519},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

History · components