musiccaps
2 rows where aspect_list contains "external amplification" and audioset_ids contains "/m/01b9nn"
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"] | |
U-L9YCIdLbg | This music is instrumental. The tempo is medium with rhythmic drumming accompaniment. The melody is simple and gets interesting as a layer of drums gets added. It is spirited, catchy and engaging. | ["instrumental", "medium tempo", "electric guitar", "sonic power", "spirited", "catchy", "engaging", "smooth", "rock", "external amplification", "vibrating strings", "slick drumming", "layers of music", "groovy", "catchy", "energetic", "sonic power", "minimal instrumentation"] | ["Reverberation", "Echo", "Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Distortion"] | 7 | 80 | 90 | 0 | 1 | ["/m/01b9nn", "/m/01jnbd", "/m/02rr_", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0g12c5"] |
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 );