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

16 rows where institution_id = "ror:01an3r305" 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 2

year 1

  • 2013 · 16 ✖
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
28514 28514 35388 2013 pdf:2013:C.31 4 Speakers speaker Annette Vee University of Pittsburgh, PA Ideologies of a New Mass Literacy p:annette-vee ror:01an3r305 pdf-2013-2013__program__program2013.pdf 119
28520 28520 35394 2013 pdf:2013:C.32 6 Speakers speaker James Seitz University of Pittsburgh, PA Down by the Schoolyard: From Pedagogical Education to Public Narrative p:james-seitz ror:01an3r305 pdf-2013-2013__program__program2013.pdf 119
28591 28591 35464 2013 pdf:2013:D.17 2 Speakers speaker Peter Wayne Moe University of Pittsburgh, PA What Works for Me, and for that Matter, for Us p:peter-moe ror:01an3r305 pdf-2013-2013__program__program2013.pdf 127
29106 29106 35979 2013 pdf:2013:G.24 1 Chair chair Marylou Gramm University of Pittsburgh, PA   p:marylou-gramm ror:01an3r305 pdf-2013-2013__program__program2013.pdf 176
29107 29107 35980 2013 pdf:2013:G.24 2 Speakers speaker Janine Carlock University of Pittsburgh, PA Developing an Individual Belief System p:janine-carlock ror:01an3r305 pdf-2013-2013__program__program2013.pdf 176
29108 29108 35981 2013 pdf:2013:G.24 3 Speakers speaker Marylou Gramm University of Pittsburgh, PA Chinese Students Coming Out p:marylou-gramm ror:01an3r305 pdf-2013-2013__program__program2013.pdf 176
29109 29109 35982 2013 pdf:2013:G.24 4 Speakers speaker Renee Prymus University of Pittsburgh, PA Inquiry as Intellectual Autonomy p:renee-prymus ror:01an3r305 pdf-2013-2013__program__program2013.pdf 176
29233 29233 36105 2013 pdf:2013:H.20 2 Speakers speaker Mariolina Salvatori University of Pittsburgh, PA Reading the 80s p:mariolina-salvatori ror:01an3r305 pdf-2013-2013__program__program2013.pdf 189
29828 29828 36746 2013 pdf:2013:L.22 2 Speakers speaker Pamela VanHaitsma University of Pittsburgh, PA Teaching to Queer ‘Straight’ Archives p:pamela-vanhaitsma ror:01an3r305 pdf-2013-2013__program__program2013.pdf 274
29830 29830 36748 2013 pdf:2013:L.22 4 Speakers speaker Jean Bessette University of Pittsburgh, PA Teaching Taboo Archives p:jean-bessette ror:01an3r305 pdf-2013-2013__program__program2013.pdf 274
29894 29894 36672 2013 pdf:2013:L.4 2 Speakers speaker Erin Anderson University of Pittsburgh, PA Coercive Composing: Digital Voice and a Poetics of Public Confession p:erin-anderson ror:01an3r305 pdf-2013-2013__program__program2013.pdf 268
29895 29895 36673 2013 pdf:2013:L.4 3 Speakers speaker Trisha Campbell University of Pittsburgh, PA Making Murder Matter p:trisha-campbell ror:01an3r305 pdf-2013-2013__program__program2013.pdf 268
30074 30074 34699 2013 pdf:2013:MW.2 4 Speakers speaker Kerry Banazek University of Pittsburgh, PA   p:kerry-banazek ror:01an3r305 pdf-2013-2013__program__program2013.pdf 58
30075 30075 34700 2013 pdf:2013:MW.2 5 Speakers speaker Erin Anderson University of Pittsburgh, PA   p:erin-anderson ror:01an3r305 pdf-2013-2013__program__program2013.pdf 58
30105 30105 36981 2013 pdf:2013:N.10 1 Chair chair Danielle Koupf University of Pittsburgh, PA   p:danielle-koupf ror:01an3r305 pdf-2013-2013__program__program2013.pdf 299
30106 30106 36982 2013 pdf:2013:N.10 2 Speakers speaker Danielle Koupf University of Pittsburgh, PA Compiling the Texts of Composition: Textual Reuse in Representations of the Field p:danielle-koupf ror:01an3r305 pdf-2013-2013__program__program2013.pdf 299

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