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:05dk0ce17" and year = 2027

✎ View and edit SQL

This data as json, CSV (advanced)

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

year 1

  • 2027 · 11 ✖

role 1

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
62118 62118 7339 2027 eshow:81515001-94A5-CB7D-EA88-28149563734D 1 Presenter speaker Corita Fernando Washington State University   p:corita-fernando ror:05dk0ce17 eshow-listing-2027  
62119 62119 7340 2027 eshow:81515001-94A5-CB7D-EA88-28149563734D 2 Presenter speaker Valanci Villa Washington State University   p:valanci-villa ror:05dk0ce17 eshow-listing-2027  
63258 63258 8309 2027 eshow:818236E6-E81C-60A4-A9E0-72AC11ED1081 2 Presenter speaker Jeannie Griffin Bennett Washington State University Writing Center   p:jeannie-griffin-bennett ror:05dk0ce17 eshow-listing-2027  
63431 63431 8471 2027 eshow:818946DF-BCFC-2CBF-21E5-E51CA32F49B5 1 Presenter speaker Ilana Garnica Washington State University   p:ilana-garnica ror:05dk0ce17 eshow-listing-2027  
63593 63593 8620 2027 eshow:8194CF34-C1E1-E680-AB16-13E6C62242A4 1 Presenter speaker Bibhushana Poudyal Washington State University   p:bibhushana-poudyal ror:05dk0ce17 eshow-listing-2027  
63594 63594 8621 2027 eshow:8194CF34-C1E1-E680-AB16-13E6C62242A4 2 Presenter speaker Melissa Nicolas Washington State University   p:melissa-nicolas ror:05dk0ce17 eshow-listing-2027  
63595 63595 8622 2027 eshow:8194CF34-C1E1-E680-AB16-13E6C62242A4 3 Presenter speaker Sumaiya Sarker Sharmin Washington State University   p:sumaiya-sarker-sharmin ror:05dk0ce17 eshow-listing-2027  
63596 63596 8623 2027 eshow:8194CF34-C1E1-E680-AB16-13E6C62242A4 4 Presenter speaker Sara Brock Washington State University   p:sara-brock ror:05dk0ce17 eshow-listing-2027  
63597 63597 8624 2027 eshow:8194CF34-C1E1-E680-AB16-13E6C62242A4 5 Presenter speaker Prakash Paudel Washington State University   p:prakash-paudel ror:05dk0ce17 eshow-listing-2027  
63656 63656 8683 2027 eshow:8196BCAA-020B-D1A3-0A6D-A9201E5E5106 5 Presenter speaker Prakash Paudel Washington State University   p:prakash-paudel ror:05dk0ce17 eshow-listing-2027  
63776 63776 8793 2027 eshow:819DDC5C-CEEF-39C7-28EC-BF7661737F24 1 Presenter speaker Geoffrey Clegg Washington State University   p:geoffrey-clegg ror:05dk0ce17 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);