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

9 rows where institution_id = "ror:02der9h97" and year = 2019

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: session_id, ord, role_group, name_as_printed, person_id, page

year 1

  • 2019 · 9 ✖
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
44884 44884 51864 2019 pdf:2019:A.29 1 Chair chair Brenda Jo Brueggemann University of Connecticut, Storrs   p:brenda-brueggemann ror:02der9h97 pdf-2019-2019__02__CCCC2019FullProgram.pdf 76
44885 44885 51865 2019 pdf:2019:A.29 2 Speakers speaker Lisa Blansett University of Connecticut, Storrs   p:lisa-blansett ror:02der9h97 pdf-2019-2019__02__CCCC2019FullProgram.pdf 76
44886 44886 51866 2019 pdf:2019:A.29 3 Speakers speaker Gabriel Morrison University of Connecticut, Storrs   p:gabriel-morrison ror:02der9h97 pdf-2019-2019__02__CCCC2019FullProgram.pdf 76
45150 45150 52074 2019 pdf:2019:B.35 3 Speakers speaker Sarah Moon University of Connecticut, Storrs A Seat at the Table: Food-Centered Autobiography in Performance in First-Year Writing p:sarah-moon ror:02der9h97 pdf-2019-2019__02__CCCC2019FullProgram.pdf 95
45900 45900 52859 2019 pdf:2019:F.43 4 Speakers speaker Christopher Iverson University of Connecticut, Storrs Explicit Instruction toward a Tactical Approach to Service-Learning p:christopher-iverson ror:02der9h97 pdf-2019-2019__02__CCCC2019FullProgram.pdf 184
47022 47022 53985 2019 pdf:2019:M.33 2 Speakers speaker Scott Campbell University of Connecticut, Storrs Composition in the Echo Echo Mirror House: Anthony Braxton’s Sonic Collage p:scott-campbell ror:02der9h97 pdf-2019-2019__02__CCCC2019FullProgram.pdf 323
47358 47358 52683 2019 pdf:2019:TSIG.32 2 Chairs chair Ellen Carillo University of Connecticut, Storrs   p:ellen-carillo ror:02der9h97 pdf-2019-2019__02__CCCC2019FullProgram.pdf 163
47370 47370 51653 2019 pdf:2019:W.1 2 Workshop Facilitators facilitator Brenda Jo Brueggemann University of Connecticut, Storrs   p:brenda-brueggemann ror:02der9h97 pdf-2019-2019__02__CCCC2019FullProgram.pdf 48
47396 47396 51674 2019 pdf:2019:W.4 2 Speakers speaker Lynn Bloom University of Connecticut, Storrs   p:lynn-z-bloom ror:02der9h97 pdf-2019-2019__02__CCCC2019FullProgram.pdf 50

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