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

12 rows where role = "Chairs" and year = 2015

✎ View and edit SQL

This data as json, CSV (advanced)

year 1

  • 2015 · 12 ✖

role 1

  • Chairs · 12 ✖
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
34411 34411 42439 2015 pdf:2015:FSIG.15 1 Chairs chair Pamela Childers The McCallie School, Palisade, CO   p:pamela-childers   pdf-2015-2015__program__fri.pdf 127
34412 34412 42440 2015 pdf:2015:FSIG.15 2 Chairs chair Anne Ellen Geller St. John’s University, New York, NY   p:anne-ellen-geller ror:00bgtad15 pdf-2015-2015__program__fri.pdf 127
34413 34413 42441 2015 pdf:2015:FSIG.15 3 Chairs chair Jeffrey Galin Florida Atlantic University, Boca Raton   p:jeffrey-galin ipeds:133669 pdf-2015-2015__program__fri.pdf 127
34414 34414 42442 2015 pdf:2015:FSIG.15 4 Chairs chair Daniel Melzer California State University, Sacramento   p:dan-melzer ror:03e26wv14 pdf-2015-2015__program__fri.pdf 127
34415 34415 42443 2015 pdf:2015:FSIG.15 5 Chairs chair Michelle Cox Dartmouth College, Hanover, NH   p:michelle-cox ror:049s0rh22 pdf-2015-2015__program__fri.pdf 127
34416 34416 42444 2015 pdf:2015:FSIG.15 6 Chairs chair Mary McMullen-Light Metropolitan Community College, Longview, MO   p:mary-mcmullen-light ror:00p11e287 pdf-2015-2015__program__fri.pdf 127
34417 34417 42445 2015 pdf:2015:FSIG.15 7 Chairs chair David Russell Iowa State University, Ames   p:david-russell ror:04rswrd78 pdf-2015-2015__program__fri.pdf 127
34418 34418 42446 2015 pdf:2015:FSIG.15 8 Chairs chair Dilek Tokay Sabanci University, Istanbul, Turkey   p:dilek-tokay ror:049asqa32 pdf-2015-2015__program__fri.pdf 127
34419 34419 42447 2015 pdf:2015:FSIG.15 9 Chairs chair Terry Zawacki George Mason University, Fairfax, VA   p:terry-zawacki ror:02jqj7156 pdf-2015-2015__program__fri.pdf 127
34420 34420 42448 2015 pdf:2015:FSIG.15 10 Chairs chair Martha Townsend University of Missouri, Columbia   p:martha-townsend ror:02ymw8z06 pdf-2015-2015__program__fri.pdf 127
34421 34421 42449 2015 pdf:2015:FSIG.15 11 Chairs chair Vicki Tolar Burton Oregon State University, Corvallis   p:vicki-tolar-burton ror:00ysfqy60 pdf-2015-2015__program__fri.pdf 127
34422 34422 42450 2015 pdf:2015:FSIG.15 12 Chairs chair Chris Thaiss University of California, Davis   p:chris-thaiss ror:05rrcem69 pdf-2015-2015__program__fri.pdf 127

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