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

17 rows where institution_id = "ror:01y2jtd41", role = "Presenter" 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 · 17 ✖

role 1

  • Presenter · 17 ✖
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
62211 62211 7432 2027 eshow:815443F9-D0FB-651A-165D-A73001820E59 1 Presenter speaker Will Kurlinkus University of Wisconsin-Madison   p:william-c-kurlinkus ror:01y2jtd41 eshow-listing-2027  
62367 62367 7557 2027 eshow:815C5BAF-973B-E908-CE46-10152C6DFC98 4 Presenter speaker Sujash Purna University of Wisconsin-Madison   p:sujash-purna ror:01y2jtd41 eshow-listing-2027  
62490 62490 7622 2027 eshow:815EE76F-C94A-4B55-D337-972E15B55ADB 6 Presenter speaker Morris Young University of Wisconsin-Madison   p:morris-young ror:01y2jtd41 eshow-listing-2027  
62748 62748 7841 2027 eshow:8168ADE6-D50B-1053-AB88-60F3F0E25D15 5 Presenter speaker Caden Holbrook University of Wisconsin-Madison   p:caden-holbrook ror:01y2jtd41 eshow-listing-2027  
62788 62788 7242 2027 eshow:816A75ED-EB02-7ACB-9D86-148858C13C89 2 Presenter speaker Libby Burton University of Wisconsin-Madison   p:libby-burton ror:01y2jtd41 eshow-listing-2027  
62848 62848 7907 2027 eshow:816CCF5D-D93F-6A6B-5FB1-58605E660E95 1 Presenter speaker Matthew Louie University of Wisconsin-Madison   p:matthew-louie ror:01y2jtd41 eshow-listing-2027  
62849 62849 7908 2027 eshow:816CCF5D-D93F-6A6B-5FB1-58605E660E95 2 Presenter speaker Grace Atkins University of Wisconsin Madison   p:grace-atkins ror:01y2jtd41 eshow-listing-2027  
62942 62942 7997 2027 eshow:81702266-CCDF-ECFE-9E07-0C9062FE7B45 3 Presenter speaker Kate Vieira University of Wisconsin, Madison   p:kate-vieira ror:01y2jtd41 eshow-listing-2027  
63102 63102 8155 2027 eshow:81796652-D5B4-0C37-64CE-D892A9ACCDEE 3 Presenter speaker Sujash Purna University of Wisconsin-Madison   p:sujash-purna ror:01y2jtd41 eshow-listing-2027  
63205 63205 8258 2027 eshow:817D22FF-ADBB-09CC-5270-CD20F0D22126 1 Presenter speaker Shourya Mohaniya University of Wisconsin-Madison   p:shourya-mohaniya ror:01y2jtd41 eshow-listing-2027  
63206 63206 8259 2027 eshow:817D22FF-ADBB-09CC-5270-CD20F0D22126 2 Presenter speaker Taylor Dickson University of Wisconsin-Madison   p:taylor-dickson ror:01y2jtd41 eshow-listing-2027  
63365 63365 8405 2027 eshow:818698B5-EB0E-462E-1ECA-173971A96526 1 Presenter speaker Caroline Hensley University of Wisconsin-Madison   p:caroline-hensley ror:01y2jtd41 eshow-listing-2027  
63367 63367 8407 2027 eshow:818698B5-EB0E-462E-1ECA-173971A96526 3 Presenter speaker Eileen Lagman University of Wisconsin-Madison   p:eileen-lagman ror:01y2jtd41 eshow-listing-2027  
63378 63378 8418 2027 eshow:818755A2-F263-2663-2344-D9FFA9826750 1 Presenter speaker Alexandra Chakov University of Wisconsin-Madison   p:alexandra-chakov ror:01y2jtd41 eshow-listing-2027  
63461 63461 8501 2027 eshow:818B2C61-BB70-049A-4283-6772ACAFB40A 1 Presenter speaker Ludmila Rao University of Wisconsin Madison   p:ludmila-rao ror:01y2jtd41 eshow-listing-2027  
63581 63581 8608 2027 eshow:8193F8F4-F0F7-F030-DAE4-E274F3584721 2 Presenter speaker Erin Miller University of WIsconsin-Madison   p:erin-miller ror:01y2jtd41 eshow-listing-2027  
63791 63791 8808 2027 eshow:BB8685C6-F226-85E1-5284-42CD73B39EC5 3 Presenter speaker Javier Rosario University of Wisconsin-Madison   p:javier-rosario ror:01y2jtd41 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);