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

16 rows where institution_id = "ror:02w0trx84" and role = "Chair"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name_as_printed, affiliation_as_printed, person_id, source_document_id

year 10

role 1

  • Chair · 16 ✖
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
6343 6343 13229 2004 pdf:2004:O.8 1 Chair chair Michael Konsmo Montana State University, Bozeman   p:michael-konsmo ror:02w0trx84 pdf-2004-2004__2004completeprogram.pdf 288
17948 17948 24864 2009 pdf:2009:C.33 1 Chair chair Danell Jones Montana State University, Bozeman   p:danell-jones ror:02w0trx84 pdf-2009-2009__2009completeprogram.pdf 114
18267 18267 25198 2009 pdf:2009:E.26 1 Chair chair Doug Downs Montana State University, Bozeman   p:doug-downs ror:02w0trx84 pdf-2009-2009__2009completeprogram.pdf 142
22041 22041 28981 2010 pdf:2010:K.19 1 Chair chair Kirk Branch Montana State University, Bozeman   p:kirk-branch ror:02w0trx84 pdf-2010-2010__cccc2010-program.pdf 242
23993 23993 30906 2011 pdf:2011:F.36 1 Chair chair Doug Downs Montana State University, Bozeman   p:doug-downs ror:02w0trx84 pdf-2011-2011__program__entire-prog.pdf 166
26906 26906 33872 2012 pdf:2012:I.17 1 Chair chair Doug Downs Montana State University, Bozeman   p:doug-downs ror:02w0trx84 pdf-2012-2012__program__program2012.pdf 215
30897 30897 37821 2014 pdf:2014:C.28 1 Chair chair Doug Downs Montana State University, Bozeman   p:doug-downs ror:02w0trx84 pdf-2014-2014__program__program.pdf 129
31423 31423 38263 2014 pdf:2014:F.3 1 Chair chair Joy Barber City College Montana State University, Bozeman   p:joy-barber ror:02w0trx84 pdf-2014-2014__program__program.pdf 172
32803 32803 37163 2014 pdf:2014:MW.9 1 Chair chair Doug Downs Montana State University, Bozeman   p:doug-downs ror:02w0trx84 pdf-2014-2014__program__program.pdf 68
36988 36988 43829 2016 pdf:2016:E.4 1 Chair chair Jill Davis Montana State University   p:jill-davis ror:02w0trx84 pdf-2016-2016__program__2016program.pdf 133
37793 37793 44837 2016 pdf:2016:J.12 1 Chair chair Michelle Miley Montana State University   p:michelle-miley ror:02w0trx84 pdf-2016-2016__program__2016program.pdf 232
40286 40286 48473 2017 pdf:2017:FSIG.11 1 Chair chair Doug Downs Montana State University, Bozeman   p:doug-downs ror:02w0trx84 pdf-2017-2017__program__2017program.pdf 334
40984 40984 47964 2017 pdf:2017:I.49 1 Chair chair Doug Downs Montana State University, Bozeman   p:doug-downs ror:02w0trx84 pdf-2017-2017__program__2017program.pdf 275
43409 43409 50240 2018 pdf:2018:F.8 1 Chair chair Mark Schlenz Montana State University, Bozeman   p:mark-schlenz ror:02w0trx84 pdf-2018-2018__program__program.pdf 181
43808 43808 50783 2018 pdf:2018:I.22 1 Chair chair Doug Downs Montana State University, Bozeman   p:doug-downs ror:02w0trx84 pdf-2018-2018__program__program.pdf 241
47822 47822 54736 2020 pdf:2020:B.22 1 Chair chair Michelle Miley Montana State University, Bozeman   p:michelle-miley ror:02w0trx84 pdf-2020-2018__06__2020CCCCThurs.pdf 29

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