musiccaps
2 rows where aspect_list contains "jingle" and aspect_list contains "rock"
This data as json, CSV (advanced)
aspect_list (array) 18 ✖
- electric guitar 2
- jingle · 2 ✖
- rock · 2 ✖
- acoustic 1
- acoustic guitar 1
- christmas 1
- compilation 1
- disorganized 1
- electronic drums 1
- female vocal 1
- festive 1
- footsteps 1
- generic 1
- keyboard 1
- male vocals 1
- pop 1
- random 1
- static sound effect 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
4AfykLGm0j8 | This is a compilation of various different music pieces all in one recording to advertise a radio software. The pieces are generic in nature. There is a rock music piece with an electric guitar playing. After a static sound effect, it switches to a pop music piece. There is a female vocalist singing over a keyboard and electronic drum beat background. There is a random feeling to this track. | ["compilation", "jingle", "generic", "rock", "electric guitar", "static sound effect", "pop", "female vocal", "keyboard", "electronic drums", "disorganized", "random"] | ["Music", "Radio"] | 9 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/06bz3"] | |
SLdVSirZMSI | This is an amateur acoustic rock performance of a Christmas song. There are three male voices singing the song. Two acoustic guitars and an electric guitar provide the melodic background. The players are stepping their foot on the ground for an added percussive effect to keep the rhythm. | ["rock", "acoustic", "jingle", "christmas", "male vocals", "acoustic guitar", "electric guitar", "footsteps", "festive"] | ["Christmas music", "Singing", "Guitar", "Music", "Song"] | 9 | 30 | 40 | 0 | 1 | ["/m/0140xf", "/m/015lz1", "/m/0342h", "/m/04rlf", "/m/074ft"] |
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 );