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-05T00:49:03.050800+00:00","dedupe_key":"signal_enriched:opportunity_research_delta:e906d555d5299b64","evidence_event_ids":["evt_83a7d91d80e9"],"signal_type":"opportunity_research_delta","source":"opportunity_research_ingestor","value":{"aggregator_url":"https://www.facebook.com/BuildersMvt/posts/most-americans-agreemost-americans-actually-share-more-common-ground-than-we-oft/1899100724140147/","as_of":"2026-04-05T00:49:03.050800+00:00","canonical_url":"https://www.facebook.com/BuildersMvt/posts/most-americans-agreemost-americans-actually-share-more-common-ground-than-we-oft/1899100724140147/","enrichment":{"aggregator_url":"https://www.facebook.com/BuildersMvt/posts/most-americans-agreemost-americans-actually-share-more-common-ground-than-we-oft/1899100724140147/","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_c2760d17d9646524","canonical_host":"facebook.com","canonical_is_aggregator":false,"canonical_url":"https://www.facebook.com/BuildersMvt/posts/most-americans-agreemost-americans-actually-share-more-common-ground-than-we-oft/1899100724140147/","content_type":"text/html; charset=\"utf-8\"","enriched_at":"2026-04-05T11:00:14.471022+00:00","extraction_method":"heuristic","fetched_description":"Most Americans agree\u2026 Most Americans actually share more common ground than we often realize. Beneath the headlines, people across the country often agree on the issues that matter most. The real...","fetched_title":"Most Americans agree\u2026 Most Americans... - Builders Movement","final_url":"https://www.facebook.com/BuildersMvt/posts/most-americans-agreemost-americans-actually-share-more-common-ground-than-we-oft/1899100724140147/","html_truncated":true,"paywall_likely":false,"publisher_domain":"facebook.com","publisher_resolution":"canonical_url","requested_url":"https://www.facebook.com/BuildersMvt/posts/most-americans-agreemost-americans-actually-share-more-common-ground-than-we-oft/1899100724140147/","source_event_id":"evt_83a7d91d80e9","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"3dc5d3638fe51cb4","published_at":"","publisher_domain":"facebook.com","query":"clash between earnings conflicting reports resolution primary sources","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"social","name":"Americans","relevance":"high","symbol":"","type":"demographic"}],"event_type":"research","information_gaps":["Specific data on the percentage of Americans who agree on shared goals is not provided."],"key_facts":["Conflict distracts from shared goals.","Most Americans share common interests."],"numeric_claims":[],"primary_claim":"Most Americans agree on shared goals despite the presence of conflict in conversations.","relevance_score":0.8,"sentiment":"neutral","source_quality":"high","summary":"The article discusses how conflict in conversations distracts from shared goals among Americans, suggesting that most people agree on common interests despite polarization.","topics":["shared goals","polarization","conflict resolution"]},"snippet":"When conflict dominates the conversation, it distracts from shared goals, stalls progress, and gives power to those who profit from polarization. Recognizing ...","source":"web_search","source_domain":"facebook.com","summary":"When conflict dominates the conversation, it distracts from shared goals, stalls progress, and gives power to those who profit from polarization. Recognizing ...","title":"Most Americans agree\u2026 Most Americans actually share more ...","url":"https://www.facebook.com/BuildersMvt/posts/most-americans-agreemost-americans-actually-share-more-common-ground-than-we-oft/1899100724140147/"}}

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 20625 in events