home / cccc

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 institution_id = "ror:02t0qr014" 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 8

  • 2008 2
  • 2009 2
  • 1998 1
  • 2004 1
  • 2006 1
  • 2007 1
  • 2010 1
  • 2016 1

role 1

  • Chair · 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
1761 1761 69401 1998 html:1998:L.5 1 Chair chair Donald Bushman University of North Carolina, Wilmington   p:don-bushman ror:02t0qr014 wayback-98-program-ll.htm  
6252 6252 13249 2004 pdf:2004:O.12 1 Chair chair Elizabeth Ervin University of North Carolina at Wilmington   p:elizabeth-ervin ror:02t0qr014 pdf-2004-2004__2004completeprogram.pdf 290
10866 10866 17690 2006 pdf:2006:H.3 1 Chair chair Lu Ellen Huntley University of North Carolina, Wilmington   p:lu-ellen-huntley ror:02t0qr014 pdf-2006-2006__2006programfriday.pdf 37
14573 14573 18760 2007 pdf:2007:P.34 6 Chair chair Anthony T. Atkins University of North Carolina at Wilmington   p:anthony-atkins ror:02t0qr014 pdf-2007-2007__2007completeprogram.pdf 53
15794 15794 22836 2008 pdf:2008:F.13 1 Chair chair Lu Ellen Huntley University of North Carolina, Wilmington   p:lu-ellen-huntley ror:02t0qr014 pdf-2008-2008__2008completeprogram.pdf 160
16404 16404 23416 2008 pdf:2008:J.10 1 Chair chair Anthony Atkins University of North Carolina, Wilmington   p:anthony-atkins ror:02t0qr014 pdf-2008-2008__2008completeprogram.pdf 209
17589 17589 24383 2009 pdf:2009:AW.13 1 Chair chair Colleen A. Reilly University of North Carolina, Wilmington   p:colleen-reilly ror:02t0qr014 pdf-2009-2009__2009completeprogram.pdf 68
19892 19892 26774 2009 pdf:2009:O.11 1 Chair chair Kristen Seas University of North Carolina-Wilmington   p:kristen-seas ror:02t0qr014 pdf-2009-2009__2009completeprogram.pdf 297
20710 20710 27620 2010 pdf:2010:C.36 1 Chair chair LuEllen Huntley University of North Carolina, Wilmington   p:luellen-huntley ror:02t0qr014 pdf-2010-2010__cccc2010-program.pdf 117
36834 36834 43814 2016 pdf:2016:E.1 1 Chair chair Lance Cummings University of North Carolina Wilmington   p:lance-cummings ror:02t0qr014 pdf-2016-2016__program__2016program.pdf 132

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);
Powered by Datasette · Queries took 17.745ms · Data license: CC BY 4.0 (data), MIT (code) · Data source: Source code, methods and known limits