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:01e3m7079", role = "Speakers" and year = 2019

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: session_id, ord, affiliation_as_printed, paper_title

year 1

  • 2019 · 14 ✖

role 1

  • Speakers · 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
44855 44855 51835 2019 pdf:2019:A.22 1 Speakers speaker Rhiannon Scharnhorst University of Cincinnati, OH   p:rhiannon-scharnhorst ror:01e3m7079 pdf-2019-2019__02__CCCC2019FullProgram.pdf 74
44856 44856 51836 2019 pdf:2019:A.22 2 Speakers speaker Rich Shivener University of Cincinnati, OH   p:rich-shivener ror:01e3m7079 pdf-2019-2019__02__CCCC2019FullProgram.pdf 74
45059 45059 51991 2019 pdf:2019:B.16 1 Speakers speaker Christopher Carter University of Cincinnati, OH   p:christopher-carter ror:01e3m7079 pdf-2019-2019__02__CCCC2019FullProgram.pdf 88
45060 45060 51992 2019 pdf:2019:B.16 2 Speakers speaker Daniel Floyd University of Cincinnati, OH Nineteenth-Century Composition Archive p:daniel-floyd ror:01e3m7079 pdf-2019-2019__02__CCCC2019FullProgram.pdf 88
45061 45061 51993 2019 pdf:2019:B.16 3 Speakers speaker Carla Sarr University of Cincinnati, OH Nineteenth-Century Composition Archive p:carla-sarr ror:01e3m7079 pdf-2019-2019__02__CCCC2019FullProgram.pdf 88
45147 45147 52071 2019 pdf:2019:B.34 4 Speakers speaker Aaron Kerley University of Cincinnati, OH Let It Blurt: Performative Agency and Popular Music Criticism p:aaron-kerley ror:01e3m7079 pdf-2019-2019__02__CCCC2019FullProgram.pdf 95
45310 45310 52125 2019 pdf:2019:C.3 3 Speakers speaker Kathleen Spada University of Cincinnati, OH Performative Feminist Rhetoric of Grailville p:kathleen-spada ror:01e3m7079 pdf-2019-2019__02__CCCC2019FullProgram.pdf 102
45583 45583 52515 2019 pdf:2019:E.11 3 Speakers speaker Daniel Sansing University of Cincinnati Blue Ash College, OH Responding Positively to Meltdowns on Campus p:daniel-sansing ror:01e3m7079 pdf-2019-2019__02__CCCC2019FullProgram.pdf 141
45837 45837 52801 2019 pdf:2019:F.30 2 Speakers speaker Christiane Boehr University of Cincinnati, OH Out-Performing Silences: Applied Empathy in Gendered Communal Writing p:christiane-boehr ror:01e3m7079 pdf-2019-2019__02__CCCC2019FullProgram.pdf 179
46060 46060 53000 2019 pdf:2019:G.33 2 Speakers speaker Ian Golding University of Cincinnati, OH Drawing Civic Identity: How Illustrations Shaped 19th-Century America p:ian-golding ror:01e3m7079 pdf-2019-2019__02__CCCC2019FullProgram.pdf 197
46230 46230 53174 2019 pdf:2019:H.34 3 Speakers speaker Gary Vaughn University of Cincinnati, OH ‘Yonder Comes the Kid and His Poke’: Language Performance from Family to the Classroom p:gary-vaughn ror:01e3m7079 pdf-2019-2019__02__CCCC2019FullProgram.pdf 217
46560 46560 53499 2019 pdf:2019:J.30 2 Speakers speaker Benjamin Hojem University of Cincinnati, OH Writing while Not White: The Racializing Influence of the Too-White Workshop p:benjamin-hojem ror:01e3m7079 pdf-2019-2019__02__CCCC2019FullProgram.pdf 249
46745 46745 53706 2019 pdf:2019:K.35 3 Speakers speaker Aleashia Walton Valentin University of Cincinnati, OH The Challenges of Representation in Charity Marketing p:aleashia-walton-valentin ror:01e3m7079 pdf-2019-2019__02__CCCC2019FullProgram.pdf 294
47361 47361 52686 2019 pdf:2019:TSIG.33 2 Speakers speaker Kathryn Rentz University of Cincinnati, OH   p:kathryn-rentz ror:01e3m7079 pdf-2019-2019__02__CCCC2019FullProgram.pdf 163

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