musiccaps
2 rows where aspect_list contains "latin jazz" and author_id = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|
MrMXYO2fzJ4 | The low quality recording features a latin jazz song played in the background over which a drums solo is played. The solo consists of shimmering hi hats, punchy snare and kick hits and low tom rolls, while the latin jazz song consists of groovy piano chords and wooden percussion. It sounds energetic and exciting. | ["low quality", "latin jazz", "groovy piano chords", "wooden percussion", "drums solo", "punchy kick", "punchy snare", "low tom roll", "shimmering hi hats", "energetic", "exciting"] | ["Cymbal", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Bass drum", "Percussion"] | 4 | 140 | 150 | 0 | 0 | ["/m/01qbl", "/m/026t6", "/m/02hnl", "/m/03qtq", "/m/03t3fj", "/m/0bm02", "/m/0l14md"] | |
zYUZEXCE7gw | The Latin Jazz song features an exotic, jazzy piano melody, plucked double bass, subtle hi hats and percussive wooden elements playing as the passionate female vocalist is singing. It sounds like it was recorded with stereo room microphones, since the vocal sounds a bit "roomy". | ["latin jazz", "low quality", "passionate female vocal", "exotic piano melody", "subtle hi hats", "percussive wooden elements", "plucked double bass", "reverberant"] | ["Music", "A capella"] | 4 | 30 | 40 | 1 | 1 | ["/m/04rlf", "/m/0z9c"] |
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 );