musiccaps
1 row where aspect_list contains "latin love song" and aspect_list contains "madly in love"
This data as json, CSV (advanced)
aspect_list (array) 21 ✖
- acoustic guitar player 1
- acoustic love song 1
- bad audio quality 1
- beautiful melody 1
- classical guitar accompaniment 1
- emotional 1
- groovy rhythm 1
- groovy sluice 1
- home studio recording 1
- latin indie song 1
- latin love song · 1 ✖
- latin pop hits 1
- live sessions 1
- madly in love · 1 ✖
- male singer 1
- medium tempo 1
- romantic 1
- soloist 1
- soulful singer 1
- style guitar playing 1
- youtube music video 1
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 );