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

7 rows where institution_id = "ipeds:131159" and year = 2017

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: session_id, ord, role_group, affiliation_as_printed, page

role 2

year 1

  • 2017 · 7 ✖
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
40024 40024 46986 2017 pdf:2017:E.50 1 Speakers speaker Edward Comstock American University What Stanley Fish Can Teach Neurorhetoric p:edward-comstock ipeds:131159 pdf-2017-2017__program__2017program.pdf 175
40025 40025 46987 2017 pdf:2017:E.50 2 Speakers speaker Hunter Hoskins American University What’s Living or Dead in Stanley Fish’s Composition Theory? p:hunter-hoskins ipeds:131159 pdf-2017-2017__program__2017program.pdf 175
40026 40026 46988 2017 pdf:2017:E.50 3 Speakers speaker Mary Switalski American University Teaching Fish: Uses and Limits p:mary-switalski ipeds:131159 pdf-2017-2017__program__2017program.pdf 175
40513 40513 47485 2017 pdf:2017:G.43 2 Speakers speaker Niesha-Anne Green American University, Washington, DC   p:niesha-anne-green ipeds:131159 pdf-2017-2017__program__2017program.pdf 227
40576 40576 47346 2017 pdf:2017:G.8 2 Speakers speaker Alex Hodges American University   p:alex-hodges ipeds:131159 pdf-2017-2017__program__2017program.pdf 214
40578 40578 47348 2017 pdf:2017:G.8 4 Speakers speaker Alison Thomas American University   p:alison-thomas ipeds:131159 pdf-2017-2017__program__2017program.pdf 214
40915 40915 47901 2017 pdf:2017:I.34 1 Chair chair Cynthia Bair Van Dam American University, Washington, DC   p:cynthia-bair-van-dam ipeds:131159 pdf-2017-2017__program__2017program.pdf 269

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