musiccaps
2 rows where aspect_list contains "hopeful" and audioset_ids contains "/t/dd00003"
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 |
---|---|---|---|---|---|---|---|---|---|---|
01hjVJN9xCg | A low fidelity recording of a gospel choir with group vocals, a female singer, a male rapper, piano, a busy kick pattern, finger snaps and a slow tempo. The mood is hopeful and spiritual. | ["low fidelity recording", "gospel", "choir", "piano", "group vocals", "female singer", "male rapper", "busy kick pattern", "finger snaps", "slow tempo", "hopeful", "spiritual"] | ["Music", "Choir", "/t/dd00003", "Synthetic singing"] | 8 | 30 | 40 | 0 | 0 | ["/m/04rlf", "/m/0l14jd", "/t/dd00003", "/t/dd00006"] | |
l1coM570kVw | The low quality recording features a live performance of a soul song and it consists of passionate male vocal singing over playback instrumentals. The instrumental consists of a shimmering tambourine layered with punchy snare hits, soft kick hits, some toms rolls, groovy bass, electric guitar melody and harmonizing male vocals. It sounds emotional, soulful, hopeful and joyful. | ["low quality", "live performance", "noisy", "mono", "passionate male vocal", "soul", "playback instrumental", "shimmering tambourine", "punchy snare", "groovy bass", "electric guitar melody", "soft kick hits", "toms roll", "harmonizing male vocals", "emotional", "hopeful", "joyful", "soulful"] | ["Music", "/t/dd00003"] | 4 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/t/dd00003"] |
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 );