home / cccc

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

8 rows where institution_id = "ror:05dk0ce17" and year = 2025

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ord, name_as_printed, person_id

year 1

  • 2025 · 8 ✖

role 1

  • Speaker(s) 8
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
57332 57332 3503 2025 eshow:670FD8AD-FF9B-A8A6-2738-610C8F498B70 1 Speaker(s) speaker Elizabeth Forsythe Washington State University   p:elizabeth-forsythe ror:05dk0ce17 eshow-listing-2025 119
57598 57598 2952 2025 eshow:6716F283-D598-B73D-388F-7980F9401E04 2 Speaker(s) speaker Mike Edwards Washington State University   p:michael-edwards ror:05dk0ce17 eshow-listing-2025 168
57977 57977 2286 2025 eshow:671D34A4-08DA-DBF9-F8D0-1B1141FF05E4 3 Speaker(s) speaker Sara Brock Washington State University   p:sara-brock ror:05dk0ce17 eshow-listing-2025 333
58418 58418 4833 2025 eshow:6725F168-F5C4-1DBC-A83F-2AEB20A96683 1 Speaker(s) speaker Genoveva Vega Washington State University   p:genoveva-vega ror:05dk0ce17 eshow-listing-2025 198
58568 58568 4609 2025 eshow:67282854-AFF8-010D-4925-B00FF4567AAD 5 Speaker(s) speaker Kate Watts Washington State University   p:kate-watts ror:05dk0ce17 eshow-listing-2025 295
58734 58734 3637 2025 eshow:672B2F9E-9DF6-B5BD-B597-83C58D45CEC2 1 Speaker(s) speaker Geoffrey Clegg Washington State University   p:geoffrey-clegg ror:05dk0ce17 eshow-listing-2025 141
59110 59110 4621 2025 eshow:6733DE98-0CA0-0029-91DD-F4130A8478B9 3 Speaker(s) speaker Bibhushana Poudyal Washington State University   p:bibhushana-poudyal ror:05dk0ce17 eshow-listing-2025 39
59125 59125 3353 2025 eshow:673409E8-C7F7-2929-C6B9-0A8DB002095E 4 Speaker(s) speaker Mike Edwards Washington State University   p:michael-edwards ror:05dk0ce17 eshow-listing-2025 301

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);
Powered by Datasette · Queries took 27.338ms · Data license: CC BY 4.0 (data), MIT (code) · Data source: Source code, methods and known limits