musiccaps
2 rows where aspect_list contains "stereo imbalance" 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 |
---|---|---|---|---|---|---|---|---|---|---|
6u1ckcErgcQ | The Funk song features a passionate female vocalist talking and singing over funky wide electric guitars and some guitar licks in the right channel, followed by smooth synth keys, punchy snare hits, soft kick hits, bouncy hi hats, soft crash cymbals and funky bass guitar. What makes this song low quality is the stereo imbalance - regardless, it sounds funky. | ["funk", "funky bass", "passionate female vocal", "funky wide electric guitar", "guitar licks", "smooth synth keys", "punchy snare", "bouncy hi hats", "soft crash cymbal", "soft kick hits", "low quality", "funky", "stereo imbalance"] | ["Funk", "Music"] | 4 | 30 | 40 | 0 | 1 | ["/m/02x8m", "/m/04rlf"] | |
dbldb9tq8ng | The Soft rock song features a mellow female vocal singing the same melody as the lead electric guitar, followed by widely spread acoustic rhythm guitars, simple bass, soft kick hits, punchy snare, simple hi hats, shimmering open hats and energetic crash cymbals. There is a short snare roll at some point in the loop. The stereo bass guitar is what makes the stereo image imbalance and therefore the song sounds lower in quality. | ["soft rock", "mellow female vocal", "wide acoustic rhythm guitars", "mono solo electric guitar lead melody", "short snare roll", "energetic cash cymbal", "simple hi hats", "shimmering open hat", "easygoing", "smooth", "simple bass guitar", "low quality", "stereo imbalance"] | ["Music", "Punk rock", "Rock music", "Rock and roll", "Grunge"] | 4 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/05r6t", "/m/06by7", "/m/07sbbz2", "/m/0dls3"] |
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 );