appearances
Data license: CC BY 4.0 (data), MIT (code) · Data source: Source code, methods and known limits
3 rows where institution_id = "ror:03taz7m60", role = "Presenter" and year = 2024
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 55382 | 55382 | 737 | 2024 | eshow:98C49BEC-0DE5-A705-FFB0-A82BBF90DD21 | 1 | Presenter | speaker | Michelle Brittan Rosado | University of Southern California | p:michelle-brittan-rosado | ror:03taz7m60 | eshow-listing-2024 | ||
| 55466 | 55466 | 2215 | 2024 | eshow:98C6B9EF-BDA0-858E-2DC6-D888A9DBE8AC | 1 | Presenter | speaker | Andrew De Silva | University of Southern California | p:andrew-de-silva | ror:03taz7m60 | eshow-listing-2024 | ||
| 55581 | 55581 | 744 | 2024 | eshow:98C9FF33-FD04-89A7-331A-3A59B4DA5285 | 1 | Presenter | speaker | Alisa Sanchez | University of Southern California | p:alisa-sanchez | ror:03taz7m60 | eshow-listing-2024 |
Advanced export
JSON shape: default, array, newline-delimited
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);