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

11 rows where institution_id = "ror:02dqehb95", role = "Chair" and year = 2004

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name_as_printed, affiliation_as_printed, page

year 1

  • 2004 · 11 ✖

role 1

  • Chair · 11 ✖
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
4084 4084 10846 2004 pdf:2004:AW.7 1 Chair chair Irwin Weiser Purdue University, West Lafayette, IN   p:irwin-weiser ror:02dqehb95 pdf-2004-2004__2004completeprogram.pdf 68
4653 4653 11548 2004 pdf:2004:E.27 1 Chair chair Janice Lauer Purdue University, West Lafayette, IN   p:janice-lauer ror:02dqehb95 pdf-2004-2004__2004completeprogram.pdf 135
4687 4687 11579 2004 pdf:2004:E.34 1 Chair chair Karl Stolley Purdue University, West Lafayette, IN   p:karl-stolley ror:02dqehb95 pdf-2004-2004__2004completeprogram.pdf 138
4784 4784 11682 2004 pdf:2004:F.23 1 Chair chair Jessie Moore Kapper Purdue University, West Lafayette, IN   p:jessie-moore-kapper ror:02dqehb95 pdf-2004-2004__2004completeprogram.pdf 147
4787 4787 11685 2004 pdf:2004:F.24 1 Chair chair Karl Stolley Purdue University, West Lafayette, IN   p:karl-stolley ror:02dqehb95 pdf-2004-2004__2004completeprogram.pdf 147
5047 5047 11965 2004 pdf:2004:G.19 1 Chair chair Joseph Wenig Purdue University, West Lafayette, IN   p:joseph-wenig ror:02dqehb95 pdf-2004-2004__2004completeprogram.pdf 170
5148 5148 12064 2004 pdf:2004:H.11 1 Chair chair Samantha Blackmon Purdue University, West Lafayette, IN   p:samantha-blackmon ror:02dqehb95 pdf-2004-2004__2004completeprogram.pdf 179
5957 5957 13009 2004 pdf:2004:M.19 1 Chair chair Debrah Huffman Purdue University, Lafayette, IN   p:debrah-huffman ror:02dqehb95 pdf-2004-2004__2004completeprogram.pdf 269
5977 5977 13023 2004 pdf:2004:M.22 1 Chair chair Thomas Rickert Purdue University, West Lafayette, IN   p:thomas-rickert ror:02dqehb95 pdf-2004-2004__2004completeprogram.pdf 270
6010 6010 12939 2004 pdf:2004:M.3 1 Chair chair Yufeng Zhang Purdue University, West Lafayette, IN   p:yufeng-zhang ror:02dqehb95 pdf-2004-2004__2004completeprogram.pdf 263
6121 6121 13109 2004 pdf:2004:N.10 1 Chair chair Jessie Moore Kapper Purdue University, West Lafayette, IN   p:jessie-moore-kapper ror:02dqehb95 pdf-2004-2004__2004completeprogram.pdf 278

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