SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://news.google.com/rss/articles/CBMimgFBVV95cUxOVTJ3dXFSXzdrTXBzME1kQWM3WG9GT3JWZTdkMnJhSWJyUS1ZdFkzSHJBbU0yczAtdFdENEo2NEU1c2xJd0lPRVh3b2xaN1llVmdkNEV4WENMRjNNeWRqUFp0aHk1S0xzV3VZS1AtQ3lNWE0yM1J3SldRRVkwaUtxS3ZLR3VISU1fU3g0LXJZdXZJZkRrOFQxYXlB?oc=5","as_of":"2026-04-08T02:29:41.145862+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/CBMimgFBVV95cUxOVTJ3dXFSXzdrTXBzME1kQWM3WG9GT3JWZTdkMnJhSWJyUS1ZdFkzSHJBbU0yczAtdFdENEo2NEU1c2xJd0lPRVh3b2xaN1llVmdkNEV4WENMRjNNeWRqUFp0aHk1S0xzV3VZS1AtQ3lNWE0yM1J3SldRRVkwaUtxS3ZLR3VISU1fU3g0LXJZdXZJZkRrOFQxYXlB?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_82124bcc138bde13","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-08T03:50:55.430171+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimgFBVV95cUxOVTJ3dXFSXzdrTXBzME1kQWM3WG9GT3JWZTdkMnJhSWJyUS1ZdFkzSHJBbU0yczAtdFdENEo2NEU1c2xJd0lPRVh3b2xaN1llVmdkNEV4WENMRjNNeWRqUFp0aHk1S0xzV3VZS1AtQ3lNWE0yM1J3SldRRVkwaUtxS3ZLR3VISU1fU3g0LXJZdXZJZkRrOFQxYXlB?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMimgFBVV95cUxOVTJ3dXFSXzdrTXBzME1kQWM3WG9GT3JWZTdkMnJhSWJyUS1ZdFkzSHJBbU0yczAtdFdENEo2NEU1c2xJd0lPRVh3b2xaN1llVmdkNEV4WENMRjNNeWRqUFp0aHk1S0xzV3VZS1AtQ3lNWE0yM1J3SldRRVkwaUtxS3ZLR3VISU1fU3g0LXJZdXZJZkRrOFQxYXlB?oc=5","source_event_id":"evt_c4dde59764c8","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"61b429c5b54db493","published_at":"2026-04-07T23:50:16+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Taylor Frankie Paul","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Dakota Mortensen","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Utah court / Utah commissioner overseeing child visitation dispute","relevance":"medium","symbol":"","type":"institution"}],"event_type":"conflict","information_gaps":["The cleaned article text provided contains only HTML/CSS and does not include the actual article content, so details of the petition (court, filing date, specific requested relief) are not verifiable from the provided text.","No specific timing (exact hearing date) is included in the provided headline/summary beyond the existence of a protective order hearing.","No direct details are provided here about what Dakota Mortensen requested or how the competing petition differs from prior filings (uncertain)."],"key_facts":["The New York Times headline states that Taylor Frankie Paul filed a competing court petition against Dakota Mortensen.","The provided source summary indicates the dispute involves alleged behavior concerns and a child visitation dispute overseen by a Utah commissioner.","The source summary also indicates there is (or was) a protective order hearing and that a Utah court ruled Taylor Frankie Paul cannot have unsupervised visits with her 2-year-old son."],"numeric_claims":[{"label":"child age mentioned","value":"2-year-old"}],"primary_claim":"Taylor Frankie Paul filed a competing court petition against Dakota Mortensen, as reported by The New York Times.","relevance_score":0.62,"sentiment":"neutral","source_quality":"high","summary":"Taylor Frankie Paul has filed a competing court petition against Dakota Mortensen, according to a New York Times report. The dispute is tied to an ongoing Utah child-visitation/protective-order matter, with near-term court proceedings likely to affect visitation arrangements.","topics":["court petition","child visitation dispute","protective order","family law","Utah courts","Bachelorette-related public profile"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Taylor Frankie Paul Files Competing Court Petition Against Dakota Mortensen The New York Times Dakota Mortensen Allegedly Got Taylor Frankie Paul Tattoo Before 'Bachelorette' (Exclusive) People.com Taylor Frankie Paul\u2019s \u2018volatile\u2019 behavior concerns Utah commissioner overseeing child visitation dispute sltrib.com Taylor Frankie Paul faces protective order hearing after 'Bachelorette' cancellation kutv.com Utah court rules Taylor Frankie Paul can't have unsupervised visits with her 2-year-old son PBS","title":"Taylor Frankie Paul Files Competing Court Petition Against Dakota Mortensen - The New York Times","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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_993feaff622f in signals