musiccaps
2 rows where aspect_list contains "emotional electric guitar melody" and audioset_ids contains "/m/06w87"
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 |
---|---|---|---|---|---|---|---|---|---|---|
2T1P9ovsl4A | The low quality recording features an emotional electric guitar melody, shimmering hi hats, soft kick hits and punchy snare in the left channel and arpeggiated electric guitar melody and simple bass guitar in the right channel of the stereo image. Due to this unconventional panning, the stereo image sounds a bit unbalanced. It is still emotional and passionate. | ["low quality", "emotional electric guitar melody", "arpeggiated electric guitar melody", "mellow kick hits", "soft snare hits", "shimmering hi hats", "unbalanced stereo", "emotional", "passionate"] | ["Bass guitar", "Music", "Steel guitar, slide guitar", "Chorus effect"] | 4 | 30 | 40 | 0 | 1 | ["/m/018vs", "/m/04rlf", "/m/06w87", "/m/07m2kt"] | |
WjPHxUtF9go | The low quality recording features an emotional electric guitar melody. The recording is noisy and in mono as it was probably recorded with a poor quality microphone. | ["low quality", "mono", "noisy", "emotional electric guitar melody"] | ["Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Chorus effect", "Strum", "Plucked string instrument"] | 4 | 30 | 40 | 0 | 0 | ["/m/0342h", "/m/04rlf", "/m/04szw", "/m/06w87", "/m/07m2kt", "/m/07s0s5r", "/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 );