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

18 rows where institution_id = "ror:017zqws13" and year = 2027

✎ View and edit SQL

This data as json, CSV (advanced)

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

role 2

year 1

  • 2027 · 18 ✖
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
62125 62125 7346 2027 eshow:81519103-FF13-291F-8913-DF16694CEA7E 1 Presenter speaker Jack Christian University of Minnesota Twin Cities   p:jack-christian ror:017zqws13 eshow-listing-2027  
62150 62150 7371 2027 eshow:81522192-F8D4-86A0-78FA-65DFE2EFF624 6 Presenter speaker Timothy Amidon University of Minnesota   p:timothy-amidon ror:017zqws13 eshow-listing-2027  
62154 62154 7375 2027 eshow:81522192-F8D4-86A0-78FA-65DFE2EFF624 10 Presenter speaker Molly Kessler University of Minnesota-Twin Cities   p:molly-kessler ror:017zqws13 eshow-listing-2027  
62196 62196 7417 2027 eshow:815348A5-C339-F853-6084-A82114BC7212 2 Presenter speaker Hunter Whitt University of Minnesota   p:hunter-whitt ror:017zqws13 eshow-listing-2027  
62293 62293 7119 2027 eshow:8156ED1C-BD61-759B-649A-9D6E0275FFC8 16 Presenter speaker Rhiannon Zwieg University of Minnesota   p:rhiannon-zwieg ror:017zqws13 eshow-listing-2027  
62462 62462 7603 2027 eshow:815E2295-CCB8-C961-611E-E17EF99739FF 1 Presenter speaker Joe Moses University of Minnesota--Twin Cities   p:joseph-moses ror:017zqws13 eshow-listing-2027  
62510 62510 7642 2027 eshow:815FCBE5-ED70-D11A-CCAD-0F5CB4B2228D 3 Presenter speaker Stuart Deets University of Minnesota-Twin Cities   p:stuart-deets ror:017zqws13 eshow-listing-2027  
62603 62603 7717 2027 eshow:81623F36-978B-355C-F739-D6A3BD6DFBE9 1 Presenter speaker Audrey DeCelle University of Minnesota   p:audrey-decelle ror:017zqws13 eshow-listing-2027  
62734 62734 7827 2027 eshow:81685CF4-E78D-3B7C-36BE-ED4A9325FC20 1 Session Chair chair Jessa Wood University of Minnesota, Twin Cities   p:jessa-wood ror:017zqws13 eshow-listing-2027  
62735 62735 7828 2027 eshow:81685CF4-E78D-3B7C-36BE-ED4A9325FC20 2 Presenter speaker Daniel Emery University of Minnesota, Twin Cities   p:daniel-emery ror:017zqws13 eshow-listing-2027  
62736 62736 7829 2027 eshow:81685CF4-E78D-3B7C-36BE-ED4A9325FC20 3 Presenter speaker Matthew Luskey University of Minnesota, Twin Cities   p:matthew-luskey ror:017zqws13 eshow-listing-2027  
63062 63062 8115 2027 eshow:81784489-D70E-741A-E8D7-D9D29D035246 2 Presenter speaker Timothy Amidon University of Minnesota   p:timothy-amidon ror:017zqws13 eshow-listing-2027  
63169 63169 8222 2027 eshow:817B4A09-9C7F-75E0-852A-81EE088ADBFE 2 Presenter speaker Emily Gresbrink University of Minnesota   p:emily-gresbrink ror:017zqws13 eshow-listing-2027  
63516 63516 8546 2027 eshow:8191335C-9A5E-3987-317D-01CA06D1C64D 1 Presenter speaker Danielle Hinrichs University of Minnesota Twin Cities   p:danielle-hinrichs ror:017zqws13 eshow-listing-2027  
63517 63517 8547 2027 eshow:8191335C-9A5E-3987-317D-01CA06D1C64D 2 Presenter speaker Yasmine Telwana University of Minnesota Twin Cities   p:yasmine-telwana ror:017zqws13 eshow-listing-2027  
63518 63518 8548 2027 eshow:8191335C-9A5E-3987-317D-01CA06D1C64D 3 Presenter speaker Elise Toedt University of Minnesota Twin Cities   p:elise-toedt ror:017zqws13 eshow-listing-2027  
63519 63519 8549 2027 eshow:8191335C-9A5E-3987-317D-01CA06D1C64D 4 Presenter speaker Hanan Saadi University of Minnesota Twin Cities   p:hanan-saadi ror:017zqws13 eshow-listing-2027  
63520 63520 8550 2027 eshow:8191335C-9A5E-3987-317D-01CA06D1C64D 5 Presenter speaker Megan Mills-Rittmann University of Minnesota Twin Cities   p:megan-mills-rittmann ror:017zqws13 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);