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/CBMickFVX3lxTE5hbXFRRjlpYjRKaS1hNmRBYXJRMmpfQkJvclZaemFoMG5PZkU2QmRqb3prdGVKb2J2b2lqaE50YllrdDQtZ0hlOFR6N1hDS1dZMC1jaW1zUG9QSS05azlGdlRWZmN4cVZ4ZE5BazNYN0lDUQ?oc=5","as_of":"2026-04-09T23:49:35.029504+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/CBMickFVX3lxTE5hbXFRRjlpYjRKaS1hNmRBYXJRMmpfQkJvclZaemFoMG5PZkU2QmRqb3prdGVKb2J2b2lqaE50YllrdDQtZ0hlOFR6N1hDS1dZMC1jaW1zUG9QSS05azlGdlRWZmN4cVZ4ZE5BazNYN0lDUQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_15ada9dcd027a7f2","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:55:36.309368+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMickFVX3lxTE5hbXFRRjlpYjRKaS1hNmRBYXJRMmpfQkJvclZaemFoMG5PZkU2QmRqb3prdGVKb2J2b2lqaE50YllrdDQtZ0hlOFR6N1hDS1dZMC1jaW1zUG9QSS05azlGdlRWZmN4cVZ4ZE5BazNYN0lDUQ?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/CBMickFVX3lxTE5hbXFRRjlpYjRKaS1hNmRBYXJRMmpfQkJvclZaemFoMG5PZkU2QmRqb3prdGVKb2J2b2lqaE50YllrdDQtZ0hlOFR6N1hDS1dZMC1jaW1zUG9QSS05azlGdlRWZmN4cVZ4ZE5BazNYN0lDUQ?oc=5","source_event_id":"evt_f20acc5cafca","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"4e8807ed74087c18","published_at":"2026-04-09T17:00:03+00:00","publisher_domain":"phys.org","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"human_spaceflight","name":"Artemis II crew","relevance":"high","symbol":"","type":"people"},{"asset_class":"space_mission","name":"Artemis II","relevance":"high","symbol":"","type":"program"},{"asset_class":"media","name":"Phys.org","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The provided text does not include the specific survival mechanism details (e.g., heat shield material, capsule design, or procedures).","No re-entry date/time or exact splashdown timing is included in the provided excerpt.","The article\u2019s attribution (which hypersonics expert, and what specific claims they make) is not present in the provided content."],"key_facts":["The Phys.org headline states Artemis II crew will endure 3,000\u00b0C on re-entry.","The Phys.org piece includes an explanation from a hypersonics expert about how the crew will survive re-entry."],"numeric_claims":[{"label":"Re-entry temperature","value":"3,000\u00b0C"}],"primary_claim":"Artemis II crew will endure approximately 3,000\u00b0C during re-entry, and the article explains how they will survive.","relevance_score":0.62,"sentiment":"neutral","source_quality":"high","summary":"Phys.org reports that Artemis II\u2019s crew will face extreme heating\u2014about 3,000\u00b0C\u2014during Earth re-entry, and discusses how they will survive. The near-term catalyst is the upcoming re-entry/splashdown phase of the Artemis II mission.","topics":["spaceflight","re-entry heating","human survival","hypersonics","Artemis II","NASA re-entry"]},"source":"Phys.org","source_domain":"phys.org","source_url":"https://phys.org","summary":"Artemis II crew will endure 3,000\u00b0C on re\u2011entry. A hypersonics expert explains how they will survive Phys.org For Artemis II, Returning to Earth May Be the Most Dangerous Part of the Mission The New York Times Artemis II Flight Day 9: Crew Prepares to Come Home NASA (.gov) Can you see the Artemis II splash down off the California coast? cbs8.com Artemis II reentry: Will San Diego hear a sonic boom? fox5sandiego.com","title":"Artemis II crew will endure 3,000\u00b0C on re\u2011entry. A hypersonics expert explains how they will survive - 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_a77de0a7f60a in signals