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

11 rows where institution_id = "ror:03k1gpj17" and year = 2019

✎ 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, page

year 1

  • 2019 · 11 ✖
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
45772 45772 52743 2019 pdf:2019:F.16 1 Speakers speaker Tobi Jacobi Colorado State University, Fort Collins Ribbon Girls, Cottage Matrons, and Parole Letters: A Feminist Reads the 1915 Annual Report from the New York State Training School for Girls p:tobi-jacobi ror:03k1gpj17 pdf-2019-2019__02__CCCC2019FullProgram.pdf 174
45986 45986 52936 2019 pdf:2019:G.17 3 Speakers speaker Mike Palmquist Colorado State University, Fort Collins   p:mike-palmquist ror:03k1gpj17 pdf-2019-2019__02__CCCC2019FullProgram.pdf 191
46038 46038 52878 2019 pdf:2019:G.3 1 Speakers speaker Sheri Anderson Colorado State University, Fort Collins The Veterans’ Imprint on the Land Grant U—Physical and Programmatic p:sheri-anderson ror:03k1gpj17 pdf-2019-2019__02__CCCC2019FullProgram.pdf 187
46039 46039 52879 2019 pdf:2019:G.3 2 Speakers speaker Ross Atkinson Colorado State University, Fort Collins Strength-Based Pedagogy from a Vet’s Point of View p:ross-atkinson ror:03k1gpj17 pdf-2019-2019__02__CCCC2019FullProgram.pdf 187
46040 46040 52880 2019 pdf:2019:G.3 3 Speakers speaker Erin Davis US Army and Colorado State University, Fort Collins Genre and Military Literacies p:erin-davis ror:03k1gpj17 pdf-2019-2019__02__CCCC2019FullProgram.pdf 187
46041 46041 52881 2019 pdf:2019:G.3 4 Speakers speaker Ann Diaz Colorado State University, Fort Collins Bridging the Military-Civilian Gap via the American Legion p:ann-diaz ror:03k1gpj17 pdf-2019-2019__02__CCCC2019FullProgram.pdf 187
46042 46042 52882 2019 pdf:2019:G.3 5 Speakers speaker Lisa Langstraat Colorado State University, Fort Collins A Veteran Writing Workshop Collaboration with the Public Library p:lisa-langstraat ror:03k1gpj17 pdf-2019-2019__02__CCCC2019FullProgram.pdf 187
46449 46449 53386 2019 pdf:2019:I.44 2 Speaker speaker Tim Amidon Colorado State University, Fort Collins   p:timothy-amidon ror:03k1gpj17 pdf-2019-2019__02__CCCC2019FullProgram.pdf 237
47107 47107 51526 2019 pdf:2019:MW.3 1 Workshop Facilitator facilitator Genesea Carter Colorado State University, Fort Collins   p:genesea-carter ror:03k1gpj17 pdf-2019-2019__02__CCCC2019FullProgram.pdf 38
47108 47108 51527 2019 pdf:2019:MW.3 2 Roundtable Leaders facilitator Kelly Bradbury Colorado State University, Fort Collins   p:kelly-bradbury ror:03k1gpj17 pdf-2019-2019__02__CCCC2019FullProgram.pdf 38
47305 47305 54164 2019 pdf:2019:SW.1 7 Workshop Facilitators facilitator Tobi Jacobi Colorado State University, Fort Collins   p:tobi-jacobi ror:03k1gpj17 pdf-2019-2019__02__CCCC2019FullProgram.pdf 342

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