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

10 rows where institution_id = "ror:020f3ap87", role = "Speakers" and year = 2020

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ord, affiliation_as_printed, source_document_id

year 1

  • 2020 · 10 ✖

role 1

  • Speakers · 10 ✖
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
47830 47830 54744 2020 pdf:2020:B.24 4 Speakers speaker Rik Hunter University of Tennessee, Chattanooga A Sense of the Commonplace: Campus and Community Boundaries and Meeting Places p:rik-hunter ror:020f3ap87 pdf-2020-2018__06__2020CCCCThurs.pdf 30
47895 47895 54803 2020 pdf:2020:B.43 3 Speakers speaker Allie Johnston The University of Tennessee, Knoxville Transfer and Writing Support p:allie-johnston ror:020f3ap87 pdf-2020-2018__06__2020CCCCThurs.pdf 37
47944 47944 54869 2020 pdf:2020:C.12 5 Speakers speaker Holland Prior University of Tennessee, Knoxville   p:holland-prior ror:020f3ap87 pdf-2020-2018__06__2020CCCCThurs.pdf 47
48140 48140 54990 2020 pdf:2020:D.2 4 Speakers speaker Jeffrey Michael Ringer University of Tennessee, Knoxville   p:jeffrey-ringer ror:020f3ap87 pdf-2020-2018__06__2020CCCCThurs.pdf 62
48319 48319 55233 2020 pdf:2020:E.31 2 Speakers speaker Sean Morey University of Tennessee Going Hyper: Beyond Linking p:sean-morey ror:020f3ap87 pdf-2020-2018__06__2020CCCCThurs.pdf 91
48864 48864 55597 2020 pdf:2020:G.8 3 Speakers speaker Megan Von Bergen University of Tennessee, Knoxville   p:megan-von-bergen ror:020f3ap87 pdf-2020-2020__02__2020CCCCFri.pdf 28
49081 49081 55994 2020 pdf:2020:I.18 4 Speakers speaker Zoi Traga Philippakos University of Tennessee   p:zoi-traga-philippakos ror:020f3ap87 pdf-2020-2020__02__2020CCCCFri.pdf 79
49174 49174 56077 2020 pdf:2020:I.44 2 Speakers speaker Jennifer Beech University of Tennessee, Chattanooga Oh, Come On! Of Course That Address Made You Uncomfortable: Moving beyond Shame to Allyship p:jennifer-beech ror:020f3ap87 pdf-2020-2020__02__2020CCCCFri.pdf 90
49208 49208 56106 2020 pdf:2020:I.51 2 Speakers speaker Kelle Alden University of Tennessee, Martin Writing Center Studies and Creative Writing Studies: A Call for Departmental Partnerships p:kelle-alden ror:020f3ap87 pdf-2020-2020__02__2020CCCCFri.pdf 93
49571 49571 56568 2020 pdf:2020:L.16 4 Speakers speaker Lauren Ingraham University of Tennessee, Chattanooga The Balance between First-Year Composition and WAC/WID May Create a Strain on Resources p:lauren-ingraham ror:020f3ap87 pdf-2020-2020__02__2020CCCCSat.pdf 27

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