musiccaps
3 rows where aspect_list contains "live performance", aspect_list contains "mellow" and aspect_list contains "soft"
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 |
---|---|---|---|---|---|---|---|---|---|---|
G7pD1K3jYg4 | The low quality recording features a live performance of a classical song and it consists of tuba melody. It sounds mellow, soft and reverberant, as it was recorded in a huge concert hall. The recording is a bit noisy. | ["low quality", "tuba melody", "reverberant", "mellow", "noisy", "soft", "concert hall", "classical", "live performance"] | ["Brass instrument", "French horn"] | 4 | 30 | 40 | 0 | 0 | ["/m/01kcd", "/m/0319l"] | |
hm0SeoNSGkc | The low quality recording features a live performance of an arpeggiated acoustic guitar melody and plucked harp melody. It sounds mellow, soft, easygoing and the recording is really noisy and in mono. | ["low quality", "plucked harp melody", "arpeggiated acoustic guitar melody", "noisy", "mono", "live performance", "mellow", "soft", "easygoing"] | ["Harp", "Pizzicato"] | 4 | 410 | 420 | 0 | 0 | ["/m/03m5k", "/m/0d8_n"] | |
u3yOMK8SuRI | This song is a simple instrumental. The tempo slows with the sound of clapping followed by a soft and mellow ukelele melody. This is a home video of a Ukelele instrumental. | ["instrumental", "slow tempo", "ukelele melody", "minimalist", "pleasant sound", "simple", "rhythmic", "soft", "mellow", "sound of clapping", "live performance", "four stringed instrument", "stringed instrument", "hawaiian instrument", "lute family"] | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Ukulele", "Plucked string instrument", "Bowed string instrument"] | 7 | 0 | 10 | 0 | 0 | ["/m/0342h", "/m/042v_gx", "/m/04rlf", "/m/04szw", "/m/07xzm", "/m/0fx80y", "/m/0l14_3"] |
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 );