musiccaps
3 rows where aspect_list contains "fun", aspect_list contains "happy" and audioset_names contains "Blues"
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 |
---|---|---|---|---|---|---|---|---|---|---|
-rAhS48FkYw | The low quality recording features a pop song that consists of a passionate male vocal singing over mellow kick hits, shimmering hi hats, wide electric guitar melody, syncopated snare and wooden percussion. The first half of the loop does not consist of the vocal, snare and hi hats. It sounds happy, fun and joyful. | ["low quality", "pop", "passionate male vocal", "happy", "fun", "joyful", "mellow kick hits", "shimmering hi hats", "wide electric guitar melody", "wooden percussions", "syncopated snare"] | ["Blues", "Music"] | 4 | 30 | 40 | 0 | 0 | ["/m/0155w", "/m/04rlf"] | |
GBsate-JQAo | The low quality recording features a live performance sung by harmonizing mixed vocals and followed by acoustic rhythm guitar and shimmering shaker. In the second part, a hollow male vocal continues to sing over shaker and acoustic guitar. It sounds thin, but fun, happy and emotional - it was probably recorded with a phone or camera microphone. | ["low quality", "live performance", "shimmering shakers", "harmonizing mixed vocals", "hollow male vocal", "acoustic rhythm guitar", "fun", "happy", "emotional", "thin"] | ["Blues", "Singing", "Music"] | 4 | 120 | 130 | 0 | 1 | ["/m/0155w", "/m/015lz1", "/m/04rlf"] | |
NZ2kFIaW05k | The low quality recording features an electric guitar melody played over a playback that consists of groovy bass, punchy snare and shimmering cymbals. At the end of the loop, there is a flat male vocal talking. It sounds groovy, fun and the recording is noisy and slightly distorted. | ["low quality", "electric guitar melody", "groovy bass", "punchy snare", "shimmering cymbals", "groovy", "fun", "happy", "flat male vocal", "distorted", "noisy"] | ["Blues", "Bass guitar", "Guitar", "Music", "Musical instrument", "Rhythm and blues", "Speech", "Harmonic", "Plucked string instrument"] | 4 | 450 | 460 | 0 | 0 | ["/m/0155w", "/m/018vs", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/06j6l", "/m/09x0r", "/m/0b9m1", "/m/0fx80y"] |
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 );