musiccaps
2 rows where audioset_ids contains "/m/015lz1", audioset_ids contains "/m/016cjb" and audioset_ids contains "/m/0y4f8"
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 |
---|---|---|---|---|---|---|---|---|---|---|
9ziKfjHWqZ0 | The low quality recording features a gospel song that consists of harmonizing mixed choir singing. The recording is noisy, in mono and it sounds passionate, joyful, soulful and reverberant. | ["low quality", "gospel", "harmonizing mixed choir", "reverberant", "noisy", "mono", "joyful", "passionate", "soulful"] | ["Singing", "Gospel music", "Christian music", "Choir", "Vocal music", "A capella"] | 4 | 40 | 50 | 0 | 0 | ["/m/015lz1", "/m/016cjb", "/m/02mscn", "/m/0l14jd", "/m/0y4f8", "/m/0z9c"] | |
_78P-0zWJtg | The low quality recording features a live performance of fruity male vocal singing over funky piano melody and beat played on playback that consists of punchy snare and kick hits, shimmering hi hats and smooth bass. The crowd is also singing along, harmonizing with the lead vocal. It sounds emotional and groovy, even though the recording is noisy. | ["low quality", "folk", "fruity male vocal", "funky piano melody", "playback beat", "shimmering hi hats", "punchy snare", "punchy kick", "smooth bass", "noisy", "live performance", "harmonizing crowd vocals", "emotional", "groovy"] | ["Singing", "Gospel music", "Music", "Vocal music"] | 4 | 420 | 430 | 1 | 1 | ["/m/015lz1", "/m/016cjb", "/m/04rlf", "/m/0y4f8"] |
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 );