musiccaps
2 rows where aspect_list contains "reverberant" and audioset_ids contains "/m/06by7"
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 |
---|---|---|---|---|---|---|---|---|---|---|
s5kz8qg4B2Y | The low quality recording features a live performance of a rock song that consists of a passionate male vocal, followed by passionate female vocal singing over shimmering cymbals, mellow snare and kick hits, electric guitar melody and groovy bass guitar. It sounds distant, reverberant, but also energetic. | ["low quality", "rock", "live performance", "passionate male vocal", "passionate female vocal", "shimmering cymbals", "mellow snare", "electric guitar melody", "groovy bass guitar", "mellow kick hits", "reverberant", "distant", "energetic"] | ["Punk rock", "Rock music"] | 4 | 210 | 220 | 0 | 0 | ["/m/05r6t", "/m/06by7"] | |
xrqDoBor2dk | The low quality recording features an alternative/indie song that consists of electric guitar chords, groovy repetitive bass guitar, harsh electric guitar solo, percussive toms and shimmering shakers. It sounds muffled, harsh, groovy and it is uptempo and noisy. | ["low quality", "alternative/indie", "muffled", "harsh", "noisy", "electric guitar chords", "groovy repetitive bass guitar", "harsh electric guitar solo melody", "percussive toms", "shimmering shakers", "reverberant", "uptempo", "groovy"] | ["Swing music", "Funk", "Music", "Psychedelic rock", "Rock music"] | 4 | 30 | 40 | 1 | 1 | ["/m/015y_n", "/m/02x8m", "/m/04rlf", "/m/05w3f", "/m/06by7"] |
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 );