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 institution_id = "ror:02dqehb95" and year = 2022

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: session_id, ord, role_group, source_document_id, page

year 1

  • 2022 · 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
51496 51496 58195 2022 pdf:2022:F.3 1 Speakers speaker Jennifer Bay Purdue University   p:jennifer-bay ror:02dqehb95 pdf-2022-2022__02__2022-CCCC-conv-A-M-sessions-2-21-22.pdf 22
51497 51497 58196 2022 pdf:2022:F.3 2 Speakers speaker Tracy Clark Purdue University   p:tracy-clark ror:02dqehb95 pdf-2022-2022__02__2022-CCCC-conv-A-M-sessions-2-21-22.pdf 22
51498 51498 58197 2022 pdf:2022:F.3 3 Speakers speaker Garrett Ivn Coln Purdue University   p:garrett-ivn-coln ror:02dqehb95 pdf-2022-2022__02__2022-CCCC-conv-A-M-sessions-2-21-22.pdf 22
51499 51499 58198 2022 pdf:2022:F.3 4 Speakers speaker Eliza Gellis Purdue University   p:eliza-gellis ror:02dqehb95 pdf-2022-2022__02__2022-CCCC-conv-A-M-sessions-2-21-22.pdf 22
51500 51500 58199 2022 pdf:2022:F.3 5 Speakers speaker Maryam Ghafoor Purdue University   p:maryam-ghafoor ror:02dqehb95 pdf-2022-2022__02__2022-CCCC-conv-A-M-sessions-2-21-22.pdf 22
51501 51501 58200 2022 pdf:2022:F.3 6 Speakers speaker Ryan Murphy Purdue University   p:ryan-murphy ror:02dqehb95 pdf-2022-2022__02__2022-CCCC-conv-A-M-sessions-2-21-22.pdf 22
51687 51687 58378 2022 pdf:2022:J.3 1 Roundtable Leaders facilitator Linda Haynes Purdue University   p:linda-haynes ror:02dqehb95 pdf-2022-2022__02__2022-CCCC-conv-A-M-sessions-2-21-22.pdf 40
51690 51690 58381 2022 pdf:2022:J.3 4 Roundtable Leaders facilitator Marisa Yerace Purdue University   p:marisa-yerace ror:02dqehb95 pdf-2022-2022__02__2022-CCCC-conv-A-M-sessions-2-21-22.pdf 40
51877 51877 58888 2022 pdf:2022:OD.113 1 Speakers speaker Rachel Atherton Purdue University   p:rachel-atherton ror:02dqehb95 pdf-2022-2022__03__2022-cccc-conv-On-Demand-sessions-3-8-22.pdf 45
52123 52123 59111 2022 pdf:2022:OD.186 1 Speakers speaker Jianfen Chen Purdue University   p:jianfen-chen ror:02dqehb95 pdf-2022-2022__03__2022-cccc-conv-On-Demand-sessions-3-8-22.pdf 72
52188 52188 59167 2022 pdf:2022:OD.208 2 Speakers speaker Shyam Pandey Purdue University STEM Job Market and Transnational Digital Writers’ Making of Multimodal Career Portfolio p:shyam-pandey ror:02dqehb95 pdf-2022-2022__03__2022-cccc-conv-On-Demand-sessions-3-8-22.pdf 81
52292 52292 59260 2022 pdf:2022:OD.237 4 Speakers speaker Caroline Jennings Purdue University Methods and Metaphors of Ear Training in Language Learning: Facilitating Cherokee Voices in Peer Review p:caroline-jennings ror:02dqehb95 pdf-2022-2022__03__2022-cccc-conv-On-Demand-sessions-3-8-22.pdf 93
52309 52309 59273 2022 pdf:2022:OD.242 1 Speaker speaker Phuong Tran Purdue University   p:phuong-tran ror:02dqehb95 pdf-2022-2022__03__2022-cccc-conv-On-Demand-sessions-3-8-22.pdf 95
52442 52442 59389 2022 pdf:2022:OD.281 2 Speaker speaker Mason Pellegrini Purdue University The Real Price of That Shrimp Cocktail: Why Academic Textbooks Cost So Much and Ways Forward with Open Access p:mason-pellegrini ror:02dqehb95 pdf-2022-2022__03__2022-cccc-conv-On-Demand-sessions-3-8-22.pdf 111

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