musiccaps
1 row where aspect_list contains "acoustic guitar player", aspect_list contains "emotional" and aspect_list contains "latin pop hits"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 );