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 = 2006

✎ View and edit SQL

This data as json, CSV (advanced)

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

year 1

  • 2006 · 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
10366 10366 17465 2006 pdf:2006:F.28 2 Speakers speaker Jenn Fishman University of Tennessee, Knoxville   p:jenn-fishman ror:020f3ap87 pdf-2006-2006__2006programfriday.pdf 11
10367 10367 17466 2006 pdf:2006:F.28 3 Speakers speaker Bill Doyle University of Tennessee, Knoxville   p:bill-doyle ror:020f3ap87 pdf-2006-2006__2006programfriday.pdf 11
10368 10368 17467 2006 pdf:2006:F.28 4 Speakers speaker Amanda Watkins University of Tennessee, Knoxville   p:amanda-watkins ror:020f3ap87 pdf-2006-2006__2006programfriday.pdf 11
10369 10369 17468 2006 pdf:2006:F.28 5 Speakers speaker Miya Abbott University of Tennessee, Knoxville   p:miya-abbott ror:020f3ap87 pdf-2006-2006__2006programfriday.pdf 11
10370 10370 17469 2006 pdf:2006:F.28 6 Speakers speaker Casie Fedukovich University of Tennessee, Knoxville   p:casie-fedukovich ror:020f3ap87 pdf-2006-2006__2006programfriday.pdf 11
10371 10371 17470 2006 pdf:2006:F.28 7 Speakers speaker Stacey Pigg University of Tennessee, Knoxville   p:stacey-pigg ror:020f3ap87 pdf-2006-2006__2006programfriday.pdf 11
10657 10657 17593 2006 pdf:2006:G.23 4 Speakers speaker Mary Jo Reiff University of Tennessee, Knoxville The Public Petition as Center Space between Critique and Change p:mary-jo-reiff ror:020f3ap87 pdf-2006-2006__2006programfriday.pdf 25
10872 10872 17804 2006 pdf:2006:H.30 3 Speakers speaker Matthew Abraham University of Tennessee-Knoxville Activist Rhetorics, Activist Rhetoricians: What Are We Acting Toward? p:matthew-abraham ror:020f3ap87 pdf-2006-2006__2006programfriday.pdf 46
11938 11938 16080 2006 pdf:2006:W.6 3 Speakers speaker Matthew Abraham University of Tennessee, Knoxville   p:matthew-abraham ror:020f3ap87 pdf-2006-2006__2006programwednesday.pdf 13
11945 11945 16087 2006 pdf:2006:W.6 10 Speakers speaker Donald Lazere University of Tennessee, Knoxville   p:donald-lazere ror:020f3ap87 pdf-2006-2006__2006programwednesday.pdf 13

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