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-09T13:30:32.831623+00:00","dedupe_key":"signal_enriched:news_delta:c4555042dae69d37","evidence_event_ids":["evt_83e228521907"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxPemI1bXF5cHVjdW9FNTFRdHVNam40OG9xMFZpVmlqLUNaa0p6MTN2UG5TOXY2dVlZYU95SENwT296T3VGTEstaU0yQXp1eWdZQmdKYXkySVowMnVzeGFiSWhrQTdyaFZtUFIyZkVmbWh5aHZTeENkcFkwX1l6d3Bqak5WX3ZxVlJvRFUxSkpuVHB2Y2JQQVJNWmhDRWZLdHZsNGFNZGE2M0pSLWxS?oc=5","as_of":"2026-04-09T13:30:32.831623+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/CBMirAFBVV95cUxPemI1bXF5cHVjdW9FNTFRdHVNam40OG9xMFZpVmlqLUNaa0p6MTN2UG5TOXY2dVlZYU95SENwT296T3VGTEstaU0yQXp1eWdZQmdKYXkySVowMnVzeGFiSWhrQTdyaFZtUFIyZkVmbWh5aHZTeENkcFkwX1l6d3Bqak5WX3ZxVlJvRFUxSkpuVHB2Y2JQQVJNWmhDRWZLdHZsNGFNZGE2M0pSLWxS?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_ff0b30a67e6473fc","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-09T23:27:44.124686+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxPemI1bXF5cHVjdW9FNTFRdHVNam40OG9xMFZpVmlqLUNaa0p6MTN2UG5TOXY2dVlZYU95SENwT296T3VGTEstaU0yQXp1eWdZQmdKYXkySVowMnVzeGFiSWhrQTdyaFZtUFIyZkVmbWh5aHZTeENkcFkwX1l6d3Bqak5WX3ZxVlJvRFUxSkpuVHB2Y2JQQVJNWmhDRWZLdHZsNGFNZGE2M0pSLWxS?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"zacks.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxPemI1bXF5cHVjdW9FNTFRdHVNam40OG9xMFZpVmlqLUNaa0p6MTN2UG5TOXY2dVlZYU95SENwT296T3VGTEstaU0yQXp1eWdZQmdKYXkySVowMnVzeGFiSWhrQTdyaFZtUFIyZkVmbWh5aHZTeENkcFkwX1l6d3Bqak5WX3ZxVlJvRFUxSkpuVHB2Y2JQQVJNWmhDRWZLdHZsNGFNZGE2M0pSLWxS?oc=5","source_event_id":"evt_83e228521907","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"8fcad4452a5d616a","published_at":"2026-04-09T12:43:59+00:00","publisher_domain":"zacks.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"JPMorgan","relevance":"high","symbol":"JPM","type":"company"},{"asset_class":"equity","name":"Citigroup","relevance":"high","symbol":"C","type":"company"},{"asset_class":"equity","name":"Wells Fargo","relevance":"high","symbol":"WFC","type":"company"},{"asset_class":"other","name":"Zacks Investment Research","relevance":"high","symbol":"","type":"publisher"}],"event_type":"earnings","information_gaps":["The provided article text contains only HTML/CSS styling fragments and does not include the actual earnings-trends content.","No specific earnings metrics (e.g., EPS, revenue, estimates vs. actual), guidance, revisions, or surprise magnitude are provided.","No publication date, earnings date, or near-term catalyst timing is included in the provided text.","No stated directional impact (beat/miss, estimate changes, revisions) is present in the provided text."],"key_facts":["Headline states: \"Zacks Earnings Trends Highlights: JPMorgan, Citigroup and Wells Fargo\".","Source summary repeats the same earnings-trends highlight focus on the three banks.","No additional quantitative or qualitative earnings details are included in the provided cleaned text (only page styling/HTML fragments)."],"numeric_claims":[],"primary_claim":"Zacks Investment Research released an earnings-trends highlight article for JPMorgan, Citigroup, and Wells Fargo.","relevance_score":0.55,"sentiment":"neutral","source_quality":"high","summary":"Zacks Investment Research published an earnings-trends highlight covering JPMorgan, Citigroup, and Wells Fargo. The signal indicates the article focuses on these banks\u2019 earnings trends, but no specific results or timing details are present in the provided text.","topics":["earnings trends","bank earnings","financial sector","equity research"]},"source":"Zacks Investment Research","source_domain":"zacks.com","source_url":"https://www.zacks.com","summary":"Zacks Earnings Trends Highlights: JPMorgan, Citigroup and Wells Fargo Zacks Investment Research","title":"Zacks Earnings Trends Highlights: JPMorgan, Citigroup and Wells Fargo - Zacks Investment Research","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 10023 in events