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/CBMiuAFBVV95cUxOSmpZNmZRLVRPOTVXWWdQWmJoS3YyOHZ4TXdQc0xYTlZQel9DQUxzbXpKTGY3YTN6REhXTEZCajlQakpDVnQ1d2NvcXVzLWRQRll5Y2pROTBnVzBUeFl1dk40T3lydk1VLW9UQ21nZTgxNG1Pd0JtZ191ek9zc1lTNVlCb3FDbXFIVVJWdWtlM1J2RFRWeVNRTWNRTmF5LVJITlJYVllYa3RNSHB6cExiMFlpVkdVd09i?oc=5","as_of":"2026-04-10T06:33:29.354488+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/CBMiuAFBVV95cUxOSmpZNmZRLVRPOTVXWWdQWmJoS3YyOHZ4TXdQc0xYTlZQel9DQUxzbXpKTGY3YTN6REhXTEZCajlQakpDVnQ1d2NvcXVzLWRQRll5Y2pROTBnVzBUeFl1dk40T3lydk1VLW9UQ21nZTgxNG1Pd0JtZ191ek9zc1lTNVlCb3FDbXFIVVJWdWtlM1J2RFRWeVNRTWNRTmF5LVJITlJYVllYa3RNSHB6cExiMFlpVkdVd09i?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_7226b4e28dd36237","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-10T06:34:33.095148+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiuAFBVV95cUxOSmpZNmZRLVRPOTVXWWdQWmJoS3YyOHZ4TXdQc0xYTlZQel9DQUxzbXpKTGY3YTN6REhXTEZCajlQakpDVnQ1d2NvcXVzLWRQRll5Y2pROTBnVzBUeFl1dk40T3lydk1VLW9UQ21nZTgxNG1Pd0JtZ191ek9zc1lTNVlCb3FDbXFIVVJWdWtlM1J2RFRWeVNRTWNRTmF5LVJITlJYVllYa3RNSHB6cExiMFlpVkdVd09i?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"politico.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiuAFBVV95cUxOSmpZNmZRLVRPOTVXWWdQWmJoS3YyOHZ4TXdQc0xYTlZQel9DQUxzbXpKTGY3YTN6REhXTEZCajlQakpDVnQ1d2NvcXVzLWRQRll5Y2pROTBnVzBUeFl1dk40T3lydk1VLW9UQ21nZTgxNG1Pd0JtZ191ek9zc1lTNVlCb3FDbXFIVVJWdWtlM1J2RFRWeVNRTWNRTmF5LVJITlJYVllYa3RNSHB6cExiMFlpVkdVd09i?oc=5","source_event_id":"evt_9ad1efb87bb5","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"50592e3959414903","published_at":"2026-04-10T01:00:00+00:00","publisher_domain":"politico.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["July"],"entities":[{"asset_class":"public_service","name":"United States Postal Service (USPS)","relevance":"high","symbol":"","type":"organization"},{"asset_class":"liability","name":"USPS pension plan","relevance":"high","symbol":"","type":"pension_plan"},{"asset_class":"postal_service_product","name":"First-class mail stamps","relevance":"high","symbol":"","type":"product"}],"event_type":"supply_disruption","information_gaps":["The cleaned article text provided is not usable for extracting additional details beyond the headline/source summary; specific dates (exact day in July) and the formal approval process/timeline are not included in the provided text.","Whether the pension contribution suspension is temporary or for how long is not specified in the provided content.","The exact mechanism USPS is using to seek the stamp price hike (e.g., regulatory filing) is not detailed in the provided text."],"key_facts":["Politico reports USPS will suspend pension contributions.","USPS is seeking a 4-cent increase in the price of first-class mail stamps.","The proposed first-class stamp price would be 82 cents in July.","Multiple source summaries indicate USPS is cash-strapped and is delaying pension contributions to avoid running out of cash (timing/cause described as liquidity/cash management)."],"numeric_claims":[{"label":"Stamp price increase (cents)","value":"4"},{"label":"Proposed first-class stamp price (cents)","value":"82"},{"label":"Proposed timing for stamp price (month)","value":"July"}],"primary_claim":"USPS plans to suspend pension contributions and is seeking a 4-cent increase in the first-class stamp price to 82 cents in July.","relevance_score":0.86,"sentiment":"mixed","source_quality":"high","summary":"USPS is taking cash-conservation steps by suspending pension contributions and is seeking a first-class stamp price increase. The proposed increase would raise the 1st-class stamp price to 82 cents in July.","topics":["USPS cash conservation","pension contributions suspension","stamp price hike","postal pricing","liquidity risk"]},"source":"Politico","source_domain":"politico.com","source_url":"https://www.politico.com","summary":"USPS to suspend pension contributions, seeks 4-cent stamp price hike Politico USPS suspends contributions to pension plan to delay running out of cash Federal News Network Cash-strapped US Postal Service suspends contributions to pension plan Reuters USPS begins cash conservation plan USPS U.S. Postal Service seeks hike in price of first-class mail stamps to 82 cents in July CNBC","title":"USPS to suspend pension contributions, seeks 4-cent stamp price hike - Politico","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_a153da8fc020 in signals