musiccaps
1 row where aspect_list contains "electric guitar", aspect_list contains "guitar tutorial" and aspect_list contains "powerful"
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 |
---|---|---|---|---|---|---|---|---|---|---|
IqGB4nQIAcQ | This clip is an instrumental. The tempo is medium with an electric guitar solo lead. There are no other instruments used. There is an interaction between two men in the interval . The music is powerful, loud and skilled and the speech indicates that this is probably a tutorial on how to play the guitar or an interview. | ["instrumental", "electric guitar", "medium tempo", "external amplification", "embedded pickups", "sonic power", "powerful", "amplified guitar", "vibrations", "dexterity", "male voices interaction", "interview", "tutorial", "guitar tutorial"] | ["Reverberation", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | 7 | 210 | 220 | 0 | 1 | ["/m/01b9nn", "/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 );