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/CBMif0FVX3lxTE5VemRudWR3ZGIzbmxfSklvcWhydjQ0aWxzM21aTnBIYTZCTFdZWGlrcFIyZkZ5QTZtUENnWlB4Ukhhanlsbm9Lb2hhOVVfOG5Ja1pac0lmbHJUUkI4eTNGdGlpSFdlRjc5YUVhVm9lVDZvMFlTR2EyZ2VkbUZPR0U?oc=5","as_of":"2026-04-10T19:36:11.922159+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/CBMif0FVX3lxTE5VemRudWR3ZGIzbmxfSklvcWhydjQ0aWxzM21aTnBIYTZCTFdZWGlrcFIyZkZ5QTZtUENnWlB4Ukhhanlsbm9Lb2hhOVVfOG5Ja1pac0lmbHJUUkI4eTNGdGlpSFdlRjc5YUVhVm9lVDZvMFlTR2EyZ2VkbUZPR0U?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_01143c8e29226f53","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-10T20:15:20.389502+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMif0FVX3lxTE5VemRudWR3ZGIzbmxfSklvcWhydjQ0aWxzM21aTnBIYTZCTFdZWGlrcFIyZkZ5QTZtUENnWlB4Ukhhanlsbm9Lb2hhOVVfOG5Ja1pac0lmbHJUUkI4eTNGdGlpSFdlRjc5YUVhVm9lVDZvMFlTR2EyZ2VkbUZPR0U?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"phys.org","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMif0FVX3lxTE5VemRudWR3ZGIzbmxfSklvcWhydjQ0aWxzM21aTnBIYTZCTFdZWGlrcFIyZkZ5QTZtUENnWlB4Ukhhanlsbm9Lb2hhOVVfOG5Ja1pac0lmbHJUUkI4eTNGdGlpSFdlRjc5YUVhVm9lVDZvMFlTR2EyZ2VkbUZPR0U?oc=5","source_event_id":"evt_1e395bdc93dc","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"41d945a1a6deb72d","published_at":"2026-04-10T16:40:01+00:00","publisher_domain":"phys.org","signal_understanding":{"analysis_basis":"article","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"natural_resource","name":"Yellowstone","relevance":"high","symbol":"","type":"geographic_feature"},{"asset_class":"media","name":"Phys.org","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"government_research","name":"USGS (U.S. Geological Survey)","relevance":"medium","symbol":"","type":"organization"},{"asset_class":"media","name":"Gizmodo","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"media","name":"Xinhua","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"media","name":"FOX Weather","relevance":"low","symbol":"","type":"publisher"}],"event_type":"research","information_gaps":["The cleaned article text provided appears to be mostly HTML/CSS and does not include the actual article content; therefore, specific study details (e.g., distance estimates, methods, authors, publication date, magnitude of hazard-model changes) are not extractable from the provided text.","The signal includes multiple other publishers (Gizmodo, Xinhua, FOX Weather) but no concrete cross-verified details are included in the provided content beyond the headline/source-summary snippets.","Near-term catalyst timing (e.g., when hazard models will be updated or when agencies will act) is not stated in the provided material."],"key_facts":["Phys.org headline states Yellowstone\u2019s magma source may be closer than thought and that this could reshape hazard models.","The provided source summary references multiple related reports/studies about Yellowstone\u2019s \u201chidden underground plumbing system\u201d and using electrical measurements to investigate hot spring plumbing systems.","USGS (.gov) is mentioned in the source summary as being involved in investigating Yellowstone\u2019s underground plumbing using electrical measurements."],"numeric_claims":[],"primary_claim":"A new study indicates Yellowstone\u2019s magma source may be closer than previously believed, reshaping volcanic hazard models.","relevance_score":0.72,"sentiment":"neutral","source_quality":"high","summary":"A Phys.org report says new research suggests Yellowstone\u2019s magma source is located closer to the surface than previously thought, which could change how scientists model volcanic hazards. The work implies updated hazard assessments may be needed, though the near-term timing of any policy or operational changes is not specified.","topics":["Yellowstone supervolcano","magma source location","volcanic hazard modeling","geothermal/hydrothermal plumbing","electrical measurements","USGS investigations"]},"source":"Phys.org","source_domain":"phys.org","source_url":"https://phys.org","summary":"Yellowstone's magma source may be closer than thought, reshaping hazard models Phys.org Yellowstone\u2019s Dreaded Supervolcano Has an Unexpected Power Source, Study Says Gizmodo New study reveals hidden forces behind Yellowstone supervolcano Xinhua The path of least resistance: Investigating hot spring plumbing systems in Yellowstone using electrical measurements USGS (.gov) Scientists use new methods to map Yellowstone's hidden underground plumbing system FOX Weather","title":"Yellowstone's magma source may be closer than thought, reshaping hazard models - Phys.org","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_0325e027ab1c in signals