musiccaps
2 rows where aspect_list contains "bad mix" and audioset_ids contains "/m/04rlf"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| SG24NL2Xi3A | The low quality recording features a hip hop song sung with an addictive flow by flat double male vocals over arpeggiated piano melody, boomy, layered bass and kick hits, soft crash cymbal and claps. It sounds muddy and messy as the mix of the song is bad making the frequencies clash with each other - especially in the low end. | ["low quality", "hip hop", "arpeggiated piano melody", "boomy kick", "claps", "soft crash cymbal", "flat double male vocals", "boomy bass", "muddy", "messy", "bad mix", "addictive"] | ["Music", "Independent music", "Rhythm and blues", "Song"] | 4 | 30 | 40 | 1 | 1 | ["/m/04rlf", "/m/05rwpb", "/m/06j6l", "/m/074ft"] | |
| eXWBC3XfiXY | The low quality recording features a soft rock song that consists of harmonizing mixed vocals singing passionately over mellow piano chords, soft synth pad chords, boomy kick and reverberant claps. It sounds boomy, muddy and dull, as the low frequencies are clashing, bu it is also emotional regardless. | ["low quality", "passionate harmonizing mixed vocals", "soft rock", "mellow piano chords", "soft synth pad chords", "boomy kick", "reverberant claps", "bad mix", "boomy", "muddy", "dull"] | ["Christmas music", "Christian music", "Music", "Pop music", "Rock music", "Soul music"] | 4 | 30 | 40 | 1 | 1 | ["/m/0140xf", "/m/02mscn", "/m/04rlf", "/m/064t9", "/m/06by7", "/m/0gywn"] |
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 );