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

7 rows where institution_id = "ror:01kw1gj07" and role = "Chair"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name_as_printed, affiliation_as_printed, person_id, source_document_id

year 5

role 1

  • Chair · 7 ✖
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
1557 1557 69197 1998 html:1998:K.29 1 Chair chair Ron Denson Ithaca College, New York   p:ron-denson ror:01kw1gj07 wayback-98-program-kk.htm  
2328 2328 8921 1999 pdf:1999:B.3 1 Chair chair Jerry Mirskin Ithaca College, NY   p:jerry-mirskin ror:01kw1gj07 pdf-1999-99__program__b.pdf 2
2722 2722 9441 1999 pdf:1999:G.11 1 Chair chair Anthony DiRenzo Ithaca College, Syracuse, NY   p:anthony-direnzo ror:01kw1gj07 pdf-1999-99__program__g.pdf 3
31291 31291 38207 2014 pdf:2014:E.37 1 Chair chair Susan Delaney Ithaca College, NY   p:susan-delaney ror:01kw1gj07 pdf-2014-2014__program__program.pdf 164
32167 32167 39076 2014 pdf:2014:J.23 1 Chair chair Thomas Girshin Ithaca College, NY   p:thomas-girshin ror:01kw1gj07 pdf-2014-2014__program__program.pdf 242
36544 36544 43560 2016 pdf:2016:C.26 1 Chair chair Thomas Girshin Ithaca College   p:thomas-girshin ror:01kw1gj07 pdf-2016-2016__program__2016program.pdf 108
46059 46059 52999 2019 pdf:2019:G.33 1 Chair chair Amy Quan Ithaca College, NY   p:amy-quan ror:01kw1gj07 pdf-2019-2019__02__CCCC2019FullProgram.pdf 197

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