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

9 rows where institution_id = "ror:00rs6vg23", role = "Chair" and year = 2004

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name_as_printed, affiliation_as_printed, person_id

year 1

  • 2004 · 9 ✖

role 1

  • Chair · 9 ✖
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
4481 4481 11378 2004 pdf:2004:D.23 1 Chair chair Beverly J. Moss The Ohio State University, Columbus   p:beverly-moss ror:00rs6vg23 pdf-2004-2004__2004completeprogram.pdf 121
4637 4637 11532 2004 pdf:2004:E.23 1 Chair chair Mindy Wright The Ohio State University, Columbus   p:mindy-wright ror:00rs6vg23 pdf-2004-2004__2004completeprogram.pdf 134
4658 4658 11553 2004 pdf:2004:E.28 1 Chair chair Brenda Jo Brueggemann The Ohio State University, Columbus   p:brenda-brueggemann ror:00rs6vg23 pdf-2004-2004__2004completeprogram.pdf 136
4817 4817 11711 2004 pdf:2004:F.30 1 Chair chair Jason Palmeri The Ohio State University, Columbus   p:jason-palmeri ror:00rs6vg23 pdf-2004-2004__2004completeprogram.pdf 149
5388 5388 12292 2004 pdf:2004:I.30 1 Chair chair Jacqueline Jones Royster The Ohio State University, Columbus   p:jacqueline-jones-royster ror:00rs6vg23 pdf-2004-2004__2004completeprogram.pdf 199
5594 5594 12502 2004 pdf:2004:K.11 1 Chair chair Catherine C. Braun The Ohio State University, Columbus   p:catherine-braun ror:00rs6vg23 pdf-2004-2004__2004completeprogram.pdf 219
5980 5980 13026 2004 pdf:2004:M.23 1 Chair chair Vandana Gavaskar The Ohio State University, Columbus   p:vandana-gavaskar ror:00rs6vg23 pdf-2004-2004__2004completeprogram.pdf 270
6385 6385 13321 2004 pdf:2004:SW.3 1 Chair chair Vandana Gavaskar The Ohio State University, Columbus   p:vandana-gavaskar ror:00rs6vg23 pdf-2004-2004__2004completeprogram.pdf 297
6573 6573 10697 2004 pdf:2004:W.1 1 Chair chair Linda Houston The Ohio State University, Wooster, OH   p:linda-houston ror:00rs6vg23 pdf-2004-2004__2004completeprogram.pdf 58

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