musiccaps
1 row where aspect_list contains "electric guitar" and aspect_list contains "violin"
This data as json, CSV (advanced)
aspect_list (array) 10 ✖
- acoustic drums 1
- banjo 1
- country music 1
- electric guitar · 1 ✖
- hard-hitting 1
- lively 1
- male vocal 1
- preach-like singing 1
- upright bass 1
- violin · 1 ✖
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
adYFXYPqo2M | This is a country music piece. There is a male vocalist singing in a preaching manner. The melody is being played by a violin, a banjo and an electric guitar while an upright bass is playing in the background. The rhythmic background consists of an accentuated acoustic drum beat. The atmosphere is lively and hard-hitting. This piece could be used in the soundtrack of a historical crime movie taking place in the US. | ["country music", "male vocal", "preach-like singing", "violin", "banjo", "electric guitar", "upright bass", "acoustic drums", "lively", "hard-hitting"] | ["Music", "Ska", "Song", "Rock and roll"] | 9 | 30 | 40 | 1 | 1 | ["/m/04rlf", "/m/06rqw", "/m/074ft", "/m/07sbbz2"] |
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 );