musiccaps

1 row where aspect_list contains "demo audio" and start_s = 290

✎ 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
vyNstX5b1V8 This song features an electric guitar. The guitar starts off with a descending pentatonic run. A descending slide is played followed by a moderate tempo blues lick. There are no other instruments in this song. There is no voice in this song. This is an instrumental song with a blues mood. This song can be played as an instructional blues song. ["electric guitar", "amateur recording", "blues melody", "no other instruments", "demo audio", "instructional audio", "no voices", "instrumental", "moderate tempo"] ["Blues", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] 0 290 300 0 0 ["/m/0155w", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y"]

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