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/CBMieEFVX3lxTE00bkJUMTlxdkJsYkRnZFJGa1VPWnZLcmhIYVlaWTdTd1ZNQkgwTk1PWExDeF9QMEZQNk1xZDNEWXo4Y2xUTFFoVHQ1RlllZXJBbUkxRk1yVE9seVFLX2JyR3ZqRklpV0NaTDVxZDFFNFZfeVdXR1lYWQ?oc=5","as_of":"2026-04-08T04:49:08.435128+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/CBMieEFVX3lxTE00bkJUMTlxdkJsYkRnZFJGa1VPWnZLcmhIYVlaWTdTd1ZNQkgwTk1PWExDeF9QMEZQNk1xZDNEWXo4Y2xUTFFoVHQ1RlllZXJBbUkxRk1yVE9seVFLX2JyR3ZqRklpV0NaTDVxZDFFNFZfeVdXR1lYWQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_0e71247df7f16bfb","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-08T04:49:38.709952+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMieEFVX3lxTE00bkJUMTlxdkJsYkRnZFJGa1VPWnZLcmhIYVlaWTdTd1ZNQkgwTk1PWExDeF9QMEZQNk1xZDNEWXo4Y2xUTFFoVHQ1RlllZXJBbUkxRk1yVE9seVFLX2JyR3ZqRklpV0NaTDVxZDFFNFZfeVdXR1lYWQ?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/CBMieEFVX3lxTE00bkJUMTlxdkJsYkRnZFJGa1VPWnZLcmhIYVlaWTdTd1ZNQkgwTk1PWExDeF9QMEZQNk1xZDNEWXo4Y2xUTFFoVHQ1RlllZXJBbUkxRk1yVE9seVFLX2JyR3ZqRklpV0NaTDVxZDFFNFZfeVdXR1lYWQ?oc=5","source_event_id":"evt_5c239c5315fe","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"2fa17a985cc221ca","published_at":"2026-04-07T23:10:16+00:00","publisher_domain":"phys.org","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"\u201cOldest octopus\u201d fossil","relevance":"central subject of the claim","symbol":"","type":"fossil specimen"},{"asset_class":"other","name":"Octopus","relevance":"the incorrect identification being challenged","symbol":"","type":"taxon"},{"asset_class":"other","name":"Phys.org","relevance":"source of the headline signal","symbol":"","type":"publisher"},{"asset_class":"other","name":"ScienceDaily","relevance":"reported similar conclusion in the provided source summary","symbol":"","type":"publisher"},{"asset_class":"other","name":"Science News","relevance":"reported similar conclusion in the provided source summary","symbol":"","type":"publisher"},{"asset_class":"other","name":"Nautilus","relevance":"reported similar conclusion in the provided source summary","symbol":"","type":"publisher"},{"asset_class":"other","name":"The Times","relevance":"reported similar conclusion in the provided source summary","symbol":"","type":"publisher"}],"event_type":"research","information_gaps":["The cleaned article text provided is not usable for extracting specific technical details (e.g., which imaging modality, what anatomical features, or the alternative taxon).","No explicit age/date of the fossil is included in the provided signal content.","The exact alternative animal group/species is not stated in the provided text; only that it is \u201cprobably another animal.\u201d","No study authors, journal name, or publication date are included in the provided signal content."],"key_facts":["A fossil previously described as the \u201coldest octopus\u201d is reported to be misidentified.","The misidentification is attributed to scans/reanalysis (e.g., imaging) revealing it is likely another animal rather than an octopus.","The fossil\u2019s \u201coldest octopus\u201d title is reported to be withdrawn/invalidated based on the new evidence."],"numeric_claims":[],"primary_claim":"Scans reveal the fossil previously called the world\u2019s \u201coldest octopus\u201d is probably not an octopus at all.","relevance_score":0.35,"sentiment":"mixed","source_quality":"high","summary":"Multiple science outlets report that the fossil previously promoted as the \u201coldest octopus\u201d is not actually an octopus. CT/scans and reanalysis suggest it belongs to another animal group, stripping the fossil of its \u201coctopus\u201d title.","topics":["paleontology","cephalopods","fossil identification","imaging/CT scans","scientific reclassification"]},"source":"Phys.org","source_domain":"phys.org","source_url":"https://phys.org","summary":"'Oldest octopus' fossil is no octopus at all, scans reveal Phys.org The \u2018oldest fossil octopus\u2019 is probably another animal Science News The world\u2019s \u201coldest octopus\u201d was never an octopus ScienceDaily This Record-Breaking Octopus Fossil Isn\u2019t an Octopus After All Nautilus | Science So long, sucker: world\u2019s \u2018oldest octopus\u2019 is stripped of its title The Times","title":"'Oldest octopus' fossil is no octopus at all, scans reveal - 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_604c6ef20b6b in signals