musiccaps
3 rows where aspect_list contains "live performance" and audioset_ids = "["/m/03m5k", "/m/0d8_n"]"
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 |
---|---|---|---|---|---|---|---|---|---|---|
PemDZNVE370 | The low quality recording features a live performance of softly arpeggiated harp melody and mellow sustained strings. It sounds passionate and emotional. | ["low quality", "live performance", "softly arpeggiated harp melody", "mellow sustained strings", "passionate", "emotional"] | ["Harp", "Pizzicato"] | 4 | 390 | 400 | 0 | 0 | ["/m/03m5k", "/m/0d8_n"] | |
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"] | |
lDGQu122JdU | The song is an instrumental. The tempo is medium with a quartzophone being played delicately by an expert producing ethereal pulsating tones of music. The song is emotional and beautiful. The audio quality with ambient nature sounds. | ["quartzophone", "quartzophonist", "instrumental music", "ambient noises", "gong", "playing different notes", "pulsating tones", "vibrato", "echoes", "brent nature sounds", "live performance", "outdoors", "demonstration", "heavenly", "angelic", "overtones", "medium tempo", "passionate", "nostalgia", "romantic", "awe", "wonder", "christmas", "technique", "virtuoso", "ethereal tones"] | ["Harp", "Pizzicato"] | 1 | 190 | 200 | 0 | 0 | ["/m/03m5k", "/m/0d8_n"] |
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 );