uhg sorry about the npub key not parsing guess I need to fix that.

two views you should use are nostr_events and nostr_users. you can just select * them to see their columns. they join on pubkey. the base table is nostr but its hard to use bc everything is stored in json.