musiccaps

2 rows where aspect_list contains "bow stringed instrument" and aspect_list contains "brass band"

✎ 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
GcqCHmHXEjo This music is instrumental . The tempo is fast with a burst of harmonious instrumentation. The music is orchestral with animated trumpets, melodious violin symphony, enthusiastic drumming, piano accompaniment and male vocalisation in the background. The music is bright, lively, powerful, commanding, fluent, gripping ,compelling and a delight to the ears. ["instrumental", "fast tempo", "bright", "gripping", "compelling", "delightful", "commanding", "enthralling", "orchestra", "bright trumpets", "bow stringed instrument", "cello", "viola", "vocalisation in background", "burgeoning", "instrumental ensemble", "sonic treat", "brass band", "melodious violin symphony", "enthusiastic drumming"] ["Theme music", "Music", "Orchestra"] 7 30 40 0 1 ["/m/02cjck", "/m/04rlf", "/m/05pd6"]
erHadqauC8A This song is a simple instrumental. The tempo is medium with a lively tempo and melodic violin accompaniment. The tune is simple,refreshing, emphatic and mellifluous. ["instrumental", "medium tempo", "lively tempo", "brass", "brass instrument", "brass band", "string instrument", "bow stringed instrument", "perfectly synced", "complimentary harmony", "violin accompaniment", "simple", "melodic", "harmonic"] ["Brass instrument", "Trumpet", "Violin, fiddle", "Bowed string instrument"] 7 30 40 0 0 ["/m/01kcd", "/m/07gql", "/m/07y_7", "/m/0l14_3"]

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