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-05T19:49:03.060041+00:00","dedupe_key":"signal_enriched:opportunity_research_delta:2ca71d8ce0870e45","evidence_event_ids":["evt_8a3e10d4ea7a"],"signal_type":"opportunity_research_delta","source":"opportunity_research_ingestor","value":{"aggregator_url":"https://www.facebook.com/groups/513332088870472/posts/2977211049149218/","as_of":"2026-04-05T19:49:03.060041+00:00","canonical_url":"https://www.facebook.com/groups/513332088870472/posts/2977211049149218/","enrichment":{"aggregator_url":"https://www.facebook.com/groups/513332088870472/posts/2977211049149218/","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_a68c35876e218476","canonical_host":"facebook.com","canonical_is_aggregator":false,"canonical_url":"https://www.facebook.com/groups/513332088870472/posts/2977211049149218/","content_type":"text/html; charset=\"utf-8\"","enriched_at":"2026-04-05T23:09:24.714652+00:00","extraction_method":"heuristic","fetched_description":"Bengali Babus were primarily urban gentlefolks who received an English education, imbibing ideas of liberalism, nationalism. Yet they tenaciously adhered to own culture that they\u200b enriched with...","fetched_title":"Angel book collection | Bengali Babus were primarily urban gentlefolks who received an English education, imbibing ideas of liberalism, nationalism","final_url":"https://www.facebook.com/groups/513332088870472/posts/2977211049149218/","html_truncated":true,"paywall_likely":false,"publisher_domain":"facebook.com","publisher_resolution":"canonical_url","requested_url":"https://www.facebook.com/groups/513332088870472/posts/2977211049149218/","source_event_id":"evt_8a3e10d4ea7a","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9614797f6abc4847","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.9,"dates_mentioned":[],"entities":[{"asset_class":"cultural","name":"Bengali Babus","relevance":"central to the claim","symbol":"","type":"cultural group"}],"event_type":"research","information_gaps":["No specific dates or historical context provided for the emergence of Bengali Babus."],"key_facts":["Bengali Babus were urban gentlefolk.","They received an English education.","They were influenced by liberalism and nationalism."],"numeric_claims":[],"primary_claim":"Bengali Babus were primarily urban gentlefolk who received an English education.","relevance_score":0.8,"sentiment":"neutral","source_quality":"high","summary":"Bengali Babus were urban gentlefolk educated in English, influenced by liberalism and nationalism, while maintaining traditional values.","topics":["Bengali Babus","urban culture","education","nationalism","liberalism"]},"snippet":"Bengali Babus were primarily urban gentlefolks who received an English education, imbibing ideas of liberalism, nationalism. Yet they tenaciously adhered...","source":"web_search","source_domain":"facebook.com","summary":"Bengali Babus were primarily urban gentlefolks who received an English education, imbibing ideas of liberalism, nationalism. Yet they tenaciously adhered...","title":"Bengali Babus were primarily urban gentlefolks who received an ...","url":"https://www.facebook.com/groups/513332088870472/posts/2977211049149218/"}}

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