musiccaps
2 rows where aspect_list contains "groovy" and audioset_ids = "["/m/04rlf", "/m/0dls3"]"
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 |
---|---|---|---|---|---|---|---|---|---|---|
I4Jp0kB2Ns0 | The Rock instrumental features a passionate electric guitar solo melody played over punchy kick and snare hits, shimmering hi hats, groovy bass guitar, wooden bouncy percussion and electric guitar, mellow feedback, located in the left channel of the stereo image. It sounds groovy, addictive and passionate, thanks to that solo melody. | ["rock", "instrumental", "groovy bass guitar", "passionate electric guitar solo melody", "punchy kick", "punchy snare", "wooden bouncy percussion", "shimmering hi hats", "electric guitar mellow feedback", "groovy", "addictive", "passionate"] | ["Music", "Grunge"] | 4 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/0dls3"] | |
LbPRGDwlfqs | This is an electroclash piece. There is a male vocalist singing in the lead with hollering samples in the background. An electric guitar is playing the main theme repeatedly. The bass guitar is playing a groovy bass line. In the rhythmic background, there is an upbeat acoustic drum beat. The piece is groovy and danceable. It could be playing in the background at a sports bar or a rock bar. The music would also suit well with sports venues. | ["electroclash", "male vocal", "electric guitar", "repeated theme", "bass guitar", "groovy", "danceable", "energetic", "bravado", "upbeat"] | ["Music", "Grunge"] | 9 | 40 | 50 | 0 | 1 | ["/m/04rlf", "/m/0dls3"] |
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 );