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

6 rows where institution_id = "ror:00hj8s172", role = "Speakers" and year = 2013

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ord, affiliation_as_printed

year 1

  • 2013 · 6 ✖

role 1

  • Speakers · 6 ✖
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
28002 28002 34982 2013 pdf:2013:A.13 3 Speakers speaker Sheridan Blau Teachers College, Columbia University, New York, NY Vernacular Eloquence as the Foundation for a Vital Academic Discourse p:sheridan-blau ror:00hj8s172 pdf-2013-2013__program__program2013.pdf 84
28401 28401 35113 2013 pdf:2013:B.8 4 Speakers speaker Aaron Ritzenberg Columbia University, New York, NY   p:aaron-ritzenberg ror:00hj8s172 pdf-2013-2013__program__program2013.pdf 97
28652 28652 35412 2013 pdf:2013:D.3 3 Speakers speaker Catherine DeLazzero Teachers College, Columbia University, Grafton, IL Writing Bodies in First-Year Composition and the World Beyond p:catherine-delazzero ror:00hj8s172 pdf-2013-2013__program__program2013.pdf 123
29271 29271 36143 2013 pdf:2013:H.29 4 Speakers speaker Nicole Wallack Columbia College, New York, NY Lessons in Civil Discourse: Examining the Rhetoric of Civic Inclusion in Standardized Essay Examinations from 1954–1964 p:nicole-b-wallack ror:00hj8s172 pdf-2013-2013__program__program2013.pdf 192
29497 29497 36371 2013 pdf:2013:J.13 3 Speakers speaker Glenn Michael Gordon Columbia College, New York, NY Writing About Gender or Sexual Identity When You Didn’t Know You Had One p:glenn-michael-gordon ror:00hj8s172 pdf-2013-2013__program__program2013.pdf 216
30129 30129 37005 2013 pdf:2013:N.14 4 Speakers speaker Sue Mendelsohn Columbia University, New York, NY Radio Free America: The Public Project of Multiliteracy Instruction p:sue-mendelsohn ror:00hj8s172 pdf-2013-2013__program__program2013.pdf 301

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