musiccaps
1 row where aspect_list contains "passionate electric guitar melody" and aspect_list contains "soulful"
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 |
---|---|---|---|---|---|---|---|---|---|---|
6iZ49s7eH5g | The Rock song features a groovy piano melody followed by passionate electric guitar melody, church organ chord progression, strummed acoustic rhythm guitar chords, shimmering cymbals, punchy snare and mellow kick hits. It sounds emotional, soulful and passionate. | ["rock", "groovy piano melody", "passionate electric guitar melody", "church organ chords progression", "strummed acoustic rhythm guitar chords progression", "shimmering cymbals", "punchy snare", "mellow kick", "emotional", "soulful", "passionate"] | ["Music", "Soul music"] | 4 | 300 | 310 | 0 | 0 | ["/m/04rlf", "/m/0gywn"] |
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 );