musiccaps
2 rows where aspect_list contains "pop" and audioset_ids contains "/m/0g12c5"
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 |
---|---|---|---|---|---|---|---|---|---|---|
kaabXWuPWRg | This music clip is an electric guitar solo lead instrumental. The tempo is fast with the guitarist playing a very emphatic, intense riff. No other instruments have been used. The music is loud, intense, engaging and catchy. | ["electric guitar", "instrumental", "string instrument", "external amplification", "vibrations", "skilful", "pop", "jazz", "country", "blues", "heavy metal", "lead instrument", "medium tempo", "sonic power", "amplified guitar", "melodious", "minimal instrumentation", "rock", "hard rock", "intense", "loud", "powerful"] | ["Effects unit", "Electric guitar", "Music", "Harmonic", "Distortion"] | 7 | 30 | 40 | 0 | 1 | ["/m/02rr_", "/m/02sgy", "/m/04rlf", "/m/0b9m1", "/m/0g12c5"] | |
sp77ueBkqS0 | This music is an Electric Guitar instrumental. The tempo is medium with a pleasant electric guitar riff. The music is loud, powerful, clear, tight, intense and engaging. | ["instrumental", "medium tempo", "electric guitar", "stringed instrument", "amplified guitar", "rock", "hard rock", "pop", "metal", "heavy metal", "intense", "full bodied", "classic", "versatile", "shiny acoustic", "tight", "powerful", "intense deep", "loud feedback", "lucid"] | ["Effects unit", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] | 7 | 60 | 70 | 0 | 0 | ["/m/02rr_", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y", "/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 );