musiccaps
1 row where aspect_list contains "weird" and audioset_ids contains "/m/018vs"
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 |
---|---|---|---|---|---|---|---|---|---|---|
7xD_Ib3VS_w | The low quality recording features widely spread electric guitar melodies. One of the melodies is solo and it is panned to the right channel, while the other one is an arpeggiated electric guitar melody, and it is panned to the left channel of the stereo image. The recording is a bit noisy and weird, since it is a bit too wide, but it also sounds passionate. | ["low quality", "noisy", "wide", "electric guitar melody solo", "arpeggiated electric guitar melody", "passionate", "weird"] | ["Bass guitar", "Echo", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | 4 | 30 | 40 | 0 | 0 | ["/m/018vs", "/m/01jnbd", "/m/0342h", "/m/042v_gx", "/m/04rlf", "/m/04szw", "/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 );