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/CBMigAFBVV95cUxOQUJSUzdaV2JHdmVWSTcwd2lLS0hYTFdGYU9TdFlaQm5kU0pJblU2OC01dG5vc0NsamY0NmtHZGJEbFA0QzZtSHIxdVVXbW5nQlRJOE1LdFhLY3JUOUxWaHR6MkxpNDBuMnJBTGNOQnRqVVdFQlVMRXN5VlJ5MVpTZg?oc=5","as_of":"2026-04-10T19:36:11.936152+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/CBMigAFBVV95cUxOQUJSUzdaV2JHdmVWSTcwd2lLS0hYTFdGYU9TdFlaQm5kU0pJblU2OC01dG5vc0NsamY0NmtHZGJEbFA0QzZtSHIxdVVXbW5nQlRJOE1LdFhLY3JUOUxWaHR6MkxpNDBuMnJBTGNOQnRqVVdFQlVMRXN5VlJ5MVpTZg?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_2c7401d1fb1e3ee6","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-10T20:15:23.887223+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMigAFBVV95cUxOQUJSUzdaV2JHdmVWSTcwd2lLS0hYTFdGYU9TdFlaQm5kU0pJblU2OC01dG5vc0NsamY0NmtHZGJEbFA0QzZtSHIxdVVXbW5nQlRJOE1LdFhLY3JUOUxWaHR6MkxpNDBuMnJBTGNOQnRqVVdFQlVMRXN5VlJ5MVpTZg?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"ufc.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMigAFBVV95cUxOQUJSUzdaV2JHdmVWSTcwd2lLS0hYTFdGYU9TdFlaQm5kU0pJblU2OC01dG5vc0NsamY0NmtHZGJEbFA0QzZtSHIxdVVXbW5nQlRJOE1LdFhLY3JUOUxWaHR6MkxpNDBuMnJBTGNOQnRqVVdFQlVMRXN5VlJ5MVpTZg?oc=5","source_event_id":"evt_c0f3b4c88bdc","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e90a85212f2e6e23","published_at":"2026-04-10T16:19:28+00:00","publisher_domain":"ufc.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"sports_event","name":"UFC 327","relevance":"high","symbol":"","type":"event"},{"asset_class":"athlete","name":"Ji\u0159\u00ed Proch\u00e1zka","relevance":"high","symbol":"","type":"fighter"},{"asset_class":"athlete","name":"Carlos Ulberg","relevance":"high","symbol":"","type":"fighter"},{"asset_class":"media","name":"UFC.com","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The cleaned article text provided is largely HTML/CSS and does not include the actual weigh-in numbers or which fighter missed weight.","No specific weights, weight-difference, or whether a penalty/fine occurred are included in the provided content.","The event date and venue for UFC 327 are not present in the provided text.","No confirmation is provided on whether the \u201c1 fighter heavy\u201d affected bout status beyond the general statement that the title fight is set."],"key_facts":["UFC.com headline indicates publication of \u201cOfficial Weigh-In Results\u201d for UFC 327.","The featured main event/title fight is Proch\u00e1zka vs Ulberg.","The provided source summary states: \u201cTitle fight set.\u201d","The source summary also states: \u201c1 fighter heavy.\u201d (Which fighter is not specified in the provided text.)"],"numeric_claims":[],"primary_claim":"The official UFC 327 weigh-in results confirm the Proch\u00e1zka vs Ulberg title fight is set.","relevance_score":0.42,"sentiment":"neutral","source_quality":"high","summary":"UFC.com published the official weigh-in results for UFC 327\u2019s title fight between Ji\u0159\u00ed Proch\u00e1zka and Carlos Ulberg. The weigh-in confirms the bout is set, with at least one fighter reported as heavy on the scale.","topics":["UFC","weigh-ins","Proch\u00e1zka vs Ulberg","title fight","UFC 327"]},"source":"UFC.com","source_domain":"ufc.com","source_url":"https://www.ufc.com","summary":"Official Weigh-In Results | UFC 327: Proch\u00e1zka vs Ulberg UFC.com UFC 327 picks: Experts expect Ji\u0159\u00ed Proch\u00e1zka to finish Carlos Ulberg ESPN UFC 327 predictions: Will Jiri Prochazka reclaim gold or does Carlos Ulberg start his reign? Yahoo Sports UFC 327 odds, props, card: Prochazka vs. Ulberg picks, predictions from 10,000 model simulations CBS Sports UFC 327 weigh-in results: Title fight set; 1 fighter heavy Sherdog","title":"Official Weigh-In Results | UFC 327: Proch\u00e1zka vs Ulberg - UFC.com","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_38d5cf5b34c7 in signals