musiccaps
2 rows where aspect_list contains "passionate female vocal" and audioset_ids contains "/m/03_d0"
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 |
---|---|---|---|---|---|---|---|---|---|---|
0TiEO149Ydc | The low quality recording features a live performance of an Alternative/Indie song and it consists of passionate female vocal singing over acoustic guitar strummed chord and wooden percussive element. The recording is noisy and the vocal is slightly moving throughout the stereo image making it unbalanced. It sounds passionate and emotional. | ["low quality", "noisy", "alternative/indie", "wooden percussive element", "acoustic guitar strummed chord", "passionate female vocal", "emotional", "passionate", "live performance", "unbalanced stereo image"] | ["Jazz", "Music"] | 4 | 30 | 40 | 0 | 1 | ["/m/03_d0", "/m/04rlf"] | |
mFcHGbnNtSQ | The low quality recording features a live performance of a jazz song and it consists of a passionate female vocalist singing over groovy piano melody, saxophone melody, groovy bass, shimmering hi hats, punchy snare and soft kick hits. It sounds passionate, soulful and the recording is noisy and in mono. | ["low quality", "live performance", "passionate female vocal", "groovy piano melody", "saxophone melody", "groovy bass", "shimmering hi hats", "punchy snare", "soft kick hits", "jazz", "passionate", "soulful", "noisy", "mono"] | ["Blues", "Singing", "Jazz", "Music", "Harmonic"] | 4 | 70 | 80 | 0 | 0 | ["/m/0155w", "/m/015lz1", "/m/03_d0", "/m/04rlf", "/m/0b9m1"] |
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 );