appearances
Data license: CC BY 4.0 (data), MIT (code) · Data source: Source code, methods and known limits
4 rows where institution_id = "ror:00f54p054", role = "Presenter" and year = 2024
This data as json, CSV (advanced)
Suggested facets: session_id, ord, name_as_printed, person_id
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 56213 | 56213 | 1681 | 2024 | eshow:98E06EEF-91F7-F417-2EA1-EBC96572D27A | 1 | Presenter | speaker | Lisa Swan | Stanford University | p:lisa-swan | ror:00f54p054 | eshow-listing-2024 | ||
| 56214 | 56214 | 1682 | 2024 | eshow:98E06EEF-91F7-F417-2EA1-EBC96572D27A | 2 | Presenter | speaker | Tesla Schaeffer | Stanford University | p:tesla-schaeffer | ror:00f54p054 | eshow-listing-2024 | ||
| 56891 | 56891 | 693 | 2024 | eshow:98F97C75-03B8-81AF-087B-682B1B8A4B3E | 1 | Presenter | speaker | Kath Rothschild | Stanford University | p:kath-rothschild | ror:00f54p054 | eshow-listing-2024 | ||
| 56892 | 56892 | 694 | 2024 | eshow:98F97C75-03B8-81AF-087B-682B1B8A4B3E | 2 | Presenter | speaker | Kath Rothschild | Stanford University | p:kath-rothschild | ror:00f54p054 | 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);