appearances
Data license: CC BY 4.0 (data), MIT (code) · Data source: Source code, methods and known limits
6 rows where institution_id = "ror:02tvcev59" and role = "Speaker(s)"
This data as json, CSV (advanced)
Suggested facets: session_id, ord, name_as_printed, affiliation_as_printed, person_id, source_document_id, page
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 55283 | 55283 | 288 | 2024 | eshow:98C0BE52-CCD8-4104-64CE-6CC5A3EC0D73 | 1 | Speaker(s) | speaker | Joseph Salvatore | The New School | p:joseph-salvatore | ror:02tvcev59 | eshow-listing-2024 | 85 | |
| 55432 | 55432 | 543 | 2024 | eshow:98C605EF-C121-640B-097A-F1288C80C49B | 1 | Speaker(s) | speaker | Joseph Salvatore | The New School | p:joseph-salvatore | ror:02tvcev59 | eshow-listing-2024 | 207 | |
| 57540 | 57540 | 4926 | 2025 | eshow:67160D68-E6E6-4809-3494-CDB72169D0C2 | 2 | Speaker(s) | speaker | Olivia Cadwell | The New School for Social Research | p:olivia-cadwell | ror:02tvcev59 | eshow-listing-2025 | 196 | |
| 58940 | 58940 | 4191 | 2025 | eshow:6730F49E-DBB8-DDA9-85AE-7A44FD1266F7 | 5 | Speaker(s) | speaker | Joseph Salvatore | The New School | p:joseph-salvatore | ror:02tvcev59 | eshow-listing-2025 | 335 | |
| 59207 | 59207 | 3811 | 2025 | eshow:67354B05-B11C-FE1D-FB3A-806F98851A13 | 1 | Speaker(s) | speaker | Joseph Salvatore | The New School | p:joseph-salvatore | ror:02tvcev59 | eshow-listing-2025 | 269 | |
| 59208 | 59208 | 3812 | 2025 | eshow:67354B05-B11C-FE1D-FB3A-806F98851A13 | 2 | Speaker(s) | speaker | Joseph Salvatore | The New School | p:joseph-salvatore | ror:02tvcev59 | eshow-listing-2025 | 269 |
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);