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:05qghxh33" and year = 2015

✎ View and edit SQL

This data as json, CSV (advanced)

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

role 2

year 1

  • 2015 · 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
33437 33437 40406 2015 pdf:2015:B.15 2 Speakers speaker Nicole Galante State University of New York, Stony Brook Innovating in Fourth Space: Reflective, Communal Teaching and Learning p:nicole-galante ror:05qghxh33 pdf-2015-2015__program__thurs.pdf 28
34191 34191 40958 2015 pdf:2015:E.8 2 Speakers speaker Peter Khost Stony Brook University, New York Using Freeware to Foster and Research Writing Transfer across the Curriculum and beyond Graduation p:peter-khost ror:05qghxh33 pdf-2015-2015__program__thurs.pdf 79
34403 34403 42431 2015 pdf:2015:FSIG.12 3 Co-Chairs chair Ken Lindblom Stony Brook University, Shoreham, NY   p:kenneth-lindblom ror:05qghxh33 pdf-2015-2015__program__fri.pdf 126
34469 34469 41401 2015 pdf:2015:G.1 3 Speakers speaker Ghanashyam Sharma Stony Brook University, NY Effective Writing Programs and Pedagogies at the Graduate Levels in STEM Disciplines p:ghanashyam-sharma ror:05qghxh33 pdf-2015-2015__program__fri.pdf 19
35077 35077 41852 2015 pdf:2015:I.9 2 Speakers speaker Ken Lindblom Stony Brook University, NY Too Much Information? The Place of the Infographic in Writing Instruction p:kenneth-lindblom ror:05qghxh33 pdf-2015-2015__program__fri.pdf 62
35749 35749 39898 2015 pdf:2015:MW.13 2 Speakers speaker Rita Nezami Stony Brook University, NY   p:rita-nezami ror:05qghxh33 pdf-2015-2015__program__wed.pdf 12
35758 35758 39907 2015 pdf:2015:MW.13 11 Speakers speaker Ghanashyam Sharma Stony Brook University, NY   p:ghanashyam-sharma ror:05qghxh33 pdf-2015-2015__program__wed.pdf 12
35898 35898 39934 2015 pdf:2015:W.1 4 Speakers speaker Lauren Esposito State University of New York, Stony Brook Embodied Rhetoric: Improvisation and Invention p:lauren-esposito ror:05qghxh33 pdf-2015-2015__program__wed.pdf 14
35901 35901 39937 2015 pdf:2015:W.1 7 Speakers speaker Nicole Galante State University of New York, Stony Brook The Influence of Anxiety: Kairos and Karaoke p:nicole-galante ror:05qghxh33 pdf-2015-2015__program__wed.pdf 14
35902 35902 39938 2015 pdf:2015:W.1 8 Speakers speaker Peter Khost Stony Brook University, New York The Influence of Anxiety: Kairos and Karaoke p:peter-khost ror:05qghxh33 pdf-2015-2015__program__wed.pdf 14

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