musiccaps
3 rows where aspect_list contains "keys chords" and author_id = 4
This data as json, CSV (advanced)
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
05JAmKFVy44 | The low quality recording features a kids song played through some kind of toy, and it consists of low male vocal singing over some key chords. It sounds distorted and crushed. The recording is noisy and in mono, as it was probably recorded with a poor quality microphone. | ["low quality", "kids song", "distorted", "crushed", "noisy", "mono", "keys chords", "low male vocal"] | ["Music", "Tick-tock"] | 4 | 20 | 30 | 0 | 1 | ["/m/04rlf", "/m/07qjznl"] | |
6807299U5eg | The low quality recording features a traditional song that consists of a passionate female vocal singing over breathy flute melody, wooden percussion, keys chords and acoustic guitar chords. It sounds soulful, passionate and the recording is in mono and noisy. | ["low quality", "noisy", "mono", "breathy flute melody", "passionate female vocal", "wooden percussions", "acoustic guitar chords", "keys chords", "soulful", "traditional", "passionate"] | ["Singing", "Carnatic music", "Music of Asia", "Music"] | 4 | 490 | 500 | 0 | 0 | ["/m/015lz1", "/m/015vgc", "/m/028sqc", "/m/04rlf"] | |
tGic59TlrVg | The Country song features a fruity male vocal singing over percussive acoustic rhythm guitar, simple bass and keys chords. It sounds emotional, passionate and heartfelt - like something you would hear in the old pubs and bars. | ["country", "percussive acoustic rhythm guitar", "keys chords", "fruity male vocal", "emotional", "passionate", "heartfelt", "simple bass"] | ["Christmas music", "Music"] | 4 | 30 | 40 | 1 | 1 | ["/m/0140xf", "/m/04rlf"] |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [musiccaps] ( [ytid] TEXT PRIMARY KEY, [url] TEXT, [caption] TEXT, [aspect_list] TEXT, [audioset_names] TEXT, [author_id] TEXT, [start_s] TEXT, [end_s] TEXT, [is_balanced_subset] INTEGER, [is_audioset_eval] INTEGER, [audioset_ids] TEXT );