musiccaps
3 rows where aspect_list contains "acoustic rhythm guitar", audioset_ids contains "/m/03qjg" and audioset_ids contains "/m/085jw"
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 |
---|---|---|---|---|---|---|---|---|---|---|
JCfZpSEH77Y | The low quality recording features a blues song that consists of a passionate fruity male vocal singing over harmonica licks, acoustic rhythm guitar, groovy bass and steel guitar melody. It sounds passionate and soulful. The recording is noisy and since the bass sound is leaning towards the right channel of the stereo image - the stereo image is unbalanced. | ["low quality", "blues", "passionate fruity male vocal", "harmonica licks", "acoustic rhythm guitar", "steel guitar melody", "passionate", "soulful", "groovy bass", "unbalanced stereo", "noisy"] | ["Harmonica", "Wind instrument, woodwind instrument"] | 4 | 380 | 390 | 0 | 0 | ["/m/03qjg", "/m/085jw"] | |
drqKxGmdf8Y | The low quality recording features a live performance of a folk song and it consists of harmonica solo melody over acoustic rhythm guitar chord progression. It sounds happy and fun. The recording is noisy and a bit reverberant as it was probably recorded with a poor quality microphone. | ["low quality", "live performance", "folk", "acoustic rhythm guitar", "harmonica solo", "happy", "fun", "noisy", "reverberant"] | ["Harmonica", "Wind instrument, woodwind instrument"] | 4 | 30 | 40 | 0 | 0 | ["/m/03qjg", "/m/085jw"] | |
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"] |
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 );