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-12T20:36:08.655721+00:00","dedupe_key":"signal_enriched:news_delta:150d137e72960a38","evidence_event_ids":["evt_a3be9615f9dc"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMioAFBVV95cUxQRXVKeXJ0VVAwWXFNRWVTTkxxb28tTjNWVm9adDk2dnBhanhJNno3WnRYaGI4bEpIV2xCaFdheGxhZWFvZ245Tm9tUnJkWTlFc1ZqTDZSaWdjeFpEMFNJLTBjeVRNRU1XSG80ZnhLeDlZNDdQZjZuZlBjSHlabG5UU2plbmxCdGlYTHFMbTFPMGRNQ21ZaTNvdFBLN21nMmRm?oc=5","as_of":"2026-04-12T20:36:08.655721+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/CBMioAFBVV95cUxQRXVKeXJ0VVAwWXFNRWVTTkxxb28tTjNWVm9adDk2dnBhanhJNno3WnRYaGI4bEpIV2xCaFdheGxhZWFvZ245Tm9tUnJkWTlFc1ZqTDZSaWdjeFpEMFNJLTBjeVRNRU1XSG80ZnhLeDlZNDdQZjZuZlBjSHlabG5UU2plbmxCdGlYTHFMbTFPMGRNQ21ZaTNvdFBLN21nMmRm?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_49763aacacebb276","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-12T22:53:36.433396+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMioAFBVV95cUxQRXVKeXJ0VVAwWXFNRWVTTkxxb28tTjNWVm9adDk2dnBhanhJNno3WnRYaGI4bEpIV2xCaFdheGxhZWFvZ245Tm9tUnJkWTlFc1ZqTDZSaWdjeFpEMFNJLTBjeVRNRU1XSG80ZnhLeDlZNDdQZjZuZlBjSHlabG5UU2plbmxCdGlYTHFMbTFPMGRNQ21ZaTNvdFBLN21nMmRm?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/CBMioAFBVV95cUxQRXVKeXJ0VVAwWXFNRWVTTkxxb28tTjNWVm9adDk2dnBhanhJNno3WnRYaGI4bEpIV2xCaFdheGxhZWFvZ245Tm9tUnJkWTlFc1ZqTDZSaWdjeFpEMFNJLTBjeVRNRU1XSG80ZnhLeDlZNDdQZjZuZlBjSHlabG5UU2plbmxCdGlYTHFMbTFPMGRNQ21ZaTNvdFBLN21nMmRm?oc=5","source_event_id":"evt_a3be9615f9dc","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"a868eb8ea3d3ee04","published_at":"2026-04-12T20:02:02+00:00","publisher_domain":"finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.6,"dates_mentioned":["April 2026"],"entities":[{"asset_class":"media","name":"Yahoo Finance","relevance":"high","symbol":"","type":"publisher"}],"event_type":"listing","information_gaps":["List of the specific penny stocks mentioned in the article is not provided.","Any stated rationale, performance metrics, or near-term catalysts are not provided.","No standardized ticker symbols (ASX codes) are available from the provided text.","No information is provided about whether the article is new, updated, or tied to a particular corporate event."],"key_facts":["Headline: \u201cApril 2026's Promising Penny Stocks On The ASX - Yahoo Finance.\u201d","Source summary repeats the same title/subject.","No article body content is provided, so no specific ASX penny stocks or claims can be extracted."],"numeric_claims":[],"primary_claim":"A Yahoo Finance piece titled \u201cApril 2026's Promising Penny Stocks On The ASX\u201d exists (as indicated by the headline and source summary).","relevance_score":0.25,"sentiment":"neutral","source_quality":"unknown","summary":"The provided signal references a Yahoo Finance article titled \u201cApril 2026's Promising Penny Stocks On The ASX,\u201d but no article details are included. No specific penny stocks, prices, or catalysts are stated in the provided text.","topics":["ASX","penny stocks","April 2026","stock picks"]},"source":"Yahoo Finance","source_domain":"finance.yahoo.com","source_url":"https://finance.yahoo.com","summary":"April 2026's Promising Penny Stocks On The ASX Yahoo Finance","title":"April 2026's Promising Penny Stocks On The ASX - 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 31265 in events