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/CBMiuAFBVV95cUxPT1IzZ3FnRHpYYmJTYzNjclFaUmRHZE5NM1hfQk0wZEFRZDNOZHBZa2EtaTdWUzYyWkhMWWFELXQtVEM5WDZYM0ZTbUVCVzRMWUtIc1dSV2tMemh2UEMzWTdqM3lUM3IwQTRXLUpmM3NBZUdYeWYxdmZVV0FkZmdkcG50WkdTQjBCNW1qU0pzdnJVR1hWM291OGFrUTZsT25Vd2ZqR2g3YkdqUzBjV2FsbHJlOHYzVjJK0gG-AUFVX3lxTE1kblRBaEtZbHdXMEM3MWpmdVhBWDBMVmgxamI0ek13cWVRbDJrQ2xZLWF2SXJhMmJzSXVFMDZjbFlQU2pFQXI4dzNPZnVOVV9uV25CWWlKWGxheTNqYnlYZ2pjTEtfZEZRMnFZbjFnRHM0V2o2Y3JVOWYtSVdDbTRPdUJSZzVZOUhkcXZNbzR1ajE3Mzl5WmFNcTd2SGcyTzA5akhEN1NVYWVOdDF4b3NnYjNvZVRVejJiMi1TOHc?oc=5","as_of":"2026-04-08T08:07:06.518305+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/CBMiuAFBVV95cUxPT1IzZ3FnRHpYYmJTYzNjclFaUmRHZE5NM1hfQk0wZEFRZDNOZHBZa2EtaTdWUzYyWkhMWWFELXQtVEM5WDZYM0ZTbUVCVzRMWUtIc1dSV2tMemh2UEMzWTdqM3lUM3IwQTRXLUpmM3NBZUdYeWYxdmZVV0FkZmdkcG50WkdTQjBCNW1qU0pzdnJVR1hWM291OGFrUTZsT25Vd2ZqR2g3YkdqUzBjV2FsbHJlOHYzVjJK0gG-AUFVX3lxTE1kblRBaEtZbHdXMEM3MWpmdVhBWDBMVmgxamI0ek13cWVRbDJrQ2xZLWF2SXJhMmJzSXVFMDZjbFlQU2pFQXI4dzNPZnVOVV9uV25CWWlKWGxheTNqYnlYZ2pjTEtfZEZRMnFZbjFnRHM0V2o2Y3JVOWYtSVdDbTRPdUJSZzVZOUhkcXZNbzR1ajE3Mzl5WmFNcTd2SGcyTzA5akhEN1NVYWVOdDF4b3NnYjNvZVRVejJiMi1TOHc?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_55045eaa6a624748","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-08T08:07:37.194861+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiuAFBVV95cUxPT1IzZ3FnRHpYYmJTYzNjclFaUmRHZE5NM1hfQk0wZEFRZDNOZHBZa2EtaTdWUzYyWkhMWWFELXQtVEM5WDZYM0ZTbUVCVzRMWUtIc1dSV2tMemh2UEMzWTdqM3lUM3IwQTRXLUpmM3NBZUdYeWYxdmZVV0FkZmdkcG50WkdTQjBCNW1qU0pzdnJVR1hWM291OGFrUTZsT25Vd2ZqR2g3YkdqUzBjV2FsbHJlOHYzVjJK0gG-AUFVX3lxTE1kblRBaEtZbHdXMEM3MWpmdVhBWDBMVmgxamI0ek13cWVRbDJrQ2xZLWF2SXJhMmJzSXVFMDZjbFlQU2pFQXI4dzNPZnVOVV9uV25CWWlKWGxheTNqYnlYZ2pjTEtfZEZRMnFZbjFnRHM0V2o2Y3JVOWYtSVdDbTRPdUJSZzVZOUhkcXZNbzR1ajE3Mzl5WmFNcTd2SGcyTzA5akhEN1NVYWVOdDF4b3NnYjNvZVRVejJiMi1TOHc?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"foxnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiuAFBVV95cUxPT1IzZ3FnRHpYYmJTYzNjclFaUmRHZE5NM1hfQk0wZEFRZDNOZHBZa2EtaTdWUzYyWkhMWWFELXQtVEM5WDZYM0ZTbUVCVzRMWUtIc1dSV2tMemh2UEMzWTdqM3lUM3IwQTRXLUpmM3NBZUdYeWYxdmZVV0FkZmdkcG50WkdTQjBCNW1qU0pzdnJVR1hWM291OGFrUTZsT25Vd2ZqR2g3YkdqUzBjV2FsbHJlOHYzVjJK0gG-AUFVX3lxTE1kblRBaEtZbHdXMEM3MWpmdVhBWDBMVmgxamI0ek13cWVRbDJrQ2xZLWF2SXJhMmJzSXVFMDZjbFlQU2pFQXI4dzNPZnVOVV9uV25CWWlKWGxheTNqYnlYZ2pjTEtfZEZRMnFZbjFnRHM0V2o2Y3JVOWYtSVdDbTRPdUJSZzVZOUhkcXZNbzR1ajE3Mzl5WmFNcTd2SGcyTzA5akhEN1NVYWVOdDF4b3NnYjNvZVRVejJiMi1TOHc?oc=5","source_event_id":"evt_f24bb2c20e92","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"72bf65e078516a93","published_at":"2026-04-07T21:33:24+00:00","publisher_domain":"foxnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.45,"dates_mentioned":["April 6"],"entities":[{"asset_class":"space_mission","name":"Artemis II","relevance":"high","symbol":"","type":"space_mission"},{"asset_class":"astronomy","name":"Earth","relevance":"high","symbol":"","type":"planet"},{"asset_class":"astronomy","name":"Moon (far side)","relevance":"high","symbol":"","type":"astronomical_location"},{"asset_class":"politics","name":"Donald Trump","relevance":"medium","symbol":"","type":"person"},{"asset_class":"space_agency","name":"NASA","relevance":"medium","symbol":"","type":"organization"}],"event_type":"other","information_gaps":["The cleaned article text provided is not the actual Fox News article content (it appears to be page styling/CSS), so specific details about the photo, who took it, and when exactly it was unveiled are not verifiable from the supplied text.","The nature/content of Donald Trump\u2019s comments is not included in the provided material.","The April 6 timing is mentioned only in the source summary snippets; the exact relationship to the photo unveiling is not specified."],"key_facts":["A first-ever photo of Earth from the moon\u2019s far side has been unveiled (per the Fox News headline).","Artemis II is beginning its journey home (per the Fox News headline).","The headline states that Donald Trump is weighing in (details not provided in the provided text).","The provided source summary references an April 6 flyby and an attempt to recreate Apollo 8\u2019s 'Earthrise' photo (timing mentioned in the summary, not in the Fox headline itself)."],"numeric_claims":[],"primary_claim":"A first-ever photo of Earth from the moon\u2019s far side was unveiled as Artemis II begins its journey home.","relevance_score":0.55,"sentiment":"neutral","source_quality":"high","summary":"Fox News reports that a first-ever photo of Earth taken from the moon\u2019s far side has been unveiled, coinciding with Artemis II beginning its journey home. The headline also notes that Donald Trump is weighing in on the event.","topics":["space exploration","Artemis II","Earth imaging","moon far side","Earthrise comparison","public/political commentary"]},"source":"Fox News","source_domain":"foxnews.com","source_url":"https://www.foxnews.com","summary":"First-ever photo of Earth from moon\u2019s far side unveiled as Artemis II begins journey home, Trump weighs in Fox News 58 Years After \u2018Earthrise,\u2019 NASA\u2019s New Moonshot May Rediscover Earth The New York Times Earthrise to Earthset: how the planet\u2019s climate has changed since the photo that inspired the environmental movement The Conversation Artemis 2 moon astronauts will try to recreate Apollo 8's historic 'Earthrise' photo during April 6 flyby Space The Artemis II crew has a chance to recreate \u2018Earthrise,\u2019 one of the most famous photos of all time National Geographic","title":"First-ever photo of Earth from moon\u2019s far side unveiled as Artemis II begins journey home, Trump weighs in - Fox News","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_bfb3b2eff2e4 in signals