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

14 rows where institution_id = "ror:020f3ap87" and year = 2018

✎ View and edit SQL

This data as json, CSV (advanced)

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

year 1

  • 2018 · 14 ✖
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
42330 42330 49241 2018 pdf:2018:A.4 2 Speakers speaker Lisa King University of Tennessee, Knoxville Beads, Vamps, and Bearing Witness: Walking with Our Sisters and the Rhetorical Tangibility of Unfinished Lives p:lisa-king ror:020f3ap87 pdf-2018-2018__program__program.pdf 67
42372 42372 49431 2018 pdf:2018:A.46 8 Respondents respondent Jeffrey Ringer University of Tennessee, Knoxville   p:jeffrey-ringer ror:020f3ap87 pdf-2018-2018__program__program.pdf 83
42450 42450 49116 2018 pdf:2018:AW.13 12 Workshop Facilitators facilitator Lauren Ingraham University of Tennessee, Chattanooga   p:lauren-ingraham ror:020f3ap87 pdf-2018-2018__program__program.pdf 47
43060 43060 50017 2018 pdf:2018:D.45 1 Speakers speaker Trisha Capansky University of Tennessee, Martin   p:trisha-capansky ror:020f3ap87 pdf-2018-2018__program__program.pdf 147
43061 43061 50018 2018 pdf:2018:D.45 2 Speakers speaker David Carithers University of Tennessee, Martin   p:david-carithers ror:020f3ap87 pdf-2018-2018__program__program.pdf 147
43062 43062 50019 2018 pdf:2018:D.45 3 Speakers speaker Tim Hacker University of Tennessee, Martin   p:tim-hacker ror:020f3ap87 pdf-2018-2018__program__program.pdf 147
43063 43063 50020 2018 pdf:2018:D.45 4 Speakers speaker Heidi Huse University of Tennessee, Martin   p:heidi-huse ror:020f3ap87 pdf-2018-2018__program__program.pdf 147
43551 43551 50380 2018 pdf:2018:G.6 3 Speakers speaker Jeffrey Ringer University of Tennessee, Knoxville   p:jeffrey-ringer ror:020f3ap87 pdf-2018-2018__program__program.pdf 201
43603 43603 50585 2018 pdf:2018:H.20 2 Speakers speaker Jennifer Beech University of Tennessee, Chattanooga The Hard Work of Producing and Consuming Satire in the Age of Trump: Teaching Humor Writing as Civic Engagement p:jennifer-beech ror:020f3ap87 pdf-2018-2018__program__program.pdf 222
43758 43758 50709 2018 pdf:2018:I.1 1 Co-Chairs chair Jennifer Beech University of Tennessee, Chattanooga   p:jennifer-beech ror:020f3ap87 pdf-2018-2018__program__program.pdf 233
43772 43772 50747 2018 pdf:2018:I.12 3 Speakers speaker Tanita Saenkhum University of Tennessee, Knoxville The Placement of L2 Writers into First-Year Composition Courses in US Colleges and Universities: A Nationwide Survey p:tanita-saenkhum ror:020f3ap87 pdf-2018-2018__program__program.pdf 237
43774 43774 50749 2018 pdf:2018:I.12 5 Speakers speaker Joseph Wilson University of Tennessee, Knoxville A Continual Assessment of Placement Procedures for L2 Writers p:joseph-wilson ror:020f3ap87 pdf-2018-2018__program__program.pdf 237
44464 44464 51443 2018 pdf:2018:M.21 4 Speakers speaker Sean Morey University of Tennessee, Knoxville On the Edge of Nature: Natural Discourse through AR p:sean-morey ror:020f3ap87 pdf-2018-2018__program__program.pdf 333
44684 44684 50051 2018 pdf:2018:TSIG.21 5 Speaker speaker Elizabeth Leahy University of Tennessee, Chattanooga   p:elizabeth-leahy ror:020f3ap87 pdf-2018-2018__program__program.pdf 156

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