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

13 rows where institution_id = "ror:04w7skc03" and year = 2013

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: session_id, ord, role_group, name_as_printed, person_id, page

role 3

year 1

  • 2013 · 13 ✖
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
28129 28129 34944 2013 pdf:2013:A.8 3 Speakers speaker Kara Taczak University of Denver, CO Key Terms and Threshold Concepts: Bridging Connections for Transfer p:kara-taczak ror:04w7skc03 pdf-2013-2013__program__program2013.pdf 82
28165 28165 34891 2013 pdf:2013:AW.11 9 Speakers speaker Amber Engelson University of Denver, CO   p:amber-engelson ror:04w7skc03 pdf-2013-2013__program__program2013.pdf 67
28385 28385 35097 2013 pdf:2013:B.5 2 Speakers speaker Doug Hesse University of Denver, CO Letter to Message, Scrapbook to Timeline: The Everyday Writings of Two Dozen Professionals, 1912 to 2012 p:doug-hesse ror:04w7skc03 pdf-2013-2013__program__program2013.pdf 96
28387 28387 35099 2013 pdf:2013:B.5 4 Speakers speaker Juli Parrish University of Denver, CO The Other Social Network: Commonplace and Community in the Back Smoker Diaries p:juli-parrish ror:04w7skc03 pdf-2013-2013__program__program2013.pdf 96
28638 28638 35507 2013 pdf:2013:D.27 1 Chair chair Richard Colby University of Denver, CO   p:richard-colby ror:04w7skc03 pdf-2013-2013__program__program2013.pdf 131
28639 28639 35508 2013 pdf:2013:D.27 2 Speakers speaker Richard Colby University of Denver, CO Gaming Literacies in Transmedia Shift p:richard-colby ror:04w7skc03 pdf-2013-2013__program__program2013.pdf 131
28640 28640 35509 2013 pdf:2013:D.27 3 Speakers speaker Rebekah Shultz Colby University of Denver, CO Gaming Literacies and the Ideologies of Play p:rebekah-shultz-colby ror:04w7skc03 pdf-2013-2013__program__program2013.pdf 131
29072 29072 35950 2013 pdf:2013:G.17 3 Speakers speaker Cydney Alexis University of Denver, CO Moving Writing, Shifting Habitats: Affective, Material, and Place-Based Inquiries into Writing Practice p:cydney-alexis ror:04w7skc03 pdf-2013-2013__program__program2013.pdf 174
29082 29082 35880 2013 pdf:2013:G.2 1 Chair chair Doug Hesse University of Denver, CO   p:doug-hesse ror:04w7skc03 pdf-2013-2013__program__program2013.pdf 169
29308 29308 36176 2013 pdf:2013:H.37 5 Respondent respondent Doug Hesse University of Denver, CO   p:doug-hesse ror:04w7skc03 pdf-2013-2013__program__program2013.pdf 194
29680 29680 36552 2013 pdf:2013:K.23 5 Respondent respondent Doug Hesse University of Denver, CO   p:doug-hesse ror:04w7skc03 pdf-2013-2013__program__program2013.pdf 235
29772 29772 36493 2013 pdf:2013:K.9 4 Speakers speaker Eric Leake University of Denver, CO Implosions and Nostalgia in Las Vegas p:eric-leake ror:04w7skc03 pdf-2013-2013__program__program2013.pdf 231
29976 29976 36897 2013 pdf:2013:M.22 4 Respondent respondent Cydney Alexis University of Denver, CO   p:cydney-alexis ror:04w7skc03 pdf-2013-2013__program__program2013.pdf 288

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