cccc: appearances: 16 rows where institution_id = "ror:05cdayb58" and role = "Chair"

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

16 rows where institution_id = "ror:05cdayb58" and role = "Chair"

Search:

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	rowid ▼	id	year	session_id	ord	role	role_group	name_as_printed	affiliation_as_printed	person_id	institution_id	source_document_id	page
17439	17439	24469	2009	pdf:2009:A.18	1	Chair	chair	Peter Adams	Community College Baltimore County, MD	p:peter-adams	ror:05cdayb58	pdf-2009-2009__2009completeprogram.pdf	82
19836	19836	26725	2009	pdf:2009:N.28	1	Chair	chair	Robert Miller	Community College of Baltimore County, MD	p:robert-miller	ror:05cdayb58	pdf-2009-2009__2009completeprogram.pdf	293
21293	21293	29072	2010	pdf:2010:FSIG.7	1	Chair	chair	Peter Adams	Community College Baltimore County, MD	p:peter-adams	ror:05cdayb58	pdf-2010-2010__cccc2010-program.pdf	260
26870	26870	33693	2012	pdf:2012:H.9	1	Chair	chair	Robert Miller	The Community College of Baltimore County, MD	p:robert-miller	ror:05cdayb58	pdf-2012-2012__program__program2012.pdf	198
27273	27273	34100	2012	pdf:2012:K.4	1	Chair	chair	Peter Adams	Community College of Baltimore County, MD	p:peter-adams	ror:05cdayb58	pdf-2012-2012__program__program2012.pdf	240
29035	29035	35877	2013	pdf:2013:G.1	1	Chair	chair	Linda De La Ysla	Community College of Baltimore County, MD	p:linda-de-la-ysla	ror:05cdayb58	pdf-2013-2013__program__program2013.pdf	169
29211	29211	36088	2013	pdf:2013:H.16	1	Chair	chair	Jamey Gallagher	Community College of Baltimore County, MD	p:jamey-gallagher	ror:05cdayb58	pdf-2013-2013__program__program2013.pdf	187
29507	29507	36381	2013	pdf:2013:J.16	1	Chair	chair	Robert Miller	The Community College of Baltimore County, MD	p:robert-miller	ror:05cdayb58	pdf-2013-2013__program__program2013.pdf	217
32013	32013	38804	2014	pdf:2014:I.3	1	Chair	chair	Jamey Gallagher	Community College of Baltimore County, MD	p:jamey-gallagher	ror:05cdayb58	pdf-2014-2014__program__program.pdf	219
33404	33404	40339	2015	pdf:2015:B.1	1	Chair	chair	Susan Gabriel	Community College of Baltimore County, MD	p:susan-gabriel	ror:05cdayb58	pdf-2015-2015__program__thurs.pdf	22
34252	34252	41210	2015	pdf:2015:F.2	1	Chair	chair	Peter Adams	Community College of Baltimore County, MD	p:peter-adams	ror:05cdayb58	pdf-2015-2015__program__fri.pdf	2
40136	40136	47193	2017	pdf:2017:F.28	1	Chair	chair	Peter Adams	Community College of Baltimore County, MD	p:peter-adams	ror:05cdayb58	pdf-2017-2017__program__2017program.pdf	200
41525	41525	48577	2017	pdf:2017:L.17	1	Chair	chair	Peter Adams	Community College of Baltimore County, MD	p:peter-adams	ror:05cdayb58	pdf-2017-2017__program__2017program.pdf	351
44899	44899	51875	2019	pdf:2019:A.32	1	Chair	chair	June Locco	Community College of Baltimore County, MD	p:june-locco	ror:05cdayb58	pdf-2019-2019__02__CCCC2019FullProgram.pdf	77
46595	46595	53534	2019	pdf:2019:J.39	1	Chair	chair	Kristen Messer	Community College of Baltimore County, MD	p:kristen-messer	ror:05cdayb58	pdf-2019-2019__02__CCCC2019FullProgram.pdf	253
47566	47566	54583	2020	pdf:2020:A.29	1	Chair	chair	Peter Adams	Community College of Baltimore County	p:peter-adams	ror:05cdayb58	pdf-2020-2018__06__2020CCCCThurs.pdf	13

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