home / cccc

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

5 rows where institution_id = "ror:03q1dcf42"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: session_id, ord, role_group, name_as_printed, affiliation_as_printed, paper_title, person_id, source_document_id, page

year 3

  • 2016 3
  • 2006 1
  • 2009 1

role 2

  • Speakers 4
  • Chair 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
11870 11870 17267 2006 pdf:2006:TSIG.9 3 Speakers speaker Janene Lewis University of Mary Hardin-Baylor, Belton, TX Composition Teaching and Christian Tradition p:janene-lewis ror:03q1dcf42 pdf-2006-2006__2006programthursday.pdf 93
17486 17486 24509 2009 pdf:2009:A.28 4 Speakers speaker Janene Lewis University of Mary Hardin-Baylor, Belton, TX What Makes You so Strong?”: Using the African American Sermonic Tradition to Make Waves in Freshman Composition p:janene-lewis ror:03q1dcf42 pdf-2009-2009__2009completeprogram.pdf 85
37814 37814 44858 2016 pdf:2016:J.17 4 Speakers speaker Frances Crawford University of Mary Hardin-Baylor Taking Your QEP-Sweet Time: For Every Action... p:frances-crawford ror:03q1dcf42 pdf-2016-2016__program__2016program.pdf 234
37815 37815 44859 2016 pdf:2016:J.17 5 Speakers speaker Toby Coley University of Mary Hardin-Baylor Taking Your QEP-Sweet Time: For Every Action... p:toby-coley ror:03q1dcf42 pdf-2016-2016__program__2016program.pdf 234
38365 38365 45346 2016 pdf:2016:M.9 1 Chair chair Toby Coley University of Mary Hardin-Baylor   p:toby-coley ror:03q1dcf42 pdf-2016-2016__program__2016program.pdf 283

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);
Powered by Datasette · Queries took 13.168ms · Data license: CC BY 4.0 (data), MIT (code) · Data source: Source code, methods and known limits