SQLite Web: event

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-05T17:49:01.991925+00:00","dedupe_key":"signal_enriched:opportunity_research_delta:3e7a1d2dcf5daa17","evidence_event_ids":["evt_ec9333044c4e"],"signal_type":"opportunity_research_delta","source":"opportunity_research_ingestor","value":{"aggregator_url":"https://www.facebook.com/Accuretti/photos/when-silence-itself-becomes-the-story-at-lopez-holdingsthere-are-moments-in-capi/1555992536531445/","as_of":"2026-04-05T17:49:01.991925+00:00","canonical_url":"https://www.facebook.com/login","enrichment":{"aggregator_url":"https://www.facebook.com/Accuretti/photos/when-silence-itself-becomes-the-story-at-lopez-holdingsthere-are-moments-in-capi/1555992536531445/","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_066b24ac2fa68fd3","canonical_host":"facebook.com","canonical_is_aggregator":false,"canonical_url":"https://www.facebook.com/login","content_type":"text/html; charset=\"utf-8\"","enriched_at":"2026-04-05T22:52:42.681077+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"Facebook","final_url":"https://www.facebook.com/login/?next=https%3A%2F%2Fwww.facebook.com%2FAccuretti%2Fphotos%2Fwhen-silence-itself-becomes-the-story-at-lopez-holdingsthere-are-moments-in-capi%2F1555992536531445%2F","html_truncated":true,"paywall_likely":false,"publisher_domain":"facebook.com","publisher_resolution":"canonical_url","requested_url":"https://www.facebook.com/Accuretti/photos/when-silence-itself-becomes-the-story-at-lopez-holdingsthere-are-moments-in-capi/1555992536531445/","source_event_id":"evt_ec9333044c4e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"bb5235897b6d1b90","published_at":"","publisher_domain":"facebook.com","query":"TMC stock gaining latest developments TMC stock gaining favor retail traders due corroboration","signal_understanding":{"analysis_basis":"article","claim_confidence":0.8,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Lopez Holdings","relevance":"central to the governance issue","symbol":"not provided","type":"company"},{"asset_class":"equity","name":"ABS-CBN","relevance":"related to the shares in question","symbol":"not provided","type":"company"}],"event_type":"research","information_gaps":["Specific details on the nature of the governance issue are unclear.","No timeline for resolution of the governance issue is provided."],"key_facts":["Lopez Holdings has obligations to deliver ABS-CBN shares.","These obligations are secured by a Pledge of Shares."],"numeric_claims":[],"primary_claim":"Lopez Holdings has unresolved governance issues related to the delivery of ABS-CBN shares secured by a Pledge of Shares.","relevance_score":0.7,"sentiment":"neutral","source_quality":"high","summary":"The governance issue surrounding Lopez Holdings remains ambiguous, particularly regarding the obligations related to the ABS-CBN shares and the Pledge of Shares.","topics":["governance","corporate obligations","ABS-CBN shares"]},"snippet":"The obligations of the Company to deliver the ABS-CBN shares on the exercise of the right contained in the PDRs are secured by the Pledge of Shares in favor of ...","source":"web_search","source_domain":"facebook.com","summary":"The obligations of the Company to deliver the ABS-CBN shares on the exercise of the right contained in the PDRs are secured by the Pledge of Shares in favor of ...","title":"Lopez Holdings governance issue remains unclear - Facebook","url":"https://www.facebook.com/login"}}

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')

event_store.db — events

Update row 25072 in events