musiccaps
3 rows where aspect_list contains "live performance" and audioset_ids = "["/m/04rlf", "/t/dd00003"]"
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 |
---|---|---|---|---|---|---|---|---|---|---|
0Olm321vgk8 | The Low Quality recording features r&b/soul songs sung by passionate male vocalists over fat bass guitar, punchy kick and snare hits and arpeggiated electric guitar melody. There are also some chattering voices in the background, it sounds like it is a live performance. | ["low quality", "r&b/soul", "passionate echoing male vocal", "punchy kick", "punchy snare", "electric guitar arpeggiated melody", "fat bass guitar", "people chattering", "reverberant", "live performance"] | ["Music", "/t/dd00003"] | 4 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/t/dd00003"] | |
73YTz8RC2Fo | The low quality recording features a passionate male vocal singing over playback instrumental that consists of straight piano chord progression. It is noisy and reverberant, as the singer is singing in a larger room. It sounds emotional, passionate and powerful. | ["low quality", "passionate male vocal", "playback instrumental", "straight piano chords", "reverberant", "loud", "noisy", "live performance", "passionate", "powerful", "emotional"] | ["Music", "/t/dd00003"] | 4 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/t/dd00003"] | |
l1coM570kVw | The low quality recording features a live performance of a soul song and it consists of passionate male vocal singing over playback instrumentals. The instrumental consists of a shimmering tambourine layered with punchy snare hits, soft kick hits, some toms rolls, groovy bass, electric guitar melody and harmonizing male vocals. It sounds emotional, soulful, hopeful and joyful. | ["low quality", "live performance", "noisy", "mono", "passionate male vocal", "soul", "playback instrumental", "shimmering tambourine", "punchy snare", "groovy bass", "electric guitar melody", "soft kick hits", "toms roll", "harmonizing male vocals", "emotional", "hopeful", "joyful", "soulful"] | ["Music", "/t/dd00003"] | 4 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/t/dd00003"] |
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 );