musiccaps
2 rows where aspect_list contains "jazz" and audioset_ids contains "/m/07pkxdp"
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 |
---|---|---|---|---|---|---|---|---|---|---|
ETl0hYRlVmg | The low quality recording features a live performance of a jazz song and it features a passionate female vocal singing over shimmering hi hats, groovy piano chords and smooth double bass. The recording has some audio crackles and that would be the only reason for it to go under the "low quality" category. It sounds emotional, passionate and groovy. | ["low quality", "jazz", "passionate female vocal", "groovy piano chords", "smooth double bass", "shimmering hi hats", "audio crackles", "live performance", "emotional", "passionate", "groovy"] | ["Music", "Lullaby"] | 4 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/07pkxdp"] | |
M4rXhyyvERM | This is the recording of a jazz improvisation performance. It is in an instrumental piece performed with a keyboard that utilizes a classical piano sound. The chords are being played gently which creates a calming atmosphere. Due to various chords and lines being played in this performance, parts of it could be lifted to be used as piano samples for a beat. It could also be playing in the background of a restaurant or a jazz bar. | ["jazz", "improvisation", "no singer", "instrumental", "single instrument", "jam", "keyboard", "piano sound", "gentle", "calming"] | ["Music", "Musical instrument", "Keyboard (musical)", "Piano", "Lullaby", "Synthesizer"] | 9 | 40 | 50 | 0 | 1 | ["/m/04rlf", "/m/04szw", "/m/05148p4", "/m/05r5c", "/m/07pkxdp", "/m/0l14qv"] |
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 );