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:02der9h97" and year = 2017

✎ View and edit SQL

This data as json, CSV (advanced)

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

role 2

year 1

  • 2017 · 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
38811 38811 45928 2017 pdf:2017:A.24 2 Speakers speaker Lynn Z. Bloom University of Connecticut, Storrs My Intimate Understanding of Illness/Disability: Student Storytelling on the Cutting Edge p:lynn-z-bloom ror:02der9h97 pdf-2017-2017__program__2017program.pdf 77
39300 39300 46261 2017 pdf:2017:B.47 1 Chair chair Brenda Brueggemann University of Connecticut   p:brenda-brueggemann ror:02der9h97 pdf-2017-2017__program__2017program.pdf 109
39896 39896 46877 2017 pdf:2017:E.24 3 Speakers speaker Scott Campbell University of Connecticut High School Teachers in the FYC Ecology: Revising the Terms of Contingency p:scott-campbell ror:02der9h97 pdf-2017-2017__program__2017program.pdf 166
39993 39993 46961 2017 pdf:2017:E.44 4 Speakers speaker Erick Piller University of Connecticut What’s Creative about Creative Writing? Toward a Pedagogy of Transversal Flexibility p:erick-piller ror:02der9h97 pdf-2017-2017__program__2017program.pdf 173
40215 40215 47266 2017 pdf:2017:F.46 2 Speakers speaker Brenda Brueggemann University of Connecticut   p:brenda-brueggemann ror:02der9h97 pdf-2017-2017__program__2017program.pdf 206
40320 40320 48505 2017 pdf:2017:FSIG.21 2 Speakers speaker Ellen Carillo University of Connecticut, Storrs-Mansfield   p:ellen-carillo ror:02der9h97 pdf-2017-2017__program__2017program.pdf 336
40593 40593 47583 2017 pdf:2017:H.12 2 Speakers speaker Lisa Blansett University of Connecticut, Storrs Sustainable Translingualism: Working Productively in Multiple Languages p:lisa-blansett ror:02der9h97 pdf-2017-2017__program__2017program.pdf 239
40650 40650 47637 2017 pdf:2017:H.25 3 Speakers speaker Cynthia DeRoma University of Connecticut Cultivating Connections between ESL Instructors and FYC Programs p:cynthia-deroma ror:02der9h97 pdf-2017-2017__program__2017program.pdf 244
41570 41570 48622 2017 pdf:2017:L.27 2 Speakers speaker Melissa Bugdal University of Connecticut, Storrs The Rhetorical Situation and Transfer of Writing Knowledge from Basic Writing to Writing in the Disciplines p:melissa-bugdal ror:02der9h97 pdf-2017-2017__program__2017program.pdf 355
42125 42125 45823 2017 pdf:2017:W.13 2 Speakers speaker Brenda Brueggemann University of Connecticut, Storrs   p:brenda-brueggemann ror:02der9h97 pdf-2017-2017__program__2017program.pdf 57
42131 42131 45735 2017 pdf:2017:W.3 1 Speakers speaker Lynn Z. Bloom University of Connecticut, Storrs   p:lynn-z-bloom ror:02der9h97 pdf-2017-2017__program__2017program.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);