musiccaps
2 rows where aspect_list contains "harmonizing male vocals" 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 |
---|---|---|---|---|---|---|---|---|---|---|
5xIBQGMjiX4 | The low quality recording features harmonized male vocals singing over shimmering shakers, repetitive cowbell hits and acoustic rhythm guitar chord progressions. It is a bit noisy and loud, as it was probably recorded with the phone. | ["low quality", "harmonizing male vocals", "shimmering shakers", "cowbell hits", "acoustic rhythm guitar chords progression", "traditional", "noisy", "loud"] | ["Banjo", "Music", "Bluegrass"] | 4 | 30 | 40 | 0 | 1 | ["/m/018j2", "/m/04rlf", "/m/0gg8l"] | |
ZX2fVPmUidA | The low quality recording features a live performance of a country song and it consists of harmonizing male vocals singing over groovy steel guitar, groovy mandoline melody and groovy acoustic rhythm guitar chords. There are some crowd chattering noises in the background. It sounds passionate, happy and fun. | ["low quality", "live performance", "country", "harmonizing male vocals", "groovy steel guitars melody", "noisy", "groovy mandoline melody", "groovy acoustic rhythm guitar melody", "passionate", "happy", "fun", "crowd chattering"] | ["Banjo", "Country", "Music", "Bluegrass"] | 4 | 30 | 40 | 0 | 1 | ["/m/018j2", "/m/01lyv", "/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 );