musiccaps
3 rows where aspect_list contains "noisy", aspect_list contains "passionate" and aspect_list contains "smooth bass"
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 |
---|---|---|---|---|---|---|---|---|---|---|
-OAyRsvFGgc | The low quality recording features a cover of a rock song that consists of an electric guitar solo melody played over playback instrumental. The instrumental features a punchy kick and snare hits, soft cymbals and smooth bass. It sounds passionate, even though the recording is muffled and noisy, as it was probably recorded with a phone. | ["low quality", "noisy", "cover", "rock", "electric guitar solo melody", "playback instrumental", "punchy snare", "punchy kick", "smooth bass", "soft cymbals", "passionate", "muffled"] | ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Heavy metal", "Music", "Distortion"] | 4 | 30 | 40 | 0 | 1 | ["/m/01glhc", "/m/02sgy", "/m/0342h", "/m/03lty", "/m/04rlf", "/m/0g12c5"] | |
exD5okdopWc | The low quality recording features a folk song that consists of passionate male vocal singing over shimmering shakers, smooth bass, sustained strings melody and groovy piano melody. It sounds emotional, soulful and passionate - like something you would hear in movies. | ["low quality", "folk", "noisy", "mono", "passionate male vocal", "sustained strings melody", "shimmering shakers", "smooth bass", "groovy piano melody", "emotional", "passionate", "soulful"] | ["Music of Asia", "Music"] | 4 | 60 | 70 | 0 | 0 | ["/m/028sqc", "/m/04rlf"] | |
swIXVQtP_TI | The low quality recording features a cover that consists of a mandolin solo melody playing over playback instrumental that has smooth bass and acoustic rhythm guitar. The recording is noisy, in mono and it sounds passionate and joyful. | ["low quality", "noisy", "mono", "cover", "mandolin solo melody", "acoustic rhythm guitar", "smooth bass", "instrumental playback", "passionate", "joyful"] | ["Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | 4 | 30 | 40 | 1 | 1 | ["/m/042v_gx", "/m/04rlf", "/m/04rzd", "/m/04szw", "/m/06w87", "/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 );