musiccaps
2 rows where audioset_names contains "Ska" and start_s = 260
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 |
---|---|---|---|---|---|---|---|---|---|---|
0EzWmAPwoTs | The Rock song features an energetic male vocal singing over repetitive electric guitar melody, groovy bass, punchy kick and snare, shimmering hi hats and energetic crash cymbal. There is a short drum roll that represents a variation in a repetitive loop. It sounds energetic and passionate. | ["rock", "energetic male vocal", "repetitive electric guitar melody", "groovy bass", "punchy snare", "punchy kick", "shimmering hi hats", "short drums roll", "energetic crash cymbal", "energetic", "passionate"] | ["Music", "Ska"] | 4 | 260 | 270 | 0 | 0 | ["/m/04rlf", "/m/06rqw"] | |
TEWYFkjH2jc | A male vocalist sings this upbeat song in a foreign language. The tempo is fast with a lively keyboard harmony, spirited drumming, funky bass line, rhythmic acoustic guitar, shakers enthusiastic vocal backup and clapping. The song is upbeat, high-spirited, energetic, buoyant, cheerful, peppy, happy and groovy. This song is a lively Pop song. | ["male singer", "fast tempo", "foreign language", "rhythmic acoustic guitar", "groovy", "dance music", "dance groove", "pop", "shakers", "lively keyboard harmony", "spirited drumming", "funky bass line", "enthusiastic vocal backup", "clapping", "keyboard harmony", "tambourine beats", "catchy", "punchy", "bouncy", "buoyant", "energetic", "enthusiastic", "pop", "regional pop", "world music"] | ["Music of Africa", "Music", "Ska"] | 7 | 260 | 270 | 0 | 0 | ["/m/0164x2", "/m/04rlf", "/m/06rqw"] |
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 );