musiccaps
1 row where aspect_list contains "electric guitar chords" and aspect_list contains "straight piano melody"
This data as json, CSV (advanced)
aspect_list (array) 13 ✖
- addictive 1
- electric guitar chords · 1 ✖
- groovy 1
- low quality 1
- passionate 1
- pop 1
- punchy snare 1
- reverberant passionate female vocal 1
- smooth bass guitar 1
- straight piano melody · 1 ✖
- wide brass melody 1
- wide harmonizing male vocals 1
- wide shimmering hi hats 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
46WpyRUqwXU | The low quality recording features a pop song that contains a passionate female vocal, alongside wide harmonizing male vocals, singing over wide brass melody, electric guitar chords, straight piano melody, punchy snare and smooth bass guitar. It sounds groovy, addictive and passionate. | ["low quality", "pop", "wide harmonizing male vocals", "wide shimmering hi hats", "wide brass melody", "electric guitar chords", "straight piano melody", "reverberant passionate female vocal", "punchy snare", "smooth bass guitar", "groovy", "addictive", "passionate"] | ["Music", "Vocal music"] | 4 | 30 | 40 | 0 | 0 | ["/m/04rlf", "/m/0y4f8"] |
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 );