// Per-City Carrier Scorecard — the paid product surface. // // One carrier, one metro. The deliverable shippers, brokers, and carriers // pay for. Renders in two modes: // // 1. LA-seeded mode: real scored carrier data from LA_REPORT — full // scorecard with metric bars, peer rank, verdict, all the goods. // 2. Provisional mode (every other metro): live operator-network signal // filtered by carrier + city. No fake scores. Honest framing, // subscribe-CTA upsell to the full Pulse. const { useState: useStateSC, useEffect: useEffectSC, useMemo: useMemoSC } = React; function PerCityScorecard({ carrierSlug, cityId, onNav, onCarrier }) { const cities = (window.SI_DATA && window.SI_DATA.ALL_CITIES) || []; const cityMeta = cities.find(c => c.id === cityId) || { id: cityId, name: cityId, state: "" }; // LA scorecard is the only seeded full-data city. const isLA = cityId === "los-angeles"; const LA_REPORT = window.SI_DATA && window.SI_DATA.LA_REPORT; const METRICS = (window.SI_DATA && window.SI_DATA.METRICS) || []; // Find the carrier inside LA_REPORT (only valid in LA mode). let laCarrier = null, laCatId = null; if (isLA && LA_REPORT) { for (const cat of Object.keys(LA_REPORT.carriers || {})) { const found = LA_REPORT.carriers[cat].find(c => c.id === carrierSlug); if (found) { laCarrier = found; laCatId = cat; break; } } } // Carrier display name — fall back gracefully when the carrier isn't in // the LA seed (e.g. a smaller TL like Covenant in Chicago). const [carrierName, setCarrierName] = useStateSC( laCarrier ? laCarrier.name : carrierSlug.split("-").map(w => w[0].toUpperCase() + w.slice(1)).join(" ") ); // Live data const [signals, setSignals] = useStateSC([]); const [loadingSignals, setLoadingSignals] = useStateSC(true); useEffectSC(() => { let alive = true; async function load() { if (!window.SI_DB || !window.SI_DB.raw) { setLoadingSignals(false); return; } try { // Operator-network signals tagged to this carrier in this city. const data = await window.SI_DB.raw.select( "intel_submissions", `select=id,parsed_carrier,parsed_intel_type,severity,raw_text,created_at,source_url,notes` + `&parsed_carrier=eq.${encodeURIComponent(carrierSlug)}` + `&city_id=eq.${encodeURIComponent(cityId)}` + `&status=eq.verified&visibility=eq.public` + `&order=created_at.desc&limit=100` ); if (!alive) return; setSignals(Array.isArray(data) ? data : []); // If we still don't have a friendly carrier name, look it up. if (!laCarrier) { const ent = await window.SI_DB.raw.select( "entities", `select=name&type=eq.carrier&slug=eq.${encodeURIComponent(carrierSlug)}&limit=1` ); if (alive && Array.isArray(ent) && ent[0] && ent[0].name) { setCarrierName(ent[0].name); } } } catch (e) { console.warn("[scorecard] load failed", e); } finally { if (alive) setLoadingSignals(false); } } load(); return () => { alive = false; }; }, [carrierSlug, cityId]); const now = Date.now(); const day = 24 * 3600 * 1000; const within30d = signals.filter(r => now - new Date(r.created_at).getTime() < 30 * day); const sev = (r) => r.severity || "low"; const high30d = within30d.filter(r => sev(r) === "high" || sev(r) === "critical").length; const byType = {}; within30d.forEach(r => { const t = r.parsed_intel_type || "other"; byType[t] = (byType[t] || 0) + 1; }); const topTypes = Object.entries(byType).sort((a,b)=>b[1]-a[1]).slice(0, 5); function fmtDate(s) { const d = new Date(s); const days = Math.round((now - d.getTime()) / day); if (days === 0) return "today"; if (days === 1) return "yesterday"; if (days < 7) return `${days}d ago`; return d.toLocaleDateString("en-US", { month: "short", day: "numeric" }); } function prettyType(t) { return t.replace(/_/g, " "); } // Peer rank within the metro (LA mode only — uses seeded scores). const peers = (isLA && laCarrier && LA_REPORT) ? (LA_REPORT.carriers[laCatId] || []).slice().sort((a,b)=>b.score-a.score) : []; const rank = peers.findIndex(p => p.id === carrierSlug); return (
{ e.preventDefault(); onNav("home"); }}>Home / { e.preventDefault(); onCarrier(carrierSlug); }}>{carrierName} / {cityMeta.name}, {cityMeta.state}
{isLA && laCarrier ? "Q1 2026 Carrier Scorecard" : "Provisional Pulse · Operator-network signal"}

{carrierName} in {cityMeta.name}.

{isLA && laCarrier ? (

{laCarrier.shipments} shipments analyzed · {laCarrier.complaints} complaints filed · Q1 2026 reporting period

) : (

{within30d.length} operator signals · last 30 days · published intel only

)}
{isLA && laCarrier ? (

"{laCarrier.verdict}"

) : (

Provisional read for {carrierName} in {cityMeta.name}. The full carrier scorecard publishes once we have enough field-validated lanes here. In the meantime, this page surfaces every published operator signal tagged to {carrierName} in this metro.

)} {rank >= 0 && peers.length > 1 && (

Ranks #{rank + 1} of {peers.length} in {cityMeta.name} · {" "}{laCatId === "small" ? "Small Package" : laCatId === "ltl" ? "LTL Freight" : laCatId === "ftl" ? "Truckload (FTL)" : laCatId === "courier" ? "Courier" : "International"}

)}
{isLA && laCarrier ? ( <>
Score · 0–100
{laCarrier.score}
{window.SI_DATA && window.SI_DATA.scoreToLetter ? window.SI_DATA.scoreToLetter(laCarrier.score) : ""}
Trend {laCarrier.trend > 0 ? "↑" : laCarrier.trend < 0 ? "↓" : "→"} QoQ
) : ( <>
Score
Provisional
Pulse-tier signal only
)}
{/* Stats strip */}
{loadingSignals ? "…" : within30d.length}
Signals · 30d
0 ? "oklch(0.55 0.18 25)" : "var(--ink)" }}> {loadingSignals ? "…" : high30d}
High + critical
{loadingSignals ? "…" : Object.keys(byType).length}
Distinct issue types
{isLA && laCarrier ? laCarrier.complaints : "—"}
Complaints filed
{/* Metric breakdown — LA mode only (real seeded data) */} {isLA && laCarrier && (
Metric breakdown · {cityMeta.name}
{METRICS.map((m, i) => ( ))}
)} {/* Live signal feed */}
{carrierName} · {cityMeta.name} · operator-network signal
{loadingSignals ? (

Loading…

) : within30d.length === 0 ? (
No public operator signals tagged to {carrierName} in {cityMeta.name} in the last 30 days.
That's not the same as nothing happening — submit a tip if you've seen something.
) : ( <>

Top issue types

{topTypes.length ? (
    {topTypes.map(([t, n]) => (
  • {prettyType(t)}{n}
    • ))}
) :

—

}

Severity mix · 30d

    {["critical","high","moderate","low"].map(s => { const n = within30d.filter(r => sev(r) === s).length; if (n === 0) return null; return
  • {s}{n}
    • ; })}
{within30d.slice(0, 10).map(r => (
{sev(r)} {prettyType(r.parsed_intel_type || "other")} · {fmtDate(r.created_at)}

{r.raw_text}

))}
)}
{/* Paywall affordance — premium-tier upsell */}
Subscriber-tier deliverable

The full {carrierName} · {cityMeta.name} report

Lane-level scoring, dock-level operator-rated detention, claims and damage-rate trend over six quarters, real-name shipper testimony (where consented), regulatory and FMCSA-tied violations, and the editorial pattern read. Updated every Pulse cycle.

); } window.PerCityScorecard = PerCityScorecard;