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

20 rows where institution_id = "ror:05dk0ce17" and year = 2018

✎ View and edit SQL

This data as json, CSV (advanced)

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

year 1

  • 2018 · 20 ✖
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
42606 42606 49569 2018 pdf:2018:B.31 1 Speakers speaker Brandon Dudley Washington State University, Pullman   p:brandon-dudley ror:05dk0ce17 pdf-2018-2018__program__program.pdf 95
42607 42607 49570 2018 pdf:2018:B.31 2 Speakers speaker David Saldivar Washington State University, Pullman   p:david-saldivar ror:05dk0ce17 pdf-2018-2018__program__program.pdf 95
42608 42608 49571 2018 pdf:2018:B.31 3 Speakers speaker Rachel Sanchez Washington State University, Pullman   p:rachel-sanchez ror:05dk0ce17 pdf-2018-2018__program__program.pdf 95
42609 42609 49572 2018 pdf:2018:B.31 4 Respondent respondent Jonathan Torres Washington State University, Pullman   p:jonathan-torres ror:05dk0ce17 pdf-2018-2018__program__program.pdf 95
42702 42702 49481 2018 pdf:2018:B.8 5 Speakers speaker Victor Villanueva Washington State University, Pullman What We Know p:victor-villanueva ror:05dk0ce17 pdf-2018-2018__program__program.pdf 87
43029 43029 49838 2018 pdf:2018:D.4 4 Speakers speaker Mark Triana Washington State University, Pullman   p:mark-triana ror:05dk0ce17 pdf-2018-2018__program__program.pdf 131
43032 43032 49841 2018 pdf:2018:D.4 7 Respondents respondent Victor Villanueva Washington State University, Pullman   p:victor-villanueva ror:05dk0ce17 pdf-2018-2018__program__program.pdf 131
43367 43367 50347 2018 pdf:2018:F.38 1 Chair chair Victor Villanueva Washington State University, Pullman   p:victor-villanueva ror:05dk0ce17 pdf-2018-2018__program__program.pdf 192
43440 43440 50411 2018 pdf:2018:G.15 2 Speakers speaker Jonathan Torres Washington State University, Pullman   p:jonathan-torres ror:05dk0ce17 pdf-2018-2018__program__program.pdf 204
43719 43719 50692 2018 pdf:2018:H.47 1 Speakers speaker Beth Buyserie Washington State University, Pullman   p:beth-buyserie ror:05dk0ce17 pdf-2018-2018__program__program.pdf 231
43720 43720 50693 2018 pdf:2018:H.47 2 Speakers speaker Edie-Marie Roper Washington State University, Pullman   p:edie-marie-roper ror:05dk0ce17 pdf-2018-2018__program__program.pdf 231
43721 43721 50694 2018 pdf:2018:H.47 3 Speakers speaker Mark Triana Washington State University, Pullman   p:mark-triana ror:05dk0ce17 pdf-2018-2018__program__program.pdf 231
43722 43722 50695 2018 pdf:2018:H.47 4 Speakers speaker Tabitha Espina Velasco Washington State University, Pullman   p:tabitha-espina-velasco ror:05dk0ce17 pdf-2018-2018__program__program.pdf 231
43723 43723 50696 2018 pdf:2018:H.47 5 Speakers speaker Kate Watts Washington State University, Pullman   p:kate-watts ror:05dk0ce17 pdf-2018-2018__program__program.pdf 231
43838 43838 50813 2018 pdf:2018:I.30 3 Speakers speaker Zarah Moeggenberg Washington State University, Pullman Failing on Purpose with Bodies: A Queer Inquiry into Making All Bodies Count p:zarah-moeggenberg ror:05dk0ce17 pdf-2018-2018__program__program.pdf 244
43869 43869 50844 2018 pdf:2018:I.37 6 Respondent respondent Victor Villanueva Washington State University, Pullman   p:victor-villanueva ror:05dk0ce17 pdf-2018-2018__program__program.pdf 247
44103 44103 50901 2018 pdf:2018:J.5 3 Speakers speaker Michael Edwards Washington State University, Pullman The Economic Transformation of Written Labor into Data from Learning Management Systems: Students’ Rights to Their Own Digital Capital p:michael-edwards ror:05dk0ce17 pdf-2018-2018__program__program.pdf 254
44107 44107 50905 2018 pdf:2018:J.6 3 Speakers speaker Anna Plemons Washington State University, Pullman A Pedagogy for the Visiting Room: Indigenous Theory and Relational Methodologies in the Prison Classroom p:anna-plemons ror:05dk0ce17 pdf-2018-2018__program__program.pdf 254
44198 44198 51177 2018 pdf:2018:K.30 1 Speakers speaker Lucy Johnson Washington State University, Pullman (Re)Inventing in Affective Spaces p:lucy-johnson ror:05dk0ce17 pdf-2018-2018__program__program.pdf 305
44562 44562 49008 2018 pdf:2018:MW.13 9 Workshop Facilitators facilitator Anna Plemons Washington State University, Pullman   p:anna-plemons ror:05dk0ce17 pdf-2018-2018__program__program.pdf 40

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