home / musiccaps

musiccaps

2 rows where aspect_list contains "guitar player"

✎ 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
E3F9bzeCgTQ The song is an instrumental. The song is fast tempo with soloists playing an enthusiastic guitar strumming and harmony. The song is energetic and entertaining. The audio is poor and the song is played in front of a live audience that is cheering and hooting in approval. ["poor audio quality", "instrumental music", "virtuous guitarist", "classic guitar hits", "adrenaline rush", "people cheering", "groovy", "hooting", "guitar player", "soloist", "fast strumming rhythm", "energetic", "passionate", "dance rhythm", "groovy music", "jazz blues", "gypsy guitar music", "blues music", "fast tempo"] ["Folk music", "Music"] 1 30 40 0 1 ["/m/02w4v", "/m/04rlf"]
Pn8HqUbNQAc A male guitar player plays a guitar riff followed by an introduction of a guitar effects flanger pedal. The video has an instrumental solo of a guitar playing rhythm and no other instrumentation. The soundtrack has a poor audio quality. ["male guitar teacher", "guitar pedal demonstration", "poor audio quality", "guitarist", "home video", "guitar player", "electric guitar solo", "youtube gear demonstration", "instrumental", "average audio quality", "amplifier", "flanger unit", "energetic", "exciting", "gadget porn"] ["Effects unit", "Guitar", "Music", "Musical instrument", "Chorus effect", "Speech", "Plucked string instrument", "Distortion"] 1 30 40 0 0 ["/m/02rr_", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/07m2kt", "/m/09x0r", "/m/0fx80y", "/m/0g12c5"]

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
);
Powered by Datasette · Queries took 808.239ms · About: simonw/musiccaps-datasette