musiccaps
2 rows where aspect_list contains "punchy snare" and audioset_ids = "["/m/04rlf", "/t/dd00032"]"
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 |
---|---|---|---|---|---|---|---|---|---|---|
1PSzSTilu_s | The low quality recording features a southern rock song that consists of flat male vocal singing over wide acoustic rhythm guitars, short electric guitar lick, smooth bass guitar, punchy snare, simple kick pattern and shimmering hi-hats. It sounds happy and fun. | ["low quality", "flat male vocal", "wide acoustic rhythm guitar", "short electric guitar lick", "smooth bass guitar", "punchy snare", "simple kick pattern", "shimmering hi hats", "happy", "fun", "southern rock"] | ["Music", "/t/dd00032"] | 4 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/t/dd00032"] | |
FaD9qs2ACpI | The Hip Hop song features a passionate female vocal singing and flat male vocal rapping over piano chords, punchy kick and snare hits, repetitive synth hits and sustained strings melody. At the end of the first section there is an echoing effect on vocals. It sounds energetic and addictive, even though the audio cuts out in the middle of the chorus, straight to the verse. | ["hip hop", "piano chords progression", "repetitive synth hits", "passionate female vocal", "flat male vocal", "punchy snare", "punchy kick", "cheering", "audio cutout", "echoing effect", "sustained strings melody", "energetic", "addictive"] | ["Music", "/t/dd00032"] | 4 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/t/dd00032"] |
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 );