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

10 rows where institution_id = "ror:02gn3zg65" and role = "Speakers"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ord, name_as_printed, affiliation_as_printed, person_id, source_document_id

year 9

role 1

  • Speakers · 10 ✖
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
11840 11840 17237 2006 pdf:2006:TSIG.4 5 Speakers speaker Katherine Frank Dvorsky Colorado State University, Pueblo Fostering Communication and Collaboration through Dual-Credit Programs p:katherine-frank-dvorsky ror:02gn3zg65 pdf-2006-2006__2006programthursday.pdf 91
20300 20300 27279 2010 pdf:2010:A.29 3 Speakers speaker Patricia Trujillo Colorado State University–Pueblo Ristra Composition: Sustainable, Land-based Pedagogical Practices in Northern New Mexico p:patricia-trujillo ror:02gn3zg65 pdf-2010-2010__cccc2010-program.pdf 88
26921 26921 33810 2012 pdf:2012:I.2 2 Speakers speaker Scott Gage Colorado State University-Pueblo Corporeal Invitations: Photography and Pathos in Nineteenth-Century Constructions of Race and Gender p:scott-gage ror:02gn3zg65 pdf-2012-2012__program__program2012.pdf 210
29829 29829 36747 2013 pdf:2013:L.22 3 Speakers speaker Scott Gage Colorado State University-Pueblo Teaching the Lynching Archive p:scott-gage ror:02gn3zg65 pdf-2013-2013__program__program2013.pdf 274
33628 33628 40593 2015 pdf:2015:C.17 2 Speakers speaker Scott Gage Colorado State University-Pueblo The Archive, the Image, the Memory: Challenging White Supremacist Memories of Lynching in the Writing Classroom p:scott-gage ror:02gn3zg65 pdf-2015-2015__program__thurs.pdf 45
37767 37767 44645 2016 pdf:2016:I.7 4 Speakers speaker Scott Gage Colorado State University-Pueblo A Pedagogy of Multimodal Activism: Resisting the Multimodal Message in the Classroom p:scott-gage ror:02gn3zg65 pdf-2016-2016__program__2016program.pdf 214
39770 39770 46732 2017 pdf:2017:D.47 5 Speakers speaker Jason Saphara Colorado State University-Pueblo   p:jason-saphara ror:02gn3zg65 pdf-2017-2017__program__2017program.pdf 153
44120 44120 50918 2018 pdf:2018:J.9 4 Speakers speaker Kevin Van Winkle Colorado State University, Pueblo The Rhetoric of Visual Euphemism in W. E. B. DuBois’s Infographics p:kevin-van-winkle ror:02gn3zg65 pdf-2018-2018__program__program.pdf 256
45932 45932 53568 2019 pdf:2019:FSIG.13 2 Speakers speaker Danny Iberri-Shea Colorado State University, Pueblo   p:danny-iberri-shea ror:02gn3zg65 pdf-2019-2019__02__CCCC2019FullProgram.pdf 259
46240 46240 53184 2019 pdf:2019:H.37 2 Speakers speaker Danny Iberri-Shea Colorado State University, Pueblo   p:danny-iberri-shea ror:02gn3zg65 pdf-2019-2019__02__CCCC2019FullProgram.pdf 218

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