musiccaps
3 rows where aspect_list contains "jazzy" and audioset_ids contains "/m/04szw"
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 |
---|---|---|---|---|---|---|---|---|---|---|
-VclCul6FrI | The low quality recording features a jazzy organ keys melody. The recording is in mono, noisy, muffled and slightly distorted. | ["low quality", "noisy", "mono", "organ keys melody", "muffled", "distorted", "jazzy"] | ["Organ", "Music", "Musical instrument", "Keyboard (musical)", "Piano", "Harmonic", "Inside, small room"] | 4 | 80 | 90 | 0 | 0 | ["/m/013y1f", "/m/04rlf", "/m/04szw", "/m/05148p4", "/m/05r5c", "/m/0b9m1", "/t/dd00125"] | |
JRfU_hF1wdM | The low quality recording features a jazzy song that consists of shimmering hi hats, repetitive cowbell, snappy rimshots and smooth bass in the right channel, short brass stabs and groovy piano chords in the left channel of the stereo image and electric guitar solo melody in the middle. The stereo image of the song is a bit unbalanced, due to the spreadness of low frequency sounds throughout the stereo image. It sounds easygoing and percussive. | ["low quality", "jazzy", "unbalanced stereo", "shimmering hi hats", "repetitive cowbell", "short brass stabs", "electric guitar solo melody", "groovy piano chords", "smooth bass", "easygoing", "percussive", "snappy rimshots"] | ["Swing music", "Music", "Musical instrument", "Music of Latin America"] | 4 | 30 | 40 | 0 | 1 | ["/m/015y_n", "/m/04rlf", "/m/04szw", "/m/0g293"] | |
NVo-stvk_QE | Here we have an electric guitarist intricately playing a guitar solo with a reverb effect applied to his guitar. The music is a jazzy type of backing track with a sophisticated walking bassline. The guitarist is highly skilled. | ["jazzy", "electric guitar solo", "simple jazzy drumming", "intricate walking bassline", "reverb effect", "complex electric guitar playing"] | ["Reverberation", "Effects unit", "Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument", "Distortion"] | 3 | 30 | 40 | 0 | 0 | ["/m/01b9nn", "/m/02rr_", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/06w87", "/m/0fx80y", "/m/0g12c5"] |
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 );