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:0294hxs80", role = "Speakers" and year = 2023

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: session_id, ord, person_id, page

year 1

  • 2023 · 8 ✖

role 1

  • Speakers · 8 ✖
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
53089 53089 59947 2023 pdf:2023:B.24 1 Speakers speaker Danelle Dyckhoff California State University, Los Angeles   p:danelle-dyckhoff ror:0294hxs80 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 92
53090 53090 59948 2023 pdf:2023:B.24 2 Speakers speaker Linda Greenberg California State University, Los Angeles   p:linda-greenberg ror:0294hxs80 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 92
53091 53091 59949 2023 pdf:2023:B.24 3 Speakers speaker Mijanur Rahman California State University, Los Angeles   p:mijanur-rahman ror:0294hxs80 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 92
53966 53966 60803 2023 pdf:2023:H.38 3 Speakers speaker Mijanur Rahman California State University, Los Angeles ‘Return of the Repressed’: Celebrating Diverse Writing Practices p:mijanur-rahman ror:0294hxs80 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 208
54699 54699 61607 2023 pdf:2023:OD.42 1 Speakers speaker Danelle Dyckhoff California State University, Los Angeles   p:danelle-dyckhoff ror:0294hxs80 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 333
54700 54700 61608 2023 pdf:2023:OD.42 2 Speakers speaker Rebecca MacLean California State University, Los Angeles   p:rebecca-maclean ror:0294hxs80 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 333
54701 54701 61609 2023 pdf:2023:OD.42 3 Speakers speaker Raoul Rodriguez California State University, Los Angeles   p:raoul-rodriguez ror:0294hxs80 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 333
54702 54702 61610 2023 pdf:2023:OD.42 4 Speakers speaker Jasper Yangchareon California State University, Los Angeles   p:jasper-yangchareon ror:0294hxs80 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 333

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