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

12 rows where institution_id = "ror:05qghxh33", role = "Presenter" and year = 2027

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: session_id, ord, affiliation_as_printed, person_id

year 1

  • 2027 · 12 ✖

role 1

  • Presenter · 12 ✖
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
62221 62221 7442 2027 eshow:815491BD-91A8-6949-01B4-AA26F84BC987 3 Presenter speaker Stephanie Wade Stony Brook University   p:stephanie-wade ror:05qghxh33 eshow-listing-2027  
62338 62338 7537 2027 eshow:815B233F-E702-E1FE-D41E-344472242E2A 2 Presenter speaker Stephanie Wade Stony Brook University   p:stephanie-wade ror:05qghxh33 eshow-listing-2027  
63105 63105 8158 2027 eshow:817983E0-99F8-C79E-E802-073E3805605C 1 Presenter speaker Stephanie Wade Stony Brook University   p:stephanie-wade ror:05qghxh33 eshow-listing-2027  
63106 63106 8159 2027 eshow:817983E0-99F8-C79E-E802-073E3805605C 2 Presenter speaker Cathleen Rowley Stony Brook University   p:cathleen-rowley ror:05qghxh33 eshow-listing-2027  
63107 63107 8160 2027 eshow:817983E0-99F8-C79E-E802-073E3805605C 3 Presenter speaker Jill Robbins Stony Brook University   p:jill-robbins ror:05qghxh33 eshow-listing-2027  
63108 63108 8161 2027 eshow:817983E0-99F8-C79E-E802-073E3805605C 4 Presenter speaker Aroona Khan Stony Brook University   p:aroona-khan ror:05qghxh33 eshow-listing-2027  
63109 63109 8162 2027 eshow:817983E0-99F8-C79E-E802-073E3805605C 5 Presenter speaker Soni Adhikari Stony Brook University   p:soni-adhikari ror:05qghxh33 eshow-listing-2027  
63110 63110 8163 2027 eshow:817983E0-99F8-C79E-E802-073E3805605C 6 Presenter speaker Hui Wang Stony Brook University   p:hui-wang ror:05qghxh33 eshow-listing-2027  
63111 63111 8164 2027 eshow:817983E0-99F8-C79E-E802-073E3805605C 7 Presenter speaker Laura Marciano Stony Brook University   p:laura-marciano ror:05qghxh33 eshow-listing-2027  
63112 63112 8165 2027 eshow:817983E0-99F8-C79E-E802-073E3805605C 8 Presenter speaker Jennifer Young Stony Brook University   p:jennifer-young ror:05qghxh33 eshow-listing-2027  
63113 63113 8166 2027 eshow:817983E0-99F8-C79E-E802-073E3805605C 9 Presenter speaker Lori Carrierre Stony Brook University   p:lori-carrierre ror:05qghxh33 eshow-listing-2027  
63735 63735 8753 2027 eshow:819A4230-F289-7366-1737-4D6ED2D67111 2 Presenter speaker Shyam Sharma SUNY Stony Brook   p:shyam-sharma ror:05qghxh33 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);