musiccaps
2 rows where aspect_list contains "melancholic" 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"] | |
KXRngbBe0bg | The song is an instrumental. The tempo is medium with a guitar playing lead and rhythm with differences ranging from echo tones to distorted high gains. The song is a guitar reverb pedal test or demonstration. The audio quality is poor with high gains. | ["instrumental music", "high gain", "dissonant tones", "home music video", "poor audio quality", "effects pedal", "high gain tones", "changing tones", "echoes", "delay effects", "distortion tones", "guitar effects module demonstration", "homemjsic video", "guitar echo pedal", "overuse of effect", "melancholic", "poignant", "groovy", "amateur player", "soloist", "out of tune", "medium tempo", "noisy"] | ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument"] | 1 | 80 | 90 | 0 | 1 | ["/m/01glhc", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw"] |
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 );