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:02b9aym09" and role = "Chairs"

✎ View and edit SQL

This data as json, CSV (advanced)

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

year 3

role 1

  • Chairs · 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
6629 6629 10753 2004 pdf:2004:W.7 3 Chairs chair Pia Seagrave Gallaudet University, Washington, DC   p:pia-seagrave ror:02b9aym09 pdf-2004-2004__2004completeprogram.pdf 63
6653 6653 10777 2004 pdf:2004:W.7 27 Chairs chair Tonya Stremlau Gallaudet University, Bethesda, MD   p:tonya-stremlau ror:02b9aym09 pdf-2004-2004__2004completeprogram.pdf 63
7635 7635 15598 2005 pdf:2005:FSIG.20 1 Chairs chair Tonya Stremlau Gallaudet University, Washington D.C.   p:tonya-stremlau ror:02b9aym09 pdf-2005-2005__2005completeprogram.pdf 266
7636 7636 15599 2005 pdf:2005:FSIG.20 2 Chairs chair Paige Franklin Gallaudet University, Washington, D.C.   p:paige-franklin ror:02b9aym09 pdf-2005-2005__2005completeprogram.pdf 266
8936 8936 15920 2005 pdf:2005:SW.2 2 Chairs chair Pia Taavila Gallaudet University, Washington, D.C.   p:pia-taavila ror:02b9aym09 pdf-2005-2005__2005completeprogram.pdf 299
13039 13039 20712 2007 pdf:2007:FSIG.15 1 Chairs chair Jane Nickerson Gallaudet University, Washington, D.C.   p:jane-nickerson ror:02b9aym09 pdf-2007-2007__2007completeprogram.pdf 231
13040 13040 20713 2007 pdf:2007:FSIG.15 2 Chairs chair Marcia Bordman Gallaudet University, Washington, D.C   p:marcia-bordman ror:02b9aym09 pdf-2007-2007__2007completeprogram.pdf 231

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