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

17 rows where institution_id = "ror:04w7skc03", role = "Speakers" and year = 2023

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: session_id, ord, name_as_printed, person_id

year 1

  • 2023 · 17 ✖

role 1

  • Speakers · 17 ✖
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
52907 52907 59806 2023 pdf:2023:A.26 1 Speakers speaker Katherine M. Crowe University of Denver   p:katherine-crowe ror:04w7skc03 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 74
52908 52908 59807 2023 pdf:2023:A.26 2 Speakers speaker Robert Gilmor University of Denver   p:robert-gilmor ror:04w7skc03 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 74
52909 52909 59808 2023 pdf:2023:A.26 3 Speakers speaker Kamila Kinyon University of Denver   p:kamila-kinyon ror:04w7skc03 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 74
52910 52910 59809 2023 pdf:2023:A.26 4 Speakers speaker Madison Sussmann University of Denver   p:madison-sussmann ror:04w7skc03 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 74
52911 52911 59810 2023 pdf:2023:A.26 5 Speakers speaker Olivia Tracy University of Denver   p:olivia-tracy ror:04w7skc03 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 74
53259 53259 60109 2023 pdf:2023:C.32 1 Speakers speaker Russell Brakefield University of Denver   p:russell-brakefield ror:04w7skc03 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 114
53260 53260 60110 2023 pdf:2023:C.32 2 Speakers speaker David Daniels University of Denver   p:david-daniels ror:04w7skc03 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 114
53261 53261 60111 2023 pdf:2023:C.32 3 Speakers speaker LP Picard University of Denver   p:lp-picard ror:04w7skc03 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 114
53262 53262 60112 2023 pdf:2023:C.32 4 Speakers speaker Aubrey Schiavone University of Denver   p:aubrey-schiavone ror:04w7skc03 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 114
53749 53749 60606 2023 pdf:2023:G.14 2 Speakers speaker Matthew Hill University of Denver A Manifesto for Hope and Writing p:matt-hill ror:04w7skc03 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 181
53798 53798 60650 2023 pdf:2023:G.27 2 Speakers speaker David Riche University of Denver Pedagogy, Vulnerability, and Rhetorical Self-Care p:david-riche ror:04w7skc03 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 186
54167 54167 61075 2023 pdf:2023:J.26 1 Speakers speaker Rebekah Shultz Colby University of Denver Designing Affective Game Systems for Social Change p:rebekah-shultz-colby ror:04w7skc03 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 265
54168 54168 61076 2023 pdf:2023:J.26 2 Speakers speaker Richard Colby University of Denver Is Hope and Change Even Possible with Games in FYW? p:richard-colby ror:04w7skc03 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 265
54495 54495 61405 2023 pdf:2023:M.18 4 Speakers speaker Kara Taczak University of Denver   p:kara-taczak ror:04w7skc03 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 306
54590 54590 59578 2023 pdf:2023:MW.4 6 Speakers speaker Libby Catchings University of Denver   p:libby-catchings ror:04w7skc03 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 39
54895 54895 60372 2023 pdf:2023:TSIG.2 2 Speakers speaker Kara Taczak University of Denver   p:kara-taczak ror:04w7skc03 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 147
54926 54926 60386 2023 pdf:2023:TSIG.8 1 Speakers speaker Libby Catchings University of Denver   p:libby-catchings ror:04w7skc03 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 149

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