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:04xtx5t16" and year = 2017

✎ 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

  • 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
39114 39114 45649 2017 pdf:2017:AW.9 5 Speakers speaker Sarah Read DePaul University, Chicago, IL   p:sarah-read ror:04xtx5t16 pdf-2017-2017__program__2017program.pdf 46
40080 40080 47139 2017 pdf:2017:F.16 1 Chair chair Peter Vandenberg DePaul University   p:peter-vandenberg ror:04xtx5t16 pdf-2017-2017__program__2017program.pdf 194
40452 40452 47445 2017 pdf:2017:G.33 1 Speakers speaker Darsie Bowden DePaul University   p:darsie-bowden ror:04xtx5t16 pdf-2017-2017__program__2017program.pdf 223
40453 40453 47446 2017 pdf:2017:G.33 2 Speakers speaker Carolyn Vos DePaul University   p:carolyn-vos ror:04xtx5t16 pdf-2017-2017__program__2017program.pdf 223
40454 40454 47447 2017 pdf:2017:G.33 3 Speakers speaker Bridget Wagner DePaul University   p:bridget-wagner ror:04xtx5t16 pdf-2017-2017__program__2017program.pdf 223
40946 40946 47776 2017 pdf:2017:I.4 5 Speakers speaker Jason Schneider DePaul University Preparing MA Students to Teach Multilingual Writers p:jason-schneider ror:04xtx5t16 pdf-2017-2017__program__2017program.pdf 258
41029 41029 47986 2017 pdf:2017:J.1 4 Facilitators facilitator Michelle Navarre Cleary DePaul University   p:michelle-navarre-cleary ror:04xtx5t16 pdf-2017-2017__program__2017program.pdf 279
41293 41293 48283 2017 pdf:2017:K.11 5 Speakers speaker Jason Kalin DePaul University Writing with Time: Cultivating Temporal Visualities in Mobile Composition p:jason-kalin ror:04xtx5t16 pdf-2017-2017__program__2017program.pdf 306
41326 41326 48242 2017 pdf:2017:K.2 1 Chairs chair Darsie Bowden DePaul University   p:darsie-bowden ror:04xtx5t16 pdf-2017-2017__program__2017program.pdf 302
41722 41722 48770 2017 pdf:2017:M.21 1 Speakers speaker Antonio Ceraso DePaul University What’s Aesthetic about Public Engagement? p:antonio-ceraso ror:04xtx5t16 pdf-2017-2017__program__2017program.pdf 369
42020 42020 47025 2017 pdf:2017:TSIG.15 1 Speakers speaker Darsie Bowden DePaul University   p:darsie-bowden ror:04xtx5t16 pdf-2017-2017__program__2017program.pdf 180

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