cccc: appearances: 17 rows where institution_id = "ror:03enmdz06" 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

17 rows where institution_id = "ror:03enmdz06" 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
5782	5782	12698	2004	pdf:2004:L.15	1	Chair	chair	Iris Ruiz	California State University, Fresno	p:iris-ruiz	ror:03enmdz06	pdf-2004-2004__2004completeprogram.pdf	235
14470	14470	21363	2007	pdf:2007:P.12	1	Chair	chair	Nathan Franklin	California State University, Fresno	p:nathan-franklin	ror:03enmdz06	pdf-2007-2007__2007completeprogram.pdf	294
15501	15501	22505	2008	pdf:2008:D.30	1	Chair	chair	Virginia Crisco	California State University, Fresno	p:virginia-crisco	ror:03enmdz06	pdf-2008-2008__2008completeprogram.pdf	131
16279	16279	23296	2008	pdf:2008:I.13	1	Chair	chair	Asao B. Inoue	California State University, Fresno	p:asao-inoue	ror:03enmdz06	pdf-2008-2008__2008completeprogram.pdf	199
17707	17707	24640	2009	pdf:2009:B.19	1	Chair	chair	Asao Inoue	California State University, Fresno	p:asao-inoue	ror:03enmdz06	pdf-2009-2009__2009completeprogram.pdf	95
19841	19841	26730	2009	pdf:2009:N.29	1	Chair	chair	Virginia Crisco	California State University, Fresno	p:virginia-crisco	ror:03enmdz06	pdf-2009-2009__2009completeprogram.pdf	293
20489	20489	27400	2010	pdf:2010:B.23	1	Chair	chair	Asao Inoue	California State University, Fresno	p:asao-inoue	ror:03enmdz06	pdf-2010-2010__cccc2010-program.pdf	98
23295	23295	30189	2011	pdf:2011:B.27	1	Chair	chair	Jennifer Mayer	California State University, Fresno	p:jennifer-mayer	ror:03enmdz06	pdf-2011-2011__program__entire-prog.pdf	100
23913	23913	30836	2011	pdf:2011:F.19	1	Chair	chair	Asao Inoue	California State University, Fresno	p:asao-inoue	ror:03enmdz06	pdf-2011-2011__program__entire-prog.pdf	161
24552	24552	31437	2011	pdf:2011:I.39	1	Chair	chair	Asao B. Inoue	California State University, Fresno	p:asao-inoue	ror:03enmdz06	pdf-2011-2011__program__entire-prog.pdf	216
26586	26586	33552	2012	pdf:2012:G.10	1	Chair	chair	Asao B. Inoue	California State University, Fresno	p:asao-inoue	ror:03enmdz06	pdf-2012-2012__program__program2012.pdf	183
28632	28632	35501	2013	pdf:2013:D.26	1	Chair	chair	Asao Inoue	California State University, Fresno	p:asao-inoue	ror:03enmdz06	pdf-2013-2013__program__program2013.pdf	130
30795	30795	37561	2014	pdf:2014:B.9	1	Chair	chair	Asao Inoue	California State University, Fresno	p:asao-inoue	ror:03enmdz06	pdf-2014-2014__program__program.pdf	109
32157	32157	39066	2014	pdf:2014:J.21	1	Chair	chair	Asao Inoue	California State University, Fresno	p:asao-inoue	ror:03enmdz06	pdf-2014-2014__program__program.pdf	241
36808	36808	43656	2016	pdf:2016:D.5	1	Chair	chair	Emily Beals	California State University, Fresno	p:emily-beals	ror:03enmdz06	pdf-2016-2016__program__2016program.pdf	117
38955	38955	45856	2017	pdf:2017:A.7	1	Chair	chair	Ruben Casas	California State University, Fresno	p:ruben-casas	ror:03enmdz06	pdf-2017-2017__program__2017program.pdf	71
39851	39851	46836	2017	pdf:2017:E.15	1	Chair	chair	Tara Williams	California State University, Fresno	p:tara-williams	ror:03enmdz06	pdf-2017-2017__program__2017program.pdf	162

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