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/CBMiiwFBVV95cUxNOV9xUGV2UGlLRm4xNDJlTDRSaDZjSW9VYUZubGZUWEdTMHRLMHRZVGZLVXdDUW9sYUUtR2xOS215ZUVMSUVJdmdkTXlHcEZNa1FVaFVBV2RzdHNNY3JoRTMxYTgyOV9VT2V1WEtNZGpGSlROeV9Zam44UzVoX1pmNTBxN0txZzRRMXow?oc=5","as_of":"2026-04-06T17:07:35.154484+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxNOV9xUGV2UGlLRm4xNDJlTDRSaDZjSW9VYUZubGZUWEdTMHRLMHRZVGZLVXdDUW9sYUUtR2xOS215ZUVMSUVJdmdkTXlHcEZNa1FVaFVBV2RzdHNNY3JoRTMxYTgyOV9VT2V1WEtNZGpGSlROeV9Zam44UzVoX1pmNTBxN0txZzRRMXow?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_6319b05c9720b1ec","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-06T17:11:25.555349+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxNOV9xUGV2UGlLRm4xNDJlTDRSaDZjSW9VYUZubGZUWEdTMHRLMHRZVGZLVXdDUW9sYUUtR2xOS215ZUVMSUVJdmdkTXlHcEZNa1FVaFVBV2RzdHNNY3JoRTMxYTgyOV9VT2V1WEtNZGpGSlROeV9Zam44UzVoX1pmNTBxN0txZzRRMXow?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxNOV9xUGV2UGlLRm4xNDJlTDRSaDZjSW9VYUZubGZUWEdTMHRLMHRZVGZLVXdDUW9sYUUtR2xOS215ZUVMSUVJdmdkTXlHcEZNa1FVaFVBV2RzdHNNY3JoRTMxYTgyOV9VT2V1WEtNZGpGSlROeV9Zam44UzVoX1pmNTBxN0txZzRRMXow?oc=5","source_event_id":"evt_a3e24656d4b3","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"81e2f28f9edca724","published_at":"2026-04-06T15:00:12+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.95,"dates_mentioned":[],"entities":[{"asset_class":"healthcare","name":"Federal Agency","relevance":"high","symbol":"","type":"government"},{"asset_class":"healthcare","name":"Duke Health","relevance":"high","symbol":"","type":"institution"},{"asset_class":"healthcare","name":"University of Colorado Boulder","relevance":"high","symbol":"","type":"institution"},{"asset_class":"healthcare","name":"Stanford University","relevance":"high","symbol":"","type":"institution"}],"event_type":"research","information_gaps":["Specific details on the treatments are not provided.","Timing for availability of treatments is unclear."],"key_facts":["Three treatments for osteoarthritis have been developed.","Research indicates potential for reversing osteoarthritis within weeks.","Studies from Duke Health and Stanford University highlight advancements in joint cartilage regrowth."],"numeric_claims":[],"primary_claim":"Three potential osteoarthritis treatments have been unveiled by a federal agency.","relevance_score":0.9,"sentiment":"positive","source_quality":"high","summary":"A federal agency has announced three potential treatments for osteoarthritis, which could significantly improve joint repair for millions affected by the condition.","topics":["healthcare","osteoarthritis","medical research"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Federal Agency Unveils Three Potential Osteoarthritis Treatments The New York Times New Research Brings Joint Repair Closer for Millions With Osteoarthritis Duke Health A simple shot shows promise to reverse osteoarthritis within weeks University of Colorado Boulder Stunning Stanford study finds way to regrow joint cartilage. Could it mean an end to osteoarthritis? KTVU Goodbye, knee pain. In a medical first, scientists have found a way to regrow damaged cartilage. Yahoo News Canada","title":"Federal Agency Unveils Three Potential Osteoarthritis Treatments - The New York Times","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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_d7338138d90d in signals