appearances

One row per name listed in a session, with the name, affiliation and paper title exactly as printed, and the matched person and institution.

Data license: CC BY 4.0 (data), MIT (code) · Data source: Source code, methods and known limits

10 rows where institution_id = "ror:03taz7m60" and year = 2027

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: session_id, ord, role_group, affiliation_as_printed

role 2

year 1

  • 2027 · 10 ✖
Link rowid ▼ id year session_id ord role role_group name_as_printed affiliation_as_printed paper_title person_id institution_id source_document_id page
62203 62203 7424 2027 eshow:8153F9CE-E7DB-1ED8-C7DB-8301A0276E69 1 Presenter speaker Liz Blomstedt University of Southern California   p:liz-blomstedt ror:03taz7m60 eshow-listing-2027  
62204 62204 7425 2027 eshow:8153F9CE-E7DB-1ED8-C7DB-8301A0276E69 2 Presenter speaker Z. D. Dochterman University of Southern California   p:z-d-dochterman ror:03taz7m60 eshow-listing-2027  
62205 62205 7426 2027 eshow:8153F9CE-E7DB-1ED8-C7DB-8301A0276E69 3 Presenter speaker Jen Bankard University of Southern California   p:jennifer-bankard ror:03taz7m60 eshow-listing-2027  
62206 62206 7427 2027 eshow:8153F9CE-E7DB-1ED8-C7DB-8301A0276E69 4 Presenter speaker Dan Pecchenino University of Southern California   p:daniel-pecchenino ror:03taz7m60 eshow-listing-2027  
62346 62346 7128 2027 eshow:815BCA7C-A077-1A6E-68F7-051768C0735E 3 Facilitator facilitator Patricia Taylor University of Southern California   p:patricia-taylor ror:03taz7m60 eshow-listing-2027  
62767 62767 7238 2027 eshow:81699DE0-994A-94B8-34B3-25B241B4E151 7 Presenter speaker Kate Levin University of Southern California   p:kate-levin ror:03taz7m60 eshow-listing-2027  
62768 62768 7239 2027 eshow:81699DE0-994A-94B8-34B3-25B241B4E151 8 Presenter speaker Ryan Boyd University of Southern California   p:ryan-boyd ror:03taz7m60 eshow-listing-2027  
63532 63532 8559 2027 eshow:8191BDFF-9BBF-1F89-B859-81B645244ED1 1 Presenter speaker Rory Lukins University of Southern California   p:rory-lukins ror:03taz7m60 eshow-listing-2027  
63533 63533 8560 2027 eshow:8191BDFF-9BBF-1F89-B859-81B645244ED1 2 Presenter speaker Tamara Black The Writing Program, University of Southern California   p:tamara-black ror:03taz7m60 eshow-listing-2027  
63747 63747 8765 2027 eshow:819ACCB7-A579-3F9B-6B0E-F7E36053CBE1 1 Presenter speaker Vanessa Osborne The Writing Program at the University of Southern California   p:vanessa-osborne ror:03taz7m60 eshow-listing-2027  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE appearances (id INTEGER, year INTEGER, session_id TEXT, ord INTEGER, role TEXT, role_group TEXT, name_as_printed TEXT, affiliation_as_printed TEXT, paper_title TEXT, person_id TEXT, institution_id TEXT, source_document_id TEXT, page INTEGER);
CREATE INDEX ix_appearances_session_id ON appearances(session_id);
CREATE INDEX ix_appearances_person_id ON appearances(person_id);
CREATE INDEX ix_appearances_institution_id ON appearances(institution_id);
CREATE INDEX ix_appearances_year ON appearances(year);