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

2 rows where institution_id = "ror:05t5ek106", role = "Speakers" and year = 2006

✎ View and edit SQL

This data as json, CSV (advanced)

year 1

  • 2006 · 2 ✖

role 1

  • Speakers · 2 ✖
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
11189 11189 18124 2006 pdf:2006:J.32 3 Speakers speaker Sonja L. Andrus Collin County Community College District, McKinney, TX What Happens when Mainstream Voices are Those Marginalized in the Border Towns? p:sonja-andrus ror:05t5ek106 pdf-2006-2006__2006programfriday.pdf 75
11931 11931 16073 2006 pdf:2006:W.5 6 Speakers speaker Sonja L. Andrus Collin County Community College District, McKinney, TX ‘Hi! I’m from Theorytowne. So glad to be here!’ (Incredibly cold splash!) Going in with Open Eyes Isn’t Always What We Think It is. p:sonja-andrus ror:05t5ek106 pdf-2006-2006__2006programwednesday.pdf 12

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