Data license: CC-BY-4.0

194 rows where speaker = "E000607"

- remove filter - rowid original_uuid trial speaker addressee transcript start_timestamp end_timestamp split_index

= != 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 speaker addressee transcript start_timestamp end_timestamp split_index

= != 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 speaker Sort by addressee Sort by transcript Sort by start_timestamp Sort by end_timestamp Sort by split_index

descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: trial, addressee, split_index

Next page

CREATE TABLE entrainment (
                original_uuid TEXT,
                trial TEXT,
                speaker TEXT,
                addressee TEXT,
                transcript TEXT,
                start_timestamp TEXT NOT NULL,
                end_timestamp TEXT NOT NULL,
                split_index INTEGER,
                FOREIGN KEY(trial) REFERENCES trial(id)
                FOREIGN KEY(speaker) REFERENCES participant(id)
                FOREIGN KEY(original_uuid) REFERENCES utterance(original_uuid)
            );