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/CBMimgFBVV95cUxOcUtiNVhWWUJaZVpuc0NuaGNXZDh4cFhYQkh0c0V5aW1abmdqMDQ4QTNJZzhmSi1KZzJGTHFtSUpDNmJmem81ZlF6YU1nd2xIazVVZDZVMTY5dUhQUEF6eUh2MmFSblYwMlhyRkZSVHBLWldma2xHc244d3NKRW04X2paT2JjN0VLRldZUEI2cmpTV3k5YUFfQ0dR?oc=5","as_of":"2026-04-09T20:52:32.828177+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/CBMimgFBVV95cUxOcUtiNVhWWUJaZVpuc0NuaGNXZDh4cFhYQkh0c0V5aW1abmdqMDQ4QTNJZzhmSi1KZzJGTHFtSUpDNmJmem81ZlF6YU1nd2xIazVVZDZVMTY5dUhQUEF6eUh2MmFSblYwMlhyRkZSVHBLWldma2xHc244d3NKRW04X2paT2JjN0VLRldZUEI2cmpTV3k5YUFfQ0dR?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_583894a133ba27a5","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:33:22.873045+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimgFBVV95cUxOcUtiNVhWWUJaZVpuc0NuaGNXZDh4cFhYQkh0c0V5aW1abmdqMDQ4QTNJZzhmSi1KZzJGTHFtSUpDNmJmem81ZlF6YU1nd2xIazVVZDZVMTY5dUhQUEF6eUh2MmFSblYwMlhyRkZSVHBLWldma2xHc244d3NKRW04X2paT2JjN0VLRldZUEI2cmpTV3k5YUFfQ0dR?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"rollingstone.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMimgFBVV95cUxOcUtiNVhWWUJaZVpuc0NuaGNXZDh4cFhYQkh0c0V5aW1abmdqMDQ4QTNJZzhmSi1KZzJGTHFtSUpDNmJmem81ZlF6YU1nd2xIazVVZDZVMTY5dUhQUEF6eUh2MmFSblYwMlhyRkZSVHBLWldma2xHc244d3NKRW04X2paT2JjN0VLRldZUEI2cmpTV3k5YUFfQ0dR?oc=5","source_event_id":"evt_4d823b66f473","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"2b2e21a11a999e9d","published_at":"2026-04-09T17:13:20+00:00","publisher_domain":"rollingstone.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"BTS","relevance":"primary","symbol":"","type":"music_group"},{"asset_class":"other","name":"Jin (BTS)","relevance":"secondary","symbol":"","type":"person"},{"asset_class":"other","name":"Rolling Stone","relevance":"source","symbol":"","type":"publisher"},{"asset_class":"other","name":"BBC","relevance":"source_mentioned_in_summary","symbol":"","type":"publisher"},{"asset_class":"other","name":"Yahoo","relevance":"source_mentioned_in_summary","symbol":"","type":"publisher"},{"asset_class":"other","name":"ABC News","relevance":"source_mentioned_in_summary","symbol":"","type":"publisher"},{"asset_class":"other","name":"Reuters","relevance":"source_mentioned_in_summary","symbol":"","type":"publisher"}],"event_type":"price_action","information_gaps":["The cleaned article text provided is largely HTML/CSS and does not contain the actual narrative content; only the headline and the multi-source summary are usable here.","No specific date(s), venue name(s), or whether any show was delayed/cancelled are included in the provided text.","The $1bn figure\u2019s basis (reported estimate vs. confirmed contract value) is not verifiable from the provided excerpt.","No direct financial/market impact details are present; the event type categorization is therefore uncertain relative to typical \u201cnews_headline_delta\u201d financial signals."],"key_facts":["Rolling Stone headline indicates BTS performed/\u201cbrought the hits\u201d at a tour kickoff despite torrential rain.","The provided source summary states the tour kickoff occurred in South Korea.","The summary includes a claim that the tour is a \u201c$1bn world tour\u201d (exact figure attribution/timing not fully verifiable from the provided text).","The summary indicates Jin commented on feeling like he was \u201cback home\u201d for the first concert of the ARIRANG World Tour (exact quote context not fully verifiable from the provided text).","The summary indicates thousands of fans gathered for the tour launch in South Korea."],"numeric_claims":[{"label":"Tour value","value":"$1bn"}],"primary_claim":"BTS launched their world tour in South Korea at kickoff while facing torrential rain, described as an intense weather event during the opening shows.","relevance_score":0.42,"sentiment":"mixed","source_quality":"high","summary":"Rolling Stone reports that BTS kicked off their ARIRANG World Tour in South Korea amid torrential rain, with fans and the group continuing the show. The coverage frames the weather as a notable near-term condition during the tour kickoff rather than a cancellation or policy change.","topics":["BTS","world tour kickoff","South Korea","torrential rain","concert attendance","ARIRANG World Tour"]},"source":"Rolling Stone","source_domain":"rollingstone.com","source_url":"https://www.rollingstone.com","summary":"BTS Bring the Hits, Brave Torrents of Rain at Tour Kickoff Rolling Stone 'It's like a water park': BTS battle torrential rain as $1bn world tour kicks off BBC BTS\u2019 Jin Reflects on Band\u2019s First Concert of ARIRANG World Tour: \u2018I Feel Like I\u2019m Back Home\u2019 Yahoo Thousands of fans gather as BTS launches world tour in South Korea ABC News BTS to kick off massive world tour in South Korea Reuters","title":"BTS Bring the Hits, Brave Torrents of Rain at Tour Kickoff - Rolling Stone","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_a9d17544bc01 in signals