musiccaps
1 row where aspect_list contains "acoustic guitar" and aspect_list contains "fingerstyle-guitar"
This data as json, CSV (advanced)
aspect_list (array) 4 ✖
- acoustic guitar · 1 ✖
- classical atmosphere 1
- fingerstyle-guitar · 1 ✖
- medium tempo 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
07FxCXxknY4 | This audio contains an acoustic guitar. The piece is played in fingerstyle. Meaning that the chords and the melody are played at the same time. The guitar has some reverb on it. This song may be playing live at an art gallery. | ["fingerstyle-guitar", "acoustic guitar", "medium tempo", "classical atmosphere"] | ["Bass guitar", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Happy music"] | 6 | 30 | 40 | 0 | 1 | ["/m/018vs", "/m/0342h", "/m/042v_gx", "/m/04rlf", "/m/04szw", "/m/07s0s5r", "/t/dd00031"] |
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 );