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:37.630880+00:00","dedupe_key":"signal_enriched:news_delta:5670c875c81174d6","evidence_event_ids":["evt_2f58ab441c57"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMirgFBVV95cUxNRDkwU0lraFJCbzJzbXhVZlR4MHNkTDN1c3pUM3o4Y1FKLW9EQjdFSUZ6LTlmdkRhM1JIWDNFbnJSak5kbXRVUzRXVXdwSmRaZG1vNFlRckp3YjlZU1NocmZDWFhFWGExa0lfeWlvLUY3czJoeFlFd3VFM0ZXTi00ZkR0akRubmVPNTF2QnBibTljN1NkLTlCWmZLOFNtZ3JhYURnUXVBOWFtWG5Md2c?oc=5","as_of":"2026-04-07T23:23:37.630880+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/CBMirgFBVV95cUxNRDkwU0lraFJCbzJzbXhVZlR4MHNkTDN1c3pUM3o4Y1FKLW9EQjdFSUZ6LTlmdkRhM1JIWDNFbnJSak5kbXRVUzRXVXdwSmRaZG1vNFlRckp3YjlZU1NocmZDWFhFWGExa0lfeWlvLUY3czJoeFlFd3VFM0ZXTi00ZkR0akRubmVPNTF2QnBibTljN1NkLTlCWmZLOFNtZ3JhYURnUXVBOWFtWG5Md2c?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_b050412844dbea83","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:31:29.653068+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMirgFBVV95cUxNRDkwU0lraFJCbzJzbXhVZlR4MHNkTDN1c3pUM3o4Y1FKLW9EQjdFSUZ6LTlmdkRhM1JIWDNFbnJSak5kbXRVUzRXVXdwSmRaZG1vNFlRckp3YjlZU1NocmZDWFhFWGExa0lfeWlvLUY3czJoeFlFd3VFM0ZXTi00ZkR0akRubmVPNTF2QnBibTljN1NkLTlCWmZLOFNtZ3JhYURnUXVBOWFtWG5Md2c?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"apnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMirgFBVV95cUxNRDkwU0lraFJCbzJzbXhVZlR4MHNkTDN1c3pUM3o4Y1FKLW9EQjdFSUZ6LTlmdkRhM1JIWDNFbnJSak5kbXRVUzRXVXdwSmRaZG1vNFlRckp3YjlZU1NocmZDWFhFWGExa0lfeWlvLUY3czJoeFlFd3VFM0ZXTi00ZkR0akRubmVPNTF2QnBibTljN1NkLTlCWmZLOFNtZ3JhYURnUXVBOWFtWG5Md2c?oc=5","source_event_id":"evt_2f58ab441c57","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"b2a6187ae253f133","published_at":"2026-04-07T22:38:00+00:00","publisher_domain":"apnews.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"equity/other","name":"Taylor Frankie Paul","relevance":"primary","symbol":"","type":"person"},{"asset_class":"equity/other","name":"Dakota Mortensen","relevance":"primary","symbol":"","type":"person"},{"asset_class":"other","name":"Utah commissioner","relevance":"secondary","symbol":"","type":"organization/role"},{"asset_class":"other","name":"\u201cThe Bachelorette\u201d","relevance":"secondary","symbol":"","type":"media"}],"event_type":"conflict","information_gaps":["The cleaned article text provided does not include the substantive AP News content; only styling/boilerplate is present, so exact hearing date/time, court details, and the specific protective-order allegations are not verifiable from the provided text.","The directionality of market/financial impact is not applicable/unclear from the signal; this is a legal/family-court event.","The provided source summary includes claims attributed to other outlets (NBC News, Entertainment Weekly, Salt Lake Tribune, TODAY), but the exact wording and which party made which allegation are not fully grounded in the supplied article text."],"key_facts":["Taylor Frankie Paul is facing a protective order hearing in Utah.","The hearing follows the cancellation of her \u201cBachelorette\u201d appearance (as referenced in the headline).","The dispute involves allegations of a \u201cpattern of abusive conduct\u201d by Taylor Frankie Paul toward/with her ex Dakota Mortensen (as referenced in the provided source summary).","There is a related child custody dispute in Utah, with concerns raised about Taylor Frankie Paul\u2019s behavior (as referenced in the provided source summary).","Taylor Frankie Paul was granted supervised visits with her and Dakota Mortensen\u2019s 2-year-old son (as referenced in the provided source summary)."],"numeric_claims":[{"label":"child age","value":"2-year-old"}],"primary_claim":"Taylor Frankie Paul faces a protective order hearing in Utah after \u201cThe Bachelorette\u201d cancellation.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"Taylor Frankie Paul is scheduled for a protective order hearing in Utah following the cancellation of her appearance on \u201cThe Bachelorette.\u201d The case centers on allegations of abusive conduct and a related child-custody dispute involving her ex, Dakota Mortensen.","topics":["protective order hearing","domestic violence allegations","child custody dispute","supervised visitation","media cancellation"]},"source":"AP News","source_domain":"apnews.com","source_url":"https://apnews.com","summary":"Taylor Frankie Paul faces protective order hearing in Utah after \u2018Bachelorette\u2019 cancellation AP News Taylor Frankie Paul alleges 'pattern of abusive conduct' with ex Dakota Mortensen nbcnews.com Taylor Frankie Paul court hearing: Lawyer claims Dakota asked for sex after alleged domestic violence incident Entertainment Weekly Taylor Frankie Paul\u2019s \u2018volatile\u2019 behavior concerns Utah commissioner overseeing child custody dispute The Salt Lake Tribune Taylor Frankie Paul Granted Supervised Visits With Her and Dakota Mortensen's 2-Year-Old Son today.com","title":"Taylor Frankie Paul faces protective order hearing in Utah after \u2018Bachelorette\u2019 cancellation - AP News","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 2187 in events