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/CBMi5gFBVV95cUxNU1IyYVlNTVdzb3h6ZFh6MkZWc0E3TUJEWTIyenROMGhiQ2cwdGlTQzZQaVFnc1VsRV8xTno2VThsUkVzcGR3ZWdQczhFZ0hOeGVFTVFyVG9JUWN2NFJOVWVqYmR6OU5Nblo4NndadlluU05QT2tFbkxfNFI4QWFwc0tLdUZXMjVEbDI4WG9SUzI0TnVsUWNLYTJJdGkyU2tIVFFaYWt3N043N19NY3Z2QU1iWVpOZWZMbXIyWEdWQTJxVFZpNlZtTkt4N3hhUUFuV2lFYzlUalpWS0FpdzNxR29VRzlnQdIB-gFBVV95cUxPbGowWUYwR3NWMlN0eVNnNlFHREQwdll4akhOdGJ4QkhuYjBCOVM4eExWMkdua2Z5SEpxMkt1N3BPMXVzVHM4cW5wMnBWN1ZuczJMMVdKNW1UaUxROXFqRzVXS0VfRjl2QXJUM1dYZHNyOHRubkt2RzhVVU5IU183WlRjQVlhUzV3MmxUbTJ1eldxT2VMTGRjTWdOUEUweFQ3SUdiNWZ6RmdlMVhpMkxhZ1Q2YVNzVWpRQmYtOGNOblJta0hLTHJDdVFtU21nUERKN2xQbWl5UEFJOUUwTzRWODA1OE4tWkhKcXQ1eTlIa0RjaEFKMXVPdUNB?oc=5","as_of":"2026-04-09T01:37:47.362693+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/CBMi5gFBVV95cUxNU1IyYVlNTVdzb3h6ZFh6MkZWc0E3TUJEWTIyenROMGhiQ2cwdGlTQzZQaVFnc1VsRV8xTno2VThsUkVzcGR3ZWdQczhFZ0hOeGVFTVFyVG9JUWN2NFJOVWVqYmR6OU5Nblo4NndadlluU05QT2tFbkxfNFI4QWFwc0tLdUZXMjVEbDI4WG9SUzI0TnVsUWNLYTJJdGkyU2tIVFFaYWt3N043N19NY3Z2QU1iWVpOZWZMbXIyWEdWQTJxVFZpNlZtTkt4N3hhUUFuV2lFYzlUalpWS0FpdzNxR29VRzlnQdIB-gFBVV95cUxPbGowWUYwR3NWMlN0eVNnNlFHREQwdll4akhOdGJ4QkhuYjBCOVM4eExWMkdua2Z5SEpxMkt1N3BPMXVzVHM4cW5wMnBWN1ZuczJMMVdKNW1UaUxROXFqRzVXS0VfRjl2QXJUM1dYZHNyOHRubkt2RzhVVU5IU183WlRjQVlhUzV3MmxUbTJ1eldxT2VMTGRjTWdOUEUweFQ3SUdiNWZ6RmdlMVhpMkxhZ1Q2YVNzVWpRQmYtOGNOblJta0hLTHJDdVFtU21nUERKN2xQbWl5UEFJOUUwTzRWODA1OE4tWkhKcXQ1eTlIa0RjaEFKMXVPdUNB?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_0a5f9d768707b6d5","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-09T22:23:06.371062+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi5gFBVV95cUxNU1IyYVlNTVdzb3h6ZFh6MkZWc0E3TUJEWTIyenROMGhiQ2cwdGlTQzZQaVFnc1VsRV8xTno2VThsUkVzcGR3ZWdQczhFZ0hOeGVFTVFyVG9JUWN2NFJOVWVqYmR6OU5Nblo4NndadlluU05QT2tFbkxfNFI4QWFwc0tLdUZXMjVEbDI4WG9SUzI0TnVsUWNLYTJJdGkyU2tIVFFaYWt3N043N19NY3Z2QU1iWVpOZWZMbXIyWEdWQTJxVFZpNlZtTkt4N3hhUUFuV2lFYzlUalpWS0FpdzNxR29VRzlnQdIB-gFBVV95cUxPbGowWUYwR3NWMlN0eVNnNlFHREQwdll4akhOdGJ4QkhuYjBCOVM4eExWMkdua2Z5SEpxMkt1N3BPMXVzVHM4cW5wMnBWN1ZuczJMMVdKNW1UaUxROXFqRzVXS0VfRjl2QXJUM1dYZHNyOHRubkt2RzhVVU5IU183WlRjQVlhUzV3MmxUbTJ1eldxT2VMTGRjTWdOUEUweFQ3SUdiNWZ6RmdlMVhpMkxhZ1Q2YVNzVWpRQmYtOGNOblJta0hLTHJDdVFtU21nUERKN2xQbWl5UEFJOUUwTzRWODA1OE4tWkhKcXQ1eTlIa0RjaEFKMXVPdUNB?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"syracuse.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi5gFBVV95cUxNU1IyYVlNTVdzb3h6ZFh6MkZWc0E3TUJEWTIyenROMGhiQ2cwdGlTQzZQaVFnc1VsRV8xTno2VThsUkVzcGR3ZWdQczhFZ0hOeGVFTVFyVG9JUWN2NFJOVWVqYmR6OU5Nblo4NndadlluU05QT2tFbkxfNFI4QWFwc0tLdUZXMjVEbDI4WG9SUzI0TnVsUWNLYTJJdGkyU2tIVFFaYWt3N043N19NY3Z2QU1iWVpOZWZMbXIyWEdWQTJxVFZpNlZtTkt4N3hhUUFuV2lFYzlUalpWS0FpdzNxR29VRzlnQdIB-gFBVV95cUxPbGowWUYwR3NWMlN0eVNnNlFHREQwdll4akhOdGJ4QkhuYjBCOVM4eExWMkdua2Z5SEpxMkt1N3BPMXVzVHM4cW5wMnBWN1ZuczJMMVdKNW1UaUxROXFqRzVXS0VfRjl2QXJUM1dYZHNyOHRubkt2RzhVVU5IU183WlRjQVlhUzV3MmxUbTJ1eldxT2VMTGRjTWdOUEUweFQ3SUdiNWZ6RmdlMVhpMkxhZ1Q2YVNzVWpRQmYtOGNOblJta0hLTHJDdVFtU21nUERKN2xQbWl5UEFJOUUwTzRWODA1OE4tWkhKcXQ1eTlIa0RjaEFKMXVPdUNB?oc=5","source_event_id":"evt_3ae12ba3607b","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"46f63a69f3260081","published_at":"2026-04-08T21:15:00+00:00","publisher_domain":"syracuse.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"media","name":"Hacks","relevance":"high","symbol":"","type":"tv_series"},{"asset_class":"media","name":"HBO","relevance":"high","symbol":"","type":"network"},{"asset_class":"media","name":"Rotten Tomatoes","relevance":"high","symbol":"","type":"review_aggregator"},{"asset_class":"media","name":"Syracuse.com","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The cleaned article text provided contains no substantive body content beyond page styling; only the headline and source summary are available for extraction.","The exact Rotten Tomatoes metric definition (e.g., number of reviews, critics vs audience) is not specified in the provided text.","The claim that it is HBO\u2019s \u201chighest-rated show ever\u201d is not verifiable from the provided excerpt (no comparison set or methodology shown).","No premiere date/time for the final season is included in the provided excerpt (only referenced in the source summary)."],"key_facts":["Syracuse.com reports that \u201cHacks\u201d final season scored 100% on Rotten Tomatoes.","Syracuse.com further claims this makes it HBO\u2019s highest-rated show ever.","The provided source summary also references other \u201cHacks\u201d final-season coverage (e.g., premiere time and season review), but those details are not included in the cleaned article text shown."],"numeric_claims":[{"label":"Rotten Tomatoes score (final season)","value":"100%"}],"primary_claim":"\u201cHacks\u201d final season scored 100% on Rotten Tomatoes, making it HBO\u2019s highest-rated show ever (per Syracuse.com).","relevance_score":0.35,"sentiment":"positive","source_quality":"high","summary":"HBO\u2019s comedy series \u201cHacks\u201d has received a 100% score for its final season on Rotten Tomatoes, which the article claims is the network\u2019s highest-rated show ever. The coverage frames this as a strong critical reception and a near-term promotional/cultural catalyst around the show\u2019s end.","topics":["television","streaming","critical reception","Rotten Tomatoes","HBO","series finale"]},"source":"Syracuse.com","source_domain":"syracuse.com","source_url":"https://www.syracuse.com","summary":"HBO show\u2019s final season scores 100% on Rotten Tomatoes, making it the network\u2019s highest-rated show ever Syracuse.com 'Hacks' returns for its final season. What time does it premiere? USA Today From Jean Smart\u2019s Heart Surgery to a Shocking Lesbian Episode, \u2018Hacks\u2019 Ends \u2014 and Cements Its Legacy as One of TV\u2019s Best Comedies Variety 'Hacks' Season 5 Review: Jean Smart in Final Season of HBO Max Comedy The Hollywood Reporter \u2018Hacks\u2019 Star \u2018Taken Aback\u2019 by Series-Ending Surprise Twist The Daily Beast","title":"HBO show\u2019s final season scores 100% on Rotten Tomatoes, making it the network\u2019s highest-rated show ever - Syracuse.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_e51e1277e426 in signals