musiccaps
1 row where aspect_list contains "overdriven guitar" and aspect_list contains "rock and roll"
This data as json, CSV (advanced)
aspect_list (array) 7 ✖
- bass 1
- happy mood 1
- male voice 1
- moderate tempo 1
- overdriven guitar · 1 ✖
- percussion 1
- rock and roll · 1 ✖
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
vEN9szBPBkw | This rock and roll song features a male voice singing the main melody. This is accompanied by percussion playing a simple beat in common time. An overdriven guitar plays chords with licks in between lines. The bass plays the root notes of the chords. The mood of this song is happy. This song can be played in a movie scene when the protagonist is walking into a hotel prior to a fight scene. | ["rock and roll", "male voice", "overdriven guitar", "percussion", "bass", "moderate tempo", "happy mood"] | ["Singing", "Music", "Ska"] | 0 | 40 | 50 | 0 | 0 | ["/m/015lz1", "/m/04rlf", "/m/06rqw"] |
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 );