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

7 rows where institution_id = "ror:05x2bcf33" and year = 2027

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: session_id, ord, role_group, name_as_printed, person_id

role 2

year 1

  • 2027 · 7 ✖
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
62597 62597 7208 2027 eshow:816221CB-D9F8-E35A-197A-383F67BE3438 3 Presenter speaker Danielle Zawodny Wetzel Carnegie Mellon University   p:danielle-zawodny-wetzel ror:05x2bcf33 eshow-listing-2027  
62809 62809 7889 2027 eshow:816B7F6F-C659-CB9A-1D74-A960044C0059 4 Respondent respondent Danielle Zawodny Wetzel Carnegie Mellon University   p:danielle-zawodny-wetzel ror:05x2bcf33 eshow-listing-2027  
63359 63359 8399 2027 eshow:81866F0D-BC70-F11F-F378-42B864E857FB 1 Presenter speaker Danielle Zawodny Wetzel Carnegie Mellon University   p:danielle-zawodny-wetzel ror:05x2bcf33 eshow-listing-2027  
63361 63361 8401 2027 eshow:81866F0D-BC70-F11F-F378-42B864E857FB 3 Presenter speaker Paul Beer Carnegie Mellon University   p:paul-beer ror:05x2bcf33 eshow-listing-2027  
63362 63362 8402 2027 eshow:81866F0D-BC70-F11F-F378-42B864E857FB 4 Presenter speaker Suguru Ishizaki Carnegie Mellon University   p:suguru-ishizaki ror:05x2bcf33 eshow-listing-2027  
63478 63478 8518 2027 eshow:818F93EB-0571-5F68-E4CD-C1BAE683CFD5 1 Presenter speaker Chris Mayer Carnegie Mellon University   p:chris-mayer ror:05x2bcf33 eshow-listing-2027  
63481 63481 8521 2027 eshow:818FC20C-D56D-A612-47C2-0C27E5084649 2 Presenter speaker Jungwan Yoon Carnegie Mellon University   p:jungwan-yoon ror:05x2bcf33 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);