musiccaps
1 row where aspect_list contains "acoustic guitar accompaniment" and aspect_list contains "ambient"
This data as json, CSV (advanced)
aspect_list (array) 20 ✖
- acoustic guitar accompaniment · 1 ✖
- ambient · 1 ✖
- dulcet 1
- emphatic lead 1
- fluid 1
- groovy bass lines 1
- instrumental 1
- melancholic 1
- mellow 1
- melodic electric guitar lead 1
- mood 1
- nostalgic 1
- pleasant 1
- retro pop 1
- rock and roll 1
- romantic 1
- simple melody 1
- slow tempo 1
- soft 1
- steady drumming 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
xKc_9B3RiOc | This song is an instrumental. The tempo is medium with a melodious lead on the electric guitar, steady drumming, groovy bass lines and acoustic guitar accompaniment. The melody is simple, mellow, pleasant, melancholic, nostalgic and ambient. This instrumental song is a Classic Rock and Roll. | ["retro pop", "slow tempo", "instrumental", "acoustic guitar accompaniment", "emphatic lead", "simple melody", "dulcet", "mood", "fluid", "romantic", "ambient", "melodic electric guitar lead", "steady drumming", "groovy bass lines", "acoustic guitar accompaniment", "mellow", "soft", "pleasant", "melancholic", "nostalgic", "rock and roll"] | ["Swing music", "Music"] | 7 | 60 | 70 | 1 | 1 | ["/m/015y_n", "/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 );