musiccaps

1 row where aspect_list contains "ektare", aspect_list contains "female backup" and aspect_list contains "simple"

✎ 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
UQKLBsZJsww This song is a happy Punjabi song. The tempo is fast with a male vocalist singing an enthusiastic melody to the beat of a dhol , tanpura and beat of a shaker. The song is lively, simple, energetic and festive. This song is sung at weddings. It is a jugalbandi between the bride and groom’s side where two vocalists compete playful in vocal battle. ["duet", "fast tempo", "female vocalisation", "vocal battle", "ektara", "tanpura", "indian festivities", "festive", "happy occasion", "simple", "minimal instruments", "vocal jugalbandi", "female backup", "ektare", "sapp", "shaker", "tano indian festivities", "punjabi song", "happy", "cheerful", "merry", "upbeat", "string instrument", "dhol", "barrel drum", "dholaki", "indian song"] ["Music", "Wedding music"] 7 30 40 1 1 ["/m/04rlf", "/m/04wptg"]

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