musiccaps
2 rows where aspect_list contains "electric guitar solo", aspect_list contains "energetic" and aspect_list contains "passionate"
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 |
---|---|---|---|---|---|---|---|---|---|---|
t8os583-_JM | The low quality recording features a cover of a latin urban song that consists of a groovy bass guitar, acoustic rhythm guitar, hand tapping and electric guitar solo playing over it in the first half of the loop, followed by harmonica solo in the second half of the loop. It sounds passionate and energetic. | ["low quality", "latin urban", "cover", "hand tapping", "groovy bass guitar", "acoustic rhythm guitar", "electric guitar solo", "harmonica solo", "passionate", "energetic"] | ["Harmonica", "Wind instrument, woodwind instrument"] | 4 | 30 | 40 | 0 | 0 | ["/m/03qjg", "/m/085jw"] | |
ylKvglDzBU4 | The song is an instrumental improvisation. The song is medium fast tempo with a groovy bass line, electric guitar playing, saxophone playing, jazz drumming with percussive hits and a xylophone playing. The song is highly improvisational and energetic. The song is a modern jazz fusion or improvisation jam. | ["funk jazz", "medium fast tempo", "instrumental music", "saxophone playing", "electric guitar solo", "funky jazz drumming", "groovy bass line", "drum rolls", "various percussion hits", "live improvisation", "bells percussion tones", "xylophone playing", "jazz improvisation", "energetic", "exciting", "jazz band", "modern jazz hits", "groovy rhythm", "jazz festival", "emphatic cries", "emotional", "passionate"] | ["Music", "Ska", "Vibraphone"] | 1 | 70 | 80 | 1 | 1 | ["/m/04rlf", "/m/06rqw", "/m/0dwt5"] |
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 );