musiccaps

1 row where aspect_list contains "live performance", aspect_list contains "pop music" and aspect_list contains "teen female vocal"

✎ 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
BaMBwXQwK3g This is a live performance of a pop music piece. There is a teenage female vocalist singing melodically in the Spanish language. An acoustic guitar plays the main tune while there is a slow tempo acoustic drum beat in the rhythmic background. The spectators are joining the song at a volume that is sometimes higher than the song itself and it creates an irritating aura. ["live performance", "pop music", "ballad", "teen female vocal", "melodic singing", "acoustic guitar", "acoustic drums", "crowd singing", "emotional", "slow tempo", "spanish"] ["Singing", "Music", "Song", "A capella"] 9 30 40 0 1 ["/m/015lz1", "/m/04rlf", "/m/074ft", "/m/0z9c"]

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