musiccaps
1 row where aspect_list contains "americana" and aspect_list contains "melancholic"
This data as json, CSV (advanced)
aspect_list (array) 10 ✖
- acoustic guitar 1
- americana · 1 ✖
- country 1
- gravelly voice 1
- male vocal 1
- melancholic · 1 ✖
- percussion 1
- rock 1
- sentimental 1
- steady tempo 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
6OcoDIrbMtY | This is a country/Americana music piece. There is a male vocalist with a gravelly voice singing in the lead. An acoustic guitar is playing a simple tune. There is a faint percussive element that can be heard in the background that resembles pinched harmonics coming from a guitar. The atmosphere is melancholic. This piece could be used in the soundtrack of a drama movie or a TV show during a scene of introspection where a character is experiencing dark thoughts. | ["country", "americana", "rock", "male vocal", "gravelly voice", "acoustic guitar", "percussion", "melancholic", "sentimental", "steady tempo"] | ["Country", "Music", "Bluegrass"] | 9 | 130 | 140 | 0 | 0 | ["/m/01lyv", "/m/04rlf", "/m/0gg8l"] |
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 );