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:01q1z8k08", role = "Speakers" and year = 2007

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: session_id, ord, affiliation_as_printed

year 1

  • 2007 · 10 ✖

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
12060 12060 19056 2007 pdf:2007:A.12 3 Speakers speaker Robert Yagelski State University of New York at Albany Textbook Writing as Scholarly Inquiry: Selling Ideas or Selling Out? p:robert-yagelski ror:01q1z8k08 pdf-2007-2007__2007completeprogram.pdf 82
12207 12207 19000 2007 pdf:2007:AW.10 2 Speakers speaker Frank Madden The State University of New York/Westchester Community College, Valhalla, NY   p:frank-madden ror:01q1z8k08 pdf-2007-2007__2007completeprogram.pdf 70
12768 12768 19686 2007 pdf:2007:E.17 3 Speakers speaker Thomas Wirth Binghamton University, The State University of New York, Binghamton Education for the Purposes of Democracy: Intellectuals and Workers at the Rand School of Social Science p:thomas-wirth ror:01q1z8k08 pdf-2007-2007__2007completeprogram.pdf 135
13937 13937 20877 2007 pdf:2007:L.34 4 Speakers speaker Kathleen Ethel Welch Stony Brook University, The State University of New York Computer Classrooms and Composition-Rhetoric Classes p:kathleen-ethel-welch ror:01q1z8k08 pdf-2007-2007__2007completeprogram.pdf 251
13997 13997 20948 2007 pdf:2007:M.15 2 Speakers speaker Christine Timm The State University of New York, Westchester Community College, Valhalla, NY The New Voices of the Community: Two-Year College Poets on the Bowery p:christine-timm ror:01q1z8k08 pdf-2007-2007__2007completeprogram.pdf 257
13998 13998 20949 2007 pdf:2007:M.15 3 Speakers speaker James Werner The State University of New York, Westchester Community College, Valhalla, NY Crossing the Student/Teacher Divide at the Community College p:james-werner ror:01q1z8k08 pdf-2007-2007__2007completeprogram.pdf 257
13999 13999 20950 2007 pdf:2007:M.15 4 Speakers speaker Scott Zaluda The State University of New York, Westchester Community College, Valhalla, NY Africa and the Americas: Humanities Scholarship and the Community College p:scott-zaluda ror:01q1z8k08 pdf-2007-2007__2007completeprogram.pdf 257
14384 14384 21269 2007 pdf:2007:O.24 4 Speakers speaker Herbert Shapiro Empire State College of the State University of New York, Rochester The Use of Learning Contracts to Renegotiate Identities in the College Composition Classroom p:herbert-shapiro ror:01q1z8k08 pdf-2007-2007__2007completeprogram.pdf 284
14409 14409 21176 2007 pdf:2007:O.3 3 Speakers speaker Jennie Dautermann The State University of New York, Syracuse Collaborating on Chinese Business Writing Textbook Production p:jennie-dautermann ror:01q1z8k08 pdf-2007-2007__2007completeprogram.pdf 277
14566 14566 21449 2007 pdf:2007:P.33 3 Speakers speaker Patricia Dunn Stony Brook University, The State University of New York Analyzing Published Complaints about Language Use: Empowerment through Rhetorical Analysis p:patricia-dunn ror:01q1z8k08 pdf-2007-2007__2007completeprogram.pdf 301

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