musiccaps
2 rows where audioset_names contains "Punk rock", audioset_names contains "Rock and roll" and is_balanced_subset = 1
This data as json, CSV (advanced)
Suggested facets: audioset_ids (array)
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
nP05Sf4Fgac | A blues rock power trio with electric bass and overdriven electric guitar playing a riff together and the drummer playing a backdoor shuffle. It is instrumental with a swung rhythm. | ["blues rock", "overdriven electric guitar", "guitar riff", "bass riff", "backdoor shuffle", "electric bass", "instrumental", "power trio", "swung rhythm"] | ["Blues", "Music", "Punk rock", "Rock music", "Rock and roll"] | 8 | 30 | 40 | 1 | 1 | ["/m/0155w", "/m/04rlf", "/m/05r6t", "/m/06by7", "/m/07sbbz2"] | |
zWJC_qr2610 | The low quality recording features a live performance of a rock song and it features passionate male vocals, alongside harmonizing male vocals, singing over arpeggiated electric guitar melody, boomy bass guitar, punchy kick and snare hits and shimmering open hats. It sounds noisy and messy, as the frequencies are clashing with each other, but it is still groovy and emotional regardless. | ["low quality", "rock", "live performance", "arpeggiated electric guitar melody", "passionate male vocal", "harmonizing male vocals", "boomy bass guitar", "shimmering open hats", "punchy kick", "punchy snare", "messy", "noisy", "groovy", "emotional"] | ["Bass guitar", "Music", "Punk rock", "Rock and roll"] | 4 | 30 | 40 | 1 | 1 | ["/m/018vs", "/m/04rlf", "/m/05r6t", "/m/07sbbz2"] |
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 );