musiccaps
1 row where aspect_list contains "compilation" and aspect_list contains "wide electric guitar melodies"
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 |
---|---|---|---|---|---|---|---|---|---|---|
-T4GeTHKtJQ | The low quality recording features a compilation of rock songs and it consists of punchy kicks, wide electric guitar melodies, distorted bass guitar, energetic crash cymbals, shimmering hi hats and harmonizing male vocals singing over it. It sounds energetic. | ["low quality", "rock", "punchy kick", "punchy kick", "wide electric guitar melodies", "distorted bass guitar", "energetic crash cymbal", "shimmering hi hats", "harmonizing male vocals", "energetic", "compilation"] | ["Funk", "Music"] | 4 | 30 | 40 | 0 | 0 | ["/m/02x8m", "/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 );