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/CBMioAFBVV95cUxONE9vajdOQWNjd1N0Vzlzb0J2d3BFWUJWVjU5dXVhZmI4bThnNkk4ekhKSWN1N0UyVEZmZXYza3ZlRnJud2h2bUxfSWZqOUh5UEh3LWhFbmJ6aDJ0X2I2dnM5UFdMWEZPLW9KNGxfOWZzN0QwN19uM3pubE9CQlBFR2tVSXpzQ080V0pEZEZFS2RPcjZYZjdJMldWX3JvY2Q50gG0AUFVX3lxTE92TGFBMzZ1VEhNWnRaNzljV1JteHZxdGo2UHRCTGkyNmM2VUFMMkF1ZFQwX0JrR2VQWi12SDRKMTF1TXllcWJFZDRPUU80S0EyNkEtdlRGdjRXR0FCdUMzM2pPSm56dDNTdlhuRHgyR0FNRFJOVmU5QUEwUTVzLWhPLTExRVdtdDhtVlhtdHAwSnM0dXAtT1RUbEZqVHpNNFBVOHVSbVlkd201LVJQVTBCM1lRRQ?oc=5","as_of":"2026-04-21T04:05:36.954166+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.ZC4SwnwBFEo.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OnHEEtl37V-jXhbqB2FmnEcwzOBQ/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMioAFBVV95cUxONE9vajdOQWNjd1N0Vzlzb0J2d3BFWUJWVjU5dXVhZmI4bThnNkk4ekhKSWN1N0UyVEZmZXYza3ZlRnJud2h2bUxfSWZqOUh5UEh3LWhFbmJ6aDJ0X2I2dnM5UFdMWEZPLW9KNGxfOWZzN0QwN19uM3pubE9CQlBFR2tVSXpzQ080V0pEZEZFS2RPcjZYZjdJMldWX3JvY2Q50gG0AUFVX3lxTE92TGFBMzZ1VEhNWnRaNzljV1JteHZxdGo2UHRCTGkyNmM2VUFMMkF1ZFQwX0JrR2VQWi12SDRKMTF1TXllcWJFZDRPUU80S0EyNkEtdlRGdjRXR0FCdUMzM2pPSm56dDNTdlhuRHgyR0FNRFJOVmU5QUEwUTVzLWhPLTExRVdtdDhtVlhtdHAwSnM0dXAtT1RUbEZqVHpNNFBVOHVSbVlkd201LVJQVTBCM1lRRQ?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_7df02b7d2aa1f62f","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.ZC4SwnwBFEo.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OnHEEtl37V-jXhbqB2FmnEcwzOBQ/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T16:45:58.251101+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMioAFBVV95cUxONE9vajdOQWNjd1N0Vzlzb0J2d3BFWUJWVjU5dXVhZmI4bThnNkk4ekhKSWN1N0UyVEZmZXYza3ZlRnJud2h2bUxfSWZqOUh5UEh3LWhFbmJ6aDJ0X2I2dnM5UFdMWEZPLW9KNGxfOWZzN0QwN19uM3pubE9CQlBFR2tVSXpzQ080V0pEZEZFS2RPcjZYZjdJMldWX3JvY2Q50gG0AUFVX3lxTE92TGFBMzZ1VEhNWnRaNzljV1JteHZxdGo2UHRCTGkyNmM2VUFMMkF1ZFQwX0JrR2VQWi12SDRKMTF1TXllcWJFZDRPUU80S0EyNkEtdlRGdjRXR0FCdUMzM2pPSm56dDNTdlhuRHgyR0FNRFJOVmU5QUEwUTVzLWhPLTExRVdtdDhtVlhtdHAwSnM0dXAtT1RUbEZqVHpNNFBVOHVSbVlkd201LVJQVTBCM1lRRQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nj.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMioAFBVV95cUxONE9vajdOQWNjd1N0Vzlzb0J2d3BFWUJWVjU5dXVhZmI4bThnNkk4ekhKSWN1N0UyVEZmZXYza3ZlRnJud2h2bUxfSWZqOUh5UEh3LWhFbmJ6aDJ0X2I2dnM5UFdMWEZPLW9KNGxfOWZzN0QwN19uM3pubE9CQlBFR2tVSXpzQ080V0pEZEZFS2RPcjZYZjdJMldWX3JvY2Q50gG0AUFVX3lxTE92TGFBMzZ1VEhNWnRaNzljV1JteHZxdGo2UHRCTGkyNmM2VUFMMkF1ZFQwX0JrR2VQWi12SDRKMTF1TXllcWJFZDRPUU80S0EyNkEtdlRGdjRXR0FCdUMzM2pPSm56dDNTdlhuRHgyR0FNRFJOVmU5QUEwUTVzLWhPLTExRVdtdDhtVlhtdHAwSnM0dXAtT1RUbEZqVHpNNFBVOHVSbVlkd201LVJQVTBCM1lRRQ?oc=5","source_event_id":"evt_b55ea8a7f0c6","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"bd37952810571eee","published_at":"2026-04-21T01:45:00+00:00","publisher_domain":"nj.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: Meteor shower could bring 20 shooting stars per hour this week - NJ.com","Source summary: Meteor shower could bring 20 shooting stars per hour this week NJ.com Look Up This Week to See the Peak of the Lyrid Meteor Shower. Humans Have Documented This Dazzling Annual Display for 2,700 Years Smithsonian Magazine What's the best time to see Lyrid meteors in 2026? Space Arizona stargazers could spot Lyrids meteor shower, rare comet in April KJZZ Lyrids meteor shower peaks in Wisconsin on Earth Day. Here's how "],"numeric_claims":[],"primary_claim":"Meteor shower could bring 20 shooting stars per hour this week - NJ.com","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"Meteor shower could bring 20 shooting stars per hour this week NJ.com Look Up This Week to See the Peak of the Lyrid Meteor Shower. Humans Have Documented This Dazzling Annual Display for 2,700 Years Smithsonian Magazine What's the best time to see Lyrid meteors in 2026? Space Arizona stargazers could spot Lyrids meteor shower, rare comet in April KJZZ Lyrids meteor shower peaks in Wisconsin on Ea","topics":["news headline"]},"source":"NJ.com","source_domain":"nj.com","source_url":"https://www.nj.com","summary":"Meteor shower could bring 20 shooting stars per hour this week NJ.com Look Up This Week to See the Peak of the Lyrid Meteor Shower. Humans Have Documented This Dazzling Annual Display for 2,700 Years Smithsonian Magazine What's the best time to see Lyrid meteors in 2026? Space Arizona stargazers could spot Lyrids meteor shower, rare comet in April KJZZ Lyrids meteor shower peaks in Wisconsin on Earth Day. Here's how to watch it Milwaukee Journal Sentinel","title":"Meteor shower could bring 20 shooting stars per hour this week - NJ.com","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.ZC4SwnwBFEo.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OnHEEtl37V-jXhbqB2FmnEcwzOBQ/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_829cef8f8533 in signals