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-10T11:36:23.096067+00:00","dedupe_key":"signal_enriched:news_delta:86a13610ec03c102","evidence_event_ids":["evt_19eed8e01098"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMifkFVX3lxTE14UWNXTFMybTJEZVJqcG1oa3BMSk1nMF8zNUs1bzc5VmotbUNxTW5BQ1cxODhMNVJzc3ROamt3MlJLRmJfUThxUnJNYS1YNjdDdmExNDFBSEM5WTBkT3hyNW9BNlJvaEdtY29aZXN2NmZQMDMyWGxhczVPcjZOUQ?oc=5","as_of":"2026-04-10T11:36:23.096067+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/CBMifkFVX3lxTE14UWNXTFMybTJEZVJqcG1oa3BMSk1nMF8zNUs1bzc5VmotbUNxTW5BQ1cxODhMNVJzc3ROamt3MlJLRmJfUThxUnJNYS1YNjdDdmExNDFBSEM5WTBkT3hyNW9BNlJvaEdtY29aZXN2NmZQMDMyWGxhczVPcjZOUQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_31335c037c3cb3d5","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-10T11:37:51.040642+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMifkFVX3lxTE14UWNXTFMybTJEZVJqcG1oa3BMSk1nMF8zNUs1bzc5VmotbUNxTW5BQ1cxODhMNVJzc3ROamt3MlJLRmJfUThxUnJNYS1YNjdDdmExNDFBSEM5WTBkT3hyNW9BNlJvaEdtY29aZXN2NmZQMDMyWGxhczVPcjZOUQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"indiandefencereview.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMifkFVX3lxTE14UWNXTFMybTJEZVJqcG1oa3BMSk1nMF8zNUs1bzc5VmotbUNxTW5BQ1cxODhMNVJzc3ROamt3MlJLRmJfUThxUnJNYS1YNjdDdmExNDFBSEM5WTBkT3hyNW9BNlJvaEdtY29aZXN2NmZQMDMyWGxhczVPcjZOUQ?oc=5","source_event_id":"evt_19eed8e01098","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c3e904b4cf92dbed","published_at":"2026-04-09T23:21:21+00:00","publisher_domain":"indiandefencereview.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"n/a","name":"Mammal ancestors (proto-mammals)","relevance":"central to the claim","symbol":"","type":"biological group"},{"asset_class":"n/a","name":"250-million-year-old fossil egg","relevance":"evidence cited for the claim","symbol":"","type":"fossil specimen"},{"asset_class":"n/a","name":"Paleontologists/scientists","relevance":"reported as finding/confirming the evidence","symbol":"","type":"research community"},{"asset_class":"n/a","name":"Indian Defence Review","relevance":"source of the headline signal","symbol":"","type":"publisher"},{"asset_class":"n/a","name":"Phys.org","relevance":"linked/mentioned in source summary","symbol":"","type":"publisher"},{"asset_class":"n/a","name":"Popular Science","relevance":"linked/mentioned in source summary","symbol":"","type":"publisher"},{"asset_class":"n/a","name":"The Times","relevance":"linked/mentioned in source summary","symbol":"","type":"publisher"},{"asset_class":"n/a","name":"Interesting Engineering","relevance":"linked/mentioned in source summary","symbol":"","type":"publisher"}],"event_type":"research","information_gaps":["The cleaned article text provided contains only page styling/HTML/CSS and does not include the actual scientific details (e.g., species, location, depositional context, imaging/diagnostics).","No peer-reviewed paper citation, author names, journal, or DOI are included in the provided content.","The exact nature of the \u201cfossil egg\u201d (e.g., morphology, classification criteria, whether it is definitively attributable to proto-mammals vs. other synapsids) is not specified in the provided text.","No near-term catalyst timing is indicated (this appears to be a research discovery rather than an event with immediate operational timing)."],"key_facts":["The headline claims a 250-million-year-old fossil confirms mammal ancestors laid eggs.","The headline frames this as solving a long-standing mystery about mammal ancestor reproduction.","The source summary indicates scientists/paleontologists are described as \u201cthrilled\u201d about the egg finding."],"numeric_claims":[{"label":"fossil age","value":"250 million years"}],"primary_claim":"A 250-million-year-old fossil confirms that mammal ancestors laid eggs.","relevance_score":0.35,"sentiment":"positive","source_quality":"high","summary":"A reported 250-million-year-old fossil egg is said to confirm that mammal ancestors laid eggs, resolving a long-standing question about early mammal reproduction. The signal is a science/paleontology discovery with no direct market or policy implications.","topics":["paleontology","mammal evolution","fossil evidence","reproduction","proto-mammals","science discovery"]},"source":"Indian Defence Review","source_domain":"indiandefencereview.com","source_url":"https://indiandefencereview.com","summary":"250-Million-Year-Old Fossil Confirms That Mammal Ancestors Laid Eggs, Solving a Long-Standing Mystery Indian Defence Review Scientists \u2018thrilled\u2019 to find egg laid by our distant ancestors The Times Mammal ancestors laid eggs\u2014and this 250-million-year-old fossil proves it Phys.org Proto-mammals laid eggs, paleontologists finally confirm Popular Science Paleontologists identify 250-million-year-old fossil egg of mammal ancestor Interesting Engineering","title":"250-Million-Year-Old Fossil Confirms That Mammal Ancestors Laid Eggs, Solving a Long-Standing Mystery - Indian Defence Review","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 15982 in events