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

8 rows where institution_id = "ror:0259gsa43"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: session_id, ord, role_group, name_as_printed, affiliation_as_printed, person_id, source_document_id, page

year 3

role 3

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
14200 14200 21092 2007 pdf:2007:N.16 1 Chair chair Keith Peterson Brigham Young University–Hawai’i, Laie   p:keith-peterson ror:0259gsa43 pdf-2007-2007__2007completeprogram.pdf 269
14201 14201 21093 2007 pdf:2007:N.16 2 Speakers speaker Keith Peterson Brigham Young University–Hawai’i, Laie Appropriating the Fiction of Fact and Fact of Fiction from British Travel Writings to De-Shackle and Re-Present Identity for the Colonized p:keith-peterson ror:0259gsa43 pdf-2007-2007__2007completeprogram.pdf 269
14202 14202 21094 2007 pdf:2007:N.16 3 Speakers speaker Sanoma Goodwill Brigham Young University–Hawai’i, Laie Developing Professional Identity by Appropriating Professional Voice: A Case Study of Biology Senior Theses in Draft p:sanoma-goodwill ror:0259gsa43 pdf-2007-2007__2007completeprogram.pdf 269
54550 54550 61450 2023 pdf:2023:M.34 1 Speakers speaker Christina Akanoa Brigham Young University-Hawaii   p:christina-akanoa ror:0259gsa43 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 312
54551 54551 61451 2023 pdf:2023:M.34 2 Speakers speaker Becky DeMartini Brigham Young University-Hawaii   p:becky-demartini ror:0259gsa43 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 312
54552 54552 61452 2023 pdf:2023:M.34 3 Speakers speaker Caryn Lesuma Brigham Young University-Hawaii   p:caryn-lesuma ror:0259gsa43 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 312
54553 54553 61453 2023 pdf:2023:M.34 4 Speakers speaker Spencer Scanlan Brigham Young University-Hawaii   p:spencer-scanlan ror:0259gsa43 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 312
62089 62089 7310 2027 eshow:814F86A6-A9DD-94E8-611A-7129CA2D8502 1 Presenter speaker Benjamin Brown Brigham Young University Hawai'i   p:benjamin-brown ror:0259gsa43 eshow-listing-2027  

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