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 = "ror:04q3ga974"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ord, role_group, name_as_printed, affiliation_as_printed, person_id, source_document_id

year 5

role 2

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
15876 15876 22910 2008 pdf:2008:F.30 3 Speakers speaker Melanie Van der Tuin Leeward Community College, Pearl City, HI The Road to Waianae p:melanie-van-der-tuin ror:04q3ga974 pdf-2008-2008__2008completeprogram.pdf 166
22929 22929 27024 2010 pdf:2010:W.2 5 Speakers speaker Susan Waldman Leeward Community College, Kaneohe, HI   p:susan-waldman ror:04q3ga974 pdf-2010-2010__cccc2010-program.pdf 64
31635 31635 38549 2014 pdf:2014:G.27 1 Speakers speaker Susan Waldman Leeward Community College, Pearl City, HI Meeting Students Where They Are: Using Local Issues to Focus Writing and Research for a First-Year Composition Course p:susan-waldman ror:04q3ga974 pdf-2014-2014__program__program.pdf 196
34346 34346 41220 2015 pdf:2015:F.4 3 Speakers speaker Cara Chang Leeward Community College, Aiea, HI From Mauka to Makai: Incorporating Place-Based Education and Culture-Based Education into Writing Courses p:cara-chang ror:04q3ga974 pdf-2015-2015__program__fri.pdf 3
34734 34734 41696 2015 pdf:2015:H.20 3 Speakers speaker Junie Hayashi Leeward Community College, Pearl City, HI Epic Research in English 100 p:junie-hayashi ror:04q3ga974 pdf-2015-2015__program__fri.pdf 46
39881 39881 46862 2017 pdf:2017:E.21 1 Chair chair Jeffrey Breitenfeldt Leeward Community College   p:jeffrey-breitenfeldt ror:04q3ga974 pdf-2017-2017__program__2017program.pdf 164
41388 41388 48370 2017 pdf:2017:K.33 1 Speakers speaker Jeffrey Breitenfeldt Leeward Community College Cultivating Expertise from ‘Wicked Problems’: Strategies for Using Visual Argument and Design to Improve Student Writing p:jeffrey-breitenfeldt ror:04q3ga974 pdf-2017-2017__program__2017program.pdf 314

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