musiccaps
1 row where aspect_list contains "latin romantic hits" and aspect_list contains "male singer"
This data as json, CSV (advanced)
aspect_list (array) 20 ✖
- couples dancing 1
- emotional 1
- groovy bass line 1
- keyboard accompaniment 1
- keyboard harmony 1
- latin folk music 1
- latin percussions 1
- latin romantic hits · 1 ✖
- love songs 1
- male singer · 1 ✖
- medium tempo 1
- mysterious 1
- passionate 1
- passionate song 1
- poor audio quality 1
- romantic 1
- salsa 1
- spirited singing 1
- trumpets playing 1
- various percussion hits 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
DKflAAykh6A | A male singer sings this Latin melody. The song is medium tempo with a groovy Latin percussive rhythm, keyboard accompaniment, brass band harmony and a groovy bass line. The song is romantic and emotional. The song is a salsa dance hit, but has poor audio quality issues.. | ["salsa", "latin folk music", "male singer", "spirited singing", "emotional", "couples dancing", "passionate song", "mysterious", "latin percussions", "trumpets playing", "medium tempo", "various percussion hits", "keyboard harmony", "romantic", "love songs", "latin romantic hits", "keyboard accompaniment", "poor audio quality", "passionate", "groovy bass line"] | ["Music", "Middle Eastern music", "Salsa music"] | 1 | 30 | 40 | 1 | 1 | ["/m/04rlf", "/m/06j64v", "/m/0ln16"] |
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 );