SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

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

event_store.db — signals

Update row sig_c734bbbfdb59 in signals