musiccaps
2 rows where aspect_list contains "punchy snare" and audioset_ids contains "/m/0y4f8"
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 |
---|---|---|---|---|---|---|---|---|---|---|
46WpyRUqwXU | The low quality recording features a pop song that contains a passionate female vocal, alongside wide harmonizing male vocals, singing over wide brass melody, electric guitar chords, straight piano melody, punchy snare and smooth bass guitar. It sounds groovy, addictive and passionate. | ["low quality", "pop", "wide harmonizing male vocals", "wide shimmering hi hats", "wide brass melody", "electric guitar chords", "straight piano melody", "reverberant passionate female vocal", "punchy snare", "smooth bass guitar", "groovy", "addictive", "passionate"] | ["Music", "Vocal music"] | 4 | 30 | 40 | 0 | 0 | ["/m/04rlf", "/m/0y4f8"] | |
_78P-0zWJtg | The low quality recording features a live performance of fruity male vocal singing over funky piano melody and beat played on playback that consists of punchy snare and kick hits, shimmering hi hats and smooth bass. The crowd is also singing along, harmonizing with the lead vocal. It sounds emotional and groovy, even though the recording is noisy. | ["low quality", "folk", "fruity male vocal", "funky piano melody", "playback beat", "shimmering hi hats", "punchy snare", "punchy kick", "smooth bass", "noisy", "live performance", "harmonizing crowd vocals", "emotional", "groovy"] | ["Singing", "Gospel music", "Music", "Vocal music"] | 4 | 420 | 430 | 1 | 1 | ["/m/015lz1", "/m/016cjb", "/m/04rlf", "/m/0y4f8"] |
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 );