musiccaps
2 rows where aspect_list contains "emotional", aspect_list contains "home video" and audioset_names contains "Distortion"
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 |
---|---|---|---|---|---|---|---|---|---|---|
7V0G65FK2VQ | The song is an instrumental guitar solo. The song tempo is medium with a racy electric guitar solo with a show of technique of note bending, tremolo and playing rhythmically. The song is home video and an average quality recording. | ["electric guitar lead", "note bending", "playing rhythm guitar", "solo guitarist", "soloist", "no other instrumentation", "no percussions", "home video", "poor quality video", "guitar technique", "guitar a", "plification", "medium tempo", "spirited", "emotional", "youthful", "groovy", "energetic"] | ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Distortion"] | 1 | 0 | 10 | 0 | 1 | ["/m/01glhc", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/0g12c5"] | |
eM0PkfqGmIE | The song is an instrumental. The song is medium fast tempo with a bass guitar soloist playing a cool accompaniment groove with no other instrumentation. The song is passionate and energetic. The song is a bass guitar demo or a home music video. | ["bass guitar", "slap bass", "energetic", "echoes", "home video", "average audio quality", "passionate", "virtuoso player", "bass guitar technique", "bass guitar demo", "instrumental music", "emotional", "romantic", "groovy", "funk bass line", "guitar accompaniment style", "instrumental music", "syncopation", "enegetic", "medium fast tempo"] | ["Bass guitar", "Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] | 1 | 30 | 40 | 1 | 1 | ["/m/018vs", "/m/01glhc", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw", "/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 );