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/CBMijAFBVV95cUxNVkpwTUstOWlTYjEzVTlsVWNLd1ZKRGdzRXhmSmFZb3NBUWlXaHp3UVlSRmlibF9GcEVJUXVkYklBVldkNnRjRGhnaTIxV19lWm5tY1ZSYXl6QUJiTjhKT3ZwRjZGQ05yTDJNdjRvTUdxNjZucEU0dDJwNkhwLTRVQ2RHaUd5cDBRYWlPbNIBkgFBVV95cUxOX0FxOC1QZXExV0tzcjRBQ2pOSXF3bDM1MnlORWhPaVFjN2RvRE1Ob3V2OC1MTmhTYlBJRnlreVRpazlWc05QRzRDZTgtUm5VU3Z5MUdtaUhPMFY3WFVfN0ltOXJYSHFQSzVfUXhleklxU1U1MWhCZ3l1X29wdmk5Z3d2WjdPMkxuTGVoQWRIc3dJdw?oc=5","as_of":"2026-04-10T19:36:11.831704+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/CBMijAFBVV95cUxNVkpwTUstOWlTYjEzVTlsVWNLd1ZKRGdzRXhmSmFZb3NBUWlXaHp3UVlSRmlibF9GcEVJUXVkYklBVldkNnRjRGhnaTIxV19lWm5tY1ZSYXl6QUJiTjhKT3ZwRjZGQ05yTDJNdjRvTUdxNjZucEU0dDJwNkhwLTRVQ2RHaUd5cDBRYWlPbNIBkgFBVV95cUxOX0FxOC1QZXExV0tzcjRBQ2pOSXF3bDM1MnlORWhPaVFjN2RvRE1Ob3V2OC1MTmhTYlBJRnlreVRpazlWc05QRzRDZTgtUm5VU3Z5MUdtaUhPMFY3WFVfN0ltOXJYSHFQSzVfUXhleklxU1U1MWhCZ3l1X29wdmk5Z3d2WjdPMkxuTGVoQWRIc3dJdw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_df2d600919e4a926","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-10T20:00:10.010922+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMijAFBVV95cUxNVkpwTUstOWlTYjEzVTlsVWNLd1ZKRGdzRXhmSmFZb3NBUWlXaHp3UVlSRmlibF9GcEVJUXVkYklBVldkNnRjRGhnaTIxV19lWm5tY1ZSYXl6QUJiTjhKT3ZwRjZGQ05yTDJNdjRvTUdxNjZucEU0dDJwNkhwLTRVQ2RHaUd5cDBRYWlPbNIBkgFBVV95cUxOX0FxOC1QZXExV0tzcjRBQ2pOSXF3bDM1MnlORWhPaVFjN2RvRE1Ob3V2OC1MTmhTYlBJRnlreVRpazlWc05QRzRDZTgtUm5VU3Z5MUdtaUhPMFY3WFVfN0ltOXJYSHFQSzVfUXhleklxU1U1MWhCZ3l1X29wdmk5Z3d2WjdPMkxuTGVoQWRIc3dJdw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cbsnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMijAFBVV95cUxNVkpwTUstOWlTYjEzVTlsVWNLd1ZKRGdzRXhmSmFZb3NBUWlXaHp3UVlSRmlibF9GcEVJUXVkYklBVldkNnRjRGhnaTIxV19lWm5tY1ZSYXl6QUJiTjhKT3ZwRjZGQ05yTDJNdjRvTUdxNjZucEU0dDJwNkhwLTRVQ2RHaUd5cDBRYWlPbNIBkgFBVV95cUxOX0FxOC1QZXExV0tzcjRBQ2pOSXF3bDM1MnlORWhPaVFjN2RvRE1Ob3V2OC1MTmhTYlBJRnlreVRpazlWc05QRzRDZTgtUm5VU3Z5MUdtaUhPMFY3WFVfN0ltOXJYSHFQSzVfUXhleklxU1U1MWhCZ3l1X29wdmk5Z3d2WjdPMkxuTGVoQWRIc3dJdw?oc=5","source_event_id":"evt_4ce64c89ee9f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"1944942fd40f75b4","published_at":"2026-04-10T18:20:00+00:00","publisher_domain":"cbsnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Trump officials","relevance":"primary_actor","symbol":"","type":"organization_or_government_body"},{"asset_class":"","name":"Donald Trump","relevance":"political_figure_associated","symbol":"","type":"person"},{"asset_class":"real_estate/landmark","name":"Lincoln Memorial","relevance":"comparison_reference","symbol":"","type":"landmark"},{"asset_class":"geography","name":"Washington, D.C.","relevance":"project_location","symbol":"","type":"location"},{"asset_class":"","name":"CBS News","relevance":"source","symbol":"","type":"media_outlet"}],"event_type":"other","information_gaps":["The provided text does not include the specific date of the design release/unveiling.","No details are provided here on location within D.C., funding, timeline for construction, or permitting status.","No specifics are provided on what makes the arch 'controversial' (e.g., legal, aesthetic, environmental, or political objections).","The exact basis for 'dwarfing' the Lincoln Memorial (e.g., which dimension is compared) is not included in the provided content."],"key_facts":["A proposed arch in Washington, D.C. is described as being 250 feet tall.","The new plans/renderings are described as showing the arch would dwarf the Lincoln Memorial.","CBS News reports officials released design plans for the arch.","The project is associated with Trump seeking another imprint/imprint in Washington, D.C."],"numeric_claims":[{"label":"arch_height_feet","value":"250"}],"primary_claim":"Trump officials have unveiled new plans/designs for a proposed 250-foot arch in Washington, D.C. that would be larger than the Lincoln Memorial.","relevance_score":0.42,"sentiment":"mixed","source_quality":"high","summary":"CBS News reports that Trump officials have released new design plans for a proposed 250-foot arch in Washington, D.C., described as dwarfing the Lincoln Memorial. The near-term catalyst is the public unveiling of renderings/designs, which may shape subsequent planning and political debate.","topics":["infrastructure","public works","Washington, D.C.","politics","monument design","public architecture","controversy"]},"source":"CBS News","source_domain":"cbsnews.com","source_url":"https://www.cbsnews.com","summary":"Planned Trump arch would dwarf Lincoln Memorial, new plans show CBS News Officials Release Design for 250-Foot Arch in Washington, as Trump Seeks Another Imprint The New York Times Trump officials unveil designs for president\u2019s controversial 250-foot arch The Washington Post Trump Wants To Build An Arch In D.C.\u2014Here\u2019s What It Would Look Like Forbes Renderings revealed for Trump\u2019s 250-foot Triumphal Arch FOX 5 DC","title":"Planned Trump arch would dwarf Lincoln Memorial, new plans show - CBS 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

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_5b91cb322f3c in signals