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

11 rows where institution_id = "ror:04w7skc03" and year = 2009

✎ View and edit SQL

This data as json, CSV (advanced)

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

role 3

year 1

  • 2009 · 11 ✖
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
17406 17406 24436 2009 pdf:2009:A.10 4 Speakers speaker Doug Hesse University of Denver, CO Sustainability after the Honeymoon: Or, ‘You’ve had a gee-whiz writing program. So what’s it to you—and to us?’ p:doug-hesse ror:04w7skc03 pdf-2009-2009__2009completeprogram.pdf 79
17918 17918 24838 2009 pdf:2009:C.27 1 Chair chair Douglas Hesse University of Denver, CO   p:doug-hesse ror:04w7skc03 pdf-2009-2009__2009completeprogram.pdf 113
17920 17920 24840 2009 pdf:2009:C.27 3 Speakers speaker Eliana Schonberg University of Denver, CO Training Writing Consultants to be Visual Rhetoricians p:eliana-schonberg ror:04w7skc03 pdf-2009-2009__2009completeprogram.pdf 113
18351 18351 25114 2009 pdf:2009:E.6 1 Chair chair Richard Colby University of Denver, CO   p:richard-colby ror:04w7skc03 pdf-2009-2009__2009completeprogram.pdf 136
18352 18352 25115 2009 pdf:2009:E.6 2 Speakers speaker Richard Colby University of Denver, CO   p:richard-colby ror:04w7skc03 pdf-2009-2009__2009completeprogram.pdf 136
18353 18353 25116 2009 pdf:2009:E.6 3 Speakers speaker Rebekah Shultz Colby University of Denver, CO   p:rebekah-shultz-colby ror:04w7skc03 pdf-2009-2009__2009completeprogram.pdf 136
18354 18354 25117 2009 pdf:2009:E.6 4 Speakers speaker David Daniels University of Denver, CO   p:david-daniels ror:04w7skc03 pdf-2009-2009__2009completeprogram.pdf 136
18661 18661 25577 2009 pdf:2009:G.28 4 Speakers speaker Alba Newmann University of Denver, CO Lightning-bolt Literacies: Kenneth Burke’s Zigzag Flashes of Lightning p:alba-newmann ror:04w7skc03 pdf-2009-2009__2009completeprogram.pdf 177
18897 18897 25788 2009 pdf:2009:I.1 3 Discussants respondent Doug Hesse The University of Denver, CO   p:doug-hesse ror:04w7skc03 pdf-2009-2009__2009completeprogram.pdf 196
19604 19604 26559 2009 pdf:2009:M.20 4 Speakers speaker Kelli Custer University of Denver, CO Rocking the Boat: Strategies for Teaching with Required Texts p:kelli-custer ror:04w7skc03 pdf-2009-2009__2009completeprogram.pdf 279
20202 20202 24269 2009 pdf:2009:W.8 5 Speakers speaker Doug Hesse University of Denver, CO Connecting Private to Public p:doug-hesse ror:04w7skc03 pdf-2009-2009__2009completeprogram.pdf 63

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