home

cccc

Data license: CC BY 4.0 (data), MIT (code) · Data source: Source code, methods and known limits

Custom SQL query

Queries

  • A word or phrase in titles, by year
  • Every listing for a name
  • An institution's listings by year
  • Most-listed institutions in a year

Tables

affiliation_matches

affiliation_as_printed, institution_id, method, score

8,309 rows

appearances

id, year, session_id, ord, role, role_group, name_as_printed, affiliation_as_printed, paper_title, person_id, institution_id, source_document_id, page

63,791 rows

conventions

year, city, venue, theme, chair, status, dates, site

79 rows

groups

id, name, kind, first_year, last_year, years, sessions

379 rows

institutions

id, name, ror_id, wikidata, ipeds_unitid, sector, iclevel, two_year, carnegie_basic, country, kind, control, state, lat, lon, hbcu, tribal

1,957 rows

people

id, display_name, method

19,207 rows

sessions

id, year, source_document_id, parent_id, code, title, session_type, audience_level, tracks, area, area_group, topic_tags, group_id, dates, time_label, room, cancelled

16,166 rows

source_documents

id, year, kind, url, rights

88 rows

year_summary

year, city, status, sessions, listed_people, people_with_affiliation, people_matched, people_us_ipeds, people_two_year, two_year_share

26 rows

... and 15 hidden tables

Download SQLite DB: cccc.db 29.0 MB

Powered by Datasette · Queries took 34.257ms · Data license: CC BY 4.0 (data), MIT (code) · Data source: Source code, methods and known limits