musiccaps
2 rows where aspect_list contains "emotional", aspect_list contains "passionate", aspect_list contains "shimmering cymbals" and aspect_list contains "soulful"
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 |
---|---|---|---|---|---|---|---|---|---|---|
6iZ49s7eH5g | The Rock song features a groovy piano melody followed by passionate electric guitar melody, church organ chord progression, strummed acoustic rhythm guitar chords, shimmering cymbals, punchy snare and mellow kick hits. It sounds emotional, soulful and passionate. | ["rock", "groovy piano melody", "passionate electric guitar melody", "church organ chords progression", "strummed acoustic rhythm guitar chords progression", "shimmering cymbals", "punchy snare", "mellow kick", "emotional", "soulful", "passionate"] | ["Music", "Soul music"] | 4 | 300 | 310 | 0 | 0 | ["/m/04rlf", "/m/0gywn"] | |
lSbCqHZy_l4 | The low quality recording features a fruity male vocal talking, after which he starts singing over harmonizing choir, groovy bass, mellow piano melody, shimmering cymbals, punchy kick, punchy tom and snappy rimshots. It sounds emotional, soulful and passionate. | ["low quality", "fruity male vocal", "gospel", "harmonizing choir", "groovy bass", "mellow piano melody", "shimmering cymbals", "punchy kick", "punchy tom", "snappy rimshots", "emotional", "soulful", "passionate"] | ["Singing", "Gospel music", "Choir"] | 4 | 110 | 120 | 0 | 0 | ["/m/015lz1", "/m/016cjb", "/m/0l14jd"] |
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 );