musiccaps
1 row where aspect_list contains "boomy kick", aspect_list contains "exciting" and aspect_list contains "live performance"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Q8f6y2IcVg0 | The low quality recording features a live performance of a rock song that consists of echoing, energetic male vocals that are singing over wide electric guitar chord progression, energetic crash cymbals, punchy snare, boomy kick and groovy bass guitar. It sounds energetic and exciting. | ["low quality", "echoing energetic male vocal", "wide electric guitar chord progression", "energetic crash cymbals", "punchy snare", "boomy kick", "groovy bass guitar", "rock", "live performance", "energetic", "exciting"] | ["Music", "Roll", "Rock and roll"] | 4 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/07s8j8t", "/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 );