musiccaps
2 rows where aspect_list contains "soft piano melody" and author_id = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|
7FHzw4HV75Y | The Regional Mexican song features a soft piano melody, rhythm acoustic guitar, smooth bass, addictive brass melody and passionate male vocal singing on top of it. It sounds soft, mellow, passionate and emotional. | ["regional mexican", "soft piano melody", "acoustic rhythm guitar", "smooth bass", "passionate male vocal", "addictive brass melody", "soft", "mellow", "emotional", "passionate"] | ["Brass instrument", "Trumpet"] | 4 | 230 | 240 | 0 | 0 | ["/m/01kcd", "/m/07gql"] | |
Wdtku1dqJo0 | The low quality recording features a live performance of a ballad song that consists of sustained strings, soft crash cymbals and soft piano melody. At the very end of the loop, there are passionate muddy female vocals. It sounds passionate, emotional and heartfelt, while it is a bit noisy too. | ["low quality", "noisy", "live performance", "sustained stings", "passionate muddy female vocal", "soft piano melody", "ballad", "soft crash cymbal", "passionate", "emotional", "heartfelt"] | ["Music", "/t/dd00004"] | 4 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/t/dd00004"] |
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 );