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-07T23:23:54.391414+00:00","dedupe_key":"signal_enriched:discovery_sector_rotation_delta:f00827447eef31b7","evidence_event_ids":["evt_f2a5ead44961"],"signal_type":"discovery_sector_rotation_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiXkFVX3lxTFBWTjlRbUU2aVRqVllpSkFZVUg0UzhjMnVFMGxFdXRLbjJBRndfeE9feko3Q0E2MWhxSUlWWTY0RFBubnhlYkJNQ3BocG9NZC1SNzhLeTVVWjhzR3lvS2fSAWNBVV95cUxPLXNabTBMYUxTdlBTY0FvclpvU182S2lfYmRXdUt3Q0xaVS1YU3F3WlFBcnFrQTNYbmw5TTJpU01Ca0loRW1XaGNiZFE4TmhXVzkxeXZrWTRkMnVLN3lndUJYazA?oc=5","as_of":"2026-04-07T23:23:54.391414+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/CBMiXkFVX3lxTFBWTjlRbUU2aVRqVllpSkFZVUg0UzhjMnVFMGxFdXRLbjJBRndfeE9feko3Q0E2MWhxSUlWWTY0RFBubnhlYkJNQ3BocG9NZC1SNzhLeTVVWjhzR3lvS2fSAWNBVV95cUxPLXNabTBMYUxTdlBTY0FvclpvU182S2lfYmRXdUt3Q0xaVS1YU3F3WlFBcnFrQTNYbmw5TTJpU01Ca0loRW1XaGNiZFE4TmhXVzkxeXZrWTRkMnVLN3lndUJYazA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_2cb3ddea96bda641","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-08T00:50:07.614893+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiXkFVX3lxTFBWTjlRbUU2aVRqVllpSkFZVUg0UzhjMnVFMGxFdXRLbjJBRndfeE9feko3Q0E2MWhxSUlWWTY0RFBubnhlYkJNQ3BocG9NZC1SNzhLeTVVWjhzR3lvS2fSAWNBVV95cUxPLXNabTBMYUxTdlBTY0FvclpvU182S2lfYmRXdUt3Q0xaVS1YU3F3WlFBcnFrQTNYbmw5TTJpU01Ca0loRW1XaGNiZFE4TmhXVzkxeXZrWTRkMnVLN3lndUJYazA?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/CBMiXkFVX3lxTFBWTjlRbUU2aVRqVllpSkFZVUg0UzhjMnVFMGxFdXRLbjJBRndfeE9feko3Q0E2MWhxSUlWWTY0RFBubnhlYkJNQ3BocG9NZC1SNzhLeTVVWjhzR3lvS2fSAWNBVV95cUxPLXNabTBMYUxTdlBTY0FvclpvU182S2lfYmRXdUt3Q0xaVS1YU3F3WlFBcnFrQTNYbmw5TTJpU01Ca0loRW1XaGNiZFE4TmhXVzkxeXZrWTRkMnVLN3lndUJYazA?oc=5","source_event_id":"evt_f2a5ead44961","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"40801e21854ac7d8","kind":"sector_rotation","published_at":"2026-04-06T00:28:00+00:00","publisher_domain":"gstatic.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"MP Materials","relevance":"high","symbol":"MP","type":"company"},{"asset_class":"sector","name":"Materials industry","relevance":"medium","symbol":"","type":"sector"}],"event_type":"earnings","information_gaps":["No explicit list of which sectors are gaining vs losing is provided beyond the mention of \u201cmaterials industry.\u201d","No macro driver is specified other than the generic phrase \u201csector rotation.\u201d","No details are provided on whether the rotation is a regime shift or short-term rebalancing.","No earnings metrics (e.g., EPS, revenue growth, guidance) are included in the provided text.","The publisher/domain shown in the provided context is inconsistent with the article text (article text references Bitget; publisher_domain provided is gstatic.com), so the exact source content cannot be verified from the cleaned text alone."],"key_facts":["MP Materials received a buy recommendation.","The rationale given is strong earnings performance.","The strong earnings performance is described as occurring during sector rotation in the materials industry."],"numeric_claims":[],"primary_claim":"MP Materials was given a buy recommendation due to strong earnings performance during sector rotation in the materials industry.","relevance_score":0.45,"sentiment":"positive","source_quality":"high","summary":"The signal claims MP Materials received a buy recommendation, attributing it to strong earnings performance amid sector rotation within the materials industry.","topics":["sector rotation","materials","earnings","analyst recommendation","buy rating"]},"source":"Bitget","source_domain":"gstatic.com","summary":"MP Materials Receives Buy Recommendation Due to Strong Earnings Performance During Sector Rotation in Materials Industry Bitget","tickers":[],"title":"MP Materials Receives Buy Recommendation Due to Strong Earnings Performance During Sector Rotation in Materials Industry - Bitget","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 2604 in events