Create
Query
event_store.db
—
events
actions
approvals
artifacts
commitments
constraints
conversation_compaction
conversation_state
conversation_turns
dead_letters
decisions
deliveries
effects
email_messages
email_reply_drafts
email_threads
entities
entity_aliases
entity_tags
episode_context_index
episodes
event_subjects
events
events_archive
fact_sources
facts
inbox_items
inbox_links
jobs
leader_leases
links
memory_candidates
memory_embeddings
memory_items
memory_items_fts
(v)
memory_items_fts_config
memory_items_fts_data
memory_items_fts_idx
opportunity_memory
pending_interactions
proposal_sources
proposals
reminders
schedules
schema_migrations
signal_candidates
signal_fps
signals
sms_conversations
sms_messages
sms_reply_drafts
source_cursors
sources
sqlite_sequence
sqlite_stat1
stream_cursors
threads
watchers
Toggle helper tables
memory_items_fts_content
memory_items_fts_docsize
memory_items_fts_segdir
memory_items_fts_segments
memory_items_fts_stat
Structure
Content
Query
Insert
Drop
Import
Export
Update row 33385 in events
seq
Primary key.
INTEGER
id
evt_628c6afcf7b8
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-13T08:52:31.697409+00:00
TEXT NOT NULL
actor
daemon:signal_enrichment
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-13T07:19:16.918048+00:00","dedupe_key":"signal_enriched:market_headline_delta:3201939f87d9ed55","evidence_event_ids":["evt_e695dd859948"],"signal_type":"market_headline_delta","source":"market_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMi3AFBVV95cUxPQnMyc0xNUHVrU1dkSF9JLXNlUC02Y0pjSF9xQ2U5bG4yY2xPZlpTOUVBXzZwajZTcE1DVzRKZHF3SkdTRnFMa3BsYnJGekhrVDZCU3JsN2U4R1FFNWdfaWJmal83X0RaWmN0U1FMQ2t4b0VsY29HS1ZQQVRJUEY5WFZHZ1FyLWtJSHBrREVQaGQ4VkpfbE5lU2I5dVBoYjR3WkQ5eWdwQm9jUUxpQmtxRXlvMW9MY1JVc3FsUlk3blVFSk9GckNleDZySUk3ZzZLNnhkcm9ESzBfYzBy?oc=5","as_of":"2026-04-13T07:19:16.918048+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/CBMi3AFBVV95cUxPQnMyc0xNUHVrU1dkSF9JLXNlUC02Y0pjSF9xQ2U5bG4yY2xPZlpTOUVBXzZwajZTcE1DVzRKZHF3SkdTRnFMa3BsYnJGekhrVDZCU3JsN2U4R1FFNWdfaWJmal83X0RaWmN0U1FMQ2t4b0VsY29HS1ZQQVRJUEY5WFZHZ1FyLWtJSHBrREVQaGQ4VkpfbE5lU2I5dVBoYjR3WkQ5eWdwQm9jUUxpQmtxRXlvMW9MY1JVc3FsUlk3blVFSk9GckNleDZySUk3ZzZLNnhkcm9ESzBfYzBy?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_85cefe7fbb56c73c","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-13T08:52:31.697236+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi3AFBVV95cUxPQnMyc0xNUHVrU1dkSF9JLXNlUC02Y0pjSF9xQ2U5bG4yY2xPZlpTOUVBXzZwajZTcE1DVzRKZHF3SkdTRnFMa3BsYnJGekhrVDZCU3JsN2U4R1FFNWdfaWJmal83X0RaWmN0U1FMQ2t4b0VsY29HS1ZQQVRJUEY5WFZHZ1FyLWtJSHBrREVQaGQ4VkpfbE5lU2I5dVBoYjR3WkQ5eWdwQm9jUUxpQmtxRXlvMW9MY1JVc3FsUlk3blVFSk9GckNleDZySUk3ZzZLNnhkcm9ESzBfYzBy?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"markets.financialcontent.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi3AFBVV95cUxPQnMyc0xNUHVrU1dkSF9JLXNlUC02Y0pjSF9xQ2U5bG4yY2xPZlpTOUVBXzZwajZTcE1DVzRKZHF3SkdTRnFMa3BsYnJGekhrVDZCU3JsN2U4R1FFNWdfaWJmal83X0RaWmN0U1FMQ2t4b0VsY29HS1ZQQVRJUEY5WFZHZ1FyLWtJSHBrREVQaGQ4VkpfbE5lU2I5dVBoYjR3WkQ5eWdwQm9jUUxpQmtxRXlvMW9MY1JVc3FsUlk3blVFSk9GckNleDZySUk3ZzZLNnhkcm9ESzBfYzBy?oc=5","source_event_id":"evt_e695dd859948","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"f1c797bccd644a0f","published_at":"2026-04-13T04:44:00+00:00","publisher_domain":"markets.financialcontent.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.45,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Unspecified (2 \u201cunpopular stocks\u201d)","relevance":"high","symbol":"","type":"equity"},{"asset_class":"equity","name":"Unspecified (1 \u201cunderwhelming\u201d stock)","relevance":"high","symbol":"","type":"equity"}],"event_type":"other","information_gaps":["Company names and ticker symbols for the three stocks are not provided.","No performance metrics, valuation metrics, catalysts, or time horizon are included.","No article text is available to verify the specific claims behind \u201cmore attention\u201d or \u201cunderwhelm.\u201d","No indication of trend continuation vs reversal is provided beyond qualitative descriptors."],"key_facts":["Headline states there are \u201c2 Unpopular Stocks That Should Get More Attention.\u201d","Headline states there is \u201c1 That Underwhelm.\u201d","No company names or ticker symbols are included in the provided text."],"numeric_claims":[],"primary_claim":"Two stocks are characterized as \u201cunpopular\u201d and deserving more attention, while one stock is characterized as underwhelming.","relevance_score":0.25,"sentiment":"mixed","source_quality":"unknown","summary":"The headline promotes three stocks: two described as \u201cunpopular\u201d and deserving more attention, and one described as underwhelming. No tickers or company names are provided in the provided text.","topics":["stock selection","equities","market commentary"]},"source":"FinancialContent","source_domain":"markets.financialcontent.com","source_url":"https://markets.financialcontent.com","summary":"","tickers":[],"title":"2 Unpopular Stocks That Should Get More Attention and 1 That Underwhelm - FinancialContent","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
source_ref
candidate:sc_85cefe7fbb56c73c
TEXT
confidence
REAL (default 0.0
dedupe_key
signal_enriched:market_headline_delta:3201939f87d9ed55
TEXT
episode_id
NULL
TEXT
created_at
2026-04-13T08:52:31.697898+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel