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

7 rows where institution_id = "ror:04p491231", role = "Chair" and year = 2010

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: affiliation_as_printed

year 1

  • 2010 · 7 ✖

role 1

  • Chair · 7 ✖
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
20435 20435 27350 2010 pdf:2010:B.11 1 Chair chair Jon Olson The Pennsylvania State University, State College   p:jon-olson ror:04p491231 pdf-2010-2010__cccc2010-program.pdf 94
20908 20908 27665 2010 pdf:2010:D.5 1 Chair chair Suresh Canagarajah The Pennsylvania State University, University Park   p:suresh-canagarajah ror:04p491231 pdf-2010-2010__cccc2010-program.pdf 124
21355 21355 28280 2010 pdf:2010:G.23 1 Chair chair Keith Gilyard The Pennsylvania State University, University Park   p:keith-gilyard ror:04p491231 pdf-2010-2010__cccc2010-program.pdf 179
21520 21520 28373 2010 pdf:2010:H.2 1 Chair chair Sharon M. Gallagher Penn State, Erie   p:sharon-gallagher ror:04p491231 pdf-2010-2010__cccc2010-program.pdf 188
21785 21785 28706 2010 pdf:2010:I.39 1 Chair chair Kimberly Quiogue Andrews The Pennsylvania State University, State College   p:kimberly-quiogue-andrews ror:04p491231 pdf-2010-2010__cccc2010-program.pdf 217
21964 21964 28733 2010 pdf:2010:J.4 1 Chair chair Catherine G. Latterell Penn State Altoona   p:catherine-latterell ror:04p491231 pdf-2010-2010__cccc2010-program.pdf 221
22132 22132 29059 2010 pdf:2010:K.42 1 Chair chair Cheryl Glenn The Pennsylvania State University, University Park   p:cheryl-glenn ror:04p491231 pdf-2010-2010__cccc2010-program.pdf 249

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