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:03k1gpj17" and year = 2017

✎ 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, page

year 1

  • 2017 · 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
39257 39257 46223 2017 pdf:2017:B.39 3 Speakers speaker Mike Palmquist Colorado State University Open-Access Books: The Art, Craft, Theory, and Economics of the Publishing Collaborative p:mike-palmquist ror:03k1gpj17 pdf-2017-2017__program__2017program.pdf 106
39673 39673 46643 2017 pdf:2017:D.27 3 Speakers speaker Sue Doe Colorado State University, Fort Collins How the Arts Can Inform STEM Writing: Social Practice as Threshold Concept in Writing Studies p:sue-doe ror:03k1gpj17 pdf-2017-2017__program__2017program.pdf 146
39694 39694 46664 2017 pdf:2017:D.32 2 Speakers speaker Doug Cloud Colorado State University Resisting Change: Rhetorical Strategies for Revealing/Concealing Animus in Public Arguments about LGBTQ People p:doug-cloud ror:03k1gpj17 pdf-2017-2017__program__2017program.pdf 148
40090 40090 47149 2017 pdf:2017:F.18 1 Chair chair Gwen Gorzelsky Colorado State University   p:gwen-gorzelsky ror:03k1gpj17 pdf-2017-2017__program__2017program.pdf 195
40091 40091 47150 2017 pdf:2017:F.18 2 Speakers speaker Gwen Gorzelsky Colorado State University   p:gwen-gorzelsky ror:03k1gpj17 pdf-2017-2017__program__2017program.pdf 195
40949 40949 47929 2017 pdf:2017:I.40 2 Speakers speaker Timothy Amidon Colorado State University Secret Spots and Surf Cultures: Localism, Nomoi, and Appropriative Disclosure p:timothy-amidon ror:03k1gpj17 pdf-2017-2017__program__2017program.pdf 272
40993 40993 47782 2017 pdf:2017:I.5 5 Respondent respondent Tobi Jacobi Colorado State University, Fort Collins   p:tobi-jacobi ror:03k1gpj17 pdf-2017-2017__program__2017program.pdf 258
41219 41219 48198 2017 pdf:2017:J.45 5 Speakers speaker Tobi Jacobi Colorado State University, Fort Collins Not ‘All Ellas’: Risking Exploitation in a Prison Public Memory Project p:tobi-jacobi ror:03k1gpj17 pdf-2017-2017__program__2017program.pdf 296
41923 41923 45463 2017 pdf:2017:MW.3 6 Speakers speaker Tobi Jacobi Colorado State University, Fort Collins   p:tobi-jacobi ror:03k1gpj17 pdf-2017-2017__program__2017program.pdf 35
41945 41945 45485 2017 pdf:2017:MW.5 10 Workshop Facilitators facilitator Tobi Jacobi Colorado State University, Fort Collins   p:tobi-jacobi ror:03k1gpj17 pdf-2017-2017__program__2017program.pdf 36
42031 42031 47036 2017 pdf:2017:TSIG.19 2 Chairs chair Sue Doe Colorado State University, Fort Collins   p:sue-doe ror:03k1gpj17 pdf-2017-2017__program__2017program.pdf 181
42182 42182 45786 2017 pdf:2017:W.8 2 Speakers speaker Natalie Barnes Colorado State University, Fort Collins   p:natalie-barnes ror:03k1gpj17 pdf-2017-2017__program__2017program.pdf 55
42183 42183 45787 2017 pdf:2017:W.8 3 Speakers speaker Sue Doe Colorado State University, Fort Collins   p:sue-doe ror:03k1gpj17 pdf-2017-2017__program__2017program.pdf 55
42185 42185 45789 2017 pdf:2017:W.8 5 Speakers speaker Lydia Page Colorado State University, Fort Collins   p:lydia-page ror:03k1gpj17 pdf-2017-2017__program__2017program.pdf 55

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