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

15 rows where institution_id = "ror:03taz7m60", role = "Speakers" and year = 2019

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: session_id, ord, page

year 1

  • 2019 · 15 ✖

role 1

  • Speakers · 15 ✖
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
44811 44811 51796 2019 pdf:2019:A.12 1 Speakers speaker Jim Clements University of Southern California, Los Angeles   p:james-clements ror:03taz7m60 pdf-2019-2019__02__CCCC2019FullProgram.pdf 70
44812 44812 51797 2019 pdf:2019:A.12 2 Speakers speaker Jim Condon University of Southern California, Los Angeles   p:james-condon ror:03taz7m60 pdf-2019-2019__02__CCCC2019FullProgram.pdf 70
44814 44814 51799 2019 pdf:2019:A.12 4 Speakers speaker David Tomkins University of Southern California, Los Angeles   p:david-tomkins ror:03taz7m60 pdf-2019-2019__02__CCCC2019FullProgram.pdf 70
45462 45462 52388 2019 pdf:2019:D.26 1 Speakers speaker Tamara Black University of Southern California, Los Angeles   p:tamara-black ror:03taz7m60 pdf-2019-2019__02__CCCC2019FullProgram.pdf 129
45463 45463 52389 2019 pdf:2019:D.26 2 Speakers speaker Daniel Dissinger University of Southern California, Los Angeles   p:daniel-dissinger ror:03taz7m60 pdf-2019-2019__02__CCCC2019FullProgram.pdf 129
45464 45464 52390 2019 pdf:2019:D.26 3 Speakers speaker Amber Foster University of Southern California, Los Angeles   p:amber-foster ror:03taz7m60 pdf-2019-2019__02__CCCC2019FullProgram.pdf 129
45499 45499 52422 2019 pdf:2019:D.34 3 Speakers speaker Brent Chappelow University of Southern California, Los Angeles Rhetorical Performance, Audience, and Cultural Memories: A Historical Case Study of Performance-Rhetoric p:brent-chappelow ror:03taz7m60 pdf-2019-2019__02__CCCC2019FullProgram.pdf 132
45525 45525 52310 2019 pdf:2019:D.4 3 Speakers speaker Kate Partridge University of Southern California, Los Angeles   p:kate-partridge ror:03taz7m60 pdf-2019-2019__02__CCCC2019FullProgram.pdf 122
45744 45744 52505 2019 pdf:2019:E.8 1 Speakers speaker Emily Artiano University of Southern California, Los Angeles   p:emily-artiano ror:03taz7m60 pdf-2019-2019__02__CCCC2019FullProgram.pdf 140
45745 45745 52506 2019 pdf:2019:E.8 2 Speakers speaker Stephanie Bower University of Southern California, Los Angeles   p:stephanie-bower ror:03taz7m60 pdf-2019-2019__02__CCCC2019FullProgram.pdf 140
45953 45953 52903 2019 pdf:2019:G.10 2 Speakers speaker Jennifer Bankard University of Southern California, Los Angeles   p:jennifer-bankard ror:03taz7m60 pdf-2019-2019__02__CCCC2019FullProgram.pdf 189
45954 45954 52904 2019 pdf:2019:G.10 3 Speakers speaker Jeffrey Chisum University of Southern California, Los Angeles   p:jeffrey-chisum ror:03taz7m60 pdf-2019-2019__02__CCCC2019FullProgram.pdf 189
46392 46392 53332 2019 pdf:2019:I.31 2 Speakers speaker Antonio Elefano University of Southern California, Los Angeles Performing Professions: Legal Writing as Litmus Test for Prospective Attorneys p:antonio-elefano ror:03taz7m60 pdf-2019-2019__02__CCCC2019FullProgram.pdf 232
46792 46792 53731 2019 pdf:2019:L.1 2 Speakers speaker Mary Traester University of Southern California, Los Angeles Digital Annotation as Performance p:mary-traester ror:03taz7m60 pdf-2019-2019__02__CCCC2019FullProgram.pdf 298
46868 46868 53836 2019 pdf:2019:L.28 3 Speakers speaker Vanessa Osborne University of Southern California, Los Angeles Entering the Storehouse of Knowledge: Editing Wikipedia Stubs in the Composition Classroom p:vanessa-osborne ror:03taz7m60 pdf-2019-2019__02__CCCC2019FullProgram.pdf 307

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