musiccaps
2 rows where aspect_list contains "acoustic love song" and audioset_ids contains "/m/015lz1"
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 |
---|---|---|---|---|---|---|---|---|---|---|
N8Fg3L1Cc5E | A female singer sings this beautiful melody. The tempo is medium with a piano or keyboard accompaniment and no other instrumentation. The song is emotional and passionate like a love song. The audio quality is very poor with a lot of hissing noise and distortion. | ["female singer", "poor audio quality", "hissing noise", "distorted vocals", "pop songs", "pop cover", "song covers", "piano accompaniment", "acoustic love song", "live performance", "club", "romantic", "emotional", "sad song", "passionate", "melancholic", "with you forever", "missing you", "passionate", "bad audio quality", "medium tempo"] | ["Singing", "Bell", "Music"] | 1 | 20 | 30 | 0 | 0 | ["/m/015lz1", "/m/0395lw", "/m/04rlf"] | |
oxhFIoExrMk | A male Latin singer sings this romantic melody. The song is medium tempo with an acoustic guitar accompaniment with no other instrumentation. The song is emotional and passionate. The audio quality is poor. | ["acoustic guitar player", "soulful singer", "live sessions", "youtube music video", "medium tempo", "latin love song", "latin pop hits", "groovy rhythm", "beautiful melody", "latin indie song", "home studio recording", "style guitar playing", "emotional", "romantic", "groovy sluice", "soloist", "acoustic love song", "bad audio quality", "madly in love", "classical guitar accompaniment", "male singer"] | ["Singing", "Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | 1 | 30 | 40 | 0 | 0 | ["/m/015lz1", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/07s0s5r", "/m/0fx80y"] |
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 );