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:1d54c2fae504bb2e","evidence_event_ids":["evt_7360bc311552"],"signal_type":"discovery_sector_rotation_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMilwFBVV95cUxPUmM0akNuMVB0dWdOT04zT1FCZzNpZ2d6MkJTdG5ZUW1HU2xZbXRPdFFJeTFDaHNfRVNXdUhma0k2RHZGQmszVlltcC12Tl9mYm90VF9NTWRiZFZaQUdZekRjeFotekRpY2dUaGJGaVY5YnljWlphUXh6STZKWW9pMFM5YTBoODJtV2tFcmIyb3Z6enRHRjdv?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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMilwFBVV95cUxPUmM0akNuMVB0dWdOT04zT1FCZzNpZ2d6MkJTdG5ZUW1HU2xZbXRPdFFJeTFDaHNfRVNXdUhma0k2RHZGQmszVlltcC12Tl9mYm90VF9NTWRiZFZaQUdZekRjeFotekRpY2dUaGJGaVY5YnljWlphUXh6STZKWW9pMFM5YTBoODJtV2tFcmIyb3Z6enRHRjdv?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9cc692a09e2e2665","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T00:50:36.580060+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilwFBVV95cUxPUmM0akNuMVB0dWdOT04zT1FCZzNpZ2d6MkJTdG5ZUW1HU2xZbXRPdFFJeTFDaHNfRVNXdUhma0k2RHZGQmszVlltcC12Tl9mYm90VF9NTWRiZFZaQUdZekRjeFotekRpY2dUaGJGaVY5YnljWlphUXh6STZKWW9pMFM5YTBoODJtV2tFcmIyb3Z6enRHRjdv?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/CBMilwFBVV95cUxPUmM0akNuMVB0dWdOT04zT1FCZzNpZ2d6MkJTdG5ZUW1HU2xZbXRPdFFJeTFDaHNfRVNXdUhma0k2RHZGQmszVlltcC12Tl9mYm90VF9NTWRiZFZaQUdZekRjeFotekRpY2dUaGJGaVY5YnljWlphUXh6STZKWW9pMFM5YTBoODJtV2tFcmIyb3Z6enRHRjdv?oc=5","source_event_id":"evt_7360bc311552","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"840886b25929f726","kind":"sector_rotation","published_at":"2026-04-04T15:14:31+00:00","publisher_domain":"gstatic.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"etf","name":"Anfield US Equity Sector Rotation ETF","relevance":"primary","symbol":"","type":"fund"},{"asset_class":"etf","name":"iShares U.S. Pharmaceuticals ETF","relevance":"primary","symbol":"IHE","type":"fund"},{"asset_class":"website","name":"GuruFocus","relevance":"supporting","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The cleaned article text does not include any actual holding history data (e.g., dates, weights, share counts, or changes).","No information is provided on which sectors are gaining or losing.","No macro driver (e.g., rates, inflation, earnings, risk-on/off) is stated in the provided text.","No evidence is provided to determine whether this is a regime shift versus short-term rebalancing.","No time window for the rotation/holding history is included in the provided text."],"key_facts":["Headline indicates the page is about \u201cAnfield US Equity Sector Rotation ETF's iShares U.S. Pharmaceuticals ETF (IHE) Holding History.\u201d","No sector gain/loss, macro driver, or rotation/regime-shift information is present in the provided cleaned article text (it is largely CSS/HTML styling)."],"numeric_claims":[],"primary_claim":"The source is a GuruFocus page titled about Anfield US Equity Sector Rotation ETF\u2019s holding history of iShares U.S. Pharmaceuticals ETF (IHE).","relevance_score":0.25,"sentiment":"neutral","source_quality":"high","summary":"The provided signal references a GuruFocus page about Anfield US Equity Sector Rotation ETF\u2019s holding history for iShares U.S. Pharmaceuticals ETF (IHE), but the cleaned article text contains no readable holding/rotation details.","topics":["sector rotation","ETF holding history","pharmaceuticals sector","IHE"]},"source":"GuruFocus","source_domain":"gstatic.com","summary":"Anfield US Equity Sector Rotation ETF's iShares U.S. Pharmaceuticals ETF(IHE) Holding History GuruFocus","tickers":["IHE"],"title":"Anfield US Equity Sector Rotation ETF's iShares U.S. Pharmaceuticals ETF(IHE) Holding History - GuruFocus","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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 2612 in events