Data license: CC-BY-4.0

original_uuid

Original UUID of the ASR utterance. This can be null if the utterance was manually added by an annotator.

trial

Trial ID

participant

Participant ID

asr_text

ASR transcription

corrected_text

Manually corrected transcription, if the ASR transcription is incorrect.

start_timestamp

Start timestamp

stop_timestamp

Stop timestamp

dialog_acts

Dialog acts identified.

adjacency_pairs

Adjacency pair annotations.

sentiment

Sentiment label. Can be null if (i) the trial wasn't annotated for sent/emo or (ii) if the audio of the utterance is not clear enough to assign a label.

emotion

Emotion label. Can be null if (i) the trial wasn't annotated for sent/emo or (ii) if the audio of the utterance is not clear enough to assign a label.

background_noise

Annotations describing background noise during an utterance, if any.

42 rows where participant = "E000687"

- remove filter - rowid original_uuid trial participant asr_text corrected_text start_timestamp end_timestamp dialog_acts adjacency_pairs sentiment emotion clc_label checkback_score background_noise

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains array does not contain date is null is not null is blank is not blank

- column - rowid original_uuid trial participant asr_text corrected_text start_timestamp end_timestamp dialog_acts adjacency_pairs sentiment emotion clc_label checkback_score background_noise

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains array does not contain date is null is not null is blank is not blank

Sort... Sort by rowid Sort by original_uuid Sort by trial Sort by participant Sort by asr_text Sort by corrected_text Sort by start_timestamp Sort by end_timestamp Sort by dialog_acts Sort by adjacency_pairs Sort by sentiment Sort by emotion Sort by clc_label Sort by checkback_score Sort by background_noise

descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: trial, asr_text, corrected_text, dialog_acts, sentiment, emotion, clc_label, checkback_score

CREATE TABLE utterance (
                original_uuid TEXT UNIQUE,
                trial TEXT NOT NULL,
                participant TEXT NOT NULL,
                asr_text TEXT,
                corrected_text TEXT,
                start_timestamp TEXT NOT NULL,
                end_timestamp TEXT NOT NULL,
                dialog_acts TEXT,
                adjacency_pairs TEXT,
                sentiment TEXT,
                emotion TEXT,
                clc_label TEXT,
                checkback_score INTEGER,
                background_noise TEXT,
                FOREIGN KEY(participant) REFERENCES participant(id)
                FOREIGN KEY(trial) REFERENCES trial(id)
                FOREIGN KEY(emotion) REFERENCES emotion(id)
                FOREIGN KEY(sentiment) REFERENCES sentiment(id)
                FOREIGN KEY(checkback_score) REFERENCES checkback_score(value)
            );