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/CBMiowFBVV95cUxNaUZzOTFVcnNCU3l6ZXkxQVFyOGcyc29sbVBsNUd1ZXJfY3hjTW12OHVjaE1vM1B2Mm5sMk5ITWNrODBsZHRVUzJETThXS29BVm9EVFk1RkFQNWttYnpIVF9FWm1PRFJMajNncnhSdnB3UkI2NDJzMHFWZVNzYnNCSHV3TGthcktfbEh5ODNCcHFXYjdndUVpaWd1bzJNMDZiQlBr?oc=5","as_of":"2026-04-09T17:20:48.809402+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/CBMiowFBVV95cUxNaUZzOTFVcnNCU3l6ZXkxQVFyOGcyc29sbVBsNUd1ZXJfY3hjTW12OHVjaE1vM1B2Mm5sMk5ITWNrODBsZHRVUzJETThXS29BVm9EVFk1RkFQNWttYnpIVF9FWm1PRFJMajNncnhSdnB3UkI2NDJzMHFWZVNzYnNCSHV3TGthcktfbEh5ODNCcHFXYjdndUVpaWd1bzJNMDZiQlBr?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_dd7b38c3fd458deb","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:10:05.447000+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiowFBVV95cUxNaUZzOTFVcnNCU3l6ZXkxQVFyOGcyc29sbVBsNUd1ZXJfY3hjTW12OHVjaE1vM1B2Mm5sMk5ITWNrODBsZHRVUzJETThXS29BVm9EVFk1RkFQNWttYnpIVF9FWm1PRFJMajNncnhSdnB3UkI2NDJzMHFWZVNzYnNCSHV3TGthcktfbEh5ODNCcHFXYjdndUVpaWd1bzJNMDZiQlBr?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"salon.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiowFBVV95cUxNaUZzOTFVcnNCU3l6ZXkxQVFyOGcyc29sbVBsNUd1ZXJfY3hjTW12OHVjaE1vM1B2Mm5sMk5ITWNrODBsZHRVUzJETThXS29BVm9EVFk1RkFQNWttYnpIVF9FWm1PRFJMajNncnhSdnB3UkI2NDJzMHFWZVNzYnNCSHV3TGthcktfbEh5ODNCcHFXYjdndUVpaWd1bzJNMDZiQlBr?oc=5","source_event_id":"evt_9369649efc03","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c80121ddd1ed5873","published_at":"2026-04-09T10:30:45+00:00","publisher_domain":"salon.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.55,"dates_mentioned":["2030"],"entities":[{"asset_class":"other","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"China","relevance":"high","symbol":"","type":"country"},{"asset_class":"other","name":"NASA","relevance":"high","symbol":"","type":"organization"},{"asset_class":"other","name":"Artemis program","relevance":"high","symbol":"","type":"program"},{"asset_class":"other","name":"China\u2019s 2030 crewed landing goal","relevance":"high","symbol":"","type":"goal"},{"asset_class":"other","name":"Salon.com","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"other","name":"Scientific American","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"other","name":"Reuters","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"other","name":"EE Times","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"other","name":"Australian Broadcasting Corporation (ABC)","relevance":"low","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only page styling/HTML fragments and does not include the actual article body, so only the headline and the supplied source summary can be used.","No specific near-term catalyst timing (e.g., mission dates, policy announcements) is included in the provided content beyond the 2030 goal.","The claim that Trump\u2019s framing is \u201cabout dominance over China\u201d is attributed to Salon.com\u2019s interpretation, but the underlying evidence/quotes from the article are not present in the provided text."],"key_facts":["Salon.com headline frames Trump\u2019s lunar effort as dominance over China rather than discovery.","NASA\u2019s lunar success is described as sharpening focus on China\u2019s stated goal of a crewed landing by 2030 (per the provided source summary).","The provided summary states that NASA\u2019s Artemis program may be in the lead, but China could still win the \u201cnew moon race\u201d (per the provided source summary).","The provided summary references additional coverage on lunar initiatives and challenges (Scientific American, EE Times, ABC), but specific details are not included in the provided text."],"numeric_claims":[{"label":"China crewed landing target year","value":"2030"}],"primary_claim":"Salon.com contends that Trump\u2019s \u201crace to the moon\u201d is about dominance over China, not discovery.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"Salon.com argues that Trump\u2019s push for a lunar program is framed primarily as geopolitical dominance over China rather than scientific discovery. The broader discussion highlights NASA\u2019s Artemis progress and China\u2019s stated goal of a crewed lunar landing by 2030, implying near-term competition dynamics around lunar missions.","topics":["lunar exploration","space race","U.S.-China competition","Artemis","geopolitics","crewed lunar landing","policy framing"]},"source":"Salon.com","source_domain":"salon.com","source_url":"https://www.salon.com","summary":"Trump\u2019s race to the moon is about dominance over China, not discovery Salon.com NASA's lunar success sharpens focus on China's 2030 crewed landing goal Reuters NASA\u2019s Artemis program may be in the lead, but China could still win the new moon race Scientific American NASA Ignition Initiative: The Moon is Back on the Menu EE Times Mining on the Moon is closer than ever, but challenges remain Australian Broadcasting Corporation","title":"Trump\u2019s race to the moon is about dominance over China, not discovery - Salon.com","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_b300615ebb60 in signals