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:05rrcem69" 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 · 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
42386 42386 49244 2018 pdf:2018:A.5 1 Speakers speaker Sophia Bamert University of California, Davis   p:sophia-bamert ror:05rrcem69 pdf-2018-2018__program__program.pdf 67
42841 42841 49793 2018 pdf:2018:C.41 3 Speakers speaker Theresa Walsh University of California, Davis Laboring and Lecturing: Whose Baby Is This? p:theresa-walsh ror:05rrcem69 pdf-2018-2018__program__program.pdf 124
43141 43141 50131 2018 pdf:2018:E.20 4 Speakers speaker Michele Zugnoni University of California, Davis Exploring First-Generation Spaces through Practices of Self-Reflection p:michele-zugnoni ror:05rrcem69 pdf-2018-2018__program__program.pdf 166
43452 43452 50423 2018 pdf:2018:G.19 1 Speakers speaker Lauren Fink University of California, Davis   p:lauren-fink ror:05rrcem69 pdf-2018-2018__program__program.pdf 205
43453 43453 50424 2018 pdf:2018:G.19 2 Speakers speaker Julia Singleton University of California, Davis   p:julia-singleton ror:05rrcem69 pdf-2018-2018__program__program.pdf 205
43454 43454 50425 2018 pdf:2018:G.19 3 Speakers speaker Victoria White University of California, Davis   p:victoria-white ror:05rrcem69 pdf-2018-2018__program__program.pdf 205
43547 43547 50376 2018 pdf:2018:G.5 4 Speakers speaker Vajra Watson University of California, Davis Learning to Write the Poetry of Life and Hope with Marginalized Youth p:vajra-watson ror:05rrcem69 pdf-2018-2018__program__program.pdf 201
43927 43927 50892 2018 pdf:2018:I.50 3 Speakers speaker Katherina Sibbald University of California, Davis Eavesdropping on System Talk: Critical Reflections on Discourses in High School Literature Writing Conferences p:katherina-sibbald ror:05rrcem69 pdf-2018-2018__program__program.pdf 252
43947 43947 50923 2018 pdf:2018:J.10 5 Speakers speaker Brenda Rinard University of California, Davis Using Classic Books in Biology to Explore the Interdisciplinary Features in Popular Science Writing p:brenda-rinard ror:05rrcem69 pdf-2018-2018__program__program.pdf 256
44141 44141 51131 2018 pdf:2018:K.14 2 Speakers speaker Kendon Kurzer University of California, Davis   p:kendon-kurzer ror:05rrcem69 pdf-2018-2018__program__program.pdf 300
44224 44224 51203 2018 pdf:2018:K.38 3 Speakers speaker Carl Whithaus University of California, Davis   p:carl-whithaus ror:05rrcem69 pdf-2018-2018__program__program.pdf 307
44365 44365 51344 2018 pdf:2018:L.30 4 Speakers speaker Tricia Serviss University of California, Davis Lives on the Boundaries of Cultural and Professional Worlds: Reports from a Longitudinal Study of First-Generation STEM Undergraduate Literacies p:tricia-serviss ror:05rrcem69 pdf-2018-2018__program__program.pdf 323
44553 44553 48999 2018 pdf:2018:MW.12 3 Speakers speaker Dan Melzer University of California, Davis   p:dan-melzer ror:05rrcem69 pdf-2018-2018__program__program.pdf 40
44582 44582 48927 2018 pdf:2018:MW.3 6 Workshop Facilitators facilitator Brenda Rinard University of California, Davis   p:brenda-rinard ror:05rrcem69 pdf-2018-2018__program__program.pdf 36

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