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/CBMirgFBVV95cUxPdjhtODNfWlJNNW1kNkJoZkg2U3R0MEZVRnNEU3pnVWtaTFdyME1Zd2tIcE45WEE2Y0hNSWt3RUdhZkVzeXNpckhaVWg0a1Nmc2hEYm1HVzlabl9GSmpPblBJZFgyMk4tcjNhUDNKa1g2VHY2SmRVVGxzZy1rN1p0dHh2RnJKWjEzLVhBTXY4LUFmU2kyOGdEWDNDMTgzVUVlTEREajcyc1lhV2tQWmfSAa4BQVVfeXFMTUZ6S3BFZmJLTXNpNHRCS2pjOE1EbF9HeTdieC02WFVzd2s2eXdxbG5lZS1zVnEtdVdWZHZfb3BjYmVqQXlxbEtobk1KU0dyMmtQakFzTE5TTDNCaVZqM1lhSU5QMzdJLV9uTHU4eVNBR0lrNm9vSFFZa001NnhmdzVESFNzRE9YWFdUSlllTjRjcUVsV25fM2I5eU51OTRQcnN2N3lHbmFCSzNBZ2hR?oc=5","as_of":"2026-04-09T18:49:36.688123+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/CBMirgFBVV95cUxPdjhtODNfWlJNNW1kNkJoZkg2U3R0MEZVRnNEU3pnVWtaTFdyME1Zd2tIcE45WEE2Y0hNSWt3RUdhZkVzeXNpckhaVWg0a1Nmc2hEYm1HVzlabl9GSmpPblBJZFgyMk4tcjNhUDNKa1g2VHY2SmRVVGxzZy1rN1p0dHh2RnJKWjEzLVhBTXY4LUFmU2kyOGdEWDNDMTgzVUVlTEREajcyc1lhV2tQWmfSAa4BQVVfeXFMTUZ6S3BFZmJLTXNpNHRCS2pjOE1EbF9HeTdieC02WFVzd2s2eXdxbG5lZS1zVnEtdVdWZHZfb3BjYmVqQXlxbEtobk1KU0dyMmtQakFzTE5TTDNCaVZqM1lhSU5QMzdJLV9uTHU4eVNBR0lrNm9vSFFZa001NnhmdzVESFNzRE9YWFdUSlllTjRjcUVsV25fM2I5eU51OTRQcnN2N3lHbmFCSzNBZ2hR?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_984c8486b6b0ecc2","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-10T00:18:59.717833+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMirgFBVV95cUxPdjhtODNfWlJNNW1kNkJoZkg2U3R0MEZVRnNEU3pnVWtaTFdyME1Zd2tIcE45WEE2Y0hNSWt3RUdhZkVzeXNpckhaVWg0a1Nmc2hEYm1HVzlabl9GSmpPblBJZFgyMk4tcjNhUDNKa1g2VHY2SmRVVGxzZy1rN1p0dHh2RnJKWjEzLVhBTXY4LUFmU2kyOGdEWDNDMTgzVUVlTEREajcyc1lhV2tQWmfSAa4BQVVfeXFMTUZ6S3BFZmJLTXNpNHRCS2pjOE1EbF9HeTdieC02WFVzd2s2eXdxbG5lZS1zVnEtdVdWZHZfb3BjYmVqQXlxbEtobk1KU0dyMmtQakFzTE5TTDNCaVZqM1lhSU5QMzdJLV9uTHU4eVNBR0lrNm9vSFFZa001NnhmdzVESFNzRE9YWFdUSlllTjRjcUVsV25fM2I5eU51OTRQcnN2N3lHbmFCSzNBZ2hR?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"dw.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMirgFBVV95cUxPdjhtODNfWlJNNW1kNkJoZkg2U3R0MEZVRnNEU3pnVWtaTFdyME1Zd2tIcE45WEE2Y0hNSWt3RUdhZkVzeXNpckhaVWg0a1Nmc2hEYm1HVzlabl9GSmpPblBJZFgyMk4tcjNhUDNKa1g2VHY2SmRVVGxzZy1rN1p0dHh2RnJKWjEzLVhBTXY4LUFmU2kyOGdEWDNDMTgzVUVlTEREajcyc1lhV2tQWmfSAa4BQVVfeXFMTUZ6S3BFZmJLTXNpNHRCS2pjOE1EbF9HeTdieC02WFVzd2s2eXdxbG5lZS1zVnEtdVdWZHZfb3BjYmVqQXlxbEtobk1KU0dyMmtQakFzTE5TTDNCaVZqM1lhSU5QMzdJLV9uTHU4eVNBR0lrNm9vSFFZa001NnhmdzVESFNzRE9YWFdUSlllTjRjcUVsV25fM2I5eU51OTRQcnN2N3lHbmFCSzNBZ2hR?oc=5","source_event_id":"evt_545a1cc4a7b0","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"414a76fa800e12c5","published_at":"2026-04-09T14:50:18+00:00","publisher_domain":"dw.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"sovereign_politics","name":"Hungary voters","relevance":"directly referenced as driving the political direction","symbol":"","type":"voters/electorate"},{"asset_class":"sovereign","name":"Hungary","relevance":"country whose election/voter sentiment is discussed","symbol":"","type":"country"},{"asset_class":"political_union","name":"EU (European Union)","relevance":"policy direction sought by voters","symbol":"","type":"supranational_organization"},{"asset_class":"sovereign","name":"Ukraine","relevance":"target of the tougher stance","symbol":"","type":"country"}],"event_type":"geopolitical_risk","information_gaps":["The provided text does not include the election date, the specific parties/candidates, or the exact policy proposals implied by \u201cnew EU approach.\u201d","No details are provided on what \u201ctough on Ukraine\u201d concretely means (e.g., sanctions, aid, border/immigration, diplomatic stance).","Near-term catalyst timing (e.g., when EU policy changes would occur) is not specified in the provided material.","The signal includes references to other outlets (NYT, Guardian, Foreign Affairs, Reuters) but their specific claims are not included in the provided excerpt."],"key_facts":["DW.com headline indicates Hungarian voters want a new EU approach.","DW.com headline indicates Hungarian voters are tough on Ukraine."],"numeric_claims":[],"primary_claim":"Hungarian voters want a new EU approach but are tough on Ukraine, according to a DW.com piece.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"DW.com reports that Hungary\u2019s voters are seeking a new EU approach while also backing a tougher stance toward Ukraine. The signal frames this as a political direction that could affect Hungary\u2019s role and posture within the EU, particularly on Ukraine-related policy.","topics":["Hungary election","EU policy","Ukraine policy","Voter sentiment","EU internal politics"]},"source":"dw.com","source_domain":"dw.com","source_url":"https://www.dw.com","summary":"Hungary voters want new EU approach, but tough on Ukraine dw.com Opinion | Viktor Orban\u2019s Fate Is a Warning Not to Get Too Close to Trump The New York Times The Guardian view on Hungary\u2019s election: a bellwether contest for the global far right | Editorial The Guardian A Last Chance for Hungary: Orban\u2019s Mafia State Could Fall\u2014or Cement Itself Foreign Affairs Hungary's election could end Orban era and reshape its place in Europe Reuters","title":"Hungary voters want new EU approach, but tough on Ukraine - dw.com","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_4422f6196925 in signals