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/CBMiswFBVV95cUxNcWcybmRLcnc1VWJpNDlpU2E2QXliTHpQRkFpWW5tc2lGaVRSYkNMcGZZcGxqWldVRDUxMFpPRFlVdEozaFN0bGZZbU5qY1QtMHRoMlFHQms0blBzU1Rjd1VTd0NsM2Rha0ptRXJiQ0lwVDdITmgyVTVIOHBQWEV5T3pIanQxU3A1WWNiNThySDY5VnA2NUZSQ2NVV3F1LVVQOWpSNnpTa0g5U1RTZnBtV3RsUQ?oc=5","as_of":"2026-04-10T12:11:33.277556+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/CBMiswFBVV95cUxNcWcybmRLcnc1VWJpNDlpU2E2QXliTHpQRkFpWW5tc2lGaVRSYkNMcGZZcGxqWldVRDUxMFpPRFlVdEozaFN0bGZZbU5qY1QtMHRoMlFHQms0blBzU1Rjd1VTd0NsM2Rha0ptRXJiQ0lwVDdITmgyVTVIOHBQWEV5T3pIanQxU3A1WWNiNThySDY5VnA2NUZSQ2NVV3F1LVVQOWpSNnpTa0g5U1RTZnBtV3RsUQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_6226a5543175796a","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-10T12:15:07.118456+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiswFBVV95cUxNcWcybmRLcnc1VWJpNDlpU2E2QXliTHpQRkFpWW5tc2lGaVRSYkNMcGZZcGxqWldVRDUxMFpPRFlVdEozaFN0bGZZbU5qY1QtMHRoMlFHQms0blBzU1Rjd1VTd0NsM2Rha0ptRXJiQ0lwVDdITmgyVTVIOHBQWEV5T3pIanQxU3A1WWNiNThySDY5VnA2NUZSQ2NVV3F1LVVQOWpSNnpTa0g5U1RTZnBtV3RsUQ?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/CBMiswFBVV95cUxNcWcybmRLcnc1VWJpNDlpU2E2QXliTHpQRkFpWW5tc2lGaVRSYkNMcGZZcGxqWldVRDUxMFpPRFlVdEozaFN0bGZZbU5qY1QtMHRoMlFHQms0blBzU1Rjd1VTd0NsM2Rha0ptRXJiQ0lwVDdITmgyVTVIOHBQWEV5T3pIanQxU3A1WWNiNThySDY5VnA2NUZSQ2NVV3F1LVVQOWpSNnpTa0g5U1RTZnBtV3RsUQ?oc=5","source_event_id":"evt_64b5e3fd04b2","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"d58c993e6dc2a682","kind":"ipo_calendar","published_at":"2026-04-10T11:56:50+00:00","publisher_domain":"gstatic.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.45,"dates_mentioned":[],"entities":[{"asset_class":"equity/crypto platform (unspecified)","name":"Bitget","relevance":"primary","symbol":"","type":"company"},{"asset_class":"equity (unspecified)","name":"SpaceX","relevance":"secondary","symbol":"","type":"company"}],"event_type":"listing","information_gaps":["The cleaned article text contains only HTML/CSS styling and no readable body content, so details (e.g., how IPO Prime works, eligibility, jurisdictions, timelines, pricing, or regulatory status) are not present.","No confirmation is provided in the available text about whether SpaceX is actually included, the specific structure of \u201cIPO Prime,\u201d or whether this is an IPO, pre-IPO, or another product type.","No additional measurable claims (fees, limits, dates, volumes, or terms) are present in the provided text."],"key_facts":["Headline states: \u201cBitget Enables Early-Stage Exposure to Companies Like SpaceX via IPO Prime.\u201d"],"numeric_claims":[],"primary_claim":"Bitget enables early-stage exposure to companies like SpaceX via \u201cIPO Prime.\u201d","relevance_score":0.55,"sentiment":"neutral","source_quality":"high","summary":"The signal claims that Bitget is enabling early-stage exposure to companies such as SpaceX through an offering called \u201cIPO Prime.\u201d The provided article text is not available beyond styling/HTML, so the underlying details cannot be verified.","topics":["IPO","early-stage exposure","Bitget","IPO Prime","SpaceX"]},"source":"TechAfrica News","source_domain":"gstatic.com","summary":"Bitget Enables Early-Stage Exposure to Companies Like SpaceX via IPO Prime TechAfrica News","tickers":[],"title":"Bitget Enables Early-Stage Exposure to Companies Like SpaceX via IPO Prime - TechAfrica News","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_6ff050bdaf5b in signals