musiccaps
2 rows where aspect_list contains "electric guitar playing" and audioset_ids contains "/m/02sgy"
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 |
---|---|---|---|---|---|---|---|---|---|---|
BjqhHeJD28U | The song is an instrumental. The song is medium tempo with an amplified guitar playing lead with different tone settings. The song is melancholic and more of a demo play. The song has poor audio quality. | ["electric guitar playing", "medium tempo", "poor audio quality", "melancholic", "music demo", "different tone settings", "arpeggio playing", "guitar tones", "instrumental music", "guitar test demo", "bas audio quality", "wobbly notes", "no other instrumentation", "no percussion instruments", "guitar amplifier", "slow tempo"] | ["Effects unit", "Electric guitar", "Guitar", "Music", "Chorus effect"] | 1 | 30 | 40 | 0 | 1 | ["/m/02rr_", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/07m2kt"] | |
aqhhfkXKJ1o | This is a solo electric guitarist playing some blues. It's a twelve bar blues progression that's intricately finger picked. It has a turnaround. | ["electric guitar playing", "country blues guitar playing", "electric guitar arpeggio", "complex guitar playing"] | ["Electric guitar", "Guitar", "Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | 3 | 10 | 20 | 0 | 1 | ["/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/07xzm", "/m/0fx80y"] |
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 );