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:00bgtad15", role = "Co-Chairs" and year = 2015

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: session_id, ord, affiliation_as_printed, page

year 1

  • 2015 · 11 ✖

role 1

  • Co-Chairs · 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
33372 33372 40088 2015 pdf:2015:AW.6 1 Co-Chairs chair Nathalie Virgintino St. John’s University, Queens, NY   p:nathalie-virgintino ror:00bgtad15 pdf-2015-2015__program__wed.pdf 23
33373 33373 40089 2015 pdf:2015:AW.6 2 Co-Chairs chair Tom Philipose St. John’s University, Queens, NY   p:tom-philipose ror:00bgtad15 pdf-2015-2015__program__wed.pdf 23
33374 33374 40090 2015 pdf:2015:AW.6 3 Co-Chairs chair Dan Dissinger St. John’s University, Queens, NY   p:dan-dissinger ror:00bgtad15 pdf-2015-2015__program__wed.pdf 23
33375 33375 40091 2015 pdf:2015:AW.6 4 Co-Chairs chair Nancy Alvarez St. John’s University, Queens, NY   p:nancy-alvarez ror:00bgtad15 pdf-2015-2015__program__wed.pdf 23
33377 33377 40093 2015 pdf:2015:AW.6 6 Co-Chairs chair Katelynn Deluca St. John’s University, Queens, NY   p:katelynn-deluca ror:00bgtad15 pdf-2015-2015__program__wed.pdf 23
33378 33378 40094 2015 pdf:2015:AW.6 7 Co-Chairs chair Cristina Migliaccio St. John’s University, Queens, NY   p:cristina-migliaccio ror:00bgtad15 pdf-2015-2015__program__wed.pdf 23
33379 33379 40095 2015 pdf:2015:AW.6 8 Co-Chairs chair Nick Young St. John’s University, Queens, NY   p:nick-young ror:00bgtad15 pdf-2015-2015__program__wed.pdf 23
33380 33380 40096 2015 pdf:2015:AW.6 9 Co-Chairs chair Scott Morgan St. John’s University, Queens, NY   p:scott-morgan ror:00bgtad15 pdf-2015-2015__program__wed.pdf 23
33382 33382 40098 2015 pdf:2015:AW.6 11 Co-Chairs chair Anna Sicari St. John’s University, Queens, NY   p:anna-sicari ror:00bgtad15 pdf-2015-2015__program__wed.pdf 23
35871 35871 41202 2015 pdf:2015:TSIG.26 2 Co-Chairs chair Sharon Marshall St. John’s University, New York, NY   p:sharon-marshall ror:00bgtad15 pdf-2015-2015__program__thurs.pdf 100
35927 35927 39945 2015 pdf:2015:W.2 7 Co-Chairs chair Roseanne Gatto St John’s University, Queens, NY   p:roseanne-gatto ror:00bgtad15 pdf-2015-2015__program__wed.pdf 14

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