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/CBMizwFBVV95cUxNYUVzaGNCNE9oU3d3WHRSc0pqWkExSU9GMmw2WEYtUjc2bDhsT0ZwRHRlR0Ftc2gwTWlqWDE2MDlkRnRnUVZZOE5RYm9paVpCWXBxTVR5UnlKQjNnZ3pDX193bWpmS3hJd1ZCVmIzY3ZFZUh3VjNHNFlpUnRwUElaaHlQOGx2S3dQcXZLUUViRS1HMVh4VXIwVXJvRjB1ZTM5bmNWbnBETHEwX2t3bkdleGVTTnNXa3BPMVRBbzlLUXpLNUo0ZGVWRlBnRzRaYW8?oc=5","as_of":"2026-04-09T07:33:13.560563+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/CBMizwFBVV95cUxNYUVzaGNCNE9oU3d3WHRSc0pqWkExSU9GMmw2WEYtUjc2bDhsT0ZwRHRlR0Ftc2gwTWlqWDE2MDlkRnRnUVZZOE5RYm9paVpCWXBxTVR5UnlKQjNnZ3pDX193bWpmS3hJd1ZCVmIzY3ZFZUh3VjNHNFlpUnRwUElaaHlQOGx2S3dQcXZLUUViRS1HMVh4VXIwVXJvRjB1ZTM5bmNWbnBETHEwX2t3bkdleGVTTnNXa3BPMVRBbzlLUXpLNUo0ZGVWRlBnRzRaYW8?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9307597aed019d2e","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-09T22:51:09.964683+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMizwFBVV95cUxNYUVzaGNCNE9oU3d3WHRSc0pqWkExSU9GMmw2WEYtUjc2bDhsT0ZwRHRlR0Ftc2gwTWlqWDE2MDlkRnRnUVZZOE5RYm9paVpCWXBxTVR5UnlKQjNnZ3pDX193bWpmS3hJd1ZCVmIzY3ZFZUh3VjNHNFlpUnRwUElaaHlQOGx2S3dQcXZLUUViRS1HMVh4VXIwVXJvRjB1ZTM5bmNWbnBETHEwX2t3bkdleGVTTnNXa3BPMVRBbzlLUXpLNUo0ZGVWRlBnRzRaYW8?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"theconversation.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMizwFBVV95cUxNYUVzaGNCNE9oU3d3WHRSc0pqWkExSU9GMmw2WEYtUjc2bDhsT0ZwRHRlR0Ftc2gwTWlqWDE2MDlkRnRnUVZZOE5RYm9paVpCWXBxTVR5UnlKQjNnZ3pDX193bWpmS3hJd1ZCVmIzY3ZFZUh3VjNHNFlpUnRwUElaaHlQOGx2S3dQcXZLUUViRS1HMVh4VXIwVXJvRjB1ZTM5bmNWbnBETHEwX2t3bkdleGVTTnNXa3BPMVRBbzlLUXpLNUo0ZGVWRlBnRzRaYW8?oc=5","source_event_id":"evt_3d3deb16df93","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ba128f36241d1e61","published_at":"2026-04-09T04:40:32+00:00","publisher_domain":"theconversation.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":["Friday"],"entities":[{"asset_class":"space_mission","name":"Artemis II crew","relevance":"high","symbol":"","type":"group"},{"asset_class":"space_mission","name":"Artemis II","relevance":"high","symbol":"","type":"program"},{"asset_class":"media","name":"The Conversation","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"expert","name":"hypersonics expert (unnamed)","relevance":"medium","symbol":"","type":"person"}],"event_type":"geopolitical_risk","information_gaps":["The provided article text is not actually present (only CSS/HTML boilerplate), so survival details (e.g., specific thermal protection system, heat-shield performance, or procedures) cannot be extracted.","The exact date of \u201cFriday\u201d and the mission phase timing (re-entry vs splashdown) are not specified in the provided content.","No named hypersonics expert or specific technical mechanism is included in the provided excerpt beyond the headline claim."],"key_facts":["The headline states Artemis II crew will endure 3,000\u00b0C on re-entry.","The headline states a hypersonics expert explains how the crew will survive.","The source summary indicates Artemis II is preparing to end the mission with splashdown on Friday."],"numeric_claims":[{"label":"Re-entry temperature (\u00b0C)","value":"3000"}],"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":"The Conversation article says the Artemis II crew will experience extreme heating\u2014about 3,000\u00b0C\u2014during re-entry, and discusses mechanisms for how they will survive. The near-term catalyst is the Artemis II return/splashdown on Friday.","topics":["spaceflight","re-entry heating","thermal protection","human survival","hypersonics","Artemis II return"]},"source":"The Conversation","source_domain":"theconversation.com","source_url":"https://theconversation.com","summary":"Artemis II crew will endure 3,000\u00b0C on re-entry. A hypersonics expert explains how they will survive The Conversation Artemis II crew reflects on historic mission before splashdown on Friday BBC Solar Eclipse of the Heart NASA (.gov) NASA Artemis II astronauts prepare to end moon mission in 'fireball' re-entry Reuters Artemis II astronauts reflect on record journey before return Yahoo","title":"Artemis II crew will endure 3,000\u00b0C on re-entry. A hypersonics expert explains how they will survive - The Conversation","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_9cb6ec6466cf in signals