musiccaps
2 rows where aspect_list contains "arpeggiated acoustic guitar melody" and audioset_ids contains "/m/0gg8l"
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 |
---|---|---|---|---|---|---|---|---|---|---|
dzPPmuFUicc | The low quality recording features a country song that consists of a passionate male vocal singing over arpeggiated acoustic guitar melody, acoustic rhythm guitar chords, mandoline guitar melody and groovy bass. It sounds passionate, joyful and emotional. | ["low quality", "country", "groovy bass", "arpeggiated acoustic guitar melody", "acoustic rhythm guitar chords", "mandoline melody", "passionate", "joyful", "emotional"] | ["Country", "Music", "Bluegrass"] | 4 | 30 | 40 | 0 | 0 | ["/m/01lyv", "/m/04rlf", "/m/0gg8l"] | |
gNjeps3EbJA | The low quality recording features a live performance of a folk song and it contains harmonized mixed vocals singing over groovy bass, groovy accordion melody and arpeggiated acoustic guitar solo melody. The recording took place outdoors, since there was some crowd chattering and nature sounds. It sounds happy and fun. | ["low quality", "live performance", "folk", "harmonized vocals", "crowd chattering", "outdoor recording", "groovy bass", "groovy accordion melody", "arpeggiated acoustic guitar melody", "happy", "fun", "nature"] | ["Singing", "Yodeling", "Music", "Bluegrass"] | 4 | 30 | 40 | 0 | 1 | ["/m/015lz1", "/m/01swy6", "/m/04rlf", "/m/0gg8l"] |
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 );