Console

Every edition, session, speaker and sponsor as SQL, queried by DuckDB (opens in a new tab) running in your browser.

Tables

venues4
Places an edition, or one of its days, is held.
- idvarchar!
- namevarchar!
- street_addressvarchar
- localityvarchar
- regionvarchar
- postal_codevarchar
- countryvarchar
rooms7
Rooms within a venue that sessions are held in.
- idvarchar!
- venue_idvarchar!
- namevarchar!
organizations41
Companies and groups, such as sponsors.
- idvarchar!
- namevarchar!
- urlvarchar
- summaryvarchar
sponsor_tiers10
Sponsorship levels; the first tier gets the largest logos.
- idvarchar!
- namevarchar!
- positioninteger!
topics0
Subjects a session can cover.
- idvarchar!
- titlevarchar!
- slugvarchar!
speakers132
People who speak at or host sessions.
- idvarchar!
- namevarchar!
- slugvarchar!
- pronounsvarchar
- job_titlevarchar
- companyvarchar
- biovarchar
speaker_links70
Links on a speaker's page, such as their website or social profiles.
- speaker_idvarchar!
- positioninteger!
- urlvarchar!
- labelvarchar
editions10
One conference per year.
- idvarchar!
- yearinteger!
- namevarchar!
- summaryvarchar
- statusenum!
- starts_ondate
- ends_ondate
- venue_idvarchar
- programme_statusenum!
- cfp_statusenum!
- cfp_opens_attimestamptz
- cfp_closes_attimestamptz
- ticket_statusenum!
- tickets_on_sale_attimestamptz
edition_days13
The days of an edition. A session belongs to the day matching its local start date.
- edition_idvarchar!
- datedate!
- labelvarchar!
- venue_idvarchar
sponsorships88
An organization sponsoring an edition at a tier.
- edition_idvarchar!
- positioninteger!
- organization_idvarchar!
- sponsor_tier_idvarchar!
- summaryvarchar
- urlvarchar
tracks2
Parallel streams of sessions within an edition.
- idvarchar!
- edition_idvarchar!
- namevarchar!
- summaryvarchar
sessions213
Everything on an edition's schedule: talks, workshops and panels (kind 'session') and breaks or registration (kind 'service').
- idvarchar!
- edition_idvarchar!
- slugvarchar!
- titlevarchar!
- subtitlevarchar
- kindenum!
- formatenum
- levelenum
- abstractvarchar
- starts_attimestamptz
- duration_minutesinteger
- room_idvarchar
- track_idvarchar
- statusenum!
- slides_urlvarchar
- recording_urlvarchar
- recording_published_ondate
session_speakers184
Who presents each session.
- session_idvarchar!
- speaker_idvarchar!
- positioninteger!
session_hosts23
Who hosts each session, such as an MC or panel moderator.
- session_idvarchar!
- speaker_idvarchar!
- positioninteger!
session_topics0
The topics each session covers.
- session_idvarchar!
- topic_idvarchar!