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

15 rows where institution_id = "ror:01x8rc503" and role = "Chair"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ord, name_as_printed, affiliation_as_printed, person_id, source_document_id

year 10

role 1

  • Chair · 15 ✖
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
66 66 67706 1998 html:1998:A.8 1 Chair chair Christopher Schroeder University of Southwestern Louisiana, Lafayette   p:christopher-schroeder ror:01x8rc503 wayback-98-program-aa.htm  
391 391 68031 1998 html:1998:C.7 1 Chair chair Ann Dobie University of Southwestern Louisiana, Lafayette   p:ann-b-dobie ror:01x8rc503 wayback-98-program-cc.htm  
3132 3132 9838 1999 pdf:1999:I.33 1 Chair chair Ann B. Dobie University of Southwestern Louisiana, Lafayette   p:ann-b-dobie ror:01x8rc503 pdf-1999-99__program__i.pdf 6
3713 3713 10607 1999 pdf:1999:SW.6 1 Chair chair Risa P. Gorelick University of Southwestern Louisiana, Lafayette   p:risa-p-gorelick ror:01x8rc503 pdf-1999-99__program__sat-workshops.pdf 3
5459 5459 12366 2004 pdf:2004:J.13 1 Chair chair Carolyn J. Pastel Anderson University of Louisiana at Lafayette   p:carolyn-j-pastel-anderson ror:01x8rc503 pdf-2004-2004__2004completeprogram.pdf 207
5930 5930 12982 2004 pdf:2004:M.13 1 Chair chair Casey Hayes University of Louisiana at Lafayette   p:casey-hayes ror:01x8rc503 pdf-2004-2004__2004completeprogram.pdf 267
7077 7077 13817 2005 pdf:2005:C.9 1 Chair chair Carolyn Anderson University of Louisiana at Lafayette   p:carolyn-j-pastel-anderson ror:01x8rc503 pdf-2005-2005__2005completeprogram.pdf 104
9143 9143 14436 2005 pdf:2005:TSIG.7 1 Chair chair James McDonald University of Louisiana at Lafayette   p:james-mcdonald ror:01x8rc503 pdf-2005-2005__2005completeprogram.pdf 159
10227 10227 17047 2006 pdf:2006:E.6 1 Chair chair James McDonald University of Louisiana at Lafayette   p:james-mcdonald ror:01x8rc503 pdf-2006-2006__2006programthursday.pdf 76
14575 14575 18762 2007 pdf:2007:P.34 8 Chair chair Carolyn J. Pastel Anderson University of Louisiana at Lafayette   p:carolyn-j-pastel-anderson ror:01x8rc503 pdf-2007-2007__2007completeprogram.pdf 53
16013 16013 22945 2008 pdf:2008:G.2 1 Chair chair Clancy Ratliff University of Louisiana at Lafayette   p:clancy-ratliff ror:01x8rc503 pdf-2008-2008__2008completeprogram.pdf 170
29607 29607 36341 2013 pdf:2013:J.6 1 Chair chair Clancy Ratliff University of Louisiana at Lafayette   p:clancy-ratliff ror:01x8rc503 pdf-2013-2013__program__program2013.pdf 214
32006 32006 38917 2014 pdf:2014:I.28 1 Chair chair Clancy Ratliff University of Louisiana at Lafayette   p:clancy-ratliff ror:01x8rc503 pdf-2014-2014__program__program.pdf 228
38838 38838 45955 2017 pdf:2017:A.31 1 Chair chair Clancy Ratliff University of Louisiana at Lafayette   p:clancy-ratliff ror:01x8rc503 pdf-2017-2017__program__2017program.pdf 80
40657 40657 47644 2017 pdf:2017:H.27 1 Chair chair Clancy Ratliff University of Louisiana at Lafayette   p:clancy-ratliff ror:01x8rc503 pdf-2017-2017__program__2017program.pdf 245

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