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

4 rows where institution_id = "ror:01zkghx44", role = "Chair" and year = 1999

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ord, source_document_id

year 1

  • 1999 · 4 ✖

role 1

  • Chair · 4 ✖
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
2210 2210 10533 1999 pdf:1999:AW.9 1 Chair chair TyAnna K. Herrington Georgia Institute of Technology, Atlanta   p:tyanna-herrington ror:01zkghx44 pdf-1999-99__program__wed-workshops.pdf 12
2306 2306 9020 1999 pdf:1999:B.25 1 Chair chair Heather J. Huddleston Georgia Institute of Technology, Atlanta   p:heather-j-huddleston ror:01zkghx44 pdf-1999-99__program__b.pdf 5
3221 3221 9865 1999 pdf:1999:J.2 1 Chair chair Gregory VanHoosier-Carey Georgia Institute of Technology, Atlanta   p:gregory-vanhoosier-carey ror:01zkghx44 pdf-1999-99__program__j.pdf 1
3650 3650 10555 1999 pdf:1999:RN.1 3 Chair chair Jay Bolter Georgia Institute of Technology (an overview of hypermedia, where it is and where it is going, and how it is changing the way we teach and learn), Georgia Institute of Technology   p:jay-bolter ror:01zkghx44 pdf-1999-99__program__wed-workshops.pdf 13

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