musiccaps
1 row where aspect_list contains "country love song" and aspect_list contains "romantic"
This data as json, CSV (advanced)
aspect_list (array) 26 ✖
- acoustic guitar 1
- auto harp 1
- banjo 1
- bass guitar 1
- cello 1
- country love song · 1 ✖
- country pop 1
- country song 1
- country song hits 1
- duet 1
- electric guitar 1
- emotional 1
- fiddle 1
- first love 1
- folk music 1
- intense drumming 1
- keyboard harmony 1
- love song 1
- mandolin 1
- medium tempo 1
- passionate 1
- proposal song 1
- romantic · 1 ✖
- song climax 1
- violins 1
- wedding song 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
AagemOzvoZE | This song is a romantic duet. The tempo is medium with a plethora of instruments like the auto harp, fiddle, acoustic guitar, electric guitar, bass guitar, banjo,intense drumming, cello, violin harmony and vocal harmony. The song is a romantic, charming,emotional, passionate love song. The instrumentation style and music decibels indicate that this is the climax of a country love song. | ["duet", "medium tempo", "country song", "fiddle", "auto harp", "song climax", "country love song", "first love", "wedding song", "proposal song", "banjo", "mandolin", "acoustic guitar", "intense drumming", "keyboard harmony", "cello", "violins", "electric guitar", "bass guitar", "love song", "romantic", "passionate", "emotional", "country song hits", "country pop", "folk music"] | ["Singing", "Country", "Music"] | 7 | 30 | 40 | 0 | 0 | ["/m/015lz1", "/m/01lyv", "/m/04rlf"] |
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 );