musiccaps
1 row where aspect_list contains "male voice singing" and aspect_list contains "rock&roll"
This data as json, CSV (advanced)
aspect_list (array) 8 ✖
- acoustic drum 1
- e-bass 1
- e-guitar 1
- male voice singing · 1 ✖
- organ 1
- positive vibes 1
- rock&roll · 1 ✖
- uptempo 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
BHu95Y_kVQA | This song contains acoustic drums playing a steady groove with an uplifting bassline that repeats itself. An e-guitar is playing a single note melody while strings and an organ are elevating the energy with long higher register chords. Some backing vocals are singing along to the strings while the male voice is singing his melody. This song may be playing on a sunny day at the park having a picnic. | ["rock&roll", "acoustic drum", "e-bass", "organ", "e-guitar", "male voice singing", "uptempo", "positive vibes"] | ["Music", "Independent music"] | 6 | 30 | 40 | 1 | 1 | ["/m/04rlf", "/m/05rwpb"] |
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 );