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-08T04:33:58.949501+00:00","dedupe_key":"signal_enriched:news_delta:03b70f7035c3db57","evidence_event_ids":["evt_a9cbf05f007e"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMisgFBVV95cUxPODFsczJxNTV4c1loYjVYdUcydS1OYVFPQXVkUzZsbnB1WWJjRkhRZFJJcnd0V09NSWFqUVVpMktZbEVGUXB1OFZGWmlaUjF4ZUFwRmZEYVh6bERWcVpUNV9BTDdFS0JFWVhYS1o2dmF2SVpsTGtMQy02TGl6M1FqMjNURTZIZ1B3VjhFMUlyRVNqSndqUjd2YThUN0RFcDhOTHljOWxPaVFaRE5KeVhOWkJn?oc=5","as_of":"2026-04-08T04:33:58.949501+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/CBMisgFBVV95cUxPODFsczJxNTV4c1loYjVYdUcydS1OYVFPQXVkUzZsbnB1WWJjRkhRZFJJcnd0V09NSWFqUVVpMktZbEVGUXB1OFZGWmlaUjF4ZUFwRmZEYVh6bERWcVpUNV9BTDdFS0JFWVhYS1o2dmF2SVpsTGtMQy02TGl6M1FqMjNURTZIZ1B3VjhFMUlyRVNqSndqUjd2YThUN0RFcDhOTHljOWxPaVFaRE5KeVhOWkJn?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_6af7c6f1fbca4514","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-08T04:34:39.909934+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMisgFBVV95cUxPODFsczJxNTV4c1loYjVYdUcydS1OYVFPQXVkUzZsbnB1WWJjRkhRZFJJcnd0V09NSWFqUVVpMktZbEVGUXB1OFZGWmlaUjF4ZUFwRmZEYVh6bERWcVpUNV9BTDdFS0JFWVhYS1o2dmF2SVpsTGtMQy02TGl6M1FqMjNURTZIZ1B3VjhFMUlyRVNqSndqUjd2YThUN0RFcDhOTHljOWxPaVFaRE5KeVhOWkJn?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nbcnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMisgFBVV95cUxPODFsczJxNTV4c1loYjVYdUcydS1OYVFPQXVkUzZsbnB1WWJjRkhRZFJJcnd0V09NSWFqUVVpMktZbEVGUXB1OFZGWmlaUjF4ZUFwRmZEYVh6bERWcVpUNV9BTDdFS0JFWVhYS1o2dmF2SVpsTGtMQy02TGl6M1FqMjNURTZIZ1B3VjhFMUlyRVNqSndqUjd2YThUN0RFcDhOTHljOWxPaVFaRE5KeVhOWkJn?oc=5","source_event_id":"evt_a9cbf05f007e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"afd9e658f2a89b01","published_at":"2026-04-08T01:30:00+00:00","publisher_domain":"nbcnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Chris Taylor","relevance":"primary","symbol":"","type":"person"},{"asset_class":"","name":"Wisconsin Supreme Court","relevance":"affected","symbol":"","type":"institution"},{"asset_class":"","name":"NBC News","relevance":"source","symbol":"","type":"publisher"}],"event_type":"earnings","information_gaps":["The provided article text is not actually present (only page CSS/HTML content), so vote totals, opponent name, and whether the projection is final vs. projected are not verifiable from the supplied text.","The exact mechanism of \u201cexpanding liberals\u2019 majority\u201d (e.g., seat count change) is not specified in the provided content.","No timing details (e.g., election date, when the seat takes effect) are included in the supplied material."],"key_facts":["NBC News headline states Chris Taylor won the Wisconsin Supreme Court race.","NBC News headline states the win expands liberals\u2019 majority on the Wisconsin Supreme Court."],"numeric_claims":[],"primary_claim":"Chris Taylor won the Wisconsin Supreme Court race, expanding liberals\u2019 majority.","relevance_score":0.62,"sentiment":"positive","source_quality":"high","summary":"Chris Taylor has won a Wisconsin Supreme Court race, with NBC News reporting the result expands liberals\u2019 majority on the court.","topics":["US state supreme court","Wisconsin elections","judicial elections","partisan balance","liberals' majority"]},"source":"NBC News","source_domain":"nbcnews.com","source_url":"https://www.nbcnews.com","summary":"Chris Taylor wins Wisconsin Supreme Court race, expanding liberals' majority NBC News Wisconsin Supreme Court 2026: Live Election Results The New York Times Liberal-backed Judge Chris Taylor wins Supreme Court race, AP projects Channel 3000 A subdued Wisconsin Supreme Court race tilts Democrats\u2019 way Politico What's on my ballot in Wisconsin election today, and in Milwaukee? Milwaukee Journal Sentinel","title":"Chris Taylor wins Wisconsin Supreme Court race, expanding liberals' majority - NBC News","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 4603 in events