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-13T08:49:35.028914+00:00","dedupe_key":"signal_enriched:market_headline_delta:ec0549e971c7e2fb","evidence_event_ids":["evt_5dcb7fcaf2c2"],"signal_type":"market_headline_delta","source":"market_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMi6wFBVV95cUxOWmpIcFdRak9GTUJ2RHJUam5iY3BKTTlyVjlMVE5iRDQ5eFNJOTVUYXh1TU9RS3lOY2dfbEdMcUpYMHR1ejJCM2dtbFdJaVlYY3h4cnh6dkI3bkVvRVJGaU5TZGdxUUZCZ1lsN2R0a2I0WHoxWmxFTzNUdzVEVHJFYklGbTlZS3BfZXpRaklPRkpmSG4tWWFjM3gtZXpBeEcwR2I4c3RrOTduRnNfZ3BUenlyQ1hrRFljdldwTDh0aklRRWdBT0JKQlRJZ0FjbVFOcWIzYTJ1WjBSQUdxRWRRTU0zRVlqN0hCZ0dv?oc=5","as_of":"2026-04-13T08:49:35.028914+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMi6wFBVV95cUxOWmpIcFdRak9GTUJ2RHJUam5iY3BKTTlyVjlMVE5iRDQ5eFNJOTVUYXh1TU9RS3lOY2dfbEdMcUpYMHR1ejJCM2dtbFdJaVlYY3h4cnh6dkI3bkVvRVJGaU5TZGdxUUZCZ1lsN2R0a2I0WHoxWmxFTzNUdzVEVHJFYklGbTlZS3BfZXpRaklPRkpmSG4tWWFjM3gtZXpBeEcwR2I4c3RrOTduRnNfZ3BUenlyQ1hrRFljdldwTDh0aklRRWdBT0JKQlRJZ0FjbVFOcWIzYTJ1WjBSQUdxRWRRTU0zRVlqN0hCZ0dv?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_28e9ee585b5e7538","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-13T08:56:01.783955+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi6wFBVV95cUxOWmpIcFdRak9GTUJ2RHJUam5iY3BKTTlyVjlMVE5iRDQ5eFNJOTVUYXh1TU9RS3lOY2dfbEdMcUpYMHR1ejJCM2dtbFdJaVlYY3h4cnh6dkI3bkVvRVJGaU5TZGdxUUZCZ1lsN2R0a2I0WHoxWmxFTzNUdzVEVHJFYklGbTlZS3BfZXpRaklPRkpmSG4tWWFjM3gtZXpBeEcwR2I4c3RrOTduRnNfZ3BUenlyQ1hrRFljdldwTDh0aklRRWdBT0JKQlRJZ0FjbVFOcWIzYTJ1WjBSQUdxRWRRTU0zRVlqN0hCZ0dv?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"theglobeandmail.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi6wFBVV95cUxOWmpIcFdRak9GTUJ2RHJUam5iY3BKTTlyVjlMVE5iRDQ5eFNJOTVUYXh1TU9RS3lOY2dfbEdMcUpYMHR1ejJCM2dtbFdJaVlYY3h4cnh6dkI3bkVvRVJGaU5TZGdxUUZCZ1lsN2R0a2I0WHoxWmxFTzNUdzVEVHJFYklGbTlZS3BfZXpRaklPRkpmSG4tWWFjM3gtZXpBeEcwR2I4c3RrOTduRnNfZ3BUenlyQ1hrRFljdldwTDh0aklRRWdBT0JKQlRJZ0FjbVFOcWIzYTJ1WjBSQUdxRWRRTU0zRVlqN0hCZ0dv?oc=5","source_event_id":"evt_5dcb7fcaf2c2","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"dae482a44f1dbb5c","published_at":"2026-04-13T04:44:00+00:00","publisher_domain":"theglobeandmail.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.4,"dates_mentioned":[],"entities":[],"event_type":"other","information_gaps":["Company names for the \u201c2 unpopular stocks\u201d and the \u201c1 that underwhelm\u201d are not provided.","Ticker symbols/standardized asset identifiers are not provided.","No performance metrics, catalysts, or time horizon are included in the provided text.","No article summary or body text is available to validate or contextualize the claims."],"key_facts":["Headline states: \u201c2 Unpopular Stocks That Should Get More Attention and 1 That Underwhelm - The Globe and Mail.\u201d","No company names or ticker symbols are included in the provided text."],"numeric_claims":[],"primary_claim":"The article headline claims there are two \u201cunpopular\u201d stocks that should get more attention and one stock that underwhelms.","relevance_score":0.25,"sentiment":"mixed","source_quality":"unknown","summary":"The Globe and Mail headline highlights three stocks: two described as \u201cunpopular\u201d that \u201cshould get more attention,\u201d and one described as \u201cunderwhelm.\u201d No tickers or company names are provided in the provided text.","topics":["stock selection","equities","market commentary"]},"source":"The Globe and Mail","source_domain":"theglobeandmail.com","source_url":"https://www.theglobeandmail.com","summary":"","tickers":[],"title":"2 Unpopular Stocks That Should Get More Attention and 1 That Underwhelm - The Globe and Mail","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp"}}

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