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/CBMimwFBVV95cUxNS19aWXB0WldqR2NQNTFmYnJ5V0U4eFlDTzAyTWJLUW0tUDJZMEFRNlhTczFTRmtLZkp4ZmFpNzZ4ZnB3WEJYWHFFZ1pOTkJSUGowaGhvdlBlY1kzR2VXQURWS0stM0I4TkwwNjc4LUNNQUxYMExSUGNVdGVCUkNUNG56dVhXbUZORTg4cWJTc2ZqSVVHTFF4X1lWVQ?oc=5","as_of":"2026-04-09T16:31:19.717272+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/CBMimwFBVV95cUxNS19aWXB0WldqR2NQNTFmYnJ5V0U4eFlDTzAyTWJLUW0tUDJZMEFRNlhTczFTRmtLZkp4ZmFpNzZ4ZnB3WEJYWHFFZ1pOTkJSUGowaGhvdlBlY1kzR2VXQURWS0stM0I4TkwwNjc4LUNNQUxYMExSUGNVdGVCUkNUNG56dVhXbUZORTg4cWJTc2ZqSVVHTFF4X1lWVQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9c33d0cc340e7068","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-09T23:59:40.016250+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimwFBVV95cUxNS19aWXB0WldqR2NQNTFmYnJ5V0U4eFlDTzAyTWJLUW0tUDJZMEFRNlhTczFTRmtLZkp4ZmFpNzZ4ZnB3WEJYWHFFZ1pOTkJSUGowaGhvdlBlY1kzR2VXQURWS0stM0I4TkwwNjc4LUNNQUxYMExSUGNVdGVCUkNUNG56dVhXbUZORTg4cWJTc2ZqSVVHTFF4X1lWVQ?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/CBMimwFBVV95cUxNS19aWXB0WldqR2NQNTFmYnJ5V0U4eFlDTzAyTWJLUW0tUDJZMEFRNlhTczFTRmtLZkp4ZmFpNzZ4ZnB3WEJYWHFFZ1pOTkJSUGowaGhvdlBlY1kzR2VXQURWS0stM0I4TkwwNjc4LUNNQUxYMExSUGNVdGVCUkNUNG56dVhXbUZORTg4cWJTc2ZqSVVHTFF4X1lWVQ?oc=5","source_event_id":"evt_426cd78be2b1","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7a0d9765dac9ca03","published_at":"2026-04-09T14:01:00+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"FIFA","relevance":"high","symbol":"","type":"organization"},{"asset_class":"other","name":"New York Times","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"other","name":"The Athletic","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"other","name":"BBC","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"other","name":"Sports Business Journal","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"other","name":"The Guardian","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"other","name":"World Cup fans (England and Scotland ticket buyers referenced)","relevance":"high","symbol":"","type":"group"},{"asset_class":"other","name":"England and Scotland (ticket buyers)","relevance":"medium","symbol":"","type":"country/teams"}],"event_type":"listing","information_gaps":["The provided text does not specify the name/definition of the new FIFA ticket category.","No concrete details are given on what exactly was wrong/misleading in the seat maps or allocations (e.g., seat location changes, mapping methodology, timing).","No specific timing is provided for when the new ticket category was introduced or when affected ticketing/resale occurred.","The source summary references multiple outlets, but the actual NYT article content is not included here beyond the headline; therefore, the exact NYT wording and evidence are unknown.","No quantitative figures (ticket price differences, allocation counts, or resale spreads) are included in the provided material."],"key_facts":["FIFA created a new World Cup ticket category (reported by The New York Times headline).","Fans allege FIFA misled them regarding ticket allocations and seat maps (The Athletic and BBC references in provided source summary).","The allegations are described as deepening suspicions of deception (NYT headline framing).","Some reporting notes resale of England and Scotland World Cup tickets at inflated prices (BBC referenced in source summary).","A Sports Business Journal item quotes an MLS commissioner saying FIFA was 'smart' to use dynamic pricing for World Cup tickets (The Guardian referenced in source summary)."],"numeric_claims":[],"primary_claim":"FIFA created a new World Cup ticket category, and fans accuse FIFA of misleading them about ticket allocations and seat maps.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"FIFA introduced a new World Cup ticket category, and multiple outlets report fan allegations that FIFA misled buyers via ticket allocations and seat maps. The change is being framed as deepening suspicions of deception around ticketing and resale pricing.","topics":["World Cup ticketing","FIFA ticket categories","seat maps","ticket allocations","resale pricing","dynamic pricing","consumer deception allegations"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"FIFA creates new World Cup ticket category, deepening suspicions of deception The New York Times \u2018Hard to not feel scammed\u2019: World Cup fans say FIFA misled them with ticket allocations, seat maps - The Athletic The New York Times England and Scotland World Cup tickets on resale at inflated prices BBC Fans accuse FIFA of \u2018misleading\u2019 World Cup seat maps when purchasing tickets Sports Business Journal MLS commissioner: Fifa \u2018smart\u2019 to use dynamic pricing for World Cup tickets The Guardian","title":"FIFA creates new World Cup ticket category, deepening suspicions of deception - 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_564a27ac76e0 in signals