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:02dqehb95", role = "Chair" and year = 2020

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: session_id, ord, affiliation_as_printed, source_document_id

year 1

  • 2020 · 11 ✖

role 1

  • Chair · 11 ✖
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
47587 47587 54600 2020 pdf:2020:A.34 2 Chair chair Sweta Baniya Purdue University   p:sweta-baniya ror:02dqehb95 pdf-2020-2018__06__2020CCCCThurs.pdf 15
47799 47799 54721 2020 pdf:2020:B.19 1 Chair chair Michael Salvo Purdue University Open Access: From the Classroom to the Globe p:michael-salvo ror:02dqehb95 pdf-2020-2018__06__2020CCCCThurs.pdf 28
47800 47800 54722 2020 pdf:2020:B.19 2 Chair chair Mattie Bruton Purdue University Open Access and the Interface: Accessibility Remediation Plans p:mattie-bruton ror:02dqehb95 pdf-2020-2018__06__2020CCCCThurs.pdf 28
47801 47801 54723 2020 pdf:2020:B.19 3 Chair chair Ryan Murphy Purdue University International Perspectives on Inclusion and OA p:ryan-murphy ror:02dqehb95 pdf-2020-2018__06__2020CCCCThurs.pdf 28
47802 47802 54724 2020 pdf:2020:B.19 4 Chair chair Shyam B. Pandey Purdue University Who’s Really Paying for That Shrimp Cocktail: Academic Textbook Publishing and OA Alternatives p:shyam-pandey ror:02dqehb95 pdf-2020-2018__06__2020CCCCThurs.pdf 28
47803 47803 54725 2020 pdf:2020:B.19 5 Chair chair Mason Pellegrini Purdue University Family, Community, and Open Access Scholarship p:mason-pellegrini ror:02dqehb95 pdf-2020-2018__06__2020CCCCThurs.pdf 28
47804 47804 54726 2020 pdf:2020:B.19 6 Chair chair Shelton Weech Purdue University   p:shelton-weech ror:02dqehb95 pdf-2020-2018__06__2020CCCCThurs.pdf 28
48137 48137 54987 2020 pdf:2020:D.2 1 Chair chair Bradley Dilger Purdue University   p:bradley-dilger ror:02dqehb95 pdf-2020-2018__06__2020CCCCThurs.pdf 62
48690 48690 55619 2020 pdf:2020:G.15 1 Chair chair Kaden Milliren Purdue University, West Lafayette, IN   p:kaden-c-milliren ror:02dqehb95 pdf-2020-2020__02__2020CCCCFri.pdf 31
48697 48697 55626 2020 pdf:2020:G.17 1 Chair chair Tony Silva Purdue University, West Lafayette, IN   p:tony-silva ror:02dqehb95 pdf-2020-2020__02__2020CCCCFri.pdf 32
49073 49073 55986 2020 pdf:2020:I.17 1 Chair chair Rachel Atherton Purdue University, West Lafayette, IN   p:rachel-atherton ror:02dqehb95 pdf-2020-2020__02__2020CCCCFri.pdf 79

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