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

9 rows where institution_id = "ror:02mpq6x41" and year = 2017

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ord, name_as_printed, affiliation_as_printed, person_id

year 1

  • 2017 · 9 ✖

role 1

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
39462 39462 46434 2017 pdf:2017:C.33 3 Speakers speaker Aaron Krall University of Illinois at Chicago Organizing Work: Faculty Unions, Higher Education, and the Capacity for Change p:aaron-krall ror:02mpq6x41 pdf-2017-2017__program__2017program.pdf 125
39610 39610 46583 2017 pdf:2017:D.13 1 Speakers speaker Lindsay Marshall University of Illinois at Chicago The Material of Disease p:lindsay-marshall ror:02mpq6x41 pdf-2017-2017__program__2017program.pdf 140
39901 39901 46882 2017 pdf:2017:E.25 3 Speakers speaker Nicole Khoury University of Illinois, Chicago   p:nicole-khoury ror:02mpq6x41 pdf-2017-2017__program__2017program.pdf 166
39937 39937 46911 2017 pdf:2017:E.32 1 Speakers speaker Tara Betts University of Illinois, Chicago   p:tara-betts ror:02mpq6x41 pdf-2017-2017__program__2017program.pdf 169
39967 39967 46941 2017 pdf:2017:E.39 2 Speakers speaker Russell Mayo University of Illinois at Chicago Share Your Work: Cultivating Communities of Labor and Care p:russell-mayo ror:02mpq6x41 pdf-2017-2017__program__2017program.pdf 171
40081 40081 47140 2017 pdf:2017:F.16 2 Speakers speaker Mark Bennett University of Illinois at Chicago Supporting Student Writers at a Dual AANAPISI/HSI University p:mark-bennett ror:02mpq6x41 pdf-2017-2017__program__2017program.pdf 195
41473 41473 48448 2017 pdf:2017:K.52 2 Speakers speaker Hailee Gibbons University of Illinois at Chicago Using ‘Demented Time’ to Cultivate Access and Relationships with People with Mental Disabilities p:hailee-gibbons ror:02mpq6x41 pdf-2017-2017__program__2017program.pdf 321
42073 42073 47001 2017 pdf:2017:TSIG.3 2 Speakers speaker Nicole Khoury University of Illinois, Chicago   p:nicole-khoury ror:02mpq6x41 pdf-2017-2017__program__2017program.pdf 177
42093 42093 45724 2017 pdf:2017:W.1 5 Speakers speaker Nicole Khoury University of Illinois, Chicago   p:nicole-khoury ror:02mpq6x41 pdf-2017-2017__program__2017program.pdf 51

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