starttime (in seconds based on the transcript segments)
type and sub-type (e.g. person, mention)
identifier (most commonly the person's name)
YouTube links can easily be derived from the starttimes. (If pre-generated links are necessary I can generate those.)
I included additional columns with some more info about each person. The extra columns can be ignored if they're not needed, but I wanted to experiment with adding additional info related to each person. Some tags for relationships include: org: for company/organization, game:, person:, skills:, etc. along with roles or actions for that relationship. It did take a fair amount of additional effort to identify endtimes and relationships which may not be practical to do on many episodes (at least not the way I did it).
See #5
The main columns are:
YouTube links can easily be derived from the starttimes. (If pre-generated links are necessary I can generate those.)
I included additional columns with some more info about each person. The extra columns can be ignored if they're not needed, but I wanted to experiment with adding additional info related to each person. Some tags for relationships include: org: for company/organization, game:, person:, skills:, etc. along with roles or actions for that relationship. It did take a fair amount of additional effort to identify endtimes and relationships which may not be practical to do on many episodes (at least not the way I did it).