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

1 row where institution_id = "ror:041yk2d64"

✎ View and edit SQL

This data as json, CSV (advanced)

year 1

role 1

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
22495 22495 27008 2010 pdf:2010:MW.11 11 Speakers speaker Janete Sander Costa Universidade Federale do Rio Grande do Sul, Porto Alegre, Brazil Collective Authorship and New Genre Production in the Perspective of English Teaching Education in Virtual Learning Environments p:janete-sander-costa ror:041yk2d64 pdf-2010-2010__cccc2010-program.pdf 62

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