← back to Commercialrealestate
deals-flow: map SEC EDGAR filing date to year so 2025/2026 REIT deals surface
143952a07165d3a99ad4000d0134155b9974fc69 · 2026-08-06 14:52:40 -0700 · Steve Abrams
The edgar merge set date=d.filed but omitted year, so all 88 current 2025/2026
REIT filings fell into the '—' unknown-year bucket instead of 2025/2026
Transaction-Year chips. One-line fix: derive year from d.filed.
Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
Files touched
Diff
commit 143952a07165d3a99ad4000d0134155b9974fc69
Author: Steve Abrams <steve@designerwallcoverings.com>
Date: Thu Aug 6 14:52:40 2026 -0700
deals-flow: map SEC EDGAR filing date to year so 2025/2026 REIT deals surface
The edgar merge set date=d.filed but omitted year, so all 88 current 2025/2026
REIT filings fell into the '—' unknown-year bucket instead of 2025/2026
Transaction-Year chips. One-line fix: derive year from d.filed.
Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
---
public/deals-flow.html | 5 ++++-
1 file changed, 4 insertions(+), 1 deletion(-)
diff --git a/public/deals-flow.html b/public/deals-flow.html
index 12d2237..9b73ece 100644
--- a/public/deals-flow.html
+++ b/public/deals-flow.html
@@ -313,7 +313,10 @@ Promise.all([
const c=(county.deals||[]).map(d=>({...d,kind:'county-sale',name:d.address||d.ain,source_label:'LA County Assessor'}));
const e=(edgar.deals||[]).map(d=>({...d,kind:'reit-filing',name:d.company,
use:d.property?('REIT: '+String(d.property).slice(0,44)):(d.price?'REIT acquisition':'REIT filing · price pending'),
- deal_city:d.deal_city||null,date:d.filed,url:d.filing_url,source_label:'SEC EDGAR'}));
+ // Map the SEC filing date to `year` too — without this the current 2025/2026 REIT deals had a
+ // date but no year, so they fell into the "—" (unknown-year) bucket instead of the 2025/2026
+ // Transaction-Year chips (they were in the grid, just invisible to the year filter).
+ deal_city:d.deal_city||null,date:d.filed,year:(parseInt(String(d.filed||'').slice(0,4))||null),url:d.filing_url,source_label:'SEC EDGAR'}));
// FHA-financed properties as a co-source (city/zip only — rides alongside, not a per-parcel join).
const f=(fha.rows||[]).filter(r=>r.state==='CA'&&r.rate!=null).map(d=>({
kind:'fha',name:d.property,use:'FHA-financed multifamily',price:d.originalAmount,units:d.units,
← 63a53ca afternoon CRE update 2026-08-06
·
back to Commercialrealestate
·
Add DSCR Qualifier to the initial page (index.html) + Frank' 750c9b8 →