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 22013 in events
seq
Primary key.
INTEGER
id
evt_09e7386c2fb1
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-05T15:18:58.795748+00:00
TEXT NOT NULL
actor
collector:opportunity_research
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-05T15:18:58.795748+00:00","signal_type":"opportunity_research_snapshot","source":"opportunity_research_ingestor","value":{"as_of":"2026-04-05T15:18:58.795748+00:00","bucket":"2026-04-05T15:00Z","items":[{"fp":"39a14e582a583f5f","provider":"serper","published_at":"2026-04-05T15:18:58.795748+00:00","quality_hint":1.0,"query":"Aerodrome Finance has conflicting reports resolution primary sources","snippet":"The Lease of the Crookwell Aerodrome was surrendered / Terminated in December 2025 exactly 3 years later. To my knowledge there has been no official ...","source":"web_search","source_url":"https://www.facebook.com/groups/1182629796177641/posts/1580422036398413/","summary":"The Lease of the Crookwell Aerodrome was surrendered / Terminated in December 2025 exactly 3 years later. To my knowledge there has been no official ...","title":"Commissioner's response to airport authority dissolution - Facebook","url":"https://www.facebook.com/groups/1182629796177641/posts/1580422036398413/"},{"fp":"0e8a724eec8027ac","provider":"serper","published_at":"2026-04-05T15:18:58.795748+00:00","quality_hint":1.0,"query":"Aerodrome Finance has conflicting reports resolution primary sources","snippet":"Members, pursuant to the provisions of Standing Order 41(4), I wish to report to the House that I have received four. Messages from the Senate regarding its ...","source":"web_search","source_url":"https://www.parliament.go.ke/sites/default/files/2026-04/The%20Hansard%20-%20Tuesday%2C%2031%20March%202026.pdf","summary":"Members, pursuant to the provisions of Standing Order 41(4), I wish to report to the House that I have received four. Messages from the Senate regarding its ...","title":"[PDF] The Hansard - Tuesday, 31 March 2026 - Parliament of Kenya","url":"https://www.parliament.go.ke/sites/default/files/2026-04/The%20Hansard%20-%20Tuesday%2C%2031%20March%202026.pdf"},{"fp":"9fab65b512f4e73a","provider":"serper","published_at":"2026-04-05T15:18:58.795748+00:00","quality_hint":1.0,"query":"Aerodrome Finance has conflicting reports resolution primary sources","snippet":"Members weigh in their minds these conflicting needs, they will say that on the whole I have held the balance between the different requirement of the country ...","source":"web_search","source_url":"https://hansard.parliament.uk/Commons/1925-02-26/debates/82713973-c237-45ad-96fb-5ecce8896964/Supply","summary":"Members weigh in their minds these conflicting needs, they will say that on the whole I have held the balance between the different requirement of the country ...","title":"Supply - Hansard - UK Parliament","url":"https://hansard.parliament.uk/Commons/1925-02-26/debates/82713973-c237-45ad-96fb-5ecce8896964/Supply"},{"fp":"b3d3d22250275352","provider":"serper","published_at":"2026-04-05T15:18:58.795748+00:00","quality_hint":1.0,"query":"Aerodrome Finance has conflicting reports resolution primary sources","snippet":"The second half of the Session resumed on March 9, 2026, and is scheduled to conclude on April 2, 2026. Five Bills have been introduced in the second half ...","source":"web_search","source_url":"https://prsindia.org/policy/monthly-policy-review/march-2026","summary":"The second half of the Session resumed on March 9, 2026, and is scheduled to conclude on April 2, 2026. Five Bills have been introduced in the second half ...","title":"March 2026 - PRS India","url":"https://prsindia.org/policy/monthly-policy-review/march-2026"},{"fp":"d7b518fcfc9357ec","provider":"serper","published_at":"2026-04-05T15:18:58.795748+00:00","quality_hint":1.0,"query":"Aerodrome Finance has conflicting reports resolution primary sources","snippet":"(b) conflict resolution between IFR aircraft and VFR aircraft;. (c) conflict resolution between VFR aircraft, on request;. (d) traffic information; and. (e) ...","source":"web_search","source_url":"https://laws-lois.justice.gc.ca/eng/regulations/sor-96-433/page-110.html","summary":"(b) conflict resolution between IFR aircraft and VFR aircraft;. (c) conflict resolution between VFR aircraft, on request;. (d) traffic information; and. (e) ...","title":"Canadian Aviation Regulations ( SOR /96-433) - Justice Laws Website","url":"https://laws-lois.justice.gc.ca/eng/regulations/sor-96-433/page-110.html"},{"fp":"600c029276e6ff47","provider":"serper","published_at":"2026-04-05T15:18:58.795748+00:00","quality_hint":1.0,"query":"Aerodrome Finance has conflicting reports resolution primary sources","snippet":"AgEagle reported 2025 revenue of $12.8M, slightly below 2024, but cut its net loss to about $5.3M from $35.0M in 2024. Drones contributed $7.9M and sensors $5.0 ...","source":"web_search","source_url":"https://www.stocktitan.net/sec-filings/UAVS/10-k-ag-eagle-aerial-systems-inc-files-annual-report-2539b3a579bd.html","summary":"AgEagle reported 2025 revenue of $12.8M, slightly below 2024, but cut its net loss to about $5.3M from $35.0M in 2024. Drones contributed $7.9M and sensors $5.0 ...","title":"[10-K] AgEagle Aerial Systems Inc. Files Annual Report - Stock Titan","url":"https://www.stocktitan.net/sec-filings/UAVS/10-k-ag-eagle-aerial-systems-inc-files-annual-report-2539b3a579bd.html"}],"meta":{},"provider":"serper","quality_hint":1.0,"query":"Aerodrome Finance has conflicting reports resolution primary sources","source":"opportunity_research_ingestor","source_ref":"targeted_research:case_e8518db200341b09","status":"ok"}}
TEXT NOT NULL
source_ref
targeted_research:case_e8518db200341b09
TEXT
confidence
REAL (default 0.0
dedupe_key
opportunity_research_snapshot:89e90ab4aca18e93
TEXT
episode_id
NULL
TEXT
created_at
2026-04-05T15:19:06.796502+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel