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-10T18:06:51.548375+00:00","dedupe_key":"signal_enriched:news_delta:7700cdda472c2143","evidence_event_ids":["evt_342c7134de73"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxPcWNuc09VWk9iSDU0MGNfRmY5U1dGOHdlWGxyZjktaG56UEtDSFpTWkU0NHdkbk5KcGhvazhSNHdoRG9vVkUtNnNTa0d2V0ctSXd1T0hvYkQyUUtSMVJzUm5QaUVScGhxRDhsenQ2T3lkMlFhdWhfX0tVQnhDMUg5NnN0ZUVxUWstTWItTGJlTjlCNnpNQzJjMA?oc=5","as_of":"2026-04-10T18:06:51.548375+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/CBMimAFBVV95cUxPcWNuc09VWk9iSDU0MGNfRmY5U1dGOHdlWGxyZjktaG56UEtDSFpTWkU0NHdkbk5KcGhvazhSNHdoRG9vVkUtNnNTa0d2V0ctSXd1T0hvYkQyUUtSMVJzUm5QaUVScGhxRDhsenQ2T3lkMlFhdWhfX0tVQnhDMUg5NnN0ZUVxUWstTWItTGJlTjlCNnpNQzJjMA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_24e8856ccba6816d","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-10T18:30:48.625649+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxPcWNuc09VWk9iSDU0MGNfRmY5U1dGOHdlWGxyZjktaG56UEtDSFpTWkU0NHdkbk5KcGhvazhSNHdoRG9vVkUtNnNTa0d2V0ctSXd1T0hvYkQyUUtSMVJzUm5QaUVScGhxRDhsenQ2T3lkMlFhdWhfX0tVQnhDMUg5NnN0ZUVxUWstTWItTGJlTjlCNnpNQzJjMA?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"finance.yahoo.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxPcWNuc09VWk9iSDU0MGNfRmY5U1dGOHdlWGxyZjktaG56UEtDSFpTWkU0NHdkbk5KcGhvazhSNHdoRG9vVkUtNnNTa0d2V0ctSXd1T0hvYkQyUUtSMVJzUm5QaUVScGhxRDhsenQ2T3lkMlFhdWhfX0tVQnhDMUg5NnN0ZUVxUWstTWItTGJlTjlCNnpNQzJjMA?oc=5","source_event_id":"evt_342c7134de73","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"6ca7eb798f27d540","published_at":"2026-04-10T17:50:44+00:00","publisher_domain":"finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Yahoo Finance","relevance":"source of the headline/article","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The three specific value stocks (company names and tickers) are not included in the provided text.","The nature of the \u201cwarning signs\u201d is not described.","No timing/catalyst information (e.g., earnings dates) is provided.","No market impact direction (up/down) is stated in the provided text."],"key_facts":["Headline states: \u201c3 Value Stocks with Warning Signs - Yahoo Finance.\u201d","Source summary repeats: \u201c3 Value Stocks with Warning Signs Yahoo Finance.\u201d","No stock tickers or company names are present in the provided text.","No details of the warning signs (e.g., financial metrics, catalysts, dates) are present in the provided text."],"numeric_claims":[],"primary_claim":"The Yahoo Finance article \u201c3 Value Stocks with Warning Signs\u201d identifies three value stocks as having warning signs.","relevance_score":0.35,"sentiment":"mixed","source_quality":"high","summary":"Yahoo Finance published an article titled \u201c3 Value Stocks with Warning Signs,\u201d indicating three value stocks are flagged for potential concerns. The provided text does not include the names of the stocks or the specific warning signs.","topics":["value stocks","warning signs","equities","stock screening"]},"source":"Yahoo Finance","source_domain":"finance.yahoo.com","source_url":"https://finance.yahoo.com","summary":"3 Value Stocks with Warning Signs Yahoo Finance","title":"3 Value Stocks with Warning Signs - Yahoo Finance","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 18885 in events