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/CBMi9AFBVV95cUxQWXJ4VFQ0dnI2ekxMZnZhZUotNkZlTXdOQmtVd0Q0a2Y4UURoLTZFRkVoYWQ2WlZDWjRuRUQzTUxDemVtOFR5TDZ6aG0zYmo2bE1FQ0xKcUF5VjNGSUhYTmxtemRSeDg0ZzRRRmtPVlpVQUlWSVlPV1E2Z2d0UXh2cWZlU1hnb05Ld0RZYUNiYnViVmtkZVBRM1JqV1JCVF82TzZSWkxTdlplZTJoS3FOd0RWNzM0dEVwSXYxWjZTOG84aHl0eW1TRjh0MFVBajJmQnJPeWNCR3Z2QXJpdnpwYllNc0p5UnNabjJQZ0tITTlobjhI?oc=5","as_of":"2026-04-09T21:31:27.529333+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/CBMi9AFBVV95cUxQWXJ4VFQ0dnI2ekxMZnZhZUotNkZlTXdOQmtVd0Q0a2Y4UURoLTZFRkVoYWQ2WlZDWjRuRUQzTUxDemVtOFR5TDZ6aG0zYmo2bE1FQ0xKcUF5VjNGSUhYTmxtemRSeDg0ZzRRRmtPVlpVQUlWSVlPV1E2Z2d0UXh2cWZlU1hnb05Ld0RZYUNiYnViVmtkZVBRM1JqV1JCVF82TzZSWkxTdlplZTJoS3FOd0RWNzM0dEVwSXYxWjZTOG84aHl0eW1TRjh0MFVBajJmQnJPeWNCR3Z2QXJpdnpwYllNc0p5UnNabjJQZ0tITTlobjhI?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_a0eb59f9b58f620e","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-10T02:44:11.951457+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi9AFBVV95cUxQWXJ4VFQ0dnI2ekxMZnZhZUotNkZlTXdOQmtVd0Q0a2Y4UURoLTZFRkVoYWQ2WlZDWjRuRUQzTUxDemVtOFR5TDZ6aG0zYmo2bE1FQ0xKcUF5VjNGSUhYTmxtemRSeDg0ZzRRRmtPVlpVQUlWSVlPV1E2Z2d0UXh2cWZlU1hnb05Ld0RZYUNiYnViVmtkZVBRM1JqV1JCVF82TzZSWkxTdlplZTJoS3FOd0RWNzM0dEVwSXYxWjZTOG84aHl0eW1TRjh0MFVBajJmQnJPeWNCR3Z2QXJpdnpwYllNc0p5UnNabjJQZ0tITTlobjhI?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"gstatic.com","publisher_resolution":"canonical_aggregator_unresolved","requested_url":"https://news.google.com/rss/articles/CBMi9AFBVV95cUxQWXJ4VFQ0dnI2ekxMZnZhZUotNkZlTXdOQmtVd0Q0a2Y4UURoLTZFRkVoYWQ2WlZDWjRuRUQzTUxDemVtOFR5TDZ6aG0zYmo2bE1FQ0xKcUF5VjNGSUhYTmxtemRSeDg0ZzRRRmtPVlpVQUlWSVlPV1E2Z2d0UXh2cWZlU1hnb05Ld0RZYUNiYnViVmtkZVBRM1JqV1JCVF82TzZSWkxTdlplZTJoS3FOd0RWNzM0dEVwSXYxWjZTOG84aHl0eW1TRjh0MFVBajJmQnJPeWNCR3Z2QXJpdnpwYllNc0p5UnNabjJQZ0tITTlobjhI?oc=5","source_event_id":"evt_985ecc955f59","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e5caa0c4dd9b5a91","kind":"ipo_calendar","published_at":"2026-04-09T20:05:00+00:00","publisher_domain":"gstatic.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Gemini Space Station","relevance":"high","symbol":"GEMI","type":"company"},{"asset_class":"other","name":"Hagens Berman","relevance":"medium","symbol":"","type":"law_firm"},{"asset_class":"other","name":"Morningstar","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"conflict","information_gaps":["The provided article text is not present (only CSS/HTML styling content is included), so details such as filing date, court, allegations, class period, and specific alleged misstatements are not available.","The signal does not specify the IPO date or the measurement window for the 75% decline.","No confirmation is provided in the supplied text beyond the headline/summary that the class action has been filed (vs. threatened or reported)."],"key_facts":["The signal headline states that Gemini Space Station (GEMI) is facing a securities class action.","The headline states the company\u2019s stock collapsed by 75% after its IPO."],"numeric_claims":[{"label":"Post-IPO collapse","value":"75%"}],"primary_claim":"Gemini Space Station (GEMI) is facing a securities class action following a 75% post-IPO collapse.","relevance_score":0.78,"sentiment":"negative","source_quality":"high","summary":"Gemini Space Station (GEMI) is reported to be facing a securities class action after its stock fell 75% following its IPO.","topics":["securities class action","IPO","post-IPO stock decline","litigation"]},"source":"Morningstar","source_domain":"gstatic.com","summary":"Gemini Space Station (GEMI) Facing Securities Class Action Following 75% Post-IPO Collapse - Hagens Berman Morningstar","tickers":["GEMI"],"title":"Gemini Space Station (GEMI) Facing Securities Class Action Following 75% Post-IPO Collapse - Hagens Berman - Morningstar","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_6f38ff9f84de in signals