SQLite Web: event_store.db

Update row 39679 in events

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-14T02:04:49.876253+00:00","dedupe_key":"signal_enriched:discovery_sec_filing_delta:97e0a14b2b6857cc","evidence_event_ids":["evt_26aca82c0684"],"signal_type":"discovery_sec_filing_delta","source":"discovery_sec_filings","value":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1080657/0001437749-26-012166.txt","as_of":"2026-04-14T02:04:49.876253+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/1080657/0001437749-26-012166.txt","company":"Presidio Property Trust, Inc.","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1080657/0001437749-26-012166.txt","article_chars":1940,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_37131774757d0efe","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/1080657/0001437749-26-012166.txt","content_type":"text/plain","enriched_at":"2026-04-14T02:29:11.383460+00:00","extraction_method":"trafilatura","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/1080657/0001437749-26-012166.txt","html_truncated":false,"paywall_likely":false,"publisher_domain":"sec.gov","publisher_resolution":"canonical_url","requested_url":"https://www.sec.gov/Archives/edgar/data/1080657/0001437749-26-012166.txt","source_event_id":"evt_26aca82c0684","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"form_type":"4","fp":"0bcdb1637c466f7b","kind":"sec_filing","published_at":"20260413","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["2026-04-10","2026-04-13","2026-04-14T02:04:49.876253+00:00","2010-09-03","1999-02-25"],"entities":[{"asset_class":"equity","name":"Presidio Property Trust, Inc.","relevance":"high","symbol":"SQFTW","type":"issuer"},{"asset_class":"person","name":"Jack Kendrick Heilbron","relevance":"high","symbol":"","type":"reporting-owner"},{"asset_class":"company","name":"Puppy Toes, Inc.","relevance":"medium","symbol":"","type":"indirect_holder"},{"asset_class":"company","name":"Centurion Counsel, Inc.","relevance":"low","symbol":"","type":"indirect_holder"}],"event_type":"listing","information_gaps":["The provided text does not explicitly state the transaction type (e.g., buy/sell) or whether shares increased/decreased versus a prior filing; it mainly provides identification and a holdings breakdown.","The signal headline mentions \u201cSQFTW filed 4,\u201d but the provided excerpt does not explicitly show the ticker symbol mapping; SQFTW is inferred only from the signal context, not directly from the excerpt.","No explicit prior-known state is included in the provided text, so \u201cwhat changed vs prior\u201d cannot be determined from this input alone."],"key_facts":["SEC accession number: 0001437749-26-012166.","Conformed submission type: Form 4.","Conformed period of report: 20260410; filed as of date: 20260413.","Reporting-owner: Jack Kendrick Heilbron; company: Presidio Property Trust, Inc.","The filing text includes a holdings breakdown stating: (i) 22,480 shares held by Puppy Toes, Inc. and its subsidiaries (including Centurion Counsel, Inc.) where Mr. Heilbron is the controlling shareholder; (ii) 1,000 shares held by Mr. Heilbron's spouse; (iii) 60 shares held by or for the benefit of Mr. Heilbron's grandchildren; (iv) 29,670 shares of unvested stock; and (v) 60,869 shares held directly by Mr. Heilbron.","The signature block shows: /s/Jack Heilbron dated 2026-04-13."],"numeric_claims":[{"label":"Directly held shares by Jack Kendrick Heilbron","value":"60,869"},{"label":"Shares held by Puppy Toes, Inc. and subsidiaries (including Centurion Counsel, Inc.)","value":"22,480"},{"label":"Shares held by spouse","value":"1,000"},{"label":"Shares held for grandchildren","value":"60"},{"label":"Unvested stock shares","value":"29,670"}],"primary_claim":"A Form 4 was filed on 2026-04-13 by Presidio Property Trust, Inc. reporting-owner Jack Kendrick Heilbron for the period ending 2026-04-10.","relevance_score":0.55,"sentiment":"neutral","source_quality":"medium","summary":"Presidio Property Trust, Inc. reported a Form 4 filed on 2026-04-13 covering reporting-owner Jack Kendrick Heilbron for the reporting period ending 2026-04-10. The filing indicates holdings of SQFTW-related shares and includes shares held directly and indirectly, plus unvested shares.","topics":["SEC Form 4","insider holdings","REIT","Presidio Property Trust, Inc."]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 4 \u00b7 Presidio Property Trust, Inc. \u00b7 Filed 20260413","ticker":"SQFTW","tickers":["SQFTW"],"title":"SQFTW filed 4","url":"https://www.sec.gov/Archives/edgar/data/1080657/0001437749-26-012166.txt"}}

TEXT NOT NULL

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

Cancel