musiccaps
2 rows where aspect_list contains "wide electric guitar melodies" 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 |
---|---|---|---|---|---|---|---|---|---|---|
-T4GeTHKtJQ | The low quality recording features a compilation of rock songs and it consists of punchy kicks, wide electric guitar melodies, distorted bass guitar, energetic crash cymbals, shimmering hi hats and harmonizing male vocals singing over it. It sounds energetic. | ["low quality", "rock", "punchy kick", "punchy kick", "wide electric guitar melodies", "distorted bass guitar", "energetic crash cymbal", "shimmering hi hats", "harmonizing male vocals", "energetic", "compilation"] | ["Funk", "Music"] | 4 | 30 | 40 | 0 | 0 | ["/m/02x8m", "/m/04rlf"] | |
C-7ubPOCeJk | The Pop song features a passionate female vocal singing over groovy bass, wide electric guitar melodies and shimmering shakers, as the overall audio is slowly fading out. It sounds addictive, passionate and intimate. | ["pop", "passionate female vocal", "groovy bass", "wide electric guitar melodies", "shimmering shakers", "fade out", "addictive", "passionate", "intimate"] | ["Singing", "Funk"] | 4 | 240 | 250 | 0 | 0 | ["/m/015lz1", "/m/02x8m"] |
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 );