SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-08T08:07:06.518305+00:00","dedupe_key":"signal_enriched:news_delta:0572e256007841d7","evidence_event_ids":["evt_f24bb2c20e92"],"signal_type":"news_headline_delta","source":"news_rss","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 5337 in events