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/CBMi3AFBVV95cUxOUEM0VWI1dG04dWNGRm1nYTI1WDdiR1ItUENnTHpFOEdlMXd4VTZHRm56aHYtSVZFWE1WcGt1MWtmeEk0UGs4UW1mTnBUektfTC1UWTBXMnFFV3RkaVBrMFhiT2c2YWxNRHVHRXBIZjQ1aHZRNjlzYmEzUnZ0ZnJEdWwtRlh1LWpqWDVJTUVocTB1YUxiUHRhWjdFeGZkQjZFeE10T2k0VmFHZFJFZ3F0Yks0c1Y0V2tWd2V4Q1RxcWlfQ1MxejItcE8yWmZueW44M2ZDTWZWbS1UVEdv?oc=5","as_of":"2026-04-09T23:03:23.158584+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/CBMi3AFBVV95cUxOUEM0VWI1dG04dWNGRm1nYTI1WDdiR1ItUENnTHpFOEdlMXd4VTZHRm56aHYtSVZFWE1WcGt1MWtmeEk0UGs4UW1mTnBUektfTC1UWTBXMnFFV3RkaVBrMFhiT2c2YWxNRHVHRXBIZjQ1aHZRNjlzYmEzUnZ0ZnJEdWwtRlh1LWpqWDVJTUVocTB1YUxiUHRhWjdFeGZkQjZFeE10T2k0VmFHZFJFZ3F0Yks0c1Y0V2tWd2V4Q1RxcWlfQ1MxejItcE8yWmZueW44M2ZDTWZWbS1UVEdv?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_f2bdfabd4a53cf31","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-10T00:50:04.676608+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi3AFBVV95cUxOUEM0VWI1dG04dWNGRm1nYTI1WDdiR1ItUENnTHpFOEdlMXd4VTZHRm56aHYtSVZFWE1WcGt1MWtmeEk0UGs4UW1mTnBUektfTC1UWTBXMnFFV3RkaVBrMFhiT2c2YWxNRHVHRXBIZjQ1aHZRNjlzYmEzUnZ0ZnJEdWwtRlh1LWpqWDVJTUVocTB1YUxiUHRhWjdFeGZkQjZFeE10T2k0VmFHZFJFZ3F0Yks0c1Y0V2tWd2V4Q1RxcWlfQ1MxejItcE8yWmZueW44M2ZDTWZWbS1UVEdv?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"mmajunkie.usatoday.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi3AFBVV95cUxOUEM0VWI1dG04dWNGRm1nYTI1WDdiR1ItUENnTHpFOEdlMXd4VTZHRm56aHYtSVZFWE1WcGt1MWtmeEk0UGs4UW1mTnBUektfTC1UWTBXMnFFV3RkaVBrMFhiT2c2YWxNRHVHRXBIZjQ1aHZRNjlzYmEzUnZ0ZnJEdWwtRlh1LWpqWDVJTUVocTB1YUxiUHRhWjdFeGZkQjZFeE10T2k0VmFHZFJFZ3F0Yks0c1Y0V2tWd2V4Q1RxcWlfQ1MxejItcE8yWmZueW44M2ZDTWZWbS1UVEdv?oc=5","source_event_id":"evt_8ee5c5deaaef","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"b7ecd95cb9c2762c","published_at":"2026-04-09T14:30:00+00:00","publisher_domain":"mmajunkie.usatoday.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Rashad Evans","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Carlos Ulberg","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"UFC 327","relevance":"high","symbol":"","type":"event"}],"event_type":"other","information_gaps":["The specific \u201conly way\u201d (e.g., method of defeat, round/timing, or tactical scenario) is not present in the provided text.","The opponent in the UFC 327 title bout is not explicitly stated in the provided headline/signal content (though the broader source summary mentions Ji\u0159\u00ed Proch\u00e1zka vs Carlos Ulberg, this is not confirmed within the headline itself).","No direct quote text beyond the \u201conly way\u201d framing is included in the provided content."],"key_facts":["The article is from MMA Junkie (mmajunkie.usatoday.com).","Headline indicates Rashad Evans revealed the \u201conly way\u201d Carlos Ulberg loses his UFC 327 title bout.","The signal is a headline delta referencing Evans\u2019 comments about the outcome condition."],"numeric_claims":[],"primary_claim":"Rashad Evans stated the \u201conly way\u201d Carlos Ulberg loses his UFC 327 title bout.","relevance_score":0.42,"sentiment":"neutral","source_quality":"high","summary":"Rashad Evans says there is a specific path for Carlos Ulberg to lose his UFC 327 title fight. The headline frames Evans\u2019 view as a near-term tactical/conditional factor for the bout\u2019s outcome.","topics":["MMA","UFC 327","title bout","fight prediction","tactical conditions"]},"source":"MMA Junkie","source_domain":"mmajunkie.usatoday.com","source_url":"https://mmajunkie.usatoday.com","summary":"Rashad Evans reveals 'only way' Carlos Ulberg loses UFC 327 title bout MMA Junkie UFC 327 picks: Experts expect Ji\u0159\u00ed Proch\u00e1zka to finish Carlos Ulberg ESPN Staredowns! UFC 327 press conference face offs featuring, Jiri-Ulberg, Costa-Murzakanov & more Yahoo Sports Fight By Fight Preview | UFC 327: Proch\u00e1zka vs Ulberg UFC.com \u2018F*ck the others\u2019: Jiri Prochazka isn\u2019t thinking about Alex Pereira, Khamzat Chimaev or anything else until after UFC 327 MMA Fighting","title":"Rashad Evans reveals 'only way' Carlos Ulberg loses UFC 327 title bout - MMA Junkie","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_011eb9c82db9 in signals