musiccaps
3 rows where aspect_list contains "soulful" and audioset_ids contains "/m/03qjg"
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"] | |
sSavMIH-e-w | The Jazz song features a saxophone solo melody playing over shimmering hi hats, groovy bass and shimmering bells melody. It sounds passionate, soft, mellow and soulful. | ["jazz", "groovy bass", "shimmering bells melody", "saxophone solo melody", "shimmering hi hats", "mellow", "soft", "passionate", "soulful"] | ["Harmonica", "Wind instrument, woodwind instrument"] | 4 | 20 | 30 | 0 | 0 | ["/m/03qjg", "/m/085jw"] | |
uA-JpZppFsc | The low quality recording features an accordion melody with some plastic tapping keys along the way. It sounds soulful and passionate and the recording is noisy. | ["low quality", "noisy", "accordion melody", "plastic tapping sounds", "soulful", "passionate"] | ["Harmonica"] | 4 | 30 | 40 | 0 | 0 | ["/m/03qjg"] |
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 );