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/CBMihAFBVV95cUxNdjR2VWxDTzd4cE90RndyUndza2hmYVNkSExzRjIwVWxYRHdJMlZZb19DRWMwZ1RRUWJIak9IbWVzTTh0UkJaSUsxQlBNRE5HdlhrTUpCamNtRjl2cHBZNWdBcVhWZzY4dlVWa2l0RW5rR3JDUm1DWGQ4N21OZUpMUThDZEk?oc=5","as_of":"2026-04-20T17:59:52.170340+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.66Y3bu-8kXQ.L.X.O/am=GAIFAgCAA2YBAwpA/d=1/ed=1/rs=ALs0n2OvQgcBFbGEQHisaePTgNFsUePnGA/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxNdjR2VWxDTzd4cE90RndyUndza2hmYVNkSExzRjIwVWxYRHdJMlZZb19DRWMwZ1RRUWJIak9IbWVzTTh0UkJaSUsxQlBNRE5HdlhrTUpCamNtRjl2cHBZNWdBcVhWZzY4dlVWa2l0RW5rR3JDUm1DWGQ4N21OZUpMUThDZEk?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_2fe4b69ce5201c6e","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.66Y3bu-8kXQ.L.X.O/am=GAIFAgCAA2YBAwpA/d=1/ed=1/rs=ALs0n2OvQgcBFbGEQHisaePTgNFsUePnGA/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-20T18:28:43.489721+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxNdjR2VWxDTzd4cE90RndyUndza2hmYVNkSExzRjIwVWxYRHdJMlZZb19DRWMwZ1RRUWJIak9IbWVzTTh0UkJaSUsxQlBNRE5HdlhrTUpCamNtRjl2cHBZNWdBcVhWZzY4dlVWa2l0RW5rR3JDUm1DWGQ4N21OZUpMUThDZEk?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"japantimes.co.jp","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxNdjR2VWxDTzd4cE90RndyUndza2hmYVNkSExzRjIwVWxYRHdJMlZZb19DRWMwZ1RRUWJIak9IbWVzTTh0UkJaSUsxQlBNRE5HdlhrTUpCamNtRjl2cHBZNWdBcVhWZzY4dlVWa2l0RW5rR3JDUm1DWGQ4N21OZUpMUThDZEk?oc=5","source_event_id":"evt_ab0f31e65132","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"a789c1556edbb0fd","published_at":"2026-04-20T14:04:55+00:00","publisher_domain":"japantimes.co.jp","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.42,"dates_mentioned":[],"entities":[],"event_type":"other","information_gaps":["article_text_unavailable"],"key_facts":["Headline: Japan issues rare special advisory over chance of more powerful quake - The Japan Times","Source summary: Japan issues rare special advisory over chance of more powerful quake The Japan Times Risk of 'megaquake' in Japan higher after powerful earthquake strikes Scientific American M7.7 jolts northeastern Japan, tsunami advisories in effect Japan Wire by Kyodo News No tsunami threat to Hawaii after major Japan earthquake (updated) Yahoo Japan Issued A Megaquake Warning, But What Is It? The Weather Channel"],"numeric_claims":[],"primary_claim":"Japan issues rare special advisory over chance of more powerful quake - The Japan Times","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"Japan issues rare special advisory over chance of more powerful quake The Japan Times Risk of 'megaquake' in Japan higher after powerful earthquake strikes Scientific American M7.7 jolts northeastern Japan, tsunami advisories in effect Japan Wire by Kyodo News No tsunami threat to Hawaii after major Japan earthquake (updated) Yahoo Japan Issued A Megaquake Warning, But What Is It? The Weather Chan","topics":["news headline"]},"source":"The Japan Times","source_domain":"japantimes.co.jp","source_url":"https://www.japantimes.co.jp","summary":"Japan issues rare special advisory over chance of more powerful quake The Japan Times Risk of 'megaquake' in Japan higher after powerful earthquake strikes Scientific American M7.7 jolts northeastern Japan, tsunami advisories in effect Japan Wire by Kyodo News No tsunami threat to Hawaii after major Japan earthquake (updated) Yahoo Japan Issued A Megaquake Warning, But What Is It? The Weather Channel","title":"Japan issues rare special advisory over chance of more powerful quake - The Japan Times","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.66Y3bu-8kXQ.L.X.O/am=GAIFAgCAA2YBAwpA/d=1/ed=1/rs=ALs0n2OvQgcBFbGEQHisaePTgNFsUePnGA/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_2cf45645ee93 in signals