musiccaps

1 row where audioset_ids contains "/m/015lz1", audioset_ids contains "/m/042v_gx", audioset_ids contains "/m/04rlf" and audioset_ids contains "/t/dd00031"

✎ View and edit SQL

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
ao-TFiShaWU This is an acoustic indie rock piece. There is a male vocalist singing gently in the Thai language. An acoustic guitar plays the main tune while a bass guitar is in the background. There is a piano that starts out by supporting the melody, but then wanders towards off-key notes, creating an air of conflict. The atmosphere is melancholic. This piece can be used in the soundtrack of a drama movie/TV show that takes place in Thailand. ["acoustic", "indie rock", "male vocal", "acoustic guitar", "bass guitar", "off-key piano", "acoustic drums", "gentle", "easygoing", "melancholic", "thai"] ["Singing", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument", "Bowed string instrument", "Happy music"] 9 120 130 1 1 ["/m/015lz1", "/m/0342h", "/m/042v_gx", "/m/04rlf", "/m/04szw", "/m/0fx80y", "/m/0l14_3", "/t/dd00031"]

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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
);