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

13 rows where institution_id = "ror:04wzzqn13" 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

  • 2009 3
  • 2007 2
  • 2013 2
  • 2006 1
  • 2008 1
  • 2011 1
  • 2014 1
  • 2019 1
  • 2020 1

role 1

  • Chair · 13 ✖
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
10830 10830 17766 2006 pdf:2006:H.21 1 Chair chair Sally Chandler Kean University, Union, NJ   p:sally-chandler ror:04wzzqn13 pdf-2006-2006__2006programfriday.pdf 43
13516 13516 20280 2007 pdf:2007:I.8 1 Chair chair Sally Chandler Kean University, Union, NJ   p:sally-chandler ror:04wzzqn13 pdf-2007-2007__2007completeprogram.pdf 188
13794 13794 20574 2007 pdf:2007:K.4 1 Chair chair Linda Best Kean University, Union, NJ   p:linda-best ror:04wzzqn13 pdf-2007-2007__2007completeprogram.pdf 211
17133 17133 24065 2008 pdf:2008:P.13 1 Chair chair Sally Chandler Kean University, Union, NJ   p:sally-chandler ror:04wzzqn13 pdf-2008-2008__2008completeprogram.pdf 282
18151 18151 25074 2009 pdf:2009:D.39 1 Chair chair Mark Sutton Kean University, Union, NJ   p:mark-sutton ror:04wzzqn13 pdf-2009-2009__2009completeprogram.pdf 132
18496 18496 25452 2009 pdf:2009:F.36 1 Chair chair Maria Montaperto Kean University, Union, NJ   p:maria-montaperto ror:04wzzqn13 pdf-2009-2009__2009completeprogram.pdf 166
18975 18975 25904 2009 pdf:2009:I.24 1 Chair chair Sally Chandler Kean University, Union, NJ   p:sally-chandler ror:04wzzqn13 pdf-2009-2009__2009completeprogram.pdf 205
23553 23553 30453 2011 pdf:2011:D.12 1 Chair chair Sally Chandler Kean University, Union, NJ   p:sally-chandler ror:04wzzqn13 pdf-2011-2011__program__entire-prog.pdf 124
28487 28487 35365 2013 pdf:2013:C.27 1 Chair chair Mark Sutton Kean University, Union, NJ   p:mark-sutton ror:04wzzqn13 pdf-2013-2013__program__program2013.pdf 117
29339 29339 36214 2013 pdf:2013:I.11 1 Chair chair Barbara Todish Kean University, Newark, NJ   p:barbara-todish ror:04wzzqn13 pdf-2013-2013__program__program2013.pdf 202
30861 30861 37789 2014 pdf:2014:C.20 1 Chair chair Sally Chandler Kean University, Union, NJ   p:sally-chandler ror:04wzzqn13 pdf-2014-2014__program__program.pdf 127
46567 46567 53506 2019 pdf:2019:J.32 1 Chair chair Andre Jones Kean University, Union, NJ   p:andre-jones ror:04wzzqn13 pdf-2019-2019__02__CCCC2019FullProgram.pdf 250
49062 49062 55975 2020 pdf:2020:I.15 1 Chair chair Wendy Warren-Austin Kean University   p:wendy-warren-austin ror:04wzzqn13 pdf-2020-2020__02__2020CCCCFri.pdf 78

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 19.713ms · Data license: CC BY 4.0 (data), MIT (code) · Data source: Source code, methods and known limits