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 = "Presenters" and year = 2023

✎ View and edit SQL

This data as json, CSV (advanced)

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

year 1

  • 2023 · 10 ✖

role 1

  • Presenters · 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
52954 52954 59848 2023 pdf:2023:A.39 1 Presenters speaker Kristin Arola Michigan State University   p:kristin-arola ror:05hs6h993 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 80
52955 52955 59849 2023 pdf:2023:A.39 2 Presenters speaker Maria Novotny University of Wisconsin-Milwaukee   p:maria-novotny ror:031q21x57 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 80
52956 52956 59850 2023 pdf:2023:A.39 3 Presenters speaker Ames Hawkins Columbia College Chicago   p:ames-hawkins ror:03a3kvy61 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 80
52957 52957 59851 2023 pdf:2023:A.39 4 Presenters speaker Karrieann M. Soto Vega University of Kentucky   p:karrieann-m-soto-vega ror:02k3smh20 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 80
53436 53436 60171 2023 pdf:2023:D.8 1 Presenters speaker Michelle Bean Knabe California State University, Sacramento   p:michelle-bean-knabe ror:03e26wv14 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 122
53437 53437 60172 2023 pdf:2023:D.8 2 Presenters speaker Angela Laflen California State University, Sacramento   p:angela-laflen ror:03e26wv14 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 122
54904 54904 60420 2023 pdf:2023:TSIG.24 1 Presenters speaker Analeigh Horton University of Arizona   p:analeigh-horton ror:03m2x1q45 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 154
54905 54905 60421 2023 pdf:2023:TSIG.24 2 Presenters speaker Shawna Shapiro Middlebury College   p:shawna-shapiro ror:0217hb928 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 154
54906 54906 60422 2023 pdf:2023:TSIG.24 3 Presenters speaker Zhaozhe Wang University of Toronto   p:zhaozhe-wang ror:03dbr7087 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 154
54907 54907 60423 2023 pdf:2023:TSIG.24 4 Presenters speaker Qianqian Zhang-Wu Northeastern University   p:qianqian-zhang-wu ipeds:167358 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 154

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