musiccaps
2 rows where aspect_list contains "punchy tom" and author_id = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|
lSbCqHZy_l4 | The low quality recording features a fruity male vocal talking, after which he starts singing over harmonizing choir, groovy bass, mellow piano melody, shimmering cymbals, punchy kick, punchy tom and snappy rimshots. It sounds emotional, soulful and passionate. | ["low quality", "fruity male vocal", "gospel", "harmonizing choir", "groovy bass", "mellow piano melody", "shimmering cymbals", "punchy kick", "punchy tom", "snappy rimshots", "emotional", "soulful", "passionate"] | ["Singing", "Gospel music", "Choir"] | 4 | 110 | 120 | 0 | 0 | ["/m/015lz1", "/m/016cjb", "/m/0l14jd"] | |
xiN6XwZNEJo | The low quality recording features an energetic drums solo that consists of punchy snare, tom and kick hits, alongside repetitive cowbell. There is a flat male vocal talking right before the solo. It sounds like a tutorial. The recording is noisy and in mono. | ["low quality", "drums solo", "noisy", "mono", "punchy snare", "punchy tom", "repetitive cowbell", "energetic", "tutorial"] | ["Cowbell", "Drum", "Drum kit", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | 4 | 80 | 90 | 0 | 0 | ["/m/0239kh", "/m/026t6", "/m/02hnl", "/m/03t3fj", "/m/06rvn", "/m/0bm02", "/m/0l14md"] |
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 );