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

17 rows where institution_id = "ror:02dqehb95", role = "Chair" and year = 2006

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: session_id, name_as_printed, person_id, source_document_id, page

year 1

  • 2006 · 17 ✖

role 1

  • Chair · 17 ✖
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
9320 9320 16382 2006 pdf:2006:A.25 1 Chair chair Mary Godwin Purdue University, West Lafayette, IN   p:mary-godwin ror:02dqehb95 pdf-2006-2006__2006programthursday.pdf 16
9321 9321 16383 2006 pdf:2006:A.25 2 Chair chair Mary Godwin Purdue University, West Lafayette, IN   p:mary-godwin ror:02dqehb95 pdf-2006-2006__2006programthursday.pdf 16
9322 9322 16384 2006 pdf:2006:A.25 3 Chair chair Marc C. Santos Purdue University, West Lafayette, IN   p:marc-c-santos ror:02dqehb95 pdf-2006-2006__2006programthursday.pdf 16
9323 9323 16385 2006 pdf:2006:A.25 4 Chair chair Jason Buchanan Purdue University, West Lafayette, IN   p:jason-buchanan ror:02dqehb95 pdf-2006-2006__2006programthursday.pdf 16
9324 9324 16386 2006 pdf:2006:A.26 1 Chair chair Michael Salvo Purdue University, West Lafayette, IN   p:michael-salvo ror:02dqehb95 pdf-2006-2006__2006programthursday.pdf 16
9368 9368 16425 2006 pdf:2006:A.35 1 Chair chair Tammy Conard-Salvo Purdue University, West Lafayette, IN   p:tammy-conard-salvo ror:02dqehb95 pdf-2006-2006__2006programthursday.pdf 19
9442 9442 16126 2006 pdf:2006:AW.1 1 Chair chair Irwin Weiser Purdue University, West Lafayette, IN   p:irwin-weiser ror:02dqehb95 pdf-2006-2006__2006programwednesday.pdf 17
9600 9600 16594 2006 pdf:2006:B.30 1 Chair chair Irwin Weiser Purdue University, West Lafayette, IN   p:irwin-weiser ror:02dqehb95 pdf-2006-2006__2006programthursday.pdf 34
9981 9981 16976 2006 pdf:2006:D.34 1 Chair chair Samantha Blackmon Purdue University, West Lafayette, IN   p:samantha-blackmon ror:02dqehb95 pdf-2006-2006__2006programthursday.pdf 69
10018 10018 17008 2006 pdf:2006:D.42 1 Chair chair Kristine Johnson Purdue University, West Lafayette, IN   p:kristine-johnson ror:02dqehb95 pdf-2006-2006__2006programthursday.pdf 71
10316 10316 17418 2006 pdf:2006:F.18 1 Chair chair Janice Lauer Purdue University, West Lafayette, IN   p:janice-lauer ror:02dqehb95 pdf-2006-2006__2006programfriday.pdf 8
10700 10700 17632 2006 pdf:2006:G.34 1 Chair chair Tony Silva Purdue University, West Lafayette, IN   p:tony-silva ror:02dqehb95 pdf-2006-2006__2006programfriday.pdf 28
10961 10961 17902 2006 pdf:2006:I.19 1 Chair chair Shirley K. Rose Purdue University, West Lafayette, IN   p:shirley-rose ror:02dqehb95 pdf-2006-2006__2006programfriday.pdf 57
11095 11095 18037 2006 pdf:2006:J.13 1 Chair chair Janice Lauer Purdue University, West Lafayette, IN   p:janice-lauer ror:02dqehb95 pdf-2006-2006__2006programfriday.pdf 69
11233 11233 18347 2006 pdf:2006:K.10 1 Chair chair Tony Silva Purdue University, West Lafayette, IN   p:tony-silva ror:02dqehb95 pdf-2006-2006__2006programsaturday.pdf 10
11414 11414 18522 2006 pdf:2006:L.13 1 Chair chair David Blakesley Purdue University, West Lafayette, IN   p:david-blakesley ror:02dqehb95 pdf-2006-2006__2006programsaturday.pdf 23
11433 11433 18541 2006 pdf:2006:L.17 1 Chair chair Linda Bergmann Purdue University, West Lafayette, IN   p:linda-bergmann ror:02dqehb95 pdf-2006-2006__2006programsaturday.pdf 25

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