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

7 rows where institution_id = "ror:05x2bcf33" and year = 2018

✎ 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

year 1

  • 2018 · 7 ✖
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
43423 43423 50394 2018 pdf:2018:G.10 2 Speakers speaker Justin Mando Carnegie Mellon University, Pittsburgh, PA   p:justin-mando ror:05x2bcf33 pdf-2018-2018__program__program.pdf 202
44027 44027 51002 2018 pdf:2018:J.30 1 Chair chair Ryan Roderick Carnegie Mellon, Pittsburgh, PA   p:ryan-roderick ror:05x2bcf33 pdf-2018-2018__program__program.pdf 264
44039 44039 51014 2018 pdf:2018:J.33 1 Speakers speaker Ryan Roderick Carnegie Mellon, Pittsburgh, PA CGA and Self-Regulation: The Effects of Genre Analysis on First-Year Students’ Writing Strategies for Composing Research p:ryan-roderick ror:05x2bcf33 pdf-2018-2018__program__program.pdf 265
44040 44040 51015 2018 pdf:2018:J.33 2 Speakers speaker Danielle Wetzel Carnegie Mellon University, Pittsburgh, PA Assessing the Use of CGA in Mini-Sections of First-Year Writing p:danielle-zawodny-wetzel ror:05x2bcf33 pdf-2018-2018__program__program.pdf 265
44042 44042 51017 2018 pdf:2018:J.33 4 Speakers speaker Joanna Wolfe Carnegie Mellon University, Pittsburgh, PA Using CGA and Scientific Genre Knowledge to Analyze Unfamiliar Writing Prompts p:joanna-wolfe ror:05x2bcf33 pdf-2018-2018__program__program.pdf 265
44334 44334 51315 2018 pdf:2018:L.23 2 Speakers speaker Emily Ferris Carnegie Mellon University, Pittsburgh, PA Patient Stories: Narrative and Reflection in Medical School Personal Statements p:emily-ferris ror:05x2bcf33 pdf-2018-2018__program__program.pdf 320
44787 44787 49210 2018 pdf:2018:W.9 2 Workshop Facilitators facilitator Derek Handley Carnegie Mellon University, Pittsburgh, PA   p:derek-handley ror:05x2bcf33 pdf-2018-2018__program__program.pdf 53

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