musiccaps
2 rows where aspect_list contains "shimmering hi hats" and audioset_ids contains "/m/015y_n"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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"] | |
l0fCHZhKEDA | The low quality recording features a groovy piano organ keys in the left channel and organ keys lead melody played in the right and the middle channel of the stereo image, followed by groovy bass, shimmering hi hats and soft kick hits. It sounds happy and joyful. | ["low quality", "groovy organ keys melody", "organ keys lead melody", "groovy bass", "shimmering hi hats", "soft kick hits", "happy", "joyful"] | ["Swing music", "New-age music", "Music"] | 4 | 30 | 40 | 0 | 0 | ["/m/015y_n", "/m/02v2lh", "/m/04rlf"] |
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 );