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/CBMingFBVV95cUxQVENDOVlkdTUzZDRkb2hrWlBXaUNvWTdURjBHb1UwRFVMcmZHRGVsdDJFYjJIamFTNEY1anQ1MnU1ZTFpTTB6WjJHRE5pWG41RlhoODU3OVVEZ0s2TFhNUzR6RUZOTVVsVW4xdVktdDZzNV9ReWYtZGFMMlZ0Z1d1bUo5dlhOcWFOSm8yemdhUGFhZUVRN3I5eXlyWlEyZw?oc=5","as_of":"2026-04-10T05:17:48.000934+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/CBMingFBVV95cUxQVENDOVlkdTUzZDRkb2hrWlBXaUNvWTdURjBHb1UwRFVMcmZHRGVsdDJFYjJIamFTNEY1anQ1MnU1ZTFpTTB6WjJHRE5pWG41RlhoODU3OVVEZ0s2TFhNUzR6RUZOTVVsVW4xdVktdDZzNV9ReWYtZGFMMlZ0Z1d1bUo5dlhOcWFOSm8yemdhUGFhZUVRN3I5eXlyWlEyZw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_3ec7efa73f08d933","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-10T05:18:19.525921+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMingFBVV95cUxQVENDOVlkdTUzZDRkb2hrWlBXaUNvWTdURjBHb1UwRFVMcmZHRGVsdDJFYjJIamFTNEY1anQ1MnU1ZTFpTTB6WjJHRE5pWG41RlhoODU3OVVEZ0s2TFhNUzR6RUZOTVVsVW4xdVktdDZzNV9ReWYtZGFMMlZ0Z1d1bUo5dlhOcWFOSm8yemdhUGFhZUVRN3I5eXlyWlEyZw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"billboard.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMingFBVV95cUxQVENDOVlkdTUzZDRkb2hrWlBXaUNvWTdURjBHb1UwRFVMcmZHRGVsdDJFYjJIamFTNEY1anQ1MnU1ZTFpTTB6WjJHRE5pWG41RlhoODU3OVVEZ0s2TFhNUzR6RUZOTVVsVW4xdVktdDZzNV9ReWYtZGFMMlZ0Z1d1bUo5dlhOcWFOSm8yemdhUGFhZUVRN3I5eXlyWlEyZw?oc=5","source_event_id":"evt_7ed9c82a0ca3","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"0334695338ef4caa","published_at":"2026-04-09T17:58:08+00:00","publisher_domain":"billboard.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"equity/none","name":"BTS","relevance":"primary subject","symbol":"","type":"music_group"},{"asset_class":"none","name":"Jin (BTS)","relevance":"quoted speaker","symbol":"","type":"person"},{"asset_class":"none","name":"ARIRANG World Tour","relevance":"tour being discussed","symbol":"","type":"event"},{"asset_class":"none","name":"Goyang Stadium","relevance":"location of first-night concert (per provided source summary)","symbol":"","type":"venue"},{"asset_class":"none","name":"South Korea","relevance":"tour kickoff location (per provided source summary)","symbol":"","type":"country"},{"asset_class":"media","name":"Billboard","relevance":"source","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The cleaned article text provided appears to be mostly page styling/HTML and does not contain the actual article content; extraction is therefore based on the headline and the provided source summary only.","No specific concert date/time, attendance figures, or setlist details are present in the provided signal content.","The signal includes multiple related headlines (e.g., Reuters/Rolling Stone) but only Billboard is explicitly the source for the quoted Jin reflection; cross-source details are not fully verifiable from the provided text."],"key_facts":["Billboard headline states Jin reflected on BTS\u2019s band\u2019s first concert of the ARIRANG World Tour.","Jin\u2019s quoted sentiment: \u201cI Feel Like I\u2019m Back Home.\u201d","The provided source summary indicates the ARIRANG tour kicked off in South Korea.","The provided source summary indicates the first night occurred at Goyang Stadium in South Korea.","The provided source summary mentions torrential rain during the tour kickoff (contextual detail from the signal\u2019s listed related headlines)."],"numeric_claims":[],"primary_claim":"Jin said BTS\u2019s first ARIRANG World Tour concert made him feel like he was \u201cback home.\u201d","relevance_score":0.35,"sentiment":"positive","source_quality":"high","summary":"Billboard reports that BTS member Jin reflected on the band\u2019s first concert of the ARIRANG World Tour, saying it felt like being \u201cback home.\u201d The near-term catalyst is the ARIRANG tour kickoff in South Korea, including a first-night performance at Goyang Stadium.","topics":["BTS","Jin","ARIRANG World Tour","concert kickoff","South Korea","Goyang Stadium","fan/press coverage"]},"source":"Billboard","source_domain":"billboard.com","source_url":"https://www.billboard.com","summary":"BTS\u2019 Jin Reflects on Band\u2019s First Concert of ARIRANG World Tour: \u2018I Feel Like I\u2019m Back Home\u2019 Billboard 'It's like a water park': BTS battle torrential rain as $1bn world tour kicks off BBC BTS\u2019 \u2018ARIRANG\u2019 Concert Setlist: Every Song From Night 1 at South Korea\u2019s Goyang Stadium Billboard BTS to kick off massive world tour in South Korea Reuters BTS Bring the Hits, Brave Torrents of Rain at Tour Kickoff Rolling Stone","title":"BTS\u2019 Jin Reflects on Band\u2019s First Concert of ARIRANG World Tour: \u2018I Feel Like I\u2019m Back Home\u2019 - Billboard","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_dafe667fdc57 in signals