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:029z7h505" and role = "Chair"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name_as_printed, affiliation_as_printed, person_id, source_document_id

year 9

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
10198 10198 17192 2006 pdf:2006:E.40 1 Chair chair Tiffany Rousculp Salt Lake City Community College, UT   p:tiffany-rousculp ror:029z7h505 pdf-2006-2006__2006programthursday.pdf 87
11845 11845 17242 2006 pdf:2006:TSIG.6 1 Chair chair Clint Gardner Salt Lake Community College, UT   p:clint-gardner ror:029z7h505 pdf-2006-2006__2006programthursday.pdf 91
12416 12416 19180 2007 pdf:2007:B.7 1 Chair chair Tiffany Rousculp Salt Lake Community College, UT   p:tiffany-rousculp ror:029z7h505 pdf-2007-2007__2007completeprogram.pdf 93
14596 14596 21347 2007 pdf:2007:P.8 1 Chair chair Clint Gardner Salt Lake Community College, UT   p:clint-gardner ror:029z7h505 pdf-2007-2007__2007completeprogram.pdf 293
18246 18246 25177 2009 pdf:2009:E.21 1 Chair chair Tiffany Rousculp Salt Lake Community College, UT   p:tiffany-rousculp ror:029z7h505 pdf-2009-2009__2009completeprogram.pdf 140
20731 20731 27637 2010 pdf:2010:C.40 1 Chair chair Ron Christiansen Salt Lake Community College, UT   p:ron-christiansen ror:029z7h505 pdf-2010-2010__cccc2010-program.pdf 118
24349 24349 31238 2011 pdf:2011:H.34 1 Chair chair Clint Gardner Salt Lake Community College, UT   p:clint-gardner ror:029z7h505 pdf-2011-2011__program__entire-prog.pdf 198
29531 29531 36401 2013 pdf:2013:J.21 1 Chair chair Jennifer Courtney Salt Lake Community College, UT   p:jennifer-courtney ror:029z7h505 pdf-2013-2013__program__program2013.pdf 219
34837 34837 41790 2015 pdf:2015:H.41 1 Chair chair Brittany Stephenson Salt Lake Community College, UT   p:brittany-stephenson ror:029z7h505 pdf-2015-2015__program__fri.pdf 55
40795 40795 47570 2017 pdf:2017:H.9 1 Chair chair Tiffany Rousculp Salt Lake Community College   p:tiffany-rousculp ror:029z7h505 pdf-2017-2017__program__2017program.pdf 238
54225 54225 61014 2023 pdf:2023:J.8 1 Chair chair Bernice Olivas Salt Lake Community College   p:bernice-olivas ror:029z7h505 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 258

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