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

11 rows where institution_id = "ror:03nawhv43" and role = "Presenter"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: session_id, ord, affiliation_as_printed

year 1

role 1

  • Presenter · 11 ✖
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
62113 62113 7334 2027 eshow:81512838-CEC7-B68C-FC19-F7EEE1686F35 1 Presenter speaker Kimberly Turner-Shukis University of California Riverside   p:kimberly-turner-shukis ror:03nawhv43 eshow-listing-2027  
62114 62114 7335 2027 eshow:81512838-CEC7-B68C-FC19-F7EEE1686F35 2 Presenter speaker Devon Hackelton University of California Riverside   p:devon-hackelton ror:03nawhv43 eshow-listing-2027  
62115 62115 7336 2027 eshow:81512838-CEC7-B68C-FC19-F7EEE1686F35 3 Presenter speaker Joanna Bradfield University of California Riverside   p:joanna-bradfield ror:03nawhv43 eshow-listing-2027  
62215 62215 7436 2027 eshow:815471D8-B209-62DA-CA25-9A1BA3DD80A5 1 Presenter speaker Anne Sullivan University of California, Riverside   p:anne-sullivan ror:03nawhv43 eshow-listing-2027  
62216 62216 7437 2027 eshow:815471D8-B209-62DA-CA25-9A1BA3DD80A5 2 Presenter speaker Grant Palmer University of California, Riverside   p:grant-palmer ror:03nawhv43 eshow-listing-2027  
62217 62217 7438 2027 eshow:815471D8-B209-62DA-CA25-9A1BA3DD80A5 3 Presenter speaker Jennie Friedrich University of California, Riverside   p:jennie-friedrich ror:03nawhv43 eshow-listing-2027  
62257 62257 7478 2027 eshow:8155B246-FF1F-D59F-897C-DD97B6F34725 1 Presenter speaker Jungmin Lee University of California, Riverside   p:jungmin-lee ror:03nawhv43 eshow-listing-2027  
62258 62258 7479 2027 eshow:8155B246-FF1F-D59F-897C-DD97B6F34725 2 Presenter speaker Paul Beehler University of California, Riverside   p:paul-beehler ror:03nawhv43 eshow-listing-2027  
63385 63385 8425 2027 eshow:818784E4-EF8A-AE63-39EC-2FBF7613A17E 3 Presenter speaker Jaclyn Vasquez University of California, Riverside   p:jaclyn-vasquez ror:03nawhv43 eshow-listing-2027  
63576 63576 8603 2027 eshow:8193C1C6-03B1-1C95-EFD2-F8FF62041DC6 1 Presenter speaker Clare O'Brien University of California, Riverside   p:clare-o-brien ror:03nawhv43 eshow-listing-2027  
63577 63577 8604 2027 eshow:8193C1C6-03B1-1C95-EFD2-F8FF62041DC6 2 Presenter speaker Vlad Sirbu University of California, Riverside   p:vlad-sirbu ror:03nawhv43 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);