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

10 rows where institution_id = "ror:02ttsq026" and year = 2013

✎ 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

  • 2013 · 10 ✖
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
28083 28083 34923 2013 pdf:2013:A.3 4 Speakers speaker Petger Schaberg University of Colorado, Boulder Don’t Forget the Alphabet: Critical Writing in Video Design Projects p:petger-schaberg ror:02ttsq026 pdf-2013-2013__program__program2013.pdf 80
28423 28423 35306 2013 pdf:2013:C.13 1 Chair chair John Ackerman University of Colorado, Boulder   p:john-ackerman ror:02ttsq026 pdf-2013-2013__program__program2013.pdf 113
28424 28424 35307 2013 pdf:2013:C.13 2 Speakers speaker John Ackerman University of Colorado, Boulder Capitalizing on the Cultural Economy of Writing and Rhetoric p:john-ackerman ror:02ttsq026 pdf-2013-2013__program__program2013.pdf 113
29083 29083 35881 2013 pdf:2013:G.2 2 Speakers speaker Ginger Knowlton University of Colorado-Boulder We Are the Spaces that We Breathe: Creative Nonfiction and Ecopoetics p:ginger-knowlton ror:02ttsq026 pdf-2013-2013__program__program2013.pdf 169
29084 29084 35882 2013 pdf:2013:G.2 3 Speakers speaker Eric Burger University of Colorado-Boulder But What Does It Mean?: Student Engagement with the Lyric Essay p:eric-burger ror:02ttsq026 pdf-2013-2013__program__program2013.pdf 169
29085 29085 35883 2013 pdf:2013:G.2 4 Speakers speaker Tobin Von Der Nuell University of Colorado-Boulder I’ve Got Something to Say: Creative Nonfiction and the Teaching of Voice p:tobin-von-der-nuell ror:02ttsq026 pdf-2013-2013__program__program2013.pdf 169
29086 29086 35884 2013 pdf:2013:G.2 5 Speakers speaker John-Michael Rivera University of Colorado-Boulder The Nonfiction of the Public University p:john-michael-rivera ror:02ttsq026 pdf-2013-2013__program__program2013.pdf 169
29717 29717 36585 2013 pdf:2013:K.31 3 Speakers speaker Veronica House University of Colorado Boulder Food, Composition, and Service-Learning: Connecting Students to Grassroots Community Initiatives p:veronica-house ror:02ttsq026 pdf-2013-2013__program__program2013.pdf 238
30067 30067 34692 2013 pdf:2013:MW.1 11 Respondents respondent Steve Lamos University of Colorado, Boulder   p:steve-lamos ror:02ttsq026 pdf-2013-2013__program__program2013.pdf 58
30346 30346 34791 2013 pdf:2013:W.6 7 Speakers speaker Steve Lamos University of Colorado, Boulder   p:steve-lamos ror:02ttsq026 pdf-2013-2013__program__program2013.pdf 62

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