musiccaps
2 rows where aspect_list contains "chaotic" and audioset_ids contains "/m/074ft"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Bgsy5UpXx8I | The low quality recording features a rock song that consists of flat male vocal singing over punchy snare, soft kick hits, repetitive organ keys chords, shimmering hi hats and groovy bass. It sounds messy, loud, muddy and chaotic, since the frequencies are clashing with each other due to a bad mix. | ["low quality", "muddy", "messy", "rock", "flat male vocal", "punchy snare", "groovy bass", "repetitive organ keys chords", "soft kick hits", "shimmering hi hats", "chaotic", "loud"] | ["Country", "Music", "Punk rock", "Psychedelic rock", "Song", "Rock and roll"] | 4 | 30 | 40 | 0 | 1 | ["/m/01lyv", "/m/04rlf", "/m/05r6t", "/m/05w3f", "/m/074ft", "/m/07sbbz2"] | |
uAgizG1hYw0 | The low quality recording features a rock song that contains filtered female vocal singing over loud and harsh electric guitar chords, energetic drums and buzzy bass guitar. It sounds chaotic due to the bad mix and since the drums are panned in an unconventional way - making the stereo image unbalanced. It sounds harsh, but also energetic. | ["low quality", "loud", "rock", "harsh electric guitar chords", "filtered female vocal", "energetic drums", "unbalanced stereo", "chaotic", "energetic", "buzzy bass guitar"] | ["Blues", "Swing music", "Bass guitar", "Funk", "Music", "Pop music", "Song"] | 4 | 60 | 70 | 1 | 1 | ["/m/0155w", "/m/015y_n", "/m/018vs", "/m/02x8m", "/m/04rlf", "/m/064t9", "/m/074ft"] |
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 );