musiccaps
3 rows where aspect_list contains "crowd chattering" 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 |
---|---|---|---|---|---|---|---|---|---|---|
QtjMlA_7dds | The low quality recording features a live performance of an indie song and it features a passionate male vocal singing over acoustic rhythm guitar and soft double bass, There are laughing and crowd chattering noises in the background. It sounds emotional and sad, even though the recording is a bit noisy. | ["low quality", "indie", "live performance", "noisy", "passionate male vocal", "acoustic rhythm guitar", "soft double bass", "crowd chattering", "laughing", "passionate", "emotional", "sad"] | ["Country", "Flamenco", "Music", "Bluegrass", "Vocal music"] | 4 | 30 | 40 | 0 | 1 | ["/m/01lyv", "/m/0326g", "/m/04rlf", "/m/0gg8l", "/m/0y4f8"] | |
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"] | |
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 );