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

6 rows where institution_id = "ror:01szgyb91" and year = 2024

✎ View and edit SQL

This data as json, CSV (advanced)

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

year 1

  • 2024 · 6 ✖

role 1

  • Speaker(s) 6
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
56837 56837 26 2024 eshow:98F7FF1C-F7BE-F153-78E5-2EF447712379 1 Speaker(s) speaker Jessie Moore Elon University   p:jessie-moore ror:01szgyb91 eshow-listing-2024 67
56847 56847 36 2024 eshow:98F7FF1C-F7BE-F153-78E5-2EF447712379 11 Speaker(s) speaker Lauren Jablon Elon University A Rhetorical Analysis of Concussion Awareness: A Cultural Comparison in Popular Media in the US and Argentina p:lauren-jablon ror:01szgyb91 eshow-listing-2024 67
56964 56964 1864 2024 eshow:98FEECAF-0B48-25DC-4267-8FA12DABF295 1 Speaker(s) speaker Jessie Moore Elon University   p:jessie-moore ror:01szgyb91 eshow-listing-2024 105
56965 56965 1865 2024 eshow:98FEECAF-0B48-25DC-4267-8FA12DABF295 2 Speaker(s) speaker Julia Bleakney Elon University   p:julia-bleakney ror:01szgyb91 eshow-listing-2024 105
56966 56966 1866 2024 eshow:98FEECAF-0B48-25DC-4267-8FA12DABF295 3 Speaker(s) speaker Paula Rosinski Elon University   p:paula-rosinski ror:01szgyb91 eshow-listing-2024 105
57212 57212 1256 2024 eshow:F2AA71B7-F5E4-8453-604A-994AEFFF3A44 2 Speaker(s) speaker Jessie Moore Elon University   p:jessie-moore ror:01szgyb91 eshow-listing-2024  

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