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-10T03:04:31.796915+00:00","dedupe_key":"signal_enriched:discovery_sector_rotation_delta:08cb9d744703797b","evidence_event_ids":["evt_38f6d771a82f"],"signal_type":"discovery_sector_rotation_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMijwFBVV95cUxPbld3bEJkcHUtYTlzRmV0R05lV080Z0NCMlRnUjJkVGRXOWlpR0RveVNkQ0hqY3dUSkNmTW1kajE4aHpTellLX0lVeGh3Z1A5SHk5TzFJekMxTUxqRUd2RjlQSFBRYXk1UmU2N0lkSV9lLTVzM3pWOWxzRzNNaWJwcjlKM3BwOC1LbFBxakV0TQ?oc=5","as_of":"2026-04-10T03:04:31.796915+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/CBMijwFBVV95cUxPbld3bEJkcHUtYTlzRmV0R05lV080Z0NCMlRnUjJkVGRXOWlpR0RveVNkQ0hqY3dUSkNmTW1kajE4aHpTellLX0lVeGh3Z1A5SHk5TzFJekMxTUxqRUd2RjlQSFBRYXk1UmU2N0lkSV9lLTVzM3pWOWxzRzNNaWJwcjlKM3BwOC1LbFBxakV0TQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_8be435f8c1bf20c1","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-10T03:40:52.436122+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMijwFBVV95cUxPbld3bEJkcHUtYTlzRmV0R05lV080Z0NCMlRnUjJkVGRXOWlpR0RveVNkQ0hqY3dUSkNmTW1kajE4aHpTellLX0lVeGh3Z1A5SHk5TzFJekMxTUxqRUd2RjlQSFBRYXk1UmU2N0lkSV9lLTVzM3pWOWxzRzNNaWJwcjlKM3BwOC1LbFBxakV0TQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"gstatic.com","publisher_resolution":"canonical_aggregator_unresolved","requested_url":"https://news.google.com/rss/articles/CBMijwFBVV95cUxPbld3bEJkcHUtYTlzRmV0R05lV080Z0NCMlRnUjJkVGRXOWlpR0RveVNkQ0hqY3dUSkNmTW1kajE4aHpTellLX0lVeGh3Z1A5SHk5TzFJekMxTUxqRUd2RjlQSFBRYXk1UmU2N0lkSV9lLTVzM3pWOWxzRzNNaWJwcjlKM3BwOC1LbFBxakV0TQ?oc=5","source_event_id":"evt_38f6d771a82f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"3dc838aeccde1e0b","kind":"sector_rotation","published_at":"2026-04-09T22:43:06+00:00","publisher_domain":"gstatic.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.45,"dates_mentioned":["Aug","2026"],"entities":[{"asset_class":"equity","name":"Castor Maritime Inc","relevance":"high","symbol":"","type":"company"}],"event_type":"other","information_gaps":["The cleaned article text contains mostly CSS/boilerplate and does not include the substantive content needed to extract which sectors are gaining/losing.","No macro driver is described in the provided text.","No evidence in the provided text indicates whether this is a regime shift versus short-term rebalancing.","No performance metrics, rankings, or sector names are included in the provided text."],"key_facts":["Headline states: \u201cAug Gainers: Will Castor Maritime Inc benefit from sector rotation - 2026 Stock Rankings & Safe Entry Point Identification.\u201d","No explicit list of gaining vs losing sectors is present in the provided cleaned article text.","No explicit macro driver (e.g., rates, inflation, commodities, growth) is stated in the provided cleaned article text."],"numeric_claims":[],"primary_claim":"The source headline suggests that Castor Maritime Inc may benefit from sector rotation in August.","relevance_score":0.35,"sentiment":"mixed","source_quality":"high","summary":"The signal claims that in August, certain stocks/sectors are outperforming due to \u201csector rotation,\u201d and specifically suggests Castor Maritime Inc could benefit. The provided article text is largely non-informative (CSS/boilerplate) and does not list actual gaining/losing sectors or a macro driver.","topics":["sector rotation","August stock rankings","Castor Maritime Inc"]},"source":"baoquankhu1.vn","source_domain":"gstatic.com","summary":"Aug Gainers: Will Castor Maritime Inc benefit from sector rotation - 2026 Stock Rankings & Safe Entry Point Identification baoquankhu1.vn","tickers":[],"title":"Aug Gainers: Will Castor Maritime Inc benefit from sector rotation - 2026 Stock Rankings & Safe Entry Point Identification - baoquankhu1.vn","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 13984 in events