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/CBMijAFBVV95cUxOVnUxSDZ3dExHbl8wanY2M094QjU4T2RkNm5TWjd2Qmk3RUlCc1RGeWhXUlI3WG54Ti02NlVobDZYU01nbzRjbXVDLWZ4WFZwMlRlZU0tY2laQ0tGdGluYVhReUNES1lHcVpVcWdJM3hKNlNJb0pWQkVLQV9TTG5kVWhUM1ZabmdFQnQzTQ?oc=5","as_of":"2026-04-07T23:23:54.391414+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/CBMijAFBVV95cUxOVnUxSDZ3dExHbl8wanY2M094QjU4T2RkNm5TWjd2Qmk3RUlCc1RGeWhXUlI3WG54Ti02NlVobDZYU01nbzRjbXVDLWZ4WFZwMlRlZU0tY2laQ0tGdGluYVhReUNES1lHcVpVcWdJM3hKNlNJb0pWQkVLQV9TTG5kVWhUM1ZabmdFQnQzTQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_a1f2ec43b41b2569","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-08T01:05:53.943449+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMijAFBVV95cUxOVnUxSDZ3dExHbl8wanY2M094QjU4T2RkNm5TWjd2Qmk3RUlCc1RGeWhXUlI3WG54Ti02NlVobDZYU01nbzRjbXVDLWZ4WFZwMlRlZU0tY2laQ0tGdGluYVhReUNES1lHcVpVcWdJM3hKNlNJb0pWQkVLQV9TTG5kVWhUM1ZabmdFQnQzTQ?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/CBMijAFBVV95cUxOVnUxSDZ3dExHbl8wanY2M094QjU4T2RkNm5TWjd2Qmk3RUlCc1RGeWhXUlI3WG54Ti02NlVobDZYU01nbzRjbXVDLWZ4WFZwMlRlZU0tY2laQ0tGdGluYVhReUNES1lHcVpVcWdJM3hKNlNJb0pWQkVLQV9TTG5kVWhUM1ZabmdFQnQzTQ?oc=5","source_event_id":"evt_7c7ec1644daf","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9e7b4dff3fc5e83a","kind":"ipo_calendar","published_at":"2026-04-07T11:30:05+00:00","publisher_domain":"gstatic.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":["June"],"entities":[{"asset_class":"equity (IPO referenced)","name":"SpaceX","relevance":"primary","symbol":"","type":"company"}],"event_type":"listing","information_gaps":["No article body content was provided beyond the headline/source summary, so details such as the exact June date, geography/venue, IPO timing, pricing, or underwriters are not available.","The phrase \u201crecord retail investor push\u201d is not quantified in the provided text (e.g., number of retail investors, allocation size, or percentage).","No confirmation of whether the IPO itself is in June (only the roadshow targeting June is stated)."],"key_facts":["SpaceX plans a \u201crecord retail investor push\u201d for its IPO.","The IPO roadshow is targeting June."],"numeric_claims":[],"primary_claim":"SpaceX plans a record retail investor push as its IPO roadshow targets June.","relevance_score":0.72,"sentiment":"neutral","source_quality":"high","summary":"The signal states that SpaceX plans a record retail-investor push for its IPO, with the IPO roadshow targeting June.","topics":["IPO","retail investors","roadshow","June","SpaceX"]},"source":"Yahoo! Finance Canada","source_domain":"gstatic.com","summary":"SpaceX plans record retail investor push as IPO roadshow targets June Yahoo! Finance Canada","tickers":[],"title":"SpaceX plans record retail investor push as IPO roadshow targets June - Yahoo! Finance Canada","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_1e80cb195d1d in signals