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

14 rows where institution_id = "ror:00hj8s172", role = "Speaker(s)" and year = 2025

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: session_id, ord, name_as_printed, affiliation_as_printed, person_id

year 1

  • 2025 · 14 ✖

role 1

  • Speaker(s) · 14 ✖
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
57507 57507 2348 2025 eshow:67156989-D776-AD25-B98B-1D7235004CEB 3 Speaker(s) speaker Kirkwood Adams Columbia University   p:kirkwood-adams ror:00hj8s172 eshow-listing-2025 109
57508 57508 2349 2025 eshow:67156989-D776-AD25-B98B-1D7235004CEB 4 Speaker(s) speaker Maria Baker Pratt Institute and Columbia University   p:maria-baker ror:00hj8s172 eshow-listing-2025 109
57642 57642 4062 2025 eshow:6717E1C1-EF2F-BC8B-B20C-27AEAC3AADA0 1 Speaker(s) speaker Valeria Tsygankova Columbia University   p:valeria-tsygankova ror:00hj8s172 eshow-listing-2025 309
57844 57844 4928 2025 eshow:671AD384-CA92-7D42-D0B4-50B037D5E305 1 Speaker(s) speaker Erag Ramizi Columbia University   p:erag-ramizi ror:00hj8s172 eshow-listing-2025 80
57881 57881 4859 2025 eshow:671B740D-B8BE-0262-ED53-D8A0A743040D 1 Speaker(s) speaker Chelsey Barber Teachers College Columbia University International Services - New York, NY   p:chelsey-barber ror:00hj8s172 eshow-listing-2025 120
58066 58066 4094 2025 eshow:671EF00D-D439-23F6-898B-BD82B14E6F71 1 Speaker(s) speaker Barbara Kruchin Columbia University   p:barbara-kruchin ror:00hj8s172 eshow-listing-2025 84
58067 58067 4095 2025 eshow:671EF00D-D439-23F6-898B-BD82B14E6F71 2 Speaker(s) speaker Brittany Ober Columbia University   p:brittany-ober ror:00hj8s172 eshow-listing-2025 84
58722 58722 3341 2025 eshow:672A8741-03B1-0C6C-5C52-C8CED20A34E7 1 Speaker(s) speaker Kristie Schlauraff Columbia University   p:kristie-schlauraff ror:00hj8s172 eshow-listing-2025 94
58723 58723 3342 2025 eshow:672A8741-03B1-0C6C-5C52-C8CED20A34E7 2 Speaker(s) speaker Kristie Schlauraff Columbia University   p:kristie-schlauraff ror:00hj8s172 eshow-listing-2025 94
58724 58724 3343 2025 eshow:672A8741-03B1-0C6C-5C52-C8CED20A34E7 3 Speaker(s) speaker Celine Aenlle-Rocha Columbia University   p:celine-aenlle-rocha ror:00hj8s172 eshow-listing-2025 94
58767 58767 4041 2025 eshow:672D4DF3-B226-47E8-C713-E8A3E2480169 1 Speaker(s) speaker Chelsey Barber Teachers College Columbia University International Services - New York, NY   p:chelsey-barber ror:00hj8s172 eshow-listing-2025 83
58916 58916 3639 2025 eshow:673092F1-DC00-CAC9-F702-9C1D7583AADF 1 Speaker(s) speaker Aaron Ritzenberg Columbia University   p:aaron-ritzenberg ror:00hj8s172 eshow-listing-2025 161
59531 59531 2428 2025 eshow:673C6EC0-A952-C116-C783-68117B1F01DD 1 Speaker(s) speaker Elizabeth Walters Columbia University   p:elizabeth-walters ror:00hj8s172 eshow-listing-2025 338
59718 59718 4886 2025 eshow:673F34E1-C1DE-DF9F-604D-7ACED0AE451F 1 Speaker(s) speaker Catherine Kirch Columbia University   p:catherine-kirch ror:00hj8s172 eshow-listing-2025 126

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 2240.517ms · Data license: CC BY 4.0 (data), MIT (code) · Data source: Source code, methods and known limits