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

6 rows where institution_id = "ror:04qk6pt94" and year = 2018

✎ View and edit SQL

This data as json, CSV (advanced)

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

year 1

  • 2018 · 6 ✖
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
43069 43069 49847 2018 pdf:2018:D.5 3 Speakers speaker Nancy Mack Wright State University, Dayton, OH Working-Class Students Need to Write about Their Lives: Critical Narratives and Emotional Labor p:nancy-mack ror:04qk6pt94 pdf-2018-2018__program__program.pdf 131
43166 43166 50156 2018 pdf:2018:E.26 2 Speakers speaker Deborah Crusan Wright State University, Dayton, OH A Missionary’s Assessment of the Hegemony of SLMN p:deborah-crusan ror:04qk6pt94 pdf-2018-2018__program__program.pdf 169
43392 43392 50368 2018 pdf:2018:F.43 7 Speakers speaker Jennifer Ware Wright State University, Dayton, OH Rhetorical Bursts in the Ambient Soundscape: ‘Nat Pops’ in the Field p:jennifer-ware ror:04qk6pt94 pdf-2018-2018__program__program.pdf 194
44323 44323 51304 2018 pdf:2018:L.21 1 Chair chair David Seitz Wright State University, Dayton, OH   p:david-seitz ror:04qk6pt94 pdf-2018-2018__program__program.pdf 319
44324 44324 51305 2018 pdf:2018:L.21 2 Speakers speaker Anthony Edgington University of Toledo, OH, Ashley Hall, Wright State University, Dayton, OH   p:anthony-edgington ror:04qk6pt94 pdf-2018-2018__program__program.pdf 319
44661 44661 51505 2018 pdf:2018:SW.6 3 Workshop Facilitators facilitator Gerald Nelms Wright State University, Dayton, OH   p:gerald-nelms ror:04qk6pt94 pdf-2018-2018__program__program.pdf 338

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