musiccaps
2 rows where aspect_list contains "energetic" and aspect_list contains "guitar player"
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
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 );