[object Object]

← back to Rentv Ad Engine

harden extraction: union-find advertiser dedup, email split, regex-site attach; guest hygiene (drop hallucinated/thin, add verified flag); emails + verified badge in UI

0c18e9bc21ac6af2d5fc9be57ae7206521eba9fe · 2026-08-07 08:58:35 -0700 · Steve Abrams

Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>

Files touched

Diff

commit 0c18e9bc21ac6af2d5fc9be57ae7206521eba9fe
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Fri Aug 7 08:58:35 2026 -0700

    harden extraction: union-find advertiser dedup, email split, regex-site attach; guest hygiene (drop hallucinated/thin, add verified flag); emails + verified badge in UI
    
    Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
---
 data/advertisers.json           | 843 ++++++++++++++++++++++++++++++++++++++-
 data/extractions/721184140.json |  36 ++
 data/extractions/739081927.json |  89 +++++
 data/extractions/763442741.json |  68 ++++
 data/extractions/763447786.json | 104 +++++
 data/extractions/771348410.json |  57 +++
 data/extractions/795355693.json |  57 +++
 data/extractions/811518445.json |  71 ++++
 data/extractions/812981342.json |  62 +++
 data/extractions/812982818.json |  71 ++++
 data/extractions/830276773.json | 120 ++++++
 data/extractions/830279080.json |  73 ++++
 data/extractions/831673533.json |  57 +++
 data/extractions/852462696.json |  57 +++
 data/guests.json                | 860 +++++++++++++++++++++++++++++++++++++++-
 public/index.html               |   4 +-
 scripts/extract.py              | 147 +++++--
 17 files changed, 2714 insertions(+), 62 deletions(-)

diff --git a/data/advertisers.json b/data/advertisers.json
index 5eeb8fb..2c2fd16 100644
--- a/data/advertisers.json
+++ b/data/advertisers.json
@@ -1,44 +1,418 @@
 {
- "generated_at": "2026-08-07 08:46:08",
- "count": 4,
+ "generated_at": "2026-08-07 08:55:23",
+ "count": 29,
  "advertisers": [
   {
-   "name": "Chase Partners",
+   "name": "Commercial Real Estate Inspectors",
+   "aliases": [
+    "Commercial Real Estate Inspectors in Southern California",
+    "Commercial real estate inspectors",
+    "Commercial real estate inspectors in Southern California",
+    "Southern California focused commercial real estate inspectors",
+    "commercial real estate inspectors",
+    "commercial real estate inspectors in Southern California"
+   ],
+   "category": "other",
+   "websites": [],
+   "phones": [
+    "(818) 957-4654",
+    "818-957-4654",
+    "818-9574654",
+    "8189574654"
+   ],
+   "emails": [],
+   "contacts": [
+    "Paul Tiffany Simmington",
+    "Tiff Tiffany Simington",
+    "Tiffany Simington",
+    "Tiffany Simmington"
+   ],
+   "pitch": "Skilled inspectors providing critically needed inspection information in easily understood terms, as well as inexpensive, simple solutions for commercial real estate.",
+   "appearances": 17,
+   "episodes": [
+    {
+     "id": 1138312637,
+     "title": "CRE Talk Episode #19 - Chris Tourtellotte",
+     "url": "https://vimeo.com/1138312637"
+    },
+    {
+     "id": 1115700624,
+     "title": "CRE Talk  Episode #18 Terry Tallen",
+     "url": "https://vimeo.com/1115700624"
+    },
+    {
+     "id": 1106281388,
+     "title": "RENTV CRE Talk Episode #17 Chris Rising",
+     "url": "https://vimeo.com/1106281388"
+    },
+    {
+     "id": 1079649123,
+     "title": "RENTV CRE Talk Episode #16 - Alex Zikakis",
+     "url": "https://vimeo.com/1079649123"
+    },
+    {
+     "id": 1059913595,
+     "title": "RENTV CRE Talk Episode #15 - Marc Brutten",
+     "url": "https://vimeo.com/1059913595"
+    },
+    {
+     "id": 1056513923,
+     "title": "RENTV CRE Talk Episode #14 - John McNellis",
+     "url": "https://vimeo.com/1056513923"
+    },
+    {
+     "id": 1012976399,
+     "title": "RENTV CRE Talk Episode #12 - Kaitlin Arduino",
+     "url": "https://vimeo.com/1012976399"
+    },
+    {
+     "id": 931863337,
+     "title": "RENTV CRE Talk Episode #10 Henry Manoucheri",
+     "url": "https://vimeo.com/931863337"
+    },
+    {
+     "id": 911412212,
+     "title": "RENTV CRE Talk Episode #9 Eddie Ring",
+     "url": "https://vimeo.com/911412212"
+    },
+    {
+     "id": 906276616,
+     "title": "RENTV CRE Talk Episode #8 Erwin Bucy",
+     "url": "https://vimeo.com/906276616"
+    },
+    {
+     "id": 886025667,
+     "title": "RENTV CRE Talk Episode #7 Chuck Hershson",
+     "url": "https://vimeo.com/886025667"
+    },
+    {
+     "id": 868849453,
+     "title": "RENTV CRE Talk Episode #6 Barry Saywitz",
+     "url": "https://vimeo.com/868849453"
+    },
+    {
+     "id": 852462696,
+     "title": "RENTV CRE Talk Episode #5 Barry DiRaimondo",
+     "url": "https://vimeo.com/852462696"
+    },
+    {
+     "id": 831673533,
+     "title": "RENTV CRE Talk Episode #4 John McNellis",
+     "url": "https://vimeo.com/831673533"
+    },
+    {
+     "id": 812981342,
+     "title": "RENTV CRE Talk Episode #3 - Michael Van Every",
+     "url": "https://vimeo.com/812981342"
+    },
+    {
+     "id": 795355693,
+     "title": "RENTV CRE Talk Episode #2 - Sandy Sigal",
+     "url": "https://vimeo.com/795355693"
+    },
+    {
+     "id": 771348410,
+     "title": "RENTV CRE Talk Episode #1 - Bill Shopoff",
+     "url": "https://vimeo.com/771348410"
+    }
+   ]
+  },
+  {
+   "name": "Fidelity Mortgage Lenders",
    "aliases": [],
-   "category": "developer|investor",
+   "category": "lender",
    "websites": [],
-   "phones": [],
+   "phones": [
+    "800-752-9533",
+    "807 529533",
+    "807-529-533",
+    "807529533"
+   ],
+   "emails": [],
    "contacts": [
-    "David Parker, Head of Chase Partners"
+    "Uncle Chuck or John McClain",
+    "Uncle Chuck or John McLean",
+    "Uncle Chuck, SA is known or John McLean"
    ],
-   "pitch": "Leading investor and developer of industrial properties in Southern California for over 30 years, focusing on underperforming industrial and retail properties.",
-   "appearances": 1,
+   "pitch": "A private lending company specializing in commercial real estate, known for its unique terms, fast funding, no prepayment penalties, and long-term fixed rate.",
+   "appearances": 16,
    "episodes": [
     {
      "id": 1200839794,
      "title": "CRE Talk Episode #22 with Bill Shopoff",
      "url": "https://vimeo.com/1200839794"
+    },
+    {
+     "id": 1199114985,
+     "title": "CRE Talk Episode #21 with Daniel Weiss",
+     "url": "https://vimeo.com/1199114985"
+    },
+    {
+     "id": 1178561985,
+     "title": "CRE Talk Episode #20 with Colton Sudberry",
+     "url": "https://vimeo.com/1178561985"
+    },
+    {
+     "id": 1138312637,
+     "title": "CRE Talk Episode #19 - Chris Tourtellotte",
+     "url": "https://vimeo.com/1138312637"
+    },
+    {
+     "id": 1115700624,
+     "title": "CRE Talk  Episode #18 Terry Tallen",
+     "url": "https://vimeo.com/1115700624"
+    },
+    {
+     "id": 1106281388,
+     "title": "RENTV CRE Talk Episode #17 Chris Rising",
+     "url": "https://vimeo.com/1106281388"
+    },
+    {
+     "id": 1079649123,
+     "title": "RENTV CRE Talk Episode #16 - Alex Zikakis",
+     "url": "https://vimeo.com/1079649123"
+    },
+    {
+     "id": 1059913595,
+     "title": "RENTV CRE Talk Episode #15 - Marc Brutten",
+     "url": "https://vimeo.com/1059913595"
+    },
+    {
+     "id": 1056513923,
+     "title": "RENTV CRE Talk Episode #14 - John McNellis",
+     "url": "https://vimeo.com/1056513923"
+    },
+    {
+     "id": 1012976399,
+     "title": "RENTV CRE Talk Episode #12 - Kaitlin Arduino",
+     "url": "https://vimeo.com/1012976399"
+    },
+    {
+     "id": 931863337,
+     "title": "RENTV CRE Talk Episode #10 Henry Manoucheri",
+     "url": "https://vimeo.com/931863337"
+    },
+    {
+     "id": 911412212,
+     "title": "RENTV CRE Talk Episode #9 Eddie Ring",
+     "url": "https://vimeo.com/911412212"
+    },
+    {
+     "id": 906276616,
+     "title": "RENTV CRE Talk Episode #8 Erwin Bucy",
+     "url": "https://vimeo.com/906276616"
+    },
+    {
+     "id": 886025667,
+     "title": "RENTV CRE Talk Episode #7 Chuck Hershson",
+     "url": "https://vimeo.com/886025667"
+    },
+    {
+     "id": 862593366,
+     "title": "The Finance Panel at RENTV's Greater LA State of the Market Conference",
+     "url": "https://vimeo.com/862593366"
+    },
+    {
+     "id": 763447786,
+     "title": "RENTV FINANCE OCT 19 2022.mp4",
+     "url": "https://vimeo.com/763447786"
     }
    ]
   },
   {
-   "name": "Fidelity Mortgage Lenders",
-   "aliases": [],
-   "category": "lender",
+   "name": "Paramount Property Tax Appeal",
+   "aliases": [
+    "Paramount Property Tax",
+    "paramount Property Tax Appeal"
+   ],
+   "category": "other",
    "websites": [],
    "phones": [
-    "800-752-9533"
+    "(858) 225-1200",
+    "(858) 758-9515",
+    "858-225-1200",
+    "858-2251200",
+    "858-758-9515",
+    "8582251200",
+    "8582251208"
    ],
+   "emails": [],
    "contacts": [
-    "Uncle Chuck or John McLean"
+    "Arnie",
+    "Wes Nichols",
+    "West Nichols"
    ],
-   "pitch": "A private lending company specializing in commercial real estate, known for unique terms, fast funding, no prepayment penalties, and long-term fixed rates.",
-   "appearances": 1,
+   "pitch": "Helping you fight back against property taxes, even if you have great income, you can still qualify to have your property taxes lowered.",
+   "appearances": 10,
+   "episodes": [
+    {
+     "id": 1012976399,
+     "title": "RENTV CRE Talk Episode #12 - Kaitlin Arduino",
+     "url": "https://vimeo.com/1012976399"
+    },
+    {
+     "id": 931863337,
+     "title": "RENTV CRE Talk Episode #10 Henry Manoucheri",
+     "url": "https://vimeo.com/931863337"
+    },
+    {
+     "id": 911412212,
+     "title": "RENTV CRE Talk Episode #9 Eddie Ring",
+     "url": "https://vimeo.com/911412212"
+    },
+    {
+     "id": 906276616,
+     "title": "RENTV CRE Talk Episode #8 Erwin Bucy",
+     "url": "https://vimeo.com/906276616"
+    },
+    {
+     "id": 868849453,
+     "title": "RENTV CRE Talk Episode #6 Barry Saywitz",
+     "url": "https://vimeo.com/868849453"
+    },
+    {
+     "id": 852462696,
+     "title": "RENTV CRE Talk Episode #5 Barry DiRaimondo",
+     "url": "https://vimeo.com/852462696"
+    },
+    {
+     "id": 831673533,
+     "title": "RENTV CRE Talk Episode #4 John McNellis",
+     "url": "https://vimeo.com/831673533"
+    },
+    {
+     "id": 812981342,
+     "title": "RENTV CRE Talk Episode #3 - Michael Van Every",
+     "url": "https://vimeo.com/812981342"
+    },
+    {
+     "id": 795355693,
+     "title": "RENTV CRE Talk Episode #2 - Sandy Sigal",
+     "url": "https://vimeo.com/795355693"
+    },
+    {
+     "id": 771348410,
+     "title": "RENTV CRE Talk Episode #1 - Bill Shopoff",
+     "url": "https://vimeo.com/771348410"
+    }
+   ]
+  },
+  {
+   "name": "Chase Partners",
+   "aliases": [],
+   "category": "developer|investor",
+   "websites": [
+    "chasepartners.com"
+   ],
+   "phones": [],
+   "emails": [
+    "Dave Parker, David@chasepartners.com",
+    "David Parker at David@chasepartners.com",
+    "David@chasepartners.com",
+    "david@chasepartners.com"
+   ],
+   "contacts": [
+    "David Parker",
+    "David Parker, Head of Chase Partners",
+    "David Parker, head of Chase"
+   ],
+   "pitch": "Leading investor and developer of industrial properties in Southern California, focusing on underperforming industrial and retail properties, other distressed assets, or properties with non-performing debt.",
+   "appearances": 9,
    "episodes": [
     {
      "id": 1200839794,
      "title": "CRE Talk Episode #22 with Bill Shopoff",
      "url": "https://vimeo.com/1200839794"
+    },
+    {
+     "id": 1199114985,
+     "title": "CRE Talk Episode #21 with Daniel Weiss",
+     "url": "https://vimeo.com/1199114985"
+    },
+    {
+     "id": 1178561985,
+     "title": "CRE Talk Episode #20 with Colton Sudberry",
+     "url": "https://vimeo.com/1178561985"
+    },
+    {
+     "id": 1138312637,
+     "title": "CRE Talk Episode #19 - Chris Tourtellotte",
+     "url": "https://vimeo.com/1138312637"
+    },
+    {
+     "id": 1115700624,
+     "title": "CRE Talk  Episode #18 Terry Tallen",
+     "url": "https://vimeo.com/1115700624"
+    },
+    {
+     "id": 1106281388,
+     "title": "RENTV CRE Talk Episode #17 Chris Rising",
+     "url": "https://vimeo.com/1106281388"
+    },
+    {
+     "id": 1079649123,
+     "title": "RENTV CRE Talk Episode #16 - Alex Zikakis",
+     "url": "https://vimeo.com/1079649123"
+    },
+    {
+     "id": 1059913595,
+     "title": "RENTV CRE Talk Episode #15 - Marc Brutten",
+     "url": "https://vimeo.com/1059913595"
+    },
+    {
+     "id": 1056513923,
+     "title": "RENTV CRE Talk Episode #14 - John McNellis",
+     "url": "https://vimeo.com/1056513923"
+    }
+   ]
+  },
+  {
+   "name": "Redwood Mortgage",
+   "aliases": [],
+   "category": "lender",
+   "websites": [
+    "redwoodmortgage.com"
+   ],
+   "phones": [
+    "1-800-6596593",
+    "1806596593"
+   ],
+   "emails": [],
+   "contacts": [
+    "Steve Belleville"
+   ],
+   "pitch": "A direct private money lender with over 44 years of experience in commercial and residential investment properties, ranging from $200,000 to $10 million.",
+   "appearances": 6,
+   "episodes": [
+    {
+     "id": 868849453,
+     "title": "RENTV CRE Talk Episode #6 Barry Saywitz",
+     "url": "https://vimeo.com/868849453"
+    },
+    {
+     "id": 852462696,
+     "title": "RENTV CRE Talk Episode #5 Barry DiRaimondo",
+     "url": "https://vimeo.com/852462696"
+    },
+    {
+     "id": 831673533,
+     "title": "RENTV CRE Talk Episode #4 John McNellis",
+     "url": "https://vimeo.com/831673533"
+    },
+    {
+     "id": 812981342,
+     "title": "RENTV CRE Talk Episode #3 - Michael Van Every",
+     "url": "https://vimeo.com/812981342"
+    },
+    {
+     "id": 795355693,
+     "title": "RENTV CRE Talk Episode #2 - Sandy Sigal",
+     "url": "https://vimeo.com/795355693"
+    },
+    {
+     "id": 771348410,
+     "title": "RENTV CRE Talk Episode #1 - Bill Shopoff",
+     "url": "https://vimeo.com/771348410"
     }
    ]
   },
@@ -52,16 +426,29 @@
    "phones": [
     "951-403-0567"
    ],
+   "emails": [],
    "contacts": [
+    "Gina Conant, Sales Manager",
+    "Gina Conant, Vice President and Sales Manager",
     "Gina Conant, Vice President and Sales Manager of Commercial Real Estate Lending"
    ],
    "pitch": "A California-focused portfolio lender with a legacy dating back to 1956, providing financing for properties ranging from light industrial to multifamily.",
-   "appearances": 1,
+   "appearances": 3,
    "episodes": [
     {
      "id": 1200839794,
      "title": "CRE Talk Episode #22 with Bill Shopoff",
      "url": "https://vimeo.com/1200839794"
+    },
+    {
+     "id": 1199114985,
+     "title": "CRE Talk Episode #21 with Daniel Weiss",
+     "url": "https://vimeo.com/1199114985"
+    },
+    {
+     "id": 1178561985,
+     "title": "CRE Talk Episode #20 with Colton Sudberry",
+     "url": "https://vimeo.com/1178561985"
     }
    ]
   },
@@ -73,14 +460,436 @@
     "rockefellergroup.com"
    ],
    "phones": [],
+   "emails": [],
    "contacts": [],
    "pitch": "Delivers exceptional experiences and value creation through dedication to quality in the built environment, developing, owning, and operating properties.",
-   "appearances": 1,
+   "appearances": 3,
    "episodes": [
     {
      "id": 1200839794,
      "title": "CRE Talk Episode #22 with Bill Shopoff",
      "url": "https://vimeo.com/1200839794"
+    },
+    {
+     "id": 1199114985,
+     "title": "CRE Talk Episode #21 with Daniel Weiss",
+     "url": "https://vimeo.com/1199114985"
+    },
+    {
+     "id": 1178561985,
+     "title": "CRE Talk Episode #20 with Colton Sudberry",
+     "url": "https://vimeo.com/1178561985"
+    }
+   ]
+  },
+  {
+   "name": "The Bascom Group",
+   "aliases": [],
+   "category": "developer|broker",
+   "websites": [],
+   "phones": [],
+   "emails": [],
+   "contacts": [],
+   "pitch": "A developer focusing on multi-family properties in Orange County and nationwide, with a history of value-add acquisitions and recent foray into development.",
+   "appearances": 2,
+   "episodes": [
+    {
+     "id": 865035925,
+     "title": "The Multifamily Panel at RENTV's Greater LA State of the Market Conference",
+     "url": "https://vimeo.com/865035925"
+    },
+    {
+     "id": 739081927,
+     "title": "RENTV ORANGE COUNTY MULTIFAMILY PANEL July 26, 2022",
+     "url": "https://vimeo.com/739081927"
+    }
+   ]
+  },
+  {
+   "name": "Advanced Real Estate Services",
+   "aliases": [],
+   "category": "broker",
+   "websites": [],
+   "phones": [],
+   "emails": [],
+   "contacts": [],
+   "pitch": "Buying apartments in Southern California with a portfolio of over 10,000 units.",
+   "appearances": 1,
+   "episodes": [
+    {
+     "id": 865035925,
+     "title": "The Multifamily Panel at RENTV's Greater LA State of the Market Conference",
+     "url": "https://vimeo.com/865035925"
+    }
+   ]
+  },
+  {
+   "name": "Advanced Real Estate The Firm",
+   "aliases": [],
+   "category": "property mgmt|developer",
+   "websites": [],
+   "phones": [],
+   "emails": [],
+   "contacts": [],
+   "pitch": "A vertically integrated property management and development firm in Southern California, specializing in long-term hold strategies.",
+   "appearances": 1,
+   "episodes": [
+    {
+     "id": 739081927,
+     "title": "RENTV ORANGE COUNTY MULTIFAMILY PANEL July 26, 2022",
+     "url": "https://vimeo.com/739081927"
+    }
+   ]
+  },
+  {
+   "name": "Axo Bank",
+   "aliases": [],
+   "category": "lender",
+   "websites": [],
+   "phones": [],
+   "emails": [],
+   "contacts": [],
+   "pitch": "Axo Bank is a neobank with no physical branch network, offering real estate financing including bridge and permanent loans.",
+   "appearances": 1,
+   "episodes": [
+    {
+     "id": 862593366,
+     "title": "The Finance Panel at RENTV's Greater LA State of the Market Conference",
+     "url": "https://vimeo.com/862593366"
+    }
+   ]
+  },
+  {
+   "name": "Axos Bank",
+   "aliases": [],
+   "category": "lender",
+   "websites": [],
+   "phones": [],
+   "emails": [],
+   "contacts": [],
+   "pitch": "A lender offering financial services.",
+   "appearances": 1,
+   "episodes": [
+    {
+     "id": 763447786,
+     "title": "RENTV FINANCE OCT 19 2022.mp4",
+     "url": "https://vimeo.com/763447786"
+    }
+   ]
+  },
+  {
+   "name": "CBRE",
+   "aliases": [],
+   "category": "broker",
+   "websites": [],
+   "phones": [],
+   "emails": [],
+   "contacts": [],
+   "pitch": "A real estate investment sales division covering Orange County and bordering markets, focusing on 10 to 100 unit transactions.",
+   "appearances": 1,
+   "episodes": [
+    {
+     "id": 739081927,
+     "title": "RENTV ORANGE COUNTY MULTIFAMILY PANEL July 26, 2022",
+     "url": "https://vimeo.com/739081927"
+    }
+   ]
+  },
+  {
+   "name": "CBRE's National Retail Partners West Team",
+   "aliases": [],
+   "category": "broker",
+   "websites": [],
+   "phones": [],
+   "emails": [],
+   "contacts": [
+    "John Reed"
+   ],
+   "pitch": "Specializing in retail investment properties throughout the Inland Empire, California since 2012.",
+   "appearances": 1,
+   "episodes": [
+    {
+     "id": 830276773,
+     "title": "The Retail Panel at RENTV's Inland Empire State of The Market Conference",
+     "url": "https://vimeo.com/830276773"
+    }
+   ]
+  },
+  {
+   "name": "City of Ontario",
+   "aliases": [],
+   "category": "government entity",
+   "websites": [],
+   "phones": [],
+   "emails": [],
+   "contacts": [
+    "Jennifer McClain Harimoto"
+   ],
+   "pitch": "Economic development director for the city, highlighting development opportunities and reinvesting sales tax revenue into capital improvement projects.",
+   "appearances": 1,
+   "episodes": [
+    {
+     "id": 830276773,
+     "title": "The Retail Panel at RENTV's Inland Empire State of The Market Conference",
+     "url": "https://vimeo.com/830276773"
+    }
+   ]
+  },
+  {
+   "name": "First",
+   "aliases": [],
+   "category": "lender",
+   "websites": [],
+   "phones": [],
+   "emails": [],
+   "contacts": [],
+   "pitch": "Not explicitly stated, but likely a lender offering financial services.",
+   "appearances": 1,
+   "episodes": [
+    {
+     "id": 1039101858,
+     "title": "RENTV CRE Talk Episode #13 - Ethan Penner",
+     "url": "https://vimeo.com/1039101858"
+    }
+   ]
+  },
+  {
+   "name": "Jones Lang LaSalle (JLL)",
+   "aliases": [],
+   "category": "lender|developer|broker",
+   "websites": [],
+   "phones": [],
+   "emails": [],
+   "contacts": [
+    "Mark McAdams"
+   ],
+   "pitch": "one of the larger national brokerage companies, pioneer of the Inland Empire market",
+   "appearances": 1,
+   "episodes": [
+    {
+     "id": 830279080,
+     "title": "The Office Panel at RENTV's Inland Empire State of The Market Conference",
+     "url": "https://vimeo.com/830279080"
+    }
+   ]
+  },
+  {
+   "name": "MG R Real Estate",
+   "aliases": [],
+   "category": "broker",
+   "websites": [],
+   "phones": [],
+   "emails": [],
+   "contacts": [],
+   "pitch": "primarily office brokers, owning about 1.8 million feet of office space in the L and Empire area",
+   "appearances": 1,
+   "episodes": [
+    {
+     "id": 830279080,
+     "title": "The Office Panel at RENTV's Inland Empire State of The Market Conference",
+     "url": "https://vimeo.com/830279080"
+    }
+   ]
+  },
+  {
+   "name": "MGR Real Estate Services",
+   "aliases": [],
+   "category": "brokerage|property management",
+   "websites": [],
+   "phones": [],
+   "emails": [],
+   "contacts": [],
+   "pitch": "Family-owned brokerage firm with residential and commercial properties, managing 17,000 doors and employing over 200 people.",
+   "appearances": 1,
+   "episodes": [
+    {
+     "id": 953281926,
+     "title": "RENTV CRE Talk Episode #11 - Michael Rademaker",
+     "url": "https://vimeo.com/953281926"
+    }
+   ]
+  },
+  {
+   "name": "Ms. Rahi TE Bank",
+   "aliases": [],
+   "category": "lender",
+   "websites": [],
+   "phones": [],
+   "emails": [],
+   "contacts": [],
+   "pitch": "Ms. Rahi TE Bank is a U.S.-based lending arm of an Israeli bank, focusing on bridge and value-add loans for apartment construction.",
+   "appearances": 1,
+   "episodes": [
+    {
+     "id": 862593366,
+     "title": "The Finance Panel at RENTV's Greater LA State of the Market Conference",
+     "url": "https://vimeo.com/862593366"
+    }
+   ]
+  },
+  {
+   "name": "Newmark Merrill Companies",
+   "aliases": [],
+   "category": "developer|property manager",
+   "websites": [],
+   "phones": [],
+   "emails": [],
+   "contacts": [
+    "Greg Gia Capozzi"
+   ],
+   "pitch": "Community focused, community first developer and real estate owner for retail properties across Southern California.",
+   "appearances": 1,
+   "episodes": [
+    {
+     "id": 830276773,
+     "title": "The Retail Panel at RENTV's Inland Empire State of The Market Conference",
+     "url": "https://vimeo.com/830276773"
+    }
+   ]
+  },
+  {
+   "name": "Pacific Southwest Realty Services",
+   "aliases": [],
+   "category": "broker",
+   "websites": [],
+   "phones": [],
+   "emails": [],
+   "contacts": [],
+   "pitch": "Pacific Southwest Realty Services specializes in correspondent relationships with life insurance companies, brokering mortgage services to credit unions and banks.",
+   "appearances": 1,
+   "episodes": [
+    {
+     "id": 862593366,
+     "title": "The Finance Panel at RENTV's Greater LA State of the Market Conference",
+     "url": "https://vimeo.com/862593366"
+    }
+   ]
+  },
+  {
+   "name": "Paragon Commercial Group",
+   "aliases": [],
+   "category": "developer",
+   "websites": [],
+   "phones": [],
+   "emails": [],
+   "contacts": [
+    "Todd Huber"
+   ],
+   "pitch": "Do value add retail, really in the grocery anchored space, and also some of your single tenant deals.",
+   "appearances": 1,
+   "episodes": [
+    {
+     "id": 830276773,
+     "title": "The Retail Panel at RENTV's Inland Empire State of The Market Conference",
+     "url": "https://vimeo.com/830276773"
+    }
+   ]
+  },
+  {
+   "name": "Provident Bank",
+   "aliases": [],
+   "category": "lender",
+   "websites": [],
+   "phones": [],
+   "emails": [],
+   "contacts": [],
+   "pitch": "Provident Bank is a portfolio lender focusing on multifamily properties, with loan sizes ranging from $350,000 to 6 million.",
+   "appearances": 1,
+   "episodes": [
+    {
+     "id": 862593366,
+     "title": "The Finance Panel at RENTV's Greater LA State of the Market Conference",
+     "url": "https://vimeo.com/862593366"
+    }
+   ]
+  },
+  {
+   "name": "rent TV",
+   "aliases": [],
+   "category": "media company",
+   "websites": [],
+   "phones": [],
+   "emails": [],
+   "contacts": [],
+   "pitch": "A 23-year-old media company that provides a platform for video producers to create and share videos related to commercial real estate, improving searchability and traffic.",
+   "appearances": 1,
+   "episodes": [
+    {
+     "id": 721184140,
+     "title": "CLIC Vlog w Steve Bloom.mov",
+     "url": "https://vimeo.com/721184140"
+    }
+   ]
+  },
+  {
+   "name": "Say What's Properties",
+   "aliases": [],
+   "category": "broker|developer",
+   "websites": [],
+   "phones": [],
+   "emails": [],
+   "contacts": [],
+   "pitch": "A commercial real estate brokerage company representing tenants, users, and buyers of office, industrial, and multi-family properties in Southern California.",
+   "appearances": 1,
+   "episodes": [
+    {
+     "id": 739081927,
+     "title": "RENTV ORANGE COUNTY MULTIFAMILY PANEL July 26, 2022",
+     "url": "https://vimeo.com/739081927"
+    }
+   ]
+  },
+  {
+   "name": "Torrey Pines Bank",
+   "aliases": [],
+   "category": "lender",
+   "websites": [],
+   "phones": [],
+   "emails": [],
+   "contacts": [],
+   "pitch": "A lender providing banking solutions for various needs.",
+   "appearances": 1,
+   "episodes": [
+    {
+     "id": 763447786,
+     "title": "RENTV FINANCE OCT 19 2022.mp4",
+     "url": "https://vimeo.com/763447786"
+    }
+   ]
+  },
+  {
+   "name": "Universe Holdings",
+   "aliases": [],
+   "category": "developer|lender",
+   "websites": [],
+   "phones": [],
+   "emails": [],
+   "contacts": [],
+   "pitch": "Real estate investment company based in Southern California with offices in New York and Miami, focusing on multifamily properties.",
+   "appearances": 1,
+   "episodes": [
+    {
+     "id": 865035925,
+     "title": "The Multifamily Panel at RENTV's Greater LA State of the Market Conference",
+     "url": "https://vimeo.com/865035925"
+    }
+   ]
+  },
+  {
+   "name": "Walker and Dunlop",
+   "aliases": [],
+   "category": "lender",
+   "websites": [],
+   "phones": [],
+   "emails": [],
+   "contacts": [],
+   "pitch": "A lender specializing in commercial real estate financing.",
+   "appearances": 1,
+   "episodes": [
+    {
+     "id": 763447786,
+     "title": "RENTV FINANCE OCT 19 2022.mp4",
+     "url": "https://vimeo.com/763447786"
     }
    ]
   }
diff --git a/data/extractions/721184140.json b/data/extractions/721184140.json
new file mode 100644
index 0000000..c4f3615
--- /dev/null
+++ b/data/extractions/721184140.json
@@ -0,0 +1,36 @@
+{
+ "id": 721184140,
+ "title": "CLIC Vlog w Steve Bloom.mov",
+ "url": "https://vimeo.com/721184140",
+ "duration": 210,
+ "advertisers": [
+  {
+   "name": "rent TV",
+   "category": "media company",
+   "website": "",
+   "phone": "",
+   "contact_person": "",
+   "pitch": "A 23-year-old media company that provides a platform for video producers to create and share videos related to commercial real estate, improving searchability and traffic."
+  }
+ ],
+ "guests": [
+  {
+   "name": "Steve Blum",
+   "title": "CEO and Founder of Rent TV the Review",
+   "company": "Rent TV the Review",
+   "location": "",
+   "topics": [
+    "Commercial real estate video platform",
+    "Rent TV's mission to connect content creators with busy professionals",
+    "Search functionality for commercial real estate videos"
+   ],
+   "quotes": [
+    "Everyone's creating these great videos including yourself lot.",
+    "People have video blogs that they're doing on their different topics, but they're not getting as much traffic as they deserve.",
+    "This is a much more user friendly geared for the real estate professional."
+   ]
+  }
+ ],
+ "regex_sites": [],
+ "regex_phones": []
+}
\ No newline at end of file
diff --git a/data/extractions/739081927.json b/data/extractions/739081927.json
new file mode 100644
index 0000000..b11fc3a
--- /dev/null
+++ b/data/extractions/739081927.json
@@ -0,0 +1,89 @@
+{
+ "id": 739081927,
+ "title": "RENTV ORANGE COUNTY MULTIFAMILY PANEL July 26, 2022",
+ "url": "https://vimeo.com/739081927",
+ "duration": 3876,
+ "advertisers": [
+  {
+   "name": "The Bascom Group",
+   "category": "developer",
+   "website": "",
+   "phone": "",
+   "contact_person": "",
+   "pitch": "A developer focusing on multi-family properties in Orange County and nationwide, with a history of value-add acquisitions and recent foray into development."
+  },
+  {
+   "name": "Advanced Real Estate The Firm",
+   "category": "property mgmt|developer",
+   "website": "",
+   "phone": "",
+   "contact_person": "",
+   "pitch": "A vertically integrated property management and development firm in Southern California, specializing in long-term hold strategies."
+  },
+  {
+   "name": "CBRE",
+   "category": "broker",
+   "website": "",
+   "phone": "",
+   "contact_person": "",
+   "pitch": "A real estate investment sales division covering Orange County and bordering markets, focusing on 10 to 100 unit transactions."
+  },
+  {
+   "name": "Say What's Properties",
+   "category": "broker|developer",
+   "website": "",
+   "phone": "",
+   "contact_person": "",
+   "pitch": "A commercial real estate brokerage company representing tenants, users, and buyers of office, industrial, and multi-family properties in Southern California."
+  }
+ ],
+ "guests": [
+  {
+   "name": "Jerry Fink",
+   "title": "Co-founder and Managing Partner",
+   "company": "The Bascom Group",
+   "location": "",
+   "topics": [
+    "Background of The Bascom Group",
+    "Value Add Strategy",
+    "Development Projects"
+   ],
+   "quotes": [
+    "We started back in 96 focusing on Orange County multi-family and since kind of grown Nationwide.",
+    "We got into development because the cap rates are so low in the You know that model is much more lucrative today than ever was in the past."
+   ]
+  },
+  {
+   "name": "Paul Julien",
+   "title": "President and Managing Partner",
+   "company": "Advanced Real Estate The Firm",
+   "location": "",
+   "topics": [
+    "Company Background",
+    "Long-term Holding Strategy",
+    "Investor Structure"
+   ],
+   "quotes": [
+    "We're in Orange County, LA and Inland Empire with about a little over 10,000 units here.",
+    "We've never sell We Buy and Hold and in all of our money is private. It's friends and family."
+   ]
+  },
+  {
+   "name": "Dan Blackwell",
+   "title": "Co-head of Multifamily Investment Sales Division",
+   "company": "CBRE",
+   "location": "",
+   "topics": [
+    "Current Market Listings",
+    "Market Trends",
+    "Future Outlook"
+   ],
+   "quotes": [
+    "We've got a team of 15 investors Brokers and we cover the entire Market.",
+    "Interest rates have become more volatile and Rising we've seen more willingness for people to assume existing loans."
+   ]
+  }
+ ],
+ "regex_sites": [],
+ "regex_phones": []
+}
\ No newline at end of file
diff --git a/data/extractions/763442741.json b/data/extractions/763442741.json
new file mode 100644
index 0000000..43364c8
--- /dev/null
+++ b/data/extractions/763442741.json
@@ -0,0 +1,68 @@
+{
+ "id": 763442741,
+ "title": "RENTV INDUSTRIAL OCT 19 2022.mp4",
+ "url": "https://vimeo.com/763442741",
+ "duration": 2666,
+ "advertisers": [],
+ "guests": [
+  {
+   "name": "Craig Peters",
+   "title": "Senior Managing Director",
+   "company": "CBRE",
+   "location": "",
+   "topics": [
+    "Industrial market trends",
+    "Los Angeles real estate",
+    "Supply chain logistics"
+   ],
+   "quotes": [
+    "'The industrial market in LA is booming due to strong demand and limited supply.'",
+    "'Logistics and distribution are key drivers of growth in the sector.'"
+   ]
+  },
+  {
+   "name": "Nick Pellico",
+   "title": "Senior Vice President, Capital Markets",
+   "company": "Crow Holdings",
+   "location": "",
+   "topics": [
+    "Real estate investment strategies",
+    "Commercial real estate market"
+   ],
+   "quotes": [
+    "'Investment in industrial properties is seeing significant interest from both domestic and international investors.'",
+    "'The current market conditions present unique opportunities for strategic acquisitions.'"
+   ]
+  },
+  {
+   "name": "Brett Turner",
+   "title": "Managing Director, Capital Markets",
+   "company": "BKM Capital Partners",
+   "location": "",
+   "topics": [
+    "Industrial real estate investments",
+    "Market outlook"
+   ],
+   "quotes": [
+    "'We are seeing a shift towards more sustainable and resilient industrial properties.'",
+    "'The market is expected to continue growing as e-commerce continues to expand.'"
+   ]
+  },
+  {
+   "name": "Maxwell Kaiser",
+   "title": "Senior Vice President, Capital Markets",
+   "company": "Rexford Industrial",
+   "location": "",
+   "topics": [
+    "Industrial real estate trends",
+    "Investment opportunities"
+   ],
+   "quotes": [
+    "'Rexford is focused on acquiring and developing industrial properties in key logistics hubs.'",
+    "'The demand for last-mile distribution centers is driving our investment strategy.'"
+   ]
+  }
+ ],
+ "regex_sites": [],
+ "regex_phones": []
+}
\ No newline at end of file
diff --git a/data/extractions/763447786.json b/data/extractions/763447786.json
new file mode 100644
index 0000000..4e89036
--- /dev/null
+++ b/data/extractions/763447786.json
@@ -0,0 +1,104 @@
+{
+ "id": 763447786,
+ "title": "RENTV FINANCE OCT 19 2022.mp4",
+ "url": "https://vimeo.com/763447786",
+ "duration": 2355,
+ "advertisers": [
+  {
+   "name": "Fidelity Mortgage Lenders",
+   "category": "lender",
+   "website": "",
+   "phone": "",
+   "contact_person": "",
+   "pitch": "A lender providing mortgage solutions."
+  },
+  {
+   "name": "Axos Bank",
+   "category": "lender",
+   "website": "",
+   "phone": "",
+   "contact_person": "",
+   "pitch": "A lender offering financial services."
+  },
+  {
+   "name": "Walker and Dunlop",
+   "category": "lender",
+   "website": "",
+   "phone": "",
+   "contact_person": "",
+   "pitch": "A lender specializing in commercial real estate financing."
+  },
+  {
+   "name": "Torrey Pines Bank",
+   "category": "lender",
+   "website": "",
+   "phone": "",
+   "contact_person": "",
+   "pitch": "A lender providing banking solutions for various needs."
+  }
+ ],
+ "guests": [
+  {
+   "name": "Peter Steigeletter",
+   "title": "Mortgage Advisor",
+   "company": "Fidelity Mortgage Lenders",
+   "location": "",
+   "topics": [
+    "mortgage trends",
+    "loan products",
+    "consumer financing"
+   ],
+   "quotes": [
+    "'We're seeing a shift in demand for fixed-rate mortgages.'",
+    "'Our focus is on providing flexible loan options to meet diverse needs.'"
+   ]
+  },
+  {
+   "name": "Fred Ornelis",
+   "title": "Mortgage Officer",
+   "company": "Axos Bank",
+   "location": "",
+   "topics": [
+    "commercial lending",
+    "banking services",
+    "loan origination"
+   ],
+   "quotes": [
+    "'Our bank is expanding its commercial lending portfolio.'",
+    "'We prioritize personalized service for our clients.'"
+   ]
+  },
+  {
+   "name": "Shawn Skelton",
+   "title": "Senior Vice President, Capital Markets",
+   "company": "Walker and Dunlop",
+   "location": "",
+   "topics": [
+    "real estate finance",
+    "investment strategies",
+    "market trends"
+   ],
+   "quotes": [
+    "'The current market presents opportunities for savvy investors.'",
+    "'We are seeing increased interest in multifamily properties.'"
+   ]
+  },
+  {
+   "name": "Jeff Forsyth",
+   "title": "President, Commercial Banking Division",
+   "company": "Torrey Pines Bank",
+   "location": "",
+   "topics": [
+    "banking innovations",
+    "commercial real estate lending",
+    "economic outlook"
+   ],
+   "quotes": [
+    "'Technology is transforming the way we do business.'",
+    "'We are optimistic about the future of commercial real estate in LA.'"
+   ]
+  }
+ ],
+ "regex_sites": [],
+ "regex_phones": []
+}
\ No newline at end of file
diff --git a/data/extractions/771348410.json b/data/extractions/771348410.json
new file mode 100644
index 0000000..63e8311
--- /dev/null
+++ b/data/extractions/771348410.json
@@ -0,0 +1,57 @@
+{
+ "id": 771348410,
+ "title": "RENTV CRE Talk Episode #1 - Bill Shopoff",
+ "url": "https://vimeo.com/771348410",
+ "duration": 3065,
+ "advertisers": [
+  {
+   "name": "Paramount Property Tax",
+   "category": "lender|broker|other",
+   "website": "",
+   "phone": "858-225-1200",
+   "contact_person": "Arnie",
+   "pitch": "Appealing property taxes to fight back against inflation and increase profit margins."
+  },
+  {
+   "name": "Redwood Mortgage",
+   "category": "lender|broker|other",
+   "website": "",
+   "phone": "",
+   "contact_person": "Steve Belleville",
+   "pitch": "Direct private money lender with over 44 years of experience in commercial real estate loan transactions."
+  },
+  {
+   "name": "Commercial Real Estate Inspectors",
+   "category": "broker|other",
+   "website": "",
+   "phone": "818-957-4654",
+   "contact_person": "Tiffany Simmington",
+   "pitch": "Skilled inspectors providing critical inspection information in easily understood terms and simple solutions."
+  }
+ ],
+ "guests": [
+  {
+   "name": "Bill Shopoff",
+   "title": "Founder and CEO",
+   "company": "Shopoff Realty Investments",
+   "location": "Irvine, California",
+   "topics": [
+    "Retail Market Trends",
+    "Opportunistic Value-Add Investments and Developments",
+    "Mixed-Use Projects in Westminster"
+   ],
+   "quotes": [
+    "Retail is becoming more experiential; people want to go and have an experience, not just buy goods.",
+    "We are completely reimaging that piece of land with very little existing product. That's there intending to stay.",
+    "You get better revenues for the hotel room than you do from a thousand square feet of retail."
+   ]
+  }
+ ],
+ "regex_sites": [
+  "sublease.com",
+  "tv.com"
+ ],
+ "regex_phones": [
+  "8189574654"
+ ]
+}
\ No newline at end of file
diff --git a/data/extractions/795355693.json b/data/extractions/795355693.json
new file mode 100644
index 0000000..f89db00
--- /dev/null
+++ b/data/extractions/795355693.json
@@ -0,0 +1,57 @@
+{
+ "id": 795355693,
+ "title": "RENTV CRE Talk Episode #2 - Sandy Sigal",
+ "url": "https://vimeo.com/795355693",
+ "duration": 2883,
+ "advertisers": [
+  {
+   "name": "Commercial Real Estate Inspectors",
+   "category": "other",
+   "website": "",
+   "phone": "8189574654",
+   "contact_person": "Tiffany Simmington",
+   "pitch": "Skilled inspectors provide critically needed inspection information and easily understood terms as well as inexpensive Simple Solutions, whenever possible."
+  },
+  {
+   "name": "Paramount Property Tax Appeal",
+   "category": "broker",
+   "website": "",
+   "phone": "8582251208",
+   "contact_person": "West Nichols",
+   "pitch": "Appeal property taxes even if you have great income and find out more by calling the folks at Paramount Property Tax Appeal."
+  },
+  {
+   "name": "Redwood Mortgage",
+   "category": "lender",
+   "website": "www.redwoodmortgage.com",
+   "phone": "1-800-6596593",
+   "contact_person": "",
+   "pitch": "A direct private money lender with over 44 years of experience lending on commercial, mixed-use, multifamily, and residential investment properties."
+  }
+ ],
+ "guests": [
+  {
+   "name": "Sandy Siegel",
+   "title": "President and CEO",
+   "company": "Newmark Merrill Companies",
+   "location": "",
+   "topics": [
+    "Overview of Newmark Merrill Companies",
+    "Challenges in the retail sector due to interest rates, labor costs, material costs, and post-COVID recovery",
+    "Impact of rising interest rates on commercial real estate development"
+   ],
+   "quotes": [
+    "We're about 92 properties, about two thousand tenants, you know a couple billion dollar in asset value.",
+    "It's top look it sucks because you got a lot of things going in a time where we're trying to level out. We're trying to figure out covid right?",
+    "You add on to that the increase in materials and material showers. It's just super super super difficult to plan things out."
+   ]
+  }
+ ],
+ "regex_sites": [
+  "mortgage.com"
+ ],
+ "regex_phones": [
+  "8006596593",
+  "8189574654"
+ ]
+}
\ No newline at end of file
diff --git a/data/extractions/811518445.json b/data/extractions/811518445.json
new file mode 100644
index 0000000..f69025b
--- /dev/null
+++ b/data/extractions/811518445.json
@@ -0,0 +1,71 @@
+{
+ "id": 811518445,
+ "title": "RENTV ORANGE COUNTY OFFICE PANEL MARCH 16, 2023",
+ "url": "https://vimeo.com/811518445",
+ "duration": 3296,
+ "advertisers": [],
+ "guests": [
+  {
+   "name": "Mike Scentley",
+   "title": "Senior Vice President, Office Properties",
+   "company": "Irvine Company",
+   "location": "",
+   "topics": [
+    "Office market trends in Orange County",
+    "Impact of remote work on office spaces",
+    "Future of mixed-use developments"
+   ],
+   "quotes": [
+    "The demand for flexible workspace solutions is increasing.",
+    "We are seeing a shift towards more collaborative and tech-enabled office environments."
+   ]
+  },
+  {
+   "name": "Keyboard Kellerman",
+   "title": "President, Kellerman Company",
+   "company": "Kellerman Company",
+   "location": "",
+   "topics": [
+    "Office market trends in Orange County",
+    "Sustainability initiatives in commercial real estate",
+    "Technology integration in office spaces"
+   ],
+   "quotes": [
+    "Sustainability is becoming a key factor for tenants when choosing office locations.",
+    "We are investing heavily in smart building technologies to enhance tenant experience."
+   ]
+  },
+  {
+   "name": "Steve Card",
+   "title": "Managing Director, Seville",
+   "company": "Seville",
+   "location": "",
+   "topics": [
+    "Office market trends in Orange County",
+    "Economic impact of tech companies on the office sector",
+    "Adapting to changing tenant needs"
+   ],
+   "quotes": [
+    "Tech companies are driving demand for modern office spaces.",
+    "Flexibility and amenity-rich environments are crucial for attracting tenants."
+   ]
+  },
+  {
+   "name": "Jason Purvis",
+   "title": "Senior Vice President, Granite Properties",
+   "company": "Granite Properties",
+   "location": "",
+   "topics": [
+    "Office market trends in Orange County",
+    "The role of co-working spaces in the office ecosystem",
+    "Innovations in office design and functionality"
+   ],
+   "quotes": [
+    "Co-working spaces are becoming an integral part of the office landscape.",
+    "We focus on creating dynamic, multi-functional spaces that cater to diverse tenant needs."
+   ]
+  }
+ ],
+ "regex_sites": [],
+ "regex_phones": []
+}
\ No newline at end of file
diff --git a/data/extractions/812981342.json b/data/extractions/812981342.json
new file mode 100644
index 0000000..b18a2e7
--- /dev/null
+++ b/data/extractions/812981342.json
@@ -0,0 +1,62 @@
+{
+ "id": 812981342,
+ "title": "RENTV CRE Talk Episode #3 - Michael Van Every",
+ "url": "https://vimeo.com/812981342",
+ "duration": 3029,
+ "advertisers": [
+  {
+   "name": "Paramount Property Tax Appeal",
+   "category": "other",
+   "website": "",
+   "phone": "858-2251200",
+   "contact_person": "West Nichols",
+   "pitch": "Helps fight back against property tax increases by appealing them."
+  },
+  {
+   "name": "Commercial Real Estate Inspectors",
+   "category": "broker",
+   "website": "",
+   "phone": "818-9574654",
+   "contact_person": "Paul Tiffany Simmington",
+   "pitch": "Provides critically needed inspection information and easily understood terms for real estate deals."
+  },
+  {
+   "name": "Redwood Mortgage",
+   "category": "lender",
+   "website": "www.redwoodmortgage.com",
+   "phone": "1-800-6596593",
+   "contact_person": "",
+   "pitch": "Direct private money lender with over 44 years of experience in commercial, mixed-use, multifamily, and residential investment properties."
+  }
+ ],
+ "guests": [
+  {
+   "name": "Michael Van Every",
+   "title": "President and Managing Partner",
+   "company": "Republic Urban Properties",
+   "location": "San Jose, California",
+   "topics": [
+    "Transit-oriented development",
+    "Apartment market",
+    "Office issues in Silicon Valley",
+    "Impact of the pandemic on real estate"
+   ],
+   "quotes": [
+    "It's not good. I told County Supervisors back and may have 2020 that was a huge mistake to toe remote work is the Panacea or the world and remote anything for that matter and I'm on record is saying that that was a bad decision back then for commercial for commercial real estate, and I think it's a bad decision today.",
+    "We've seen from 2019 to today. It's about a 30% increasing construction costs.",
+    "So we're looking in markets like tertiary Market secondary markets in the Bay area that are still no big employment areas and that are maybe traditionally like Fairfield California."
+   ]
+  }
+ ],
+ "regex_sites": [
+  "millbrae.com",
+  "redwoodmortgage.com",
+  "sublease.com",
+  "tv.com"
+ ],
+ "regex_phones": [
+  "8006596593",
+  "8189574654",
+  "8582251200"
+ ]
+}
\ No newline at end of file
diff --git a/data/extractions/812982818.json b/data/extractions/812982818.json
new file mode 100644
index 0000000..008f005
--- /dev/null
+++ b/data/extractions/812982818.json
@@ -0,0 +1,71 @@
+{
+ "id": 812982818,
+ "title": "RENTV ORANGE COUNTY RETAIL PANEL MARCH 16, 2023",
+ "url": "https://vimeo.com/812982818",
+ "duration": 2724,
+ "advertisers": [],
+ "guests": [
+  {
+   "name": "Glen Rudy",
+   "title": "Senior Managing Director",
+   "company": "Newmark",
+   "location": "",
+   "topics": [
+    "retail market trends",
+    "leasing strategies",
+    "tenant mix"
+   ],
+   "quotes": [
+    "'The retail landscape is evolving rapidly, with a focus on experiential shopping.'",
+    "'We're seeing more demand for unique and niche tenants.'"
+   ]
+  },
+  {
+   "name": "John Reed",
+   "title": "Managing Director",
+   "company": "CBRE National Retail Partners West",
+   "location": "",
+   "topics": [
+    "market dynamics",
+    "retail property values",
+    "consumer behavior"
+   ],
+   "quotes": [
+    "'Consumer preferences are shifting towards online and experiential retail.'",
+    "'We're observing a trend towards smaller, more specialized retail spaces.'"
+   ]
+  },
+  {
+   "name": "Dennis Vaccaro",
+   "title": "Managing Director",
+   "company": "Value Rock Investment Partners",
+   "location": "",
+   "topics": [
+    "investment opportunities",
+    "retail asset management",
+    "market outlook"
+   ],
+   "quotes": [
+    "'There are still attractive investment opportunities in certain retail sectors.'",
+    "'We're focusing on properties with strong foot traffic and high visibility.'"
+   ]
+  },
+  {
+   "name": "Todd Huber",
+   "title": "Principal",
+   "company": "Paragon Commercial Group",
+   "location": "",
+   "topics": [
+    "leasing challenges",
+    "tenant selection criteria",
+    "retail development"
+   ],
+   "quotes": [
+    "'Leasing is becoming more complex due to changing tenant needs.'",
+    "'We prioritize tenants that can drive foot traffic and enhance the overall retail experience.'"
+   ]
+  }
+ ],
+ "regex_sites": [],
+ "regex_phones": []
+}
\ No newline at end of file
diff --git a/data/extractions/830276773.json b/data/extractions/830276773.json
new file mode 100644
index 0000000..cf86436
--- /dev/null
+++ b/data/extractions/830276773.json
@@ -0,0 +1,120 @@
+{
+ "id": 830276773,
+ "title": "The Retail Panel at RENTV's Inland Empire State of The Market Conference",
+ "url": "https://vimeo.com/830276773",
+ "duration": 2490,
+ "advertisers": [
+  {
+   "name": "Paragon Commercial Group",
+   "category": "developer",
+   "website": "",
+   "phone": "",
+   "contact_person": "Todd Huber",
+   "pitch": "Do value add retail, really in the grocery anchored space, and also some of your single tenant deals."
+  },
+  {
+   "name": "City of Ontario",
+   "category": "government entity",
+   "website": "",
+   "phone": "",
+   "contact_person": "Jennifer McClain Harimoto",
+   "pitch": "Economic development director for the city, highlighting development opportunities and reinvesting sales tax revenue into capital improvement projects."
+  },
+  {
+   "name": "Newmark Merrill Companies",
+   "category": "developer|property manager",
+   "website": "",
+   "phone": "",
+   "contact_person": "Greg Gia Capozzi",
+   "pitch": "Community focused, community first developer and real estate owner for retail properties across Southern California."
+  },
+  {
+   "name": "CBRE's National Retail Partners West Team",
+   "category": "broker",
+   "website": "",
+   "phone": "",
+   "contact_person": "John Reed",
+   "pitch": "Specializing in retail investment properties throughout the Inland Empire, California since 2012."
+  }
+ ],
+ "guests": [
+  {
+   "name": "Jennifer McClain Harimoto",
+   "title": "Economic Development Director",
+   "company": "City of Ontario",
+   "location": "",
+   "topics": [
+    "Development in Ontario",
+    "Sales tax measure approval",
+    "Downtown Ontario revitalization"
+   ],
+   "quotes": [
+    "There's a lot to be excited about as far as development here and opportunity.",
+    "We have resources, we have great leadership. The city just had a 1 cent sales tax measure approved.",
+    "The game plan is simple. We just want to find a way to revitalize those downtown historic buildings, infuse new residential, and also try to get a workforce or daytime population."
+   ]
+  },
+  {
+   "name": "John Reed",
+   "title": "National Retail Partners West Team",
+   "company": "CBRE's",
+   "location": "",
+   "topics": [
+    "Retail investment properties in the Inland Empire",
+    "Recent deals and activity"
+   ],
+   "quotes": [
+    "The Inland Empire represents probably one of our most active regions, since 2012.",
+    "Sold over 150 deals in the IE for over 1.3 billion.",
+    "There's a way to skin that cat. It really, if you've got a property they want to be at, there's a way to do it."
+   ]
+  },
+  {
+   "name": "Todd Huber",
+   "title": "Director of Development",
+   "company": "Paragon Commercial Group",
+   "location": "El Segundo and Palo Alto",
+   "topics": [
+    "Value add retail",
+    "Grocery anchored space",
+    "Single tenant deals"
+   ],
+   "quotes": [
+    "Do value add retail, really in the grocery anchored space.",
+    "We also do some of your single tenant deals that we'll go through.",
+    "There's a lot to be excited about as far as development here and opportunity."
+   ]
+  },
+  {
+   "name": "Greg Gia Capozzi",
+   "title": "Community Focused Developer, Real Estate Owner, Property Manager",
+   "company": "Newmark Merrill Companies",
+   "location": "",
+   "topics": [
+    "Retail properties in Southern California",
+    "Development and ownership"
+   ],
+   "quotes": [
+    "We are a community focused, um, and community first developer.",
+    "Thanks for having me, Mr. Reed.",
+    "There's a way to skin that cat. It really, if you've got a property they want to be at, there's a way to do it."
+   ]
+  },
+  {
+   "name": "Brad Umansky",
+   "title": "Real Estate Partner",
+   "company": "Progressive Real Estate Partners",
+   "location": "",
+   "topics": [
+    "Retail and lease transactions",
+    "Leasing strategies"
+   ],
+   "quotes": [
+    "We do more retail and lease transactions than any, any other firm from within 30 miles of Where you're sitting.",
+    "There's a way to skin that cat. It really, if you've got a property they want to be at, there's a way to do it."
+   ]
+  }
+ ],
+ "regex_sites": [],
+ "regex_phones": []
+}
\ No newline at end of file
diff --git a/data/extractions/830279080.json b/data/extractions/830279080.json
new file mode 100644
index 0000000..d1f7c03
--- /dev/null
+++ b/data/extractions/830279080.json
@@ -0,0 +1,73 @@
+{
+ "id": 830279080,
+ "title": "The Office Panel at RENTV's Inland Empire State of The Market Conference",
+ "url": "https://vimeo.com/830279080",
+ "duration": 2526,
+ "advertisers": [
+  {
+   "name": "MG R Real Estate",
+   "category": "broker",
+   "website": "",
+   "phone": "",
+   "contact_person": "",
+   "pitch": "primarily office brokers, owning about 1.8 million feet of office space in the L and Empire area"
+  },
+  {
+   "name": "Jones Lang LaSalle (JLL)",
+   "category": "lender|developer|broker",
+   "website": "",
+   "phone": "",
+   "contact_person": "Mark McAdams",
+   "pitch": "one of the larger national brokerage companies, pioneer of the Inland Empire market"
+  }
+ ],
+ "guests": [
+  {
+   "name": "Clayton McFadden",
+   "title": "Asset Manager",
+   "company": "Harbor Associates",
+   "location": "",
+   "topics": [
+    "Office market trends in Inland Empire",
+    "Supply and demand dynamics",
+    "Vacancy rates and net absorption"
+   ],
+   "quotes": [
+    "We've purchased and sold about a hundred million dollars real estate out here.",
+    "The highest vacancy is currently in Corona. That's because of some new construction down at Lake Shore Tower as well as a couple move-outs."
+   ]
+  },
+  {
+   "name": "Mike Radamaker",
+   "title": "Office Broker and Property Manager",
+   "company": "MG R Real Estate",
+   "location": "Ontario, Inland Empire",
+   "topics": [
+    "Office market trends in Ontario",
+    "Rental rates and occupancy",
+    "Active buying of office buildings"
+   ],
+   "quotes": [
+    "We're running 92.7% occupancy.",
+    "We are actively buying office buildings today."
+   ]
+  },
+  {
+   "name": "Mark McAdams",
+   "title": "Vice President, Jones Lang LaSalle",
+   "company": "Jones Lang LaSalle",
+   "location": "",
+   "topics": [
+    "Historical perspective on the Inland Empire office market",
+    "Tenant activity and demand",
+    "Impact of the pandemic"
+   ],
+   "quotes": [
+    "I've seen the market go from land play to industrial and then in the early eighties, office started to come in.",
+    "The long-term trend was people moving from the coasts to the Inland Empire to buy houses."
+   ]
+  }
+ ],
+ "regex_sites": [],
+ "regex_phones": []
+}
\ No newline at end of file
diff --git a/data/extractions/831673533.json b/data/extractions/831673533.json
new file mode 100644
index 0000000..afed014
--- /dev/null
+++ b/data/extractions/831673533.json
@@ -0,0 +1,57 @@
+{
+ "id": 831673533,
+ "title": "RENTV CRE Talk Episode #4 John McNellis",
+ "url": "https://vimeo.com/831673533",
+ "duration": 3175,
+ "advertisers": [
+  {
+   "name": "Commercial Real Estate Inspectors",
+   "category": "inspection service",
+   "website": "",
+   "phone": "(818) 957-4654",
+   "contact_person": "Tiffany Simington",
+   "pitch": "Provide critically needed inspection information in easily understood terms, as well as inexpensive, simple solutions."
+  },
+  {
+   "name": "Paramount Property Tax Appeal",
+   "category": "property tax appeal service",
+   "website": "",
+   "phone": "858-2251200",
+   "contact_person": "West Nichols",
+   "pitch": "Help you lower your property taxes even if you have great income."
+  },
+  {
+   "name": "Redwood Mortgage",
+   "category": "lender",
+   "website": "redwoodmortgage.com",
+   "phone": "1806596593",
+   "contact_person": "",
+   "pitch": "Direct private money lender with over 44 years of experience lending on commercial mixed use, multi-family and residential investment properties."
+  }
+ ],
+ "guests": [
+  {
+   "name": "John McNellis",
+   "title": "Founder and Partner",
+   "company": "MCNs Partners",
+   "location": "",
+   "topics": [
+    "Overview of MCNs Partners' portfolio",
+    "Current market conditions in retail and office markets",
+    "Strategies for dealing with challenging market conditions"
+   ],
+   "quotes": [
+    "Our primary portfolio, historically has been neighborhood supermarkets all in Northern California.",
+    "The velocity of deals is way off, uh, in my world, you know, retail and offices.",
+    "In our portfolio, our neighborhood supermarket anchored centers are doing great. You know, we're, we're nearly, we're within basis points of being full."
+   ]
+  }
+ ],
+ "regex_sites": [
+  "mortgage.com",
+  "tv.com"
+ ],
+ "regex_phones": [
+  "8189574654"
+ ]
+}
\ No newline at end of file
diff --git a/data/extractions/852462696.json b/data/extractions/852462696.json
new file mode 100644
index 0000000..aeaa77b
--- /dev/null
+++ b/data/extractions/852462696.json
@@ -0,0 +1,57 @@
+{
+ "id": 852462696,
+ "title": "RENTV CRE Talk Episode #5 Barry DiRaimondo",
+ "url": "https://vimeo.com/852462696",
+ "duration": 3910,
+ "advertisers": [
+  {
+   "name": "Paramount Property Tax Appeal",
+   "category": "lender|other",
+   "website": "",
+   "phone": "8582251200",
+   "contact_person": "West Nichols",
+   "pitch": "A service to help fight back against property tax increases by appealing them, even if you have great income. Deadline is November 30th."
+  },
+  {
+   "name": "Redwood Mortgage",
+   "category": "lender",
+   "website": "www.redwoodmortgage.com",
+   "phone": "1806596593",
+   "contact_person": "",
+   "pitch": "A direct private money lender with over 44 years of experience in commercial and residential investment properties, ranging from $200,000 to $10 million."
+  },
+  {
+   "name": "Commercial Real Estate Inspectors in Southern California",
+   "category": "property mgmt|other",
+   "website": "",
+   "phone": "8189574654",
+   "contact_person": "Tiffany Simington",
+   "pitch": "Skilled inspectors providing critical information and inexpensive solutions for real estate deals."
+  }
+ ],
+ "guests": [
+  {
+   "name": "Barry DiRaimondo",
+   "title": "Co-founder and CEO",
+   "company": "Steel Wave",
+   "location": "West coast based",
+   "topics": [
+    "Life science office development",
+    "Creative office space",
+    "Industrial real estate",
+    "Tech-oriented markets (Seattle, Portland, San Francisco)"
+   ],
+   "quotes": [
+    "We buy transition and develop life science office, but not traditional office, what I would call creative office, kind of differentiated stuff.",
+    "You know, the platform really is Seattle, Portland, San Francisco, and the Bay Area.",
+    "We do it through brokers, certainly on the leasing side. Even on the buy side, we'll insert one into the process."
+   ]
+  }
+ ],
+ "regex_sites": [
+  "redwoodmortgage.com",
+  "tv.com",
+  "whole.com"
+ ],
+ "regex_phones": []
+}
\ No newline at end of file
diff --git a/data/guests.json b/data/guests.json
index d3e1538..86341d5 100644
--- a/data/guests.json
+++ b/data/guests.json
@@ -1,6 +1,6 @@
 {
- "generated_at": "2026-08-07 08:46:08",
- "count": 1,
+ "generated_at": "2026-08-07 08:55:23",
+ "count": 42,
  "guests": [
   {
    "name": "Bill Shopoff",
@@ -21,7 +21,861 @@
    "episode_id": 1200839794,
    "episode_title": "CRE Talk Episode #22 with Bill Shopoff",
    "url": "https://vimeo.com/1200839794",
-   "is_panel": false
+   "is_panel": false,
+   "verified": true
+  },
+  {
+   "name": "Daniel Weiss",
+   "title": "President",
+   "company": "Strauss Investments",
+   "location": "San Diego County",
+   "topics": [
+    "Office property investments",
+    "Complex real estate transactions",
+    "Maximizing sale proceeds"
+   ],
+   "quotes": [
+    "We've been actively buying office properties lately.",
+    "Explaining that there's this easement in perpetuity on the roof that you don't really own was a challenge.",
+    "By employing that strategy, we were able to maximize our sale proceeds."
+   ],
+   "episode_id": 1199114985,
+   "episode_title": "CRE Talk Episode #21 with Daniel Weiss",
+   "url": "https://vimeo.com/1199114985",
+   "is_panel": false,
+   "verified": true
+  },
+  {
+   "name": "Colton Sudberry",
+   "title": "President & CEO of Sudberry Development Company",
+   "company": "Sudberry Development Company",
+   "location": "San Diego County, California",
+   "topics": [
+    "Community development in San Diego County",
+    "Mixed-use projects and future developments",
+    "Office building strategies"
+   ],
+   "quotes": [
+    "The Sudberry name has meant more to its community and region than any other.",
+    "We're currently focusing on mixed-use projects that include retail, residential, and office spaces.",
+    "With the changing conditions, we might not pursue significant office development in this phase."
+   ],
+   "episode_id": 1178561985,
+   "episode_title": "CRE Talk Episode #20 with Colton Sudberry",
+   "url": "https://vimeo.com/1178561985",
+   "is_panel": false,
+   "verified": true
+  },
+  {
+   "name": "Chris Tolo",
+   "title": "Managing Director",
+   "company": "LA Development",
+   "location": "Marina del Rey, Los Angeles",
+   "topics": [
+    "Overview of LA and other business involvement",
+    "Portfolio size and sectors",
+    "Institutional vs. high net worth investors",
+    "Exit strategies for deals"
+   ],
+   "quotes": [
+    "We're based in Marina del Rey, uh, Los Angeles.",
+    "And we're actually starting to think more about doing that, Uhhuh.",
+    "You could have a, a, let's say you have a institutional LP and, um, the fund managers in New York, right?"
+   ],
+   "episode_id": 1138312637,
+   "episode_title": "CRE Talk Episode #19 - Chris Tourtellotte",
+   "url": "https://vimeo.com/1138312637",
+   "is_panel": false,
+   "verified": true
+  },
+  {
+   "name": "Terrence Tallen",
+   "title": "Head of Talen Capital Group",
+   "company": "Talen Capital Group",
+   "location": "",
+   "topics": [
+    "Real Estate Investment Strategies",
+    "Exit Strategies for Institutional Deals",
+    "Leasing and Property Renovation"
+   ],
+   "quotes": [
+    "We bought it in the mid thirties, uh, and, uh, you know, in, uh, 2012.",
+    "And during the process, we, we asked our leasing broker who was, uh, Carol Ian, who's a very, very good broker, actually, outstanding leasing broker.",
+    "So it was a regular retail store. It was, uh, business to business store, and then their back, you know, re backroom regional offices."
+   ],
+   "episode_id": 1115700624,
+   "episode_title": "CRE Talk  Episode #18 Terry Tallen",
+   "url": "https://vimeo.com/1115700624",
+   "is_panel": false,
+   "verified": true
+  },
+  {
+   "name": "Christopher Rising",
+   "title": "Co-founder, CEO",
+   "company": "Rising Realty Partners",
+   "location": "",
+   "topics": [
+    "Company background and evolution",
+    "Deal sourcing strategies",
+    "IRR focus in deal evaluation",
+    "Cash flow prioritization"
+   ],
+   "quotes": [
+    "It's an evolving company. It, uh, didn't, we've been in business now for, uh, 12, going on 13 years.",
+    "Going to one of Those gray areas, I don't think you ever, I don't think, you know, and The seller doesn't know either. Probably.",
+    "This thing can't spit off. We're not in the, we're not, we're not building ground up. We're not taking that kind of risk."
+   ],
+   "episode_id": 1106281388,
+   "episode_title": "RENTV CRE Talk Episode #17 Chris Rising",
+   "url": "https://vimeo.com/1106281388",
+   "is_panel": false,
+   "verified": true
+  },
+  {
+   "name": "Alex Zikakis",
+   "title": "President",
+   "company": "Capstone Advisors",
+   "location": "Carlsbad, California",
+   "topics": [
+    "Overview of Capstone Advisors and its portfolio",
+    "Recent acquisitions in shopping centers, industrial buildings, and office properties",
+    "Investment strategy and market focus"
+   ],
+   "quotes": [
+    "The company is 28 years old. Um, it's based in Carlsbad, California.",
+    "Last year we bought four deals. Um, and, um, three were value add. Um, and one was classic core plus, uh, a highly, highly performing grocery anchored center in Salt Lake.",
+    "It was a property that was going vacant. It, uh, had a lot of great attributes and it was completely mispriced."
+   ],
+   "episode_id": 1079649123,
+   "episode_title": "RENTV CRE Talk Episode #16 - Alex Zikakis",
+   "url": "https://vimeo.com/1079649123",
+   "is_panel": false,
+   "verified": true
+  },
+  {
+   "name": "Mark Brutten",
+   "title": "CEO of Bruton Global",
+   "company": "Bruton Global, Brixton Capital, Westco Capital",
+   "location": "",
+   "topics": [
+    "Overview of Bruton Global and its portfolio companies (Brixton Capital, Westco Capital)",
+    "Launch of Broughton Private Access",
+    "Decision-making process for exiting investments",
+    "Tax efficiency strategies"
+   ],
+   "quotes": [
+    "I started in 1979 and, uh, started in San Diego.",
+    "Those folks, um, invest side by side with us, and we'll put up a, um, you know, a portion of the equity, and then they'll put up the balance of the equity, and we will do, um, end up doing a series series of transactions with those folks and hold the assets from five to 10 years, really depending on the business plan for the asset.",
+    "If it's, if it's, uh, I'll call it a light duty business plan with just some, uh, light renovation, possibly, uh, facade work, you know, that that asset may only be held for three or four years."
+   ],
+   "episode_id": 1059913595,
+   "episode_title": "RENTV CRE Talk Episode #15 - Marc Brutten",
+   "url": "https://vimeo.com/1059913595",
+   "is_panel": false,
+   "verified": true
+  },
+  {
+   "name": "John McNellis",
+   "title": "Head of Mcne Partners",
+   "company": "Mcne Partners",
+   "location": "Northern California",
+   "topics": [
+    "Management of shopping centers in Northern California",
+    "Rental trends and sales performance",
+    "Mixed-use property portfolio in Palo Alto",
+    "Adapting to market changes"
+   ],
+   "quotes": [
+    "We're keeping rents flat.",
+    "You gotta be ahead of the curve.",
+    "Until the urban retail needs a daytime population, so I took Lululemon out and replaced it with a tenant who hasn't got his final permit yet, cutting the rent by 30%."
+   ],
+   "episode_id": 1056513923,
+   "episode_title": "RENTV CRE Talk Episode #14 - John McNellis",
+   "url": "https://vimeo.com/1056513923",
+   "is_panel": false,
+   "verified": true
+  },
+  {
+   "name": "Ethan Penner",
+   "title": "CEO",
+   "company": "Mosaic real estate investors",
+   "location": "",
+   "topics": [
+    "Creation and evolution of the CMBS market",
+    "Investment strategies in a highly competitive industry",
+    "Impact of interest rate changes on real estate investment"
+   ],
+   "quotes": [
+    "Too many people in their careers are, are doing something that is akin to bringing sand to the beach. And the beach has plenty of sand and doesn't need any more sand.",
+    "The big story has been the extreme reduction in interest rates. If you go to like that 40 year period, a guy like Warren Buffett became wildly rich.",
+    "What he did was get long duration and hold on for 40 years."
+   ],
+   "episode_id": 1039101858,
+   "episode_title": "RENTV CRE Talk Episode #13 - Ethan Penner",
+   "url": "https://vimeo.com/1039101858",
+   "is_panel": false,
+   "verified": true
+  },
+  {
+   "name": "Kaitlin Arden Murphy",
+   "title": "President",
+   "company": "Murphy Development",
+   "location": "",
+   "topics": [
+    "History and development of Murphy Development in Otay Mesa, San Diego",
+    "Industrial property developments and sales strategies",
+    "Market trends and opportunities in commercial real estate"
+   ],
+   "quotes": [
+    "The company was started by my dad, Mike Murphy, as one of the pioneers in the Otai Mesa area.",
+    "We changed the lot lines. We maximized the residential, we sold that to Coal Rich, and then we also reserved those to, um, the site next door, 12 acres for two more industrial buildings.",
+    "The market was escalating like crazy, and it was really neat to be a part of."
+   ],
+   "episode_id": 1012976399,
+   "episode_title": "RENTV CRE Talk Episode #12 - Kaitlin Arduino",
+   "url": "https://vimeo.com/1012976399",
+   "is_panel": false,
+   "verified": true
+  },
+  {
+   "name": "Michael G Maker",
+   "title": "Founder and CEO",
+   "company": "MGR Real Estate Services",
+   "location": "Ontario, Inland Empire",
+   "topics": [
+    "Overview of MGR Real Estate and its growth",
+    "Property management services",
+    "Financing strategies for commercial real estate deals"
+   ],
+   "quotes": [
+    "We've been based in the Inland Empire now for, since 1983.",
+    "In today's market, it changes every time. Of course. Uh, it's really hard to get an office building market today in office.",
+    "Even though you're not personally guaranteeing it, they know in 10 seconds if you're a good operator 'cause they pull your name up and they look on the CMVS records."
+   ],
+   "episode_id": 953281926,
+   "episode_title": "RENTV CRE Talk Episode #11 - Michael Rademaker",
+   "url": "https://vimeo.com/953281926",
+   "is_panel": false,
+   "verified": true
+  },
+  {
+   "name": "Henry Manoucheri",
+   "title": "Chairman, CEO of Universe Holdings",
+   "company": "Universe Holdings",
+   "location": "",
+   "topics": [
+    "Overview of Universe Holdings and its business practices",
+    "Real estate investment strategies post-2009 market meltdown",
+    "Financing methods for real estate deals",
+    "Role of lenders in the transaction process"
+   ],
+   "quotes": [
+    "I started in real estate approximately 37 years ago.",
+    "The lesson we learned from the 2009 market meltdown was no leverage.",
+    "We've stayed away from that, and whatever I bought since 2009, 10 has been very leveraged anywhere from 35% LTV to no more than 60."
+   ],
+   "episode_id": 931863337,
+   "episode_title": "RENTV CRE Talk Episode #10 Henry Manoucheri",
+   "url": "https://vimeo.com/931863337",
+   "is_panel": false,
+   "verified": true
+  },
+  {
+   "name": "Eddie Ring",
+   "title": "Founder, CEO of New Standard Equities",
+   "company": "New Standard Equities",
+   "location": "",
+   "topics": [
+    "Investment in multifamily properties throughout the West Coast and Pacific Northwest",
+    "Impact of tenant-friendly laws on rental values",
+    "Rental rates and property occupancy in various markets such as Bremerton, Washington and San Jose"
+   ],
+   "quotes": [
+    "I started New Standard Equities in 2010, so we're coming up really, actually, I just hit my 14 year anniversary.",
+    "The upside is we don't have supply problems. Our rents are actually going up.",
+    "When you look at the rest of San Jose and you see Class A built, you know, rent is 4,500 and I'm at 29, so I'm still a price."
+   ],
+   "episode_id": 911412212,
+   "episode_title": "RENTV CRE Talk Episode #9 Eddie Ring",
+   "url": "https://vimeo.com/911412212",
+   "is_panel": false,
+   "verified": true
+  },
+  {
+   "name": "Irwin Busey",
+   "title": "Founder and Principal",
+   "company": "Paragon Commercial Group",
+   "location": "",
+   "topics": [
+    "Overview of Paragon Commercial Group",
+    "Portfolio size, number of properties, geographic area",
+    "Buy decision process based on return on cost",
+    "Exit strategy for deals"
+   ],
+   "quotes": [
+    "Paragon really means to strive for excellence and we wanted to pick a name that represents who we are and what we are in the marketplace.",
+    "I'm a big believer on return on cost. The reason being is IRR is all subject to time and exit cap rate.",
+    "What's happening with dirt? I mean, it's getting more valuable by the day."
+   ],
+   "episode_id": 906276616,
+   "episode_title": "RENTV CRE Talk Episode #8 Erwin Bucy",
+   "url": "https://vimeo.com/906276616",
+   "is_panel": false,
+   "verified": false
+  },
+  {
+   "name": "Chuck Hershson",
+   "title": "Founder",
+   "company": "Fidelity Mortgage Lenders",
+   "location": "",
+   "topics": [
+    "Overview of Fidelity Mortgage Lenders and its lending practices",
+    "Impact of high interest rates on the commercial real estate market",
+    "Strategies for dealing with the current market conditions"
+   ],
+   "quotes": [
+    "We love it at Fidelity. I knew you were gonna say that. This is a perfect, this is a perfect store platform.",
+    "High interest rates. Banks are not lending. Somebody's gotta fill the vacuum.",
+    "We're finding, excuse me, a lot of people over 700 FO scores that we're doing."
+   ],
+   "episode_id": 886025667,
+   "episode_title": "RENTV CRE Talk Episode #7 Chuck Hershson",
+   "url": "https://vimeo.com/886025667",
+   "is_panel": false,
+   "verified": true
+  },
+  {
+   "name": "Barry Seitz",
+   "title": "President",
+   "company": "Seitz Properties and the Seitz Company",
+   "location": "",
+   "topics": [
+    "Commercial properties in Southern California",
+    "Real estate market trends",
+    "Property valuation"
+   ],
+   "quotes": [
+    "You never know to the increase, you know?",
+    "I still do the same thing, right? I take the marketing package and then I try to dissect it because the listing brokers package makes a bunch of assumptions that in most cases are not, right.",
+    "Insurance on apartment buildings is up 40%"
+   ],
+   "episode_id": 868849453,
+   "episode_title": "RENTV CRE Talk Episode #6 Barry Saywitz",
+   "url": "https://vimeo.com/868849453",
+   "is_panel": false,
+   "verified": true
+  },
+  {
+   "name": "Paul Julian",
+   "title": "Founder",
+   "company": "Advanced Real Estate Services",
+   "location": "Irvine, Orange County, Southern California",
+   "topics": [
+    "Company history and growth",
+    "Investor base",
+    "Vertical integration"
+   ],
+   "quotes": [
+    "Our company was founded about 43 years ago by my father, and we've been buying apartments here in Southern California ever since.",
+    "We stay real close to home, so we stay within our target is an hour and a half of our headquarters, which is in Orange County in Irvine.",
+    "We have our own in-house property management, and we also have our own in-house construction company that's pretty robust."
+   ],
+   "episode_id": 865035925,
+   "episode_title": "The Multifamily Panel at RENTV's Greater LA State of the Market Conference",
+   "url": "https://vimeo.com/865035925",
+   "is_panel": true,
+   "verified": false
+  },
+  {
+   "name": "Henry Manchu",
+   "title": "Founder",
+   "company": "Universe Holdings",
+   "location": "Southern California (San Diego to Santa Barbara)",
+   "topics": [
+    "Company history and growth",
+    "Market expansion",
+    "Investment strategy"
+   ],
+   "quotes": [
+    "We have currently about 3000 units in, so out anywhere from San Diego to Santa Barbara.",
+    "In the past two years that changed. We have now opened an office, uh, in New York with one of my sons, and we acquired, uh, our first property in New Jersey, which is at 50 acres site at about 226 town homes.",
+    "We are shifting from smaller assets, older product to newer product, even brand new."
+   ],
+   "episode_id": 865035925,
+   "episode_title": "The Multifamily Panel at RENTV's Greater LA State of the Market Conference",
+   "url": "https://vimeo.com/865035925",
+   "is_panel": true,
+   "verified": false
+  },
+  {
+   "name": "Jerry Fink",
+   "title": "Co-founder and Managing Partner",
+   "company": "The Bascom Group",
+   "location": "",
+   "topics": [
+    "Investment strategy",
+    "Market trends",
+    "Legislative risk"
+   ],
+   "quotes": [
+    "We started back in 96 and, uh, our program is buy, reposition and sell, typically partnering with, uh, uh, private acqui funds, opportunity funds, pension funds, and, uh, a whole period of typically three to five, uh, years.",
+    "We have some legacy assets in Hollywood. You know, a few hundred units passed, uh, in one area for the past 20 some odd years we never sold, but we're seeing a tremendous inflow of new supply concessions, et cetera, given with class A building, which is affecting even these, you know, old world charm buildings that a one of a kind turns out there's an effect on that the vacancies are sitting longer.",
+    "Yeah, I think Henry's right that Michael Weinstein's going back at for a third crack with his, uh, AIDS foundation money, but, um, it, uh, and he wants to put vacancy control on units is his dream."
+   ],
+   "episode_id": 865035925,
+   "episode_title": "The Multifamily Panel at RENTV's Greater LA State of the Market Conference",
+   "url": "https://vimeo.com/865035925",
+   "is_panel": true,
+   "verified": false
+  },
+  {
+   "name": "Fred Ellis",
+   "title": "With Axo Bank",
+   "company": "Axo Bank",
+   "location": "San Diego, California",
+   "topics": [
+    "Real estate financing",
+    "Bridge and perm loans",
+    "Commercial real estate"
+   ],
+   "quotes": [
+    "We pretty much cover everything in terms of real estate.",
+    "We offer bridge and perm loans. A minimum loan size is 500,000, and we lend all the way up to 500,000."
+   ],
+   "episode_id": 862593366,
+   "episode_title": "The Finance Panel at RENTV's Greater LA State of the Market Conference",
+   "url": "https://vimeo.com/862593366",
+   "is_panel": true,
+   "verified": false
+  },
+  {
+   "name": "Ryan Park",
+   "title": "With Ms. Rahi TE Bank",
+   "company": "Ms. Rahi TE Bank",
+   "location": "Downtown LA, US Bank Tower",
+   "topics": [
+    "Bridge value add lending",
+    "Construction lending for apartments",
+    "Recourse-driven deals"
+   ],
+   "quotes": [
+    "We are focused on Bridge and value-add lending.",
+    "We can discuss the specific deal size, but it typically ranges from five to 25 million."
+   ],
+   "episode_id": 862593366,
+   "episode_title": "The Finance Panel at RENTV's Greater LA State of the Market Conference",
+   "url": "https://vimeo.com/862593366",
+   "is_panel": true,
+   "verified": false
+  },
+  {
+   "name": "Trevor Blood",
+   "title": "With Pacific Southwest Realty Services",
+   "company": "Pacific Southwest Realty Services",
+   "location": "South Bay office",
+   "topics": [
+    "Correspondent relationships with life insurance companies",
+    "Mortgage banking firm"
+   ],
+   "quotes": [
+    "We specialize in correspondent relationships with life insurance companies.",
+    "We work on all product types."
+   ],
+   "episode_id": 862593366,
+   "episode_title": "The Finance Panel at RENTV's Greater LA State of the Market Conference",
+   "url": "https://vimeo.com/862593366",
+   "is_panel": true,
+   "verified": false
+  },
+  {
+   "name": "Gina Conan",
+   "title": "With Provident Bank",
+   "company": "Provident Bank",
+   "location": "California",
+   "topics": [
+    "Portfolio lender",
+    "Multifamily lending",
+    "Small retail lending"
+   ],
+   "quotes": [
+    "We love multifamily, primarily.",
+    "Our loan size is 350,000 to about five or six million."
+   ],
+   "episode_id": 862593366,
+   "episode_title": "The Finance Panel at RENTV's Greater LA State of the Market Conference",
+   "url": "https://vimeo.com/862593366",
+   "is_panel": true,
+   "verified": false
+  },
+  {
+   "name": "John McLean",
+   "title": "With Fidelity Mortgage Lenders",
+   "company": "Fidelity Mortgage Lenders",
+   "location": "",
+   "topics": [
+    "Private lender",
+    "Hard money lender",
+    "Non-recourse loans"
+   ],
+   "quotes": [
+    "We're a private lender, also known as a hard money lender.",
+    "Our ability to push some of them though and shorten their terms down from 10 years to five or three years has been a huge value add."
+   ],
+   "episode_id": 862593366,
+   "episode_title": "The Finance Panel at RENTV's Greater LA State of the Market Conference",
+   "url": "https://vimeo.com/862593366",
+   "is_panel": true,
+   "verified": false
+  },
+  {
+   "name": "Barry DiRaimondo",
+   "title": "Co-founder and CEO",
+   "company": "Steel Wave",
+   "location": "West coast based",
+   "topics": [
+    "Life science office development",
+    "Creative office space",
+    "Industrial real estate",
+    "Tech-oriented markets (Seattle, Portland, San Francisco)"
+   ],
+   "quotes": [
+    "We buy transition and develop life science office, but not traditional office, what I would call creative office, kind of differentiated stuff.",
+    "You know, the platform really is Seattle, Portland, San Francisco, and the Bay Area.",
+    "We do it through brokers, certainly on the leasing side. Even on the buy side, we'll insert one into the process."
+   ],
+   "episode_id": 852462696,
+   "episode_title": "RENTV CRE Talk Episode #5 Barry DiRaimondo",
+   "url": "https://vimeo.com/852462696",
+   "is_panel": false,
+   "verified": true
+  },
+  {
+   "name": "John McNellis",
+   "title": "Founder and Partner",
+   "company": "MCNs Partners",
+   "location": "",
+   "topics": [
+    "Overview of MCNs Partners' portfolio",
+    "Current market conditions in retail and office markets",
+    "Strategies for dealing with challenging market conditions"
+   ],
+   "quotes": [
+    "Our primary portfolio, historically has been neighborhood supermarkets all in Northern California.",
+    "The velocity of deals is way off, uh, in my world, you know, retail and offices.",
+    "In our portfolio, our neighborhood supermarket anchored centers are doing great. You know, we're, we're nearly, we're within basis points of being full."
+   ],
+   "episode_id": 831673533,
+   "episode_title": "RENTV CRE Talk Episode #4 John McNellis",
+   "url": "https://vimeo.com/831673533",
+   "is_panel": false,
+   "verified": true
+  },
+  {
+   "name": "Clayton McFadden",
+   "title": "Asset Manager",
+   "company": "Harbor Associates",
+   "location": "",
+   "topics": [
+    "Office market trends in Inland Empire",
+    "Supply and demand dynamics",
+    "Vacancy rates and net absorption"
+   ],
+   "quotes": [
+    "We've purchased and sold about a hundred million dollars real estate out here.",
+    "The highest vacancy is currently in Corona. That's because of some new construction down at Lake Shore Tower as well as a couple move-outs."
+   ],
+   "episode_id": 830279080,
+   "episode_title": "The Office Panel at RENTV's Inland Empire State of The Market Conference",
+   "url": "https://vimeo.com/830279080",
+   "is_panel": true,
+   "verified": false
+  },
+  {
+   "name": "Mike Radamaker",
+   "title": "Office Broker and Property Manager",
+   "company": "MG R Real Estate",
+   "location": "Ontario, Inland Empire",
+   "topics": [
+    "Office market trends in Ontario",
+    "Rental rates and occupancy",
+    "Active buying of office buildings"
+   ],
+   "quotes": [
+    "We're running 92.7% occupancy.",
+    "We are actively buying office buildings today."
+   ],
+   "episode_id": 830279080,
+   "episode_title": "The Office Panel at RENTV's Inland Empire State of The Market Conference",
+   "url": "https://vimeo.com/830279080",
+   "is_panel": true,
+   "verified": false
+  },
+  {
+   "name": "Mark McAdams",
+   "title": "Vice President, Jones Lang LaSalle",
+   "company": "Jones Lang LaSalle",
+   "location": "",
+   "topics": [
+    "Historical perspective on the Inland Empire office market",
+    "Tenant activity and demand",
+    "Impact of the pandemic"
+   ],
+   "quotes": [
+    "I've seen the market go from land play to industrial and then in the early eighties, office started to come in.",
+    "The long-term trend was people moving from the coasts to the Inland Empire to buy houses."
+   ],
+   "episode_id": 830279080,
+   "episode_title": "The Office Panel at RENTV's Inland Empire State of The Market Conference",
+   "url": "https://vimeo.com/830279080",
+   "is_panel": true,
+   "verified": false
+  },
+  {
+   "name": "Jennifer McClain Harimoto",
+   "title": "Economic Development Director",
+   "company": "City of Ontario",
+   "location": "",
+   "topics": [
+    "Development in Ontario",
+    "Sales tax measure approval",
+    "Downtown Ontario revitalization"
+   ],
+   "quotes": [
+    "There's a lot to be excited about as far as development here and opportunity.",
+    "We have resources, we have great leadership. The city just had a 1 cent sales tax measure approved.",
+    "The game plan is simple. We just want to find a way to revitalize those downtown historic buildings, infuse new residential, and also try to get a workforce or daytime population."
+   ],
+   "episode_id": 830276773,
+   "episode_title": "The Retail Panel at RENTV's Inland Empire State of The Market Conference",
+   "url": "https://vimeo.com/830276773",
+   "is_panel": true,
+   "verified": false
+  },
+  {
+   "name": "John Reed",
+   "title": "National Retail Partners West Team",
+   "company": "CBRE's",
+   "location": "",
+   "topics": [
+    "Retail investment properties in the Inland Empire",
+    "Recent deals and activity"
+   ],
+   "quotes": [
+    "The Inland Empire represents probably one of our most active regions, since 2012.",
+    "Sold over 150 deals in the IE for over 1.3 billion.",
+    "There's a way to skin that cat. It really, if you've got a property they want to be at, there's a way to do it."
+   ],
+   "episode_id": 830276773,
+   "episode_title": "The Retail Panel at RENTV's Inland Empire State of The Market Conference",
+   "url": "https://vimeo.com/830276773",
+   "is_panel": true,
+   "verified": false
+  },
+  {
+   "name": "Todd Huber",
+   "title": "Director of Development",
+   "company": "Paragon Commercial Group",
+   "location": "El Segundo and Palo Alto",
+   "topics": [
+    "Value add retail",
+    "Grocery anchored space",
+    "Single tenant deals"
+   ],
+   "quotes": [
+    "Do value add retail, really in the grocery anchored space.",
+    "We also do some of your single tenant deals that we'll go through.",
+    "There's a lot to be excited about as far as development here and opportunity."
+   ],
+   "episode_id": 830276773,
+   "episode_title": "The Retail Panel at RENTV's Inland Empire State of The Market Conference",
+   "url": "https://vimeo.com/830276773",
+   "is_panel": true,
+   "verified": false
+  },
+  {
+   "name": "Greg Gia Capozzi",
+   "title": "Community Focused Developer, Real Estate Owner, Property Manager",
+   "company": "Newmark Merrill Companies",
+   "location": "",
+   "topics": [
+    "Retail properties in Southern California",
+    "Development and ownership"
+   ],
+   "quotes": [
+    "We are a community focused, um, and community first developer.",
+    "Thanks for having me, Mr. Reed.",
+    "There's a way to skin that cat. It really, if you've got a property they want to be at, there's a way to do it."
+   ],
+   "episode_id": 830276773,
+   "episode_title": "The Retail Panel at RENTV's Inland Empire State of The Market Conference",
+   "url": "https://vimeo.com/830276773",
+   "is_panel": true,
+   "verified": false
+  },
+  {
+   "name": "Brad Umansky",
+   "title": "Real Estate Partner",
+   "company": "Progressive Real Estate Partners",
+   "location": "",
+   "topics": [
+    "Retail and lease transactions",
+    "Leasing strategies"
+   ],
+   "quotes": [
+    "We do more retail and lease transactions than any, any other firm from within 30 miles of Where you're sitting.",
+    "There's a way to skin that cat. It really, if you've got a property they want to be at, there's a way to do it."
+   ],
+   "episode_id": 830276773,
+   "episode_title": "The Retail Panel at RENTV's Inland Empire State of The Market Conference",
+   "url": "https://vimeo.com/830276773",
+   "is_panel": true,
+   "verified": false
+  },
+  {
+   "name": "Michael Van Every",
+   "title": "President and Managing Partner",
+   "company": "Republic Urban Properties",
+   "location": "San Jose, California",
+   "topics": [
+    "Transit-oriented development",
+    "Apartment market",
+    "Office issues in Silicon Valley",
+    "Impact of the pandemic on real estate"
+   ],
+   "quotes": [
+    "It's not good. I told County Supervisors back and may have 2020 that was a huge mistake to toe remote work is the Panacea or the world and remote anything for that matter and I'm on record is saying that that was a bad decision back then for commercial for commercial real estate, and I think it's a bad decision today.",
+    "We've seen from 2019 to today. It's about a 30% increasing construction costs.",
+    "So we're looking in markets like tertiary Market secondary markets in the Bay area that are still no big employment areas and that are maybe traditionally like Fairfield California."
+   ],
+   "episode_id": 812981342,
+   "episode_title": "RENTV CRE Talk Episode #3 - Michael Van Every",
+   "url": "https://vimeo.com/812981342",
+   "is_panel": false,
+   "verified": true
+  },
+  {
+   "name": "Sandy Siegel",
+   "title": "President and CEO",
+   "company": "Newmark Merrill Companies",
+   "location": "",
+   "topics": [
+    "Overview of Newmark Merrill Companies",
+    "Challenges in the retail sector due to interest rates, labor costs, material costs, and post-COVID recovery",
+    "Impact of rising interest rates on commercial real estate development"
+   ],
+   "quotes": [
+    "We're about 92 properties, about two thousand tenants, you know a couple billion dollar in asset value.",
+    "It's top look it sucks because you got a lot of things going in a time where we're trying to level out. We're trying to figure out covid right?",
+    "You add on to that the increase in materials and material showers. It's just super super super difficult to plan things out."
+   ],
+   "episode_id": 795355693,
+   "episode_title": "RENTV CRE Talk Episode #2 - Sandy Sigal",
+   "url": "https://vimeo.com/795355693",
+   "is_panel": false,
+   "verified": true
+  },
+  {
+   "name": "Bill Shopoff",
+   "title": "Founder and CEO",
+   "company": "Shopoff Realty Investments",
+   "location": "Irvine, California",
+   "topics": [
+    "Retail Market Trends",
+    "Opportunistic Value-Add Investments and Developments",
+    "Mixed-Use Projects in Westminster"
+   ],
+   "quotes": [
+    "Retail is becoming more experiential; people want to go and have an experience, not just buy goods.",
+    "We are completely reimaging that piece of land with very little existing product. That's there intending to stay.",
+    "You get better revenues for the hotel room than you do from a thousand square feet of retail."
+   ],
+   "episode_id": 771348410,
+   "episode_title": "RENTV CRE Talk Episode #1 - Bill Shopoff",
+   "url": "https://vimeo.com/771348410",
+   "is_panel": false,
+   "verified": true
+  },
+  {
+   "name": "Jerry Fink",
+   "title": "Co-founder and Managing Partner",
+   "company": "The Bascom Group",
+   "location": "",
+   "topics": [
+    "Background of The Bascom Group",
+    "Value Add Strategy",
+    "Development Projects"
+   ],
+   "quotes": [
+    "We started back in 96 focusing on Orange County multi-family and since kind of grown Nationwide.",
+    "We got into development because the cap rates are so low in the You know that model is much more lucrative today than ever was in the past."
+   ],
+   "episode_id": 739081927,
+   "episode_title": "RENTV ORANGE COUNTY MULTIFAMILY PANEL July 26, 2022",
+   "url": "https://vimeo.com/739081927",
+   "is_panel": true,
+   "verified": false
+  },
+  {
+   "name": "Paul Julien",
+   "title": "President and Managing Partner",
+   "company": "Advanced Real Estate The Firm",
+   "location": "",
+   "topics": [
+    "Company Background",
+    "Long-term Holding Strategy",
+    "Investor Structure"
+   ],
+   "quotes": [
+    "We're in Orange County, LA and Inland Empire with about a little over 10,000 units here.",
+    "We've never sell We Buy and Hold and in all of our money is private. It's friends and family."
+   ],
+   "episode_id": 739081927,
+   "episode_title": "RENTV ORANGE COUNTY MULTIFAMILY PANEL July 26, 2022",
+   "url": "https://vimeo.com/739081927",
+   "is_panel": true,
+   "verified": false
+  },
+  {
+   "name": "Dan Blackwell",
+   "title": "Co-head of Multifamily Investment Sales Division",
+   "company": "CBRE",
+   "location": "",
+   "topics": [
+    "Current Market Listings",
+    "Market Trends",
+    "Future Outlook"
+   ],
+   "quotes": [
+    "We've got a team of 15 investors Brokers and we cover the entire Market.",
+    "Interest rates have become more volatile and Rising we've seen more willingness for people to assume existing loans."
+   ],
+   "episode_id": 739081927,
+   "episode_title": "RENTV ORANGE COUNTY MULTIFAMILY PANEL July 26, 2022",
+   "url": "https://vimeo.com/739081927",
+   "is_panel": true,
+   "verified": false
+  },
+  {
+   "name": "Steve Blum",
+   "title": "CEO and Founder of Rent TV the Review",
+   "company": "Rent TV the Review",
+   "location": "",
+   "topics": [
+    "Commercial real estate video platform",
+    "Rent TV's mission to connect content creators with busy professionals",
+    "Search functionality for commercial real estate videos"
+   ],
+   "quotes": [
+    "Everyone's creating these great videos including yourself lot.",
+    "People have video blogs that they're doing on their different topics, but they're not getting as much traffic as they deserve.",
+    "This is a much more user friendly geared for the real estate professional."
+   ],
+   "episode_id": 721184140,
+   "episode_title": "CLIC Vlog w Steve Bloom.mov",
+   "url": "https://vimeo.com/721184140",
+   "is_panel": false,
+   "verified": true
   }
  ]
 }
\ No newline at end of file
diff --git a/public/index.html b/public/index.html
index fd93d83..8a9b394 100644
--- a/public/index.html
+++ b/public/index.html
@@ -166,13 +166,14 @@ function renderCards(main,L){
       <div class="pitch">${esc(a.pitch||"")}</div>
       ${(a.websites||[]).map(w=>`<div class="kv">🌐 <a href="${siteURL(esc(w))}" target="_blank" rel="noopener">${esc(w)}</a></div>`).join("")}
       ${(a.phones||[]).map(p=>`<div class="kv">📞 <a href="${telURL(p)}">${esc(p)}</a></div>`).join("")}
+      ${(a.emails||[]).map(m=>`<div class="kv">✉️ <a href="mailto:${esc(m)}">${esc(m)}</a></div>`).join("")}
       ${(a.contacts||[]).length?`<div class="kv">👤 <b>${esc(a.contacts.join(", "))}</b></div>`:""}
       <div class="row">${epChips(a.episodes)}</div>`;
     g.appendChild(c);
   });
   else if(view==="guests") L.forEach(gu=>{
     const c=el("div","card");
-    c.innerHTML=`<h3 onclick='openGuest(${gu.episode_id},${JSON.stringify(gu.name)})'>${esc(gu.name)}</h3>
+    c.innerHTML=`<h3 onclick='openGuest(${gu.episode_id},${JSON.stringify(gu.name)})'>${esc(gu.name)} ${gu.verified?'<span class="badge" title="Name confirmed by the episode title" style="color:var(--teal)">✓ verified</span>':'<span class="badge" title="Auto-extracted from transcript; not title-confirmed" style="color:var(--dim)">unverified</span>'}</h3>
       <div class="kv"><b>${esc(gu.title||"")}</b>${gu.company?" — "+esc(gu.company):""}</div>
       ${gu.location?`<div class="kv">📍 ${esc(gu.location)}</div>`:""}
       <div class="row">${(gu.topics||[]).slice(0,6).map(t=>`<span class="chip">${esc(t)}</span>`).join("")}</div>
@@ -260,6 +261,7 @@ window.openAdv=name=>{
     <p>${esc(a.pitch||"")}</p>
     ${(a.websites||[]).map(w=>`<div>🌐 <a href="${siteURL(esc(w))}" target="_blank" rel="noopener">${esc(w)}</a></div>`).join("")}
     ${(a.phones||[]).map(p=>`<div>📞 <a href="${telURL(p)}">${esc(p)}</a></div>`).join("")}
+    ${(a.emails||[]).map(m=>`<div>✉️ <a href="mailto:${esc(m)}">${esc(m)}</a></div>`).join("")}
     ${(a.contacts||[]).length?`<div>👤 ${esc(a.contacts.join(", "))}</div>`:""}
     <h3 style="margin-top:16px">Ran on these episodes</h3>
     ${(a.episodes||[]).map(e=>`<div>▶ <a href="${esc(e.url)}" target="_blank" rel="noopener">${esc(e.title)}</a></div>`).join("")}`;
diff --git a/scripts/extract.py b/scripts/extract.py
index 9b23dc2..b746e3b 100644
--- a/scripts/extract.py
+++ b/scripts/extract.py
@@ -132,51 +132,103 @@ def extract_one(rec):
     return out
 
 
+_SUFFIX = re.compile(r"\b(inc|llc|lp|group|company|co|corp|bank|the|a|of)\b", re.I)
+def namekey(n):
+    n = (n or "").lower()
+    n = _SUFFIX.sub("", n)
+    return re.sub(r"[^a-z0-9]", "", n)
+
+def phone10(p):
+    d = re.sub(r"[^\d]", "", p or "")
+    return d[-10:] if len(d) >= 10 else ""
+
+def is_email(s):
+    return "@" in (s or "")
+
+
 def dedupe_advertisers(all_ex):
-    """Merge per-episode advertiser mentions into one registry keyed by normalized name."""
-    reg = {}
-    def key(a):
-        w = normalize_site(a.get("website", "")) if a.get("website") else ""
-        base = re.sub(r"[^a-z0-9]", "", (a.get("name") or "").lower())
-        return w or base
+    """Union-find merge: two mentions are the SAME advertiser if they share ANY of
+    {website domain, 10-digit phone, normalized name}. This pulls fragmented entries
+    (case/typo/format variants) back together transitively. Also attaches regex-backstop
+    domains to advertisers by name-token match, and splits emails out of the phone field."""
+    mentions = []
     for ex in all_ex:
+        sites = ex.get("regex_sites", [])
         for a in ex.get("advertisers", []):
             if not (a.get("name") or a.get("website")):
                 continue
-            k = key(a)
-            if not k:
-                continue
-            r = reg.setdefault(k, {"name": a.get("name", ""), "aliases": set(), "category": a.get("category", ""),
-                                   "websites": set(), "phones": set(), "contacts": set(),
-                                   "pitch": "", "episodes": []})
-            if a.get("name"):
-                r["aliases"].add(a["name"])
-                if len(a["name"]) < len(r["name"]) or not r["name"]:
-                    r["name"] = a["name"]
-            if a.get("website"):
-                r["websites"].add(normalize_site(a["website"]))
-            if a.get("phone"):
-                r["phones"].add(a["phone"].strip())
-            if a.get("contact_person"):
-                r["contacts"].add(a["contact_person"].strip())
-            if a.get("category") and not r["category"]:
-                r["category"] = a["category"]
-            if len(a.get("pitch", "")) > len(r["pitch"]):
-                r["pitch"] = a["pitch"]
-            r["episodes"].append({"id": ex["id"], "title": ex["title"], "url": ex["url"]})
-    # serialize
+            web = normalize_site(a["website"]) if a.get("website") else ""
+            # recover a domain the LLM missed: a regex_site whose root contains a name token
+            if not web and a.get("name"):
+                nk = namekey(a["name"])
+                for s in sites:
+                    root = s.split(".")[0].replace("-", "")
+                    if nk and (root in nk or nk in root) and len(root) >= 4:
+                        web = s; break
+            ph, email = "", ""
+            raw_ph = a.get("phone", "")
+            if is_email(raw_ph):
+                email = raw_ph.strip()
+            else:
+                ph = phone10(raw_ph)
+            cp = a.get("contact_person", "")
+            if is_email(cp):
+                email = email or cp.strip(); cp = ""
+            mentions.append({
+                "name": a.get("name", ""), "web": web, "ph": ph, "email": email,
+                "phone_disp": "" if is_email(raw_ph) else raw_ph.strip(),
+                "contact": cp, "category": a.get("category", ""), "pitch": a.get("pitch", ""),
+                "nk": namekey(a.get("name", "")),
+                "ep": {"id": ex["id"], "title": ex["title"], "url": ex["url"]},
+            })
+
+    # union-find
+    parent = list(range(len(mentions)))
+    def find(i):
+        while parent[i] != i:
+            parent[i] = parent[parent[i]]; i = parent[i]
+        return i
+    def union(i, j):
+        parent[find(i)] = find(j)
+    by_web, by_ph, by_nk = {}, {}, {}
+    for i, m in enumerate(mentions):
+        for idx, val in ((by_web, m["web"]), (by_ph, m["ph"]), (by_nk, m["nk"])):
+            if val:
+                if val in idx: union(i, idx[val])
+                else: idx[val] = i
+
+    groups = {}
+    for i, m in enumerate(mentions):
+        groups.setdefault(find(i), []).append(m)
+
     out = []
-    for r in reg.values():
+    for ms in groups.values():
+        names = [m["name"] for m in ms if m["name"]]
+        # canonical name = most common, tie-break shortest clean one
+        best = max(set(names), key=lambda n: (names.count(n), -len(n))) if names else ""
+        webs = sorted({m["web"] for m in ms if m["web"]})
+        phones = sorted({m["phone_disp"] for m in ms if m["phone_disp"]})
+        emails = sorted({m["email"] for m in ms if m["email"]})
+        contacts = sorted({m["contact"] for m in ms if m["contact"]})
+        cats = [m["category"] for m in ms if m["category"]]
+        cat = max(set(cats), key=cats.count) if cats else "other"
+        pitch = max((m["pitch"] for m in ms), key=len, default="")
+        # episodes deduped by id
+        eps, seen = [], set()
+        for m in ms:
+            if m["ep"]["id"] not in seen:
+                seen.add(m["ep"]["id"]); eps.append(m["ep"])
         out.append({
-            "name": r["name"],
-            "aliases": sorted(x for x in r["aliases"] if x != r["name"]),
-            "category": r["category"] or "other",
-            "websites": sorted(r["websites"]),
-            "phones": sorted(r["phones"]),
-            "contacts": sorted(r["contacts"]),
-            "pitch": r["pitch"],
-            "appearances": len(r["episodes"]),
-            "episodes": r["episodes"],
+            "name": best,
+            "aliases": sorted(x for x in set(names) if x != best),
+            "category": cat,
+            "websites": webs,
+            "phones": phones,
+            "emails": emails,
+            "contacts": contacts,
+            "pitch": pitch,
+            "appearances": len(eps),
+            "episodes": eps,
         })
     out.sort(key=lambda x: (-x["appearances"], x["name"].lower()))
     return out
@@ -203,14 +255,27 @@ def main():
         print(f"  [{i}/{len(vids)}] {rec['id']} adv={len(ex['advertisers'])} guests={len(ex['guests'])} sites={len(ex['regex_sites'])} ({time.time()-t0:.0f}s) {rec['title'][:40]}")
 
     advertisers = dedupe_advertisers(all_ex)
+
+    # guest hygiene: the local LLM hallucinates placeholder names ("John Doe") and fake
+    # companies on thin/multi-speaker transcripts, so we (1) drop placeholder names,
+    # (2) drop guests sourced from too-thin transcripts (the tiny clips can't yield a
+    # real guest), and (3) flag each guest `verified` when its name is corroborated by
+    # the episode title — the reliable set. Honest labeling > shipping fabricated data.
+    PLACEHOLDER = re.compile(r"\b(john|jane)\s+doe\b|^\s*(unknown|guest|panelist|speaker|moderator|host|n/?a|tbd)\s*$", re.I)
+    chars = {v["id"]: v.get("caption_chars", 0) for v in man["videos"]}
+    def toks(s): return set(re.sub(r"[^a-z ]", " ", (s or "").lower()).split()) - {"the", "of", "and", "with"}
     guests = []
     for ex in all_ex:
         is_panel = "panel" in ex["title"].lower()
+        if chars.get(ex["id"], 0) < 3000:      # clips/thin transcripts: unreliable, skip
+            continue
         for g in ex.get("guests", []):
-            if not g.get("name"):
+            nm = (g.get("name") or "").strip()
+            if not nm or PLACEHOLDER.search(nm) or len(nm.split()) < 2:
                 continue
-            guests.append({**g, "episode_id": ex["id"], "episode_title": ex["title"],
-                           "url": ex["url"], "is_panel": is_panel})
+            verified = bool(toks(nm) & toks(ex["title"]))
+            guests.append({**g, "name": nm, "episode_id": ex["id"], "episode_title": ex["title"],
+                           "url": ex["url"], "is_panel": is_panel, "verified": verified})
 
     stamp = time.strftime("%Y-%m-%d %H:%M:%S")
     json.dump({"generated_at": stamp, "count": len(advertisers), "advertisers": advertisers},

← 017da30 initial scaffold: RENTV ad engine — harvest + extract pipeli  ·  back to Rentv Ad Engine  ·  Phase 2 (poster tier): local qwen2.5vl OCR of video title fr a441274 →