appearances
Data license: CC BY 4.0 (data), MIT (code) · Data source: Source code, methods and known limits
4 rows where institution_id = "ror:04w7skc03", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 55290 | 55290 | 594 | 2024 | eshow:98C0CF3C-E16A-DF1D-2E09-B5B806BB44C1 | 1 | Presenter | speaker | Douglas Hesse | University of Denver | p:doug-hesse | ror:04w7skc03 | eshow-listing-2024 | ||
| 55336 | 55336 | 712 | 2024 | eshow:98C1D76A-0897-A7BF-75FE-CB8521ECB395 | 1 | Presenter | speaker | Veronica House | University of Denver | p:veronica-house | ror:04w7skc03 | eshow-listing-2024 | ||
| 55593 | 55593 | 1406 | 2024 | eshow:98CA819B-BB2B-B8B5-C8FC-BCF8A213A570 | 1 | Presenter | speaker | Angela Sowa | University of Denver | p:angela-sowa | ror:04w7skc03 | eshow-listing-2024 | ||
| 56288 | 56288 | 1468 | 2024 | eshow:98E3AD9A-AE0D-2F06-2D0D-F39487E8B2A8 | 1 | Presenter | speaker | Lauren Picard | University of Denver | p:lauren-picard | ror:04w7skc03 | 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);