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

18 rows where institution_id = "ror:047s2c258" and year = 2023

✎ View and edit SQL

This data as json, CSV (advanced)

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

year 1

  • 2023 · 18 ✖

role 1

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
52877 52877 59780 2023 pdf:2023:A.18 3 Speakers speaker Jessica Enoch University of Maryland Suffrage Memory and Voting Rights Hope p:jessica-enoch ror:047s2c258 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 71
52992 52992 59624 2023 pdf:2023:AW.1 3 Speakers speaker Lyra Hilliard University of Maryland   p:lyra-hilliard ror:047s2c258 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 43
53131 53131 59985 2023 pdf:2023:B.35 1 Speakers speaker Elizabeth Catchmark University of Maryland   p:elizabeth-catchmark ror:047s2c258 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 97
53132 53132 59986 2023 pdf:2023:B.35 2 Speakers speaker Erin Green University of Maryland   p:erin-green ror:047s2c258 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 97
53133 53133 59987 2023 pdf:2023:B.35 3 Speakers speaker Alexis Walston University of Maryland   p:alexis-walston ror:047s2c258 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 97
53150 53150 59875 2023 pdf:2023:B.5 3 Speakers speaker Leigh Ryan University of Maryland   p:leigh-ryan ror:047s2c258 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 84
53343 53343 60209 2023 pdf:2023:D.18 1 Speakers speaker Catherine Bayly University of Maryland College Park   p:catherine-bayly ror:047s2c258 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 126
53344 53344 60210 2023 pdf:2023:D.18 2 Speakers speaker Melvette Davis University of Maryland   p:melvette-davis ror:047s2c258 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 126
53345 53345 60211 2023 pdf:2023:D.18 3 Speakers speaker Jessica Enoch University of Maryland   p:jessica-enoch ror:047s2c258 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 126
53346 53346 60212 2023 pdf:2023:D.18 4 Speakers speaker Britt Starr University of Maryland   p:britt-starr ror:047s2c258 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 126
53347 53347 60213 2023 pdf:2023:D.18 5 Speakers speaker Alexis Walston University of Maryland   p:alexis-walston ror:047s2c258 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 126
53442 53442 60272 2023 pdf:2023:E.1 3 Speakers speaker Elizabeth McClure University of Maryland-College Park   p:elizabeth-mcclure ror:047s2c258 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 135
53465 53465 60321 2023 pdf:2023:E.17 3 Speakers speaker Shirley Logan University of Maryland   p:shirley-logan ror:047s2c258 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 140
53948 53948 60785 2023 pdf:2023:H.33 2 Speakers speaker Lyra Hilliard University of Maryland   p:lyra-hilliard ror:047s2c258 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 206
54067 54067 60895 2023 pdf:2023:I.32 2 Speakers speaker Marina Ellis University of Maryland, College Park   p:marina-ellis ror:047s2c258 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 223
54073 54073 60901 2023 pdf:2023:I.32 8 Speakers speaker James Wright University of Maryland   p:james-wright ror:047s2c258 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 223
54093 54093 60921 2023 pdf:2023:I.39 3 Speakers speaker Cecilia Shelton University of Maryland   p:cecilia-shelton ror:047s2c258 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 226
54711 54711 61619 2023 pdf:2023:OD.48 3 Speakers speaker James Wright University of Maryland   p:james-wright ror:047s2c258 pdf-2023-2023__01__2023-CCCC-Conv-revised-program2.pdf 334

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);