musiccaps
1 row where aspect_list contains "electric guitar" and aspect_list contains "repeated tune"
This data as json, CSV (advanced)
aspect_list (array) 9 ✖
- acoustic drums 1
- alternative 1
- bass guitar 1
- electric guitar · 1 ✖
- energetic 1
- live performance 1
- male vocal 1
- nu-metal 1
- repeated tune · 1 ✖
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
79tuMIiWMZ4 | This is a nu-metal piece performed live on the stage. There is a male vocal shouting the words at the end of the song. The electric guitar is repeating the same tune while the bass guitar is playing in the background. The drummer plays fills on the acoustic drums to provide the rhythmic background. There is a high energy atmosphere to this piece. It could be used in an ad targeted for teenagers. | ["nu-metal", "alternative", "live performance", "male vocal", "electric guitar", "repeated tune", "bass guitar", "acoustic drums", "energetic"] | ["Music", "Exciting music"] | 9 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/t/dd00035"] |
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 );