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

14 rows where role = "Speaker" and year = 2018

✎ View and edit SQL

This data as json, CSV (advanced)

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

year 1

  • 2018 · 14 ✖

role 1

  • Speaker · 14 ✖
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
42366 42366 49425 2018 pdf:2018:A.46 2 Speaker speaker Louise Wetherbee Phelps Old Dominion University, Norfolk, VA   p:louise-wetherbee-phelps ipeds:232982 pdf-2018-2018__program__program.pdf 83
42468 42468 49031 2018 pdf:2018:AW.2 3 Speaker speaker Susan Miller-Cochran University of Arizona, Tucson   p:susan-miller-cochran ror:03m2x1q45 pdf-2018-2018__program__program.pdf 42
42754 42754 49649 2018 pdf:2018:C.2 10 Speaker speaker Amy Brumfield Idaho State University, Pocatello   p:amy-brumfield ror:0162z8b04 pdf-2018-2018__program__program.pdf 109
42835 42835 49650 2018 pdf:2018:C.4 1 Speaker speaker Nate Mickelson Guttman Community College, CUNY, New York, NY   p:nate-mickelson ror:04nq4b349 pdf-2018-2018__program__program.pdf 110
43417 43417 51072 2018 pdf:2018:FSIG.2 1 Speaker speaker Aparna Sinha California State University, Maritime   p:aparna-sinha ror:020qm1538 pdf-2018-2018__program__program.pdf 271
43706 43706 50679 2018 pdf:2018:H.43 2 Speaker speaker Yvette Johnson Arizona State University, Tempe   p:yvette-johnson ror:03efmqc40 pdf-2018-2018__program__program.pdf 230
44033 44033 51008 2018 pdf:2018:J.31 1 Speaker speaker Patricia Medved St. John’s University, Queens, NY   p:patricia-medved ror:00bgtad15 pdf-2018-2018__program__program.pdf 264
44600 44600 48945 2018 pdf:2018:MW.5 1 Speaker speaker Tiffiny Sia Texas Lutheran University, Seguin Psychology and the Post-Truth World p:tiffiny-sia ror:03gsa2724 pdf-2018-2018__program__program.pdf 37
44679 44679 50046 2018 pdf:2018:TSIG.19 2 Speaker speaker Deborah Rossen-Knill University of Rochester, NY   p:deborah-rossen-knill ror:022kthw22 pdf-2018-2018__program__program.pdf 152
44681 44681 50048 2018 pdf:2018:TSIG.21 2 Speaker speaker Sheeba Varkey St. John’s University, Queens, NY   p:sheeba-varkey ror:00bgtad15 pdf-2018-2018__program__program.pdf 156
44682 44682 50049 2018 pdf:2018:TSIG.21 3 Speaker speaker Transforms Our Narratives     p:transforms-our-narratives   pdf-2018-2018__program__program.pdf 156
44683 44683 50050 2018 pdf:2018:TSIG.21 4 Speaker speaker Cory Chamberlain University of New Hampshire, Durham   p:cory-chamberlain ror:01rmh9n78 pdf-2018-2018__program__program.pdf 156
44684 44684 50051 2018 pdf:2018:TSIG.21 5 Speaker speaker Elizabeth Leahy University of Tennessee, Chattanooga   p:elizabeth-leahy ror:020f3ap87 pdf-2018-2018__program__program.pdf 156
44719 44719 49234 2018 pdf:2018:W.11 1 Speaker speaker Steve Bailey Central Michigan University, Mount Pleasant   p:steve-bailey ror:02xawj266 pdf-2018-2018__program__program.pdf 54

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