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:04f00y561"

✎ View and edit SQL

This data as json, CSV (advanced)

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

year 6

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
7917 7917 14823 2005 pdf:2005:H.28 2 Presenters speaker Kate Pantelides Berkeley Preparatory High School, Tampa, FL   p:kate-pantelides ror:04f00y561 pdf-2005-2005__2005completeprogram.pdf 194
7918 7918 14824 2005 pdf:2005:H.28 3 Presenters speaker Victoria Bekiempis Berkeley Preparatory High School, Tampa, FL Diverse Perspectives on Access and Success: The Second Year of the Berkeley Study of Writing p:victoria-bekiempis ror:04f00y561 pdf-2005-2005__2005completeprogram.pdf 194
11406 11406 18514 2006 pdf:2006:L.10 1 Chair chair Sarada Weber Jones College Prep, Chicago, IL   p:sarada-weber-jones ror:04f00y561 pdf-2006-2006__2006programsaturday.pdf 23
33345 33345 40061 2015 pdf:2015:AW.2 3 Speakers speaker Andrea Becksvoort Girls Preparatory School, Chattanooga, TN   p:andrea-becksvoort ror:04f00y561 pdf-2015-2015__program__wed.pdf 21
46821 46821 53792 2019 pdf:2019:L.16 1 Speakers speaker Jobin Davis Hogan Preparatory Academy High School, Kansas City, MO Gender p:jobin-davis ror:04f00y561 pdf-2019-2019__02__CCCC2019FullProgram.pdf 303
49365 49365 56269 2020 pdf:2020:J.47 2 Roundtable Leaders facilitator Sarah Austin United States Air Force Academy Prep School   p:sarah-austin ror:04f00y561 pdf-2020-2020__02__2020CCCCFri.pdf 116
51449 51449 58148 2022 pdf:2022:D.8 1 Roundtable Leaders facilitator Sarah Austin United States Air Force Academy Prep School   p:sarah-austin ror:04f00y561 pdf-2022-2022__02__2022-CCCC-conv-A-M-sessions-2-21-22.pdf 17

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