musiccaps

1 row where aspect_list contains "high-spirited", aspect_list contains "trumpets" and aspect_list contains "world music"

✎ 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
mcAsO331Z9s This music is an upbeat instrumental. The tempo is fast with a plethora of instruments like trumpets, congas, bongos, steel drum, accordion,saxophone, keyboard,and electric guitar. The music is perky, buoyant, high spirited, enthusiastic, energetic with complex harmonies. This music is a contemporary take in Traditional Latin folk music. ["instrumental", "fast tempo", "trumpets", "complex harmonies", "syncopated", "electronic reggae", "synthesiser arrangement", "folk music", "latin folk", "world music", "accordion harmony", "psychedelic", "party song", "dance groove", "contemporary traditional music", "trombone", "conga", "bongos", "steel pan", "saxophone", "electric guitar", "groovy bass", "upbeat", "cheerful", "happy merry", "polyrhythms", "animated", "high-spirited", "lively", "colourful", "vivid", "vivacious"] ["Music", "Ska"] 7 30 40 0 0 ["/m/04rlf", "/m/06rqw"]

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