musiccaps
1 row where aspect_list contains "descendling scale pattern", aspect_list contains "electric guitar" and aspect_list contains "guitar lesson"
This data as json, CSV (advanced)
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
eyY6f4iQDH4 | This song features an electric guitar. A male voice is narrating about the major scale. The guitar plays a descending scale pattern from the high note in the scale to the low note. There are no other instruments in this song. There is no vocal melody in this song. This can be played for an instructional video on playing the guitar. | ["electric guitar", "descendling scale pattern", "no other instrument", "male voice", "narration", "guitar lesson"] | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | 0 | 80 | 90 | 0 | 0 | ["/m/01glhc", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y"] |
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 );