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/CBMiiwFBVV95cUxOTmxaR1RGY1lwa1dnTE9oNy1hWjgwVkI0eE9IT3lVeE1XOWs1S1MyZzJuV29VTXlfMzZCVnluYmlydFM1c2VRZUQzcEtvaDQyRDFmVmt3ZGFrbVJ0OFZyUUV2Z19ndVgxT2FqRW8wVlFabmFPQmotTFdMU3JTOHhLTFJaLURaTXk5Tzlj?oc=5","as_of":"2026-04-08T19:34:52.188157+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/CBMiiwFBVV95cUxOTmxaR1RGY1lwa1dnTE9oNy1hWjgwVkI0eE9IT3lVeE1XOWs1S1MyZzJuV29VTXlfMzZCVnluYmlydFM1c2VRZUQzcEtvaDQyRDFmVmt3ZGFrbVJ0OFZyUUV2Z19ndVgxT2FqRW8wVlFabmFPQmotTFdMU3JTOHhLTFJaLURaTXk5Tzlj?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_869e18860dbdea1d","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-09T22:03:02.997599+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxOTmxaR1RGY1lwa1dnTE9oNy1hWjgwVkI0eE9IT3lVeE1XOWs1S1MyZzJuV29VTXlfMzZCVnluYmlydFM1c2VRZUQzcEtvaDQyRDFmVmt3ZGFrbVJ0OFZyUUV2Z19ndVgxT2FqRW8wVlFabmFPQmotTFdMU3JTOHhLTFJaLURaTXk5Tzlj?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/CBMiiwFBVV95cUxOTmxaR1RGY1lwa1dnTE9oNy1hWjgwVkI0eE9IT3lVeE1XOWs1S1MyZzJuV29VTXlfMzZCVnluYmlydFM1c2VRZUQzcEtvaDQyRDFmVmt3ZGFrbVJ0OFZyUUV2Z19ndVgxT2FqRW8wVlFabmFPQmotTFdMU3JTOHhLTFJaLURaTXk5Tzlj?oc=5","source_event_id":"evt_31f6cf37b79b","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"1e0c034e848a2cba","published_at":"2026-04-08T18:01:41+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"crypto/individual","name":"Adam Back","relevance":"high","symbol":"","type":"person"},{"asset_class":"crypto/individual","name":"Satoshi Nakamoto","relevance":"high","symbol":"","type":"person_or_alias"},{"asset_class":"equity/crypto infrastructure","name":"Blockstream","relevance":"medium","symbol":"","type":"company"},{"asset_class":"equity/crypto infrastructure","name":"Blockstream CEO (Adam Back)","relevance":"medium","symbol":"","type":"role"},{"asset_class":"media","name":"The New York Times","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The provided text does not include the specific evidence or methodology used by The New York Times to link Adam Back to Satoshi Nakamoto.","The provided text does not include Adam Back\u2019s detailed rebuttal content (e.g., statements, documents, or arguments).","No direct market/price reaction is included in the provided material, so near-term directional impact on Bitcoin is not grounded here."],"key_facts":["The New York Times published an investigation into whether Adam Back is Satoshi Nakamoto.","The investigation is described as tying the identity of Bitcoin founder Satoshi Nakamoto to Blockstream CEO Adam Back.","Adam Back denies he is Satoshi Nakamoto in response to the Times investigation."],"numeric_claims":[],"primary_claim":"Adam Back denies he is Satoshi Nakamoto in response to a New York Times investigation linking him to the Bitcoin founder identity.","relevance_score":0.55,"sentiment":"neutral","source_quality":"high","summary":"The New York Times reports that it investigated whether Bitcoin creator Satoshi Nakamoto is Adam Back, and Back publicly denies the claim. The investigation is described as tying Nakamoto identity to Blockstream CEO Adam Back.","topics":["Bitcoin founder identity","Satoshi Nakamoto","Adam Back denial","Blockstream CEO","media investigation"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Adam Back Denies He Is Satoshi Nakamoto in Response to Times Investigation The New York Times Latest investigation of Bitcoin founder ties identity to Blockstream CEO Adam Back CNBC 4 Takeaways From Our Search for Satoshi Nakamoto, Bitcoin\u2019s Creator The New York Times British computer scientist denies he is bitcoin developer Satoshi Nakamoto The Guardian Secret Billionaire May Have Had His Insane Wealth Exposed The Daily Beast","title":"Adam Back Denies He Is Satoshi Nakamoto in Response to Times Investigation - The New York Times","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_f7180b0ec03e in signals