musiccaps
2 rows where aspect_list contains "noisy" and audioset_ids contains "/m/0dl5d"
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 |
---|---|---|---|---|---|---|---|---|---|---|
4refolVb_uQ | The low quality recording features a rock song that consists of reverberant male vocal singing over groovy bass, short electric guitar chords, punchy snare, soft kick hits, shimmering hi hats and soft crash cymbals. The reverb of the vocal is located in the right channel of the stereo image, which makes it sound interesting. It is easygoing and groovy. | ["low quality", "noisy", "rock", "reverberant male vocal", "groovy bass", "shimmering hi hats", "soft crash cymbal", "punchy snare", "soft kick hits", "short electric guitar chords", "easygoing", "groovy"] | ["Funk", "Music", "Punk rock", "Rock music", "Progressive rock"] | 4 | 30 | 40 | 0 | 1 | ["/m/02x8m", "/m/04rlf", "/m/05r6t", "/m/06by7", "/m/0dl5d"] | |
NdiSW-p2I0c | The low quality recording features a passionate electric guitar solo melody over wide playback rock instrumental. The recording is noisy. | ["low quality", "wide playback instrumental", "rock", "passionate electric guitar solo melody", "noisy"] | ["Electric guitar", "Music", "Rock music", "Electronic tuner", "Progressive rock"] | 4 | 30 | 40 | 0 | 1 | ["/m/02sgy", "/m/04rlf", "/m/06by7", "/m/0b_fwt", "/m/0dl5d"] |
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 );