Question: Where are guest author display names stored?

[rchalhoub]

Hello, Our multisite is using Co-Authors Plus 3.4.92. I'm generating author reports by using SQL to query our databases. So far I've been unable to find a standalone field for the guest author display names. This is what I've found so far:

The wp_terms table has these columns:
Name: john-smith
Slug: cap-john-smith

The wp_term_taxonomy table has the display name combined with the first/last name, ID, etc all in one cell in the description column:
John Smith John Smith john-smith 1234

Is there anywhere I can find the display name separated from the other info, so I can set up a query that will just give me "John Smith" ?

Thank you