Create
Query
event_store.db
—
events
actions
approvals
artifacts
commitments
constraints
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 13484 in events
seq
Primary key.
INTEGER
id
evt_049bb7700ac1
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-04T10:49:41.777360+00:00
TEXT NOT NULL
actor
daemon:signal_enrichment
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-04T10:48:20.843843+00:00","dedupe_key":"signal_enriched:opportunity_research_delta:4b298de1250648a9","evidence_event_ids":["evt_51f85dda9243"],"signal_type":"opportunity_research_delta","source":"opportunity_research_ingestor","value":{"aggregator_url":"https://extinctmonsters.net/category/history-of-science/","as_of":"2026-04-04T10:48:20.843843+00:00","canonical_url":"https://extinctmonsters.net/category/history-of-science/","enrichment":{"aggregator_url":"https://extinctmonsters.net/category/history-of-science/","article_chars":4999,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_aadb8e1c36867821","canonical_host":"extinctmonsters.net","canonical_is_aggregator":false,"canonical_url":"https://extinctmonsters.net/category/history-of-science/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-04T10:49:41.777300+00:00","extraction_method":"heuristic","fetched_description":"Posts about history of science written by Ben","fetched_title":"history of science | EXTINCT MONSTERS","final_url":"https://extinctmonsters.net/category/history-of-science/","html_truncated":true,"paywall_likely":false,"publisher_domain":"extinctmonsters.net","publisher_resolution":"canonical_url","requested_url":"https://extinctmonsters.net/category/history-of-science/","source_event_id":"evt_51f85dda9243","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"59ed6120c172d0ef","published_at":"","publisher_domain":"extinctmonsters.net","query":"Alfred Sandrock sold conflicting reports resolution primary sources","signal_understanding":{"analysis_basis":"article","claim_confidence":0.95,"dates_mentioned":["1870s","1970s","1908"],"entities":[{"asset_class":"none","name":"Charles H. Sternberg","relevance":"central figure in fossil hunting","symbol":"","type":"person"},{"asset_class":"none","name":"George Fryer Sternberg","relevance":"son of Charles H. Sternberg","symbol":"","type":"person"},{"asset_class":"none","name":"Charles Mortram Sternberg","relevance":"son of Charles H. Sternberg","symbol":"","type":"person"},{"asset_class":"none","name":"American Museum of Natural History (AMNH)","relevance":"museum involved in fossil sales","symbol":"AMNH","type":"institution"},{"asset_class":"none","name":"Smithsonian Institution","relevance":"institution Charles H. Sternberg contacted","symbol":"SI","type":"institution"},{"asset_class":"none","name":"Academy of Natural Sciences","relevance":"employer of Charles H. Sternberg","symbol":"","type":"institution"},{"asset_class":"none","name":"British Museum (Natural History)","relevance":"client of Charles H. Sternberg","symbol":"","type":"institution"}],"event_type":"research","information_gaps":["Specific details on the fossils collected are not provided.","The exact nature of the most famous fossil found in 1908 is not described."],"key_facts":["The Sternbergs operated from the 1870s to the 1970s.","Charles H. Sternberg developed techniques for fossil transport still in use today.","The family found significant fossils, including a famous one in 1908."],"numeric_claims":[],"primary_claim":"The Sternbergs were highly skilled fossil hunters who collected specimens for major museums from the 1870s to the 1970s.","relevance_score":0.9,"sentiment":"positive","source_quality":"high","summary":"The Sternberg family, particularly Charles H. Sternberg and his sons, were prominent fossil hunters from the 1870s to the 1970s, significantly contributing to museum collections across North America and Europe.","topics":["fossil hunting","natural history","museum collections","Sternberg family"]},"snippet":"In 1941, AMNH ended its Tyrannosaurus monopoly and sold the incomplete type specimen (the partial skeleton described in Osborn's 1905 publication) to ...","source":"web_search","source_domain":"extinctmonsters.net","summary":"In 1941, AMNH ended its Tyrannosaurus monopoly and sold the incomplete type specimen (the partial skeleton described in Osborn's 1905 publication) to ...","title":"Category Archives: history of science - extinct monsters","url":"https://extinctmonsters.net/category/history-of-science/"}}
TEXT NOT NULL
source_ref
candidate:sc_aadb8e1c36867821
TEXT
confidence
REAL (default 0.0
dedupe_key
signal_enriched:opportunity_research_delta:4b298de1250648a9
TEXT
episode_id
NULL
TEXT
created_at
2026-04-04T10:49:41.777401+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel