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

15 rows where institution_id = "ror:00bgtad15", role = "Speakers" and year = 2019

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: session_id, name_as_printed, affiliation_as_printed, person_id, page

year 1

  • 2019 · 15 ✖

role 1

  • Speakers · 15 ✖
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
44863 44863 51843 2019 pdf:2019:A.24 3 Speakers speaker Roseanne Gatto St. John’s University, New York, NY   p:roseanne-gatto ror:00bgtad15 pdf-2019-2019__02__CCCC2019FullProgram.pdf 74
44866 44866 51846 2019 pdf:2019:A.24 6 Speakers speaker Tara Roeder St. John’s University, New York, NY   p:tara-roeder ror:00bgtad15 pdf-2019-2019__02__CCCC2019FullProgram.pdf 74
45412 45412 52341 2019 pdf:2019:D.13 1 Speakers speaker Collin Craig St. John’s University, Queens, NY   p:collin-craig ror:00bgtad15 pdf-2019-2019__02__CCCC2019FullProgram.pdf 125
45578 45578 52510 2019 pdf:2019:E.10 1 Speakers speaker Sophie Bell St. John’s University, New York, NY ‘Your Grammar Is All Over the Place’: Translingualism and Intersectionality For Post-‘Language Rights’ Multilingual Student Writers p:sophie-bell ror:00bgtad15 pdf-2019-2019__02__CCCC2019FullProgram.pdf 141
45760 45760 52731 2019 pdf:2019:F.12 3 Speakers speaker Derek Owens St. John’s University, New York, NY   p:derek-owens ror:00bgtad15 pdf-2019-2019__02__CCCC2019FullProgram.pdf 172
45913 45913 52708 2019 pdf:2019:F.5 4 Speakers speaker Sheeba Varkey St. John’s University, New York, NY   p:sheeba-varkey ror:00bgtad15 pdf-2019-2019__02__CCCC2019FullProgram.pdf 170
46429 46429 53228 2019 pdf:2019:I.4 2 Speakers speaker Tamara Issak St. John’s University, New York, NY   p:tamara-issak ror:00bgtad15 pdf-2019-2019__02__CCCC2019FullProgram.pdf 223
46496 46496 53442 2019 pdf:2019:J.14 2 Speakers speaker Steven Alvarez St. John’s University, New York, NY   p:steven-alvarez ror:00bgtad15 pdf-2019-2019__02__CCCC2019FullProgram.pdf 243
46801 46801 53772 2019 pdf:2019:L.11 1 Speakers speaker Danielle Bacigalupo St. John’s University, New York, NY   p:danielle-bacigalupo ror:00bgtad15 pdf-2019-2019__02__CCCC2019FullProgram.pdf 301
46804 46804 53775 2019 pdf:2019:L.11 4 Speakers speaker Michael Reich St. John’s University, New York, NY   p:michael-reich ror:00bgtad15 pdf-2019-2019__02__CCCC2019FullProgram.pdf 301
47217 47217 54098 2019 pdf:2019:N.27 1 Speakers speaker Anne Ellen Geller St. John’s University, New York, NY   p:anne-ellen-geller ror:00bgtad15 pdf-2019-2019__02__CCCC2019FullProgram.pdf 335
47218 47218 54099 2019 pdf:2019:N.27 2 Speakers speaker Tina Iemma St. John’s University, New York, NY   p:tina-iemma ror:00bgtad15 pdf-2019-2019__02__CCCC2019FullProgram.pdf 335
47288 47288 54027 2019 pdf:2019:N.7 1 Speakers speaker Raquel Corona St. John’s University, New York, NY   p:raquel-corona ror:00bgtad15 pdf-2019-2019__02__CCCC2019FullProgram.pdf 328
47290 47290 54029 2019 pdf:2019:N.7 3 Speakers speaker Laura Lisabeth St. John’s University, New York, NY   p:laura-lisabeth ror:00bgtad15 pdf-2019-2019__02__CCCC2019FullProgram.pdf 328
47381 47381 51752 2019 pdf:2019:W.10 3 Speakers speaker Raquel Corona St. John’s University, Queens, NY   p:raquel-corona ror:00bgtad15 pdf-2019-2019__02__CCCC2019FullProgram.pdf 53

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