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

12 rows where institution_id = "ror:01y2jtd41" and year = 2023

✎ View and edit SQL

This data as json, CSV (advanced)

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

year 1

  • 2023 · 12 ✖

role 1

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
52943 52943 59837 2023 pdf:2023:A.36 1 Speakers speaker Nick Avery University of Wisconsin-Madison   p:nick-avery ror:01y2jtd41 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 79
52944 52944 59838 2023 pdf:2023:A.36 2 Speakers speaker Nora Harris University of Wisconsin-Madison   p:nora-harris ror:01y2jtd41 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 79
52946 52946 59840 2023 pdf:2023:A.36 4 Speakers speaker Eileen Lagman University of Wisconsin-Madison   p:eileen-lagman ror:01y2jtd41 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 79
52975 52975 59742 2023 pdf:2023:A.6 9 Speakers speaker Brenna Swift University of Wisconsin-Madison If You Enjoy Making It, It’s Worthwhile p:brenna-swift ror:01y2jtd41 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 67
52987 52987 59754 2023 pdf:2023:A.8 3 Speakers speaker Catherine Vieira University of Wisconsin-Madison   p:kate-vieira ror:01y2jtd41 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 68
53291 53291 60016 2023 pdf:2023:C.4 6 Speakers speaker Morris Young University of Wisconsin-Madison Flexibility as Value: Creating Conditions for Dis/Engagement p:morris-young ror:01y2jtd41 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 103
53426 53426 60161 2023 pdf:2023:D.5 5 Speakers speaker Guadalupe Remigio Ortega University of Wisconsin Madison   p:guadalupe-remigio-ortega ror:01y2jtd41 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 120
53745 53745 60602 2023 pdf:2023:G.12 3 Speakers speaker Olagbenro Oladipo University of Wisconsin-Madison Whose English?: Resistance, Agency, and the Writing Classroom p:olagbenro-oladipo ror:01y2jtd41 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 180
53858 53858 60581 2023 pdf:2023:G.7 1 Speakers speaker Alexandra Chakov University of Wisconsin-Madison   p:alexandra-chakov ror:01y2jtd41 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 179
53971 53971 60705 2023 pdf:2023:H.4 5 Speakers speaker Brenna Swift University of Wisconsin-Madison ‘I Had to Write My Way through It’: Disabled Writers Journaling to Name and Build Futures p:brenna-swift ror:01y2jtd41 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 196
54675 54675 61584 2023 pdf:2023:OD.30 1 Speakers speaker Henry Covey University of Wisconsin-Madison   p:henry-covey ror:01y2jtd41 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 329
54786 54786 61691 2023 pdf:2023:OD.98 9 Speakers speaker Nathan Workman University of Wisconsin-Madison   p:nathan-workman ror:01y2jtd41 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 346

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