musiccaps
2 rows where aspect_list contains "cheering" 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 |
---|---|---|---|---|---|---|---|---|---|---|
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"] | |
LwmwCpAVPWU | The low quality recording features a live performance including resonating bass, energetic drums and strings melody. The recording is in a terrible condition, as the bass is resonating much and the sound is overall muffled and muddy. There are some cheering and clapping sounds from a crowd. The listener can barely hear the instruments, as it sounds chaotic. It was definitely recorded with a phone. | ["low quality", "crowd cheering", "muffled sound", "resonating bass", "live performance", "strings melody", "energetic drums", "cheering", "clapping", "chaotic"] | ["Music", "Rock and roll", "Harmonic"] | 4 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/07sbbz2", "/m/0b9m1"] |
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 );