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

6 rows where institution_id = "ror:012zs8222", role = "Speaker(s)" and year = 2025

✎ View and edit SQL

This data as json, CSV (advanced)

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

year 1

  • 2025 · 6 ✖

role 1

  • Speaker(s) · 6 ✖
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
57854 57854 4346 2025 eshow:671AF34E-FFD9-2E30-BE2B-E0B1F4804CCB 4 Speaker(s) speaker Craig Hancock University at Albany (SUNY) Emeritus   p:craig-hancock ror:012zs8222 eshow-listing-2025 42
59039 59039 4392 2025 eshow:6732C33F-D17D-D42E-D87A-25AF06463C07 3 Speaker(s) speaker Craig Hancock University at Albany (SUNY) Emeritus   p:craig-hancock ror:012zs8222 eshow-listing-2025 185
59041 59041 4394 2025 eshow:6732C33F-D17D-D42E-D87A-25AF06463C07 5 Speaker(s) speaker Amber Jackson University at Albany   p:amber-jackson ror:012zs8222 eshow-listing-2025 185
59042 59042 4395 2025 eshow:6732C33F-D17D-D42E-D87A-25AF06463C07 6 Speaker(s) speaker Casandra Murray University at Albany   p:casandra-murray ror:012zs8222 eshow-listing-2025 186
59458 59458 4204 2025 eshow:673B24C4-E80A-AAAE-53BF-B14C8853FDAB 4 Speaker(s) speaker Laura Wilder University at Albany, SUNY   p:laura-wilder ror:012zs8222 eshow-listing-2025 206
59989 59989 5013 2025 eshow:76F00335-AC59-097D-AF71-DE837DF30F09 7 Speaker(s) speaker Laura Wilder University at Albany, SUNY   p:laura-wilder ror:012zs8222 eshow-listing-2025 40

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);