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

10 rows where role = "Co-Chairs" and year = 2010

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: session_id, ord, affiliation_as_printed, institution_id, page

year 1

  • 2010 · 10 ✖

role 1

  • Co-Chairs · 10 ✖
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
20253 20253 27236 2010 pdf:2010:A.19 1 Co-Chairs chair Bump Halbritter Michigan State University, East Lansing   p:bump-halbritter ror:05hs6h993 pdf-2010-2010__cccc2010-program.pdf 84
20254 20254 27237 2010 pdf:2010:A.19 2 Co-Chairs chair Jenn Fishman University of Tennessee, Knoxville   p:jenn-fishman ror:020f3ap87 pdf-2010-2010__cccc2010-program.pdf 84
20306 20306 27285 2010 pdf:2010:A.31 1 Co-Chairs chair Wendi Jewell North Carolina State University, Raleigh   p:wendi-jewell ror:04tj63d06 pdf-2010-2010__cccc2010-program.pdf 88
20307 20307 27286 2010 pdf:2010:A.31 2 Co-Chairs chair Scott Reed University of Georgia, Athens   p:scott-reed ipeds:139959 pdf-2010-2010__cccc2010-program.pdf 88
20372 20372 27107 2010 pdf:2010:AW.2 1 Co-Chairs chair Janine Utell Widener University, Chester, PA   p:janine-utell ror:00nsyd297 pdf-2010-2010__cccc2010-program.pdf 68
20373 20373 27108 2010 pdf:2010:AW.2 2 Co-Chairs chair Patricia Dyer Widener University, Chester, PA   p:patricia-dyer ror:00nsyd297 pdf-2010-2010__cccc2010-program.pdf 68
21284 21284 29091 2010 pdf:2010:FSIG.21 1 Co-Chairs chair Mark McBeth John Jay College of Criminal Justice, NY   p:mark-mcbeth ror:01p9rc392 pdf-2010-2010__cccc2010-program.pdf 262
21285 21285 29092 2010 pdf:2010:FSIG.21 2 Co-Chairs chair Martha Marinara University of Central Florida, Orlando   p:martha-marinara ror:036nfer12 pdf-2010-2010__cccc2010-program.pdf 262
22934 22934 27029 2010 pdf:2010:W.3 2 Co-Chairs chair Angela Dadak American University, Washington, D.C.   p:angela-dadak ipeds:131159 pdf-2010-2010__cccc2010-program.pdf 64
22935 22935 27030 2010 pdf:2010:W.3 3 Co-Chairs chair Kathryn Nielsen-Dube Merrimack College, North Andover, MA   p:kathryn-nielsen-dube ror:00bqy3h17 pdf-2010-2010__cccc2010-program.pdf 64

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