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/CBMikAFBVV95cUxPYUlTTFF5Z1FWemJYS3NxQi1JR2lZY1piTzJ5MjNZTEU5NWJyLU9vMnBzcHhEVEg5M08td3dIcHR4enlfdWRmc1pjaUM2ekNyV180el9VNGhxOTdYV3pIWFlIZTZFT09VeC1IZGpFc2h0QnExcy1aRkI3aFNPcnh6OGFWU2FhNmQ4bU5sbUxsNkg?oc=5","as_of":"2026-04-18T07:45:38.637049+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMikAFBVV95cUxPYUlTTFF5Z1FWemJYS3NxQi1JR2lZY1piTzJ5MjNZTEU5NWJyLU9vMnBzcHhEVEg5M08td3dIcHR4enlfdWRmc1pjaUM2ekNyV180el9VNGhxOTdYV3pIWFlIZTZFT09VeC1IZGpFc2h0QnExcy1aRkI3aFNPcnh6OGFWU2FhNmQ4bU5sbUxsNkg?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_951eb7f308c16e93","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-18T07:45:57.742531+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikAFBVV95cUxPYUlTTFF5Z1FWemJYS3NxQi1JR2lZY1piTzJ5MjNZTEU5NWJyLU9vMnBzcHhEVEg5M08td3dIcHR4enlfdWRmc1pjaUM2ekNyV180el9VNGhxOTdYV3pIWFlIZTZFT09VeC1IZGpFc2h0QnExcy1aRkI3aFNPcnh6OGFWU2FhNmQ4bU5sbUxsNkg?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"newjerseyglobe.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMikAFBVV95cUxPYUlTTFF5Z1FWemJYS3NxQi1JR2lZY1piTzJ5MjNZTEU5NWJyLU9vMnBzcHhEVEg5M08td3dIcHR4enlfdWRmc1pjaUM2ekNyV180el9VNGhxOTdYV3pIWFlIZTZFT09VeC1IZGpFc2h0QnExcy1aRkI3aFNPcnh6OGFWU2FhNmQ4bU5sbUxsNkg?oc=5","source_event_id":"evt_384d18e1a56a","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"aa02e2c967e69a9e","published_at":"2026-04-18T01:13:04+00:00","publisher_domain":"newjerseyglobe.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.42,"dates_mentioned":[],"entities":[],"event_type":"other","information_gaps":["article_text_unavailable"],"key_facts":["Headline: Mejia scored an NJ-11 landslide \u2013 but not everywhere - New Jersey Globe","Source summary: Mejia scored an NJ-11 landslide \u2013 but not everywhere New Jersey Globe Democrat Analilia Mejia will win House special election in New Jersey, further narrowing GOP majority CNN Steve Kornacki: How a traditionally Republican area helped deliver a progressive victory in New Jersey NBC News The latest Democratic special election win adds to GOP leaders\u2019 headaches MS NOW An unabashed progressive dominates in New Jersey, a"],"numeric_claims":[],"primary_claim":"Mejia scored an NJ-11 landslide \u2013 but not everywhere - New Jersey Globe","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"Mejia scored an NJ-11 landslide \u2013 but not everywhere New Jersey Globe Democrat Analilia Mejia will win House special election in New Jersey, further narrowing GOP majority CNN Steve Kornacki: How a traditionally Republican area helped deliver a progressive victory in New Jersey NBC News The latest Democratic special election win adds to GOP leaders\u2019 headaches MS NOW An unabashed progressive domina","topics":["news headline"]},"source":"New Jersey Globe","source_domain":"newjerseyglobe.com","source_url":"https://newjerseyglobe.com","summary":"Mejia scored an NJ-11 landslide \u2013 but not everywhere New Jersey Globe Democrat Analilia Mejia will win House special election in New Jersey, further narrowing GOP majority CNN Steve Kornacki: How a traditionally Republican area helped deliver a progressive victory in New Jersey NBC News The latest Democratic special election win adds to GOP leaders\u2019 headaches MS NOW An unabashed progressive dominates in New Jersey, another midterm warning sign for Republicans Politico","title":"Mejia scored an NJ-11 landslide \u2013 but not everywhere - New Jersey Globe","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/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_98ff20d6d6b3 in signals