SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-04T17:18:28.725985+00:00","dedupe_key":"signal_enriched:opportunity_research_delta:f023a535ab5fac30","evidence_event_ids":["evt_1a7631e5bd24"],"signal_type":"opportunity_research_delta","source":"opportunity_research_ingestor","value":{"aggregator_url":"https://www.dvidshub.net/publication/issues/76721","as_of":"2026-04-04T17:18:28.725985+00:00","canonical_url":"https://d34w7g4gy10iej.cloudfront.net/pubs/pdf_76721.pdf","enrichment":{"aggregator_url":"https://www.dvidshub.net/publication/issues/76721","article_chars":0,"article_truncated":false,"blocked_reason":"unsupported_content_type","candidate_id":"sc_38685e68cf02f72b","canonical_host":"d34w7g4gy10iej.cloudfront.net","canonical_is_aggregator":false,"canonical_url":"https://d34w7g4gy10iej.cloudfront.net/pubs/pdf_76721.pdf","content_type":"application/pdf","enriched_at":"2026-04-04T18:40:09.132806+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://d34w7g4gy10iej.cloudfront.net/pubs/pdf_76721.pdf","html_truncated":false,"paywall_likely":false,"publisher_domain":"d34w7g4gy10iej.cloudfront.net","publisher_resolution":"canonical_url","requested_url":"https://www.dvidshub.net/publication/issues/76721","source_event_id":"evt_1a7631e5bd24","source_quality":"blocked","status_code":200,"version":"signal_enrichment_v2"},"fp":"5a4a51afa9d7b0ad","published_at":"","publisher_domain":"d34w7g4gy10iej.cloudfront.net","query":"Riot Platforms transitioning conflicting reports resolution primary sources","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.35,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"U.S. Army Combat Capabilities Development Command Chemical Biological Center (DEVCOM CBC)","relevance":"primary","symbol":"","type":"organization"}],"event_type":"research","information_gaps":["No article/PDF content beyond the truncated source summary is available.","The specific heat-based technology is not named.","No information is provided on what \u201ctransitioned\u201d means (e.g., to production, fielding, another organization).","No dates, locations, outcomes, performance metrics, or stakeholders are included.","No tradable assets or financial instruments are mentioned."],"key_facts":["DEVCOM CBC researchers successfully transitioned a heat-based technology (details not provided)."],"numeric_claims":[],"primary_claim":"Researchers at DEVCOM CBC have successfully transitioned a heat-based technology.","relevance_score":0.35,"sentiment":"neutral","source_quality":"blocked","summary":"The provided signal indicates that researchers at DEVCOM CBC (U.S. Army Combat Capabilities Development Command Chemical Biological Center) successfully transitioned a heat-based technology, but no further details are included in the available text.","topics":["DEVCOM CBC","heat-based technology","transition"]},"snippet":"Researchers at the U.S. Army Combat Capabilities Development. Command Chemical Biological Center (DEVCOM CBC) have successfully transitioned a heat-based ...","source":"web_search","source_domain":"d34w7g4gy10iej.cloudfront.net","summary":"Researchers at the U.S. Army Combat Capabilities Development. Command Chemical Biological Center (DEVCOM CBC) have successfully transitioned a heat-based ...","title":"[PDF] DEVCOM CBC - DVIDS","url":"https://d34w7g4gy10iej.cloudfront.net/pubs/pdf_76721.pdf"}}

TEXT NOT NULL

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 15965 in events